APPS.ORACLENAVIGATE dependencies on ICX_CUSTOM_MENU_ENTRIES

Line 1427: ICX_CUSTOM_MENU_ENTRIES a

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
1431: and ( RESPONSIBILITY_ID in

Line 1433: icx_custom_menu_entries

1429: and PLUG_ID = p_plug_id
1430: and b.FUNCTION_ID(+) = a.FUNCTION_ID
1431: and ( RESPONSIBILITY_ID in
1432: (select responsibility_id from
1433: icx_custom_menu_entries
1434: where USER_ID=icx_sec.g_user_id
1435: intersect
1436: select RESPONSIBILITY_ID from fnd_user_resp_groups where
1437: USER_ID=icx_sec.g_user_id

Line 1449: delete ICX_CUSTOM_MENU_ENTRIES

1445:
1446: if p_delete = 'Y'
1447: then
1448: begin
1449: delete ICX_CUSTOM_MENU_ENTRIES
1450: where USER_ID = icx_sec.g_user_id
1451: and PLUG_ID = p_plug_id;
1452: exception
1453: when others then

Line 1822: from ICX_CUSTOM_MENU_ENTRIES

1818: SECURITY_GROUP_ID,
1819: FUNCTION_ID,
1820: FUNCTION_TYPE,
1821: URL
1822: from ICX_CUSTOM_MENU_ENTRIES
1823: where USER_ID = icx_sec.g_user_id
1824: and PLUG_ID = l_plug_id
1825: order by DISPLAY_SEQUENCE;
1826:

Line 2204: delete ICX_CUSTOM_MENU_ENTRIES

2200: l_index := 0;
2201: l_occurence := 1;
2202: l_lastcount := 1;
2203:
2204: delete ICX_CUSTOM_MENU_ENTRIES
2205: where USER_ID = icx_sec.g_user_id
2206: and PLUG_ID = l_plug_id;
2207:
2208: while l_lastcount <= l_length loop

Line 2238: insert into ICX_CUSTOM_MENU_ENTRIES

2234: end if;
2235: l_function_type := substr(l_line,l_point4+1,l_point_4_5);
2236: l_prompt := substr(l_line,l_point5+1,length(l_line));
2237:
2238: insert into ICX_CUSTOM_MENU_ENTRIES
2239: (USER_ID,
2240: PLUG_ID,
2241: DISPLAY_SEQUENCE,
2242: PROMPT,