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_PJP_EXTRACTION_UTILS dependencies on FND_STATS

Line 378: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

374: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
375: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
376:
377: -- partitioned tables
378: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
379: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
380: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
381: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
382: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

Line 379: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

375: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
376:
377: -- partitioned tables
378: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
379: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
380: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
381: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
382: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
383: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

Line 380: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

376:
377: -- partitioned tables
378: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
379: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
380: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
381: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
382: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
383: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
384: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);

Line 381: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

377: -- partitioned tables
378: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
379: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
380: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
381: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
382: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
383: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
384: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
385: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);

Line 382: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

378: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
379: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
380: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
381: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
382: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
383: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
384: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
385: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
386: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);

Line 383: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

379: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
380: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
381: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
382: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
383: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
384: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
385: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
386: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
387: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

Line 384: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);

380: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
381: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
382: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
383: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
384: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
385: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
386: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
387: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
388: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

Line 385: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);

381: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
382: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
383: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
384: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
385: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
386: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
387: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
388: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
389: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

Line 386: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);

382: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
383: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
384: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
385: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
386: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
387: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
388: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
389: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
390: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

Line 387: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

383: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
384: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
385: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
386: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
387: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
388: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
389: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
390: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
391: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

Line 388: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

384: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
385: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
386: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
387: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
388: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
389: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
390: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
391: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
392:

Line 389: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

385: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
386: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
387: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
388: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
389: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
390: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
391: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
392:
393: -- non-partitioned tables

Line 390: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

386: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
387: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
388: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
389: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
390: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
391: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
392:
393: -- non-partitioned tables
394: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);

Line 391: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

387: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
388: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
389: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
390: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
391: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
392:
393: -- non-partitioned tables
394: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);
395: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);

Line 394: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);

390: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
391: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
392:
393: -- non-partitioned tables
394: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);
395: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);
396:
397: -- gather statistics for PJI metadata tables
398: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,

Line 395: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);

391: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
392:
393: -- non-partitioned tables
394: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);
395: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);
396:
397: -- gather statistics for PJI metadata tables
398: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
399: tabname => 'PJI_PJP_PROJ_EXTR_STATUS',

Line 398: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,

394: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);
395: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);
396:
397: -- gather statistics for PJI metadata tables
398: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
399: tabname => 'PJI_PJP_PROJ_EXTR_STATUS',
400: percent => 10,
401: degree => l_degree);
402:

Line 429: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,

425: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
426: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
427: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM;
428:
429: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
430: tabname => 'PJI_FP_XBS_ACCUM_F',
431: percent => 10,
432: degree => l_degree);
433:

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

430: tabname => 'PJI_FP_XBS_ACCUM_F',
431: percent => 10,
432: degree => l_degree);
433:
434: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
435: tabname => 'PJI_AC_XBS_ACCUM_F',
436: percent => 10,
437: degree => l_degree);
438:

Line 439: FND_STATS.GATHER_TABLE_STATS(ownname => l_pa_schema,

435: tabname => 'PJI_AC_XBS_ACCUM_F',
436: percent => 10,
437: degree => l_degree);
438:
439: FND_STATS.GATHER_TABLE_STATS(ownname => l_pa_schema,
440: tabname => 'PA_XBS_DENORM',
441: percent => 10,
442: degree => l_degree);
443:

Line 444: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,

440: tabname => 'PA_XBS_DENORM',
441: percent => 10,
442: degree => l_degree);
443:
444: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
445: tabname => 'PJI_XBS_DENORM',
446: percent => 10,
447: degree => l_degree);
448:

Line 449: FND_STATS.GATHER_TABLE_STATS(ownname => l_pa_schema,

445: tabname => 'PJI_XBS_DENORM',
446: percent => 10,
447: degree => l_degree);
448:
449: FND_STATS.GATHER_TABLE_STATS(ownname => l_pa_schema,
450: tabname => 'PA_RBS_DENORM',
451: percent => 10,
452: degree => l_degree);
453:

Line 454: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,

450: tabname => 'PA_RBS_DENORM',
451: percent => 10,
452: degree => l_degree);
453:
454: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
455: tabname => 'PJI_RBS_DENORM',
456: percent => 10,
457: degree => l_degree);
458:

Line 459: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,

455: tabname => 'PJI_RBS_DENORM',
456: percent => 10,
457: degree => l_degree);
458:
459: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
460: tabname => 'PJI_PJP_WBS_HEADER',
461: percent => 10,
462: degree => l_degree);
463:

Line 464: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,

460: tabname => 'PJI_PJP_WBS_HEADER',
461: percent => 10,
462: degree => l_degree);
463:
464: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
465: tabname => 'PJI_PJP_RBS_HEADER',
466: percent => 10,
467: degree => l_degree);
468: