[Home] [Help]
137: AND su.uoo_id = cp_uoo_id;
138:
139: --Cursor to select the org unit cd whene it is not identified in the c_org_unit_cd cursor.
140:
141: CURSOR c_org_unit_sec_cd(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
142: SELECT owner_org_unit_cd
143: FROM igs_ps_unit_ofr_opt uoo
144: WHERE uoo_id = cp_uoo_id;
145:
139: --Cursor to select the org unit cd whene it is not identified in the c_org_unit_cd cursor.
140:
141: CURSOR c_org_unit_sec_cd(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
142: SELECT owner_org_unit_cd
143: FROM igs_ps_unit_ofr_opt uoo
144: WHERE uoo_id = cp_uoo_id;
145:
146: --cursor to select the Unit Program Type Level, Unit Class and Unit Mode attributes when creating
147: --a Special Fee charge.
144: WHERE uoo_id = cp_uoo_id;
145:
146: --cursor to select the Unit Program Type Level, Unit Class and Unit Mode attributes when creating
147: --a Special Fee charge.
148: CURSOR c_unit_level_detail(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
149: SELECT uv.unit_type_id,
150: asuc.unit_class,
151: asuc.unit_mode,
152: uv.unit_level
150: asuc.unit_class,
151: asuc.unit_mode,
152: uv.unit_level
153: FROM igs_ps_unit_ver uv,
154: igs_ps_unit_ofr_opt_all uoo,
155: igs_as_unit_class asuc
156: WHERE uv.unit_cd = uoo.unit_cd
157: AND uv.version_number = uoo.version_number
158: AND asuc.unit_class = uoo.unit_class
188: FETCH c_org_unit_cd INTO l_rec_cur_org_unit_cd;
189: CLOSE c_org_unit_cd;
190:
191: --if org unit code is not derived from the student unit attempts then derive it from the
192: --Unit Section table of IGS_PS_UNIT_OFR_OPT.
193: IF l_rec_cur_org_unit_cd.org_unit_cd IS NULL THEN
194: OPEN c_org_unit_sec_cd(p_n_uoo_id);
195: FETCH c_org_unit_sec_cd INTO l_v_derived_org_unit_cd;
196: CLOSE c_org_unit_sec_cd;
282: ******************************************************************/
283:
284: TYPE sp_fees_rec_type IS RECORD( person_id hz_parties.party_id%TYPE,
285: course_cd igs_ps_ver.course_cd%TYPE,
286: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
287: fee_type igs_fi_fee_type.fee_type%TYPE,
288: fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
289: fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
290: old_amount igs_fi_special_fees.fee_amt%TYPE,
299: -- Cursor to determine sum of Special Fees for a student from the special fees table
300: -- This does not include the Retention Fees
301: CURSOR cur_get_sum_sp_fees(cp_n_person_id hz_parties.party_id%TYPE,
302: cp_v_course_cd igs_ps_ver.course_cd%TYPE,
303: cp_n_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
304: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
305: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
306: cp_v_transaction_type_cd igs_fi_special_fees.s_transaction_type_code%TYPE) IS
307: SELECT fee_type,
318:
319: -- Cursor to determine if the current unit attempt is assessable or not
320: CURSOR cur_unit_load(cp_n_person_id hz_parties.party_id%TYPE,
321: cp_v_course_cd igs_ps_ver.course_cd%TYPE,
322: cp_n_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
323: cp_v_unit_att_status igs_lookups_view.lookup_type%TYPE,
324: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE) IS
325: SELECT sua.cal_type,
326: sua.ci_sequence_number, sua.discontinued_dt,
347: AND sua.uoo_id = cp_n_uoo_id
348: AND sua.course_cd = cp_v_course_cd;
349:
350: -- Cursor to obtain all fee types from the Special Fees Rate setup
351: CURSOR cur_usec_sp_fees(cp_n_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
352: SELECT sp_fee_amt,
353: fee_type
354: FROM igs_ps_usec_sp_fees
355: WHERE uoo_id = cp_n_uoo_id