1 package IGS_PS_UNIT_VER_PKG as
2 /* $Header: IGSPI92S.pls 120.2 2005/11/28 21:44:46 appldev ship $ */
3
4 /*******************************************************************************
5 Created by : Oracle IDC
6 Date created:
7 Purpose:
8 1.
9 Usage: (e.g. restricted, unrestricted, where to call from)
10 1.
11 Known limitations/enhancements/remarks:
12 -
13 Change History: (who, when, what: NO CREATION RECORDS HERE!)
14 Who When What
15 msrinivi 18 Jul,2001 Added a new col : revenue_account_cd
16 *******************************************************************************/
17 PROCEDURE INSERT_ROW (
18 X_ROWID IN OUT NOCOPY VARCHAR2,
19 X_UNIT_CD IN VARCHAR2,
20 X_VERSION_NUMBER in NUMBER,
21 X_START_DT IN DATE,
22 X_REVIEW_DT IN DATE,
23 X_EXPIRY_DT IN DATE,
24 X_END_DT IN DATE,
25 X_UNIT_STATUS IN VARCHAR2,
26 X_TITLE in VARCHAR2,
27 X_SHORT_TITLE IN VARCHAR2,
28 X_TITLE_OVERRIDE_IND IN VARCHAR2,
29 X_ABBREVIATION IN VARCHAR2,
30 X_UNIT_LEVEL in VARCHAR2,
31 X_CREDIT_POINT_DESCRIPTOR IN VARCHAR2,
32 X_ENROLLED_CREDIT_POINTS IN NUMBER,
33 X_POINTS_OVERRIDE_IND IN VARCHAR2,
34 X_SUPP_EXAM_PERMITTED_IND IN VARCHAR2,
35 X_COORD_PERSON_ID IN NUMBER,
36 X_OWNER_ORG_UNIT_CD IN VARCHAR2,
37 X_OWNER_OU_START_DT IN DATE,
38 X_AWARD_COURSE_ONLY_IND IN VARCHAR2,
39 X_RESEARCH_UNIT_IND IN VARCHAR2,
40 X_INDUSTRIAL_IND IN VARCHAR2,
41 X_PRACTICAL_IND IN VARCHAR2,
42 X_REPEATABLE_IND in VARCHAR2,
43 X_ASSESSABLE_IND in VARCHAR2,
44 X_ACHIEVABLE_CREDIT_POINTS in NUMBER,
45 X_POINTS_INCREMENT in NUMBER,
46 X_POINTS_MIN in NUMBER,
47 X_POINTS_MAX in NUMBER,
48 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
49 X_SUBTITLE in VARCHAR2,
50 X_SUBTITLE_MODIFIABLE_FLAG in VARCHAR2,
51 X_APPROVAL_DATE in DATE,
52 X_LECTURE_CREDIT_POINTS in NUMBER,
53 X_LAB_CREDIT_POINTS in NUMBER,
54 X_OTHER_CREDIT_POINTS in NUMBER,
55 X_CLOCK_HOURS in NUMBER,
56 X_WORK_LOAD_CP_LECTURE in NUMBER,
57 X_WORK_LOAD_CP_LAB in NUMBER,
58 X_CONTINUING_EDUCATION_UNITS in NUMBER,
59 X_ENROLLMENT_EXPECTED in NUMBER,
60 X_ENROLLMENT_MINIMUM in NUMBER,
61 X_ENROLLMENT_MAXIMUM in NUMBER,
62 X_ADVANCE_MAXIMUM in NUMBER,
63 X_STATE_FINANCIAL_AID in VARCHAR2,
64 X_FEDERAL_FINANCIAL_AID in VARCHAR2,
65 X_INSTITUTIONAL_FINANCIAL_AID in VARCHAR2,
66 X_SAME_TEACHING_PERIOD in VARCHAR2,
67 X_MAX_REPEATS_FOR_CREDIT in NUMBER,
68 X_MAX_REPEATS_FOR_FUNDING in NUMBER,
69 X_MAX_REPEAT_CREDIT_POINTS in NUMBER,
70 X_SAME_TEACH_PERIOD_REPEATS in NUMBER,
71 X_SAME_TEACH_PERIOD_REPEATS_CP in NUMBER,
72 X_ATTRIBUTE_CATEGORY in VARCHAR2,
73 X_ATTRIBUTE1 in VARCHAR2,
74 X_ATTRIBUTE2 in VARCHAR2,
75 X_ATTRIBUTE3 in VARCHAR2,
76 X_ATTRIBUTE4 in VARCHAR2,
77 X_ATTRIBUTE5 in VARCHAR2,
78 X_ATTRIBUTE6 in VARCHAR2,
79 X_ATTRIBUTE7 in VARCHAR2,
80 X_ATTRIBUTE8 in VARCHAR2,
81 X_ATTRIBUTE9 in VARCHAR2,
82 X_ATTRIBUTE10 in VARCHAR2,
83 X_ATTRIBUTE11 in VARCHAR2,
84 X_ATTRIBUTE12 in VARCHAR2,
85 X_ATTRIBUTE13 in VARCHAR2,
86 X_ATTRIBUTE14 in VARCHAR2,
87 X_ATTRIBUTE15 in VARCHAR2,
88 X_ATTRIBUTE16 in VARCHAR2,
89 X_ATTRIBUTE17 in VARCHAR2,
90 X_ATTRIBUTE18 in VARCHAR2,
91 X_ATTRIBUTE19 in VARCHAR2,
92 X_ATTRIBUTE20 in VARCHAR2,
93 x_subtitle_id IN NUMBER DEFAULT NULL,
94 x_work_load_other IN NUMBER DEFAULT NULL,
95 x_contact_hrs_lecture IN NUMBER DEFAULT NULL,
96 x_contact_hrs_lab IN NUMBER DEFAULT NULL,
97 x_contact_hrs_other IN NUMBER DEFAULT NULL,
98 x_non_schd_required_hrs IN NUMBER DEFAULT NULL,
99 x_exclude_from_max_cp_limit IN VARCHAR2 DEFAULT NULL,
100 x_record_exclusion_flag IN VARCHAR2 DEFAULT NULL,
101 x_ss_display_ind IN VARCHAR2 DEFAULT NULL,
102 x_cal_type_enrol_load_cal IN VARCHAR2 DEFAULT NULL,
103 x_sequence_num_enrol_load_cal IN NUMBER DEFAULT NULL,
104 x_cal_type_offer_load_cal IN VARCHAR2 DEFAULT NULL,
105 x_sequence_num_offer_load_cal IN NUMBER DEFAULT NULL,
106 x_curriculum_id IN VARCHAR2 DEFAULT NULL,
107 x_override_enrollment_max IN NUMBER DEFAULT NULL,
108 x_rpt_fmly_id IN NUMBER DEFAULT NULL,
109 x_unit_type_id IN NUMBER DEFAULT NULL,
110 x_special_permission_ind IN VARCHAR2 DEFAULT NULL,
111 X_MODE in VARCHAR2 default 'R',
112 X_ORG_ID IN NUMBER,
113 X_SS_ENROL_IND IN Varchar2 DEFAULT 'N',
114 X_IVR_enrol_ind IN Varchar2 DEFAULT 'N',
115 x_claimable_hours IN NUMBER DEFAULT NULL,
116 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
117 x_anon_unit_grading_ind IN VARCHAR2 DEFAULT NULL,
118 x_anon_assess_grading_ind IN VARCHAR2 DEFAULT NULL,
119 x_auditable_ind IN VARCHAR2 DEFAULT 'N',
120 x_audit_permission_ind IN VARCHAR2 DEFAULT 'N',
121 x_max_auditors_allowed IN NUMBER DEFAULT NULL,
122 x_billing_credit_points IN NUMBER DEFAULT NULL,
123 x_ovrd_wkld_val_flag IN VARCHAR2 DEFAULT 'N',
124 x_workload_val_code IN VARCHAR2 DEFAULT NULL,
125 x_billing_hrs IN NUMBER DEFAULT NULL
126 );
127
128 /*******************************************************************************
129 Created by : Oracle IDC
130 Date created:
131 Purpose:
132 1.
133 Usage: (e.g. restricted, unrestricted, where to call from)
134 1.
135 Known limitations/enhancements/remarks:
136 -
137 Change History: (who, when, what: NO CREATION RECORDS HERE!)
138 Who When What
139 msrinivi 18 Jul,2001 Added a new col : revenue_account_cd
140 *******************************************************************************/
141 PROCEDURE LOCK_ROW (
142 X_ROWID in VARCHAR2,
143 X_UNIT_CD in VARCHAR2,
144 X_VERSION_NUMBER in NUMBER,
145 X_START_DT in DATE,
146 X_REVIEW_DT in DATE,
147 X_EXPIRY_DT in DATE,
148 X_END_DT in DATE,
149 X_UNIT_STATUS in VARCHAR2,
150 X_TITLE in VARCHAR2,
151 X_SHORT_TITLE in VARCHAR2,
152 X_TITLE_OVERRIDE_IND in VARCHAR2,
153 X_ABBREVIATION in VARCHAR2,
154 X_UNIT_LEVEL in VARCHAR2,
155 X_CREDIT_POINT_DESCRIPTOR in VARCHAR2,
156 X_ENROLLED_CREDIT_POINTS in NUMBER,
157 X_POINTS_OVERRIDE_IND in VARCHAR2,
158 X_SUPP_EXAM_PERMITTED_IND in VARCHAR2,
159 X_COORD_PERSON_ID in NUMBER,
160 X_OWNER_ORG_UNIT_CD in VARCHAR2,
161 X_OWNER_OU_START_DT in DATE,
162 X_AWARD_COURSE_ONLY_IND in VARCHAR2,
163 X_RESEARCH_UNIT_IND in VARCHAR2,
164 X_INDUSTRIAL_IND in VARCHAR2,
165 X_PRACTICAL_IND in VARCHAR2,
166 X_REPEATABLE_IND in VARCHAR2,
167 X_ASSESSABLE_IND in VARCHAR2,
168 X_ACHIEVABLE_CREDIT_POINTS in NUMBER,
169 X_POINTS_INCREMENT in NUMBER,
170 X_POINTS_MIN in NUMBER,
171 X_POINTS_MAX in NUMBER,
172 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
173 X_SUBTITLE in VARCHAR2,
174 X_SUBTITLE_MODIFIABLE_FLAG in VARCHAR2,
175 X_APPROVAL_DATE in DATE,
176 X_LECTURE_CREDIT_POINTS in NUMBER,
177 X_LAB_CREDIT_POINTS in NUMBER,
178 X_OTHER_CREDIT_POINTS in NUMBER,
179 X_CLOCK_HOURS in NUMBER,
180 X_WORK_LOAD_CP_LECTURE in NUMBER,
181 X_WORK_LOAD_CP_LAB in NUMBER,
182 X_CONTINUING_EDUCATION_UNITS in NUMBER,
183 X_ENROLLMENT_EXPECTED in NUMBER,
184 X_ENROLLMENT_MINIMUM in NUMBER,
185 X_ENROLLMENT_MAXIMUM in NUMBER,
186 X_ADVANCE_MAXIMUM in NUMBER,
187 X_STATE_FINANCIAL_AID in VARCHAR2,
188 X_FEDERAL_FINANCIAL_AID in VARCHAR2,
189 X_INSTITUTIONAL_FINANCIAL_AID in VARCHAR2,
190 X_SAME_TEACHING_PERIOD in VARCHAR2,
191 X_MAX_REPEATS_FOR_CREDIT in NUMBER,
192 X_MAX_REPEATS_FOR_FUNDING in NUMBER,
193 X_MAX_REPEAT_CREDIT_POINTS in NUMBER,
194 X_SAME_TEACH_PERIOD_REPEATS in NUMBER,
195 X_SAME_TEACH_PERIOD_REPEATS_CP in NUMBER,
196 X_ATTRIBUTE_CATEGORY in VARCHAR2,
197 X_ATTRIBUTE1 IN VARCHAR2,
198 X_ATTRIBUTE2 IN VARCHAR2,
199 X_ATTRIBUTE3 IN VARCHAR2,
200 X_ATTRIBUTE4 IN VARCHAR2,
201 X_ATTRIBUTE5 IN VARCHAR2,
202 X_ATTRIBUTE6 IN VARCHAR2,
203 X_ATTRIBUTE7 IN VARCHAR2,
204 X_ATTRIBUTE8 IN VARCHAR2,
205 X_ATTRIBUTE9 IN VARCHAR2,
206 X_ATTRIBUTE10 IN VARCHAR2,
207 X_ATTRIBUTE11 IN VARCHAR2,
208 X_ATTRIBUTE12 IN VARCHAR2,
209 X_ATTRIBUTE13 IN VARCHAR2,
210 X_ATTRIBUTE14 IN VARCHAR2,
211 X_ATTRIBUTE15 IN VARCHAR2,
212 X_ATTRIBUTE16 IN VARCHAR2,
213 X_ATTRIBUTE17 IN VARCHAR2,
214 X_ATTRIBUTE18 IN VARCHAR2,
215 X_ATTRIBUTE19 IN VARCHAR2,
216 X_ATTRIBUTE20 IN VARCHAR2,
217 x_subtitle_id IN NUMBER DEFAULT NULL,
218 x_work_load_other IN NUMBER DEFAULT NULL,
219 x_contact_hrs_lecture IN NUMBER DEFAULT NULL,
220 x_contact_hrs_lab IN NUMBER DEFAULT NULL,
221 x_contact_hrs_other IN NUMBER DEFAULT NULL,
222 x_non_schd_required_hrs IN NUMBER DEFAULT NULL,
223 x_exclude_from_max_cp_limit IN VARCHAR2 DEFAULT NULL,
224 x_record_exclusion_flag IN VARCHAR2 DEFAULT NULL,
225 x_ss_display_ind IN VARCHAR2 DEFAULT NULL,
226 x_cal_type_enrol_load_cal IN VARCHAR2 DEFAULT NULL,
227 x_sequence_num_enrol_load_cal IN NUMBER DEFAULT NULL,
228 x_cal_type_offer_load_cal IN VARCHAR2 DEFAULT NULL,
229 x_sequence_num_offer_load_cal IN NUMBER DEFAULT NULL,
230 x_curriculum_id IN VARCHAR2 DEFAULT NULL,
231 x_override_enrollment_max IN NUMBER DEFAULT NULL,
232 x_rpt_fmly_id IN NUMBER DEFAULT NULL,
233 x_unit_type_id IN NUMBER DEFAULT NULL,
234 x_special_permission_ind IN VARCHAR2 DEFAULT NULL,
235 X_SS_ENROL_IND IN VARCHAR2 DEFAULT 'N',
236 X_IVR_ENROL_IND IN VARCHAR2 DEFAULT 'N',
237 x_claimable_hours IN NUMBER DEFAULT NULL,
238 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
239 x_anon_unit_grading_ind IN VARCHAR2 DEFAULT NULL,
240 x_anon_assess_grading_ind IN VARCHAR2 DEFAULT NULL,
241 x_auditable_ind IN VARCHAR2 DEFAULT 'N',
242 x_audit_permission_ind IN VARCHAR2 DEFAULT 'N',
243 x_max_auditors_allowed IN NUMBER DEFAULT NULL ,
244 x_billing_credit_points IN NUMBER DEFAULT NULL,
245 x_ovrd_wkld_val_flag IN VARCHAR2 DEFAULT 'N',
246 x_workload_val_code IN VARCHAR2 DEFAULT NULL,
247 x_billing_hrs IN NUMBER DEFAULT NULL
248 );
249 /*******************************************************************************
250 Created by : Oracle IDC
251 Date created:
252 Purpose:
253 1.
254 Usage: (e.g. restricted, unrestricted, where to call from)
255 1.
256 Known limitations/enhancements/remarks:
257 -
258 Change History: (who, when, what: NO CREATION RECORDS HERE!)
259 Who When What
260 msrinivi 18 Jul,2001 Added a new col : revenue_account_cd
261 *******************************************************************************/
262 PROCEDURE UPDATE_ROW (
263 X_ROWID in VARCHAR2,
264 X_UNIT_CD in VARCHAR2,
265 X_VERSION_NUMBER in NUMBER,
266 X_START_DT in DATE,
267 X_REVIEW_DT in DATE,
268 X_EXPIRY_DT in DATE,
269 X_END_DT in DATE,
270 X_UNIT_STATUS in VARCHAR2,
271 X_TITLE in VARCHAR2,
272 X_SHORT_TITLE in VARCHAR2,
273 X_TITLE_OVERRIDE_IND in VARCHAR2,
274 X_ABBREVIATION in VARCHAR2,
275 X_UNIT_LEVEL in VARCHAR2,
276 X_CREDIT_POINT_DESCRIPTOR in VARCHAR2,
277 X_ENROLLED_CREDIT_POINTS in NUMBER,
278 X_POINTS_OVERRIDE_IND in VARCHAR2,
279 X_SUPP_EXAM_PERMITTED_IND in VARCHAR2,
280 X_COORD_PERSON_ID in NUMBER,
281 X_OWNER_ORG_UNIT_CD in VARCHAR2,
282 X_OWNER_OU_START_DT in DATE,
283 X_AWARD_COURSE_ONLY_IND in VARCHAR2,
284 X_RESEARCH_UNIT_IND in VARCHAR2,
285 X_INDUSTRIAL_IND in VARCHAR2,
286 X_PRACTICAL_IND in VARCHAR2,
287 X_REPEATABLE_IND in VARCHAR2,
288 X_ASSESSABLE_IND in VARCHAR2,
289 X_ACHIEVABLE_CREDIT_POINTS in NUMBER,
290 X_POINTS_INCREMENT in NUMBER,
291 X_POINTS_MIN in NUMBER,
292 X_POINTS_MAX in NUMBER,
293 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
294 X_SUBTITLE in VARCHAR2,
295 X_SUBTITLE_MODIFIABLE_FLAG in VARCHAR2,
296 X_APPROVAL_DATE in DATE,
297 X_LECTURE_CREDIT_POINTS in NUMBER,
298 X_LAB_CREDIT_POINTS in NUMBER,
299 X_OTHER_CREDIT_POINTS in NUMBER,
300 X_CLOCK_HOURS in NUMBER,
301 X_WORK_LOAD_CP_LECTURE in NUMBER,
302 X_WORK_LOAD_CP_LAB in NUMBER,
303 X_CONTINUING_EDUCATION_UNITS in NUMBER,
304 X_ENROLLMENT_EXPECTED in NUMBER,
305 X_ENROLLMENT_MINIMUM in NUMBER,
306 X_ENROLLMENT_MAXIMUM in NUMBER,
307 X_ADVANCE_MAXIMUM in NUMBER,
308 X_STATE_FINANCIAL_AID in VARCHAR2,
309 X_FEDERAL_FINANCIAL_AID in VARCHAR2,
310 X_INSTITUTIONAL_FINANCIAL_AID in VARCHAR2,
311 X_SAME_TEACHING_PERIOD in VARCHAR2,
312 X_MAX_REPEATS_FOR_CREDIT in NUMBER,
313 X_MAX_REPEATS_FOR_FUNDING in NUMBER,
314 X_MAX_REPEAT_CREDIT_POINTS in NUMBER,
315 X_SAME_TEACH_PERIOD_REPEATS in NUMBER,
316 X_SAME_TEACH_PERIOD_REPEATS_CP in NUMBER,
317 X_ATTRIBUTE_CATEGORY in VARCHAR2,
318 X_ATTRIBUTE1 in VARCHAR2,
319 X_ATTRIBUTE2 in VARCHAR2,
320 X_ATTRIBUTE3 in VARCHAR2,
321 X_ATTRIBUTE4 in VARCHAR2,
322 X_ATTRIBUTE5 in VARCHAR2,
323 X_ATTRIBUTE6 in VARCHAR2,
324 X_ATTRIBUTE7 in VARCHAR2,
325 X_ATTRIBUTE8 in VARCHAR2,
326 X_ATTRIBUTE9 in VARCHAR2,
327 X_ATTRIBUTE10 in VARCHAR2,
328 X_ATTRIBUTE11 in VARCHAR2,
329 X_ATTRIBUTE12 in VARCHAR2,
330 X_ATTRIBUTE13 in VARCHAR2,
331 X_ATTRIBUTE14 in VARCHAR2,
332 X_ATTRIBUTE15 in VARCHAR2,
333 X_ATTRIBUTE16 in VARCHAR2,
334 X_ATTRIBUTE17 in VARCHAR2,
335 X_ATTRIBUTE18 in VARCHAR2,
336 X_ATTRIBUTE19 in VARCHAR2,
337 X_ATTRIBUTE20 in VARCHAR2,
338 x_subtitle_id IN NUMBER DEFAULT NULL,
339 x_work_load_other IN NUMBER DEFAULT NULL,
340 x_contact_hrs_lecture IN NUMBER DEFAULT NULL,
341 x_contact_hrs_lab IN NUMBER DEFAULT NULL,
342 x_contact_hrs_other IN NUMBER DEFAULT NULL,
343 x_non_schd_required_hrs IN NUMBER DEFAULT NULL,
344 x_exclude_from_max_cp_limit IN VARCHAR2 DEFAULT NULL,
345 x_record_exclusion_flag IN VARCHAR2 DEFAULT NULL,
346 x_ss_display_ind IN VARCHAR2 DEFAULT NULL,
347 x_cal_type_enrol_load_cal IN VARCHAR2 DEFAULT NULL,
348 x_sequence_num_enrol_load_cal IN NUMBER DEFAULT NULL,
349 x_cal_type_offer_load_cal IN VARCHAR2 DEFAULT NULL,
350 x_sequence_num_offer_load_cal IN NUMBER DEFAULT NULL,
351 x_curriculum_id IN VARCHAR2 DEFAULT NULL,
352 x_override_enrollment_max IN NUMBER DEFAULT NULL,
353 x_rpt_fmly_id IN NUMBER DEFAULT NULL,
354 x_unit_type_id IN NUMBER DEFAULT NULL,
355 x_special_permission_ind IN VARCHAR2 DEFAULT NULL,
356 X_MODE in VARCHAR2 default 'R',
357 X_SS_ENROL_IND IN VARCHAR2 DEFAULT 'N',
358 X_IVR_ENROL_IND IN VARCHAR2 DEFAULT 'N',
359 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
360 x_claimable_hours IN NUMBER DEFAULT NULL,
361 x_anon_unit_grading_ind IN VARCHAR2 DEFAULT NULL,
362 x_anon_assess_grading_ind IN VARCHAR2 DEFAULT NULL,
363 x_auditable_ind IN VARCHAR2 DEFAULT 'N',
364 x_audit_permission_ind IN VARCHAR2 DEFAULT 'N',
365 x_max_auditors_allowed IN NUMBER DEFAULT NULL,
366 x_billing_credit_points IN NUMBER DEFAULT NULL,
367 x_ovrd_wkld_val_flag IN VARCHAR2 DEFAULT 'N',
368 x_workload_val_code IN VARCHAR2 DEFAULT NULL,
369 x_billing_hrs IN NUMBER DEFAULT NULL
370 );
371 /*******************************************************************************
372 Created by : Oracle IDC
373 Date created:
374 Purpose:
375 1.
376 Usage: (e.g. restricted, unrestricted, where to call from)
377 1.
381 Who When What
378 Known limitations/enhancements/remarks:
379 -
380 Change History: (who, when, what: NO CREATION RECORDS HERE!)
382 msrinivi 18 Jul,2001 Added a new col : revenue_account_cd
383 *******************************************************************************/
384 PROCEDURE ADD_ROW (
385 X_ROWID in out NOCOPY VARCHAR2,
386 X_UNIT_CD in VARCHAR2,
387 X_VERSION_NUMBER in NUMBER,
388 X_START_DT in DATE,
389 X_REVIEW_DT in DATE,
390 X_EXPIRY_DT in DATE,
391 X_END_DT in DATE,
392 X_UNIT_STATUS in VARCHAR2,
393 X_TITLE in VARCHAR2,
394 X_SHORT_TITLE in VARCHAR2,
395 X_TITLE_OVERRIDE_IND in VARCHAR2,
396 X_ABBREVIATION in VARCHAR2,
397 X_UNIT_LEVEL in VARCHAR2,
398 X_CREDIT_POINT_DESCRIPTOR in VARCHAR2,
399 X_ENROLLED_CREDIT_POINTS in NUMBER,
400 X_POINTS_OVERRIDE_IND in VARCHAR2,
401 X_SUPP_EXAM_PERMITTED_IND in VARCHAR2,
402 X_COORD_PERSON_ID in NUMBER,
403 X_OWNER_ORG_UNIT_CD in VARCHAR2,
404 X_OWNER_OU_START_DT in DATE,
405 X_AWARD_COURSE_ONLY_IND in VARCHAR2,
406 X_RESEARCH_UNIT_IND in VARCHAR2,
407 X_INDUSTRIAL_IND in VARCHAR2,
408 X_PRACTICAL_IND in VARCHAR2,
409 X_REPEATABLE_IND in VARCHAR2,
410 X_ASSESSABLE_IND in VARCHAR2,
411 X_ACHIEVABLE_CREDIT_POINTS in NUMBER,
412 X_POINTS_INCREMENT in NUMBER,
413 X_POINTS_MIN in NUMBER,
414 X_POINTS_MAX in NUMBER,
415 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
416 X_SUBTITLE in VARCHAR2,
417 X_SUBTITLE_MODIFIABLE_FLAG in VARCHAR2,
418 X_APPROVAL_DATE in DATE,
419 X_LECTURE_CREDIT_POINTS in NUMBER,
420 X_LAB_CREDIT_POINTS in NUMBER,
421 X_OTHER_CREDIT_POINTS in NUMBER,
422 X_CLOCK_HOURS in NUMBER,
423 X_WORK_LOAD_CP_LECTURE in NUMBER,
424 X_WORK_LOAD_CP_LAB in NUMBER,
425 X_CONTINUING_EDUCATION_UNITS in NUMBER,
426 X_ENROLLMENT_EXPECTED in NUMBER,
427 X_ENROLLMENT_MINIMUM in NUMBER,
428 X_ENROLLMENT_MAXIMUM in NUMBER,
429 X_ADVANCE_MAXIMUM in NUMBER,
430 X_STATE_FINANCIAL_AID in VARCHAR2,
431 X_FEDERAL_FINANCIAL_AID in VARCHAR2,
432 X_INSTITUTIONAL_FINANCIAL_AID in VARCHAR2,
433 X_SAME_TEACHING_PERIOD in VARCHAR2,
434 X_MAX_REPEATS_FOR_CREDIT in NUMBER,
435 X_MAX_REPEATS_FOR_FUNDING in NUMBER,
436 X_MAX_REPEAT_CREDIT_POINTS in NUMBER,
437 X_SAME_TEACH_PERIOD_REPEATS in NUMBER,
438 X_SAME_TEACH_PERIOD_REPEATS_CP in NUMBER,
439 X_ATTRIBUTE_CATEGORY in VARCHAR2,
440 X_ATTRIBUTE1 in VARCHAR2,
441 X_ATTRIBUTE2 in VARCHAR2,
442 X_ATTRIBUTE3 in VARCHAR2,
443 X_ATTRIBUTE4 in VARCHAR2,
444 X_ATTRIBUTE5 in VARCHAR2,
445 X_ATTRIBUTE6 in VARCHAR2,
446 X_ATTRIBUTE7 in VARCHAR2,
447 X_ATTRIBUTE8 in VARCHAR2,
448 X_ATTRIBUTE9 in VARCHAR2,
449 X_ATTRIBUTE10 in VARCHAR2,
450 X_ATTRIBUTE11 in VARCHAR2,
451 X_ATTRIBUTE12 in VARCHAR2,
452 X_ATTRIBUTE13 in VARCHAR2,
453 X_ATTRIBUTE14 in VARCHAR2,
454 X_ATTRIBUTE15 in VARCHAR2,
455 X_ATTRIBUTE16 in VARCHAR2,
456 X_ATTRIBUTE17 in VARCHAR2,
457 X_ATTRIBUTE18 in VARCHAR2,
458 X_ATTRIBUTE19 in VARCHAR2,
459 X_ATTRIBUTE20 in VARCHAR2,
460 x_subtitle_id IN NUMBER DEFAULT NULL,
461 x_work_load_other IN NUMBER DEFAULT NULL,
462 x_contact_hrs_lecture IN NUMBER DEFAULT NULL,
463 x_contact_hrs_lab IN NUMBER DEFAULT NULL,
464 x_contact_hrs_other IN NUMBER DEFAULT NULL,
465 x_non_schd_required_hrs IN NUMBER DEFAULT NULL,
466 x_exclude_from_max_cp_limit IN VARCHAR2 DEFAULT NULL,
467 x_record_exclusion_flag IN VARCHAR2 DEFAULT NULL,
468 x_ss_display_ind IN VARCHAR2 DEFAULT NULL,
469 x_cal_type_enrol_load_cal IN VARCHAR2 DEFAULT NULL,
470 x_sequence_num_enrol_load_cal IN NUMBER DEFAULT NULL,
471 x_cal_type_offer_load_cal IN VARCHAR2 DEFAULT NULL,
472 x_sequence_num_offer_load_cal IN NUMBER DEFAULT NULL,
473 x_curriculum_id IN VARCHAR2 DEFAULT NULL,
474 x_override_enrollment_max IN NUMBER DEFAULT NULL,
475 x_rpt_fmly_id IN NUMBER DEFAULT NULL,
476 x_unit_type_id IN NUMBER DEFAULT NULL,
477 x_special_permission_ind IN VARCHAR2 DEFAULT NULL,
478 X_MODE in VARCHAR2 default 'R',
479 X_ORG_ID IN NUMBER ,
480 X_SS_ENROL_IND IN VARCHAR2 DEFAULT 'N',
481 X_IVR_ENROL_IND IN VARCHAR2 DEFAULT 'N',
482 x_claimable_hours IN NUMBER DEFAULT NULL,
483 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
484 x_anon_unit_grading_ind IN VARCHAR2 DEFAULT NULL,
485 x_anon_assess_grading_ind IN VARCHAR2 DEFAULT NULL,
486 x_auditable_ind IN VARCHAR2 DEFAULT 'N',
487 x_audit_permission_ind IN VARCHAR2 DEFAULT 'N',
488 x_max_auditors_allowed IN NUMBER DEFAULT NULL ,
489 x_billing_credit_points IN NUMBER DEFAULT NULL,
490 x_ovrd_wkld_val_flag IN VARCHAR2 DEFAULT 'N',
491 x_workload_val_code IN VARCHAR2 DEFAULT NULL,
492 x_billing_hrs IN NUMBER DEFAULT NULL
493 );
494 /*******************************************************************************
495 Created by : Oracle IDC
496 Date created:
497 Purpose:
498 1.
499 Usage: (e.g. restricted, unrestricted, where to call from)
500 1.
501 Known limitations/enhancements/remarks:
502 -
506 PROCEDURE DELETE_ROW (
503 Change History: (who, when, what: NO CREATION RECORDS HERE!)
504 Who When What
505 *******************************************************************************/
507 X_ROWID in VARCHAR2
508 );
509 /*******************************************************************************
510 Created by : Oracle IDC
511 Date created:
512 Purpose:
513 1.
514 Usage: (e.g. restricted, unrestricted, where to call from)
515 1.
516 Known limitations/enhancements/remarks: -
517 Change History: (who, when, what: NO CREATION RECORDS HERE!)
518 Who When What
519 *******************************************************************************/
520 FUNCTION Get_PK_For_Validation (
521 x_unit_cd IN VARCHAR2,
522 x_version_number IN NUMBER
523 ) RETURN BOOLEAN;
524
525 /*******************************************************************************
526 Created by : Oracle IDC
527 Date created:
528 Purpose:
529 1.
530 Usage: (e.g. restricted, unrestricted, where to call from)
531 1.
532 Known limitations/enhancements/remarks: -
533 Change History: (who, when, what: NO CREATION RECORDS HERE!)
534 Who When What
535 *******************************************************************************/
536 PROCEDURE GET_FK_IGS_PS_CR_PT_DSCR (
537 x_credit_point_descriptor IN VARCHAR2
538 );
539
540 /*******************************************************************************
541 Created by : Oracle IDC
542 Date created:
543 Purpose:
544 1.
545 Usage: (e.g. restricted, unrestricted, where to call from)
546 1.
547 Known limitations/enhancements/remarks: -
548 Change History: (who, when, what: NO CREATION RECORDS HERE!)
549 Who When What
550 *******************************************************************************/
551 PROCEDURE GET_FK_IGS_OR_UNIT (
552 x_org_unit_cd IN VARCHAR2,
553 x_start_dt IN DATE
554 );
555 /*******************************************************************************
556 Created by : Oracle IDC
557 Date created:
558 Purpose:
559 1.
560 Usage: (e.g. restricted, unrestricted, where to call from)
561 1.
562 Known limitations/enhancements/remarks: -
563 Change History: (who, when, what: NO CREATION RECORDS HERE!)
564 Who When What
565 *******************************************************************************/
566 PROCEDURE GET_FK_IGS_PE_PERSON (
567 x_person_id IN NUMBER
568 );
569
570 /*******************************************************************************
571 Created by : Oracle IDC
572 Date created:
573 Purpose:
574 1.
575 Usage: (e.g. restricted, unrestricted, where to call from)
576 1.
577 Known limitations/enhancements/remarks: -
578 Change History: (who, when, what: NO CREATION RECORDS HERE!)
579 Who When What
580 *******************************************************************************/
581 PROCEDURE GET_FK_IGS_PS_UNIT_INT_LVL (
582 x_unit_int_course_level_cd IN VARCHAR2
583 );
584
585 /*******************************************************************************
586 Created by : Oracle IDC
587 Date created:
588 Purpose:
589 1.
590 Usage: (e.g. restricted, unrestricted, where to call from)
591 1.
592 Known limitations/enhancements/remarks: -
593 Change History: (who, when, what: NO CREATION RECORDS HERE!)
594 Who When What
595 *******************************************************************************/
596
597 PROCEDURE GET_FK_IGS_PS_UNIT (
598 x_unit_cd IN VARCHAR2
599 );
600
601 /*******************************************************************************
602 Created by : Oracle IDC
603 Date created:
604 Purpose:
605 1.
606 Usage: (e.g. restricted, unrestricted, where to call from)
607 1.
608 Known limitations/enhancements/remarks: -
609 Change History: (who, when, what: NO CREATION RECORDS HERE!)
610 Who When What
611 *******************************************************************************/
612 PROCEDURE GET_FK_IGS_PS_UNIT_STAT (
613 x_unit_status IN VARCHAR2
614 );
615
616 /*******************************************************************************
617 Created by : Oracle IDC
618 Date created:
619 Purpose:
620 1.
621 Usage: (e.g. restricted, unrestricted, where to call from)
622 1.
623 Known limitations/enhancements/remarks: -
624 Change History: (who, when, what: NO CREATION RECORDS HERE!)
625 Who When What
626 *******************************************************************************/
627 PROCEDURE GET_FK_IGS_PS_RPT_FMLY_ALL(
628 x_rpt_fmly_id IN NUMBER
629 );
630
631 /*******************************************************************************
632 Created by : Oracle IDC
633 Date created:
634 Purpose:
635 1.
636 Usage: (e.g. restricted, unrestricted, where to call from)
637 1.
641 *******************************************************************************/
638 Known limitations/enhancements/remarks: -
639 Change History: (who, when, what: NO CREATION RECORDS HERE!)
640 Who When What
642 PROCEDURE get_fk_igs_ps_unit_subtitle (
643 x_subtitle_id IN NUMBER
644 );
645
646 /*******************************************************************************
647 Created by : Oracle IDC
648 Date created:
649 Purpose:
650 1.
651 Usage: (e.g. restricted, unrestricted, where to call from)
652 1.
653 Known limitations/enhancements/remarks: -
654 Change History: (who, when, what: NO CREATION RECORDS HERE!)
655 Who When What
656 *******************************************************************************/
657 PROCEDURE get_fk_igs_ps_unt_crclm_all(
658 x_curriculum_id IN VARCHAR2
659 );
660 /*******************************************************************************
661 Created by : Oracle IDC
662 Date created:
663 Purpose:
664 1.
665 Usage: (e.g. restricted, unrestricted, where to call from)
666 1.
667 Known limitations/enhancements/remarks: -
668 Change History: (who, when, what: NO CREATION RECORDS HERE!)
669 Who When What
670 *******************************************************************************/
671 PROCEDURE get_fk_igs_ca_inst_all(
672 x_cal_type IN VARCHAR2,
673 x_sequence_number IN NUMBER
674 );
675
676 /*******************************************************************************
677 Created by : Oracle IDC
678 Date created:
679 Purpose:
680 1.
681 Usage: (e.g. restricted, unrestricted, where to call from)
682 1.
683 Known limitations/enhancements/remarks: -
684 Change History: (who, when, what: NO CREATION RECORDS HERE!)
685 Who When What
686 *******************************************************************************/
687 PROCEDURE get_fk_igs_ca_inst_all1(
688 x_cal_type IN VARCHAR2,
689 x_sequence_number IN NUMBER
690 );
691
692 /*******************************************************************************
693 Created by : Oracle IDC
694 Date created:
695 Purpose:
696 1.
697 Usage: (e.g. restricted, unrestricted, where to call from)
698 1.
699 Known limitations/enhancements/remarks: -
700 Change History: (who, when, what: NO CREATION RECORDS HERE!)
701 Who When What
702 *******************************************************************************/
703 PROCEDURE Check_Constraints(
704 Column_Name IN VARCHAR2 DEFAULT NULL,
705 Column_Value IN VARCHAR2 DEFAULT NULL);
706
707 /*******************************************************************************
708 Created by : Oracle IDC
709 Date created:
710 Purpose:
711 1.
712 Usage: (e.g. restricted, unrestricted, where to call from)
713 1.
714 Known limitations/enhancements/remarks: -
715 Change History: (who, when, what: NO CREATION RECORDS HERE!)
716 Who When What
717 msrinivi 18 Jul,2001 Added a new col : revenue_account_cd
718 *******************************************************************************/
719 PROCEDURE Before_DML (
720 P_ACTION IN VARCHAR2,
721 X_ROWID IN VARCHAR2 DEFAULT NULL,
722 X_UNIT_CD in VARCHAR2 DEFAULT NULL,
723 X_VERSION_NUMBER in NUMBER DEFAULT NULL,
724 X_START_DT in DATE DEFAULT NULL,
725 X_REVIEW_DT in DATE DEFAULT NULL,
726 X_EXPIRY_DT in DATE DEFAULT NULL,
727 X_END_DT in DATE DEFAULT NULL,
728 X_UNIT_STATUS in VARCHAR2 DEFAULT NULL,
729 X_TITLE in VARCHAR2 DEFAULT NULL,
730 X_SHORT_TITLE in VARCHAR2 DEFAULT NULL,
731 X_TITLE_OVERRIDE_IND in VARCHAR2 DEFAULT NULL,
732 X_ABBREVIATION in VARCHAR2 DEFAULT NULL,
733 X_UNIT_LEVEL in VARCHAR2 DEFAULT NULL,
734 X_CREDIT_POINT_DESCRIPTOR in VARCHAR2 DEFAULT NULL,
735 X_ENROLLED_CREDIT_POINTS in NUMBER DEFAULT NULL,
736 X_POINTS_OVERRIDE_IND in VARCHAR2 DEFAULT NULL,
737 X_SUPP_EXAM_PERMITTED_IND in VARCHAR2 DEFAULT NULL,
738 X_COORD_PERSON_ID in NUMBER DEFAULT NULL,
739 X_OWNER_ORG_UNIT_CD in VARCHAR2 DEFAULT NULL,
740 X_OWNER_OU_START_DT in DATE DEFAULT NULL,
741 X_AWARD_COURSE_ONLY_IND in VARCHAR2 DEFAULT NULL,
742 X_RESEARCH_UNIT_IND in VARCHAR2 DEFAULT NULL,
743 X_INDUSTRIAL_IND in VARCHAR2 DEFAULT NULL,
744 X_PRACTICAL_IND in VARCHAR2 DEFAULT NULL,
745 X_REPEATABLE_IND in VARCHAR2 DEFAULT NULL,
746 X_ASSESSABLE_IND in VARCHAR2 DEFAULT NULL,
747 X_ACHIEVABLE_CREDIT_POINTS in NUMBER DEFAULT NULL,
748 X_POINTS_INCREMENT in NUMBER DEFAULT NULL,
749 X_POINTS_MIN in NUMBER DEFAULT NULL,
750 X_POINTS_MAX in NUMBER DEFAULT NULL,
751 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2 DEFAULT NULL,
752 X_SUBTITLE in VARCHAR2 DEFAULT NULL,
753 X_SUBTITLE_MODIFIABLE_FLAG in VARCHAR2 DEFAULT NULL,
754 X_APPROVAL_DATE in DATE DEFAULT NULL,
755 X_LECTURE_CREDIT_POINTS in NUMBER DEFAULT NULL,
756 X_LAB_CREDIT_POINTS in NUMBER DEFAULT NULL,
757 X_OTHER_CREDIT_POINTS in NUMBER DEFAULT NULL,
758 X_CLOCK_HOURS in NUMBER DEFAULT NULL,
759 X_WORK_LOAD_CP_LECTURE in NUMBER DEFAULT NULL,
760 X_WORK_LOAD_CP_LAB in NUMBER DEFAULT NULL,
761 X_CONTINUING_EDUCATION_UNITS in NUMBER DEFAULT NULL,
762 X_ENROLLMENT_EXPECTED in NUMBER DEFAULT NULL,
763 X_ENROLLMENT_MINIMUM in NUMBER DEFAULT NULL,
764 X_ENROLLMENT_MAXIMUM in NUMBER DEFAULT NULL,
765 X_ADVANCE_MAXIMUM in NUMBER DEFAULT NULL,
766 X_STATE_FINANCIAL_AID in VARCHAR2 DEFAULT NULL,
767 X_FEDERAL_FINANCIAL_AID in VARCHAR2 DEFAULT NULL,
768 X_INSTITUTIONAL_FINANCIAL_AID in VARCHAR2 DEFAULT NULL,
769 X_SAME_TEACHING_PERIOD in VARCHAR2 DEFAULT NULL,
770 X_MAX_REPEATS_FOR_CREDIT in NUMBER DEFAULT NULL,
771 X_MAX_REPEATS_FOR_FUNDING in NUMBER DEFAULT NULL,
772 X_MAX_REPEAT_CREDIT_POINTS in NUMBER DEFAULT NULL,
773 X_SAME_TEACH_PERIOD_REPEATS in NUMBER DEFAULT NULL,
774 X_SAME_TEACH_PERIOD_REPEATS_CP in NUMBER DEFAULT NULL,
775 X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
776 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
777 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
778 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
779 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
780 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
781 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
782 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
783 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
784 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
785 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
786 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
787 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
788 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
789 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
790 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
791 X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
792 X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
793 X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
794 X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
795 X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
796 x_subtitle_id IN NUMBER DEFAULT NULL,
797 x_work_load_other IN NUMBER DEFAULT NULL,
798 x_contact_hrs_lecture IN NUMBER DEFAULT NULL,
799 x_contact_hrs_lab IN NUMBER DEFAULT NULL,
800 x_contact_hrs_other IN NUMBER DEFAULT NULL,
801 x_non_schd_required_hrs IN NUMBER DEFAULT NULL,
802 x_exclude_from_max_cp_limit IN VARCHAR2 DEFAULT NULL,
803 x_record_exclusion_flag IN VARCHAR2 DEFAULT NULL,
804 x_ss_display_ind IN VARCHAR2 DEFAULT NULL,
805 x_cal_type_enrol_load_cal IN VARCHAR2 DEFAULT NULL,
806 x_sequence_num_enrol_load_cal IN NUMBER DEFAULT NULL,
807 x_cal_type_offer_load_cal IN VARCHAR2 DEFAULT NULL,
808 x_sequence_num_offer_load_cal IN NUMBER DEFAULT NULL,
809 x_curriculum_id IN VARCHAR2 DEFAULT NULL,
810 x_override_enrollment_max IN NUMBER DEFAULT NULL,
811 x_rpt_fmly_id IN NUMBER DEFAULT NULL,
812 x_unit_type_id IN NUMBER DEFAULT NULL,
813 x_special_permission_ind IN VARCHAR2 DEFAULT NULL,
814 X_CREATED_BY in NUMBER DEFAULT NULL,
815 X_CREATION_DATE in DATE DEFAULT NULL,
816 X_LAST_UPDATED_BY in NUMBER DEFAULT NULL,
817 X_LAST_UPDATE_DATE in DATE DEFAULT NULL,
818 X_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL,
819 X_ORG_ID IN NUMBER DEFAULT NULL,
820 X_SS_ENROL_IND IN VARCHAR2 DEFAULT 'N',
821 X_IVR_ENROL_IND IN VARCHAR2 DEFAULT 'N',
822 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
823 x_claimable_hours IN NUMBER DEFAULT NULL,
824 x_anon_unit_grading_ind IN VARCHAR2 DEFAULT NULL,
825 x_anon_assess_grading_ind IN VARCHAR2 DEFAULT NULL,
826 x_auditable_ind IN VARCHAR2 DEFAULT 'N',
827 x_audit_permission_ind IN VARCHAR2 DEFAULT 'N',
828 x_max_auditors_allowed IN NUMBER DEFAULT NULL,
829 x_billing_credit_points IN NUMBER DEFAULT NULL,
830 x_ovrd_wkld_val_flag IN VARCHAR2 DEFAULT 'N',
831 x_workload_val_code IN VARCHAR2 DEFAULT NULL,
832 x_billing_hrs IN NUMBER DEFAULT NULL
833 );
834
835 PROCEDURE update_row_subtitle_id(X_RowId IN VARCHAR2,X_Subtitle_Id IN NUMBER);
836 /*******************************************************************************
837 Created by : Sommukhe, Oracle IDC
838 Date created:
839 Purpose:
840
841 Known limitations/enhancements/remarks:
842 -
843 Change History:
844 Who When What
845 *******************************************************************************/
846
847 END IGS_PS_UNIT_VER_PKG;
[Home] [Help]