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.PER_RI_CONFIG_UTILITIES dependencies on PER_SEC_PROFILE_ASSIGNMENTS

Line 2204: l_sec_profile_assignment_id per_sec_profile_assignments.sec_profile_assignment_id%type;

2200: select security_profile_id
2201: from per_security_profiles
2202: where security_profile_name = cp_security_profile_name;
2203:
2204: l_sec_profile_assignment_id per_sec_profile_assignments.sec_profile_assignment_id%type;
2205: l_user_id per_sec_profile_assignments.user_id%type;
2206: l_security_group_id per_sec_profile_assignments.security_group_id%type;
2207: l_business_group_id per_sec_profile_assignments.business_group_id%type;
2208: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;

Line 2205: l_user_id per_sec_profile_assignments.user_id%type;

2201: from per_security_profiles
2202: where security_profile_name = cp_security_profile_name;
2203:
2204: l_sec_profile_assignment_id per_sec_profile_assignments.sec_profile_assignment_id%type;
2205: l_user_id per_sec_profile_assignments.user_id%type;
2206: l_security_group_id per_sec_profile_assignments.security_group_id%type;
2207: l_business_group_id per_sec_profile_assignments.business_group_id%type;
2208: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
2209: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;

Line 2206: l_security_group_id per_sec_profile_assignments.security_group_id%type;

2202: where security_profile_name = cp_security_profile_name;
2203:
2204: l_sec_profile_assignment_id per_sec_profile_assignments.sec_profile_assignment_id%type;
2205: l_user_id per_sec_profile_assignments.user_id%type;
2206: l_security_group_id per_sec_profile_assignments.security_group_id%type;
2207: l_business_group_id per_sec_profile_assignments.business_group_id%type;
2208: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
2209: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
2210: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;

Line 2207: l_business_group_id per_sec_profile_assignments.business_group_id%type;

2203:
2204: l_sec_profile_assignment_id per_sec_profile_assignments.sec_profile_assignment_id%type;
2205: l_user_id per_sec_profile_assignments.user_id%type;
2206: l_security_group_id per_sec_profile_assignments.security_group_id%type;
2207: l_business_group_id per_sec_profile_assignments.business_group_id%type;
2208: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
2209: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
2210: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;
2211:

Line 2208: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;

2204: l_sec_profile_assignment_id per_sec_profile_assignments.sec_profile_assignment_id%type;
2205: l_user_id per_sec_profile_assignments.user_id%type;
2206: l_security_group_id per_sec_profile_assignments.security_group_id%type;
2207: l_business_group_id per_sec_profile_assignments.business_group_id%type;
2208: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
2209: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
2210: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;
2211:
2212: l_security_profile_name per_business_groups.name%type;

Line 2209: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;

2205: l_user_id per_sec_profile_assignments.user_id%type;
2206: l_security_group_id per_sec_profile_assignments.security_group_id%type;
2207: l_business_group_id per_sec_profile_assignments.business_group_id%type;
2208: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
2209: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
2210: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;
2211:
2212: l_security_profile_name per_business_groups.name%type;
2213: l_responsibility_key fnd_responsibility_vl.responsibility_name%type;

Line 2210: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;

2206: l_security_group_id per_sec_profile_assignments.security_group_id%type;
2207: l_business_group_id per_sec_profile_assignments.business_group_id%type;
2208: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
2209: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
2210: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;
2211:
2212: l_security_profile_name per_business_groups.name%type;
2213: l_responsibility_key fnd_responsibility_vl.responsibility_name%type;
2214: l_ovn number(9);

Line 3394: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;

3390: l_user_name fnd_user.user_name%type;
3391: l_security_group_id fnd_security_groups.security_group_id%type;
3392: l_business_group_id per_business_groups.business_group_id%type;
3393: l_business_group_name per_business_groups.name%type;
3394: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
3395: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
3396: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;
3397:
3398: l_security_group_name fnd_security_groups_vl.security_group_name%type;

Line 3395: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;

3391: l_security_group_id fnd_security_groups.security_group_id%type;
3392: l_business_group_id per_business_groups.business_group_id%type;
3393: l_business_group_name per_business_groups.name%type;
3394: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
3395: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
3396: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;
3397:
3398: l_security_group_name fnd_security_groups_vl.security_group_name%type;
3399: l_security_group_key fnd_security_groups_vl.security_group_key%type;

Line 3396: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;

3392: l_business_group_id per_business_groups.business_group_id%type;
3393: l_business_group_name per_business_groups.name%type;
3394: l_security_profile_id per_sec_profile_assignments.security_profile_id%type;
3395: l_responsibility_id per_sec_profile_assignments.responsibility_id%type;
3396: l_responsibility_application_i per_sec_profile_assignments.responsibility_application_id%type;
3397:
3398: l_security_group_name fnd_security_groups_vl.security_group_name%type;
3399: l_security_group_key fnd_security_groups_vl.security_group_key%type;
3400: l_application_short_name fnd_application.application_short_name%type;