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 230: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;

226: l_next_period_start_date DATE;
227: l_next_period_end_date DATE;
228: l_interest_amt NUMBER;
229: l_interest_due NUMBER;
230: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
231: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
232:
233: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS
234: SELECT principal_basis_code

Line 231: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

227: l_next_period_end_date DATE;
228: l_interest_amt NUMBER;
229: l_interest_due NUMBER;
230: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
231: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
232:
233: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS
234: SELECT principal_basis_code
235: FROM okl_k_rate_params

Line 253: okl_product_parameters_v ppm

249: CURSOR l_int_calc_basis_csr(cp_khr_id IN NUMBER) IS
250: SELECT ppm.interest_calculation_basis
251: ,ppm.revenue_recognition_method
252: FROM okl_k_headers khr,
253: okl_product_parameters_v ppm
254: WHERE khr.id = cp_khr_id
255: AND khr.pdt_id = ppm.id;
256:
257: CURSOR l_interest_due_csr (cp_khr_id NUMBER,

Line 525: okl_product_parameters_v ppm

521: CURSOR l_int_calc_basis_csr(cp_khr_id IN NUMBER) IS
522: SELECT ppm.interest_calculation_basis
523: ,ppm.revenue_recognition_method
524: FROM okl_k_headers khr,
525: okl_product_parameters_v ppm
526: WHERE khr.id = cp_khr_id
527: AND khr.pdt_id = ppm.id;
528:
529: -- sechawla 02-may-08 6939451 Addec this cursor

Line 535: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;

531: SELECT deal_type
532: FROM okl_k_headers
533: WHERE id = p_contract_id;
534:
535: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
536: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
537:
538: BEGIN
539: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 536: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

532: FROM okl_k_headers
533: WHERE id = p_contract_id;
534:
535: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
536: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
537:
538: BEGIN
539: l_debug_enabled := okl_debug_pub.check_log_enabled;
540: IF(NVL(l_debug_enabled,'N')='Y') THEN

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

973: FUNCTION get_effective_int_rate(
974: x_return_status OUT NOCOPY VARCHAR2,
975: p_khr_id IN NUMBER,
976: p_effective_date IN DATE) RETURN NUMBER IS
977: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
978: CURSOR l_calc_basis_csr(cp_khr_id IN NUMBER) IS
979: SELECT ppm.quality_val interest_calculation_basis
980: , end_date
981: FROM okl_k_headers_full_v khr,

Line 995: l_process_flag okl_product_parameters_v.interest_calculation_basis%TYPE;

991: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_EFFECTIVE_INT_RATE';
992:
993: l_interest_rate_tbl okl_variable_interest_pvt.interest_rate_tbl_type;
994: l_effective_int_rate NUMBER;
995: l_process_flag okl_product_parameters_v.interest_calculation_basis%TYPE;
996: l_end_date okl_k_headers_full_v.end_date%TYPE;
997: l_effective_date DATE := NULL;
998:
999: BEGIN