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');
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
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