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_FIN_LT_CHG dependencies on IGS_FI_FIN_LT_PLAN

Line 53: CURSOR cur_plan(cp_plan_name igs_fi_fin_lt_plan.plan_name%TYPE) IS

49: -- person_id local function.
50: -------------------------------------------------------------------
51:
52: -- Global cursor, added NVL condition as part of Enh# 2562745.
53: CURSOR cur_plan(cp_plan_name igs_fi_fin_lt_plan.plan_name%TYPE) IS
54: SELECT *
55: FROM igs_fi_fin_lt_plan
56: WHERE plan_name= cp_plan_name
57: AND NVL(closed_ind,'N')='N';

Line 55: FROM igs_fi_fin_lt_plan

51:
52: -- Global cursor, added NVL condition as part of Enh# 2562745.
53: CURSOR cur_plan(cp_plan_name igs_fi_fin_lt_plan.plan_name%TYPE) IS
54: SELECT *
55: FROM igs_fi_fin_lt_plan
56: WHERE plan_name= cp_plan_name
57: AND NVL(closed_ind,'N')='N';
58:
59:

Line 71: g_v_flat_amt igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_AMOUNT';

67: g_last_conversion_date igs_fi_balance_rules.last_conversion_date%TYPE;
68: g_version_number igs_fi_balance_rules.version_number%TYPE;
69:
70: l_validation_exp exception;
71: g_v_flat_amt igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_AMOUNT';
72: g_v_flat_rate igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_RATE';
73: g_v_cutoff_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_CUTOFF_DT';
74: g_v_due_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_DUE_DT';
75: g_v_finance igs_fi_fin_lt_plan.plan_type%TYPE := 'INTEREST';

Line 72: g_v_flat_rate igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_RATE';

68: g_version_number igs_fi_balance_rules.version_number%TYPE;
69:
70: l_validation_exp exception;
71: g_v_flat_amt igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_AMOUNT';
72: g_v_flat_rate igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_RATE';
73: g_v_cutoff_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_CUTOFF_DT';
74: g_v_due_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_DUE_DT';
75: g_v_finance igs_fi_fin_lt_plan.plan_type%TYPE := 'INTEREST';
76: g_v_late igs_fi_fin_lt_plan.plan_type%TYPE := 'LATE';

Line 73: g_v_cutoff_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_CUTOFF_DT';

69:
70: l_validation_exp exception;
71: g_v_flat_amt igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_AMOUNT';
72: g_v_flat_rate igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_RATE';
73: g_v_cutoff_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_CUTOFF_DT';
74: g_v_due_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_DUE_DT';
75: g_v_finance igs_fi_fin_lt_plan.plan_type%TYPE := 'INTEREST';
76: g_v_late igs_fi_fin_lt_plan.plan_type%TYPE := 'LATE';
77: g_d_sysdate DATE := TRUNC(SYSDATE);

Line 74: g_v_due_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_DUE_DT';

70: l_validation_exp exception;
71: g_v_flat_amt igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_AMOUNT';
72: g_v_flat_rate igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_RATE';
73: g_v_cutoff_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_CUTOFF_DT';
74: g_v_due_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_DUE_DT';
75: g_v_finance igs_fi_fin_lt_plan.plan_type%TYPE := 'INTEREST';
76: g_v_late igs_fi_fin_lt_plan.plan_type%TYPE := 'LATE';
77: g_d_sysdate DATE := TRUNC(SYSDATE);
78: g_v_hor_line VARCHAR2(100) := RPAD('-',77,'-');

Line 75: g_v_finance igs_fi_fin_lt_plan.plan_type%TYPE := 'INTEREST';

71: g_v_flat_amt igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_AMOUNT';
72: g_v_flat_rate igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_RATE';
73: g_v_cutoff_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_CUTOFF_DT';
74: g_v_due_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_DUE_DT';
75: g_v_finance igs_fi_fin_lt_plan.plan_type%TYPE := 'INTEREST';
76: g_v_late igs_fi_fin_lt_plan.plan_type%TYPE := 'LATE';
77: g_d_sysdate DATE := TRUNC(SYSDATE);
78: g_v_hor_line VARCHAR2(100) := RPAD('-',77,'-');
79:

Line 76: g_v_late igs_fi_fin_lt_plan.plan_type%TYPE := 'LATE';

72: g_v_flat_rate igs_fi_fin_lt_plan.accrual_type%TYPE := 'FLAT_RATE';
73: g_v_cutoff_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_CUTOFF_DT';
74: g_v_due_dt igs_fi_fin_lt_plan.accrual_type%TYPE := 'AVG_DLY_BAL_DUE_DT';
75: g_v_finance igs_fi_fin_lt_plan.plan_type%TYPE := 'INTEREST';
76: g_v_late igs_fi_fin_lt_plan.plan_type%TYPE := 'LATE';
77: g_d_sysdate DATE := TRUNC(SYSDATE);
78: g_v_hor_line VARCHAR2(100) := RPAD('-',77,'-');
79:
80:

Line 153: FUNCTION validate_plan_name(p_plan_name IN igs_fi_fin_lt_plan.plan_name%TYPE)

