1 PACKAGE igs_ps_unit_lgcy_pvt AS
2 /* $Header: IGSPS93S.pls 120.1 2005/09/08 15:21:54 appldev noship $ */
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
38 PROCEDURE create_unit(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,
47 p_unit_tr_tbl IN OUT NOCOPY igs_ps_generic_pub.unit_tr_tbl_type,
48 p_unit_dscp_tbl IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_tbl_type,
49 p_unit_gs_tbl IN OUT NOCOPY igs_ps_generic_pub.unit_gs_tbl_type,
50 p_usec_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_tbl_type,
51 p_usec_gs_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_gs_tbl_type,
52 p_uso_tbl IN OUT NOCOPY igs_ps_generic_pub.uso_tbl_type,
53 p_unit_ref_tbl IN OUT NOCOPY igs_ps_generic_pub.unit_ref_tbl_type,
54 p_uso_ins_tbl IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type
55 );
56
57
58 END igs_ps_unit_lgcy_pvt;