APPS.WF_EVENT SQL Statements

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

Line: 50

  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: 1999

  WF_EVENT.evt_param_index.DELETE;

Line: 2736

    wf_core.raise('WFE_SUB_DELETED');

Line: 2753

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

Line: 3221

      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: 3227

      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: 3279

     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: 3631

     select count(1)
     into l_count
     from fnd_concurrent_requests
     where concurrent_program_id in
                  (select concurrent_program_id
                  from fnd_concurrent_programs
                  where concurrent_program_name = 'FNDWFLIC')
     and phase_code = 'P' -- Pending
     and status_code = 'I' -- Normal
     and edition_name = ad_zd.get_edition
     and rownum < 2;

Line: 3653

           SELECT u.user_id
           INTO l_user_id
           FROM fnd_user u
           WHERE u.user_name = l_user_name;

Line: 3658

           SELECT r.application_id, r.responsibility_id
           INTO l_resp_appl_id, l_resp_id
           FROM fnd_application a, fnd_responsibility r
           WHERE r.application_id = a.application_id
           AND a.application_short_name = l_appl_short_name
           AND r.responsibility_key = l_resp_key;

Line: 3702

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