85: ,p_sec_group_id in fnd_security_groups.security_group_id%type
86: ,p_sec_profile_id in per_security_profiles.security_profile_id%type
87: ,p_resp_key in fnd_responsibility.responsibility_key%type
88: ,p_resp_app_id in
89: per_sec_profile_assignments.responsibility_application_id%type
90: ,p_start_date in per_sec_profile_assignments.start_date%type
91: ,p_end_date in per_sec_profile_assignments.end_date%type
92: default null
93: ,p_business_group_id in per_sec_profile_assignments.business_group_id%type
86: ,p_sec_profile_id in per_security_profiles.security_profile_id%type
87: ,p_resp_key in fnd_responsibility.responsibility_key%type
88: ,p_resp_app_id in
89: per_sec_profile_assignments.responsibility_application_id%type
90: ,p_start_date in per_sec_profile_assignments.start_date%type
91: ,p_end_date in per_sec_profile_assignments.end_date%type
92: default null
93: ,p_business_group_id in per_sec_profile_assignments.business_group_id%type
94: default null
87: ,p_resp_key in fnd_responsibility.responsibility_key%type
88: ,p_resp_app_id in
89: per_sec_profile_assignments.responsibility_application_id%type
90: ,p_start_date in per_sec_profile_assignments.start_date%type
91: ,p_end_date in per_sec_profile_assignments.end_date%type
92: default null
93: ,p_business_group_id in per_sec_profile_assignments.business_group_id%type
94: default null
95: );
89: per_sec_profile_assignments.responsibility_application_id%type
90: ,p_start_date in per_sec_profile_assignments.start_date%type
91: ,p_end_date in per_sec_profile_assignments.end_date%type
92: default null
93: ,p_business_group_id in per_sec_profile_assignments.business_group_id%type
94: default null
95: );
96: --
97: --
254:
255: --
256: -- ----------------------------------------------------------------------------
257: -- |---------------------- < update_sec_profile_asg > ------------------------|
258: -- |This procedure is called to update the per_sec_profile_assignments row |
259: -- |when the profile option 'ENABLE_SECURITY_GROUPS' = 'N'. |
260: -- ----------------------------------------------------------------------------
261: --
262: PROCEDURE update_sec_profile_asg
260: -- ----------------------------------------------------------------------------
261: --
262: PROCEDURE update_sec_profile_asg
263: (p_sec_profile_asg_id in
264: per_sec_profile_assignments.sec_profile_assignment_id%type default null
265: ,p_user_id in fnd_user.user_id%type default null
266: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type
267: default null
268: ,p_resp_app_id in
262: PROCEDURE update_sec_profile_asg
263: (p_sec_profile_asg_id in
264: per_sec_profile_assignments.sec_profile_assignment_id%type default null
265: ,p_user_id in fnd_user.user_id%type default null
266: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type
267: default null
268: ,p_resp_app_id in
269: per_sec_profile_assignments.responsibility_application_id%type default null
270: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
265: ,p_user_id in fnd_user.user_id%type default null
266: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type
267: default null
268: ,p_resp_app_id in
269: per_sec_profile_assignments.responsibility_application_id%type default null
270: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
271: default null
272: ,p_start_date in per_sec_profile_assignments.start_date%type
273: default null
268: ,p_resp_app_id in
269: per_sec_profile_assignments.responsibility_application_id%type default null
270: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
271: default null
272: ,p_start_date in per_sec_profile_assignments.start_date%type
273: default null
274: ,p_end_date in per_sec_profile_assignments.end_date%type
275: default null
276: ,p_object_version_number in
270: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
271: default null
272: ,p_start_date in per_sec_profile_assignments.start_date%type
273: default null
274: ,p_end_date in per_sec_profile_assignments.end_date%type
275: default null
276: ,p_object_version_number in
277: per_sec_profile_assignments.object_version_number%type default null
278: );
273: default null
274: ,p_end_date in per_sec_profile_assignments.end_date%type
275: default null
276: ,p_object_version_number in
277: per_sec_profile_assignments.object_version_number%type default null
278: );
279:
280: --
281: --