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_RATE_PARAMS

Line 21: ,DAYS_IN_A_MONTH_CODE OKL_K_RATE_PARAMS.DAYS_IN_A_MONTH_CODE%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));
25:

Line 22: ,DAYS_IN_A_YEAR_CODE OKL_K_RATE_PARAMS.DAYS_IN_A_YEAR_CODE%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));
25:
26: TYPE vrc_tbl_type IS TABLE OF vrc_rec_type INDEX BY BINARY_INTEGER;

Line 23: ,RATE_CHANGE_VALUE OKL_K_RATE_PARAMS.RATE_CHANGE_VALUE%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));
25:
26: TYPE vrc_tbl_type IS TABLE OF vrc_rec_type INDEX BY BINARY_INTEGER;
27:

Line 58: ,days_in_a_month_code okl_k_rate_params.days_in_a_month_code%TYPE

54:
55: TYPE rpt_success_rec_type IS RECORD (
56: contract_id okc_k_headers_b.id%TYPE
57: ,contract_number okc_k_headers_b.contract_number%TYPE
58: ,days_in_a_month_code okl_k_rate_params.days_in_a_month_code%TYPE
59: ,days_in_a_year_code okl_k_rate_params.days_in_a_year_code%TYPE);
60:
61: TYPE rpt_success_tbl_type IS TABLE OF rpt_success_rec_type INDEX BY BINARY_INTEGER;
62:

Line 59: ,days_in_a_year_code okl_k_rate_params.days_in_a_year_code%TYPE);

55: TYPE rpt_success_rec_type IS RECORD (
56: contract_id okc_k_headers_b.id%TYPE
57: ,contract_number okc_k_headers_b.contract_number%TYPE
58: ,days_in_a_month_code okl_k_rate_params.days_in_a_month_code%TYPE
59: ,days_in_a_year_code okl_k_rate_params.days_in_a_year_code%TYPE);
60:
61: TYPE rpt_success_tbl_type IS TABLE OF rpt_success_rec_type INDEX BY BINARY_INTEGER;
62:
63: TYPE rpt_success_icb_tbl_type IS TABLE OF rpt_success_tbl_type INDEX BY VARCHAR2(30);

Line 263: FROM okl_k_rate_params

259: nvl(principal_basis_code, 'ACTUAL') principal_basis_code,
260: days_in_a_month_code,
261: days_in_a_year_code,
262: catchup_settlement_code
263: FROM okl_k_rate_params
264: WHERE khr_id = p_contract_id
265: AND SYSDATE BETWEEN effective_from_date and nvl(effective_to_date, SYSDATE);
266:
267: Cursor product_params_csr (p_product_id NUMBER) IS

Line 594: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;

590: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
591: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;
592: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;
593: l_icb_counter VARCHAR2(30);
594: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;
595: l_days_in_a_year_code OKL_K_RATE_PARAMS.days_in_a_year_code%TYPE;
596: l_separator VARCHAR2(1);
597: l_success_count NUMBER;
598: l_rejected_count NUMBER;

Line 595: l_days_in_a_year_code OKL_K_RATE_PARAMS.days_in_a_year_code%TYPE;

591: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;
592: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;
593: l_icb_counter VARCHAR2(30);
594: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;
595: l_days_in_a_year_code OKL_K_RATE_PARAMS.days_in_a_year_code%TYPE;
596: l_separator VARCHAR2(1);
597: l_success_count NUMBER;
598: l_rejected_count NUMBER;
599:

Line 1444: l_principal_basis OKL_K_RATE_PARAMS.principal_basis_code%TYPE;

1440: x_principal_balance_tbl OUT NOCOPY principal_balance_tbl_typ) IS
1441:
1442: l_api_name CONSTANT VARCHAR2(30) := 'PRIN_DATE_RANGE_VAR_INT_LOAN';
1443: l_api_version CONSTANT NUMBER := 1.0;
1444: l_principal_basis OKL_K_RATE_PARAMS.principal_basis_code%TYPE;
1445: l_effective_date DATE := SYSDATE;
1446: l_principal_balance_tbl principal_balance_tbl_typ ;
1447: l_principal_balance_tbl_tmp principal_balance_tbl_typ ;
1448: -- l_contract_start_date DATE;

