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: g_nzdtPrepare boolean := false;

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

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

Line 1868: 'WF_EVENT_GROUPS',

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
1872: for i in WFTable.FIRST..WFTable.LAST loop