APPS.WF_EVENT dependencies on WF_SYSTEMS

Line 38: wf_systems sys

34: agt2.queue_handler as queue_handler
35: from wf_agent_groups agp ,
36: wf_agents agt1 ,
37: wf_agents agt2 ,
38: wf_systems sys
39: where agt1.name = agent_name
40: and agt1.type = 'GROUP'
41: and agt1.status = 'ENABLED'
42: and agt1.system_guid = sys.guid

Line 864: toagtsys WF_SYSTEMS.NAME%TYPE;

860: */
861: PROCEDURE send(p_event in out nocopy wf_event_t) is
862: outguid WF_AGENTS.GUID%TYPE;
863: toagtname WF_AGENTS.NAME%TYPE;
864: toagtsys WF_SYSTEMS.NAME%TYPE;
865: outagtname WF_AGENTS.NAME%TYPE;
866: outagtsys WF_SYSTEMS.NAME%TYPE;
867: l_to_type WF_AGENTS.TYPE%TYPE;
868: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;

Line 866: outagtsys WF_SYSTEMS.NAME%TYPE;

862: outguid WF_AGENTS.GUID%TYPE;
863: toagtname WF_AGENTS.NAME%TYPE;
864: toagtsys WF_SYSTEMS.NAME%TYPE;
865: outagtname WF_AGENTS.NAME%TYPE;
866: outagtsys WF_SYSTEMS.NAME%TYPE;
867: l_to_type WF_AGENTS.TYPE%TYPE;
868: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;
869: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
870:

Line 1059: l_to_system_name WF_SYSTEMS.NAME%TYPE;

1055: p_out_system_name in varchar2,
1056: x_message_properties in out nocopy dbms_aq.message_properties_t) IS
1057: l_to_type WF_AGENTS.TYPE%TYPE;
1058: l_to_agent_name WF_AGENTS.NAME%TYPE;
1059: l_to_system_name WF_SYSTEMS.NAME%TYPE;
1060: l_out_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
1061: l_recipient_agent sys.aq$_agent;
1062: --Bug 2676549
1063: i number := 0;

Line 3396: from wf_systems

3392:
3393: wf_event.local_system_status := wf_core.translate('WF_SYSTEM_STATUS');
3394:
3395: select name into wf_event.local_system_name
3396: from wf_systems
3397: where guid = wf_event.local_system_guid;
3398: ---------------------------------------------------------------------------
3399: wf_event.schema_name := wf_core.translate('WF_SCHEMA');
3400: