APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_BIS_TARGET_LEVELS

Line 2740: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_TARGET_LEVELS', MSC_CL_COLLECTION.v_instance_id, NULL);

2736: BEGIN
2737:
2738: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2739:
2740: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_TARGET_LEVELS', MSC_CL_COLLECTION.v_instance_id, NULL);
2741:
2742: END IF;
2743:
2744: c_count:= 0;

Line 2750: INSERT INTO MSC_BIS_TARGET_LEVELS

2746: FOR c_rec IN c2 LOOP
2747:
2748: BEGIN
2749:
2750: INSERT INTO MSC_BIS_TARGET_LEVELS
2751: ( TARGET_LEVEL_ID,
2752: TARGET_LEVEL_SHORT_NAME,
2753: TARGET_LEVEL_NAME,
2754: DESCRIPTION,

Line 2818: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');

2814:
2815: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2816: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2818: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2820:
2821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2822: RAISE;

Line 2831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');

2827:
2828: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2833:
2834: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2835: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');