APPS.WF_CLONE dependencies on WF_RESOURCES

Line 26: from wf_resources

22:
23: --Select source agent
24: select text
25: into source_web_agent
26: from wf_resources
27: where name = 'WF_WEB_AGENT'
28: and language = 'US';
29:
30: --Check if there is a trailing '/' in the web_agent

Line 124: from wf_resources

120: savepoint wf_update_guid;
121:
122: select text
123: into source_guid
124: from wf_resources
125: where name = 'WF_SYSTEM_GUID'
126: and language = 'US';
127:
128: --Get a global unique identifier here

Line 131: --Now set this value for the sysguid in wf_resources

127:
128: --Get a global unique identifier here
129: target_guid := sys_guid();
130:
131: --Now set this value for the sysguid in wf_resources
132: update wf_resources
133: set text = target_guid
134: where name = 'WF_SYSTEM_GUID';
135:

Line 132: update wf_resources

128: --Get a global unique identifier here
129: target_guid := sys_guid();
130:
131: --Now set this value for the sysguid in wf_resources
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

Line 195: from wf_resources

191:
192: --Select source agent
193: select text
194: into source_web_agent
195: from wf_resources
196: where name = 'WF_WEB_AGENT'
197: and language = 'US';
198:
199:

Line 243: update wf_resources

239:
240: target_web_agent := l_url_proto||'://'||WEB_HOST||'.'||DOMAIN||':'||WEB_PORT||'/pls/'||SID;
241:
242: --Update the target webagent.
243: update wf_resources
244: set text = target_web_agent
245: where name = 'WF_WEB_AGENT';
246:
247: exception

Line 266: from wf_resources

262:
263: begin
264: select text
265: into source_agent
266: from wf_resources
267: where name = 'WF_WEB_AGENT'
268: and language = 'US';
269: exception
270: when no_data_found then