eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_GRANTS_UTIL dependencies on FND_USER

Line 17: fnd_user fu, fnd_user_resp_groups furg

13: IS
14: cursor csr_get_candidates(p_resp_id number, p_menu_id number) is
15: select fu.user_id, fu.user_name, furg.security_group_id
16: from
17: fnd_user fu, fnd_user_resp_groups furg
18: where furg.responsibility_id = p_resp_id
19: and furg.user_id=fu.user_id
20: and fu.user_id > 1000
21: and trunc(sysdate) between nvl(fu.start_date,trunc(sysdate)) and nvl(fu.end_date,trunc(sysdate))

Line 34: TYPE l_user_id_typ IS TABLE OF FND_USER.USER_ID%TYPE index by binary_integer;

30: from fnd_responsibility where responsibility_key=upper(p_resp_key);
31:
32: l_user_id number;
33:
34: TYPE l_user_id_typ IS TABLE OF FND_USER.USER_ID%TYPE index by binary_integer;
35: TYPE l_user_name_typ IS TABLE OF FND_USER.USER_NAME%TYPE index by binary_integer;
36: TYPE l_resp_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_ID%TYPE index by binary_integer;
37: TYPE l_resp_appl_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_APPLICATION_ID%TYPE index by binary_integer;
38: TYPE l_sec_group_id_typ IS TABLE OF FND_USER_RESP_GROUPS.SECURITY_GROUP_ID%TYPE index by binary_integer;

Line 35: TYPE l_user_name_typ IS TABLE OF FND_USER.USER_NAME%TYPE index by binary_integer;

31:
32: l_user_id number;
33:
34: TYPE l_user_id_typ IS TABLE OF FND_USER.USER_ID%TYPE index by binary_integer;
35: TYPE l_user_name_typ IS TABLE OF FND_USER.USER_NAME%TYPE index by binary_integer;
36: TYPE l_resp_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_ID%TYPE index by binary_integer;
37: TYPE l_resp_appl_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_APPLICATION_ID%TYPE index by binary_integer;
38: TYPE l_sec_group_id_typ IS TABLE OF FND_USER_RESP_GROUPS.SECURITY_GROUP_ID%TYPE index by binary_integer;
39:

Line 36: TYPE l_resp_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_ID%TYPE index by binary_integer;

32: l_user_id number;
33:
34: TYPE l_user_id_typ IS TABLE OF FND_USER.USER_ID%TYPE index by binary_integer;
35: TYPE l_user_name_typ IS TABLE OF FND_USER.USER_NAME%TYPE index by binary_integer;
36: TYPE l_resp_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_ID%TYPE index by binary_integer;
37: TYPE l_resp_appl_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_APPLICATION_ID%TYPE index by binary_integer;
38: TYPE l_sec_group_id_typ IS TABLE OF FND_USER_RESP_GROUPS.SECURITY_GROUP_ID%TYPE index by binary_integer;
39:
40: l_user_id_tbl l_user_id_typ;

Line 37: TYPE l_resp_appl_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_APPLICATION_ID%TYPE index by binary_integer;

33:
34: TYPE l_user_id_typ IS TABLE OF FND_USER.USER_ID%TYPE index by binary_integer;
35: TYPE l_user_name_typ IS TABLE OF FND_USER.USER_NAME%TYPE index by binary_integer;
36: TYPE l_resp_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_ID%TYPE index by binary_integer;
37: TYPE l_resp_appl_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_APPLICATION_ID%TYPE index by binary_integer;
38: TYPE l_sec_group_id_typ IS TABLE OF FND_USER_RESP_GROUPS.SECURITY_GROUP_ID%TYPE index by binary_integer;
39:
40: l_user_id_tbl l_user_id_typ;
41: l_user_name_tbl l_user_name_typ;

Line 38: TYPE l_sec_group_id_typ IS TABLE OF FND_USER_RESP_GROUPS.SECURITY_GROUP_ID%TYPE index by binary_integer;

34: TYPE l_user_id_typ IS TABLE OF FND_USER.USER_ID%TYPE index by binary_integer;
35: TYPE l_user_name_typ IS TABLE OF FND_USER.USER_NAME%TYPE index by binary_integer;
36: TYPE l_resp_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_ID%TYPE index by binary_integer;
37: TYPE l_resp_appl_id_typ IS TABLE OF FND_USER_RESP_GROUPS.RESPONSIBILITY_APPLICATION_ID%TYPE index by binary_integer;
38: TYPE l_sec_group_id_typ IS TABLE OF FND_USER_RESP_GROUPS.SECURITY_GROUP_ID%TYPE index by binary_integer;
39:
40: l_user_id_tbl l_user_id_typ;
41: l_user_name_tbl l_user_name_typ;
42: l_sec_group_id_tbl l_sec_group_id_typ;