APPS.WF_CLONE dependencies on WF_MAILER_PARAMETERS

Line 207: update wf_mailer_parameters

203: l_url_proto := URL_PROTO;
204: end if;
205: --The mailer parameter should be the WEB_AGENT name
206: --Update HTML agent
207: update wf_mailer_parameters
208: set VALUE = l_url_proto||'://'||WEB_HOST||'.'||DOMAIN||':'||WEB_PORT||'/pls/'||SID
209: where parameter = 'HTMLAGENT';
210:
211: --Update replyto with new host name

Line 212: update wf_mailer_parameters

208: set VALUE = l_url_proto||'://'||WEB_HOST||'.'||DOMAIN||':'||WEB_PORT||'/pls/'||SID
209: where parameter = 'HTMLAGENT';
210:
211: --Update replyto with new host name
212: update wf_mailer_parameters
213: set VALUE = substr(VALUE,1,instr(VALUE,'@'))||DOMAIN
214: where parameter = 'REPLYTO';
215:
216: exception