APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_SHIFT_DATES

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

1295: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_SHIFTS', MSC_CL_COLLECTION.v_instance_id, NULL);
1296:
1297: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_CALENDAR_SHIFTS', MSC_CL_COLLECTION.v_instance_id, NULL);
1298:
1299: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SHIFT_DATES', MSC_CL_COLLECTION.v_instance_id, NULL);
1300:
1301: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_CHANGES', MSC_CL_COLLECTION.v_instance_id, NULL);
1302:
1303: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SHIFT_TIMES', MSC_CL_COLLECTION.v_instance_id, NULL);

Line 1517: UPDATE MSC_SHIFT_DATES

1513: BEGIN
1514:
1515: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1516:
1517: UPDATE MSC_SHIFT_DATES
1518: SET
1519: SEQ_NUM= c_rec.SEQ_NUM,
1520: NEXT_SEQ_NUM= c_rec.NEXT_SEQ_NUM,
1521: PRIOR_SEQ_NUM= c_rec.PRIOR_SEQ_NUM,

Line 1537: INSERT INTO MSC_SHIFT_DATES

1533: END IF;
1534:
1535: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1536:
1537: INSERT INTO MSC_SHIFT_DATES
1538: ( CALENDAR_CODE,
1539: EXCEPTION_SET_ID,
1540: SHIFT_NUM,
1541: SHIFT_DATE,

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

1582: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1583: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1584: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1585: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1586: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_DATES');
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1588:
1589: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1590: RAISE;

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

1594:
1595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1596: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1597: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1598: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_DATES');
1599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1600:
1601: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1602: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');