1 PACKAGE igs_ss_en_wrappers AS
2 /* $Header: IGSSS09S.pls 120.12 2006/08/24 07:34:34 bdeviset noship $ */
3
4 PROCEDURE validate_prog_pro(
5 p_person_id igs_en_su_attempt.person_id%TYPE,
6 p_cal_type igs_ca_inst.cal_type%TYPE,
7 p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
8 p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
9 p_course_cd igs_en_su_attempt.course_cd%TYPE,
10 p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
11 p_message_name OUT NOCOPY VARCHAR2,
12 p_deny_warn OUT NOCOPY VARCHAR2,
13 p_return_status OUT NOCOPY VARCHAR2);
14
15 PROCEDURE enrp_ss_val_person_step(
16 p_person_id IN NUMBER,
17 p_person_type IN VARCHAR2,
18 p_load_cal_type IN VARCHAR2,
19 p_load_ci_sequence_number IN NUMBER,
20 p_program_cd IN VARCHAR2,
21 p_program_version IN NUMBER,
22 p_message_name OUT NOCOPY VARCHAR2,
23 p_deny_warn OUT NOCOPY VARCHAR2,
24 p_step_eval_result OUT NOCOPY VARCHAR2,
25 p_calling_obj IN VARCHAR2,
26 p_create_warning IN VARCHAR2,
27 p_ss_session_id IN NUMBER);
28
29 PROCEDURE validate_unit_steps(
30 p_person_id IN igs_en_su_attempt.person_id%TYPE,
31 p_cal_type IN igs_ca_inst.cal_type%TYPE,
32 p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
33 p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
34 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
35 p_return_status OUT NOCOPY VARCHAR2,
36 p_message_name OUT NOCOPY VARCHAR2,
37 p_deny_warn OUT NOCOPY VARCHAR2);
38
39 PROCEDURE get_person_type_by_rank(
40 p_person_id IN NUMBER,
41 p_person_type OUT NOCOPY VARCHAR2);
42
43 PROCEDURE call_fee_ass (
44 p_person_id IN NUMBER,
45 p_cal_type IN VARCHAR2,
46 p_sequence_number IN NUMBER,
47 p_course_cd IN VARCHAR2,
48 p_unit_cd IN VARCHAR2,
49 p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE);
50
51
52 PROCEDURE enroll_cart_unit(
53 p_person_id IN NUMBER,
54 p_uoo_id IN NUMBER,
55 p_unit_cd IN VARCHAR2,
56 p_version_number IN NUMBER,
57 p_course_cd IN VARCHAR2,
58 p_unit_attempt_status IN VARCHAR2,
59 p_enrolled_dt IN DATE DEFAULT SYSDATE);
60
61 PROCEDURE Validate_enroll_validate (
62 p_person_id IN igs_en_su_attempt.person_id%TYPE,
63 p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
64 p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
65 p_uoo_ids IN VARCHAR2,
66 p_program_cd IN igs_en_su_attempt.course_cd%TYPE,
67 p_message_name OUT NOCOPY VARCHAR2,
68 p_deny_warn OUT NOCOPY VARCHAR2,
69 p_return_status OUT NOCOPY VARCHAR2,
70 p_enr_method IN igs_en_cat_prc_dtl.enr_method_type%TYPE DEFAULT NULL,
71 p_enrolled_dt IN DATE DEFAULT SYSDATE);
72
73 PROCEDURE get_cart_details(
74 p_person_id IN NUMBER,
75 p_program_cd IN VARCHAR2,
76 p_load_cal_type IN VARCHAR2,
77 p_load_ci_seq_num IN NUMBER,
78 p_total_units_cart OUT NOCOPY NUMBER,
79 p_total_cp_cart OUT NOCOPY NUMBER);
80
81 PROCEDURE insert_into_enr_worksheet(
82 p_person_number IN VARCHAR2,
83 p_course_cd IN VARCHAR2,
84 p_uoo_id IN NUMBER,
85 p_waitlist_ind IN VARCHAR2,
86 p_session_id IN NUMBER,
87 p_return_status OUT NOCOPY VARCHAR2,
88 p_message OUT NOCOPY VARCHAR2,
89 p_cal_type IN VARCHAR2 DEFAULT NULL,
90 p_ci_sequence_number IN NUMBER DEFAULT NULL,
91 p_audit_requested IN VARCHAR2 DEFAULT 'N',
92 p_enr_method IN igs_en_cat_prc_dtl.enr_method_type%TYPE DEFAULT NULL,
93 p_override_cp IN NUMBER DEFAULT NULL, --rvivekan ,added as a part of Bulk unit upload 3-Aug-2003
94 p_subtitle IN VARCHAR2 DEFAULT NULL, --rvivekan ,added as a part of Bulk unit upload 3-Aug-2003
95 p_gradsch_cd IN VARCHAR2 DEFAULT NULL, --rvivekan ,added as a part of Bulk unit upload 3-Aug-2003
96 p_gs_version_num IN NUMBER DEFAULT NULL, --rvivekan ,added as a part of Bulk unit upload 3-Aug-2003
97 p_core_indicator_code IN VARCHAR2 DEFAULT NULL,
98 p_calling_obj IN VARCHAR2); --ptandon, added as part of Prevent Dropping Core Units build 1-Oct-2003
99
100 PROCEDURE drop_selected_units (
101 p_uoo_ids IN VARCHAR2,
102 p_person_id IN NUMBER,
103 p_person_type IN VARCHAR2,
104 p_load_cal_type IN VARCHAR2,
105 p_load_sequence_number IN NUMBER,
106 p_program_cd IN VARCHAR2,
107 p_program_version IN NUMBER DEFAULT NULL,
108 P_DCNT_REASON_CD IN VARCHAR2 DEFAULT NULL,
109 p_admin_unit_status IN VARCHAR2 DEFAULT NULL,
110 p_effective_date IN DATE DEFAULT SYSDATE,
111 p_failed_uoo_ids OUT NOCOPY VARCHAR2,
112 p_failed_unit_cds OUT NOCOPY VARCHAR2,
113 p_return_status OUT NOCOPY VARCHAR2,
114 p_message OUT NOCOPY VARCHAR2,
115 p_ovrrd_min_cp_chk IN VARCHAR2 DEFAULT 'N', --msrinivi , added new param 22-feb-2002
116 p_ovrrd_crq_chk IN VARCHAR2 DEFAULT 'N', --msrinivi , added new param 2-may-2002
117 p_ovrrd_prq_chk IN VARCHAR2 DEFAULT 'N' ,--msrinivi , added new param 2-may-2002
118 p_ovrrd_att_typ_chk IN VARCHAR2 DEFAULT 'N') ;
119
120 -- Added the following two parameters p_reason, p_source_of_drop
121 -- as part of Drop/ Transfer Workflow Notification DLD. Bug# 2599925.
122
123 PROCEDURE drop_all_workflow (
124 p_uoo_ids IN VARCHAR2,
125 p_person_id IN NUMBER,
126 p_load_cal_type IN VARCHAR2,
127 p_load_sequence_number IN NUMBER,
128 p_program_cd IN VARCHAR2,
129 p_return_status OUT NOCOPY VARCHAR2,
130 p_drop_date IN DATE DEFAULT NULL,
131 p_old_cp IN NUMBER DEFAULT NULL,
132 p_new_cp IN NUMBER DEFAULT NULL);
133
134 PROCEDURE transfer_workflow (
135 p_source_uoo_ids IN VARCHAR2,
136 p_dest_uoo_ids IN VARCHAR2,
137 p_person_id IN NUMBER,
138 p_load_cal_type IN VARCHAR2,
139 p_load_sequence_number IN NUMBER,
140 p_program_cd IN VARCHAR2,
141 p_unit_attempt_status IN VARCHAR2,
142 p_reason IN VARCHAR2,
143 p_return_status OUT NOCOPY VARCHAR2,
144 p_message OUT NOCOPY VARCHAR2);
145
146 /*
147 Procedure to check whether Grading Schema exists in the Unit Section Level /
148 Unit level. Added as part of Drop / Transfer Workflow Notification DLD.
149 pradhakr; 03-Oct-2002; Bug# 2599925.
150 */
151
152 FUNCTION enr_val_grad_usec(
153 p_uoo_ids IN VARCHAR2,
154 p_grading_schema_code IN VARCHAR2,
155 p_gs_version_number IN NUMBER
156 ) RETURN BOOLEAN;
157
158 PROCEDURE validate_upd_cp(
159 x_person_id IN NUMBER,
160 x_person_type IN VARCHAR2,
161 x_load_cal_type IN VARCHAR2,
162 x_load_sequence_number IN NUMBER,
163 x_uoo_id IN NUMBER,
164 x_program_cd IN VARCHAR2,
165 x_program_version IN NUMBER,
166 X_OVERRIDE_ENROLLED_CP IN NUMBER,
167 x_message OUT NOCOPY VARCHAR2,
168 x_return_status OUT NOCOPY VARCHAR2) ;
169
170 PROCEDURE blk_drop_units(
171 p_uoo_id IN NUMBER,
172 p_person_id IN NUMBER,
173 p_person_type IN VARCHAR2,
174 p_load_cal_type IN VARCHAR2,
175 p_load_sequence_number IN NUMBER,
176 p_acad_cal_type IN VARCHAR2,
177 p_acad_sequence_number IN NUMBER,
178 p_program_cd IN VARCHAR2,
179 p_program_version IN NUMBER,
180 p_dcnt_reason_cd IN VARCHAR2,
181 p_admin_unit_status IN VARCHAR2,
182 p_effective_date IN DATE DEFAULT SYSDATE,
183 p_enrolment_cat IN VARCHAR2,
184 p_comm_type IN VARCHAR2,
185 p_enr_meth_type IN VARCHAR2,
186 p_total_credit_points IN NUMBER,
187 p_force_att_type IN VARCHAR2,
188 p_val_ovrrd_chk IN VARCHAR2,
189 p_ovrrd_drop IN VARCHAR2,
190 p_return_status OUT NOCOPY BOOLEAN,
191 p_message OUT NOCOPY VARCHAR2,
192 p_sub_unit IN VARCHAR2 DEFAULT NULL);
193
194 --
195 -- Added as Part of EN213 Build
196 -- This Procedure is to switch the core unit sections selected.
197 --
198 PROCEDURE enrp_switch_core_section(
199 p_person_id IN NUMBER,
200 p_program_cd IN VARCHAR2,
201 p_source_uoo_id IN NUMBER,
202 p_dest_uoo_id IN NUMBER,
203 p_session_id IN NUMBER,
204 p_cal_type IN VARCHAR2,
205 p_ci_sequence_number IN NUMBER,
206 p_audit_requested IN VARCHAR2,
207 p_core_indicator_code IN VARCHAR2,
208 p_waitlist_ind IN VARCHAR2,
209 p_return_status OUT NOCOPY VARCHAR2,
210 p_message_name OUT NOCOPY VARCHAR2);
211
212 PROCEDURE drop_notif_variable(
213 p_reason IN VARCHAR2,
214 p_source_of_drop IN VARCHAR2);
215
216 PROCEDURE ENRP_CHK_DEL_SUB_UNITS(
217 p_person_id IN NUMBER,
218 p_course_cd IN VARCHAR2,
219 p_load_cal_type IN VARCHAR2,
220 p_load_ci_seq_num IN NUMBER,
221 p_selected_uoo_ids IN VARCHAR2,
222 p_ret_all_uoo_ids OUT NOCOPY VARCHAR2,
223 p_ret_sub_uoo_ids OUT NOCOPY VARCHAR2,
224 p_ret_nonsub_uoo_ids OUT NOCOPY VARCHAR2,
225 p_delete_flag IN VARCHAR2 DEFAULT 'N'
226 );
227
228 FUNCTION get_unit_int_status(
229 x_person_id IN NUMBER,
230 x_person_type IN VARCHAR2,
231 x_load_cal_type IN VARCHAR2,
232 x_load_sequence_number IN NUMBER,
233 x_program_cd IN VARCHAR2,
234 x_message OUT NOCOPY VARCHAR2,
235 x_return_status OUT NOCOPY VARCHAR2
236 )
237 RETURN VARCHAR2;
238
239 --procedure to update the terms SPA planning sheet status.
240 PROCEDURE update_spa_plan_sts( p_n_person_id IN NUMBER,
241 p_c_program_cd IN VARCHAR2,
242 p_c_cal_type IN VARCHAR2,
243 p_n_seq_num IN NUMBER,
244 p_c_plan_sts IN VARCHAR2);
245
246 PROCEDURE update_grading_schema(
247 p_person_id IN NUMBER,
248 p_uoo_id IN NUMBER,
249 p_course_cd IN VARCHAR2,
250 p_grading_schema IN VARCHAR2,
251 p_gs_version IN NUMBER,
252 p_message OUT NOCOPY VARCHAR2,
253 p_return_status OUT NOCOPY VARCHAR2
254 );
255
256 PROCEDURE update_credit_points(
257 p_person_id IN NUMBER,
258 p_person_type IN VARCHAR2,
259 p_load_cal_type IN VARCHAR2,
260 p_load_sequence_number IN NUMBER,
261 p_uoo_id IN NUMBER,
262 p_course_cd IN VARCHAR2,
263 p_course_version IN NUMBER,
264 p_override_enrolled_cp IN NUMBER,
265 p_message OUT NOCOPY VARCHAR2,
266 p_return_status OUT NOCOPY VARCHAR2
267 );
268
269 PROCEDURE update_audit(
270 p_person_id IN NUMBER,
271 p_load_cal_type IN VARCHAR2,
272 p_load_sequence_number IN NUMBER,
273 p_uoo_id IN NUMBER,
274 p_course_cd IN VARCHAR2,
275 p_no_assessment_ind IN VARCHAR2,
276 p_override_cp IN NUMBER,
277 p_message OUT NOCOPY VARCHAR2,
278 p_return_status OUT NOCOPY VARCHAR2
279 );
280
281 PROCEDURE remove_permission_unit(
282 p_request_id IN NUMBER,
283 p_load_cal IN VARCHAR2,
284 p_load_seq_num IN NUMBER,
285 p_course_cd IN VARCHAR2
286 );
287
288
289 PROCEDURE update_core_indicator(
290 p_person_id IN NUMBER,
291 p_uoo_id IN NUMBER,
292 p_program_cd IN VARCHAR2,
293 p_core_indicator IN VARCHAR2,
294 p_message OUT NOCOPY VARCHAR2);
295
296 PROCEDURE check_en_security( p_person_id IN NUMBER,
297 p_course_cd IN VARCHAR2,
298 p_uoo_id IN NUMBER,
299 p_table IN VARCHAR2,
300 p_mode IN VARCHAR2,
301 p_select_allowed OUT NOCOPY VARCHAR2,
302 p_update_allowed OUT NOCOPY VARCHAR2,
303 p_message OUT NOCOPY VARCHAR2);
304
305 PROCEDURE update_audit_flag(p_person_id IN NUMBER,
306 p_course_cd IN VARCHAR2,
307 p_uoo_id IN NUMBER,
308 p_upd_audit_flag IN VARCHAR2);
309
310 FUNCTION check_perm_exists(p_person_id IN NUMBER,
311 p_uoo_id IN NUMBER,
312 p_request_type IN VARCHAR2) return varchar2;
313 FUNCTION check_sua_exists(p_person_id IN NUMBER,
314 p_uoo_id IN NUMBER,
315 p_course_cd IN VARCHAR2) return varchar2;
316
317 PROCEDURE chk_cart_units(p_person_id IN NUMBER,
318 p_course_cd IN VARCHAR2,
319 p_load_cal_type IN VARCHAR2,
320 p_load_sequence_number IN NUMBER,
321 p_cart_exists OUT NOCOPY VARCHAR2
322 );
323
324 END igs_ss_en_wrappers;