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_INT_UTIL_PVT dependencies on OKL_PRODUCT_PARAMETERS_V

Line 316: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;

312: l_next_period_start_date DATE;
313: l_next_period_end_date DATE;
314: l_interest_amt NUMBER;
315: l_interest_due NUMBER;
316: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
317: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
318:
319: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS
320: SELECT principal_basis_code

Line 317: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

313: l_next_period_end_date DATE;
314: l_interest_amt NUMBER;
315: l_interest_due NUMBER;
316: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
317: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
318:
319: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS
320: SELECT principal_basis_code
321: FROM okl_k_rate_params

Line 339: okl_product_parameters_v ppm

335: CURSOR l_int_calc_basis_csr(cp_khr_id IN NUMBER) IS
336: SELECT ppm.interest_calculation_basis
337: ,ppm.revenue_recognition_method
338: FROM okl_k_headers khr,
339: okl_product_parameters_v ppm
340: WHERE khr.id = cp_khr_id
341: AND khr.pdt_id = ppm.id;
342:
343: CURSOR l_interest_due_csr (cp_khr_id NUMBER,

Line 611: okl_product_parameters_v ppm

607: CURSOR l_int_calc_basis_csr(cp_khr_id IN NUMBER) IS
608: SELECT ppm.interest_calculation_basis
609: ,ppm.revenue_recognition_method
610: FROM okl_k_headers khr,
611: okl_product_parameters_v ppm
612: WHERE khr.id = cp_khr_id
613: AND khr.pdt_id = ppm.id;
614:
615: -- sechawla 02-may-08 6939451 Addec this cursor

Line 621: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;

617: SELECT deal_type
618: FROM okl_k_headers
619: WHERE id = p_contract_id;
620:
621: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
622: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
623:
624: BEGIN
625: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 622: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

618: FROM okl_k_headers
619: WHERE id = p_contract_id;
620:
621: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
622: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
623:
624: BEGIN
625: l_debug_enabled := okl_debug_pub.check_log_enabled;
626: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 1024: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

1020: FUNCTION get_effective_int_rate(
1021: x_return_status OUT NOCOPY VARCHAR2,
1022: p_khr_id IN NUMBER,
1023: p_effective_date IN DATE) RETURN NUMBER IS
1024: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
1025: CURSOR l_calc_basis_csr(cp_khr_id IN NUMBER) IS
1026: SELECT ppm.quality_val interest_calculation_basis
1027: , end_date
1028: FROM okl_k_headers_full_v khr,

Line 1042: l_process_flag okl_product_parameters_v.interest_calculation_basis%TYPE;

1038: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_EFFECTIVE_INT_RATE';
1039:
1040: l_interest_rate_tbl okl_variable_interest_pvt.interest_rate_tbl_type;
1041: l_effective_int_rate NUMBER;
1042: l_process_flag okl_product_parameters_v.interest_calculation_basis%TYPE;
1043: l_end_date okl_k_headers_full_v.end_date%TYPE;
1044: l_effective_date DATE := NULL;
1045:
1046: BEGIN