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_UTILITY dependencies on FND_RESPONSIBILITY

Line 118: -- the fnd_responsibility.responsibility_id value.

114: -- existing_resp_id - optional. If creating a new responsibility and would
115: -- want to use an existing responsibility as a template,
116: -- or to associate the new user name to an existing
117: -- responsibililty, then fill in this field with
118: -- the fnd_responsibility.responsibility_id value.
119: -- If no template is to be used, leave this field null.
120: --
121: -- existing_resp_key - optional. If creating a new responsibility and would
122: -- want to use an existing responsibility as a template,

Line 125: -- the fnd_responsibility.responsibility_key value.

121: -- existing_resp_key - optional. If creating a new responsibility and would
122: -- want to use an existing responsibility as a template,
123: -- or to associate the new user name to an existing
124: -- responsibililty, then fill in this field with
125: -- the fnd_responsibility.responsibility_key value.
126: -- If no template is to be used, leave this field null.
127: --
128: -- existing_resp_app_id - optional. If creating a new responsibility and would
129: -- want to use an existing responsibility as a template,

Line 132: -- the fnd_responsibility.application_id value.

128: -- existing_resp_app_id - optional. If creating a new responsibility and would
129: -- want to use an existing responsibility as a template,
130: -- or to associate the new user name to an existing
131: -- responsibililty, then fill in this field with
132: -- the fnd_responsibility.application_id value.
133: -- If no template is to be used, leave this field null.
134: -- the fnd_responsibility.responsibility_id value.
135: --
136: -- new_resp_name - mandatory only for creating a new responsibility. If

Line 134: -- the fnd_responsibility.responsibility_id value.

130: -- or to associate the new user name to an existing
131: -- responsibililty, then fill in this field with
132: -- the fnd_responsibility.application_id value.
133: -- If no template is to be used, leave this field null.
134: -- the fnd_responsibility.responsibility_id value.
135: --
136: -- new_resp_name - mandatory only for creating a new responsibility. If
137: -- entered, cannot exceed the length of
138: -- fnd_responsibility_tl.responsibility_name, which is

Line 138: -- fnd_responsibility_tl.responsibility_name, which is

134: -- the fnd_responsibility.responsibility_id value.
135: --
136: -- new_resp_name - mandatory only for creating a new responsibility. If
137: -- entered, cannot exceed the length of
138: -- fnd_responsibility_tl.responsibility_name, which is
139: -- 100 characters. If associating the new user name to
140: -- an existing responsibility, do not enter any value
141: -- in this field.
142: --

Line 145: -- fnd_responsibility.responsibility_key, which is

141: -- in this field.
142: --
143: -- new_resp_key - mandatory only for creating a new responsibility. If
144: -- entered, cannot exceed the length of
145: -- fnd_responsibility.responsibility_key, which is
146: -- 30 characters. If associating the new user name to
147: -- an existing responsibility, do not enter any value
148: -- in this field.
149: --

Line 152: -- fnd_responsibility.application_id, which is a number type

148: -- in this field.
149: --
150: -- new_resp_app_id - mandatory only for creating a new responsibility. If
151: -- entered, cannot exceed the length of
152: -- fnd_responsibility.application_id, which is a number type
153: -- with a size of 15. If associating the new user name to
154: -- an existing responsibility, do not enter any value
155: -- in this field.
156: --

Line 159: -- fnd_responsibility_tl.description, which is 240

155: -- in this field.
156: --
157: -- new_resp_description - optional for creating a new responsibility. If
158: -- entered, cannot exceed the length of
159: -- fnd_responsibility_tl.description, which is 240
160: -- characters. If associating the new user name to
161: -- an existing responsibility, do not enter any value
162: -- in this field.
163: --

Line 183: -- fnd_responsibility.data_group_application_id, which is

