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_PRODUCT_PARAMETERS_V

Line 20: ,INTEREST_CALCULATION_BASIS OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE

16: CONTRACT_NUMBER OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE
17: ,CONTRACT_ID OKL_K_HEADERS_FULL_V.ID%TYPE
18: ,START_DATE OKL_K_HEADERS_FULL_V.START_DATE%TYPE
19: ,END_DATE OKL_K_HEADERS_FULL_V.END_DATE%TYPE
20: ,INTEREST_CALCULATION_BASIS OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE
21: ,DAYS_IN_A_MONTH_CODE OKL_K_RATE_PARAMS.DAYS_IN_A_MONTH_CODE%TYPE
22: ,DAYS_IN_A_YEAR_CODE OKL_K_RATE_PARAMS.DAYS_IN_A_YEAR_CODE%TYPE
23: ,RATE_CHANGE_VALUE OKL_K_RATE_PARAMS.RATE_CHANGE_VALUE%TYPE
24: ,PROCESS_STATUS VARCHAR2(1));

Line 346: l_interest_calculation_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;

342:
343: l_api_name CONSTANT VARCHAR2(30) := 'INITIALIZE_CONTRACT_PARAMS';
344: l_api_version CONSTANT NUMBER := 1.0;
345: init_ctr_params_failed EXCEPTION;
346: l_interest_calculation_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
347:
348:
349: Cursor contract_csr (p_contract_id NUMBER) IS
350: SELECT id,

Line 374: FROM okl_product_parameters_v ppm

370:
371: Cursor product_params_csr (p_product_id NUMBER) IS
372: SELECT ppm.revenue_recognition_method,
373: ppm.interest_calculation_basis
374: FROM okl_product_parameters_v ppm
375: WHERE ppm.id = p_product_id;
376:
377: BEGIN
378: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3460: l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

3456: l_start_date DATE;
3457: l_principal_balance NUMBER;
3458: l_counter NUMBER := 0;
3459: l_receipt_counter NUMBER := 0;
3460: l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
3461: l_receipt_date DATE;
3462: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
3463: l_receipt_tbl receipt_tbl_type;
3464: l_rcpt_tbl_count NUMBER := 0;

Line 3462: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;

3458: l_counter NUMBER := 0;
3459: l_receipt_counter NUMBER := 0;
3460: l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
3461: l_receipt_date DATE;
3462: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
3463: l_receipt_tbl receipt_tbl_type;
3464: l_rcpt_tbl_count NUMBER := 0;
3465: l_rcpt_tbl_index NUMBER := 0;
3466: l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;

Line 3528: okl_product_parameters_v ppm

3524: Cursor revenue_recognition_csr (p_contract_id NUMBER) IS
3525: SELECT ppm.revenue_recognition_method,
3526: ppm.interest_calculation_basis
3527: FROM okl_k_headers khr,
3528: okl_product_parameters_v ppm
3529: WHERE khr.pdt_id = ppm.id
3530: AND khr.id = p_contract_id;
3531:
3532: Cursor receipt_details_csr (p_contract_id NUMBER,

Line 3866: l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

3862: l_contract_start_date DATE;
3863: l_start_date DATE;
3864: l_principal_balance NUMBER;
3865: l_counter NUMBER := 0;
3866: l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
3867: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
3868: l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;
3869: l_current_txn_date DATE;
3870:

Line 3867: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;

3863: l_start_date DATE;
3864: l_principal_balance NUMBER;
3865: l_counter NUMBER := 0;
3866: l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
3867: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
3868: l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;
3869: l_current_txn_date DATE;
3870:
3871: Cursor contract_csr (p_contract_id NUMBER) IS

Line 3880: okl_product_parameters_v ppm

3876: Cursor revenue_recognition_csr (p_contract_id NUMBER) IS
3877: SELECT ppm.revenue_recognition_method,
3878: ppm.interest_calculation_basis
3879: FROM okl_k_headers khr,
3880: okl_product_parameters_v ppm
3881: WHERE khr.pdt_id = ppm.id
3882: AND khr.id = p_contract_id;
3883:
3884: -- sjalasut, modified the cursor to have khr_id referred from the lines table

Line 4204: -- l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

4200: l_principal_balance NUMBER;
4201: l_counter NUMBER := 0;
4202: l_counter_tmp NUMBER := 0;
4203: l_receipt_counter NUMBER := 0;
4204: -- l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
4205: l_receipt_date DATE;
4206: -- l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
4207: l_receipt_tbl receipt_tbl_type;
4208: lx_receipt_tbl receipt_tbl_type;

Line 4206: -- l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;

4202: l_counter_tmp NUMBER := 0;
4203: l_receipt_counter NUMBER := 0;
4204: -- l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
4205: l_receipt_date DATE;
4206: -- l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
4207: l_receipt_tbl receipt_tbl_type;
4208: lx_receipt_tbl receipt_tbl_type;
4209: l_rcpt_tbl_count NUMBER := 0;
4210: l_rcpt_tbl_index NUMBER := 0;

Line 4797: -- l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

4793: l_principal_balance NUMBER;
4794: l_counter NUMBER := 0;
4795: l_counter_tmp NUMBER := 0;
4796: -- l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;
4797: -- l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
4798: l_current_txn_date DATE;
4799: prin_date_range_rloan_failed EXCEPTION;
4800: l_receipt_tbl receipt_tbl_type;
4801: lx_receipt_tbl receipt_tbl_type;

Line 4815: okl_product_parameters_v ppm

4811:
4812: Cursor revenue_recognition_csr (p_contract_id NUMBER) IS
4813: SELECT ppm.revenue_recognition_method
4814: FROM okl_k_headers khr,
4815: okl_product_parameters_v ppm
4816: WHERE khr.pdt_id = ppm.id
4817: AND khr.id = p_contract_id;
4818: */
4819:

Line 10014: okl_product_parameters_v ppm

10010: /*
10011: Cursor interest_calc_basis_csr (p_contract_id NUMBER) IS
10012: SELECT ppm.interest_calculation_basis
10013: FROM okl_k_headers khr,
10014: okl_product_parameters_v ppm
10015: WHERE khr.pdt_id = ppm.id
10016: AND khr.id = p_contract_id;
10017: */
10018:

Line 10253: --dkagrawa changed query to use view okl_prod_qlty_val_uv than okl_product_parameters_v for performance

10249: l_interest_rate okl_var_int_params.INTEREST_RATE%type;
10250: l_rebook_flag BOOLEAN := TRUE;
10251: l_interest_calc_end_date DATE;
10252: -- End by prasjain bug# 6142095
10253: --dkagrawa changed query to use view okl_prod_qlty_val_uv than okl_product_parameters_v for performance
10254: CURSOR c_chr_id (cp_khr_id VARCHAR2) IS
10255: SELECT okc.contract_number
10256: , NVL(okl.date_last_interim_interest_cal, okc.start_date) start_date
10257: , okl.deal_type deal_type

Line 12655: okl_product_parameters_v ppm

12651: ppm.name product_name
12652: FROM okc_k_headers_b chr,
12653: okl_k_headers khr,
12654: okc_statuses_b khs,
12655: okl_product_parameters_v ppm
12656: WHERE CHR.CONTRACT_NUMBER = NVL(p_contract_number,CHR.CONTRACT_NUMBER)
12657: AND khr.deal_type IN ('LOAN','LEASEDF','LOAN-REVOLVING','LEASEST','LEASEOP')
12658: AND chr.id = khr.id
12659: AND khs.code = chr.sts_code