1 PACKAGE UMX_LOGIN_HELP_PVT AUTHID CURRENT_USER AS
2 /* $Header: UMXLHLPS.pls 120.4 2006/05/26 18:39:45 pseo noship $ */
3
4 /******************************************************************************
5 * UserNameList
6 *
7 ******************************************************************************/
8 type UsersWEmailList is Record
9 (
10 --email fnd_user.email_address%type,
11 --role_name WF_LOCAL_ROLES.name%type,
12 user_name FND_USER.USER_NAME%TYPE,
13 notification_preference WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%type
14 );
15
16 type UsersWEmail is table of UsersWEmailList
17 index by binary_integer;
18
19
20 procedure ForgottenPwd(p_username in fnd_user.user_name%type,
21 x_return_status out NOCOPY varchar2,
22 x_message_name out NOCOPY varchar2) ;
23
24 procedure ForgottenUname
25 (p_email in fnd_user.email_address%type,
26 x_return_status out NOCOPY varchar2,
27 x_message_name out NOCOPY varchar2);
28
29 Procedure CreateRole(itemtype in varchar2,
30 itemkey in varchar2,
31 actid in number,
32 funcmode in varchar2,
33 resultout in out NOCOPY varchar2);
34
35
36 Procedure GenAuthKey(itemtype in varchar2,
37 itemkey in varchar2,
38 actid in number,
39 funcmode in varchar2,
40 resultout in out NOCOPY varchar2);
41
42 Procedure GenUrl2ResetPwdPg(itemtype in varchar2,
43 itemkey in varchar2,
44 actid in number,
45 funcmode in varchar2,
46 resultout in out NOCOPY varchar2);
47 Procedure GenUrl2LoginPg(itemtype in varchar2,
48 itemkey in varchar2,
49 actid in number,
50 funcmode in varchar2,
51 resultout in out NOCOPY varchar2);
52 Procedure DisableAccount(itemtype in varchar2,
53 itemkey in varchar2,
54 actid in number,
55 funcmode in varchar2,
56 resultout in out NOCOPY varchar2);
57 procedure CompleteActivity( p_itemKey in varchar2,
58 x_return_status out NOCOPY varchar2,
59 x_message_name out NOCOPY varchar2);
60 procedure ResetPassword( p_username in fnd_user.user_name%type,
61 --p_usernameurl in fnd_user.user_name%type,
62 p_password in varchar2 default null,
63 p_itemkey in varchar2,
64 p_authkey in varchar2,
65 x_no_attempts out NOCOPY varchar2,
66 x_return_status out NOCOPY varchar2,
67 x_message_name out NOCOPY varchar2,
68 x_message_data out NOCOPY varchar2);
69
70
71 PROCEDURE ValidateResetPwdReq (p_username in fnd_user.user_name%type,
72 p_authkey in varchar2,
73 p_itemkey in varchar2,
74 x_no_attempts out NOCOPY varchar2,
75 x_return_status out NOCOPY varchar2,
76 x_message_name out NOCOPY varchar2);
77 PROCEDURE ValidateAuthKey( p_authkey in varchar2,
78 p_itemkey in varchar2,
79 x_no_attempts out NOCOPY varchar2,
80 x_return_status out NOCOPY varchar2,
81 x_message_name out NOCOPY varchar2);
82
83 end UMX_LOGIN_HELP_PVT;