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.HR_USER_ACCT_API dependencies on FND_RESPONSIBILITY

Line 10: g_emtpy_fnd_resp_tbl hr_user_acct_utility.fnd_responsibility_tbl;

6: --
7: g_package varchar2(33) := 'hr_user_acct_api.';
8: g_api_vers constant number := 1.0;
9: g_empty_fnd_user_rec hr_user_acct_utility.fnd_user_rec;
10: g_emtpy_fnd_resp_tbl hr_user_acct_utility.fnd_responsibility_tbl;
11: g_emtpy_fnd_prof_opt_val_tbl hr_user_acct_utility.fnd_profile_opt_val_tbl;
12: g_empty_fnd_resp_func_tbl hr_user_acct_utility.fnd_resp_functions_tbl;
13: g_empty_func_sec_excl_tbl hr_user_acct_utility.func_sec_excl_tbl;
14: --

Line 43: l_exist_resp_id fnd_responsibility.responsibility_id%type;

39: --
40: -- Declare cursors and local variables
41: -- The following two variables must be declared ahead of the cursors because
42: -- they are referenced inside the cursors.
43: l_exist_resp_id fnd_responsibility.responsibility_id%type;
44: l_exist_resp_app_id fnd_responsibility.application_id%type;
45: --
46: --
47: CURSOR lc_get_existing_fnd_resp

Line 44: l_exist_resp_app_id fnd_responsibility.application_id%type;

40: -- Declare cursors and local variables
41: -- The following two variables must be declared ahead of the cursors because
42: -- they are referenced inside the cursors.
43: l_exist_resp_id fnd_responsibility.responsibility_id%type;
44: l_exist_resp_app_id fnd_responsibility.application_id%type;
45: --
46: --
47: CURSOR lc_get_existing_fnd_resp
48: IS

Line 65: FROM fnd_responsibility fr

61: ,fr.group_application_id req_group_app_id
62: ,fr.version
63: ,fr.web_host_name
64: ,fr.web_agent_name
65: FROM fnd_responsibility fr
66: ,fnd_responsibility_tl frtl
67: ,fnd_menus fm
68: ,fnd_data_groups fdg
69: ,fnd_request_groups frg

Line 66: ,fnd_responsibility_tl frtl

62: ,fr.version
63: ,fr.web_host_name
64: ,fr.web_agent_name
65: FROM fnd_responsibility fr
66: ,fnd_responsibility_tl frtl
67: ,fnd_menus fm
68: ,fnd_data_groups fdg
69: ,fnd_request_groups frg
70: WHERE fr.responsibility_id = l_exist_resp_id

Line 84: FROM fnd_responsibility

80: --
81: CURSOR lc_fnd_resp_exists (p_resp_key in varchar2)
82: IS
83: SELECT responsibility_id, application_id
84: FROM fnd_responsibility
85: WHERE responsibility_key = p_resp_key;
86: --
87: CURSOR lc_get_sec_group_id
88: IS

Line 109: l_fnd_resp_rec hr_user_acct_utility.fnd_responsibility_rec;

105: l_language fnd_profile_option_values.profile_option_value%type
106: default null;
107: l_user_id number default null;
108: --
109: l_fnd_resp_rec hr_user_acct_utility.fnd_responsibility_rec;
110: l_responsibility_id fnd_responsibility.responsibility_id%type := null;
111: l_responsibility_key fnd_responsibility.responsibility_key%type := null;
112: l_user_resp_start_date fnd_user_resp_groups.start_date%type;
113: l_user_resp_end_date fnd_user_resp_groups.end_date%type;

Line 110: l_responsibility_id fnd_responsibility.responsibility_id%type := null;

106: default null;
107: l_user_id number default null;
108: --
109: l_fnd_resp_rec hr_user_acct_utility.fnd_responsibility_rec;
110: l_responsibility_id fnd_responsibility.responsibility_id%type := null;
111: l_responsibility_key fnd_responsibility.responsibility_key%type := null;
112: l_user_resp_start_date fnd_user_resp_groups.start_date%type;
113: l_user_resp_end_date fnd_user_resp_groups.end_date%type;
114: l_user_level_only boolean default false;

Line 111: l_responsibility_key fnd_responsibility.responsibility_key%type := null;

