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

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 8298: l_err_msg VARCHAR2(100):= 'Error in PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS -> PJI_FM_PLAN_MAINT.POPULATE_FIN8';

8294: l_last_update_login number;
8295:
8296: l_return_status varchar2(255) := FND_API.G_RET_STS_SUCCESS;
8297: l_msg_data varchar2(2000);
8298: l_err_msg VARCHAR2(100):= 'Error in PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS -> PJI_FM_PLAN_MAINT.POPULATE_FIN8';
8299:
8300: begin
8301:
8302: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

Line 8402: PJI_FM_PLAN_MAINT.POPULATE_FIN8 (p_worker_id => p_worker_id,

8398: -- This change needs to be kept in mind when performing changes to sumz (adding
8399: -- new steps or changing sequences) programs in future.
8400: --
8401:
8402: PJI_FM_PLAN_MAINT.POPULATE_FIN8 (p_worker_id => p_worker_id,
8403: p_extraction_type => l_extraction_type,
8404: x_return_status => l_return_status,
8405: x_msg_data => l_msg_data);
8406:

Line 10314: Pji_Fm_Plan_Maint.CREATE_SECONDARY_PVT;

10310:
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);');

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 10364: PJI_FM_PLAN_MAINT.PULL_PLANS_FOR_PR(null,

10360: if (l_plan_type_id = -1) then
10361: l_plan_type_id := null;
10362: end if;
10363:
10364: PJI_FM_PLAN_MAINT.PULL_PLANS_FOR_PR(null,
10365: l_plan_type_id,
10366: 'PLANTYPE',
10367: l_return_status,
10368: l_msg_code);

Line 10416: PJI_FM_PLAN_MAINT.PULL_PLANS_FOR_PR(l_rbs_version_id,

10412:
10413: l_rbs_version_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
10414: (l_process, 'RBS_VERSION_ID');
10415:
10416: PJI_FM_PLAN_MAINT.PULL_PLANS_FOR_PR(l_rbs_version_id,
10417: null,
10418: 'RBS',
10419: l_return_status,
10420: l_msg_code);

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 19449: l_err_msg2 VARCHAR2(100):= 'Error in PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS -> PJI_FM_PLAN_MAINT.GET_ACTUALS_SUMM';

19445: l_ret_msg_data varchar2(2000);
19446: l_ret_status varchar2(255);
19447: l_success varchar2(1) := 'Y';
19448: l_err_msg1 VARCHAR2(100):= 'Error in PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS -> PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS';
19449: l_err_msg2 VARCHAR2(100):= 'Error in PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS -> PJI_FM_PLAN_MAINT.GET_ACTUALS_SUMM';
19450:
19451: begin
19452:
19453: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

Line 19550: PJI_FM_PLAN_MAINT.GET_ACTUALS_SUMM (

19546: WORKER_ID = p_worker_id and
19547: pji_project_status <> 'N';
19548:
19549:
19550: PJI_FM_PLAN_MAINT.GET_ACTUALS_SUMM (
19551: p_extr_type => l_extraction_type
19552: , x_return_status => l_return_status
19553: , x_msg_code => l_msg_data ) ;
19554:

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;