1 PACKAGE igs_ps_unit_lgcy_pub AS
2 /* $Header: IGSPS84S.pls 120.1 2005/06/29 04:17:08 appldev ship $ */
3
4
5 /***********************************************************************************************
6 Created By: Sanjeeb Rakshit
7 Date Created By: 20-Nov-2002
8 Purpose: A public API to import data from external system to OSS is declared along with
9 several PL-SQL table types to be used in the API.
10 Known limitations,enhancements,remarks:
11
12 Change History
13
14 Who When What
15 smvk 28-Jul-2004 Bug # 3793580. Allowing the user to import instructors for No Set Day USO.
16 Added column no_set_day_ind to uso_ins_rec_type record type.
17 sarakshi 04-May-2004 Enh#3568858,Added columns ovrd_wkld_val_flag, workload_val_code to the unit record type
18 sarakshi 10-Nov-2003 Enh#3116171, added logic related to the newly introduced field BILLING_CREDIT_POINTS in unit_ver_rec_type and usec_rec_type
19 sarakshi 02-sep-2003 Enh#3052452,Removed the reference of the column sup_unit_allowed_ind and sub_unit_allowed_ind.
20 Modified unit section record type(usec_rec_type) to add new columns sup_unit_cd,sup_version_number,
21 sup_teach_cal_alternate_code,sup_location_cd,sup_unit_class,default_enroll_flag
22 vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified unit section record type(usec_rec_type) to add
23 new column not_multiple_section_flag.
24 sarakshi 28-Jun-2003 Enh#2930935, added fields achievable and enrolled credit points to usec_rec_type
25 smvk 26-Jun-2003 Bug # 2999888. Added gen_ref_flag in the unit_ref_rec_type record type.
26 jbegum 02-june-2003 Bug # 2972950.
27 As mentioned in Legacy Enhancements TD:
28 Added an in out paramter p_uso_ins_tbl, defined record / table
29 structure uso_ins_rec_type / uso_ins_tbl_type and Added eight attribute to record structure usec_rec_type.
30 As mentioned in the PSP Scheduling Enhancements TD:
31 Added fields no_set_day_ind and preferred_region_code in the record structure of uso_rec_type.
32 Added fields uso_start_date,uso_end_date and no_set_day_ind in the record structure of unit_ref_rec_type
33
34 ***********************************************************************************************/
35
36
37 END igs_ps_unit_lgcy_pub;