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 PJI_PJP_SUM_ROLLUP

Line 339: PJI_PJP_SUM_ROLLUP.REMAP_RBS_TXN_ACCUM_HDRS(l_worker_id);

335: --
336: -- 0. ... Remap txn accum headers with new rbs element ids.
337: --
338: IF (p_context = 'TRUNCATE') THEN
339: PJI_PJP_SUM_ROLLUP.REMAP_RBS_TXN_ACCUM_HDRS(l_worker_id);
340: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(l_worker_id, 'ALL', NULL);
341: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(l_worker_id);
342: END IF;
343:

Line 341: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(l_worker_id);

337: --
338: IF (p_context = 'TRUNCATE') THEN
339: PJI_PJP_SUM_ROLLUP.REMAP_RBS_TXN_ACCUM_HDRS(l_worker_id);
340: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(l_worker_id, 'ALL', NULL);
341: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(l_worker_id);
342: END IF;
343:
344: --
345: -- 1. ... populate pji_time% tables.

Line 347: PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(l_worker_id);

343:
344: --
345: -- 1. ... populate pji_time% tables.
346: --
347: PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(l_worker_id);
348: l_count := l_count + 1;
349: print_time('FPM Upgr a ' || l_count);
350:
351: --

Line 400: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(l_worker_id);

396: --#bug 5356051
397: --
398: -- 3. ... populate pji xbs denorm table for wbs/programs.
399: --
400: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(l_worker_id);
401: l_count := 31;
402: print_time('FPM Upgr c ' || l_count);
403:
404: --#bug 5356051

Line 433: PJI_PJP_SUM_ROLLUP.EXTRACT_FIN_PLAN_VERS_BULK(l_worker_id);

429: -- 4. ... cache plan version related info like time phased code type (pa/gl cal),
430: -- whether it is workplan/financial plan, is it current original/baselined
431: -- baselined version, etc in ver3.
432: --
433: PJI_PJP_SUM_ROLLUP.EXTRACT_FIN_PLAN_VERS_BULK(l_worker_id);
434: l_count := l_count + 1;
435: print_time('FPM Upgr d ' || l_count);
436: -- PRINT_TBL_SIZE;
437:

Line 441: PJI_PJP_SUM_ROLLUP.POPULATE_WBS_HDR(l_worker_id);

437:
438: --
439: -- 5. ... populate the wbs header table.
440: --
441: PJI_PJP_SUM_ROLLUP.POPULATE_WBS_HDR(l_worker_id);
442: l_count := l_count + 1;
443: print_time('FPM Upgr e ' || l_count);
444:
445:

Line 449: PJI_PJP_SUM_ROLLUP.POPULATE_RBS_HDR(l_worker_id);

445:
446: --
447: -- 6. ... populate the rbs header table.
448: --
449: PJI_PJP_SUM_ROLLUP.POPULATE_RBS_HDR(l_worker_id);
450: l_count := l_count + 1;
451: print_time('FPM Upgr f ' || l_count);
452:
453: --

Line 460: PJI_PJP_SUM_ROLLUP.RETRIEVE_OVERRIDDEN_WP_ETC(l_worker_id);

456:
457: IF (p_context = 'TRUNCATE') THEN
458:
459: -- Extract plan lines.
460: PJI_PJP_SUM_ROLLUP.RETRIEVE_OVERRIDDEN_WP_ETC(l_worker_id);
461: l_count := l_count + 1;
462: -- print_time('FPM Upgr g ' || l_count);
463:
464: -- Extract plans and etc (=plan).

Line 465: PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_ETC_PRIRBS(l_worker_id);

461: l_count := l_count + 1;
462: -- print_time('FPM Upgr g ' || l_count);
463:
464: -- Extract plans and etc (=plan).
465: PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_ETC_PRIRBS(l_worker_id);
466: l_count := l_count + 1;
467: print_time('FPM Upgr g ' || l_count);
468:
469: -- Delete plan lines.

Line 470: -- PJI_PJP_SUM_ROLLUP.DELETE_PLAN_LINES(l_worker_id);

