DBA Data[Home] [Help]

APPS.FII_BUDGET_FORECAST_C dependencies on FND_STATS

Line 6769: FND_STATS.GATHER_TABLE_STATS(

6765:
6766: /* fix by ilavenil, gather statistics on fii_budget_interface*/
6767: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry,
6768: l_fii_schema)) THEN
6769: FND_STATS.GATHER_TABLE_STATS(
6770: OWNNAME => l_fii_schema,
6771: TABNAME => 'FII_BUDGET_INTERFACE');
6772:
6773: -- Bug 4674640: Should enable parallel dml after calling

Line 6998: FND_STATS.gather_table_stats

6994:
6995: FII_BUDGET_FORECAST_C.Psi_Budget_Extract(l_ret_code);
6996:
6997: -- Bug 4674640: Added gather stats for the budget base table
6998: FND_STATS.gather_table_stats
6999: (ownname => l_fii_schema,
7000: tabname => 'FII_BUDGET_BASE');
7001:
7002: execute immediate 'alter session enable parallel dml';

Line 7569: FND_STATS.gather_table_stats

7565:
7566: FND_CONCURRENT.Af_Commit;
7567:
7568: -- Bug 4674640: Added gather stats for the budget base table
7569: FND_STATS.gather_table_stats
7570: (ownname => l_fii_schema,
7571: tabname => 'FII_BUDGET_BASE');
7572:
7573: execute immediate 'alter session enable parallel dml';