APPS.PJI_PJP_EXTRACTION_UTILS dependencies on PJI_UTILS

Line 415: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;

411: l_high_blocks := 1.25*(l_high_rows*225)/l_db_block_size;
412: l_med_blocks := 1.25*(l_med_rows*150)/l_db_block_size;
413: l_low_blocks := 1.25*(l_low_rows*75)/l_db_block_size;
414:
415: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
416: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
417: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
418:
419: -- partitioned tables

Line 416: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

412: l_med_blocks := 1.25*(l_med_rows*150)/l_db_block_size;
413: l_low_blocks := 1.25*(l_low_rows*75)/l_db_block_size;
414:
415: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
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);

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

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

Line 467: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;

463: l_degree number;
464:
465: begin
466:
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,

Line 468: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

464:
465: begin
466:
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',

Line 469: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM;

465: begin
466:
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,

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

547:
548: FND_MESSAGE.SET_NAME('PJI', 'PJI_SUM_CLEANALL_FAILED');
549:
550: if (upper(nvl(p_check, 'N')) <> 'Y') then
551: pji_utils.write2out(FND_MESSAGE.GET);
552: commit;
553: retcode := 1;
554: return;
555: end if;

Line 608: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

604: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
605:
606: commit;
607:
608: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
609: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
610:
611:
612:

Line 609: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;

605:
606: commit;
607:
608: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
609: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
610:
611:
612:
613: -- PJP summarization tables with persistent data

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

676: commit;
677:
678: end if;
679:
680: l_fpm_upgrade := nvl(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'X');
681:
682: if (p_fpm_upgrade = 'Y' and l_fpm_upgrade <> 'C') then
683:
684: PJI_FM_PLAN_MAINT.CREATE_PRIMARY_UPGRD_PVT(p_context => 'TRUNCATE');