466: l_count := l_count + 1;
467: print_time('FPM Upgr g ' || l_count);
468:
469: -- Delete plan lines.
470: -- PJI_PJP_SUM_ROLLUP.DELETE_PLAN_LINES(l_worker_id);
471: -- l_count := l_count + 1;
472: -- print_time('FPM Upgr g ' || l_count);
473:
474: ELSIF (p_context = 'FPM_UPGRADE') THEN

Line 476: PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_AMOUNTS_PRIRBS(l_worker_id);

472: -- print_time('FPM Upgr g ' || l_count);
473:
474: ELSIF (p_context = 'FPM_UPGRADE') THEN
475:
476: PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_AMOUNTS_PRIRBS(l_worker_id);
477: l_count := l_count + 1;
478: print_time('FPM Upgr g ' || l_count);
479:
480: END IF;

Line 486: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(l_worker_id);

482:
483: --
484: -- 9. ... update the wbs header table.
485: --
486: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(l_worker_id);
487: l_count := l_count + 1;
488: print_time('FPM Upgr e ' || l_count);
489:
490:

Line 494: PJI_PJP_SUM_ROLLUP.CREATE_FP_PA_PRI_ROLLUP(l_worker_id);

490:
491: --
492: -- 11. ... perform time rollup for 'PA' calendar and insert data into pjp1.
493: --
494: PJI_PJP_SUM_ROLLUP.CREATE_FP_PA_PRI_ROLLUP(l_worker_id);
495: l_count := l_count + 1;
496: print_time('FPM Upgr k ' || l_count);
497:
498: --

Line 501: PJI_PJP_SUM_ROLLUP.CREATE_FP_GL_PRI_ROLLUP(l_worker_id);

497:
498: --
499: -- 12. ... perform time rollup for 'GL' calendar and insert data into pjp1.
500: --
501: PJI_PJP_SUM_ROLLUP.CREATE_FP_GL_PRI_ROLLUP(l_worker_id);
502: l_count := l_count + 1;
503: print_time('FPM Upgr l ' || l_count);
504: -- PRINT_TBL_SIZE;
505:

Line 509: PJI_PJP_SUM_ROLLUP.CREATE_FP_ALL_PRI_ROLLUP(l_worker_id);

505:
506: --
507: -- 12.1 ... perform 2048 slice time rollup for PA and GL calendarS and insert data into pjp1.
508: --
509: PJI_PJP_SUM_ROLLUP.CREATE_FP_ALL_PRI_ROLLUP(l_worker_id);
510: l_count := l_count + 1;
511: print_time('FPM Upgr l ' || l_count);
512: -- PRINT_TBL_SIZE;
513:

Line 518: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_T_SLICE(l_worker_id);

514:
515: --
516: -- 10. ... perform rbs rollup for 'T' slice alone and insert data into pjp1.
517: --
518: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_T_SLICE(l_worker_id);
519: l_count := 50;
520: l_count := l_count + 1;
521: print_time('FPM Upgr j ' || l_count);
522:

Line 526: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(l_worker_id);

522:
523: --
524: -- 9. ... perform wbs rollup and insert data into pjp1.
525: --
526: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(l_worker_id);
527: l_count := l_count + 1;
528: print_time('FPM Upgr i ' || l_count);
529: -- PRINT_TBL_SIZE;
530:

Line 535: PJI_PJP_SUM_ROLLUP.INSERT_INTO_FP_FACT(l_worker_id);

531:
532: --
533: -- 13. ... insert data in pjp1 into pji_fp_xbs_accum_f.
534: --
535: PJI_PJP_SUM_ROLLUP.INSERT_INTO_FP_FACT(l_worker_id);
536: l_count := l_count + 1;
537: print_time('FPM Upgr ' || l_count);
538:
539: --

Line 542: PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PLANS(l_worker_id);

538:
539: --
540: -- 14. ... mark all the extracted financial plan versions as 'P' and work plans as 'Y'.
541: --
542: PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PLANS(l_worker_id);
543: l_count := l_count + 1;
544: print_time('FPM Upgr ' || l_count);
545:
546:

Line 795: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;

791: -- Mark extracted versions, clean up the interim tables and insert into FP RL fact.
792:
793:
794: PRI_SLICE_CREATE_T; print_time(' 6 .. ');
795: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
796: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT; print_time(' 14 .. ');
797:
798: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('PRI'); print_time(' 15 .. ');
799:

Line 935: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;

931:
932: SEC_SLICE_CREATE_T;
933: print_time('Proration done and rollups created.');
934:
935: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
936:
937: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;
938: print_time('Merged reversed data.');
939:

Line 1000: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;

996: -- Mark extracted versions, clean up the interim tables and insert into FP RL fact.
997:
998: PRI_SLICE_CREATE_T;
999: print_time ( ' 3 PRI_SLICE_CREATE_T ');
1000: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
1001: WBSCHANGEPROC_POSTRLP_CLEANUP;
1002: print_time(' Cleanup after calling WBS rollup code. ');
1003:
1004: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;

Line 1061: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;

1057: p_new_pub_version_id => p_plan_version_id
1058: , p_prev_pub_version_id => p_prev_pub_version_id ) ; print_time ( ' 0.2 ');
1059:
1060: PRI_SLICE_CREATE_T; print_time ( ' 3 ');
1061: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
1062: -- WBSCHANGEPROC_POSTRLP_CLEANUP;
1063: -- print_time(' Cleanup after calling WBS rollup code. ');
1064:
1065: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT; print_time(' 4 .. ');

Line 1507: Pji_Pjp_Sum_Rollup.set_online_context (

1503:
1504: print_time('project_id = ' || j.project_id);
1505: print_time('wbs_version_id = ' || j.wbs_struct_version_id);
1506:
1507: Pji_Pjp_Sum_Rollup.set_online_context (
1508: p_event_id => NULL,
1509: p_project_id => j.project_id,
1510: p_plan_type_id => NULL,
1511: p_old_baselined_version => NULL,

Line 1530: Pji_Pjp_Sum_Rollup.update_xbs_denorm;

1526: );
1527:
1528: print_time(' row cnt after populating xbs denorm ' || SQL%ROWCOUNT );
1529:
1530: Pji_Pjp_Sum_Rollup.update_xbs_denorm;
1531:
1532: print_time(' row cnt after updating xbs denorm ' || SQL%ROWCOUNT );
1533:
1534: Pji_Pjp_Sum_Denorm.cleanup_xbs_denorm(

Line 1836: Pji_Pjp_Sum_Rollup.set_online_context (

1832: p_prg_group2 => NULL
1833: );
1834: print_time(' PA denorm table data created. ');
1835:
1836: Pji_Pjp_Sum_Rollup.set_online_context (
1837: p_event_id => g_event_rec.event_id,
1838: p_project_id => l_project_id,
1839: p_plan_type_id => NULL,
1840: p_old_baselined_version => NULL,

Line 1848: Pji_Pjp_Sum_Rollup.populate_xbs_denorm_delta;

1844: p_old_struct_version => l_wbs_version_id,
1845: p_new_struct_version => l_wbs_version_id
1846: );
1847:
1848: Pji_Pjp_Sum_Rollup.populate_xbs_denorm_delta;
1849: print_time(' PA denorm delta table data created. ');
1850:
1851: END IF;
1852:

Line 1868: Pji_Pjp_Sum_Rollup.rollup_acr_wbs;

1864: BEGIN
1865:
1866: IF g_process_update_wbs_flag = 'Y' THEN
1867:
1868: Pji_Pjp_Sum_Rollup.rollup_acr_wbs;
1869: print_time(' Did AC lines rollup. ');
1870:
1871: Pji_Pjp_Sum_Rollup.update_xbs_denorm;
1872: print_time(' Updated PJI xbs denorm. ');

Line 1871: Pji_Pjp_Sum_Rollup.update_xbs_denorm;

1867:
1868: Pji_Pjp_Sum_Rollup.rollup_acr_wbs;
1869: print_time(' Did AC lines rollup. ');
1870:
1871: Pji_Pjp_Sum_Rollup.update_xbs_denorm;
1872: print_time(' Updated PJI xbs denorm. ');
1873:
1874: Pji_Pjp_Sum_Denorm.cleanup_xbs_denorm(
1875: p_worker_id => 1