DBA Data[Home] [Help]

APPS.PJI_FM_SUM_MAIN dependencies on FND_GLOBAL

Line 167: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,

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,

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

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,

Line 202: FND_GLOBAL.CONC_REQUEST_ID and

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),

Line 234: ) < FND_GLOBAL.CONC_REQUEST_ID and

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;

Line 254: FND_GLOBAL.CONC_REQUEST_ID);

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

Line 382: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,

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 || ', ' ||

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

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 || ', ' ||

Line 1601: FND_GLOBAL.CONC_REQUEST_ID and

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),

Line 1625: FND_GLOBAL.CONC_REQUEST_ID);

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;