APPS.OKL_MULTIGAAP_ENGINE_PVT dependencies on OKL_PRODUCTS

Line 55: l_reporting_product OKL_PRODUCTS_V.NAME%TYPE;

51: lx_pdt_parameter_rec pdt_parameters_rec_type ;
52: l_contract_number VARCHAR2(120);
53:
54: --mg_error EXCEPTION;
55: l_reporting_product OKL_PRODUCTS_V.NAME%TYPE;
56: l_reporting_product_id NUMBER;
57:
58: BEGIN
59: -- get the financial product of the contract

Line 476: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS

472:
473: l_sec_trx_tclv_tbl tclv_tbl_type; --SGIYER := p_tclv_tbl;
474: x_sec_trx_tclv_tbl tclv_tbl_type ;
475:
476: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS
477: SELECT name
478: FROM okl_products
479: WHERE id = l_pdt_id ;
480:

Line 478: FROM okl_products

474: x_sec_trx_tclv_tbl tclv_tbl_type ;
475:
476: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS
477: SELECT name
478: FROM okl_products
479: WHERE id = l_pdt_id ;
480:
481: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS
482: SELECT name