APPS.ORACLEMYPAGE dependencies on ICX_PAGE_PLUGS

Line 69: ICX_PAGE_PLUGS b

65: from fnd_responsibility e,
66: FND_USER_RESP_GROUPS d,
67: FND_FORM_FUNCTIONS a,
68: FND_MENU_ENTRIES_VL c,
69: ICX_PAGE_PLUGS b
70: where b.PAGE_ID = l_page_id
71: and b.MENU_ID = c.MENU_ID
72: and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
73: and c.FUNCTION_ID = a.FUNCTION_ID

Line 89: ICX_PAGE_PLUGS b

85: b.MENU_ID,b.ENTRY_SEQUENCE,
86: nvl(b.DISPLAY_NAME,a.USER_FUNCTION_NAME) prompt,
87: a.DESCRIPTION,a.WEB_HTML_CALL
88: from FND_FORM_FUNCTIONS_VL a,
89: ICX_PAGE_PLUGS b
90: where b.PAGE_ID = l_page_id
91: and b.MENU_ID = -1
92: and b.ENTRY_SEQUENCE = a.FUNCTION_ID
93: and a.type in ('WWL','WWLG')

Line 105: ICX_PAGE_PLUGS b

101: from fnd_responsibility e,
102: FND_USER_RESP_GROUPS d,
103: FND_FORM_FUNCTIONS a,
104: FND_MENU_ENTRIES_VL c,
105: ICX_PAGE_PLUGS b
106: where b.PAGE_ID = l_page_id
107: and b.MENU_ID = c.MENU_ID
108: and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
109: and c.FUNCTION_ID = a.FUNCTION_ID

Line 315: icx_page_plugs ipp

311: fff.WEB_HTML_CALL, fff.FUNCTION_ID, ipp.PLUG_ID,
312: nvl(ipp.DISPLAY_NAME,fme.PROMPT) display, ipp.DISPLAY_SEQUENCE
313: from fnd_responsibility fr, FND_USER_RESP_GROUPS furg,
314: fnd_form_functions fff, fnd_menu_entries_vl fme,
315: icx_page_plugs ipp
316: where ipp.PAGE_ID = p_page_id and fme.MENU_ID = ipp.MENU_ID
317: and fme.ENTRY_SEQUENCE = ipp.ENTRY_SEQUENCE
318: and fff.FUNCTION_ID = fme.FUNCTION_ID
319: and ipp.RESPONSIBILITY_ID = furg.RESPONSIBILITY_ID

Line 331: from fnd_form_functions_vl fff, icx_page_plugs ipp

327: select fff.FUNCTION_NAME, fff.TYPE, fff.WEB_HOST_NAME,
328: fff.WEB_HTML_CALL, fff.FUNCTION_ID, ipp.PLUG_ID,
329: nvl(ipp.DISPLAY_NAME,fff.USER_FUNCTION_NAME),
330: ipp.DISPLAY_SEQUENCE
331: from fnd_form_functions_vl fff, icx_page_plugs ipp
332: where ipp.MENU_ID = -1 and ipp.ENTRY_SEQUENCE = fff.FUNCTION_ID
333: and ipp.PAGE_ID = p_page_id
334: order by 8;
335:

Line 871: FROM icx_page_plugs

867: WHERE user_id = l_user_id;
868:
869: select count(*)
870: INTO l_region_count
871: FROM icx_page_plugs
872: WHERE page_id=l_page_id;
873:
874:
875: END IF;