APPS.BEN_PROCESS_USER_SS_API dependencies on PER_SECURITY_PROFILES

Line 166: ,p_sec_profile_id in per_security_profiles.security_profile_id%type

162: --
163: PROCEDURE create_sec_profile_asg
164: (p_user_id in fnd_user.user_id%type
165: ,p_sec_group_id in fnd_security_groups.security_group_id%type
166: ,p_sec_profile_id in per_security_profiles.security_profile_id%type
167: ,p_resp_id in fnd_responsibility.responsibility_id%type
168: ,p_resp_app_id in per_sec_profile_assignments.responsibility_application_id%type
169: ,p_start_date in per_sec_profile_assignments.start_date%type
170: ,p_end_date in per_sec_profile_assignments.end_date%type default null

Line 184: from per_security_profiles psp

180: --
181: cursor lc_get_sec_profile IS
182: select psp.security_profile_id
183: ,psp.business_group_id
184: from per_security_profiles psp
185: where psp.security_profile_id = p_sec_profile_id;
186: --
187: l_bg_id per_security_profiles.business_group_id%type := null;
188: l_dummy number default null;

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

183: ,psp.business_group_id
184: from per_security_profiles psp
185: where psp.security_profile_id = p_sec_profile_id;
186: --
187: l_bg_id per_security_profiles.business_group_id%type := null;
188: l_dummy number default null;
189: l_sec_prof_asg_id
190: per_sec_profile_assignments.sec_profile_assignment_id%type := null;
191: l_obj_vers_num

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

223: if lc_get_sec_profile%NOTFOUND
224: then
225: close lc_get_sec_profile;
226: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
227: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');
228: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');
229: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));
230: hr_utility.raise_error;
231: else