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_K_HEADERS_FULL_V

Line 16: CONTRACT_NUMBER OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE

12:
13: SUBTYPE vir_tbl_type IS OKL_VIR_PVT.vir_tbl_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

Line 17: ,CONTRACT_ID OKL_K_HEADERS_FULL_V.ID%TYPE

13: SUBTYPE vir_tbl_type IS OKL_VIR_PVT.vir_tbl_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

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 357: FROM okl_k_headers_full_v

353: end_date,
354: currency_code,
355: pdt_id,
356: authoring_org_id
357: FROM okl_k_headers_full_v
358: WHERE id = p_contract_id;
359:
360: Cursor interest_params_csr (p_contract_id NUMBER) IS
361: SELECT interest_basis_code,

Line 2340: FROM okl_k_headers_full_v khr,

2336:
2337: --get next reamort date for a contract
2338: CURSOR l_next_reamort_date_csr(cp_khr_id IN NUMBER) IS
2339: SELECT add_months(NVL(date_last_interim_interest_cal, start_date), decode(pay_freq, 'M', 1, 'Q', 3, 'S', 6, 'A', 12, 1)) next_reamort_date
2340: FROM okl_k_headers_full_v khr,
2341: (Select distinct rgp.dnz_chr_id khr_id
2342: ,sll.object1_id1 Pay_freq
2343: from okc_rules_b sll,
2344: okc_rules_b slh,

Line 3168: FROM okl_k_headers_full_v khr

3164:
3165: --Derive print lead days from receivables setup
3166: CURSOR c_default_lead_days(p_khr_id IN NUMBER) IS
3167: SELECT term.printing_lead_days
3168: FROM okl_k_headers_full_v khr
3169: ,hz_customer_profiles cp
3170: ,ra_terms term
3171: WHERE khr.id = p_khr_id
3172: AND khr.bill_to_site_use_id = cp.site_use_id

Line 3466: l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;

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;
3467: l_prev_rcpt_date DATE;
3468: l_current_rcpt_date DATE;
3469: l_total_rcpt_prin_amt NUMBER;
3470: l_current_rcpt_prin_amt NUMBER;

Line 3485: FROM okl_k_headers_full_v

3481: AND parameter_type_code = 'ACTUAL';
3482:
3483: Cursor contract_csr (p_contract_id NUMBER) IS
3484: SELECT start_date, currency_code
3485: FROM okl_k_headers_full_v
3486: WHERE khr_id = p_contract_id;
3487:
3488: Cursor sch_asset_prin_bal_stream_csr (p_contract_id NUMBER,
3489: p_line_id NUMBER,

Line 3868: l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;

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
3872: SELECT start_date, currency_code

Line 3873: FROM okl_k_headers_full_v

3869: l_current_txn_date DATE;
3870:
3871: Cursor contract_csr (p_contract_id NUMBER) IS
3872: SELECT start_date, currency_code
3873: FROM okl_k_headers_full_v
3874: WHERE khr_id = p_contract_id;
3875:
3876: Cursor revenue_recognition_csr (p_contract_id NUMBER) IS
3877: SELECT ppm.revenue_recognition_method,

Line 4211: -- l_currency_code OKL_K_HEADERS_FULL_V.currency_code%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;
4211: -- l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;
4212: l_prev_rcpt_date DATE;
4213: l_current_rcpt_date DATE;
4214: l_total_rcpt_prin_amt NUMBER;
4215: l_current_rcpt_prin_amt NUMBER;

Line 4232: FROM okl_k_headers_full_v

4228: AND parameter_type_code = 'ACTUAL';
4229:
4230: Cursor contract_csr (p_contract_id NUMBER) IS
4231: SELECT start_date, currency_code
4232: FROM okl_k_headers_full_v
4233: WHERE id = p_contract_id;
4234: */
4235: Cursor sch_asset_prin_balance_csr (p_contract_id NUMBER,
4236: p_line_id NUMBER,

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

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

Line 4809: FROM okl_k_headers_full_v

4805:
4806: /*
4807: Cursor contract_csr (p_contract_id NUMBER) IS
4808: SELECT start_date, currency_code
4809: FROM okl_k_headers_full_v
4810: WHERE id = p_contract_id;
4811:
4812: Cursor revenue_recognition_csr (p_contract_id NUMBER) IS
4813: SELECT ppm.revenue_recognition_method

Line 5211: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

5207:
5208: l_api_name CONSTANT VARCHAR2(30) := 'PRIN_DATE_RANGE_VAR_RATE_CTR';
5209: l_api_version CONSTANT NUMBER := 1.0;
5210: r_principal_balance_tbl principal_balance_tbl_typ ;
5211: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
5212: prin_date_range_failed EXCEPTION;
5213:
5214:
5215: Cursor contract_csr (p_contract_id NUMBER) IS

Line 5217: FROM okl_k_headers_full_v

5213:
5214:
5215: Cursor contract_csr (p_contract_id NUMBER) IS
5216: SELECT deal_type
5217: FROM okl_k_headers_full_v
5218: WHERE id = p_contract_id;
5219:
5220:
5221: BEGIN

Line 8977: FROM okl_k_headers_full_v

8973:
8974: CURSOR c_last_int_cur (p_contract_id NUMBER) IS
8975: SELECT NVL(date_last_interim_interest_cal, start_date) reamort_date
8976: ,currency_code
8977: FROM okl_k_headers_full_v
8978: WHERE id = p_chr_id;
8979:
8980: CURSOR c_freq_cur(p_contract_id NUMBER) IS
8981: select object1_id1 from okc_rules_b

Line 10306: FROM okl_k_headers_full_v

10302: AND INTEREST_CALC_END_DATE = (SELECT max(INTEREST_CALC_END_DATE) FROM okl_var_int_params WHERE khr_id = p_contract_id);
10303:
10304: CURSOR c_last_int_cur (p_contract_id NUMBER) IS
10305: SELECT NVL(date_last_interim_interest_cal, start_date) reamort_date
10306: FROM okl_k_headers_full_v
10307: WHERE id = p_contract_id;
10308: -- End by prasjain bug# 6142095
10309: --start | 19-May-08 cklee fixed Bug 7043360 |
10310: l_line_id_buf okl_k_lines.id%type := -1;

Line 12032: from okl_k_headers_full_v khr

12028: select khr.date_last_interim_interest_cal date_last_interim_interest_cal
12029: , NVL(rpm.catchup_start_date, khr.start_date) catchup_start_date
12030: , NVL(rpm.catchup_frequency_code, 'MONTHLY') catchup_frequency_code
12031: , NVL(khr.date_terminated, khr.end_date) end_date
12032: from okl_k_headers_full_v khr
12033: , okl_k_rate_params rpm
12034: where khr.id = rpm.khr_id
12035: and khr.id = cp_khr_id;
12036: