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 596: select guid from wf_agents

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

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

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

Line 995: select guid from wf_agents

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

Line 1190: wf_agents_pkg.receive(p_messagedata);

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

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

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

Line 1400: from wf_agents

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

Line 1480: select guid from wf_agents

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

Line 1740: from wf_agents

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

Line 1806: from wf_agents

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

Line 1864: 'WF_AGENTS',

1860: l_tem_tab_name varchar2(50);
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',