1 PACKAGE IGP_AD_USERID_PKG AS
2 /* $Header: IGSPADAS.pls 120.0 2005/06/01 18:34:46 appldev noship $ */
3 /*
4 || Created By : nsidana
5 || Created On : 1/28/2004
6 || Purpose : Main package specs for Portfolio user creation and deactivation.
7 || Known limitations, enhancements or remarks :
8 || Change History :
9 || Who When What
10 || (reverse chronological order - newest change first)
11 */
12
13 PROCEDURE CHECK_EXISTING_ACCOUNT(itemtype IN VARCHAR2,
14 itemkey IN VARCHAR2,
15 actid IN NUMBER,
16 funcmode IN VARCHAR2,
17 resultout OUT NOCOPY VARCHAR2 );
18
19 PROCEDURE RECORD_DATA(itemtype IN VARCHAR2,
20 itemkey IN VARCHAR2,
21 actid IN NUMBER,
22 funcmode IN VARCHAR2,
23 resultout OUT NOCOPY VARCHAR2 );
24
25 PROCEDURE CHECK_ACTION(itemtype IN VARCHAR2,
26 itemkey IN VARCHAR2,
27 actid IN NUMBER,
28 funcmode IN VARCHAR2,
29 resultout OUT NOCOPY VARCHAR2 );
30
31 PROCEDURE VALIDATE_USER_NAME(itemtype IN VARCHAR2,
32 itemkey IN VARCHAR2,
33 actid IN NUMBER,
34 funcmode IN VARCHAR2,
35 resultout OUT NOCOPY VARCHAR2 );
36
37 PROCEDURE CREATE_FND_USER(itemtype IN VARCHAR2,
38 itemkey IN VARCHAR2,
39 actid IN NUMBER,
40 funcmode IN VARCHAR2,
41 resultout OUT NOCOPY VARCHAR2 );
42
43 PROCEDURE CREATE_PORT_ACCOUNT(itemtype IN VARCHAR2,
44 itemkey IN VARCHAR2,
45 actid IN NUMBER,
46 funcmode IN VARCHAR2,
47 resultout OUT NOCOPY VARCHAR2 );
48
49 PROCEDURE SET_DATA(itemtype IN VARCHAR2,
50 itemkey IN VARCHAR2,
51 actid IN NUMBER,
52 funcmode IN VARCHAR2,
53 resultout OUT NOCOPY VARCHAR2 );
54
55 PROCEDURE CLEANUP(itemtype IN VARCHAR2,
56 itemkey IN VARCHAR2,
57 actid IN NUMBER,
58 funcmode IN VARCHAR2,
59 resultout OUT NOCOPY VARCHAR2 );
60
61 FUNCTION GENERATE_PASSWORD ( p_party_id NUMBER) RETURN VARCHAR2;
62
63 END igp_ad_userid_pkg;
|
|
|