1 PACKAGE igs_ps_create_generic_pkg AS
2 /* $Header: IGSPS91S.pls 120.1 2005/09/08 15:08:05 appldev noship $ */
3
4 /***********************************************************************************************
5 Created By : Sanjeeb Rakshit, Somnath Mukherjee
6 Date Created By: 17-Jun-2005
7
8
9 Known limitations,enhancements,remarks:
10 Change History (in reverse chronological order)
11 Who When What
12 ********************************************************************************************** */
13
14 TYPE uoo_tbl_type IS TABLE OF igs_ps_unit_ofr_opt_all.uoo_id%TYPE INDEX BY BINARY_INTEGER;
15 l_tbl_uoo uoo_tbl_type;
16
17 TYPE class_meet_rec_type IS RECORD (
18 class_meet_group_name igs_ps_uso_cm_grp.class_meet_group_name%TYPE,
19 class_meet_group_id igs_ps_uso_cm_grp.class_meet_group_id%TYPE,
20 old_max_enr_group NUMBER
21 );
22
23 TYPE class_meet_rec_tbl_type IS TABLE OF class_meet_rec_type INDEX BY BINARY_INTEGER;
24 class_meet_rec class_meet_rec_type;
25 class_meet_tab class_meet_rec_tbl_type;
26
27 TYPE cross_group_rec_type IS RECORD (
28 usec_x_listed_group_name igs_ps_usec_x_grp.usec_x_listed_group_name%TYPE,
29 usec_x_listed_group_id igs_ps_usec_x_grp.usec_x_listed_group_id%TYPE,
30 old_max_enr_group NUMBER
31 );
32
33 TYPE cross_group_rec_tbl_type IS TABLE OF cross_group_rec_type INDEX BY BINARY_INTEGER;
34 cross_group_rec cross_group_rec_type;
35 cross_group_tab cross_group_rec_tbl_type;
36
37
38
39 --This procedure is a sub process to import records of Unit Section Reserve Seating.
40 PROCEDURE create_usec_res_seat(
41 p_usec_res_seat_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_tbl_type,
42 p_c_rec_status OUT NOCOPY VARCHAR2,
43 p_calling_context IN VARCHAR2
44 ) ;
45
46 --This procedure is a sub process to import records of Unit Section Occurence facility.
47 PROCEDURE create_uso_facility (
48 p_usec_occurs_facility_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_tbl_type,
49 p_c_rec_status OUT NOCOPY VARCHAR2,
50 p_calling_context IN VARCHAR2
51 ) ;
52
53 --This procedure is a sub process to import records of Unit Section category.
54 PROCEDURE create_usec_cat (
55 p_usec_cat_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_cat_tbl_type,
56 p_c_rec_status OUT NOCOPY VARCHAR2,
57 p_calling_context IN VARCHAR2
58 ) ;
59
60 --This procedure is a sub process to import records of Unit Section Teaching Responsibility Overrides.
61 PROCEDURE create_usec_teach_resp_ovrd (
62 p_usec_teach_resp_ovrd_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_tbl_type,
63 p_c_rec_status OUT NOCOPY VARCHAR2,
64 p_calling_context IN VARCHAR2
65 ) ;
66
67 --This procedure is a sub process to import records of Unit Section Unit Section Assesment Item .
68 PROCEDURE create_usec_ass_item_grp(
69 p_usec_ass_item_grp_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_tbl_type,
70 p_c_rec_status OUT NOCOPY VARCHAR2,
71 p_calling_context IN VARCHAR2
72 ) ;
73
74 --This procedure is a sub process to import records of Unit Section meet with Class group .
75 PROCEDURE create_usec_meet_with(
76 p_usec_meet_with_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_tbl_type,
77 p_c_rec_status OUT NOCOPY VARCHAR2,
78 p_calling_context IN VARCHAR2
79 ) ;
80
81 --This procedure is a sub process to import records of Cross-listed Unit Section Group .
82 PROCEDURE create_usec_cross_group(
83 p_usec_cross_group_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_tbl_type,
84 p_c_rec_status OUT NOCOPY VARCHAR2,
85 p_calling_context IN VARCHAR2
86 ) ;
87
88 --This procedure is a sub process to import Unit Section Waitlist.
89 PROCEDURE create_usec_waitlist(
90 p_usec_waitlist_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_tbl_type,
91 p_c_rec_status OUT NOCOPY VARCHAR2,
92 p_calling_context IN VARCHAR2
93 ) ;
94
95 --This procedure is a sub process to import Unit Section Notes.
96 PROCEDURE create_usec_notes(
97 p_usec_notes_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_notes_tbl_type,
98 p_c_rec_status OUT NOCOPY VARCHAR2,
99 p_calling_context IN VARCHAR2
100 ) ;
101
102 --This procedure is a sub process to insert Unit Section assesment.
103 PROCEDURE create_usec_assmnt(
104 p_usec_assmnt_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_tbl_type,
105 p_c_rec_status OUT NOCOPY VARCHAR2,
106 p_calling_context IN VARCHAR2
107 ) ;
108
109
110
111 PROCEDURE create_uso_ins_ovrd(
112 p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type,
113 p_c_rec_status OUT NOCOPY VARCHAR2,
114 p_calling_context IN VARCHAR2);
115
116 PROCEDURE create_usec_teach_resp(
117 p_usec_teach_resp_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_tbl_type,
118 p_c_rec_status OUT NOCOPY VARCHAR2,
119 p_calling_context IN VARCHAR2);
120
121 PROCEDURE create_usec_sp_fee(
122 p_usec_sp_fee_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_tbl_type,
123 p_c_rec_status OUT NOCOPY VARCHAR2,
124 p_calling_context IN VARCHAR2);
125
126 PROCEDURE create_usec_plus_hr(
127 p_usec_plus_hr_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_tbl_type,
128 p_c_rec_status OUT NOCOPY VARCHAR2,
129 p_calling_context IN VARCHAR2);
130
131 PROCEDURE create_usec_rule(
132 p_usec_rule_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_rule_tbl_type,
133 p_c_rec_status OUT NOCOPY VARCHAR2,
134 p_calling_context IN VARCHAR2);
135
136 PROCEDURE create_usec_enr_dead(
137 p_usec_enr_dead_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_tbl_type,
138 p_c_rec_status OUT NOCOPY VARCHAR2,
139 p_calling_context IN VARCHAR2);
140
141 PROCEDURE create_usec_enr_dis(
142 p_usec_enr_dis_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_tbl_type,
143 p_c_rec_status OUT NOCOPY VARCHAR2,
144 p_calling_context IN VARCHAR2);
145
146 PROCEDURE create_usec_ret(
147 p_usec_ret_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ret_tbl_type,
148 p_c_rec_status OUT NOCOPY VARCHAR2,
149 p_calling_context IN VARCHAR2);
150
151 PROCEDURE create_usec_ret_dtl(
152 p_usec_ret_dtl_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_tbl_type,
153 p_c_rec_status OUT NOCOPY VARCHAR2,
154 p_calling_context IN VARCHAR2);
155
156
157 END igs_ps_create_generic_pkg;