APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_SHIFT_DATES

Line 1303: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SHIFT_DATES', MSC_CL_COLLECTION.v_instance_id, NULL);

1299: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_SHIFTS', MSC_CL_COLLECTION.v_instance_id, NULL);
1300:
1301: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_CALENDAR_SHIFTS', MSC_CL_COLLECTION.v_instance_id, NULL);
1302:
1303: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SHIFT_DATES', MSC_CL_COLLECTION.v_instance_id, NULL);
1304:
1305: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_CHANGES', MSC_CL_COLLECTION.v_instance_id, NULL);
1306:
1307: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SHIFT_TIMES', MSC_CL_COLLECTION.v_instance_id, NULL);

Line 1522: UPDATE MSC_SHIFT_DATES

1518: BEGIN
1519:
1520: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1521:
1522: UPDATE MSC_SHIFT_DATES
1523: SET
1524: SEQ_NUM= c_rec.SEQ_NUM,
1525: NEXT_SEQ_NUM= c_rec.NEXT_SEQ_NUM,
1526: PRIOR_SEQ_NUM= c_rec.PRIOR_SEQ_NUM,

Line 1542: INSERT INTO MSC_SHIFT_DATES

1538: END IF;
1539:
1540: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1541:
1542: INSERT INTO MSC_SHIFT_DATES
1543: ( CALENDAR_CODE,
1544: EXCEPTION_SET_ID,
1545: SHIFT_NUM,
1546: SHIFT_DATE,

Line 1591: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_DATES');

1587: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1589: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1590: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1591: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_DATES');
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593:
1594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1595: RAISE;

Line 1603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_DATES');

1599:
1600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1601: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1602: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_DATES');
1604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1605:
1606: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1607: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');