DBA Data[Home] [Help]

APPS.PA_FP_CALC_PLAN_PKG dependencies on FND_STATS

Line 1356: FND_STATS.GATHER_TABLE_STATS

1352: End If;
1353: l_num_blks := ROUND((l_numRows / 30));
1354: IF p_table_name IS NOT NULL Then
1355: /* Calling Gather_table_stats implicitly commits the data so changed to set_table_stats
1356: FND_STATS.GATHER_TABLE_STATS
1357: (ownname => g_owner_name
1358: ,tabname => UPPER(p_table_name)
1359: ,cascade => TRUE
1360: ,percent in number

Line 1370: FND_STATS.SET_TABLE_STATS

1366: ,invalidate in varchar2 default 'Y'
1367: );
1368: */
1369: print_msg('Calling set Table Stats API for ['||p_table_name||']');
1370: FND_STATS.SET_TABLE_STATS
1371: (ownname => g_owner_name
1372: ,tabname => UPPER(p_table_name)
1373: ,numrows => l_numRows
1374: ,numblks => l_num_blks