APPS.FII_GL_JE_B_C dependencies on FND_STATS

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

2118: -- Bug 4545509: Per performance team, we need to commit before we call
2119: -- gather stats so that stats will be gathered at 10% vs 99%.
2120: commit;
2121:
2122: --Call FND_STATS to collect statistics after populating the table
2123: g_phase := 'Calling FND_STATS to collect statistics for FII_GL_JE_SUMMARY_STG';
2124: FND_STATS.gather_table_stats
2125: (ownname => g_fii_schema,
2126: tabname => 'FII_GL_JE_SUMMARY_STG');

Line 2123: g_phase := 'Calling FND_STATS to collect statistics for FII_GL_JE_SUMMARY_STG';

2119: -- gather stats so that stats will be gathered at 10% vs 99%.
2120: commit;
2121:
2122: --Call FND_STATS to collect statistics after populating the table
2123: g_phase := 'Calling FND_STATS to collect statistics for FII_GL_JE_SUMMARY_STG';
2124: FND_STATS.gather_table_stats
2125: (ownname => g_fii_schema,
2126: tabname => 'FII_GL_JE_SUMMARY_STG');
2127:

Line 2124: FND_STATS.gather_table_stats

2120: commit;
2121:
2122: --Call FND_STATS to collect statistics after populating the table
2123: g_phase := 'Calling FND_STATS to collect statistics for FII_GL_JE_SUMMARY_STG';
2124: FND_STATS.gather_table_stats
2125: (ownname => g_fii_schema,
2126: tabname => 'FII_GL_JE_SUMMARY_STG');
2127:
2128: g_phase := 'Enabling parallel dml';

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

2457: from FII_gl_je_summary_STG
2458: );
2459:
2460:
2461: --Call FND_STATS to collect statistics after populating the table
2462: g_phase := 'Calling FND_STATS to collect statistics for fii_gl_revenue_rates_temp';
2463: FND_STATS.gather_table_stats
2464: (ownname => g_fii_schema,
2465: tabname => 'FII_GL_REVENUE_RATES_TEMP');

Line 2462: g_phase := 'Calling FND_STATS to collect statistics for fii_gl_revenue_rates_temp';

2458: );
2459:
2460:
2461: --Call FND_STATS to collect statistics after populating the table
2462: g_phase := 'Calling FND_STATS to collect statistics for fii_gl_revenue_rates_temp';
2463: FND_STATS.gather_table_stats
2464: (ownname => g_fii_schema,
2465: tabname => 'FII_GL_REVENUE_RATES_TEMP');
2466:

Line 2463: FND_STATS.gather_table_stats

2459:
2460:
2461: --Call FND_STATS to collect statistics after populating the table
2462: g_phase := 'Calling FND_STATS to collect statistics for fii_gl_revenue_rates_temp';
2463: FND_STATS.gather_table_stats
2464: (ownname => g_fii_schema,
2465: tabname => 'FII_GL_REVENUE_RATES_TEMP');
2466:
2467: g_phase := 'Enabling parallel dml';

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

2591:
2592: --Fix bug 3561245
2593: commit;
2594:
2595: --Call FND_STATS to collect statistics after populating the table
2596: g_phase := 'Calling FND_STATS to collect statistics for FII_GL_JE_SUMMARY_B';
2597: FND_STATS.gather_table_stats
2598: (ownname => g_fii_schema,
2599: tabname => 'FII_GL_JE_SUMMARY_B');

Line 2596: g_phase := 'Calling FND_STATS to collect statistics for FII_GL_JE_SUMMARY_B';

2592: --Fix bug 3561245
2593: commit;
2594:
2595: --Call FND_STATS to collect statistics after populating the table
2596: g_phase := 'Calling FND_STATS to collect statistics for FII_GL_JE_SUMMARY_B';
2597: FND_STATS.gather_table_stats
2598: (ownname => g_fii_schema,
2599: tabname => 'FII_GL_JE_SUMMARY_B');
2600:

Line 2597: FND_STATS.gather_table_stats

2593: commit;
2594:
2595: --Call FND_STATS to collect statistics after populating the table
2596: g_phase := 'Calling FND_STATS to collect statistics for FII_GL_JE_SUMMARY_B';
2597: FND_STATS.gather_table_stats
2598: (ownname => g_fii_schema,
2599: tabname => 'FII_GL_JE_SUMMARY_B');
2600:
2601: g_phase := 'Enabling parallel dml';