APPS.WF_EVENT SQL Statements

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

Line: 33

  select agt2.name as agt_name,
         agt2.queue_handler as queue_handler
  from   wf_agent_groups agp ,
         wf_agents agt1 ,
         wf_agents agt2 ,
         wf_systems sys
  where  agt1.name      =  agent_name
  and    agt1.type      = 'GROUP'
  and    agt1.status    = 'ENABLED'
  and    agt1.system_guid = sys.guid
  and    sys.name        = system_name
  and    agp.group_guid =  agt1.guid
  and    agp.member_guid = agt2.guid
  and    agt2.system_guid = sys.guid
  and    agt2.status      = 'ENABLED';

Line: 1942

  WF_EVENT.evt_param_index.DELETE;

Line: 2678

    wf_core.raise('WFE_SUB_DELETED');

Line: 2695

  select sys_context('USERENV', 'CURRENT_SCHEMA')
  into wf_event.account_name
  from sys.dual;

Line: 3159

      select aq.queue_type, aq.QUEUE_TABLE, trim(dequeue_enabled)
      into WF_EVENT.g_queueType, l_queue_table, WF_EVENT.pv_last_dequeue_enabled
      from   all_queues aq
      where  aq.owner = l_owner
      and    aq.name = l_name;

Line: 3165

      select aqt.recipients, aqt.message_grouping
      into   WF_EVENT.pv_last_recipients, WF_EVENT.g_message_grouping
      from   all_queue_tables aqt
      where  aqt.queue_table = l_queue_table
      and    aqt.owner = l_owner;

Line: 3217

     SELECT  name
     FROM    all_queues
     WHERE   name in ('WF_DEFERRED', 'WF_ERROR', 'WF_JAVA_DEFERRED','WF_JAVA_ERROR')
     AND     owner =schema
     AND   ((trim(enqueue_enabled) = 'NO') OR (trim(dequeue_enabled) = 'NO'));

Line: 3395

  select name into wf_event.local_system_name
  from wf_systems
  where guid = wf_event.local_system_guid;