[Home] [Help]
PACKAGE: APPS.PV_PG_ENRL_REQUESTS_PVT
Source
1 PACKAGE PV_Pg_Enrl_Requests_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvpers.pls 120.2 2005/10/24 08:31:35 dgottlie ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Pg_Enrl_Requests_PVT
7 -- Purpose
8 --
9 -- History
10 -- 20-OCT-2002 Karen.Tsao Created
11 -- 27-NOV-2002 Karen.Tsao 1. Modified to change datatype for order_header_id.
12 -- 2. Debug message to be wrapped with IF check.
13 -- 3. Replace of COPY with NOCOPY string.
14 -- 27-AUG-2003 Karen.Tsao Update the enrl_request_rec_type with two new columns in
15 -- pv_pg_enrl_requests: membership_fee, transactional_curr_code
16 -- 29-AUG-2003 Karen.Tsao Modified for column name change: transactional_curr_code to trans_curr_code
17 -- 26-SEP-2003 pukken Added dependent_program_id column in pv_pg_enrl_requests record
18 -- 20-APR-2005 Karen.Tsao Modified for R12.
19 -- 05-JUL-2005 kvattiku Added trxn_extension_id column in pv_pg_enrl_requests record
20 --
21 -- NOTE
22 --
23 -- This Api is generated with Latest version of
24 -- Rosetta, where g_miss indicates NULL and
25 -- NULL indicates missing value. Rosetta Version 1.55
26 -- End of Comments
27 -- ===============================================================
28
29 -- Default number of records fetch per call
30 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
31 --===================================================================
32 -- Start of Comments
33 -- -------------------------------------------------------
34 -- Record name
35 -- enrl_request_rec_type
36 -- -------------------------------------------------------
37 -- Parameters:
38 -- enrl_request_id
39 -- object_version_number
40 -- program_id
41 -- partner_id
42 -- custom_setup_id
43 -- requestor_resource_id
44 -- request_status_code
45 -- enrollment_type_code
46 -- request_submission_date
47 -- contract_id
48 -- request_initiated_by_code
49 -- invite_header_id
50 -- tentative_start_date
51 -- tentative_end_date
52 -- contract_status_code
53 -- payment_status_code
54 -- score_result_code
55 -- created_by
56 -- creation_date
57 -- last_updated_by
58 -- last_update_date
59 -- last_update_login
60 -- order_header_id
61 -- membership_fee
62 -- dependent_program_id
63 -- trans_curr_code
64 -- contract_binding_contact_id
65 -- contract_signed_date
66 -- trxn_extension_id
67 --
68 -- Required
69 --
70 -- Defaults
71 --
72 -- Note: This is automatic generated record definition, it includes all columns
73 -- defined in the table, developer must manually add or delete some of the attributes.
74 --
75 -- End of Comments
76
77 --===================================================================
78 TYPE enrl_request_rec_type IS RECORD
79 (
80 enrl_request_id NUMBER,
81 object_version_number NUMBER,
82 program_id NUMBER,
83 partner_id NUMBER,
84 custom_setup_id NUMBER,
85 requestor_resource_id NUMBER,
86 request_status_code VARCHAR2(30),
87 enrollment_type_code VARCHAR2(30),
88 request_submission_date DATE,
89 contract_id NUMBER,
90 request_initiated_by_code VARCHAR2(30),
91 invite_header_id NUMBER,
92 tentative_start_date DATE,
93 tentative_end_date DATE,
94 contract_status_code VARCHAR2(30),
95 payment_status_code VARCHAR2(30),
96 score_result_code VARCHAR2(30),
97 created_by NUMBER,
98 creation_date DATE,
99 last_updated_by NUMBER,
100 last_update_date DATE,
101 last_update_login NUMBER,
102 order_header_id NUMBER,
103 membership_fee NUMBER,
104 dependent_program_id NUMBER,
105 trans_curr_code VARCHAR2(15),
106 contract_binding_contact_id NUMBER,
107 contract_signed_date DATE,
108 trxn_extension_id NUMBER,
109 attribute1 VARCHAR2(240),
110 attribute2 VARCHAR2(240),
111 attribute3 VARCHAR2(240),
112 attribute4 VARCHAR2(240),
113 attribute5 VARCHAR2(240),
114 attribute6 VARCHAR2(240),
115 attribute7 VARCHAR2(240),
116 attribute8 VARCHAR2(240),
117 attribute9 VARCHAR2(240),
118 attribute10 VARCHAR2(240),
119 attribute11 VARCHAR2(240),
120 attribute12 VARCHAR2(240),
121 attribute13 VARCHAR2(240),
122 attribute14 VARCHAR2(240),
123 attribute15 VARCHAR2(240)
124 );
125
126 g_miss_enrl_request_rec enrl_request_rec_type := NULL;
127 TYPE enrl_request_tbl_type IS TABLE OF enrl_request_rec_type INDEX BY BINARY_INTEGER;
128 g_miss_enrl_request_tbl enrl_request_tbl_type;
129
130 -- ==============================================================================
131 -- Start of Comments
132 -- ==============================================================================
133 -- API Name
134 -- Create_Pg_Enrl_Requests
135 -- Type
136 -- Private
137 -- Pre-Req
138 --
139 -- Parameters
140 --
141 -- IN
142 -- p_api_version_number IN NUMBER Required
143 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146 -- p_enrl_request_rec IN enrl_request_rec_type Required
147 --
148 -- OUT
149 -- x_return_status OUT VARCHAR2
150 -- x_msg_count OUT NUMBER
151 -- x_msg_data OUT VARCHAR2
152 -- Version : Current version 1.0
153 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
154 -- and basic operation, developer must manually add parameters and business logic as necessary.
155 --
156 -- History
157 --
158 -- NOTE
159 --
160 -- End of Comments
161 -- ==============================================================================
162
163 PROCEDURE Create_Pg_Enrl_Requests(
164 p_api_version_number IN NUMBER,
165 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166 p_commit IN VARCHAR2 := FND_API.G_FALSE,
167 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172
173 p_enrl_request_rec IN enrl_request_rec_type := g_miss_enrl_request_rec,
174 x_enrl_request_id OUT NOCOPY NUMBER
175 );
176
177 -- ==============================================================================
178 -- Start of Comments
179 -- ==============================================================================
180 -- API Name
181 -- Update_Pg_Enrl_Requests
182 -- Type
183 -- Private
184 -- Pre-Req
185 --
186 -- Parameters
187 --
188 -- IN
189 -- p_api_version_number IN NUMBER Required
190 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
191 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
192 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
193 -- p_enrl_request_rec IN enrl_request_rec_type Required
194 --
195 -- OUT
196 -- x_return_status OUT VARCHAR2
197 -- x_msg_count OUT NUMBER
198 -- x_msg_data OUT VARCHAR2
199 -- Version : Current version 1.0
200 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
201 -- and basic operation, developer must manually add parameters and business logic as necessary.
202 --
203 -- History
204 --
205 -- NOTE
206 --
207 -- End of Comments
208 -- ==============================================================================
209
210 PROCEDURE Update_Pg_Enrl_Requests(
211 p_api_version_number IN NUMBER,
212 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213 p_commit IN VARCHAR2 := FND_API.G_FALSE,
214 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219
220 p_enrl_request_rec IN enrl_request_rec_type
221 );
222
223 -- ==============================================================================
224 -- Start of Comments
225 -- ==============================================================================
226 -- API Name
227 -- Delete_Pg_Enrl_Requests
228 -- Type
229 -- Private
230 -- Pre-Req
231 --
232 -- Parameters
233 --
234 -- IN
235 -- p_api_version_number IN NUMBER Required
236 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
237 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
238 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
239 -- p_enrl_request_id IN NUMBER
240 -- p_object_version_number IN NUMBER Optional Default = NULL
241 --
242 -- OUT
243 -- x_return_status OUT VARCHAR2
244 -- x_msg_count OUT NUMBER
245 -- x_msg_data OUT VARCHAR2
246 -- Version : Current version 1.0
247 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
248 -- and basic operation, developer must manually add parameters and business logic as necessary.
249 --
250 -- History
251 --
252 -- NOTE
253 --
254 -- End of Comments
255 -- ==============================================================================
256
257 PROCEDURE Delete_Pg_Enrl_Requests(
258 p_api_version_number IN NUMBER,
259 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260 p_commit IN VARCHAR2 := FND_API.G_FALSE,
261 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2,
265 p_enrl_request_id IN NUMBER,
266 p_object_version_number IN NUMBER
267 );
268
269 -- ==============================================================================
270 -- Start of Comments
271 -- ==============================================================================
272 -- API Name
273 -- Lock_Pg_Enrl_Requests
274 -- Type
275 -- Private
276 -- Pre-Req
277 --
278 -- Parameters
279 --
280 -- IN
281 -- p_api_version_number IN NUMBER Required
282 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
283 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
284 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
285 -- p_enrl_request_rec IN enrl_request_rec_type Required
286 --
287 -- OUT
288 -- x_return_status OUT VARCHAR2
289 -- x_msg_count OUT NUMBER
290 -- x_msg_data OUT VARCHAR2
291 -- Version : Current version 1.0
292 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
293 -- and basic operation, developer must manually add parameters and business logic as necessary.
294 --
295 -- History
296 --
297 -- NOTE
298 --
299 -- End of Comments
300 -- ==============================================================================
301
302 PROCEDURE Lock_Pg_Enrl_Requests(
303 p_api_version_number IN NUMBER,
304 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305
306 x_return_status OUT NOCOPY VARCHAR2,
307 x_msg_count OUT NOCOPY NUMBER,
308 x_msg_data OUT NOCOPY VARCHAR2,
309
310 p_enrl_request_id IN NUMBER,
311 p_object_version IN NUMBER
312 );
313
314
315 -- ==============================================================================
316 -- Start of Comments
317 -- ==============================================================================
318 -- API Name
319 -- Validate_Pg_Enrl_Requests
320 --
321 -- Version : Current version 1.0
322 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
323 -- For create: G_CREATE, for update: G_UPDATE
324 -- Note: 1. This is automated generated item level validation procedure.
325 -- The actual validation detail is needed to be added.
326 -- 2. We can also validate table instead of record. There will be an option for user to choose.
327 --
328 -- History
329 --
330 -- NOTE
331 --
332 -- End of Comments
333 -- ==============================================================================
334
335
336 PROCEDURE Validate_Pg_Enrl_Requests(
340 p_enrl_request_rec IN enrl_request_rec_type,
337 p_api_version_number IN NUMBER,
338 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341 p_validation_mode IN VARCHAR2,
342 x_return_status OUT NOCOPY VARCHAR2,
343 x_msg_count OUT NOCOPY NUMBER,
344 x_msg_data OUT NOCOPY VARCHAR2
345 );
346
347 -- ==============================================================================
348 -- Start of Comments
349 -- ==============================================================================
350 -- API Name
351 -- Enrl_Request_Items
352 --
353 -- Version : Current version 1.0
354 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
355 -- For create: G_CREATE, for update: G_UPDATE
356 -- Note: 1. This is automated generated item level validation procedure.
357 -- The actual validation detail is needed to be added.
358 -- 2. Validate the unique keys, lookups here
359 --
360 -- History
361 --
362 -- NOTE
363 --
364 -- End of Comments
365 -- ==============================================================================
366
367
368 PROCEDURE Check_Enrl_Request_Items (
369 P_enrl_request_rec IN enrl_request_rec_type,
370 p_validation_mode IN VARCHAR2,
371 x_return_status OUT NOCOPY VARCHAR2
372 );
373
374 -- ==============================================================================
375 -- Start of Comments
376 -- ==============================================================================
377 -- API Name
378 -- Validate_Enrl_Request_Rec
379 --
380 -- Version : Current version 1.0
381 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
382 -- For create: G_CREATE, for update: G_UPDATE
383 -- Note: 1. This is automated generated item level validation procedure.
384 -- The actual validation detail is needed to be added.
385 -- 2. Developer can manually added inter-field level validation.
386 --
387 -- History
388 --
389 -- NOTE
390 --
391 -- End of Comments
392 -- ==============================================================================
393
394
395 PROCEDURE Validate_Enrl_Request_Rec (
396 p_api_version_number IN NUMBER,
397 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
398 x_return_status OUT NOCOPY VARCHAR2,
399 x_msg_count OUT NOCOPY NUMBER,
400 x_msg_data OUT NOCOPY VARCHAR2,
401 p_enrl_request_rec IN enrl_request_rec_type
402 );
403
404 END PV_Pg_Enrl_Requests_PVT;