[Home] [Help]
1583: -- Cursor to find all rates defined under element range found in above cursor.
1584: CURSOR c_elm_rng_rates ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
1585: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
1586: cp_n_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
1587: cp_v_fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
1588: cp_n_range_number igs_fi_elm_range.range_number%TYPE,
1589: cp_v_relation_type igs_fi_elm_range.s_relation_type%TYPE) IS
1590: SELECT err.rate_number,
1591: far.order_of_precedence,
2828: -- Cursor to find all Global Element ranges defined for the input parameter combination.
2829: CURSOR c_elm_ranges ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
2830: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
2831: cp_n_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
2832: cp_v_fee_cat igs_fi_fee_cat_all.fee_cat%TYPE ) IS
2833: SELECT er_id,
2834: s_relation_type,
2835: range_number,
2836: lower_range,
2847: -- Cursor to find all rates defined under element range found in above cursor.
2848: CURSOR c_elm_rng_rates ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
2849: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
2850: cp_n_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
2851: cp_v_fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
2852: cp_n_range_number igs_fi_elm_range.range_number%TYPE,
2853: cp_v_relation_type igs_fi_elm_range.s_relation_type%TYPE) IS
2854: SELECT far.*
2855: FROM igs_fi_elm_range_rt err,
4544: v_fee_cat igs_fi_f_cat_ca_inst.fee_cat%TYPE;
4545: v_record_found BOOLEAN := FALSE;
4546: v_message_name VARCHAR2(30);
4547:
4548: l_fee_category igs_fi_fee_cat_all.fee_cat%TYPE;
4549: l_b_fci_lci BOOLEAN := FALSE;
4550: l_b_ret_status BOOLEAN;
4551: l_b_recs_found BOOLEAN;
4552: l_b_return_status BOOLEAN := FALSE;
4621: l_c_control_curr igs_fi_control_all.currency_cd%TYPE;
4622:
4623: CURSOR cur_fee_cat_curr(cp_fee_cat IN VARCHAR2) IS
4624: SELECT currency_cd
4625: FROM igs_fi_fee_cat_all
4626: WHERE fee_cat = cp_fee_cat;
4627: l_cur_fee_cat_curr cur_fee_cat_curr%ROWTYPE;
4628:
4629: lv_sum_message varchar2(30);
4760: AND scas.fee_ass_ind = cp_v_fee_ass_ind
4761: AND esptv.fee_cat = cp_v_fee_cat;
4762:
4763: l_v_person_name hz_parties.party_name%TYPE;
4764: l_v_currency_cd igs_fi_fee_cat_all.currency_cd%TYPE;
4765:
4766: TYPE t_fee_type_typ IS TABLE OF igs_fi_fee_type_all.fee_type%TYPE INDEX BY BINARY_INTEGER;
4767: tbl_fee_type t_fee_type_typ;
4768: l_b_found BOOLEAN;
9140:
9141: PROCEDURE finpl_prc_predictive_scas ( p_n_person_id IN igs_fi_fee_as_items.person_id%TYPE,
9142: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
9143: p_v_career IN igs_ps_ver_all.course_type%TYPE,
9144: p_v_fee_category IN igs_fi_fee_cat_all.fee_cat%TYPE,
9145: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
9146: p_n_fee_ci_sequence_num IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
9147: p_v_curr_cd IN igs_fi_control_all.currency_cd%TYPE,
9148: p_d_effective_date IN DATE,
9171: person_id hz_parties.party_id%TYPE,
9172: program_cd igs_ps_ver_all.course_cd%TYPE,
9173: program_version igs_ps_ver_all.version_number%TYPE,
9174: career igs_ps_ver_all.course_type%TYPE,
9175: fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9176: crs_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
9177: location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
9178: att_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
9179: att_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
9199: -- Cursor to get Fee Assessable Program Attempts from Terms Table.
9200: --Enh 3988455: Uptake of Program Transfer Enhancements
9201: --Cursor modified to ignore program attempts with Future-Dated Transfer flag set to 'C'
9202: CURSOR c_get_term_recs(cp_n_person_id igs_fi_fee_as_items.person_id%TYPE,
9203: cp_v_fee_category igs_fi_fee_cat_all.fee_cat%TYPE,
9204: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9205: cp_v_career igs_ps_ver_all.course_type%TYPE,
9206: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
9207: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9262: -- Cursor to fetch Program Attempts from Student Program Attempt table.
9263: --Enh 3988455: Uptake of Program Transfer Enhancements
9264: --Cursor modified to ignore program attempts with Future-Dated Transfer flag set to 'C'
9265: CURSOR c_get_scas_recs(cp_n_person_id igs_fi_fee_as_items.person_id%TYPE,
9266: cp_v_fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9267: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9268: cp_v_career igs_ps_ver_all.course_type%TYPE,
9269: cp_v_primary_program_type igs_en_stdnt_ps_att_all.primary_program_type%TYPE,
9270: cp_v_key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9315: ORDER BY sca.fee_cat,
9316: sca.person_id,
9317: sca.course_cd;
9318:
9319: CURSOR c_fee_cat_curr (cp_v_fee_cat IN igs_fi_fee_cat_all.fee_cat%TYPE) IS
9320: SELECT currency_cd
9321: FROM igs_fi_fee_cat_all
9322: WHERE fee_cat = cp_v_fee_cat;
9323: rec_cur_fee_cat_curr c_fee_cat_curr%ROWTYPE;
9317: sca.course_cd;
9318:
9319: CURSOR c_fee_cat_curr (cp_v_fee_cat IN igs_fi_fee_cat_all.fee_cat%TYPE) IS
9320: SELECT currency_cd
9321: FROM igs_fi_fee_cat_all
9322: WHERE fee_cat = cp_v_fee_cat;
9323: rec_cur_fee_cat_curr c_fee_cat_curr%ROWTYPE;
9324:
9325: l_b_rec_found_at_terms BOOLEAN;