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_PJP_SUM_ROLLUP dependencies on PJI_FM_PLAN_MAINT_PVT

Line 4648: Pji_Fm_Plan_Maint_Pvt.OBTAIN_RELEASE_LOCKS (

4644: -- SELECT DECODE(l_extraction_type, 'PARTIAL', 'PLANTYPE', l_extraction_type)
4645: -- INTO l_extraction_type
4646: -- FROM DUAL ;
4647:
4648: Pji_Fm_Plan_Maint_Pvt.OBTAIN_RELEASE_LOCKS (
4649: p_context => l_extraction_type
4650: , p_lock_mode => 'P'
4651: , x_return_status => l_return_status
4652: , x_msg_code => l_msg_code

Line 10315: -- PJI_FM_PLAN_MAINT_PVT.PULL_DANGLING_PLANS; -- Removing redundant api nesting.

10311: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
10312:
10313: IF (l_extraction_type = 'INCREMENTAL') THEN
10314: Pji_Fm_Plan_Maint.CREATE_SECONDARY_PVT;
10315: -- PJI_FM_PLAN_MAINT_PVT.PULL_DANGLING_PLANS; -- Removing redundant api nesting.
10316: END IF;
10317:
10318: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);');
10319:

Line 18188: PJI_FM_PLAN_MAINT_PVT.GET_FP_ROW_IDS;

18184: end if;
18185:
18186: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
18187:
18188: PJI_FM_PLAN_MAINT_PVT.GET_FP_ROW_IDS;
18189:
18190: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);');
18191:
18192: commit;

Line 18227: PJI_FM_PLAN_MAINT_PVT.UPDATE_FP_ROWS;

18223: end if;
18224:
18225: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
18226:
18227: PJI_FM_PLAN_MAINT_PVT.UPDATE_FP_ROWS;
18228:
18229: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);');
18230:
18231: commit;

Line 18266: PJI_FM_PLAN_MAINT_PVT.INSERT_FP_ROWS;

18262: end if;
18263:
18264: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
18265:
18266: PJI_FM_PLAN_MAINT_PVT.INSERT_FP_ROWS;
18267:
18268: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);');
18269:
18270: commit;

Line 18305: -- PJI_FM_PLAN_MAINT_PVT.CLEANUP_FP_RMAP_FPR;

18301: end if;
18302:
18303: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
18304:
18305: -- PJI_FM_PLAN_MAINT_PVT.CLEANUP_FP_RMAP_FPR;
18306:
18307: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);');
18308:
18309: commit;

Line 18346: PJI_FM_PLAN_MAINT_PVT.GET_AC_ROW_IDS;

18342: if (l_extraction_type = 'INCREMENTAL' or
18343: l_extraction_type = 'PARTIAL' or
18344: l_extraction_type = 'RBS') then
18345:
18346: PJI_FM_PLAN_MAINT_PVT.GET_AC_ROW_IDS;
18347:
18348: end if;
18349:
18350: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);');

Line 18389: PJI_FM_PLAN_MAINT_PVT.UPDATE_AC_ROWS;

18385: if (l_extraction_type = 'INCREMENTAL' or
18386: l_extraction_type = 'PARTIAL' or
18387: l_extraction_type = 'RBS') then
18388:
18389: PJI_FM_PLAN_MAINT_PVT.UPDATE_AC_ROWS;
18390:
18391: end if;
18392:
18393: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);');

Line 18430: PJI_FM_PLAN_MAINT_PVT.INSERT_INTO_AC_FACT;

18426: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
18427:
18428: if (l_extraction_type = 'FULL') then
18429:
18430: PJI_FM_PLAN_MAINT_PVT.INSERT_INTO_AC_FACT;
18431:
18432: elsif (l_extraction_type = 'INCREMENTAL' or
18433: l_extraction_type = 'PARTIAL' or
18434: l_extraction_type = 'RBS') then

Line 18436: PJI_FM_PLAN_MAINT_PVT.INSERT_AC_ROWS;

18432: elsif (l_extraction_type = 'INCREMENTAL' or
18433: l_extraction_type = 'PARTIAL' or
18434: l_extraction_type = 'RBS') then
18435:
18436: PJI_FM_PLAN_MAINT_PVT.INSERT_AC_ROWS;
18437:
18438: end if;
18439:
18440: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);');

Line 18479: -- PJI_FM_PLAN_MAINT_PVT.CLEANUP_AC_RMAP_FPR;

18475: -- if (l_extraction_type = 'INCREMENTAL' or
18476: -- l_extraction_type = 'PARTIAL' or
18477: -- l_extraction_type = 'RBS') then
18478: --
18479: -- PJI_FM_PLAN_MAINT_PVT.CLEANUP_AC_RMAP_FPR;
18480: --
18481: -- end if;
18482:
18483: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);');

