1 PACKAGE IGS_EN_GEN_010 AS
2 /* $Header: IGSEN10S.pls 120.1 2005/08/18 05:58:26 appldev ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --Bayadav 09-Nov-2001 Added the columns catalog cal type and catalog seq num in Enrp_ins_susa_hist as a part of build of career impact DLD
7 --Nalin Kumar 11-Nov-2001 Added Procedure 'adv_stand_trans' as pert of the Career Impact DLD.
8 -- Bug# 2027984.
9 --smaddali 26-dec-2001 added 18 new params from units 9-12 and unit set cd1,2 to procedures enrp_ins_snew/sret_prenrl
10 -- bug# 2156956
11 --Nalin Kumar 28-Jan-2002 Added Procedure 'enrp_ins_sca_ukstat_trnsfr' as pert of the HESA Intregation DLD (ENCR019).
12 -- Bug# 2201753.
13 --Nishikant 07OCT2002 UK Enhancement Build - Enh Bug#2580731 - Added the parameter p_selection_date in the Function Enrp_Ins_Sret_Prenrl
14 --kkillams 25-04-2003 New parameters p_new_uoo_id and p_old_uoo_id to the function Enrp_Ins_Sua_Hist.
15 -- New parameter p_uoo_id added to the Enrp_Ins_Sua_Trnsfr and Enrp_Ins_Suao_Discon functions
16 -- w.r.t. bug number 2829262
17 --amuthu 10-JUN-2003 modified as per the UK Streaming and Repeat TD (bug 2829265)
18 --kkillams 16-06-2003 Three new parameters are added to the Enrp_Ins_Snew_Prenrl and Enrp_Ins_Sret_Prenrl functions
19 -- w.r.t. bug no 2829270
20 --ptandon 06-Oct-2003 Modified the specifications of Enrp_Ins_Sua_Hist and Enrp_Vald_Inst_Sua as part of
21 -- Prevent Dropping Core Units. Enh Bug# 3052432.
22 -- amuthu 21-NOV-2004 Modified as part of program transfer build, modified enrp_ins_sua_trnsfr.
23 -- Added new procedure to copy outcome and placement details
24 -- ckasu 11-Dec-2004 Modified signature of Enrp_del_all_Sua_Trnsfr by adding new parameter and removed
25 -- Enrp_del_Sua_Trnsfr as a part of bug#4061818
26 -- smaddali 21-dec-04 created new function unit_effect_or_future_term for bug#4083358
27 -- rvangala 12-AUG-2005 Bug #4551013. EN320 Build
28 -------------------------------------------------------------------------------------------
29 FUNCTION Enrp_Ins_Snew_Prenrl(
30 p_person_id IN NUMBER ,
31 p_course_cd IN VARCHAR2 ,
32 p_enrolment_cat IN VARCHAR2 ,
33 p_acad_cal_type IN VARCHAR2 ,
34 p_acad_sequence_number IN NUMBER ,
35 p_units_indicator IN VARCHAR2 ,
36 p_dflt_confirmed_course_ind IN VARCHAR2 ,
37 p_override_enr_form_due_dt IN DATE ,
38 p_override_enr_pckg_prod_dt IN DATE ,
39 p_check_eligibility_ind IN VARCHAR2 ,
40 p_acai_admission_appl_number IN NUMBER ,
41 p_acai_nominated_course_cd IN VARCHAR2 ,
42 p_acai_sequence_number IN NUMBER ,
43 p_unit1_unit_cd IN VARCHAR2 ,
44 p_unit1_cal_type IN VARCHAR2 ,
45 p_unit1_location_cd IN VARCHAR2 ,
46 p_unit1_unit_class IN VARCHAR2 ,
47 p_unit2_unit_cd IN VARCHAR2 ,
48 p_unit2_cal_type IN VARCHAR2 ,
49 p_unit2_location_cd IN VARCHAR2 ,
50 p_unit2_unit_class IN VARCHAR2 ,
51 p_unit3_unit_cd IN VARCHAR2 ,
52 p_unit3_cal_type IN VARCHAR2 ,
53 p_unit3_location_cd IN VARCHAR2 ,
54 p_unit3_unit_class IN VARCHAR2 ,
55 p_unit4_unit_cd IN VARCHAR2 ,
56 p_unit4_cal_type IN VARCHAR2 ,
57 p_unit4_location_cd IN VARCHAR2 ,
58 p_unit4_unit_class IN VARCHAR2 ,
59 p_unit5_unit_cd IN VARCHAR2 ,
60 p_unit5_cal_type IN VARCHAR2 ,
61 p_unit5_location_cd IN VARCHAR2 ,
62 p_unit5_unit_class IN VARCHAR2 ,
63 p_unit6_unit_cd IN VARCHAR2 ,
64 p_unit6_cal_type IN VARCHAR2 ,
65 p_unit6_location_cd IN VARCHAR2 ,
66 p_unit6_unit_class IN VARCHAR2 ,
67 p_unit7_unit_cd IN VARCHAR2 ,
68 p_unit7_cal_type IN VARCHAR2 ,
69 p_unit7_location_cd IN VARCHAR2 ,
70 p_unit7_unit_class IN VARCHAR2 ,
71 p_unit8_unit_cd IN VARCHAR2 ,
72 p_unit8_cal_type IN VARCHAR2 ,
73 p_unit8_location_cd IN VARCHAR2 ,
74 p_unit8_unit_class IN VARCHAR2 ,
75 p_log_creation_dt IN DATE ,
76 p_warn_level IN OUT NOCOPY VARCHAR2 ,
77 p_message_name OUT NOCOPY VARCHAR2 ,
78 --smaddali addded these 18 params for YOP-EN build bug#2156956
79 p_unit9_unit_cd IN VARCHAR2 DEFAULT NULL,
80 p_unit9_cal_type IN VARCHAR2 DEFAULT NULL,
81 p_unit9_location_cd IN VARCHAR2 DEFAULT NULL,
82 p_unit9_unit_class IN VARCHAR2 DEFAULT NULL,
83 p_unit10_unit_cd IN VARCHAR2 DEFAULT NULL,
84 p_unit10_cal_type IN VARCHAR2 DEFAULT NULL,
85 p_unit10_location_cd IN VARCHAR2 DEFAULT NULL,
86 p_unit10_unit_class IN VARCHAR2 DEFAULT NULL,
87 p_unit11_unit_cd IN VARCHAR2 DEFAULT NULL,
88 p_unit11_cal_type IN VARCHAR2 DEFAULT NULL,
89 p_unit11_location_cd IN VARCHAR2 DEFAULT NULL,
90 p_unit11_unit_class IN VARCHAR2 DEFAULT NULL,
91 p_unit12_unit_cd IN VARCHAR2 DEFAULT NULL,
92 p_unit12_cal_type IN VARCHAR2 DEFAULT NULL,
93 p_unit12_location_cd IN VARCHAR2 DEFAULT NULL,
94 p_unit12_unit_class IN VARCHAR2 DEFAULT NULL,
95 p_unit_set_cd1 IN VARCHAR2 DEFAULT NULL,
96 p_unit_set_cd2 IN VARCHAR2 DEFAULT NULL,
97 p_progress_stat IN VARCHAR2 DEFAULT NULL,
98 p_dflt_enr_method IN VARCHAR2 DEFAULT NULL,
99 p_load_cal_type IN VARCHAR2 DEFAULT NULL,
100 p_load_ci_seq_num IN NUMBER DEFAULT NULL)
101 RETURN boolean;
102
103
104 FUNCTION Enrp_Ins_Sret_Prenrl(
105 p_person_id IN NUMBER ,
106 p_course_cd IN VARCHAR2 ,
107 p_enrolment_cat IN VARCHAR2 ,
108 p_acad_cal_type IN VARCHAR2 ,
109 p_acad_sequence_number IN NUMBER ,
110 p_enrol_cal_type IN VARCHAR2 ,
111 p_enrol_sequence_number IN NUMBER ,
112 p_units_ind IN VARCHAR2 DEFAULT 'N',
113 p_override_enr_form_due_dt IN DATE ,
114 p_override_enr_pckg_prod_dt IN DATE ,
115 p_log_creation_dt IN DATE ,
116 p_warn_level OUT NOCOPY VARCHAR2 ,
117 p_message_name OUT NOCOPY VARCHAR2 ,
118 --smaddali addded these params for YOP-EN build bug#2156956
119 p_unit1_unit_cd IN VARCHAR2 DEFAULT NULL,
120 p_unit1_cal_type IN VARCHAR2 DEFAULT NULL,
121 p_unit1_location_cd IN VARCHAR2 DEFAULT NULL,
122 p_unit1_unit_class IN VARCHAR2 DEFAULT NULL,
123 p_unit2_unit_cd IN VARCHAR2 DEFAULT NULL,
124 p_unit2_cal_type IN VARCHAR2 DEFAULT NULL,
125 p_unit2_location_cd IN VARCHAR2 DEFAULT NULL,
126 p_unit2_unit_class IN VARCHAR2 DEFAULT NULL,
127 p_unit3_unit_cd IN VARCHAR2 DEFAULT NULL,
128 p_unit3_cal_type IN VARCHAR2 DEFAULT NULL,
129 p_unit3_location_cd IN VARCHAR2 DEFAULT NULL,
130 p_unit3_unit_class IN VARCHAR2 DEFAULT NULL,
131 p_unit4_unit_cd IN VARCHAR2 DEFAULT NULL,
132 p_unit4_cal_type IN VARCHAR2 DEFAULT NULL,
133 p_unit4_location_cd IN VARCHAR2 DEFAULT NULL,
134 p_unit4_unit_class IN VARCHAR2 DEFAULT NULL,
135 p_unit5_unit_cd IN VARCHAR2 DEFAULT NULL,
136 p_unit5_cal_type IN VARCHAR2 DEFAULT NULL,
137 p_unit5_location_cd IN VARCHAR2 DEFAULT NULL,
138 p_unit5_unit_class IN VARCHAR2 DEFAULT NULL,
139 p_unit6_unit_cd IN VARCHAR2 DEFAULT NULL,
140 p_unit6_cal_type IN VARCHAR2 DEFAULT NULL,
141 p_unit6_location_cd IN VARCHAR2 DEFAULT NULL,
142 p_unit6_unit_class IN VARCHAR2 DEFAULT NULL,
143 p_unit7_unit_cd IN VARCHAR2 DEFAULT NULL,
144 p_unit7_cal_type IN VARCHAR2 DEFAULT NULL,
145 p_unit7_location_cd IN VARCHAR2 DEFAULT NULL,
146 p_unit7_unit_class IN VARCHAR2 DEFAULT NULL,
147 p_unit8_unit_cd IN VARCHAR2 DEFAULT NULL,
148 p_unit8_cal_type IN VARCHAR2 DEFAULT NULL,
149 p_unit8_location_cd IN VARCHAR2 DEFAULT NULL,
150 p_unit8_unit_class IN VARCHAR2 DEFAULT NULL,
151 p_unit9_unit_cd IN VARCHAR2 DEFAULT NULL,
152 p_unit9_cal_type IN VARCHAR2 DEFAULT NULL,
153 p_unit9_location_cd IN VARCHAR2 DEFAULT NULL,
154 p_unit9_unit_class IN VARCHAR2 DEFAULT NULL,
155 p_unit10_unit_cd IN VARCHAR2 DEFAULT NULL,
156 p_unit10_cal_type IN VARCHAR2 DEFAULT NULL,
157 p_unit10_location_cd IN VARCHAR2 DEFAULT NULL,
158 p_unit10_unit_class IN VARCHAR2 DEFAULT NULL,
159 p_unit11_unit_cd IN VARCHAR2 DEFAULT NULL,
160 p_unit11_cal_type IN VARCHAR2 DEFAULT NULL,
161 p_unit11_location_cd IN VARCHAR2 DEFAULT NULL,
162 p_unit11_unit_class IN VARCHAR2 DEFAULT NULL,
163 p_unit12_unit_cd IN VARCHAR2 DEFAULT NULL,
164 p_unit12_cal_type IN VARCHAR2 DEFAULT NULL,
165 p_unit12_location_cd IN VARCHAR2 DEFAULT NULL,
166 p_unit12_unit_class IN VARCHAR2 DEFAULT NULL,
167 p_unit_set_cd1 IN VARCHAR2 DEFAULT NULL,
168 p_unit_set_cd2 IN VARCHAR2 DEFAULT NULL,
169 --Added the parameter p_selection_date - UK Enhancement Build - Enh Bug#2580731 - 07OCT2002
170 p_selection_date IN DATE DEFAULT NULL,
171 --Added the parameter p_completion_date - ENCR030(UK Enh) Build - Enh Bug#2708430 - 16DEC2002
172 p_completion_date IN DATE DEFAULT NULL,
173 p_progress_stat IN VARCHAR2 DEFAULT NULL,
174 p_dflt_enr_method IN VARCHAR2 DEFAULT NULL,
175 p_load_cal_type IN VARCHAR2 DEFAULT NULL,
176 p_load_ci_seq_num IN NUMBER DEFAULT NULL)
177 RETURN BOOLEAN;
178
179 FUNCTION Enrp_Ins_Suao_Discon(
180 p_person_id IN NUMBER ,
181 p_course_cd IN VARCHAR2 ,
182 p_unit_cd IN VARCHAR2 ,
183 p_cal_type IN VARCHAR2 ,
184 p_ci_sequence_number IN NUMBER ,
185 p_ci_start_dt IN DATE ,
186 p_ci_end_dt IN DATE ,
187 p_discontinued_dt IN DATE ,
188 p_administrative_unit_status IN VARCHAR2 ,
189 p_message_name OUT NOCOPY VARCHAR2,
190 p_uoo_id IN NUMBER)
191 RETURN BOOLEAN;
192
193
194 PROCEDURE Enrp_Ins_Sua_Hist(
195 p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
196 p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
197 p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
198 p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
199 p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
200 p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
201 p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
202 p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
203 p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
204 p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
205 p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
206 p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
207 p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
208 p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
209 p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
210 p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
211 p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
212 p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
213 p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
214 p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
215 p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
216 p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
217 p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
218 p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
219 p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
220 p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
221 p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
222 p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
223 p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
224 p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
225 p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
226 p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
227 p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
228 p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
229 p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
230 p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
231 p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
232 p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
233 p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
234 p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
235 p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
236 p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
237 p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
238 p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
239 p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
240 p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
241 p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
242 p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
243 p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
244 p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
245 p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build
246 p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL -- ptandon, Prevent Dropping Core Units build
247 );
248
249 FUNCTION Enrp_Ins_Sua_Trnsfr(
250 p_person_id IN NUMBER ,
251 p_course_cd IN VARCHAR2 ,
252 p_transfer_course_cd IN VARCHAR2 ,
253 p_coo_id IN NUMBER ,
254 p_unit_cd IN VARCHAR2 ,
255 p_version_number IN NUMBER ,
256 p_cal_type IN VARCHAR2 ,
257 p_ci_sequence_number IN NUMBER ,
258 p_return_type OUT NOCOPY VARCHAR2 ,
259 p_message_name OUT NOCOPY VARCHAR2,
260 p_uoo_id IN NUMBER,
261 p_core_ind IN VARCHAR2,
262 p_term_cal_type IN VARCHAR2,
263 p_term_seq_num IN NUMBER)
264 RETURN BOOLEAN;
265
266
267 PROCEDURE Enrp_Ins_Susa_Hist(
268 p_person_id IN NUMBER ,
269 p_course_cd IN VARCHAR2 ,
270 p_unit_set_cd IN VARCHAR2 ,
271 p_sequence_number IN NUMBER ,
272 p_new_us_version_number IN NUMBER ,
273 p_old_us_version_number IN NUMBER ,
274 p_new_selection_dt IN DATE ,
275 p_old_selection_dt IN DATE ,
276 p_new_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
277 p_old_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
278 p_new_end_dt IN DATE ,
279 p_old_end_dt IN DATE ,
280 p_new_parent_unit_set_cd IN VARCHAR2 ,
281 p_old_parent_unit_set_cd IN VARCHAR2 ,
282 p_new_parent_sequence_number IN NUMBER ,
283 p_old_parent_sequence_number IN NUMBER ,
284 p_new_primary_set_ind IN VARCHAR2 DEFAULT 'N',
285 p_old_primary_set_ind IN VARCHAR2 DEFAULT 'N',
286 p_new_voluntary_end_ind IN VARCHAR2 DEFAULT 'N',
287 p_old_voluntary_end_ind IN VARCHAR2 DEFAULT 'N',
291 p_old_authorised_on IN DATE ,
288 p_new_authorised_person_id IN NUMBER ,
289 p_old_authorised_person_id IN NUMBER ,
290 p_new_authorised_on IN DATE ,
292 p_new_override_title IN VARCHAR2 ,
293 p_old_override_title IN VARCHAR2 ,
294 p_new_rqrmnts_complete_ind IN VARCHAR2 DEFAULT 'N',
295 p_old_rqrmnts_complete_ind IN VARCHAR2 DEFAULT 'N',
296 p_new_rqrmnts_complete_dt IN DATE ,
297 p_old_rqrmnts_complete_dt IN DATE ,
298 p_new_s_completed_source_type IN VARCHAR2 ,
299 p_old_s_completed_source_type IN VARCHAR2 ,
300 p_new_catalog_cal_type IN VARCHAR2 DEFAULT NULL,
301 p_old_catalog_cal_type IN VARCHAR2 DEFAULT NULL,
302 p_new_catalog_seq_num IN NUMBER DEFAULT NULL,
303 p_old_catalog_seq_num IN NUMBER DEFAULT NULL,
304 p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,
305 p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,
306 p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL,
307 p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL);
308
309 FUNCTION Enrp_Ins_Susa_Trnsfr(
310 p_person_id IN NUMBER ,
311 p_course_cd IN VARCHAR2 ,
312 p_transfer_course_cd IN VARCHAR2 ,
313 p_unit_set_cd IN VARCHAR2 ,
314 p_us_version_number IN NUMBER ,
315 p_sequence_number IN NUMBER ,
316 p_primary_set_ind IN VARCHAR2 DEFAULT 'N',
317 p_message_name out NOCOPY Varchar2 )
318 RETURN BOOLEAN;
319
320
321 FUNCTION Enrp_Ins_Sut_Trnsfr(
322 p_person_id IN NUMBER ,
323 p_course_cd IN VARCHAR2 ,
324 p_transfer_course_cd IN VARCHAR2 ,
325 p_transfer_dt IN DATE ,
326 p_unit_cd IN VARCHAR2 ,
327 p_cal_type IN VARCHAR2 ,
328 p_ci_sequence_number IN NUMBER ,
329 p_message_name OUT NOCOPY VARCHAR2,
330 p_uoo_id IN NUMBER)
331 RETURN BOOLEAN;
332
333 PROCEDURE adv_stand_trans(
334 p_person_id IN NUMBER,
335 p_course_cd IN VARCHAR2,
336 p_version_number IN NUMBER,
337 p_course_cd_new IN VARCHAR2,
338 p_version_number_new IN NUMBER,
339 p_message_name OUT NOCOPY VARCHAR2
340 );
341
342 PROCEDURE enrp_ins_sca_ukstat_trnsfr( p_person_id IN NUMBER,
343 p_source_course_cd IN VARCHAR2,
344 p_destination_course_cd IN VARCHAR2,
345 p_message_name OUT NOCOPY VARCHAR2 );
346 FUNCTION enrp_vald_inst_sua(
347 p_person_id IN igs_en_su_attempt.person_id%TYPE,
348 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
349 p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
350 p_version_number IN igs_en_su_attempt.version_number%TYPE,
351 p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
352 p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
353 p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
354 p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
355 p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
356 p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
357 p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
358 p_enr_method IN igs_en_method_type.enr_method_type%TYPE,
359 p_core_indicator_code IN igs_en_su_attempt.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build
360 p_message OUT NOCOPY VARCHAR2)
361 RETURN BOOLEAN;
362
363 FUNCTION enrf_unit_from_past(
364 p_person_id IN NUMBER,
365 p_source_course_cd IN VARCHAR2,
366 p_uoo_id IN NUMBER,
367 p_unit_attempt_status IN VARCHAR2,
368 p_discontinued_dt IN DATE,
369 p_term_cal_type IN VARCHAR2,
370 p_term_seq_num IN NUMBER) RETURN BOOLEAN;
371
372 FUNCTION Enrp_del_all_Sua_Trnsfr(
373 p_person_id IN NUMBER ,
374 p_source_course_cd IN VARCHAR2 ,
375 p_dest_course_cd IN VARCHAR2 ,
376 p_uoo_ids IN VARCHAR2,
380 p_message_name OUT NOCOPY VARCHAR2
377 P_TERM_CAL_TYPE IN VARCHAR2,
378 P_TERM_SEQ_NUM IN NUMBER,
379 p_drop IN BOOLEAN,
381 ) RETURN BOOLEAN;
382
383 PROCEDURE Enrp_Ins_Splace_Trnsfr (
384 p_person_id IN NUMBER,
385 p_source_course_cd IN VARCHAR2,
386 p_dest_course_cd IN VARCHAR2,
387 p_source_uoo_id IN NUMBER,
388 p_dest_uoo_id IN NUMBER);
389
390 PROCEDURE Enrp_Ins_Suao_Trnsfr (
391 p_person_id IN NUMBER,
392 p_source_course_cd IN VARCHAR2,
393 p_dest_course_cd IN VARCHAR2,
394 p_source_uoo_id IN NUMBER,
395 p_dest_uoo_id IN NUMBER,
396 p_delete_source IN BOOLEAN);
397
398 FUNCTION enrf_sup_sua_exists(
399 p_person_id IN NUMBER,
400 p_course_cd IN VARCHAR2,
401 p_uoo_id IN NUMBER)
402 RETURN BOOLEAN;
403
404 -- smaddali added this function for bug#4083358
405 FUNCTION unit_effect_or_future_term( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
406 p_dest_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
407 p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
408 p_term_cal_type igs_ca_inst_all.cal_type%TYPE,
409 p_term_seq_num igs_ca_inst_all.sequence_number%TYPE)
410 RETURN BOOLEAN ;
411
412 PROCEDURE enrp_ins_suai_trnsfr(
413 p_person_id IN NUMBER,
414 p_source_course_cd IN VARCHAR2,
415 p_dest_course_cd IN VARCHAR2,
416 p_source_uoo_id IN NUMBER,
417 p_dest_uoo_id IN NUMBER,
418 p_delete_source IN BOOLEAN);
419
420
421 END IGS_EN_GEN_010;
[Home] [Help]