APPS.WF_EVENT dependencies on WF_AGENT_OBJ

Line 830: l_agent_obj wf_agent_obj;

826: agt_name varchar2(30);
827: sys_name varchar2(30);
828:
829: -- wf bes cache implementation
830: l_agent_obj wf_agent_obj;
831: begin
832: if (p_agent_guid is null) then
833: return null;
834: end if;

Line 902: l_to_agt_obj wf_agent_obj;

898: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;
899: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
900:
901: -- wf bes cache implementation
902: l_to_agt_obj wf_agent_obj;
903: l_out_agt_obj wf_agent_obj;
904: begin
905: --
906: -- if from_agent is null, pick one from the local system that uses

Line 903: l_out_agt_obj wf_agent_obj;

899: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
900:
901: -- wf bes cache implementation
902: l_to_agt_obj wf_agent_obj;
903: l_out_agt_obj wf_agent_obj;
904: begin
905: --
906: -- if from_agent is null, pick one from the local system that uses
907: -- the same queue handler (i.e.: same event type)

Line 1016: l_to_agt_obj wf_agent_obj;

1012: l_to_queue_name WF_AGENTS.QUEUE_NAME%TYPE;
1013: l_to_protocol_number NUMBER := 0; -- Hard code as SQLNET
1014:
1015: -- wf bes cache implementation
1016: l_to_agt_obj wf_agent_obj;
1017: BEGIN
1018:
1019: -- MJC: We need to make sure the recipient address is in the correct
1020: -- format otherwise dequeue will not work.

Line 1096: l_to_agt_obj wf_agent_obj;

1092: --Bug 2676549
1093: i number := 0;
1094:
1095: -- bes cache implementation
1096: l_to_agt_obj wf_agent_obj;
1097: l_out_agt_obj wf_agent_obj;
1098: BEGIN
1099:
1100: -- Ignore if to agent is not set or the out agent is DEFERRED.

Line 1097: l_out_agt_obj wf_agent_obj;

1093: i number := 0;
1094:
1095: -- bes cache implementation
1096: l_to_agt_obj wf_agent_obj;
1097: l_out_agt_obj wf_agent_obj;
1098: BEGIN
1099:
1100: -- Ignore if to agent is not set or the out agent is DEFERRED.
1101: if ((p_event.getToAgent() is null) or (p_out_agent_name = 'WF_DEFERRED')) then

Line 1249: l_agent_obj wf_agent_obj;

1245: l_dequeue_enabled VARCHAR2(30);
1246: l_queueTable VARCHAR2(30);
1247:
1248: -- bes caching implementation
1249: l_agent_obj wf_agent_obj;
1250:
1251: begin
1252:
1253: -- return an error if listen is invoked on WF_JAVA_DEFERRED or

Line 1692: l_agent_obj wf_agent_obj;

1688: end_of_transaction exception;
1689: pragma exception_init (end_of_transaction, -25235);
1690:
1691: -- bes caching implementation
1692: l_agent_obj wf_agent_obj;
1693: begin
1694:
1695: -- Confirm that p_agent_name includes a transactional queue.
1696: -- Tuned and separated sql statement for better performance

Line 2265: l_agent_obj wf_agent_obj;

2261: agtname varchar2(30);
2262: sysname varchar2(30);
2263:
2264: -- bes caching implementation
2265: l_agent_obj wf_agent_obj;
2266: p_executed boolean;
2267: begin
2268: /*
2269: ** mjc If an override agent is defined, we should

Line 2332: l_agent_obj wf_agent_obj;

2328: cmd varchar2(1000);
2329: evt_errmsg varchar2(2000);
2330:
2331: -- bes caching implementation
2332: l_agent_obj wf_agent_obj;
2333: p_executed boolean;
2334: begin
2335: if (p_queue_handler is null) then
2336: -- get queue details from cache for given agent GUID

Line 3139: l_agent_obj wf_agent_obj;

3135: agent_system in varchar2,
3136: agent_guid out nocopy raw)
3137: is
3138: -- bes caching implementation
3139: l_agent_obj wf_agent_obj;
3140: begin
3141:
3142: l_agent_obj := wf_bes_cache.GetAgentByName(agent_name, agent_system);
3143:

Line 3175: l_agent_obj wf_agent_obj;

3171: l_owner varchar2(30);
3172: l_queue_table varchar2(30);
3173:
3174: -- bes caching implementation
3175: l_agent_obj wf_agent_obj;
3176: begin
3177: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3178: wf_log_pkg.string(wf_log_pkg.level_procedure,
3179: 'wf.plsql.WF_EVENT.GetAgentDetails.Begin',