DBA Data[Home] [Help]

APPS.PJI_FM_CMT_EXTR dependencies on PJI_FM_SUM_MAIN

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

557: l_psi_ppr_flag varchar2(1); -- bug 13889383
558:
559: begin
560:
561: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
562:
563: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
564: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);')) then
565: return;

Line 569: (PJI_FM_SUM_MAIN.g_process,

565: return;
566: end if;
567:
568: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
569: (PJI_FM_SUM_MAIN.g_process,
570: 'EXTRACT_COMMITMENTS');
571:
572: select psi_ppr_flag into l_psi_ppr_flag from pji_system_settings; -- Added for bug 13889383
573:

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

578: return;
579: end if;
580:
581: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
582: (PJI_FM_SUM_MAIN.g_process, 'PROJECT_OPERATING_UNIT');
583:
584: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
585: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');
586:

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

581: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
582: (PJI_FM_SUM_MAIN.g_process, 'PROJECT_OPERATING_UNIT');
583:
584: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
585: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');
586:
587: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
588: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT');
589:

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

584: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
585: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');
586:
587: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
588: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT');
589:
590: if (l_from_project is null) then
591:
592: begin

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

598: from
599: PA_PROJECTS_ALL prj
600: where
601: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
602: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT_ID');
603:
604: exception when no_data_found then null;
605:
606: end;

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

618: from
619: PA_PROJECTS_ALL prj
620: where
621: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
622: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT_ID');
623:
624: exception when no_data_found then null;
625:
626: end;

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

763: l_psi_ppr_flag varchar2(1); -- bug 13889383
764:
765: begin
766:
767: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
768:
769: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
770: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);')) then
771: return;

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

771: return;
772: end if;
773:
774: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
775: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
776:
777: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
778: (PJI_FM_SUM_MAIN.g_process,
779: 'EXTRACT_COMMITMENTS');

Line 778: (PJI_FM_SUM_MAIN.g_process,

774: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
775: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
776:
777: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
778: (PJI_FM_SUM_MAIN.g_process,
779: 'EXTRACT_COMMITMENTS');
780:
781: select psi_ppr_flag into l_psi_ppr_flag from pji_system_settings; -- Added for bug 13889383
782:

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

785: for x in 2 .. l_parallel_processes loop
786:
787: update PJI_SYSTEM_PRC_STATUS
788: set STEP_STATUS = 'C'
789: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
790: STEP_NAME =
791: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);' and
792: START_DATE is null;
793:

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

962: for x in 2 .. l_parallel_processes loop
963:
964: update PJI_SYSTEM_PRC_STATUS
965: set STEP_STATUS = 'C'
966: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
967: STEP_NAME =
968: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);' and
969: START_DATE is null;
970:

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

1017: l_psi_ppr_flag varchar2(1); -- bug 13889383
1018:
1019: begin
1020:
1021: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1022:
1023: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
1024: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);')) then
1025: return;

Line 1029: (PJI_FM_SUM_MAIN.g_process,

1025: return;
1026: end if;
1027:
1028: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1029: (PJI_FM_SUM_MAIN.g_process,
1030: 'EXTRACT_COMMITMENTS');
1031:
1032: select psi_ppr_flag into l_psi_ppr_flag from pji_system_settings; -- Added for bug 13889383
1033:

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

1072: l_g2_currency_code varchar2(30);
1073:
1074: begin
1075:
1076: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1077:
1078: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
1079: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);')) then
1080: return;

Line 1084: (PJI_FM_SUM_MAIN.g_process,

1080: return;
1081: end if;
1082:
1083: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1084: (PJI_FM_SUM_MAIN.g_process,
1085: 'EXTRACT_COMMITMENTS');
1086:
1087: if (l_extract_commitments = 'N') then
1088: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

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

1091: return;
1092: end if;
1093:
1094: pji_utils.write2log('Entering FIN_CMT_SUMMARY');
1095: l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process, 'TRANSITION');
1096:
1097: if (l_transition_flag = 'Y') then
1098: l_params_cost_flag := nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,'CONFIG_COST_FLAG'), 'N');
1099: else -- l_transition is null or 'N'

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

1094: pji_utils.write2log('Entering FIN_CMT_SUMMARY');
1095: l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process, 'TRANSITION');
1096:
1097: if (l_transition_flag = 'Y') then
1098: l_params_cost_flag := nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,'CONFIG_COST_FLAG'), 'N');
1099: else -- l_transition is null or 'N'
1100: l_params_cost_flag := nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
1101: end if;
1102: