The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'OKL_PRICING_OBJECTS' AND LOOKUP_CODE = object_type;
SELECT STD_RATE_TMPL_VER_ID,
OBJECT_VERSION_NUMBER,
VERSION_NUMBER,
STD_RATE_TMPL_ID,
EFFECTIVE_FROM_DATE,
EFFECTIVE_TO_DATE,
STS_CODE,
ADJ_MAT_VERSION_ID,
SRT_RATE,
SPREAD,
DAY_CONVENTION_CODE,
MIN_ADJ_RATE,
MAX_ADJ_RATE,
CURRENCY_CODE,
RATE_CARD_YN,
PRICING_ENGINE_CODE,
ORIG_STD_RATE_TMPL_ID,
RATE_TYPE_CODE,
FREQUENCY_CODE,
INDEX_ID,
HDR_STS_CODE,
HDR_EFFECTIVE_FROM_DATE,
HDR_EFFECTIVE_TO_DATE,
HDR_SRT_RATE,
TEMPLATE_NAME,
TEMPLATE_DESC
FROM OKL_FE_STD_RT_TMP_VERS_V
WHERE STD_RATE_TMPL_VER_ID = p_srt_version_id;
SELECT USER_NAME
FROM FND_USER
WHERE USER_ID = fnd_global.user_id;
SELECT APPLICATION_ID
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
okl_srv_pvt.update_row(l_api_version,
p_init_msg_list,
x_return_status,
lx_msg_count,
lx_msg_data,
l_srv_rec,
x_srv_rec);
SELECT ADJ_MAT_VERSION_ID,
OBJECT_VERSION_NUMBER,
VERSION_NUMBER,
ADJ_MAT_ID,
STS_CODE,
EFFECTIVE_FROM_DATE,
EFFECTIVE_TO_DATE,
CURRENCY_CODE,
ADJ_MAT_TYPE_CODE,
ORIG_ADJ_MAT_ID,
HDR_STS_CODE,
HDR_EFFECTIVE_FROM_DATE,
HDR_EFFECTIVE_TO_DATE,
ADJ_MAT_NAME,
ADJ_MAT_DESC
FROM OKL_FE_ADJ_MAT_VERS_V
WHERE ADJ_MAT_VERSION_ID = p_adj_mat_ver_id;
SELECT USER_NAME
FROM FND_USER
WHERE USER_ID = fnd_global.user_id;
SELECT APPLICATION_ID
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
okl_pal_pvt.update_row(l_api_version,
p_init_msg_list,
x_return_status,
lx_msg_count,
lx_msg_data,
l_pal_rec,
x_pal_rec);
SELECT END_OF_TERM_VER_ID,
OBJECT_VERSION_NUMBER,
VERSION_NUMBER,
END_OF_TERM_ID,
STS_CODE,
EFFECTIVE_FROM_DATE,
EFFECTIVE_TO_DATE,
CURRENCY_CODE,
EOT_TYPE_CODE,
PRODUCT_ID,
CATEGORY_TYPE_CODE,
ORIG_END_OF_TERM_ID,
HDR_STS_CODE,
HDR_EFFECTIVE_FROM_DATE,
HDR_EFFECTIVE_TO_DATE,
END_OF_TERM_NAME,
END_OF_TERM_DESC
FROM OKL_FE_EO_TERM_VERS_V
WHERE END_OF_TERM_VER_ID = p_eot_version_id;
SELECT USER_NAME
FROM FND_USER
WHERE USER_ID = fnd_global.user_id;
SELECT APPLICATION_ID
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
okl_eve_pvt.update_row(l_api_version,
p_init_msg_list,
x_return_status,
lx_msg_count,
lx_msg_data,
l_eve_rec,
x_eve_rec);
SELECT A.ID,
A.NAME,
A.DESCRIPTION,
A.LRS_TYPE_CODE,
A.END_OF_TERM_ID,
A.CURRENCY_CODE,
A.FRQ_CODE,
B.RATE_SET_VERSION_ID,
B.STS_CODE,
B.ARREARS_YN,
B.EFFECTIVE_FROM_DATE,
B.EFFECTIVE_TO_DATE,
B.END_OF_TERM_VER_ID,
B.STD_RATE_TMPL_VER_ID,
B.ADJ_MAT_VERSION_ID,
B.VERSION_NUMBER,
B.LRS_RATE,
B.RATE_TOLERANCE,
B.RESIDUAL_TOLERANCE,
B.DEFERRED_PMTS,
B.ADVANCE_PMTS
FROM OKL_LS_RT_FCTR_SETS_V A,
OKL_FE_RATE_SET_VERSIONS B
WHERE A.ID = B.RATE_SET_ID
AND B.RATE_SET_VERSION_ID = p_rate_set_ver_id;
SELECT USER_NAME
FROM FND_USER
WHERE USER_ID = fnd_global.user_id;
SELECT APPLICATION_ID
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
okl_lrv_pvt.update_row(l_api_version,
p_init_msg_list,
x_return_status,
lx_msg_count,
lx_msg_data,
l_lrvv_rec,
x_lrvv_rec);
SELECT IRHV.ITEM_RESIDUAL_ID,
IRHV.CATEGORY_TYPE_CODE,
IRHV.INVENTORY_ITEM_ID,
IRHV.ORGANIZATION_ID,
IRHV.CATEGORY_ID,
IRHV.CATEGORY_SET_ID,
IRHV.RESI_CATEGORY_SET_ID,
IRHV.RESIDUAL_TYPE_CODE,
IRHV.CURRENCY_CODE,
INV.CONCATENATED_SEGMENTS NAME,
ICPV.VERSION_NUMBER,
ICPV.STS_CODE,
ICPV.START_DATE,
ICPV.END_DATE,
ICPV.ID
FROM OKL_FE_ITEM_RESIDUAL IRHV,
OKL_ITM_CAT_RV_PRCS_V ICPV,
MTL_SYSTEM_ITEMS_VL INV
WHERE IRHV.INVENTORY_ITEM_ID = INV.INVENTORY_ITEM_ID
AND IRHV.ORGANIZATION_ID = INV.ORGANIZATION_ID
AND ICPV.ITEM_RESIDUAL_ID = IRHV.ITEM_RESIDUAL_ID
AND ICPV.ID = p_itm_resdl_ver_id;
SELECT IRHV.ITEM_RESIDUAL_ID,
IRHV.CATEGORY_TYPE_CODE,
IRHV.INVENTORY_ITEM_ID,
IRHV.ORGANIZATION_ID,
IRHV.CATEGORY_ID,
IRHV.CATEGORY_SET_ID,
IRHV.RESI_CATEGORY_SET_ID,
IRHV.RESIDUAL_TYPE_CODE,
IRHV.CURRENCY_CODE,
INVCAT.CATEGORY_CONCAT_SEGS NAME,
ICPV.VERSION_NUMBER,
ICPV.STS_CODE,
ICPV.START_DATE,
ICPV.END_DATE,
ICPV.ID
FROM OKL_FE_ITEM_RESIDUAL IRHV,
OKL_ITM_CAT_RV_PRCS_V ICPV,
MTL_CATEGORIES_V INVCAT
WHERE IRHV.CATEGORY_ID = INVCAT.CATEGORY_ID
AND ICPV.ITEM_RESIDUAL_ID = IRHV.ITEM_RESIDUAL_ID
AND ICPV.ID = p_itm_resdl_ver_id;
SELECT IRHV.ITEM_RESIDUAL_ID,
IRHV.CATEGORY_TYPE_CODE,
IRHV.INVENTORY_ITEM_ID,
IRHV.ORGANIZATION_ID,
IRHV.CATEGORY_ID,
IRHV.CATEGORY_SET_ID,
IRHV.RESI_CATEGORY_SET_ID,
IRHV.RESIDUAL_TYPE_CODE,
IRHV.CURRENCY_CODE,
RCSV.RESI_CAT_NAME NAME,
ICPV.VERSION_NUMBER,
ICPV.STS_CODE,
ICPV.START_DATE,
ICPV.END_DATE,
ICPV.ID
FROM OKL_FE_ITEM_RESIDUAL IRHV,
OKL_ITM_CAT_RV_PRCS_V ICPV,
OKL_FE_RESI_CAT_V RCSV
WHERE IRHV.RESI_CATEGORY_SET_ID = RCSV.RESI_CATEGORY_SET_ID
AND ICPV.ITEM_RESIDUAL_ID = IRHV.ITEM_RESIDUAL_ID
AND ICPV.ID = p_itm_resdl_ver_id;
SELECT USER_NAME
FROM FND_USER
WHERE USER_ID = fnd_global.user_id;
SELECT APPLICATION_ID
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
SELECT IRHV.CATEGORY_TYPE_CODE
FROM OKL_FE_ITEM_RESIDUAL IRHV,
OKL_ITM_CAT_RV_PRCS_V ICPV
WHERE IRHV.ITEM_RESIDUAL_ID = ICPV.ITEM_RESIDUAL_ID
AND ICPV.ID = p_item_resdl_version_id; -- Item residual version ID
Select the category type of the item residual.
*/
OPEN c_get_cat_type(l_item_resdl_version_id);
okl_icp_pvt.update_row(l_api_version,
p_init_msg_list,
x_return_status,
lx_msg_count,
lx_msg_data,
l_icpv_rec,
x_icpv_rec);
SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'OKL_PRICING_OBJECTS' AND LOOKUP_CODE = 'PAM';
SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'OKL_PRICING_OBJECTS' AND LOOKUP_CODE = 'SRT';
SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'OKL_PRICING_OBJECTS' AND LOOKUP_CODE = 'EOT';
SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'OKL_PRICING_OBJECTS' AND LOOKUP_CODE = 'IRS';
SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'OKL_PRICING_OBJECTS' AND LOOKUP_CODE = 'LRS';