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_VAR_INT_REAMORT_PVT dependencies on DUAL

Line 203: OKL_VARIABLE_INTEREST_PVT.print_debug('residual_amount: '||set_value_null(l_csm_line_details_tbl(i).residual_amount));

199: exit when i is null;
200: OKL_VARIABLE_INTEREST_PVT.print_debug('kle_asset_id: '||set_value_null(l_csm_line_details_tbl(i).kle_asset_id));
201: OKL_VARIABLE_INTEREST_PVT.print_debug('----------------------------------------------------');
202: OKL_VARIABLE_INTEREST_PVT.print_debug('asset_cost: '||set_value_null(l_csm_line_details_tbl(i).asset_cost));
203: OKL_VARIABLE_INTEREST_PVT.print_debug('residual_amount: '||set_value_null(l_csm_line_details_tbl(i).residual_amount));
204: OKL_VARIABLE_INTEREST_PVT.print_debug('residual_date: '||set_value_null(l_csm_line_details_tbl(i).residual_date));
205: OKL_VARIABLE_INTEREST_PVT.print_debug('description: '||set_value_null(l_csm_line_details_tbl(i).description));
206: i := l_csm_line_details_tbl.next(i);
207: end loop;

Line 204: OKL_VARIABLE_INTEREST_PVT.print_debug('residual_date: '||set_value_null(l_csm_line_details_tbl(i).residual_date));

200: OKL_VARIABLE_INTEREST_PVT.print_debug('kle_asset_id: '||set_value_null(l_csm_line_details_tbl(i).kle_asset_id));
201: OKL_VARIABLE_INTEREST_PVT.print_debug('----------------------------------------------------');
202: OKL_VARIABLE_INTEREST_PVT.print_debug('asset_cost: '||set_value_null(l_csm_line_details_tbl(i).asset_cost));
203: OKL_VARIABLE_INTEREST_PVT.print_debug('residual_amount: '||set_value_null(l_csm_line_details_tbl(i).residual_amount));
204: OKL_VARIABLE_INTEREST_PVT.print_debug('residual_date: '||set_value_null(l_csm_line_details_tbl(i).residual_date));
205: OKL_VARIABLE_INTEREST_PVT.print_debug('description: '||set_value_null(l_csm_line_details_tbl(i).description));
206: i := l_csm_line_details_tbl.next(i);
207: end loop;
208: OKL_VARIABLE_INTEREST_PVT.print_debug('**END CONTENTS OF P_CSM_LINE_DETAILS_TBL***');

Line 499: -- Function Name contract_residual_value

495:
496: ------------------------------------------------------------------------------
497: -- Start of Comments
498: -- Created By: Sanjeev Ahuja
499: -- Function Name contract_residual_value
500: -- Description: returns the residual value for a contract line
501: -- Dependencies:
502: -- Parameters: contract id, date.
503: -- Version: 1.0

Line 500: -- Description: returns the residual value for a contract line

496: ------------------------------------------------------------------------------
497: -- Start of Comments
498: -- Created By: Sanjeev Ahuja
499: -- Function Name contract_residual_value
500: -- Description: returns the residual value for a contract line
501: -- Dependencies:
502: -- Parameters: contract id, date.
503: -- Version: 1.0
504: -- End of Comments

Line 506: FUNCTION contract_residual_value(

502: -- Parameters: contract id, date.
503: -- Version: 1.0
504: -- End of Comments
505: ------------------------------------------------------------------------------
506: FUNCTION contract_residual_value(
507: p_chr_id IN NUMBER,
508: p_kle_id IN NUMBER) RETURN NUMBER IS
509:
510: l_residual_value NUMBER := 0;

Line 510: l_residual_value NUMBER := 0;

506: FUNCTION contract_residual_value(
507: p_chr_id IN NUMBER,
508: p_kle_id IN NUMBER) RETURN NUMBER IS
509:
510: l_residual_value NUMBER := 0;
511:
512: Cursor residual_value_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS
513: SELECT nvl(kle.residual_value,0) Value
514: FROM OKC_LINE_STYLES_B LS,

Line 512: Cursor residual_value_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS

508: p_kle_id IN NUMBER) RETURN NUMBER IS
509:
510: l_residual_value NUMBER := 0;
511:
512: Cursor residual_value_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS
513: SELECT nvl(kle.residual_value,0) Value
514: FROM OKC_LINE_STYLES_B LS,
515: okl_K_lines_full_v kle,
516: okc_statuses_b sts

