APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_CALENDAR_SHIFTS

Line 1301: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_CALENDAR_SHIFTS', MSC_CL_COLLECTION.v_instance_id, NULL);

1297: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1298:
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);

Line 1422: UPDATE MSC_CALENDAR_SHIFTS

1418: BEGIN
1419:
1420: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1421:
1422: UPDATE MSC_CALENDAR_SHIFTS
1423: SET
1424: DAYS_ON= c_rec.DAYS_ON,
1425: DAYS_OFF= c_rec.DAYS_OFF,
1426: DESCRIPTION= c_rec.DESCRIPTION,

Line 1438: INSERT INTO MSC_CALENDAR_SHIFTS

1434: END IF;
1435:
1436: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1437:
1438: INSERT INTO MSC_CALENDAR_SHIFTS
1439: ( CALENDAR_CODE,
1440: SHIFT_NUM,
1441: DAYS_ON,
1442: DAYS_OFF,

Line 1480: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_SHIFTS');

1476: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1478: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1479: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1480: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_SHIFTS');
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1482:
1483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1484: RAISE;

Line 1492: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_SHIFTS');

1488:
1489: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1490: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1491: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1492: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_SHIFTS');
1493: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1494:
1495: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1496: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');