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_VAR_INT_PARAMS

Line 68: --Bug# 13447258: Changes to store catchup calculated values in okl_var_int_params_all

64:
65: g_rpt_success_icb_tbl rpt_success_icb_tbl_type;
66: --Bug# 7277007
67:
68: --Bug# 13447258: Changes to store catchup calculated values in okl_var_int_params_all
69: --Bug# 12974796
70: /*TYPE rpt_catchup_rec_type IS RECORD (
71: catchup_amount NUMBER
72: ,catchup_settlement_type VARCHAR2(30)

Line 625: FROM okl_var_int_params vip,

621: vip.kle_id,
622: cle.name asset_number,
623: DECODE(NVL(vip.catchup_amt,0),0,' ',OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.catchup_amt,0),chr.currency_code)) catchup_amt,
624: vip.catchup_settlement_code
625: FROM okl_var_int_params vip,
626: okc_k_headers_b chr,
627: okc_k_lines_v cle
628: WHERE chr.id = p_contract_id
629: AND vip.khr_id = chr.id

Line 655: FROM okl_var_int_params vip,

651: SUM(NVL(vip.principal_balance,0)) principal_balance,
652: SUM(NVL(vip.interest_amt,0)) interest_amt,
653: vip.interest_calc_days,
654: chr.currency_code
655: FROM okl_var_int_params vip,
656: okc_k_headers_b chr
657: WHERE vip.khr_id = p_contract_id
658: AND chr.id = vip.khr_id
659: AND vip.request_id = g_request_id

Line 3017: FROM okl_var_int_params vip

3013: SELECT DISTINCT
3014: vip.interest_rate VALUE,
3015: GREATEST(trunc(cp_start_date),interest_calc_start_date) VALID_FROM,
3016: LEAST(trunc(cp_end_date),NVL(interest_calc_end_date, trunc(sysdate))) VALID_UNTIL
3017: FROM okl_var_int_params vip
3018: WHERE vip.khr_id = cp_khr_id
3019: AND (cp_start_date BETWEEN vip.interest_calc_start_date AND nvl(vip.interest_calc_end_date, trunc(cp_start_date))
3020: OR (cp_end_date BETWEEN vip.interest_calc_start_date AND nvl(vip.interest_calc_end_date, trunc(cp_end_date)))
3021: OR (vip.interest_calc_start_date >= cp_start_date AND nvl(vip.interest_calc_end_date, trunc(sysdate + 9999)) <= cp_end_date) )

Line 3269: from okl_var_int_params vip

3265: ,interest_rate
3266: from (select vip.interest_calc_start_date
3267: ,vip.interest_calc_end_date
3268: ,vip.interest_rate
3269: from okl_var_int_params vip
3270: where vip.khr_id = cp_khr_id
3271: and vip.interest_calc_end_date < cp_from_date
3272: AND vip.calc_method_code = NVL(cp_process_flag, vip.calc_method_code)
3273: AND vip.valid_yn = 'Y'

Line 3454: --get the interest rate for l_start_date to l_end_date from okl_var_int_params

3450: --if the proc is not called from the variable rate - initiate request
3451: --then derive the rates for the date range passed
3452: --else retrieve the previously derived rates
3453: IF (l_end_date <= cur_int_param.date_last_interim_interest_cal) THEN
3454: --get the interest rate for l_start_date to l_end_date from okl_var_int_params
3455: print_debug('in procedure interest_date_range - get the interest rate for l_start_date to l_end_date from okl_var_int_params');
3456: FOR cur_param_rate IN c_param_rate(p_contract_id, l_start_date, l_end_date, p_process_flag) LOOP
3457: l_int_tbl_row := l_int_tbl_row + 1;
3458: l_interest_rate_tbl(l_int_tbl_row).from_date := cur_param_rate.valid_from;

Line 3455: print_debug('in procedure interest_date_range - get the interest rate for l_start_date to l_end_date from okl_var_int_params');

3451: --then derive the rates for the date range passed
3452: --else retrieve the previously derived rates
3453: IF (l_end_date <= cur_int_param.date_last_interim_interest_cal) THEN
3454: --get the interest rate for l_start_date to l_end_date from okl_var_int_params
3455: print_debug('in procedure interest_date_range - get the interest rate for l_start_date to l_end_date from okl_var_int_params');
3456: FOR cur_param_rate IN c_param_rate(p_contract_id, l_start_date, l_end_date, p_process_flag) LOOP
3457: l_int_tbl_row := l_int_tbl_row + 1;
3458: l_interest_rate_tbl(l_int_tbl_row).from_date := cur_param_rate.valid_from;
3459: l_interest_rate_tbl(l_int_tbl_row).to_date := cur_param_rate.valid_until;

Line 3468: --get the interest rate for l_start_date to date last interim interest cal from okl_var_int_params

3464:
3465: print_table_content(l_int_param_tbl , l_interest_rate_tbl);
3466: l_derive_rate_flag := 'N';
3467: ELSE
3468: --get the interest rate for l_start_date to date last interim interest cal from okl_var_int_params
3469: print_debug('in procedure interest_date_range - get the interest rate for l_start_date to date last interim interest cal from okl_var_int_params');
3470: FOR cur_param_rate IN c_param_rate(p_contract_id, l_start_date, cur_int_param.date_last_interim_interest_cal, p_process_flag) LOOP
3471: l_int_tbl_row := l_int_tbl_row + 1;
3472: l_interest_rate_tbl(l_int_tbl_row).from_date := cur_param_rate.valid_from;

Line 3469: print_debug('in procedure interest_date_range - get the interest rate for l_start_date to date last interim interest cal from okl_var_int_params');

3465: print_table_content(l_int_param_tbl , l_interest_rate_tbl);
3466: l_derive_rate_flag := 'N';
3467: ELSE
3468: --get the interest rate for l_start_date to date last interim interest cal from okl_var_int_params
3469: print_debug('in procedure interest_date_range - get the interest rate for l_start_date to date last interim interest cal from okl_var_int_params');
3470: FOR cur_param_rate IN c_param_rate(p_contract_id, l_start_date, cur_int_param.date_last_interim_interest_cal, p_process_flag) LOOP
3471: l_int_tbl_row := l_int_tbl_row + 1;
3472: l_interest_rate_tbl(l_int_tbl_row).from_date := cur_param_rate.valid_from;
3473: l_interest_rate_tbl(l_int_tbl_row).to_date := cur_param_rate.valid_until;

Line 4340: IF (p_source_table = 'OKL_VAR_INT_PARAMS') THEN

4336: IF p_source_table IS NOT NULL THEN
4337: x_vir_tbl(l_index).source_table := p_source_table;
4338: END IF;
4339:
4340: IF (p_source_table = 'OKL_VAR_INT_PARAMS') THEN
4341: x_vir_tbl(l_index).source_id := x_vir_tbl(l_index).id;
4342: END IF;
4343: --Bug# 12974796
4344:

Line 6487: FROM okl_var_int_params

6483:
6484: CURSOR c_var_int_params_csr(p_chr_id IN NUMBER,
6485: p_req_id IN NUMBER) IS
6486: SELECT 'Y'
6487: FROM okl_var_int_params
6488: WHERE khr_id = p_chr_id
6489: AND request_id = p_req_id;
6490:
6491: l_var_int_params_found_yn VARCHAR2(1);