DBA Data[Home] [Help]

APPS.HR_USER_ACCT_INTERNAL dependencies on PER_SEC_PROFILE_ASSIGNMENTS

Line 89: per_sec_profile_assignments.responsibility_application_id%type

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

Line 90: ,p_start_date in per_sec_profile_assignments.start_date%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

Line 91: ,p_end_date in per_sec_profile_assignments.end_date%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
95: );

Line 93: ,p_business_group_id in per_sec_profile_assignments.business_group_id%type

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

Line 258: -- |This procedure is called to update the per_sec_profile_assignments row |

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

Line 264: per_sec_profile_assignments.sec_profile_assignment_id%type default null

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

Line 266: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type

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

Line 269: per_sec_profile_assignments.responsibility_application_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
271: default null
272: ,p_start_date in per_sec_profile_assignments.start_date%type
273: default null

Line 272: ,p_start_date in per_sec_profile_assignments.start_date%type

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

Line 274: ,p_end_date in per_sec_profile_assignments.end_date%type

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: );

Line 277: per_sec_profile_assignments.object_version_number%type default null

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