APPS.WF_SETUP dependencies on WF_AGENTS

Line 111: from WF_AGENTS

107: is
108: -- all db link
109: cursor dblcurs is
110: select distinct substr(ADDRESS, instr(ADDRESS, '@')+1) NAME
111: from WF_AGENTS
112: where PROTOCOL = 'SQLNET'
113: and DIRECTION = 'IN'
114: and SYSTEM_GUID <> localsguid;
115:

Line 181: from WF_AGENTS A

177: )
178: is
179: cursor lquecurs is
180: select A.GUID, A.NAME, A.DIRECTION, A.QUEUE_NAME
181: from WF_AGENTS A
182: where A.SYSTEM_GUID = localsguid
183: and A.PROTOCOL = 'SQLNET';
184:
185: hTab wfe_html_util.headerTabType;

Line 299: from WF_AGENTS A

295: )is
296: -- find all local queues that have direction of IN, ANY or undefined
297: cursor lqcurs is
298: select A.GUID, A.NAME
299: from WF_AGENTS A
300: where A.SYSTEM_GUID = localsguid
301: and A.PROTOCOL = 'SQLNET'
302: and A.STATUS = 'ENABLED'
303: and (A.DIRECTION is null or A.DIRECTION in ('IN', 'ANY'));

Line 324: -- lqr.name came from WF_AGENTS.NAME

320:
321: -- check existence
322: creatable := FALSE;
323: begin
324: -- lqr.name came from WF_AGENTS.NAME
325: -- BINDVAR_SCAN_IGNORE[6]
326: select 'YES'
327: into dTab(i).col02
328: from WF_ALL_JOBS

Line 400: from WF_AGENTS OA, WF_AGENTS TA

396: select OA.GUID OGUID,
397: OA.NAME,
398: OA.QUEUE_NAME OQUEUE,
399: upper(substr(TA.ADDRESS, instr(TA.ADDRESS, '@')+1)) TOSYSTEM
400: from WF_AGENTS OA, WF_AGENTS TA
401: where OA.SYSTEM_GUID = localsguid
402: and OA.PROTOCOL = 'SQLNET'
403: and OA.DIRECTION = 'OUT'
404: and TA.SYSTEM_GUID <> localsguid

Line 416: from WF_AGENTS A

412: select A.GUID OGUID,
413: A.NAME,
414: A.QUEUE_NAME OQUEUE,
415: NULL TOSYSTEM
416: from WF_AGENTS A
417: where A.SYSTEM_GUID = localsguid
418: and A.PROTOCOL = 'SQLNET'
419: and A.DIRECTION = 'OUT'
420: order by TOSYSTEM;

Line 442: from WF_AGENTS

438: -- check out queue
439: begin
440: select NAME
441: into dTab(i).col03
442: from WF_AGENTS
443: where GUID = ppgr.oguid
444: and (PROTOCOL <> 'SQLNET'
445: or (DIRECTION is not null and DIRECTION = 'IN'));
446:

Line 648: from WF_AGENTS

644:
645: begin
646: select SYSTEM_GUID, substr(QUEUE_NAME,1,30)
647: into sguid, qname
648: from WF_AGENTS
649: where GUID = aguid;
650: exception
651: when OTHERS then
652: wf_core.raise('WFE_AGENT_NOTEXIST');

Line 706: -- nm came from WF_AGENTS.NAME

702: --
703: procedure List_Listener(
704: aguid in raw
705: ) is
706: -- nm came from WF_AGENTS.NAME
707: -- BINDVAR_SCAN_IGNORE[4]
708: cursor jobc(nm varchar2) is
709: select JOB, WHAT, upper(INTERVAL) interval
710: from WF_ALL_JOBS

Line 767: from WF_AGENTS

763: -- check agent is local
764: begin
765: select NAME
766: into aname
767: from WF_AGENTS
768: where GUID = l_aguid
769: and SYSTEM_GUID = lguid;
770: exception
771: when OTHERS then

Line 934: from WF_AGENTS

930: -- check agent is local
931: begin
932: select NAME
933: into aname
934: from WF_AGENTS
935: where GUID = aguid
936: and SYSTEM_GUID = lguid;
937: exception
938: when OTHERS then

Line 1421: from wf_agents

1417: -- otherwise raise error.
1418: begin
1419: select name
1420: into l_name
1421: from wf_agents
1422: where name = upper(h_name);
1423:
1424: DBMS_JOB.Submit(
1425: job=>l_job,