APPS.JTM_COMMON_CON_PROG_PUB SQL Statements

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

Line: 43

  SELECT INTERVAL_ID FROM JTM_CON_REQUEST_INTERVALS
  WHERE  INTERVAL <= CURRENT_ROUND;

Line: 47

  SELECT PACKAGE_NAME, PROCEDURE_NAME
  FROM JTM_CON_REQUEST_DATA req
  WHERE (req.INTERVAL_ID = x_interval_id
            AND   req.EXECUTE_FLAG = 'Y')
  OR
        (req.INTERVAL_ID = x_interval_id
            AND SYSDATE - req.LAST_RUN_DATE > x_interval/1440)
  ORDER BY PRODUCT_CODE, EXECUTION_ORDER;

Line: 85

   UPDATE JTM_CON_REQUEST_INTERVALS
   SET CURRENT_ROUND = CURRENT_ROUND + 1 ;

Line: 92

       SELECT INTERVAL INTO l_interval FROM jtm_con_request_intervals
       where INTERVAL_ID = r_interval.INTERVAL_ID;

Line: 114

	    UPDATE JTM_CON_REQUEST_INTERVALS
            SET CURRENT_ROUND = 0
            WHERE INTERVAL_ID = r_interval.INTERVAL_ID;

Line: 133

     	    UPDATE JTM_CON_REQUEST_DATA
 	    SET LAST_TXC_START = l_api_start,
 	    	LAST_TXC_END = l_api_end,
 		COMPLETION_TEXT = l_api_status
 	    WHERE PACKAGE_NAME = x_request.PACKAGE_NAME
 	    AND PROCEDURE_NAME = x_request.PROCEDURE_NAME;

Line: 144

   UPDATE JTM_CON_REQUEST_INTERVALS
   SET CURRENT_ROUND = 0
   WHERE CURRENT_ROUND >= INTERVAL;

Line: 154

         UPDATE JTM_CON_REQUEST_INTERVALS
         SET CURRENT_ROUND = 0
         WHERE CURRENT_ROUND >= INTERVAL;