[Home] [Help]
PACKAGE: APPS.IGS_PS_GENERIC_PUB
Source
1 PACKAGE igs_ps_generic_pub AS
2 /* $Header: IGSPS89S.pls 120.3 2006/01/17 05:53:33 sommukhe noship $ */
3 /*#
4 * A public API to import data from external system to OSS for unit section and its details. This API to be used to import scheduled data to OSS, also can be used for generic imports of unit section and details.
5 * This can also this can be used to import legacy related data.
6 * @rep:scope public
7 * @rep:product IGS
8 * @rep:displayname Program Structure and Planning Import
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY IGS_UNIT
12 */
13
14 /***********************************************************************************************
15 Created By: Sanjeeb Rakshit
16 Date Created By: 20-Nov-2002
17 Purpose: A public API to import data from external system to OSS is declared along with
18 several PL-SQL table types to be used in the API.
19 Known limitations,enhancements,remarks:
20
21 Change History
22
23 Who When What
24
25 ***********************************************************************************************/
26 -- Start of Comments
27 -- API Name : psp_import
28 -- Type : Public
29 -- Pre-reqs : None
30 -- Function : Imports Unit Section and occurrence related data from external System to OSS
31 -- Parameters
32 -- IN p_api_version
33 -- IN p_init_msg_list
34 -- IN p_commit
35 -- IN p_validation_level
36 -- OUT x_return_status
37 -- OUT x_msg_count
38 -- OUT x_msg_data
39 -- IN OUT p_usec_tbl
40 -- This parameter holds values for unit section table
41 -- IN OUT p_usec_gs_tbl
42 -- This parameter holds values for unit section grading schema table
43 -- IN OUT p_uso_tbl
44 -- This parameter holds values for unit section occurrence table
45 -- IN OUT p_unit_ref_tbl
46 -- This parameter holds values for unit/unit section/unit section occurrence reference table
47 -- IN OUT p_uso_ins_tbl
48 -- This parameter holds values for unit section occurrence instructor table
49 -- IN OUT p_usec_occurs_facility_tbl
50 -- This parameter holds values for unit section occurrence facilities table
51 -- IN OUT p_usec_teach_resp_ovrd_tbl
52 -- This parameter holds values for unit section Teaching Responsibility Override table
53 -- IN OUT p_usec_notes_tbl
54 -- This parameter holds values for unit section Notes table
55 -- IN OUT p_usec_assmnt_tbl
56 -- This parameter holds values for unit section Assessment(Exam Details) table
57 -- IN OUT p_usec_plus_hr_tbl
58 -- This parameter holds values for unit section Plus Hour table
59 -- IN OUT p_usec_cat_tbl
60 -- This parameter holds values for unit section Categories table
61 -- IN OUT p_usec_rule_tbl
62 -- This parameter holds values for unit section Rules table
63 -- IN OUT p_usec_cross_group_tbl
64 -- This parameter holds values for unit section Cross Listed Group table
65 -- IN OUT p_usec_meet_with_tbl
66 -- This parameter holds values for unit section MeetWith Class Group table
67 -- IN OUT p_usec_waitlist_tbl
68 -- This parameter holds values for unit section Waitlist table
69 -- IN OUT p_usec_res_seat_tbl
70 -- This parameter holds values for unit section Reserve Seating table
71 -- IN OUT p_usec_sp_fee_tbl
72 -- This parameter holds values for unit section special fees table
73 -- IN OUT p_usec_ret_tbl
74 -- This parameter holds values for unit section Retention table
75 -- IN OUT p_usec_ret_dtl_tbl
76 -- This parameter holds values for unit section Retention Details table
77 -- IN OUT p_usec_enr_dead_tbl
78 -- This parameter holds values for unit section Enrollment Deadline table
79 -- IN OUT p_usec_enr_dis_tbl
80 -- This parameter holds values for unit section Discontinuation Deadline table
81 -- IN OUT p_usec_teach_resp_tbl
82 -- This parameter holds values for unit section Teaching Responsibility (update only) table
83 -- IN OUT p_usec_ass_item_grp_tbl
84 -- This parameter holds values for unit section Assessment Item Group table
85 -- IN OUT p_usec_ass_item_tbl
86 -- This parameter holds values for unit section Assessment Item table
87 -- OUT p_usec_status
88 -- This parameter returns the import status of unit section table
89 -- OUT p_usec_gs_status
90 -- This parameter returns the import status of unit section grading schema table
91 -- OUT p_uso_status
92 -- This parameter returns the import status of unit section occurrence table
93 -- OUT p_uso_ins_status
94 -- This parameter returns the import status of unit section instructor table
95 -- OUT p_uso_facility_status
96 -- This parameter returns the import status of unit section facility table
97 -- OUT p_unit_ref_status
98 -- This parameter returns the import status of unit section/unit section occurrence reference code table
99 -- OUT p_usec_teach_resp_ovrd_status
100 -- This parameter returns the import status of unit section teaching responsibility override table
101 -- OUT p_usec_notes_status
102 -- This parameter returns the import status of unit section Note table
103 -- OUT p_usec_assmnt_status
104 -- This parameter returns the import status of unit section Assessment table
105 -- OUT p_usec_plus_hr_status
106 -- This parameter returns the import status of unit section plus hour table
107 -- OUT p_usec_cat_status
108 -- This parameter returns the import status of unit section categories table
109 -- OUT p_usec_rule_status
110 -- This parameter returns the import status of unit section rules table
111 -- OUT p_usec_cross_group_status
112 -- This parameter returns the import status of unit section cross listed group table
113 -- OUT p_usec_meet_with_status
114 -- This parameter returns the import status of unit section MeetWith listed group table
115 -- OUT p_usec_waitlist_status
116 -- This parameter returns the import status of unit section waitlist table
117 -- OUT p_usec_res_seat_status
118 -- This parameter returns the import status of unit section Reserve Seating table
119 -- OUT p_usec_sp_fee_status
120 -- This parameter returns the import status of unit section special fees table
121 -- OUT p_usec_ret_status
122 -- This parameter returns the import status of unit section retention table
123 -- OUT p_usec_ret_dtl_status
124 -- This parameter returns the import status of unit section retention details table
125 -- OUT p_usec_enr_dead_status
126 -- This parameter returns the import status of unit section deadline table
127 -- OUT p_usec_enr_dis_status
128 -- This parameter returns the import status of unit section discontinuation table
129 -- OUT p_usec_teach_resp_status
130 -- This parameter returns the import status of unit section teaching responsibility table
131 -- OUT p_usec_ass_item_grp_status
132 -- This parameter returns the import status of unit section assessment items group table
133 -- OUT p_usec_ass_item_status
134 -- This parameter returns the import status of unit section assessment items table
135
136
137 -- Version: Current Version 1.0
138 -- Previous Version
139 -- Initial Version 1.0
140 -- End of Comments
141
142
143 /*********************** Unit Version Record ************************/
144
145 TYPE unit_ver_rec_type IS RECORD (
146 unit_cd igs_ps_unit_ver_all.unit_cd%type,
147 version_number igs_ps_unit_ver_all.version_number%type,
148 start_dt igs_ps_unit_ver_all.start_dt%type,
149 review_dt igs_ps_unit_ver_all.review_dt%type,
150 expiry_dt igs_ps_unit_ver_all.expiry_dt%type,
151 end_dt igs_ps_unit_ver_all.end_dt%type,
152 unit_status igs_ps_unit_ver_all.unit_status%type,
153 title igs_ps_unit_ver_all.title%type,
154 short_title igs_ps_unit_ver_all.short_title%type,
155 title_override_ind igs_ps_unit_ver_all.title_override_ind%type,
156 abbreviation igs_ps_unit_ver_all.abbreviation%type,
157 unit_level igs_ps_unit_ver_all.unit_level%type,
158 credit_point_descriptor igs_ps_unit_ver_all.credit_point_descriptor%type,
159 enrolled_credit_points igs_ps_unit_ver_all.enrolled_credit_points%type,
160 points_override_ind igs_ps_unit_ver_all. points_override_ind%type,
161 supp_exam_permitted_ind igs_ps_unit_ver_all.supp_exam_permitted_ind%type,
162 coord_person_number igs_pe_person_base_v.person_number%type,
163 owner_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%type,
164 award_course_only_ind igs_ps_unit_ver_all.award_course_only_ind%type,
165 research_unit_ind igs_ps_unit_ver_all.research_unit_ind%type,
166 industrial_ind igs_ps_unit_ver_all.industrial_ind%type,
167 practical_ind igs_ps_unit_ver_all.practical_ind%type,
168 repeatable_ind igs_ps_unit_ver_all.repeatable_ind%type,
169 assessable_ind igs_ps_unit_ver_all.assessable_ind%type,
170 achievable_credit_points igs_ps_unit_ver_all.achievable_credit_points%type,
171 points_increment igs_ps_unit_ver_all.points_increment%type,
172 points_min igs_ps_unit_ver_all.points_min%type,
173 points_max igs_ps_unit_ver_all.points_max%type,
174 unit_int_course_level_cd igs_ps_unit_ver_all.unit_int_course_level_cd%type,
175 subtitle_modifiable_flag igs_ps_unit_ver_all.subtitle_modifiable_flag%type,
176 approval_date igs_ps_unit_ver_all.approval_date%type,
177 lecture_credit_points igs_ps_unit_ver_all.lecture_credit_points%type,
178 lab_credit_points igs_ps_unit_ver_all.lab_credit_points%type,
179 other_credit_points igs_ps_unit_ver_all.other_credit_points%type,
180 clock_hours igs_ps_unit_ver_all.clock_hours%type,
181 work_load_cp_lecture igs_ps_unit_ver_all.work_load_cp_lecture%type,
182 work_load_cp_lab igs_ps_unit_ver_all.work_load_cp_lab%type,
183 continuing_education_units igs_ps_unit_ver_all.continuing_education_units%type,
184 enrollment_expected igs_ps_unit_ver_all.enrollment_expected%type,
185 enrollment_minimum igs_ps_unit_ver_all.enrollment_minimum%type,
186 enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%type,
187 advance_maximum igs_ps_unit_ver_all.advance_maximum%type,
188 state_financial_aid igs_ps_unit_ver_all.state_financial_aid%type,
189 federal_financial_aid igs_ps_unit_ver_all.federal_financial_aid%type,
190 institutional_financial_aid igs_ps_unit_ver_all.institutional_financial_aid%type,
191 same_teaching_period igs_ps_unit_ver_all.same_teaching_period%type,
192 max_repeats_for_credit igs_ps_unit_ver_all.max_repeats_for_credit%type,
193 max_repeats_for_funding igs_ps_unit_ver_all.max_repeats_for_funding%type,
194 max_repeat_credit_points igs_ps_unit_ver_all.max_repeat_credit_points%type,
195 same_teach_period_repeats igs_ps_unit_ver_all.same_teach_period_repeats%type,
196 same_teach_period_repeats_cp igs_ps_unit_ver_all.same_teach_period_repeats_cp%type,
197 attribute_category igs_ps_unit_ver_all.attribute_category%type,
198 attribute1 igs_ps_unit_ver_all.attribute1%type,
199 attribute2 igs_ps_unit_ver_all.attribute2%type,
200 attribute3 igs_ps_unit_ver_all.attribute3%type,
201 attribute4 igs_ps_unit_ver_all.attribute4%type,
202 attribute5 igs_ps_unit_ver_all.attribute5%type,
203 attribute6 igs_ps_unit_ver_all.attribute6%type,
204 attribute7 igs_ps_unit_ver_all.attribute7%type,
205 attribute8 igs_ps_unit_ver_all.attribute8%type,
206 attribute9 igs_ps_unit_ver_all.attribute9%type,
207 attribute10 igs_ps_unit_ver_all.attribute10%type,
208 attribute11 igs_ps_unit_ver_all.attribute11%type,
209 attribute12 igs_ps_unit_ver_all.attribute12%type,
210 attribute13 igs_ps_unit_ver_all.attribute13%type,
211 attribute14 igs_ps_unit_ver_all.attribute14%type,
212 attribute15 igs_ps_unit_ver_all.attribute15%type,
213 attribute16 igs_ps_unit_ver_all.attribute16%type,
214 attribute17 igs_ps_unit_ver_all.attribute17%type,
215 attribute18 igs_ps_unit_ver_all.attribute18%type,
216 attribute19 igs_ps_unit_ver_all.attribute19%type,
217 attribute20 igs_ps_unit_ver_all.attribute20%type,
218 ivr_enrol_ind igs_ps_unit_ver_all.ivr_enrol_ind%type,
219 ss_enrol_ind igs_ps_unit_ver_all.ss_enrol_ind%type,
220 work_load_other igs_ps_unit_ver_all.work_load_other%type,
221 contact_hrs_lecture igs_ps_unit_ver_all.contact_hrs_lecture%type,
222 contact_hrs_lab igs_ps_unit_ver_all.contact_hrs_lab%type,
223 contact_hrs_other igs_ps_unit_ver_all.contact_hrs_other%type,
224 non_schd_required_hrs igs_ps_unit_ver_all.non_schd_required_hrs%type,
225 exclude_from_max_cp_limit igs_ps_unit_ver_all.exclude_from_max_cp_limit%type,
226 record_exclusion_flag igs_ps_unit_ver_all.record_exclusion_flag%type,
227 ss_display_ind igs_ps_unit_ver_all.ss_display_ind%type,
228 enrol_load_alt_cd igs_ca_inst_all.alternate_code%type,
229 offer_load_alt_cd igs_ca_inst_all.alternate_code%type,
230 override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%type,
231 repeat_code igs_ps_rpt_fmly_all.repeat_code%type,
232 level_code igs_ps_unit_type_lvl.level_code%type,
233 special_permission_ind igs_ps_unit_ver_all.special_permission_ind%type,
234 rev_account_cd igs_ps_unit_ver_all.rev_account_cd%type,
235 claimable_hours igs_ps_unit_ver_all.claimable_hours%type,
236 anon_unit_grading_ind igs_ps_unit_ver_all.anon_unit_grading_ind%type,
240 subtitle_closed_ind igs_ps_unit_subtitle.closed_ind%type,
237 anon_assess_grading_ind igs_ps_unit_ver_all.anon_assess_grading_ind%type,
238 subtitle igs_ps_unit_subtitle.subtitle%type,
239 subtitle_approved_ind igs_ps_unit_subtitle.approved_ind%type,
241 curriculum_id igs_ps_unt_crclm_all.curriculum_id%type,
242 curriculum_description igs_ps_unt_crclm_all.description%type,
243 curriculum_closed_ind igs_ps_unt_crclm_all.closed_ind%type,
244 auditable_ind igs_ps_unit_ver_all.auditable_ind%type,
245 audit_permission_ind igs_ps_unit_ver_all.audit_permission_ind%type,
246 max_auditors_allowed igs_ps_unit_ver_all.max_auditors_allowed%type,
247 billing_credit_points igs_ps_unit_ver_all.billing_credit_points%type,
248 ovrd_wkld_val_flag igs_ps_unit_ver_all.ovrd_wkld_val_flag%type,
249 workload_val_code igs_ps_unit_ver_all.workload_val_code%type,
250 billing_hrs igs_ps_unit_ver_all.billing_hrs%type,
251 interface_id NUMBER(15),
252 msg_from NUMBER(6),
253 msg_to NUMBER(6),
254 status VARCHAR2(1)
255 );
256
257
258
259 /*********************** Teaching Responsibility ************************/
260
261 TYPE unit_tr_rec_type IS RECORD (
262 unit_cd igs_ps_tch_resp.unit_cd%type,
263 version_number igs_ps_tch_resp.version_number%type,
264 org_unit_cd igs_ps_tch_resp.org_unit_cd%type,
265 percentage igs_ps_tch_resp.percentage%type,
266 interface_id NUMBER(15),
267 msg_from NUMBER(6),
268 msg_to NUMBER(6),
269 status VARCHAR2(1)
270 );
271
272 TYPE unit_tr_tbl_type IS TABLE OF unit_tr_rec_type INDEX BY BINARY_INTEGER;
273
274 /*********************** Unit Discplines ************************/
275
276 TYPE unit_dscp_rec_type IS RECORD (
277 unit_cd igs_ps_unit_dscp.unit_cd%type,
278 version_number igs_ps_unit_dscp.version_number%type,
279 discipline_group_cd igs_ps_unit_dscp.discipline_group_cd%type,
280 percentage igs_ps_unit_dscp.percentage%type,
281 interface_id NUMBER(15),
282 msg_from NUMBER(6),
283 msg_to NUMBER(6),
284 status VARCHAR2(1)
285 );
286
287 TYPE unit_dscp_tbl_type IS TABLE OF unit_dscp_rec_type INDEX BY BINARY_INTEGER;
288
289 /*********************** Unit Grading Schema ************************/
290
291 TYPE unit_gs_rec_type IS RECORD (
292 unit_cd igs_ps_unit_grd_schm.unit_code%type,
293 version_number igs_ps_unit_grd_schm.unit_version_number%type,
294 grading_schema_code igs_ps_unit_grd_schm.grading_schema_code%type,
295 grd_schm_version_number igs_ps_unit_grd_schm.grd_schm_version_number%type,
296 default_flag igs_ps_unit_grd_schm.default_flag%type,
297 interface_id NUMBER(15),
298 msg_from NUMBER(6),
299 msg_to NUMBER(6),
300 status VARCHAR2(1)
301 );
302
303 TYPE unit_gs_tbl_type IS TABLE OF unit_gs_rec_type INDEX BY BINARY_INTEGER;
304
305 /*********************** Unit Sections ************************/
306
307 TYPE usec_rec_type IS RECORD (
308 unit_cd igs_ps_unit_ofr_opt_all.unit_cd%type,
309 version_number igs_ps_unit_ofr_opt_all.version_number%type,
310 teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
311 location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
312 unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
313 ivrs_available_ind igs_ps_unit_ofr_opt_all.ivrs_available_ind%type,
314 call_number igs_ps_unit_ofr_opt_all.call_number%type,
315 unit_section_status igs_ps_unit_ofr_opt_all.unit_section_status%type,
316 unit_section_start_date igs_ps_unit_ofr_opt_all.unit_section_start_date%type,
317 unit_section_end_date igs_ps_unit_ofr_opt_all.unit_section_end_date%type,
318 offered_ind igs_ps_unit_ofr_opt_all.offered_ind%type,
319 state_financial_aid igs_ps_unit_ofr_opt_all.state_financial_aid%type,
320 grading_schema_prcdnce_ind igs_ps_unit_ofr_opt_all.grading_schema_prcdnce_ind%type,
321 federal_financial_aid igs_ps_unit_ofr_opt_all.federal_financial_aid%type,
322 unit_quota igs_ps_unit_ofr_opt_all.unit_quota%type,
323 unit_quota_reserved_places igs_ps_unit_ofr_opt_all.unit_quota_reserved_places%type,
324 institutional_financial_aid igs_ps_unit_ofr_opt_all.institutional_financial_aid%type,
325 grading_schema_cd igs_ps_unit_ofr_opt_all.grading_schema_cd%type,
329 owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type,
326 gs_version_number igs_ps_unit_ofr_opt_all.gs_version_number%type,
327 unit_contact_number igs_pe_person_base_v.person_number%type,
328 ss_enrol_ind igs_ps_unit_ofr_opt_all.ss_enrol_ind%type,
330 attendance_required_ind igs_ps_unit_ofr_opt_all.attendance_required_ind%type,
331 reserved_seating_allowed igs_ps_unit_ofr_opt_all.reserved_seating_allowed%type,
332 special_permission_ind igs_ps_unit_ofr_opt_all.special_permission_ind%type,
333 ss_display_ind igs_ps_unit_ofr_opt_all.ss_display_ind%type,
334 rev_account_cd igs_ps_unit_ofr_opt_all.rev_account_cd%type,
335 anon_unit_grading_ind igs_ps_unit_ofr_opt_all.anon_unit_grading_ind%type,
336 anon_assess_grading_ind igs_ps_unit_ofr_opt_all.anon_assess_grading_ind%type,
337 non_std_usec_ind igs_ps_unit_ofr_opt_all.non_std_usec_ind%type,
338 auditable_ind igs_ps_unit_ofr_opt_all.auditable_ind%type,
339 audit_permission_ind igs_ps_unit_ofr_opt_all.audit_permission_ind%type,
340 waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%type,
341 max_students_per_waitlist igs_ps_unit_ofr_pat_all.max_students_per_waitlist%type,
342 minimum_credit_points igs_ps_usec_cps.minimum_credit_points%type,
343 maximum_credit_points igs_ps_usec_cps.maximum_credit_points%type,
344 variable_increment igs_ps_usec_cps.variable_increment%type,
345 lecture_credit_points igs_ps_usec_cps.lecture_credit_points%type,
346 lab_credit_points igs_ps_usec_cps.lab_credit_points%type,
347 other_credit_points igs_ps_usec_cps.other_credit_points%type,
348 clock_hours igs_ps_usec_cps.clock_hours%type,
349 work_load_cp_lecture igs_ps_usec_cps.work_load_cp_lecture%type,
350 work_load_cp_lab igs_ps_usec_cps.work_load_cp_lab%type,
351 continuing_education_units igs_ps_usec_cps.continuing_education_units%type,
352 work_load_other igs_ps_usec_cps.work_load_other%type,
353 contact_hrs_lecture igs_ps_usec_cps.contact_hrs_lecture%type,
354 contact_hrs_lab igs_ps_usec_cps.contact_hrs_lab%type,
355 contact_hrs_other igs_ps_usec_cps.contact_hrs_other%type,
356 non_schd_required_hrs igs_ps_usec_cps.non_schd_required_hrs%type,
357 exclude_from_max_cp_limit igs_ps_usec_cps.exclude_from_max_cp_limit%type,
358 claimable_hours igs_ps_usec_cps.claimable_hours%type,
359 achievable_credit_points igs_ps_usec_cps.achievable_credit_points%TYPE,
360 enrolled_credit_points igs_ps_usec_cps.enrolled_credit_points%TYPE,
361 billing_credit_points igs_ps_usec_cps.billing_credit_points%TYPE,
362 reference_subtitle igs_ps_unit_subtitle.subtitle%type,
363 reference_short_title igs_ps_usec_ref.short_title%type,
364 reference_subtitle_mod_flag igs_ps_usec_ref.subtitle_modifiable_flag%type,
365 reference_class_sch_excl_flag igs_ps_usec_ref.class_schedule_exclusion_flag%type,
366 reference_rec_exclusion_flag igs_ps_usec_ref.record_exclusion_flag%type,
367 reference_title igs_ps_usec_ref.title%type,
368 reference_attribute_category igs_ps_usec_ref.attribute_category%type,
369 reference_attribute1 igs_ps_usec_ref.attribute1%type,
370 reference_attribute2 igs_ps_usec_ref.attribute2%type,
371 reference_attribute3 igs_ps_usec_ref.attribute3%type,
372 reference_attribute4 igs_ps_usec_ref.attribute4%type,
373 reference_attribute5 igs_ps_usec_ref.attribute5%type,
374 reference_attribute6 igs_ps_usec_ref.attribute6%type,
375 reference_attribute7 igs_ps_usec_ref.attribute7%type,
376 reference_attribute8 igs_ps_usec_ref.attribute8%type,
377 reference_attribute9 igs_ps_usec_ref.attribute9%type,
378 reference_attribute10 igs_ps_usec_ref.attribute10%type,
379 reference_attribute11 igs_ps_usec_ref.attribute11%type,
380 reference_attribute12 igs_ps_usec_ref.attribute12%type,
381 reference_attribute13 igs_ps_usec_ref.attribute13%type,
382 reference_attribute14 igs_ps_usec_ref.attribute14%type,
383 reference_attribute15 igs_ps_usec_ref.attribute15%type,
384 reference_attribute16 igs_ps_usec_ref.attribute16%type,
385 reference_attribute17 igs_ps_usec_ref.attribute17%type,
386 reference_attribute18 igs_ps_usec_ref.attribute18%type,
387 reference_attribute19 igs_ps_usec_ref.attribute19%type,
388 reference_attribute20 igs_ps_usec_ref.attribute20%type,
389 enrollment_expected igs_ps_usec_lim_wlst.enrollment_expected%TYPE,
390 enrollment_minimum igs_ps_usec_lim_wlst.enrollment_minimum%TYPE,
391 enrollment_maximum igs_ps_usec_lim_wlst.enrollment_maximum%TYPE,
392 advance_maximum igs_ps_usec_lim_wlst.advance_maximum%TYPE,
393 usec_waitlist_allowed igs_ps_usec_lim_wlst.waitlist_allowed%TYPE,
397 interface_id NUMBER(15),
394 usec_max_students_per_waitlist igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE,
395 override_enrollment_maximum igs_ps_usec_lim_wlst.override_enrollment_max%TYPE,
396 max_auditors_allowed igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE,
398 msg_from NUMBER(6),
399 msg_to NUMBER(6),
400 status VARCHAR2(1),
401 not_multiple_section_flag igs_ps_unit_ofr_opt_all.not_multiple_section_flag%TYPE,
402 sup_unit_cd igs_ps_unit_ver_all.unit_cd%type,
403 sup_version_number igs_ps_unit_ver_all.version_number%type,
404 sup_teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
405 sup_location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
406 sup_unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
407 default_enroll_flag igs_ps_unit_ofr_opt_all.default_enroll_flag%type,
408 billing_hrs igs_ps_usec_cps.billing_hrs%type
409 );
410
411 TYPE usec_tbl_type IS TABLE OF usec_rec_type INDEX BY BINARY_INTEGER;
412
413
414 /*********************** Unit Section Grading Schema ************************/
415
416 TYPE usec_gs_rec_type IS RECORD (
417 unit_cd igs_ps_unit_ver_all.unit_cd%type,
418 version_number igs_ps_unit_ver_all.version_number%type,
419 teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
420 location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
421 unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
422 grading_schema_code igs_ps_usec_grd_schm.grading_schema_code%type,
423 grd_schm_version_number igs_ps_usec_grd_schm.grd_schm_version_number%type,
424 default_flag igs_ps_usec_grd_schm.default_flag%type,
425 interface_id NUMBER(15),
426 msg_from NUMBER(6),
427 msg_to NUMBER(6),
428 status VARCHAR2(1)
429 );
430
431 TYPE usec_gs_tbl_type IS TABLE OF usec_gs_rec_type INDEX BY BINARY_INTEGER;
432
433
434 /*********************** Unit Section Occurrences ************************/
435
436
437 TYPE uso_rec_type IS RECORD (
438 unit_cd igs_ps_unit_ver_all.unit_cd%type,
439 version_number igs_ps_unit_ver_all.version_number%type,
440 teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
441 location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
442 unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
443 occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
444 to_be_announced igs_ps_usec_occurs_all.to_be_announced%type,
445 monday igs_ps_usec_occurs_all.monday%type,
446 tuesday igs_ps_usec_occurs_all.tuesday%type,
447 wednesday igs_ps_usec_occurs_all.wednesday%type,
448 thursday igs_ps_usec_occurs_all.thursday%type,
449 friday igs_ps_usec_occurs_all.friday%type,
450 saturday igs_ps_usec_occurs_all.saturday%type,
451 sunday igs_ps_usec_occurs_all.sunday%type,
452 start_date igs_ps_usec_occurs_all.start_date%type,
453 end_date igs_ps_usec_occurs_all.end_date%type,
454 start_time igs_ps_usec_occurs_all.start_time%type,
455 end_time igs_ps_usec_occurs_all.end_time%type,
456 building_code igs_ad_building_all.building_cd%type,
457 room_code igs_ad_room_all.room_cd%type,
458 dedicated_building_code igs_ad_building_all.building_cd%type,
459 dedicated_room_code igs_ad_room_all.room_cd%type,
460 preferred_building_code igs_ad_building_all.building_cd%type,
461 preferred_room_code igs_ad_room_all.room_cd%type,
462 no_set_day_ind igs_ps_usec_occurs_all.no_set_day_ind%type,
463 preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%type,
464 attribute_category igs_ps_usec_occurs_all.attribute_category%type,
465 attribute1 igs_ps_usec_occurs_all.attribute1%type,
466 attribute2 igs_ps_usec_occurs_all.attribute2%type,
467 attribute3 igs_ps_usec_occurs_all.attribute3%type,
468 attribute4 igs_ps_usec_occurs_all.attribute4%type,
469 attribute5 igs_ps_usec_occurs_all.attribute5%type,
470 attribute6 igs_ps_usec_occurs_all.attribute6%type,
471 attribute7 igs_ps_usec_occurs_all.attribute7%type,
472 attribute8 igs_ps_usec_occurs_all.attribute8%type,
473 attribute9 igs_ps_usec_occurs_all.attribute9%type,
474 attribute10 igs_ps_usec_occurs_all.attribute10%type,
478 attribute14 igs_ps_usec_occurs_all.attribute14%type,
475 attribute11 igs_ps_usec_occurs_all.attribute11%type,
476 attribute12 igs_ps_usec_occurs_all.attribute12%type,
477 attribute13 igs_ps_usec_occurs_all.attribute13%type,
479 attribute15 igs_ps_usec_occurs_all.attribute15%type,
480 attribute16 igs_ps_usec_occurs_all.attribute16%type,
481 attribute17 igs_ps_usec_occurs_all.attribute17%type,
482 attribute18 igs_ps_usec_occurs_all.attribute18%type,
483 attribute19 igs_ps_usec_occurs_all.attribute19%type,
484 attribute20 igs_ps_usec_occurs_all.attribute20%type,
485 interface_id NUMBER(15),
486 msg_from NUMBER(6),
487 msg_to NUMBER(6),
488 status VARCHAR2(1)
489 );
490
491 TYPE uso_tbl_type IS TABLE OF uso_rec_type INDEX BY BINARY_INTEGER;
492
493 /*********************** Reference Codes ************************/
494
495 TYPE unit_ref_rec_type IS RECORD (
496 production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
497 unit_cd igs_ps_unit_ver_all.unit_cd%type,
498 version_number igs_ps_unit_ver_all.version_number%type,
499 data_type varchar2(10),
500 teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
501 location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
502 unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
503 occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
504 reference_cd_type igs_ps_unit_ref_cd.reference_cd_type%type,
505 reference_cd igs_ge_ref_cd.reference_cd%type,
506 description igs_ge_ref_cd.description%type,
507 gen_ref_flag igs_ps_lgcy_ur_int.GEN_REF_FLAG%TYPE,
508 interface_id NUMBER(15),
509 msg_from NUMBER(6),
510 msg_to NUMBER(6),
511 status VARCHAR2(1)
512 );
513
514 TYPE unit_ref_tbl_type IS TABLE OF unit_ref_rec_type INDEX BY BINARY_INTEGER;
515
516 /********************** Unit Section Occurrence Instructor ************/
517 TYPE uso_ins_rec_type IS RECORD (
518 instructor_person_number hz_parties.party_number%TYPE,
519 production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
520 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
521 version_number igs_ps_unit_ver_all.version_number%TYPE,
522 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
523 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
524 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
525 occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
526 confirmed_flag igs_ps_usec_tch_resp.confirmed_flag%TYPE,
527 wl_percentage_allocation igs_ps_usec_tch_resp.percentage_allocation%TYPE,
528 instructional_load_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE,
529 instructional_load_laboratory igs_ps_usec_tch_resp.instructional_load_lab%TYPE,
530 instructional_load_other igs_ps_usec_tch_resp.instructional_load%TYPE,
531 lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%TYPE,
532 system_uoo_id NUMBER,
533 system_uso_id NUMBER,
534 system_instructor_id NUMBER,
535 interface_id NUMBER(15),
536 msg_from NUMBER(6),
537 msg_to NUMBER(6),
538 status VARCHAR2(1)
539 );
540
541 TYPE uso_ins_tbl_type IS TABLE OF uso_ins_rec_type INDEX BY BINARY_INTEGER;
542
543 /********************** Unit Section Occurrence facilities ************/
544 TYPE usec_occurs_facility_rec_type IS RECORD (
545 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
546 version_number igs_ps_unit_ver_all.version_number%TYPE,
547 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
548 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
549 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
550 production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
551 occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE,
552 facility_code igs_ps_uso_facility.facility_code%TYPE,
553 msg_from NUMBER(6),
554 msg_to NUMBER(6),
555 status VARCHAR2(1)
556 );
557
558 TYPE usec_occurs_facility_tbl_type IS TABLE OF usec_occurs_facility_rec_type INDEX BY BINARY_INTEGER;
559
560 /********************** Unit Section Teaching Responsibility Overrides ************/
561 TYPE usec_teach_resp_ovrd_rec_type IS RECORD (
562 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
566 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
563 version_number igs_ps_unit_ver_all.version_number%TYPE,
564 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
565 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
567 org_unit_cd igs_ps_tch_resp_ovrd_all.org_unit_cd%TYPE,
568 ou_start_dt igs_ps_tch_resp_ovrd_all.ou_start_dt%TYPE,
569 percentage igs_ps_tch_resp_ovrd_all.percentage%TYPE,
570 msg_from NUMBER(6),
571 msg_to NUMBER(6),
572 status VARCHAR2(1)
573 );
574
575 TYPE usec_teach_resp_ovrd_tbl_type IS TABLE OF usec_teach_resp_ovrd_rec_type INDEX BY BINARY_INTEGER;
576
577 /********************** Unit Section Notes ************/
578 TYPE usec_notes_rec_type IS RECORD (
579 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
580 version_number igs_ps_unit_ver_all.version_number%TYPE,
581 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
582 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
583 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
584 reference_number igs_ps_unt_ofr_opt_n.reference_number%TYPE,
585 crs_note_type igs_ps_unt_ofr_opt_n.crs_note_type%TYPE,
586 note_text igs_ge_note.note_text%TYPE,
587 msg_from NUMBER(6),
588 msg_to NUMBER(6),
589 status VARCHAR2(1)
590 );
591
592 TYPE usec_notes_tbl_type IS TABLE OF usec_notes_rec_type INDEX BY BINARY_INTEGER;
593
594 /********************** Unit Section Assessment ************/
595 TYPE usec_assmnt_rec_type IS RECORD (
596 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
597 version_number igs_ps_unit_ver_all.version_number%TYPE,
598 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
599 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
600 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
601 final_exam_date igs_ps_usec_as.final_exam_date%TYPE,
602 exam_start_time VARCHAR2(5),--igs_ps_usec_as.exam_start_time%TYPE,
603 exam_end_time VARCHAR2(5),--igs_ps_usec_as.exam_end_time%TYPE,
604 exam_location_cd igs_ps_usec_as.location_cd%TYPE,
605 building_code igs_ad_building_all.building_cd%TYPE,
606 room_code igs_ad_room_all.room_cd%TYPE,
607 msg_from NUMBER(6),
608 msg_to NUMBER(6),
609 status VARCHAR2(1)
610 );
611
612 TYPE usec_assmnt_tbl_type IS TABLE OF usec_assmnt_rec_type INDEX BY BINARY_INTEGER;
613
614 /********************** Unit Section Plus Hours ************/
615 TYPE usec_plus_hr_rec_type IS RECORD (
616 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
617 version_number igs_ps_unit_ver_all.version_number%TYPE,
618 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
619 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
620 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
621 activity_type_code igs_ps_usec_act_type.activity_type_code%TYPE,
622 activity_location_cd igs_ad_location.location_cd%TYPE,
623 building_cd igs_ad_building.building_cd%TYPE,
624 room_cd igs_ad_room.room_cd%TYPE,
625 number_of_students igs_ps_us_unsched_cl.number_of_students%TYPE,
626 hours_per_student igs_ps_us_unsched_cl.hours_per_student%TYPE,
627 hours_per_faculty igs_ps_us_unsched_cl.hours_per_faculty%TYPE,
628 instructor_number hz_parties.party_number%TYPE,
629 msg_from NUMBER(6),
630 msg_to NUMBER(6),
631 status VARCHAR2(1)
632 );
633
634 TYPE usec_plus_hr_tbl_type IS TABLE OF usec_plus_hr_rec_type INDEX BY BINARY_INTEGER;
635
636 /********************** Unit Section categories ************/
637 TYPE usec_cat_rec_type IS RECORD (
638 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
639 version_number igs_ps_unit_ver_all.version_number%TYPE,
640 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
641 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
642 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
643 unit_cat igs_ps_usec_category.unit_cat%TYPE,
644 msg_from NUMBER(6),
645 msg_to NUMBER(6),
646 status VARCHAR2(1)
647 );
648
649 TYPE usec_cat_tbl_type IS TABLE OF usec_cat_rec_type INDEX BY BINARY_INTEGER;
650
651 /********************** Unit Section Rules ************/
652 TYPE usec_rule_rec_type IS RECORD (
653 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
654 version_number igs_ps_unit_ver_all.version_number%TYPE,
655 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
656 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
657 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
658 s_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE,
659 rule_text VARCHAR2(4000),
660 msg_from NUMBER(6),
661 msg_to NUMBER(6),
662 status VARCHAR2(1)
663 );
664
668 TYPE usec_cross_group_rec_type IS RECORD (
665 TYPE usec_rule_tbl_type IS TABLE OF usec_rule_rec_type INDEX BY BINARY_INTEGER;
666
667 /********************** Unit Section Cross Listed Groups ************/
669 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
670 version_number igs_ps_unit_ver_all.version_number%TYPE,
671 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
672 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
673 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
674 usec_x_listed_group_name igs_ps_usec_x_grp.usec_x_listed_group_name%TYPE,
675 location_inheritance igs_ps_usec_x_grp.location_inheritance%TYPE,
676 max_enr_group NUMBER,--igs_ps_usec_x_grp.max_enr_group%TYPE,
677 max_ovr_group NUMBER,--igs_ps_usec_x_grp.max_ovr_group%TYPE,
678 parent igs_ps_usec_x_grpmem.parent%TYPE,
679 msg_from NUMBER(6),
680 msg_to NUMBER(6),
681 status VARCHAR2(1)
682 );
683
684 TYPE usec_cross_group_tbl_type IS TABLE OF usec_cross_group_rec_type INDEX BY BINARY_INTEGER;
685
686 /********************** Unit Section Meet With Groups ************/
687 TYPE usec_meet_with_rec_type IS RECORD (
688 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
689 version_number igs_ps_unit_ver_all.version_number%TYPE,
690 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
691 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
692 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
693 class_meet_group_name igs_ps_uso_cm_grp.class_meet_group_name%TYPE,
694 max_enr_group NUMBER,--igs_ps_uso_cm_grp.max_enr_group%TYPE,
695 max_ovr_group NUMBER,--igs_ps_uso_cm_grp.max_ovr_group%TYPE,
696 host igs_ps_uso_clas_meet.host%TYPE,
697 msg_from NUMBER(6),
698 msg_to NUMBER(6),
699 status VARCHAR2(1)
700 );
701
702 TYPE usec_meet_with_tbl_type IS TABLE OF usec_meet_with_rec_type INDEX BY BINARY_INTEGER;
703
704 /********************** Unit Section Waitlist Priorities and Preferences ************/
705 TYPE usec_waitlist_rec_type IS RECORD (
706 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
707 version_number igs_ps_unit_ver_all.version_number%TYPE,
708 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
709 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
710 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
711 priority_number igs_ps_usec_wlst_pri.priority_number%TYPE,
712 priority_value igs_ps_usec_wlst_pri.priority_value%TYPE,
713 preference_order igs_ps_usec_wlst_prf.preference_order%TYPE,
714 preference_code igs_ps_usec_wlst_prf.preference_code%TYPE,
715 preference_version igs_ps_usec_wlst_prf.preference_version%TYPE,
716 msg_from NUMBER(6),
717 msg_to NUMBER(6),
718 status VARCHAR2(1)
719 );
720
721 TYPE usec_waitlist_tbl_type IS TABLE OF usec_waitlist_rec_type INDEX BY BINARY_INTEGER;
722
723 /********************** Unit Section Reserve Seating Priorities and Preferences ************/
724 TYPE usec_res_seat_rec_type IS RECORD (
725 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
726 version_number igs_ps_unit_ver_all.version_number%TYPE,
727 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
728 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
729 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
730 priority_order igs_ps_rsv_usec_pri.priority_order%TYPE,
731 priority_value igs_ps_rsv_usec_pri.priority_value%TYPE,
732 preference_order igs_ps_rsv_usec_prf.preference_order%TYPE,
733 preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
734 preference_version igs_ps_rsv_usec_prf.preference_version%TYPE,
735 percentage_reserved igs_ps_rsv_usec_prf.percentage_reserved%TYPE,
736 msg_from NUMBER(6),
737 msg_to NUMBER(6),
738 status VARCHAR2(1)
739 );
740
741 TYPE usec_res_seat_tbl_type IS TABLE OF usec_res_seat_rec_type INDEX BY BINARY_INTEGER;
742
743 /********************** Unit Section Special Fees ************/
744 TYPE usec_sp_fee_rec_type IS RECORD (
745 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
746 version_number igs_ps_unit_ver_all.version_number%TYPE,
747 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
748 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
749 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
750 fee_type igs_ps_usec_sp_fees.fee_type%TYPE,
751 sp_fee_amt igs_ps_usec_sp_fees.sp_fee_amt%TYPE,
752 closed_flag igs_ps_usec_sp_fees.closed_flag%TYPE,
753 msg_from NUMBER(6),
754 msg_to NUMBER(6),
755 status VARCHAR2(1)
756 );
757
758 TYPE usec_sp_fee_tbl_type IS TABLE OF usec_sp_fee_rec_type INDEX BY BINARY_INTEGER;
759
760 /********************** Unit Section Retention ************/
761 TYPE usec_ret_rec_type IS RECORD (
762 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
766 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
763 version_number igs_ps_unit_ver_all.version_number%TYPE,
764 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
765 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
767 definition_level igs_ps_nsus_rtn.definition_code%TYPE,
768 fee_type igs_ps_nsus_rtn.fee_type%TYPE,
769 formula_method igs_ps_nsus_rtn.formula_method%TYPE,
770 round_method igs_ps_nsus_rtn.round_method%TYPE,
771 incl_wkend_duration_flag igs_ps_nsus_rtn.incl_wkend_duration_flag%TYPE,
772 msg_from NUMBER(6),
773 msg_to NUMBER(6),
774 status VARCHAR2(1)
775 );
776
777 TYPE usec_ret_tbl_type IS TABLE OF usec_ret_rec_type INDEX BY BINARY_INTEGER;
778
779 /********************** Unit Section Retention Details ************/
780 TYPE usec_ret_dtl_rec_type IS RECORD (
781 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
782 version_number igs_ps_unit_ver_all.version_number%TYPE,
783 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
784 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
785 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
786 definition_level igs_ps_nsus_rtn.definition_code%TYPE,
787 fee_type igs_ps_nsus_rtn.fee_type%TYPE,
788 offset_value igs_ps_nsus_rtn_dtl.offset_value%TYPE,
789 retention_percent igs_ps_nsus_rtn_dtl.retention_percent%TYPE,
790 retention_amount igs_ps_nsus_rtn_dtl.retention_amount%TYPE,
791 override_date_flag igs_ps_nsus_rtn_dtl.override_date_flag%TYPE,
792 offset_date igs_ps_nsus_rtn_dtl.offset_date%TYPE,
793 msg_from NUMBER(6),
794 msg_to NUMBER(6),
795 status VARCHAR2(1)
796 );
797
798 TYPE usec_ret_dtl_tbl_type IS TABLE OF usec_ret_dtl_rec_type INDEX BY BINARY_INTEGER;
799
800 /********************** Unit Section Enrollment Deadline ************/
801 TYPE usec_enr_dead_rec_type IS RECORD (
802 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
803 version_number igs_ps_unit_ver_all.version_number%TYPE,
804 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
805 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
806 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
807 function_name igs_en_nstd_usec_dl.function_name%TYPE,
808 enr_dl_date igs_en_nstd_usec_dl.enr_dl_date%TYPE,
809 msg_from NUMBER(6),
810 msg_to NUMBER(6),
811 status VARCHAR2(1)
812 );
813
814 TYPE usec_enr_dead_tbl_type IS TABLE OF usec_enr_dead_rec_type INDEX BY BINARY_INTEGER;
815
816 /********************** Unit Section Enrollment Discontinuation ************/
817 TYPE usec_enr_dis_rec_type IS RECORD (
818 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
819 version_number igs_ps_unit_ver_all.version_number%TYPE,
820 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
821 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
822 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
823 administrative_unit_status igs_en_usec_disc_dl.administrative_unit_status%TYPE,
824 usec_disc_dl_date igs_en_usec_disc_dl.usec_disc_dl_date%TYPE,
825 msg_from NUMBER(6),
826 msg_to NUMBER(6),
827 status VARCHAR2(1)
828 );
829
830 TYPE usec_enr_dis_tbl_type IS TABLE OF usec_enr_dis_rec_type INDEX BY BINARY_INTEGER;
831
832 /********************** Unit Section Teaching Responsibility ************/
833 TYPE usec_teach_resp_rec_type IS RECORD (
834 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
835 version_number igs_ps_unit_ver_all.version_number%TYPE,
836 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
837 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
838 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
839 instructor_person_number hz_parties.party_number%TYPE,
840 confirmed_flag igs_ps_usec_tch_resp.confirmed_flag%TYPE,
841 wl_percentage_allocation NUMBER, --igs_ps_usec_tch_resp.percentage_allocation%TYPE,
842 instructional_load_lecture NUMBER, --igs_ps_usec_tch_resp.instructional_load_lecture%TYPE,
843 instructional_load_laboratory NUMBER, --igs_ps_usec_tch_resp.instructional_load_lab%TYPE,
844 instructional_load_other NUMBER, --igs_ps_usec_tch_resp.instructional_load%TYPE,
845 lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%TYPE,
846 msg_from NUMBER(6),
847 msg_to NUMBER(6),
848 status VARCHAR2(1)
849 );
850
851 TYPE usec_teach_resp_tbl_type IS TABLE OF usec_teach_resp_rec_type INDEX BY BINARY_INTEGER;
852
853 /********************** Unit Section Assessment Item Group ************/
854 TYPE usec_ass_item_grp_rec_type IS RECORD (
855 unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
856 version_number igs_ps_unit_ver_all.version_number%TYPE,
857 teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
861 midterm_formula_code igs_as_us_ai_group.midterm_formula_code%TYPE,
858 location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
859 unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
860 group_name igs_as_us_ai_group.group_name%TYPE,
862 midterm_formula_qty NUMBER,--igs_as_us_ai_group.midterm_formula_qty%TYPE,
863 midterm_weight_qty NUMBER,--igs_as_us_ai_group.midterm_weight_qty%TYPE,
864 final_formula_code igs_as_us_ai_group.final_formula_code%TYPE,
865 final_formula_qty NUMBER,--igs_as_us_ai_group.final_formula_qty%TYPE,
866 final_weight_qty NUMBER,--igs_as_us_ai_group.final_weight_qty%TYPE,
867 assessment_id igs_ps_unitass_item.ass_id%TYPE,
868 sequence_number igs_ps_unitass_item.sequence_number%TYPE,
869 due_dt igs_ps_unitass_item.due_dt%TYPE,
870 reference igs_ps_unitass_item.reference%TYPE,
871 dflt_item_ind igs_ps_unitass_item.dflt_item_ind%TYPE,
872 logical_delete_dt igs_ps_unitass_item.logical_delete_dt%TYPE,
873 exam_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
874 description igs_ps_unitass_item.description%TYPE,
875 grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE,
876 gs_version_number igs_ps_unitass_item.gs_version_number%TYPE,
877 release_date igs_ps_unitass_item.release_date%TYPE,
878 midterm_mandatory_type_code igs_ps_unitass_item.midterm_mandatory_type_code%TYPE,
879 midterm_weight_qty_item NUMBER,--igs_ps_unitass_item.midterm_weight_qty%TYPE,
880 final_mandatory_type_code igs_ps_unitass_item.final_mandatory_type_code%TYPE,
881 final_weight_qty_item NUMBER,--igs_ps_unitass_item.final_weight_qty%TYPE,
882 msg_from NUMBER(6),
883 msg_to NUMBER(6),
884 status VARCHAR2(1)
885 );
886 TYPE usec_ass_item_grp_tbl_type IS TABLE OF usec_ass_item_grp_rec_type INDEX BY BINARY_INTEGER;
887
888
889 /*#
890 * A public API to import data from external system to OSS for unit section and its details. This API to be used to import scheduled data to OSS, also can be used for generic imports of unit section and details.
891 * This can also this can be used to import legacy related data.
892 * @param p_API_VERSION API Version Number
893 * @param p_INIT_MSG_LIST Initialize Message List
894 * @param p_COMMIT Commit Transaction
895 * @param p_VALIDATION_LEVEL Validation Level
896 * @param X_RETURN_STATUS Return Status
897 * @param X_MSG_COUNT Message Count
898 * @param X_MSG_DATA Message Data
899 * @param p_CALLING_CONTEXT Calling Context of the API
900 * @param p_USEC_STATUS Unit Section Return Status
901 * @param p_USEC_GS_STATUS Unit Section Grading Schema Return Status
902 * @param p_USO_STATUS Ocurrence Return Status
903 * @param p_USO_INS_STATUS Occurrence Instructor Return Status
904 * @param p_USO_FACILITY_STATUS Occurrence Facility Return Status
905 * @param p_UNIT_REF_STATUS Reference Return Status
906 * @param p_USEC_TEACH_RESP_OVRD_STATUS Unit Section Teaching Responsibility Override Return Status
907 * @param p_USEC_NOTES_STATUS Unit Section Notes Return Status
908 * @param p_USEC_ASSMNT_STATUS Unit Section Assessment Return Status
909 * @param p_USEC_PLUS_HR_STATUS Unit Section Plus Hours Return Status
910 * @param p_USEC_CAT_STATUS Unit Section Categories Return Status
911 * @param p_USEC_RULE_STATUS Unit Section Rules Return Status
912 * @param p_USEC_CROSS_GROUP_STATUS Unit Section Crosslisted Group Return Status
913 * @param p_USEC_MEET_WITH_STATUS Unit Section Meetwith Group Return Status
914 * @param p_USEC_WAITLIST_STATUS Unit Section Waitlist Return Status
915 * @param p_USEC_RES_SEAT_STATUS Unit Section Reserve Seating Return Status
916 * @param p_USEC_SP_FEE_STATUS Unit Section Special Fee Return Status
917 * @param p_USEC_RET_STATUS Unit Section Retention Return Status
918 * @param p_USEC_RET_DTL_STATUS Unit Section Retention Details Return Status
919 * @param p_USEC_ENR_DEAD_STATUS Unit Section Enrollment Deadline Return Status
920 * @param p_USEC_ENR_DIS_STATUS Unit Section Enrollment Discontinuation Return Status
921 * @param p_USEC_TEACH_RESP_STATUS Unit Section Teaching Responsibility Return Status
922 * @param p_USEC_ASS_ITEM_GRP_STATUS Unit Section Assessment Item Return Status
923 * @param p_UNIT_VER_REC Unit Version Records
924 * @param p_UNIT_TR_TBL Unit Teaching Responsibility Records
925 * @param p_UNIT_DSCP_TBL Unit Discipline Records
926 * @param p_UNIT_GS_TBL Unit Grading Schema Records
927 * @param p_USEC_TBL Unit Section Records
928 * @param p_USEC_GS_TBL Unit Section Grading Schema Records
929 * @param p_USO_TBL Unit Section Occurrence Records
930 * @param p_UNIT_REF_TBL Unit Reference Records
931 * @param p_USO_INS_TBL Unit Section Occurrence Instructor Records
932 * @param p_USEC_OCCURS_FACILITY_TBL Unit Section Occurrence Facility Records
933 * @param p_USEC_TEACH_RESP_OVRD_TBL Unit Section Teaching Responsibility Override Records
934 * @param p_USEC_NOTES_TBL Unit Section Notes Records
935 * @param p_USEC_ASSMNT_TBL Unit Section Assessment Records
936 * @param p_USEC_PLUS_HR_TBL Unit Section Plus Hours Records
937 * @param p_USEC_CAT_TBL Unit Section Categorizations Records
938 * @param p_USEC_RULE_TBL Unit Section Rule Records
939 * @param p_USEC_CROSS_GROUP_TBL Unit Section Cross-Listed Groups Records
940 * @param p_USEC_MEET_WITH_TBL Unit Section Meet-With Records
941 * @param p_USEC_WAITLIST_TBL Unit Section Waitlist Records
942 * @param p_USEC_RES_SEAT_TBL Unit Section Reserved Seating Records
943 * @param p_USEC_SP_FEE_TBL Unit Section Special Fee Records
944 * @param p_USEC_RET_TBL Unit Section Retention Records
945 * @param p_USEC_RET_DTL_TBL Unit Section Retention Detail Records
946 * @param p_USEC_ENR_DEAD_TBL Unit Section Enrollment Deadline Records
947 * @param p_USEC_ENR_DIS_TBL Unit Section Enrollment Disconinuation Records
948 * @param p_USEC_TEACH_RESP_TBL Unit Section Teaching Responsibility Records
949 * @param p_USEC_ASS_ITEM_GRP_TBL Unit Section Assessment Item Group Records
950 * @rep:scope public
951 * @rep:lifecycle active
952 * @rep:displayname Program Structure and Planning Import
953 */
954 PROCEDURE psp_import (
955 p_api_version IN NUMBER,
956 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
957 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
958 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
959 x_return_status OUT NOCOPY VARCHAR2,
960 x_msg_count OUT NOCOPY NUMBER,
961 x_msg_data OUT NOCOPY VARCHAR2,
962 p_calling_context IN VARCHAR2,
963 p_unit_ver_rec IN OUT NOCOPY unit_ver_rec_type,
964 p_unit_tr_tbl IN OUT NOCOPY unit_tr_tbl_type,
965 p_unit_dscp_tbl IN OUT NOCOPY unit_dscp_tbl_type,
966 p_unit_gs_tbl IN OUT NOCOPY unit_gs_tbl_type,
967 p_usec_tbl IN OUT NOCOPY usec_tbl_type,
968 p_usec_gs_tbl IN OUT NOCOPY usec_gs_tbl_type,
969 p_uso_tbl IN OUT NOCOPY uso_tbl_type,
970 p_unit_ref_tbl IN OUT NOCOPY unit_ref_tbl_type,
971 p_uso_ins_tbl IN OUT NOCOPY uso_ins_tbl_type,
972 p_usec_occurs_facility_tbl IN OUT NOCOPY usec_occurs_facility_tbl_type,
973 p_usec_teach_resp_ovrd_tbl IN OUT NOCOPY usec_teach_resp_ovrd_tbl_type,
974 p_usec_notes_tbl IN OUT NOCOPY usec_notes_tbl_type,
975 p_usec_assmnt_tbl IN OUT NOCOPY usec_assmnt_tbl_type,
976 p_usec_plus_hr_tbl IN OUT NOCOPY usec_plus_hr_tbl_type,
977 p_usec_cat_tbl IN OUT NOCOPY usec_cat_tbl_type,
978 p_usec_rule_tbl IN OUT NOCOPY usec_rule_tbl_type,
979 p_usec_cross_group_tbl IN OUT NOCOPY usec_cross_group_tbl_type,
980 p_usec_meet_with_tbl IN OUT NOCOPY usec_meet_with_tbl_type,
981 p_usec_waitlist_tbl IN OUT NOCOPY usec_waitlist_tbl_type,
982 p_usec_res_seat_tbl IN OUT NOCOPY usec_res_seat_tbl_type,
983 p_usec_sp_fee_tbl IN OUT NOCOPY usec_sp_fee_tbl_type,
984 p_usec_ret_tbl IN OUT NOCOPY usec_ret_tbl_type,
985 p_usec_ret_dtl_tbl IN OUT NOCOPY usec_ret_dtl_tbl_type,
986 p_usec_enr_dead_tbl IN OUT NOCOPY usec_enr_dead_tbl_type,
987 p_usec_enr_dis_tbl IN OUT NOCOPY usec_enr_dis_tbl_type,
988 p_usec_teach_resp_tbl IN OUT NOCOPY usec_teach_resp_tbl_type,
989 p_usec_ass_item_grp_tbl IN OUT NOCOPY usec_ass_item_grp_tbl_type,
990 p_usec_status OUT NOCOPY VARCHAR2,
991 p_usec_gs_status OUT NOCOPY VARCHAR2,
992 p_uso_status OUT NOCOPY VARCHAR2,
993 p_uso_ins_status OUT NOCOPY VARCHAR2,
994 p_uso_facility_status OUT NOCOPY VARCHAR2,
995 p_unit_ref_status OUT NOCOPY VARCHAR2,
996 p_usec_teach_resp_ovrd_status OUT NOCOPY VARCHAR2,
997 p_usec_notes_status OUT NOCOPY VARCHAR2,
998 p_usec_assmnt_status OUT NOCOPY VARCHAR2,
999 p_usec_plus_hr_status OUT NOCOPY VARCHAR2,
1000 p_usec_cat_status OUT NOCOPY VARCHAR2,
1001 p_usec_rule_status OUT NOCOPY VARCHAR2,
1002 p_usec_cross_group_status OUT NOCOPY VARCHAR2,
1003 p_usec_meet_with_status OUT NOCOPY VARCHAR2,
1004 p_usec_waitlist_status OUT NOCOPY VARCHAR2,
1005 p_usec_res_seat_status OUT NOCOPY VARCHAR2,
1006 p_usec_sp_fee_status OUT NOCOPY VARCHAR2,
1007 p_usec_ret_status OUT NOCOPY VARCHAR2,
1008 p_usec_ret_dtl_status OUT NOCOPY VARCHAR2,
1009 p_usec_enr_dead_status OUT NOCOPY VARCHAR2,
1010 p_usec_enr_dis_status OUT NOCOPY VARCHAR2,
1011 p_usec_teach_resp_status OUT NOCOPY VARCHAR2,
1012 p_usec_ass_item_grp_status OUT NOCOPY VARCHAR2 ) ;
1013
1014
1015 END igs_ps_generic_pub;