DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on FND_STATS

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

4354: fetch c1 bulk collect into x_row_id limit 500000;
4355:
4356: If x_row_id.count > 0 then
4357: -- gather statistics for PJI metadata tables
4358: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4359: tabname => 'PJI_FP_AGGR_PJP1',
4360: percent => 5,
4361: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
4362:

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

4360: percent => 5,
4361: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
4362:
4363: -- gather statistics for PJI metadata tables
4364: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4365: tabname => 'PJI_FP_XBS_ACCUM_F',
4366: percent => 5,
4367: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
4368:

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

11234: fetch c1 bulk collect into x_row_id limit 500000;
11235:
11236: If x_row_id.count > 0 then
11237: -- gather statistics for PJI metadata tables
11238: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
11239: tabname => 'PJI_FP_AGGR_PJP1',
11240: percent => 5,
11241: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11242:

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

11240: percent => 5,
11241: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11242:
11243: -- gather statistics for PJI metadata tables
11244: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
11245: tabname => 'PJI_FP_XBS_ACCUM_F',
11246: percent => 5,
11247: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11248: