DBA Data[Home] [Help]

APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_FPS2_P

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

1121: + l_prin_adj
1122: * pmt.INTEREST_RATE / 100
1123: * l_no_of_days -- Bug 1139396 (pmt.MATURITY_DATE - pmt.START_DATE)
1124: / l_year_basis);
1125: l_cum_int := xtr_fps2_p.interest_round(l_cum_int, rounding_fac, l_rounding_type);
1126: else
1127: l_cum_int := 0;
1128: end if;
1129: end if;

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

1142: l_first_trans_flag);
1143: if pmt.ADJUSTED_BALANCE >0 then --- add
1144: pmt.INTEREST := (pmt.ADJUSTED_BALANCE * pmt.INTEREST_RATE / 100 *
1145: pmt.NO_OF_DAYS / l_year_basis);
1146: pmt.INTEREST := xtr_fps2_p.interest_round(pmt.INTEREST, rounding_fac, l_rounding_type);
1147: else
1148: pmt.INTEREST :=0;
1149: end if;
1150:

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

1189: l_day_count_type,
1190: l_first_trans_flag);
1191: l_exp_int := (pmt.EXPECTED_BALANCE_OUT * pmt.INTEREST_RATE / 100
1192: * l_no_of_days / l_year_basis);
1193: l_exp_int := xtr_fps2_p.interest_round(l_exp_int, rounding_fac, l_rounding_type);
1194: if nvl(l_cum_int,0) <> 0 then
1195: l_exp_int := l_exp_int + l_cum_int;
1196: l_cum_int := 0;
1197: end if;

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

1256: -- Calc HCE amounts
1257: hce_decr := round(l_prin_decr / l_hce_rate,rounding_fac);
1258: hce_balbf := round(pmt.BALANCE_OUT_BF / l_hce_rate,rounding_fac);
1259: hce_interest := (pmt.INTEREST / l_hce_rate);
1260: hce_interest := xtr_fps2_p.interest_round(hce_interest, rounding_fac, l_rounding_type);
1261: hce_settled := round(pmt.INTEREST_SETTLED / l_hce_rate,rounding_fac);
1262: hce_accum_int_bf := (pmt.ACCUM_INTEREST_BF / l_hce_rate);
1263: hce_accum_int_bf := xtr_fps2_p.interest_round(hce_accum_int_bf, rounding_fac, l_rounding_type);
1264: hce_princ := round(pmt.PRINCIPAL_ADJUST / l_hce_rate,rounding_fac);

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

1259: hce_interest := (pmt.INTEREST / l_hce_rate);
1260: hce_interest := xtr_fps2_p.interest_round(hce_interest, rounding_fac, l_rounding_type);
1261: hce_settled := round(pmt.INTEREST_SETTLED / l_hce_rate,rounding_fac);
1262: hce_accum_int_bf := (pmt.ACCUM_INTEREST_BF / l_hce_rate);
1263: hce_accum_int_bf := xtr_fps2_p.interest_round(hce_accum_int_bf, rounding_fac, l_rounding_type);
1264: hce_princ := round(pmt.PRINCIPAL_ADJUST / l_hce_rate,rounding_fac);
1265: hce_balos := round(pmt.BALANCE_OUT / l_hce_rate,rounding_fac);
1266: hce_accum_int := (pmt.ACCUM_INTEREST / l_hce_rate);
1267: hce_accum_int := xtr_fps2_p.interest_round(hce_accum_int, rounding_fac, l_rounding_type);

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

1263: hce_accum_int_bf := xtr_fps2_p.interest_round(hce_accum_int_bf, rounding_fac, l_rounding_type);
1264: hce_princ := round(pmt.PRINCIPAL_ADJUST / l_hce_rate,rounding_fac);
1265: hce_balos := round(pmt.BALANCE_OUT / l_hce_rate,rounding_fac);
1266: hce_accum_int := (pmt.ACCUM_INTEREST / l_hce_rate);
1267: hce_accum_int := xtr_fps2_p.interest_round(hce_accum_int, rounding_fac, l_rounding_type);
1268: hce_due := round(pmt.PI_AMOUNT_DUE / l_hce_rate,rounding_fac);
1269: --
1270: update XTR_ROLLOVER_TRANSACTIONS_V
1271: set START_DATE = pmt.START_DATE,