APPS.HR_USER_ACCT_INTERNAL dependencies on FND_USER_RESP_GROUPS

Line 63: -- |-------------------- < create_fnd_user_resp_groups > ---------------------|

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

Line 66: PROCEDURE create_fnd_user_resp_groups

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

Line 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

Line 71: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type

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

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

Line 73: ,p_end_date in fnd_user_resp_groups.end_date%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
77: );

Line 75: ,p_description in fnd_user_resp_groups.description%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: );
78: --
79: -- ----------------------------------------------------------------------------

Line 240: -- |-------------------- < update_fnd_user_resp_groups > ----------------------|

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

Line 241: -- |This procedure is called to update the fnd_user_resp_groups row when the |

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

Line 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

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

Line 270: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type

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