[Home] [Help]
PACKAGE: APPS.IGS_PE_USERID_PKG
Source
1 PACKAGE IGS_PE_USERID_PKG AS
2 /* $Header: IGSPE11S.pls 120.4 2006/06/28 12:35:42 gmaheswa ship $ */
3
4
5 FUNCTION Generate_Username(
6 p_subscription_guid IN raw,
7 p_event IN OUT NOCOPY wf_event_t
8 ) return varchar2;
9
10 PROCEDURE Create_Batch_Users (errbuf OUT NOCOPY VARCHAR2,
11 retcode OUT NOCOPY NUMBER,
12 p_group_id IN NUMBER,
13 p_org_id IN VARCHAR2 DEFAULT NULL
14 );
15
16
17
18 PROCEDURE Check_Setup
19 (
20 itemtype IN VARCHAR2,
21 itemkey IN VARCHAR2,
22 actid IN NUMBER,
23 funcmode IN VARCHAR2,
24 resultout OUT NOCOPY VARCHAR2
25 );
26
27 FUNCTION generate_party_number (
28 P_SUBSCRIPTION_GUID IN raw,
29 P_EVENT IN OUT NOCOPY wf_event_t
30 ) RETURN VARCHAR2;
31
32 PROCEDURE Create_Party
33 (
34 itemtype IN VARCHAR2,
35 itemkey IN VARCHAR2,
36 actid IN NUMBER,
37 funcmode IN VARCHAR2,
38 resultout OUT NOCOPY VARCHAR2
39 );
40
41
42 PROCEDURE Create_Fnd_User
43 (
44 itemtype IN VARCHAR2,
45 itemkey IN VARCHAR2,
46 actid IN NUMBER,
47 funcmode IN VARCHAR2,
48 resultout OUT NOCOPY VARCHAR2
49 );
50
51
52
53 PROCEDURE Validate_Username
54 (
55 itemtype IN VARCHAR2,
56 itemkey IN VARCHAR2,
57 actid IN NUMBER,
58 funcmode IN VARCHAR2,
59 resultout OUT NOCOPY VARCHAR2
60 );
61
62
63 PROCEDURE Generate_User
64 (
65 p_api_version IN NUMBER ,
66 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
67 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
68 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
69 x_return_status OUT NOCOPY VARCHAR2 ,
70 x_msg_count OUT NOCOPY NUMBER ,
71 x_msg_data OUT NOCOPY VARCHAR2 ,
72 p_title IN VARCHAR2 ,
73 p_number IN VARCHAR2 ,
74 p_prefix IN VARCHAR2 ,
75 p_alt_id IN VARCHAR2 ,
76 p_given_name IN VARCHAR2 ,
77 p_pref_name IN VARCHAR2 ,
78 p_middle_name IN VARCHAR2 ,
79 p_gender IN VARCHAR2 ,
80 p_surname IN VARCHAR2 ,
81 p_birth IN VARCHAR2 ,
82 p_suffix IN VARCHAR2 ,
83 p_user_name IN VARCHAR2 ,
84 p_user_password IN VARCHAR2 ,
85 p_email_format IN VARCHAR2 ,
86 p_email_address IN VARCHAR2
87 );
88
89 FUNCTION get_id_name RETURN VARCHAR2;
90
91 PRAGMA RESTRICT_REFERENCES(get_id_name,WNDS,WNPS,RNPS);
92
93 FUNCTION generate_password ( p_username IN VARCHAR2) return varchar2;
94
95
96 PROCEDURE Generate_Password
97 (
98 p_api_version IN NUMBER ,
99 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
100 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
101 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
102 x_return_status OUT NOCOPY VARCHAR2 ,
103 x_msg_count OUT NOCOPY NUMBER ,
104 x_msg_data OUT NOCOPY VARCHAR2 ,
105 p_user_name IN VARCHAR2
106 );
107
108 PROCEDURE assign_responsibility
109 (
110 p_person_id NUMBER,
111 p_user_id NUMBER
112 );
113
114 FUNCTION umx_business_logic(
115 p_subscription_guid IN RAW,
116 p_event IN OUT NOCOPY WF_EVENT_T
117 ) RETURN VARCHAR2;
118
119 PROCEDURE TestUserName
120 (
121 p_user_name IN VARCHAR2,
122 x_return_status OUT NOCOPY VARCHAR2 ,
123 x_message_app_name OUT NOCOPY VARCHAR2 ,
124 x_message_name OUT NOCOPY VARCHAR2 ,
125 x_message_text OUT NOCOPY VARCHAR2
126 );
127
128
129 PROCEDURE Validate_Person
130 (
131 p_first_name IN VARCHAR2,
132 p_last_name IN VARCHAR2,
133 p_birth_date IN DATE,
134 p_gender IN VARCHAR2,
135 p_person_num IN OUT NOCOPY VARCHAR2,
136 p_pref_alt_id IN VARCHAR2,
137 p_isApplicant IN VARCHAR2,
138 p_Zipcode IN VARCHAR2,
139 p_phoneCountry IN VARCHAR2,
140 p_phoneArea IN VARCHAR2,
141 p_phoneNumber IN VARCHAR2,
142 p_email_address IN VARCHAR2,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_message_name OUT NOCOPY VARCHAR2,
145 p_person_id OUT NOCOPY NUMBER
146 );
147
148 PROCEDURE AUTO_GENERATE_USERNAME
149 (
150 p_user_name OUT NOCOPY VARCHAR2 ,
151 p_person_number IN VARCHAR2,
152 p_first_name IN VARCHAR2,
153 p_last_name IN VARCHAR2,
154 p_middle_name IN VARCHAR2,
155 p_pref_name IN VARCHAR2,
156 p_pref_alt_id IN VARCHAR2,
157 p_title IN VARCHAR2,
158 p_prefix IN VARCHAR2,
159 p_suffix IN VARCHAR2,
160 p_gender IN VARCHAR2,
161 p_birth_date IN DATE,
162 p_email_address IN VARCHAR2,
163 p_email_format IN VARCHAR2
164 );
165
166 PROCEDURE process_alumni_nomatch_event
167 ( itemtype IN VARCHAR2,
168 itemkey IN VARCHAR2,
169 actid IN NUMBER,
170 funcmode IN VARCHAR2,
171 resultout OUT NOCOPY VARCHAR
172 );
173
174 PROCEDURE validate_password
175 (
176 p_user_name IN VARCHAR2,
177 p_password IN VARCHAR2,
178 x_return_status OUT NOCOPY VARCHAR2 ,
179 x_message_text OUT NOCOPY VARCHAR2
180 );
181
182 END IGS_PE_USERID_PKG;