[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))
648: end if;
649:
650: if (result = 0) then -- Success
651: select 1 into dummy
652: from fnd_concurrent_processes
653: where concurrent_process_id = cpid
654: for update nowait;
655:
656: update fnd_concurrent_processes
652: from fnd_concurrent_processes
653: where concurrent_process_id = cpid
654: for update nowait;
655:
656: update fnd_concurrent_processes
657: set process_status_code = decode (process_status_code,
658: 'A', 'K',
659: 'M', 'S',
660: process_status_code)
730: select queue_application_id,
731: concurrent_queue_id,
732: concurrent_process_id,
733: rowid
734: from fnd_concurrent_processes
735: where manager_type between 1 and 5
736: and process_status_code in ('A', 'C')
737: order by concurrent_process_id;
738:
754: dbms_lock.allocate_unique (FNDCPLK ||
755: apid || '_' || qid || '_' || pid,
756: hndl, EON);
757:
758: update fnd_concurrent_processes
759: set lk_handle = hndl
760: where rowid = rid;
761:
762: end loop;