APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_UOM_CLASS_CONVERSIONS

Line 3370: DELETE FROM MSC_UOM_CLASS_CONVERSIONS

3366:
3367: /*
3368: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
3369:
3370: DELETE FROM MSC_UOM_CLASS_CONVERSIONS
3371: WHERE SR_INSTANCE_ID IN ( MSC_CL_COLLECTION.v_instance_id, -MSC_CL_COLLECTION.v_instance_id);
3372:
3373: COMMIT;
3374:

Line 3384: UPDATE MSC_UOM_CLASS_CONVERSIONS mucc

3380: FOR c_rec IN c2 LOOP
3381:
3382: BEGIN
3383:
3384: UPDATE MSC_UOM_CLASS_CONVERSIONS mucc
3385: SET mucc.FROM_UOM_CODE= c_rec.FROM_UOM_CODE,
3386: mucc.FROM_UOM_CLASS= c_rec.FROM_UOM_CLASS,
3387: mucc.TO_UOM_CODE= c_rec.TO_UOM_CODE,
3388: mucc.TO_UOM_CLASS= c_rec.TO_UOM_CLASS,

Line 3401: insert into MSC_UOM_CLASS_CONVERSIONS

3397: AND mucc.TO_UNIT_OF_MEASURE= c_rec.TO_UNIT_OF_MEASURE;
3398:
3399: IF SQL%NOTFOUND THEN
3400:
3401: insert into MSC_UOM_CLASS_CONVERSIONS
3402: ( INVENTORY_ITEM_ID,
3403: FROM_UNIT_OF_MEASURE,
3404: FROM_UOM_CODE,
3405: FROM_UOM_CLASS,

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

3447:
3448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3449: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3450: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UOM');
3451: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UOM_CLASS_CONVERSIONS');
3452: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3453:
3454: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3455: RAISE;

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

3460:
3461: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3462: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3463: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UOM');
3464: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UOM_CLASS_CONVERSIONS');
3465: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3466:
3467: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3468: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.item_name');