DBA Data[Home] [Help]

APPS.OZF_REFRESH_VIEW_PVT dependencies on FND_STATS

Line 51: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');

47:
48: --------------------------------------------------------
49: -- Gather statistics for the use of cost-based optimizer
50: --------------------------------------------------------
51: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');
52: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>l_view_name);
53: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');
54: END IF;
55:

Line 52: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>l_view_name);

48: --------------------------------------------------------
49: -- Gather statistics for the use of cost-based optimizer
50: --------------------------------------------------------
51: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');
52: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>l_view_name);
53: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');
54: END IF;
55:
56: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': End');

Line 53: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');

49: -- Gather statistics for the use of cost-based optimizer
50: --------------------------------------------------------
51: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');
52: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>l_view_name);
53: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');
54: END IF;
55:
56: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': End');
57: EXCEPTION