APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_UNITS_OF_MEASURE

Line 3262: DELETE FROM MSC_UNITS_OF_MEASURE

3258:
3259: /*
3260: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
3261:
3262: DELETE FROM MSC_UNITS_OF_MEASURE
3263: WHERE SR_INSTANCE_ID IN ( MSC_CL_COLLECTION.v_instance_id, -MSC_CL_COLLECTION.v_instance_id);
3264:
3265: END IF;
3266: */

Line 3274: UPDATE MSC_UNITS_OF_MEASURE muom

3270: FOR c_rec IN c1 LOOP
3271:
3272: BEGIN
3273:
3274: UPDATE MSC_UNITS_OF_MEASURE muom
3275: SET muom.UOM_CODE= c_rec.UOM_CODE,
3276: muom.UOM_CLASS= c_rec.UOM_CLASS,
3277: muom.BASE_UOM_FLAG= c_rec.BASE_UOM_FLAG,
3278: muom.DISABLE_DATE= c_rec.DISABLE_DATE,

Line 3288: INSERT INTO MSC_UNITS_OF_MEASURE

3284: WHERE muom.UNIT_OF_MEASURE= c_rec.UNIT_OF_MEASURE;
3285:
3286: IF SQL%NOTFOUND THEN
3287:
3288: INSERT INTO MSC_UNITS_OF_MEASURE
3289: ( UNIT_OF_MEASURE,
3290: UOM_CODE,
3291: UOM_CLASS,
3292: BASE_UOM_FLAG,

Line 3332: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNITS_OF_MEASURE');

3328:
3329: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3330: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3331: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UOM');
3332: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNITS_OF_MEASURE');
3333: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3334:
3335: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3336: RAISE;

Line 3345: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNITS_OF_MEASURE');

3341:
3342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3343: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3344: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UOM');
3345: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNITS_OF_MEASURE');
3346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3347:
3348: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3349: FND_MESSAGE.SET_TOKEN('COLUMN', 'UOM_CODE');