APPS.ORACLECONFIGURE dependencies on FND_FORM_FUNCTIONS

Line 76: from fnd_form_functions_vl

72:
73: BEGIN
74: select function_id, user_function_name
75: into l_function_id, l_display_name
76: from fnd_form_functions_vl
77: where function_name = 'ICX_NAVIGATE_PLUG';
78: /* added for 1378862 mputman
79: NO_DATA_FOUND Exception means
80: that the NLS patch was not applied

Line 336: from FND_FORM_FUNCTIONS a,

332:
333: begin
334: select WEB_HTML_CALL
335: into l_web_html_call
336: from FND_FORM_FUNCTIONS a,
337: FND_MENU_ENTRIES b
338: where b.MENU_ID = thisplug.MENU_ID
339: and a.FUNCTION_ID = b.FUNCTION_ID
340: and b.ENTRY_SEQUENCE = thisplug.entry_sequence;

Line 742: fnd_form_functions fff

738: ipp.display_sequence,
739: fme.menu_id
740: from icx_page_plugs ipp,
741: fnd_menu_entries_vl fme,
742: fnd_form_functions fff
743: where ipp.region_id = p_region.region_id
744: and ipp.page_id = p_page_id
745: and ipp.menu_id = fme.menu_id
746: and ipp.entry_sequence = fme.entry_sequence

Line 755: from FND_FORM_FUNCTIONS_VL a,

751: a.function_id,
752: a.web_html_call,
753: b.display_sequence,
754: b.menu_id
755: from FND_FORM_FUNCTIONS_VL a,
756: ICX_PAGE_PLUGS b
757: where b.PAGE_ID = p_page_id
758: and b.MENU_ID = -1
759: and b.ENTRY_SEQUENCE = a.FUNCTION_ID

Line 1306: fnd_form_functions fff

1302: select nvl(ipp.DISPLAY_NAME, fme.PROMPT)
1303: into l_plug_name
1304: from icx_page_plugs ipp,
1305: fnd_menu_entries_vl fme,
1306: fnd_form_functions fff
1307: where ipp.plug_id = p_plug_id
1308: and ipp.menu_id = fme.menu_id
1309: and ipp.entry_sequence = fme.entry_sequence
1310: and fff.function_id = fme.function_id;

Line 1320: from FND_FORM_FUNCTIONS_VL a,

1316: if l_plug_name is null then
1317: begin
1318: select nvl(b.DISPLAY_NAME,a.USER_FUNCTION_NAME)
1319: into l_plug_name
1320: from FND_FORM_FUNCTIONS_VL a,
1321: ICX_PAGE_PLUGS b
1322: where b.plug_id = p_plug_id
1323: and b.MENU_ID = -1
1324: and b.ENTRY_SEQUENCE = a.FUNCTION_ID;

Line 1472: from fnd_form_functions d,

1468: c.prompt,
1469: c.description,
1470: d.function_id,
1471: d.type
1472: from fnd_form_functions d,
1473: fnd_menu_entries_vl c,
1474: fnd_responsibility_vl a,
1475: FND_USER_RESP_GROUPS b
1476: where b.user_id = icx_sec.g_user_id

Line 1499: fnd_form_functions fff

1495: fff.web_html_call,
1496: ipp.display_sequence
1497: from icx_page_plugs ipp,
1498: fnd_menu_entries_vl fme,
1499: fnd_form_functions fff
1500: where ipp.region_id = p_region_id
1501: and ipp.page_id = p_page_id
1502: and ipp.menu_id = fme.menu_id
1503: and ipp.entry_sequence = fme.entry_sequence

Line 1511: from FND_FORM_FUNCTIONS_VL a,

1507: b.PLUG_ID,
1508: nvl(b.DISPLAY_NAME,a.USER_FUNCTION_NAME) plug_name,
1509: a.web_html_call,
1510: b.display_sequence
1511: from FND_FORM_FUNCTIONS_VL a,
1512: ICX_PAGE_PLUGS b
1513: where b.PAGE_ID = p_page_id
1514: and b.MENU_ID = -1
1515: and b.ENTRY_SEQUENCE = a.FUNCTION_ID

Line 1901: FROM fnd_form_functions

1897: if (p_web_html_call is not null) then
1898:
1899: SELECT web_html_call
1900: INTO l_web_html_call
1901: FROM fnd_form_functions
1902: WHERE function_id=p_web_html_call;
1903:
1904: execute immediate 'begin '
1905: || l_web_html_call