1 PACKAGE IGS_EN_VAL_SCA AS
2 /* $Header: IGSEN61S.pls 120.2 2006/05/02 23:56:53 ckasu ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --shtatiko 08-MAR-2004 Enh# 3167098, Removed finp_audit_fee_cat procedure.
7 --vchappid 28-Vov-01 Enh Bug No: 2122257, Added new procedure finp_audit_fee_cat
8 --smadathi 29-AUG-2001 Bug No. 1956374 .The function genp_val_sdtt_sess
9 --kkillams 11-11-2002 As part of Legacy Build bug no:2661533,
10 -- New parameter p_legacy is added to following functions
11 -- enrp_val_sca_lapse,enrp_val_sca_dr,enrp_val_sca_discont.
12 --ckasu 02-May-2006 Modified as a part of bug#5191592
13 -------------------------------------------------------------------------------------------
14 --msrinivi bug 1956364 Removed duplciate finp_val_fc_closed func
15 -- bug id : 1956374
16 -- sjadhav , 28-aug-2001
17 -- removed function ENRP_VAL_SCA_TRNSFR
18 --
19 --
20 -- Validate candidature proposed commencement date.
21 FUNCTION admp_val_ca_comm(
22 p_person_id IN NUMBER ,
23 p_course_cd IN VARCHAR2 ,
24 p_crv_version_number IN NUMBER ,
25 p_acai_admission_appl_number IN NUMBER ,
26 p_acai_nominated_course_cd IN VARCHAR2 ,
27 p_acai_sequence_number IN NUMBER ,
28 p_adm_outcome_status IN VARCHAR2 ,
29 p_commencement_dt IN DATE ,
30 p_min_submission_dt IN DATE ,
31 p_parent IN VARCHAR2 ,
32 p_ca_sequence_number IN OUT NOCOPY NUMBER ,
33 p_candidature_exists_ind OUT NOCOPY VARCHAR2 ,
34 p_message_name OUT NOCOPY VARCHAR2)
35 RETURN BOOLEAN;
36 --PRAGMA RESTRICT_REFERENCES( admp_val_ca_comm, WNDS);
37 --
38 -- Validate candidature proposed commencement date value.
39 FUNCTION admp_val_ca_comm_val(
40 p_person_id IN NUMBER ,
41 p_acai_admission_appl_number IN NUMBER ,
42 p_acai_nominated_course_cd IN VARCHAR2 ,
43 p_acai_sequence_number IN NUMBER ,
44 p_adm_cal_type IN VARCHAR2 ,
45 p_adm_ci_sequence_number IN NUMBER ,
46 p_course_start_dt IN DATE ,
47 p_prpsd_commencement_dt IN DATE ,
48 p_parent IN VARCHAR2 ,
49 p_message_name OUT NOCOPY VARCHAR2)
50 RETURN BOOLEAN;
51 --PRAGMA RESTRICT_REFERENCES( admp_val_ca_comm_val , WNDS);
52 --
53 -- Validate candidature attendance percentage
54 FUNCTION resp_val_ca_att_perc(
55 p_person_id IN NUMBER ,
56 p_course_cd IN VARCHAR2 ,
57 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
58 p_attendance_type IN VARCHAR2 ,
59 p_attendance_percentage IN NUMBER ,
60 p_candidature_ind IN VARCHAR2 DEFAULT 'N',
61 p_message_name OUT NOCOPY VARCHAR2)
62 RETURN BOOLEAN;
63 --PRAGMA RESTRICT_REFERENCES( resp_val_ca_att_perc , WNDS);
64 --
65 -- Validate that conditional offer is valid for course enrolment.
66 FUNCTION enrp_val_acai_cndtnl(
67 p_adm_cndtnl_offer_status IN VARCHAR2 ,
68 p_cndtnl_off_must_be_stsfd_ind IN VARCHAR2 DEFAULT 'N',
69 p_s_adm_cndtnl_offer_status OUT NOCOPY VARCHAR2 ,
70 p_message_name OUT NOCOPY VARCHAR2)
71 RETURN BOOLEAN;
72 PRAGMA RESTRICT_REFERENCES( enrp_val_acai_cndtnl,WNDS,WNPS);
73 --
74 -- Validate that research detail is valid for enrolment.
75 FUNCTION enrp_val_res_elgbl(
76 p_person_id IN NUMBER ,
77 p_course_cd IN VARCHAR2 ,
78 p_crv_version_number IN NUMBER ,
79 p_message_name OUT NOCOPY VARCHAR2)
80 RETURN BOOLEAN;
81 PRAGMA RESTRICT_REFERENCES( enrp_val_res_elgbl,WNDS,WNPS);
82 --
83 -- Validate if research candidature details are complete.
84 FUNCTION resp_val_ca_dtl_comp(
85 p_person_id IN NUMBER ,
86 p_sca_course_cd IN VARCHAR2 ,
87 p_acai_admission_appl_number IN NUMBER ,
88 p_acai_nominated_course_cd IN VARCHAR2 ,
89 p_acai_sequence_number IN NUMBER ,
90 p_parent IN VARCHAR2 ,
91 p_message_name OUT NOCOPY VARCHAR2)
92 RETURN BOOLEAN;
93 PRAGMA RESTRICT_REFERENCES( resp_val_ca_dtl_comp,WNDS,WNPS);
94
95 --
96 -- To validate student course attempt enrolled units satisfy rules.
97 FUNCTION enrp_val_unit_rule(
98 p_person_id IN NUMBER ,
99 p_course_cd IN VARCHAR2 ,
100 p_rule_check_ind IN VARCHAR2 DEFAULT 'N',
101 p_unit_cd OUT NOCOPY VARCHAR2 ,
102 p_uv_version_number OUT NOCOPY NUMBER ,
103 p_message_name OUT NOCOPY VARCHAR2,
104 p_message_text OUT NOCOPY VARCHAR2 )
105 RETURN BOOLEAN;
106 --PRAGMA RESTRICT_REFERENCES( enrp_val_unit_rule , WNDS);
107 --
108 -- To validate sca UNIT calendars against academic calendar type
109 FUNCTION ENRP_VAL_SCA_CAT(
110 p_person_id IN NUMBER ,
111 p_course_cd IN VARCHAR2 ,
112 p_cal_type IN VARCHAR2 ,
113 p_message_name OUT NOCOPY VARCHAR2)
114 RETURN boolean;
115 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SCA_CAT , WNDS);
116 --
117 -- To validate the IGS_EN_STDNT_PS_ATT.lapse_dt
118 FUNCTION ENRP_VAL_SCA_LAPSE(
119 p_course_attempt_status IN VARCHAR2 ,
120 p_lapse_dt IN DATE ,
121 p_message_name OUT NOCOPY VARCHAR2,
122 p_legacy IN VARCHAR2 DEFAULT 'N')
123 RETURN boolean;
124 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SCA_LAPSE, WNDS);
125 --
126 --
127 -- To validate acceptance of admission course transfer.
128 FUNCTION enrp_val_trnsfr_acpt(
129 p_person_id IN NUMBER ,
130 p_course_cd IN VARCHAR2 ,
131 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
132 p_admission_appl_number IN NUMBER ,
133 p_nominated_course_cd IN VARCHAR2 ,
134 p_adm_offer_resp_status IN VARCHAR2 ,
135 p_message_name OUT NOCOPY VARCHAR2)
136 RETURN BOOLEAN;
137 --PRAGMA RESTRICT_REFERENCES( enrp_val_trnsfr_acpt , WNDS);
138 --
139 -- To validate whether a change of course offering option is allowed
140 FUNCTION ENRP_VAL_CHGO_ALWD(
141 p_person_id IN NUMBER ,
142 p_course_cd IN VARCHAR2 ,
143 p_message_name OUT NOCOPY VARCHAR2)
144 RETURN boolean;
145 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_CHGO_ALWD , WNDS);
146 --
147 -- To validate all sua records against coo cross restrictions
148 FUNCTION ENRP_VAL_SUA_COO(
149 p_person_id IN NUMBER ,
150 p_course_cd IN VARCHAR2 ,
151 p_coo_id IN NUMBER ,
152 p_cal_type IN VARCHAR2 ,
153 p_sequence_number IN NUMBER ,
154 p_message_name1 OUT NOCOPY VARCHAR2 ,
155 p_message_name2 OUT NOCOPY VARCHAR2,
156 p_message_name3 OUT NOCOPY VARCHAR2 ,
157 p_load_or_teach_cal_type IN VARCHAR2,
158 p_load_or_teach_seq_number IN NUMBER)
159 RETURN boolean;
160 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUA_COO, WNDS);
161 --
162 -- To validate confirmed indicator on student course attempt
163 FUNCTION enrp_val_sca_confirm(
164 p_person_id IN NUMBER ,
165 p_course_cd IN VARCHAR2 ,
166 p_admission_appl_number IN NUMBER ,
167 p_nominated_course_cd IN VARCHAR2 ,
168 p_acai_sequence_number IN NUMBER ,
169 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
170 p_course_attempt_status IN VARCHAR2 ,
171 p_message_name OUT NOCOPY VARCHAR2)
172 RETURN BOOLEAN;
173 --PRAGMA RESTRICT_REFERENCES( enrp_val_sca_confirm , WNDS);
174 --
175 -- To validate the sca attendance type against the coo restriction
176 FUNCTION ENRP_VAL_COO_ATT(
177 p_person_id IN NUMBER ,
178 p_coo_id IN NUMBER ,
179 p_cal_type IN VARCHAR2 ,
180 p_ci_sequence_number IN NUMBER ,
181 p_message_name OUT NOCOPY VARCHAR2,
182 p_attendance_types OUT NOCOPY VARCHAR2,
183 p_load_or_teach_cal_type IN VARCHAR2,
184 p_load_or_teach_seq_number IN NUMBER)
185 RETURN boolean;
186 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_COO_ATT, WNDS);
187 --
188 -- To validate the SCA discontinuation reason code
189 FUNCTION enrp_val_sca_dr(
190 p_person_id IN NUMBER,
191 p_course_cd IN VARCHAR2,
192 p_discontinuation_reason_cd IN VARCHAR2,
193 p_discontinued_dt IN DATE,
194 p_message_name OUT NOCOPY VARCHAR2,
195 p_legacy IN VARCHAR2 DEFAULT 'N')
196 RETURN BOOLEAN;
197 --PRAGMA RESTRICT_REFERENCES( enrp_val_sca_dr, WNDS);
198 --
199 -- To validate the course attempt against funding source restrictions
200 FUNCTION ENRP_VAL_SCA_FSR(
201 p_course_cd IN VARCHAR2 ,
202 p_version_number IN NUMBER ,
203 p_funding_source IN VARCHAR2 ,
204 p_message_name OUT NOCOPY VARCHAR2)
205 RETURN boolean;
206 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SCA_FSR , WNDS);
207 --
208 -- To validate the discontinuation date and the reason cd
209 FUNCTION enrp_val_sca_discont(
210 p_person_id IN NUMBER ,
211 p_course_cd IN VARCHAR2 ,
212 p_version_number IN NUMBER ,
213 p_course_attempt_status IN VARCHAR2 ,
214 p_discontinuation_reason_cd IN VARCHAR2 ,
215 p_discontinued_dt IN DATE ,
216 p_commencement_dt IN DATE ,
217 p_message_name OUT NOCOPY VARCHAR2,
218 p_legacy IN VARCHAR2 DEFAULT 'N')
219 RETURN BOOLEAN;
220 --PRAGMA RESTRICT_REFERENCES( enrp_val_sca_discont , WNDS);
221 --
222 -- Validate the course commencement date against the students birth date
223 FUNCTION enrp_val_sca_comm(
224 p_person_id IN NUMBER ,
225 p_course_cd IN VARCHAR2 ,
226 p_commencement_dt IN DATE ,
227 p_acad_cal_type IN VARCHAR2 ,
228 p_acad_ci_sequence_number IN NUMBER ,
229 p_message_name OUT NOCOPY VARCHAR2)
230 RETURN BOOLEAN;
231 --PRAGMA RESTRICT_REFERENCES( enrp_val_sca_comm , WNDS);
232 --
233 -- To validate the student course attempt funding source
234 FUNCTION ENRP_VAL_SCA_FS(
235 p_course_cd IN VARCHAR2 ,
236 p_version_number IN NUMBER ,
237 p_funding_source IN VARCHAR2 ,
238 p_message_name OUT NOCOPY VARCHAR2)
239 RETURN BOOLEAN;
240 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SCA_FS , WNDS);
241 --
242 -- Validate the IGS_PS_OFR_PAT for a IGS_EN_STDNT_PS_ATT
243 FUNCTION enrp_val_sca_cop(
244 p_course_cd IN VARCHAR2 ,
245 p_version_number IN NUMBER ,
246 p_location_cd IN VARCHAR2 ,
247 p_attendance_type IN VARCHAR2 ,
248 p_attendance_mode IN VARCHAR2 ,
249 p_cal_type IN VARCHAR2 ,
250 p_ci_sequence_number IN NUMBER ,
251 p_message_name OUT NOCOPY VARCHAR2)
252 RETURN BOOLEAN;
253 --PRAGMA RESTRICT_REFERENCES( enrp_val_sca_cop, WNDS);
254 --
255
256
257 -- A FUNCTION enrp_val_sca_fc in this package has been removed as this will not be invoked
258 -- as per the build changes for the Fee clac Build (Bug 1851586)
259 -- This function validates whether the Student Program Attempt had an assessment
260 -- record with the specified Fee Category.
261 -- was invoked from IGS_EN_STDNT_PS_ATT_PKG.
262
263 --
264
265 FUNCTION handle_rederive_prog_att(
266 p_person_id IN NUMBER ,
267 p_admission_appl_number IN NUMBER ,
268 p_nominated_course_cd IN VARCHAR2 ,
269 p_sequence_number IN NUMBER,
270 p_message OUT NOCOPY VARCHAR2)
271 RETURN BOOLEAN;
272
273 END IGS_EN_VAL_SCA;