1 PACKAGE IGR_VAL_EAP AS
2 /* $Header: IGSRT08S.pls 120.0 2005/06/02 04:08:35 appldev noship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --sjlaport 18-Feb-05 Created for IGR Migration
7 ------------------------------------------------------------------------------------------
8
9 -- Validate the Enquiry application status.
10 FUNCTION admp_val_eap_es_comp(
11 p_person_id IN NUMBER ,
12 p_enquiry_appl_number IN NUMBER ,
13 p_enquiry_status IN VARCHAR2 ,
14 p_message_name OUT NOCOPY VARCHAR2)
15 RETURN BOOLEAN;
16
17 -- Validate the admission enquiry academic calendar.
18 FUNCTION admp_val_ae_acad_cal(
19 p_acad_cal_type IN VARCHAR2 ,
20 p_acad_ci_sequence_number IN NUMBER ,
21 p_message_name OUT NOCOPY VARCHAR2)
22 RETURN BOOLEAN;
23
24 -- Validate the admission enquiry admission calendar.
25 FUNCTION admp_val_ae_adm_cal(
26 p_adm_cal_type IN VARCHAR2 ,
27 p_adm_ci_sequence_number IN NUMBER ,
28 p_acad_cal_type IN VARCHAR2 ,
29 p_acad_ci_sequence_number IN NUMBER ,
30 p_message_name OUT NOCOPY VARCHAR2)
31 RETURN BOOLEAN;
32
33 -- Validate the Enquiry applicant has a current address.
34 FUNCTION admp_val_eap_addr(
35 p_person_id IN NUMBER ,
36 p_message_name OUT NOCOPY VARCHAR2)
37 RETURN BOOLEAN;
38
39 -- Validate the Enquiry application status on insert.
40 FUNCTION admp_val_eap_reg(
41 p_enquiry_status IN VARCHAR2 ,
42 p_message_name OUT NOCOPY VARCHAR2)
43 RETURN BOOLEAN;
44
45 -- Validate the Enquiry application status.
46 FUNCTION admp_val_eap_status(
47 p_person_id IN NUMBER ,
48 p_enquiry_appl_number IN NUMBER ,
49 p_old_enquiry_status IN VARCHAR2 ,
50 p_new_enquiry_status IN VARCHAR2 ,
51 p_message_name OUT NOCOPY VARCHAR2)
52 RETURN BOOLEAN;
53
54 -- Validate the Enquiry completion status.
55 FUNCTION admp_val_eap_comp(
56 p_person_id IN NUMBER ,
57 p_enquiry_appl_number IN NUMBER ,
58 p_message_name OUT NOCOPY VARCHAR2)
59 RETURN BOOLEAN;
60
61 -- Validate the Enquiry Status closed indicator.
62 FUNCTION admp_val_es_status(
63 p_enquiry_status IN VARCHAR2 ,
64 p_message_name OUT NOCOPY VARCHAR2)
65 RETURN BOOLEAN;
66
67 -- To validate the indicated mailing date of the enquiry package.
68 FUNCTION admp_val_eap_ind_dt(
69 p_enquiry_dt IN DATE ,
70 p_indicated_mailing_dt IN DATE ,
71 p_message_name OUT NOCOPY VARCHAR2)
72 RETURN BOOLEAN;
73
74
75 END IGR_VAL_EAP;
[Home] [Help]