1 package FND_USER_PKG_WRP AUTHID CURRENT_USER as
2 /* $Header: AFSCUSWS.pls 120.0.12000000.3 2007/06/01 19:04:37 fskinner ship $ */
3
4 -- This routine is for AOL INTERNAL USE ONLY !!!!!!!
5 --
6 -- user_synch
7 -- Wrapper for fnd_user_pkg.user_synch()
8 -- IN
9 -- p_user_name
10 --
11 procedure user_synch (p_user_name in varchar2);
12
13 -- This routine is for AOL INTERNAL USE ONLY !!!!!!!
14 --
15 -- derive_person_party_id
16 -- Wrapper for fnd_user_pkg.derive_person_party_id()
17 -- IN
18 -- p_user_name
19 -- p_customer_id
20 -- p_employee_id
21 -- p_log_exception
22 --
23 function derive_person_party_id (p_user_name in varchar2,
24 p_customer_id in number,
25 p_employee_id in number,
26 p_log_exception in varchar2 default 'Y')
27 return number;
28
29 -- This routine is for AOL INTERNAL USE ONLY !!!!!!!
30 --
31 -- set_old_user_name
32 -- Wrapper for fnd_user_pkg.set_old_user_name()
33 -- IN
34 -- p_old_user_name
35 --
36 function set_old_user_name (p_old_user_name in varchar2) return number;
37
38 -- This routine is for AOL INTERNAL USE ONLY !!!!!!!
39 --
40 -- validate_user_name
41 -- Wrapper for fnd_user_pkg.validate_user_name()
42 -- IN
43 -- p_user_name
44 --
45 procedure validate_user_name (p_user_name in varchar2);
46
47 -- This routine is for AOL INTERNAL USE ONLY !!!!!!!
48 --
49 -- isPasswordChangable
50 -- Wrapper for fnd_user_pkg.isPasswordChangable()
51 -- IN
52 -- p_user_name
53 -- OUT
54 -- TRUE/FALSE
55 --
56 function isPasswordChangeable (p_user_name in varchar2) return boolean;
57
58 -- This routine is for AOL INTERNAL USE ONLY !!!!!!!
59 --
60 -- ldap_wrapper_create_user
61 -- Wrapper for fnd_user_pkg.ldap_wrapper_create_user()
62 procedure ldap_wrapper_create_user (p_user_name in varchar2,
63 p_unencrypted_password in varchar2,
64 p_start_date in date,
65 p_end_date in date,
66 p_description in varchar2,
67 p_email_address in varchar2,
68 p_fax in varchar2);
69
70 -- This routine is for AOL INTERNAL USE ONLY !!!!!!!
71 --
72 -- ldap_wrapper_update_user
73 -- Wrapper for fnd_user_pkg.ldap_wrapper_update_user()
74 --
75 procedure ldap_wrapper_update_user (p_user_name in varchar2,
76 p_unencrypted_password in varchar2,
77 p_start_date in date,
78 p_end_date in date,
79 p_description in varchar2,
80 p_email_address in varchar2,
81 p_fax in varchar2,
82 p_out_pwd in out nocopy varchar2);
83
84
85 -- This routine is for AOL INTERNAL USE ONLY !!!!!!!
86 --
87 -- ldap_wrapper_change_user_name
88 -- Wrapper for fnd_user_pkg.ldap_wrapper_change_user_name()
89 -- IN
90 -- p_old_user_name
91 -- p_new_user_name
92 --
93 procedure ldap_wrapper_change_user_name (p_old_user_name in varchar2,
94 p_new_user_name in varchar2);
95
96 -- This routine is for AOL INTERNAL USE ONLY !!!!!!!
97 --
98 -- forms_validate_password
99 -- Wrapper for fnd_web_sec.validate_password()
100 -- IN
101 -- p_username
102 -- p_new_password
103 --
104 function forms_validate_password (p_username in varchar2,
105 p_new_password in varchar2)
106 return varchar2;
107
108 -- This routine is for AOL INTERNAL USE ONLY !!!!!!!
109 --
110 -- forms_change_user_pwd
111 -- This function figures out what should be stored in the
112 -- fnd_user encrypted_user_password and encrypted_foundation_password
113 -- columns and passes this back to forms so forms can do the commit.
114 -- IN
115 -- p_userid - user_id
116 -- p_username - user name
117 -- p_new_password - new user password
118 -- OUT
119 -- p_enc_user_pwd - encrypted user password/hash
120 -- p_enc_fnd_pwd - encrypted fnd password or password metadata
121 -- RETURNS
122 -- 'Y' or 'N' for success or failure
123 -- On failure message is on message dictionary stack.
124 --
125 function forms_change_user_pwd(p_userid in NUMBER,
126 p_username in VARCHAR2,
127 p_new_password in VARCHAR2,
128 p_enc_user_pwd out nocopy VARCHAR2,
129 p_enc_fnd_pwd out nocopy VARCHAR2)
130 return VARCHAR2;
131
132
133 END FND_USER_PKG_WRP;