APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_BIS_BUSINESS_PLANS

Line 3057: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_BUSINESS_PLANS', MSC_CL_COLLECTION.v_instance_id, NULL);

3053: BEGIN
3054:
3055: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
3056:
3057: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_BUSINESS_PLANS', MSC_CL_COLLECTION.v_instance_id, NULL);
3058:
3059: END IF;
3060:
3061: c_count:= 0;

Line 3066: INSERT INTO MSC_BIS_BUSINESS_PLANS

3062:
3063: FOR c_rec IN c4 LOOP
3064:
3065: BEGIN
3066: INSERT INTO MSC_BIS_BUSINESS_PLANS
3067: ( BUSINESS_PLAN_ID,
3068: SHORT_NAME,
3069: NAME,
3070: DESCRIPTION,

Line 3106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');

3102:
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3104: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3108:
3109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3110: RAISE;

Line 3119: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');

3115:
3116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3117: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3118: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3119: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3121:
3122: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3123: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');