APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_RESOURCE_CHANGES

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

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);
1306:
1307: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SHIFT_TIMES', MSC_CL_COLLECTION.v_instance_id, NULL);
1308:
1309: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SHIFT_EXCEPTIONS', MSC_CL_COLLECTION.v_instance_id, NULL);

Line 1645: DELETE MSC_RESOURCE_CHANGES

1641: IF MSC_CL_COLLECTION.v_is_incremental_refresh AND c_rec.DELETED_FLAG= MSC_UTIL.SYS_YES THEN
1642:
1643: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
1644:
1645: DELETE MSC_RESOURCE_CHANGES
1646: WHERE DEPARTMENT_ID= c_rec.DEPARTMENT_ID
1647: AND RESOURCE_ID= c_rec.RESOURCE_ID
1648: AND SHIFT_NUM= c_rec.SHIFT_NUM
1649: AND FROM_DATE= c_rec.FROM_DATE

Line 1659: INSERT INTO MSC_RESOURCE_CHANGES

1655: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
1656:
1657: ELSE
1658:
1659: INSERT INTO MSC_RESOURCE_CHANGES
1660: ( DEPARTMENT_ID,
1661: RESOURCE_ID,
1662: SHIFT_NUM,
1663: FROM_DATE,

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

1707: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1709: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1710: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1711: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHANGES');
1712: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1713:
1714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1715: RAISE;

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

1719:
1720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1721: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1722: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1723: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_CHANGES');
1724: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1725:
1726: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1727: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');