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_OPEN_INTERFACE_PVT dependencies on OKL_PRODUCTS

Line 3747: -- It gets Product ID if any. It checks againts okl_products_v for

3743:
3744: --+++++++++++++++++++++++ Load Interface +++++++++++++++++++++++++++++++++++++++
3745: ------------------------------------------------------------------------------
3746: -- FUNCTION get_product_id
3747: -- It gets Product ID if any. It checks againts okl_products_v for
3748: -- esistance of product as supplied in parameters
3749: -- Calls:
3750: -- None
3751: -- Called By:

Line 3755: FUNCTION get_product_id (p_product_id IN okl_products_v.id%TYPE,

3751: -- Called By:
3752: -- load_input_record
3753: ------------------------------------------------------------------------------
3754:
3755: FUNCTION get_product_id (p_product_id IN okl_products_v.id%TYPE,
3756: p_product_name IN okl_products_v.name%TYPE,
3757: x_product_id OUT NOCOPY okl_products_v.id%TYPE )
3758: RETURN VARCHAR2 IS
3759:

Line 3756: p_product_name IN okl_products_v.name%TYPE,

3752: -- load_input_record
3753: ------------------------------------------------------------------------------
3754:
3755: FUNCTION get_product_id (p_product_id IN okl_products_v.id%TYPE,
3756: p_product_name IN okl_products_v.name%TYPE,
3757: x_product_id OUT NOCOPY okl_products_v.id%TYPE )
3758: RETURN VARCHAR2 IS
3759:
3760: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 3757: x_product_id OUT NOCOPY okl_products_v.id%TYPE )

3753: ------------------------------------------------------------------------------
3754:
3755: FUNCTION get_product_id (p_product_id IN okl_products_v.id%TYPE,
3756: p_product_name IN okl_products_v.name%TYPE,
3757: x_product_id OUT NOCOPY okl_products_v.id%TYPE )
3758: RETURN VARCHAR2 IS
3759:
3760: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3761: l_product_id OKL_PRODUCTS_V.ID%TYPE;

Line 3761: l_product_id OKL_PRODUCTS_V.ID%TYPE;

3757: x_product_id OUT NOCOPY okl_products_v.id%TYPE )
3758: RETURN VARCHAR2 IS
3759:
3760: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3761: l_product_id OKL_PRODUCTS_V.ID%TYPE;
3762: l_revenue_recognition_method okl_product_parameters_v.REVENUE_RECOGNITION_METHOD%TYPE;
3763: l_interest_calculation_basis okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;
3764: l_deal_type okl_product_parameters_v.DEAL_TYPE%TYPE;
3765: product_exception EXCEPTION;

Line 3767: CURSOR product_csr(p_product_name okl_products_v.name%TYPE,

3763: l_interest_calculation_basis okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;
3764: l_deal_type okl_product_parameters_v.DEAL_TYPE%TYPE;
3765: product_exception EXCEPTION;
3766:
3767: CURSOR product_csr(p_product_name okl_products_v.name%TYPE,
3768: p_product_id okl_products_v.id%TYPE) IS
3769: SELECT a.id,
3770: b.revenue_recognition_method,
3771: b.interest_calculation_basis,

Line 3768: p_product_id okl_products_v.id%TYPE) IS

3764: l_deal_type okl_product_parameters_v.DEAL_TYPE%TYPE;
3765: product_exception EXCEPTION;
3766:
3767: CURSOR product_csr(p_product_name okl_products_v.name%TYPE,
3768: p_product_id okl_products_v.id%TYPE) IS
3769: SELECT a.id,
3770: b.revenue_recognition_method,
3771: b.interest_calculation_basis,
3772: b.deal_type

Line 3773: FROM okl_products_v a,

3769: SELECT a.id,
3770: b.revenue_recognition_method,
3771: b.interest_calculation_basis,
3772: b.deal_type
3773: FROM okl_products_v a,
3774: okl_product_parameters_v b
3775: WHERE ((a.name = p_product_name
3776: AND
3777: p_product_name IS NOT NULL

Line 3850: CURSOR prod_type_csr(p_product_name okl_products_v.name%TYPE,

3846: l_type VARCHAR2(1) := 'N';
3847: l_proc_name VARCHAR2(35) := 'CHECK_PRODUCT_TYPE';
3848:
3849: --dkagrawa changed query to use view okl_prod_qlty_val_uv than product_parameters_v for performance
3850: CURSOR prod_type_csr(p_product_name okl_products_v.name%TYPE,
3851: p_product_id okl_products_v.id%TYPE) IS
3852: SELECT 'Y'
3853: FROM okl_products prod,
3854: okl_prod_qlty_val_uv pqv

Line 3851: p_product_id okl_products_v.id%TYPE) IS

3847: l_proc_name VARCHAR2(35) := 'CHECK_PRODUCT_TYPE';
3848:
3849: --dkagrawa changed query to use view okl_prod_qlty_val_uv than product_parameters_v for performance
3850: CURSOR prod_type_csr(p_product_name okl_products_v.name%TYPE,
3851: p_product_id okl_products_v.id%TYPE) IS
3852: SELECT 'Y'
3853: FROM okl_products prod,
3854: okl_prod_qlty_val_uv pqv
3855: WHERE ((prod.name = p_product_name

Line 3853: FROM okl_products prod,

3849: --dkagrawa changed query to use view okl_prod_qlty_val_uv than product_parameters_v for performance
3850: CURSOR prod_type_csr(p_product_name okl_products_v.name%TYPE,
3851: p_product_id okl_products_v.id%TYPE) IS
3852: SELECT 'Y'
3853: FROM okl_products prod,
3854: okl_prod_qlty_val_uv pqv
3855: WHERE ((prod.name = p_product_name
3856: AND
3857: p_product_name IS NOT NULL