APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_RESOURCE_CHANGES

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

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);
1304:
1305: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SHIFT_EXCEPTIONS', MSC_CL_COLLECTION.v_instance_id, NULL);

Line 1640: DELETE MSC_RESOURCE_CHANGES

1636: IF MSC_CL_COLLECTION.v_is_incremental_refresh AND c_rec.DELETED_FLAG= MSC_UTIL.SYS_YES THEN
1637:
1638: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
1639:
1640: DELETE MSC_RESOURCE_CHANGES
1641: WHERE DEPARTMENT_ID= c_rec.DEPARTMENT_ID
1642: AND RESOURCE_ID= c_rec.RESOURCE_ID
1643: AND SHIFT_NUM= c_rec.SHIFT_NUM
1644: AND FROM_DATE= c_rec.FROM_DATE

Line 1654: INSERT INTO MSC_RESOURCE_CHANGES

1650: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
1651:
1652: ELSE
1653:
1654: INSERT INTO MSC_RESOURCE_CHANGES
1655: ( DEPARTMENT_ID,
1656: RESOURCE_ID,
1657: SHIFT_NUM,
1658: FROM_DATE,

Line 1706: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHANGES');

1702: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1703: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1704: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1705: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1706: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHANGES');
1707: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1708:
1709: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1710: RAISE;

Line 1718: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHANGES');

1714:
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1716: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1717: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1718: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHANGES');
1719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1720:
1721: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1722: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');