149: RETURN FALSE;
150: END IF;
151: END validate_persid_grp;
152:
153: FUNCTION validate_plan_name(p_plan_name IN igs_fi_fin_lt_plan.plan_name%TYPE)
154: RETURN BOOLEAN AS
155: /***********************************************************************************************
156:
157: Created By : Sarakshi

Line 169: FROM igs_fi_fin_lt_plan

165: ********************************************************************************************** */
166:
167: CURSOR cur_val IS
168: SELECT 'X'
169: FROM igs_fi_fin_lt_plan
170: WHERE plan_name = p_plan_name
171: AND closed_ind = 'N';
172: l_temp VARCHAR2(1);
173: BEGIN

Line 767: l_n_min_chg_amt_no_chg igs_fi_fin_lt_plan.payment_plan_minchgamt_nochg%TYPE;

763: WHERE person_id = cp_n_person_id
764: ORDER BY bill_date DESC;
765:
766: l_cur_bill cur_bill%ROWTYPE;
767: l_n_min_chg_amt_no_chg igs_fi_fin_lt_plan.payment_plan_minchgamt_nochg%TYPE;
768: l_n_min_chrg_amt igs_fi_fin_lt_plan.payment_plan_min_charge_amt%TYPE;
769: l_n_max_chrg_amt igs_fi_fin_lt_plan.payment_plan_max_charge_amt%TYPE;
770: l_v_accrual_type igs_fi_fin_lt_plan.accrual_type%TYPE;
771: l_n_charge_amount NUMBER := 0;

Line 768: l_n_min_chrg_amt igs_fi_fin_lt_plan.payment_plan_min_charge_amt%TYPE;

764: ORDER BY bill_date DESC;
765:
766: l_cur_bill cur_bill%ROWTYPE;
767: l_n_min_chg_amt_no_chg igs_fi_fin_lt_plan.payment_plan_minchgamt_nochg%TYPE;
768: l_n_min_chrg_amt igs_fi_fin_lt_plan.payment_plan_min_charge_amt%TYPE;
769: l_n_max_chrg_amt igs_fi_fin_lt_plan.payment_plan_max_charge_amt%TYPE;
770: l_v_accrual_type igs_fi_fin_lt_plan.accrual_type%TYPE;
771: l_n_charge_amount NUMBER := 0;
772: l_b_chrg_flag BOOLEAN := TRUE;

Line 769: l_n_max_chrg_amt igs_fi_fin_lt_plan.payment_plan_max_charge_amt%TYPE;

765:
766: l_cur_bill cur_bill%ROWTYPE;
767: l_n_min_chg_amt_no_chg igs_fi_fin_lt_plan.payment_plan_minchgamt_nochg%TYPE;
768: l_n_min_chrg_amt igs_fi_fin_lt_plan.payment_plan_min_charge_amt%TYPE;
769: l_n_max_chrg_amt igs_fi_fin_lt_plan.payment_plan_max_charge_amt%TYPE;
770: l_v_accrual_type igs_fi_fin_lt_plan.accrual_type%TYPE;
771: l_n_charge_amount NUMBER := 0;
772: l_b_chrg_flag BOOLEAN := TRUE;
773:

Line 770: l_v_accrual_type igs_fi_fin_lt_plan.accrual_type%TYPE;

766: l_cur_bill cur_bill%ROWTYPE;
767: l_n_min_chg_amt_no_chg igs_fi_fin_lt_plan.payment_plan_minchgamt_nochg%TYPE;
768: l_n_min_chrg_amt igs_fi_fin_lt_plan.payment_plan_min_charge_amt%TYPE;
769: l_n_max_chrg_amt igs_fi_fin_lt_plan.payment_plan_max_charge_amt%TYPE;
770: l_v_accrual_type igs_fi_fin_lt_plan.accrual_type%TYPE;
771: l_n_charge_amount NUMBER := 0;
772: l_b_chrg_flag BOOLEAN := TRUE;
773:
774: BEGIN

Line 986: l_n_chg_rate igs_fi_fin_lt_plan.payment_plan_chg_rate%TYPE;

982:
983: l_b_grt_min_bal_amt BOOLEAN;
984: l_n_charge_amount NUMBER := 0;
985: l_d_effective_dt DATE;
986: l_n_chg_rate igs_fi_fin_lt_plan.payment_plan_chg_rate%TYPE;
987: l_b_chrg_flag BOOLEAN;
988: l_b_inst_exists BOOLEAN := FALSE;
989:
990: BEGIN

Line 1447: p_plan_name IN igs_fi_fin_lt_plan.plan_name%TYPE ,

1443: errbuf OUT NOCOPY VARCHAR2,
1444: retcode OUT NOCOPY NUMBER,
1445: p_person_id IN igs_pe_person.person_id%TYPE,
1446: p_pers_id_grp_id IN igs_pe_persid_group.group_id%TYPE,
1447: p_plan_name IN igs_fi_fin_lt_plan.plan_name%TYPE ,
1448: p_batch_cutoff_dt IN VARCHAR2,
1449: p_batch_due_dt IN VARCHAR2,
1450: p_fee_period IN VARCHAR2,
1451: p_chg_crtn_dt IN VARCHAR2,