1 PACKAGE IGS_PRECREATE_APPL_PUB AS
2 /* $Header: IGSPSAPS.pls 120.4 2006/05/31 08:00:24 arvsrini noship $ */
3 /*#
4 * The Pre Create Application Package contains Public API's for Pre Creation of Admission Application.
5 * @rep:scope public
6 * @rep:product IGS
7 * @rep:displayname Pre-Create Admission Application
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY IGS_ADM_APPLICATION
11 */
12 -- Start of comments
13 -- API name : PRE_CREATE_APPLICATION
14 -- Type : Public.
15 -- Function :
16 -- Pre-reqs : None.
17 -- Parameters :
18 -- IN : p_api_version :
19 -- It is Required parameter. Its data type is Number
20 -- p_init_msg_list :
21 -- It is an optional parameter.Default value is FND_API.G_FALSE
22 -- p_commit :
23 -- It is an optional parameter.Default value is FND_API.G_FALSE
24 -- p_validation_level :
25 -- It is an optional parameter.Default value is FND_API.G_VALID_LEVEL_FULL
26 -- p_person_id :
27 -- It is a required parameter. Its datatype is NUMBER.
28 -- Maximum Length is 15. This parameter contains the Person Identifier.
29 -- p_appl_date :
30 -- It is an optional parameter. Its datatype is DATE.
31 -- This parameter contains the Application Date.
32 -- p_acad_cal_type :
33 -- It is a required parameter. Its datatype is VARCHAR2.
34 -- Maximum Length is 10. This parameter contains the Academic Calendar Type.
35 -- p_acad_cal_seq_number :
36 -- It is a required parameter. Its datatype is NUMBER.
37 -- Maximum Length is 15. This parameter contains the Academic Calendar Sequence Number.
38 -- p_adm_cal_type :
39 -- It is a required parameter. Its datatype is VARCHAR2.
40 -- Maximum Length is 10. This parameter contains the Admission Calendar Type.
41 -- p_adm_cal_seq_number :
42 -- It is a required parameter. Its datatype is NUMBER.
43 -- Maximum Length is 15. This parameter contains the Admission Calendar Sequence Number.
44 -- p_entry_status :
45 -- It is an optional parameter. Its datatype is NUMBER.
46 -- This parameter contains the Entry Status.
47 -- p_entry_level :
48 -- It is an optional parameter. Its datatype is NUMBER.
49 -- This parameter contains the Entry Level.
50 -- p_spcl_gr1 :
51 -- It is an optional parameter. Its datatype is NUMBER.
52 -- This parameter contains the Special Group1.
53 -- p_spcl_gr2 :
54 -- It is an optional parameter. Its datatype is NUMBER.
55 -- This parameter contains the Special Group2.
56 -- p_apply_for_finaid :
57 -- It is an optional parameter. Its datatype is VARCHAR2.
58 -- Maximum Length is 1. This parameter contains the Apply for Financial Aid indicator .
59 -- p_finaid_apply_date :
60 -- It is an optional parameter. Its datatype is DATE.
61 -- This parameter contains the Financial Aid Apply Date.
62 -- p_admission_application_type :
63 -- It is a required parameter. Its datatype is VARCHAR2.
64 -- Maximum Length is 30. This parameter contains the Application Type.
65 -- p_apsource_id :
66 -- It is a required parameter. Its datatype is NUMBER.
67 -- Maximum Length is 15. This parameter contains the Application Source Identifier.
68 -- p_application_fee_amount :
69 -- It is an optional parameter. Its datatype is NUMBER.
70 -- This parameter contains the Application Fee Amount.
71 --
72 -- OUT : x_return_status :
73 -- It is out parameter that will contain the return status at the time of exiting the API.
74 -- and calling program can look into this variable to check whether API run was succesful or Not
75 -- It can have three values given below(with definition) :
76 -- G_RET_STS_SUCCESS CONSTANT VARCHAR2 (1):='S';
77 -- G_RET_STS_ERROR CONSTANT VARCHAR2 (1):='E';
78 -- This variable is of type varchar2, and length should be 1
79 -- x_msg_count :
80 -- It is also a out variable which will hold total no of messages issued by API
81 -- This variable is of type number.
82 -- x_msg_data
83 -- if x_msg_count = 1 then this variable will hold the top message on message stack
84 -- else it will be null. Api will expect it as varchar2 type and length of 2000
85 -- x_ss_adm_appl_id :
86 -- Contains the Admission Application Identifier. Its DataType is NUMBER.
87 -- Version : Current version 1.0
88 -- previous version N.A.
89 -- Initial version 1.0
90 -- Notes : None.
91 --
92 -- End of comments
93 /*#
94 * The Pre-Create Admission Application API is a public API that enables captured data to be populated into an unsubmitted admissions
95 * application that is then completed and submitted via WEB self-service.
96 * @param p_API_VERSION API Version Number
97 * @param p_INIT_MSG_LIST Initialize Message List
98 * @param p_COMMIT Commit Transaction
99 * @param p_VALIDATION_LEVEL Validation Level
100 * @param X_RETURN_STATUS Return Status
101 * @param X_MSG_COUNT Message Count
102 * @param X_MSG_DATA Message Data
103 * @param p_PERSON_ID Person ID
104 * @param p_APPL_DATE Application Date
105 * @param p_ACAD_CAL_TYPE Academic Calendar Type
106 * @param p_ACAD_CAL_SEQ_NUMBER Academic Calendar Sequence Number
107 * @param p_ADM_CAL_TYPE Admission Calendar Type
108 * @param p_ADM_CAL_SEQ_NUMBER Admission Calendar Sequence Number
109 * @param p_ENTRY_STATUS Entry Status
110 * @param p_ENTRY_LEVEL Entry Level
111 * @param p_SPCL_GR1 Special Group1
112 * @param p_SPCL_GR2 Special Group2
113 * @param p_APPLY_FOR_FINAID Apply for Financial Aid indicator
114 * @param p_FINAID_APPLY_DATE Financial Aid Apply Date
115 * @param p_ADMISSION_APPLICATION_TYPE Application Type
116 * @param p_APSOURCE_ID Application Source Identifier
117 * @param p_APPLICATION_FEE_AMOUNT Application fee amount
118 * @param X_SS_ADM_APPL_ID Admission Application Id
119 * @rep:scope public
120 * @rep:lifecycle active
121 * @rep:displayname Pre-Create Admission Application
122 */
123 PROCEDURE PRE_CREATE_APPLICATION(
124 --Standard Parameters Start
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
127 p_commit IN VARCHAR2 default FND_API.G_FALSE,
128 p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 --Standard Parameters Start
133 p_person_id IN NUMBER,
134 p_appl_date IN DATE,
135 p_acad_cal_type IN VARCHAR2,
136 p_acad_cal_seq_number IN NUMBER,
137 p_adm_cal_type IN VARCHAR2,
138 p_adm_cal_seq_number IN NUMBER,
139 p_entry_status IN NUMBER,
140 p_entry_level IN NUMBER,
141 p_spcl_gr1 IN NUMBER,
142 p_spcl_gr2 IN NUMBER,
143 p_apply_for_finaid IN VARCHAR2,
144 p_finaid_apply_date IN DATE,
145 p_admission_application_type IN VARCHAR2,
146 p_apsource_id IN NUMBER,
147 p_application_fee_amount IN NUMBER,
148 x_ss_adm_appl_id OUT NOCOPY NUMBER
149 );
150
151 -- Start of comments
152 --
153 -- API name : PRE_CREATE_APPLICATION_INST
154 -- Type : Public.
155 -- Function :
156 -- Pre-reqs : None.
157 -- Parameters :
158 -- IN : p_api_version :
159 -- It is Required parameter. Its data type is Number
160 -- p_init_msg_list :
161 -- It is an optional parameter.Default value is FND_API.G_FALSE
162 -- p_commit :
163 -- It is an optional parameter.Default value is FND_API.G_FALSE
164 -- p_validation_level :
165 -- It is an optional parameter.Default value is FND_API.G_VALID_LEVEL_FULL
166 -- p_ss_adm_appl_id :
167 -- It is a required parameter. Its datatype is NUMBER.
168 -- Maximum Length is 15. This parameter contains the Admission Application Identifier.
169 -- p_sch_apl_to_id :
170 -- It is an optional parameter. Its datatype is NUMBER.
171 -- This parameter contains the School Applying to Identifier.
172 -- p_location_cd :
173 -- It is an optional parameter. Its datatype is VARCHAR2.
174 -- Maximum Length is 10. This parameter contains the Location Code.
175 -- p_attendance_type :
176 -- It is an optional parameter. Its datatype is VARCHAR2.
177 -- Maximum Length is 2. This parameter contains the Attendance Type.
178 -- p_attendance_mode :
179 -- It is an optional parameter. Its datatype is VARCHAR2.
180 -- Maximum Length is 2. This parameter contains the Attendance Mode.
181 -- p_attribute_category :
182 -- It is an optional parameter. Its datatype is VARCHAR2.
183 -- Maximum Length is 30. This parameter contains the Descriptive flex field qualifier..
184 -- p_attribute1 :
185 -- It is an optional parameter. Its datatype is VARCHAR2.
186 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
187 -- p_attribute2 :
188 -- It is an optional parameter. Its datatype is VARCHAR2.
189 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
190 -- p_attribute3 :
191 -- It is an optional parameter. Its datatype is VARCHAR2.
192 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
193 -- p_attribute4 :
194 -- It is an optional parameter. Its datatype is VARCHAR2.
195 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
196 -- p_attribute5 :
197 -- It is an optional parameter. Its datatype is VARCHAR2.
198 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
199 -- p_attribute6 :
200 -- It is an optional parameter. Its datatype is VARCHAR2.
201 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
202 -- p_attribute7 :
203 -- It is an optional parameter. Its datatype is VARCHAR2.
204 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
205 -- p_attribute8 :
206 -- It is an optional parameter. Its datatype is VARCHAR2.
207 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
208 -- p_attribute9 :
209 -- It is an optional parameter. Its datatype is VARCHAR2.
210 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
211 -- p_attribute10 :
212 -- It is an optional parameter. Its datatype is VARCHAR2.
213 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
214 -- p_attribute11 :
215 -- It is an optional parameter. Its datatype is VARCHAR2.
216 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
217 -- p_attribute12 :
218 -- It is an optional parameter. Its datatype is VARCHAR2.
219 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
220 -- p_attribute13 :
221 -- It is an optional parameter. Its datatype is VARCHAR2.
222 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
223 -- p_attribute14 :
224 -- It is an optional parameter. Its datatype is VARCHAR2.
225 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
226 -- p_attribute15 :
227 -- It is an optional parameter. Its datatype is VARCHAR2.
228 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
229 -- p_attribute16 :
230 -- It is an optional parameter. Its datatype is VARCHAR2.
231 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
232 -- p_attribute17 :
233 -- It is an optional parameter. Its datatype is VARCHAR2.
234 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
235 -- p_attribute18 :
236 -- It is an optional parameter. Its datatype is VARCHAR2.
237 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
238 -- p_attribute19 :
239 -- It is an optional parameter. Its datatype is VARCHAR2.
240 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
241 -- p_attribute20 :
242 -- It is an optional parameter. Its datatype is VARCHAR2.
243 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
244 -- p_attribute21 :
245 -- It is an optional parameter. Its datatype is VARCHAR2.
246 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
247 -- p_attribute22 :
248 -- It is an optional parameter. Its datatype is VARCHAR2.
249 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
250 -- p_attribute23 :
251 -- It is an optional parameter. Its datatype is VARCHAR2.
252 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
253 -- p_attribute24 :
254 -- It is an optional parameter. Its datatype is VARCHAR2.
255 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
256 -- p_attribute25 :
257 -- It is an optional parameter. Its datatype is VARCHAR2.
258 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
259 -- p_attribute26 :
260 -- It is an optional parameter. Its datatype is VARCHAR2.
261 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
262 -- p_attribute27 :
263 -- It is an optional parameter. Its datatype is VARCHAR2.
264 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
265 -- p_attribute28 :
266 -- It is an optional parameter. Its datatype is VARCHAR2.
267 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
268 -- p_attribute29 :
269 -- It is an optional parameter. Its datatype is VARCHAR2.
270 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
271 -- p_attribute30 :
272 -- It is an optional parameter. Its datatype is VARCHAR2.
273 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
274 -- p_attribute31 :
275 -- It is an optional parameter. Its datatype is VARCHAR2.
276 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
277 -- p_attribute32 :
278 -- It is an optional parameter. Its datatype is VARCHAR2.
282 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
279 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
280 -- p_attribute33 :
281 -- It is an optional parameter. Its datatype is VARCHAR2.
283 -- p_attribute34 :
284 -- It is an optional parameter. Its datatype is VARCHAR2.
285 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
286 -- p_attribute35 :
287 -- It is an optional parameter. Its datatype is VARCHAR2.
288 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
289 -- p_attribute36 :
290 -- It is an optional parameter. Its datatype is VARCHAR2.
291 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
292 -- p_attribute37 :
293 -- It is an optional parameter. Its datatype is VARCHAR2.
294 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
295 -- p_attribute38 :
296 -- It is an optional parameter. Its datatype is VARCHAR2.
297 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
298 -- p_attribute39 :
299 -- It is an optional parameter. Its datatype is VARCHAR2.
300 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
301 -- p_attribute40 :
302 -- It is an optional parameter. Its datatype is VARCHAR2.
303 -- Maximum Length is 150. This parameter contains the Standard Attribute Column. Meant for descriptive flex field.
304 --
305 -- OUT : x_return_status :
306 -- It is out parameter that will contain the return status at the time of exiting the API.
307 -- and calling program can look into this variable to check whether API run was succesful or Not
308 -- It can have three values given below(with definition) :
309 -- G_RET_STS_SUCCESS CONSTANT VARCHAR2 (1):='S';
310 -- G_RET_STS_ERROR CONSTANT VARCHAR2 (1):='E';
311 -- G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2 (1):='U';
312 -- This variable is of type varchar2, and length should be 1
313 -- x_msg_count :
314 -- It is also a out variable which will hold total no of messages issued by API
315 -- This variable is of type number.
316 -- x_msg_data
317 -- if x_msg_count = 1 then this variable will hold the top message on message stack
318 -- else it will be null. Api will expect it as varchar2 type and length of 2000
319 -- x_ss_admappl_pgm_id :
320 -- It is the Admission Application Program Instance Identifier. Datatype is NUMBER.
321 -- Version : Current version 1.0
322 -- previous version N.A.
323 -- Initial version 1.0
324 -- Notes : None.
325 --
326 -- End of comments
327
328 /*#
329 * The Pre-Create Admission Application Instance API is a public API that enables captured data to be populated into
330 * an unsubmitted admissions application instance that is then completed and submitted via WEB self-service.
331 * @param p_API_VERSION API Version Number
332 * @param p_INIT_MSG_LIST Initialize Message List
333 * @param p_COMMIT Commit Transaction
334 * @param p_VALIDATION_LEVEL Validation Level
335 * @param X_RETURN_STATUS Return Status
336 * @param X_MSG_COUNT Message Count
337 * @param X_MSG_DATA Message Data
338 * @param p_SS_ADM_APPL_ID A unique identifier to identify a Self Service Admission Application
339 * @param p_SCH_APL_TO_ID School Applying to Id
340 * @param p_LOCATION_CD Location Code
341 * @param p_ATTENDANCE_TYPE Attendance Type
342 * @param p_ATTENDANCE_MODE Attendance Mode
343 * @param p_ATTRIBUTE_CATEGORY Descriptive flex field qualifier.
344 * @param p_ATTRIBUTE1 Standard Attribute Column. Meant for descriptive flex field.
345 * @param p_ATTRIBUTE2 Standard Attribute Column. Meant for descriptive flex field.
346 * @param p_ATTRIBUTE3 Standard Attribute Column. Meant for descriptive flex field.
347 * @param p_ATTRIBUTE4 Standard Attribute Column. Meant for descriptive flex field.
348 * @param p_ATTRIBUTE5 Standard Attribute Column. Meant for descriptive flex field.
349 * @param p_ATTRIBUTE6 Standard Attribute Column. Meant for descriptive flex field.
350 * @param p_ATTRIBUTE7 Standard Attribute Column. Meant for descriptive flex field.
351 * @param p_ATTRIBUTE8 Standard Attribute Column. Meant for descriptive flex field.
352 * @param p_ATTRIBUTE9 Standard Attribute Column. Meant for descriptive flex field.
353 * @param p_ATTRIBUTE10 Standard Attribute Column. Meant for descriptive flex field.
354 * @param p_ATTRIBUTE11 Standard Attribute Column. Meant for descriptive flex field.
355 * @param p_ATTRIBUTE12 Standard Attribute Column. Meant for descriptive flex field.
356 * @param p_ATTRIBUTE13 Standard Attribute Column. Meant for descriptive flex field.
357 * @param p_ATTRIBUTE14 Standard Attribute Column. Meant for descriptive flex field.
358 * @param p_ATTRIBUTE15 Standard Attribute Column. Meant for descriptive flex field.
359 * @param p_ATTRIBUTE16 Standard Attribute Column. Meant for descriptive flex field.
360 * @param p_ATTRIBUTE17 Standard Attribute Column. Meant for descriptive flex field.
361 * @param p_ATTRIBUTE18 Standard Attribute Column. Meant for descriptive flex field.
362 * @param p_ATTRIBUTE19 Standard Attribute Column. Meant for descriptive flex field.
363 * @param p_ATTRIBUTE20 Standard Attribute Column. Meant for descriptive flex field.
364 * @param p_ATTRIBUTE21 Standard Attribute Column. Meant for descriptive flex field.
365 * @param p_ATTRIBUTE22 Standard Attribute Column. Meant for descriptive flex field.
369 * @param p_ATTRIBUTE26 Standard Attribute Column. Meant for descriptive flex field.
366 * @param p_ATTRIBUTE23 Standard Attribute Column. Meant for descriptive flex field.
367 * @param p_ATTRIBUTE24 Standard Attribute Column. Meant for descriptive flex field.
368 * @param p_ATTRIBUTE25 Standard Attribute Column. Meant for descriptive flex field.
370 * @param p_ATTRIBUTE27 Standard Attribute Column. Meant for descriptive flex field.
371 * @param p_ATTRIBUTE28 Standard Attribute Column. Meant for descriptive flex field.
372 * @param p_ATTRIBUTE29 Standard Attribute Column. Meant for descriptive flex field.
373 * @param p_ATTRIBUTE30 Standard Attribute Column. Meant for descriptive flex field.
374 * @param p_ATTRIBUTE31 Standard Attribute Column. Meant for descriptive flex field.
375 * @param p_ATTRIBUTE32 Standard Attribute Column. Meant for descriptive flex field.
376 * @param p_ATTRIBUTE33 Standard Attribute Column. Meant for descriptive flex field.
377 * @param p_ATTRIBUTE34 Standard Attribute Column. Meant for descriptive flex field.
378 * @param p_ATTRIBUTE35 Standard Attribute Column. Meant for descriptive flex field.
379 * @param p_ATTRIBUTE36 Standard Attribute Column. Meant for descriptive flex field.
380 * @param p_ATTRIBUTE37 Standard Attribute Column. Meant for descriptive flex field.
381 * @param p_ATTRIBUTE38 Standard Attribute Column. Meant for descriptive flex field.
382 * @param p_ATTRIBUTE39 Standard Attribute Column. Meant for descriptive flex field.
383 * @param p_ATTRIBUTE40 Standard Attribute Column. Meant for descriptive flex field.
384 * @param X_SS_ADMAPPL_PGM_ID Admission Application Program Identifier
385 * @rep:scope public
386 * @rep:lifecycle active
387 * @rep:displayname Pre-Create Admission Application Instance
388 */
389 PROCEDURE PRE_CREATE_APPLICATION_INST(
390 --Standard Parameters Start
391 p_api_version IN NUMBER,
392 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
393 p_commit IN VARCHAR2 default FND_API.G_FALSE,
394 p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
395 x_return_status OUT NOCOPY VARCHAR2,
396 x_msg_count OUT NOCOPY NUMBER,
397 x_msg_data OUT NOCOPY VARCHAR2,
398 --Standard Parameters Start
399 p_ss_adm_appl_id IN NUMBER,
400 p_sch_apl_to_id IN NUMBER,
401 p_location_cd IN VARCHAR2,
402 p_attendance_type IN VARCHAR2,
403 p_attendance_mode IN VARCHAR2,
404 p_attribute_category IN VARCHAR2,
405 p_attribute1 IN VARCHAR2,
406 p_attribute2 IN VARCHAR2,
407 p_attribute3 IN VARCHAR2,
408 p_attribute4 IN VARCHAR2,
409 p_attribute5 IN VARCHAR2,
410 p_attribute6 IN VARCHAR2,
411 p_attribute7 IN VARCHAR2,
412 p_attribute8 IN VARCHAR2,
413 p_attribute9 IN VARCHAR2,
414 p_attribute10 IN VARCHAR2,
415 p_attribute11 IN VARCHAR2,
416 p_attribute12 IN VARCHAR2,
417 p_attribute13 IN VARCHAR2,
418 p_attribute14 IN VARCHAR2,
419 p_attribute15 IN VARCHAR2,
420 p_attribute16 IN VARCHAR2,
421 p_attribute17 IN VARCHAR2,
422 p_attribute18 IN VARCHAR2,
423 p_attribute19 IN VARCHAR2,
424 p_attribute20 IN VARCHAR2,
425 p_attribute21 IN VARCHAR2,
426 p_attribute22 IN VARCHAR2,
427 p_attribute23 IN VARCHAR2,
428 p_attribute24 IN VARCHAR2,
429 p_attribute25 IN VARCHAR2,
430 p_attribute26 IN VARCHAR2,
431 p_attribute27 IN VARCHAR2,
432 p_attribute28 IN VARCHAR2,
433 p_attribute29 IN VARCHAR2,
434 p_attribute30 IN VARCHAR2,
435 p_attribute31 IN VARCHAR2,
436 p_attribute32 IN VARCHAR2,
437 p_attribute33 IN VARCHAR2,
438 p_attribute34 IN VARCHAR2,
439 p_attribute35 IN VARCHAR2,
440 p_attribute36 IN VARCHAR2,
441 p_attribute37 IN VARCHAR2,
442 p_attribute38 IN VARCHAR2,
443 p_attribute39 IN VARCHAR2,
444 p_attribute40 IN VARCHAR2,
445 x_ss_admappl_pgm_id OUT NOCOPY NUMBER
446 );
447
448 -- Start of comments
449 --
450 -- API name : INSERT_STG_FEE_REQ_DET
451 -- Type : Public.
452 -- Function :
453 -- Pre-reqs : None.
454 -- Parameters :
455 -- IN : p_api_version :
456 -- It is Required parameter. Its data type is Number
457 -- p_init_msg_list :
458 -- It is an optional parameter.Default value is FND_API.G_FALSE
459 -- p_commit :
460 -- It is an optional parameter.Default value is FND_API.G_FALSE
461 -- p_validation_level :
462 -- It is an optional parameter.Default value is FND_API.G_VALID_LEVEL_FULL
463 -- p_SS_ADM_APPL_ID :
464 -- It is a required parameter. Its datatype is NUMBER.
465 -- Maximum Length is 15. This parameter contains the Admission Application Identifier.
466 -- p_PERSON_ID :
467 -- It is a required parameter. Its datatype is NUMBER.
468 -- Maximum Length is 15. This parameter contains the Person Identifier.
469 -- p_APPLICANT_FEE_TYPE :
470 -- It is a required parameter. Its datatype is NUMBER.
471 -- Maximum Length is 15. This parameter contains the Application Fee Type.
472 -- p_APPLICANT_FEE_STATUS :
473 -- It is a required parameter. Its datatype is NUMBER.
474 -- Maximum Length is 15. This parameter contains the Applicant Fee Status.
475 -- p_FEE_DATE :
476 -- It is a required parameter. Its datatype is DATE.
477 -- This parameter contains the Fee Date.
478 -- p_FEE_PAYMENT_METHOD :
479 -- It is an optional parameter. Its datatype is NUMBER.
480 -- Maximum Length is 15. This parameter contains the Fee Payment Methods.
481 -- p_FEE_AMOUNT :
482 -- It is a required parameter. Its datatype is NUMBER.
483 -- This parameter contains the Fee Amount.
484 -- p_REFERENCE_NUM :
485 -- It is an optional parameter. Its datatype is VARCHAR2.
489 -- It is out parameter that will contain the return status at the time of exiting the API.
486 -- Maximum Length is 60. This parameter contains the Reference Number.
487 --
488 -- OUT : x_return_status :
490 -- and calling program can look into this variable to check whether API run was succesful or Not
491 -- It can have three values given below(with definition) :
492 -- G_RET_STS_SUCCESS CONSTANT VARCHAR2 (1):='S';
493 -- G_RET_STS_ERROR CONSTANT VARCHAR2 (1):='E';
494 -- G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2 (1):='U';
495 -- This variable is of type varchar2, and length should be 1
496 -- x_msg_count :
497 -- It is also a out variable which will hold total no of messages issued by API
498 -- This variable is of type number.
499 -- x_msg_data
500 -- if x_msg_count = 1 then this variable will hold the top message on message stack
501 -- else it will be null. Api will expect it as varchar2 type and length of 2000
502 --
503 -- Version : Current version 1.0
504 -- previous version N.A.
505 -- Initial version 1.0
506 -- Notes : None.
507 --
508 -- End of comments
509 /*#
510 * The Admission Fee Detail API is a public API that enables customers to insert fee transaction records (most notably waivers) on the basis of data captured in the create application flow
511 * application on its submission via WEB self-service.
512 * @param p_API_VERSION API Version Number
513 * @param p_INIT_MSG_LIST Initialize Message List
514 * @param p_COMMIT Commit Transaction
515 * @param p_VALIDATION_LEVEL Validation Level
516 * @param X_RETURN_STATUS Return Status
517 * @param X_MSG_COUNT Message Count
518 * @param X_MSG_DATA Message Data
519 * @param p_SS_ADM_APPL_ID Self-Service Admission Application Identifier
520 * @param p_PERSON_ID Person Identifier
521 * @param p_APPLICANT_FEE_TYPE Application Fee Type
522 * @param p_APPLICANT_FEE_STATUS Application Fee Status
523 * @param p_FEE_DATE Application Fee Date
524 * @param p_FEE_PAYMENT_METHOD Fee Payment Method
525 * @param p_FEE_AMOUNT Fee Amount Paid
526 * @param p_REFERENCE_NUM Transaction Reference Number
527 * @rep:scope public
528 * @rep:lifecycle active
529 * @rep:displayname Admission Fee Detail
530 */
531 PROCEDURE INSERT_STG_FEE_REQ_DET (
532 p_api_version IN NUMBER, -- standard Public API IN params
533 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
534 p_commit IN VARCHAR2 default FND_API.G_FALSE,
535 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
536 x_return_status OUT NOCOPY VARCHAR2, -- standard Public API OUT params
537 x_msg_count OUT NOCOPY NUMBER,
538 x_msg_data OUT NOCOPY VARCHAR2,
539 p_SS_ADM_APPL_ID IN NUMBER, -- Staging table related params
540 p_PERSON_ID IN NUMBER,
541 p_APPLICANT_FEE_TYPE IN NUMBER,
542 p_APPLICANT_FEE_STATUS IN NUMBER,
543 p_FEE_DATE IN DATE,
544 p_FEE_PAYMENT_METHOD IN NUMBER,
545 p_FEE_AMOUNT IN NUMBER,
546 p_REFERENCE_NUM IN VARCHAR2
547 );
548
549 END IGS_PRECREATE_APPL_PUB;