Line 1480: FROM okl_k_rate_params

1476: /*
1477: Cursor principal_basis_csr (p_contract_id NUMBER,
1478: p_effective_date DATE) IS
1479: SELECT nvl(principal_basis_code, 'ACTUAL')
1480: FROM okl_k_rate_params
1481: WHERE khr_id = p_contract_id
1482: AND p_effective_date BETWEEN effective_from_date and nvl(effective_to_date, p_effective_date)
1483: AND parameter_type_code = 'ACTUAL';
1484:

Line 2988: FROM okl_k_rate_params krp

2984: , chr.end_date contract_end_date
2985: , chr.id khr_id
2986: , ppm.quality_val interest_calculation_basis
2987: , NULL pay_freq
2988: FROM okl_k_rate_params krp
2989: , okl_k_headers khr
2990: , okc_k_headers_b chr
2991: , okl_prod_qlty_val_uv ppm
2992: WHERE krp.rowid = cp_rate_param_rowid

Line 3843: FROM okl_k_rate_params krp

3839: CURSOR c_param_rate(cp_khr_id NUMBER, cp_start_date DATE, cp_end_date DATE) IS
3840: SELECT krp.rowid rate_param_rowid,
3841: GREATEST(trunc(cp_start_date),krp.effective_from_date) start_date,
3842: LEAST(trunc(cp_end_date),NVL(krp.effective_to_date, trunc(sysdate + 9999))) end_date
3843: FROM okl_k_rate_params krp
3844: WHERE krp.khr_id = cp_khr_id
3845: AND krp.parameter_type_code = 'ACTUAL'
3846: AND (cp_start_date BETWEEN krp.effective_from_date AND nvl(krp.effective_to_date, trunc(cp_start_date))
3847: OR (cp_end_date BETWEEN krp.effective_from_date AND nvl(krp.effective_to_date, trunc(cp_end_date)))

Line 3966: l_interest_basis OKL_K_RATE_PARAMS.interest_basis_code%TYPE;

3962: l_year_days NUMBER;
3963: l_interest_amt NUMBER := 0;
3964: l_total_interest_amt NUMBER := 0;
3965: l_year_part NUMBER;
3966: l_interest_basis OKL_K_RATE_PARAMS.interest_basis_code%TYPE;
3967: l_calculation_formula_id OKL_K_RATE_PARAMS.calculation_formula_id%TYPE;
3968: l_derived_flag VARCHAR2(1);
3969: calculate_interest_failed EXCEPTION;
3970:

Line 3967: l_calculation_formula_id OKL_K_RATE_PARAMS.calculation_formula_id%TYPE;

3963: l_interest_amt NUMBER := 0;
3964: l_total_interest_amt NUMBER := 0;
3965: l_year_part NUMBER;
3966: l_interest_basis OKL_K_RATE_PARAMS.interest_basis_code%TYPE;
3967: l_calculation_formula_id OKL_K_RATE_PARAMS.calculation_formula_id%TYPE;
3968: l_derived_flag VARCHAR2(1);
3969: calculate_interest_failed EXCEPTION;
3970:
3971:

Line 6443: l_rate_change_value OKL_K_RATE_PARAMS.rate_change_value%TYPE;

6439: l_int_params_exist BOOLEAN := TRUE;
6440: l_msg_count NUMBER;
6441: l_from_date DATE;
6442: l_to_date DATE;
6443: l_rate_change_value OKL_K_RATE_PARAMS.rate_change_value%TYPE;
6444: l_catchup_date DATE;
6445: l_termination_date DATE;
6446: l_print_lead_days NUMBER;
6447: l_vrc_report_tbl vrc_tbl_type;

Line 6540: FROM okl_k_rate_params

6536: days_in_a_month_code,
6537: days_in_a_year_code,
6538: rate_change_value,
6539: catchup_settlement_code
6540: FROM okl_k_rate_params
6541: WHERE khr_id = p_contract_id
6542: AND p_effective_date BETWEEN effective_from_date and nvl(effective_to_date, p_effective_date)
6543: AND parameter_type_code = 'ACTUAL';
6544: