DBA Data[Home] [Help]

APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_BIS_PERFORMANCE_MEASURES

Line 2603: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERFORMANCE_MEASURES', MSC_CL_COLLECTION.v_instance_id, NULL);

2599: BEGIN
2600:
2601: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2602:
2603: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERFORMANCE_MEASURES', MSC_CL_COLLECTION.v_instance_id, NULL);
2604:
2605: END IF;
2606:
2607: c_count:= 0;

Line 2613: INSERT INTO MSC_BIS_PERFORMANCE_MEASURES

2609: FOR c_rec IN c1 LOOP
2610:
2611: BEGIN
2612:
2613: INSERT INTO MSC_BIS_PERFORMANCE_MEASURES
2614: ( MEASURE_ID,
2615: MEASURE_SHORT_NAME,
2616: MEASURE_NAME,
2617: DESCRIPTION,

Line 2665: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');

2661:
2662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2663: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2664: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2665: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2667:
2668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2669: RAISE;

Line 2677: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');

2673:
2674: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2675: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2676: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2677: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2679:
2680: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2681: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');