APPS.PJI_FM_PLAN_MAINT_PVT dependencies on FND_STATS

Line 5539: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

5535: fetch c1 bulk collect into x_row_id limit 500000;
5536:
5537: If x_row_id.count > 0 then
5538: -- gather statistics for PJI metadata tables
5539: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
5540: tabname => 'PJI_FP_AGGR_PJP1',
5541: percent => 5,
5542: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
5543:

Line 5545: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

5541: percent => 5,
5542: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
5543:
5544: -- gather statistics for PJI metadata tables
5545: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
5546: tabname => 'PJI_FP_XBS_ACCUM_F',
5547: percent => 5,
5548: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
5549:

Line 12684: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

12680: /*Bug Fix 9212516*/
12681:
12682: -- gather statistics for PJI metadata tables
12683: /* Gather stats by partition added for bug 7551819 */
12684: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
12685: tabname => 'PJI_FP_AGGR_PJP1',
12686: partname=>'P'|| g_worker_id,
12687: granularity=>'PARTITION',
12688: percent => 5,

Line 12698: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

12694:
12695: if l_from_launch = 'N' then
12696: IF nvl(FND_PROFILE.VALUE('PJI_GATHERSTATS_FACT'),'N') = 'Y' THEN -- Added for bug 11789673 Base bug 9824355
12697: -- gather statistics for PJI metadata tables
12698: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
12699: tabname => 'PJI_FP_XBS_ACCUM_F',
12700: percent => 5,
12701: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
12702: END IF;

Line 13152: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

13148:
13149: /* Added for bug 14636607 Starts */
13150: else
13151:
13152: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
13153: tabname => 'PJI_FP_AGGR_PJP1',
13154: partname => 'P'|| g_worker_id,
13155: granularity => 'PARTITION',
13156: percent => 5,

Line 13576: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

13572:
13573: close c1;
13574:
13575: /* Gather stats since we have inserted data into fact table */
13576: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
13577: tabname => 'PJI_FP_XBS_ACCUM_F',
13578: percent => 5,
13579: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
13580: