APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_PERIOD_START_DATES

Line 459: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PERIOD_START_DATES', MSC_CL_COLLECTION.v_instance_id, NULL);

455:
456:
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);

Line 882: UPDATE MSC_PERIOD_START_DATES

878: BEGIN
879:
880: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
881:
882: UPDATE MSC_PERIOD_START_DATES
883: SET
884: PERIOD_SEQUENCE_NUM= c_rec.PERIOD_SEQUENCE_NUM,
885: PERIOD_NAME= c_rec.PERIOD_NAME,
886: NEXT_DATE= c_rec.NEXT_DATE,

Line 901: INSERT INTO MSC_PERIOD_START_DATES

897:
898:
899: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
900:
901: INSERT INTO MSC_PERIOD_START_DATES
902: ( CALENDAR_CODE,
903: EXCEPTION_SET_ID,
904: PERIOD_START_DATE,
905: PERIOD_SEQUENCE_NUM,

Line 948: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PERIOD_START_DATES');

944:
945: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
946: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
947: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
948: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PERIOD_START_DATES');
949: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
950:
951: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
952: RAISE;

Line 960: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PERIOD_START_DATES');

956:
957: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
958: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
959: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
960: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PERIOD_START_DATES');
961: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
962:
963: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
964: FND_MESSAGE.SET_TOKEN('COLUMN', 'EXCEPTION_SET_ID');