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

Line 28: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'TRANSITION') is not null) then

24: l_dangling_error varchar2(255) := 'Cannot run a configuration transition when dangling rows exist.';
25:
26: begin
27:
28: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'TRANSITION') is not null) then
29: return;
30: end if;
31:
32: select

Line 96: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process, 'TRANSITION', 'N');

92: commit;
93: dbms_standard.raise_application_error(-20040, l_setup_error);
94: end if;
95:
96: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process, 'TRANSITION', 'N');
97: l_transition_flag := 'N';
98:
99: if (l_settings_proj_perf_flag = 'Y' and l_params_proj_perf_flag = 'N') then
100: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 100: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

96: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process, 'TRANSITION', 'N');
97: l_transition_flag := 'N';
98:
99: if (l_settings_proj_perf_flag = 'Y' and l_params_proj_perf_flag = 'N') then
100: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
101: (g_process, 'TRANSITION', 'Y');
102: l_transition_flag := 'Y';
103: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
104: (g_process, 'CONFIG_PROJ_PERF_FLAG', 'Y');

Line 103: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

99: if (l_settings_proj_perf_flag = 'Y' and l_params_proj_perf_flag = 'N') then
100: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
101: (g_process, 'TRANSITION', 'Y');
102: l_transition_flag := 'Y';
103: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
104: (g_process, 'CONFIG_PROJ_PERF_FLAG', 'Y');
105: end if;
106:
107: if (l_settings_cost_flag = 'Y' and l_params_cost_flag = 'N') then

Line 108: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

104: (g_process, 'CONFIG_PROJ_PERF_FLAG', 'Y');
105: end if;
106:
107: if (l_settings_cost_flag = 'Y' and l_params_cost_flag = 'N') then
108: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
109: (g_process, 'TRANSITION', 'Y');
110: l_transition_flag := 'Y';
111: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
112: (g_process, 'CONFIG_COST_FLAG', 'Y');

Line 111: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

107: if (l_settings_cost_flag = 'Y' and l_params_cost_flag = 'N') then
108: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
109: (g_process, 'TRANSITION', 'Y');
110: l_transition_flag := 'Y';
111: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
112: (g_process, 'CONFIG_COST_FLAG', 'Y');
113: end if;
114:
115: if (l_settings_profit_flag = 'Y' and l_params_profit_flag = 'N') then

Line 116: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

112: (g_process, 'CONFIG_COST_FLAG', 'Y');
113: end if;
114:
115: if (l_settings_profit_flag = 'Y' and l_params_profit_flag = 'N') then
116: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
117: (g_process, 'TRANSITION', 'Y');
118: l_transition_flag := 'Y';
119: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
120: (g_process, 'CONFIG_PROFIT_FLAG', 'Y');

Line 119: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

115: if (l_settings_profit_flag = 'Y' and l_params_profit_flag = 'N') then
116: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
117: (g_process, 'TRANSITION', 'Y');
118: l_transition_flag := 'Y';
119: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
120: (g_process, 'CONFIG_PROFIT_FLAG', 'Y');
121: end if;
122:
123: if (l_settings_util_flag = 'Y' and l_params_util_flag = 'N') then

Line 124: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

120: (g_process, 'CONFIG_PROFIT_FLAG', 'Y');
121: end if;
122:
123: if (l_settings_util_flag = 'Y' and l_params_util_flag = 'N') then
124: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
125: (g_process, 'TRANSITION', 'Y');
126: l_transition_flag := 'Y';
127: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
128: (g_process, 'CONFIG_UTIL_FLAG', 'Y');

Line 127: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

123: if (l_settings_util_flag = 'Y' and l_params_util_flag = 'N') then
124: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
125: (g_process, 'TRANSITION', 'Y');
126: l_transition_flag := 'Y';
127: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
128: (g_process, 'CONFIG_UTIL_FLAG', 'Y');
129: end if;
130:
131: select count(*)

Line 141: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

137: from PJI_FM_DNGL_ACT;
138:
139: if (l_row_count > 0 and l_transition_flag = 'Y') then
140:
141: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
142: (g_process, 'TRANSITION', 'N');
143: l_transition_flag := 'N';
144:
145: PJI_UTILS.WRITE2LOG('Error: ' || l_dangling_error);

Line 202: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process) <>

198: begin
199:
200: l_count := 0;
201:
202: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process) <>
203: FND_GLOBAL.CONC_REQUEST_ID and
204: (PJI_PROCESS_UTIL.REQUEST_STATUS
205: (
206: 'RUNNING',

Line 204: (PJI_PROCESS_UTIL.REQUEST_STATUS

200: l_count := 0;
201:
202: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process) <>
203: FND_GLOBAL.CONC_REQUEST_ID and
204: (PJI_PROCESS_UTIL.REQUEST_STATUS
205: (
206: 'RUNNING',
207: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
208: g_full_disp_name

Line 207: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),

203: FND_GLOBAL.CONC_REQUEST_ID and
204: (PJI_PROCESS_UTIL.REQUEST_STATUS
205: (
206: 'RUNNING',
207: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
208: g_full_disp_name
209: ) or
210: PJI_PROCESS_UTIL.REQUEST_STATUS
211: (

Line 210: PJI_PROCESS_UTIL.REQUEST_STATUS

206: 'RUNNING',
207: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
208: g_full_disp_name
209: ) or
210: PJI_PROCESS_UTIL.REQUEST_STATUS
211: (
212: 'RUNNING',
213: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
214: g_incr_disp_name

Line 213: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),

209: ) or
210: PJI_PROCESS_UTIL.REQUEST_STATUS
211: (
212: 'RUNNING',
213: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
214: g_incr_disp_name
215: ) or
216: PJI_PROCESS_UTIL.REQUEST_STATUS
217: (

Line 216: PJI_PROCESS_UTIL.REQUEST_STATUS

212: 'RUNNING',
213: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
214: g_incr_disp_name
215: ) or
216: PJI_PROCESS_UTIL.REQUEST_STATUS
217: (
218: 'RUNNING',
219: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
220: g_prtl_disp_name

Line 219: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),

215: ) or
216: PJI_PROCESS_UTIL.REQUEST_STATUS
217: (
218: 'RUNNING',
219: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
220: g_prtl_disp_name
221: ))) then
222: l_count := l_count + 1;
223: end if;

Line 226: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PARALLEL_PROCESSES');

222: l_count := l_count + 1;
223: end if;
224:
225: l_parallel_processes :=
226: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PARALLEL_PROCESSES');
227:
228: if (l_parallel_processes is not null) then
229:
230: for x in 2 .. l_parallel_processes loop

Line 231: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

227:
228: if (l_parallel_processes is not null) then
229:
230: for x in 2 .. l_parallel_processes loop
231: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
232: (
233: g_process || to_char(x),
234: g_process || to_char(x)
235: ) < FND_GLOBAL.CONC_REQUEST_ID and

Line 249: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

245: commit;
246: dbms_standard.raise_application_error(-20010, l_sum_fm_running);
247: end if;
248:
249: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
250: 'PROCESS_RUNNING',
251: 'Y');
252:
253: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 253: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

249: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
250: 'PROCESS_RUNNING',
251: 'Y');
252:
253: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
254: g_process,
255: FND_GLOBAL.CONC_REQUEST_ID);
256:
257: commit;

Line 263: return PJI_PROCESS_UTIL.PRIOR_ITERATION_SUCCESSFUL(g_process);

259: -- The API call below checks if the table PJI_SYSTEM_PRC_STATUS
260: -- has any records for this process. If any records exist, the prior
261: -- process did not complete successfully.
262:
263: return PJI_PROCESS_UTIL.PRIOR_ITERATION_SUCCESSFUL(g_process);
264:
265: end PRIOR_ITERATION_SUCCESSFUL;
266:
267:

Line 349: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,

345: l_extraction_type := 'PARTIAL';
346: end if;
347:
348: l_transition_flag :=
349: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,
350: 'TRANSITION');
351:
352: if (l_project_count = 0 or l_transition_flag = 'Y') then
353: l_extraction_type := 'FULL';

Line 358: PJI_PROCESS_UTIL.ADD_STEPS(g_process || 1, 'PJI_EXTR', l_extraction_type);

354: elsif (l_project_count > 0 and l_extraction_type = 'FULL') then
355: l_extraction_type := 'INCREMENTAL';
356: end if;
357:
358: PJI_PROCESS_UTIL.ADD_STEPS(g_process || 1, 'PJI_EXTR', l_extraction_type);
359:
360: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_FM_SUM_MAIN.INIT_PROCESS;')) then
361: rollback;
362: return;

Line 360: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_FM_SUM_MAIN.INIT_PROCESS;')) then

356: end if;
357:
358: PJI_PROCESS_UTIL.ADD_STEPS(g_process || 1, 'PJI_EXTR', l_extraction_type);
359:
360: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_FM_SUM_MAIN.INIT_PROCESS;')) then
361: rollback;
362: return;
363: end if;
364:

Line 684: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

680: l_global_start_date,
681: g_date_mask
682: ));
683:
684: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
685: 'EXTRACT_COMMITMENTS',
686: p_extract_commitments);
687:
688: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 688: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

684: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
685: 'EXTRACT_COMMITMENTS',
686: p_extract_commitments);
687:
688: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
689: 'ORGANIZATION_ID',
690: p_organization_id);
691:
692: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 692: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

688: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
689: 'ORGANIZATION_ID',
690: p_organization_id);
691:
692: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
693: 'INCLUDE_SUB_ORG',
694: p_include_sub_org);
695:
696: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 696: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

692: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
693: 'INCLUDE_SUB_ORG',
694: p_include_sub_org);
695:
696: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
697: 'PROJECT_OPERATING_UNIT',
698: p_operating_unit);
699:
700: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 700: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

696: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
697: 'PROJECT_OPERATING_UNIT',
698: p_operating_unit);
699:
700: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
701: 'FROM_PROJECT',
702: p_from_project);
703:
704: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 704: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

700: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
701: 'FROM_PROJECT',
702: p_from_project);
703:
704: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
705: 'FROM_PROJECT_ID',
706: p_from_project_id);
707:
708: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 708: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

704: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
705: 'FROM_PROJECT_ID',
706: p_from_project_id);
707:
708: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
709: 'TO_PROJECT',
710: p_to_project);
711:
712: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 712: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

708: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
709: 'TO_PROJECT',
710: p_to_project);
711:
712: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
713: 'TO_PROJECT_ID',
714: p_to_project_id);
715:
716: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 716: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

712: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
713: 'TO_PROJECT_ID',
714: p_to_project_id);
715:
716: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
717: 'PLAN_TYPE_ID',
718: p_plan_type);
719:
720: if (p_cmt_operating_unit is not null or

Line 724: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

720: if (p_cmt_operating_unit is not null or
721: p_cmt_from_project is not null or
722: p_cmt_to_project is not null) then
723:
724: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
725: 'PROJECT_OPERATING_UNIT',
726: p_cmt_operating_unit);
727:
728: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 728: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

724: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
725: 'PROJECT_OPERATING_UNIT',
726: p_cmt_operating_unit);
727:
728: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
729: 'FROM_PROJECT',
730: p_cmt_from_project);
731:
732: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 732: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

728: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
729: 'FROM_PROJECT',
730: p_cmt_from_project);
731:
732: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
733: 'TO_PROJECT',
734: p_cmt_to_project);
735:
736: end if;

Line 740: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

736: end if;
737:
738: g_parallel_processes := PJI_EXTRACTION_UTIL.GET_PARALLEL_PROCESSES;
739:
740: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
741: 'PARALLEL_PROCESSES',
742: g_parallel_processes);
743:
744: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'N') then

Line 745: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

741: 'PARALLEL_PROCESSES',
742: g_parallel_processes);
743:
744: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'N') then
745: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
746: 'PA_CALENDAR_FLAG',
747: 'N');
748: else
749: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 749: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

745: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
746: 'PA_CALENDAR_FLAG',
747: 'N');
748: else
749: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
750: 'PA_CALENDAR_FLAG',
751: 'Y');
752: end if;
753:

Line 755: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

751: 'Y');
752: end if;
753:
754: if (PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG') = 'N') then
755: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
756: 'GL_CALENDAR_FLAG',
757: 'N');
758: else
759: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 759: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

755: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
756: 'GL_CALENDAR_FLAG',
757: 'N');
758: else
759: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
760: 'GL_CALENDAR_FLAG',
761: 'Y');
762: end if;
763:

Line 764: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_FM_SUM_MAIN.INIT_PROCESS;');

760: 'GL_CALENDAR_FLAG',
761: 'Y');
762: end if;
763:
764: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_FM_SUM_MAIN.INIT_PROCESS;');
765:
766: commit;
767:
768: end INIT_PROCESS;

Line 785: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') <> 'Y' and

781:
782: -- if process is determined to be over or any worker has failed then signal
783: -- that workers should stop processing and wrapup
784:
785: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') <> 'Y' and
786: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') <> 'N') then
787: return false;
788: end if;
789:

Line 786: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') <> 'N') then

782: -- if process is determined to be over or any worker has failed then signal
783: -- that workers should stop processing and wrapup
784:
785: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') <> 'Y' and
786: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') <> 'N') then
787: return false;
788: end if;
789:
790: l_parallel_processes :=

Line 791: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PARALLEL_PROCESSES');

787: return false;
788: end if;
789:
790: l_parallel_processes :=
791: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PARALLEL_PROCESSES');
792:
793: if (p_wait = 'WAIT') then
794: l_from_process := 2;
795: elsif (p_wait = 'DO_NOT_WAIT') then

Line 808: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

804: end if;
805: end loop;
806:
807: if (l_batch_count > 0) then
808: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
809: 'PROCESS_RUNNING',
810: 'F');
811: commit;
812: return false;

Line 819: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

815: if (p_wait = 'DO_NOT_WAIT') then
816: return true;
817: end if;
818:
819: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
820: 'PROCESS_RUNNING',
821: 'N');
822: commit;
823:

Line 844: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_FM_SUM_MAIN.RUN_PROCESS;')) then

840: l_parallel_processes number;
841:
842: begin
843:
844: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_FM_SUM_MAIN.RUN_PROCESS;')) then
845: return;
846: end if;
847:
848: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

Line 848: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

844: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(g_process || 1, 'PJI_FM_SUM_MAIN.RUN_PROCESS;')) then
845: return;
846: end if;
847:
848: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
849: 'PROCESS_RUNNING',
850: 'Y');
851:
852: -- ensure that worker and helpers can run concurrently

Line 857: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PARALLEL_PROCESSES');

853: FND_PROFILE.PUT('CONC_SINGLE_THREAD', 'N');
854: commit;
855:
856: l_parallel_processes :=
857: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PARALLEL_PROCESSES');
858:
859: -- start extraction helpers
860:
861: for x in 2 .. l_parallel_processes loop

Line 872: PJI_PROCESS_UTIL.SLEEP(g_process_delay);

868:
869: -- sleep until process is complete
870:
871: while PROCESS_RUNNING('WAIT') loop
872: PJI_PROCESS_UTIL.SLEEP(g_process_delay);
873: end loop;
874:
875: -- process finished
876:

Line 877: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'N') then

873: end loop;
874:
875: -- process finished
876:
877: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'N') then
878:
879: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_FM_SUM_MAIN.RUN_PROCESS;');
880:
881: commit;

Line 879: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_FM_SUM_MAIN.RUN_PROCESS;');

875: -- process finished
876:
877: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'N') then
878:
879: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(g_process || 1, 'PJI_FM_SUM_MAIN.RUN_PROCESS;');
880:
881: commit;
882:
883: end if;

Line 1406: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,

1402: l_params_util_flag varchar2(1);
1403:
1404: begin
1405:
1406: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1407: 'TRANSITION') = 'Y') then
1408:
1409: l_params_proj_perf_flag :=
1410: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,

Line 1410: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,

1406: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1407: 'TRANSITION') = 'Y') then
1408:
1409: l_params_proj_perf_flag :=
1410: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1411: 'CONFIG_PROJ_PERF_FLAG'), 'N');
1412: l_params_cost_flag :=
1413: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1414: 'CONFIG_COST_FLAG'), 'N');

