1 PACKAGE UMX_PASSWORD_PVT AUTHID CURRENT_USER AS
2 /* $Header: UMXVUPWS.pls 120.2.12020000.2 2012/07/18 14:38:04 avelu ship $ */
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 p_htmlagent in varchar2 default null,
32 x_return_status out NOCOPY varchar2,
33 x_message_data out NOCOPY varchar2) ;
34
35 Procedure UpdatePassword_WF(itemtype in varchar2,
36 itemkey in varchar2,
37 actid in number,
38 funcmode in varchar2,
39 resultout in out NOCOPY varchar2);
40
41 Procedure CreateRole(itemtype in varchar2,
42 itemkey in varchar2,
43 actid in number,
44 funcmode in varchar2,
45 resultout in out NOCOPY varchar2);
46
47 Procedure SetPassword_WF(itemtype in varchar2,
48 itemkey in varchar2,
49 actid in number,
50 funcmode in varchar2,
51 resultout in out NOCOPY varchar2);
52
53 procedure ForgotPwd(p_username in fnd_user.user_name%type,
54 p_user_appr_msg_name in varchar2 default null,
55 p_pwd_reset_msg_name in varchar2 default null,
56 p_check_identity in varchar2 default 'Y',
57 p_htmlagent in varchar2 default null,
58 x_return_status out NOCOPY varchar2,
59 x_message_name out NOCOPY varchar2,
60 x_message_data out NOCOPY varchar2) ;
61
62 -------------------------------------------------------------------
63 -- Name: clean_up_ad_hoc_role
64 -- Description: This API set the status to inactive and expiration
65 -- date to sysdate of the ad hoc role created by the password
66 -- workflow.
67 -------------------------------------------------------------------
68 Procedure clean_up_ad_hoc_role (itemtype in varchar2,
69 itemkey in varchar2,
70 actid in number,
71 funcmode in varchar2,
72 resultout in out NOCOPY varchar2);
73
74 end UMX_PASSWORD_PVT;