EBS form 中LOV的创建及参数传递和Template中标准Calendar的使用

效果:

 

 

 

1 LOV的创建及参数传递

 Record group query:

 

LOV column mapping:

     LOV中每个column的值跟据mapping赋值给block中相应的item

 

2 Query_Find中参数传递

    

 通过trigger PRE_QUERY中的COPY将query_find

   Block 中的item的值传递给result block中相应的item

 

--:IF :parameter.G_query_find = TRUE THEN
-- COPY (<find Window field>,<results field>);
-- :parameter.G_query_find := FALSE;
--END IF;

IF :parameter.G_query_find = 'TRUE' THEN
  COPY(:QUERY_FIND.EMPNO, 'XX425457_EMPLOYEES.EMPNO');
  COPY(:QUERY_FIND.FIRST_NAME, 'XX425457_EMPLOYEES.FIRST_NAME');
  COPY(:QUERY_FIND.LAST_NAME, 'XX425457_EMPLOYEES.LAST_NAME');
  :parameter.G_query_find := 'FALSE';
END IF;

 

 

--APP_STANDARD.EVENT('QUERY_FIND');

--APP_FIND.QUERY_FIND(<results block window>,<Find window>,<Find window block>);

APP_FIND.QUERY_FIND('XX425457_EMPLOYEES', 'QUERY_FIND','QUERY_FIND');

 

 

 

 

3 Template中标准Calendar的使用

 

Item Date_Joined 的LOV选择Template中定义好的LOV TIMEZONES_AND_DATETIME

Validate from List 选择NO

Date fields should use the ENABLE_LIST_LAMP LOV, which is included in the TEMPLATE form. This setting enables the menu and Toolbar List of Values entries for your date fields. Set '"Validate from List" to No on fields that use this LOV. If you leave "Validate from List" set to Yes, you will see an LOV that has no columns.

 

创建 Trigger Key-LISTVAL: CALENDAR.SHOW