APPS.FND_HTTP_TICKET SQL Statements

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

Line: 37

        insert into FND_HTTP_TICKETS (TICKET, OPERATION, ARGUMENT,
                                      START_DATE, END_DATE)
             values (X_TICKET, P_OPERATION, P_ARGUMENT,
                     X_START_DATE, X_END_DATE);

Line: 73

    select TICKET, OLD_TICKET, END_DATE
      into X_TICKET, X_OLD_TICKET, X_END_DATE
      from FND_HTTP_SERVICE_TICKETS
     where SERVICE = P_SERVICE
       for update;

Line: 81

      update FND_HTTP_SERVICE_TICKETS
         set TICKET = X_TICKET,
             OLD_TICKET = X_OLD_TICKET,
             END_DATE = SYSDATE + 1
       where SERVICE = P_SERVICE;

Line: 103

    select TICKET, OLD_TICKET, END_DATE
      into X_TICKET, X_OLD_TICKET, X_END_DATE
      from FND_HTTP_SERVICE_TICKETS where SERVICE = P_SERVICE;

Line: 179

    select OPERATION, ARGUMENT, END_DATE
      into P_OPERATION, P_ARGUMENT, X_END_DATE
      from FND_HTTP_TICKETS
     where TICKET = P_TICKET;

Line: 217

  function UPDATE_TICKET(P_TICKET    in raw,
                         P_OPERATION in varchar2,
                         P_ARGUMENT  in varchar2)
    return boolean
  is
  pragma AUTONOMOUS_TRANSACTION;

Line: 225

    update FND_HTTP_TICKETS
       set OPERATION = P_OPERATION,
           ARGUMENT = P_ARGUMENT
     where TICKET = P_TICKET
    returning END_DATE into X_END_DATE;

Line: 241

  end UPDATE_TICKET;

Line: 243

  function UPDATE_TICKET_STRING(P_TICKET    in varchar2,
                                P_OPERATION in varchar2,
                                P_ARGUMENT  in varchar2)
    return boolean
  is
  begin
    return(UPDATE_TICKET(FND_CRYPTO.DECODE(P_TICKET, FND_CRYPTO.ENCODE_URL),
                         P_OPERATION, P_ARGUMENT));

Line: 251

  end UPDATE_TICKET_STRING;

Line: 262

    delete from FND_HTTP_TICKETS
          where TICKET = P_TICKET
      returning TICKET, OPERATION, ARGUMENT, END_DATE
           into X_TICKET, P_OPERATION, P_ARGUMENT, X_END_DATE;

Line: 296

    delete from FND_HTTP_TICKETS where TICKET = P_TICKET;

Line: 313

      delete from FND_HTTP_TICKETS
       where SYSDATE > END_DATE
          or (SYSDATE - START_DATE) > (P_MAX_LIFESPAN/C_SECS_PER_DAY);

Line: 317

      delete from FND_HTTP_TICKETS where SYSDATE > END_DATE;