DBA Data[Home] [Help]

APPS.FII_USER_SEC_OPTIMIZER dependencies on FND_STATS

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

171: FII_UTIL.Write_Log ('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');
172: END IF;
173: --DBMS_OUTPUT.PUT_LINE('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');
174:
175: --Call FND_STATS to collect statistics after populating the table
176: g_phase := 'gather_table_stats for fii_cost_center_grants';
177: FND_STATS.gather_table_stats
178: (ownname => g_schema_name,
179: tabname => 'fii_cost_center_grants');

Line 177: FND_STATS.gather_table_stats

173: --DBMS_OUTPUT.PUT_LINE('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');
174:
175: --Call FND_STATS to collect statistics after populating the table
176: g_phase := 'gather_table_stats for fii_cost_center_grants';
177: FND_STATS.gather_table_stats
178: (ownname => g_schema_name,
179: tabname => 'fii_cost_center_grants');
180:
181: EXCEPTION