673: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_WDD_LOG');
674:
675: COMMIT;
676:
677: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
678: TABNAME => 'ISC_DBI_TMP_WDD_LOG');
679:
680: BIS_COLLECTION_UTILITIES.put_line('Deleting obsolete records from the base summary');
681: FII_UTIL.Start_Timer;
788: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_WTS_LOG');
789:
790: COMMIT;
791:
792: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
793: TABNAME => 'ISC_DBI_TMP_WTS_LOG');
794:
795: BIS_COLLECTION_UTILITIES.put_line('Deleting obsolete records from the base summary');
796: FII_UTIL.Start_Timer;
1049: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_FIH_LOG');
1050:
1051: COMMIT;
1052:
1053: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
1054: TABNAME => 'ISC_DBI_TMP_FIH_LOG');
1055:
1056: BIS_COLLECTION_UTILITIES.put_line('Deleting obsolete records from the base summary');
1057: FII_UTIL.Start_Timer;
3237: BIS_COLLECTION_UTILITIES.Put_Line(' ');
3238: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing temp tables');
3239: FII_UTIL.Start_Timer;
3240:
3241: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3242: TABNAME => 'ISC_DBI_TMP_DEL_DETAILS');
3243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3244: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3239: FII_UTIL.Start_Timer;
3240:
3241: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3242: TABNAME => 'ISC_DBI_TMP_DEL_DETAILS');
3243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3244: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3246: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3241: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3242: TABNAME => 'ISC_DBI_TMP_DEL_DETAILS');
3243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3244: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3246: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3248: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3249: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3244: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3246: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3248: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3249: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3250: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3251: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3246: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3248: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3249: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3250: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3251: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3252: TABNAME => 'ISC_DBI_FTE_UOM_RATES');
3253:
3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3248: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3249: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3250: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3251: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3252: TABNAME => 'ISC_DBI_FTE_UOM_RATES');
3253:
3254: FII_UTIL.Stop_Timer;
3255: FII_UTIL.Print_Timer('Analyzed the temp tables in ');
3388: BIS_COLLECTION_UTILITIES.Put_Line(' ');
3389: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing temp tables');
3390: FII_UTIL.Start_Timer;
3391:
3392: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3393: TABNAME => 'ISC_DBI_TMP_DEL_DETAILS');
3394:
3395: FII_UTIL.Stop_Timer;
3396: FII_UTIL.Print_Timer('Analyzed the temp tables in ');
3542: BIS_COLLECTION_UTILITIES.Put_Line(' ');
3543: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing temp tables');
3544: FII_UTIL.Start_Timer;
3545:
3546: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3547: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3548: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3549: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3550: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3544: FII_UTIL.Start_Timer;
3545:
3546: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3547: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3548: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3549: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3550: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3551: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3552: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3546: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3547: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3548: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3549: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3550: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3551: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3552: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3553: TABNAME => 'ISC_DBI_FTE_UOM_RATES');
3554:
3548: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3549: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3550: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3551: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3552: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3553: TABNAME => 'ISC_DBI_FTE_UOM_RATES');
3554:
3555: FII_UTIL.Stop_Timer;
3556: FII_UTIL.Print_Timer('Analyzed the temp tables in ');
3694: BIS_COLLECTION_UTILITIES.Put_Line(' ');
3695: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing temp tables');
3696: FII_UTIL.Start_Timer;
3697:
3698: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3699: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3700: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3701: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3702:
3696: FII_UTIL.Start_Timer;
3697:
3698: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3699: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3700: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3701: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3702:
3703: FII_UTIL.Stop_Timer;
3704: FII_UTIL.Print_Timer('Analyzed the temp tables in ');