APPS.WF_BES_CACHE SQL Statements

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

Line: 57

    SELECT name
    INTO   g_local_system_name
    FROM   wf_systems
    WHERE  guid = g_local_system_guid;

Line: 112

  if (g_LastCacheUpdate is null or p_date is null) then
    g_LastCacheUpdate := p_date;

Line: 136

                    '} Last cache time {'||to_char(g_LastCacheUpdate, g_date_mask)||'}');

Line: 139

  if (l_lastMetaUpload is not null and g_LastCacheUpdate is not null and
      l_lastMetaUpload > g_LastCacheUpdate) then
    return false;

Line: 217

  SELECT guid, name, type, status, generate_function,
         java_generate_func, licensed_flag
  FROM   wf_events
  WHERE  name = cp_event_name;

Line: 260

  select subscription_guid,
         system_guid,
         subscription_source_type,
         subscription_source_agent_guid,
         subscription_phase,
         subscription_rule_data,
         subscription_out_agent_guid,
         subscription_to_agent_guid,
         subscription_priority,
         subscription_rule_function,
         wf_process_type,
         wf_process_name,
         subscription_parameters,
         '',
         '',
         '',
         '',
         '',
         subscription_on_error_type,
         ''
  from wf_active_subscriptions_v
  where event_name in(cp_event_name, g_event_any)
  and   subscription_source_type = cp_source_type
  and   ((subscription_source_agent_guid is NOT NULL AND
          subscription_source_agent_guid = nvl(cp_source_agent_guid, subscription_source_agent_guid))
          OR subscription_source_agent_guid is NULL)
  and   system_guid = wf_bes_cache.g_local_system_guid
  order by 5;

Line: 293

  (select sub.guid                  sub_guid,
          sub.system_guid           sys_guid,
          sub.source_type           src_type,
          sub.source_agent_guid     src_agt,
          nvl(sub.phase,0)          phase,
          sub.rule_data             rule_data,
	  sub.out_agent_guid        out_agt,
          sub.to_agent_guid         to_agt,
          sub.priority              priority,
	  DECODE(sub.rule_function, NULL,
                 DECODE(sub.java_rule_func, NULL, NULL,
                        g_java_sub||sub.java_rule_func),
	         sub.rule_function) rule_func,
          sub.wf_process_type       proc_type,
          sub.wf_process_name       proc_name,
          sub.parameters            params,
          sub.expression            exp,
          sub.invocation_id         inv_id,
          sub.map_code              map_code,
          sub.standard_type         std_type,
          sub.standard_code         std_code,
          sub.on_error_code         on_error,
          sub.action_code           action
   from   wf_event_subscriptions sub,
          wf_events evt
   where  sub.system_guid   = wf_event.local_system_guid
   and    sub.status        = 'ENABLED'
   and    sub.licensed_flag = 'Y'
   and    sub.source_type   = cp_source_type
   and    ((sub.source_agent_guid is NOT NULL AND
           sub.source_agent_guid = nvl(cp_source_agent_guid, sub.source_agent_guid))
           OR sub.source_agent_guid is NULL)
   and    sub.event_filter_guid  = evt.guid
   and    evt.name          = cp_event_name
   and    evt.type          = 'EVENT'
   and    evt.status        = 'ENABLED'
   and    evt.licensed_flag = 'Y')
   order by 5;

Line: 702

  SELECT a.guid, a.name, a.system_guid, s.name, a.protocol, a.address,
         a.queue_handler, a.queue_name, a.direction, a.status,
         a.display_name, a.type, a.java_queue_handler
  FROM   wf_agents a, wf_systems s
  WHERE  a.name        = cp_agent_name
  AND    a.system_guid = s.guid
  AND    s.name        = cp_system_name;

Line: 711

  SELECT a.guid, a.name, a.system_guid, s.name, a.protocol, a.address,
         a.queue_handler, a.queue_name, a.direction, a.status,
         a.display_name, a.type, a.java_queue_handler
  FROM   wf_agents a, wf_systems s
  WHERE  a.guid = cp_agent_guid
  AND    s.guid = a.system_guid;

Line: 801

  SELECT a.guid, a.name, a.system_guid, s.name, a.protocol, a.address,
         a.queue_handler, a.queue_name, a.direction, a.status,
         a.display_name, a.type, a.java_queue_handler
  FROM   wf_agents  a, wf_systems s
  WHERE  a.system_guid   = wf_event.local_system_guid
  AND    a.system_guid   = s.guid
  AND    a.queue_handler = cp_agent_qh
  AND    a.direction     = cp_direction;