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 65: ,days_in_a_month_code okl_k_rate_params.days_in_a_month_code%TYPE

61:
62: TYPE rpt_success_rec_type IS RECORD (
63: contract_id okc_k_headers_b.id%TYPE
64: ,contract_number okc_k_headers_b.contract_number%TYPE
65: ,days_in_a_month_code okl_k_rate_params.days_in_a_month_code%TYPE
66: ,days_in_a_year_code okl_k_rate_params.days_in_a_year_code%TYPE);
67:
68: TYPE rpt_success_tbl_type IS TABLE OF rpt_success_rec_type INDEX BY BINARY_INTEGER;
69:

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

62: TYPE rpt_success_rec_type IS RECORD (
63: contract_id okc_k_headers_b.id%TYPE
64: ,contract_number okc_k_headers_b.contract_number%TYPE
65: ,days_in_a_month_code okl_k_rate_params.days_in_a_month_code%TYPE
66: ,days_in_a_year_code okl_k_rate_params.days_in_a_year_code%TYPE);
67:
68: TYPE rpt_success_tbl_type IS TABLE OF rpt_success_rec_type INDEX BY BINARY_INTEGER;
69:
70: TYPE rpt_success_icb_tbl_type IS TABLE OF rpt_success_tbl_type INDEX BY VARCHAR2(30);

Line 367: FROM okl_k_rate_params

363: nvl(principal_basis_code, 'ACTUAL') principal_basis_code,
364: days_in_a_month_code,
365: days_in_a_year_code,
366: catchup_settlement_code
367: FROM okl_k_rate_params
368: WHERE khr_id = p_contract_id
369: AND SYSDATE BETWEEN effective_from_date and nvl(effective_to_date, SYSDATE);
370:
371: Cursor product_params_csr (p_product_id NUMBER) IS

Line 686: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;

682: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
683: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;
684: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;
685: l_icb_counter VARCHAR2(30);
686: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;
687: l_days_in_a_year_code OKL_K_RATE_PARAMS.days_in_a_year_code%TYPE;
688: l_separator VARCHAR2(1);
689: l_success_count NUMBER;
690: l_rejected_count NUMBER;

Line 687: l_days_in_a_year_code OKL_K_RATE_PARAMS.days_in_a_year_code%TYPE;

683: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;
684: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;
685: l_icb_counter VARCHAR2(30);
686: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;
687: l_days_in_a_year_code OKL_K_RATE_PARAMS.days_in_a_year_code%TYPE;
688: l_separator VARCHAR2(1);
689: l_success_count NUMBER;
690: l_rejected_count NUMBER;
691:

Line 3452: l_principal_basis OKL_K_RATE_PARAMS.principal_basis_code%TYPE;

3448: x_principal_balance_tbl OUT NOCOPY principal_balance_tbl_typ) IS
3449:
3450: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_PRINCIPAL_DATE_RANGE';
3451: l_api_version CONSTANT NUMBER := 1.0;
3452: l_principal_basis OKL_K_RATE_PARAMS.principal_basis_code%TYPE;
3453: l_effective_date DATE := SYSDATE;
3454: l_principal_balance_tbl principal_balance_tbl_typ ;
3455: l_contract_start_date DATE;
3456: l_start_date DATE;

Line 3478: FROM okl_k_rate_params

3474:
3475: Cursor principal_basis_csr (p_contract_id NUMBER,
3476: p_effective_date DATE) IS
3477: SELECT principal_basis_code
3478: FROM okl_k_rate_params
3479: WHERE khr_id = p_contract_id
3480: AND p_effective_date BETWEEN effective_from_date and nvl(effective_to_date, SYSDATE)
3481: AND parameter_type_code = 'ACTUAL';
3482:

Line 4194: l_principal_basis OKL_K_RATE_PARAMS.principal_basis_code%TYPE;

4190: x_principal_balance_tbl OUT NOCOPY principal_balance_tbl_typ) IS
4191:
4192: l_api_name CONSTANT VARCHAR2(30) := 'PRIN_DATE_RANGE_VAR_INT_LOAN';
4193: l_api_version CONSTANT NUMBER := 1.0;
4194: l_principal_basis OKL_K_RATE_PARAMS.principal_basis_code%TYPE;
4195: l_effective_date DATE := SYSDATE;
4196: l_principal_balance_tbl principal_balance_tbl_typ ;
4197: l_principal_balance_tbl_tmp principal_balance_tbl_typ ;
4198: -- l_contract_start_date DATE;

Line 4225: FROM okl_k_rate_params

