[Home] [Help]
56: b.description,
57: b.function_id,
58: b.entry_sequence,
59: a.type
60: from fnd_form_functions a,
61: fnd_menu_entries_vl b
62: where b.menu_id = p_object.parent_menu_id
63: and a.function_id = b.function_id
64: and a.type = p_object.function_type
337: c.prompt,
338: c.description,
339: d.function_id,
340: d.type
341: from fnd_form_functions d,
342: fnd_menu_entries_vl c,
343: fnd_responsibility_vl a,
344: FND_USER_RESP_GROUPS b
345: where b.user_id = icx_sec.g_user_id
366: c.prompt,
367: c.description,
368: d.function_id,
369: d.type
370: from fnd_form_functions d,
371: fnd_menu_entries_vl c,
372: fnd_responsibility_vl a,
373: FND_USER_RESP_GROUPS b
374: where b.user_id = icx_sec.g_user_id
390: b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
391: c.DESCRIPTION
392: from fnd_responsibility e,
393: FND_USER_RESP_GROUPS d,
394: FND_FORM_FUNCTIONS a,
395: FND_MENU_ENTRIES_VL c,
396: ICX_PAGE_PLUGS b
397: where b.PAGE_ID = l_page_id
398: and b.MENU_ID = c.MENU_ID
410: select b.DISPLAY_SEQUENCE,b.PLUG_ID,b.RESPONSIBILITY_ID,
411: b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
412: b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,a.USER_FUNCTION_NAME) prompt,
413: a.DESCRIPTION
414: from FND_FORM_FUNCTIONS_VL a,
415: ICX_PAGE_PLUGS b
416: where b.PAGE_ID = l_page_id
417: and b.MENU_ID = -1
418: and b.ENTRY_SEQUENCE = a.FUNCTION_ID
425: b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
426: c.DESCRIPTION
427: from fnd_responsibility e,
428: FND_USER_RESP_GROUPS d,
429: FND_FORM_FUNCTIONS a,
430: FND_MENU_ENTRIES_VL c,
431: ICX_PAGE_PLUGS b
432: where b.PAGE_ID = l_page_id
433: and b.MENU_ID = c.MENU_ID
1274:
1275: begin
1276: select WEB_HTML_CALL
1277: into l_plsql_call
1278: from FND_FORM_FUNCTIONS a,
1279: FND_MENU_ENTRIES b
1280: where b.MENU_ID = p.MENU_ID
1281: and b.ENTRY_SEQUENCE = p.ENTRY_SEQUENCE
1282: and a.FUNCTION_ID = b.FUNCTION_ID;