59: );
60: --
61: --
62: -- ----------------------------------------------------------------------------
63: -- |-------------------- < create_fnd_user_resp_groups > ---------------------|
64: -- ----------------------------------------------------------------------------
65: --
66: PROCEDURE create_fnd_user_resp_groups
67: (p_user_id in fnd_user.user_id%type
62: -- ----------------------------------------------------------------------------
63: -- |-------------------- < create_fnd_user_resp_groups > ---------------------|
64: -- ----------------------------------------------------------------------------
65: --
66: PROCEDURE create_fnd_user_resp_groups
67: (p_user_id in fnd_user.user_id%type
68: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
69: ,p_application_id in
70: fnd_user_resp_groups.responsibility_application_id%type
66: PROCEDURE create_fnd_user_resp_groups
67: (p_user_id in fnd_user.user_id%type
68: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
69: ,p_application_id in
70: fnd_user_resp_groups.responsibility_application_id%type
71: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
72: ,p_start_date in fnd_user_resp_groups.start_date%type
73: ,p_end_date in fnd_user_resp_groups.end_date%type
74: default null
67: (p_user_id in fnd_user.user_id%type
68: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
69: ,p_application_id in
70: fnd_user_resp_groups.responsibility_application_id%type
71: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
72: ,p_start_date in fnd_user_resp_groups.start_date%type
73: ,p_end_date in fnd_user_resp_groups.end_date%type
74: default null
75: ,p_description in fnd_user_resp_groups.description%type
68: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
69: ,p_application_id in
70: fnd_user_resp_groups.responsibility_application_id%type
71: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
72: ,p_start_date in fnd_user_resp_groups.start_date%type
73: ,p_end_date in fnd_user_resp_groups.end_date%type
74: default null
75: ,p_description in fnd_user_resp_groups.description%type
76: default null
69: ,p_application_id in
70: fnd_user_resp_groups.responsibility_application_id%type
71: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
72: ,p_start_date in fnd_user_resp_groups.start_date%type
73: ,p_end_date in fnd_user_resp_groups.end_date%type
74: default null
75: ,p_description in fnd_user_resp_groups.description%type
76: default null
77: );
71: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
72: ,p_start_date in fnd_user_resp_groups.start_date%type
73: ,p_end_date in fnd_user_resp_groups.end_date%type
74: default null
75: ,p_description in fnd_user_resp_groups.description%type
76: default null
77: );
78: --
79: -- ----------------------------------------------------------------------------
236: );
237:
238: --
239: -- ----------------------------------------------------------------------------
240: -- |-------------------- < update_fnd_user_resp_groups > ----------------------|
241: -- |This procedure is called to update the fnd_user_resp_groups row when the |
242: -- |profile option 'ENABLE_SECURITY_GROUPS' = 'N'. |
243: -- ----------------------------------------------------------------------------
244: --
237:
238: --
239: -- ----------------------------------------------------------------------------
240: -- |-------------------- < update_fnd_user_resp_groups > ----------------------|
241: -- |This procedure is called to update the fnd_user_resp_groups row when the |
242: -- |profile option 'ENABLE_SECURITY_GROUPS' = 'N'. |
243: -- ----------------------------------------------------------------------------
244: --
245: PROCEDURE update_fnd_user_resp_groups
241: -- |This procedure is called to update the fnd_user_resp_groups row when the |
242: -- |profile option 'ENABLE_SECURITY_GROUPS' = 'N'. |
243: -- ----------------------------------------------------------------------------
244: --
245: PROCEDURE update_fnd_user_resp_groups
246: (p_user_id in number
247: ,p_responsibility_id in number
248: ,p_resp_application_id in number
249: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
245: PROCEDURE update_fnd_user_resp_groups
246: (p_user_id in number
247: ,p_responsibility_id in number
248: ,p_resp_application_id in number
249: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
250: ,p_start_date in date default hr_api.g_date
251: ,p_end_date in date default hr_api.g_date
252: ,p_description in varchar2 default hr_api.g_varchar2
253: );
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
274: ,p_end_date in per_sec_profile_assignments.end_date%type