107: l_user_id number default null;
108: --
109: l_fnd_resp_rec hr_user_acct_utility.fnd_responsibility_rec;
110: l_responsibility_id fnd_responsibility.responsibility_id%type := null;
111: l_responsibility_key fnd_responsibility.responsibility_key%type := null;
112: l_user_resp_start_date fnd_user_resp_groups.start_date%type;
113: l_user_resp_end_date fnd_user_resp_groups.end_date%type;
114: l_user_level_only boolean default false;
115: l_count number default 0;

Line 123: l_new_resp_id fnd_responsibility.responsibility_id%type := null;

119: l_out_profile_opt_val_tbl hr_user_acct_utility.fnd_profile_opt_val_tbl;
120: l_out_profile_opt_val_count number default 0;
121: l_profile_value_saved boolean default null;
122: l_msg_text varchar2(2000) default null;
123: l_new_resp_id fnd_responsibility.responsibility_id%type := null;
124: l_temp varchar2(2000) default null;
125: l_out_func_sec_excl_tbl hr_user_acct_utility.func_sec_excl_tbl;
126: l_old_resp_rec lc_get_existing_fnd_resp%rowtype;
127: l_user_resp_app_id fnd_responsibility.application_id%type := null;

Line 127: l_user_resp_app_id fnd_responsibility.application_id%type := null;

123: l_new_resp_id fnd_responsibility.responsibility_id%type := null;
124: l_temp varchar2(2000) default null;
125: l_out_func_sec_excl_tbl hr_user_acct_utility.func_sec_excl_tbl;
126: l_old_resp_rec lc_get_existing_fnd_resp%rowtype;
127: l_user_resp_app_id fnd_responsibility.application_id%type := null;
128: l_temp_id number(15) default null;
129: l_status varchar2(2000) default null;
130: l_enable_sec_groups varchar2(2000) default null;
131: l_sec_profile_asg_count number(15) default null;

Line 259: -- Create the fnd_responsibility record

255: );
256: --
257: hr_utility.set_location(l_proc, 30);
258: --
259: -- Create the fnd_responsibility record
260: --
261: l_resp_count := hr_user_acct_utility.g_fnd_resp_tbl.count;
262: --
263: IF l_resp_count < 1

Line 306: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');

302: IF lc_get_existing_fnd_resp%NOTFOUND
303: THEN
304: CLOSE lc_get_existing_fnd_resp;
305: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
306: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
307: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
308: fnd_message.set_token('VALUE', to_char(l_exist_resp_id));
309: hr_utility.raise_error;
310: ELSE

Line 462: hr_user_acct_internal.create_fnd_responsibility

458: hr_utility.set_location(l_proc, 40);
459: -- **********************************************
460: -- Create the new responsibility
461: -- **********************************************
462: hr_user_acct_internal.create_fnd_responsibility
463: (p_resp_key => l_fnd_resp_rec.new_resp_key
464: ,p_resp_name => l_fnd_resp_rec.new_resp_name
465: ,p_resp_app_id => l_fnd_resp_rec.new_resp_app_id
466: ,p_resp_description => l_fnd_resp_rec.new_resp_description

Line 733: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');

729: IF lc_fnd_resp_exists%NOTFOUND
730: THEN
731: CLOSE lc_fnd_resp_exists;
732: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
733: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
734: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
735: fnd_message.set_token('VALUE',
736: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
737: hr_utility.raise_error;

Line 807: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');

803: IF lc_fnd_resp_exists%NOTFOUND
804: THEN
805: CLOSE lc_fnd_resp_exists;
806: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
807: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
808: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
809: fnd_message.set_token('VALUE',
810: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
811: hr_utility.raise_error;

Line 1079: FROM fnd_user_resp_groups_direct furgd, FND_RESPONSIBILITY fr

1075: ,furgd.security_group_id
1076: ,furgd.start_date
1077: ,furgd.end_date
1078: -- ,description
1079: FROM fnd_user_resp_groups_direct furgd, FND_RESPONSIBILITY fr
1080: WHERE furgd.user_id = c_user_id
1081: AND fr.responsibility_id = furgd.responsibility_id
1082: AND trunc(sysdate) between fr.start_date and nvl(fr.end_date,sysdate)
1083: AND nvl(furgd.end_date, l_date + 1) > l_date