Line 19394: PJI_FM_PLAN_MAINT_PVT.PROCESS_PENDING_PLAN_UPDATES(l_extraction_type,

19390: end if;
19391:
19392: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
19393:
19394: PJI_FM_PLAN_MAINT_PVT.PROCESS_PENDING_PLAN_UPDATES(l_extraction_type,
19395: l_return_status,
19396: l_msg_data);
19397:
19398: /* Added for bug 13897252 starts */

Line 19717: Pji_Fm_Plan_Maint_Pvt.OBTAIN_RELEASE_LOCKS (

19713: -- SELECT DECODE(l_extraction_type, 'PARTIAL', 'PLANTYPE', l_extraction_type)
19714: -- INTO l_extraction_type
19715: -- FROM DUAL ;
19716:
19717: Pji_Fm_Plan_Maint_Pvt.OBTAIN_RELEASE_LOCKS (
19718: p_context => l_extraction_type
19719: , p_lock_mode => NULL
19720: , x_return_status => l_return_status
19721: , x_msg_code => l_msg_code

Line 19724: PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => l_return_status );

19720: , x_return_status => l_return_status
19721: , x_msg_code => l_msg_code
19722: );
19723:
19724: PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => l_return_status );
19725:
19726: -- Pji_Fm_Plan_Maint_Pvt.MARK_EXTRACTED_PLANS('SEC');
19727: -- Back to CREATE_SECONDARY_PVT due to issue 5155692
19728:

Line 19726: -- Pji_Fm_Plan_Maint_Pvt.MARK_EXTRACTED_PLANS('SEC');

19722: );
19723:
19724: PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => l_return_status );
19725:
19726: -- Pji_Fm_Plan_Maint_Pvt.MARK_EXTRACTED_PLANS('SEC');
19727: -- Back to CREATE_SECONDARY_PVT due to issue 5155692
19728:
19729: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);');
19730:

Line 19764: PJI_FM_PLAN_MAINT_PVT.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'PRI');

19760: end if;
19761:
19762: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
19763:
19764: PJI_FM_PLAN_MAINT_PVT.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'PRI');
19765:
19766: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.EXTRACT_FIN_PLAN_VERS_BULK(p_worker_id);');
19767:
19768: commit;

Line 19801: PJI_FM_PLAN_MAINT_PVT.POPULATE_WBS_HDR;

19797: end if;
19798:
19799: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
19800:
19801: PJI_FM_PLAN_MAINT_PVT.POPULATE_WBS_HDR;
19802:
19803: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.POPULATE_WBS_HDR(p_worker_id);');
19804:
19805: commit;

Line 19838: -- PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR;

19834: end if;
19835:
19836: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
19837:
19838: -- PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR;
19839: PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR(p_worker_id);
19840:
19841: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);');
19842:

Line 19839: PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR(p_worker_id);

19835:
19836: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
19837:
19838: -- PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR;
19839: PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR(p_worker_id);
19840:
19841: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);');
19842:
19843: commit;

Line 19876: PJI_FM_PLAN_MAINT_PVT.POPULATE_RBS_HDR;

19872: end if;
19873:
19874: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
19875:
19876: PJI_FM_PLAN_MAINT_PVT.POPULATE_RBS_HDR;
19877:
19878: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.POPULATE_RBS_HDR(p_worker_id);');
19879:
19880: commit;

Line 19913: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMOUNTS_PRIRBS;

19909: end if;
19910:
19911: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
19912:
19913: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMOUNTS_PRIRBS;
19914:
19915: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_AMOUNTS_PRIRBS(p_worker_id);');
19916:
19917: commit;

Line 19950: PJI_FM_PLAN_MAINT_PVT.ROLLUP_FPR_RBS_T_SLICE;

19946: end if;
19947:
19948: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
19949:
19950: PJI_FM_PLAN_MAINT_PVT.ROLLUP_FPR_RBS_T_SLICE;
19951:
19952: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_T_SLICE(p_worker_id);');
19953:
19954: commit;

Line 20100: PJI_FM_PLAN_MAINT_PVT.INSERT_INTO_FP_FACT;

20096: end if;
20097:
20098: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
20099:
20100: PJI_FM_PLAN_MAINT_PVT.INSERT_INTO_FP_FACT;
20101:
20102: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.INSERT_INTO_FP_FACT(p_worker_id);');
20103:
20104: commit;

Line 20137: PJI_FM_PLAN_MAINT_PVT.MARK_EXTRACTED_PLANS('PRI');

20133: end if;
20134:
20135: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
20136:
20137: PJI_FM_PLAN_MAINT_PVT.MARK_EXTRACTED_PLANS('PRI');
20138:
20139: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PLANS(p_worker_id);');
20140:
20141: commit;

Line 20200: PJI_FM_PLAN_MAINT_PVT.RETRIEVE_OVERRIDDEN_WP_ETC;

20196: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
20197: -- Extraction type is not needed for this step.
20198: -- Retaining it to maintain coding style as well as for potential future use.
20199:
20200: PJI_FM_PLAN_MAINT_PVT.RETRIEVE_OVERRIDDEN_WP_ETC;
20201:
20202: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.RETRIEVE_OVERRIDDEN_WP_ETC(p_worker_id);');
20203:
20204: commit;

Line 20230: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_ETC_PRIRBS(p_slice_type => 'SEC');

20226: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
20227: -- Extraction type is not needed for this step.
20228: -- Retaining it to maintain coding style as well as for potential future use.
20229:
20230: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_ETC_PRIRBS(p_slice_type => 'SEC');
20231:
20232: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_ETC_PRIRBS(p_worker_id);');
20233:
20234: commit;

Line 20488: PJI_FM_PLAN_MAINT_PVT.MERGE_INTO_FP_FACTS;

20484: end if;
20485:
20486: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
20487:
20488: PJI_FM_PLAN_MAINT_PVT.MERGE_INTO_FP_FACTS;
20489:
20490: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACT(p_worker_id);');
20491:
20492: commit;