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

Line 377: FND_STATS.GATHER_TABLE_STATS(

373: --#bug 5356051
374: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
375: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
376:
377: FND_STATS.GATHER_TABLE_STATS(
378: ownname => l_pa_schema
379: , tabname => 'PA_XBS_DENORM'
380: , percent => 10
381: , degree => l_degree

Line 384: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,

380: , percent => 10
381: , degree => l_degree
382: );
383:
384: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,
385: indname => 'PA_XBS_DENORM_N1',
386: percent => 10);
387:
388: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,

Line 388: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,

384: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,
385: indname => 'PA_XBS_DENORM_N1',
386: percent => 10);
387:
388: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,
389: indname => 'PA_XBS_DENORM_N2',
390: percent => 10);
391:
392: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,

Line 392: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,

388: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,
389: indname => 'PA_XBS_DENORM_N2',
390: percent => 10);
391:
392: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,
393: indname => 'PA_XBS_DENORM_N3',
394: percent => 10);
395:
396: --#bug 5356051

Line 407: FND_STATS.GATHER_TABLE_STATS(

403:
404: --#bug 5356051
405: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
406:
407: FND_STATS.GATHER_TABLE_STATS(
408: ownname => l_pji_schema
409: , tabname => 'PJI_XBS_DENORM'
410: , percent => 10
411: , degree => l_degree

Line 414: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,

410: , percent => 10
411: , degree => l_degree
412: );
413:
414: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,
415: indname => 'PJI_XBS_DENORM_N1',
416: percent => 10);
417:
418: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,

Line 418: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,

414: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,
415: indname => 'PJI_XBS_DENORM_N1',
416: percent => 10);
417:
418: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,
419: indname => 'PJI_XBS_DENORM_N2',
420: percent => 10);
421:
422: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,

Line 422: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,

418: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,
419: indname => 'PJI_XBS_DENORM_N2',
420: percent => 10);
421:
422: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,
423: indname => 'PJI_XBS_DENORM_N3',
424: percent => 10);
425:
426: --#bug 5356051

Line 869: /*fnd_stats.gather_table_stats('PA','PA_RESOURCE_ASSIGNMENTS',PERCENT=>40);

865: print_time('Populated WBS header table.');
866:
867: -- Bug 15881881
868: -- Commented for bug 16360282
869: /*fnd_stats.gather_table_stats('PA','PA_RESOURCE_ASSIGNMENTS',PERCENT=>40);
870: fnd_stats.gather_table_stats('PA','PA_BUDGET_LINES',PERCENT=>40); */
871: -- End Bug 15881881
872:
873: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;

Line 870: fnd_stats.gather_table_stats('PA','PA_BUDGET_LINES',PERCENT=>40); */

866:
867: -- Bug 15881881
868: -- Commented for bug 16360282
869: /*fnd_stats.gather_table_stats('PA','PA_RESOURCE_ASSIGNMENTS',PERCENT=>40);
870: fnd_stats.gather_table_stats('PA','PA_BUDGET_LINES',PERCENT=>40); */
871: -- End Bug 15881881
872:
873: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
874: print_time(' Extracted plan data for primary RBSes.');

Line 886: fnd_stats.gather_table_stats('PJI','PJI_FP_AGGR_PJP1',PERCENT=>40);

882: /* Added for bug 8708651 */
883: l_time_phase_flag := PJI_UTILS.GET_SETUP_PARAMETER('TIME_PHASE_FLAG');
884:
885: -- Bug 15881881
886: fnd_stats.gather_table_stats('PJI','PJI_FP_AGGR_PJP1',PERCENT=>40);
887: -- End Bug 15881881
888: if l_time_phase_flag = 'Y' then
889: null;
890: else

Line 901: fnd_stats.gather_table_stats('PJI','PJI_FP_AGGR_PJP1',PERCENT=>40);

897: -- PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR; /* Commented for bug 13897252 */
898: -- print_time(' Updated the WBS header table with min max txn dates.');
899:
900: -- Bug 15881881
901: fnd_stats.gather_table_stats('PJI','PJI_FP_AGGR_PJP1',PERCENT=>40);
902: -- Commented for bug 16360282
903: -- fnd_stats.gather_table_stats('PJI','PJI_FP_XBS_ACCUM_F',PERCENT=>40);
904: -- End Bug 15881881
905:

Line 903: -- fnd_stats.gather_table_stats('PJI','PJI_FP_XBS_ACCUM_F',PERCENT=>40);

899:
900: -- Bug 15881881
901: fnd_stats.gather_table_stats('PJI','PJI_FP_AGGR_PJP1',PERCENT=>40);
902: -- Commented for bug 16360282
903: -- fnd_stats.gather_table_stats('PJI','PJI_FP_XBS_ACCUM_F',PERCENT=>40);
904: -- End Bug 15881881
905:
906: Pji_Fm_Plan_Maint_Pvt.EXTRACT_DANGL_REVERSAL;
907: print_time(' Inserted Reversal records for dangling plans.');