APPS.WF_BES_CLEANUP dependencies on WF_AGENTS

Line 321: from wf_agents

317: begin
318:
319: select queue_name
320: INTO l_queue_name
321: from wf_agents
322: where name = p_agent_name
323: and system_guid = WF_EVENT.local_system_guid;
324:
325: if(l_queue_name is not null) then

Line 345: -- because it can have multiple result. Shall we have a column in WF_AGENTS for exception queue?

341: and name = l_name;
342:
343: -- If default exception queue table, should be l_owner || '.AQ$_' || l_queue_table || '_E'
344: -- We can't select the queue name given the queue name and queue_type = 'EXCEPTION_QUEUE',
345: -- because it can have multiple result. Shall we have a column in WF_AGENTS for exception queue?
346: l_exception_queue := l_owner || '.AQ$_' || l_queue_table || '_E';
347: x_queue_table := l_queue_table;
348: x_exception_queue := l_exception_queue;
349: x_owner := l_owner;

Line 405: l_qualified_queue_name wf_agents.queue_name%type;

401:
402: -- get the owner and queue name of the WF_CONTROL agent
403:
404: declare
405: l_qualified_queue_name wf_agents.queue_name%type;
406: j integer;
407: begin
408: select queue_name
409: into l_qualified_queue_name

Line 410: from wf_agents

406: j integer;
407: begin
408: select queue_name
409: into l_qualified_queue_name
410: from wf_agents
411: where name = 'WF_CONTROL'
412: and system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
413:
414: -- l_qualified_queue_name is of the form .