DBA Data[Home] [Help]

APPS.BIS_RL_PKG dependencies on FND_MENU_ENTRIES_VL

Line 146: from fnd_menu_entries_vl

142: select prompt,
143: description,
144: sub_menu_id,
145: entry_sequence
146: from fnd_menu_entries_vl
147: where menu_id = p_object.parent_menu_id
148: and sub_menu_id is not null
149: and prompt is not null
150: order by entry_sequence;

Line 155: from fnd_menu_entries_vl

151:
152: -- nbarik - 03/23/04- Bug Fix 3511444
153: cursor c_all_menuentries is
154: select prompt, description, sub_menu_id, entry_sequence
155: from fnd_menu_entries_vl
156: where menu_id = p_object.parent_menu_id
157: and sub_menu_id is not null
158: order by entry_sequence;
159:

Line 171: fnd_menu_entries_vl b

167: b.entry_sequence,
168: a.type,
169: a.web_html_call
170: from fnd_form_functions_vl a,
171: fnd_menu_entries_vl b
172: where b.menu_id = p_object.parent_menu_id
173: and a.function_id = b.function_id
174: --jprabhud - 03/04/03 - Refresh Portal Page - Remove the filter based on the type
175: --and a.type in (lWww ,lWwk)

Line 192: fnd_menu_entries_vl b

188: b.entry_sequence,
189: a.type,
190: a.web_html_call
191: from fnd_form_functions_vl a,
192: fnd_menu_entries_vl b
193: where b.menu_id = p_object.parent_menu_id
194: and a.function_id = b.function_id
195: and a.type in ('WEBPORTLET')
196: and a.web_html_call like '%BIS_PM_RELATED_LINK_LAYOUT%'

Line 295: fnd_menu_entries_vl b

291: --ansingh -Preseed Related Links Enhancement -Start
292: select count(*)
293: into l_rl_portlet_count
294: from fnd_form_functions_vl a,
295: fnd_menu_entries_vl b
296: where b.menu_id = p_object.parent_menu_id
297: and a.function_id = b.function_id
298: and a.type in ('WEBPORTLET')
299: and a.web_html_call like '%BIS_PM_RELATED_LINK_LAYOUT%';

Line 421: from fnd_menu_entries_vl

417: sub_menu_id
418: into l_prompt,
419: l_description,
420: l_sub_menu_id
421: from fnd_menu_entries_vl
422: where menu_id = p_object.parent_menu_id
423: and entry_sequence = p_object.entry_sequence
424: order by entry_sequence;
425:

Line 2311: FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2307: nvl(fff.description, nvl(mev.description, mev.prompt)) AS Description,
2308: ''N'' as DummySelect,
2309: NULL as ReportUrl
2310: FROM
2311: FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2312: WHERE
2313: mev.function_id=fff.function_id
2314: AND mev.function_id in (';
2315: --function criteria

Line 2359: FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2355: nvl(fff.description, nvl(mev.description, mev.prompt)) as Description,
2356: ''N'' as DummySelect,
2357: NULL as ReportUrl
2358: FROM
2359: FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2360: where
2361: mev.function_id=fff.function_id
2362: AND mev.function_id in (';
2363:

Line 2518: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2514: fff.user_function_name AS Prompt,
2515: nvl(fff.description, nvl(mev.description, mev.prompt)) as Description,
2516: ''N'' as DummySelect,
2517: null as ReportUrl
2518: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2519: where mev.function_id=fff.function_id
2520: AND mev.function_id in (';
2521: l_function_bindstring := '';
2522: for i in 1..l_function_count loop

Line 2574: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2570: fff.user_function_name AS Prompt,
2571: nvl(fff.description, nvl(mev.description, mev.prompt)) as Description,
2572: ''N'' as DummySelect,
2573: null as ReportUrl
2574: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2575: where mev.function_id=fff.function_id
2576: and mev.function_id in (';
2577: l_function_bindstring := '';
2578: for i in 1..l_function_count loop

Line 2726: FROM FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2722: NVL(mev.prompt, fff.function_name) AS Prompt,
2723: nvl(fff.description, nvl(mev.description, mev.prompt)) AS Description,
2724: ''N'' AS DummySelect,
2725: NULL AS ReportUrl
2726: FROM FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2727: WHERE mev.function_id IN (';
2728: l_function_bindstring := '';
2729: for i in 1..l_function_count loop
2730: if (i <> 1) then

Line 2779: FROM FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2775: NVL(mev.prompt, fff.function_name) AS Prompt,
2776: nvl(fff.description, nvl(mev.description, mev.prompt)) AS Description,
2777: ''N'' AS DummySelect,
2778: NULL AS ReportUrl
2779: FROM FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2780: WHERE mev.function_id IN (';
2781: l_function_bindstring := '';
2782: for i in 1..l_function_count loop
2783: if (i <> 1) then

Line 2925: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2921: fff.user_function_name AS Prompt,
2922: nvl(fff.description, nvl(mev.description, mev.prompt)) as Description,
2923: ''N'' as DummySelect,
2924: null as ReportUrl
2925: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2926: where mev.function_id=fff.function_id
2927: and mev.function_id in (';
2928: l_function_bindstring := '';
2929: for i in 1..l_function_count loop

Line 2980: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2976: fff.user_function_name AS Prompt,
2977: nvl(fff.description, nvl(mev.description, mev.prompt)) as Description,
2978: ''N'' as DummySelect,
2979: null as ReportUrl
2980: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2981: where mev.function_id=fff.function_id
2982: and mev.function_id in (';
2983: l_function_bindstring := '';
2984: for i in 1..l_function_count loop