DBA Data[Home] [Help]

APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_FPS2_P

Line 848: l_cum_int := xtr_fps2_p.interest_round(l_cum_int, rounding_fac, l_rounding_type);

844: + l_prin_adj
845: * pmt.INTEREST_RATE / 100
846: * l_no_of_days -- Bug 1139396 (pmt.MATURITY_DATE - pmt.START_DATE)
847: / l_year_basis);
848: l_cum_int := xtr_fps2_p.interest_round(l_cum_int, rounding_fac, l_rounding_type);
849: else
850: l_cum_int := 0;
851: end if;
852: end if;

Line 869: pmt.INTEREST := xtr_fps2_p.interest_round(pmt.INTEREST, rounding_fac, l_rounding_type);

865: l_first_trans_flag);
866: if pmt.ADJUSTED_BALANCE >0 then --- add
867: pmt.INTEREST := (pmt.ADJUSTED_BALANCE * pmt.INTEREST_RATE / 100 *
868: pmt.NO_OF_DAYS / l_year_basis);
869: pmt.INTEREST := xtr_fps2_p.interest_round(pmt.INTEREST, rounding_fac, l_rounding_type);
870: else
871: pmt.INTEREST :=0;
872: end if;
873:

Line 916: l_exp_int := xtr_fps2_p.interest_round(l_exp_int, rounding_fac, l_rounding_type);

912: l_day_count_type,
913: l_first_trans_flag);
914: l_exp_int := (pmt.EXPECTED_BALANCE_OUT * pmt.INTEREST_RATE / 100
915: * l_no_of_days / l_year_basis);
916: l_exp_int := xtr_fps2_p.interest_round(l_exp_int, rounding_fac, l_rounding_type);
917: if nvl(l_cum_int,0) <> 0 then
918: l_exp_int := l_exp_int + l_cum_int;
919: l_cum_int := 0;
920: end if;

Line 983: hce_interest := xtr_fps2_p.interest_round(hce_interest, rounding_fac, l_rounding_type);

979: -- Calc HCE amounts
980: hce_decr := round(l_prin_decr / l_hce_rate,rounding_fac);
981: hce_balbf := round(pmt.BALANCE_OUT_BF / l_hce_rate,rounding_fac);
982: hce_interest := (pmt.INTEREST / l_hce_rate);
983: hce_interest := xtr_fps2_p.interest_round(hce_interest, rounding_fac, l_rounding_type);
984: hce_settled := round(pmt.INTEREST_SETTLED / l_hce_rate,rounding_fac);
985: hce_accum_int_bf := (pmt.ACCUM_INTEREST_BF / l_hce_rate);
986: hce_accum_int_bf := xtr_fps2_p.interest_round(hce_accum_int_bf, rounding_fac, l_rounding_type);
987: hce_princ := round(pmt.PRINCIPAL_ADJUST / l_hce_rate,rounding_fac);

Line 986: hce_accum_int_bf := xtr_fps2_p.interest_round(hce_accum_int_bf, rounding_fac, l_rounding_type);

982: hce_interest := (pmt.INTEREST / l_hce_rate);
983: hce_interest := xtr_fps2_p.interest_round(hce_interest, rounding_fac, l_rounding_type);
984: hce_settled := round(pmt.INTEREST_SETTLED / l_hce_rate,rounding_fac);
985: hce_accum_int_bf := (pmt.ACCUM_INTEREST_BF / l_hce_rate);
986: hce_accum_int_bf := xtr_fps2_p.interest_round(hce_accum_int_bf, rounding_fac, l_rounding_type);
987: hce_princ := round(pmt.PRINCIPAL_ADJUST / l_hce_rate,rounding_fac);
988: hce_balos := round(pmt.BALANCE_OUT / l_hce_rate,rounding_fac);
989: hce_accum_int := (pmt.ACCUM_INTEREST / l_hce_rate);
990: hce_accum_int := xtr_fps2_p.interest_round(hce_accum_int, rounding_fac, l_rounding_type);

Line 990: hce_accum_int := xtr_fps2_p.interest_round(hce_accum_int, rounding_fac, l_rounding_type);

986: hce_accum_int_bf := xtr_fps2_p.interest_round(hce_accum_int_bf, rounding_fac, l_rounding_type);
987: hce_princ := round(pmt.PRINCIPAL_ADJUST / l_hce_rate,rounding_fac);
988: hce_balos := round(pmt.BALANCE_OUT / l_hce_rate,rounding_fac);
989: hce_accum_int := (pmt.ACCUM_INTEREST / l_hce_rate);
990: hce_accum_int := xtr_fps2_p.interest_round(hce_accum_int, rounding_fac, l_rounding_type);
991: hce_due := round(pmt.PI_AMOUNT_DUE / l_hce_rate,rounding_fac);
992: --
993: update XTR_ROLLOVER_TRANSACTIONS_V
994: set START_DATE = pmt.START_DATE,