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 681: from wf_agents g, wf_agents a,wf_agent_groups ag

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

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

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

Line 1191: wf_agent_groups_pkg.receive(p_messagedata);

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