APPS.IRC_PARTY_API dependencies on FND_MENUS

Line 2743: select menu_id from fnd_menus where menu_name=upper(p_menu_name);

2739: l_menu_id number;
2740: l_grant_name varchar2(80);
2741: --
2742: cursor get_menu_id (p_menu_name varchar2) is
2743: select menu_id from fnd_menus where menu_name=upper(p_menu_name);
2744: --
2745: begin
2746: hr_utility.set_location(' Entering: '||l_proc, 10);
2747: --

Line 3472: select menu_id from fnd_menus where menu_name=upper(p_menu_name);

3468: from fnd_user fusr
3469: where fusr.user_name=p_user_name;
3470: --
3471: cursor get_menu_id (p_menu_name varchar2)is
3472: select menu_id from fnd_menus where menu_name=upper(p_menu_name);
3473: --
3474: l_user_id number;
3475: l_profile_check boolean;
3476: l_sec_profile_assignment_id number;

Line 4123: select menu_id from fnd_menus where menu_name=upper(p_menu_name);

4119: and ptuf.person_type_id=p_person_type_id
4120: and trunc(sysdate) between ptuf.effective_start_date and ptuf.effective_end_date;
4121: --
4122: cursor get_menu_id (p_menu_name varchar2)is
4123: select menu_id from fnd_menus where menu_name=upper(p_menu_name);
4124: --
4125: l_nls_language fnd_languages.nls_language%type;
4126: --
4127: --

Line 4986: select menu_id from fnd_menus where menu_name=upper(p_menu_name);

4982: l_menu_id number;
4983: l_grant_name varchar2(80);
4984: --
4985: cursor get_menu_id (p_menu_name varchar2) is
4986: select menu_id from fnd_menus where menu_name=upper(p_menu_name);
4987: --
4988: begin
4989: hr_utility.set_location(' Entering: '||l_proc, 10);
4990: --