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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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:
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
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);
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);
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,
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',
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:
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:
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:
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:
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:
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:
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:
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:
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: