APPS.JTF_FM_REQUEST_GRP dependencies on JTF_FM_SERVICE

Line 80: FROM JTF_FM_SERVICE_ALL

76: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
77:
78: SELECT DECODE(p_request_type,'M', MASS_REQUEST_Q, 'B' , BATCH_REQUEST_Q, 'MP', MASS_PAUSE_Q, BATCH_PAUSE_Q)
79: INTO l_queue_name
80: FROM JTF_FM_SERVICE_ALL
81: WHERE SERVer_ID = p_server_id;
82:
83: JTF_FM_UTL_V.PRINT_MESSAGE('END function GET_QUEU_NAME', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_QUEUE_NAME');
84:

Line 4590: FROM JTF_FM_SERVICE

4586: l_xml VARCHAR2(32767);
4587: --
4588: CURSOR CREQ IS
4589: SELECT REQUEST_QUEUE_NAME, RESPONSE_QUEUE_NAME
4590: FROM JTF_FM_SERVICE
4591: WHERE
4592: SERVER_ID = l_server_id;
4593:
4594: CURSOR GETREQUEST IS

Line 4999: FROM JTF_FM_SERVICE

4995: -- Get the request and response queue names
4996:
4997: SELECT DECODE(l_request_type,'M', MASS_REQUEST_Q, 'B',BATCH_REQUEST_Q,'T',BATCH_REQUEST_Q, REQUEST_QUEUE_NAME)
4998: INTO l_request_queue
4999: FROM JTF_FM_SERVICE
5000: WHERE
5001: SERVER_ID = l_server_id;
5002:
5003: JTF_FM_UTL_V.PRINT_MESSAGE('QUEUE is :' || l_request_queue,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

Line 5523: FROM JTF_FM_SERVICE

5519: -- Get the request and response queue names
5520:
5521: SELECT REQUEST_QUEUE_NAME
5522: INTO l_request_queue
5523: FROM JTF_FM_SERVICE
5524: WHERE
5525: SERVER_ID = l_server_id;
5526:
5527: JTF_FM_UTL_V.PRINT_MESSAGE('QUEUE is :' || l_request_queue,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

Line 6303: FROM JTF_FM_SERVICE_ALL

6299:
6300:
6301: SELECT DECODE(l_request_type,'M', MASS_REQUEST_Q, 'B',BATCH_REQUEST_Q,'T',BATCH_REQUEST_Q, REQUEST_QUEUE_NAME)
6302: INTO l_request_queue
6303: FROM JTF_FM_SERVICE_ALL
6304: WHERE
6305: SERVER_ID = l_server_id;
6306:
6307: JTF_FM_UTL_V.PRINT_MESSAGE('Queue found ' || l_request_queue,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);