Depending LOV’s in a generic way

LOV 102

Andy

1. Application item named: Get_Rooms
2. block to construct a list of item
3. JavaScript in HTML Header
4. HTML Form Element Attributes

********* Begin Get_Rooms : On Demand **********

select ROOM,ROOR_ID
from SVR_ROOMS_RF
where sitr_sitr_id = :TEMPORARY_ITEM)
…. rec.ROOR_id '">' rec.ROOM '');
********* End Get_Rooms : On Demand **********
********* Begin JavaScript in HTML Header**********

…..
htmldb_Get(null,$x('pFlowId').value,'APPLICATION_PROCESS=Get_Rooms',0);
get.add('TEMPORARY_ITEM',pThis.value);
gReturn = get.get('XML');
if(gReturn && l_Select){
…..

********* End JavaScript in HTML Header**********

*********** Begin HTML Form Element Attributes **********
onchange="get_AJAX_SELECT_XML(this,'P4_ROOM')"
*********** End HTML Form Element Attributes **********
ONCHANGE
Apex Cascading LOV's

Handling Depending LOV’s in a generic way

http://forums.oracle.com/forums/thread.jspa?threadID=400026
http://forums.oracle.com/forums/thread.jspa?messageID=1371958
http://htmldb.oracle.com/pls/otn/f?p=31517:42:1201664623903907:::::
http://htmldb.oracle.com/pls/otn/f?p=31517:1:1201664623903907::NO:::
http://forums.oracle.com/forums/thread.jspa?messageID=3416455&#3416455