410: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT ||
411: ' rows of data into FII_CC_MGR_HIERARCHIES table');
412: end if;
413:
414: --Call FND_STATS to collect statistics after re-populating the tables.
415:
416: g_phase := 'gather_table_stats for FII_CC_MGR_HIERARCHIES';
417: FND_STATS.gather_table_stats
418: (ownname => g_fii_schema,
413:
414: --Call FND_STATS to collect statistics after re-populating the tables.
415:
416: g_phase := 'gather_table_stats for FII_CC_MGR_HIERARCHIES';
417: FND_STATS.gather_table_stats
418: (ownname => g_fii_schema,
419: tabname => 'FII_CC_MGR_HIERARCHIES');
420:
421: g_phase := 'gather_table_stats for MLOG$_FII_CC_MGR_HIERARCHI';
418: (ownname => g_fii_schema,
419: tabname => 'FII_CC_MGR_HIERARCHIES');
420:
421: g_phase := 'gather_table_stats for MLOG$_FII_CC_MGR_HIERARCHI';
422: FND_STATS.gather_table_stats
423: (ownname => g_fii_schema,
424: tabname => 'MLOG$_FII_CC_MGR_HIERARCHI');
425:
426: FND_CONCURRENT.Af_Commit;
518: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT ||
519: ' rows of data into FII_CC_MGR_HIERARCHIES table');
520: end if;
521:
522: --Call FND_STATS to collect statistics after re-populating the tables.
523:
524: g_phase := 'gather_table_stats for FII_CC_MGR_HIERARCHIES';
525: FND_STATS.gather_table_stats
526: (ownname => g_fii_schema,
521:
522: --Call FND_STATS to collect statistics after re-populating the tables.
523:
524: g_phase := 'gather_table_stats for FII_CC_MGR_HIERARCHIES';
525: FND_STATS.gather_table_stats
526: (ownname => g_fii_schema,
527: tabname => 'FII_CC_MGR_HIERARCHIES');
528:
529: g_phase := 'gather_table_stats for MLOG$_FII_CC_MGR_HIERARCHI';
526: (ownname => g_fii_schema,
527: tabname => 'FII_CC_MGR_HIERARCHIES');
528:
529: g_phase := 'gather_table_stats for MLOG$_FII_CC_MGR_HIERARCHI';
530: FND_STATS.gather_table_stats
531: (ownname => g_fii_schema,
532: tabname => 'MLOG$_FII_CC_MGR_HIERARCHI');
533:
534: FND_CONCURRENT.Af_Commit;