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

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

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

Line 1198: wf_event_subscriptions_pkg.receive(p_messagedata);

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

Line 1869: 'WF_EVENT_SUBSCRIPTIONS');

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
1873: l_tem_tab_name := WFTable(i);