The following lines contain the word 'select', 'insert', 'update' or 'delete':
DELETE FROM JTF_FM_REQUESTS_AQ where AQ_MSG_ID = message_handle2;
PROCEDURE INSERT_JTF_FM_REQUEST_AQ
(p_request_id NUMBER,
p_aq_msg_id RAW,
p_queue_type VARCHAR2)
IS
BEGIN
INSERT INTO JTF_FM_REQUESTS_AQ (
REQUEST_ID, AQ_MSG_ID, QUEUE_TYPE,
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
VALUES ( p_request_id,p_aq_msg_id ,p_queue_type ,
FND_GLOBAL.USER_ID,SYSDATE ,FND_GLOBAL.USER_ID,
SYSDATE,FND_GLOBAL.LOGIN_ID );
END INSERT_JTF_FM_REQUEST_AQ;
SELECT outcome_code, SERVER_ID
FROM JTF_FM_REQUEST_HISTORY_ALL
WHERE HIST_REQ_ID = request_id;
SELECT BATCH_PAUSE_Q
FROM JTF_FM_SERVICE_ALL
WHERE SERVER_ID = server_id;
INSERT_JTF_FM_REQUEST_AQ(request_id,message_handle ,'BP');
INSERT_JTF_FM_REQUEST_AQ(request_id,message_handle ,'B');