DBA Data[Home] [Help]

APPS.IRC_PARTY_API dependencies on FND_MENUS

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

2856: l_menu_id number;
2857: l_grant_name varchar2(80);
2858: --
2859: cursor get_menu_id (p_menu_name varchar2) is
2860: select menu_id from fnd_menus where menu_name=upper(p_menu_name);
2861: --
2862: begin
2863: hr_utility.set_location(' Entering: '||l_proc, 10);
2864: --

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

3597: from fnd_user fusr
3598: where fusr.user_name=p_user_name;
3599: --
3600: cursor get_menu_id (p_menu_name varchar2)is
3601: select menu_id from fnd_menus where menu_name=upper(p_menu_name);
3602: --
3603: cursor get_party_id(p_user_name varchar2) is
3604: select fusr.person_party_id
3605: from fnd_user fusr

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

4347: and ptuf.person_type_id=p_person_type_id
4348: and trunc(sysdate) between ptuf.effective_start_date and ptuf.effective_end_date;
4349: --
4350: cursor get_menu_id (p_menu_name varchar2)is
4351: select menu_id from fnd_menus where menu_name=upper(p_menu_name);
4352: --
4353: l_nls_language fnd_languages.nls_language%type;
4354: --
4355: --

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

5212: l_menu_id number;
5213: l_grant_name varchar2(80);
5214: --
5215: cursor get_menu_id (p_menu_name varchar2) is
5216: select menu_id from fnd_menus where menu_name=upper(p_menu_name);
5217: --
5218: begin
5219: hr_utility.set_location(' Entering: '||l_proc, 10);
5220: --