APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_CALENDAR_SHIFTS

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

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

Line 1417: UPDATE MSC_CALENDAR_SHIFTS

1413: BEGIN
1414:
1415: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1416:
1417: UPDATE MSC_CALENDAR_SHIFTS
1418: SET
1419: DAYS_ON= c_rec.DAYS_ON,
1420: DAYS_OFF= c_rec.DAYS_OFF,
1421: DESCRIPTION= c_rec.DESCRIPTION,

Line 1433: INSERT INTO MSC_CALENDAR_SHIFTS

1429: END IF;
1430:
1431: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1432:
1433: INSERT INTO MSC_CALENDAR_SHIFTS
1434: ( CALENDAR_CODE,
1435: SHIFT_NUM,
1436: DAYS_ON,
1437: DAYS_OFF,

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

1471: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1473: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1474: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1475: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_SHIFTS');
1476: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1477:
1478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1479: RAISE;

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

1483:
1484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1485: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1486: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1487: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_SHIFTS');
1488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1489:
1490: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1491: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');