eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IGS_AD_VAL_ACAI_STATUS

Source


1 PACKAGE IGS_AD_VAL_ACAI_STATUS AS
2 /* $Header: IGSAD24S.pls 120.1 2005/08/11 10:06:23 appldev ship $ */
3   --Bug 1956374 msrinivi Removed duplciate fun enrp_val_trnsfr_acpt 27 aug,01
4   -- Validate the IGS_AD_PS_APPL_INST.adm_entry_qual_status.
5   -- hreddych #2602077  SF Integration Added the FUNCTION admp_val_aods_update
6   FUNCTION admp_val_acai_aeqs(
7   p_adm_entry_qual_status IN VARCHAR2 ,
8   p_adm_outcome_status IN VARCHAR2 ,
9   p_s_admission_process_type IN VARCHAR2 ,
10   p_message_name  OUT NOCOPY VARCHAR2)
11 RETURN BOOLEAN;
12 
13   -- Validate the IGS_AD_PS_APPL_INST.adm_entry_qual_status.
14   FUNCTION admp_val_aeqs_item(
15   p_adm_entry_qual_status IN VARCHAR2 ,
16   p_s_admission_process_type IN VARCHAR2 ,
17   p_message_name  OUT NOCOPY VARCHAR2)
18 RETURN BOOLEAN;
19 PRAGMA RESTRICT_REFERENCES (admp_val_aeqs_item, WNDS, WNPS);
20   --
21   -- Validate if IGS_AD_ENT_QF_STAT.adm_entry_qual_status is closed.
22   FUNCTION admp_val_aeqs_closed(
23   p_adm_entry_qual_status IN VARCHAR2 ,
24   p_message_name  OUT NOCOPY VARCHAR2)
25 RETURN BOOLEAN;
26 PRAGMA RESTRICT_REFERENCES (admp_val_aeqs_closed, WNDS, WNPS);
27   --
28   -- Validates adm_entry_qual_status against adm_outcome_status.
29   FUNCTION admp_val_aeqs_aos(
30   p_s_adm_entry_qual_status IN VARCHAR2 ,
31   p_s_adm_outcome_status IN VARCHAR2 ,
32   p_message_name  OUT NOCOPY VARCHAR2)
33 RETURN BOOLEAN;
34 
35   -- Validate the IGS_AD_PS_APPL_INST.adm_doc_status.
36   FUNCTION admp_val_acai_ads(
37   p_adm_doc_status IN VARCHAR2 ,
38   p_adm_outcome_status IN VARCHAR2 ,
39   p_adm_cndtnl_offer_status IN VARCHAR2 ,
40   p_s_admission_process_type IN VARCHAR2 ,
41   p_cond_offer_doc_allowed IN VARCHAR2 DEFAULT 'N',
42   p_message_name  OUT NOCOPY VARCHAR2)
43 RETURN BOOLEAN;
44 
45   -- Validate the IGS_AD_PS_APPL_INST.adm_doc_status.
46   FUNCTION admp_val_ads_item(
47   p_adm_doc_status IN VARCHAR2 ,
48   p_s_admission_process_type IN VARCHAR2 ,
49   p_message_name  OUT NOCOPY VARCHAR2)
50 RETURN BOOLEAN;
51  PRAGMA RESTRICT_REFERENCES (admp_val_ads_item, WNDS, WNPS);
52   --
53   -- Validate if IGS_AD_DOC_STAT.adm_doc_status is closed.
54   FUNCTION admp_val_ads_closed(
55   p_adm_doc_status IN VARCHAR2 ,
56   p_message_name  OUT NOCOPY VARCHAR2)
57 RETURN BOOLEAN;
58 PRAGMA RESTRICT_REFERENCES (admp_val_ads_closed, WNDS, WNPS);
59   --
60   -- Validates adm_doc_status against adm_outcome_status.
61   FUNCTION admp_val_ads_aos(
62   p_s_adm_doc_status IN VARCHAR2 ,
63   p_s_adm_outcome_status IN VARCHAR2 ,
64   p_s_adm_cndtnl_offer_status IN VARCHAR2 ,
65   p_cond_offer_doc_allowed IN VARCHAR2 DEFAULT 'N',
66   p_message_name  OUT NOCOPY VARCHAR2)
67 RETURN BOOLEAN;
68 
69   -- Validate the IGS_AD_PS_APPL_INST.adm_offer_dfrmnt_status.
70   FUNCTION admp_val_acai_aods(
71   p_person_id IN NUMBER ,
72   p_admission_appl_number IN NUMBER ,
73   p_nominated_course_cd IN VARCHAR2 ,
74   p_acai_sequence_number IN NUMBER ,
75   p_course_cd IN VARCHAR2 ,
76   p_adm_offer_dfrmnt_status IN VARCHAR2 ,
77   p_old_adm_dfrmnt_status IN VARCHAR2 ,
78   p_adm_offer_resp_status IN VARCHAR2 ,
79   p_deferral_allowed IN VARCHAR2 DEFAULT 'N',
80   p_s_admission_process_type IN VARCHAR2 ,
81   p_message_name  OUT NOCOPY VARCHAR2)
82 RETURN BOOLEAN;
83   -- Validate the IGS_AD_PS_APPL_INST.adm_offer_dfrmnt_status.
84   FUNCTION admp_val_aods_item(
85   p_person_id IN NUMBER ,
86   p_admission_appl_number IN NUMBER ,
87   p_nominated_course_cd IN VARCHAR2 ,
88   p_acai_sequence_number IN NUMBER ,
89   p_course_cd IN VARCHAR2 ,
90   p_adm_offer_dfrmnt_status IN VARCHAR2 ,
91   p_s_admission_process_type IN VARCHAR2 ,
92   p_deferral_allowed IN VARCHAR2 DEFAULT 'N',
93   p_message_name  OUT NOCOPY VARCHAR2)
94 RETURN BOOLEAN;
95   -- Validate if IGS_AD_OFRDFRMT_STAT.adm_offer_dfrmnt_status is closed.
96   FUNCTION admp_val_aods_closed(
97   p_adm_offer_dfrmnt_status IN VARCHAR2 ,
98   p_message_name  OUT NOCOPY VARCHAR2)
99 RETURN BOOLEAN;
100   --
101   -- Validates adm_offer_dfrmnt_status against adm_offer_resp_status.
102   FUNCTION admp_val_aods_aors(
103   p_s_adm_offer_dfrmnt_status IN VARCHAR2 ,
104   p_old_s_adm_dfrmnt_status IN VARCHAR2 ,
105   p_s_adm_offer_resp_status IN VARCHAR2 ,
106   p_message_name  OUT NOCOPY VARCHAR2)
107 RETURN BOOLEAN;
108   -- Validate the IGS_AD_PS_APPL_INST.late_adm_fee_status.
109   FUNCTION admp_val_acai_lafs(
110   p_late_adm_fee_status IN VARCHAR2 ,
111   p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
112   p_late_fees_required IN VARCHAR2 DEFAULT 'N',
113   p_cond_offer_fee_allowed IN VARCHAR2 DEFAULT 'N',
114   p_appl_dt IN DATE ,
115   p_course_cd IN VARCHAR2 ,
116   p_crv_version_number IN NUMBER ,
117   p_acad_cal_type IN VARCHAR2 ,
118   p_location_cd IN VARCHAR2 ,
119   p_attendance_mode IN VARCHAR2 ,
120   p_attendance_type IN VARCHAR2 ,
121   p_adm_cal_type IN VARCHAR2 ,
122   p_adm_ci_sequence_number IN NUMBER ,
123   p_admission_cat IN VARCHAR2 ,
124   p_s_admission_process_type IN VARCHAR2 ,
125   p_adm_outcome_status IN VARCHAR2 ,
126   p_adm_cndtnl_offer_status IN VARCHAR2 ,
127   p_message_name  OUT NOCOPY VARCHAR2)
128 RETURN BOOLEAN;
129   -- Validate the IGS_AD_PS_APPL_INST.late_adm_fee_status.
130   FUNCTION admp_val_lafs_item(
131   p_late_adm_fee_status IN VARCHAR2 ,
132   p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
133   p_message_name  OUT NOCOPY VARCHAR2)
134 RETURN BOOLEAN;
135   -- Validate if IGS_AD_FEE_STAT.adm_fee_status is closed.
136   FUNCTION admp_val_afs_closed(
137   p_adm_fee_status IN VARCHAR2 ,
138   p_message_name  OUT NOCOPY VARCHAR2)
139 RETURN BOOLEAN;
140  -- Validates late_adm_fee_status against the course offering option.
141   FUNCTION admp_val_lafs_coo(
142   p_s_late_adm_fee_status IN VARCHAR2 ,
143   p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
144   p_late_fees_required IN VARCHAR2 DEFAULT 'N',
145   p_appl_dt IN DATE ,
146   p_course_cd IN VARCHAR2 ,
147   p_crv_version_number IN NUMBER ,
148   p_acad_cal_type IN VARCHAR2 ,
149   p_location_cd IN VARCHAR2 ,
150   p_attendance_mode IN VARCHAR2 ,
151   p_attendance_type IN VARCHAR2 ,
152   p_adm_cal_type IN VARCHAR2 ,
153   p_adm_ci_sequence_number IN NUMBER ,
154   p_admission_cat IN VARCHAR2 ,
155   p_s_admission_process_type IN VARCHAR2 ,
156   p_message_name  OUT NOCOPY VARCHAR2)
157 RETURN BOOLEAN;
158   -- Validates late_adm_fee_status against adm_outcome_status.
159   FUNCTION admp_val_lafs_aos(
160   p_s_late_adm_fee_status IN VARCHAR2 ,
161   p_s_adm_outcome_status IN VARCHAR2 ,
162   p_s_adm_cndtnl_offer_status IN VARCHAR2 ,
163   p_cond_offer_fee_allowed IN VARCHAR2 DEFAULT 'N',
164   p_message_name  OUT NOCOPY VARCHAR2)
165 RETURN BOOLEAN;
166   -- Validate the IGS_AD_PS_APPL_INST.adm_offer_resp_status.
167   FUNCTION admp_val_acai_aors(
168   p_person_id IN NUMBER ,
169   p_admission_appl_number IN NUMBER ,
170   p_nominated_course_cd IN VARCHAR2 ,
171   p_acai_sequence_number IN NUMBER ,
172   p_course_cd IN VARCHAR2 ,
173   p_adm_offer_resp_status IN VARCHAR2 ,
174   p_old_adm_offer_resp_status IN VARCHAR2 ,
175   p_adm_outcome_status IN VARCHAR2 ,
176   p_adm_offer_dfrmnt_status IN VARCHAR2 ,
177   p_old_adm_offer_dfrmnt_status IN VARCHAR2 ,
178   p_adm_outcome_status_auth_dt IN DATE ,
179   p_actual_response_dt IN DATE ,
180   p_adm_cal_type IN VARCHAR2 ,
181   p_adm_ci_sequence_number IN NUMBER ,
182   p_admission_cat IN VARCHAR2 ,
183   p_s_admission_process_type IN VARCHAR2 ,
184   p_deferral_allowed IN VARCHAR2 DEFAULT 'N',
185   p_multi_offer_allowed IN VARCHAR2 DEFAULT 'N',
186   p_multi_offer_limit IN NUMBER ,
187   p_pre_enrol_step IN VARCHAR2 DEFAULT 'N',
188   p_cndtnl_off_must_be_stsfd_ind IN VARCHAR2 DEFAULT 'N',
189   p_cndtnl_offer_satisfied_dt IN DATE ,
190   p_called_from IN VARCHAR2 ,
191   p_message_name  OUT NOCOPY VARCHAR2,
192   p_decline_ofr_reason IN VARCHAR2 DEFAULT NULL,		-- IGSM
193   p_attent_other_inst_cd IN VARCHAR2 DEFAULT NULL		-- igsm
194 )
195 RETURN BOOLEAN;
196   -- Validate the IGS_AD_PS_APPL_INST.adm_offer_resp_status.
197   FUNCTION admp_val_aors_item(
198   p_person_id IN NUMBER ,
199   p_admission_appl_number IN NUMBER ,
200   p_nominated_course_cd IN VARCHAR2 ,
201   p_acai_sequence_number IN NUMBER ,
202   p_course_cd IN VARCHAR2 ,
203   p_adm_offer_resp_status IN VARCHAR2 ,
204   p_actual_response_dt IN DATE ,
205   p_s_admission_process_type IN VARCHAR2 ,
206   p_deferral_allowed IN VARCHAR2 DEFAULT 'N',
207   p_pre_enrol_step IN VARCHAR2 DEFAULT 'N',
208   p_message_name  OUT NOCOPY VARCHAR2,
209   p_decline_ofr_reason IN VARCHAR2 DEFAULT NULL,		-- IGSM
210   p_attent_other_inst_cd IN VARCHAR2 DEFAULT NULL		-- igsm
211 )
212 RETURN BOOLEAN;
213   -- Validate if IGS_AD_OFR_RESP_STAT.adm_offer_resp_status is closed.
214   FUNCTION admp_val_aors_closed(
215   p_adm_offer_resp_status IN VARCHAR2 ,
216   p_message_name  OUT NOCOPY VARCHAR2)
217 RETURN BOOLEAN;
218  -- Validates adm_offer_resp_status against adm_outcome_status.
219   FUNCTION admp_val_aors_aos(
220   p_s_adm_offer_resp_status IN VARCHAR2 ,
221   p_old_s_adm_offer_resp_status IN VARCHAR2 ,
222   p_s_adm_outcome_status IN VARCHAR2 ,
223   p_adm_outcome_status_auth_dt IN DATE ,
224   p_message_name  OUT NOCOPY VARCHAR2)
225 RETURN BOOLEAN;
226   -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status.
227   FUNCTION admp_val_acai_aos(
228   p_person_id IN NUMBER ,
229   p_admission_appl_number IN NUMBER ,
230   p_nominated_course_cd IN VARCHAR2 ,
231   p_acai_sequence_number IN NUMBER ,
232   p_course_cd IN VARCHAR2 ,
233   p_crv_version_number IN NUMBER ,
234   p_location_cd IN VARCHAR2 ,
235   p_attendance_mode IN VARCHAR2 ,
236   p_attendance_type IN VARCHAR2 ,
237   p_unit_set_cd IN VARCHAR2 ,
238   p_us_version_number IN NUMBER ,
239   p_acad_cal_type IN VARCHAR2 ,
240   p_acad_ci_sequence_number IN NUMBER ,
241   p_adm_cal_type IN VARCHAR2 ,
242   p_adm_ci_sequence_number IN NUMBER ,
243   p_admission_cat IN VARCHAR2 ,
244   p_s_admission_process_type IN VARCHAR2 ,
245   p_appl_dt IN DATE ,
246   p_fee_cat IN VARCHAR2 ,
247   p_correspondence_cat IN VARCHAR2 ,
248   p_enrolment_cat IN VARCHAR2 ,
249   p_adm_outcome_status IN VARCHAR2 ,
250   p_old_adm_outcome_status IN VARCHAR2 ,
251   p_adm_doc_status IN VARCHAR2 ,
252   p_adm_fee_status IN VARCHAR2 ,
253   p_late_adm_fee_status IN VARCHAR2 ,
254   p_adm_cndtnl_offer_status IN VARCHAR2 ,
255   p_adm_entry_qual_status IN VARCHAR2 ,
256   p_adm_offer_resp_status IN VARCHAR2 ,
257   p_old_adm_offer_resp_status IN VARCHAR2 ,
258   p_adm_outcome_status_auth_dt IN DATE ,
259   p_set_outcome_allowed IN VARCHAR2 DEFAULT 'N',
260   p_cond_offer_assess_allowed IN VARCHAR2 DEFAULT 'N',
261   p_cond_offer_fee_allowed IN VARCHAR2 DEFAULT 'N',
262   p_cond_offer_doc_allowed IN VARCHAR2 DEFAULT 'N',
263   p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
264   p_fees_required IN VARCHAR2 DEFAULT 'N',
265   p_multi_offer_allowed IN VARCHAR2 DEFAULT 'N',
266   p_multi_offer_limit IN NUMBER ,
267   p_pref_allowed IN VARCHAR2 DEFAULT 'N',
268   p_unit_set_appl IN VARCHAR2 DEFAULT 'N',
269   p_check_person_encumb IN VARCHAR2 DEFAULT 'N',
270   p_check_course_encumb IN VARCHAR2 DEFAULT 'N',
271   p_called_from IN VARCHAR2 ,
272   p_message_name  OUT NOCOPY VARCHAR2)
273 RETURN BOOLEAN;
274  -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status.
275   FUNCTION admp_val_aos_item(
276   p_adm_outcome_status IN VARCHAR2 ,
277   p_old_adm_outcome_status IN VARCHAR2 ,
278   p_adm_fee_status IN VARCHAR2 ,
279   p_set_outcome_allowed IN VARCHAR2 DEFAULT 'N',
280   p_cond_offer_assess_allowed IN VARCHAR2 DEFAULT 'N',
281   p_cond_offer_fee_allowed IN VARCHAR2 DEFAULT 'N',
282   p_cond_offer_doc_allowed IN VARCHAR2 DEFAULT 'N',
283   p_person_id IN NUMBER ,
284   p_admission_appl_number IN NUMBER ,
285   p_nominated_course_cd IN VARCHAR2 ,
286   p_acai_sequence_number IN NUMBER ,
287   p_message_name  OUT NOCOPY VARCHAR2)
288 RETURN BOOLEAN;
289   -- Validate if IGS_AD_OU_STAT.adm_outcome_status is closed.
290   FUNCTION admp_val_aos_closed(
291   p_adm_outcome_status IN VARCHAR2 ,
292   p_message_name  OUT NOCOPY VARCHAR2)
293 RETURN BOOLEAN;
294   -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status.
295   FUNCTION admp_val_aos_status(
296   p_s_adm_outcome_status IN VARCHAR2 ,
297   p_old_s_adm_outcome_status IN VARCHAR2 ,
298   p_s_adm_doc_status IN VARCHAR2 ,
299   p_s_adm_fee_status IN VARCHAR2 ,
300   p_late_s_adm_fee_status IN VARCHAR2 ,
301   p_cond_offer_assess_allowed IN VARCHAR2 DEFAULT 'N',
302   p_cond_offer_fee_allowed IN VARCHAR2 DEFAULT 'N',
303   p_cond_offer_doc_allowed IN VARCHAR2 DEFAULT 'N',
304   p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
305   p_fees_required IN VARCHAR2 DEFAULT 'N',
306   p_message_name  OUT NOCOPY VARCHAR2)
307 RETURN BOOLEAN;
308   -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status.
309   FUNCTION admp_val_acai_otcome(
310   p_person_id IN NUMBER ,
311   p_admission_appl_number IN NUMBER ,
312   p_nominated_course_cd IN VARCHAR2 ,
313   p_acai_sequence_number IN NUMBER ,
314   p_course_cd IN VARCHAR2 ,
315   p_crv_version_number IN NUMBER ,
316   p_location_cd IN VARCHAR2 ,
317   p_attendance_mode IN VARCHAR2 ,
318   p_attendance_type IN VARCHAR2 ,
319   p_unit_set_cd IN VARCHAR2 ,
320   p_us_version_number IN NUMBER ,
321   p_acad_cal_type IN VARCHAR2 ,
322   p_acad_ci_sequence_number IN NUMBER ,
323   p_adm_cal_type IN VARCHAR2 ,
324   p_adm_ci_sequence_number IN NUMBER ,
325   p_admission_cat IN VARCHAR2 ,
326   p_s_admission_process_type IN VARCHAR2 ,
327   p_appl_dt IN DATE ,
328   p_fee_cat IN VARCHAR2 ,
329   p_correspondence_cat IN VARCHAR2 ,
330   p_enrolment_cat IN VARCHAR2 ,
331   p_s_adm_outcome_status IN VARCHAR2 ,
332   p_adm_outcome_status_auth_dt IN DATE ,
333   p_check_person_encumb IN VARCHAR2 DEFAULT 'N',
334   p_check_course_encumb IN VARCHAR2 DEFAULT 'N',
335   p_pref_allowed IN VARCHAR2 DEFAULT 'N',
336   p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
340 RETURN BOOLEAN;
337   p_unit_set_appl IN VARCHAR2 DEFAULT 'N',
338   p_called_from IN VARCHAR2 ,
339   p_message_name  OUT NOCOPY VARCHAR2)
341   -- This module validates multiple IGS_AD_PS_APPL_INST offers.
342   FUNCTION admp_val_offer_mult(
343   p_person_id IN NUMBER ,
344   p_admission_appl_number IN NUMBER ,
345   p_nominated_course_cd IN VARCHAR2 ,
346   p_acai_sequence_number IN NUMBER ,
347   p_course_cd IN VARCHAR2 ,
348   p_s_adm_outcome_status IN VARCHAR2 ,
349   p_s_adm_offer_resp_status IN VARCHAR2 ,
350   p_adm_cal_type IN VARCHAR2 ,
351   p_adm_ci_sequence_number IN NUMBER ,
352   p_admission_cat IN VARCHAR2 ,
353   p_s_admission_process_type IN VARCHAR2 ,
354   p_multi_offer_allowed IN VARCHAR2 DEFAULT 'N',
355   p_multi_offer_limit IN NUMBER ,
356   p_message_name  OUT NOCOPY VARCHAR2)
357 RETURN BOOLEAN;
358   -- Validate offers across admission process categories (same adm period).
359   FUNCTION admp_val_offer_x_apc(
360   p_person_id IN NUMBER ,
361   p_admission_appl_number IN NUMBER ,
362   p_nominated_course_cd IN VARCHAR2 ,
363   p_acai_sequence_number IN NUMBER ,
364   p_adm_outcome_status IN VARCHAR2 ,
365   p_adm_offer_resp_status IN VARCHAR2 ,
366   p_adm_cal_type IN VARCHAR2 ,
367   p_adm_ci_sequence_number IN NUMBER ,
368   p_admission_cat IN VARCHAR2 ,
369   p_s_admission_process_type IN VARCHAR2 ,
370   p_message_name  OUT NOCOPY VARCHAR2,
371   p_return_type OUT NOCOPY VARCHAR2 )
372 RETURN BOOLEAN;
373   -- Validate update of the admission outcome status.
374   FUNCTION admp_val_aos_update(
375   p_person_id IN NUMBER ,
376   p_admission_appl_number IN NUMBER ,
377   p_adm_outcome_status IN VARCHAR2 ,
378   p_old_adm_outcome_status IN VARCHAR2 ,
379   p_message_name  OUT NOCOPY VARCHAR2,
380   p_return_type OUT NOCOPY VARCHAR2 )
381 RETURN BOOLEAN;
382   -- Validate the IGS_AD_PS_APPL_INST.IGS_AD_CNDNL_OFRSTAT.
383   FUNCTION admp_val_acai_acos(
384   p_adm_cndtnl_offer_status IN VARCHAR2 ,
385   p_old_adm_cndtnl_offer_status IN VARCHAR2 ,
386   p_adm_outcome_status IN VARCHAR2 ,
387   p_adm_doc_status IN VARCHAR2 ,
388   p_late_adm_fee_status IN VARCHAR2 ,
389   p_adm_fee_status IN VARCHAR2 ,
390   p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
391   p_fees_required IN VARCHAR2 DEFAULT 'N',
392   p_cond_offer_assess_allowed IN VARCHAR2 DEFAULT 'N',
393   p_cond_offer_fee_allowed IN VARCHAR2 DEFAULT 'N',
394   p_cond_offer_doc_allowed IN VARCHAR2 DEFAULT 'N',
395   p_message_name  OUT NOCOPY VARCHAR2)
396 RETURN BOOLEAN;
397   -- Validate the IGS_AD_PS_APPL_INST.adm_cndtnl_offer_status.
398   FUNCTION admp_val_acos_item(
399   p_adm_cndtnl_offer_status IN VARCHAR2 ,
400   p_adm_fee_status IN VARCHAR2 ,
401   p_fees_required IN VARCHAR2 DEFAULT 'N',
402   p_cond_offer_assess_allowed IN VARCHAR2 DEFAULT 'N',
403   p_cond_offer_fee_allowed IN VARCHAR2 DEFAULT 'N',
404   p_cond_offer_doc_allowed IN VARCHAR2 DEFAULT 'N',
405   p_message_name  OUT NOCOPY VARCHAR2)
406 RETURN BOOLEAN;
407   -- Validate if IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status is closed.
408   FUNCTION admp_val_acos_closed(
409   p_adm_cndtnl_offer_status IN VARCHAR2 ,
410   p_message_name  OUT NOCOPY VARCHAR2)
411 RETURN BOOLEAN;
412   -- Validate the IGS_AD_PS_APPL_INST.adm_cndtnl_offer_status.
413   FUNCTION admp_val_acos_status(
414   p_s_adm_cndtnl_offer_status IN VARCHAR2 ,
415   p_old_s_adm_cndtnl_offer_sts IN VARCHAR2 ,
416   p_s_adm_outcome_status IN VARCHAR2 ,
417   p_s_adm_doc_status IN VARCHAR2 ,
418   p_late_s_adm_fee_status IN VARCHAR2 ,
419   p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
420   p_message_name  OUT NOCOPY VARCHAR2)
421 RETURN BOOLEAN;
422   --Validate the offer deferment status
423   FUNCTION admp_val_aods_update(
424   p_person_id IN NUMBER ,
425   p_admission_appl_number IN NUMBER ,
426   p_nominated_course_cd IN VARCHAR2 ,
427   p_sequence_number IN NUMBER ,
428   p_offer_deferment_status IN VARCHAR2,
429   p_message_name  OUT NOCOPY VARCHAR2)
430 RETURN BOOLEAN;
431 
432   FUNCTION admp_val_acai_ais(				--arvsrini igsm
433   p_appl_inst_status IN VARCHAR2 ,
434   p_ais_reason IN VARCHAR2,
435   p_adm_outcome_status IN VARCHAR2 ,
436   p_message_name OUT NOCOPY VARCHAR2 )
437 RETURN BOOLEAN;
438 
439 FUNCTION admp_val_ais_item(				--arvsrini igsm
440   p_appl_inst_status IN VARCHAR2 ,
441   p_ais_reason IN VARCHAR2,
442   p_message_name OUT NOCOPY VARCHAR2 )
443 RETURN BOOLEAN;
444 
445 FUNCTION admp_val_ais_closed(				--arvsrini igsm
446   p_appl_inst_status IN VARCHAR2 ,
447   p_message_name OUT NOCOPY VARCHAR2 )
448 RETURN BOOLEAN;
449 
450 FUNCTION admp_val_ais_aos(				--arvsrini igsm
451   p_s_appl_inst_status IN VARCHAR2 ,
452   p_s_adm_outcome_status IN VARCHAR2 ,
453   p_message_name OUT NOCOPY VARCHAR2 )
454 RETURN BOOLEAN;
455 
456 END IGS_AD_VAL_ACAI_STATUS;