APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_RESOURCE_SHIFTS

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

1295: MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_incremental_refresh) then
1296:
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);

Line 1321: UPDATE MSC_RESOURCE_SHIFTS

1317: BEGIN
1318:
1319: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1320:
1321: UPDATE MSC_RESOURCE_SHIFTS
1322: SET
1323: CAPACITY_UNITS=c_rec.CAPACITY_UNITS,
1324: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1325: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 1336: INSERT INTO MSC_RESOURCE_SHIFTS

1332: END IF;
1333:
1334: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1335:
1336: INSERT INTO MSC_RESOURCE_SHIFTS
1337: ( DEPARTMENT_ID,
1338: RESOURCE_ID,
1339: SHIFT_NUM,
1340: CAPACITY_UNITS,

Line 1375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SHIFTS');

1371: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1373: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1374: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SHIFTS');
1376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1377:
1378: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1379: RAISE;

Line 1387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SHIFTS');

1383:
1384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1385: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SHIFTS');
1388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1389:
1390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1391: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');