APPS.BEN_PROCESS_USER_SS_API dependencies on FND_SECURITY_GROUPS

Line 165: ,p_sec_group_id in fnd_security_groups.security_group_id%type

161: -- ----------------------------------------------------------------------------
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

Line 178: from fnd_security_groups fsg

174: --
175: --
176: cursor lc_get_sec_group_id IS
177: select fsg.security_group_id
178: from fnd_security_groups fsg
179: where fsg.security_group_id = p_sec_group_id;
180: --
181: cursor lc_get_sec_profile IS
182: select psp.security_profile_id

Line 209: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');

205: if lc_get_sec_group_id%NOTFOUND
206: then
207: close lc_get_sec_group_id;
208: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
209: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
210: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');
211: fnd_message.set_token('VALUE', to_char(p_sec_group_id));
212: hr_utility.raise_error;
213: else

Line 430: l_sec_group_id fnd_security_groups.security_group_id%type := null;

426: l_respons_appl_id number ;
427: l_employee_id number default null;
428: prflvalue varchar2(2000);
429: l_enable_sec_groups varchar2(2000) default null;
430: l_sec_group_id fnd_security_groups.security_group_id%type := null;
431: l_out_func_sec_excl_tbl hr_user_acct_utility.func_sec_excl_tbl;
432:
433: l_proc varchar2(72) := g_package||'create_user_details';
434:

Line 438: from fnd_security_groups fsg

434:
435: cursor lc_get_sec_group_id
436: is
437: select fsg.security_group_id
438: from fnd_security_groups fsg
439: where fsg.security_group_key = decode(p_business_group_id,0, 'STANDARD',to_char(p_business_group_id));
440: --
441:
442: begin

Line 638: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');

634: if lc_get_sec_group_id%NOTFOUND then
635:
636: close lc_get_sec_group_id;
637: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
638: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
639: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
640: fnd_message.set_token('VALUE', to_char(p_business_group_id));
641: hr_utility.raise_error;
642: else