1 package IGS_AD_PS_APLINSTHST_PKG as
2 /* $Header: IGSAI19S.pls 120.2 2005/09/21 00:32:23 appldev ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_ORG_ID in NUMBER,
6 X_PERSON_ID in NUMBER,
7 X_ADMISSION_APPL_NUMBER in NUMBER,
8 X_NOMINATED_COURSE_CD in VARCHAR2,
9 X_SEQUENCE_NUMBER in NUMBER,
10 X_HIST_START_DT in DATE,
11 X_APPLICANT_ACPTNCE_CNDTN in VARCHAR2,
12 X_CNDTNL_OFFER_CNDTN in VARCHAR2,
13 X_HIST_END_DT in DATE,
14 X_HIST_WHO in NUMBER,
15 X_HIST_OFFER_ROUND_NUMBER in NUMBER,
16 X_ADM_CAL_TYPE in VARCHAR2,
17 X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
18 X_COURSE_CD in VARCHAR2,
19 X_CRV_VERSION_NUMBER in NUMBER,
20 X_LOCATION_CD in VARCHAR2,
21 X_ATTENDANCE_MODE in VARCHAR2,
22 X_ATTENDANCE_TYPE in VARCHAR2,
23 X_UNIT_SET_CD in VARCHAR2,
24 X_US_VERSION_NUMBER in NUMBER,
25 X_PREFERENCE_NUMBER in NUMBER,
26 X_ADM_DOC_STATUS in VARCHAR2,
27 X_ADM_ENTRY_QUAL_STATUS in VARCHAR2,
28 X_LATE_ADM_FEE_STATUS in VARCHAR2,
29 X_ADM_OUTCOME_STATUS in VARCHAR2,
30 X_ADM_OTCM_STATUS_AUTH_PER_ID in NUMBER,
31 X_ADM_OUTCOME_STATUS_AUTH_DT in DATE,
32 X_ADM_OUTCOME_STATUS_REASON in VARCHAR2,
33 X_OFFER_DT in DATE,
34 X_OFFER_RESPONSE_DT in DATE,
35 X_PRPSD_COMMENCEMENT_DT in DATE,
36 X_ADM_CNDTNL_OFFER_STATUS in VARCHAR2,
37 X_CNDTNL_OFFER_SATISFIED_DT in DATE,
38 X_CNDTNL_OFR_MUST_BE_STSFD_IND in VARCHAR2,
39 X_ADM_OFFER_RESP_STATUS in VARCHAR2,
40 X_ACTUAL_RESPONSE_DT in DATE,
41 X_ADM_OFFER_DFRMNT_STATUS in VARCHAR2,
42 X_DEFERRED_ADM_CAL_TYPE in VARCHAR2,
43 X_DEFERRED_ADM_CI_SEQUENCE_NUM in NUMBER,
44 X_DEFERRED_TRACKING_ID in NUMBER,
45 X_ASS_RANK in NUMBER,
46 X_SECONDARY_ASS_RANK in NUMBER,
47 X_INTRNTNL_ACCEPT_ADVICE_NUM in NUMBER,
48 X_ASS_TRACKING_ID in NUMBER,
49 X_FEE_CAT in VARCHAR2,
50 X_HECS_PAYMENT_OPTION in VARCHAR2,
51 X_EXPECTED_COMPLETION_YR in NUMBER,
52 X_EXPECTED_COMPLETION_PERD in VARCHAR2,
53 X_CORRESPONDENCE_CAT in VARCHAR2,
54 X_ENROLMENT_CAT in VARCHAR2,
55 X_FUNDING_SOURCE in VARCHAR2,
56 X_MODE in VARCHAR2 default 'R',
57 X_APPL_INST_STATUS IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
58 X_DECISION_DATE DATE DEFAULT NULL, -- begin APADEGAL adtd001 igs.m
59 X_DECISION_MAKE_ID NUMBER DEFAULT NULL,
60 X_DECISION_REASON_ID NUMBER DEFAULT NULL,
61 X_PENDING_REASON_ID NUMBER DEFAULT NULL,
62 X_WAITLIST_STATUS VARCHAR2 DEFAULT NULL,
63 X_WAITLIST_RANK VARCHAR2 DEFAULT NULL,
64 X_FUTURE_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
65 X_FUTURE_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
66 X_FUTURE_ADM_CAL_TYPE VARCHAR2 DEFAULT NULL,
67 X_FUTURE_ADM_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
68 X_DEF_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
69 X_DEF_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
70 X_RECONSIDER_FLAG VARCHAR2 DEFAULT NULL,
71 X_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
72 );
73 procedure LOCK_ROW (
74 X_ROWID in VARCHAR2,
75 X_PERSON_ID in NUMBER,
76 X_ADMISSION_APPL_NUMBER in NUMBER,
77 X_NOMINATED_COURSE_CD in VARCHAR2,
78 X_SEQUENCE_NUMBER in NUMBER,
79 X_HIST_START_DT in DATE,
80 X_APPLICANT_ACPTNCE_CNDTN in VARCHAR2,
81 X_CNDTNL_OFFER_CNDTN in VARCHAR2,
82 X_HIST_END_DT in DATE,
83 X_HIST_WHO in NUMBER,
84 X_HIST_OFFER_ROUND_NUMBER in NUMBER,
85 X_ADM_CAL_TYPE in VARCHAR2,
86 X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
87 X_COURSE_CD in VARCHAR2,
88 X_CRV_VERSION_NUMBER in NUMBER,
89 X_LOCATION_CD in VARCHAR2,
90 X_ATTENDANCE_MODE in VARCHAR2,
91 X_ATTENDANCE_TYPE in VARCHAR2,
92 X_UNIT_SET_CD in VARCHAR2,
93 X_US_VERSION_NUMBER in NUMBER,
94 X_PREFERENCE_NUMBER in NUMBER,
95 X_ADM_DOC_STATUS in VARCHAR2,
96 X_ADM_ENTRY_QUAL_STATUS in VARCHAR2,
97 X_LATE_ADM_FEE_STATUS in VARCHAR2,
98 X_ADM_OUTCOME_STATUS in VARCHAR2,
99 X_ADM_OTCM_STATUS_AUTH_PER_ID in NUMBER,
100 X_ADM_OUTCOME_STATUS_AUTH_DT in DATE,
101 X_ADM_OUTCOME_STATUS_REASON in VARCHAR2,
102 X_OFFER_DT in DATE,
103 X_OFFER_RESPONSE_DT in DATE,
104 X_PRPSD_COMMENCEMENT_DT in DATE,
105 X_ADM_CNDTNL_OFFER_STATUS in VARCHAR2,
106 X_CNDTNL_OFFER_SATISFIED_DT in DATE,
107 X_CNDTNL_OFR_MUST_BE_STSFD_IND in VARCHAR2,
108 X_ADM_OFFER_RESP_STATUS in VARCHAR2,
109 X_ACTUAL_RESPONSE_DT in DATE,
110 X_ADM_OFFER_DFRMNT_STATUS in VARCHAR2,
111 X_DEFERRED_ADM_CAL_TYPE in VARCHAR2,
112 X_DEFERRED_ADM_CI_SEQUENCE_NUM in NUMBER,
113 X_DEFERRED_TRACKING_ID in NUMBER,
114 X_ASS_RANK in NUMBER,
115 X_SECONDARY_ASS_RANK in NUMBER,
116 X_INTRNTNL_ACCEPT_ADVICE_NUM in NUMBER,
117 X_ASS_TRACKING_ID in NUMBER,
118 X_FEE_CAT in VARCHAR2,
119 X_HECS_PAYMENT_OPTION in VARCHAR2,
120 X_EXPECTED_COMPLETION_YR in NUMBER,
121 X_EXPECTED_COMPLETION_PERD in VARCHAR2,
122 X_CORRESPONDENCE_CAT in VARCHAR2,
123 X_ENROLMENT_CAT in VARCHAR2,
124 X_FUNDING_SOURCE in VARCHAR2,
125 X_APPL_INST_STATUS IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
126 X_DECISION_DATE DATE DEFAULT NULL, -- begin APADEGAL adtd001 igs.m
127 X_DECISION_MAKE_ID NUMBER DEFAULT NULL,
128 X_DECISION_REASON_ID NUMBER DEFAULT NULL,
129 X_PENDING_REASON_ID NUMBER DEFAULT NULL,
130 X_WAITLIST_STATUS VARCHAR2 DEFAULT NULL,
131 X_WAITLIST_RANK VARCHAR2 DEFAULT NULL,
132 X_FUTURE_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
133 X_FUTURE_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
134 X_FUTURE_ADM_CAL_TYPE VARCHAR2 DEFAULT NULL,
135 X_FUTURE_ADM_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
136 X_DEF_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
137 X_DEF_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
138 X_RECONSIDER_FLAG VARCHAR2 DEFAULT NULL,
139 X_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
140 );
141 procedure UPDATE_ROW (
142 X_ROWID in VARCHAR2,
143 X_PERSON_ID in NUMBER,
144 X_ADMISSION_APPL_NUMBER in NUMBER,
145 X_NOMINATED_COURSE_CD in VARCHAR2,
146 X_SEQUENCE_NUMBER in NUMBER,
147 X_HIST_START_DT in DATE,
148 X_APPLICANT_ACPTNCE_CNDTN in VARCHAR2,
149 X_CNDTNL_OFFER_CNDTN in VARCHAR2,
150 X_HIST_END_DT in DATE,
151 X_HIST_WHO in NUMBER,
152 X_HIST_OFFER_ROUND_NUMBER in NUMBER,
153 X_ADM_CAL_TYPE in VARCHAR2,
154 X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
155 X_COURSE_CD in VARCHAR2,
156 X_CRV_VERSION_NUMBER in NUMBER,
157 X_LOCATION_CD in VARCHAR2,
158 X_ATTENDANCE_MODE in VARCHAR2,
159 X_ATTENDANCE_TYPE in VARCHAR2,
160 X_UNIT_SET_CD in VARCHAR2,
161 X_US_VERSION_NUMBER in NUMBER,
162 X_PREFERENCE_NUMBER in NUMBER,
163 X_ADM_DOC_STATUS in VARCHAR2,
164 X_ADM_ENTRY_QUAL_STATUS in VARCHAR2,
165 X_LATE_ADM_FEE_STATUS in VARCHAR2,
166 X_ADM_OUTCOME_STATUS in VARCHAR2,
167 X_ADM_OTCM_STATUS_AUTH_PER_ID in NUMBER,
168 X_ADM_OUTCOME_STATUS_AUTH_DT in DATE,
169 X_ADM_OUTCOME_STATUS_REASON in VARCHAR2,
170 X_OFFER_DT in DATE,
171 X_OFFER_RESPONSE_DT in DATE,
172 X_PRPSD_COMMENCEMENT_DT in DATE,
173 X_ADM_CNDTNL_OFFER_STATUS in VARCHAR2,
174 X_CNDTNL_OFFER_SATISFIED_DT in DATE,
175 X_CNDTNL_OFR_MUST_BE_STSFD_IND in VARCHAR2,
176 X_ADM_OFFER_RESP_STATUS in VARCHAR2,
177 X_ACTUAL_RESPONSE_DT in DATE,
178 X_ADM_OFFER_DFRMNT_STATUS in VARCHAR2,
179 X_DEFERRED_ADM_CAL_TYPE in VARCHAR2,
180 X_DEFERRED_ADM_CI_SEQUENCE_NUM in NUMBER,
181 X_DEFERRED_TRACKING_ID in NUMBER,
182 X_ASS_RANK in NUMBER,
183 X_SECONDARY_ASS_RANK in NUMBER,
184 X_INTRNTNL_ACCEPT_ADVICE_NUM in NUMBER,
185 X_ASS_TRACKING_ID in NUMBER,
186 X_FEE_CAT in VARCHAR2,
187 X_HECS_PAYMENT_OPTION in VARCHAR2,
188 X_EXPECTED_COMPLETION_YR in NUMBER,
189 X_EXPECTED_COMPLETION_PERD in VARCHAR2,
190 X_CORRESPONDENCE_CAT in VARCHAR2,
191 X_ENROLMENT_CAT in VARCHAR2,
192 X_FUNDING_SOURCE in VARCHAR2,
193 X_MODE in VARCHAR2 default 'R',
194 X_APPL_INST_STATUS IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
195 X_DECISION_DATE DATE DEFAULT NULL, -- begin APADEGAL adtd001 igs.m
196 X_DECISION_MAKE_ID NUMBER DEFAULT NULL,
197 X_DECISION_REASON_ID NUMBER DEFAULT NULL,
198 X_PENDING_REASON_ID NUMBER DEFAULT NULL,
199 X_WAITLIST_STATUS VARCHAR2 DEFAULT NULL,
200 X_WAITLIST_RANK VARCHAR2 DEFAULT NULL,
201 X_FUTURE_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
202 X_FUTURE_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
203 X_FUTURE_ADM_CAL_TYPE VARCHAR2 DEFAULT NULL,
204 X_FUTURE_ADM_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
205 X_DEF_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
206 X_DEF_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
207 X_RECONSIDER_FLAG VARCHAR2 DEFAULT NULL,
208 X_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
209 );
210 procedure ADD_ROW (
211 X_ROWID in out NOCOPY VARCHAR2,
212 X_ORG_ID in NUMBER,
213 X_PERSON_ID in NUMBER,
214 X_ADMISSION_APPL_NUMBER in NUMBER,
215 X_NOMINATED_COURSE_CD in VARCHAR2,
216 X_SEQUENCE_NUMBER in NUMBER,
217 X_HIST_START_DT in DATE,
218 X_APPLICANT_ACPTNCE_CNDTN in VARCHAR2,
219 X_CNDTNL_OFFER_CNDTN in VARCHAR2,
220 X_HIST_END_DT in DATE,
221 X_HIST_WHO in NUMBER,
222 X_HIST_OFFER_ROUND_NUMBER in NUMBER,
223 X_ADM_CAL_TYPE in VARCHAR2,
224 X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
225 X_COURSE_CD in VARCHAR2,
226 X_CRV_VERSION_NUMBER in NUMBER,
227 X_LOCATION_CD in VARCHAR2,
228 X_ATTENDANCE_MODE in VARCHAR2,
229 X_ATTENDANCE_TYPE in VARCHAR2,
230 X_UNIT_SET_CD in VARCHAR2,
231 X_US_VERSION_NUMBER in NUMBER,
232 X_PREFERENCE_NUMBER in NUMBER,
233 X_ADM_DOC_STATUS in VARCHAR2,
234 X_ADM_ENTRY_QUAL_STATUS in VARCHAR2,
235 X_LATE_ADM_FEE_STATUS in VARCHAR2,
236 X_ADM_OUTCOME_STATUS in VARCHAR2,
237 X_ADM_OTCM_STATUS_AUTH_PER_ID in NUMBER,
238 X_ADM_OUTCOME_STATUS_AUTH_DT in DATE,
239 X_ADM_OUTCOME_STATUS_REASON in VARCHAR2,
240 X_OFFER_DT in DATE,
241 X_OFFER_RESPONSE_DT in DATE,
242 X_PRPSD_COMMENCEMENT_DT in DATE,
243 X_ADM_CNDTNL_OFFER_STATUS in VARCHAR2,
244 X_CNDTNL_OFFER_SATISFIED_DT in DATE,
245 X_CNDTNL_OFR_MUST_BE_STSFD_IND in VARCHAR2,
246 X_ADM_OFFER_RESP_STATUS in VARCHAR2,
247 X_ACTUAL_RESPONSE_DT in DATE,
248 X_ADM_OFFER_DFRMNT_STATUS in VARCHAR2,
249 X_DEFERRED_ADM_CAL_TYPE in VARCHAR2,
250 X_DEFERRED_ADM_CI_SEQUENCE_NUM in NUMBER,
251 X_DEFERRED_TRACKING_ID in NUMBER,
252 X_ASS_RANK in NUMBER,
253 X_SECONDARY_ASS_RANK in NUMBER,
254 X_INTRNTNL_ACCEPT_ADVICE_NUM in NUMBER,
255 X_ASS_TRACKING_ID in NUMBER,
256 X_FEE_CAT in VARCHAR2,
257 X_HECS_PAYMENT_OPTION in VARCHAR2,
258 X_EXPECTED_COMPLETION_YR in NUMBER,
259 X_EXPECTED_COMPLETION_PERD in VARCHAR2,
260 X_CORRESPONDENCE_CAT in VARCHAR2,
261 X_ENROLMENT_CAT in VARCHAR2,
262 X_FUNDING_SOURCE in VARCHAR2,
263 X_MODE in VARCHAR2 default 'R',
264 X_APPL_INST_STATUS IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
265 X_DECISION_DATE DATE DEFAULT NULL, -- begin APADEGAL adtd001 igs.m
266 X_DECISION_MAKE_ID NUMBER DEFAULT NULL,
267 X_DECISION_REASON_ID NUMBER DEFAULT NULL,
268 X_PENDING_REASON_ID NUMBER DEFAULT NULL,
269 X_WAITLIST_STATUS VARCHAR2 DEFAULT NULL,
270 X_WAITLIST_RANK VARCHAR2 DEFAULT NULL,
271 X_FUTURE_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
272 X_FUTURE_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
273 X_FUTURE_ADM_CAL_TYPE VARCHAR2 DEFAULT NULL,
274 X_FUTURE_ADM_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
275 X_DEF_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
276 X_DEF_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
277 X_RECONSIDER_FLAG VARCHAR2 DEFAULT NULL,
278 X_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
279 );
280 procedure DELETE_ROW (
281 X_ROWID in VARCHAR2
282 );
283 FUNCTION Get_PK_For_Validation (
284 x_person_id IN NUMBER,
285 x_admission_appl_number IN NUMBER,
286 x_nominated_course_cd IN VARCHAR2,
287 x_sequence_number IN NUMBER,
288 x_hist_start_dt IN DATE
289 )
290 RETURN BOOLEAN;
291
292 Procedure Check_constraints(
293 Column_Name IN VARCHAR2 DEFAULT NULL,
294 Column_Value IN VARCHAR2 DEFAULT NULL
295 );
296
297 PROCEDURE Before_DML (
298 p_action IN VARCHAR2,
299 x_rowid IN VARCHAR2 DEFAULT NULL,
300 x_org_id IN NUMBER DEFAULT NULL,
301 x_course_cd IN VARCHAR2 DEFAULT NULL,
302 x_crv_version_number IN NUMBER DEFAULT NULL,
303 x_location_cd IN VARCHAR2 DEFAULT NULL,
304 x_attendance_mode IN VARCHAR2 DEFAULT NULL,
305 x_attendance_type IN VARCHAR2 DEFAULT NULL,
306 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
307 x_us_version_number IN NUMBER DEFAULT NULL,
308 x_preference_number IN NUMBER DEFAULT NULL,
309 x_adm_doc_status IN VARCHAR2 DEFAULT NULL,
310 x_adm_entry_qual_status IN VARCHAR2 DEFAULT NULL,
311 x_late_adm_fee_status IN VARCHAR2 DEFAULT NULL,
312 x_adm_outcome_status IN VARCHAR2 DEFAULT NULL,
313 x_adm_otcm_status_auth_per_id IN NUMBER DEFAULT NULL,
314 x_adm_outcome_status_auth_dt IN DATE DEFAULT NULL,
315 x_adm_outcome_status_reason IN VARCHAR2 DEFAULT NULL,
316 x_offer_dt IN DATE DEFAULT NULL,
317 x_offer_response_dt IN DATE DEFAULT NULL,
318 x_prpsd_commencement_dt IN DATE DEFAULT NULL,
319 x_adm_cndtnl_offer_status IN VARCHAR2 DEFAULT NULL,
320 x_cndtnl_offer_satisfied_dt IN DATE DEFAULT NULL,
321 x_cndtnl_ofr_must_be_stsfd_ind IN VARCHAR2 DEFAULT NULL,
322 x_adm_offer_resp_status IN VARCHAR2 DEFAULT NULL,
323 x_actual_response_dt IN DATE DEFAULT NULL,
324 x_adm_offer_dfrmnt_status IN VARCHAR2 DEFAULT NULL,
325 x_deferred_adm_cal_type IN VARCHAR2 DEFAULT NULL,
326 x_deferred_adm_ci_sequence_num IN NUMBER DEFAULT NULL,
327 x_deferred_tracking_id IN NUMBER DEFAULT NULL,
328 x_ass_rank IN NUMBER DEFAULT NULL,
329 x_secondary_ass_rank IN NUMBER DEFAULT NULL,
330 x_intrntnl_accept_advice_num IN NUMBER DEFAULT NULL,
331 x_ass_tracking_id IN NUMBER DEFAULT NULL,
332 x_fee_cat IN VARCHAR2 DEFAULT NULL,
333 x_hecs_payment_option IN VARCHAR2 DEFAULT NULL,
334 x_expected_completion_yr IN NUMBER DEFAULT NULL,
335 x_expected_completion_perd IN VARCHAR2 DEFAULT NULL,
336 x_correspondence_cat IN VARCHAR2 DEFAULT NULL,
337 x_enrolment_cat IN VARCHAR2 DEFAULT NULL,
338 x_funding_source IN VARCHAR2 DEFAULT NULL,
339 x_cndtnl_offer_cndtn IN VARCHAR2 DEFAULT NULL,
340 x_applicant_acptnce_cndtn IN VARCHAR2 DEFAULT NULL,
341 x_person_id IN NUMBER DEFAULT NULL,
342 x_admission_appl_number IN NUMBER DEFAULT NULL,
343 x_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
344 x_sequence_number IN NUMBER DEFAULT NULL,
345 x_hist_start_dt IN DATE DEFAULT NULL,
346 x_hist_end_dt IN DATE DEFAULT NULL,
347 x_hist_who IN NUMBER DEFAULT NULL,
348 x_hist_offer_round_number IN NUMBER DEFAULT NULL,
349 x_adm_cal_type IN VARCHAR2 DEFAULT NULL,
350 x_adm_ci_sequence_number IN NUMBER DEFAULT NULL,
351 x_creation_date IN DATE DEFAULT NULL,
352 x_created_by IN NUMBER DEFAULT NULL,
353 x_last_update_date IN DATE DEFAULT NULL,
354 x_last_updated_by IN NUMBER DEFAULT NULL,
355 x_last_update_login IN NUMBER DEFAULT NULL,
356 x_appl_inst_status IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
357 X_DECISION_DATE DATE DEFAULT NULL, -- begin APADEGAL adtd001 igs.m
358 X_DECISION_MAKE_ID NUMBER DEFAULT NULL,
359 X_DECISION_REASON_ID NUMBER DEFAULT NULL,
360 X_PENDING_REASON_ID NUMBER DEFAULT NULL,
361 X_WAITLIST_STATUS VARCHAR2 DEFAULT NULL,
362 X_WAITLIST_RANK VARCHAR2 DEFAULT NULL,
363 X_FUTURE_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
364 X_FUTURE_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
365 X_FUTURE_ADM_CAL_TYPE VARCHAR2 DEFAULT NULL,
366 X_FUTURE_ADM_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
367 X_DEF_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
368 X_DEF_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
369 X_RECONSIDER_FLAG VARCHAR2 DEFAULT NULL,
370 X_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
371 );
372
373 end IGS_AD_PS_APLINSTHST_PKG;