1 PACKAGE igs_ad_ps_appl_inst_pkg AS
2 /* $Header: IGSAI18S.pls 120.1 2005/08/11 09:56:53 appldev ship $ */
3
4 PROCEDURE insert_row (
5 X_ROWID in out NOCOPY VARCHAR2,
6 x_ORG_ID in NUMBER,
7 x_PERSON_ID IN NUMBER,
8 x_ADMISSION_APPL_NUMBER IN NUMBER,
9 x_NOMINATED_COURSE_CD IN VARCHAR2,
10 x_SEQUENCE_NUMBER IN NUMBER,
11 x_PREDICTED_GPA IN NUMBER,
12 x_ACADEMIC_INDEX IN VARCHAR2,
13 x_ADM_CAL_TYPE IN VARCHAR2,
14 x_APP_FILE_LOCATION IN VARCHAR2,
15 x_ADM_CI_SEQUENCE_NUMBER IN NUMBER,
16 x_COURSE_CD IN VARCHAR2,
17 x_APP_SOURCE_ID IN NUMBER,
18 x_CRV_VERSION_NUMBER IN NUMBER,
19 x_WAITLIST_RANK IN VARCHAR2,
20 x_LOCATION_CD IN VARCHAR2,
21 x_ATTENT_OTHER_INST_CD IN VARCHAR2,
22 x_ATTENDANCE_MODE IN VARCHAR2,
23 x_EDU_GOAL_PRIOR_ENROLL_ID IN NUMBER,
24 x_ATTENDANCE_TYPE IN VARCHAR2,
25 x_DECISION_MAKE_ID IN NUMBER,
26 x_UNIT_SET_CD IN VARCHAR2,
27 x_DECISION_DATE IN DATE,
28 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
29 x_ATTRIBUTE1 IN VARCHAR2,
30 x_ATTRIBUTE2 IN VARCHAR2,
31 x_ATTRIBUTE3 IN VARCHAR2,
32 x_ATTRIBUTE4 IN VARCHAR2,
33 x_ATTRIBUTE5 IN VARCHAR2,
34 x_ATTRIBUTE6 IN VARCHAR2,
35 x_ATTRIBUTE7 IN VARCHAR2,
36 x_ATTRIBUTE8 IN VARCHAR2,
37 x_ATTRIBUTE9 IN VARCHAR2,
38 x_ATTRIBUTE10 IN VARCHAR2,
39 x_ATTRIBUTE11 IN VARCHAR2,
40 x_ATTRIBUTE12 IN VARCHAR2,
41 x_ATTRIBUTE13 IN VARCHAR2,
42 x_ATTRIBUTE14 IN VARCHAR2,
43 x_ATTRIBUTE15 IN VARCHAR2,
44 x_ATTRIBUTE16 IN VARCHAR2,
45 x_ATTRIBUTE17 IN VARCHAR2,
46 x_ATTRIBUTE18 IN VARCHAR2,
47 x_ATTRIBUTE19 IN VARCHAR2,
48 x_ATTRIBUTE20 IN VARCHAR2,
49 x_DECISION_REASON_ID IN NUMBER,
50 x_US_VERSION_NUMBER IN NUMBER,
51 x_DECISION_NOTES IN VARCHAR2,
52 x_PENDING_REASON_ID IN NUMBER,
53 x_PREFERENCE_NUMBER IN NUMBER,
54 x_ADM_DOC_STATUS IN VARCHAR2,
55 x_ADM_ENTRY_QUAL_STATUS IN VARCHAR2,
56 x_DEFICIENCY_IN_PREP IN VARCHAR2,
57 x_LATE_ADM_FEE_STATUS IN VARCHAR2,
58 x_SPL_CONSIDER_COMMENTS IN VARCHAR2,
59 x_APPLY_FOR_FINAID IN VARCHAR2,
60 x_FINAID_APPLY_DATE IN DATE,
61 x_ADM_OUTCOME_STATUS IN VARCHAR2,
62 x_ADM_OTCM_STAT_AUTH_PER_ID IN NUMBER,
63 x_ADM_OUTCOME_STATUS_AUTH_DT IN DATE,
64 x_ADM_OUTCOME_STATUS_REASON IN VARCHAR2,
65 x_OFFER_DT IN DATE,
66 x_OFFER_RESPONSE_DT IN DATE,
67 x_PRPSD_COMMENCEMENT_DT IN DATE,
68 x_ADM_CNDTNL_OFFER_STATUS IN VARCHAR2,
69 x_CNDTNL_OFFER_SATISFIED_DT IN DATE,
70 x_CNDNL_OFR_MUST_BE_STSFD_IND IN VARCHAR2,
71 x_ADM_OFFER_RESP_STATUS IN VARCHAR2,
72 x_ACTUAL_RESPONSE_DT IN DATE,
73 x_ADM_OFFER_DFRMNT_STATUS IN VARCHAR2,
74 x_DEFERRED_ADM_CAL_TYPE IN VARCHAR2,
75 x_DEFERRED_ADM_CI_SEQUENCE_NUM IN NUMBER,
76 x_DEFERRED_TRACKING_ID IN NUMBER,
77 x_ASS_RANK IN NUMBER,
78 x_SECONDARY_ASS_RANK IN NUMBER,
79 X_INTR_ACCEPT_ADVICE_NUM IN NUMBER,
80 x_ASS_TRACKING_ID IN NUMBER,
81 x_FEE_CAT IN VARCHAR2,
82 x_HECS_PAYMENT_OPTION IN VARCHAR2,
83 x_EXPECTED_COMPLETION_YR IN NUMBER,
84 x_EXPECTED_COMPLETION_PERD IN VARCHAR2,
85 x_CORRESPONDENCE_CAT IN VARCHAR2,
86 x_ENROLMENT_CAT IN VARCHAR2,
87 x_FUNDING_SOURCE IN VARCHAR2,
88 x_APPLICANT_ACPTNCE_CNDTN IN VARCHAR2,
89 x_CNDTNL_OFFER_CNDTN IN VARCHAR2,
90 X_MODE in VARCHAR2 default 'R',
91 X_SS_APPLICATION_ID IN VARCHAR2,
92 X_SS_PWD IN VARCHAR2 ,
93 X_AUTHORIZED_DT IN DATE DEFAULT NULL,
94 X_AUTHORIZING_PERS_ID IN NUMBER DEFAULT NULL,
95 x_entry_status IN NUMBER DEFAULT NULL,
96 x_entry_level IN NUMBER DEFAULT NULL,
97 x_sch_apl_to_id IN NUMBER DEFAULT NULL,
98 x_idx_calc_date IN DATE DEFAULT NULL,
99 X_WAITLIST_STATUS IN VARCHAR2 DEFAULT NULL,
100 x_attribute21 IN VARCHAR2 DEFAULT NULL,
101 x_attribute22 IN VARCHAR2 DEFAULT NULL,
102 x_attribute23 IN VARCHAR2 DEFAULT NULL,
103 x_attribute24 IN VARCHAR2 DEFAULT NULL,
104 x_attribute25 IN VARCHAR2 DEFAULT NULL,
105 x_attribute26 IN VARCHAR2 DEFAULT NULL,
106 x_attribute27 IN VARCHAR2 DEFAULT NULL,
107 x_attribute28 IN VARCHAR2 DEFAULT NULL,
108 x_attribute29 IN VARCHAR2 DEFAULT NULL,
109 x_attribute30 IN VARCHAR2 DEFAULT NULL,
110 x_attribute31 IN VARCHAR2 DEFAULT NULL,
111 x_attribute32 IN VARCHAR2 DEFAULT NULL,
112 x_attribute33 IN VARCHAR2 DEFAULT NULL,
113 x_attribute34 IN VARCHAR2 DEFAULT NULL,
114 x_attribute35 IN VARCHAR2 DEFAULT NULL,
115 x_attribute36 IN VARCHAR2 DEFAULT NULL,
116 x_attribute37 IN VARCHAR2 DEFAULT NULL,
117 x_attribute38 IN VARCHAR2 DEFAULT NULL,
118 x_attribute39 IN VARCHAR2 DEFAULT NULL,
119 x_attribute40 IN VARCHAR2 DEFAULT NULL,
120 x_fut_acad_cal_type IN VARCHAR2 DEFAULT NULL,
121 x_fut_acad_ci_sequence_number IN NUMBER DEFAULT NULL,
122 x_fut_adm_cal_type IN VARCHAR2 DEFAULT NULL,
123 x_fut_adm_ci_sequence_number IN NUMBER DEFAULT NULL,
124 x_prev_term_adm_appl_number IN NUMBER DEFAULT NULL,
125 x_prev_term_sequence_number IN NUMBER DEFAULT NULL,
126 x_fut_term_adm_appl_number IN NUMBER DEFAULT NULL,
127 x_fut_term_sequence_number IN NUMBER DEFAULT NULL,
128 x_def_acad_cal_type IN VARCHAR2 DEFAULT NULL,
129 x_def_acad_ci_sequence_num IN NUMBER DEFAULT NULL,
130 x_def_prev_term_adm_appl_num IN NUMBER DEFAULT NULL,
131 x_def_prev_appl_sequence_num IN NUMBER DEFAULT NULL,
132 x_def_term_adm_appl_num IN NUMBER DEFAULT NULL,
133 x_def_appl_sequence_num IN NUMBER DEFAULT NULL,
134 x_appl_inst_status IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
135 x_ais_reason IN VARCHAR2 DEFAULT NULL,
136 x_decline_ofr_reason IN VARCHAR2 DEFAULT NULL
137 );
138
139 procedure LOCK_ROW (
140 X_ROWID in VARCHAR2,
141 x_PERSON_ID IN NUMBER,
142 x_ADMISSION_APPL_NUMBER IN NUMBER,
143 x_NOMINATED_COURSE_CD IN VARCHAR2,
144 x_SEQUENCE_NUMBER IN NUMBER,
145 x_PREDICTED_GPA IN NUMBER,
146 x_ACADEMIC_INDEX IN VARCHAR2,
147 x_ADM_CAL_TYPE IN VARCHAR2,
148 x_APP_FILE_LOCATION IN VARCHAR2,
149 x_ADM_CI_SEQUENCE_NUMBER IN NUMBER,
150 x_COURSE_CD IN VARCHAR2,
151 x_APP_SOURCE_ID IN NUMBER,
152 x_CRV_VERSION_NUMBER IN NUMBER,
153 x_WAITLIST_RANK IN VARCHAR2,
154 x_LOCATION_CD IN VARCHAR2,
155 x_ATTENT_OTHER_INST_CD IN VARCHAR2,
156 x_ATTENDANCE_MODE IN VARCHAR2,
157 x_EDU_GOAL_PRIOR_ENROLL_ID IN NUMBER,
158 x_ATTENDANCE_TYPE IN VARCHAR2,
159 x_DECISION_MAKE_ID IN NUMBER,
160 x_UNIT_SET_CD IN VARCHAR2,
161 x_DECISION_DATE IN DATE,
162 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
163 x_ATTRIBUTE1 IN VARCHAR2,
164 x_ATTRIBUTE2 IN VARCHAR2,
165 x_ATTRIBUTE3 IN VARCHAR2,
166 x_ATTRIBUTE4 IN VARCHAR2,
167 x_ATTRIBUTE5 IN VARCHAR2,
168 x_ATTRIBUTE6 IN VARCHAR2,
169 x_ATTRIBUTE7 IN VARCHAR2,
170 x_ATTRIBUTE8 IN VARCHAR2,
171 x_ATTRIBUTE9 IN VARCHAR2,
172 x_ATTRIBUTE10 IN VARCHAR2,
173 x_ATTRIBUTE11 IN VARCHAR2,
174 x_ATTRIBUTE12 IN VARCHAR2,
175 x_ATTRIBUTE13 IN VARCHAR2,
176 x_ATTRIBUTE14 IN VARCHAR2,
177 x_ATTRIBUTE15 IN VARCHAR2,
178 x_ATTRIBUTE16 IN VARCHAR2,
179 x_ATTRIBUTE17 IN VARCHAR2,
180 x_ATTRIBUTE18 IN VARCHAR2,
181 x_ATTRIBUTE19 IN VARCHAR2,
182 x_ATTRIBUTE20 IN VARCHAR2,
183 x_DECISION_REASON_ID IN NUMBER,
184 x_US_VERSION_NUMBER IN NUMBER,
185 x_DECISION_NOTES IN VARCHAR2,
186 x_PENDING_REASON_ID IN NUMBER,
187 x_PREFERENCE_NUMBER IN NUMBER,
188 x_ADM_DOC_STATUS IN VARCHAR2,
189 x_ADM_ENTRY_QUAL_STATUS IN VARCHAR2,
190 x_DEFICIENCY_IN_PREP IN VARCHAR2,
191 x_LATE_ADM_FEE_STATUS IN VARCHAR2,
192 x_SPL_CONSIDER_COMMENTS IN VARCHAR2,
193 x_APPLY_FOR_FINAID IN VARCHAR2,
194 x_FINAID_APPLY_DATE IN DATE,
195 x_ADM_OUTCOME_STATUS IN VARCHAR2,
196 x_ADM_OTCM_STAT_AUTH_PER_ID IN NUMBER,
197 x_ADM_OUTCOME_STATUS_AUTH_DT IN DATE,
198 x_ADM_OUTCOME_STATUS_REASON IN VARCHAR2,
199 x_OFFER_DT IN DATE,
200 x_OFFER_RESPONSE_DT IN DATE,
201 x_PRPSD_COMMENCEMENT_DT IN DATE,
202 x_ADM_CNDTNL_OFFER_STATUS IN VARCHAR2,
203 x_CNDTNL_OFFER_SATISFIED_DT IN DATE,
204 x_CNDNL_OFR_MUST_BE_STSFD_IND IN VARCHAR2,
205 x_ADM_OFFER_RESP_STATUS IN VARCHAR2,
206 x_ACTUAL_RESPONSE_DT IN DATE,
207 x_ADM_OFFER_DFRMNT_STATUS IN VARCHAR2,
208 x_DEFERRED_ADM_CAL_TYPE IN VARCHAR2,
209 x_DEFERRED_ADM_CI_SEQUENCE_NUM IN NUMBER,
210 x_DEFERRED_TRACKING_ID IN NUMBER,
211 x_ASS_RANK IN NUMBER,
212 x_SECONDARY_ASS_RANK IN NUMBER,
213 X_INTR_ACCEPT_ADVICE_NUM IN NUMBER,
214 x_ASS_TRACKING_ID IN NUMBER,
215 x_FEE_CAT IN VARCHAR2,
216 x_HECS_PAYMENT_OPTION IN VARCHAR2,
217 x_EXPECTED_COMPLETION_YR IN NUMBER,
218 x_EXPECTED_COMPLETION_PERD IN VARCHAR2,
219 x_CORRESPONDENCE_CAT IN VARCHAR2,
220 x_ENROLMENT_CAT IN VARCHAR2,
221 x_FUNDING_SOURCE IN VARCHAR2,
222 x_APPLICANT_ACPTNCE_CNDTN IN VARCHAR2,
223 x_CNDTNL_OFFER_CNDTN IN VARCHAR2,
224 X_SS_APPLICATION_ID IN VARCHAR2,
225 X_SS_PWD IN VARCHAR2,
226 X_AUTHORIZED_DT IN DATE DEFAULT NULL,
227 X_AUTHORIZING_PERS_ID IN NUMBER DEFAULT NULL,
228 x_entry_status IN NUMBER DEFAULT NULL,
229 x_entry_level IN NUMBER DEFAULT NULL,
230 x_sch_apl_to_id IN NUMBER DEFAULT NULL,
231 x_idx_calc_date IN DATE DEFAULT NULL,
232 X_WAITLIST_STATUS IN VARCHAR2 DEFAULT NULL,
233 x_attribute21 IN VARCHAR2 DEFAULT NULL,
234 x_attribute22 IN VARCHAR2 DEFAULT NULL,
235 x_attribute23 IN VARCHAR2 DEFAULT NULL,
236 x_attribute24 IN VARCHAR2 DEFAULT NULL,
237 x_attribute25 IN VARCHAR2 DEFAULT NULL,
238 x_attribute26 IN VARCHAR2 DEFAULT NULL,
239 x_attribute27 IN VARCHAR2 DEFAULT NULL,
240 x_attribute28 IN VARCHAR2 DEFAULT NULL,
241 x_attribute29 IN VARCHAR2 DEFAULT NULL,
242 x_attribute30 IN VARCHAR2 DEFAULT NULL,
243 x_attribute31 IN VARCHAR2 DEFAULT NULL,
244 x_attribute32 IN VARCHAR2 DEFAULT NULL,
245 x_attribute33 IN VARCHAR2 DEFAULT NULL,
246 x_attribute34 IN VARCHAR2 DEFAULT NULL,
247 x_attribute35 IN VARCHAR2 DEFAULT NULL,
248 x_attribute36 IN VARCHAR2 DEFAULT NULL,
249 x_attribute37 IN VARCHAR2 DEFAULT NULL,
250 x_attribute38 IN VARCHAR2 DEFAULT NULL,
251 x_attribute39 IN VARCHAR2 DEFAULT NULL,
252 x_attribute40 IN VARCHAR2 DEFAULT NULL,
253 x_fut_acad_cal_type IN VARCHAR2 DEFAULT NULL,
254 x_fut_acad_ci_sequence_number IN NUMBER DEFAULT NULL,
255 x_fut_adm_cal_type IN VARCHAR2 DEFAULT NULL,
256 x_fut_adm_ci_sequence_number IN NUMBER DEFAULT NULL,
257 x_prev_term_adm_appl_number IN NUMBER DEFAULT NULL,
258 x_prev_term_sequence_number IN NUMBER DEFAULT NULL,
259 x_fut_term_adm_appl_number IN NUMBER DEFAULT NULL,
260 x_fut_term_sequence_number IN NUMBER DEFAULT NULL,
261 x_def_acad_cal_type IN VARCHAR2 DEFAULT NULL,
262 x_def_acad_ci_sequence_num IN NUMBER DEFAULT NULL,
263 x_def_prev_term_adm_appl_num IN NUMBER DEFAULT NULL,
264 x_def_prev_appl_sequence_num IN NUMBER DEFAULT NULL,
265 x_def_term_adm_appl_num IN NUMBER DEFAULT NULL,
266 x_def_appl_sequence_num IN NUMBER DEFAULT NULL,
267 x_appl_inst_status IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
268 x_ais_reason IN VARCHAR2 DEFAULT NULL,
269 x_decline_ofr_reason IN VARCHAR2 DEFAULT NULL
270 );
271
272
273 procedure UPDATE_ROW (
274 X_ROWID in VARCHAR2,
275 x_PERSON_ID IN NUMBER,
276 x_ADMISSION_APPL_NUMBER IN NUMBER,
277 x_NOMINATED_COURSE_CD IN VARCHAR2,
278 x_SEQUENCE_NUMBER IN NUMBER,
279 x_PREDICTED_GPA IN NUMBER,
280 x_ACADEMIC_INDEX IN VARCHAR2,
281 x_ADM_CAL_TYPE IN VARCHAR2,
282 x_APP_FILE_LOCATION IN VARCHAR2,
283 x_ADM_CI_SEQUENCE_NUMBER IN NUMBER,
284 x_COURSE_CD IN VARCHAR2,
285 x_APP_SOURCE_ID IN NUMBER,
286 x_CRV_VERSION_NUMBER IN NUMBER,
287 x_WAITLIST_RANK IN VARCHAR2,
288 x_LOCATION_CD IN VARCHAR2,
289 x_ATTENT_OTHER_INST_CD IN VARCHAR2,
290 x_ATTENDANCE_MODE IN VARCHAR2,
291 x_EDU_GOAL_PRIOR_ENROLL_ID IN NUMBER,
292 x_ATTENDANCE_TYPE IN VARCHAR2,
293 x_DECISION_MAKE_ID IN NUMBER,
294 x_UNIT_SET_CD IN VARCHAR2,
295 x_DECISION_DATE IN DATE,
296 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
297 x_ATTRIBUTE1 IN VARCHAR2,
298 x_ATTRIBUTE2 IN VARCHAR2,
299 x_ATTRIBUTE3 IN VARCHAR2,
300 x_ATTRIBUTE4 IN VARCHAR2,
301 x_ATTRIBUTE5 IN VARCHAR2,
302 x_ATTRIBUTE6 IN VARCHAR2,
303 x_ATTRIBUTE7 IN VARCHAR2,
304 x_ATTRIBUTE8 IN VARCHAR2,
305 x_ATTRIBUTE9 IN VARCHAR2,
306 x_ATTRIBUTE10 IN VARCHAR2,
307 x_ATTRIBUTE11 IN VARCHAR2,
308 x_ATTRIBUTE12 IN VARCHAR2,
309 x_ATTRIBUTE13 IN VARCHAR2,
310 x_ATTRIBUTE14 IN VARCHAR2,
311 x_ATTRIBUTE15 IN VARCHAR2,
312 x_ATTRIBUTE16 IN VARCHAR2,
313 x_ATTRIBUTE17 IN VARCHAR2,
314 x_ATTRIBUTE18 IN VARCHAR2,
315 x_ATTRIBUTE19 IN VARCHAR2,
316 x_ATTRIBUTE20 IN VARCHAR2,
317 x_DECISION_REASON_ID IN NUMBER,
318 x_US_VERSION_NUMBER IN NUMBER,
319 x_DECISION_NOTES IN VARCHAR2,
320 x_PENDING_REASON_ID IN NUMBER,
321 x_PREFERENCE_NUMBER IN NUMBER,
322 x_ADM_DOC_STATUS IN VARCHAR2,
323 x_ADM_ENTRY_QUAL_STATUS IN VARCHAR2,
324 x_DEFICIENCY_IN_PREP IN VARCHAR2,
325 x_LATE_ADM_FEE_STATUS IN VARCHAR2,
326 x_SPL_CONSIDER_COMMENTS IN VARCHAR2,
327 x_APPLY_FOR_FINAID IN VARCHAR2,
328 x_FINAID_APPLY_DATE IN DATE,
329 x_ADM_OUTCOME_STATUS IN VARCHAR2,
330 x_ADM_OTCM_STAT_AUTH_PER_ID IN NUMBER,
331 x_ADM_OUTCOME_STATUS_AUTH_DT IN DATE,
332 x_ADM_OUTCOME_STATUS_REASON IN VARCHAR2,
333 x_OFFER_DT IN DATE,
334 x_OFFER_RESPONSE_DT IN DATE,
335 x_PRPSD_COMMENCEMENT_DT IN DATE,
336 x_ADM_CNDTNL_OFFER_STATUS IN VARCHAR2,
340 x_ACTUAL_RESPONSE_DT IN DATE,
337 x_CNDTNL_OFFER_SATISFIED_DT IN DATE,
338 x_CNDNL_OFR_MUST_BE_STSFD_IND IN VARCHAR2,
339 x_ADM_OFFER_RESP_STATUS IN VARCHAR2,
341 x_ADM_OFFER_DFRMNT_STATUS IN VARCHAR2,
342 x_DEFERRED_ADM_CAL_TYPE IN VARCHAR2,
343 x_DEFERRED_ADM_CI_SEQUENCE_NUM IN NUMBER,
344 x_DEFERRED_TRACKING_ID IN NUMBER,
345 x_ASS_RANK IN NUMBER,
346 x_SECONDARY_ASS_RANK IN NUMBER,
347 X_INTR_ACCEPT_ADVICE_NUM IN NUMBER,
348 x_ASS_TRACKING_ID IN NUMBER,
349 x_FEE_CAT IN VARCHAR2,
350 x_HECS_PAYMENT_OPTION IN VARCHAR2,
351 x_EXPECTED_COMPLETION_YR IN NUMBER,
352 x_EXPECTED_COMPLETION_PERD IN VARCHAR2,
353 x_CORRESPONDENCE_CAT IN VARCHAR2,
354 x_ENROLMENT_CAT IN VARCHAR2,
355 x_FUNDING_SOURCE IN VARCHAR2,
356 x_APPLICANT_ACPTNCE_CNDTN IN VARCHAR2,
357 x_CNDTNL_OFFER_CNDTN IN VARCHAR2,
358 X_MODE in VARCHAR2 default 'R',
359 X_SS_APPLICATION_ID IN VARCHAR2,
360 X_SS_PWD IN VARCHAR2 ,
361 X_AUTHORIZED_DT IN DATE DEFAULT NULL,
362 X_AUTHORIZING_PERS_ID IN NUMBER DEFAULT NULL,
363 x_entry_status IN NUMBER DEFAULT NULL,
364 x_entry_level IN NUMBER DEFAULT NULL,
365 x_sch_apl_to_id IN NUMBER DEFAULT NULL,
366 x_idx_calc_date IN DATE DEFAULT NULL,
367 X_WAITLIST_STATUS IN VARCHAR2 DEFAULT NULL,
368 x_attribute21 IN VARCHAR2 DEFAULT NULL,
369 x_attribute22 IN VARCHAR2 DEFAULT NULL,
370 x_attribute23 IN VARCHAR2 DEFAULT NULL,
371 x_attribute24 IN VARCHAR2 DEFAULT NULL,
372 x_attribute25 IN VARCHAR2 DEFAULT NULL,
373 x_attribute26 IN VARCHAR2 DEFAULT NULL,
374 x_attribute27 IN VARCHAR2 DEFAULT NULL,
375 x_attribute28 IN VARCHAR2 DEFAULT NULL,
376 x_attribute29 IN VARCHAR2 DEFAULT NULL,
377 x_attribute30 IN VARCHAR2 DEFAULT NULL,
378 x_attribute31 IN VARCHAR2 DEFAULT NULL,
379 x_attribute32 IN VARCHAR2 DEFAULT NULL,
380 x_attribute33 IN VARCHAR2 DEFAULT NULL,
381 x_attribute34 IN VARCHAR2 DEFAULT NULL,
382 x_attribute35 IN VARCHAR2 DEFAULT NULL,
383 x_attribute36 IN VARCHAR2 DEFAULT NULL,
384 x_attribute37 IN VARCHAR2 DEFAULT NULL,
385 x_attribute38 IN VARCHAR2 DEFAULT NULL,
386 x_attribute39 IN VARCHAR2 DEFAULT NULL,
387 x_attribute40 IN VARCHAR2 DEFAULT NULL,
388 x_fut_acad_cal_type IN VARCHAR2 DEFAULT NULL,
389 x_fut_acad_ci_sequence_number IN NUMBER DEFAULT NULL,
390 x_fut_adm_cal_type IN VARCHAR2 DEFAULT NULL,
391 x_fut_adm_ci_sequence_number IN NUMBER DEFAULT NULL,
392 x_prev_term_adm_appl_number IN NUMBER DEFAULT NULL,
393 x_prev_term_sequence_number IN NUMBER DEFAULT NULL,
394 x_fut_term_adm_appl_number IN NUMBER DEFAULT NULL,
395 x_fut_term_sequence_number IN NUMBER DEFAULT NULL,
396 x_def_acad_cal_type IN VARCHAR2 DEFAULT NULL,
397 x_def_acad_ci_sequence_num IN NUMBER DEFAULT NULL,
398 x_def_prev_term_adm_appl_num IN NUMBER DEFAULT NULL,
399 x_def_prev_appl_sequence_num IN NUMBER DEFAULT NULL,
400 x_def_term_adm_appl_num IN NUMBER DEFAULT NULL,
401 x_def_appl_sequence_num IN NUMBER DEFAULT NULL,
402 x_appl_inst_status IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
403 x_ais_reason IN VARCHAR2 DEFAULT NULL,
404 x_decline_ofr_reason IN VARCHAR2 DEFAULT NULL
405 );
406
407 procedure ADD_ROW (
408 X_ROWID in out NOCOPY VARCHAR2,
409 x_ORG_ID in NUMBER,
410 x_PERSON_ID IN NUMBER,
411 x_ADMISSION_APPL_NUMBER IN NUMBER,
412 x_NOMINATED_COURSE_CD IN VARCHAR2,
413 x_SEQUENCE_NUMBER IN NUMBER,
414 x_PREDICTED_GPA IN NUMBER,
415 x_ACADEMIC_INDEX IN VARCHAR2,
416 x_ADM_CAL_TYPE IN VARCHAR2,
417 x_APP_FILE_LOCATION IN VARCHAR2,
418 x_ADM_CI_SEQUENCE_NUMBER IN NUMBER,
419 x_COURSE_CD IN VARCHAR2,
420 x_APP_SOURCE_ID IN NUMBER,
421 x_CRV_VERSION_NUMBER IN NUMBER,
422 x_WAITLIST_RANK IN VARCHAR2,
423 x_LOCATION_CD IN VARCHAR2,
424 x_ATTENT_OTHER_INST_CD IN VARCHAR2,
425 x_ATTENDANCE_MODE IN VARCHAR2,
426 x_EDU_GOAL_PRIOR_ENROLL_ID IN NUMBER,
427 x_ATTENDANCE_TYPE IN VARCHAR2,
428 x_DECISION_MAKE_ID IN NUMBER,
429 x_UNIT_SET_CD IN VARCHAR2,
430 x_DECISION_DATE IN DATE,
431 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
432 x_ATTRIBUTE1 IN VARCHAR2,
433 x_ATTRIBUTE2 IN VARCHAR2,
434 x_ATTRIBUTE3 IN VARCHAR2,
435 x_ATTRIBUTE4 IN VARCHAR2,
436 x_ATTRIBUTE5 IN VARCHAR2,
437 x_ATTRIBUTE6 IN VARCHAR2,
438 x_ATTRIBUTE7 IN VARCHAR2,
439 x_ATTRIBUTE8 IN VARCHAR2,
440 x_ATTRIBUTE9 IN VARCHAR2,
441 x_ATTRIBUTE10 IN VARCHAR2,
442 x_ATTRIBUTE11 IN VARCHAR2,
443 x_ATTRIBUTE12 IN VARCHAR2,
444 x_ATTRIBUTE13 IN VARCHAR2,
445 x_ATTRIBUTE14 IN VARCHAR2,
446 x_ATTRIBUTE15 IN VARCHAR2,
447 x_ATTRIBUTE16 IN VARCHAR2,
448 x_ATTRIBUTE17 IN VARCHAR2,
449 x_ATTRIBUTE18 IN VARCHAR2,
450 x_ATTRIBUTE19 IN VARCHAR2,
451 x_ATTRIBUTE20 IN VARCHAR2,
452 x_DECISION_REASON_ID IN NUMBER,
453 x_US_VERSION_NUMBER IN NUMBER,
454 x_DECISION_NOTES IN VARCHAR2,
455 x_PENDING_REASON_ID IN NUMBER,
459 x_DEFICIENCY_IN_PREP IN VARCHAR2,
456 x_PREFERENCE_NUMBER IN NUMBER,
457 x_ADM_DOC_STATUS IN VARCHAR2,
458 x_ADM_ENTRY_QUAL_STATUS IN VARCHAR2,
460 x_LATE_ADM_FEE_STATUS IN VARCHAR2,
461 x_SPL_CONSIDER_COMMENTS IN VARCHAR2,
462 x_APPLY_FOR_FINAID IN VARCHAR2,
463 x_FINAID_APPLY_DATE IN DATE,
464 x_ADM_OUTCOME_STATUS IN VARCHAR2,
465 x_ADM_OTCM_STAT_AUTH_PER_ID IN NUMBER,
466 x_ADM_OUTCOME_STATUS_AUTH_DT IN DATE,
467 x_ADM_OUTCOME_STATUS_REASON IN VARCHAR2,
468 x_OFFER_DT IN DATE,
469 x_OFFER_RESPONSE_DT IN DATE,
470 x_PRPSD_COMMENCEMENT_DT IN DATE,
471 x_ADM_CNDTNL_OFFER_STATUS IN VARCHAR2,
472 x_CNDTNL_OFFER_SATISFIED_DT IN DATE,
473 x_CNDNL_OFR_MUST_BE_STSFD_IND IN VARCHAR2,
474 x_ADM_OFFER_RESP_STATUS IN VARCHAR2,
475 x_ACTUAL_RESPONSE_DT IN DATE,
476 x_ADM_OFFER_DFRMNT_STATUS IN VARCHAR2,
477 x_DEFERRED_ADM_CAL_TYPE IN VARCHAR2,
478 x_DEFERRED_ADM_CI_SEQUENCE_NUM IN NUMBER,
479 x_DEFERRED_TRACKING_ID IN NUMBER,
480 x_ASS_RANK IN NUMBER,
481 x_SECONDARY_ASS_RANK IN NUMBER,
482 X_INTR_ACCEPT_ADVICE_NUM IN NUMBER,
483 x_ASS_TRACKING_ID IN NUMBER,
484 x_FEE_CAT IN VARCHAR2,
485 x_HECS_PAYMENT_OPTION IN VARCHAR2,
486 x_EXPECTED_COMPLETION_YR IN NUMBER,
487 x_EXPECTED_COMPLETION_PERD IN VARCHAR2,
488 x_CORRESPONDENCE_CAT IN VARCHAR2,
489 x_ENROLMENT_CAT IN VARCHAR2,
490 x_FUNDING_SOURCE IN VARCHAR2,
491 x_APPLICANT_ACPTNCE_CNDTN IN VARCHAR2,
492 x_CNDTNL_OFFER_CNDTN IN VARCHAR2,
493 X_MODE in VARCHAR2 default 'R',
494 X_SS_APPLICATION_ID IN VARCHAR2,
495 X_SS_PWD IN VARCHAR2 ,
496 X_AUTHORIZED_DT IN DATE DEFAULT NULL,
497 X_AUTHORIZING_PERS_ID IN NUMBER DEFAULT NULL,
498 x_entry_status IN NUMBER DEFAULT NULL,
499 x_entry_level IN NUMBER DEFAULT NULL,
500 x_sch_apl_to_id IN NUMBER DEFAULT NULL,
501 x_idx_calc_date IN DATE DEFAULT NULL,
502 X_WAITLIST_STATUS IN VARCHAR2 DEFAULT NULL,
503 x_attribute21 IN VARCHAR2 DEFAULT NULL,
504 x_attribute22 IN VARCHAR2 DEFAULT NULL,
505 x_attribute23 IN VARCHAR2 DEFAULT NULL,
506 x_attribute24 IN VARCHAR2 DEFAULT NULL,
507 x_attribute25 IN VARCHAR2 DEFAULT NULL,
508 x_attribute26 IN VARCHAR2 DEFAULT NULL,
509 x_attribute27 IN VARCHAR2 DEFAULT NULL,
510 x_attribute28 IN VARCHAR2 DEFAULT NULL,
511 x_attribute29 IN VARCHAR2 DEFAULT NULL,
512 x_attribute30 IN VARCHAR2 DEFAULT NULL,
513 x_attribute31 IN VARCHAR2 DEFAULT NULL,
514 x_attribute32 IN VARCHAR2 DEFAULT NULL,
515 x_attribute33 IN VARCHAR2 DEFAULT NULL,
516 x_attribute34 IN VARCHAR2 DEFAULT NULL,
517 x_attribute35 IN VARCHAR2 DEFAULT NULL,
518 x_attribute36 IN VARCHAR2 DEFAULT NULL,
519 x_attribute37 IN VARCHAR2 DEFAULT NULL,
520 x_attribute38 IN VARCHAR2 DEFAULT NULL,
521 x_attribute39 IN VARCHAR2 DEFAULT NULL,
522 x_attribute40 IN VARCHAR2 DEFAULT NULL,
523 x_fut_acad_cal_type IN VARCHAR2 DEFAULT NULL,
524 x_fut_acad_ci_sequence_number IN NUMBER DEFAULT NULL,
525 x_fut_adm_cal_type IN VARCHAR2 DEFAULT NULL,
526 x_fut_adm_ci_sequence_number IN NUMBER DEFAULT NULL,
527 x_prev_term_adm_appl_number IN NUMBER DEFAULT NULL,
528 x_prev_term_sequence_number IN NUMBER DEFAULT NULL,
529 x_fut_term_adm_appl_number IN NUMBER DEFAULT NULL,
530 x_fut_term_sequence_number IN NUMBER DEFAULT NULL,
531 x_def_acad_cal_type IN VARCHAR2 DEFAULT NULL,
532 x_def_acad_ci_sequence_num IN NUMBER DEFAULT NULL,
533 x_def_prev_term_adm_appl_num IN NUMBER DEFAULT NULL,
534 x_def_prev_appl_sequence_num IN NUMBER DEFAULT NULL,
535 x_def_term_adm_appl_num IN NUMBER DEFAULT NULL,
536 x_def_appl_sequence_num IN NUMBER DEFAULT NULL,
537 x_appl_inst_status IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
538 x_ais_reason IN VARCHAR2 DEFAULT NULL,
539 x_decline_ofr_reason IN VARCHAR2 DEFAULT NULL
540 ) ;
541
542 procedure DELETE_ROW (
543 X_ROWID in VARCHAR2,
544 x_mode IN VARCHAR2 DEFAULT 'R'
545 ) ;
546
547 FUNCTION Get_PK_For_Validation (
548 x_person_id IN NUMBER,
549 x_admission_appl_number IN NUMBER,
550 x_nominated_course_cd IN VARCHAR2,
551 x_sequence_number IN NUMBER
552 ) RETURN BOOLEAN ;
553
554 -- Added for Locking Issue adcr061 Bug 2760811
555 -- This procedure is used if we dont need to
556 -- lock the record if the child entites are getting created
557
558
559 FUNCTION Get_PKNolock_For_Validation (
560 x_person_id IN NUMBER,
561 x_admission_appl_number IN NUMBER,
562 x_nominated_course_cd IN VARCHAR2,
563 x_sequence_number IN NUMBER
564 ) RETURN BOOLEAN ;
565
566
567 PROCEDURE Get_FK_Igs_Ad_Code_Classes (
568 x_code_id IN NUMBER
569 );
570
571 PROCEDURE Get_FK_Igs_Or_Institution (
572 x_institution_cd IN VARCHAR2
573 );
574
575 PROCEDURE GET_FK_IGS_EN_ATD_MODE (
576 x_attendance_mode IN VARCHAR2
577 );
578
579 PROCEDURE GET_FK_IGS_AD_OFRDFRMT_STAT (
580 x_adm_offer_dfrmnt_status IN VARCHAR2
581 );
582
586
583 PROCEDURE GET_FK_IGS_AD_OFR_RESP_STAT (
584 x_adm_offer_resp_status IN VARCHAR2
585 );
587 PROCEDURE GET_FK_IGS_AD_OU_STAT (
588 x_adm_outcome_status IN VARCHAR2
589 );
590
591 PROCEDURE GET_FK_IGS_EN_ATD_TYPE (
592 x_attendance_type IN VARCHAR2
593 );
594
595 PROCEDURE GET_FK_IGS_CO_CAT (
596 x_correspondence_cat IN VARCHAR2
597 );
598
599 PROCEDURE GET_FK_IGS_CA_INST (
600 x_cal_type IN VARCHAR2,
601 x_sequence_number IN NUMBER
602 );
603
604 PROCEDURE GET_FK_IGS_PS_COURSE (
605 x_course_cd IN VARCHAR2
606 );
607
608 PROCEDURE GET_FK_IGS_PS_VER (
609 x_course_cd IN VARCHAR2,
610 x_version_number IN NUMBER
611 );
612
613 PROCEDURE GET_FK_IGS_EN_ENROLMENT_CAT (
614 x_enrolment_cat IN VARCHAR2
615 );
616
617 PROCEDURE GET_FK_IGS_FI_FEE_CAT (
618 x_fee_cat IN VARCHAR2
619 );
620
621 PROCEDURE GET_FK_IGS_FI_FUND_SRC (
622 x_funding_source IN VARCHAR2
623 );
624
625 PROCEDURE GET_FK_IGS_FI_HECS_PAY_OPTN (
626 x_hecs_payment_option IN VARCHAR2
627 );
628
629 PROCEDURE GET_FK_IGS_AD_LOCATION (
630 x_location_cd IN VARCHAR2
631 );
632
633 PROCEDURE GET_FK_IGS_PE_PERSON (
634 x_person_id IN NUMBER
635 );
636
637 PROCEDURE GET_FK_IGS_TR_ITEM (
638 x_tracking_id IN NUMBER
639 );
640
641 PROCEDURE GET_FK_IGS_EN_UNIT_SET (
642 x_unit_set_cd IN VARCHAR2,
643 x_version_number IN NUMBER
644 );
645
646 PROCEDURE GET_FK_IGS_AD_APPL (
647 x_person_id IN NUMBER,
648 x_admission_appl_number IN NUMBER
649 );
650
651 PROCEDURE GET_FK_IGS_AD_PS_APPL (
652 x_person_id IN NUMBER,
653 x_admission_appl_number IN NUMBER,
654 x_nominated_course_cd IN VARCHAR2
655 );
656
657 PROCEDURE GET_FK_IGS_AD_CNDNL_OFRSTAT (
658 x_adm_cndtnl_offer_status IN VARCHAR2
659 );
660
661 PROCEDURE GET_FK_IGS_AD_DOC_STAT (
662 x_adm_doc_status IN VARCHAR2
663 );
664
665 PROCEDURE GET_FK_IGS_AD_ENT_QF_STAT (
666 x_adm_entry_qual_status IN VARCHAR2
667 );
668
669 PROCEDURE GET_FK_IGS_AD_FEE_STAT (
670 x_adm_fee_status IN VARCHAR2
671 );
672
673 PROCEDURE GET_FK_IGS_AD_SCHL_APLY_TO (
674 x_sch_apl_to_id IN NUMBER
675 );
676
677 PROCEDURE CHECK_CONSTRAINTS(
678 column_name IN VARCHAR2 DEFAULT NULL,
679 column_value IN VARCHAR2 DEFAULT NULL
680 );
681
682 PROCEDURE Before_DML (
683 p_action IN VARCHAR2,
684 x_rowid IN VARCHAR2 DEFAULT NULL,
685 x_org_id IN NUMBER DEFAULT NULL,
686 x_person_id IN NUMBER DEFAULT NULL,
687 x_admission_appl_number IN NUMBER DEFAULT NULL,
688 x_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
689 x_sequence_number IN NUMBER DEFAULT NULL,
690 x_predicted_gpa IN NUMBER DEFAULT NULL,
691 x_academic_index IN VARCHAR2 DEFAULT NULL,
692 x_adm_cal_type IN VARCHAR2 DEFAULT NULL,
693 x_app_file_location IN VARCHAR2 DEFAULT NULL,
694 x_adm_ci_sequence_number IN NUMBER DEFAULT NULL,
695 x_course_cd IN VARCHAR2 DEFAULT NULL,
696 x_app_source_id IN NUMBER DEFAULT NULL,
697 x_crv_version_number IN NUMBER DEFAULT NULL,
698 x_waitlist_rank IN VARCHAR2 DEFAULT NULL,
699 x_location_cd IN VARCHAR2 DEFAULT NULL,
700 x_attent_other_inst_cd IN VARCHAR2 DEFAULT NULL,
701 x_attendance_mode IN VARCHAR2 DEFAULT NULL,
702 x_edu_goal_prior_enroll_id IN NUMBER DEFAULT NULL,
703 x_attendance_type IN VARCHAR2 DEFAULT NULL,
704 x_decision_make_id IN NUMBER DEFAULT NULL,
705 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
706 x_decision_date IN DATE DEFAULT NULL,
707 x_attribute_category IN VARCHAR2 DEFAULT NULL,
708 x_attribute1 IN VARCHAR2 DEFAULT NULL,
709 x_attribute2 IN VARCHAR2 DEFAULT NULL,
710 x_attribute3 IN VARCHAR2 DEFAULT NULL,
711 x_attribute4 IN VARCHAR2 DEFAULT NULL,
712 x_attribute5 IN VARCHAR2 DEFAULT NULL,
713 x_attribute6 IN VARCHAR2 DEFAULT NULL,
714 x_attribute7 IN VARCHAR2 DEFAULT NULL,
715 x_attribute8 IN VARCHAR2 DEFAULT NULL,
716 x_attribute9 IN VARCHAR2 DEFAULT NULL,
717 x_attribute10 IN VARCHAR2 DEFAULT NULL,
718 x_attribute11 IN VARCHAR2 DEFAULT NULL,
719 x_attribute12 IN VARCHAR2 DEFAULT NULL,
720 x_attribute13 IN VARCHAR2 DEFAULT NULL,
721 x_attribute14 IN VARCHAR2 DEFAULT NULL,
722 x_attribute15 IN VARCHAR2 DEFAULT NULL,
723 x_attribute16 IN VARCHAR2 DEFAULT NULL,
724 x_attribute17 IN VARCHAR2 DEFAULT NULL,
725 x_attribute18 IN VARCHAR2 DEFAULT NULL,
726 x_attribute19 IN VARCHAR2 DEFAULT NULL,
727 x_attribute20 IN VARCHAR2 DEFAULT NULL,
728 x_decision_reason_id IN NUMBER DEFAULT NULL,
729 x_us_version_number IN NUMBER DEFAULT NULL,
730 x_decision_notes IN VARCHAR2 DEFAULT NULL,
731 x_pending_reason_id IN NUMBER DEFAULT NULL,
732 x_preference_number IN NUMBER DEFAULT NULL,
733 x_adm_doc_status IN VARCHAR2 DEFAULT NULL,
734 x_adm_entry_qual_status IN VARCHAR2 DEFAULT NULL,
735 x_deficiency_in_prep IN VARCHAR2 DEFAULT NULL,
739 x_finaid_apply_date IN DATE DEFAULT NULL,
736 x_late_adm_fee_status IN VARCHAR2 DEFAULT NULL,
737 x_spl_consider_comments IN VARCHAR2 DEFAULT NULL,
738 x_apply_for_finaid IN VARCHAR2 DEFAULT NULL,
740 x_adm_outcome_status IN VARCHAR2 DEFAULT NULL,
741 x_adm_otcm_STAT_AUTH_PER_id IN NUMBER DEFAULT NULL,
742 x_adm_outcome_status_auth_dt IN DATE DEFAULT NULL,
743 x_adm_outcome_status_reason IN VARCHAR2 DEFAULT NULL,
744 x_offer_dt IN DATE DEFAULT NULL,
745 x_offer_response_dt IN DATE DEFAULT NULL,
746 x_prpsd_commencement_dt IN DATE DEFAULT NULL,
747 x_adm_cndtnl_offer_status IN VARCHAR2 DEFAULT NULL,
748 x_cndtnl_offer_satisfied_dt IN DATE DEFAULT NULL,
749 x_CNDNL_OFR_must_be_stsfd_ind IN VARCHAR2 DEFAULT NULL,
750 x_adm_offer_resp_status IN VARCHAR2 DEFAULT NULL,
751 x_actual_response_dt IN DATE DEFAULT NULL,
752 x_adm_offer_dfrmnt_status IN VARCHAR2 DEFAULT NULL,
753 x_deferred_adm_cal_type IN VARCHAR2 DEFAULT NULL,
754 x_deferred_adm_ci_sequence_num IN NUMBER DEFAULT NULL,
755 x_deferred_tracking_id IN NUMBER DEFAULT NULL,
756 x_ass_rank IN NUMBER DEFAULT NULL,
757 x_secondary_ass_rank IN NUMBER DEFAULT NULL,
758 X_INTR_ACCEPT_advice_num IN NUMBER DEFAULT NULL,
759 x_ass_tracking_id IN NUMBER DEFAULT NULL,
760 x_fee_cat IN VARCHAR2 DEFAULT NULL,
761 x_hecs_payment_option IN VARCHAR2 DEFAULT NULL,
762 x_expected_completion_yr IN NUMBER DEFAULT NULL,
763 x_expected_completion_perd IN VARCHAR2 DEFAULT NULL,
764 x_correspondence_cat IN VARCHAR2 DEFAULT NULL,
765 x_enrolment_cat IN VARCHAR2 DEFAULT NULL,
766 x_funding_source IN VARCHAR2 DEFAULT NULL,
767 x_applicant_acptnce_cndtn IN VARCHAR2 DEFAULT NULL,
768 x_cndtnl_offer_cndtn IN VARCHAR2 DEFAULT NULL,
769 x_creation_date IN DATE DEFAULT NULL,
770 x_created_by IN NUMBER DEFAULT NULL,
771 x_last_update_date IN DATE DEFAULT NULL,
772 x_last_updated_by IN NUMBER DEFAULT NULL,
773 x_last_update_login IN NUMBER DEFAULT NULL,
774 X_SS_APPLICATION_ID IN VARCHAR2 DEFAULT NULL,
775 X_SS_PWD IN VARCHAR2 DEFAULT NULL,
776 X_AUTHORIZED_DT IN DATE DEFAULT NULL,
777 X_AUTHORIZING_PERS_ID IN NUMBER DEFAULT NULL,
778 x_entry_status IN NUMBER DEFAULT NULL,
779 x_entry_level IN NUMBER DEFAULT NULL,
780 x_sch_apl_to_id IN NUMBER DEFAULT NULL,
781 x_idx_calc_date IN DATE DEFAULT NULL,
782 X_WAITLIST_STATUS IN VARCHAR2 DEFAULT NULL,
783 x_attribute21 IN VARCHAR2 DEFAULT NULL,
784 x_attribute22 IN VARCHAR2 DEFAULT NULL,
785 x_attribute23 IN VARCHAR2 DEFAULT NULL,
786 x_attribute24 IN VARCHAR2 DEFAULT NULL,
787 x_attribute25 IN VARCHAR2 DEFAULT NULL,
788 x_attribute26 IN VARCHAR2 DEFAULT NULL,
789 x_attribute27 IN VARCHAR2 DEFAULT NULL,
790 x_attribute28 IN VARCHAR2 DEFAULT NULL,
791 x_attribute29 IN VARCHAR2 DEFAULT NULL,
792 x_attribute30 IN VARCHAR2 DEFAULT NULL,
793 x_attribute31 IN VARCHAR2 DEFAULT NULL,
794 x_attribute32 IN VARCHAR2 DEFAULT NULL,
795 x_attribute33 IN VARCHAR2 DEFAULT NULL,
796 x_attribute34 IN VARCHAR2 DEFAULT NULL,
797 x_attribute35 IN VARCHAR2 DEFAULT NULL,
798 x_attribute36 IN VARCHAR2 DEFAULT NULL,
799 x_attribute37 IN VARCHAR2 DEFAULT NULL,
800 x_attribute38 IN VARCHAR2 DEFAULT NULL,
801 x_attribute39 IN VARCHAR2 DEFAULT NULL,
802 x_attribute40 IN VARCHAR2 DEFAULT NULL,
803 x_fut_acad_cal_type IN VARCHAR2 DEFAULT NULL,
804 x_fut_acad_ci_sequence_number IN NUMBER DEFAULT NULL,
805 x_fut_adm_cal_type IN VARCHAR2 DEFAULT NULL,
806 x_fut_adm_ci_sequence_number IN NUMBER DEFAULT NULL,
807 x_prev_term_adm_appl_number IN NUMBER DEFAULT NULL,
808 x_prev_term_sequence_number IN NUMBER DEFAULT NULL,
809 x_fut_term_adm_appl_number IN NUMBER DEFAULT NULL,
810 x_fut_term_sequence_number IN NUMBER DEFAULT NULL,
811 x_def_acad_cal_type IN VARCHAR2 DEFAULT NULL,
812 x_def_acad_ci_sequence_num IN NUMBER DEFAULT NULL,
813 x_def_prev_term_adm_appl_num IN NUMBER DEFAULT NULL,
814 x_def_prev_appl_sequence_num IN NUMBER DEFAULT NULL,
815 x_def_term_adm_appl_num IN NUMBER DEFAULT NULL,
816 x_def_appl_sequence_num IN NUMBER DEFAULT NULL,
817 x_appl_inst_status IN VARCHAR2 DEFAULT NULL,
818 x_ais_reason IN VARCHAR2 DEFAULT NULL,
819 x_decline_ofr_reason IN VARCHAR2 DEFAULT NULL
820 );
821
822 PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
823 p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
824 p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
825 p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
826 p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
827 p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
828 p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
829 p_person_id igs_pe_person.person_id%TYPE,
830 p_condition_category IN igs_uc_offer_conds.condition_category%TYPE,
831 p_condition_name IN igs_uc_offer_conds.condition_name%TYPE,
832 p_uc_tran_id OUT NOCOPY NUMBER );
833
834 FUNCTION check_non_updateable_list RETURN BOOLEAN; --arvsrini igsm
835
836 END igs_ad_ps_appl_inst_pkg;
[Home] [Help]