APPS.FII_CC_MAINTAIN_PKG dependencies on FND_STATS

Line 444: --Call FND_STATS to collect statistics after populating the table

440: Where flex_value_set_id = l_vset_id;
441:
442: END LOOP;
443:
444: --Call FND_STATS to collect statistics after populating the table
445: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
446:
447: FND_STATS.gather_table_stats
448: (ownname => g_schema_name,

Line 447: FND_STATS.gather_table_stats

443:
444: --Call FND_STATS to collect statistics after populating the table
445: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
446:
447: FND_STATS.gather_table_stats
448: (ownname => g_schema_name,
449: tabname => 'FII_DIM_NORM_HIER_GT');
450:
451: IF (FIIDIM_Debug) THEN

Line 882: --Call FND_STATS to collect statistics after populating the table

878: IF (FIIDIM_Debug) THEN
879: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_ctr_hier_gt');
880: END IF;
881:
882: --Call FND_STATS to collect statistics after populating the table
883: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';
884:
885: FND_STATS.gather_table_stats
886: (ownname => g_schema_name,

Line 885: FND_STATS.gather_table_stats

881:
882: --Call FND_STATS to collect statistics after populating the table
883: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';
884:
885: FND_STATS.gather_table_stats
886: (ownname => g_schema_name,
887: tabname => 'FII_FIN_ITEM_HIER_GT');
888:
889: --====================================================================

Line 1275: --Call FND_STATS to collect statistics after re-populating the tables.

1271: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_COST_CTR_HIERS');
1272: END IF;
1273:
1274:
1275: --Call FND_STATS to collect statistics after re-populating the tables.
1276: --for the full dimension table since it will be used later
1277: FND_STATS.gather_table_stats
1278: (ownname => g_schema_name,
1279: tabname => 'FII_FULL_COST_CTR_HIERS');

Line 1277: FND_STATS.gather_table_stats

1273:
1274:
1275: --Call FND_STATS to collect statistics after re-populating the tables.
1276: --for the full dimension table since it will be used later
1277: FND_STATS.gather_table_stats
1278: (ownname => g_schema_name,
1279: tabname => 'FII_FULL_COST_CTR_HIERS');
1280:
1281: --==============================================================--

Line 1346: FND_STATS.gather_table_stats

1342: END IF;
1343:
1344: -- This will be in RSG data
1345: g_phase := 'gather_table_stats for FII_COST_CTR_HIERARCHIES';
1346: FND_STATS.gather_table_stats
1347: (ownname => g_schema_name,
1348: tabname => 'FII_COST_CTR_HIERARCHIES');
1349:
1350: g_phase := 'gather_table_stats for MLOG$_FII_COST_CTR_HIERARC';

Line 1351: FND_STATS.gather_table_stats

1347: (ownname => g_schema_name,
1348: tabname => 'FII_COST_CTR_HIERARCHIES');
1349:
1350: g_phase := 'gather_table_stats for MLOG$_FII_COST_CTR_HIERARC';
1351: FND_STATS.gather_table_stats
1352: (ownname => g_schema_name,
1353: tabname => 'MLOG$_FII_COST_CTR_HIERARC');
1354:
1355: --================================================================--

Line 1480: --Call FND_STATS to collect statistics after re-populating the tables.

1476: IF (FIIDIM_Debug) THEN
1477: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_COST_CTR_HIERS');
1478: END IF;
1479:
1480: --Call FND_STATS to collect statistics after re-populating the tables.
1481: --for the full dimension table since it will be used later
1482: FND_STATS.gather_table_stats
1483: (ownname => g_schema_name,
1484: tabname => 'FII_FULL_COST_CTR_HIERS');

Line 1482: FND_STATS.gather_table_stats

1478: END IF;
1479:
1480: --Call FND_STATS to collect statistics after re-populating the tables.
1481: --for the full dimension table since it will be used later
1482: FND_STATS.gather_table_stats
1483: (ownname => g_schema_name,
1484: tabname => 'FII_FULL_COST_CTR_HIERS');
1485:
1486: --==============================================================--

Line 1614: FND_STATS.gather_table_stats

1610: END IF;
1611:
1612: -- This is in RSG data
1613: g_phase := 'gather_table_stats for FII_COST_CTR_HIERARCHIES';
1614: FND_STATS.gather_table_stats
1615: (ownname => g_schema_name,
1616: tabname => 'FII_COST_CTR_HIERARCHIES');
1617:
1618: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 1621: -- FND_STATS.gather_table_stats

1617:
1618: -- Bug 4200473. Not to analyze MLOG in incremental run.
1619: -- As per performance teams suggestions.
1620: -- g_phase := 'gather_table_stats for MLOG$_FII_COST_CTR_HIERARC';
1621: -- FND_STATS.gather_table_stats
1622: -- (ownname => g_schema_name,
1623: -- tabname => 'MLOG$_FII_COST_CTR_HIERARC');
1624:
1625: --=============================================================--