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_CMT_EXTR dependencies on PJI_PROCESS_UTIL

Line 248: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

244: begin
245:
246: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
247:
248: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
249: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);')) then
250: return;
251: end if;
252:

Line 253: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

249: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);')) then
250: return;
251: end if;
252:
253: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
254: (PJI_FM_SUM_MAIN.g_process,
255: 'EXTRACT_COMMITMENTS');
256:
257: if (l_extract_commitments = 'N') then

Line 258: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

254: (PJI_FM_SUM_MAIN.g_process,
255: 'EXTRACT_COMMITMENTS');
256:
257: if (l_extract_commitments = 'N') then
258: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
259: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);');
260: commit;
261: return;
262: end if;

Line 264: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

260: commit;
261: return;
262: end if;
263:
264: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
265: (PJI_FM_SUM_MAIN.g_process, 'PROJECT_OPERATING_UNIT');
266:
267: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
268: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');

Line 267: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

263:
264: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
265: (PJI_FM_SUM_MAIN.g_process, 'PROJECT_OPERATING_UNIT');
266:
267: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
268: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');
269:
270: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
271: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT');

Line 270: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

266:
267: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
268: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');
269:
270: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
271: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT');
272:
273: if (l_from_project is null) then
274:

Line 284: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

280: l_from_project
281: from
282: PA_PROJECTS_ALL prj
283: where
284: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
285: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT_ID');
286:
287: exception when no_data_found then null;
288:

Line 304: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

300: l_to_project
301: from
302: PA_PROJECTS_ALL prj
303: where
304: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
305: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT_ID');
306:
307: exception when no_data_found then null;
308:

Line 417: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

413: from
414: PJI_FM_EXTR_DREVN -- overload of draft revenues table for cmt
415: );
416:
417: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
418: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);');
419:
420: commit;
421:

Line 451: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

447: begin
448:
449: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
450:
451: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
452: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);')) then
453: return;
454: end if;
455:

Line 456: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

452: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);')) then
453: return;
454: end if;
455:
456: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
457: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
458:
459: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
460: (PJI_FM_SUM_MAIN.g_process,

Line 459: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

455:
456: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
457: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
458:
459: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
460: (PJI_FM_SUM_MAIN.g_process,
461: 'EXTRACT_COMMITMENTS');
462:
463: if (l_extract_commitments = 'N') then

Line 478: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

474: commit;
475:
476: end loop;
477:
478: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
479: (l_process, 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);');
480:
481: commit;
482:

Line 601: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded

597: l_helper_batch_id := -1;
598:
599: else
600:
601: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded
602:
603: end if;
604:
605: end if;

Line 621: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

617: end loop;
618:
619: if (l_helper_batch_id <> -2) then
620:
621: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
622: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);');
623:
624: end if;
625:

Line 644: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

640: begin
641:
642: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
643:
644: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
645: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);')) then
646: return;
647: end if;
648:

Line 649: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

645: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);')) then
646: return;
647: end if;
648:
649: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
650: (PJI_FM_SUM_MAIN.g_process,
651: 'EXTRACT_COMMITMENTS');
652:
653: if (l_extract_commitments = 'N') then

Line 654: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

650: (PJI_FM_SUM_MAIN.g_process,
651: 'EXTRACT_COMMITMENTS');
652:
653: if (l_extract_commitments = 'N') then
654: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
655: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);');
656: commit;
657: return;
658: end if;

Line 662: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

658: end if;
659:
660: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
661:
662: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
663: 'PJI_FM_EXTR_DREVN',
664: 'NORMAL',
665: null);
666:

Line 667: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

663: 'PJI_FM_EXTR_DREVN',
664: 'NORMAL',
665: null);
666:
667: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
668: 'PJI_HELPER_BATCH_MAP',
669: 'NORMAL',
670: null);
671:

Line 672: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

668: 'PJI_HELPER_BATCH_MAP',
669: 'NORMAL',
670: null);
671:
672: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
673: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);');
674:
675: commit;
676:

Line 697: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

693: begin
694:
695: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
696:
697: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
698: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);')) then
699: return;
700: end if;
701:

Line 702: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

698: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);')) then
699: return;
700: end if;
701:
702: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
703: (PJI_FM_SUM_MAIN.g_process,
704: 'EXTRACT_COMMITMENTS');
705:
706: if (l_extract_commitments = 'N') then

Line 707: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

703: (PJI_FM_SUM_MAIN.g_process,
704: 'EXTRACT_COMMITMENTS');
705:
706: if (l_extract_commitments = 'N') then
707: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
708: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);');
709: commit;
710: return;
711: end if;

Line 714: l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process, 'TRANSITION');

710: return;
711: end if;
712:
713: pji_utils.write2log('Entering FIN_CMT_SUMMARY');
714: l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process, 'TRANSITION');
715:
716: if (l_transition_flag = 'Y') then
717: l_params_cost_flag := nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,'CONFIG_COST_FLAG'), 'N');
718: else -- l_transition is null or 'N'

Line 717: l_params_cost_flag := nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,'CONFIG_COST_FLAG'), 'N');

713: pji_utils.write2log('Entering FIN_CMT_SUMMARY');
714: l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process, 'TRANSITION');
715:
716: if (l_transition_flag = 'Y') then
717: l_params_cost_flag := nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,'CONFIG_COST_FLAG'), 'N');
718: else -- l_transition is null or 'N'
719: l_params_cost_flag := nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
720: end if;
721:

Line 1197: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

1193: tmp1.EXPENDITURE_TYPE = et.EXPENDITURE_TYPE;
1194:
1195: pji_utils.write2log('Leaving FIN_CMT_SUMMARY');
1196:
1197: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
1198: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);');
1199:
1200: commit;
1201: