1 PACKAGE IGS_EN_VAL_SUA AS
2 /* $Header: IGSEN68S.pls 120.2 2005/11/24 03:05:13 appldev ship $ */
3 -------------------------------------------------------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 28-AUG-2001 Bug No. 1956374 .The function declaration of GENP_VAL_STAFF_PRSN
7 -- removed .
8 --smadathi 25-AUG-2001 Bug No. 1956374 .The function declaration of GENP_VAL_SDTT_SESS
9 -- removed .
10 --kkillams 17-MAY-2002 New parameter is added to enrp_val_sua_ovrd_cp functionc w.r.t.
11 --Sudhir 24-MAY-2002 Added out NOCOPY parameter for procedure enrp_val_discont_aus
12 --svenkata 20-Nov-2002 Added a new parameter p_legacy to selectively carry out NOCOPY validations for legacy.
13 -- The following routines have been modified : enrp_val_sua_uoo , enrp_val_sua_enr_dt,
14 -- enrp_val_sua_advstnd,resp_val_sua_cnfrm,enrp_val_sua_discont,enrp_val_discont_aus
15 -- amuthu 20-JAn-2003 Added the no_assessment_ind column to the function enrp_val_sua_ovrd_cp
16 -- kkillams 28-04-2003 Added new parameter p_uoo_id to the enrp_get_sua_ausg, enrp_val_sua_dupl, enrp_val_sua_update
17 -- and enrp_val_sua_delete functions w.r.t. bug number 2829262
18 -- svenkata 3-Jun-2003 The function ENRP_VAL_COO_CROSS has been removed. The same functionality has been implemented as
19 -- cross-element restrictions of Validations. Bug# 2829272
20 -- svanukur 18-oct-2003 created procedures enr_sub_units and drop_sub_units as part of placements build 3052438
21 -- ckasu 17-Nov-2004 modfied signature of ENRP_VAL_SUA_CNFRM_P procedure by adding uoo_id and course_cd version
22 -- as apart of Program transfer Build#4000939
23 -- bdeviset 24-Nov_2005 Added proc validate_mus for bug#4676023
24 -------------------------------------------------------------------------------------------------------------------------------------------
25 --
26 --modified by sarakshi on 27-7-2001 to include p_uoo_id parameter in the function enrp_val_discont_aus
27
28 TYPE t_sua_duplicate_record IS RECORD
29 (
30 v_person_id IGS_EN_SU_ATTEMPT_ALL.PERSON_ID%TYPE,
31 v_course_cd IGS_EN_SU_ATTEMPT_ALL.COURSE_CD%TYPE,
32 v_unit_cd IGS_EN_SU_ATTEMPT_ALL.UNIT_CD%TYPE,
33 v_cal_type IGS_EN_SU_ATTEMPT_ALL.CAL_TYPE%TYPE,
34 v_ci_sequence_number IGS_EN_SU_ATTEMPT_ALL.CI_SEQUENCE_NUMBER%TYPE,
35 v_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE);
36 --
37 --
38 TYPE t_sua_discont_record IS RECORD
39 (
40 v_old_discontinued_dt IGS_EN_SU_ATTEMPT_ALL.DISCONTINUED_DT%TYPE,
41 v_discont_rowid ROWID);
42 --
43 --
44 TYPE t_sua_deleted_record IS RECORD
45 (
46 v_course_cd IGS_EN_SU_ATTEMPT_ALL.COURSE_CD%TYPE,
47 v_person_id IGS_EN_SU_ATTEMPT_ALL.PERSON_ID%TYPE);
48 --
49 --
50 TYPE t_sua_exists_record IS RECORD
51 (
52 v_exists_person_id IGS_EN_SU_ATTEMPT_ALL.PERSON_ID%TYPE,
53 v_exists_course_cd IGS_EN_SU_ATTEMPT_ALL.COURSE_CD%TYPE,
54 v_exists_unit_cd IGS_EN_SU_ATTEMPT_ALL.UNIT_CD%TYPE,
55 v_exists_version_number IGS_EN_SU_ATTEMPT_ALL.VERSION_NUMBER%TYPE,
56 v_exists_cal_type IGS_EN_SU_ATTEMPT_ALL.CAL_TYPE%TYPE,
57 v_exists_ci_sequence_number IGS_EN_SU_ATTEMPT_ALL.CI_SEQUENCE_NUMBER%TYPE,
58 v_exists_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE);
59 --
60 --
61 TYPE t_sua_duplicate_table IS TABLE OF
62 IGS_EN_VAL_SUA.t_sua_duplicate_record
63 INDEX BY BINARY_INTEGER;
64 --
65 --
66 TYPE t_sua_discont_table IS TABLE OF
67 IGS_EN_VAL_SUA.t_sua_discont_record
68 INDEX BY BINARY_INTEGER;
69 --
70 --
71 TYPE t_sua_deleted_table IS TABLE OF
72 IGS_EN_VAL_SUA.t_sua_deleted_record
73 INDEX BY BINARY_INTEGER;
74 --
75 --
76 TYPE t_sua_exists_table IS TABLE OF
77 IGS_EN_VAL_SUA.t_sua_exists_record
78 INDEX BY BINARY_INTEGER;
79 --
80
81 --
82 gt_sua_deleted_table t_sua_deleted_table;
83 --
84 --
85 gt_sua_deleted_empty_table t_sua_deleted_table;
86 --
87 --
88 gv_sua_deleted_table_index BINARY_INTEGER;
89 --
90 --
91 gt_sua_duplicate_table t_sua_duplicate_table;
92 --
93 --
94 gt_sua_duplicate_empty_table t_sua_duplicate_table;
95 --
96 --
97 gv_sua_duplicate_table_index BINARY_INTEGER;
98 --
99 --
100 gt_sua_exists_table t_sua_exists_table;
101 --
102 --
103 gt_sua_exists_empty_table t_sua_exists_table;
104 --
105 --
106 gv_sua_exists_table_index BINARY_INTEGER;
107 --
108 --
109 gt_sua_discont_table t_sua_discont_table;
110 --
111 --
112 gt_sua_discont_empty_table t_sua_discont_table;
113 --
114 --
115 gv_sua_discont_table_index BINARY_INTEGER;
116
117 --
118 -- To validate the confirmation of a research unit attempt.
119 FUNCTION RESP_VAL_SUA_CNFRM(
120 p_person_id IN NUMBER ,
121 p_course_cd IN VARCHAR2 ,
122 p_unit_cd IN VARCHAR2 ,
123 p_version_number IN NUMBER ,
124 p_cal_type IN VARCHAR2 ,
125 p_ci_sequence_number IN NUMBER ,
126 p_message_name OUT NOCOPY VARCHAR2 ,
127 p_legacy IN VARCHAR2 DEFAULT 'N' )
128 RETURN boolean;
129 --PRAGMA RESTRICT_REFERENCES( RESP_VAL_SUA_CNFRM , WNDS);
130
131 --
132 -- To validate all research units in an academic period
133 FUNCTION RESP_VAL_SUA_ALL(
134 p_person_id IN NUMBER ,
135 p_course_cd IN VARCHAR2 ,
136 p_acad_cal_type IN VARCHAR2 ,
137 p_acad_ci_sequence_number IN NUMBER ,
138 p_message_name OUT NOCOPY VARCHAR2)
139 RETURN boolean;
140 --PRAGMA RESTRICT_REFERENCES( RESP_VAL_SUA_ALL , WNDS);
141
142 --
143 -- To validate for student unit attempt being excluded
144 FUNCTION ENRP_VAL_SUA_EXCLD(
145 p_person_id IN NUMBER ,
146 p_course_cd IN VARCHAR2 ,
147 p_unit_cd IN VARCHAR2 ,
148 p_cal_type IN VARCHAR2 ,
149 p_ci_sequence_number IN NUMBER ,
150 p_message_name OUT NOCOPY VARCHAR2)
151 RETURN BOOLEAN;
152 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUA_EXCLD , WNDS);
153
154 --
155 -- To validate update of SUA.
156 FUNCTION enrp_val_sua_update(
157 p_person_id IN NUMBER ,
158 p_course_cd IN VARCHAR2 ,
159 p_unit_cd IN VARCHAR2 ,
160 p_cal_type IN VARCHAR2 ,
161 p_ci_sequence_number IN NUMBER ,
162 p_unit_attempt_status IN VARCHAR2 ,
163 p_new_version_number IN NUMBER ,
164 p_new_location_cd IN VARCHAR2 ,
165 p_new_unit_class IN VARCHAR2 ,
166 p_new_enrolled_dt IN DATE ,
167 p_new_discontinued_dt IN DATE ,
168 p_new_admin_unit_status IN VARCHAR2 ,
169 p_new_rule_waived_dt IN DATE ,
170 p_new_rule_waived_person_id IN NUMBER ,
171 p_new_no_assessment_ind IN VARCHAR2 ,
172 p_new_sup_unit_cd IN VARCHAR2 ,
173 p_new_sup_version_number IN NUMBER ,
174 p_new_exam_location_cd IN VARCHAR2 ,
175 p_old_version_number IN NUMBER ,
176 p_old_location_cd IN VARCHAR2 ,
177 p_old_unit_class IN VARCHAR2 ,
178 p_old_enrolled_dt IN DATE ,
179 p_old_discontinued_dt IN DATE ,
180 p_old_admin_unit_status IN VARCHAR2 ,
181 p_old_rule_waived_dt IN DATE ,
182 p_old_rule_waived_person_id IN NUMBER ,
183 p_old_no_assessment_ind IN VARCHAR2 ,
184 p_old_sup_unit_cd IN VARCHAR2 ,
185 p_old_sup_version_number IN NUMBER ,
186 p_old_exam_location_cd IN VARCHAR2 ,
187 p_message_name OUT NOCOPY VARCHAR2,
188 p_uoo_id IN NUMBER)
189 RETURN BOOLEAN;
190 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_update , WNDS);
191
192 --
193 -- To validate SUA override credit reason
194 FUNCTION enrp_val_sua_cp_rsn(
195 p_override_enrolled_cp IN NUMBER ,
196 p_override_achievable_cp IN NUMBER ,
197 p_override_credit_reason IN VARCHAR2 ,
198 p_message_name OUT NOCOPY VARCHAR2)
199 RETURN BOOLEAN;
200 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_cp_rsn , WNDS);
201
202 --
203 -- Routine to clear records saved in a PL/SQL RECORD from a prior commit.
204 PROCEDURE enrp_clear_sua_exist
205 ;
206
207 --
208 -- To validate enrolled date of SUA.
209 FUNCTION enrp_val_sua_ci(
210 p_person_id IN NUMBER ,
211 p_course_cd IN VARCHAR2 ,
212 p_cal_type IN VARCHAR2 ,
213 p_ci_sequence_number IN NUMBER ,
214 p_unit_attempt_status IN VARCHAR2 ,
215 p_commencement_dt IN DATE ,
216 p_form_trigger_ind IN VARCHAR2 ,
217 p_message_name OUT NOCOPY VARCHAR2)
218 RETURN BOOLEAN;
219 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_ci , WNDS);
220
221 --
222 -- To validate SUA alternative TITLE.
223 FUNCTION enrp_val_sua_alt_ttl(
224 p_unit_cd IN VARCHAR2 ,
225 p_version_number IN NUMBER ,
226 p_alternative_title IN VARCHAR2 ,
227 p_message_name OUT NOCOPY VARCHAR2)
228 RETURN BOOLEAN;
229 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_alt_ttl, WNDS);
230
231 --
232 -- Routine to clear records saved in a PL/SQL RECORD from a prior commit.
233 PROCEDURE enrp_clear_sua_dupl
234 ;
235
236 --
237 -- Validate whether unit attempt can be pre-enrolled
238 FUNCTION ENRP_VAL_SUA_PRE(
239 p_person_id IN NUMBER ,
240 p_course_cd IN VARCHAR2 ,
241 p_unit_cd IN VARCHAR2 ,
242 p_log_creation_dt IN DATE ,
243 p_warn_level OUT NOCOPY VARCHAR2 ,
244 p_message_name OUT NOCOPY VARCHAR2)
245 RETURN boolean;
246 --
247 -- To validate SUA advanced standing unit.
248 FUNCTION enrp_val_sua_advstnd(
249 p_person_id IN NUMBER ,
250 p_course_cd IN VARCHAR2 ,
251 p_crs_version_number IN NUMBER ,
252 p_unit_cd IN VARCHAR2 ,
253 p_un_version_number IN NUMBER ,
254 p_message_name OUT NOCOPY VARCHAR2,
255 p_legacy IN VARCHAR2 DEFAULT 'N')
256 RETURN BOOLEAN;
257 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_advstnd, WNDS);
258
259 --
260 -- To validate the insertion of an sua against any intermissions
261 FUNCTION ENRP_VAL_SUA_INTRMT(
262 p_person_id IN NUMBER ,
263 p_course_cd IN VARCHAR2 ,
264 p_cal_type IN VARCHAR2 ,
265 p_ci_sequence_number IN NUMBER ,
266 p_message_name OUT NOCOPY VARCHAR2)
267 RETURN boolean;
268 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUA_INTRMT , WNDS);
269
270 --
271 -- Routine to clear records saved in a PL/SQL RECORD from a prior commit.
272 PROCEDURE enrp_clear_sua_disc
273 ;
274
275 --
276 -- Validate the discontinued administrative unit status.
277 FUNCTION enrp_val_discont_aus(
278 p_administrative_unit_status IN VARCHAR2 ,
279 p_discontinued_dt IN DATE ,
280 p_cal_type IN VARCHAR2 ,
281 p_ci_sequence_number IN NUMBER ,
282 p_message_name OUT NOCOPY VARCHAR2,
283 p_uoo_id IN NUMBER DEFAULT NULL,
284 p_message_token OUT NOCOPY VARCHAR2 ,
285 p_legacy IN VARCHAR2 DEFAULT 'N' )
286 RETURN BOOLEAN;
287 --PRAGMA RESTRICT_REFERENCES( enrp_val_discont_aus, WNDS);
288
289 --
290 -- Get SUA grading schema.
291 FUNCTION enrp_get_sua_gs(
292 p_effective_dt IN DATE ,
293 p_administrative_unit_status IN VARCHAR2 ,
294 p_grading_schema_cd OUT NOCOPY VARCHAR2 ,
295 p_version_number OUT NOCOPY NUMBER ,
296 p_message_name OUT NOCOPY VARCHAR2)
297 RETURN BOOLEAN;
298 --PRAGMA RESTRICT_REFERENCES( enrp_get_sua_gs, WNDS);
299
300 --
301 -- Get SUA administrative unit status grade.
302 FUNCTION enrp_get_sua_ausg(
303 p_administrative_unit_status IN VARCHAR2 ,
304 p_person_id IN NUMBER ,
305 p_course_cd IN VARCHAR2 ,
306 p_unit_cd IN VARCHAR2 ,
307 p_cal_type IN VARCHAR2 ,
308 p_ci_sequence_number IN NUMBER ,
309 p_effective_dt IN DATE ,
310 p_grading_schema_cd OUT NOCOPY VARCHAR2 ,
311 p_version_number OUT NOCOPY NUMBER ,
312 p_grade OUT NOCOPY VARCHAR2 ,
313 p_message_name OUT NOCOPY VARCHAR2,
314 p_uoo_id IN NUMBER)
315 RETURN BOOLEAN;
316 --PRAGMA RESTRICT_REFERENCES( enrp_get_sua_ausg , WNDS);
317
318 --
319 -- To validate the discontinuation date
320 FUNCTION enrp_val_sua_discont(
321 p_person_id IN NUMBER ,
322 p_course_cd IN VARCHAR2 ,
323 p_unit_cd IN VARCHAR2 ,
324 p_version_number IN NUMBER ,
325 p_ci_start_dt IN DATE ,
326 p_enrolled_dt IN DATE ,
327 p_administrative_unit_status IN VARCHAR2 ,
328 p_unit_attempt_status IN VARCHAR2 ,
329 p_discontinued_dt IN DATE ,
330 p_message_name OUT NOCOPY VARCHAR2 ,
331 p_legacy IN VARCHAR2 DEFAULT 'N' )
332 RETURN BOOLEAN;
333 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_discont , WNDS);
334
335 --
336 -- To validate enrolled date of SUA.
337 FUNCTION enrp_val_sua_enr_dt(
338 p_person_id IN NUMBER ,
339 p_course_cd IN VARCHAR2 ,
340 p_enrolled_dt IN DATE ,
341 p_unit_attempt_status IN VARCHAR2 ,
342 p_ci_end_dt IN DATE ,
343 p_commencement_dt IN DATE ,
344 p_message_name OUT NOCOPY VARCHAR2 ,
345 p_legacy IN VARCHAR2 DEFAULT 'N')
346 RETURN BOOLEAN;
347 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_enr_dt , WNDS);
348
349 --
350 --
351 -- To validate deletion of the student unit attempt
352 FUNCTION enrp_val_sua_delete(
353 p_person_id IN NUMBER ,
354 p_course_cd IN VARCHAR2 ,
355 p_unit_cd IN VARCHAR2 ,
356 p_form_trigger_ind IN VARCHAR2 DEFAULT 'N' ,
357 p_unit_attempt_status IN VARCHAR2 ,
358 p_cal_type IN VARCHAR2 ,
359 p_ci_sequence_number IN NUMBER ,
360 p_discontinued_dt IN DATE ,
361 p_effective_dt IN DATE ,
362 p_message_name OUT NOCOPY VARCHAR2,
363 p_uoo_id IN NUMBER)
364 RETURN BOOLEAN;
365 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_delete, WNDS);
366
367 --
368 -- To validate insert of SUA.
369 FUNCTION enrp_val_sua_insert(
370 p_person_id IN NUMBER ,
371 p_course_cd IN VARCHAR2 ,
372 p_unit_attempt_status IN VARCHAR2 ,
373 p_message_name OUT NOCOPY VARCHAR2)
374 RETURN BOOLEAN;
375 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_insert , WNDS);
376
377 --
378 -- Validate the confirmation of a student unit attempt.
379 FUNCTION ENRP_VAL_SUA_CNFRM(
380 p_person_id IN NUMBER ,
381 p_course_cd IN VARCHAR2 ,
382 p_unit_cd IN VARCHAR2 ,
383 p_uv_version_number NUMBER ,
384 p_cal_type IN VARCHAR2 ,
385 p_ci_sequence_number IN NUMBER ,
386 p_ci_end_dt IN DATE ,
387 p_location_cd IN VARCHAR2 ,
388 p_unit_class IN VARCHAR2 ,
389 p_enrolled_dt IN DATE ,
390 p_fail_type OUT NOCOPY VARCHAR2 ,
391 p_message_name OUT NOCOPY VARCHAR2)
392 RETURN BOOLEAN;
393 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUA_CNFRM , WNDS);
394
395 --
396 -- Validate the IGS_PS_COURSE against a posted change to student unit attempt.
397 FUNCTION ENRP_VAL_SUA_CNFRM_P(
398 p_person_id IN NUMBER ,
399 p_course_cd IN VARCHAR2,
400 p_course_version IN NUMBER,
401 p_coo_id IN NUMBER ,
402 p_cal_type IN VARCHAR2 ,
403 p_ci_sequence_number IN NUMBER ,
404 p_uoo_id IN NUMBER,
405 p_fail_type OUT NOCOPY VARCHAR2 ,
406 p_message_name OUT NOCOPY varchar2 ,
407 p_message_name2 OUT NOCOPY varchar2 )
408 RETURN BOOLEAN;
409 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUA_CNFRM_P , WNDS);
410
411 --
412 -- To validate SUA override credit point values
413 FUNCTION enrp_val_sua_ovrd_cp(
414 p_unit_cd IN VARCHAR2 ,
415 p_version_number IN NUMBER ,
416 p_override_enrolled_cp IN NUMBER ,
417 p_override_achievable_cp IN NUMBER ,
418 p_override_eftsu IN NUMBER ,
419 p_message_name OUT NOCOPY VARCHAR2,
420 p_uoo_id IN NUMBER DEFAULT NULL,
421 p_no_assessment_ind IN VARCHAR2 DEFAULT 'N')
422 RETURN BOOLEAN;
423 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_ovrd_cp , WNDS);
424
425 --
426 -- To validate SUA RULE waived date.
427 FUNCTION enrp_val_sua_rule_wv(
428 p_rule_waived_dt IN DATE ,
429 p_enrolled_dt IN DATE ,
430 p_rule_waived_person_id IN OUT NOCOPY NUMBER ,
431 p_message_name OUT NOCOPY VARCHAR2)
432 RETURN BOOLEAN;
433 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_rule_wv, WNDS);
434
435 --
436
437
438 --
439 -- To validate SUA unit offering option.
440 FUNCTION enrp_val_sua_uoo(
441 p_unit_cd IN VARCHAR2 ,
442 p_version_number IN NUMBER ,
443 p_cal_type IN VARCHAR2 ,
444 p_ci_sequence_number IN NUMBER ,
445 p_location_cd IN VARCHAR2 ,
446 p_unit_class IN VARCHAR2 ,
447 p_message_name OUT NOCOPY VARCHAR2 ,
448 p_legacy IN VARCHAR2 DEFAULT 'N')
449 RETURN BOOLEAN;
450 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_uoo, WNDS);
451
452 --
453 -- To validate sca LOCATION code against coo restriction
454 FUNCTION ENRP_VAL_COO_LOC(
455 p_coo_id IN NUMBER ,
456 p_unit_location_cd IN VARCHAR2 ,
457 p_message_name OUT NOCOPY VARCHAR2)
458 RETURN boolean;
459 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_COO_LOC , WNDS);
460
461 --
462 -- To validate the sca att mode against coo restriction
463 FUNCTION ENRP_VAL_COO_MODE(
464 p_coo_id IN NUMBER ,
465 p_unit_class IN VARCHAR2 ,
466 p_message_name OUT NOCOPY VARCHAR2)
467 RETURN boolean;
468 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_COO_MODE , WNDS);
469 --
470 -- To validate for student unit attempt being duplicated
471 FUNCTION enrp_val_sua_dupl(
472 p_person_id IN NUMBER ,
473 p_course_cd IN VARCHAR2 ,
474 p_unit_cd IN VARCHAR2 ,
475 p_uv_version_number IN NUMBER ,
476 p_cal_type IN VARCHAR2 ,
477 p_ci_sequence_number IN NUMBER ,
478 p_unit_attempt_status IN VARCHAR2 ,
479 p_duplicate_course_cd OUT NOCOPY VARCHAR2 ,
480 p_message_name OUT NOCOPY VARCHAR2,
481 p_uoo_id IN NUMBER)
482 RETURN BOOLEAN;
483 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_dupl, WNDS);
484
485 PROCEDURE enr_sub_units(
486 p_person_id IN NUMBER ,
487 p_course_cd IN VARCHAR2 ,
488 p_uoo_id IN NUMBER,
489 p_waitlist_flag IN VARCHAR2,
490 p_load_cal_type IN VARCHAR2,
491 p_load_seq_num IN NUMBER,
492 p_enrollment_date IN DATE ,
493 p_enrollment_method IN VARCHAR2,
494 p_enr_uoo_ids IN VARCHAR2,
495 p_uoo_ids OUT NOCOPY VARCHAR2,
496 p_waitlist_uoo_ids OUT NOCOPY VARCHAR2,
497 p_failed_uoo_ids OUT NOCOPY VARCHAR2);
498
499 Procedure drop_sub_units(
500 p_person_id IN NUMBER,
501 p_course_cd IN VARCHAR2,
502 p_uoo_id IN NUMBER,
503 p_load_cal_type IN VARCHAR2,
504 p_load_seq_num IN NUMBER,
505 p_acad_cal_type IN VARCHAR2,
506 p_acad_seq_num IN NUMBER,
507 p_enrollment_method IN VARCHAR2,
508 p_confirmed_ind IN VARCHAR2,
509 p_person_type IN VARCHAR2,
510 p_effective_date IN DATE,
511 p_course_ver_num IN NUMBER,
512 p_dcnt_reason_cd IN VARCHAR2,
513 p_admin_unit_status IN VARCHAR2,
514 p_uoo_ids OUT NOCOPY VARCHAR2,
515 p_error_message OUT NOCOPY VARCHAR2);
516
517
518 PROCEDURE validate_mus(
519 p_person_id IN NUMBER,
520 p_course_cd IN VARCHAR2,
521 p_uoo_id IN NUMBER
522 );
523
524
525 END IGS_EN_VAL_SUA;
[Home] [Help]