APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on ISC_DBI_WDD_CHANGE_LOG

Line 670: FROM isc_dbi_wdd_change_log;

666: FII_UTIL.Start_Timer;
667:
668: INSERT INTO isc_dbi_tmp_wdd_log (DELIVERY_DETAIL_ID, LOG_ROWID, DML_TYPE, LAST_UPDATE_DATE)
669: SELECT delivery_detail_id, rowid LOG_ROWID, dml_type, last_update_date
670: FROM isc_dbi_wdd_change_log;
671:
672: FII_UTIL.Stop_Timer;
673: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_WDD_LOG');
674:

Line 3202: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_WDD_CHANGE_LOG';

3198:
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: -- -----------------------------

Line 3438: DELETE FROM ISC_DBI_WDD_CHANGE_LOG

3434:
3435: BIS_COLLECTION_UTILITIES.put_line('Deleting rows from log tables');
3436: FII_UTIL.Start_Timer;
3437:
3438: DELETE FROM ISC_DBI_WDD_CHANGE_LOG
3439: WHERE rowid IN (select log_rowid from isc_dbi_tmp_wdd_log);
3440: -- AND last_update_date < g_incre_start_date;
3441:
3442: FII_UTIL.Stop_Timer;

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

3439: WHERE rowid IN (select log_rowid from isc_dbi_tmp_wdd_log);
3440: -- AND last_update_date < g_incre_start_date;
3441:
3442: FII_UTIL.Stop_Timer;
3443: FII_UTIL.Print_Timer('Deleted ' || sql%rowcount || ' rows from ISC_DBI_WDD_CHANGE_LOG in');
3444: COMMIT;
3445:
3446: IF (WRAPUP = -1) THEN
3447: RAISE l_failure;