APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_BIS_TARGETS

Line 2902: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_TARGETS', MSC_CL_COLLECTION.v_instance_id, NULL);

2898: BEGIN
2899:
2900: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2901:
2902: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_TARGETS', MSC_CL_COLLECTION.v_instance_id, NULL);
2903:
2904: c_count:= 0;
2905:
2906: FOR c_rec IN c3 LOOP

Line 2910: INSERT INTO MSC_BIS_TARGETS

2906: FOR c_rec IN c3 LOOP
2907:
2908: BEGIN
2909:
2910: INSERT INTO MSC_BIS_TARGETS
2911: ( TARGET_ID,
2912: TARGET_LEVEL_ID,
2913: BUSINESS_PLAN_ID,
2914: ORG_LEVEL_VALUE_ID,

Line 2984: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');

2980:
2981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2982: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2983: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2984: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2986:
2987: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2988: RAISE;

Line 2996: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');

2992:
2993: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2994: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2995: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2996: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2998:
2999: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3000: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_ID');