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 616: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.principal_balance,0),chr.currency_code) principal_balance,

612: CURSOR var_int_params_csr (p_contract_id NUMBER) IS
613: SELECT vip.interest_calc_start_date,
614: vip.interest_calc_end_date,
615: vip.interest_rate,
616: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.principal_balance,0),chr.currency_code) principal_balance,
617: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.interest_amt,0),chr.currency_code) interest_amt,
618: vip.interest_calc_days,
619: --Bug# 12974796
620: vip.id vir_id,

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

613: SELECT vip.interest_calc_start_date,
614: vip.interest_calc_end_date,
615: vip.interest_rate,
616: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.principal_balance,0),chr.currency_code) principal_balance,
617: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.interest_amt,0),chr.currency_code) interest_amt,
618: vip.interest_calc_days,
619: --Bug# 12974796
620: vip.id vir_id,
621: vip.kle_id,

Line 623: DECODE(NVL(vip.catchup_amt,0),0,' ',OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.catchup_amt,0),chr.currency_code)) catchup_amt,

619: --Bug# 12974796
620: vip.id vir_id,
621: vip.kle_id,
622: cle.name asset_number,
623: DECODE(NVL(vip.catchup_amt,0),0,' ',OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.catchup_amt,0),chr.currency_code)) catchup_amt,
624: vip.catchup_settlement_code
625: FROM okl_var_int_params vip,
626: okc_k_headers_b chr,
627: okc_k_lines_v cle

Line 974: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.principal_balance,0),var_int_param_contract_rec.currency_code),18,' ') ||

970: ' |' || RPAD(TO_CHAR(var_int_param_contract_rec.interest_calc_start_date,'DD-MON-RRRR'),11,' ') ||
971: ' |' || RPAD(TO_CHAR(var_int_param_contract_rec.interest_calc_end_date,'DD-MON-RRRR'),11,' ') ||
972: ' |' || LPAD(NVL(var_int_param_contract_rec.interest_calc_days,0),10,' ') ||
973: ' |' || LPAD(NVL(var_int_param_contract_rec.interest_rate,0),13,' ') ||
974: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.principal_balance,0),var_int_param_contract_rec.currency_code),18,' ') ||
975: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.interest_amt,0),var_int_param_contract_rec.currency_code),18,' ') ||
976: ' |' || LPAD(' ',18,' ') ||
977: ' |' || RPAD(' ',20,' ') ||
978: ' |');

Line 975: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.interest_amt,0),var_int_param_contract_rec.currency_code),18,' ') ||

971: ' |' || RPAD(TO_CHAR(var_int_param_contract_rec.interest_calc_end_date,'DD-MON-RRRR'),11,' ') ||
972: ' |' || LPAD(NVL(var_int_param_contract_rec.interest_calc_days,0),10,' ') ||
973: ' |' || LPAD(NVL(var_int_param_contract_rec.interest_rate,0),13,' ') ||
974: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.principal_balance,0),var_int_param_contract_rec.currency_code),18,' ') ||
975: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.interest_amt,0),var_int_param_contract_rec.currency_code),18,' ') ||
976: ' |' || LPAD(' ',18,' ') ||
977: ' |' || RPAD(' ',20,' ') ||
978: ' |');
979:

Line 1015: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.principal_balance,0),var_int_param_contract_rec.currency_code),18,' ') ||

1011: ' |' || RPAD(TO_CHAR(var_int_param_contract_rec.interest_calc_start_date,'DD-MON-RRRR'),11,' ') ||
1012: ' |' || RPAD(TO_CHAR(var_int_param_contract_rec.interest_calc_end_date,'DD-MON-RRRR'),11,' ') ||
1013: ' |' || LPAD(NVL(var_int_param_contract_rec.interest_calc_days,0),10,' ') ||
1014: ' |' || LPAD(NVL(var_int_param_contract_rec.interest_rate,0),13,' ') ||
1015: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.principal_balance,0),var_int_param_contract_rec.currency_code),18,' ') ||
1016: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.interest_amt,0),var_int_param_contract_rec.currency_code),18,' ') ||
1017: ' |');
1018:
1019: IF l_contract_number1 IS NOT NULL THEN

Line 1016: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.interest_amt,0),var_int_param_contract_rec.currency_code),18,' ') ||

1012: ' |' || RPAD(TO_CHAR(var_int_param_contract_rec.interest_calc_end_date,'DD-MON-RRRR'),11,' ') ||
1013: ' |' || LPAD(NVL(var_int_param_contract_rec.interest_calc_days,0),10,' ') ||
1014: ' |' || LPAD(NVL(var_int_param_contract_rec.interest_rate,0),13,' ') ||
1015: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.principal_balance,0),var_int_param_contract_rec.currency_code),18,' ') ||
1016: ' |' || LPAD(OKL_ACCOUNTING_UTIL.format_amount(NVL(var_int_param_contract_rec.interest_amt,0),var_int_param_contract_rec.currency_code),18,' ') ||
1017: ' |');
1018:
1019: IF l_contract_number1 IS NOT NULL THEN
1020: print_line('|' || RPAD(l_contract_number1,50,' ') ||

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

4080: END IF;
4081:
4082: print_debug('No. of Days in the year: '|| l_year_days);
4083:
4084: l_interest_amt := OKL_ACCOUNTING_UTIL.round_amount((p_principal_amount * l_interest_rate/100) * (
4085: l_calc_days / l_year_days), p_currency_code);
4086:
4087: print_debug(' Interest : '|| l_interest_amt);
4088: l_total_interest_amt := l_total_interest_amt + l_interest_amt;

Line 6159: 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);

6155: print_debug('Creating DAILY_INTEREST_PRINCIPAL streams for assets.');
6156:
6157: FOR l_index in 1 .. l_asset_line_tbl_count
6158: LOOP
6159: 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);
6160:
6161: print_debug('Creating DAILY_INTEREST_PRINCIPAL streams for asset id : ' || l_asset_line_tbl(l_index).id || ' for Amount :' || l_prorated_invoice_amt);
6162:
6163: OKL_VR_DOCUMENT_PVT.Create_Stream_Invoice (