APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_SHIFT_TIMES

Line 1307: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SHIFT_TIMES', MSC_CL_COLLECTION.v_instance_id, NULL);

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);
1310:
1311: END IF;

Line 1772: UPDATE MSC_SHIFT_TIMES

1768: BEGIN
1769:
1770: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1771:
1772: UPDATE MSC_SHIFT_TIMES
1773: SET
1774: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1775: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1776: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 1787: INSERT INTO MSC_SHIFT_TIMES

1783: END IF;
1784:
1785: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1786:
1787: INSERT INTO MSC_SHIFT_TIMES
1788: ( CALENDAR_CODE,
1789: SHIFT_NUM,
1790: FROM_TIME,
1791: TO_TIME,

Line 1826: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_TIMES');

1822: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1823: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1824: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1825: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1826: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_TIMES');
1827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1828:
1829: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1830: RAISE;

Line 1838: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_TIMES');

1834:
1835: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1836: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1837: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1838: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_TIMES');
1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1840:
1841: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1842: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');