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 95: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process, 'TRANSITION', 'N');

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

Line 99: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

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

Line 102: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

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

Line 107: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

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

Line 110: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

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

Line 115: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

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

Line 118: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

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

Line 123: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

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

Line 126: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

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

Line 140: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

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

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

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

Line 203: (PJI_PROCESS_UTIL.REQUEST_STATUS

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

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

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

Line 209: PJI_PROCESS_UTIL.REQUEST_STATUS

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

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

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

Line 215: PJI_PROCESS_UTIL.REQUEST_STATUS

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

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

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

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

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

Line 230: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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

Line 248: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 252: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 262: return PJI_PROCESS_UTIL.PRIOR_ITERATION_SUCCESSFUL(g_process);

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

Line 348: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,

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

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

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

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

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

Line 683: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 687: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 691: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 695: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 699: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 703: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 707: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 711: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 715: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 723: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 727: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 731: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 739: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 744: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 748: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 754: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 758: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

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

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

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

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

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

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

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

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

Line 807: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 818: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

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

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

Line 847: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

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

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

Line 871: PJI_PROCESS_UTIL.SLEEP(g_process_delay);

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

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

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

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

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

Line 1405: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,

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

Line 1409: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,

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

Line 1412: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,

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

Line 1415: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,

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

Line 1418: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,

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

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

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

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

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

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

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

Line 1484: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

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

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

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

Line 1492: PJI_PROCESS_UTIL.WRAPUP_PROCESS(g_process);

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

Line 1524: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,

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

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

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

Line 1602: (PJI_PROCESS_UTIL.REQUEST_STATUS

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

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

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

Line 1608: PJI_PROCESS_UTIL.REQUEST_STATUS

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

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

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

Line 1623: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,

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

Line 1629: PJI_PROCESS_UTIL.REFRESH_STEP_TABLE;

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

Line 1634: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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

Line 1636: (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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

Line 1638: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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

Line 1640: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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

Line 1642: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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