[Home] [Help]
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
72: and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
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
108: and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
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
942: select count(*)
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
958:
959: -- 2712250 nlbarlow
960: SELECT count(*)
961: INTO l_menu_count
962: FROM fnd_menu_entries_vl c
963: WHERE prompt IS NOT NULL
964: and menu_id=(SELECT menu_id
965: FROM fnd_responsibility_vl
966: WHERE responsibility_id = r.responsibility_id
984: SELECT c.function_id, nvl(b.prompt,c.user_function_name) prompt,c.TYPE,a.menu_id
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