APPS.WF_EVENT_SYNCHRONIZE_PKG dependencies on WF_EVENTS

Line 15: g_event varchar2(100) := '';

11: g_end_string varchar2(100) := '';
12: g_system varchar2(100) := '';
13: g_agent varchar2(100) := '';
14: g_agent_group varchar2(100) := '';
15: g_event varchar2(100) := '';
16: g_event_group varchar2(100) := '';
17: g_event_sub varchar2(100) := '';
18: g_objecttype varchar2(100);
19: g_qowner varchar2(30);

Line 738: from wf_events

734:
735: -- we want to get only EVENT type objects here
736: cursor events is
737: select guid
738: from wf_events
739: where type = 'EVENT'
740: and name like p_key
741: and owner_tag like nvl(p_ownertag, '%');
742:

Line 745: from wf_events

741: and owner_tag like nvl(p_ownertag, '%');
742:
743: cursor events_all is
744: select guid
745: from wf_events
746: where type = 'EVENT'
747: and owner_tag like nvl(p_ownertag, '%');
748:
749: begin

Line 801: from wf_events g, wf_events e, wf_event_groups eg

797:
798: -- Download all groups to which the given event or key belongs to
799: cursor event_groups is
800: select g.name||'/'||e.name names
801: from wf_events g, wf_events e, wf_event_groups eg
802: where g.guid = eg.group_guid
803: and g.type = 'GROUP'
804: and e.guid = eg.member_guid
805: and e.name like p_key

Line 811: from wf_events g, wf_events e, wf_event_groups eg

807: order by e.name;
808:
809: cursor event_groups_all is
810: select g.name||'/'||e.name names
811: from wf_events g, wf_events e, wf_event_groups eg
812: where g.guid = eg.group_guid
813: and g.type = 'GROUP'
814: and e.guid = eg.member_guid
815: and e.owner_tag like nvl(p_ownertag, '%')

Line 870: from wf_events

866: returnclob clob;
867:
868: cursor events is
869: select guid
870: from wf_events
871: where type = 'GROUP'
872: and name like p_key
873: and owner_tag like nvl(p_ownertag, '%');
874:

Line 877: from wf_events

873: and owner_tag like nvl(p_ownertag, '%');
874:
875: cursor events_all is
876: select guid
877: from wf_events
878: where type = 'GROUP'
879: and owner_tag like nvl(p_ownertag, '%');
880:
881: begin

Line 928: from wf_events g, wf_events e, wf_event_groups eg

924: returnclob clob;
925:
926: cursor event_groups is
927: select g.name||'/'||e.name names
928: from wf_events g, wf_events e, wf_event_groups eg
929: where g.guid = eg.group_guid
930: and g.type = 'GROUP'
931: and e.guid = eg.member_guid
932: and (p_key is null or g.name like p_key )

Line 987: from wf_events

983: select distinct(wes.guid) GUID from wf_event_subscriptions wes
984: where owner_tag like NVL(p_ownertag, '%')
985: and exists
986: ( select 'x'
987: from wf_events
988: where guid = wes.event_filter_guid
989: and name like nvl(p_key,'%')
990: and (xguid is null or system_guid=xguid)
991: );

Line 1193: wf_events_pkg.receive(p_messagedata);

1189: wf_agents_pkg.receive(p_messagedata);
1190: ELSIF p_objecttype = g_agent_group THEN
1191: wf_agent_groups_pkg.receive(p_messagedata);
1192: ELSIF p_objecttype = g_event THEN
1193: wf_events_pkg.receive(p_messagedata);
1194: ELSIF p_objecttype = g_event_group THEN
1195: wf_event_groups_pkg.receive2(p_messagedata,p_error);
1196: ELSIF p_objecttype = g_event_sub THEN
1197: wf_event_subscriptions_pkg.receive(p_messagedata);