APPS.WF_EVENT_SYNCHRONIZE_PKG dependencies on WF_SYSTEMS

Line 12: g_system varchar2(100) := '';

8: g_begin_clob varchar2(100) := '';
9: g_end_clob varchar2(100) := '';
10: g_begin_string varchar2(100) := '';
11: g_end_string varchar2(100) := '';
12: g_system varchar2(100) := '';
13: g_agent varchar2(100) := '';
14: g_agent_group varchar2(100) := '';
15: g_event varchar2(100) := '';
16: g_event_group varchar2(100) := '';

Line 547: select guid from wf_systems

543: l_clob clob;
544: returnclob clob;
545:
546: cursor systems is
547: select guid from wf_systems
548: where name like nvl(p_key,'%');
549:
550: begin
551:

Line 1187: wf_systems_pkg.receive(p_messagedata);

1183:
1184: begin
1185:
1186: IF p_objecttype = g_system THEN
1187: wf_systems_pkg.receive(p_messagedata);
1188: ELSIF p_objecttype = g_agent THEN
1189: wf_agents_pkg.receive(p_messagedata);
1190: ELSIF p_objecttype = g_agent_group THEN
1191: wf_agent_groups_pkg.receive(p_messagedata);

Line 1223: from WF_SYSTEMS;

1219: begin
1220: if g_guid is not null then
1221: select count(*)
1222: into l_count
1223: from WF_SYSTEMS;
1224: if (l_count = 0) then
1225: update WF_RESOURCES
1226: set text=g_guid
1227: where name='WF_SYSTEM_GUID';

Line 1290: g_beg_system varchar2(100) := '';

1286: ) return varchar2 is
1287:
1288: g_guid varchar2(100) := '#NEW';
1289: g_guid2 varchar2(100) := '#NEW';
1290: g_beg_system varchar2(100) := '';
1291: g_end_system varchar2(100) := '';
1292: retStr varchar2(32000) default null;
1293: l_guid raw(16) default null;
1294:

Line 1291: g_end_system varchar2(100) := '';

1287:
1288: g_guid varchar2(100) := '#NEW';
1289: g_guid2 varchar2(100) := '#NEW';
1290: g_beg_system varchar2(100) := '';
1291: g_end_system varchar2(100) := '';
1292: retStr varchar2(32000) default null;
1293: l_guid raw(16) default null;
1294:
1295: begin