APPS.WF_EVENT_SYNCHRONIZE_PKG dependencies on WF_AGENTS

Line 13: g_agent varchar2(100) := '';

9: g_end_clob 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) := '';

Line 595: select guid from wf_agents

591: l_guid raw(16);
592: l_searchPos number default 1;
593:
594: cursor agents(xguid raw) is
595: select guid from wf_agents
596: where name like nvl(p_key,'%')
597: and (xguid is null or system_guid=xguid);
598:
599: begin

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 689: from wf_agents

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
691: and name like nvl(p_key,'%')
692: );*/
693:

Line 994: select guid from wf_agents

990: and (xguid is null or system_guid=xguid)
991: );
992:
993: cursor agents(wfagt varchar2) is
994: select guid from wf_agents
995: where name = wfagt;
996:
997: begin
998: -- Download local event subscriptions only when ObjectType is SYSTEMS, AGENTS, or EVENT

Line 1189: wf_agents_pkg.receive(p_messagedata);

1185:
1186: IF p_objecttype = g_system THEN
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);

Line 1393: --off from wf_agents or since WF_IN is seeded

1389: from all_queues
1390: where name='WF_IN';
1391: */
1392: --don't do this costly query substr it
1393: --off from wf_agents or since WF_IN is seeded
1394: --it should always be the schema
1395: /* Bug3628261 - if no data found here NOSUCHTHING was returned
1396: instead we will just cache the WF_SCHEMA.
1397: select substr(queue_name,1,instr(queue_name,'.')-1)

Line 1399: from wf_agents

1395: /* Bug3628261 - if no data found here NOSUCHTHING was returned
1396: instead we will just cache the WF_SCHEMA.
1397: select substr(queue_name,1,instr(queue_name,'.')-1)
1398: into l_owner
1399: from wf_agents
1400: where name = 'WF_IN';
1401: */
1402: if (g_qowner is null) then
1403: g_qowner := upper(wf_core.translate('WF_SCHEMA'));

Line 1479: select guid from wf_agents

1475: l_wferror varchar2(1000) default null;
1476: strGuid varchar2(100) default null;
1477:
1478: cursor agent(str varchar2) is
1479: select guid from wf_agents
1480: where name=str
1481: and system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
1482:
1483: begin

Line 1739: from wf_agents

1735: begin
1736: --Get the agent name from the guid given
1737: select name
1738: into l_replaceTarget
1739: from wf_agents
1740: where guid = l_agtguid;
1741: exception
1742: when others then
1743: wf_core.token('GUID', l_agtguid);

Line 1805: from wf_agents

1801: l_agt := substr(l_agtname,2);
1802: --Get the agent name from the guid given
1803: select guid
1804: into l_replaceTarget
1805: from wf_agents
1806: where name = l_agt;
1807:
1808: if (l_pos > 1) then
1809: l_str_new := replace(l_str,l_agtname,l_replaceTarget);