[Home] [Help]
54: bannamal 31-MAR-2005 Bug 4224364 STUDENT FINANCE UPTAKE OF PROGRAM TRANSFER FUTURE DATED FLAG VALUE CHANGES
55: Modified the cursors c_get_term_recs, c_get_scas_recs to ignore the program attempts
56: with Future-Dated Transfer flag set to 'C'
57: svuppala 21-MAR-2005 Bug 4240402 Timezone impact; Truncating the time part in calling place of the table handlers
58: of the tables IGS_FI_FEE_AS_ALL, IGS_FI_FEE_AS_ITEMS.
59: Modified the sysdate entries as Trunc(Sysdate) and
60: p_effective_dt also modified as trunc(p_effective_dt) where ever required .
61: pathipat 18-Nov-2004 Bug 4017841 - Modified get_stdnt_res_status_cd() and finp_ins_enr_fee_ass()
62: Removed reference to res_dt_alias of table igs_fi_control_all and associated code
397: p_fee_assessment IN OUT NOCOPY NUMBER ,
398: p_charge_rate OUT NOCOPY IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
399: p_c_career IN igs_ps_ver_all.course_type%TYPE,
400: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
401: p_n_max_chg_elements IN igs_fi_fee_as_items.max_chg_elements%TYPE,
402: p_n_called IN NUMBER) RETURN BOOLEAN;
403:
404:
405: FUNCTION finpl_get_org_unit_cd(p_n_party_id IN hz_parties.party_id%TYPE) RETURN VARCHAR2;
749: l_rec_index_row r_s_fee_as_items_typ;
750: l_n_order_num igs_fi_er_ord_dtls.order_num%TYPE;
751: l_v_order_attr_val igs_fi_er_ord_dtls.order_attr_value%TYPE;
752:
753: CURSOR cur_order_num (cp_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE) IS
754: SELECT order_num, order_attr_value
755: FROM igs_fi_er_ord_dtls
756: WHERE elm_rng_order_name = p_v_elm_rng_order_name
757: AND order_attr_value = TO_CHAR(cp_n_unit_type_id);
1033: Change History
1034: Who When What
1035: shtatiko 21-JUL-2004 Enh# 3741400, Created this function.
1036: ***************************************************************/
1037: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
1038: l_n_enrolled_cp igs_fi_fee_as_items.credit_points%TYPE;
1039: l_n_billing_cp igs_fi_fee_as_items.credit_points%TYPE;
1040: l_n_audit_cp igs_fi_fee_as_items.credit_points%TYPE;
1041: l_n_ret_cp igs_fi_fee_as_items.credit_points%TYPE;
1034: Who When What
1035: shtatiko 21-JUL-2004 Enh# 3741400, Created this function.
1036: ***************************************************************/
1037: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
1038: l_n_enrolled_cp igs_fi_fee_as_items.credit_points%TYPE;
1039: l_n_billing_cp igs_fi_fee_as_items.credit_points%TYPE;
1040: l_n_audit_cp igs_fi_fee_as_items.credit_points%TYPE;
1041: l_n_ret_cp igs_fi_fee_as_items.credit_points%TYPE;
1042: BEGIN
1035: shtatiko 21-JUL-2004 Enh# 3741400, Created this function.
1036: ***************************************************************/
1037: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
1038: l_n_enrolled_cp igs_fi_fee_as_items.credit_points%TYPE;
1039: l_n_billing_cp igs_fi_fee_as_items.credit_points%TYPE;
1040: l_n_audit_cp igs_fi_fee_as_items.credit_points%TYPE;
1041: l_n_ret_cp igs_fi_fee_as_items.credit_points%TYPE;
1042: BEGIN
1043:
1036: ***************************************************************/
1037: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
1038: l_n_enrolled_cp igs_fi_fee_as_items.credit_points%TYPE;
1039: l_n_billing_cp igs_fi_fee_as_items.credit_points%TYPE;
1040: l_n_audit_cp igs_fi_fee_as_items.credit_points%TYPE;
1041: l_n_ret_cp igs_fi_fee_as_items.credit_points%TYPE;
1042: BEGIN
1043:
1044: -- Invoke EN API to calculate Enrolled/Billable/Audit Credit Points
1037: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
1038: l_n_enrolled_cp igs_fi_fee_as_items.credit_points%TYPE;
1039: l_n_billing_cp igs_fi_fee_as_items.credit_points%TYPE;
1040: l_n_audit_cp igs_fi_fee_as_items.credit_points%TYPE;
1041: l_n_ret_cp igs_fi_fee_as_items.credit_points%TYPE;
1042: BEGIN
1043:
1044: -- Invoke EN API to calculate Enrolled/Billable/Audit Credit Points
1045: l_n_ret_cp := igs_en_prc_load.enrp_clc_sua_load (
1465: p_fee_assessment IN OUT NOCOPY NUMBER,
1466: p_charge_rate OUT NOCOPY IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
1467: p_c_career IN igs_ps_ver_all.course_type%TYPE,
1468: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
1469: p_n_max_chg_elements IN igs_fi_fee_as_items.max_chg_elements%TYPE,
1470: p_n_called IN NUMBER) RETURN BOOLEAN AS
1471: /*************************************************************
1472: Created By :
1473: Date Created By :
1541: lv_cntrct_rt_apply BOOLEAN;
1542:
1543: /**to check whether override charge method is actioned**/
1544: lv_charge_override BOOLEAN := FALSE;
1545: lv_fee_assessment IGS_FI_FEE_AS_ITEMS.amount%TYPE;
1546: v_derived_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
1547: l_overide_chg_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE;
1548: l_fee_category IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE;
1549:
1550: l_ch_ovr_exist BOOLEAN := FALSE;
1551:
1552: l_b_elm_ranges_defined BOOLEAN := FALSE;
1553: l_b_elm_range_applies BOOLEAN := FALSE;
1554: l_n_crs_version_num igs_fi_fee_as_items.crs_version_number%TYPE;
1555:
1556: v_derived_unit_type_id igs_fi_fee_as_rate.unit_type_id%TYPE;
1557: v_derived_unit_class igs_fi_fee_as_rate.unit_class%TYPE;
1558: v_derived_unit_mode igs_fi_fee_as_rate.unit_mode%TYPE;
1572: l_b_elm_rng BOOLEAN := FALSE;
1573: l_b_pred BOOLEAN := FALSE;
1574:
1575: /**Cursor to get fee type description**/
1576: CURSOR c_fee_type( cp_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ) IS
1577: SELECT description
1578: FROM igs_fi_fee_type_all
1579: WHERE fee_type = cp_fee_type;
1580:
1672: SELECT owner_org_unit_cd, location_cd
1673: FROM igs_ps_unit_ofr_opt_all
1674: WHERE uoo_id = cp_uoo_id;
1675:
1676: CURSOR cur_unit_cd (cp_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE) IS
1677: SELECT unit_cd, version_number
1678: FROM igs_ps_unit_ofr_opt_all
1679: WHERE uoo_id = cp_n_uoo_id;
1680:
1699: p_rate_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE,
1700: p_rate_us_version_num igs_fi_fee_as_rate.us_version_number%TYPE,
1701: p_derived_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE,
1702: p_derived_us_version_num igs_fi_fee_as_rate.us_version_number%TYPE,
1703: p_rate_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
1704: p_derived_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
1705: p_rate_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1706: p_derived_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1707: p_rate_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
1700: p_rate_us_version_num igs_fi_fee_as_rate.us_version_number%TYPE,
1701: p_derived_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE,
1702: p_derived_us_version_num igs_fi_fee_as_rate.us_version_number%TYPE,
1703: p_rate_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
1704: p_derived_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
1705: p_rate_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1706: p_derived_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1707: p_rate_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
1708: p_derived_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
1701: p_derived_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE,
1702: p_derived_us_version_num igs_fi_fee_as_rate.us_version_number%TYPE,
1703: p_rate_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
1704: p_derived_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
1705: p_rate_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1706: p_derived_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1707: p_rate_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
1708: p_derived_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
1709: p_rate_unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
1702: p_derived_us_version_num igs_fi_fee_as_rate.us_version_number%TYPE,
1703: p_rate_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
1704: p_derived_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
1705: p_rate_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1706: p_derived_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1707: p_rate_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
1708: p_derived_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
1709: p_rate_unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
1710: p_derived_unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
1703: p_rate_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
1704: p_derived_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
1705: p_rate_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1706: p_derived_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1707: p_rate_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
1708: p_derived_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
1709: p_rate_unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
1710: p_derived_unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
1711: p_rate_unit_version_num igs_fi_fee_as_rate.unit_version_number%TYPE,
1704: p_derived_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
1705: p_rate_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1706: p_derived_unit_class igs_fi_fee_as_items.unit_class%TYPE,
1707: p_rate_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
1708: p_derived_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
1709: p_rate_unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
1710: p_derived_unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
1711: p_rate_unit_version_num igs_fi_fee_as_rate.unit_version_number%TYPE,
1712: p_derived_unit_version_num igs_fi_fee_as_rate.unit_version_number%TYPE,
1709: p_rate_unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
1710: p_derived_unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
1711: p_rate_unit_version_num igs_fi_fee_as_rate.unit_version_number%TYPE,
1712: p_derived_unit_version_num igs_fi_fee_as_rate.unit_version_number%TYPE,
1713: p_rate_unit_level igs_fi_fee_as_items.unit_level%TYPE,
1714: p_derived_unit_level igs_fi_fee_as_items.unit_level%TYPE
1715: ) RETURN BOOLEAN AS
1716: /*************************************************************
1717: Created By :
1710: p_derived_unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
1711: p_rate_unit_version_num igs_fi_fee_as_rate.unit_version_number%TYPE,
1712: p_derived_unit_version_num igs_fi_fee_as_rate.unit_version_number%TYPE,
1713: p_rate_unit_level igs_fi_fee_as_items.unit_level%TYPE,
1714: p_derived_unit_level igs_fi_fee_as_items.unit_level%TYPE
1715: ) RETURN BOOLEAN AS
1716: /*************************************************************
1717: Created By :
1718: Date Created By :
2391: p_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
2392: p_charge_rate OUT NOCOPY IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
2393: p_derived_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
2394: p_derived_us_version_num IN igs_fi_fee_as_rate.us_version_number%TYPE,
2395: p_derived_unit_type_id IN igs_fi_fee_as_items.unit_type_id%TYPE,
2396: p_derived_unit_class IN igs_fi_fee_as_items.unit_class%TYPE,
2397: p_derived_unit_mode IN igs_fi_fee_as_items.unit_mode%TYPE,
2398: p_derived_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE,
2399: p_derived_unit_version_num IN igs_fi_fee_as_rate.unit_version_number%TYPE,
2392: p_charge_rate OUT NOCOPY IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
2393: p_derived_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
2394: p_derived_us_version_num IN igs_fi_fee_as_rate.us_version_number%TYPE,
2395: p_derived_unit_type_id IN igs_fi_fee_as_items.unit_type_id%TYPE,
2396: p_derived_unit_class IN igs_fi_fee_as_items.unit_class%TYPE,
2397: p_derived_unit_mode IN igs_fi_fee_as_items.unit_mode%TYPE,
2398: p_derived_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE,
2399: p_derived_unit_version_num IN igs_fi_fee_as_rate.unit_version_number%TYPE,
2400: p_derived_unit_level IN igs_fi_fee_as_items.unit_level%TYPE
2393: p_derived_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
2394: p_derived_us_version_num IN igs_fi_fee_as_rate.us_version_number%TYPE,
2395: p_derived_unit_type_id IN igs_fi_fee_as_items.unit_type_id%TYPE,
2396: p_derived_unit_class IN igs_fi_fee_as_items.unit_class%TYPE,
2397: p_derived_unit_mode IN igs_fi_fee_as_items.unit_mode%TYPE,
2398: p_derived_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE,
2399: p_derived_unit_version_num IN igs_fi_fee_as_rate.unit_version_number%TYPE,
2400: p_derived_unit_level IN igs_fi_fee_as_items.unit_level%TYPE
2401: ) AS
2396: p_derived_unit_class IN igs_fi_fee_as_items.unit_class%TYPE,
2397: p_derived_unit_mode IN igs_fi_fee_as_items.unit_mode%TYPE,
2398: p_derived_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE,
2399: p_derived_unit_version_num IN igs_fi_fee_as_rate.unit_version_number%TYPE,
2400: p_derived_unit_level IN igs_fi_fee_as_items.unit_level%TYPE
2401: ) AS
2402: /***********************************************************************************************
2403: Change History:
2404: Who When What
2916: l_n_previous_upper igs_fi_sub_elm_rng.sub_upper_range%TYPE;
2917: l_v_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE;
2918: l_n_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;
2919: lv_cntrct_rt_apply BOOLEAN;
2920: l_n_summed_chg_elm igs_fi_fee_as_items.chg_elements%TYPE;
2921: l_n_rate_factor igs_fi_fee_as_items.chg_elements%TYPE;
2922: l_b_flag BOOLEAN;
2923: l_b_first_rate_match BOOLEAN;
2924: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;
2917: l_v_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE;
2918: l_n_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;
2919: lv_cntrct_rt_apply BOOLEAN;
2920: l_n_summed_chg_elm igs_fi_fee_as_items.chg_elements%TYPE;
2921: l_n_rate_factor igs_fi_fee_as_items.chg_elements%TYPE;
2922: l_b_flag BOOLEAN;
2923: l_b_first_rate_match BOOLEAN;
2924: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;
2925: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;
3238:
3239: IF (l_b_flag = FALSE) THEN
3240:
3241: gv_as_item_cntr := nvl(gv_as_item_cntr,0) + 1;
3242: -- Insert a new record in the IGS_FI_FEE_AS_ITEMS table
3243: p_t_fee_as_items(gv_as_item_cntr).person_id := p_n_person_id;
3244: p_t_fee_as_items(gv_as_item_cntr).status := 'O';
3245: p_t_fee_as_items(gv_as_item_cntr).fee_type := p_v_fee_type;
3246: p_t_fee_as_items(gv_as_item_cntr).fee_cat := l_v_fee_category;
4780:
4781: l_v_fee_cat igs_en_stdnt_ps_att.fee_cat%TYPE;
4782:
4783: FUNCTION finpl_sum_fee_ass_item (
4784: p_person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
4785: p_status IGS_FI_FEE_AS_ITEMS.status%TYPE,
4786: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
4787: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
4788: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
4781: l_v_fee_cat igs_en_stdnt_ps_att.fee_cat%TYPE;
4782:
4783: FUNCTION finpl_sum_fee_ass_item (
4784: p_person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
4785: p_status IGS_FI_FEE_AS_ITEMS.status%TYPE,
4786: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
4787: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
4788: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
4789: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
4782:
4783: FUNCTION finpl_sum_fee_ass_item (
4784: p_person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
4785: p_status IGS_FI_FEE_AS_ITEMS.status%TYPE,
4786: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
4787: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
4788: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
4789: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
4790: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
4783: FUNCTION finpl_sum_fee_ass_item (
4784: p_person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
4785: p_status IGS_FI_FEE_AS_ITEMS.status%TYPE,
4786: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
4787: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
4788: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
4789: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
4790: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
4791: p_n_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
4784: p_person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
4785: p_status IGS_FI_FEE_AS_ITEMS.status%TYPE,
4786: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
4787: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
4788: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
4789: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
4790: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
4791: p_n_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
4792: p_chg_method_type IGS_FI_FEE_AS_ITEMS.s_chg_method_type%TYPE,
4785: p_status IGS_FI_FEE_AS_ITEMS.status%TYPE,
4786: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
4787: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
4788: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
4789: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
4790: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
4791: p_n_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
4792: p_chg_method_type IGS_FI_FEE_AS_ITEMS.s_chg_method_type%TYPE,
4793: p_description IGS_FI_FEE_AS_ITEMS.description%TYPE,
4786: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
4787: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
4788: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
4789: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
4790: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
4791: p_n_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
4792: p_chg_method_type IGS_FI_FEE_AS_ITEMS.s_chg_method_type%TYPE,
4793: p_description IGS_FI_FEE_AS_ITEMS.description%TYPE,
4794: p_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
4787: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
4788: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
4789: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
4790: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
4791: p_n_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
4792: p_chg_method_type IGS_FI_FEE_AS_ITEMS.s_chg_method_type%TYPE,
4793: p_description IGS_FI_FEE_AS_ITEMS.description%TYPE,
4794: p_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
4795: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
4788: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
4789: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
4790: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
4791: p_n_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
4792: p_chg_method_type IGS_FI_FEE_AS_ITEMS.s_chg_method_type%TYPE,
4793: p_description IGS_FI_FEE_AS_ITEMS.description%TYPE,
4794: p_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
4795: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
4796: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
4789: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
4790: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
4791: p_n_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
4792: p_chg_method_type IGS_FI_FEE_AS_ITEMS.s_chg_method_type%TYPE,
4793: p_description IGS_FI_FEE_AS_ITEMS.description%TYPE,
4794: p_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
4795: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
4796: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
4797: p_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
4790: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
4791: p_n_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
4792: p_chg_method_type IGS_FI_FEE_AS_ITEMS.s_chg_method_type%TYPE,
4793: p_description IGS_FI_FEE_AS_ITEMS.description%TYPE,
4794: p_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
4795: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
4796: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
4797: p_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
4798: p_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
4791: p_n_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
4792: p_chg_method_type IGS_FI_FEE_AS_ITEMS.s_chg_method_type%TYPE,
4793: p_description IGS_FI_FEE_AS_ITEMS.description%TYPE,
4794: p_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
4795: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
4796: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
4797: p_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
4798: p_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
4799: p_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
4792: p_chg_method_type IGS_FI_FEE_AS_ITEMS.s_chg_method_type%TYPE,
4793: p_description IGS_FI_FEE_AS_ITEMS.description%TYPE,
4794: p_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
4795: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
4796: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
4797: p_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
4798: p_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
4799: p_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
4800: p_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
4793: p_description IGS_FI_FEE_AS_ITEMS.description%TYPE,
4794: p_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
4795: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
4796: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
4797: p_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
4798: p_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
4799: p_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
4800: p_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
4801: p_trace_on VARCHAR2,
4794: p_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
4795: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
4796: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
4797: p_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
4798: p_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
4799: p_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
4800: p_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
4801: p_trace_on VARCHAR2,
4802: p_message_name OUT NOCOPY VARCHAR2,
4795: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
4796: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
4797: p_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
4798: p_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
4799: p_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
4800: p_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
4801: p_trace_on VARCHAR2,
4802: p_message_name OUT NOCOPY VARCHAR2,
4803: p_uoo_id igs_fi_fee_as_items.uoo_id%TYPE,
4796: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
4797: p_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
4798: p_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
4799: p_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
4800: p_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
4801: p_trace_on VARCHAR2,
4802: p_message_name OUT NOCOPY VARCHAR2,
4803: p_uoo_id igs_fi_fee_as_items.uoo_id%TYPE,
4804: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
4799: p_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
4800: p_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
4801: p_trace_on VARCHAR2,
4802: p_message_name OUT NOCOPY VARCHAR2,
4803: p_uoo_id igs_fi_fee_as_items.uoo_id%TYPE,
4804: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
4805: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
4806: p_v_unit_class igs_fi_fee_as_items.unit_class%TYPE,
4807: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
4800: p_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
4801: p_trace_on VARCHAR2,
4802: p_message_name OUT NOCOPY VARCHAR2,
4803: p_uoo_id igs_fi_fee_as_items.uoo_id%TYPE,
4804: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
4805: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
4806: p_v_unit_class igs_fi_fee_as_items.unit_class%TYPE,
4807: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
4808: p_v_unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
4801: p_trace_on VARCHAR2,
4802: p_message_name OUT NOCOPY VARCHAR2,
4803: p_uoo_id igs_fi_fee_as_items.uoo_id%TYPE,
4804: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
4805: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
4806: p_v_unit_class igs_fi_fee_as_items.unit_class%TYPE,
4807: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
4808: p_v_unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
4809: p_n_unit_version igs_fi_fee_as_items.unit_version_number%TYPE
4802: p_message_name OUT NOCOPY VARCHAR2,
4803: p_uoo_id igs_fi_fee_as_items.uoo_id%TYPE,
4804: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
4805: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
4806: p_v_unit_class igs_fi_fee_as_items.unit_class%TYPE,
4807: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
4808: p_v_unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
4809: p_n_unit_version igs_fi_fee_as_items.unit_version_number%TYPE
4810: )
4803: p_uoo_id igs_fi_fee_as_items.uoo_id%TYPE,
4804: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
4805: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
4806: p_v_unit_class igs_fi_fee_as_items.unit_class%TYPE,
4807: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
4808: p_v_unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
4809: p_n_unit_version igs_fi_fee_as_items.unit_version_number%TYPE
4810: )
4811: RETURN BOOLEAN AS
4804: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
4805: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
4806: p_v_unit_class igs_fi_fee_as_items.unit_class%TYPE,
4807: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
4808: p_v_unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
4809: p_n_unit_version igs_fi_fee_as_items.unit_version_number%TYPE
4810: )
4811: RETURN BOOLEAN AS
4812: /*************************************************************
4805: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
4806: p_v_unit_class igs_fi_fee_as_items.unit_class%TYPE,
4807: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
4808: p_v_unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
4809: p_n_unit_version igs_fi_fee_as_items.unit_version_number%TYPE
4810: )
4811: RETURN BOOLEAN AS
4812: /*************************************************************
4813: Created By :syam shankar
4829: (reverse chronological order - newest change first)
4830: ***************************************************************/
4831: v_message_name VARCHAR2(30);
4832: lv_record_found boolean := FALSE;
4833: CURSOR c_fee_type( cp_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ) IS
4834: SELECT description, s_fee_trigger_cat
4835: FROM igs_fi_fee_type_all
4836: WHERE fee_type = cp_fee_type;
4837:
4965: p_fee_type igs_fi_fee_as_all.fee_type%TYPE,
4966: p_fee_cal_type igs_fi_fee_as_all.fee_cal_type%TYPE,
4967: p_fee_ci_sequence_number igs_fi_fee_as_all.fee_ci_sequence_number%TYPE,
4968: p_course_cd igs_fi_fee_as_all.course_cd%TYPE,
4969: p_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
4970: p_course_attempt_status igs_fi_fee_as_items.course_attempt_status%TYPE,
4971: p_old_ass_amount igs_fi_fee_as_all.transaction_amount%TYPE,
4972: p_new_ass_amount igs_fi_fee_as_all.transaction_amount%TYPE,
4973: p_effective_date DATE,
4966: p_fee_cal_type igs_fi_fee_as_all.fee_cal_type%TYPE,
4967: p_fee_ci_sequence_number igs_fi_fee_as_all.fee_ci_sequence_number%TYPE,
4968: p_course_cd igs_fi_fee_as_all.course_cd%TYPE,
4969: p_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
4970: p_course_attempt_status igs_fi_fee_as_items.course_attempt_status%TYPE,
4971: p_old_ass_amount igs_fi_fee_as_all.transaction_amount%TYPE,
4972: p_new_ass_amount igs_fi_fee_as_all.transaction_amount%TYPE,
4973: p_effective_date DATE,
4974: p_trace_on VARCHAR2,
4973: p_effective_date DATE,
4974: p_trace_on VARCHAR2,
4975: p_d_gl_date igs_fi_invln_int_all.gl_date%TYPE,
4976: p_v_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
4977: p_n_rul_sequence_number igs_fi_fee_as_items.rul_sequence_number%TYPE,
4978: p_n_scope_rul_seq_num igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
4979: p_v_chg_method_type igs_fi_fee_as_items.s_chg_method_type%TYPE,
4980: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
4981: p_v_location_cd igs_fi_fee_as_items.location_cd%TYPE,
4974: p_trace_on VARCHAR2,
4975: p_d_gl_date igs_fi_invln_int_all.gl_date%TYPE,
4976: p_v_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
4977: p_n_rul_sequence_number igs_fi_fee_as_items.rul_sequence_number%TYPE,
4978: p_n_scope_rul_seq_num igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
4979: p_v_chg_method_type igs_fi_fee_as_items.s_chg_method_type%TYPE,
4980: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
4981: p_v_location_cd igs_fi_fee_as_items.location_cd%TYPE,
4982: p_v_career igs_ps_ver_all.course_type%TYPE,
4975: p_d_gl_date igs_fi_invln_int_all.gl_date%TYPE,
4976: p_v_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
4977: p_n_rul_sequence_number igs_fi_fee_as_items.rul_sequence_number%TYPE,
4978: p_n_scope_rul_seq_num igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
4979: p_v_chg_method_type igs_fi_fee_as_items.s_chg_method_type%TYPE,
4980: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
4981: p_v_location_cd igs_fi_fee_as_items.location_cd%TYPE,
4982: p_v_career igs_ps_ver_all.course_type%TYPE,
4983: p_elm_rng_order_name igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
4977: p_n_rul_sequence_number igs_fi_fee_as_items.rul_sequence_number%TYPE,
4978: p_n_scope_rul_seq_num igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
4979: p_v_chg_method_type igs_fi_fee_as_items.s_chg_method_type%TYPE,
4980: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
4981: p_v_location_cd igs_fi_fee_as_items.location_cd%TYPE,
4982: p_v_career igs_ps_ver_all.course_type%TYPE,
4983: p_elm_rng_order_name igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
4984: p_attendance_mode igs_fi_fee_as_items.attendance_mode%TYPE,
4985: p_attendance_type igs_fi_fee_as_items.attendance_type%TYPE,
4980: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
4981: p_v_location_cd igs_fi_fee_as_items.location_cd%TYPE,
4982: p_v_career igs_ps_ver_all.course_type%TYPE,
4983: p_elm_rng_order_name igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
4984: p_attendance_mode igs_fi_fee_as_items.attendance_mode%TYPE,
4985: p_attendance_type igs_fi_fee_as_items.attendance_type%TYPE,
4986: p_n_max_chg_elements igs_fi_fee_as_items.max_chg_elements%TYPE
4987: ) AS
4988: /********************************************************************************************************
4981: p_v_location_cd igs_fi_fee_as_items.location_cd%TYPE,
4982: p_v_career igs_ps_ver_all.course_type%TYPE,
4983: p_elm_rng_order_name igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
4984: p_attendance_mode igs_fi_fee_as_items.attendance_mode%TYPE,
4985: p_attendance_type igs_fi_fee_as_items.attendance_type%TYPE,
4986: p_n_max_chg_elements igs_fi_fee_as_items.max_chg_elements%TYPE
4987: ) AS
4988: /********************************************************************************************************
4989: CHANGE HISTORY:
4982: p_v_career igs_ps_ver_all.course_type%TYPE,
4983: p_elm_rng_order_name igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
4984: p_attendance_mode igs_fi_fee_as_items.attendance_mode%TYPE,
4985: p_attendance_type igs_fi_fee_as_items.attendance_type%TYPE,
4986: p_n_max_chg_elements igs_fi_fee_as_items.max_chg_elements%TYPE
4987: ) AS
4988: /********************************************************************************************************
4989: CHANGE HISTORY:
4990: WHO WHEN WHAT
4999: Completely revamped retention logic to include Teaching Period retention.
5000: pathipat 05-Nov-2003 Enh 3117341 - Audit and Special Fees TD
5001: Removed code for retention amount, added call to generic pkg to get amount
5002: pathipat 12-Sep-2003 Enh 3108052 - Unit Sets in Rate table build
5003: Modified TBH calls of igs_Fi_fee_As_items
5004: sarakshi 13-Sep-2002 Enh#2564643,removed teh reference of subaccount from this procedure
5005: vvutukur 11-02-2002 Removed the cursor l_c_invoice_id and the check if the retention amount is greater than 0,
5006: within which source invoice id is derived. This is done for bug 2195715 as part of SFCR003,
5007: as there is no negative adjustment charge crated by Retention.
5087: WHERE sua.uoo_id = cp_n_uoo_id
5088: AND sua.person_id = cp_n_person_id
5089: AND sua.course_cd = cp_v_course_cd;
5090:
5091: CURSOR cur_unit_cd (cp_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE) IS
5092: SELECT unit_cd, version_number
5093: FROM igs_ps_unit_ofr_opt_all
5094: WHERE uoo_id = cp_n_uoo_id;
5095:
5095:
5096: l_v_optional_ind igs_fi_fee_type_all.optional_payment_ind%TYPE := NULL;
5097: l_v_nz_bill_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE;
5098: l_v_fee_ass_ind VARCHAR2(1);
5099: l_n_chg_elements igs_fi_fee_as_items.chg_elements%TYPE;
5100: l_n_count NUMBER;
5101: l_n_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;
5102: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;
5103: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
5103: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
5104: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;
5105: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;
5106: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE;
5107: l_n_amount igs_fi_fee_as_items.amount%TYPE;
5108: l_v_charge_rate igs_fi_fee_as_rate.chg_rate%TYPE;
5109: l_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE;
5110: l_n_old_amount igs_fi_fee_as_items.amount%TYPE;
5111: l_d_disc_dt igs_en_su_attempt_all.enrolled_dt%TYPE;
5105: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;
5106: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE;
5107: l_n_amount igs_fi_fee_as_items.amount%TYPE;
5108: l_v_charge_rate igs_fi_fee_as_rate.chg_rate%TYPE;
5109: l_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE;
5110: l_n_old_amount igs_fi_fee_as_items.amount%TYPE;
5111: l_d_disc_dt igs_en_su_attempt_all.enrolled_dt%TYPE;
5112: l_d_enr_dt igs_en_su_attempt_all.enrolled_dt%TYPE;
5113: l_b_rec_found BOOLEAN;
5106: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE;
5107: l_n_amount igs_fi_fee_as_items.amount%TYPE;
5108: l_v_charge_rate igs_fi_fee_as_rate.chg_rate%TYPE;
5109: l_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE;
5110: l_n_old_amount igs_fi_fee_as_items.amount%TYPE;
5111: l_d_disc_dt igs_en_su_attempt_all.enrolled_dt%TYPE;
5112: l_d_enr_dt igs_en_su_attempt_all.enrolled_dt%TYPE;
5113: l_b_rec_found BOOLEAN;
5114: l_n_disc_units NUMBER;
5653: p_charge_rate igs_fi_fee_as_rate.chg_rate%TYPE,
5654: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
5655: p_effective_dt DATE,
5656: p_trace_on VARCHAR2,
5657: p_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
5658: p_course_attempt_status igs_fi_fee_as_items.course_attempt_status%TYPE,
5659: p_attendance_mode igs_fi_fee_as_items.attendance_mode%TYPE,
5660: p_attendance_type igs_fi_fee_as_items.attendance_type%TYPE,
5661: p_charge_elements IN OUT NOCOPY Igs_fi_fee_as_all.chg_elements%TYPE,
5654: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
5655: p_effective_dt DATE,
5656: p_trace_on VARCHAR2,
5657: p_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
5658: p_course_attempt_status igs_fi_fee_as_items.course_attempt_status%TYPE,
5659: p_attendance_mode igs_fi_fee_as_items.attendance_mode%TYPE,
5660: p_attendance_type igs_fi_fee_as_items.attendance_type%TYPE,
5661: p_charge_elements IN OUT NOCOPY Igs_fi_fee_as_all.chg_elements%TYPE,
5662: p_fee_assessment IN OUT NOCOPY NUMBER,
5655: p_effective_dt DATE,
5656: p_trace_on VARCHAR2,
5657: p_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
5658: p_course_attempt_status igs_fi_fee_as_items.course_attempt_status%TYPE,
5659: p_attendance_mode igs_fi_fee_as_items.attendance_mode%TYPE,
5660: p_attendance_type igs_fi_fee_as_items.attendance_type%TYPE,
5661: p_charge_elements IN OUT NOCOPY Igs_fi_fee_as_all.chg_elements%TYPE,
5662: p_fee_assessment IN OUT NOCOPY NUMBER,
5663: -- Added to initialize the new pl/sql table for Institution related records
5656: p_trace_on VARCHAR2,
5657: p_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
5658: p_course_attempt_status igs_fi_fee_as_items.course_attempt_status%TYPE,
5659: p_attendance_mode igs_fi_fee_as_items.attendance_mode%TYPE,
5660: p_attendance_type igs_fi_fee_as_items.attendance_type%TYPE,
5661: p_charge_elements IN OUT NOCOPY Igs_fi_fee_as_all.chg_elements%TYPE,
5662: p_fee_assessment IN OUT NOCOPY NUMBER,
5663: -- Added to initialize the new pl/sql table for Institution related records
5664: p_fcfl_status IN igs_fi_f_cat_fee_lbl_all.fee_liability_status%TYPE,
5661: p_charge_elements IN OUT NOCOPY Igs_fi_fee_as_all.chg_elements%TYPE,
5662: p_fee_assessment IN OUT NOCOPY NUMBER,
5663: -- Added to initialize the new pl/sql table for Institution related records
5664: p_fcfl_status IN igs_fi_f_cat_fee_lbl_all.fee_liability_status%TYPE,
5665: p_n_rul_sequence_number IN igs_fi_fee_as_items.rul_sequence_number%TYPE,
5666: p_n_scope_rul_seq_num IN igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
5667: p_v_chg_method_type IN igs_fi_fee_as_items.s_chg_method_type%TYPE,
5668: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,
5669: p_v_career IN igs_ps_ver_all.course_type%TYPE,
5662: p_fee_assessment IN OUT NOCOPY NUMBER,
5663: -- Added to initialize the new pl/sql table for Institution related records
5664: p_fcfl_status IN igs_fi_f_cat_fee_lbl_all.fee_liability_status%TYPE,
5665: p_n_rul_sequence_number IN igs_fi_fee_as_items.rul_sequence_number%TYPE,
5666: p_n_scope_rul_seq_num IN igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
5667: p_v_chg_method_type IN igs_fi_fee_as_items.s_chg_method_type%TYPE,
5668: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,
5669: p_v_career IN igs_ps_ver_all.course_type%TYPE,
5670: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
5663: -- Added to initialize the new pl/sql table for Institution related records
5664: p_fcfl_status IN igs_fi_f_cat_fee_lbl_all.fee_liability_status%TYPE,
5665: p_n_rul_sequence_number IN igs_fi_fee_as_items.rul_sequence_number%TYPE,
5666: p_n_scope_rul_seq_num IN igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
5667: p_v_chg_method_type IN igs_fi_fee_as_items.s_chg_method_type%TYPE,
5668: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,
5669: p_v_career IN igs_ps_ver_all.course_type%TYPE,
5670: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
5671: p_n_max_chg_elements IN igs_fi_fee_as_items.max_chg_elements%TYPE) AS
5664: p_fcfl_status IN igs_fi_f_cat_fee_lbl_all.fee_liability_status%TYPE,
5665: p_n_rul_sequence_number IN igs_fi_fee_as_items.rul_sequence_number%TYPE,
5666: p_n_scope_rul_seq_num IN igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
5667: p_v_chg_method_type IN igs_fi_fee_as_items.s_chg_method_type%TYPE,
5668: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,
5669: p_v_career IN igs_ps_ver_all.course_type%TYPE,
5670: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
5671: p_n_max_chg_elements IN igs_fi_fee_as_items.max_chg_elements%TYPE) AS
5672:
5667: p_v_chg_method_type IN igs_fi_fee_as_items.s_chg_method_type%TYPE,
5668: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,
5669: p_v_career IN igs_ps_ver_all.course_type%TYPE,
5670: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
5671: p_n_max_chg_elements IN igs_fi_fee_as_items.max_chg_elements%TYPE) AS
5672:
5673: /*************************************************************************************************
5674: CHANGE HISTORY:
5675: WHO WHEN WHAT
5679: pathipat 14-Oct-2005 Bug 4644004 - Retention amount is not calculated for increment charge method
5680: Added code to set t_fee_as_items(i).crs_version_number to p_crs_version_number
5681: uudayapr 14-Sep-2005 Bug 4609164 - passed the value of unit_class and unit_mode to the charges Api.
5682: pathipat 06-Sep-2005 Bug 4540295 - Fee assessment produce double fees after program version change
5683: Used t_Fee_as_items.crs_version_number for inserting into igs_fi_fee_as_items
5684: instead of the local variable l_crs_version_number.
5685: bannamal 08-Jul-2005 Enh#3392088 Campus Privilege Fee.
5686: Modified the tbh call to fee as items table to include two new columns.
5687: bannamal 03-Jun-2005 Bug#3442712 Unit Level Fee Assessment Build. Modified the call to igs_fi_fee_as_items_pkg.insert_row
5683: Used t_Fee_as_items.crs_version_number for inserting into igs_fi_fee_as_items
5684: instead of the local variable l_crs_version_number.
5685: bannamal 08-Jul-2005 Enh#3392088 Campus Privilege Fee.
5686: Modified the tbh call to fee as items table to include two new columns.
5687: bannamal 03-Jun-2005 Bug#3442712 Unit Level Fee Assessment Build. Modified the call to igs_fi_fee_as_items_pkg.insert_row
5688: added new parameters unit_type_id, unit_class, unit_mode and unit_level.
5689: pathipat 07-Sep-2004 Enh 3880438 - Retention Enhancements build
5690: Removed condition checking if new amount < old amount before invoking finpl_chk_debt_ret_sched
5691: shtatiko 27-JUL-2004 Enh# 3787816, Replaced the call to finpl_charge_is_declined with igs_fi_gen_008.chk_chg_adj.
5689: pathipat 07-Sep-2004 Enh 3880438 - Retention Enhancements build
5690: Removed condition checking if new amount < old amount before invoking finpl_chk_debt_ret_sched
5691: shtatiko 27-JUL-2004 Enh# 3787816, Replaced the call to finpl_charge_is_declined with igs_fi_gen_008.chk_chg_adj.
5692: pathipat 06-Jul-2004 Bug 3734842 - Added logic to check if records have been created correctly
5693: in IGS_FI_FEE_AS and IGS_FI_FEE_AS_ITEMS tables - added call to finpl_check_header_lines
5694: UUDAYAPR 17-DEC-2003 BUG#3080983 Modified V_assessment_amount,V_transaction_amount,p_fee_assessment
5695: To Number From Igs_fi_fee_ass_debt_v.Assessment_amount%Type,
5696: V_manual_entry_ind To Varchar2(1)
5697: v_last_effective_assessment_dt = IGS_FI_FEE_ASS_DEBT_V.last_effective_assessment_dt%TYPE TO DATE;
5698: and also the Cursor c_fadv
5699: pathipat 01-Oct-2003 Bug 3164141 - Added check for Declined Charges
5700: Moved code for logging messages to before the actual insert happens
5701: pathipat 12-Sep-2003 Enh 3108052 - Unit Sets in Rate Table build
5702: Modified TBH call of igs_fi_fee_as_items
5703: vvutukur 26-May-2003 Enh#2831572.Financial Accounting Build. Assigned proper value to p_v_residency_cd before calling charges api.
5704: sarakshi 13-Sep-2002 Enh#2564643,removed teh reference of subaccount from this procedure
5705: VVUTUKUR 11-02-2002 Removed cursor l_c_invoice_id and related logic reg. the derivation of the source transaction ID.
5706: Since this part of covered in Charges API. bug 2195715 as part of SFCR003
5706: Since this part of covered in Charges API. bug 2195715 as part of SFCR003
5707: rnirwani 17-apr-02 Before invocation to the charges api the orgunit code is also assigned to record group
5708: relating to lines entry for bug# 2317155
5709: ************************************************************************************************/
5710: -- Exception raised when insertion into IGS_FI_FEE_AS and IGS_FI_FEE_AS_ITEMS had some errors
5711: e_unexpected_error EXCEPTION;
5712:
5713: BEGIN
5714: DECLARE
5730: l_status VARCHAR2(1);
5731: l_msg_count NUMBER;
5732: l_msg_data VARCHAR2(2000);
5733:
5734: l_crs_attempt_status igs_fi_fee_as_items.course_attempt_status%TYPE;
5735:
5736: v_rec_found BOOLEAN;
5737: l_v_invoice_number igs_fi_inv_int_all.invoice_number%TYPE;
5738: l_b_charge_declined BOOLEAN;
5798:
5799: log_to_fnd( p_v_module => 'finpl_ins_fee_ass',
5800: p_v_string => 'Vars to be used: ' || v_fee_cat||','||v_course_cd||','||v_chg_rate||','||v_chg_elements );
5801: DECLARE
5802: lv_diff_amount igs_fi_fee_as_items.amount%type := 0;
5803: lv_sum_diff igs_fi_fee_as_items.amount%type := 0;
5804: lv_as_record_ins boolean := FALSE;
5805: lv_fee_ass_item_id IGS_FI_FEE_AS_ITEMS.fee_ass_item_id%TYPE;
5806: lv_as_items_rowid VARCHAR2(25);
5799: log_to_fnd( p_v_module => 'finpl_ins_fee_ass',
5800: p_v_string => 'Vars to be used: ' || v_fee_cat||','||v_course_cd||','||v_chg_rate||','||v_chg_elements );
5801: DECLARE
5802: lv_diff_amount igs_fi_fee_as_items.amount%type := 0;
5803: lv_sum_diff igs_fi_fee_as_items.amount%type := 0;
5804: lv_as_record_ins boolean := FALSE;
5805: lv_fee_ass_item_id IGS_FI_FEE_AS_ITEMS.fee_ass_item_id%TYPE;
5806: lv_as_items_rowid VARCHAR2(25);
5807: lv_as_rowid VARCHAR2(25);
5801: DECLARE
5802: lv_diff_amount igs_fi_fee_as_items.amount%type := 0;
5803: lv_sum_diff igs_fi_fee_as_items.amount%type := 0;
5804: lv_as_record_ins boolean := FALSE;
5805: lv_fee_ass_item_id IGS_FI_FEE_AS_ITEMS.fee_ass_item_id%TYPE;
5806: lv_as_items_rowid VARCHAR2(25);
5807: lv_as_rowid VARCHAR2(25);
5808: lv_sum_old_amount igs_fi_fee_as_all.transaction_amount%TYPE := 0;
5809: lv_sum_new_amount igs_fi_fee_as_all.transaction_amount%TYPE := 0;
6108: lv_as_items_rowid := NULL;
6109: log_to_fnd( p_v_module => 'finpl_ins_fee_ass',
6110: p_v_string => 'Inserting Fee Assessment Items Record.');
6111:
6112: igs_fi_fee_as_items_pkg.insert_row(
6113: x_rowid => lv_as_items_rowid,
6114: x_fee_ass_item_id => lv_fee_ass_item_id,
6115: x_transaction_id => v_fa_sequence_number,
6116: x_person_id => t_fee_as_items(i).person_id,
6189: END LOOP;
6190:
6191: log_to_fnd( p_v_module => 'finpl_ins_fee_ass',
6192: p_v_string => 'Checking if Header and Lines match, calling finpl_check_header_lines');
6193: -- Check if records have been created correctly in IGS_FI_FEE_AS and IGS_FI_FEE_AS_ITEMS
6194: IF NOT finpl_check_header_lines(p_person_id,v_fa_sequence_number) THEN
6195: -- Any error in Header and Lines records, raise error
6196: log_to_fnd( p_v_module => 'finpl_ins_fee_ass',
6197: p_v_string => 'Header and Lines do not match, RAISE e_unexpected_error');
6246: p_unit_version_number igs_en_su_attempt_h_all.version_number%TYPE,
6247: p_cal_type igs_en_su_attempt_h_all.CAL_TYPE%TYPE,
6248: p_effective_start_dt igs_en_su_attempt_h_all.hist_start_dt%TYPE,
6249: p_effective_end_dt igs_en_su_attempt_h_all.hist_end_dt%TYPE,
6250: p_eftsu igs_fi_fee_as_items.eftsu%TYPE,
6251: p_credit_points igs_fi_fee_as_items.credit_points%TYPE,
6252: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
6253: p_charge_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE,
6254: p_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ,
6247: p_cal_type igs_en_su_attempt_h_all.CAL_TYPE%TYPE,
6248: p_effective_start_dt igs_en_su_attempt_h_all.hist_start_dt%TYPE,
6249: p_effective_end_dt igs_en_su_attempt_h_all.hist_end_dt%TYPE,
6250: p_eftsu igs_fi_fee_as_items.eftsu%TYPE,
6251: p_credit_points igs_fi_fee_as_items.credit_points%TYPE,
6252: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
6253: p_charge_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE,
6254: p_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ,
6255: p_fee_cat IGS_FI_FEE_AS_ITEMS.FEE_CAT%TYPE,
6250: p_eftsu igs_fi_fee_as_items.eftsu%TYPE,
6251: p_credit_points igs_fi_fee_as_items.credit_points%TYPE,
6252: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
6253: p_charge_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE,
6254: p_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ,
6255: p_fee_cat IGS_FI_FEE_AS_ITEMS.FEE_CAT%TYPE,
6256: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.FEE_CAL_TYPE%TYPE,
6257: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
6258: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
6251: p_credit_points igs_fi_fee_as_items.credit_points%TYPE,
6252: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
6253: p_charge_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE,
6254: p_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ,
6255: p_fee_cat IGS_FI_FEE_AS_ITEMS.FEE_CAT%TYPE,
6256: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.FEE_CAL_TYPE%TYPE,
6257: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
6258: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
6259: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
6252: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
6253: p_charge_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE,
6254: p_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ,
6255: p_fee_cat IGS_FI_FEE_AS_ITEMS.FEE_CAT%TYPE,
6256: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.FEE_CAL_TYPE%TYPE,
6257: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
6258: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
6259: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
6260: p_ci_sequence_number IGS_FI_FEE_AS_ITEMS.ci_sequence_number%TYPE,
6253: p_charge_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE,
6254: p_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ,
6255: p_fee_cat IGS_FI_FEE_AS_ITEMS.FEE_CAT%TYPE,
6256: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.FEE_CAL_TYPE%TYPE,
6257: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
6258: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
6259: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
6260: p_ci_sequence_number IGS_FI_FEE_AS_ITEMS.ci_sequence_number%TYPE,
6261: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE,
6254: p_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ,
6255: p_fee_cat IGS_FI_FEE_AS_ITEMS.FEE_CAT%TYPE,
6256: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.FEE_CAL_TYPE%TYPE,
6257: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
6258: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
6259: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
6260: p_ci_sequence_number IGS_FI_FEE_AS_ITEMS.ci_sequence_number%TYPE,
6261: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE,
6262: p_ret_true_flag OUT NOCOPY BOOLEAN,
6255: p_fee_cat IGS_FI_FEE_AS_ITEMS.FEE_CAT%TYPE,
6256: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.FEE_CAL_TYPE%TYPE,
6257: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
6258: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
6259: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
6260: p_ci_sequence_number IGS_FI_FEE_AS_ITEMS.ci_sequence_number%TYPE,
6261: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE,
6262: p_ret_true_flag OUT NOCOPY BOOLEAN,
6263: p_message_name OUT NOCOPY VARCHAR2,
6256: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.FEE_CAL_TYPE%TYPE,
6257: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
6258: p_unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
6259: p_location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
6260: p_ci_sequence_number IGS_FI_FEE_AS_ITEMS.ci_sequence_number%TYPE,
6261: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE,
6262: p_ret_true_flag OUT NOCOPY BOOLEAN,
6263: p_message_name OUT NOCOPY VARCHAR2,
6264: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
6261: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE,
6262: p_ret_true_flag OUT NOCOPY BOOLEAN,
6263: p_message_name OUT NOCOPY VARCHAR2,
6264: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
6265: p_uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
6266: p_unit_course_cd igs_ps_ver_all.course_cd%TYPE,
6267: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
6268: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
6269: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE
6263: p_message_name OUT NOCOPY VARCHAR2,
6264: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
6265: p_uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
6266: p_unit_course_cd igs_ps_ver_all.course_cd%TYPE,
6267: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
6268: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
6269: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE
6270: ) RETURN BOOLEAN AS
6271: -- added the parameter p_s_fee_trigger_cat Bug# 1906022
6264: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
6265: p_uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
6266: p_unit_course_cd igs_ps_ver_all.course_cd%TYPE,
6267: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
6268: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
6269: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE
6270: ) RETURN BOOLEAN AS
6271: -- added the parameter p_s_fee_trigger_cat Bug# 1906022
6272: -- since certain processing here would vary for the fee trigger
6265: p_uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
6266: p_unit_course_cd igs_ps_ver_all.course_cd%TYPE,
6267: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
6268: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
6269: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE
6270: ) RETURN BOOLEAN AS
6271: -- added the parameter p_s_fee_trigger_cat Bug# 1906022
6272: -- since certain processing here would vary for the fee trigger
6273: -- generally special handling for INSTITUTN trigger
6273: -- generally special handling for INSTITUTN trigger
6274: BEGIN
6275: DECLARE
6276: v_message_name VARCHAR2(30);
6277: v_derived_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE;
6278:
6279: l_v_no_assessment_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
6280: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
6281: l_n_credit_points igs_fi_fee_as_items.credit_points%TYPE;
6276: v_message_name VARCHAR2(30);
6277: v_derived_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE;
6278:
6279: l_v_no_assessment_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
6280: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
6281: l_n_credit_points igs_fi_fee_as_items.credit_points%TYPE;
6282:
6283:
6284: CURSOR c_unit_class_att (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
6277: v_derived_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE;
6278:
6279: l_v_no_assessment_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
6280: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
6281: l_n_credit_points igs_fi_fee_as_items.credit_points%TYPE;
6282:
6283:
6284: CURSOR c_unit_class_att (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
6285: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
6704: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
6705: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
6706: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE,
6707: p_message_name OUT NOCOPY VARCHAR2,
6708: p_location_cd IGS_FI_FEE_AS_ITEMS.LOCATION_CD%TYPE,
6709: p_c_career igs_ps_ver_all.course_type%TYPE,
6710: p_n_selection_rule IN igs_ru_rule.sequence_number%TYPE
6711: )
6712: RETURN BOOLEAN AS
6736: v_credit_points igs_fi_fee_as_all.chg_elements%TYPE;
6737: v_ret_true_flag BOOLEAN;
6738: v_trigger_fired fnd_lookup_values.lookup_code%TYPE;
6739: v_message_name VARCHAR2(30);
6740: v_derived_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE;
6741: v_derived_location_cd IGS_FI_FEE_AS_ITEMS.LOCATION_CD%TYPE;
6742: l_eftsu NUMBER;
6743: l_crpoint NUMBER;
6744:
6737: v_ret_true_flag BOOLEAN;
6738: v_trigger_fired fnd_lookup_values.lookup_code%TYPE;
6739: v_message_name VARCHAR2(30);
6740: v_derived_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE;
6741: v_derived_location_cd IGS_FI_FEE_AS_ITEMS.LOCATION_CD%TYPE;
6742: l_eftsu NUMBER;
6743: l_crpoint NUMBER;
6744:
6745: l_v_fee_ass_ind VARCHAR2(1) := NULL;
6743: l_crpoint NUMBER;
6744:
6745: l_v_fee_ass_ind VARCHAR2(1) := NULL;
6746:
6747: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
6748: l_n_credit_points igs_fi_fee_as_items.credit_points%TYPE;
6749:
6750: l_b_sca_liable_fcfl BOOLEAN;
6751: l_v_prg_liabale VARCHAR2(10);
6744:
6745: l_v_fee_ass_ind VARCHAR2(1) := NULL;
6746:
6747: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
6748: l_n_credit_points igs_fi_fee_as_items.credit_points%TYPE;
6749:
6750: l_b_sca_liable_fcfl BOOLEAN;
6751: l_v_prg_liabale VARCHAR2(10);
6752:
6930: WHERE fee_type = cp_v_fee_type
6931: AND fee_cal_type = cp_v_fee_cal_type
6932: AND fee_ci_sequence_number = cp_n_fee_ci_seq_number;
6933:
6934: CURSOR cur_unit_cd (cp_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE) IS
6935: SELECT unit_cd, version_number
6936: FROM igs_ps_unit_ofr_opt_all
6937: WHERE uoo_id = cp_n_uoo_id;
6938:
6969: l_v_fee_cat VARCHAR2(30);
6970: l_v_location_cd VARCHAR2(30);
6971: l_v_org_unit_cd VARCHAR2(30);
6972: l_v_nz_bill_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE;
6973: l_n_crs_version_number igs_fi_Fee_as_items.crs_version_number%TYPE;
6974:
6975: l_n_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;
6976: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;
6977: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
7915: 'OLD' source,
7916: ast.elm_rng_order_name,
7917: ast.scope_rul_sequence_num,
7918: ast.max_chg_elements
7919: FROM igs_fi_fee_as_items ast,
7920: igs_fi_fee_as_all fas,
7921: igs_fi_fee_type_all ft,
7922: igs_ps_ver_all ps
7923: WHERE ast.person_id = p_person_id
7998:
7999: l_v_liable VARCHAR2(10) := 'FALSE';
8000:
8001: FUNCTION finpl_init_fee_ass_item (
8002: p_person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
8003: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
8004: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
8005: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
8006: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
7999: l_v_liable VARCHAR2(10) := 'FALSE';
8000:
8001: FUNCTION finpl_init_fee_ass_item (
8002: p_person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
8003: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
8004: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
8005: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
8006: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
8007: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
8000:
8001: FUNCTION finpl_init_fee_ass_item (
8002: p_person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
8003: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
8004: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
8005: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
8006: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
8007: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
8008: p_effective_date DATE,
8001: FUNCTION finpl_init_fee_ass_item (
8002: p_person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
8003: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
8004: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
8005: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
8006: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
8007: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
8008: p_effective_date DATE,
8009: p_trace_on VARCHAR2,
8002: p_person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
8003: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
8004: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
8005: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
8006: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
8007: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
8008: p_effective_date DATE,
8009: p_trace_on VARCHAR2,
8010: p_c_career igs_ps_ver_all.course_type%TYPE)
8003: p_fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
8004: P_fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
8005: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
8006: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
8007: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
8008: p_effective_date DATE,
8009: p_trace_on VARCHAR2,
8010: p_c_career igs_ps_ver_all.course_type%TYPE)
8011: RETURN BOOLEAN
8024: Added unit_set_cd and us_version_number to plsql table
8025: (reverse chronological order - newest change first)
8026: ***************************************************************/
8027: v_message_name VARCHAR2(30);
8028: ln_fee_ass_item_id igs_fi_fee_as_items.fee_ass_item_id%TYPE;
8029: lv_fee_trg_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE;
8030: lv_chg_method IGS_FI_FEE_AS_ITEMS.S_Chg_Method_Type%TYPE;
8031:
8032:
8026: ***************************************************************/
8027: v_message_name VARCHAR2(30);
8028: ln_fee_ass_item_id igs_fi_fee_as_items.fee_ass_item_id%TYPE;
8029: lv_fee_trg_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE;
8030: lv_chg_method IGS_FI_FEE_AS_ITEMS.S_Chg_Method_Type%TYPE;
8031:
8032:
8033: CURSOR c_fee_type( cp_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ) IS
8034: SELECT description,
8029: lv_fee_trg_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE;
8030: lv_chg_method IGS_FI_FEE_AS_ITEMS.S_Chg_Method_Type%TYPE;
8031:
8032:
8033: CURSOR c_fee_type( cp_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ) IS
8034: SELECT description,
8035: s_fee_trigger_cat
8036: FROM igs_fi_fee_type_all
8037: WHERE fee_type = cp_fee_type;
8048: AND fee_cal_type = cp_fee_cal_type
8049: AND fee_ci_sequence_number = cp_fee_ci_sequence_number;
8050:
8051: -- Enh# 3167098, Removed the context of Fee Category when selecting as Fee Cat can be changed after assessment.
8052: CURSOR c_as_items (cp_person_id igs_fi_fee_as_items.person_id%TYPE,
8053: cp_fee_type igs_fi_fee_as_items.fee_type%TYPE ,
8054: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8055: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8056: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8049: AND fee_ci_sequence_number = cp_fee_ci_sequence_number;
8050:
8051: -- Enh# 3167098, Removed the context of Fee Category when selecting as Fee Cat can be changed after assessment.
8052: CURSOR c_as_items (cp_person_id igs_fi_fee_as_items.person_id%TYPE,
8053: cp_fee_type igs_fi_fee_as_items.fee_type%TYPE ,
8054: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8055: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8056: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8057: cp_career igs_ps_ver_all.course_type%TYPE,
8050:
8051: -- Enh# 3167098, Removed the context of Fee Category when selecting as Fee Cat can be changed after assessment.
8052: CURSOR c_as_items (cp_person_id igs_fi_fee_as_items.person_id%TYPE,
8053: cp_fee_type igs_fi_fee_as_items.fee_type%TYPE ,
8054: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8055: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8056: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8057: cp_career igs_ps_ver_all.course_type%TYPE,
8058: cp_s_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
8051: -- Enh# 3167098, Removed the context of Fee Category when selecting as Fee Cat can be changed after assessment.
8052: CURSOR c_as_items (cp_person_id igs_fi_fee_as_items.person_id%TYPE,
8053: cp_fee_type igs_fi_fee_as_items.fee_type%TYPE ,
8054: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8055: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8056: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8057: cp_career igs_ps_ver_all.course_type%TYPE,
8058: cp_s_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
8059: cp_v_s_transaction_type1 igs_fi_fee_as_all.s_transaction_type%TYPE,
8052: CURSOR c_as_items (cp_person_id igs_fi_fee_as_items.person_id%TYPE,
8053: cp_fee_type igs_fi_fee_as_items.fee_type%TYPE ,
8054: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8055: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8056: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8057: cp_career igs_ps_ver_all.course_type%TYPE,
8058: cp_s_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
8059: cp_v_s_transaction_type1 igs_fi_fee_as_all.s_transaction_type%TYPE,
8060: cp_v_s_transaction_type2 igs_fi_fee_as_all.s_transaction_type%TYPE
8068: SUM(a.eftsu) sum_eftsu,
8069: a.org_unit_cd,
8070: a.uoo_id,
8071: a.fee_cat
8072: FROM igs_fi_fee_as_items a,
8073: igs_ps_ver_all ps
8074: WHERE a.course_cd = ps.course_cd (+)
8075: AND a.crs_version_number = ps.version_number (+)
8076: AND a.person_id = cp_person_id
8121: a.location_cd,
8122: a.org_unit_cd;
8123:
8124: -- Cursor to select all charges created if is is 'Institution' Fee and the charge method identified is 'Flat Rate'
8125: CURSOR c_as_inst_items (cp_person_id igs_fi_fee_as_items.person_id%TYPE,
8126: cp_fee_type igs_fi_fee_as_items.fee_type%TYPE,
8127: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8128: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8129: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8122: a.org_unit_cd;
8123:
8124: -- Cursor to select all charges created if is is 'Institution' Fee and the charge method identified is 'Flat Rate'
8125: CURSOR c_as_inst_items (cp_person_id igs_fi_fee_as_items.person_id%TYPE,
8126: cp_fee_type igs_fi_fee_as_items.fee_type%TYPE,
8127: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8128: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8129: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8130: cp_v_s_transaction_type1 igs_fi_fee_as_all.s_transaction_type%TYPE,
8123:
8124: -- Cursor to select all charges created if is is 'Institution' Fee and the charge method identified is 'Flat Rate'
8125: CURSOR c_as_inst_items (cp_person_id igs_fi_fee_as_items.person_id%TYPE,
8126: cp_fee_type igs_fi_fee_as_items.fee_type%TYPE,
8127: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8128: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8129: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8130: cp_v_s_transaction_type1 igs_fi_fee_as_all.s_transaction_type%TYPE,
8131: cp_v_s_transaction_type2 igs_fi_fee_as_all.s_transaction_type%TYPE
8124: -- Cursor to select all charges created if is is 'Institution' Fee and the charge method identified is 'Flat Rate'
8125: CURSOR c_as_inst_items (cp_person_id igs_fi_fee_as_items.person_id%TYPE,
8126: cp_fee_type igs_fi_fee_as_items.fee_type%TYPE,
8127: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8128: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8129: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8130: cp_v_s_transaction_type1 igs_fi_fee_as_all.s_transaction_type%TYPE,
8131: cp_v_s_transaction_type2 igs_fi_fee_as_all.s_transaction_type%TYPE
8132: ) IS
8125: CURSOR c_as_inst_items (cp_person_id igs_fi_fee_as_items.person_id%TYPE,
8126: cp_fee_type igs_fi_fee_as_items.fee_type%TYPE,
8127: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8128: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8129: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8130: cp_v_s_transaction_type1 igs_fi_fee_as_all.s_transaction_type%TYPE,
8131: cp_v_s_transaction_type2 igs_fi_fee_as_all.s_transaction_type%TYPE
8132: ) IS
8133:
8140: SUM(a.eftsu) sum_eftsu,
8141: a.org_unit_cd,
8142: a.uoo_id,
8143: a.fee_cat
8144: FROM igs_fi_fee_as_items a
8145: WHERE a.person_id = cp_person_id AND
8146: a.fee_type = cp_fee_type AND
8147: a.fee_cal_type = cp_fee_cal_type AND
8148: a.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
8174: cp_career igs_ps_ver_all.course_type%TYPE) IS
8175:
8176: SELECT a.fee_ass_item_id upd,
8177: a.s_chg_method_type
8178: FROM igs_fi_fee_as_items a,
8179: igs_ps_ver_all ps
8180: WHERE a.course_cd = ps.course_cd (+)
8181: AND a.crs_version_number = ps.version_number (+)
8182: AND a.person_id = cp_person_id
9137: IGS_GE_MSG_STACK.ADD;
9138: App_Exception.Raise_Exception;
9139: END finpl_prc_fee_cat_fee_liab;
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,
9198:
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,
9261:
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,
10908: /*************************************************************
10909: Created By : Priya Athipatla
10910: Date Created By : 01-Jul-2004
10911: Purpose : This function checks if a header in IGS_FI_FEE_AS and
10912: line records in IGS_FI_FEE_AS_ITEMS have been created
10913: correctly or not.
10914:
10915: Know limitations, enhancements or remarks
10916: Change History
10925:
10926: CURSOR cur_fee_as_items(cp_n_person_id igs_fi_fee_as_all.person_id%TYPE,
10927: cp_n_transaction_id igs_fi_fee_as_all.transaction_id%TYPE) IS
10928: SELECT amount
10929: FROM igs_fi_fee_as_items
10930: WHERE person_id = cp_n_person_id
10931: AND transaction_id = cp_n_transaction_id;
10932:
10933: l_n_lines_sum NUMBER := 0.0;
10952: RETURN FALSE;
10953: END IF;
10954: CLOSE cur_fee_as;
10955:
10956: -- Loop through Line records and obtain total amount in IGS_FI_FEE_AS_ITEMS
10957: FOR l_rec_fee_as_items IN cur_fee_as_items(p_n_person_id, p_n_transaction_id) LOOP
10958: l_b_line_exists := TRUE;
10959: -- 'Amount' is a Nullable column, so check for Null
10960: IF l_rec_fee_as_items.amount IS NULL THEN
10958: l_b_line_exists := TRUE;
10959: -- 'Amount' is a Nullable column, so check for Null
10960: IF l_rec_fee_as_items.amount IS NULL THEN
10961: log_to_fnd( p_v_module => 'finpl_check_header_lines',
10962: p_v_string => 'Amount in IGS_FI_FEE_AS_ITEMS is NULL for Person ID: '||p_n_person_id||
10963: ' and Transaction ID: '||p_n_transaction_id||
10964: '. Returning FALSE');
10965: RETURN FALSE;
10966: ELSE
10968: l_n_lines_sum := l_n_lines_sum + l_rec_fee_as_items.amount;
10969: END IF;
10970: END LOOP;
10971:
10972: -- Check if atleast one line record was found in IGS_FI_FEE_AS_ITEMS for the given transaction
10973: IF NOT l_b_line_exists THEN
10974: log_to_fnd( p_v_module => 'finpl_check_header_lines',
10975: p_v_string => 'Record not found in IGS_FI_FEE_AS_ITEMS for Person ID: '||p_n_person_id||
10976: ' and Transaction ID: '||p_n_transaction_id||' Returning FALSE');
10971:
10972: -- Check if atleast one line record was found in IGS_FI_FEE_AS_ITEMS for the given transaction
10973: IF NOT l_b_line_exists THEN
10974: log_to_fnd( p_v_module => 'finpl_check_header_lines',
10975: p_v_string => 'Record not found in IGS_FI_FEE_AS_ITEMS for Person ID: '||p_n_person_id||
10976: ' and Transaction ID: '||p_n_transaction_id||' Returning FALSE');
10977: RETURN FALSE;
10978: END IF;
10979:
11026: Who When What
11027: abshriva 24-May-2006 Bug 5204728: Introduced p_trace_on in parameter list.
11028: abshriva 12-May-2006 Bug 5217319: Amount Precision change, added API call to allow correct precison into DB
11029: bannamal 03-Jun-2005 Bug#3442712 Unit Level Fee Assessment Build. Modified the call
11030: to igs_fi_fee_as_items_pkg.insert_row added new parameters
11031: unit_type_id, unit_class, unit_mode and unit_level.
11032:
11033: ***************************************************************/
11034:
11038: l_n_transaction_id igs_fi_fee_as_all.transaction_id%TYPE := NULL;
11039: l_v_fee_cat igs_fi_fee_as_all.fee_cat%TYPE := NULL;
11040: l_v_course_cd igs_fi_fee_as_all.course_cd%TYPE := NULL;
11041: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE := NULL;
11042: l_n_fee_ass_item_id igs_fi_fee_as_items.fee_ass_item_id%TYPE := NULL;
11043:
11044: l_header_rec igs_fi_charges_api_pvt.header_rec_type;
11045: l_line_rec igs_fi_charges_api_pvt.line_tbl_type;
11046: l_line_rec_dummy igs_fi_charges_api_pvt.line_tbl_type;
11167: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_CHG_NUM') || ': ' || l_v_invoice_num);
11168: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_CHG_AMT') || ': ' || TO_CHAR(p_n_amount));
11169: fnd_file.new_line(fnd_file.log);
11170: END IF;
11171: -- Call the TBH for inserting record in IGS_FI_FEE_AS_ITEMS if Charges API returned successfully
11172: -- Modified fee_effective_dt entry as Trunc(Sysdate) as part of Bug 4240402: Timezone impact
11173: l_rowid := NULL;
11174: l_n_fee_ass_item_id := NULL;
11175: log_to_fnd( p_v_module => 'create_retention_charge',
11173: l_rowid := NULL;
11174: l_n_fee_ass_item_id := NULL;
11175: log_to_fnd( p_v_module => 'create_retention_charge',
11176: p_v_string => 'Inserting Fee Assessment Items Record for Rentention charge.');
11177: igs_fi_fee_as_items_pkg.insert_row( x_rowid => l_rowid,
11178: x_fee_ass_item_id => l_n_fee_ass_item_id,
11179: x_transaction_id => l_n_transaction_id,
11180: x_person_id => p_n_person_id,
11181: x_status => 'E',