DBA Data[Home] [Help]

APPS.PJI_RM_SUM_MAIN dependencies on FND_GLOBAL

Line 198: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,

194: END_DATE,
195: COMPLETION_TEXT
196: )
197: select
198: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
199: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
200: g_process || 1 PROCESS_NAME,
201: 'TRANSITION' RUN_TYPE,
202: null PARAMETERS,

Line 199: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,

195: COMPLETION_TEXT
196: )
197: select
198: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
199: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
200: g_process || 1 PROCESS_NAME,
201: 'TRANSITION' RUN_TYPE,
202: null PARAMETERS,
203: l_settings_proj_perf_flag CONFIG_PROJ_PERF_FLAG,

Line 237: FND_GLOBAL.CONC_REQUEST_ID and

233:
234: l_count := 0;
235:
236: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process) <>
237: FND_GLOBAL.CONC_REQUEST_ID and
238: (PJI_PROCESS_UTIL.REQUEST_STATUS
239: (
240: 'RUNNING',
241: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),

Line 269: ) < FND_GLOBAL.CONC_REQUEST_ID and

265: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
266: (
267: g_process || to_char(x),
268: g_process || to_char(x)
269: ) < FND_GLOBAL.CONC_REQUEST_ID and
270: PJI_RM_SUM_EXTR.WORKER_STATUS(x, 'RUNNING')) then
271: l_count := l_count + 1;
272: end if;
273: end loop;

Line 289: FND_GLOBAL.CONC_REQUEST_ID);

285: 'Y');
286:
287: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
288: g_process,
289: FND_GLOBAL.CONC_REQUEST_ID);
290:
291: commit;
292:
293: -- API call below check if table PJI_SYSTEM_PRC_STATUS has any

Line 412: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,

408: END_DATE,
409: COMPLETION_TEXT
410: )
411: select
412: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
413: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
414: g_process || 1 PROCESS_NAME,
415: l_extraction_type RUN_TYPE,
416: substr(p_run_mode || ', ' ||

Line 413: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,

409: COMPLETION_TEXT
410: )
411: select
412: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
413: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
414: g_process || 1 PROCESS_NAME,
415: l_extraction_type RUN_TYPE,
416: substr(p_run_mode || ', ' ||
417: p_prtl_schedule || ', ' ||

Line 1565: FND_GLOBAL.CONC_REQUEST_ID and

1561: raise l_pji_not_licensed;
1562: end if;*/
1563:
1564: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process) <>
1565: FND_GLOBAL.CONC_REQUEST_ID and
1566: (PJI_PROCESS_UTIL.REQUEST_STATUS
1567: (
1568: 'RUNNING',
1569: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),

Line 1615: FND_GLOBAL.CONC_REQUEST_ID);

1611: execute immediate 'alter session enable parallel dml';
1612:
1613: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
1614: g_process,
1615: FND_GLOBAL.CONC_REQUEST_ID);
1616:
1617: commit;
1618:
1619: PJI_PROCESS_UTIL.REFRESH_STEP_TABLE;