APPS.WF_EVENT_SYNCHRONIZE_PKG SQL Statements

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

Line: 451

**			inserts objects into Event System
**			Parameters:	EventData
**
*/
procedure UPLOADSYNCCLOB (
 P_EVENTDATA		in	clob
) is

l_length_end_string	integer := 16;

Line: 547

select guid from wf_systems
where name like nvl(p_key,'%');

Line: 559

    l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.system.update', g.guid);

Line: 595

select guid from wf_agents
where name like nvl(p_key,'%')
and (xguid is null or system_guid=xguid);

Line: 626

    l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.agent.update', g.guid);

Line: 680

select g.name||'/'||a.name GUID
from   wf_agents g, wf_agents a,wf_agent_groups ag
where  g.guid=ag.group_guid
and    a.guid=ag.member_guid
and    (p_key is null or a.name like p_key);

Line: 686

/*select wag.group_guid||'/'||wag.member_guid GUID from wf_agent_groups wag
where exists
        (       select 'x'
                from wf_agents
                where guid = wag.member_guid
                and name like nvl(p_key,'%')
        );*/

Line: 703

    l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.agentgroup.update', g.guid);

Line: 737

select guid
from   wf_events
where  type = 'EVENT'
and    name like p_key
and    owner_tag like nvl(p_ownertag, '%');

Line: 744

select guid
from   wf_events
where  type = 'EVENT'
and    owner_tag like nvl(p_ownertag, '%');

Line: 758

      l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);

Line: 769

      l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);

Line: 800

select g.name||'/'||e.name names
from   wf_events g, wf_events e, wf_event_groups eg
where  g.guid = eg.group_guid
and    g.type = 'GROUP'
and    e.guid = eg.member_guid
and    e.name like p_key
and    e.owner_tag like nvl(p_ownertag, '%')
order by e.name;

Line: 810

select g.name||'/'||e.name names
from   wf_events g, wf_events e, wf_event_groups eg
where  g.guid = eg.group_guid
and    g.type = 'GROUP'
and    e.guid = eg.member_guid
and    e.owner_tag like nvl(p_ownertag, '%')
order by e.name;

Line: 827

      l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.group.update', g.names);

Line: 838

      l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.group.update', g.names);

Line: 869

select guid
from   wf_events
where  type = 'GROUP'
and    name like p_key
and    owner_tag like nvl(p_ownertag, '%');

Line: 876

select guid
from   wf_events
where  type = 'GROUP'
and    owner_tag like nvl(p_ownertag, '%');

Line: 890

      l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);

Line: 901

      l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);

Line: 927

select g.name||'/'||e.name names
from   wf_events g, wf_events e, wf_event_groups eg
where  g.guid = eg.group_guid
and    g.type = 'GROUP'
and    e.guid = eg.member_guid
and    (p_key is null or g.name like p_key )
and    (p_ownertag is null or g.owner_tag like p_ownertag)
order by g.name;

Line: 945

    l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.group.update', g.names);

Line: 983

select distinct(wes.guid) GUID from wf_event_subscriptions wes
where owner_tag like NVL(p_ownertag, '%')
 and exists
	(	select 'x'
		from wf_events
		where guid = wes.event_filter_guid
		and   name like nvl(p_key,'%')
                and   (xguid is null or system_guid=xguid)
	);

Line: 994

select guid from wf_agents
where name = wfagt;

Line: 1023

    l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.subscription.update', g.guid);

Line: 1209

** UpdateGUID- Update GUID in WF_RESOURCES table
**                      returns varchar2
**                      Parameters:     
*/
procedure UpdateGUID (
 g_guid in varchar2
) is
ret number default 0; -- 0 means value didn't get update

Line: 1221

    select count(*)
    into l_count
    from WF_SYSTEMS;

Line: 1225

      update WF_RESOURCES
      set text=g_guid
      where name='WF_SYSTEM_GUID';

Line: 1232

    wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UpdateGUID');

Line: 1301

      UpdateGUID(l_guid);

Line: 1356

    select value
    into l_sid
    from v$parameter
    where name='db_name';

Line: 1361

    select global_name
    into l_sid from global_name;

Line: 1387

    select owner
    into l_owner
    from all_queues
    where name='WF_IN';

Line: 1397

    select substr(queue_name,1,instr(queue_name,'.')-1)
    into   l_owner
    from   wf_agents
    where  name = 'WF_IN';

Line: 1479

select guid from wf_agents
where name=str
and system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));

Line: 1737

        select name
        into   l_replaceTarget
        from   wf_agents
        where  guid = l_agtguid;

Line: 1803

         select guid
         into   l_replaceTarget
         from   wf_agents
         where  name = l_agt;