APPS.FII_LOB_MAINTAIN_PKG dependencies on FND_STATS

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

1369: IF (FIIDIM_Debug) THEN
1370: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_LOB_HIERS');
1371: END IF;
1372:
1373: --Call FND_STATS to collect statistics after re-populating the tables.
1374: --for the full dimension table since it will be used later
1375:
1376: g_phase := 'gather_table_stats for FII_FULL_LOB_HIERS';
1377:

Line 1378: FND_STATS.gather_table_stats

1374: --for the full dimension table since it will be used later
1375:
1376: g_phase := 'gather_table_stats for FII_FULL_LOB_HIERS';
1377:
1378: FND_STATS.gather_table_stats
1379: (ownname => g_schema_name,
1380: tabname => 'FII_FULL_LOB_HIERS');
1381:
1382: --==============================================================--

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

1430: IF (FIIDIM_Debug) THEN
1431: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_LOB_HIERARCHIES');
1432: END IF;
1433:
1434: --Call FND_STATS to collect statistics after re-populating the tables.
1435: --Will seed this in RSG
1436: -- FND_STATS.gather_table_stats
1437: -- (ownname => g_schema_name,
1438: -- tabname => 'FII_LOB_HIERARCHIES');

Line 1436: -- FND_STATS.gather_table_stats

1432: END IF;
1433:
1434: --Call FND_STATS to collect statistics after re-populating the tables.
1435: --Will seed this in RSG
1436: -- FND_STATS.gather_table_stats
1437: -- (ownname => g_schema_name,
1438: -- tabname => 'FII_LOB_HIERARCHIES');
1439:
1440: --================================================================--

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

1632: IF (FIIDIM_Debug) THEN
1633: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_LOB_HIERS');
1634: END IF;
1635:
1636: --Call FND_STATS to collect statistics after re-populating the tables.
1637: --for the full dimension table since it will be used later
1638:
1639: g_phase := 'gather_table_stats for FII_FULL_LOB_HIERS';
1640:

Line 1641: FND_STATS.gather_table_stats

1637: --for the full dimension table since it will be used later
1638:
1639: g_phase := 'gather_table_stats for FII_FULL_LOB_HIERS';
1640:
1641: FND_STATS.gather_table_stats
1642: (ownname => g_schema_name,
1643: tabname => 'FII_FULL_LOB_HIERS');
1644:
1645: --==============================================================--

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

1741: IF (FIIDIM_Debug) THEN
1742: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_LOB_HIERARCHIES');
1743: END IF;
1744:
1745: --Call FND_STATS to collect statistics after re-populating the tables.
1746: --Will seed this in RSG
1747: -- FND_STATS.gather_table_stats
1748: -- (ownname => g_schema_name,
1749: -- tabname => 'FII_LOB_HIERARCHIES');

Line 1747: -- FND_STATS.gather_table_stats

1743: END IF;
1744:
1745: --Call FND_STATS to collect statistics after re-populating the tables.
1746: --Will seed this in RSG
1747: -- FND_STATS.gather_table_stats
1748: -- (ownname => g_schema_name,
1749: -- tabname => 'FII_LOB_HIERARCHIES');
1750:
1751: --=============================================================--