126: G_WF_ITM_CONTRACT_ID CONSTANT VARCHAR2(20) := 'CONTRACT_ID';
127: G_WF_ITM_ASSET_ID CONSTANT VARCHAR2(10) := 'ASSET_ID';
128: G_WF_ITM_TRANS_DATE CONSTANT VARCHAR2(20) := 'TRANSACTION_DATE';
129: -- Bug# 4542290 - smadhava - Added - Start
130: G_RRB_ESTIMATED CONSTANT OKL_PQY_VALUES_V.VALUE%TYPE := 'ESTIMATED_AND_BILLED';
131: G_RRB_ACTUAL CONSTANT OKL_PQY_VALUES_V.VALUE%TYPE := 'ACTUAL';
132: -- Bug# 4542290 - smadhava - Added - End
133:
134: --Bug# 6612475 Start
127: G_WF_ITM_ASSET_ID CONSTANT VARCHAR2(10) := 'ASSET_ID';
128: G_WF_ITM_TRANS_DATE CONSTANT VARCHAR2(20) := 'TRANSACTION_DATE';
129: -- Bug# 4542290 - smadhava - Added - Start
130: G_RRB_ESTIMATED CONSTANT OKL_PQY_VALUES_V.VALUE%TYPE := 'ESTIMATED_AND_BILLED';
131: G_RRB_ACTUAL CONSTANT OKL_PQY_VALUES_V.VALUE%TYPE := 'ACTUAL';
132: -- Bug# 4542290 - smadhava - Added - End
133:
134: --Bug# 6612475 Start
135: ------------------------------------------------------------------------------
6016: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
6017: l_rev_recog_meaning OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_MEANING%TYPE;
6018:
6019: CURSOR get_prod_param_values(cp_name OKL_PDT_QUALITYS.NAME%TYPE
6020: , cp_value OKL_PQY_VALUES.VALUE%TYPE) IS
6021: SELECT
6022: QVE.DESCRIPTION
6023: FROM
6024: OKL_PDT_QUALITYS PQY