1 PACKAGE UMX_PASSWORD_PVT AS
2 /* $Header: UMXVUPWS.pls 120.2 2006/07/21 00:01:34 kching noship $ */
3
4 -- Procedure : validate_password
5 -- Type : Private
6 -- Pre_reqs :
7 -- Description: This API will validate the user's password.
8 -- Parameters
9 -- input parameters :
10 -- p_username - username of the password's owner
11 -- p_password - password to validate
12 -- output parameters:
13 -- x_return_status - Returns FND_API.G_RET_STS_SUCCESS if success
14 -- - Returns FND_API.G_RET_STS_ERROR if failed
15 -- x_message_data - Reason why it is failed.
16 -- Errors :
17 -- Other Comments :
18 Procedure validate_password (p_username in fnd_user.user_name%type,
19 p_password in varchar2,
20 x_return_status out NOCOPY varchar2,
21 x_message_data out NOCOPY varchar2);
22
23 -- *******************************************
24 -- Procedure ResetPwd
25 -- *******************************************
26 procedure ResetPwd (p_username in fnd_user.user_name%type,
27 p_password in varchar2 default null,
28 p_user_appr_msg_name in varchar2 default null,
29 p_pwd_reset_msg_name in varchar2 default null,
30 p_check_identity in varchar2 default 'Y',
31 x_return_status out NOCOPY varchar2,
32 x_message_data out NOCOPY varchar2) ;
33
34 Procedure UpdatePassword_WF(itemtype in varchar2,
35 itemkey in varchar2,
36 actid in number,
37 funcmode in varchar2,
38 resultout in out NOCOPY varchar2);
39
40 Procedure CreateRole(itemtype in varchar2,
41 itemkey in varchar2,
42 actid in number,
43 funcmode in varchar2,
44 resultout in out NOCOPY varchar2);
45
46 Procedure SetPassword_WF(itemtype in varchar2,
47 itemkey in varchar2,
48 actid in number,
49 funcmode in varchar2,
50 resultout in out NOCOPY varchar2);
51
52 procedure ForgotPwd(p_username in fnd_user.user_name%type,
53 p_user_appr_msg_name in varchar2 default null,
54 p_pwd_reset_msg_name in varchar2 default null,
55 p_check_identity in varchar2 default 'Y',
56 x_return_status out NOCOPY varchar2,
57 x_message_name out NOCOPY varchar2,
58 x_message_data out NOCOPY varchar2) ;
59
60 -------------------------------------------------------------------
61 -- Name: clean_up_ad_hoc_role
62 -- Description: This API set the status to inactive and expiration
63 -- date to sysdate of the ad hoc role created by the password
64 -- workflow.
65 -------------------------------------------------------------------
66 Procedure clean_up_ad_hoc_role (itemtype in varchar2,
67 itemkey in varchar2,
68 actid in number,
69 funcmode in varchar2,
70 resultout in out NOCOPY varchar2);
71
72 end UMX_PASSWORD_PVT;