APPS.WF_BES_CLEANUP SQL Statements

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

Line: 48

   update wf_bes_subscriber_pings
   set status = STATUS_RESPONDED,
       action_time = sysdate
   where ping_number = p_ping_number
   and queue_name = p_queue_name
   and subscriber_name = p_subscriber_name;

Line: 75

   insert into wf_bes_subscriber_pings
   (
      ping_number,
      ping_time,
      queue_name,
      subscriber_name,
      status,
      action_time
   )
   values
   (
      p_ping_number,
      p_ping_time,
      p_queue_name,
      p_subscriber_name,
      STATUS_PINGED,
      p_ping_time
   );

Line: 268

   update wf_bes_subscriber_pings
   set status = STATUS_REMOVED,
       action_time = sysdate
   where queue_name = p_queue_name
   and subscriber_name = p_subscriber_name
   and status = STATUS_PINGED;

Line: 287

      update wf_bes_subscriber_pings
      set status = STATUS_REMOVE_FAILED,
          action_time = sysdate
      where queue_name = p_queue_name
      and subscriber_name = p_subscriber_name
      and status = STATUS_PINGED;

Line: 319

    select queue_name
    INTO   l_queue_name
    from   wf_agents
    where  name = p_agent_name
    and    system_guid = WF_EVENT.local_system_guid;

Line: 337

      SELECT queue_table
      into l_queue_table
      from all_queues
      where owner = l_owner
      and   name  = l_name;

Line: 370

      select distinct queue_name, subscriber_name
      from wf_bes_subscriber_pings
      where ping_time < sysdate - G_MIN_WAIT_TIME
      and status = STATUS_PINGED;

Line: 387

   select max(ping_time)
   into l_last_ping_time
   from wf_bes_subscriber_pings;

Line: 408

         select queue_name
         into l_qualified_queue_name
         from wf_agents
         where name = 'WF_CONTROL'
         and system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));

Line: 459

         select wf_bes_ping_number_s.nextval
         into l_ping_number
         from dual;

Line: 488

      delete
      from wf_bes_subscriber_pings
      where ping_time < sysdate - G_MAX_RETENTION_TIME;