163: END_DATE,
164: COMPLETION_TEXT
165: )
166: select
167: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
168: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
169: g_process || 1 PROCESS_NAME,
170: 'TRANSITION' RUN_TYPE,
171: null PARAMETERS,
164: COMPLETION_TEXT
165: )
166: select
167: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
168: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
169: g_process || 1 PROCESS_NAME,
170: 'TRANSITION' RUN_TYPE,
171: null PARAMETERS,
172: l_settings_proj_perf_flag CONFIG_PROJ_PERF_FLAG,
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',
206: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
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
235: PJI_FM_SUM_EXTR.WORKER_STATUS(x, 'RUNNING')) then
236: l_count := l_count + 1;
237: end if;
238: end loop;
250: 'Y');
251:
252: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
253: g_process,
254: FND_GLOBAL.CONC_REQUEST_ID);
255:
256: commit;
257:
258: -- The API call below checks if the table PJI_SYSTEM_PRC_STATUS
378: END_DATE,
379: COMPLETION_TEXT
380: )
381: select
382: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
383: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
384: g_process || 1 PROCESS_NAME,
385: l_extraction_type RUN_TYPE,
386: substr(p_run_mode || ', ' ||
379: COMPLETION_TEXT
380: )
381: select
382: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
383: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
384: g_process || 1 PROCESS_NAME,
385: l_extraction_type RUN_TYPE,
386: substr(p_run_mode || ', ' ||
387: p_extract_commitments || ', ' ||
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',
1605: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
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;
1628:
1629: PJI_PROCESS_UTIL.REFRESH_STEP_TABLE;