APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_DEMAND_CLASSES

Line 3711: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEMAND_CLASSES', MSC_CL_COLLECTION.v_instance_id, NULL);

3707: BEGIN
3708:
3709: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
3710:
3711: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEMAND_CLASSES', MSC_CL_COLLECTION.v_instance_id, NULL);
3712:
3713: END IF;
3714:
3715: -- IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN

Line 3723: UPDATE MSC_DEMAND_CLASSES

3719: BEGIN
3720:
3721: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
3722:
3723: UPDATE MSC_DEMAND_CLASSES
3724: SET
3725: MEANING = c_rec.MEANING,
3726: DESCRIPTION = c_rec.DESCRIPTION,
3727: FROM_DATE = c_rec.FROM_DATE,

Line 3739: INSERT INTO MSC_DEMAND_CLASSES

3735: END IF;
3736:
3737: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) OR (MSC_CL_COLLECTION.v_is_legacy_refresh AND SQL%NOTFOUND) THEN
3738:
3739: INSERT INTO MSC_DEMAND_CLASSES
3740: ( DEMAND_CLASS,
3741: MEANING,
3742: DESCRIPTION,
3743: FROM_DATE,

Line 3774: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');

3770:
3771: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3772: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3773: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3774: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3776:
3777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3778: RAISE;

Line 3787: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');

3783:
3784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3785: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3786: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3787: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3789:
3790: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3791: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_CLASS');