APPS.WF_SETUP SQL Statements

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

Line: 9

  select substr(TEXT, 1, 32) into lguid
    from WF_RESOURCES
   where NAME = 'WF_SYSTEM_GUID'
     and LANGUAGE = userenv('LANG');

Line: 28

  select S.NAME into lsys
    from WF_SYSTEMS S, WF_RESOURCES R
   where R.NAME = 'WF_SYSTEM_GUID'
     and R.LANGUAGE = userenv('LANG')
     and S.GUID = hextoraw(R.TEXT);

Line: 44

    select NAME, VALUE
      from v$parameter
     where NAME in ('aq_tm_processes', 'job_queue_processes',
                    'job_queue_interval')
     order by NAME;

Line: 73

    dTab(i).selectable := FALSE;

Line: 110

    select distinct substr(ADDRESS, instr(ADDRESS, '@')+1) NAME
      from WF_AGENTS
     where PROTOCOL = 'SQLNET'
       and DIRECTION = 'IN'
       and SYSTEM_GUID <> localsguid;

Line: 130

      select 'EXIST' into dTab(i).col02
        from sys.dual
       where upper(dblr.name) in (
           select DB_LINK from USER_DB_LINKS
           union all
           select DB_LINK from ALL_DB_LINKS
            where OWNER = 'PUBLIC');

Line: 146

    dTab(i).selectable := FALSE;

Line: 180

    select A.GUID, A.NAME, A.DIRECTION, A.QUEUE_NAME
      from WF_AGENTS A
     where A.SYSTEM_GUID = localsguid
       and A.PROTOCOL = 'SQLNET';

Line: 210

      select DQ.QID
        into l_qid
        from ALL_QUEUES DQ
       where lquer.queue_name = DQ.OWNER||'.'||DQ.NAME
         and QUEUE_TYPE = 'NORMAL_QUEUE';

Line: 236

        select to_char(v.ready), to_char(v.waiting)
          into dTab(i).col05, dTab(i).col06
          from gv$aq v
         where v.qid = l_qid;

Line: 248

    dTab(i).selectable := FALSE;

Line: 298

    select A.GUID, A.NAME
      from WF_AGENTS A
     where A.SYSTEM_GUID = localsguid
       and A.PROTOCOL = 'SQLNET'
       and A.STATUS = 'ENABLED'
       and (A.DIRECTION is null or A.DIRECTION in ('IN', 'ANY'));

Line: 326

      select 'YES'
        into dTab(i).col02
        from WF_ALL_JOBS
       where upper(substr(WHAT, 1, 60))
             like 'WF_EVENT.LISTEN('''||lqr.name||''')%'
         and rownum < 2;

Line: 357

    dTab(i).selectable := FALSE;

Line: 396

    select OA.GUID OGUID,
           OA.NAME,
           OA.QUEUE_NAME OQUEUE,
           upper(substr(TA.ADDRESS, instr(TA.ADDRESS, '@')+1)) TOSYSTEM
      from WF_AGENTS OA, WF_AGENTS TA
     where OA.SYSTEM_GUID = localsguid
       and OA.PROTOCOL = 'SQLNET'
       and OA.DIRECTION = 'OUT'
       and TA.SYSTEM_GUID <> localsguid
       and TA.PROTOCOL = 'SQLNET'
       and TA.DIRECTION = 'IN'
       and TA.ADDRESS IS NOT NULL
       and TA.NAME <> 'WF_ERROR'
       and TA.SYSTEM_GUID in (select GUID from WF_SYSTEMS)
    union
    -- propgation to a local queue
    select A.GUID OGUID,
           A.NAME,
           A.QUEUE_NAME OQUEUE,
           NULL TOSYSTEM
      from WF_AGENTS A
     where A.SYSTEM_GUID = localsguid
       and A.PROTOCOL = 'SQLNET'
       and A.DIRECTION = 'OUT'
       order by TOSYSTEM;

Line: 440

      select NAME
        into dTab(i).col03
        from WF_AGENTS
       where GUID = ppgr.oguid
         and (PROTOCOL <> 'SQLNET'
           or (DIRECTION is not null and DIRECTION = 'IN'));

Line: 461

        select null
          into dTab(i).col03
          from sys.dual
         where exists (
           select NULL
             from DBA_QUEUE_SCHEDULES QS
            where QS.DESTINATION = nvl(ppgr.tosystem, 'AQ$_LOCAL')
              and QS.SCHEMA||'.'||QS.QNAME = ppgr.oqueue);

Line: 499

    dTab(i).selectable := FALSE;

Line: 646

    select SYSTEM_GUID, substr(QUEUE_NAME,1,30)
      into sguid, qname
      from WF_AGENTS
     where GUID = aguid;

Line: 709

    select JOB, WHAT, upper(INTERVAL) interval
      from WF_ALL_JOBS
     where upper(WHAT) like 'WF_EVENT.LISTEN('''||nm||''');';

Line: 765

    select NAME
      into aname
      from WF_AGENTS
     where GUID = l_aguid
       and SYSTEM_GUID = lguid;

Line: 782

    dTab(i).selectable := FALSE;

Line: 789

  hTab(i).value    := 'Wf_Setup.DeleteJob?h_url='||
                      wfa_html.base_url||'/Wf_Setup.List_Listener&h_job=';

Line: 908

    select NEXT_DATE, upper(INTERVAL) interval
      from WF_ALL_JOBS
     where job = x_jobnum;

Line: 932

    select NAME
      into aname
      from WF_AGENTS
     where GUID = aguid
       and SYSTEM_GUID = lguid;

Line: 1119

    select PROPAGATION_WINDOW, upper(NEXT_TIME) NEXT_TIME, LATENCY
      from DBA_QUEUE_SCHEDULES
     where DESTINATION = nvl(x_system, 'AQ$_LOCAL')
       and SCHEMA||'.'||QNAME = x_qname;

Line: 1294

         'javascript:document.WF_PPGN_EDIT.h_action.value=''DELETE'';'||

Line: 1296

         wf_core.translate ('DELETE'),
         wfa_html.image_loc,
         null,
         wf_core.translate ('DELETE'));

Line: 1419

        select name
        into l_name
        from wf_agents
        where name = upper(h_name);

Line: 1499

  if (h_action = 'DELETE') then
    Wf_Setup.DeletePropagation(h_qname, h_system);

Line: 1533

    Wf_Setup.DeletePropagation(h_qname, h_system);

Line: 1570

procedure DeleteJob(
  h_job pls_integer,
  h_url varchar2
) is
  username varchar2(320);   -- Username to query

Line: 1597

    wf_core.context('WF_SETUP', 'DeleteJob', h_job, h_url);

Line: 1599

end DeleteJob;

Line: 1604

procedure DeletePropagation(
  h_qname    in varchar2,
  h_system   in varchar2
)is
  username varchar2(320);   -- Username to query

Line: 1631

    wf_core.context('WF_SETUP', 'DeletePropagation', h_qname, h_system);

Line: 1633

end DeletePropagation;

Line: 1650

    select NEXT_DATE into nDate
      from WF_ALL_JOBS
     where job = jobnum;

Line: 1698

  Wf_Setup.DeletePropagation(h_qname, h_system);