179: -- responsibility, do not enter any value in this field.
180: --
181: -- new_resp_data_grp_app_id - mandatory only for creating a new responsibility.
182: -- Length cannot exceed the length of
183: -- fnd_responsibility.data_group_application_id, which is
184: -- a number data type with a size of 15.
185: -- If associating the new user name to an existing
186: -- responsibility, do not enter any value in this field.
187: --

Line 211: -- fnd_responsibility.version, which is 1 character with

207: -- responsibility, do not enter any value in this field.
208: --
209: -- new_resp_version - optional for creating a new responsibility.
210: -- If entered, cannot exceed the length of
211: -- fnd_responsibility.version, which is 1 character with
212: -- the following valid values:
213: -- '4' = Oracle Applications, ie. Forms
214: -- 'W' = Oracle Self Service Web Applications.
215: -- If associating the new user name to an existing

Line 304: TYPE fnd_responsibility_rec IS RECORD

300: -------------------------------------------------------------------------------
301: --
302: -- RECORD STRUCTURE FOR FND_RESPONSIBILITIES
303: -- =========================================
304: TYPE fnd_responsibility_rec IS RECORD
305: (existing_resp_id fnd_responsibility.responsibility_id%type
306: ,existing_resp_key fnd_responsibility.responsibility_key%type
307: ,existing_resp_app_id fnd_responsibility.application_id%type
308: ,new_resp_name fnd_responsibility_tl.responsibility_name%type

Line 305: (existing_resp_id fnd_responsibility.responsibility_id%type

301: --
302: -- RECORD STRUCTURE FOR FND_RESPONSIBILITIES
303: -- =========================================
304: TYPE fnd_responsibility_rec IS RECORD
305: (existing_resp_id fnd_responsibility.responsibility_id%type
306: ,existing_resp_key fnd_responsibility.responsibility_key%type
307: ,existing_resp_app_id fnd_responsibility.application_id%type
308: ,new_resp_name fnd_responsibility_tl.responsibility_name%type
309: ,new_resp_key fnd_responsibility.responsibility_key%type

Line 306: ,existing_resp_key fnd_responsibility.responsibility_key%type

302: -- RECORD STRUCTURE FOR FND_RESPONSIBILITIES
303: -- =========================================
304: TYPE fnd_responsibility_rec IS RECORD
305: (existing_resp_id fnd_responsibility.responsibility_id%type
306: ,existing_resp_key fnd_responsibility.responsibility_key%type
307: ,existing_resp_app_id fnd_responsibility.application_id%type
308: ,new_resp_name fnd_responsibility_tl.responsibility_name%type
309: ,new_resp_key fnd_responsibility.responsibility_key%type
310: ,new_resp_app_id fnd_application.application_id%type

Line 307: ,existing_resp_app_id fnd_responsibility.application_id%type

303: -- =========================================
304: TYPE fnd_responsibility_rec IS RECORD
305: (existing_resp_id fnd_responsibility.responsibility_id%type
306: ,existing_resp_key fnd_responsibility.responsibility_key%type
307: ,existing_resp_app_id fnd_responsibility.application_id%type
308: ,new_resp_name fnd_responsibility_tl.responsibility_name%type
309: ,new_resp_key fnd_responsibility.responsibility_key%type
310: ,new_resp_app_id fnd_application.application_id%type
311: ,new_resp_description fnd_responsibility_tl.description%type

Line 308: ,new_resp_name fnd_responsibility_tl.responsibility_name%type

304: TYPE fnd_responsibility_rec IS RECORD
305: (existing_resp_id fnd_responsibility.responsibility_id%type
306: ,existing_resp_key fnd_responsibility.responsibility_key%type
307: ,existing_resp_app_id fnd_responsibility.application_id%type
308: ,new_resp_name fnd_responsibility_tl.responsibility_name%type
309: ,new_resp_key fnd_responsibility.responsibility_key%type
310: ,new_resp_app_id fnd_application.application_id%type
311: ,new_resp_description fnd_responsibility_tl.description%type
312: ,new_resp_start_date fnd_responsibility.start_date%type

Line 309: ,new_resp_key fnd_responsibility.responsibility_key%type

305: (existing_resp_id fnd_responsibility.responsibility_id%type
306: ,existing_resp_key fnd_responsibility.responsibility_key%type
307: ,existing_resp_app_id fnd_responsibility.application_id%type
308: ,new_resp_name fnd_responsibility_tl.responsibility_name%type
309: ,new_resp_key fnd_responsibility.responsibility_key%type
310: ,new_resp_app_id fnd_application.application_id%type
311: ,new_resp_description fnd_responsibility_tl.description%type
312: ,new_resp_start_date fnd_responsibility.start_date%type
313: ,new_resp_end_date fnd_responsibility.end_date%type

Line 311: ,new_resp_description fnd_responsibility_tl.description%type

307: ,existing_resp_app_id fnd_responsibility.application_id%type
308: ,new_resp_name fnd_responsibility_tl.responsibility_name%type
309: ,new_resp_key fnd_responsibility.responsibility_key%type
310: ,new_resp_app_id fnd_application.application_id%type
311: ,new_resp_description fnd_responsibility_tl.description%type
312: ,new_resp_start_date fnd_responsibility.start_date%type
313: ,new_resp_end_date fnd_responsibility.end_date%type
314: ,new_resp_data_group_name
315: fnd_data_groups_standard_view.data_group_name%type

Line 312: ,new_resp_start_date fnd_responsibility.start_date%type

308: ,new_resp_name fnd_responsibility_tl.responsibility_name%type
309: ,new_resp_key fnd_responsibility.responsibility_key%type
310: ,new_resp_app_id fnd_application.application_id%type
311: ,new_resp_description fnd_responsibility_tl.description%type
312: ,new_resp_start_date fnd_responsibility.start_date%type
313: ,new_resp_end_date fnd_responsibility.end_date%type
314: ,new_resp_data_group_name
315: fnd_data_groups_standard_view.data_group_name%type
316: ,new_resp_data_grp_app_id

Line 313: ,new_resp_end_date fnd_responsibility.end_date%type

309: ,new_resp_key fnd_responsibility.responsibility_key%type
310: ,new_resp_app_id fnd_application.application_id%type
311: ,new_resp_description fnd_responsibility_tl.description%type
312: ,new_resp_start_date fnd_responsibility.start_date%type
313: ,new_resp_end_date fnd_responsibility.end_date%type
314: ,new_resp_data_group_name
315: fnd_data_groups_standard_view.data_group_name%type
316: ,new_resp_data_grp_app_id
317: fnd_responsibility.data_group_application_id%type

Line 317: fnd_responsibility.data_group_application_id%type

313: ,new_resp_end_date fnd_responsibility.end_date%type
314: ,new_resp_data_group_name
315: fnd_data_groups_standard_view.data_group_name%type
316: ,new_resp_data_grp_app_id
317: fnd_responsibility.data_group_application_id%type
318: ,new_resp_menu_name fnd_menus.menu_name%type
319: ,new_resp_request_group_name fnd_request_groups.request_group_name%type
320: ,new_resp_req_grp_app_id fnd_application.application_id%type
321: ,new_resp_version fnd_responsibility.version%type

Line 321: ,new_resp_version fnd_responsibility.version%type

317: fnd_responsibility.data_group_application_id%type
318: ,new_resp_menu_name fnd_menus.menu_name%type
319: ,new_resp_request_group_name fnd_request_groups.request_group_name%type
320: ,new_resp_req_grp_app_id fnd_application.application_id%type
321: ,new_resp_version fnd_responsibility.version%type
322: ,new_resp_web_host_name fnd_responsibility.web_host_name%type
323: ,new_resp_web_agent_name fnd_responsibility.web_agent_name%type
324: ,user_resp_start_date fnd_user_resp_groups.start_date%type
325: ,user_resp_end_date fnd_user_resp_groups.end_date%type

Line 322: ,new_resp_web_host_name fnd_responsibility.web_host_name%type

318: ,new_resp_menu_name fnd_menus.menu_name%type
319: ,new_resp_request_group_name fnd_request_groups.request_group_name%type
320: ,new_resp_req_grp_app_id fnd_application.application_id%type
321: ,new_resp_version fnd_responsibility.version%type
322: ,new_resp_web_host_name fnd_responsibility.web_host_name%type
323: ,new_resp_web_agent_name fnd_responsibility.web_agent_name%type
324: ,user_resp_start_date fnd_user_resp_groups.start_date%type
325: ,user_resp_end_date fnd_user_resp_groups.end_date%type
326: ,user_resp_description fnd_user_resp_groups.description%type

Line 323: ,new_resp_web_agent_name fnd_responsibility.web_agent_name%type

319: ,new_resp_request_group_name fnd_request_groups.request_group_name%type
320: ,new_resp_req_grp_app_id fnd_application.application_id%type
321: ,new_resp_version fnd_responsibility.version%type
322: ,new_resp_web_host_name fnd_responsibility.web_host_name%type
323: ,new_resp_web_agent_name fnd_responsibility.web_agent_name%type
324: ,user_resp_start_date fnd_user_resp_groups.start_date%type
325: ,user_resp_end_date fnd_user_resp_groups.end_date%type
326: ,user_resp_description fnd_user_resp_groups.description%type
327: ,sec_group_id

Line 332: TYPE fnd_responsibility_tbl IS TABLE OF fnd_responsibility_rec

328: per_sec_profile_assignments.security_group_id%type
329: ,sec_profile_id per_sec_profile_assignments.security_profile_id%type
330: );
331:
332: TYPE fnd_responsibility_tbl IS TABLE OF fnd_responsibility_rec
333: INDEX BY BINARY_INTEGER;
334: --
335: -- USE INDEX = 1 TO START LOADING THE TABLE.
336: g_fnd_resp_tbl fnd_responsibility_tbl;

Line 336: g_fnd_resp_tbl fnd_responsibility_tbl;

332: TYPE fnd_responsibility_tbl IS TABLE OF fnd_responsibility_rec
333: INDEX BY BINARY_INTEGER;
334: --
335: -- USE INDEX = 1 TO START LOADING THE TABLE.
336: g_fnd_resp_tbl fnd_responsibility_tbl;
337:
338: --
339: -- ----------------------------------------------------------------------------
340: -- USAGE NOTES FOR ASSOCIATING FUNCTION SECURITY EXCLUSION RULES TO A NEW

Line 355: -- fnd_responsibility.responsibility_key, which is

351: -- function security exclusion rules are to be copied to the
352: -- new responsibility, then this field can be filled in with
353: -- an existing responsibility key in the database.
354: -- If entered, cannot exceed the length of
355: -- fnd_responsibility.responsibility_key, which is
356: -- 30 characters.
357: -- If you want to add a new function exclusion rule, you need
358: -- to create a new entry in this table with this field being
359: -- null.

Line 363: -- of fnd_responsibility.responsibility_key, which is

359: -- null.
360: --
361: -- new_resp_key - mandatory for a new responsibility listed in
362: -- g_fnd_resp_tbl above. Length cannot exceed the length
363: -- of fnd_responsibility.responsibility_key, which is
364: -- 30 characters.
365: --
366: -- rule_type - optional. If the function security exclusion rules of a
367: -- template responsibility are to be used, this field can be

Line 409: (existing_resp_key fnd_responsibility.responsibility_key%type

405: --
406: -- RECORD STRUCTURE FOR FND_RESP_FUNCTIONS:
407: -- =========================================
408: TYPE fnd_resp_functions_rec IS RECORD
409: (existing_resp_key fnd_responsibility.responsibility_key%type
410: ,new_resp_key fnd_responsibility.responsibility_key%type
411: ,rule_type fnd_resp_functions.rule_type%type
412: ,rule_name varchar2(30)
413: ,delete_flag varchar2(1));

Line 410: ,new_resp_key fnd_responsibility.responsibility_key%type

406: -- RECORD STRUCTURE FOR FND_RESP_FUNCTIONS:
407: -- =========================================
408: TYPE fnd_resp_functions_rec IS RECORD
409: (existing_resp_key fnd_responsibility.responsibility_key%type
410: ,new_resp_key fnd_responsibility.responsibility_key%type
411: ,rule_type fnd_resp_functions.rule_type%type
412: ,rule_name varchar2(30)
413: ,delete_flag varchar2(1));
414: --

Line 528: -- - fnd_responsibility.responsbility_key if

524: --
525: -- profile_level_value - mandatory for creating a new profile option value
526: -- at the new responsibility level or at the new user level.
527: -- It must be one of the following values:
528: -- - fnd_responsibility.responsbility_key if
529: -- profile_level_name = "RESP"
530: -- - fnd_user.user_id if profile_level_name = "USER".
531: --
532: -- Examples:

Line 535: -- fnd_responsibility.responsibility_key, which is

531: --
532: -- Examples:
533: -- - to create a new profile option value for the
534: -- responsibility "US HRMS Manager", this field will be the
535: -- fnd_responsibility.responsibility_key, which is
536: -- "US_HRMS_MANAGER". If the responsibility is new, use
537: -- the fnd_responsibility_tbl.new_resp_key value.
538: -- - to create a new profile option value for the user
539: -- "SYSADMIN", this field will be the fnd_user.user_id, which

Line 537: -- the fnd_responsibility_tbl.new_resp_key value.

533: -- - to create a new profile option value for the
534: -- responsibility "US HRMS Manager", this field will be the
535: -- fnd_responsibility.responsibility_key, which is
536: -- "US_HRMS_MANAGER". If the responsibility is new, use
537: -- the fnd_responsibility_tbl.new_resp_key value.
538: -- - to create a new profile option value for the user
539: -- "SYSADMIN", this field will be the fnd_user.user_id, which
540: -- is 0.
541: --

Line 549: -- fnd_responsibility_tl.application_id, which is 800.

545: -- the application id for the responsibility specified in
546: -- profile_level_value.
547: -- For example, to create a new profile option value for the
548: -- responsibility "US HRMS Manager", this field will be the
549: -- fnd_responsibility_tl.application_id, which is 800.
550: -- If the responsibility is new, use the
551: -- fnd_responsibility_tbl.new_resp_app_id value.
552: --
553: -- Example 1: To add a profile option value for the profile option name

Line 551: -- fnd_responsibility_tbl.new_resp_app_id value.

547: -- For example, to create a new profile option value for the
548: -- responsibility "US HRMS Manager", this field will be the
549: -- fnd_responsibility_tl.application_id, which is 800.
550: -- If the responsibility is new, use the
551: -- fnd_responsibility_tbl.new_resp_app_id value.
552: --
553: -- Example 1: To add a profile option value for the profile option name
554: -- 'PER_BUSINESS_GROUP_ID' at the responsibility level:
555: -- profile_option_name = fnd_profile_options.profile_option_name. In this

Line 608: (resp_key fnd_responsibility.responsibility_key%type

604: -- declarations are for program internal processing. Customers can ignore
605: -- these definitions.
606: ------------------------------------------------------------------------------
607: TYPE func_sec_excl_rec IS RECORD
608: (resp_key fnd_responsibility.responsibility_key%type
609: ,rule_type fnd_resp_functions.rule_type%type
610: ,rule_name fnd_form_functions.function_name%type
611: ,delete_flag varchar2(1));
612: --