APPS.BEN_PROCESS_USER_SS_API dependencies on FND_RESPONSIBILITY

Line 167: ,p_resp_id in fnd_responsibility.responsibility_id%type

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
171: ,p_business_group_id in per_sec_profile_assignments.business_group_id%type default null

Line 276: (p_resp_id in fnd_responsibility.responsibility_id%type

272: -- ---------------------------------------------------------------------------
273: -- ---------------------- < add_func_sec_exclusion_rules> -------------------------
274: -- ---------------------------------------------------------------------------
275: procedure add_func_sec_exclusion_rules
276: (p_resp_id in fnd_responsibility.responsibility_id%type
277: ,p_resp_app_id in fnd_responsibility.application_id%type)
278: is
279: --
280: cursor lc_get_resp_func (p_resp_id in

Line 277: ,p_resp_app_id in fnd_responsibility.application_id%type)

273: -- ---------------------- < add_func_sec_exclusion_rules> -------------------------
274: -- ---------------------------------------------------------------------------
275: procedure add_func_sec_exclusion_rules
276: (p_resp_id in fnd_responsibility.responsibility_id%type
277: ,p_resp_app_id in fnd_responsibility.application_id%type)
278: is
279: --
280: cursor lc_get_resp_func (p_resp_id in
281: fnd_responsibility.responsibility_id%type

Line 281: fnd_responsibility.responsibility_id%type

277: ,p_resp_app_id in fnd_responsibility.application_id%type)
278: is
279: --
280: cursor lc_get_resp_func (p_resp_id in
281: fnd_responsibility.responsibility_id%type
282: ,p_app_id in
283: fnd_responsibility.application_id%type)
284: is
285: select frf.action_id, frf.rule_type

Line 283: fnd_responsibility.application_id%type)

279: --
280: cursor lc_get_resp_func (p_resp_id in
281: fnd_responsibility.responsibility_id%type
282: ,p_app_id in
283: fnd_responsibility.application_id%type)
284: is
285: select frf.action_id, frf.rule_type
286: from fnd_resp_functions frf
287: where frf.application_id = p_app_id

Line 304: fnd_responsibility.responsibility_id%type

300: from fnd_menus fm
301: where fm.menu_id = p_menu_id;
302: --
303: cursor lc_get_resp_id (p_resp_id in
304: fnd_responsibility.responsibility_id%type
305: ,p_app_id in
306: fnd_responsibility.application_id%type)
307: is
308: select fr.responsibility_key

Line 306: fnd_responsibility.application_id%type)

302: --
303: cursor lc_get_resp_id (p_resp_id in
304: fnd_responsibility.responsibility_id%type
305: ,p_app_id in
306: fnd_responsibility.application_id%type)
307: is
308: select fr.responsibility_key
309: FROM fnd_responsibility fr
310: where fr.application_id = p_app_id

Line 309: FROM fnd_responsibility fr

305: ,p_app_id in
306: fnd_responsibility.application_id%type)
307: is
308: select fr.responsibility_key
309: FROM fnd_responsibility fr
310: where fr.application_id = p_app_id
311: and fr.responsibility_id = p_resp_id;
312: --
313: l_proc varchar2(72) := g_package ||

Line 316: l_resp_key fnd_responsibility.responsibility_key%type;

312: --
313: l_proc varchar2(72) := g_package ||
314: 'add_func_sec_exclusion_rules';
315: l_rule_name fnd_form_functions.function_name%type;
316: l_resp_key fnd_responsibility.responsibility_key%type;
317: l_func_sec_excl_err exception;
318: --
319: begin
320: hr_utility.set_location('Entering:'|| l_proc, 11);