eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_UDD2_MAINTAIN_PKG dependencies on FND_STATS

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

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

Line 450: FND_STATS.gather_table_stats

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

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

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

Line 893: FND_STATS.gather_table_stats

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

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

991: IF (FIIDIM_Debug) THEN
992: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS_GT');
993: END IF;
994:
995: --Call FND_STATS to collect statistics after populating the table
996: g_phase := 'gather_table_stats for FII_UDD2_MAPPINGS_GT';
997:
998: FND_STATS.gather_table_stats
999: (ownname => g_schema_name,

Line 998: FND_STATS.gather_table_stats

994:
995: --Call FND_STATS to collect statistics after populating the table
996: g_phase := 'gather_table_stats for FII_UDD2_MAPPINGS_GT';
997:
998: FND_STATS.gather_table_stats
999: (ownname => g_schema_name,
1000: tabname => 'FII_UDD2_MAPPING_GT');
1001:
1002: IF (FIIDIM_Debug) THEN

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

1305: IF (FIIDIM_Debug) THEN
1306: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows in FII_FULL_UDD2_HIERS');
1307: END IF;
1308:
1309: --Call FND_STATS to collect statistics after re-populating the tables.
1310: --for the full dimension table since it will be used later
1311: FND_STATS.gather_table_stats
1312: (ownname => g_schema_name,
1313: tabname => 'FII_FULL_UDD2_HIERS');

Line 1311: FND_STATS.gather_table_stats

1307: END IF;
1308:
1309: --Call FND_STATS to collect statistics after re-populating the tables.
1310: --for the full dimension table since it will be used later
1311: FND_STATS.gather_table_stats
1312: (ownname => g_schema_name,
1313: tabname => 'FII_FULL_UDD2_HIERS');
1314:
1315: --==============================================================--

Line 1371: FND_STATS.gather_table_stats

1367: END IF;
1368:
1369: -- This will be in RSG data
1370: g_phase := 'gather_table_stats for FII_UDD2_HIERARCHIES';
1371: FND_STATS.gather_table_stats
1372: (ownname => g_schema_name,
1373: tabname => 'FII_UDD2_HIERARCHIES');
1374:
1375: g_phase := 'gather_table_stats for MLOG$_FII_UDD2_HIERARCHIES';

Line 1376: FND_STATS.gather_table_stats

1372: (ownname => g_schema_name,
1373: tabname => 'FII_UDD2_HIERARCHIES');
1374:
1375: g_phase := 'gather_table_stats for MLOG$_FII_UDD2_HIERARCHIES';
1376: FND_STATS.gather_table_stats
1377: (ownname => g_schema_name,
1378: tabname => 'MLOG$_FII_UDD2_HIERARCHIES');
1379:
1380: --to avoid ORA-12838: cannot read/modify an object after modifying

Line 1418: --Call FND_STATS to collect statistics after re-populating the table.

1414: IF (FIIDIM_Debug) THEN
1415: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS');
1416: END IF;
1417:
1418: --Call FND_STATS to collect statistics after re-populating the table.
1419:
1420: g_phase := 'gather_table_stats FII_UDD2_MAPPINGS';
1421:
1422: FND_STATS.gather_table_stats

Line 1422: FND_STATS.gather_table_stats

1418: --Call FND_STATS to collect statistics after re-populating the table.
1419:
1420: g_phase := 'gather_table_stats FII_UDD2_MAPPINGS';
1421:
1422: FND_STATS.gather_table_stats
1423: (ownname => g_schema_name,
1424: tabname => 'FII_UDD2_MAPPINGS');
1425:
1426: g_phase := 'gather_table_stats MLOG$_FII_UDD2_MAPPINGS';

Line 1428: FND_STATS.gather_table_stats

1424: tabname => 'FII_UDD2_MAPPINGS');
1425:
1426: g_phase := 'gather_table_stats MLOG$_FII_UDD2_MAPPINGS';
1427:
1428: FND_STATS.gather_table_stats
1429: (ownname => g_schema_name,
1430: tabname => 'MLOG$_FII_UDD2_MAPPINGS');
1431:
1432: --=====================================================================

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

1552: IF (FIIDIM_Debug) THEN
1553: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_UDD2_HIERS');
1554: END IF;
1555:
1556: --Call FND_STATS to collect statistics after re-populating the tables.
1557: --for the full dimension table since it will be used later
1558: FND_STATS.gather_table_stats
1559: (ownname => g_schema_name,
1560: tabname => 'FII_FULL_UDD2_HIERS');

Line 1558: FND_STATS.gather_table_stats

1554: END IF;
1555:
1556: --Call FND_STATS to collect statistics after re-populating the tables.
1557: --for the full dimension table since it will be used later
1558: FND_STATS.gather_table_stats
1559: (ownname => g_schema_name,
1560: tabname => 'FII_FULL_UDD2_HIERS');
1561:
1562: --==============================================================--

Line 1669: FND_STATS.gather_table_stats

1665: END IF;
1666:
1667: -- This will be in RSG data
1668: g_phase := 'gather_table_stats for FII_UDD2_HIERARCHIES';
1669: FND_STATS.gather_table_stats
1670: (ownname => g_schema_name,
1671: tabname => 'FII_UDD2_HIERARCHIES');
1672:
1673: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 1677: --FND_STATS.gather_table_stats

1673: -- Bug 4200473. Not to analyze MLOG in incremental run.
1674: -- As per performance teams suggestions.
1675:
1676: --g_phase := 'gather_table_stats for MLOG$_FII_UDD2_HIERARCHIES';
1677: --FND_STATS.gather_table_stats
1678: -- (ownname => g_schema_name,
1679: -- tabname => 'MLOG$_FII_UDD2_HIERARCHIES');
1680: --=============================================================--
1681:

Line 1737: --Call FND_STATS to collect statistics after re-populating the table.

1733: IF (FIIDIM_Debug) THEN
1734: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS');
1735: END IF;
1736:
1737: --Call FND_STATS to collect statistics after re-populating the table.
1738:
1739: g_phase := 'gather_table_stats for FII_UDD2_MAPPINGS';
1740:
1741: FND_STATS.gather_table_stats

Line 1741: FND_STATS.gather_table_stats

1737: --Call FND_STATS to collect statistics after re-populating the table.
1738:
1739: g_phase := 'gather_table_stats for FII_UDD2_MAPPINGS';
1740:
1741: FND_STATS.gather_table_stats
1742: (ownname => g_schema_name,
1743: tabname => 'FII_UDD2_MAPPINGS');
1744:
1745: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 1750: -- FND_STATS.gather_table_stats

1746: -- As per performance teams suggestions.
1747:
1748: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD2_MAPPINGS';
1749:
1750: -- FND_STATS.gather_table_stats
1751: -- (ownname => g_schema_name,
1752: -- tabname => 'MLOG$_FII_UDD2_MAPPINGS');
1753:
1754: --=====================================================================