APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on ISC_DBI_WTS_CHANGE_LOG

Line 785: FROM isc_dbi_wts_change_log;

781: FII_UTIL.Start_Timer;
782:
783: INSERT INTO isc_dbi_tmp_wts_log (STOP_ID, LOG_ROWID, DML_TYPE, LAST_UPDATE_DATE)
784: SELECT stop_id, rowid LOG_ROWID, dml_type, last_update_date
785: FROM isc_dbi_wts_change_log;
786:
787: FII_UTIL.Stop_Timer;
788: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_WTS_LOG');
789:

Line 3203: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_WTS_CHANGE_LOG';

3199: EXECUTE IMMEDIATE 'alter session set hash_area_size=104857600';
3200: EXECUTE IMMEDIATE 'alter session set sort_area_size=104857600';
3201:
3202: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_WDD_CHANGE_LOG';
3203: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_WTS_CHANGE_LOG';
3204: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_FIH_CHANGE_LOG';
3205:
3206: -- -----------------------------
3207: -- Load Data into staging tables

Line 3598: DELETE FROM ISC_DBI_WTS_CHANGE_LOG

3594:
3595: BIS_COLLECTION_UTILITIES.put_line('Deleting rows from log tables');
3596: FII_UTIL.Start_Timer;
3597:
3598: DELETE FROM ISC_DBI_WTS_CHANGE_LOG
3599: WHERE rowid IN (select log_rowid from isc_dbi_tmp_wts_log);
3600: -- AND last_update_date < g_incre_start_date;
3601:
3602: FII_UTIL.Stop_Timer;

Line 3603: FII_UTIL.Print_Timer('Deleted ' || sql%rowcount || ' rows from ISC_DBI_WTS_CHANGE_LOG in');

3599: WHERE rowid IN (select log_rowid from isc_dbi_tmp_wts_log);
3600: -- AND last_update_date < g_incre_start_date;
3601:
3602: FII_UTIL.Stop_Timer;
3603: FII_UTIL.Print_Timer('Deleted ' || sql%rowcount || ' rows from ISC_DBI_WTS_CHANGE_LOG in');
3604: COMMIT;
3605:
3606: IF (WRAPUP = -1) THEN
3607: RAISE l_failure;