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