APPS.WF_EVENT dependencies on WF_AGENT_OBJ

Line 800: l_agent_obj wf_agent_obj;

796: agt_name varchar2(30);
797: sys_name varchar2(30);
798:
799: -- wf bes cache implementation
800: l_agent_obj wf_agent_obj;
801: begin
802: if (p_agent_guid is null) then
803: return null;
804: end if;

Line 872: l_to_agt_obj wf_agent_obj;

868: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;
869: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
870:
871: -- wf bes cache implementation
872: l_to_agt_obj wf_agent_obj;
873: l_out_agt_obj wf_agent_obj;
874: begin
875: --
876: -- if from_agent is null, pick one from the local system that uses

Line 873: l_out_agt_obj wf_agent_obj;

869: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
870:
871: -- wf bes cache implementation
872: l_to_agt_obj wf_agent_obj;
873: l_out_agt_obj wf_agent_obj;
874: begin
875: --
876: -- if from_agent is null, pick one from the local system that uses
877: -- the same queue handler (i.e.: same event type)

Line 986: l_to_agt_obj wf_agent_obj;

982: l_to_queue_name WF_AGENTS.QUEUE_NAME%TYPE;
983: l_to_protocol_number NUMBER := 0; -- Hard code as SQLNET
984:
985: -- wf bes cache implementation
986: l_to_agt_obj wf_agent_obj;
987: BEGIN
988:
989: -- MJC: We need to make sure the recipient address is in the correct
990: -- format otherwise dequeue will not work.

Line 1066: l_to_agt_obj wf_agent_obj;

1062: --Bug 2676549
1063: i number := 0;
1064:
1065: -- bes cache implementation
1066: l_to_agt_obj wf_agent_obj;
1067: l_out_agt_obj wf_agent_obj;
1068: BEGIN
1069:
1070: -- Ignore if to agent is not set or the out agent is DEFERRED.

Line 1067: l_out_agt_obj wf_agent_obj;

1063: i number := 0;
1064:
1065: -- bes cache implementation
1066: l_to_agt_obj wf_agent_obj;
1067: l_out_agt_obj wf_agent_obj;
1068: BEGIN
1069:
1070: -- Ignore if to agent is not set or the out agent is DEFERRED.
1071: if ((p_event.getToAgent() is null) or (p_out_agent_name = 'WF_DEFERRED')) then

Line 1218: l_agent_obj wf_agent_obj;

1214: l_dequeue_enabled VARCHAR2(30);
1215: l_queueTable VARCHAR2(30); -- 1216:
1217: -- bes caching implementation
1218: l_agent_obj wf_agent_obj;
1219:
1220: begin
1221:
1222: -- return an error if listen is invoked on WF_JAVA_DEFERRED or

Line 1651: l_agent_obj wf_agent_obj;

1647: end_of_transaction exception;
1648: pragma exception_init (end_of_transaction, -25235);
1649:
1650: -- bes caching implementation
1651: l_agent_obj wf_agent_obj;
1652: begin
1653:
1654: -- Confirm that p_agent_name includes a transactional queue.
1655: -- Tuned and separated sql statement for better performance

Line 2208: l_agent_obj wf_agent_obj;

2204: agtname varchar2(30);
2205: sysname varchar2(30);
2206:
2207: -- bes caching implementation
2208: l_agent_obj wf_agent_obj;
2209: p_executed boolean;
2210: begin
2211: /*
2212: ** mjc If an override agent is defined, we should

Line 2275: l_agent_obj wf_agent_obj;

2271: cmd varchar2(1000);
2272: evt_errmsg varchar2(2000);
2273:
2274: -- bes caching implementation
2275: l_agent_obj wf_agent_obj;
2276: p_executed boolean;
2277: begin
2278: if (p_queue_handler is null) then
2279: -- get queue details from cache for given agent GUID

Line 3077: l_agent_obj wf_agent_obj;

3073: agent_system in varchar2,
3074: agent_guid out nocopy raw)
3075: is
3076: -- bes caching implementation
3077: l_agent_obj wf_agent_obj;
3078: begin
3079:
3080: l_agent_obj := wf_bes_cache.GetAgentByName(agent_name, agent_system);
3081:

Line 3113: l_agent_obj wf_agent_obj;

3109: l_owner varchar2(30);
3110: l_queue_table varchar2(30);
3111:
3112: -- bes caching implementation
3113: l_agent_obj wf_agent_obj;
3114: begin
3115: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3116: wf_log_pkg.string(wf_log_pkg.level_procedure,
3117: 'wf.plsql.WF_EVENT.GetAgentDetails.Begin',