[Home] [Help]
56: into cpid,
57: node,
58: logf,
59: inst
60: from fnd_concurrent_processes
61: where concurrent_process_id in (
62: select max (concurrent_process_id)
63: from fnd_concurrent_processes
64: where queue_application_id = 0
59: inst
60: from fnd_concurrent_processes
61: where concurrent_process_id in (
62: select max (concurrent_process_id)
63: from fnd_concurrent_processes
64: where queue_application_id = 0
65: and concurrent_queue_id = 1
66: and process_status_code in ('A', 'M', 'K'));
67:
100: select concurrent_process_id,
101: (sysdate - last_update_date) * DAY
102: into cpid,
103: td
104: from fnd_concurrent_processes
105: where concurrent_process_id in (
106: select max (concurrent_process_id)
107: from fnd_concurrent_processes
108: where queue_application_id = apid
103: td
104: from fnd_concurrent_processes
105: where concurrent_process_id in (
106: select max (concurrent_process_id)
107: from fnd_concurrent_processes
108: where queue_application_id = apid
109: and concurrent_queue_id = qid
110: and process_status_code in (
111: psc1, psc2, psc3, psc4))
607: end if;
608:
609: if (result = 0) then -- Success
610: select 1 into dummy
611: from fnd_concurrent_processes
612: where concurrent_process_id = cpid
613: for update nowait;
614:
615: update fnd_concurrent_processes
611: from fnd_concurrent_processes
612: where concurrent_process_id = cpid
613: for update nowait;
614:
615: update fnd_concurrent_processes
616: set process_status_code = decode (process_status_code,
617: 'A', 'K',
618: 'M', 'S',
619: process_status_code)
689: select queue_application_id,
690: concurrent_queue_id,
691: concurrent_process_id,
692: rowid
693: from fnd_concurrent_processes
694: where manager_type between 1 and 5
695: and process_status_code in ('A', 'C')
696: order by concurrent_process_id;
697:
713: dbms_lock.allocate_unique (FNDCPLK ||
714: apid || '_' || qid || '_' || pid,
715: hndl, EON);
716:
717: update fnd_concurrent_processes
718: set lk_handle = hndl
719: where rowid = rid;
720:
721: end loop;