APPS.WF_QUEUE dependencies on WF_AGENTS

Line 2982: from wf_agents

2978:
2979: -- Changed upper(name) to name as queue_name should be recorded in upper case.
2980: cursor c_localagents(p_agent varchar2) is
2981: select queue_name
2982: from wf_agents
2983: where system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
2984: and name like upper(p_agent);
2985:
2986: /*

Line 3146: FROM wf_agents

3142:
3143: begin
3144: SELECT TRIM(queue_name), TRIM(queue_handler)
3145: INTO l_queue_name, l_queue_handler
3146: FROM wf_agents
3147: WHERE name = upper(p_agent_name)
3148: AND SYSTEM_GUID = wf_event.local_system_guid;
3149: exception
3150: when no_data_found then

Line 3313: FROM wf_agents

3309: l_xcount := 0;
3310:
3311: SELECT queue_name
3312: INTO l_queue_name
3313: FROM wf_agents
3314: WHERE name = upper(p_agent_name)
3315: AND SYSTEM_GUID = wf_event.local_system_guid;
3316:
3317: l_pos := instr(l_queue_name, '.', 1, 1);

Line 3347: -- Seeded WF agents

3343: --Set the Correlation ID for dequeue only if available
3344: --If the given agent is a Workflow Agent then append the
3345: --Account Name before the Correlation ID
3346: if ((p_correlation is not null) or (p_correlation <> '')) then
3347: -- Seeded WF agents
3348: if (upper(p_agent_name) like 'WF_%') then
3349: if (wf_event.account_name is null) then
3350: wf_event.SetAccountName;
3351: end if;

Line 3501: FROM wf_agents

3497: l_xcount := 0;
3498:
3499: SELECT queue_name
3500: INTO l_queue_name
3501: FROM wf_agents
3502: WHERE name = upper(p_agent_name)
3503: AND SYSTEM_GUID = wf_event.local_system_guid;
3504:
3505: l_pos := instr(l_queue_name, '.', 1, 1);

Line 3541: -- Seeded WF agents

3537: -- All the message ids older than the specified age are queried
3538: -- and the dequeue is done on the retrieved message ids
3539: --
3540: if ((p_correlation is not null) or (p_correlation <> '')) then
3541: -- Seeded WF agents
3542: if (upper(p_agent_name) like 'WF_%') then
3543: if (wf_event.account_name is null) then
3544: wf_event.SetAccountName;
3545: end if;