APPS.JTF_MENU_PUB dependencies on FND_MENU_ENTRIES_VL

Line 28: from fnd_menu_entries_vl a, fnd_menus b

24: );
25:
26: cursor get_app_menu(p_menuid number) is
27: select a.sub_menu_id , prompt,description,function_id,menu_name
28: from fnd_menu_entries_vl a, fnd_menus b
29: where a.menu_id = p_menuid and b.menu_id(+) = a.sub_menu_id ;
30:
31: cursor get_function_c(p_functionid number) is
32: select web_host_name, web_agent_name,web_html_call,

Line 450: -- from fnd_menu_entries_vl a, fnd_menus b

446: cursor get_sub_menus(p_mid number, pp_lang varchar2) is
447: -- here's the query, before we parameterized it by language
448: -- select sub_menu_id, prompt, description, function_id, menu_name,
449: -- rowidtochar(a.rowid) menu_entry_rowid
450: -- from fnd_menu_entries_vl a, fnd_menus b
451: -- where a.menu_id = p_mid and b.menu_id(+) = a.sub_menu_id
452: -- order by entry_sequence;
453: SELECT
454: rowidtochar(B.ROWID) menu_entry_rowid, B.MENU_ID, B.ENTRY_SEQUENCE,

Line 510: from fnd_menu_entries_vl a, fnd_menus b

506:
507: cursor get_sub_menus(p_mid number) is
508: --select sub_menu_id, prompt, description, function_id, menu_name, rowidtochar(a.rowid) menu_entry_rowid
509: select sub_menu_id, prompt, description, function_id, menu_name, rowidtochar(a.row_id) menu_entry_rowid
510: from fnd_menu_entries_vl a, fnd_menus b
511: where a.menu_id = p_mid and b.menu_id(+) = a.sub_menu_id
512: order by entry_sequence;
513:
514: BEGIN

Line 561: from fnd_menu_entries_vl

557:
558: cursor get_sub_menus(p_mid number) is
559: -- select sub_menu_id, prompt, description, function_id, '' menu_name, rowidtochar(rowid) menu_entry_rowid
560: select sub_menu_id, prompt, description, function_id, '' menu_name, rowidtochar(row_id) menu_entry_rowid
561: from fnd_menu_entries_vl
562: where menu_id = p_mid
563: order by entry_sequence;
564:
565: BEGIN

Line 660: -- from fnd_menu_entries_vl

656: l_prompt_name varchar2(30);
657: -- here's the query, before we parameterized it by language
658: -- cursor get_menu_name(p_row_id varchar2) is
659: -- select prompt
660: -- from fnd_menu_entries_vl
661: -- where rowid = chartorowid(p_row_id);
662: cursor get_menu_name(p_row_id varchar2, pp_lang varchar2) is
663: SELECT T.PROMPT
664: FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B

Line 690: from fnd_menu_entries_vl

686: l_prompt_name varchar2(30);
687:
688: cursor get_menu_name(p_row_id varchar2) is
689: select prompt
690: from fnd_menu_entries_vl
691: --where rowid = chartorowid(p_row_id);
692: where row_id = chartorowid(p_row_id);
693:
694: BEGIN