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_FM_SUM_MAIN

Line 246: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

242: l_batch_size number := 1;
243:
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;

Line 254: (PJI_FM_SUM_MAIN.g_process,

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
258: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

Line 265: (PJI_FM_SUM_MAIN.g_process, 'PROJECT_OPERATING_UNIT');

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

Line 268: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');

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

Line 271: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT');

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:
275: begin

Line 285: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT_ID');

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:
289: end;

Line 305: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT_ID');

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:
309: end;

Line 449: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

445: l_org_id number; -- bug 6847113
446:
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;

Line 457: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');

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,
461: 'EXTRACT_COMMITMENTS');

Line 460: (PJI_FM_SUM_MAIN.g_process,

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
464:

Line 469: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and

465: for x in 2 .. l_parallel_processes loop
466:
467: update PJI_SYSTEM_PRC_STATUS
468: set STEP_STATUS = 'C'
469: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
470: STEP_NAME =
471: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);' and
472: START_DATE is null;
473:

Line 588: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and

584: for x in 2 .. l_parallel_processes loop
585:
586: update PJI_SYSTEM_PRC_STATUS
587: set STEP_STATUS = 'C'
588: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
589: STEP_NAME =
590: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);' and
591: START_DATE is null;
592:

Line 642: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

638: l_schema varchar2(30);
639:
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;

Line 650: (PJI_FM_SUM_MAIN.g_process,

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
654: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

Line 695: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

691: l_g2_currency_code varchar2(30);
692:
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;

Line 703: (PJI_FM_SUM_MAIN.g_process,

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
707: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

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: