DBA Data[Home] [Help]

APPS.OZF_REFRESH_VIEW_PVT dependencies on FND_STATS

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

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

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

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

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

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