APPS.ORACLEMYPAGE dependencies on FND_FORM_FUNCTIONS

Line 67: FND_FORM_FUNCTIONS a,

63: b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
64: c.DESCRIPTION,a.WEB_HTML_CALL
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

Line 88: from FND_FORM_FUNCTIONS_VL a,

84: b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
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

Line 103: FND_FORM_FUNCTIONS a,

99: b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
100: c.DESCRIPTION,a.WEB_HTML_CALL
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

Line 314: fnd_form_functions fff, fnd_menu_entries_vl fme,

310: select fff.FUNCTION_NAME, fff.TYPE, fff.WEB_HOST_NAME,
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

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 601: from FND_FORM_FUNCTIONS

597: if fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'
598: then
599: select FUNCTION_ID
600: into l_function_id
601: from FND_FORM_FUNCTIONS
602: where FUNCTION_NAME = 'OAHOMEPAGE';
603:
604: l_url := icx_portlet.createExecLink
605: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),

Line 833: from FND_FORM_FUNCTIONS

829: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'
830: then
831: select FUNCTION_ID
832: into l_function_id
833: from FND_FORM_FUNCTIONS
834: where FUNCTION_NAME = 'OAHOMEPAGE';
835:
836: l_url := icx_portlet.createExecLink
837: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),

Line 947: fnd_form_functions_vl c

943: INTO l_function_count
944: from
945: fnd_responsibility_vl a,
946: fnd_menu_entries_vl b,
947: fnd_form_functions_vl c
948: where a.responsibility_id=r.responsibility_id
949: and a.menu_id=b.menu_id
950: and b.function_id=c.function_id
951: AND b.prompt IS NOT NULL

Line 989: fnd_form_functions_vl c

985: INTO l_function_code, l_menu_prompt, l_function_type, l_menu_id
986: from
987: fnd_responsibility_vl a,
988: fnd_menu_entries_vl b,
989: fnd_form_functions_vl c
990: where a.responsibility_id=r.responsibility_id
991: and a.menu_id=b.menu_id
992: and b.function_id=c.function_id
993: and b.prompt is not null -- 3275654 nlbarlow