1 PACKAGE IGS_EN_SU_ATTEMPT_PKG AS
2 /* $Header: IGSEI36S.pls 120.1 2005/07/07 02:40:17 appldev ship $ */
3
4 pkg_reason VARCHAR2(2000);
5 pkg_source_of_drop VARCHAR2(200);
6
7 procedure INSERT_ROW (
8 X_ROWID in out NOCOPY VARCHAR2,
9 X_PERSON_ID in NUMBER,
10 X_COURSE_CD in VARCHAR2,
11 X_UNIT_CD in VARCHAR2,
12 X_CAL_TYPE in VARCHAR2,
13 X_CI_SEQUENCE_NUMBER in NUMBER,
14 X_VERSION_NUMBER in NUMBER,
15 X_LOCATION_CD in VARCHAR2,
16 X_UNIT_CLASS in VARCHAR2,
17 X_CI_START_DT in DATE,
18 X_CI_END_DT in DATE,
19 X_UOO_ID in NUMBER,
20 X_ENROLLED_DT in DATE,
21 X_UNIT_ATTEMPT_STATUS in VARCHAR2,
22 X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
23 X_DISCONTINUED_DT in DATE,
24 X_RULE_WAIVED_DT in DATE,
25 X_RULE_WAIVED_PERSON_ID in NUMBER,
26 X_NO_ASSESSMENT_IND in VARCHAR2,
27 X_SUP_UNIT_CD in VARCHAR2,
28 X_SUP_VERSION_NUMBER in NUMBER,
29 X_EXAM_LOCATION_CD in VARCHAR2,
30 X_ALTERNATIVE_TITLE in VARCHAR2,
31 X_OVERRIDE_ENROLLED_CP in NUMBER,
32 X_OVERRIDE_EFTSU in NUMBER,
33 X_OVERRIDE_ACHIEVABLE_CP in NUMBER,
34 X_OVERRIDE_OUTCOME_DUE_DT in DATE,
35 X_OVERRIDE_CREDIT_REASON in VARCHAR2,
36 X_ADMINISTRATIVE_PRIORITY in NUMBER,
37 X_WAITLIST_DT in DATE,
38 X_DCNT_REASON_CD in VARCHAR2,
39 X_MODE in VARCHAR2 default 'R' ,
40 x_org_id IN NUMBER,
41 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
42 X_ENR_METHOD_TYPE IN VARCHAR2 DEFAULT NULL,
43 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
44 X_CART IN VARCHAR2 DEFAULT 'N',
45 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
46 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
47 X_GRADING_SCHEMA_CODE IN VARCHAR2 DEFAULT NULL,
48 X_SUBTITLE IN VARCHAR2 DEFAULT NULL,
49 -- session_id added by Nishikant 28JAN2002. Enh Bug#2172380.
50 X_SESSION_ID IN NUMBER DEFAULT NULL,
51 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
52 X_STUDENT_CAREER_TRANSCRIPT IN VARCHAR2 DEFAULT NULL,
53 X_STUDENT_CAREER_STATISTICS IN VARCHAR2 DEFAULT NULL,
54 X_WAITLIST_MANUAL_IND IN VARCHAR2 DEFAULT NULL,--Bug ID: 2554109 added by adhawan
55 X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
56 X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
57 X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
58 X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
59 X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
60 X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
61 X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
62 X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
63 X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
64 X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
65 X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
66 X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
67 X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
68 X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
69 X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
70 X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
71 X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
72 X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
73 X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
74 X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
75 x_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
76 -- WLST_PRIORITY_WEIGHT_NUM and WLST_PREFERENCE_WEIGHT_NUM added by ptandon 1-SEP-2003. Enh Bug# 3052426
77 X_WLST_PRIORITY_WEIGHT_NUM IN NUMBER DEFAULT NULL,
78 X_WLST_PREFERENCE_WEIGHT_NUM IN NUMBER DEFAULT NULL,
79 -- CORE_INDICATOR_CODE added by ptandon 30-SEP-2003. Enh Bug# 3052432
80 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL,
81 X_UPD_AUDIT_FLAG IN VARCHAR2 DEFAULT 'N',
82 X_SS_SOURCE_IND IN VARCHAR2 DEFAULT 'N' );
83
84 procedure LOCK_ROW (
85 X_ROWID in VARCHAR2,
86 X_PERSON_ID in NUMBER,
87 X_COURSE_CD in VARCHAR2,
88 X_UNIT_CD in VARCHAR2,
89 X_CAL_TYPE in VARCHAR2,
90 X_CI_SEQUENCE_NUMBER in NUMBER,
91 X_VERSION_NUMBER in NUMBER,
92 X_LOCATION_CD in VARCHAR2,
93 X_UNIT_CLASS in VARCHAR2,
94 X_CI_START_DT in DATE,
95 X_CI_END_DT in DATE,
96 X_UOO_ID in NUMBER,
97 X_ENROLLED_DT in DATE,
98 X_UNIT_ATTEMPT_STATUS in VARCHAR2,
99 X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
100 X_DISCONTINUED_DT in DATE,
101 X_RULE_WAIVED_DT in DATE,
102 X_RULE_WAIVED_PERSON_ID in NUMBER,
103 X_NO_ASSESSMENT_IND in VARCHAR2,
104 X_SUP_UNIT_CD in VARCHAR2,
105 X_SUP_VERSION_NUMBER in NUMBER,
106 X_EXAM_LOCATION_CD in VARCHAR2,
107 X_ALTERNATIVE_TITLE in VARCHAR2,
108 X_OVERRIDE_ENROLLED_CP in NUMBER,
109 X_OVERRIDE_EFTSU in NUMBER,
110 X_OVERRIDE_ACHIEVABLE_CP in NUMBER,
111 X_OVERRIDE_OUTCOME_DUE_DT in DATE,
112 X_OVERRIDE_CREDIT_REASON in VARCHAR2,
113 X_ADMINISTRATIVE_PRIORITY in NUMBER,
114 X_WAITLIST_DT in DATE,
115 X_DCNT_REASON_CD in VARCHAR2,
116 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
117 X_ENR_METHOD_TYPE IN VARCHAR2 DEFAULT NULL,
118 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
119 X_CART IN VARCHAR2 DEFAULT 'N',
120 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
121 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL ,
122 X_GRADING_SCHEMA_CODE IN VARCHAR2 DEFAULT NULL,
123 X_subtitle IN VARCHAR2 DEFAULT NULL,
124 -- session_id added by Nishikant 28JAN2002. Enh Bug#2172380.
125 X_SESSION_ID IN NUMBER DEFAULT NULL,
126 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL ,
127 X_STUDENT_CAREER_TRANSCRIPT IN VARCHAR2 DEFAULT NULL,
128 X_STUDENT_CAREER_STATISTICS IN VARCHAR2 DEFAULT NULL,
129 X_WAITLIST_MANUAL_IND IN VARCHAR2 DEFAULT NULL,--Bug ID: 2554109 added by adhawan
130 X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
131 X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
132 X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
133 X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
134 X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
135 X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
136 X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
137 X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
138 X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
139 X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
140 X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
141 X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
142 X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
143 X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
144 X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
145 X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
146 X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
147 X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
148 X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
149 X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
150 x_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
151 -- WLST_PRIORITY_WEIGHT_NUM and WLST_PREFERENCE_WEIGHT_NUM added by ptandon 1-SEP-2003. Enh Bug# 3052426
152 X_WLST_PRIORITY_WEIGHT_NUM IN NUMBER DEFAULT NULL,
153 X_WLST_PREFERENCE_WEIGHT_NUM IN NUMBER DEFAULT NULL,
154 -- CORE_INDICATOR_CODE added by ptandon 30-SEP-2003. Enh Bug# 3052432
155 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL,
156 X_UPD_AUDIT_FLAG IN VARCHAR2 DEFAULT NULL,
157 X_SS_SOURCE_IND IN VARCHAR2 DEFAULT NULL
158 );
159
160 procedure UPDATE_ROW (
161 X_ROWID in VARCHAR2,
162 X_PERSON_ID in NUMBER,
163 X_COURSE_CD in VARCHAR2,
164 X_UNIT_CD in VARCHAR2,
165 X_CAL_TYPE in VARCHAR2,
166 X_CI_SEQUENCE_NUMBER in NUMBER,
167 X_VERSION_NUMBER in NUMBER,
168 X_LOCATION_CD in VARCHAR2,
169 X_UNIT_CLASS in VARCHAR2,
170 X_CI_START_DT in DATE,
171 X_CI_END_DT in DATE,
172 X_UOO_ID in NUMBER,
173 X_ENROLLED_DT in DATE,
174 X_UNIT_ATTEMPT_STATUS in VARCHAR2,
175 X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
176 X_DISCONTINUED_DT in DATE,
177 X_RULE_WAIVED_DT in DATE,
178 X_RULE_WAIVED_PERSON_ID in NUMBER,
179 X_NO_ASSESSMENT_IND in VARCHAR2,
180 X_SUP_UNIT_CD in VARCHAR2,
181 X_SUP_VERSION_NUMBER in NUMBER,
182 X_EXAM_LOCATION_CD in VARCHAR2,
183 X_ALTERNATIVE_TITLE in VARCHAR2,
184 X_OVERRIDE_ENROLLED_CP in NUMBER,
185 X_OVERRIDE_EFTSU in NUMBER,
186 X_OVERRIDE_ACHIEVABLE_CP in NUMBER,
187 X_OVERRIDE_OUTCOME_DUE_DT in DATE,
188 X_OVERRIDE_CREDIT_REASON in VARCHAR2,
189 X_ADMINISTRATIVE_PRIORITY in NUMBER,
190 X_WAITLIST_DT in DATE,
191 X_DCNT_REASON_CD in VARCHAR2,
192 X_MODE in VARCHAR2 default 'R',
193 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
194 X_ENR_METHOD_TYPE IN VARCHAR2 DEFAULT NULL,
195 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
196 X_CART IN VARCHAR2 DEFAULT 'N',
197 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
198 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
199 X_GRADING_SCHEMA_CODE IN VARCHAR2 DEFAULT NULL,
200 X_SUBTITLE IN VARCHAR2 DEFAULT NULL,
201 -- session_id added by Nishikant 28JAN2002. Enh Bug#2172380.
202 X_SESSION_ID IN NUMBER DEFAULT NULL,
203 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
204 X_STUDENT_CAREER_TRANSCRIPT IN VARCHAR2 DEFAULT NULL,
205 X_STUDENT_CAREER_STATISTICS IN VARCHAR2 DEFAULT NULL,
206 X_WAITLIST_MANUAL_IND IN VARCHAR2 DEFAULT NULL,--Bug ID: 2554109 added by adhawan
207 X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
208 X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
209 X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
210 X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
211 X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
212 X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
213 X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
214 X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
215 X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
216 X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
217 X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
218 X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
219 X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
220 X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
221 X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
222 X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
223 X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
224 X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
225 X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
226 X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
227 x_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
228 -- WLST_PRIORITY_WEIGHT_NUM and WLST_PREFERENCE_WEIGHT_NUM added by ptandon 1-SEP-2003. Enh Bug# 3052426
229 X_WLST_PRIORITY_WEIGHT_NUM IN NUMBER DEFAULT NULL,
230 X_WLST_PREFERENCE_WEIGHT_NUM IN NUMBER DEFAULT NULL,
231 -- CORE_INDICATOR_CODE added by ptandon 30-SEP-2003. Enh Bug# 3052432
232 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL,
233 X_UPD_AUDIT_FLAG IN VARCHAR2 DEFAULT 'N',
234 X_SS_SOURCE_IND IN VARCHAR2 DEFAULT 'N'
235 );
236
237 procedure ADD_ROW (
238 X_ROWID in out NOCOPY VARCHAR2,
239 X_PERSON_ID in NUMBER,
240 X_COURSE_CD in VARCHAR2,
241 X_UNIT_CD in VARCHAR2,
242 X_CAL_TYPE in VARCHAR2,
243 X_CI_SEQUENCE_NUMBER in NUMBER,
244 X_VERSION_NUMBER in NUMBER,
245 X_LOCATION_CD in VARCHAR2,
246 X_UNIT_CLASS in VARCHAR2,
247 X_CI_START_DT in DATE,
248 X_CI_END_DT in DATE,
249 X_UOO_ID in NUMBER,
250 X_ENROLLED_DT in DATE,
251 X_UNIT_ATTEMPT_STATUS in VARCHAR2,
252 X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
253 X_DISCONTINUED_DT in DATE,
254 X_RULE_WAIVED_DT in DATE,
255 X_RULE_WAIVED_PERSON_ID in NUMBER,
256 X_NO_ASSESSMENT_IND in VARCHAR2,
257 X_SUP_UNIT_CD in VARCHAR2,
258 X_SUP_VERSION_NUMBER in NUMBER,
259 X_EXAM_LOCATION_CD in VARCHAR2,
260 X_ALTERNATIVE_TITLE in VARCHAR2,
261 X_OVERRIDE_ENROLLED_CP in NUMBER,
262 X_OVERRIDE_EFTSU in NUMBER,
263 X_OVERRIDE_ACHIEVABLE_CP in NUMBER,
264 X_OVERRIDE_OUTCOME_DUE_DT in DATE,
265 X_OVERRIDE_CREDIT_REASON in VARCHAR2,
266 X_ADMINISTRATIVE_PRIORITY in NUMBER,
267 X_WAITLIST_DT in DATE,
268 X_DCNT_REASON_CD in VARCHAR2,
269 X_MODE in VARCHAR2 default 'R',
270 x_org_id IN NUMBER,
271 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
272 X_ENR_METHOD_TYPE IN VARCHAR2 DEFAULT NULL,
273 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
274 X_CART IN VARCHAR2 DEFAULT 'N',
275 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
276 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
277 X_GRADING_SCHEMA_CODE IN VARCHAR2 DEFAULT NULL,
278 X_SUBTITLE IN VARCHAR2 DEFAULT NULL,
279 -- session_id added by Nishikant 28JAN2002. Enh Bug#2172380.
280 X_SESSION_ID IN NUMBER DEFAULT NULL,
281 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL ,
282 X_STUDENT_CAREER_TRANSCRIPT IN VARCHAR2 DEFAULT NULL,
283 X_STUDENT_CAREER_STATISTICS IN VARCHAR2 DEFAULT NULL,
284 X_WAITLIST_MANUAL_IND IN VARCHAR2 DEFAULT NULL,--Bug ID: 2554109 added by adhawan
285 X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
286 X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
287 X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
288 X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
289 X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
290 X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
291 X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
292 X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
293 X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
294 X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
295 X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
296 X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
297 X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
298 X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
299 X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
300 X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
301 X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
302 X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
303 X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
304 X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
305 x_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
306 -- WLST_PRIORITY_WEIGHT_NUM and WLST_PREFERENCE_WEIGHT_NUM added by ptandon 1-SEP-2003. Enh Bug# 3052426
307 X_WLST_PRIORITY_WEIGHT_NUM IN NUMBER DEFAULT NULL,
308 X_WLST_PREFERENCE_WEIGHT_NUM IN NUMBER DEFAULT NULL,
309 -- CORE_INDICATOR_CODE added by ptandon 30-SEP-2003. Enh Bug# 3052432
310 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL,
311 X_UPD_AUDIT_FLAG IN VARCHAR2 DEFAULT 'N',
312 X_SS_SOURCE_IND IN VARCHAR2 DEFAULT 'N'
313 );
314
315 procedure DELETE_ROW (
316 X_ROWID in VARCHAR2,
317 x_mode IN VARCHAR2 DEFAULT 'R'
318 );
319
320 FUNCTION Get_PK_For_Validation (
321 x_person_id IN NUMBER,
322 x_course_cd IN VARCHAR2,
323 x_uoo_id IN NUMBER
324 )RETURN BOOLEAN;
325 --This function Get_uk_For_Validation has been commented in the code for the bug 2554109
326
327
328 /*This Uk check was added as part of MUS build, # 2829262*/
329 FUNCTION Get_Uk_For_Validation (
330 x_unit_cd IN VARCHAR2,
331 x_cal_type IN VARCHAR2,
332 x_ci_sequence_number IN NUMBER,
333 x_location_cd IN VARCHAR2,
334 x_unit_class IN VARCHAR2,
335 x_person_id IN NUMBER,
336 x_course_cd IN VARCHAR2,
337 x_version_number IN NUMBER
338 ) RETURN BOOLEAN;
339
340 PROCEDURE GET_UFK_IGS_CA_INST (
341 x_cal_type IN VARCHAR2,
342 x_sequence_number IN NUMBER,
343 x_start_dt IN DATE,
344 x_end_dt IN DATE
345 );
346
347 PROCEDURE GET_FK_IGS_AD_LOCATION (
348 x_location_cd IN VARCHAR2
349 );
350
351 PROCEDURE GET_FK_IGS_AS_GRD_SCH_GRADE (
352 x_grading_schema_code IN VARCHAR2 ,
353 x_gs_version_number IN NUMBER
354 );
355
356 PROCEDURE GET_FK_IGS_PE_PERSON (
357 x_person_id IN NUMBER
358 );
359
360 PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
361 x_person_id IN NUMBER,
362 x_course_cd IN VARCHAR2
363 );
364
365 PROCEDURE GET_FK_IGS_LOOKUPS_VIEW (
366 x_unit_attempt_status IN VARCHAR2
367 );
368
369 PROCEDURE GET_FK_IGS_PS_UNIT_VER (
370 x_unit_cd IN VARCHAR2,
371 x_version_number IN NUMBER
372 );
373
374 PROCEDURE GET_FK_IGS_PS_UNIT (
375 x_unit_cd IN VARCHAR2
376 );
377
378 PROCEDURE GET_FK_IGS_PS_UNIT_OFR_OPT (
379 x_unit_cd IN VARCHAR2,
380 x_version_number IN NUMBER,
381 x_cal_type IN VARCHAR2,
382 x_ci_sequence_number IN NUMBER,
383 x_location_cd IN VARCHAR2,
384 x_unit_class IN VARCHAR2
385 );
386
387
388 PROCEDURE GET_UFK_IGS_PS_UNIT_GRD_SCHM ( x_version_number IN NUMBER,
389 x_grading_schema_code IN VARCHAR2,
393
390 x_gs_version_number IN NUMBER,
391 x_unit_cd IN VARCHAR2
392 ) ;
394 PROCEDURE GET_UFK_IGS_PS_USEC_GRD_SCHM ( x_grading_schema_code IN VARCHAR2,
395 x_gs_version_number IN NUMBER,
396 x_uoo_id IN NUMBER
397 ) ;
398
399
400
401 PROCEDURE GET_UFK_IGS_PS_UNIT_OFR_OPT (
402 x_uoo_id IN NUMBER
403 );
404
405 PROCEDURE Check_Constraints (
406 Column_Name IN VARCHAR2 DEFAULT NULL,
407 Column_Value IN VARCHAR2 DEFAULT NULL
408 );
409
410 PROCEDURE Before_DML (
411 p_action IN VARCHAR2,
412 x_rowid IN VARCHAR2 DEFAULT NULL,
413 x_uoo_id IN NUMBER DEFAULT NULL,
414 x_enrolled_dt IN DATE DEFAULT NULL,
415 x_unit_attempt_status IN VARCHAR2 DEFAULT NULL,
416 x_administrative_unit_status IN VARCHAR2 DEFAULT NULL,
417 x_discontinued_dt IN DATE DEFAULT NULL,
418 x_rule_waived_dt IN DATE DEFAULT NULL,
419 x_rule_waived_person_id IN NUMBER DEFAULT NULL,
420 x_no_assessment_ind IN VARCHAR2 DEFAULT NULL,
421 x_sup_unit_cd IN VARCHAR2 DEFAULT NULL,
422 x_sup_version_number IN NUMBER DEFAULT NULL,
423 x_exam_location_cd IN VARCHAR2 DEFAULT NULL,
424 x_alternative_title IN VARCHAR2 DEFAULT NULL,
425 x_override_enrolled_cp IN NUMBER DEFAULT NULL,
426 x_override_eftsu IN NUMBER DEFAULT NULL,
427 x_override_achievable_cp IN NUMBER DEFAULT NULL,
428 x_override_outcome_due_dt IN DATE DEFAULT NULL,
429 x_override_credit_reason IN VARCHAR2 DEFAULT NULL,
430 x_person_id IN NUMBER DEFAULT NULL,
431 x_course_cd IN VARCHAR2 DEFAULT NULL,
432 x_unit_cd IN VARCHAR2 DEFAULT NULL,
433 x_version_number IN NUMBER DEFAULT NULL,
434 x_cal_type IN VARCHAR2 DEFAULT NULL,
435 x_ci_sequence_number IN NUMBER DEFAULT NULL,
436 x_location_cd IN VARCHAR2 DEFAULT NULL,
437 x_unit_class IN VARCHAR2 DEFAULT NULL,
438 x_ci_start_dt IN DATE DEFAULT NULL,
439 x_ci_end_dt IN DATE DEFAULT NULL,
440 x_administrative_priority IN NUMBER DEFAULT NULL,
441 x_waitlist_dt IN DATE DEFAULT NULL,
442 x_dcnt_reason_Cd IN VARCHAR2 DEFAULT NULL,
443 x_creation_date IN DATE DEFAULT NULL,
444 x_created_by IN NUMBER DEFAULT NULL,
445 x_last_update_date IN DATE DEFAULT NULL,
446 x_last_updated_by IN NUMBER DEFAULT NULL,
447 x_last_update_login IN NUMBER DEFAULT NULL,
448 x_org_id IN NUMBER DEFAULT NULL,
449 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
450 X_ENR_METHOD_TYPE IN VARCHAR2 DEFAULT NULL,
451 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
452 X_CART IN VARCHAR2 DEFAULT NULL,
453 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
454 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
455 X_GRADING_SCHEMA_CODE IN VARCHAR2 DEFAULT NULL,
456 x_subtitle IN varchar2 DEFAULT NULL,
457 -- session_id added by Nishikant 28JAN2002. Enh Bug#2172380.
458 X_SESSION_ID IN NUMBER DEFAULT NULL,
459 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
460 X_STUDENT_CAREER_TRANSCRIPT IN VARCHAR2 DEFAULT NULL,
461 X_STUDENT_CAREER_STATISTICS IN VARCHAR2 DEFAULT NULL,
462 X_WAITLIST_MANUAL_IND IN VARCHAR2 DEFAULT NULL,--Bug ID: 2554109 added by adhawan
463 X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
464 X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
465 X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
466 X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
467 X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
468 X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
469 X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
470 X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
471 X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
472 X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
473 X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
474 X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
475 X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
476 X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
477 X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
478 X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
479 X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
480 X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
481 X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
482 X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
483 X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
484 -- WLST_PRIORITY_WEIGHT_NUM and WLST_PREFERENCE_WEIGHT_NUM added by ptandon 1-SEP-2003. Enh Bug# 3052426
485 X_WLST_PRIORITY_WEIGHT_NUM IN NUMBER DEFAULT NULL,
486 X_WLST_PREFERENCE_WEIGHT_NUM IN NUMBER DEFAULT NULL,
487 -- CORE_INDICATOR_CODE added by ptandon 30-SEP-2003. Enh Bug# 3052432
488 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL,
489 X_UPD_AUDIT_FLAG IN VARCHAR2 DEFAULT 'N',
490 X_SS_SOURCE_IND IN VARCHAR2 DEFAULT 'N'
491 ) ;
492
493 -- For Enhancement Bug 1287292
494
495 PROCEDURE chk_enrollment_max;
496
497
498 END IGS_EN_SU_ATTEMPT_PKG;