[Home] [Help]
221: /* Concurrent process log */
222: begin
223: select logfile_name, node_name
224: into fname, node
225: from fnd_concurrent_processes
226: where concurrent_process_id = id;
227: exception
228: when no_data_found then
229: fnd_message.set_name('FND', 'CONC-PROCESS MISSING');
241: /* ICM log */
242: begin
243: select logfile_name, node_name
244: into fname, node
245: from fnd_concurrent_processes
246: where (((id is not null)
247: and concurrent_process_id =
248: ( select max(p.concurrent_process_id)
249: from fnd_concurrent_processes p,
245: from fnd_concurrent_processes
246: where (((id is not null)
247: and concurrent_process_id =
248: ( select max(p.concurrent_process_id)
249: from fnd_concurrent_processes p,
250: fnd_concurrent_processes p2
251: where p.queue_application_id = 0
252: and p.concurrent_queue_id = 1
253: and p2.concurrent_process_id= id
246: where (((id is not null)
247: and concurrent_process_id =
248: ( select max(p.concurrent_process_id)
249: from fnd_concurrent_processes p,
250: fnd_concurrent_processes p2
251: where p.queue_application_id = 0
252: and p.concurrent_queue_id = 1
253: and p2.concurrent_process_id= id
254: and p.process_start_date <=
255: nvl(p2.process_start_date, sysdate) ) )
256: or
257: ((id is null) and concurrent_process_id =
258: ( select max(p.concurrent_process_id)
259: from fnd_concurrent_processes p
260: where p.queue_application_id = 0
261: and p.concurrent_queue_id = 1 ) ));
262: exception
263: when no_data_found then
441: begin
442: select p.logfile_name, p.node_name, r.controlling_manager,
443: p.concurrent_process_id
444: into fname, node, controlling_mgr, cpid
445: from fnd_concurrent_requests r, fnd_concurrent_processes p
446: where r.request_id = id
447: and r.controlling_manager = p.concurrent_process_id(+);
448: /* The outer join makes sure that we don't say that the request
449: row is missing, when the manager row is missing. We know that