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 242: l_interest_calculation_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;

238:
239: l_api_name CONSTANT VARCHAR2(30) := 'INITIALIZE_CONTRACT_PARAMS';
240: l_api_version CONSTANT NUMBER := 1.0;
241: init_ctr_params_failed EXCEPTION;
242: l_interest_calculation_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
243:
244:
245: Cursor contract_csr (p_contract_id NUMBER) IS
246: SELECT id,

Line 270: FROM okl_product_parameters_v ppm

266:
267: Cursor product_params_csr (p_product_id NUMBER) IS
268: SELECT ppm.revenue_recognition_method,
269: ppm.interest_calculation_basis
270: FROM okl_product_parameters_v ppm
271: WHERE ppm.id = p_product_id;
272:
273: BEGIN
274: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

1450: l_principal_balance NUMBER;
1451: l_counter NUMBER := 0;
1452: l_counter_tmp NUMBER := 0;
1453: l_receipt_counter NUMBER := 0;
1454: -- l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
1455: l_receipt_date DATE;
1456: -- l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
1457: l_receipt_tbl receipt_tbl_type;
1458: lx_receipt_tbl receipt_tbl_type;

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

1452: l_counter_tmp NUMBER := 0;
1453: l_receipt_counter NUMBER := 0;
1454: -- l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
1455: l_receipt_date DATE;
1456: -- l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
1457: l_receipt_tbl receipt_tbl_type;
1458: lx_receipt_tbl receipt_tbl_type;
1459: l_rcpt_tbl_count NUMBER := 0;
1460: l_rcpt_tbl_index NUMBER := 0;

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

2246: l_principal_balance NUMBER;
2247: l_counter NUMBER := 0;
2248: l_counter_tmp NUMBER := 0;
2249: -- l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;
2250: -- l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
2251: l_current_txn_date DATE;
2252: prin_date_range_rloan_failed EXCEPTION;
2253: l_receipt_tbl receipt_tbl_type;
2254: lx_receipt_tbl receipt_tbl_type;

Line 6517: okl_product_parameters_v ppm,

6513: ppm.name product_name
6514: FROM okc_k_headers_b chr,
6515: okl_k_headers khr,
6516: okc_statuses_b khs,
6517: okl_product_parameters_v ppm,
6518: hz_cust_accounts hca --- Added as part of Bug# 14119181
6519: WHERE CHR.CONTRACT_NUMBER = NVL(p_contract_number,CHR.CONTRACT_NUMBER)
6520: AND khr.deal_type IN ('LOAN','LEASEDF','LOAN-REVOLVING','LEASEST','LEASEOP')
6521: AND chr.id = khr.id