[Home] [Help]
81: select prompt,
82: description,
83: sub_menu_id,
84: entry_sequence
85: from fnd_menu_entries_vl
86: where menu_id = p_object.parent_menu_id
87: and sub_menu_id is not null
88: and function_id is null
89: and prompt is not null
101: b.entry_sequence,
102: a.type,
103: a.web_html_call
104: from fnd_form_functions_vl a,
105: fnd_menu_entries_vl b
106: where b.menu_id = p_object.parent_menu_id
107: AND b.prompt IS NOT NULL -- mputman added 1815466
108: --AND b.grant_flag='Y'
109: --removed grant_flag bug 3575253
294: sub_menu_id
295: into l_prompt,
296: l_description,
297: l_sub_menu_id
298: from fnd_menu_entries_vl
299: where menu_id = p_object.parent_menu_id
300: and entry_sequence = p_object.entry_sequence
301: order by entry_sequence;
302:
703: begin
704: select distinct NVL(ipp.DISPLAY_NAME, fme.prompt)
705: into l_name
706: from icx_page_plugs ipp,
707: fnd_menu_entries_vl fme,
708: fnd_form_functions fff
709: where ipp.page_id = l_page_id
710: and ipp.menu_id = fme.menu_id
711: and ipp.entry_sequence = fme.entry_sequence
749: begin
750: select distinct NVL(ipp.DISPLAY_NAME, fme.prompt)
751: into l_name
752: from icx_page_plugs ipp,
753: fnd_menu_entries_vl fme,
754: fnd_form_functions fff
755: where ipp.menu_id = fme.menu_id
756: and ipp.entry_sequence = fme.entry_sequence
757: and fff.function_id = fme.function_id
982: IF r.TYPE = 'HOMEPAGE' THEN
983: BEGIN
984: SELECT function_id
985: INTO l_function_id
986: FROM fnd_menu_entries_vl
987: WHERE menu_id=r.menu_id
988: AND FUNCTION_ID is not null
989: AND ROWNUM=1
990: ORDER BY entry_sequence;
1308: IF r.type='HOMEPAGE' THEN
1309: BEGIN
1310: SELECT function_id
1311: INTO l_function_id
1312: FROM fnd_menu_entries_vl
1313: WHERE menu_id=r.menu_id
1314: AND FUNCTION_ID is not null
1315: AND ROWNUM=1
1316: ORDER BY entry_sequence;