APPS.WSH_OTM_HTTP_UTL SQL Statements

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

Line: 415

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

Line: 417

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

Line: 431

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

Line: 433

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

Line: 464

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

Line: 465

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

Line: 501

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

Line: 512

  SELECT SYSDATE FROM DUAL;

Line: 555

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