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 420: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

416: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
417: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
418:
419: -- partitioned tables
420: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
421: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
422: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
423: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
424: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

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

417: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
418:
419: -- partitioned tables
420: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
421: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
422: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
423: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
424: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
425: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

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

418:
419: -- partitioned tables
420: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
421: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
422: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
423: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
424: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
425: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
426: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);

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

419: -- partitioned tables
420: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
421: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
422: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
423: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
424: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
425: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
426: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
427: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);

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

420: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
421: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
422: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
423: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
424: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
425: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
426: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
427: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
428: 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 425: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);

421: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
422: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
423: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
424: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
425: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
426: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
427: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
428: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
429: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

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

422: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
423: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
424: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
425: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
426: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
427: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
428: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
429: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
430: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

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

423: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_CUST_PJP0', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
424: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
425: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
426: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
427: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
428: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
429: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
430: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
431: 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 428: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);

424: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
425: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
426: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
427: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
428: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
429: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
430: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
431: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
432: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

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

425: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_AGGR_PJP1', l_high_rows, l_high_blocks, 225, 'P' || p_worker_id);
426: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
427: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
428: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
429: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
430: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
431: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
432: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
433: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);

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

426: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_XBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
427: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
428: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
429: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
430: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
431: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
432: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
433: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
434:

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

427: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_AGGR_RBS', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
428: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
429: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
430: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
431: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
432: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
433: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
434:
435: -- non-partitioned tables

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

428: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', l_med_rows, l_med_blocks, 150, 'P' || p_worker_id);
429: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
430: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
431: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
432: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
433: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
434:
435: -- non-partitioned tables
436: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);

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

429: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_XBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
430: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_RBS_DENORM_DELTA', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
431: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PA_PROJ_EVENTS_LOG', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
432: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
433: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
434:
435: -- non-partitioned tables
436: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);
437: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);

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

432: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_FP_RMAP_FPR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
433: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
434:
435: -- non-partitioned tables
436: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);
437: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);
438:
439: -- gather statistics for PJI metadata tables
440: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,

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

433: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_AC_RMAP_ACR', l_low_rows, l_low_blocks, 75, 'P' || p_worker_id);
434:
435: -- non-partitioned tables
436: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);
437: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);
438:
439: -- gather statistics for PJI metadata tables
440: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
441: tabname => 'PJI_PJP_PROJ_EXTR_STATUS',

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

436: FND_STATS.SET_TABLE_STATS(l_pa_schema, 'PA_RBS_TXN_ACCUM_MAP', l_med_rows, l_med_blocks, 150);
437: FND_STATS.SET_TABLE_STATS(l_pji_schema, 'PJI_PJP_PROJ_EXTR_STATUS', l_med_rows, l_med_blocks, 150);
438:
439: -- gather statistics for PJI metadata tables
440: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
441: tabname => 'PJI_PJP_PROJ_EXTR_STATUS',
442: percent => 10,
443: degree => l_degree);
444:

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

467: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
468: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
469: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM;
470:
471: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
472: tabname => 'PJI_FP_XBS_ACCUM_F',
473: percent => 10,
474: degree => l_degree);
475:

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

472: tabname => 'PJI_FP_XBS_ACCUM_F',
473: percent => 10,
474: degree => l_degree);
475:
476: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
477: tabname => 'PJI_AC_XBS_ACCUM_F',
478: percent => 10,
479: degree => l_degree);
480:

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

477: tabname => 'PJI_AC_XBS_ACCUM_F',
478: percent => 10,
479: degree => l_degree);
480:
481: FND_STATS.GATHER_TABLE_STATS(ownname => l_pa_schema,
482: tabname => 'PA_XBS_DENORM',
483: percent => 10,
484: degree => l_degree);
485:

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

482: tabname => 'PA_XBS_DENORM',
483: percent => 10,
484: degree => l_degree);
485:
486: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
487: tabname => 'PJI_XBS_DENORM',
488: percent => 10,
489: degree => l_degree);
490:

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

487: tabname => 'PJI_XBS_DENORM',
488: percent => 10,
489: degree => l_degree);
490:
491: FND_STATS.GATHER_TABLE_STATS(ownname => l_pa_schema,
492: tabname => 'PA_RBS_DENORM',
493: percent => 10,
494: degree => l_degree);
495:

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

492: tabname => 'PA_RBS_DENORM',
493: percent => 10,
494: degree => l_degree);
495:
496: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
497: tabname => 'PJI_RBS_DENORM',
498: percent => 10,
499: degree => l_degree);
500:

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

497: tabname => 'PJI_RBS_DENORM',
498: percent => 10,
499: degree => l_degree);
500:
501: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
502: tabname => 'PJI_PJP_WBS_HEADER',
503: percent => 10,
504: degree => l_degree);
505:

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

502: tabname => 'PJI_PJP_WBS_HEADER',
503: percent => 10,
504: degree => l_degree);
505:
506: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,
507: tabname => 'PJI_PJP_RBS_HEADER',
508: percent => 10,
509: degree => l_degree);
510: