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 739: from wf_events

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

Line 746: from wf_events

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

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

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

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

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

Line 871: from wf_events

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

Line 878: from wf_events

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

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

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

Line 988: from wf_events

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

Line 1194: wf_events_pkg.receive(p_messagedata);

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

Line 1866: 'WF_EVENTS',

1862: WFTable TableName:=TableName ('WF_RESOURCES',
1863: 'WF_SYSTEMS',
1864: 'WF_AGENTS',
1865: 'WF_AGENT_GROUPS',
1866: 'WF_EVENTS',
1867: 'WF_EVENTS_TL',
1868: 'WF_EVENT_GROUPS',
1869: 'WF_EVENT_SUBSCRIPTIONS');
1870: begin

Line 1867: 'WF_EVENTS_TL',

1863: 'WF_SYSTEMS',
1864: 'WF_AGENTS',
1865: 'WF_AGENT_GROUPS',
1866: 'WF_EVENTS',
1867: 'WF_EVENTS_TL',
1868: 'WF_EVENT_GROUPS',
1869: 'WF_EVENT_SUBSCRIPTIONS');
1870: begin
1871: if not g_nzdtPrepare then