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.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 704: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.principal_balance,0),chr.currency_code) principal_balance,

700: CURSOR var_int_params_csr (p_contract_id NUMBER) IS
701: SELECT vip.interest_calc_start_date,
702: vip.interest_calc_end_date,
703: vip.interest_rate,
704: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.principal_balance,0),chr.currency_code) principal_balance,
705: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.interest_amt,0),chr.currency_code) interest_amt,
706: vip.interest_calc_days
707: FROM okl_var_int_params vip,
708: okc_k_headers_b chr

Line 705: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.interest_amt,0),chr.currency_code) interest_amt,

701: SELECT vip.interest_calc_start_date,
702: vip.interest_calc_end_date,
703: vip.interest_rate,
704: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.principal_balance,0),chr.currency_code) principal_balance,
705: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.interest_amt,0),chr.currency_code) interest_amt,
706: vip.interest_calc_days
707: FROM okl_var_int_params vip,
708: okc_k_headers_b chr
709: WHERE chr.id = p_contract_id

Line 2193: l_interest_amount := OKL_ACCOUNTING_UTIL.round_amount((l_interest_rec.Principle * l_interest_rec.effective_rate/100)* (l_calc_days/l_year_days),l_currency_code);

2189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Principal: '||l_interest_rec.Principle);
2190:
2191: -- l_days_rate_tot := l_days_rate_tot + r_days_rate.DAYS*l_present_int_rate;
2192:
2193: l_interest_amount := OKL_ACCOUNTING_UTIL.round_amount((l_interest_rec.Principle * l_interest_rec.effective_rate/100)* (l_calc_days/l_year_days),l_currency_code);
2194:
2195: x_interest_rec.interest_amount := l_interest_amount+ x_interest_rec.interest_amount;
2196:
2197: print_debug('Interest Amount: '||l_interest_amount||' Total Interest Amount: '||x_interest_rec.interest_amount);

Line 3738: l_current_rcpt_prin_amt := OKL_ACCOUNTING_UTIL.round_amount(current_receipt.principal_pmt_rcpt_amt, l_currency_code);

3734: l_current_rcpt_loan_amt := 0;
3735: FOR current_receipt in rcpt_dtls_actual_strm_csr (p_contract_id, p_line_id, p_start_date, p_due_date)
3736: LOOP
3737: l_current_rcpt_date := current_receipt.receipt_date;
3738: l_current_rcpt_prin_amt := OKL_ACCOUNTING_UTIL.round_amount(current_receipt.principal_pmt_rcpt_amt, l_currency_code);
3739: l_current_rcpt_loan_amt := current_receipt.loan_pmt_rcpt_amt;
3740: IF (l_prev_rcpt_date = NULL) THEN
3741: l_prev_rcpt_date := l_current_rcpt_date;
3742: END IF;

Line 6364: l_interest_amt := OKL_ACCOUNTING_UTIL.round_amount((p_principal_amount * l_interest_rate/100) * (

6360: END IF;
6361:
6362: print_debug('No. of Days in the year: '|| l_year_days);
6363:
6364: l_interest_amt := OKL_ACCOUNTING_UTIL.round_amount((p_principal_amount * l_interest_rate/100) * (
6365: l_calc_days / l_year_days), p_currency_code);
6366:
6367: print_debug(' Interest : '|| l_interest_amt);
6368: l_total_interest_amt := l_total_interest_amt + l_interest_amt;

Line 9262: l_rent_tbl(l_rent_tbl_cntr).amount := OKL_ACCOUNTING_UTIL.round_amount(l_rent_tbl(l_rent_tbl_cntr).amount, l_currency_code);

9258: LOOP
9259: EXIT WHEN l_rent_tbl_cntr IS NULL;
9260: --round the amount
9261: IF (l_rent_tbl(l_rent_tbl_cntr).amount IS NOT NULL) THEN
9262: l_rent_tbl(l_rent_tbl_cntr).amount := OKL_ACCOUNTING_UTIL.round_amount(l_rent_tbl(l_rent_tbl_cntr).amount, l_currency_code);
9263: END IF;
9264:
9265: l_rent_tbl_cntr := l_rent_tbl.next(l_rent_tbl_cntr);
9266: END LOOP;

Line 9880: l_prorated_invoice_amt := OKL_ACCOUNTING_UTIL.round_amount((l_asset_line_tbl(l_index).amount * l_invoice_amt / l_total_asset_val),p_currency_code);

9876: print_debug('Creating DAILY_INTEREST_PRINCIPAL streams for assets.');
9877:
9878: FOR l_index in 1 .. l_asset_line_tbl_count
9879: LOOP
9880: l_prorated_invoice_amt := OKL_ACCOUNTING_UTIL.round_amount((l_asset_line_tbl(l_index).amount * l_invoice_amt / l_total_asset_val),p_currency_code);
9881:
9882: print_debug('Creating DAILY_INTEREST_PRINCIPAL streams for asset id : ' || l_asset_line_tbl(l_index).id || ' for Amount :' || l_prorated_invoice_amt);
9883:
9884: Create_Stream_Invoice (

Line 12268: l_invoice_amt := OKL_ACCOUNTING_UTIL.round_amount(l_interest_calculated - l_total_interest_billed, p_currency_code);

12264: CLOSE interest_payment_amount_csr;
12265: END IF;
12266:
12267: print_debug('Interest Billed : ' || l_total_interest_billed);
12268: l_invoice_amt := OKL_ACCOUNTING_UTIL.round_amount(l_interest_calculated - l_total_interest_billed, p_currency_code);
12269:
12270: Print_debug ('Invoice Amount : '|| l_invoice_amt);
12271:
12272: IF (l_invoice_amt > 0) THEN

Line 12466: l_prorated_invoice_amt := OKL_ACCOUNTING_UTIL.round_amount((l_asset_line_tbl(l_index).amount * l_invoice_amt / l_total_asset_val),p_currency_code);

12462: print_debug('Creating PRINCIPAL_CATCHUP adjustment streams for assets.');
12463:
12464: FOR l_index in 1 .. l_asset_line_tbl_count
12465: LOOP
12466: l_prorated_invoice_amt := OKL_ACCOUNTING_UTIL.round_amount((l_asset_line_tbl(l_index).amount * l_invoice_amt / l_total_asset_val),p_currency_code);
12467:
12468: print_debug('Creating PRINCIPAL_CATCHUP adjustment streams for asset id : ' || l_asset_line_tbl(l_index).id || ' for Amount :' || l_prorated_invoice_amt);
12469: Create_Stream_Invoice (
12470: p_api_version => 1.0,