DBA Data[Home] [Help]

APPS.WF_CLONE dependencies on WF_SYSTEMS

Line 140: from wf_systems

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;
142:
143: --Get the global_name of target
144: select global_name

Line 166: update wf_systems

162: set SYSTEM_GUID = target_guid
163: where SYSTEM_GUID = source_guid;
164:
165: --Update wf_system table
166: update wf_systems
167: set name = target_name
168: where name = source_name;
169:
170: --Update system guid

Line 171: update wf_systems

167: set name = target_name
168: where name = source_name;
169:
170: --Update system guid
171: update wf_systems
172: set guid = target_guid
173: where guid = source_guid;
174:
175: exception