APPS.WF_CLONE dependencies on GLOBAL_NAME

Line 136: --Get the global name of source to replace

132: update wf_resources
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

Line 143: --Get the global_name of target

139: into source_name
140: from wf_systems
141: where guid = source_guid;
142:
143: --Get the global_name of target
144: select global_name
145: into target_name
146: from global_name;
147:

Line 144: select global_name

140: from wf_systems
141: where guid = source_guid;
142:
143: --Get the global_name of target
144: select global_name
145: into target_name
146: from global_name;
147:
148: --Now replace the agent address with the

Line 146: from global_name;

142:
143: --Get the global_name of target
144: select global_name
145: into target_name
146: from global_name;
147:
148: --Now replace the agent address with the
149: --target global name.
150:

Line 149: --target global name.

145: into target_name
146: from global_name;
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;