Line 513: SELECT nvl(kle.residual_value,0) Value

509:
510: l_residual_value NUMBER := 0;
511:
512: Cursor residual_value_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS
513: SELECT nvl(kle.residual_value,0) Value
514: FROM OKC_LINE_STYLES_B LS,
515: okl_K_lines_full_v kle,
516: okc_statuses_b sts
517: WHERE LS.ID = KLE.LSE_ID

Line 524: residual_value_rec residual_value_csr%ROWTYPE;

520: AND KLE.id = p_kle_id
521: AND kle.sts_code = sts.code
522: AND sts.ste_code NOT IN ('TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD');
523:
524: residual_value_rec residual_value_csr%ROWTYPE;
525: BEGIN
526:
527: IF ( p_chr_id IS NULL OR p_kle_id IS NULL ) THEN
528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 531: OPEN residual_value_csr(p_chr_id, p_kle_id);

527: IF ( p_chr_id IS NULL OR p_kle_id IS NULL ) THEN
528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
529: END IF;
530:
531: OPEN residual_value_csr(p_chr_id, p_kle_id);
532: FETCH residual_value_csr INTO residual_value_rec;
533: CLOSE residual_value_csr;
534:
535: l_residual_value := residual_value_rec.Value;

Line 532: FETCH residual_value_csr INTO residual_value_rec;

528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
529: END IF;
530:
531: OPEN residual_value_csr(p_chr_id, p_kle_id);
532: FETCH residual_value_csr INTO residual_value_rec;
533: CLOSE residual_value_csr;
534:
535: l_residual_value := residual_value_rec.Value;
536:

Line 533: CLOSE residual_value_csr;

529: END IF;
530:
531: OPEN residual_value_csr(p_chr_id, p_kle_id);
532: FETCH residual_value_csr INTO residual_value_rec;
533: CLOSE residual_value_csr;
534:
535: l_residual_value := residual_value_rec.Value;
536:
537: OKL_VARIABLE_INTEREST_PVT.print_debug('Contract residual value :' || l_residual_value);

Line 535: l_residual_value := residual_value_rec.Value;

531: OPEN residual_value_csr(p_chr_id, p_kle_id);
532: FETCH residual_value_csr INTO residual_value_rec;
533: CLOSE residual_value_csr;
534:
535: l_residual_value := residual_value_rec.Value;
536:
537: OKL_VARIABLE_INTEREST_PVT.print_debug('Contract residual value :' || l_residual_value);
538: RETURN l_residual_value;
539:

Line 537: OKL_VARIABLE_INTEREST_PVT.print_debug('Contract residual value :' || l_residual_value);

533: CLOSE residual_value_csr;
534:
535: l_residual_value := residual_value_rec.Value;
536:
537: OKL_VARIABLE_INTEREST_PVT.print_debug('Contract residual value :' || l_residual_value);
538: RETURN l_residual_value;
539:
540: EXCEPTION
541: WHEN OTHERS THEN

Line 538: RETURN l_residual_value;

534:
535: l_residual_value := residual_value_rec.Value;
536:
537: OKL_VARIABLE_INTEREST_PVT.print_debug('Contract residual value :' || l_residual_value);
538: RETURN l_residual_value;
539:
540: EXCEPTION
541: WHEN OTHERS THEN
542: Okl_Api.SET_MESSAGE(

Line 550: END contract_residual_value;

546: p_token1_value => SQLCODE,
547: p_token2 => G_SQLERRM_TOKEN,
548: p_token2_value => SQLERRM);
549: RETURN NULL;
550: END contract_residual_value;
551:
552:
553: ----------------------------------------------------------------------------------------------------
554: -- Start of Comments