4221: /*
4222: Cursor principal_basis_csr (p_contract_id NUMBER,
4223: p_effective_date DATE) IS
4224: SELECT nvl(principal_basis_code, 'ACTUAL')
4225: FROM okl_k_rate_params
4226: WHERE khr_id = p_contract_id
4227: AND p_effective_date BETWEEN effective_from_date and nvl(effective_to_date, p_effective_date)
4228: AND parameter_type_code = 'ACTUAL';
4229:

Line 5404: FROM okl_k_rate_params krp

5400: , chr.end_date contract_end_date
5401: , chr.id khr_id
5402: , ppm.quality_val interest_calculation_basis
5403: , NULL pay_freq
5404: FROM okl_k_rate_params krp
5405: , okl_k_headers khr
5406: , okc_k_headers_b chr
5407: , okl_prod_qlty_val_uv ppm
5408: WHERE krp.rowid = cp_rate_param_rowid

Line 6115: FROM okl_k_rate_params krp

6111: CURSOR c_param_rate(cp_khr_id NUMBER, cp_start_date DATE, cp_end_date DATE) IS
6112: SELECT krp.rowid rate_param_rowid,
6113: GREATEST(trunc(cp_start_date),krp.effective_from_date) start_date,
6114: LEAST(trunc(cp_end_date),NVL(krp.effective_to_date, trunc(sysdate + 9999))) end_date
6115: FROM okl_k_rate_params krp
6116: WHERE krp.khr_id = cp_khr_id
6117: AND krp.parameter_type_code = 'ACTUAL'
6118: AND (cp_start_date BETWEEN krp.effective_from_date AND nvl(krp.effective_to_date, trunc(cp_start_date))
6119: OR (cp_end_date BETWEEN krp.effective_from_date AND nvl(krp.effective_to_date, trunc(cp_end_date)))

Line 6230: l_interest_basis OKL_K_RATE_PARAMS.interest_basis_code%TYPE;

6226: l_year_days NUMBER;
6227: l_interest_amt NUMBER := 0;
6228: l_total_interest_amt NUMBER := 0;
6229: l_year_part NUMBER;
6230: l_interest_basis OKL_K_RATE_PARAMS.interest_basis_code%TYPE;
6231: l_calculation_formula_id OKL_K_RATE_PARAMS.calculation_formula_id%TYPE;
6232: l_derived_flag VARCHAR2(1);
6233: calculate_interest_failed EXCEPTION;
6234:

Line 6231: l_calculation_formula_id OKL_K_RATE_PARAMS.calculation_formula_id%TYPE;

6227: l_interest_amt NUMBER := 0;
6228: l_total_interest_amt NUMBER := 0;
6229: l_year_part NUMBER;
6230: l_interest_basis OKL_K_RATE_PARAMS.interest_basis_code%TYPE;
6231: l_calculation_formula_id OKL_K_RATE_PARAMS.calculation_formula_id%TYPE;
6232: l_derived_flag VARCHAR2(1);
6233: calculate_interest_failed EXCEPTION;
6234:
6235:

Line 9991: -- l_interest_basis OKL_K_RATE_PARAMS.interest_basis_code%TYPE;

9987: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE_TOTAL_INTEREST_DUE';
9988: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
9989: l_interest_calculated NUMBER := 0;
9990: r_principal_balance_tbl principal_balance_tbl_typ;
9991: -- l_interest_basis OKL_K_RATE_PARAMS.interest_basis_code%TYPE;
9992: -- l_formula_id OKL_K_RATE_PARAMS.calculation_formula_id%TYPE;
9993: l_formula_name OKL_FORMULAE_V.name%TYPE;
9994: calc_total_int_due_failed EXCEPTION;
9995:

Line 9992: -- l_formula_id OKL_K_RATE_PARAMS.calculation_formula_id%TYPE;

9988: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
9989: l_interest_calculated NUMBER := 0;
9990: r_principal_balance_tbl principal_balance_tbl_typ;
9991: -- l_interest_basis OKL_K_RATE_PARAMS.interest_basis_code%TYPE;
9992: -- l_formula_id OKL_K_RATE_PARAMS.calculation_formula_id%TYPE;
9993: l_formula_name OKL_FORMULAE_V.name%TYPE;
9994: calc_total_int_due_failed EXCEPTION;
9995:
9996: /*

Line 9999: FROM okl_k_rate_params

9995:
9996: /*
9997: Cursor interest_params_csr (p_contract_id NUMBER, p_effective_date DATE) IS
9998: SELECT interest_basis_code, calculation_formula_id
9999: FROM okl_k_rate_params
10000: WHERE khr_id = p_contract_id
10001: AND p_effective_date BETWEEN effective_from_date and nvl(effective_to_date, p_effective_date)
10002: AND parameter_type_code = 'ACTUAL';
10003: */

Line 12033: , okl_k_rate_params rpm

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:
12037: l_next_catchup_date DATE;

Line 12118: -- l_catchup_settlement_code OKL_K_RATE_PARAMS.catchup_settlement_code%TYPE;

12114: l_msg_index_out NUMBER;
12115: l_interest_calculated NUMBER := 0;
12116: l_total_interest_billed NUMBER := 0;
12117: l_principal_adjusted NUMBER := 0;
12118: -- l_catchup_settlement_code OKL_K_RATE_PARAMS.catchup_settlement_code%TYPE;
12119: l_invoice_amt NUMBER := 0;
12120: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
12121: l_invoice_id NUMBER;
12122: l_principal_balance_tbl principal_balance_tbl_typ;

Line 12177: FROM okl_k_rate_params

12173:
12174: /*
12175: CURSOR catchup_params_csr (p_khr_id NUMBER, p_effective_date DATE) IS
12176: SELECT catchup_settlement_code
12177: FROM okl_k_rate_params
12178: WHERE khr_id = p_khr_id
12179: AND p_effective_date BETWEEN effective_from_date and nvl(effective_to_date, p_effective_date)
12180: AND parameter_type_code = 'ACTUAL';
12181: */

Line 12609: l_rate_change_value OKL_K_RATE_PARAMS.rate_change_value%TYPE;

12605: l_int_params_exist BOOLEAN := TRUE;
12606: l_msg_count NUMBER;
12607: l_from_date DATE;
12608: l_to_date DATE;
12609: l_rate_change_value OKL_K_RATE_PARAMS.rate_change_value%TYPE;
12610: l_catchup_date DATE;
12611: l_termination_date DATE;
12612: l_print_lead_days NUMBER;
12613: l_vrc_report_tbl vrc_tbl_type;

Line 12675: FROM okl_k_rate_params

12671: days_in_a_month_code,
12672: days_in_a_year_code,
12673: rate_change_value,
12674: catchup_settlement_code
12675: FROM okl_k_rate_params
12676: WHERE khr_id = p_contract_id
12677: AND p_effective_date BETWEEN effective_from_date and nvl(effective_to_date, p_effective_date)
12678: AND parameter_type_code = 'ACTUAL';
12679: