eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_FI_F_TYP_CA_INST_ALL

Line 390: p_charge_method IN igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE ,

386: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
387: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,
388: p_s_fee_trigger_cat IN VARCHAR2 ,
389: p_rul_sequence_number IN igs_fi_f_cat_fee_lbl_all.rul_sequence_number%TYPE ,
390: p_charge_method IN igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE ,
391: p_location_cd IN VARCHAR2 ,
392: p_attendance_type IN VARCHAR2 ,
393: p_attendance_mode IN VARCHAR2 ,
394: p_trace_on IN VARCHAR2 ,

Line 400: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,

396: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE ,
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:

Line 856: p_v_retention_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,

852: p_n_uoo_id igs_fi_fai_dtls.uoo_id%TYPE,
853: p_trace_on VARCHAR2,
854: p_d_gl_date igs_fi_invln_int_all.gl_date%TYPE,
855: p_n_diff_amount NUMBER,
856: p_v_retention_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
857: p_v_cmp_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE,
858: p_v_fee_type_desc igs_fi_fee_type_all.description%TYPE,
859: p_v_fee_trig_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE
860: ) AS

Line 857: p_v_cmp_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE,

853: p_trace_on VARCHAR2,
854: p_d_gl_date igs_fi_invln_int_all.gl_date%TYPE,
855: p_n_diff_amount NUMBER,
856: p_v_retention_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
857: p_v_cmp_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE,
858: p_v_fee_type_desc igs_fi_fee_type_all.description%TYPE,
859: p_v_fee_trig_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE
860: ) AS
861: /*************************************************************

Line 1458: p_charge_method IN igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE ,

1454: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
1455: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,
1456: p_s_fee_trigger_cat IN VARCHAR2 ,
1457: p_rul_sequence_number IN igs_fi_f_cat_fee_lbl_all.rul_sequence_number%TYPE ,
1458: p_charge_method IN igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE ,
1459: p_location_cd IN VARCHAR2 ,
1460: p_attendance_type IN VARCHAR2 ,
1461: p_attendance_mode IN VARCHAR2 ,
1462: p_trace_on IN VARCHAR2 ,

Line 1468: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,

1464: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE ,
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 :

Line 1547: l_overide_chg_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE;

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:

Line 1584: CURSOR c_elm_rng_rates ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

1580:
1581: v_fee_type_description igs_fi_fee_type_all.description%TYPE;
1582:
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,

Line 1585: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

1581: v_fee_type_description igs_fi_fee_type_all.description%TYPE;
1582:
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

Line 1586: cp_n_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,

1582:
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,

Line 2829: CURSOR c_elm_ranges ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

2825: l_v_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE;
2826: l_b_elm_range_rate_match BOOLEAN := FALSE; /* To check whether global element range rate matches or not*/
2827:
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,

Line 2830: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

2826: l_b_elm_range_rate_match BOOLEAN := FALSE; /* To check whether global element range rate matches or not*/
2827:
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,

Line 2831: cp_n_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,

2827:
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,

Line 2848: CURSOR c_elm_rng_rates ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

2844: AND logical_delete_dt IS NULL
2845: ORDER BY lower_range ASC;
2846:
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,

Line 2849: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

2845: ORDER BY lower_range ASC;
2846:
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

Line 2850: cp_n_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,

2846:
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.*

Line 2901: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

2897: FROM igs_ps_ver_all v
2898: WHERE v.course_cd = cp_course_cd
2899: AND v.version_number = cp_version_number;
2900:
2901: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
2902: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
2903: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
2904: SELECT retention_level_code
2905: FROM igs_fi_f_typ_ca_inst_all

Line 2902: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

2898: WHERE v.course_cd = cp_course_cd
2899: AND v.version_number = cp_version_number;
2900:
2901: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
2902: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
2903: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
2904: SELECT retention_level_code
2905: FROM igs_fi_f_typ_ca_inst_all
2906: WHERE fee_type = cp_v_fee_type

Line 2903: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS

2899: AND v.version_number = cp_version_number;
2900:
2901: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
2902: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
2903: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
2904: SELECT retention_level_code
2905: FROM igs_fi_f_typ_ca_inst_all
2906: WHERE fee_type = cp_v_fee_type
2907: AND fee_cal_type = cp_v_fee_cal_type

Line 2905: FROM igs_fi_f_typ_ca_inst_all

2901: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
2902: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
2903: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
2904: SELECT retention_level_code
2905: FROM igs_fi_f_typ_ca_inst_all
2906: WHERE fee_type = cp_v_fee_type
2907: AND fee_cal_type = cp_v_fee_cal_type
2908: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_num;
2909:

Line 2924: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;

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;
2926:
2927: BEGIN
2928:

Line 4983: p_elm_rng_order_name igs_fi_f_typ_ca_inst_all.elm_rng_order_name%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,
4986: p_n_max_chg_elements igs_fi_fee_as_items.max_chg_elements%TYPE
4987: ) AS

Line 5010: l_v_retention_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE := NULL;

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.
5008: *********************************************************************************************************/
5009: -- Local variables
5010: l_v_retention_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE := NULL;
5011: l_v_cmp_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE := NULL;
5012: l_n_diff_amount NUMBER := 0.0;
5013: l_n_retention_amount NUMBER := 0.0;
5014: l_v_fee_type_desc igs_fi_fee_type_all.description%TYPE := NULL;

Line 5011: l_v_cmp_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE := NULL;

5007: as there is no negative adjustment charge crated by Retention.
5008: *********************************************************************************************************/
5009: -- Local variables
5010: l_v_retention_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE := NULL;
5011: l_v_cmp_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE := NULL;
5012: l_n_diff_amount NUMBER := 0.0;
5013: l_n_retention_amount NUMBER := 0.0;
5014: l_v_fee_type_desc igs_fi_fee_type_all.description%TYPE := NULL;
5015: l_v_fee_trig_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE := NULL;

Line 5032: CURSOR cur_nz_bill_cp_flag ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

5028: WHERE fee_type = cp_v_fee_type;
5029:
5030: --- Cursor for getting nonzero_billable_cp_flag from ftci
5031:
5032: CURSOR cur_nz_bill_cp_flag ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
5033: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
5034: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE )IS
5035: SELECT nonzero_billable_cp_flag
5036: FROM igs_fi_f_typ_ca_inst_all

Line 5033: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

5029:
5030: --- Cursor for getting nonzero_billable_cp_flag from ftci
5031:
5032: CURSOR cur_nz_bill_cp_flag ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
5033: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
5034: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE )IS
5035: SELECT nonzero_billable_cp_flag
5036: FROM igs_fi_f_typ_ca_inst_all
5037: WHERE fee_type = cp_v_fee_type

Line 5034: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE )IS

5030: --- Cursor for getting nonzero_billable_cp_flag from ftci
5031:
5032: CURSOR cur_nz_bill_cp_flag ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
5033: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
5034: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE )IS
5035: SELECT nonzero_billable_cp_flag
5036: FROM igs_fi_f_typ_ca_inst_all
5037: WHERE fee_type = cp_v_fee_type
5038: AND fee_cal_type = cp_v_fee_cal_type

Line 5036: FROM igs_fi_f_typ_ca_inst_all

5032: CURSOR cur_nz_bill_cp_flag ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
5033: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
5034: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE )IS
5035: SELECT nonzero_billable_cp_flag
5036: FROM igs_fi_f_typ_ca_inst_all
5037: WHERE fee_type = cp_v_fee_type
5038: AND fee_cal_type = cp_v_fee_cal_type
5039: AND fee_ci_sequence_number = cp_n_fee_ci_seq_number;
5040:

Line 5097: l_v_nz_bill_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE;

5093: FROM igs_ps_unit_ofr_opt_all
5094: WHERE uoo_id = cp_n_uoo_id;
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;

