APPS.HR_USER_ACCT_INTERNAL dependencies on PER_SECURITY_PROFILES

Line 850: ,p_sec_profile_id in per_security_profiles.security_profile_id%type

846: --
847: PROCEDURE create_sec_profile_asg
848: (p_user_id in fnd_user.user_id%type
849: ,p_sec_group_id in fnd_security_groups.security_group_id%type
850: ,p_sec_profile_id in per_security_profiles.security_profile_id%type
851: ,p_resp_key in fnd_responsibility.responsibility_key%type
852: ,p_resp_app_id in
853: per_sec_profile_assignments.responsibility_application_id%type
854: ,p_start_date in per_sec_profile_assignments.start_date%type

Line 876: FROM per_security_profiles

872: --
873: CURSOR lc_get_sec_profile IS
874: SELECT security_profile_id
875: ,business_group_id
876: FROM per_security_profiles
877: WHERE security_profile_id = p_sec_profile_id;
878: --
879: CURSOR lc_get_resp_id IS
880: SELECT responsibility_id

Line 885: l_bg_id per_security_profiles.business_group_id%type := null;

881: FROM fnd_responsibility
882: WHERE responsibility_key = p_resp_key
883: AND application_id = p_resp_app_id;
884:
885: l_bg_id per_security_profiles.business_group_id%type := null;
886: l_resp_id fnd_responsibility.responsibility_id%type := null;
887: l_dummy number default null;
888: l_sec_prof_asg_id
889: per_sec_profile_assignments.sec_profile_assignment_id%type := null;

Line 963: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');

959: IF lc_get_sec_profile%NOTFOUND
960: THEN
961: CLOSE lc_get_sec_profile;
962: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
963: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');
964: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');
965: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));
966: hr_utility.raise_error;
967: ELSE

Line 1234: -- PER_SECURITY_PROFILE_ID PER_SECURITY_PROFILES and

1230: -- PER_OAB_NEW_BENEFITS_MODEL fnd_lookups where lookup_type ='YES_NO'
1231: --
1232: -- PER_QUERY_ONLY_MODE fnd_lookups where lookup_type ='YES_NO'
1233: --
1234: -- PER_SECURITY_PROFILE_ID PER_SECURITY_PROFILES and
1235: -- HR_ALL_ORGANIZATION_UNITS
1236: --
1237: -- VIEW_UNPUBLISHED_360_SELF_APPR FND_COMMON_LOOKUPS where lookup_type =
1238: -- 'YES_NO'

Line 1426: FROM per_security_profiles s

1422: SELECT s.security_profile_name
1423: ,s.security_profile_id
1424: ,s.business_group_id
1425: ,o.name
1426: FROM per_security_profiles s
1427: ,hr_all_organization_units o
1428: WHERE o.business_group_id = s.business_group_id
1429: AND o.organization_id = o.business_group_id
1430: ORDER BY s.security_profile_id;