Line 1413: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,

1409: l_params_proj_perf_flag :=
1410: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1411: 'CONFIG_PROJ_PERF_FLAG'), 'N');
1412: l_params_cost_flag :=
1413: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1414: 'CONFIG_COST_FLAG'), 'N');
1415: l_params_profit_flag :=
1416: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1417: 'CONFIG_PROFIT_FLAG'), 'N');

Line 1416: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,

1412: l_params_cost_flag :=
1413: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1414: 'CONFIG_COST_FLAG'), 'N');
1415: l_params_profit_flag :=
1416: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1417: 'CONFIG_PROFIT_FLAG'), 'N');
1418: l_params_util_flag :=
1419: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1420: 'CONFIG_UTIL_FLAG'), 'N');

Line 1419: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,

1415: l_params_profit_flag :=
1416: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1417: 'CONFIG_PROFIT_FLAG'), 'N');
1418: l_params_util_flag :=
1419: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1420: 'CONFIG_UTIL_FLAG'), 'N');
1421:
1422: if (l_params_proj_perf_flag = 'Y') then
1423: PJI_UTILS.SET_PARAMETER('CONFIG_PROJ_PERF_FLAG', 'Y');

Line 1467: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PARALLEL_PROCESSES');

1463:
1464: -- check that all workers have stopped
1465:
1466: l_parallel_processes :=
1467: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PARALLEL_PROCESSES');
1468:
1469: for x in 2 .. l_parallel_processes loop
1470: PJI_FM_SUM_EXTR.WAIT_FOR_WORKER(x);
1471: end loop;

Line 1473: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'A') then

1469: for x in 2 .. l_parallel_processes loop
1470: PJI_FM_SUM_EXTR.WAIT_FOR_WORKER(x);
1471: end loop;
1472:
1473: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'A') then
1474: fnd_message.set_name('PJI', 'PJI_SUM_ABORT');
1475: dbms_standard.raise_application_error(-20000, fnd_message.get);
1476: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1477: fnd_message.set_name('PJI', 'PJI_SUM_FAIL');

Line 1476: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then

1472:
1473: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'A') then
1474: fnd_message.set_name('PJI', 'PJI_SUM_ABORT');
1475: dbms_standard.raise_application_error(-20000, fnd_message.get);
1476: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1477: fnd_message.set_name('PJI', 'PJI_SUM_FAIL');
1478: dbms_standard.raise_application_error(-20000, fnd_message.get);
1479: end if;
1480:

Line 1485: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

1481: DANGLING_REPORT;
1482:
1483: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1484:
1485: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1486: 'PJI_FM_PROJ_BATCH_MAP',
1487: 'NORMAL',
1488: null);
1489:

Line 1492: PJI_PROCESS_UTIL.WRAPUP_PROCESS(g_process || 1);

1488: null);
1489:
1490: WRAPUP_SETUP;
1491:
1492: PJI_PROCESS_UTIL.WRAPUP_PROCESS(g_process || 1);
1493: PJI_PROCESS_UTIL.WRAPUP_PROCESS(g_process);
1494:
1495: update PJI_SYSTEM_CONFIG_HIST
1496: set END_DATE = sysdate,

Line 1493: PJI_PROCESS_UTIL.WRAPUP_PROCESS(g_process);

1489:
1490: WRAPUP_SETUP;
1491:
1492: PJI_PROCESS_UTIL.WRAPUP_PROCESS(g_process || 1);
1493: PJI_PROCESS_UTIL.WRAPUP_PROCESS(g_process);
1494:
1495: update PJI_SYSTEM_CONFIG_HIST
1496: set END_DATE = sysdate,
1497: COMPLETION_TEXT = 'Normal completion'

Line 1525: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,

1521: begin
1522:
1523: rollback;
1524:
1525: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,
1526: 'PROCESS_RUNNING',
1527: 'F');
1528:
1529: commit;

Line 1601: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process) <>

1597: END IF; /* end 4893117*/
1598:
1599: PJI_FM_DEBUG.CONC_REQUEST_HOOK(g_process);
1600:
1601: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process) <>
1602: FND_GLOBAL.CONC_REQUEST_ID and
1603: (PJI_PROCESS_UTIL.REQUEST_STATUS
1604: (
1605: 'RUNNING',

Line 1603: (PJI_PROCESS_UTIL.REQUEST_STATUS

1599: PJI_FM_DEBUG.CONC_REQUEST_HOOK(g_process);
1600:
1601: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process) <>
1602: FND_GLOBAL.CONC_REQUEST_ID and
1603: (PJI_PROCESS_UTIL.REQUEST_STATUS
1604: (
1605: 'RUNNING',
1606: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
1607: g_full_disp_name

Line 1606: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),

1602: FND_GLOBAL.CONC_REQUEST_ID and
1603: (PJI_PROCESS_UTIL.REQUEST_STATUS
1604: (
1605: 'RUNNING',
1606: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
1607: g_full_disp_name
1608: ) or
1609: PJI_PROCESS_UTIL.REQUEST_STATUS
1610: (

Line 1609: PJI_PROCESS_UTIL.REQUEST_STATUS

1605: 'RUNNING',
1606: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
1607: g_full_disp_name
1608: ) or
1609: PJI_PROCESS_UTIL.REQUEST_STATUS
1610: (
1611: 'RUNNING',
1612: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
1613: g_incr_disp_name

Line 1612: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),

1608: ) or
1609: PJI_PROCESS_UTIL.REQUEST_STATUS
1610: (
1611: 'RUNNING',
1612: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
1613: g_incr_disp_name
1614: ))) then
1615: pji_utils.write2log('Error: Summarization is already running.');
1616: commit;

Line 1624: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

1620: commit;
1621: execute immediate 'alter session enable parallel query';
1622: execute immediate 'alter session enable parallel dml';
1623:
1624: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
1625: g_process,
1626: FND_GLOBAL.CONC_REQUEST_ID);
1627:
1628: commit;

Line 1630: PJI_PROCESS_UTIL.REFRESH_STEP_TABLE;

1626: FND_GLOBAL.CONC_REQUEST_ID);
1627:
1628: commit;
1629:
1630: PJI_PROCESS_UTIL.REFRESH_STEP_TABLE;
1631:
1632: -- determine if a transitional configuration is needed
1633: RUN_SETUP;
1634:

Line 1635: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1631:
1632: -- determine if a transitional configuration is needed
1633: RUN_SETUP;
1634:
1635: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1636: (g_process, 'TRANSITION') = 'N' and
1637: (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1638: (g_process, 'CONFIG_PROJ_PERF_FLAG') = 'Y' or
1639: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 1637: (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1633: RUN_SETUP;
1634:
1635: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1636: (g_process, 'TRANSITION') = 'N' and
1637: (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1638: (g_process, 'CONFIG_PROJ_PERF_FLAG') = 'Y' or
1639: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1640: (g_process, 'CONFIG_COST_FLAG') = 'Y' or
1641: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 1639: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1635: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1636: (g_process, 'TRANSITION') = 'N' and
1637: (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1638: (g_process, 'CONFIG_PROJ_PERF_FLAG') = 'Y' or
1639: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1640: (g_process, 'CONFIG_COST_FLAG') = 'Y' or
1641: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1642: (g_process, 'CONFIG_PROFIT_FLAG') = 'Y' or
1643: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 1641: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1637: (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1638: (g_process, 'CONFIG_PROJ_PERF_FLAG') = 'Y' or
1639: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1640: (g_process, 'CONFIG_COST_FLAG') = 'Y' or
1641: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1642: (g_process, 'CONFIG_PROFIT_FLAG') = 'Y' or
1643: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1644: (g_process, 'CONFIG_UTIL_FLAG') = 'Y')) then
1645: retcode := 1;

Line 1643: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1639: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1640: (g_process, 'CONFIG_COST_FLAG') = 'Y' or
1641: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1642: (g_process, 'CONFIG_PROFIT_FLAG') = 'Y' or
1643: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1644: (g_process, 'CONFIG_UTIL_FLAG') = 'Y')) then
1645: retcode := 1;
1646: else
1647: retcode := 0;