APPS.IBE_CATALOG_PVT dependencies on IBE_TEMP_TABLE

Line 3042: where MSIV.INVENTORY_ITEM_ID IN (select NUM_VAL from IBE_TEMP_TABLE where key =

3038: l_init_msg_list VARCHAR2(5);
3039: cursor l_itm_attr_csr(l_temp_key VARCHAR2, l_org_id NUMBER) IS
3040: select MSIV.SERVICE_ITEM_FLAG,MSIV.SERVICEABLE_PRODUCT_FLAG
3041: from MTL_SYSTEM_ITEMS_VL MSIV
3042: where MSIV.INVENTORY_ITEM_ID IN (select NUM_VAL from IBE_TEMP_TABLE where key =
3043: l_temp_key ) and MSIV.ORGANIZATION_ID = l_org_id;
3044:
3045: BEGIN
3046: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

Line 3191: (select NUM_VAL from IBE_TEMP_TABLE where key = l_temp_key );

3187: select b.inventory_item_id
3188: from ibe_dsp_msite_sct_items a, ibe_dsp_section_items b
3189: where a.section_item_id = b.section_item_id
3190: and a.mini_site_id = l_minisite_id and b.inventory_item_id IN
3191: (select NUM_VAL from IBE_TEMP_TABLE where key = l_temp_key );
3192:
3193: BEGIN
3194:
3195: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN