eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJI_EXTRACTION_UTILS dependencies on FND_STATS

Line 256: FND_STATS.GATHER_TABLE_STATS(

252:
253: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
254: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
255:
256: FND_STATS.GATHER_TABLE_STATS(
257: ownname => l_schema
258: , tabname => 'PJI_FP_PROJ_ET_WT_F'
259: , percent => 10
260: , degree => l_degree

Line 262: FND_STATS.GATHER_TABLE_STATS(

258: , tabname => 'PJI_FP_PROJ_ET_WT_F'
259: , percent => 10
260: , degree => l_degree
261: );
262: FND_STATS.GATHER_TABLE_STATS(
263: ownname => l_schema
264: , tabname => 'PJI_FP_PROJ_ET_F'
265: , percent => 10
266: , degree => l_degree

Line 268: FND_STATS.GATHER_TABLE_STATS(

264: , tabname => 'PJI_FP_PROJ_ET_F'
265: , percent => 10
266: , degree => l_degree
267: );
268: FND_STATS.GATHER_TABLE_STATS(
269: ownname => l_schema
270: , tabname => 'PJI_FP_PROJ_F'
271: , percent => 10
272: , degree => l_degree

Line 274: FND_STATS.GATHER_TABLE_STATS(

270: , tabname => 'PJI_FP_PROJ_F'
271: , percent => 10
272: , degree => l_degree
273: );
274: FND_STATS.GATHER_TABLE_STATS(
275: ownname => l_schema
276: , tabname => 'PJI_AC_PROJ_F'
277: , percent => 10
278: , degree => l_degree

Line 280: FND_STATS.GATHER_TABLE_STATS(

276: , tabname => 'PJI_AC_PROJ_F'
277: , percent => 10
278: , degree => l_degree
279: );
280: FND_STATS.GATHER_TABLE_STATS(
281: ownname => l_schema
282: , tabname => 'PJI_RM_RES_F'
283: , percent => 10
284: , degree => l_degree

Line 286: FND_STATS.GATHER_TABLE_STATS(

282: , tabname => 'PJI_RM_RES_F'
283: , percent => 10
284: , degree => l_degree
285: );
286: FND_STATS.GATHER_TABLE_STATS(
287: ownname => l_schema
288: , tabname => 'PJI_RM_RES_WT_F'
289: , percent => 10
290: , degree => l_degree

Line 292: FND_STATS.GATHER_TABLE_STATS(

288: , tabname => 'PJI_RM_RES_WT_F'
289: , percent => 10
290: , degree => l_degree
291: );
292: FND_STATS.GATHER_TABLE_STATS(
293: ownname => l_schema
294: , tabname => 'PJI_FP_TXN_ACCUM_HEADER'
295: , percent => 10
296: , degree => l_degree

Line 298: FND_STATS.GATHER_TABLE_STATS(

294: , tabname => 'PJI_FP_TXN_ACCUM_HEADER'
295: , percent => 10
296: , degree => l_degree
297: );
298: FND_STATS.GATHER_TABLE_STATS(
299: ownname => l_schema
300: , tabname => 'PJI_FP_TXN_ACCUM'
301: , percent => 10
302: , degree => l_degree

Line 365: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P0' );

361: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
362: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
363:
364: -- partitioned tables
365: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P0' );
366: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P1' );
367: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P2' );
368: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P3' );
369: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P4' );

Line 366: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P1' );

362: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
363:
364: -- partitioned tables
365: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P0' );
366: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P1' );
367: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P2' );
368: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P3' );
369: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P4' );
370:

Line 367: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P2' );

363:
364: -- partitioned tables
365: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P0' );
366: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P1' );
367: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P2' );
368: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P3' );
369: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P4' );
370:
371: -- non-partitioned tables

Line 368: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P3' );

364: -- partitioned tables
365: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P0' );
366: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P1' );
367: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P2' );
368: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P3' );
369: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P4' );
370:
371: -- non-partitioned tables
372: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_ACT' , l_low_rows, l_low_blocks, 75);

Line 369: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P4' );

365: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P0' );
366: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P1' );
367: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P2' );
368: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P3' );
369: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P4' );
370:
371: -- non-partitioned tables
372: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_ACT' , l_low_rows, l_low_blocks, 75);
373: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT3' , l_high_rows, l_high_blocks, 225);

Line 372: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_ACT' , l_low_rows, l_low_blocks, 75);

368: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P3' );
369: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P4' );
370:
371: -- non-partitioned tables
372: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_ACT' , l_low_rows, l_low_blocks, 75);
373: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT3' , l_high_rows, l_high_blocks, 225);
374: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN3' , l_high_rows, l_high_blocks, 225);
375: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN4' , l_high_rows, l_high_blocks, 225);
376: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN5' , l_high_rows, l_high_blocks, 225);

Line 373: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT3' , l_high_rows, l_high_blocks, 225);

369: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150, 'P4' );
370:
371: -- non-partitioned tables
372: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_ACT' , l_low_rows, l_low_blocks, 75);
373: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT3' , l_high_rows, l_high_blocks, 225);
374: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN3' , l_high_rows, l_high_blocks, 225);
375: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN4' , l_high_rows, l_high_blocks, 225);
376: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN5' , l_high_rows, l_high_blocks, 225);
377: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_PLN' , l_med_rows, l_med_blocks, 150);

Line 374: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN3' , l_high_rows, l_high_blocks, 225);

370:
371: -- non-partitioned tables
372: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_ACT' , l_low_rows, l_low_blocks, 75);
373: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT3' , l_high_rows, l_high_blocks, 225);
374: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN3' , l_high_rows, l_high_blocks, 225);
375: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN4' , l_high_rows, l_high_blocks, 225);
376: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN5' , l_high_rows, l_high_blocks, 225);
377: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_PLN' , l_med_rows, l_med_blocks, 150);
378: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150);

Line 375: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN4' , l_high_rows, l_high_blocks, 225);

371: -- non-partitioned tables
372: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_ACT' , l_low_rows, l_low_blocks, 75);
373: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT3' , l_high_rows, l_high_blocks, 225);
374: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN3' , l_high_rows, l_high_blocks, 225);
375: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN4' , l_high_rows, l_high_blocks, 225);
376: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN5' , l_high_rows, l_high_blocks, 225);
377: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_PLN' , l_med_rows, l_med_blocks, 150);
378: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150);
379: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_FIN' , l_low_rows, l_low_blocks, 75);

Line 376: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN5' , l_high_rows, l_high_blocks, 225);

372: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_ACT' , l_low_rows, l_low_blocks, 75);
373: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT3' , l_high_rows, l_high_blocks, 225);
374: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN3' , l_high_rows, l_high_blocks, 225);
375: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN4' , l_high_rows, l_high_blocks, 225);
376: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN5' , l_high_rows, l_high_blocks, 225);
377: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_PLN' , l_med_rows, l_med_blocks, 150);
378: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150);
379: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_FIN' , l_low_rows, l_low_blocks, 75);
380: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_PJ_EXTR_PRJCLS' , l_low_rows, l_low_blocks, 75);

Line 377: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_PLN' , l_med_rows, l_med_blocks, 150);

373: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT3' , l_high_rows, l_high_blocks, 225);
374: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN3' , l_high_rows, l_high_blocks, 225);
375: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN4' , l_high_rows, l_high_blocks, 225);
376: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN5' , l_high_rows, l_high_blocks, 225);
377: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_PLN' , l_med_rows, l_med_blocks, 150);
378: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150);
379: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_FIN' , l_low_rows, l_low_blocks, 75);
380: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_PJ_EXTR_PRJCLS' , l_low_rows, l_low_blocks, 75);
381: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CATEGORIES' , l_low_rows, l_low_blocks, 75);

Line 378: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150);

374: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN3' , l_high_rows, l_high_blocks, 225);
375: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN4' , l_high_rows, l_high_blocks, 225);
376: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN5' , l_high_rows, l_high_blocks, 225);
377: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_PLN' , l_med_rows, l_med_blocks, 150);
378: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150);
379: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_FIN' , l_low_rows, l_low_blocks, 75);
380: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_PJ_EXTR_PRJCLS' , l_low_rows, l_low_blocks, 75);
381: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CATEGORIES' , l_low_rows, l_low_blocks, 75);
382: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CODES' , l_low_rows, l_low_blocks, 75);

Line 379: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_FIN' , l_low_rows, l_low_blocks, 75);

375: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN4' , l_high_rows, l_high_blocks, 225);
376: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN5' , l_high_rows, l_high_blocks, 225);
377: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_PLN' , l_med_rows, l_med_blocks, 150);
378: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150);
379: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_FIN' , l_low_rows, l_low_blocks, 75);
380: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_PJ_EXTR_PRJCLS' , l_low_rows, l_low_blocks, 75);
381: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CATEGORIES' , l_low_rows, l_low_blocks, 75);
382: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CODES' , l_low_rows, l_low_blocks, 75);
383: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN_LOG' , l_low_rows, l_low_blocks, 75);

Line 380: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_PJ_EXTR_PRJCLS' , l_low_rows, l_low_blocks, 75);

376: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN5' , l_high_rows, l_high_blocks, 225);
377: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_PLN' , l_med_rows, l_med_blocks, 150);
378: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150);
379: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_FIN' , l_low_rows, l_low_blocks, 75);
380: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_PJ_EXTR_PRJCLS' , l_low_rows, l_low_blocks, 75);
381: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CATEGORIES' , l_low_rows, l_low_blocks, 75);
382: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CODES' , l_low_rows, l_low_blocks, 75);
383: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN_LOG' , l_low_rows, l_low_blocks, 75);
384: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_REXT_FCSTITEM' , l_high_rows, l_high_blocks, 225);

Line 381: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CATEGORIES' , l_low_rows, l_low_blocks, 75);

377: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_PLN' , l_med_rows, l_med_blocks, 150);
378: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150);
379: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_FIN' , l_low_rows, l_low_blocks, 75);
380: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_PJ_EXTR_PRJCLS' , l_low_rows, l_low_blocks, 75);
381: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CATEGORIES' , l_low_rows, l_low_blocks, 75);
382: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CODES' , l_low_rows, l_low_blocks, 75);
383: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN_LOG' , l_low_rows, l_low_blocks, 75);
384: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_REXT_FCSTITEM' , l_high_rows, l_high_blocks, 225);
385: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES1' , l_high_rows, l_high_blocks, 225);

Line 382: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CODES' , l_low_rows, l_low_blocks, 75);

378: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN' , l_med_rows, l_med_blocks, 150);
379: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_FIN' , l_low_rows, l_low_blocks, 75);
380: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_PJ_EXTR_PRJCLS' , l_low_rows, l_low_blocks, 75);
381: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CATEGORIES' , l_low_rows, l_low_blocks, 75);
382: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CODES' , l_low_rows, l_low_blocks, 75);
383: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN_LOG' , l_low_rows, l_low_blocks, 75);
384: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_REXT_FCSTITEM' , l_high_rows, l_high_blocks, 225);
385: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES1' , l_high_rows, l_high_blocks, 225);
386: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES2' , l_high_rows, l_high_blocks, 225);

Line 383: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN_LOG' , l_low_rows, l_low_blocks, 75);

379: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_RMAP_FIN' , l_low_rows, l_low_blocks, 75);
380: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_PJ_EXTR_PRJCLS' , l_low_rows, l_low_blocks, 75);
381: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CATEGORIES' , l_low_rows, l_low_blocks, 75);
382: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CODES' , l_low_rows, l_low_blocks, 75);
383: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN_LOG' , l_low_rows, l_low_blocks, 75);
384: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_REXT_FCSTITEM' , l_high_rows, l_high_blocks, 225);
385: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES1' , l_high_rows, l_high_blocks, 225);
386: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES2' , l_high_rows, l_high_blocks, 225);
387: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES3' , l_high_rows, l_high_blocks, 225);

Line 384: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_REXT_FCSTITEM' , l_high_rows, l_high_blocks, 225);

380: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_PJ_EXTR_PRJCLS' , l_low_rows, l_low_blocks, 75);
381: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CATEGORIES' , l_low_rows, l_low_blocks, 75);
382: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CODES' , l_low_rows, l_low_blocks, 75);
383: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN_LOG' , l_low_rows, l_low_blocks, 75);
384: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_REXT_FCSTITEM' , l_high_rows, l_high_blocks, 225);
385: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES1' , l_high_rows, l_high_blocks, 225);
386: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES2' , l_high_rows, l_high_blocks, 225);
387: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES3' , l_high_rows, l_high_blocks, 225);
388: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_ORG_BATCH_MAP' , l_low_rows, l_low_blocks, 75);

Line 385: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES1' , l_high_rows, l_high_blocks, 225);

381: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CATEGORIES' , l_low_rows, l_low_blocks, 75);
382: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CODES' , l_low_rows, l_low_blocks, 75);
383: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN_LOG' , l_low_rows, l_low_blocks, 75);
384: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_REXT_FCSTITEM' , l_high_rows, l_high_blocks, 225);
385: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES1' , l_high_rows, l_high_blocks, 225);
386: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES2' , l_high_rows, l_high_blocks, 225);
387: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES3' , l_high_rows, l_high_blocks, 225);
388: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_ORG_BATCH_MAP' , l_low_rows, l_low_blocks, 75);
389:

Line 386: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES2' , l_high_rows, l_high_blocks, 225);

382: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_CLASS_CODES' , l_low_rows, l_low_blocks, 75);
383: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN_LOG' , l_low_rows, l_low_blocks, 75);
384: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_REXT_FCSTITEM' , l_high_rows, l_high_blocks, 225);
385: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES1' , l_high_rows, l_high_blocks, 225);
386: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES2' , l_high_rows, l_high_blocks, 225);
387: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES3' , l_high_rows, l_high_blocks, 225);
388: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_ORG_BATCH_MAP' , l_low_rows, l_low_blocks, 75);
389:
390: -- global temporary tables

Line 387: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES3' , l_high_rows, l_high_blocks, 225);

383: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_PLN_LOG' , l_low_rows, l_low_blocks, 75);
384: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_REXT_FCSTITEM' , l_high_rows, l_high_blocks, 225);
385: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES1' , l_high_rows, l_high_blocks, 225);
386: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES2' , l_high_rows, l_high_blocks, 225);
387: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES3' , l_high_rows, l_high_blocks, 225);
388: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_ORG_BATCH_MAP' , l_low_rows, l_low_blocks, 75);
389:
390: -- global temporary tables
391: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_ROWID_ORG_DENORM' , l_low_rows, l_low_blocks, 75);

Line 388: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_ORG_BATCH_MAP' , l_low_rows, l_low_blocks, 75);

384: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_REXT_FCSTITEM' , l_high_rows, l_high_blocks, 225);
385: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES1' , l_high_rows, l_high_blocks, 225);
386: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES2' , l_high_rows, l_high_blocks, 225);
387: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES3' , l_high_rows, l_high_blocks, 225);
388: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_ORG_BATCH_MAP' , l_low_rows, l_low_blocks, 75);
389:
390: -- global temporary tables
391: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_ROWID_ORG_DENORM' , l_low_rows, l_low_blocks, 75);
392:

Line 391: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_ROWID_ORG_DENORM' , l_low_rows, l_low_blocks, 75);

387: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES3' , l_high_rows, l_high_blocks, 225);
388: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_ORG_BATCH_MAP' , l_low_rows, l_low_blocks, 75);
389:
390: -- global temporary tables
391: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_ROWID_ORG_DENORM' , l_low_rows, l_low_blocks, 75);
392:
393: -- gather statistics for PJI metadata tables
394: FND_STATS.GATHER_TABLE_STATS(
395: ownname => l_schema

Line 394: FND_STATS.GATHER_TABLE_STATS(

390: -- global temporary tables
391: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_ROWID_ORG_DENORM' , l_low_rows, l_low_blocks, 75);
392:
393: -- gather statistics for PJI metadata tables
394: FND_STATS.GATHER_TABLE_STATS(
395: ownname => l_schema
396: , tabname => 'PJI_ORG_DENORM'
397: , percent => 50
398: , degree => l_degree

Line 400: FND_STATS.GATHER_TABLE_STATS(

396: , tabname => 'PJI_ORG_DENORM'
397: , percent => 50
398: , degree => l_degree
399: );
400: FND_STATS.GATHER_TABLE_STATS(
401: ownname => l_schema
402: , tabname => 'PJI_ORG_EXTR_INFO'
403: , percent => 50
404: , degree => l_degree

Line 406: FND_STATS.GATHER_TABLE_STATS(

402: , tabname => 'PJI_ORG_EXTR_INFO'
403: , percent => 50
404: , degree => l_degree
405: );
406: FND_STATS.GATHER_TABLE_STATS(
407: ownname => l_schema
408: , tabname => 'PJI_ORG_EXTR_STATUS'
409: , percent => 50
410: , degree => l_degree

Line 412: FND_STATS.GATHER_TABLE_STATS(

408: , tabname => 'PJI_ORG_EXTR_STATUS'
409: , percent => 50
410: , degree => l_degree
411: );
412: FND_STATS.GATHER_TABLE_STATS(
413: ownname => l_schema
414: , tabname => 'PJI_RM_WORK_TYPE_INFO'
415: , percent => 50
416: , degree => l_degree

Line 418: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

414: , tabname => 'PJI_RM_WORK_TYPE_INFO'
415: , percent => 50
416: , degree => l_degree
417: );
418: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,
419: tabname => 'PJI_RM_WORK_TYPE_INFO',
420: colname => 'WORK_TYPE_ID',
421: percent => 10,
422: degree => l_degree);

Line 423: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

419: tabname => 'PJI_RM_WORK_TYPE_INFO',
420: colname => 'WORK_TYPE_ID',
421: percent => 10,
422: degree => l_degree);
423: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,
424: tabname => 'PJI_RM_WORK_TYPE_INFO',
425: colname => 'RECORD_TYPE',
426: percent => 10,
427: degree => l_degree);

Line 428: FND_STATS.GATHER_TABLE_STATS(

424: tabname => 'PJI_RM_WORK_TYPE_INFO',
425: colname => 'RECORD_TYPE',
426: percent => 10,
427: degree => l_degree);
428: FND_STATS.GATHER_TABLE_STATS(
429: ownname => l_schema
430: , tabname => 'PJI_RESOURCES_DENORM'
431: , percent => 10
432: , degree => l_degree

Line 434: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

430: , tabname => 'PJI_RESOURCES_DENORM'
431: , percent => 10
432: , degree => l_degree
433: );
434: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
435: tabname => 'PJI_ORG_EXTR_STATUS',
436: percent => 10,
437: degree => l_degree);
438: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

Line 438: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

434: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
435: tabname => 'PJI_ORG_EXTR_STATUS',
436: percent => 10,
437: degree => l_degree);
438: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,
439: tabname => 'PJI_ORG_EXTR_STATUS',
440: colname => 'ORGANIZATION_ID',
441: percent => 10,
442: degree => l_degree);

Line 443: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

439: tabname => 'PJI_ORG_EXTR_STATUS',
440: colname => 'ORGANIZATION_ID',
441: percent => 10,
442: degree => l_degree);
443: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,
444: tabname => 'PJI_ORG_EXTR_STATUS',
445: colname => 'STATUS',
446: percent => 10,
447: degree => l_degree);

Line 448: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

444: tabname => 'PJI_ORG_EXTR_STATUS',
445: colname => 'STATUS',
446: percent => 10,
447: degree => l_degree);
448: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
449: tabname => 'PJI_RM_ORG_BATCH_MAP',
450: percent => 10,
451: degree => l_degree);
452: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

Line 452: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

448: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
449: tabname => 'PJI_RM_ORG_BATCH_MAP',
450: percent => 10,
451: degree => l_degree);
452: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,
453: tabname => 'PJI_RM_ORG_BATCH_MAP',
454: colname => 'ORGANIZATION_ID',
455: percent => 10,
456: degree => l_degree);

Line 457: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

453: tabname => 'PJI_RM_ORG_BATCH_MAP',
454: colname => 'ORGANIZATION_ID',
455: percent => 10,
456: degree => l_degree);
457: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,
458: tabname => 'PJI_RM_ORG_BATCH_MAP',
459: colname => 'EXTRACTION_TYPE',
460: percent => 10,
461: degree => l_degree);

Line 462: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

458: tabname => 'PJI_RM_ORG_BATCH_MAP',
459: colname => 'EXTRACTION_TYPE',
460: percent => 10,
461: degree => l_degree);
462: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
463: tabname => 'PJI_PROJECT_CLASSES',
464: percent => 10,
465: degree => l_degree); --Bug#4997700
466: END SEED_PJI_RM_STATS;