DBA Data[Home] [Help]

APPS.FND_OAM_BF_UTIL dependencies on FND_CONCURRENT_REQUESTS

Line 29: from fnd_concurrent_requests fcr

25: -- check if its concurrent request
26: select fnd_global.conc_request_id into v_conc_req_id from dual;
27: if v_conc_req_id > 0 then
28: select fcr.requested_by into v_userid
29: from fnd_concurrent_requests fcr
30: where fcr.request_id = v_conc_req_id;
31: else
32: select fnd_global.user_id into v_userid from dual;
33: if (v_userid < 0 or v_userid is null) then

Line 315: from fnd_concurrent_requests

311: -- count the errored requests for this component, within
312: -- last 24 hours
313: if comp.component_type = 'CONCURRENT_PROGRAM' then
314: select count(*) into v_err_requests
315: from fnd_concurrent_requests
316: where phase_code='C'
317: and status_code='E'
318: and concurrent_program_id = comp.component_id
319: and program_application_id = comp.component_appl_id

Line 323: from fnd_concurrent_requests

319: and program_application_id = comp.component_appl_id
320: and actual_completion_date > sysdate - 1;
321:
322: select count(*) into v_running_requests
323: from fnd_concurrent_requests
324: where phase_code = 'R'
325: and concurrent_program_id = comp.component_id
326: and program_application_id = comp.component_appl_id;
327: end if;