Line 685: contract_residual_value(p_khr_id, p_kle_id) -

681:
682: OKL_VARIABLE_INTEREST_PVT.print_debug('get_tot_principal_amt : p_advance_or_arrears => ' || p_advance_or_arrears);
683: if(c_khr_type_rec.deal_type = 'LEASEDF' or c_khr_type_rec.deal_type = 'LEASEST') THEN
684: l_principal_balance := contract_future_rents(p_khr_id, p_kle_id, p_date, p_advance_or_arrears) +
685: contract_residual_value(p_khr_id, p_kle_id) -
686: contract_future_income(p_khr_id, p_kle_id, p_date);
687: elsif(c_khr_type_rec.deal_type = 'LEASEOP') THEN
688: l_principal_balance := prin_bal_OP_lease(p_khr_id, p_kle_id);
689: end if;

Line 1327: p_residual_value => NULL,

1323: p_in_service_date => NULL,
1324: p_life_in_months => NULL,
1325: p_basic_rate => NULL,
1326: p_adjusted_rate => NULL,
1327: p_residual_value => NULL,
1328: p_strm_lalevl_tbl => l_strm_lalevl_tbl,
1329: p_transaction_date => l_reamort_date,
1330: x_stream_trx_tbl => x_strm_trx_tbl
1331: );

Line 2221: l_csm_yields_tbl(l_index).yield_name := 'Full term with residual';

2217: --is this correct?
2218: --CHECK WITH PM'S
2219: l_index := l_csm_yields_tbl.COUNT + 1;
2220: l_csm_yields_tbl(l_index).siy_type := OKL_SIY_PVT.G_SIY_TYPE_INTEREST_RATE;
2221: l_csm_yields_tbl(l_index).yield_name := 'Full term with residual';
2222: l_csm_yields_tbl(l_index).target_value := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
2223: OKL_VARIABLE_INTEREST_PVT.print_debug('l_csm_yields_tbl information');
2224: OKL_VARIABLE_INTEREST_PVT.print_debug('siy_type :'||l_csm_yields_tbl(l_index).siy_type);
2225: OKL_VARIABLE_INTEREST_PVT.print_debug('yield_name :'||l_csm_yields_tbl(l_index).yield_name);

Line 2317: OKL_VARIABLE_INTEREST_PVT.print_debug('Residual amount : ' || l_csm_line_details_tbl(l_csm_line_details_ctr).residual_amount);

2313: l_csm_line_details_tbl(l_csm_line_details_ctr).date_delivery := l_start_date;
2314: l_csm_line_details_tbl(l_csm_line_details_ctr).date_funding := l_start_date;
2315:
2316: OKL_VARIABLE_INTEREST_PVT.print_debug('Asset id: ' || l_csm_line_details_tbl(l_csm_line_details_ctr).kle_asset_id || ' Asset principal balance: ' ||l_csm_line_details_tbl(l_csm_line_details_ctr).asset_cost);
2317: OKL_VARIABLE_INTEREST_PVT.print_debug('Residual amount : ' || l_csm_line_details_tbl(l_csm_line_details_ctr).residual_amount);
2318: OKL_VARIABLE_INTEREST_PVT.print_debug('Date delivery : ' || l_csm_line_details_tbl(l_csm_line_details_ctr).date_delivery);
2319: OKL_VARIABLE_INTEREST_PVT.print_debug('Date funding : ' || l_csm_line_details_tbl(l_csm_line_details_ctr).date_funding);
2320:
2321: l_csm_line_details_ctr := l_csm_line_details_tbl.next(l_csm_line_details_ctr);

Line 2459: FROM dual;

2455: l_request_id,
2456: l_program_application_id,
2457: l_program_id,
2458: l_program_update_date
2459: FROM dual;
2460:
2461: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl.delete;
2462:
2463: --Bug# 14559654