Line 5670: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%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:
5673: /*************************************************************************************************
5674: CHANGE HISTORY:

Line 5739: l_v_elm_rng_ord_name igs_fi_f_typ_ca_inst_all.elm_rng_order_name%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;
5739: l_v_elm_rng_ord_name igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE;
5740: l_v_chg_mthd_typ igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE;
5741: l_v_invoice_num igs_fi_inv_int_all.invoice_number%TYPE;
5742: l_n_waiver_amt NUMBER;
5743:

Line 6253: p_charge_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%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,
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,

Line 6925: CURSOR cur_nz_bill_cp_flag ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

6921: AND lkps.fee_ass_ind = cp_v_fee_ass_ind;
6922:
6923: --- Cursor for getting nonzero_billable_cp_flag from ftci
6924:
6925: CURSOR cur_nz_bill_cp_flag ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
6926: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
6927: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE ) IS
6928: SELECT nonzero_billable_cp_flag
6929: FROM igs_fi_f_typ_ca_inst_all

Line 6926: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

6922:
6923: --- Cursor for getting nonzero_billable_cp_flag from ftci
6924:
6925: CURSOR cur_nz_bill_cp_flag ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
6926: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
6927: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE ) IS
6928: SELECT nonzero_billable_cp_flag
6929: FROM igs_fi_f_typ_ca_inst_all
6930: WHERE fee_type = cp_v_fee_type

Line 6927: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE ) IS

6923: --- Cursor for getting nonzero_billable_cp_flag from ftci
6924:
6925: CURSOR cur_nz_bill_cp_flag ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
6926: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
6927: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE ) IS
6928: SELECT nonzero_billable_cp_flag
6929: FROM igs_fi_f_typ_ca_inst_all
6930: WHERE fee_type = cp_v_fee_type
6931: AND fee_cal_type = cp_v_fee_cal_type

Line 6929: FROM igs_fi_f_typ_ca_inst_all

6925: CURSOR cur_nz_bill_cp_flag ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
6926: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
6927: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE ) IS
6928: SELECT nonzero_billable_cp_flag
6929: FROM igs_fi_f_typ_ca_inst_all
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:

Line 6939: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

6935: SELECT unit_cd, version_number
6936: FROM igs_ps_unit_ofr_opt_all
6937: WHERE uoo_id = cp_n_uoo_id;
6938:
6939: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
6940: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
6941: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
6942: SELECT retention_level_code
6943: FROM igs_fi_f_typ_ca_inst_all

Line 6940: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

6936: FROM igs_ps_unit_ofr_opt_all
6937: WHERE uoo_id = cp_n_uoo_id;
6938:
6939: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
6940: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
6941: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
6942: SELECT retention_level_code
6943: FROM igs_fi_f_typ_ca_inst_all
6944: WHERE fee_type = cp_v_fee_type

Line 6941: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS

6937: WHERE uoo_id = cp_n_uoo_id;
6938:
6939: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
6940: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
6941: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
6942: SELECT retention_level_code
6943: FROM igs_fi_f_typ_ca_inst_all
6944: WHERE fee_type = cp_v_fee_type
6945: AND fee_cal_type = cp_v_fee_cal_type

Line 6943: FROM igs_fi_f_typ_ca_inst_all

6939: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
6940: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
6941: cp_n_fee_ci_sequence_num igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
6942: SELECT retention_level_code
6943: FROM igs_fi_f_typ_ca_inst_all
6944: WHERE fee_type = cp_v_fee_type
6945: AND fee_cal_type = cp_v_fee_cal_type
6946: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_num;
6947:

Line 6972: l_v_nz_bill_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE;

6968: l_v_course_cd VARCHAR2(30);
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;

Line 6983: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;

6979: l_n_count NUMBER;
6980: l_b_rule BOOLEAN;
6981: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;
6982: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE;
6983: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;
6984: l_v_class_standing igs_fi_fee_as_rate.class_standing%TYPE;
6985: l_v_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
6986: l_n_us_version_num igs_as_su_setatmpt.us_version_number%TYPE;
6987:

Line 8039: l_n_scope_rul_seq_num igs_fi_f_typ_ca_inst_all.scope_rul_sequence_num%TYPE;

8035: s_fee_trigger_cat
8036: FROM igs_fi_fee_type_all
8037: WHERE fee_type = cp_fee_type;
8038: v_fee_type_description igs_fi_fee_type_all.description%type;
8039: l_n_scope_rul_seq_num igs_fi_f_typ_ca_inst_all.scope_rul_sequence_num%TYPE;
8040:
8041: CURSOR cur_chg_method1(cp_fee_type igs_fi_fee_as_all.fee_type%TYPE,
8042: cp_fee_cal_type igs_fi_fee_as_all.fee_cal_type%TYPE,
8043: cp_fee_ci_Sequence_number igs_fi_fee_as_all.fee_ci_sequence_number%TYPE) IS

Line 8046: FROM igs_fi_f_typ_ca_inst_all

8042: cp_fee_cal_type igs_fi_fee_as_all.fee_cal_type%TYPE,
8043: cp_fee_ci_Sequence_number igs_fi_fee_as_all.fee_ci_sequence_number%TYPE) IS
8044: SELECT s_chg_method_type,
8045: scope_rul_sequence_num
8046: FROM igs_fi_f_typ_ca_inst_all
8047: 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:

Line 9145: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

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,
9149: p_v_trace_on IN VARCHAR2,

Line 9146: p_n_fee_ci_sequence_num IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%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,
9149: p_v_trace_on IN VARCHAR2,
9150: p_b_record_found OUT NOCOPY BOOLEAN,