APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on ISC_DBI_FIH_CHANGE_LOG

Line 1046: FROM isc_dbi_fih_change_log;

1042: FII_UTIL.Start_Timer;
1043:
1044: INSERT INTO isc_dbi_tmp_fih_log (INVOICE_HEADER_ID, LOG_ROWID, DML_TYPE, LAST_UPDATE_DATE)
1045: SELECT invoice_header_id, rowid LOG_ROWID, dml_type, last_update_date
1046: FROM isc_dbi_fih_change_log;
1047:
1048: FII_UTIL.Stop_Timer;
1049: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_FIH_LOG');
1050:

Line 3204: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_FIH_CHANGE_LOG';

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

Line 3747: DELETE FROM ISC_DBI_FIH_CHANGE_LOG

3743: BIS_COLLECTION_UTILITIES.put_line('Deleting rows from log tables');
3744:
3745: FII_UTIL.Start_Timer;
3746:
3747: DELETE FROM ISC_DBI_FIH_CHANGE_LOG
3748: WHERE rowid IN (select log_rowid from isc_dbi_tmp_fih_log);
3749: -- AND last_update_date < g_incre_start_date;
3750:
3751: FII_UTIL.Stop_Timer;

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

3748: WHERE rowid IN (select log_rowid from isc_dbi_tmp_fih_log);
3749: -- AND last_update_date < g_incre_start_date;
3750:
3751: FII_UTIL.Stop_Timer;
3752: FII_UTIL.Print_Timer('Deleted ' || sql%rowcount || ' rows from ISC_DBI_FIH_CHANGE_LOG in');
3753: COMMIT;
3754:
3755: IF (WRAPUP = -1) THEN
3756: RAISE l_failure;