APPS.WSH_OTM_HTTP_UTL SQL Statements

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

Line: 409

    EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;

Line: 411

    EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;

Line: 425

    EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;

Line: 427

    EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;

Line: 458

      EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;

Line: 459

      EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;

Line: 495

  SELECT ticket, operation, argument, end_date
  FROM FND_HTTP_TICKETS
  WHERE operation = c_operation
  AND   argument  = c_argument;

Line: 506

  SELECT SYSDATE FROM DUAL;

Line: 549

        WSH_DEBUG_SV.log(l_module_name,'Ticket Exists but expired.Delete existing');