1 PACKAGE IGS_AD_VAL_ACAI AS
2 /* $Header: IGSAD22S.pls 120.0 2005/06/01 23:28:41 appldev noship $ */
3 --
4 -- bug id : 1956374
5 -- sjadhav , 29-aug-2001
6 -- removed function enrp_val_hpo_closed
7 --
8 ------------------------------------------------------------------------------------------p
9 --Change History:
10 --Who When What
11 --smadathi 28-AUG-2001 Bug No. 1956374 .The pragma restrict refrence added to function genp_val_staff_prsn
12 -- rghosh 03-mar-2003 Changed the signature of the function ADMP_VAL_DFRMNT_CAL (bug#2765260)
13 -------------------------------------------------------------------------------------------
14 -- Bug # 1956374
15 -- As part of bug 1956374 removed function crsp_val_loc_cd,finp_val_fc_closed
16 -- Bug # 1956374
17 -- As part of bug 1956374 removed the function admp_val_aa_adm_cal,admp_val_aca_trnsfr,admp_val_pref_limit
18 -- bug id : 1956374
19 -- sjadhav,28-aug-2001
20 -- removed FUNCTION enrp_val_ec_closed
21 --
22
23 -- Validate insert of an IGS_AD_PS_APPL_INST record.
24 FUNCTION admp_val_acai_insert(
25 p_person_id IN NUMBER ,
26 p_admission_appl_number IN NUMBER ,
27 p_nominated_course_cd IN VARCHAR2 ,
28 p_acai_sequence_number IN NUMBER ,
29 p_course_cd IN VARCHAR2 ,
30 p_location_cd IN VARCHAR2 ,
31 p_attendance_mode IN VARCHAR2 ,
32 p_attendance_type IN VARCHAR2 ,
33 p_unit_set_cd IN VARCHAR2 ,
34 p_us_version_number IN NUMBER ,
35 p_adm_cal_type IN VARCHAR2 ,
36 p_adm_ci_sequence_number IN NUMBER ,
37 p_s_admission_process_type IN VARCHAR2 ,
38 p_pref_limit IN NUMBER ,
39 p_validate_aa_only IN BOOLEAN ,
40 p_message_name OUT NOCOPY VARCHAR2,
41 p_return_type OUT NOCOPY VARCHAR2 )
42 RETURN BOOLEAN;
43
44 --
45 -- Validate update of an IGS_AD_PS_APPL_INST record.
46 FUNCTION admp_val_acai_update(
47 p_adm_appl_status IN VARCHAR2 ,
48 p_person_id IN NUMBER ,
49 p_admission_appl_number IN NUMBER ,
50 p_nominated_course_cd IN VARCHAR2 ,
51 p_acai_sequence_number IN NUMBER ,
52 p_message_name OUT NOCOPY VARCHAR2,
53 p_update_non_enrol_detail_ind OUT NOCOPY VARCHAR2 )
54 RETURN BOOLEAN;
55
56
57 --
58 -- Validate delete of an IGS_AD_PS_APPL_INST record.
59 FUNCTION admp_val_acai_delete(
60 p_person_id IN NUMBER ,
61 p_admission_appl_number IN NUMBER ,
62 p_adm_outcome_status IN VARCHAR2 ,
63 p_message_name OUT NOCOPY VARCHAR2,
64 p_return_type OUT NOCOPY VARCHAR2 )
65 RETURN BOOLEAN;
66
67 --
68 -- Validate change of preferences.
69 FUNCTION admp_val_chg_of_pref(
70 p_adm_cal_type IN VARCHAR2 ,
71 p_adm_ci_sequence_number IN NUMBER ,
72 p_admission_cat IN VARCHAR2 ,
73 p_s_admission_process_type IN VARCHAR2 ,
74 p_course_cd IN VARCHAR2 ,
75 p_crv_version_number IN NUMBER ,
76 p_acad_cal_type IN VARCHAR2 ,
77 p_location_cd IN VARCHAR2 ,
78 p_attendance_mode IN VARCHAR2 ,
79 p_attendance_type IN VARCHAR2 ,
80 p_message_name OUT NOCOPY VARCHAR2)
81 RETURN BOOLEAN;
82
83
84
85 --
86 --
87 -- Validate the course code of the admission application.
88 FUNCTION admp_val_acai_course(
89 p_course_cd IN VARCHAR2 ,
90 p_version_number IN NUMBER ,
91 p_admission_cat IN VARCHAR2 ,
92 p_s_admission_process_type IN VARCHAR2 ,
93 p_acad_cal_type IN VARCHAR2 ,
94 p_acad_ci_sequence_number IN NUMBER ,
95 p_adm_cal_type IN VARCHAR2 ,
96 p_adm_ci_sequence_number IN NUMBER ,
97 p_appl_dt IN DATE ,
98 p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
99 p_offer_ind IN VARCHAR2 DEFAULT 'N',
100 p_crv_version_number OUT NOCOPY NUMBER ,
101 p_message_name OUT NOCOPY VARCHAR2,
102 p_return_type OUT NOCOPY VARCHAR2 )
103 RETURN BOOLEAN;
104
105 --
106 -- Perform encumbrance check for admission_course_appl_instance.course_cd
107 FUNCTION admp_val_acai_encmb(
108 p_person_id IN NUMBER ,
109 p_course_cd IN VARCHAR2 ,
110 p_adm_cal_type IN VARCHAR2 ,
111 p_adm_ci_sequence_number IN NUMBER ,
112 p_course_encmb_chk_ind IN VARCHAR2 DEFAULT 'N',
113 p_offer_ind IN VARCHAR2 DEFAULT 'N',
114 p_message_name OUT NOCOPY VARCHAR2,
115 p_return_type OUT NOCOPY VARCHAR2 )
116 RETURN BOOLEAN;
117
118 --
119 -- Validate course appl process type against the student course attempt.
120 FUNCTION admp_val_aca_sca(
121 p_person_id IN NUMBER ,
122 p_course_cd IN VARCHAR2 ,
123 p_appl_dt IN DATE ,
124 p_admission_cat IN VARCHAR2 ,
125 p_s_admission_process_type IN VARCHAR2 ,
126 p_fee_cat IN VARCHAR2 ,
127 p_correspondence_cat IN VARCHAR2 ,
128 p_enrolment_cat IN VARCHAR2 ,
129 p_offer_ind IN VARCHAR2 DEFAULT 'N',
130 p_message_name OUT NOCOPY VARCHAR2,
131 p_return_type OUT NOCOPY VARCHAR2 )
132 RETURN BOOLEAN;
133 --
134
135
136 --
137 -- Validate the adm course application instance course offering pattern.
138 FUNCTION admp_val_acai_cop(
139 p_course_cd IN VARCHAR2 ,
140 p_version_number IN NUMBER ,
141 p_location_cd IN VARCHAR2 ,
142 p_attendance_mode IN VARCHAR2 ,
143 p_attendance_type IN VARCHAR2 ,
144 p_acad_cal_type IN VARCHAR2 ,
145 p_acad_ci_sequence_number IN NUMBER ,
146 p_adm_cal_type IN VARCHAR2 ,
147 p_adm_ci_sequence_number IN NUMBER ,
148 p_admission_cat IN VARCHAR2 ,
149 p_s_admission_process_type IN VARCHAR2 ,
150 p_offer_ind IN VARCHAR2 DEFAULT 'N',
151 p_appl_dt IN DATE ,
152 p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
153 p_deferred_appl IN VARCHAR2 DEFAULT 'N',
154 p_message_name OUT NOCOPY VARCHAR2,
155 p_return_type OUT NOCOPY VARCHAR2 ,
156 p_late_ind OUT NOCOPY VARCHAR2 )
157 RETURN BOOLEAN;
158
159 --
160 -- Validate the adm course application instance course offering option.
161 FUNCTION admp_val_acai_coo(
162 p_course_cd IN VARCHAR2 ,
163 p_version_number IN NUMBER ,
164 p_location_cd IN VARCHAR2 ,
165 p_attendance_mode IN VARCHAR2 ,
166 p_attendance_type IN VARCHAR2 ,
167 p_acad_cal_type IN VARCHAR2 ,
168 p_acad_ci_sequence_number IN NUMBER ,
169 p_adm_cal_type IN VARCHAR2 ,
170 p_adm_ci_sequence_number IN NUMBER ,
171 p_admission_cat IN VARCHAR2 ,
172 p_s_admission_process_type IN VARCHAR2 ,
173 p_offer_ind IN VARCHAR2 DEFAULT 'N',
174 p_appl_dt IN DATE ,
175 p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
176 p_deferred_appl IN VARCHAR2 DEFAULT 'N',
177 p_message_name OUT NOCOPY VARCHAR2,
178 p_return_type OUT NOCOPY VARCHAR2 ,
179 p_late_ind OUT NOCOPY VARCHAR2 )
180 RETURN BOOLEAN;
181 PRAGMA RESTRICT_REFERENCES (admp_val_acai_coo,WNDS,WNPS);
182 --
183 -- Validate if the IGS_AD_PS_APPL_INST is late.
184 FUNCTION admp_val_acai_late(
185 p_appl_dt IN DATE ,
186 p_course_cd IN VARCHAR2 ,
187 p_crv_version_number IN NUMBER ,
188 p_acad_cal_type IN VARCHAR2 ,
189 p_location_cd IN VARCHAR2 ,
190 p_attendance_mode IN VARCHAR2 ,
191 p_attendance_type IN VARCHAR2 ,
192 p_adm_cal_type IN VARCHAR2 ,
193 p_adm_ci_sequence_number IN NUMBER ,
194 p_admission_cat IN VARCHAR2 ,
195 p_s_admission_process_type IN VARCHAR2 ,
196 p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
197 p_message_name OUT NOCOPY VARCHAR2)
198 RETURN BOOLEAN;
199 PRAGMA RESTRICT_REFERENCES (admp_val_acai_late,WNDS,WNPS);
200 --
201 -- Validate the admission course appl instance offering option details.
202 FUNCTION admp_val_acai_opt(
203 p_course_cd IN VARCHAR2 ,
204 p_version_number IN NUMBER ,
205 p_acad_cal_type IN VARCHAR2 ,
206 p_acad_ci_sequence_number IN NUMBER ,
207 p_location_cd IN VARCHAR2 ,
208 p_attendance_mode IN VARCHAR2 ,
209 p_attendance_type IN VARCHAR2 ,
210 p_adm_cal_type IN VARCHAR2 ,
211 p_adm_ci_sequence_number IN NUMBER ,
212 p_admission_cat IN VARCHAR2 ,
213 p_s_admission_process_type IN VARCHAR2 ,
214 p_offer_ind IN VARCHAR2 DEFAULT 'N',
215 p_appl_dt IN DATE ,
216 p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
217 p_message_name OUT NOCOPY VARCHAR2)
218 RETURN BOOLEAN;
219
220 --
221 -- Validate the admission course application IGS_PS_UNIT set.
222 FUNCTION admp_val_acai_us(
223 p_unit_set_cd IN VARCHAR2 ,
224 p_us_version_number IN NUMBER ,
225 p_course_cd IN VARCHAR2 ,
226 p_crv_version_number IN NUMBER ,
227 p_acad_cal_type IN VARCHAR2 ,
228 p_location_cd IN VARCHAR2 ,
229 p_attendance_mode IN VARCHAR2 ,
230 p_attendance_type IN VARCHAR2 ,
231 p_admission_cat IN VARCHAR2 ,
232 p_offer_ind IN VARCHAR2 DEFAULT 'N',
233 p_unit_set_appl IN VARCHAR2 DEFAULT 'N',
234 p_message_name OUT NOCOPY VARCHAR2,
235 p_return_type OUT NOCOPY VARCHAR2 )
236 RETURN BOOLEAN;
237
238 --
239 -- Validate CACUS can only be created when US is not a subordinate
240 FUNCTION crsp_val_cacus_sub(
241 p_course_cd IN VARCHAR2 ,
242 p_crv_version_number IN NUMBER ,
243 p_cal_type IN VARCHAR2 ,
244 p_unit_set_cd IN VARCHAR2 ,
245 p_us_version_number IN NUMBER ,
246 p_message_name OUT NOCOPY VARCHAR2)
247 RETURN BOOLEAN;
248 --
249 -- Do encumbrance checks for the IGS_AD_PS_APPL_INST.unit_set_cd.
250 FUNCTION admp_val_us_encmb(
251 p_person_id IN NUMBER ,
252 p_course_cd IN VARCHAR2 ,
253 p_unit_set_cd IN VARCHAR2 ,
254 p_us_version_number IN NUMBER ,
255 p_adm_cal_type IN VARCHAR2 ,
256 p_adm_ci_sequence_number IN NUMBER ,
257 p_course_encmb_chk_ind IN VARCHAR2 DEFAULT 'N',
258 p_offer_ind IN VARCHAR2 DEFAULT 'N',
259 p_message_name OUT NOCOPY VARCHAR2,
260 p_return_type OUT NOCOPY VARCHAR2 )
261 RETURN BOOLEAN;
262 --
263 -- Validate the IGS_AD_PS_APPL_INST.offer_dt.
264 FUNCTION admp_val_offer_dt(
265 p_offer_dt IN DATE ,
266 p_adm_outcome_status IN VARCHAR2 ,
267 p_adm_cal_type IN VARCHAR2 ,
268 p_adm_ci_sequence_number IN NUMBER ,
269 p_message_name OUT NOCOPY VARCHAR2)
270 RETURN BOOLEAN;
271 --
272 -- Validate the IGS_AD_PS_APPL_INST.offer_response_dt.
273 FUNCTION admp_val_off_resp_dt(
274 p_offer_response_dt IN DATE ,
275 p_adm_outcome_status IN VARCHAR2 ,
276 p_offer_dt IN DATE ,
277 p_message_name OUT NOCOPY VARCHAR2)
278 RETURN BOOLEAN;
279 --
280 -- Validate the IGS_AD_PS_APPL_INST.actual_response_dt.
281 FUNCTION admp_val_act_resp_dt(
282 p_actual_response_dt IN DATE ,
283 p_adm_offer_resp_status IN VARCHAR2 ,
284 p_offer_dt IN DATE ,
285 p_message_name OUT NOCOPY VARCHAR2)
286 RETURN BOOLEAN;
287 --
288 -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_satisfied_dt.
289 FUNCTION admp_val_stsfd_dt(
290 p_cndtnl_offer_satisfied_dt IN DATE ,
291 p_adm_cndtnl_offer_status IN VARCHAR2 ,
292 p_message_name OUT NOCOPY VARCHAR2)
293 RETURN BOOLEAN;
294 --
295 -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_cndtn.
296 FUNCTION admp_val_offer_cndtn(
297 p_cndtnl_offer_cndtn IN VARCHAR2 ,
298 p_adm_cndtnl_offer_status IN VARCHAR2 ,
299 p_message_name OUT NOCOPY VARCHAR2)
300 RETURN BOOLEAN;
301 --
302 -- Validate the IGS_AD_PS_APPL_INST.applicant_acptnce_cndtn.
303 FUNCTION admp_val_acpt_cndtn(
304 p_applicant_acptnce_cndtn IN VARCHAR2 ,
305 p_adm_offer_resp_status IN VARCHAR2 ,
306 p_message_name OUT NOCOPY VARCHAR2)
307 RETURN BOOLEAN;
308 --
309 -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind.
310 FUNCTION admp_val_must_stsfd(
311 p_cndtnl_off_must_be_stsfd_ind IN VARCHAR2 DEFAULT 'N',
312 p_adm_cndtnl_offer_status IN VARCHAR2 ,
313 p_adm_offer_resp_status IN VARCHAR2 ,
314 p_cndtnl_offer_satisfied_dt IN DATE ,
315 p_message_name OUT NOCOPY VARCHAR2)
316 RETURN BOOLEAN;
317 --
318 -- Validate adm course application instance deferred admission calendar.
319 FUNCTION admp_val_dfrmnt_cal(
323 p_adm_offer_resp_status IN VARCHAR2 ,
320 p_deferred_adm_cal_type IN VARCHAR2 ,
321 p_deferred_adm_ci_sequence_num IN NUMBER ,
322 p_acad_cal_type IN VARCHAR2 ,
324 p_admission_cat IN VARCHAR2 ,
325 p_s_admission_process_type IN VARCHAR2 ,
326 p_appl_dt IN DATE ,
327 p_course_cd IN VARCHAR2 ,
328 p_crv_version_number IN NUMBER ,
329 p_location_cd IN VARCHAR2 ,
330 p_attendance_mode IN VARCHAR2 ,
331 p_attendance_type IN VARCHAR2 ,
332 p_unit_set_cd IN VARCHAR2 ,
333 p_us_version_number IN NUMBER ,
334 p_deferral_allowed IN VARCHAR2 DEFAULT 'N',
335 p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
336 p_message_name OUT NOCOPY VARCHAR2,
337 p_return_type OUT NOCOPY VARCHAR2,
338 p_def_acad_ci_sequence_num IN NUMBER DEFAULT NULL
339 )
340 RETURN BOOLEAN;
341 --
342 -- Validate if admission course application instance corresponce cat.
343 FUNCTION admp_val_acai_cc(
344 p_admission_cat IN VARCHAR2 ,
345 p_correspondence_cat IN VARCHAR2 ,
346 p_message_name OUT NOCOPY VARCHAR2)
347 RETURN BOOLEAN;
348 --
349 -- Validate if IGS_CO_CAT.correspondence_cat is closed.
350 FUNCTION corp_val_cc_closed(
351 p_correspondence_cat IN VARCHAR2 ,
352 p_message_name OUT NOCOPY VARCHAR2)
353 RETURN BOOLEAN;
354 --
355 -- Validate if admission course application instance enrolment category.
356 FUNCTION admp_val_acai_ec(
357 p_admission_cat IN VARCHAR2 ,
358 p_enrolment_cat IN VARCHAR2 ,
359 p_message_name OUT NOCOPY VARCHAR2)
360 RETURN BOOLEAN;
361 --
362 -- bug id : 1956374
363 -- sjadhav,28-aug-2001
364 -- removed FUNCTION enrp_val_ec_closed
365 --
366 -- Validate if admission course application instance fee category.
367 FUNCTION admp_val_acai_fc(
368 p_admission_cat IN VARCHAR2 ,
369 p_fee_cat IN VARCHAR2 ,
370 p_message_name OUT NOCOPY VARCHAR2)
371 RETURN BOOLEAN;
372 --
373 -- Validate admission course application instance HECS payment option.
374 FUNCTION admp_val_acai_hpo(
375 p_admission_cat IN VARCHAR2 ,
376 p_hecs_payment_option IN VARCHAR2 ,
377 p_message_name OUT NOCOPY VARCHAR2)
378 RETURN BOOLEAN;
379 --
380 --
381 -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status_auth_dt.
382 FUNCTION admp_val_ovrd_dt(
383 p_adm_outcome_status_auth_dt IN DATE ,
384 p_override_outcome_allowed IN VARCHAR2 DEFAULT 'N',
385 p_message_name OUT NOCOPY VARCHAR2)
386 RETURN BOOLEAN;
387 --
388 -- Validate the IGS_AD_PS_APPL_INST.adm_otcm_status_auth_person_id.
389 FUNCTION admp_val_ovrd_person(
390 p_adm_otcm_status_auth_person IN NUMBER ,
391 p_adm_outcome_status_auth_dt IN DATE ,
392 p_override_outcome_allowed IN VARCHAR2 DEFAULT 'N',
393 p_message_name OUT NOCOPY VARCHAR2)
394 RETURN BOOLEAN;
395 --
396 -- Validate a person id to ensure the person is a staff member.
397 FUNCTION genp_val_staff_prsn(
398 p_person_id IN NUMBER ,
399 p_message_name OUT NOCOPY VARCHAR2)
400 RETURN BOOLEAN;
401
402 PRAGMA RESTRICT_REFERENCES (genp_val_staff_prsn,WNDS);
403 --
404 -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status_reason.
405 FUNCTION admp_val_ovrd_reason(
406 p_adm_outcome_status_reason IN VARCHAR2 ,
407 p_adm_outcome_status_auth_dt IN DATE ,
408 p_override_outcome_allowed IN VARCHAR2 DEFAULT 'N',
409 p_message_name OUT NOCOPY VARCHAR2)
410 RETURN BOOLEAN;
411 --
412 -- Validate that the course application is complete on offer.
413 FUNCTION admp_val_offer_comp(
414 p_person_id IN NUMBER ,
415 p_admission_appl_number IN NUMBER ,
416 p_nominated_course_cd IN VARCHAR2 ,
417 p_acai_sequence_number IN NUMBER ,
418 p_course_cd IN VARCHAR2 ,
419 p_crv_version_number IN NUMBER ,
420 p_admission_cat IN VARCHAR2 ,
421 p_s_admission_process_type IN VARCHAR2 ,
422 p_effective_dt IN DATE ,
423 p_called_from IN VARCHAR2 ,
424 p_message_name OUT NOCOPY VARCHAR2)
425 RETURN BOOLEAN;
426 --
427 -- Validate if the specified IGS_AD_PS_APPL_INST is complete.
428 FUNCTION admp_val_acai_comp(
429 p_person_id IN NUMBER ,
430 p_admission_appl_number IN NUMBER ,
431 p_nominated_course_cd IN VARCHAR2 ,
432 p_acai_sequence_number IN NUMBER ,
433 p_course_cd IN VARCHAR2 ,
434 p_crv_version_number IN NUMBER ,
435 p_s_admission_process_type IN VARCHAR2 ,
436 p_effective_dt IN DATE ,
437 p_check_referee IN BOOLEAN ,
438 p_check_scholarship IN BOOLEAN ,
439 p_check_lang_prof IN BOOLEAN ,
440 p_check_interview IN BOOLEAN ,
441 p_check_exchange IN BOOLEAN ,
442 p_check_adm_test IN BOOLEAN ,
443 p_check_fee_assess IN BOOLEAN ,
444 p_check_cor_category IN BOOLEAN ,
445 p_check_enr_category IN BOOLEAN ,
446 p_check_research IN BOOLEAN ,
447 p_check_rank_app IN BOOLEAN ,
448 p_check_completion IN BOOLEAN ,
449 p_check_rank_set IN BOOLEAN ,
450 p_check_basis_adm IN BOOLEAN ,
451 p_check_crs_international IN BOOLEAN ,
452 p_check_ass_tracking IN BOOLEAN ,
453 p_check_adm_code IN BOOLEAN ,
454 p_check_fund_source IN BOOLEAN ,
455 p_check_location IN BOOLEAN ,
456 p_check_att_mode IN BOOLEAN ,
457 p_check_att_type IN BOOLEAN ,
458 p_check_unit_set IN BOOLEAN ,
462 p_valid_lang_prof OUT NOCOPY BOOLEAN ,
459 p_message_name OUT NOCOPY VARCHAR2,
460 p_valid_referee OUT NOCOPY BOOLEAN ,
461 p_valid_scholarship OUT NOCOPY BOOLEAN ,
463 p_valid_interview OUT NOCOPY BOOLEAN ,
464 p_valid_exchange OUT NOCOPY BOOLEAN ,
465 p_valid_adm_test OUT NOCOPY BOOLEAN ,
466 p_valid_fee_assess OUT NOCOPY BOOLEAN ,
467 p_valid_cor_category OUT NOCOPY BOOLEAN ,
468 p_valid_enr_category OUT NOCOPY BOOLEAN ,
469 p_valid_research OUT NOCOPY BOOLEAN ,
470 p_valid_rank_app OUT NOCOPY BOOLEAN ,
471 p_valid_completion OUT NOCOPY BOOLEAN ,
472 p_valid_rank_set OUT NOCOPY BOOLEAN ,
473 p_valid_basis_adm OUT NOCOPY BOOLEAN ,
474 p_valid_crs_international OUT NOCOPY BOOLEAN ,
475 p_valid_ass_tracking OUT NOCOPY BOOLEAN ,
476 p_valid_adm_code OUT NOCOPY BOOLEAN ,
477 p_valid_fund_source OUT NOCOPY BOOLEAN ,
478 p_valid_location OUT NOCOPY BOOLEAN ,
479 p_valid_att_mode OUT NOCOPY BOOLEAN ,
480 p_valid_att_type OUT NOCOPY BOOLEAN ,
481 p_valid_unit_set OUT NOCOPY BOOLEAN )
482 RETURN BOOLEAN;
483 --
484 -- Validate if the specified admission application person is complete.
485 FUNCTION admp_val_pe_comp(
486 p_person_id IN NUMBER ,
487 p_effective_dt IN DATE ,
488 p_check_athletics IN BOOLEAN ,
489 p_check_alternate IN BOOLEAN ,
490 p_check_address IN BOOLEAN ,
491 p_check_disability IN BOOLEAN ,
492 p_check_visa IN BOOLEAN ,
493 p_check_finance IN BOOLEAN ,
494 p_check_notes IN BOOLEAN ,
495 p_check_statistics IN BOOLEAN ,
496 p_check_alias IN BOOLEAN ,
497 p_check_tertiary IN BOOLEAN ,
498 p_check_aus_sec_ed IN BOOLEAN ,
499 p_check_os_sec_ed IN BOOLEAN ,
500 p_check_employment IN BOOLEAN ,
501 p_check_membership IN BOOLEAN ,
502 p_check_dob IN BOOLEAN ,
503 p_check_title IN BOOLEAN ,
504 p_check_excurr IN BOOLEAN DEFAULT FALSE, --tray
505 p_message_name OUT NOCOPY VARCHAR2,
506 p_valid_athletics OUT NOCOPY BOOLEAN ,
507 p_valid_alternate OUT NOCOPY BOOLEAN ,
508 p_valid_address OUT NOCOPY BOOLEAN ,
509 p_valid_disability OUT NOCOPY BOOLEAN ,
510 p_valid_visa OUT NOCOPY BOOLEAN ,
511 p_valid_finance OUT NOCOPY BOOLEAN ,
512 p_valid_notes OUT NOCOPY BOOLEAN ,
513 p_valid_statistics OUT NOCOPY BOOLEAN ,
514 p_valid_alias OUT NOCOPY BOOLEAN ,
515 p_valid_tertiary OUT NOCOPY BOOLEAN ,
516 p_valid_aus_sec_ed OUT NOCOPY BOOLEAN ,
517 p_valid_os_sec_ed OUT NOCOPY BOOLEAN ,
518 p_valid_employment OUT NOCOPY BOOLEAN ,
519 p_valid_membership OUT NOCOPY BOOLEAN ,
520 p_valid_dob OUT NOCOPY BOOLEAN ,
521 p_valid_title OUT NOCOPY BOOLEAN,
522 p_valid_excurr OUT NOCOPY BOOLEAN) --tray
523 RETURN BOOLEAN;
524 --
525 -- Validate the deferment of IGS_AD_PS_APLINSTUNT records.
526 FUNCTION admp_val_acaiu_defer(
527 p_person_id IN NUMBER ,
528 p_admission_appl_number IN NUMBER ,
529 p_nominated_course_cd IN VARCHAR2 ,
530 p_acai_sequence_number IN NUMBER ,
531 p_acad_cal_type IN VARCHAR2 ,
532 p_acad_ci_sequence_number IN NUMBER ,
533 p_adm_cal_type IN VARCHAR2 ,
534 p_adm_ci_sequence_number IN NUMBER ,
535 p_s_admission_process_type IN VARCHAR2 ,
536 p_message_name OUT NOCOPY VARCHAR2)
537 RETURN BOOLEAN;
538 --
539 -- Validate the IGS_AD_PS_APPL_INST.preference_number.
540 FUNCTION admp_val_acai_pref(
541 p_preference_number IN NUMBER ,
542 p_pref_allowed IN VARCHAR2 DEFAULT 'N',
543 p_pref_limit IN NUMBER ,
544 p_s_admission_process_type IN VARCHAR2 ,
545 p_message_name OUT NOCOPY VARCHAR2)
546 RETURN BOOLEAN;
547 --
548 -- Validate adm course application instance expected completion details.
549 FUNCTION admp_val_expctd_comp(
550 p_expected_completion_yr IN NUMBER ,
551 p_expected_completion_perd IN VARCHAR2 ,
552 p_message_name OUT NOCOPY VARCHAR2)
553 RETURN BOOLEAN;
554 --
555 -- Validate the admission course application instance funding source.
556 FUNCTION admp_val_acai_fs(
557 p_course_cd IN VARCHAR2 ,
558 p_version_number IN NUMBER ,
559 p_funding_source IN VARCHAR2 ,
560 p_message_name OUT NOCOPY VARCHAR2)
561 RETURN BOOLEAN;
562 --
563 -- Validate a IGS_PE_PERSON id to ensure the IGS_PE_PERSON is a staff member.
564 FUNCTION genp_val_staff_fculty_prsn(
565 p_person_id IN NUMBER ,
566 p_message_name OUT NOCOPY VARCHAR2 )
567 RETURN BOOLEAN;
568
569 -- Validate a IGS_PE_PERSON id to ensure the IGS_PE_PERSON is a staff/Faculty OR Evaluator member.
570 FUNCTION genp_val_staff_fac_eva_prsn(
571 p_person_id IN NUMBER ,
572 p_message_name OUT NOCOPY VARCHAR2 )
573 RETURN BOOLEAN;
574
575
576 END IGS_AD_VAL_ACAI;