APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_SHIFT_EXCEPTIONS

Line 1309: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SHIFT_EXCEPTIONS', MSC_CL_COLLECTION.v_instance_id, NULL);

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;
1312:
1313: c_count:= 0;

Line 1878: UPDATE MSC_SHIFT_EXCEPTIONS

1874: BEGIN
1875:
1876: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1877:
1878: UPDATE MSC_SHIFT_EXCEPTIONS
1879: SET
1880: EXCEPTION_TYPE= c_rec.EXCEPTION_TYPE,
1881: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1882: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 1894: INSERT INTO MSC_SHIFT_EXCEPTIONS

1890: END IF;
1891:
1892: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1893:
1894: INSERT INTO MSC_SHIFT_EXCEPTIONS
1895: ( CALENDAR_CODE,
1896: SHIFT_NUM,
1897: EXCEPTION_SET_ID,
1898: EXCEPTION_DATE,

Line 1935: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_EXCEPTIONS');

1931: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1932: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1933: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1934: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1935: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_EXCEPTIONS');
1936: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1937:
1938: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1939: RAISE;

Line 1947: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_EXCEPTIONS');

1943:
1944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1945: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1946: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1947: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_EXCEPTIONS');
1948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1949:
1950: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1951: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');