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