APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_CAL_YEAR_START_DATES

Line 461: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_CAL_YEAR_START_DATES', MSC_CL_COLLECTION.v_instance_id, NULL);

457: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
458:
459: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PERIOD_START_DATES', MSC_CL_COLLECTION.v_instance_id, NULL);
460:
461: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_CAL_YEAR_START_DATES', MSC_CL_COLLECTION.v_instance_id, NULL);
462:
463: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_CAL_WEEK_START_DATES', MSC_CL_COLLECTION.v_instance_id, NULL);
464:
465: END IF;

Line 998: UPDATE MSC_CAL_YEAR_START_DATES

994: BEGIN
995:
996: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
997:
998: UPDATE MSC_CAL_YEAR_START_DATES
999: SET
1000: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1001: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1002: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 1013: INSERT INTO MSC_CAL_YEAR_START_DATES

1009:
1010:
1011: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1012:
1013: INSERT INTO MSC_CAL_YEAR_START_DATES
1014: ( CALENDAR_CODE,
1015: EXCEPTION_SET_ID,
1016: YEAR_START_DATE,
1017: SR_INSTANCE_ID,

Line 1050: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CAL_YEAR_START_DATES');

1046: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1048: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1049: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
1050: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CAL_YEAR_START_DATES');
1051: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1052:
1053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1054: RAISE;

Line 1062: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CAL_YEAR_START_DATES');

1058:
1059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1060: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1061: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
1062: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CAL_YEAR_START_DATES');
1063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1064:
1065: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1066: FND_MESSAGE.SET_TOKEN('COLUMN', 'EXCEPTION_SET_ID');