APPS.WF_EVENT_SYNCHRONIZE_PKG dependencies on WF_EVENT_SUBSCRIPTIONS

Line 17: g_event_sub 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:
21: ------------------------------------------------------------------------------

Line 983: select distinct(wes.guid) GUID from wf_event_subscriptions wes

979: l_guid raw(16);
980: strGuid varchar2(100) default null;
981:
982: cursor event_subscriptions(xguid raw) is
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

Line 1197: wf_event_subscriptions_pkg.receive(p_messagedata);

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:
1200: /*exception
1201: when others then