DBA Data[Home] [Help]

APPS.PJI_PJP_EXTRACTION_UTILS dependencies on PJI_UTILS

Line 373: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;

369: l_high_blocks := 1.25*(l_high_rows*225)/l_db_block_size;
370: l_med_blocks := 1.25*(l_med_rows*150)/l_db_block_size;
371: l_low_blocks := 1.25*(l_low_rows*75)/l_db_block_size;
372:
373: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
374: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
375: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
376:
377: -- partitioned tables

Line 374: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

370: l_med_blocks := 1.25*(l_med_rows*150)/l_db_block_size;
371: l_low_blocks := 1.25*(l_low_rows*75)/l_db_block_size;
372:
373: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
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);

Line 375: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();

371: l_low_blocks := 1.25*(l_low_rows*75)/l_db_block_size;
372:
373: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
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);

Line 425: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;

421: l_degree number;
422:
423: begin
424:
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,

Line 426: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

422:
423: begin
424:
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',

Line 427: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM;

423: begin
424:
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,

Line 509: pji_utils.write2out(FND_MESSAGE.GET);

505:
506: FND_MESSAGE.SET_NAME('PJI', 'PJI_SUM_CLEANALL_FAILED');
507:
508: if (upper(nvl(p_check, 'N')) <> 'Y') then
509: pji_utils.write2out(FND_MESSAGE.GET);
510: commit;
511: retcode := 1;
512: return;
513: end if;

Line 566: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

562: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
563:
564: commit;
565:
566: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
567: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
568:
569:
570:

Line 567: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;

563:
564: commit;
565:
566: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
567: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
568:
569:
570:
571: -- PJP summarization tables with persistent data

Line 634: l_fpm_upgrade := nvl(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'X');

630: commit;
631:
632: end if;
633:
634: l_fpm_upgrade := nvl(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'X');
635:
636: if (p_fpm_upgrade = 'Y' and l_fpm_upgrade <> 'C') then
637:
638: PJI_FM_PLAN_MAINT.CREATE_PRIMARY_UPGRD_PVT(p_context => 'TRUNCATE');