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_FIN_CAT_MAINTAIN_PKG dependencies on FND_STATS

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

464: Where flex_value_set_id = l_vset_id;
465:
466: END LOOP;
467:
468: --Call FND_STATS to collect statistics after populating the table
469: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
470:
471: FND_STATS.gather_table_stats
472: (ownname => g_schema_name,

Line 471: FND_STATS.gather_table_stats

467:
468: --Call FND_STATS to collect statistics after populating the table
469: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
470:
471: FND_STATS.gather_table_stats
472: (ownname => g_schema_name,
473: tabname => 'FII_DIM_NORM_HIER_GT');
474:
475: Exception

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

812: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_fin_item_hier_gt');
813: END IF;
814:
815:
816: --Call FND_STATS to collect statistics after populating the table
817: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';
818:
819: FND_STATS.gather_table_stats
820: (ownname => g_schema_name,

Line 819: FND_STATS.gather_table_stats

815:
816: --Call FND_STATS to collect statistics after populating the table
817: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';
818:
819: FND_STATS.gather_table_stats
820: (ownname => g_schema_name,
821: tabname => 'FII_FIN_ITEM_HIER_GT');
822:
823: --====================================================================

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

1145: IF (FIIDIM_Debug) THEN
1146: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_MAPPINGS_GT');
1147: END IF;
1148:
1149: --Call FND_STATS to collect statistics after populating the table
1150: g_phase := 'gather_table_stats for FII_FIN_CAT_MAPPINGS_GT';
1151:
1152: FND_STATS.gather_table_stats
1153: (ownname => g_schema_name,

Line 1152: FND_STATS.gather_table_stats

1148:
1149: --Call FND_STATS to collect statistics after populating the table
1150: g_phase := 'gather_table_stats for FII_FIN_CAT_MAPPINGS_GT';
1151:
1152: FND_STATS.gather_table_stats
1153: (ownname => g_schema_name,
1154: tabname => 'FII_FIN_CAT_MAPPINGS_GT');
1155:
1156: IF (FIIDIM_Debug) THEN

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

1381: IF (FIIDIM_Debug) THEN
1382: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FC_TYPE_ASSGNS_GT');
1383: END IF;
1384:
1385: --Call FND_STATS to collect statistics after populating the table
1386: g_phase := 'gather_table_stats for FII_FC_TYPE_ASSGNS_GT';
1387:
1388: FND_STATS.gather_table_stats
1389: (ownname => g_schema_name,

Line 1388: FND_STATS.gather_table_stats

1384:
1385: --Call FND_STATS to collect statistics after populating the table
1386: g_phase := 'gather_table_stats for FII_FC_TYPE_ASSGNS_GT';
1387:
1388: FND_STATS.gather_table_stats
1389: (ownname => g_schema_name,
1390: tabname => 'FII_FC_TYPE_ASSGNS_GT');
1391:
1392: --Now to update the column TOP_NODE_FLAG

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

1520:
1521: END IF;
1522: -----------------------------------------
1523:
1524: --Call FND_STATS to collect statistics after re-populating the tables.
1525: g_phase := 'gather_table_stats for FII_FIN_CAT_TYPE_ASSGNS';
1526:
1527: FND_STATS.gather_table_stats
1528: (ownname => g_schema_name,

Line 1527: FND_STATS.gather_table_stats

1523:
1524: --Call FND_STATS to collect statistics after re-populating the tables.
1525: g_phase := 'gather_table_stats for FII_FIN_CAT_TYPE_ASSGNS';
1526:
1527: FND_STATS.gather_table_stats
1528: (ownname => g_schema_name,
1529: tabname => 'FII_FIN_CAT_TYPE_ASSGNS');
1530:
1531: IF p_initial_load = 'Y' THEN

Line 1535: FND_STATS.gather_table_stats

1531: IF p_initial_load = 'Y' THEN
1532:
1533: g_phase := 'gather_table_stats for MLOG$_FII_FIN_CAT_TYPE_ASS';
1534:
1535: FND_STATS.gather_table_stats
1536: (ownname => g_schema_name,
1537: tabname => 'MLOG$_FII_FIN_CAT_TYPE_ASS');
1538: END IF;
1539:

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

1684: END IF;
1685:
1686: commit;
1687:
1688: --Call FND_STATS to collect statistics after re-populating the tables.
1689: --for the full table since it will be used in the program later
1690:
1691: g_phase := 'gather_table_stats for FII_FULL_FIN_ITEM_HIERS';
1692:

Line 1693: FND_STATS.gather_table_stats

1689: --for the full table since it will be used in the program later
1690:
1691: g_phase := 'gather_table_stats for FII_FULL_FIN_ITEM_HIERS';
1692:
1693: FND_STATS.gather_table_stats
1694: (ownname => g_schema_name,
1695: tabname => 'FII_FULL_FIN_ITEM_HIERS');
1696:
1697: --==============================================================--

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

1806:
1807: -- We have added an update statement on FII_FIN_ITEM_LEAF_HIERS. Hence, moved gathering statistics
1808: -- for FII_FIN_ITEM_LEAF_HIERS table and its mlog at the end of procedure.
1809:
1810: --Call FND_STATS to collect statistics after re-populating the tables.
1811: --Will seed this in RSG
1812: -- FND_STATS.gather_table_stats
1813: -- (ownname => g_schema_name,
1814: -- tabname => 'FII_FIN_ITEM_HIERARCHIES');

Line 1812: -- FND_STATS.gather_table_stats

1808: -- for FII_FIN_ITEM_LEAF_HIERS table and its mlog at the end of procedure.
1809:
1810: --Call FND_STATS to collect statistics after re-populating the tables.
1811: --Will seed this in RSG
1812: -- FND_STATS.gather_table_stats
1813: -- (ownname => g_schema_name,
1814: -- tabname => 'FII_FIN_ITEM_HIERARCHIES');
1815:
1816: --to avoid ORA-12838: cannot read/modify an object after modifying

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

1876: IF (FIIDIM_Debug) THEN
1877: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_MAPPINGS');
1878: END IF;
1879:
1880: --Call FND_STATS to collect statistics after re-populating the table.
1881:
1882: g_phase := 'gather_table_stats FII_FIN_CAT_MAPPINGS';
1883:
1884: FND_STATS.gather_table_stats

Line 1884: FND_STATS.gather_table_stats

1880: --Call FND_STATS to collect statistics after re-populating the table.
1881:
1882: g_phase := 'gather_table_stats FII_FIN_CAT_MAPPINGS';
1883:
1884: FND_STATS.gather_table_stats
1885: (ownname => g_schema_name,
1886: tabname => 'FII_FIN_CAT_MAPPINGS');
1887:
1888: g_phase := 'gather_table_stats MLOG$_FII_FIN_CAT_MAPPINGS';

Line 1890: FND_STATS.gather_table_stats

1886: tabname => 'FII_FIN_CAT_MAPPINGS');
1887:
1888: g_phase := 'gather_table_stats MLOG$_FII_FIN_CAT_MAPPINGS';
1889:
1890: FND_STATS.gather_table_stats
1891: (ownname => g_schema_name,
1892: tabname => 'MLOG$_FII_FIN_CAT_MAPPINGS');
1893:
1894: g_phase := 'gather_table_stats FII_FIN_CAT_LEAF_MAPS';

Line 1896: FND_STATS.gather_table_stats

1892: tabname => 'MLOG$_FII_FIN_CAT_MAPPINGS');
1893:
1894: g_phase := 'gather_table_stats FII_FIN_CAT_LEAF_MAPS';
1895:
1896: FND_STATS.gather_table_stats
1897: (ownname => g_schema_name,
1898: tabname => 'FII_FIN_CAT_LEAF_MAPS');
1899:
1900: g_phase := 'gather_table_stats MLOG$_FII_FIN_CAT_LEAF_MAP';

Line 1902: FND_STATS.gather_table_stats

1898: tabname => 'FII_FIN_CAT_LEAF_MAPS');
1899:
1900: g_phase := 'gather_table_stats MLOG$_FII_FIN_CAT_LEAF_MAP';
1901:
1902: FND_STATS.gather_table_stats
1903: (ownname => g_schema_name,
1904: tabname => 'MLOG$_FII_FIN_CAT_LEAF_MAP');
1905:
1906: --=====================================================================

Line 1961: -- Call FND_STATS to collect statistics of the table.

1957: AND next_level_fin_cat_id <> parent_fin_cat_id;
1958:
1959:
1960:
1961: -- Call FND_STATS to collect statistics of the table.
1962: g_phase := 'gather_table_stats FII_FIN_ITEM_LEAF_HIERS';
1963:
1964: FND_STATS.gather_table_stats
1965: (ownname => g_schema_name,

Line 1964: FND_STATS.gather_table_stats

1960:
1961: -- Call FND_STATS to collect statistics of the table.
1962: g_phase := 'gather_table_stats FII_FIN_ITEM_LEAF_HIERS';
1963:
1964: FND_STATS.gather_table_stats
1965: (ownname => g_schema_name,
1966: tabname => 'FII_FIN_ITEM_LEAF_HIERS');
1967:
1968: g_phase := 'gather_table_stats MLOG$_FII_FIN_ITEM_LEAF_HI';

Line 1969: FND_STATS.gather_table_stats

1965: (ownname => g_schema_name,
1966: tabname => 'FII_FIN_ITEM_LEAF_HIERS');
1967:
1968: g_phase := 'gather_table_stats MLOG$_FII_FIN_ITEM_LEAF_HI';
1969: FND_STATS.gather_table_stats
1970: (ownname => g_schema_name,
1971: tabname => 'MLOG$_FII_FIN_ITEM_LEAF_HI');
1972:
1973: commit; --FND_CONCURRENT.Af_Commit;

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

2129: IF (FIIDIM_Debug) THEN
2130: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_FIN_ITEM_HIERS');
2131: END IF;
2132:
2133: --Call FND_STATS to collect statistics after re-populating the tables.
2134: --for the full table since it will be used later in the program
2135:
2136: g_phase := 'gather_table_stats for FII_FULL_FIN_ITEM_HIERS';
2137:

Line 2138: FND_STATS.gather_table_stats

2134: --for the full table since it will be used later in the program
2135:
2136: g_phase := 'gather_table_stats for FII_FULL_FIN_ITEM_HIERS';
2137:
2138: FND_STATS.gather_table_stats
2139: (ownname => g_schema_name,
2140: tabname => 'FII_FULL_FIN_ITEM_HIERS');
2141:
2142: --==============================================================--

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

2354:
2355: -- We have added an update statement on FII_FIN_ITEM_LEAF_HIERS. Hence, moved gathering statistics
2356: -- for FII_FIN_ITEM_LEAF_HIERS table at the end of procedure.
2357:
2358: --Call FND_STATS to collect statistics after re-populating the tables.
2359: --Will seed this in RSG
2360: -- FND_STATS.gather_table_stats
2361: -- (ownname => g_schema_name,
2362: -- tabname => 'FII_FIN_ITEM_HIERARCHIES');

Line 2360: -- FND_STATS.gather_table_stats

2356: -- for FII_FIN_ITEM_LEAF_HIERS table at the end of procedure.
2357:
2358: --Call FND_STATS to collect statistics after re-populating the tables.
2359: --Will seed this in RSG
2360: -- FND_STATS.gather_table_stats
2361: -- (ownname => g_schema_name,
2362: -- tabname => 'FII_FIN_ITEM_HIERARCHIES');
2363:
2364: --================================================================--

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

2463: IF (FIIDIM_Debug) THEN
2464: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FIN_CAT_MAPPINGS');
2465: END IF;
2466:
2467: --Call FND_STATS to collect statistics after re-populating the table.
2468:
2469: g_phase := 'gather_table_stats for FII_FIN_CAT_MAPPINGS';
2470:
2471: FND_STATS.gather_table_stats

Line 2471: FND_STATS.gather_table_stats

2467: --Call FND_STATS to collect statistics after re-populating the table.
2468:
2469: g_phase := 'gather_table_stats for FII_FIN_CAT_MAPPINGS';
2470:
2471: FND_STATS.gather_table_stats
2472: (ownname => g_schema_name,
2473: tabname => 'FII_FIN_CAT_MAPPINGS');
2474:
2475: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 2480: -- FND_STATS.gather_table_stats

2476: -- As per performance teams suggestions.
2477:
2478: -- g_phase := 'gather_table_stats for MLOG$_FII_FIN_CAT_MAPPINGS';
2479:
2480: -- FND_STATS.gather_table_stats
2481: -- (ownname => g_schema_name,
2482: -- tabname => 'MLOG$_FII_FIN_CAT_MAPPINGS');
2483:
2484:

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

2481: -- (ownname => g_schema_name,
2482: -- tabname => 'MLOG$_FII_FIN_CAT_MAPPINGS');
2483:
2484:
2485: --Call FND_STATS to collect statistics after re-populating the table.
2486:
2487: g_phase := 'gather_table_stats for FII_FIN_CAT_LEAF_MAPS';
2488:
2489: FND_STATS.gather_table_stats

Line 2489: FND_STATS.gather_table_stats

2485: --Call FND_STATS to collect statistics after re-populating the table.
2486:
2487: g_phase := 'gather_table_stats for FII_FIN_CAT_LEAF_MAPS';
2488:
2489: FND_STATS.gather_table_stats
2490: (ownname => g_schema_name,
2491: tabname => 'FII_FIN_CAT_LEAF_MAPS');
2492:
2493: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 2498: -- FND_STATS.gather_table_stats

2494: -- As per performance teams suggestions.
2495:
2496: -- g_phase := 'gather_table_stats for MLOG$_FII_FIN_CAT_LEAF_MAP';
2497:
2498: -- FND_STATS.gather_table_stats
2499: -- (ownname => g_schema_name,
2500: -- tabname => 'MLOG$_FII_FIN_CAT_LEAF_MAP');
2501:
2502: --=====================================================================

Line 2590: -- Call FND_STATS to collect statistics of the table.

2586: IF (FIIDIM_Debug) THEN
2587: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
2588: END IF;
2589:
2590: -- Call FND_STATS to collect statistics of the table.
2591: g_phase := 'gather_table_stats FII_FIN_ITEM_LEAF_HIERS';
2592:
2593: FND_STATS.gather_table_stats
2594: (ownname => g_schema_name,

Line 2593: FND_STATS.gather_table_stats

2589:
2590: -- Call FND_STATS to collect statistics of the table.
2591: g_phase := 'gather_table_stats FII_FIN_ITEM_LEAF_HIERS';
2592:
2593: FND_STATS.gather_table_stats
2594: (ownname => g_schema_name,
2595: tabname => 'FII_FIN_ITEM_LEAF_HIERS');
2596:
2597: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 2601: -- FND_STATS.gather_table_stats

2597: -- Bug 4200473. Not to analyze MLOG in incremental run.
2598: -- As per performance teams suggestions.
2599:
2600: -- g_phase := 'gather_table_stats MLOG$_FII_FIN_ITEM_LEAF_HI';
2601: -- FND_STATS.gather_table_stats
2602: -- (ownname => g_schema_name,
2603: -- tabname => 'MLOG$_FII_FIN_ITEM_LEAF_HI');
2604:
2605: commit; --FND_CONCURRENT.Af_Commit;