APPS.PA_FP_CALC_PLAN_PKG dependencies on FND_STATS

Line 1326: FND_STATS.GATHER_TABLE_STATS

1322: End If;
1323: l_num_blks := ROUND((l_numRows / 30));
1324: IF p_table_name IS NOT NULL Then
1325: /* Calling Gather_table_stats implicitly commits the data so changed to set_table_stats
1326: FND_STATS.GATHER_TABLE_STATS
1327: (ownname => g_owner_name
1328: ,tabname => UPPER(p_table_name)
1329: ,cascade => TRUE
1330: ,percent in number

Line 1340: FND_STATS.SET_TABLE_STATS

1336: ,invalidate in varchar2 default 'Y'
1337: );
1338: */
1339: print_msg('Calling set Table Stats API for ['||p_table_name||']');
1340: FND_STATS.SET_TABLE_STATS
1341: (ownname => g_owner_name
1342: ,tabname => UPPER(p_table_name)
1343: ,numrows => l_numRows
1344: ,numblks => l_num_blks