APPS.FII_COM_MAINTAIN_PKG dependencies on FND_STATS

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

445: Where flex_value_set_id = l_vset_id;
446:
447: END LOOP;
448:
449: --Call FND_STATS to collect statistics after populating the table
450: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
451:
452: FND_STATS.gather_table_stats
453: (ownname => g_schema_name,

Line 452: FND_STATS.gather_table_stats

448:
449: --Call FND_STATS to collect statistics after populating the table
450: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
451:
452: FND_STATS.gather_table_stats
453: (ownname => g_schema_name,
454: tabname => 'FII_DIM_NORM_HIER_GT');
455:
456: IF (FIIDIM_Debug) THEN

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

888: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_hier_gt');
889: END IF;
890:
891:
892: --Call FND_STATS to collect statistics after populating the table
893: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';
894:
895: FND_STATS.gather_table_stats
896: (ownname => g_schema_name,

Line 895: FND_STATS.gather_table_stats

891:
892: --Call FND_STATS to collect statistics after populating the table
893: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';
894:
895: FND_STATS.gather_table_stats
896: (ownname => g_schema_name,
897: tabname => 'FII_FIN_ITEM_HIER_GT');
898:
899: --====================================================================

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

1282: IF (FIIDIM_Debug) THEN
1283: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows in FII_FULL_COMPANY_HIERS');
1284: END IF;
1285:
1286: --Call FND_STATS to collect statistics after re-populating the tables.
1287: --for the full dimension table since it will be used later
1288: FND_STATS.gather_table_stats
1289: (ownname => g_schema_name,
1290: tabname => 'FII_FULL_COMPANY_HIERS');

Line 1288: FND_STATS.gather_table_stats

1284: END IF;
1285:
1286: --Call FND_STATS to collect statistics after re-populating the tables.
1287: --for the full dimension table since it will be used later
1288: FND_STATS.gather_table_stats
1289: (ownname => g_schema_name,
1290: tabname => 'FII_FULL_COMPANY_HIERS');
1291:
1292: --==============================================================--

Line 1356: FND_STATS.gather_table_stats

1352: END IF;
1353:
1354: -- This will be in RSG data
1355: g_phase := 'gather_table_stats for FII_COMPANY_HIERARCHIES';
1356: FND_STATS.gather_table_stats
1357: (ownname => g_schema_name,
1358: tabname => 'FII_COMPANY_HIERARCHIES');
1359:
1360: g_phase := 'gather_table_stats for MLOG$_FII_COMPANY_HIERARCH';

Line 1361: FND_STATS.gather_table_stats

1357: (ownname => g_schema_name,
1358: tabname => 'FII_COMPANY_HIERARCHIES');
1359:
1360: g_phase := 'gather_table_stats for MLOG$_FII_COMPANY_HIERARCH';
1361: FND_STATS.gather_table_stats
1362: (ownname => g_schema_name,
1363: tabname => 'MLOG$_FII_COMPANY_HIERARCH');
1364:
1365: --================================================================--

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

1487: IF (FIIDIM_Debug) THEN
1488: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_COMPANY_HIERS');
1489: END IF;
1490:
1491: --Call FND_STATS to collect statistics after re-populating the tables.
1492: --for the full dimension table since it will be used later
1493: FND_STATS.gather_table_stats
1494: (ownname => g_schema_name,
1495: tabname => 'FII_FULL_COMPANY_HIERS');

Line 1493: FND_STATS.gather_table_stats

1489: END IF;
1490:
1491: --Call FND_STATS to collect statistics after re-populating the tables.
1492: --for the full dimension table since it will be used later
1493: FND_STATS.gather_table_stats
1494: (ownname => g_schema_name,
1495: tabname => 'FII_FULL_COMPANY_HIERS');
1496:
1497: --==============================================================--

Line 1621: FND_STATS.gather_table_stats

1617: FROM FII_COMPANY_HIERARCHIES);
1618:
1619: -- This will be in RSG data
1620: g_phase := 'gather_table_stats for FII_COMPANY_HIERARCHIES';
1621: FND_STATS.gather_table_stats
1622: (ownname => g_schema_name,
1623: tabname => 'FII_COMPANY_HIERARCHIES');
1624:
1625: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 1629: -- FND_STATS.gather_table_stats

1625: -- Bug 4200473. Not to analyze MLOG in incremental run.
1626: -- As per performance teams suggestions.
1627:
1628: -- g_phase := 'gather_table_stats for MLOG$_FII_COMPANY_HIERARCH';
1629: -- FND_STATS.gather_table_stats
1630: -- (ownname => g_schema_name,
1631: -- tabname => 'MLOG$_FII_COMPANY_HIERARCH');
1632:
1633: IF (FIIDIM_Debug) THEN