APPS.WF_EVENT_SYNCHRONIZE_PKG dependencies on WF_EVENT_GROUPS

Line 16: g_event_group 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);
20:

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 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 1195: wf_event_groups_pkg.receive2(p_messagedata,p_error);

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);
1198: END IF;
1199: