APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 16: CONTRACT_NUMBER OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE

12: --Bug# 14799218
13: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.var.plsql.okl_variable_interest_pvt';
14:
15: TYPE vrc_rec_type IS RECORD (
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

Line 17: ,CONTRACT_ID OKL_K_HEADERS_FULL_V.ID%TYPE

13: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.var.plsql.okl_variable_interest_pvt';
14:
15: TYPE vrc_rec_type IS RECORD (
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

Line 18: ,START_DATE OKL_K_HEADERS_FULL_V.START_DATE%TYPE

14:
15: TYPE vrc_rec_type IS RECORD (
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

Line 19: ,END_DATE OKL_K_HEADERS_FULL_V.END_DATE%TYPE

15: TYPE vrc_rec_type IS RECORD (
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

Line 253: FROM okl_k_headers_full_v

249: end_date,
250: currency_code,
251: pdt_id,
252: authoring_org_id
253: FROM okl_k_headers_full_v
254: WHERE id = p_contract_id;
255:
256: Cursor interest_params_csr (p_contract_id NUMBER) IS
257: SELECT interest_basis_code,

Line 1096: FROM okl_k_headers_full_v khr

1092:
1093: --Derive print lead days from receivables setup
1094: CURSOR c_default_lead_days(p_khr_id IN NUMBER) IS
1095: SELECT term.printing_lead_days
1096: FROM okl_k_headers_full_v khr
1097: ,hz_customer_profiles cp
1098: ,ra_terms term
1099: WHERE khr.id = p_khr_id
1100: AND khr.bill_to_site_use_id = cp.site_use_id

Line 1461: -- l_currency_code OKL_K_HEADERS_FULL_V.currency_code%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;
1461: -- l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;
1462: l_prev_rcpt_date DATE;
1463: l_current_rcpt_date DATE;
1464: l_total_rcpt_prin_amt NUMBER;
1465: l_current_rcpt_prin_amt NUMBER;

Line 1487: FROM okl_k_headers_full_v

1483: AND parameter_type_code = 'ACTUAL';
1484:
1485: Cursor contract_csr (p_contract_id NUMBER) IS
1486: SELECT start_date, currency_code
1487: FROM okl_k_headers_full_v
1488: WHERE id = p_contract_id;
1489: */
1490: --Bug# 12903938: Modified cursor
1491: Cursor sch_asset_prin_balance_csr (p_contract_id NUMBER,

Line 2249: -- l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;

2245: l_start_date DATE;
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;

Line 2675: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

2671:
2672: l_api_name CONSTANT VARCHAR2(30) := 'PRIN_DATE_RANGE_VAR_RATE_CTR';
2673: l_api_version CONSTANT NUMBER := 1.0;
2674: r_principal_balance_tbl principal_balance_tbl_typ ;
2675: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
2676: prin_date_range_failed EXCEPTION;
2677:
2678:
2679: Cursor contract_csr (p_contract_id NUMBER) IS

Line 2681: FROM okl_k_headers_full_v

2677:
2678:
2679: Cursor contract_csr (p_contract_id NUMBER) IS
2680: SELECT deal_type
2681: FROM okl_k_headers_full_v
2682: WHERE id = p_contract_id;
2683:
2684:
2685: BEGIN