APPS.FND_CONC_REQUEST_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 247: from fnd_concurrent_requests

243:
244: begin
245: select status_code
246: into dummy
247: from fnd_concurrent_requests
248: where request_id = rid
249: and has_sub_request = 'Y'
250: and status_code = 'W'
251: for update of status_code;

Line 267: update fnd_concurrent_requests

263: uid in number)
264: return boolean is
265:
266: begin
267: update fnd_concurrent_requests
268: set status_code = 'I',
269: last_update_date = sysdate,
270: last_updated_by = uid
271: where request_id = prid

Line 275: from fnd_concurrent_requests

271: where request_id = prid
272: and has_sub_request = 'Y'
273: and status_code = 'W'
274: and not exists (select null
275: from fnd_concurrent_requests
276: where parent_request_id = prid
277: and request_id <> rid
278: and is_sub_request = 'Y'
279: and status_code between 'I' and 'T');

Line 289: update fnd_concurrent_requests

285: procedure delete_children (rid in number,
286: uid in number) is
287:
288: begin
289: update fnd_concurrent_requests
290: set phase_code = decode (status_code,
291: 'R', 'R',
292: 'C'),
293: status_code = decode (phase_code,

Line 301: from fnd_concurrent_requests

297: 'D'),
298: last_update_date = sysdate,
299: last_updated_by = uid
300: where request_id in (select request_id
301: from fnd_concurrent_requests
302: where phase_code <> 'C' and status_code <> 'T'
303: connect by prior request_id = parent_request_id
304: start with request_id = rid);
305: end delete_children;