1 package IGS_PS_UNIT_VER_HIST_PKG as
2 /* $Header: IGSPI93S.pls 120.0 2005/06/01 23:14:55 appldev noship $ */
3 PROCEDURE INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_UNIT_CD in VARCHAR2,
6 X_VERSION_NUMBER in NUMBER,
7 X_HIST_START_DT in DATE,
8 X_HIST_END_DT in DATE,
9 X_HIST_WHO in NUMBER,
10 X_START_DT in DATE,
11 X_REVIEW_DT in DATE,
12 X_EXPIRY_DT in DATE,
13 X_END_DT in DATE,
14 X_UNIT_STATUS in VARCHAR2,
15 X_TITLE in VARCHAR2,
16 X_SHORT_TITLE in VARCHAR2,
17 X_TITLE_OVERRIDE_IND in VARCHAR2,
18 X_ABBREVIATION in VARCHAR2,
19 X_UNIT_LEVEL in VARCHAR2,
20 X_UL_DESCRIPTION in VARCHAR2,
21 X_CREDIT_POINT_DESCRIPTOR in VARCHAR2,
22 X_ENROLLED_CREDIT_POINTS in NUMBER,
23 X_POINTS_OVERRIDE_IND in VARCHAR2,
24 X_SUPP_EXAM_PERMITTED_IND in VARCHAR2,
25 X_COORD_PERSON_ID in NUMBER,
26 X_OWNER_ORG_UNIT_CD in VARCHAR2,
27 X_OWNER_OU_START_DT in DATE,
28 X_OU_DESCRIPTION in VARCHAR2,
29 X_AWARD_COURSE_ONLY_IND in VARCHAR2,
30 X_RESEARCH_UNIT_IND in VARCHAR2,
31 X_INDUSTRIAL_IND in VARCHAR2,
32 X_PRACTICAL_IND in VARCHAR2,
33 X_REPEATABLE_IND in VARCHAR2,
34 X_ASSESSABLE_IND in VARCHAR2,
35 X_ACHIEVABLE_CREDIT_POINTS in NUMBER,
36 X_POINTS_INCREMENT in NUMBER,
37 X_POINTS_MIN in NUMBER,
38 X_POINTS_MAX in NUMBER,
39 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
40 X_UICL_DESCRIPTION in VARCHAR2,
41 x_subtitle_id IN NUMBER DEFAULT NULL,
42 x_work_load_other IN NUMBER DEFAULT NULL,
43 x_contact_hrs_lecture IN NUMBER DEFAULT NULL,
44 x_contact_hrs_lab IN NUMBER DEFAULT NULL,
45 x_contact_hrs_other IN NUMBER DEFAULT NULL,
46 x_non_schd_required_hrs IN NUMBER DEFAULT NULL,
47 x_exclude_from_max_cp_limit IN VARCHAR2 DEFAULT NULL,
48 x_record_exclusion_flag IN VARCHAR2 DEFAULT NULL,
49 x_ss_display_ind IN VARCHAR2 DEFAULT NULL,
50 x_cal_type_enrol_load_cal IN VARCHAR2 DEFAULT NULL,
51 x_sequence_num_enrol_load_cal IN NUMBER DEFAULT NULL,
52 x_cal_type_offer_load_cal IN VARCHAR2 DEFAULT NULL,
53 x_sequence_num_offer_load_cal IN NUMBER DEFAULT NULL,
54 x_curriculum_id IN VARCHAR2 DEFAULT NULL,
55 x_override_enrollment_max IN NUMBER DEFAULT NULL,
56 x_rpt_fmly_id IN NUMBER DEFAULT NULL,
57 x_repeat_code IN VARCHAR2 DEFAULT NULL,
58 x_unit_type_id IN NUMBER DEFAULT NULL,
59 x_level_code IN VARCHAR2 DEFAULT NULL,
60 x_advance_maximum IN NUMBER DEFAULT NULL,
61 x_approval_date IN DATE DEFAULT NULL,
62 x_continuing_education_units IN NUMBER DEFAULT NULL,
63 x_enrollment_expected IN NUMBER DEFAULT NULL,
64 x_enrollment_maximum IN NUMBER DEFAULT NULL,
65 x_enrollment_minimum IN NUMBER DEFAULT NULL,
66 x_federal_financial_aid IN VARCHAR2 DEFAULT NULL,
67 x_institutional_financial_aid IN VARCHAR2 DEFAULT NULL,
68 x_lab_credit_points IN NUMBER DEFAULT NULL,
69 x_lecture_credit_points IN NUMBER DEFAULT NULL,
70 x_max_repeats_for_credit IN NUMBER DEFAULT NULL,
71 x_max_repeats_for_funding IN NUMBER DEFAULT NULL,
72 x_max_repeat_credit_points IN NUMBER DEFAULT NULL,
73 x_clock_hours IN NUMBER DEFAULT NULL,
74 x_other_credit_points IN NUMBER DEFAULT NULL,
75 x_same_teaching_period IN VARCHAR2 DEFAULT NULL,
76 x_same_teach_period_repeats IN NUMBER DEFAULT NULL,
77 x_same_teach_period_repeats_cp IN NUMBER DEFAULT NULL,
78 x_state_financial_aid IN VARCHAR2 DEFAULT NULL,
79 x_work_load_cp_lab IN NUMBER DEFAULT NULL,
80 x_work_load_cp_lecture IN NUMBER DEFAULT NULL,
81 x_subtitle_modifiable_flag IN VARCHAR2 DEFAULT NULL,
82 x_subtitle IN VARCHAR2 DEFAULT NULL,
83 x_special_permission_ind IN VARCHAR2 DEFAULT NULL,
84 X_MODE IN VARCHAR2 DEFAULT 'R' ,
85 X_ORG_ID IN NUMBER,
86 X_SS_ENROL_IND IN VARCHAR2 DEFAULT 'N',
87 X_IVR_ENROL_IND IN VARCHAR2 DEFAULT 'N',
88 x_claimable_hours IN NUMBER DEFAULT NULL,
89 x_auditable_ind IN VARCHAR2 DEFAULT 'N',
90 x_audit_permission_ind IN VARCHAR2 DEFAULT 'N',
91 x_max_auditors_allowed IN NUMBER DEFAULT NULL,
92 x_billing_credit_points IN NUMBER DEFAULT NULL,
93 x_ovrd_wkld_val_flag IN VARCHAR2 DEFAULT NULL,
94 x_workload_val_code IN VARCHAR2 DEFAULT NULL,
95 x_billing_hrs IN NUMBER DEFAULT NULL
96 );
97
98 PROCEDURE LOCK_ROW (
99 X_ROWID in VARCHAR2,
100 X_UNIT_CD in VARCHAR2,
101 X_VERSION_NUMBER in NUMBER,
102 X_HIST_START_DT in DATE,
103 X_HIST_END_DT in DATE,
104 X_HIST_WHO in NUMBER,
105 X_START_DT in DATE,
106 X_REVIEW_DT in DATE,
107 X_EXPIRY_DT in DATE,
108 X_END_DT in DATE,
109 X_UNIT_STATUS in VARCHAR2,
110 X_TITLE in VARCHAR2,
111 X_SHORT_TITLE in VARCHAR2,
112 X_TITLE_OVERRIDE_IND in VARCHAR2,
113 X_ABBREVIATION in VARCHAR2,
114 X_UNIT_LEVEL in VARCHAR2,
115 X_UL_DESCRIPTION in VARCHAR2,
116 X_CREDIT_POINT_DESCRIPTOR in VARCHAR2,
117 X_ENROLLED_CREDIT_POINTS in NUMBER,
118 X_POINTS_OVERRIDE_IND in VARCHAR2,
119 X_SUPP_EXAM_PERMITTED_IND in VARCHAR2,
120 X_COORD_PERSON_ID in NUMBER,
121 X_OWNER_ORG_UNIT_CD in VARCHAR2,
122 X_OWNER_OU_START_DT in DATE,
123 X_OU_DESCRIPTION in VARCHAR2,
124 X_AWARD_COURSE_ONLY_IND in VARCHAR2,
125 X_RESEARCH_UNIT_IND in VARCHAR2,
126 X_INDUSTRIAL_IND in VARCHAR2,
127 X_PRACTICAL_IND in VARCHAR2,
128 X_REPEATABLE_IND in VARCHAR2,
129 X_ASSESSABLE_IND in VARCHAR2,
130 X_ACHIEVABLE_CREDIT_POINTS in NUMBER,
131 X_POINTS_INCREMENT in NUMBER,
132 X_POINTS_MIN in NUMBER,
133 X_POINTS_MAX in NUMBER,
134 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
135 X_UICL_DESCRIPTION in VARCHAR2,
136 x_subtitle_id IN NUMBER DEFAULT NULL,
137 x_work_load_other IN NUMBER DEFAULT NULL,
138 x_contact_hrs_lecture IN NUMBER DEFAULT NULL,
139 x_contact_hrs_lab IN NUMBER DEFAULT NULL,
140 x_contact_hrs_other IN NUMBER DEFAULT NULL,
141 x_non_schd_required_hrs IN NUMBER DEFAULT NULL,
142 x_exclude_from_max_cp_limit IN VARCHAR2 DEFAULT NULL,
143 x_record_exclusion_flag IN VARCHAR2 DEFAULT NULL,
144 x_ss_display_ind IN VARCHAR2 DEFAULT NULL,
145 x_cal_type_enrol_load_cal IN VARCHAR2 DEFAULT NULL,
146 x_sequence_num_enrol_load_cal IN NUMBER DEFAULT NULL,
147 x_cal_type_offer_load_cal IN VARCHAR2 DEFAULT NULL,
148 x_sequence_num_offer_load_cal IN NUMBER DEFAULT NULL,
149 x_curriculum_id IN VARCHAR2 DEFAULT NULL,
150 x_override_enrollment_max IN NUMBER DEFAULT NULL,
151 x_rpt_fmly_id IN NUMBER DEFAULT NULL,
152 x_repeat_code IN VARCHAR2 DEFAULT NULL,
153 x_unit_type_id IN NUMBER DEFAULT NULL,
154 x_level_code IN VARCHAR2 DEFAULT NULL,
155 x_advance_maximum IN NUMBER DEFAULT NULL,
156 x_approval_date IN DATE DEFAULT NULL,
157 x_continuing_education_units IN NUMBER DEFAULT NULL,
158 x_enrollment_expected IN NUMBER DEFAULT NULL,
159 x_enrollment_maximum IN NUMBER DEFAULT NULL,
160 x_enrollment_minimum IN NUMBER DEFAULT NULL,
161 x_federal_financial_aid IN VARCHAR2 DEFAULT NULL,
162 x_institutional_financial_aid IN VARCHAR2 DEFAULT NULL,
163 x_lab_credit_points IN NUMBER DEFAULT NULL,
164 x_lecture_credit_points IN NUMBER DEFAULT NULL,
165 x_max_repeats_for_credit IN NUMBER DEFAULT NULL,
166 x_max_repeats_for_funding IN NUMBER DEFAULT NULL,
167 x_max_repeat_credit_points IN NUMBER DEFAULT NULL,
168 x_clock_hours IN NUMBER DEFAULT NULL,
169 x_other_credit_points IN NUMBER DEFAULT NULL,
170 x_same_teaching_period IN VARCHAR2 DEFAULT NULL,
171 x_same_teach_period_repeats IN NUMBER DEFAULT NULL,
172 x_same_teach_period_repeats_cp IN NUMBER DEFAULT NULL,
173 x_state_financial_aid IN VARCHAR2 DEFAULT NULL,
174 x_work_load_cp_lab IN NUMBER DEFAULT NULL,
175 x_work_load_cp_lecture IN NUMBER DEFAULT NULL,
176 x_subtitle_modifiable_flag IN VARCHAR2 DEFAULT NULL,
177 x_subtitle IN VARCHAR2 DEFAULT NULL,
178 x_special_permission_ind IN VARCHAR2 DEFAULT NULL,
179 X_SS_ENROL_IND IN VARCHAR2,
180 X_IVR_ENROL_IND IN VARCHAR2,
181 x_claimable_hours IN NUMBER DEFAULT NULL,
182 x_auditable_ind IN VARCHAR2 DEFAULT 'N',
183 x_audit_permission_ind IN VARCHAR2 DEFAULT 'N',
184 x_max_auditors_allowed IN NUMBER DEFAULT NULL,
185 x_billing_credit_points IN NUMBER DEFAULT NULL,
186 x_ovrd_wkld_val_flag IN VARCHAR2 DEFAULT 'N',
187 x_workload_val_code IN VARCHAR2 DEFAULT NULL,
188 x_billing_hrs IN NUMBER DEFAULT NULL
189 );
190
191 PROCEDURE UPDATE_ROW (
192 X_ROWID in VARCHAR2,
193 X_UNIT_CD in VARCHAR2,
194 X_VERSION_NUMBER in NUMBER,
195 X_HIST_START_DT in DATE,
196 X_HIST_END_DT in DATE,
197 X_HIST_WHO in NUMBER,
198 X_START_DT in DATE,
199 X_REVIEW_DT in DATE,
200 X_EXPIRY_DT in DATE,
201 X_END_DT in DATE,
202 X_UNIT_STATUS in VARCHAR2,
203 X_TITLE in VARCHAR2,
204 X_SHORT_TITLE in VARCHAR2,
205 X_TITLE_OVERRIDE_IND in VARCHAR2,
206 X_ABBREVIATION in VARCHAR2,
207 X_UNIT_LEVEL in VARCHAR2,
208 X_UL_DESCRIPTION in VARCHAR2,
209 X_CREDIT_POINT_DESCRIPTOR in VARCHAR2,
210 X_ENROLLED_CREDIT_POINTS in NUMBER,
211 X_POINTS_OVERRIDE_IND in VARCHAR2,
212 X_SUPP_EXAM_PERMITTED_IND in VARCHAR2,
213 X_COORD_PERSON_ID in NUMBER,
214 X_OWNER_ORG_UNIT_CD in VARCHAR2,
215 X_OWNER_OU_START_DT in DATE,
216 X_OU_DESCRIPTION in VARCHAR2,
217 X_AWARD_COURSE_ONLY_IND in VARCHAR2,
218 X_RESEARCH_UNIT_IND in VARCHAR2,
219 X_INDUSTRIAL_IND in VARCHAR2,
220 X_PRACTICAL_IND in VARCHAR2,
221 X_REPEATABLE_IND in VARCHAR2,
222 X_ASSESSABLE_IND in VARCHAR2,
223 X_ACHIEVABLE_CREDIT_POINTS in NUMBER,
224 X_POINTS_INCREMENT in NUMBER,
225 X_POINTS_MIN in NUMBER,
226 X_POINTS_MAX in NUMBER,
227 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
228 X_UICL_DESCRIPTION in VARCHAR2,
229 x_subtitle_id IN NUMBER DEFAULT NULL,
230 x_work_load_other IN NUMBER DEFAULT NULL,
231 x_contact_hrs_lecture IN NUMBER DEFAULT NULL,
232 x_contact_hrs_lab IN NUMBER DEFAULT NULL,
233 x_contact_hrs_other IN NUMBER DEFAULT NULL,
234 x_non_schd_required_hrs IN NUMBER DEFAULT NULL,
235 x_exclude_from_max_cp_limit IN VARCHAR2 DEFAULT NULL,
236 x_record_exclusion_flag IN VARCHAR2 DEFAULT NULL,
237 x_ss_display_ind IN VARCHAR2 DEFAULT NULL,
238 x_cal_type_enrol_load_cal IN VARCHAR2 DEFAULT NULL,
239 x_sequence_num_enrol_load_cal IN NUMBER DEFAULT NULL,
240 x_cal_type_offer_load_cal IN VARCHAR2 DEFAULT NULL,
241 x_sequence_num_offer_load_cal IN NUMBER DEFAULT NULL,
242 x_curriculum_id IN VARCHAR2 DEFAULT NULL,
243 x_override_enrollment_max IN NUMBER DEFAULT NULL,
244 x_rpt_fmly_id IN NUMBER DEFAULT NULL,
245 x_repeat_code IN VARCHAR2 DEFAULT NULL,
246 x_unit_type_id IN NUMBER DEFAULT NULL,
247 x_level_code IN VARCHAR2 DEFAULT NULL,
248 x_advance_maximum IN NUMBER DEFAULT NULL,
249 x_approval_date IN DATE DEFAULT NULL,
250 x_continuing_education_units IN NUMBER DEFAULT NULL,
251 x_enrollment_expected IN NUMBER DEFAULT NULL,
252 x_enrollment_maximum IN NUMBER DEFAULT NULL,
253 x_enrollment_minimum IN NUMBER DEFAULT NULL,
254 x_federal_financial_aid IN VARCHAR2 DEFAULT NULL,
255 x_institutional_financial_aid IN VARCHAR2 DEFAULT NULL,
256 x_lab_credit_points IN NUMBER DEFAULT NULL,
257 x_lecture_credit_points IN NUMBER DEFAULT NULL,
258 x_max_repeats_for_credit IN NUMBER DEFAULT NULL,
259 x_max_repeats_for_funding IN NUMBER DEFAULT NULL,
260 x_max_repeat_credit_points IN NUMBER DEFAULT NULL,
261 x_clock_hours IN NUMBER DEFAULT NULL,
262 x_other_credit_points IN NUMBER DEFAULT NULL,
263 x_same_teaching_period IN VARCHAR2 DEFAULT NULL,
264 x_same_teach_period_repeats IN NUMBER DEFAULT NULL,
265 x_same_teach_period_repeats_cp IN NUMBER DEFAULT NULL,
266 x_state_financial_aid IN VARCHAR2 DEFAULT NULL,
267 x_work_load_cp_lab IN NUMBER DEFAULT NULL,
268 x_work_load_cp_lecture IN NUMBER DEFAULT NULL,
269 x_subtitle_modifiable_flag IN VARCHAR2 DEFAULT NULL,
270 x_subtitle IN VARCHAR2 DEFAULT NULL,
271 x_special_permission_ind IN VARCHAR2 DEFAULT NULL,
272 X_MODE IN VARCHAR2 DEFAULT 'R',
273 X_SS_ENROL_IND IN VARCHAR2 DEFAULT 'N',
274 X_IVR_ENROL_IND IN VARCHAR2 DEFAULT 'N',
275 x_claimable_hours IN NUMBER DEFAULT NULL,
276 x_auditable_ind IN VARCHAR2 DEFAULT 'N',
277 x_audit_permission_ind IN VARCHAR2 DEFAULT 'N',
278 x_max_auditors_allowed IN NUMBER DEFAULT NULL,
279 x_billing_credit_points IN NUMBER DEFAULT NULL,
280 x_ovrd_wkld_val_flag IN VARCHAR2 DEFAULT 'N',
281 x_workload_val_code IN VARCHAR2 DEFAULT NULL,
282 x_billing_hrs IN NUMBER DEFAULT NULL
283 );
284
285 PROCEDURE ADD_ROW (
286 X_ROWID in out NOCOPY VARCHAR2,
287 X_UNIT_CD in VARCHAR2,
288 X_VERSION_NUMBER in NUMBER,
289 X_HIST_START_DT in DATE,
290 X_HIST_END_DT in DATE,
291 X_HIST_WHO in NUMBER,
292 X_START_DT in DATE,
293 X_REVIEW_DT in DATE,
294 X_EXPIRY_DT in DATE,
295 X_END_DT in DATE,
296 X_UNIT_STATUS in VARCHAR2,
297 X_TITLE in VARCHAR2,
298 X_SHORT_TITLE in VARCHAR2,
299 X_TITLE_OVERRIDE_IND in VARCHAR2,
300 X_ABBREVIATION in VARCHAR2,
301 X_UNIT_LEVEL in VARCHAR2,
302 X_UL_DESCRIPTION in VARCHAR2,
303 X_CREDIT_POINT_DESCRIPTOR in VARCHAR2,
304 X_ENROLLED_CREDIT_POINTS in NUMBER,
305 X_POINTS_OVERRIDE_IND in VARCHAR2,
306 X_SUPP_EXAM_PERMITTED_IND in VARCHAR2,
307 X_COORD_PERSON_ID in NUMBER,
308 X_OWNER_ORG_UNIT_CD in VARCHAR2,
309 X_OWNER_OU_START_DT in DATE,
310 X_OU_DESCRIPTION in VARCHAR2,
311 X_AWARD_COURSE_ONLY_IND in VARCHAR2,
312 X_RESEARCH_UNIT_IND in VARCHAR2,
313 X_INDUSTRIAL_IND in VARCHAR2,
314 X_PRACTICAL_IND in VARCHAR2,
315 X_REPEATABLE_IND in VARCHAR2,
316 X_ASSESSABLE_IND in VARCHAR2,
317 X_ACHIEVABLE_CREDIT_POINTS in NUMBER,
318 X_POINTS_INCREMENT in NUMBER,
319 X_POINTS_MIN in NUMBER,
320 X_POINTS_MAX in NUMBER,
321 X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
322 X_UICL_DESCRIPTION in VARCHAR2,
323 x_subtitle_id IN NUMBER DEFAULT NULL,
324 x_work_load_other IN NUMBER DEFAULT NULL,
325 x_contact_hrs_lecture IN NUMBER DEFAULT NULL,
326 x_contact_hrs_lab IN NUMBER DEFAULT NULL,
327 x_contact_hrs_other IN NUMBER DEFAULT NULL,
331 x_ss_display_ind IN VARCHAR2 DEFAULT NULL,
328 x_non_schd_required_hrs IN NUMBER DEFAULT NULL,
329 x_exclude_from_max_cp_limit IN VARCHAR2 DEFAULT NULL,
330 x_record_exclusion_flag IN VARCHAR2 DEFAULT NULL,
332 x_cal_type_enrol_load_cal IN VARCHAR2 DEFAULT NULL,
333 x_sequence_num_enrol_load_cal IN NUMBER DEFAULT NULL,
334 x_cal_type_offer_load_cal IN VARCHAR2 DEFAULT NULL,
335 x_sequence_num_offer_load_cal IN NUMBER DEFAULT NULL,
336 x_curriculum_id IN VARCHAR2 DEFAULT NULL,
337 x_override_enrollment_max IN NUMBER DEFAULT NULL,
338 x_rpt_fmly_id IN NUMBER DEFAULT NULL,
339 x_repeat_code IN VARCHAR2 DEFAULT NULL,
340 x_unit_type_id IN NUMBER DEFAULT NULL,
341 x_level_code IN VARCHAR2 DEFAULT NULL,
342 x_advance_maximum IN NUMBER DEFAULT NULL,
343 x_approval_date IN DATE DEFAULT NULL,
344 x_continuing_education_units IN NUMBER DEFAULT NULL,
345 x_enrollment_expected IN NUMBER DEFAULT NULL,
346 x_enrollment_maximum IN NUMBER DEFAULT NULL,
347 x_enrollment_minimum IN NUMBER DEFAULT NULL,
348 x_federal_financial_aid IN VARCHAR2 DEFAULT NULL,
349 x_institutional_financial_aid IN VARCHAR2 DEFAULT NULL,
350 x_lab_credit_points IN NUMBER DEFAULT NULL,
351 x_lecture_credit_points IN NUMBER DEFAULT NULL,
352 x_max_repeats_for_credit IN NUMBER DEFAULT NULL,
353 x_max_repeats_for_funding IN NUMBER DEFAULT NULL,
354 x_max_repeat_credit_points IN NUMBER DEFAULT NULL,
355 x_clock_hours IN NUMBER DEFAULT NULL,
356 x_other_credit_points IN NUMBER DEFAULT NULL,
357 x_same_teaching_period IN VARCHAR2 DEFAULT NULL,
358 x_same_teach_period_repeats IN NUMBER DEFAULT NULL,
359 x_same_teach_period_repeats_cp IN NUMBER DEFAULT NULL,
360 x_state_financial_aid IN VARCHAR2 DEFAULT NULL,
361 x_work_load_cp_lab IN NUMBER DEFAULT NULL,
362 x_work_load_cp_lecture IN NUMBER DEFAULT NULL,
363 x_subtitle_modifiable_flag IN VARCHAR2 DEFAULT NULL,
364 x_subtitle IN VARCHAR2 DEFAULT NULL,
365 x_special_permission_ind IN VARCHAR2 DEFAULT NULL,
366 X_MODE IN VARCHAR2 DEFAULT 'R',
367 X_ORG_ID IN NUMBER,
368 X_SS_ENROL_IND IN VARCHAR2 DEFAULT 'N',
369 X_IVR_ENROL_IND IN VARCHAR2 DEFAULT 'N',
370 x_claimable_hours IN NUMBER DEFAULT NULL,
371 x_auditable_ind IN VARCHAR2 DEFAULT 'N',
372 x_audit_permission_ind IN VARCHAR2 DEFAULT 'N',
373 x_max_auditors_allowed IN NUMBER DEFAULT NULL,
374 x_billing_credit_points IN NUMBER DEFAULT NULL,
375 x_ovrd_wkld_val_flag IN VARCHAR2 DEFAULT 'N',
376 x_workload_val_code IN VARCHAR2 DEFAULT NULL,
377 x_billing_hrs IN NUMBER DEFAULT NULL
378 );
379
380 PROCEDURE DELETE_ROW (
381 X_ROWID in VARCHAR2
382 );
383 FUNCTION Get_PK_For_Validation (
384 x_unit_cd IN VARCHAR2,
385 x_version_number IN NUMBER,
386 x_hist_start_dt IN DATE
387 ) RETURN BOOLEAN;
388
389 PROCEDURE Check_Constraints(
390 Column_Name IN VARCHAR2 DEFAULT NULL,
391 Column_Value IN VARCHAR2 DEFAULT NULL);
392
393
394
395 PROCEDURE Before_DML (
396 p_action IN VARCHAR2,
397 x_rowid IN VARCHAR2 DEFAULT NULL,
398 x_unit_cd IN VARCHAR2 DEFAULT NULL,
399 x_version_number IN NUMBER DEFAULT NULL,
400 x_hist_start_dt IN DATE DEFAULT NULL,
401 x_hist_end_dt IN DATE DEFAULT NULL,
402 x_hist_who IN NUMBER DEFAULT NULL,
403 x_start_dt IN DATE DEFAULT NULL,
404 x_review_dt IN DATE DEFAULT NULL,
405 x_expiry_dt IN DATE DEFAULT NULL,
406 x_end_dt IN DATE DEFAULT NULL,
407 x_unit_status IN VARCHAR2 DEFAULT NULL,
408 x_title IN VARCHAR2 DEFAULT NULL,
409 x_short_title IN VARCHAR2 DEFAULT NULL,
410 x_title_override_ind IN VARCHAR2 DEFAULT NULL,
411 x_abbreviation IN VARCHAR2 DEFAULT NULL,
412 x_unit_level IN VARCHAR2 DEFAULT NULL,
413 x_ul_description IN VARCHAR2 DEFAULT NULL,
414 x_credit_point_descriptor IN VARCHAR2 DEFAULT NULL,
415 x_enrolled_credit_points IN NUMBER DEFAULT NULL,
416 x_points_override_ind IN VARCHAR2 DEFAULT NULL,
417 x_supp_exam_permitted_ind IN VARCHAR2 DEFAULT NULL,
418 x_coord_person_id IN NUMBER DEFAULT NULL,
419 x_owner_org_unit_cd IN VARCHAR2 DEFAULT NULL,
420 x_owner_ou_start_dt IN DATE DEFAULT NULL,
421 x_ou_description IN VARCHAR2 DEFAULT NULL,
422 x_award_course_only_ind IN VARCHAR2 DEFAULT NULL,
423 x_research_unit_ind IN VARCHAR2 DEFAULT NULL,
424 x_industrial_ind IN VARCHAR2 DEFAULT NULL,
425 x_practical_ind IN VARCHAR2 DEFAULT NULL,
426 x_repeatable_ind IN VARCHAR2 DEFAULT NULL,
427 x_assessable_ind IN VARCHAR2 DEFAULT NULL,
428 x_achievable_credit_points IN NUMBER DEFAULT NULL,
429 x_points_increment IN NUMBER DEFAULT NULL,
430 x_points_min IN NUMBER DEFAULT NULL,
431 x_points_max IN NUMBER DEFAULT NULL,
435 x_work_load_other IN NUMBER DEFAULT NULL,
432 x_unit_int_course_level_cd IN VARCHAR2 DEFAULT NULL,
433 x_uicl_description IN VARCHAR2 DEFAULT NULL,
434 x_subtitle_id IN NUMBER DEFAULT NULL,
436 x_contact_hrs_lecture IN NUMBER DEFAULT NULL,
437 x_contact_hrs_lab IN NUMBER DEFAULT NULL,
438 x_contact_hrs_other IN NUMBER DEFAULT NULL,
439 x_non_schd_required_hrs IN NUMBER DEFAULT NULL,
440 x_exclude_from_max_cp_limit IN VARCHAR2 DEFAULT NULL,
441 x_record_exclusion_flag IN VARCHAR2 DEFAULT NULL,
442 x_ss_display_ind IN VARCHAR2 DEFAULT NULL,
443 x_cal_type_enrol_load_cal IN VARCHAR2 DEFAULT NULL,
444 x_sequence_num_enrol_load_cal IN NUMBER DEFAULT NULL,
445 x_cal_type_offer_load_cal IN VARCHAR2 DEFAULT NULL,
446 x_sequence_num_offer_load_cal IN NUMBER DEFAULT NULL,
447 x_curriculum_id IN VARCHAR2 DEFAULT NULL,
448 x_override_enrollment_max IN NUMBER DEFAULT NULL,
449 x_rpt_fmly_id IN NUMBER DEFAULT NULL,
450 x_repeat_code IN VARCHAR2 DEFAULT NULL,
451 x_unit_type_id IN NUMBER DEFAULT NULL,
452 x_level_code IN VARCHAR2 DEFAULT NULL,
453 x_advance_maximum IN NUMBER DEFAULT NULL,
454 x_approval_date IN DATE DEFAULT NULL,
455 x_continuing_education_units IN NUMBER DEFAULT NULL,
456 x_enrollment_expected IN NUMBER DEFAULT NULL,
457 x_enrollment_maximum IN NUMBER DEFAULT NULL,
458 x_enrollment_minimum IN NUMBER DEFAULT NULL,
459 x_federal_financial_aid IN VARCHAR2 DEFAULT NULL,
460 x_institutional_financial_aid IN VARCHAR2 DEFAULT NULL,
461 x_lab_credit_points IN NUMBER DEFAULT NULL,
462 x_lecture_credit_points IN NUMBER DEFAULT NULL,
463 x_max_repeats_for_credit IN NUMBER DEFAULT NULL,
464 x_max_repeats_for_funding IN NUMBER DEFAULT NULL,
465 x_max_repeat_credit_points IN NUMBER DEFAULT NULL,
466 x_clock_hours IN NUMBER DEFAULT NULL,
467 x_other_credit_points IN NUMBER DEFAULT NULL,
468 x_same_teaching_period IN VARCHAR2 DEFAULT NULL,
469 x_same_teach_period_repeats IN NUMBER DEFAULT NULL,
470 x_same_teach_period_repeats_cp IN NUMBER DEFAULT NULL,
471 x_state_financial_aid IN VARCHAR2 DEFAULT NULL,
472 x_work_load_cp_lab IN NUMBER DEFAULT NULL,
473 x_work_load_cp_lecture IN NUMBER DEFAULT NULL,
474 x_subtitle_modifiable_flag IN VARCHAR2 DEFAULT NULL,
475 x_subtitle IN VARCHAR2 DEFAULT NULL,
476 x_special_permission_ind IN VARCHAR2 DEFAULT NULL,
477 x_creation_date IN DATE DEFAULT NULL,
478 x_created_by IN NUMBER DEFAULT NULL,
479 x_last_update_date IN DATE DEFAULT NULL,
480 x_last_updated_by IN NUMBER DEFAULT NULL,
481 x_last_update_login IN NUMBER DEFAULT NULL,
482 x_org_id IN NUMBER DEFAULT NULL,
483 x_ss_enrol_ind IN VARCHAR2 DEFAULT NULL,
484 x_ivr_enrol_ind IN VARCHAR2 DEFAULT NULL,
485 x_claimable_hours IN NUMBER 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
496 END IGS_PS_UNIT_VER_HIST_PKG;
[Home] [Help]