APPS.WF_EVENT_SYNCHRONIZE_PKG dependencies on WF_AGENT_GROUPS

Line 14: g_agent_group varchar2(100) := '';

10: g_begin_string 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);

Line 682: from wf_agents g, wf_agents a,wf_agent_groups ag

678: returnclob clob;
679:
680: cursor agent_groups is
681: select g.name||'/'||a.name GUID
682: from wf_agents g, wf_agents a,wf_agent_groups ag
683: where g.guid=ag.group_guid
684: and a.guid=ag.member_guid
685: and (p_key is null or a.name like p_key);
686:

Line 687: /*select wag.group_guid||'/'||wag.member_guid GUID from wf_agent_groups wag

683: where g.guid=ag.group_guid
684: and a.guid=ag.member_guid
685: and (p_key is null or a.name like p_key);
686:
687: /*select wag.group_guid||'/'||wag.member_guid GUID from wf_agent_groups wag
688: where exists
689: ( select 'x'
690: from wf_agents
691: where guid = wag.member_guid

Line 1192: wf_agent_groups_pkg.receive(p_messagedata);

1188: wf_systems_pkg.receive(p_messagedata);
1189: ELSIF p_objecttype = g_agent THEN
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);

Line 1865: 'WF_AGENT_GROUPS',

1861: TYPE TableName is VARRAY(8) OF VARCHAR2(50);
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');