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.

[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_PRODUCT_PARAMETERS_V

Line 100: G_REVENUE_RECOGNITION_METHOD okl_product_parameters_v.REVENUE_RECOGNITION_METHOD%TYPE;

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

Line 101: G_INTEREST_CALCULATION_BASIS okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;

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

Line 102: G_DEAL_TYPE okl_product_parameters_v.DEAL_TYPE%TYPE;

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

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

Line 3763: l_interest_calculation_basis okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;

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

Line 3764: l_deal_type okl_product_parameters_v.DEAL_TYPE%TYPE;

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

Line 3774: okl_product_parameters_v b

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