APPS.WF_CLONE dependencies on WF_AGENTS

Line 137: --the address in wf_agents

133: set text = target_guid
134: where name = 'WF_SYSTEM_GUID';
135:
136: --Get the global name of source to replace
137: --the address in wf_agents
138: select name
139: into source_name
140: from wf_systems
141: where guid = source_guid;

Line 151: update wf_agents

147:
148: --Now replace the agent address with the
149: --target global name.
150:
151: update wf_agents
152: set address = substr(address,1,instr(address,'@',1))||target_name
153: where address = substr(address,1,instr(address,'@',1))||source_name;
154:
155: --Update system guid references in wf_agents

Line 155: --Update system guid references in wf_agents

151: update wf_agents
152: set address = substr(address,1,instr(address,'@',1))||target_name
153: where address = substr(address,1,instr(address,'@',1))||source_name;
154:
155: --Update system guid references in wf_agents
156: update wf_agents
157: set system_guid = target_guid
158: where system_guid = source_guid;
159:

Line 156: update wf_agents

152: set address = substr(address,1,instr(address,'@',1))||target_name
153: where address = substr(address,1,instr(address,'@',1))||source_name;
154:
155: --Update system guid references in wf_agents
156: update wf_agents
157: set system_guid = target_guid
158: where system_guid = source_guid;
159:
160: --Update system guid references in event subscription tables

Line 321: from wf_agents

317: is
318: l_owner varchar2(30);
319: cursor queue_curs is
320: select queue_name , name
321: from wf_agents
322: where type ='AGENT';
323:
324: begin
325: --WF Tables we depend are created in the schema given by the token