[Home] [Help]
94: PROCEDURE call_charges_api(p_n_person_id IN hz_parties.party_id%TYPE,
95: p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
96: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
97: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
98: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
99: p_n_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
100: p_n_amount IN igs_fi_invln_int.amount%TYPE,
101: p_v_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,
102: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
281: Obsoleted the cursor CUR_FEE_DECLINED
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,
298:
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
317: GROUP BY fee_type, invoice_id;
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,