what are the steps Required to Implement ROW LOV in Oracle Apps?
Answers
Steps Required to Implement ROW LOV
1. Open Form in Form Builder.
2. Perform all the prerequisites to develop the form
3. Create a user defined Parameter and change the Data Type and width of the column, same as Primary Key Column.
4. Create a LOV using wizard and assign the return value of the LOV to the Parameter.
5. ROW LOV is based on Record Group.
6. SELECT Order_No, Customer FROM Ex_Orders;
P_Order_No (Parameter_Name) Look Up Return Item
7. Create QUERY_FIND user defined Trigger at Block Level.
Note: LOV Name should be Block_Name_QF
Trigger: QUERY_FIND (User Defined Trigger)
APPS_FIND.QUERY_FIND(‘LOV’);
IF QUERY_FIND IS NOT NULL THEN
‐‐‐‐‐
END IF;
IF G_QUERY_FIND := ‘TRUE’ THEN
Execute_Query;
END IF;
8. Create PRE_QUERY Trigger at Block Level.
42
IF PARAMETER.G_QUERY_FIND = ‘TRUE’ THEN
:EX_ORDERS.ORDER_NO := :PARAMETER.P_ORDER_NO;
:PARAMETER.G_QUERY_FIND := ‘FALSE’;
END IF;
Note: In latest versions of Applications Parameter_Query_Find will be implicitly
assigned by the compiler after Query Execute. We need not assign it explicitly as FALSE.
10. Save and Compile the form and copy .fmx file in to module specific forms directory.