1 PACKAGE IGS_AD_VAL_ACAIU AUTHID CURRENT_USER AS
2 /* $Header: IGSAD23S.pls 115.6 2003/12/03 20:49:00 knag ship $ */
3 -- Bug #1956374
4 -- As part of the bug# 1956374 removed the function crsp_val_um_closed
5
6 -- Validate the ins/upd/del admission course application instance unit
7 FUNCTION admp_val_acaiu_iud(
8 p_person_id IN NUMBER ,
9 p_admission_appl_number IN NUMBER ,
10 p_nominated_course_cd IN VARCHAR2 ,
11 p_acai_sequence_number IN NUMBER ,
12 p_unit_restr_ind IN VARCHAR2 DEFAULT 'N',
13 p_message_name OUT NOCOPY VARCHAR2)
14 RETURN BOOLEAN;
15
16 --
17 -- Validate the admission course application instance unit
18 FUNCTION admp_val_acaiu_unit(
19 p_unit_cd IN VARCHAR2 ,
20 p_uv_version_number IN NUMBER ,
21 p_adm_cal_type IN VARCHAR2 ,
22 p_adm_ci_sequence_number IN NUMBER ,
23 p_acad_cal_type IN VARCHAR2 ,
24 p_acad_ci_sequence_number IN NUMBER ,
25 p_s_admission_process_type IN VARCHAR2 ,
26 p_offered_ind IN VARCHAR2 DEFAULT 'N',
27 p_message_name OUT NOCOPY VARCHAR2)
28 RETURN BOOLEAN;
29 --
30 -- Validate the admission course application instance unit
31 FUNCTION admp_val_acaiu_opt(
32 p_unit_cd IN VARCHAR2 ,
33 p_uv_version_number IN NUMBER ,
34 p_cal_type IN VARCHAR2 ,
35 p_ci_sequence_number IN NUMBER ,
36 p_location_cd IN VARCHAR2 ,
37 p_unit_class IN VARCHAR2 ,
38 p_unit_mode IN VARCHAR2 ,
39 p_adm_cal_type IN VARCHAR2 ,
40 p_adm_ci_sequence_number IN NUMBER ,
41 p_acad_cal_type IN VARCHAR2 ,
42 p_acad_ci_sequence_number IN NUMBER ,
43 p_offered_ind IN VARCHAR2 DEFAULT 'N',
44 p_message_name OUT NOCOPY VARCHAR2)
45 RETURN BOOLEAN;
46 --
47 -- Validate the admission course application instance unit outcome status
48 FUNCTION admp_val_acaiu_auos(
49 p_person_id IN NUMBER ,
50 p_admission_appl_number IN NUMBER ,
51 p_nominated_course_cd IN VARCHAR2 ,
52 p_acai_sequence_number IN NUMBER ,
53 p_adm_unit_outcome_status IN VARCHAR2 ,
54 p_message_name OUT NOCOPY VARCHAR2)
55 RETURN BOOLEAN;
56 --
57 -- Validate the admission course application instance unit cal. instance
58 FUNCTION admp_val_acaiu_ci(
59 p_teach_cal_type IN VARCHAR2 ,
60 p_teach_ci_sequence_number IN NUMBER ,
61 p_adm_cal_type IN VARCHAR2 ,
62 p_adm_ci_sequence_number IN NUMBER ,
63 p_acad_cal_type IN VARCHAR2 ,
64 p_acad_ci_sequence_number IN NUMBER ,
65 p_val_adm_only_ind IN VARCHAR2 DEFAULT 'N',
66 p_offered_ind IN VARCHAR2 DEFAULT 'N',
67 p_message_name OUT NOCOPY VARCHAR2)
68 RETURN BOOLEAN;
69 --
70 -- Validate the unit mode of the admission course application inst unit.
71 FUNCTION admp_val_acaiu_um(
72 p_unit_class IN VARCHAR2 ,
73 p_unit_mode IN VARCHAR2 ,
74 p_message_name OUT NOCOPY VARCHAR2)
75 RETURN BOOLEAN;
76 --
77 -- Validate the admission course application instance unit restr number
78 FUNCTION admp_val_acaiu_restr(
79 p_person_id IN NUMBER ,
80 p_admission_appl_number IN NUMBER ,
81 p_nominated_course_cd IN VARCHAR2 ,
82 p_acai_sequence_number IN NUMBER ,
83 p_unit_cd IN VARCHAR2 ,
84 p_unit_restriction_num IN NUMBER ,
85 p_message_name OUT NOCOPY VARCHAR2,
86 p_uv_version_number IN NUMBER , -- Added for bug 3083148
87 p_cal_type IN VARCHAR2 , -- Added for bug 3083148
88 p_ci_sequence_number IN NUMBER , -- Added for bug 3083148
89 p_location_cd IN VARCHAR2 , -- Added for bug 3083148
90 p_unit_class IN VARCHAR2 ) -- Added for bug 3083148
91 RETURN BOOLEAN;
92 --
93 -- Validate if IGS_AD_OU_STAT.IGS_AD_OU_STAT is closed.
94 FUNCTION admp_val_auos_closed(
95 p_adm_unit_outcome_status IN VARCHAR2 ,
96 p_message_name OUT NOCOPY VARCHAR2)
97 RETURN BOOLEAN;
98 --
99 -- Validate the admission course application instance unit alternate code
100 FUNCTION admp_val_acaiu_altcd(
101 p_alternate_code IN VARCHAR2 ,
102 p_unit_cd IN VARCHAR2 ,
103 p_uv_version_number IN NUMBER ,
104 p_adm_cal_type IN VARCHAR2 ,
105 p_adm_ci_sequence_number IN NUMBER ,
106 p_acad_cal_type IN VARCHAR2 ,
107 p_acad_ci_sequence_number IN NUMBER ,
108 p_message_name OUT NOCOPY VARCHAR2)
109 RETURN BOOLEAN;
110 --
111 -- Validate the unit version of the admission course application.
112 FUNCTION admp_val_acaiu_uv(
113 p_unit_cd IN VARCHAR2 ,
114 p_uv_version_number IN NUMBER ,
115 p_s_admission_process_type IN VARCHAR2 ,
116 p_offered_ind IN VARCHAR2 ,
117 p_message_name OUT NOCOPY VARCHAR2)
118 RETURN BOOLEAN;
119 --
120 -- Do encumbrance check for admission_course_appl_instance_unit.unit_cd.
121 FUNCTION admp_val_acaiu_encmb(
122 p_person_id IN NUMBER ,
123 p_course_cd IN VARCHAR2 ,
124 p_unit_cd IN VARCHAR2 ,
125 p_adm_cal_type IN VARCHAR2 ,
126 p_adm_ci_sequence_number IN NUMBER ,
127 p_unit_encmb_chk_ind IN VARCHAR2 DEFAULT 'N',
128 p_offer_ind IN VARCHAR2 DEFAULT 'N',
129 p_message_name OUT NOCOPY VARCHAR2,
130 p_return_type OUT NOCOPY VARCHAR2 )
131 RETURN BOOLEAN;
132 --
133 -- Validate an admission course application instance research unit.
134 FUNCTION admp_val_res_unit(
135 p_person_id IN NUMBER ,
136 p_admission_appl_number IN NUMBER ,
137 p_nominated_course_cd IN VARCHAR2 ,
138 p_acai_sequence_number IN NUMBER ,
139 p_unit_cd IN VARCHAR2 ,
140 p_uv_version_number IN NUMBER ,
141 p_course_cd IN VARCHAR2 ,
142 p_offer_ind IN VARCHAR2 DEFAULT 'N',
143 p_s_admission_process_type IN VARCHAR2 ,
144 p_message_name OUT NOCOPY VARCHAR2,
145 p_return_type OUT NOCOPY VARCHAR2 )
146 RETURN BOOLEAN;
147 --
148 -- Validate the adm course appl inst unit against the teaching period.
149 FUNCTION admp_val_acaiu_uv_ci(
150 p_unit_cd IN VARCHAR2 ,
151 p_uv_version_number IN NUMBER ,
152 p_teach_cal_type IN VARCHAR2 ,
153 p_teach_ci_sequence_number IN NUMBER ,
154 p_message_name OUT NOCOPY VARCHAR2)
155 RETURN BOOLEAN;
156
157 END IGS_AD_VAL_ACAIU;