Create Cascade POP UP LOV

There is a requirement to create a Cascade POP UP LOV , as we know we can only create cascade select list : meaning , we have one select list and another select list will be populated on the basis of its cascade.

In the case of POP UP LOVs we faced the problem about cascading . This is very easy and by default provided by Apex in Select Lists.

But with the POP UP LOVs what you need :-

• Step 1 :-

Create Item>P1_EMP
Type>POP UP LOV
List of values >POP UP LOV
List of values > Sql Query > select ename d,empno r from emp where deptno =:P1_DEPT_LOV

• Step 2 :-

Resetting child POP UP lov on change of parent

Create Dynamic Action > set session state
event> change
selection type> items
items> P1_DEPT_LOV
condition > -Select-

Action> clear
Affected elements>selection type> items
items> P1_EMP (reset on change of parent)

Set Session value of parent Item (P1_DEPT_LOV)
Create another action 
action > Execute PLsql code
Setting > plsql code

 APEX_UTIL.SET_SESSION_STATE('P1_DEPT',v('P1_DEPT'));

Now see the results.



Initially:

click on Popup menu ( I manipulated it to lock image this is just UI factor nothing else)

lov Results(this UI also changed by me i am just playing with Apex now a days)

Result in Item
 Value in Session

  

Click on Child LOV :

Result are exactly what select list gives.