DBA Data[Home] [Help]

APPS.HR_USER_ACCT_INTERNAL dependencies on FND_USER

Line 8: -- |-------------------------- < create_fnd_user > ---------------------------|

4: -- Public Glboal Variables
5: --
6: --
7: -- ----------------------------------------------------------------------------
8: -- |-------------------------- < create_fnd_user > ---------------------------|
9: -- | NOTE: The fnd api fup.create_user that this api will be calling |
10: -- | does not have code to handle AK securing attributes. Thus, this |
11: -- | api will not do any inserts into ak_web_user_sec_attr_values table.|
12: -- | So, this api does not do everything that the FND Create User form |

Line 16: PROCEDURE create_fnd_user

12: -- | So, this api does not do everything that the FND Create User form |
13: -- | does. |
14: -- ----------------------------------------------------------------------------
15: --
16: PROCEDURE create_fnd_user
17: (p_hire_date in date default null
18: ,p_user_name in varchar2
19: ,p_password in out nocopy varchar2
20: ,p_user_start_date in date default null

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 67: (p_user_id in fnd_user.user_id%type

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
71: ,p_sec_group_id in fnd_user_resp_groups.security_group_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 84: (p_user_id in fnd_user.user_id%type

80: -- |---------------------- < create_sec_profile_asg > ------------------------|
81: -- ----------------------------------------------------------------------------
82: --
83: PROCEDURE create_sec_profile_asg
84: (p_user_id in fnd_user.user_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

Line 220: -- |-------------------------- < update_fnd_user > ---------------------------|

216: ,p_rule_name in varchar2
217: ,p_delete_flag in varchar2 default 'N');
218: --
219: -- ----------------------------------------------------------------------------
220: -- |-------------------------- < update_fnd_user > ---------------------------|
221: -- ----------------------------------------------------------------------------
222: --
223: PROCEDURE update_fnd_user
224: (p_user_id in number

Line 223: PROCEDURE update_fnd_user

219: -- ----------------------------------------------------------------------------
220: -- |-------------------------- < update_fnd_user > ---------------------------|
221: -- ----------------------------------------------------------------------------
222: --
223: PROCEDURE update_fnd_user
224: (p_user_id in number
225: ,p_old_password in varchar2 default hr_api.g_varchar2
226: ,p_new_password in varchar2 default hr_api.g_varchar2
227: ,p_end_date in date default hr_api.g_date

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 265: ,p_user_id in fnd_user.user_id%type default null

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
269: per_sec_profile_assignments.responsibility_application_id%type default null

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