APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_SHIFT_EXCEPTIONS

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

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);
1306:
1307: END IF;
1308:
1309: c_count:= 0;

Line 1873: UPDATE MSC_SHIFT_EXCEPTIONS

1869: BEGIN
1870:
1871: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1872:
1873: UPDATE MSC_SHIFT_EXCEPTIONS
1874: SET
1875: EXCEPTION_TYPE= c_rec.EXCEPTION_TYPE,
1876: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1877: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 1889: INSERT INTO MSC_SHIFT_EXCEPTIONS

1885: END IF;
1886:
1887: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1888:
1889: INSERT INTO MSC_SHIFT_EXCEPTIONS
1890: ( CALENDAR_CODE,
1891: SHIFT_NUM,
1892: EXCEPTION_SET_ID,
1893: EXCEPTION_DATE,

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

1926: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1927: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1928: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1929: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1930: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_EXCEPTIONS');
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1932:
1933: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1934: RAISE;

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

1938:
1939: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1940: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1941: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
1942: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SHIFT_EXCEPTIONS');
1943: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1944:
1945: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1946: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');