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 885: UPDATE MSC_PERIOD_START_DATES

881: BEGIN
882:
883: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
884:
885: UPDATE MSC_PERIOD_START_DATES
886: SET
887: PERIOD_SEQUENCE_NUM= c_rec.PERIOD_SEQUENCE_NUM,
888: PERIOD_NAME= c_rec.PERIOD_NAME,
889: NEXT_DATE= c_rec.NEXT_DATE,

Line 904: INSERT INTO MSC_PERIOD_START_DATES

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

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

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

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

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