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_V

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

3575:
3576: --+++++++++++++++++++++++ Load Interface +++++++++++++++++++++++++++++++++++++++
3577: ------------------------------------------------------------------------------
3578: -- FUNCTION get_product_id
3579: -- It gets Product ID if any. It checks againts okl_products_v for
3580: -- esistance of product as supplied in parameters
3581: -- Calls:
3582: -- None
3583: -- Called By:

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

3583: -- Called By:
3584: -- load_input_record
3585: ------------------------------------------------------------------------------
3586:
3587: FUNCTION get_product_id (p_product_id IN okl_products_v.id%TYPE,
3588: p_product_name IN okl_products_v.name%TYPE,
3589: x_product_id OUT NOCOPY okl_products_v.id%TYPE )
3590: RETURN VARCHAR2 IS
3591:

Line 3588: p_product_name IN okl_products_v.name%TYPE,

3584: -- load_input_record
3585: ------------------------------------------------------------------------------
3586:
3587: FUNCTION get_product_id (p_product_id IN okl_products_v.id%TYPE,
3588: p_product_name IN okl_products_v.name%TYPE,
3589: x_product_id OUT NOCOPY okl_products_v.id%TYPE )
3590: RETURN VARCHAR2 IS
3591:
3592: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

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

3585: ------------------------------------------------------------------------------
3586:
3587: FUNCTION get_product_id (p_product_id IN okl_products_v.id%TYPE,
3588: p_product_name IN okl_products_v.name%TYPE,
3589: x_product_id OUT NOCOPY okl_products_v.id%TYPE )
3590: RETURN VARCHAR2 IS
3591:
3592: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3593: l_product_id OKL_PRODUCTS_V.ID%TYPE;

Line 3593: l_product_id OKL_PRODUCTS_V.ID%TYPE;

3589: x_product_id OUT NOCOPY okl_products_v.id%TYPE )
3590: RETURN VARCHAR2 IS
3591:
3592: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3593: l_product_id OKL_PRODUCTS_V.ID%TYPE;
3594: l_revenue_recognition_method okl_product_parameters_v.REVENUE_RECOGNITION_METHOD%TYPE;
3595: l_interest_calculation_basis okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;
3596: l_deal_type okl_product_parameters_v.DEAL_TYPE%TYPE;
3597: product_exception EXCEPTION;

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

3595: l_interest_calculation_basis okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;
3596: l_deal_type okl_product_parameters_v.DEAL_TYPE%TYPE;
3597: product_exception EXCEPTION;
3598:
3599: CURSOR product_csr(p_product_name okl_products_v.name%TYPE,
3600: p_product_id okl_products_v.id%TYPE) IS
3601: SELECT a.id,
3602: b.revenue_recognition_method,
3603: b.interest_calculation_basis,

Line 3600: p_product_id okl_products_v.id%TYPE) IS

3596: l_deal_type okl_product_parameters_v.DEAL_TYPE%TYPE;
3597: product_exception EXCEPTION;
3598:
3599: CURSOR product_csr(p_product_name okl_products_v.name%TYPE,
3600: p_product_id okl_products_v.id%TYPE) IS
3601: SELECT a.id,
3602: b.revenue_recognition_method,
3603: b.interest_calculation_basis,
3604: b.deal_type

Line 3605: FROM okl_products_v a,

3601: SELECT a.id,
3602: b.revenue_recognition_method,
3603: b.interest_calculation_basis,
3604: b.deal_type
3605: FROM okl_products_v a,
3606: okl_product_parameters_v b
3607: WHERE ((a.name = p_product_name
3608: AND
3609: p_product_name IS NOT NULL

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

3678: l_type VARCHAR2(1) := 'N';
3679: l_proc_name VARCHAR2(35) := 'CHECK_PRODUCT_TYPE';
3680:
3681: --dkagrawa changed query to use view okl_prod_qlty_val_uv than product_parameters_v for performance
3682: CURSOR prod_type_csr(p_product_name okl_products_v.name%TYPE,
3683: p_product_id okl_products_v.id%TYPE) IS
3684: SELECT 'Y'
3685: FROM okl_products prod,
3686: okl_prod_qlty_val_uv pqv

Line 3683: p_product_id okl_products_v.id%TYPE) IS

3679: l_proc_name VARCHAR2(35) := 'CHECK_PRODUCT_TYPE';
3680:
3681: --dkagrawa changed query to use view okl_prod_qlty_val_uv than product_parameters_v for performance
3682: CURSOR prod_type_csr(p_product_name okl_products_v.name%TYPE,
3683: p_product_id okl_products_v.id%TYPE) IS
3684: SELECT 'Y'
3685: FROM okl_products prod,
3686: okl_prod_qlty_val_uv pqv
3687: WHERE ((prod.name = p_product_name