hi all,
my problem to have a Modal Dialog to return multiple columns/items values on the page where editing allowed, please read below
-
created a page Report with Form ( using hr.employees table ) - page name: Employees List ( IR = Page 8 and Employees Info -Form- = Page 17 )
-
created a Modal page ( IG, single selection, no Edit button using hr.departments table ) - page name: Employees Info
-
created a button on Form page before Manager ID and Department ID columns to call Modal page named: Departments LOVz
-
created a Dynamic Action on item APEX$ROW_SELECTOR of page Departments LOVz ( page/form for Editing is P17 )
Action: Execute PL/SQL Code
PL/SQL code:
BEGIN
:P17_DEPARTMENT_ID := :DEPARTMENT_ID;
:P17_MANAGER_ID := :MANAGER_ID;
END;
Items to Submit: DEPARTMENT_ID,MANAGER_ID
Items to Return: DEPARTMENT_ID,MANAGER_ID
-
created a button labeled Select which has
Action: Close Dialog
when run Employee List, press icon to call Edit form and pressed button to open Modal dialog, its worked fine, but when after selection of a row with row selector and close dialog with above button it is not return the both item's values ( nothing changed on Calling Form/Page :P17 ).
is it wrong way or i am missing something or something else to do ?
thanks to all in advance.
regards