APPS.HR_USER_ACCT_UTILITY dependencies on PER_SEC_PROFILE_ASSIGNMENTS

Line 105: -- per_sec_profile_assignments as well as to fnd_user_resp_groups.

101: -- For R11i, fnd_user_responsibility is replaced with fnd_user_resp_groups.
102: -- If the profile option 'ENABLE_SECURITY_GROUPS' for the Application is 'Y',
103: -- then you'll need to populate the sec_group_id, sec_profile_id fields at the
104: -- end of this record structure. The system will insert a row into
105: -- per_sec_profile_assignments as well as to fnd_user_resp_groups.
106: --
107: -- If the profile option 'ENABLE_SECURITY_GROUPS' for the Application is 'N',
108: -- that means you remain to use the R11 way of responsibility and security profile
109: -- set up. There is no need to fill in the values of sec_group_id and

Line 272: -- per_sec_profile_assignments.security_group_id, which is

268: -- **** If 'ENABLE_SECURITY_GROUPS' = 'N', ignore these two fields.
269: --
270: -- sec_group_id - optional for 'ENABLE_SECURITY_GROUPS' profile option =
271: -- 'Y'. Length cannot exceed
272: -- per_sec_profile_assignments.security_group_id, which is
273: -- a number data type. It must be a valid value in
274: -- fnd_security_groups.security_group_id.
275: -- Do not fill in this field with a hr_api.g_number
276: -- because each user should use his/her own security group

Line 287: -- per_sec_profile_assignments.security_profile_id, which is

283: -- this field null.
284: --
285: -- sec_profile_id - optional for 'ENABLE_SECURITY_GROUPS' profile option
286: -- = 'Y'. Length cannot exceed
287: -- per_sec_profile_assignments.security_profile_id, which is
288: -- a number data type. It must be a valid value in
289: -- per_security_profiles.security_profile_id.
290: -- Do not fill in this field with a hr_api.g_number
291: -- because each user should use his/her own security profile

Line 328: per_sec_profile_assignments.security_group_id%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
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

Line 329: ,sec_profile_id per_sec_profile_assignments.security_profile_id%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
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;