APPS.JTF_FM_AQ_WRAPPER_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 66

	DELETE FROM JTF_FM_REQUESTS_AQ where AQ_MSG_ID = message_handle2;

Line: 78

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  );

Line: 94

END INSERT_JTF_FM_REQUEST_AQ;

Line: 115

     SELECT outcome_code, SERVER_ID
     FROM JTF_FM_REQUEST_HISTORY_ALL
     WHERE HIST_REQ_ID = request_id;

Line: 122

     SELECT BATCH_PAUSE_Q
     FROM JTF_FM_SERVICE_ALL
     WHERE SERVER_ID = server_id;

Line: 154

	INSERT_JTF_FM_REQUEST_AQ(request_id,message_handle ,'BP');

Line: 168

	INSERT_JTF_FM_REQUEST_AQ(request_id,message_handle ,'B');