1 PACKAGE IGS_AD_VAL_AA AUTHID CURRENT_USER AS
2 /* $Header: IGSAD76S.pls 115.4 2002/11/28 21:41:31 nsidana ship $ */
3
4 --
5 -- Validate delete of an IGS_AD_APPL record.
6 FUNCTION admp_val_aa_delete(
7 p_adm_appl_status IN VARCHAR2 ,
8 p_message_name OUT NOCOPY VARCHAR2 )
9 RETURN BOOLEAN;
10 -- Validate insert of an IGS_AD_APPL record.
11 FUNCTION admp_val_aa_insert(
12 p_person_id IN NUMBER ,
13 p_adm_cal_type IN VARCHAR2 ,
14 p_adm_ci_sequence_number IN NUMBER ,
15 p_s_admission_process_type IN VARCHAR2 ,
16 p_encmb_chk_ind IN VARCHAR2 DEFAULT 'N',
17 p_appl_dt IN DATE ,
18 p_title_required_ind IN VARCHAR2 DEFAULT 'N',
19 p_birth_dt_required_ind IN VARCHAR2 DEFAULT 'N',
20 p_message_name OUT NOCOPY VARCHAR2 ,
21 p_return_type OUT NOCOPY VARCHAR2 )
22 RETURN BOOLEAN;
23 -- Validate update of an IGS_AD_APPL record.
24 FUNCTION admp_val_aa_update(
25 p_adm_appl_status IN VARCHAR2 ,
26 p_message_name OUT NOCOPY VARCHAR2 )
27 RETURN BOOLEAN;
28 -- Validate the IGS_AD_APPL.appl_dt.
29 FUNCTION admp_val_aa_appl_dt(
30 p_appl_dt IN DATE ,
31 p_message_name OUT NOCOPY VARCHAR2 )
32 RETURN BOOLEAN;
33 -- Validate the admission application academic calendar.
34 FUNCTION admp_val_aa_acad_cal(
35 p_acad_cal_type IN VARCHAR2 ,
36 p_acad_ci_sequence_number IN NUMBER ,
37 p_message_name OUT NOCOPY VARCHAR2 )
38 RETURN BOOLEAN;
39 -- Validate the admission application admission calendar.
40 FUNCTION admp_val_aa_adm_cal(
41 p_adm_cal_type IN VARCHAR2 ,
42 p_adm_ci_sequence_number IN NUMBER ,
43 p_acad_cal_type IN VARCHAR2 ,
44 p_acad_ci_sequence_number IN NUMBER ,
45 p_admission_cat IN VARCHAR2 ,
46 p_s_admission_process_type IN VARCHAR2 ,
47 p_message_name OUT NOCOPY VARCHAR2 )
48 RETURN BOOLEAN;
49 -- Validate the IGS_AD_APPL.admission_cat.
50 FUNCTION admp_val_aa_adm_cat(
51 p_admission_cat IN VARCHAR2 ,
52 p_message_name OUT NOCOPY VARCHAR2 )
53 RETURN BOOLEAN;
54 -- Validate the IGS_AD_APPL.adm_appl_status.
55 FUNCTION admp_val_aa_aas(
56 p_person_id IN NUMBER ,
57 p_admission_appl_number IN NUMBER ,
58 p_adm_appl_status IN VARCHAR2 ,
59 p_message_name OUT NOCOPY VARCHAR2 )
60 RETURN BOOLEAN;
61 -- Validate if IGS_AD_APPL_STAT.adm_appl_status is closed.
62 FUNCTION admp_val_aas_closed(
63 p_adm_appl_status IN VARCHAR2 ,
64 p_message_name OUT NOCOPY VARCHAR2 )
65 RETURN BOOLEAN;
66 -- Validate the IGS_AD_APPL.adm_fee_status.
67 FUNCTION admp_val_aa_afs(
68 p_person_id IN NUMBER ,
69 p_admission_appl_number IN NUMBER ,
70 p_adm_fee_status IN VARCHAR2 ,
71 p_fees_required_ind IN VARCHAR2 DEFAULT 'N',
72 p_cond_offer_fee_allowed IN VARCHAR2 DEFAULT 'N',
73 p_message_name OUT NOCOPY VARCHAR2 )
74 RETURN BOOLEAN;
75 -- Validate if IGS_AD_FEE_STAT.adm_fee_status is closed.
76
77 -- Validate the IGS_AD_APPL.tac_appl_ind.
78 FUNCTION admp_val_aa_tac_appl(
79 p_person_id IN NUMBER ,
80 p_tac_appl_ind IN VARCHAR2 DEFAULT 'N',
81 p_appl_dt IN DATE ,
82 p_s_admission_process_type IN VARCHAR2 ,
83 p_message_name OUT NOCOPY VARCHAR2 ,
84 p_return_type OUT NOCOPY VARCHAR2 )
85 RETURN BOOLEAN;
86 END IGS_AD_VAL_AA;