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_PRODUCT_PARAMETERS_V

Line 97: G_REVENUE_RECOGNITION_METHOD okl_product_parameters_v.REVENUE_RECOGNITION_METHOD%TYPE;

93: -- end cklee 02/13/2004 bug# 3440442
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
96: G_PRODUCT_ID NUMBER;
97: G_REVENUE_RECOGNITION_METHOD okl_product_parameters_v.REVENUE_RECOGNITION_METHOD%TYPE;
98: G_INTEREST_CALCULATION_BASIS okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;
99: G_DEAL_TYPE okl_product_parameters_v.DEAL_TYPE%TYPE;
100:
101: -- hariven - Bug#5393374 - Added - Start

Line 98: G_INTEREST_CALCULATION_BASIS okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;

94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
96: G_PRODUCT_ID NUMBER;
97: G_REVENUE_RECOGNITION_METHOD okl_product_parameters_v.REVENUE_RECOGNITION_METHOD%TYPE;
98: G_INTEREST_CALCULATION_BASIS okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;
99: G_DEAL_TYPE okl_product_parameters_v.DEAL_TYPE%TYPE;
100:
101: -- hariven - Bug#5393374 - Added - Start
102: G_WF_EVT_KHR_IMPORTED CONSTANT VARCHAR2(50) := 'oracle.apps.okl.la.lease_contract.imported';

Line 99: G_DEAL_TYPE okl_product_parameters_v.DEAL_TYPE%TYPE;

95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
96: G_PRODUCT_ID NUMBER;
97: G_REVENUE_RECOGNITION_METHOD okl_product_parameters_v.REVENUE_RECOGNITION_METHOD%TYPE;
98: G_INTEREST_CALCULATION_BASIS okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;
99: G_DEAL_TYPE okl_product_parameters_v.DEAL_TYPE%TYPE;
100:
101: -- hariven - Bug#5393374 - Added - Start
102: G_WF_EVT_KHR_IMPORTED CONSTANT VARCHAR2(50) := 'oracle.apps.okl.la.lease_contract.imported';
103: G_WF_ITM_CONTRACT_ID CONSTANT VARCHAR2(11) := 'CONTRACT_ID';

Line 3594: l_revenue_recognition_method okl_product_parameters_v.REVENUE_RECOGNITION_METHOD%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;
3598:

Line 3595: l_interest_calculation_basis okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;

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;
3598:
3599: CURSOR product_csr(p_product_name okl_products_v.name%TYPE,

Line 3596: l_deal_type okl_product_parameters_v.DEAL_TYPE%TYPE;

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;
3598:
3599: CURSOR product_csr(p_product_name okl_products_v.name%TYPE,
3600: p_product_id okl_products_v.id%TYPE) IS

Line 3606: okl_product_parameters_v b

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
3610: )