APPS.ORACLENAVIGATE dependencies on FND_FORM_FUNCTIONS

Line 104: from fnd_form_functions_vl a,

100: b.function_id,
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'

Line 143: from fnd_form_functions a,

139: then
140:
141: select count(*)
142: into l_count
143: from fnd_form_functions a,
144: fnd_menu_entries b
145: where b.menu_id = p_object.parent_menu_id
146: and a.function_id = b.function_id
147: and a.type in ('WWW','WWK','SERVLET','JSP','FORM','INTEROPJSP')

Line 578: from FND_FORM_FUNCTIONS

574: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'
575: then
576: select FUNCTION_ID
577: into l_function_id
578: from FND_FORM_FUNCTIONS
579: where FUNCTION_NAME = 'OAHOMEPAGE';
580:
581: l_url := icx_portlet.createExecLink
582: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),

Line 596: from FND_FORM_FUNCTIONS

592: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'PHP_FWK'
593: then
594: select FUNCTION_ID
595: into l_function_id
596: from FND_FORM_FUNCTIONS
597: where FUNCTION_NAME = 'FND_NAVIGATE_PAGE';
598:
599: l_url := icx_portlet.createExecLink
600: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),

Line 708: fnd_form_functions fff

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
712: and fff.function_id = fme.function_id

Line 754: fnd_form_functions fff

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
758: and fff.function_name = 'ICX_NAVIGATE_PLUG'

Line 1344: from FND_FORM_FUNCTIONS

1340: if l_php_mode = 'PHP_FWK'
1341: then
1342: select FUNCTION_ID
1343: into l_function_id
1344: from FND_FORM_FUNCTIONS
1345: where FUNCTION_NAME = 'FND_NAVIGATE_PAGE';
1346:
1347: l_url := icx_portlet.createExecLink
1348: (p_application_id => r.responsibility_application_id,

Line 1426: from FND_FORM_FUNCTIONS_VL b,

1422: a.FUNCTION_ID,
1423: FUNCTION_TYPE,
1424: URL,
1425: WEB_HTML_CALL
1426: from FND_FORM_FUNCTIONS_VL b,
1427: ICX_CUSTOM_MENU_ENTRIES a
1428: where USER_ID = icx_sec.g_user_id
1429: and PLUG_ID = p_plug_id
1430: and b.FUNCTION_ID(+) = a.FUNCTION_ID

Line 2314: FROM fnd_form_functions_vl

2310:
2311:
2312: SELECT web_html_call
2313: INTO l_web_call
2314: FROM fnd_form_functions_vl
2315: WHERE function_id=p_function_id;
2316: --if added for 1352780
2317: if substrb(l_web_call,1,10) = 'javascript'
2318: then