The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into fnd_concurrent_debug_info
(
session_id, user_id, login_id,
time, function, action, message,
resp_appl_id, responsibility_id,
security_group_id, transaction_id,
concurrent_queue_id, time_in_number,
source_type
)
select
userenv('SESSIONID'), fnd_global.user_id, fnd_global.login_id,
sysdate, function_name, action_name, substr(message_text, 1, 480),
fnd_global.resp_appl_id, fnd_global.resp_id,
fnd_global.security_group_id, P_REQUEST_ID, P_CONC_QUEUE_ID,
dbms_utility.get_time, s_type
from sys.dual;
select fou.oracle_id,
fou.oracle_username,
fou.encrypted_oracle_password
into oid,
ouname,
opass
from fnd_oracle_userid fou,
fnd_data_group_units fdu,
fnd_concurrent_queues fcq
where fcq.application_id = qapid
and fcq.concurrent_queue_id = qid
and fcq.processor_application_id = fdu.application_id
and fcq.data_group_id = fdu.data_group_id
and fdu.oracle_id = fou.oracle_id;
select max_processes,
running_processes,
target_node,
sleep_seconds,
diagnostic_level
into max_procs,
run_procs,
tnode,
slpsec,
mgrdbg
from fnd_concurrent_queues
where application_id = qapid
and concurrent_queue_id = qid;
select PROCESS_STATUS_CODE
into scode
from fnd_concurrent_processes
where CONCURRENT_PROCESS_ID = procid;