APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_UOM_CLASS_CONVERSIONS

Line 3360: DELETE FROM MSC_UOM_CLASS_CONVERSIONS

3356:
3357: /*
3358: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
3359:
3360: DELETE FROM MSC_UOM_CLASS_CONVERSIONS
3361: WHERE SR_INSTANCE_ID IN ( MSC_CL_COLLECTION.v_instance_id, -MSC_CL_COLLECTION.v_instance_id);
3362:
3363: COMMIT;
3364:

Line 3374: UPDATE MSC_UOM_CLASS_CONVERSIONS mucc

3370: FOR c_rec IN c2 LOOP
3371:
3372: BEGIN
3373:
3374: UPDATE MSC_UOM_CLASS_CONVERSIONS mucc
3375: SET mucc.FROM_UOM_CODE= c_rec.FROM_UOM_CODE,
3376: mucc.FROM_UOM_CLASS= c_rec.FROM_UOM_CLASS,
3377: mucc.TO_UOM_CODE= c_rec.TO_UOM_CODE,
3378: mucc.TO_UOM_CLASS= c_rec.TO_UOM_CLASS,

Line 3391: insert into MSC_UOM_CLASS_CONVERSIONS

3387: AND mucc.TO_UNIT_OF_MEASURE= c_rec.TO_UNIT_OF_MEASURE;
3388:
3389: IF SQL%NOTFOUND THEN
3390:
3391: insert into MSC_UOM_CLASS_CONVERSIONS
3392: ( INVENTORY_ITEM_ID,
3393: FROM_UNIT_OF_MEASURE,
3394: FROM_UOM_CODE,
3395: FROM_UOM_CLASS,

Line 3441: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UOM_CLASS_CONVERSIONS');

3437:
3438: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3439: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3440: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UOM');
3441: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UOM_CLASS_CONVERSIONS');
3442: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3443:
3444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3445: RAISE;

Line 3454: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UOM_CLASS_CONVERSIONS');

3450:
3451: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3452: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3453: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UOM');
3454: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UOM_CLASS_CONVERSIONS');
3455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3456:
3457: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3458: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.item_name');