[Home] [Help]
3285:
3286: corrId := wf_event.getValueForParameter('Q_CORRELATION_ID',
3287: p_parameter_list);
3288: -- Obtain the values for the configurable items
3289: nodename := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3290: pCorrId => corrId,
3291: pName => 'NODENAME',
3292: pInAttr => dummy);
3293:
3290: pCorrId => corrId,
3291: pName => 'NODENAME',
3292: pInAttr => dummy);
3293:
3294: agent := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3295: pCorrId => corrId,
3296: pName => 'HTMLAGENT',
3297: pInAttr => dummy);
3298:
3295: pCorrId => corrId,
3296: pName => 'HTMLAGENT',
3297: pInAttr => dummy);
3298:
3299: fromName := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3300: pCorrId => corrId,
3301: pName => 'FROM',
3302: pInAttr => FromInAttr);
3303:
3300: pCorrId => corrId,
3301: pName => 'FROM',
3302: pInAttr => FromInAttr);
3303:
3304: replyto := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3305: pCorrId => corrId,
3306: pName => 'REPLYTO',
3307: pInAttr => ReplyToInAttr);
3308:
3305: pCorrId => corrId,
3306: pName => 'REPLYTO',
3307: pInAttr => ReplyToInAttr);
3308:
3309: inlineAtt := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3310: pCorrId => corrId,
3311: pName => 'INLINE_ATTACHMENT',
3312: pInAttr => dummy);
3313:
3310: pCorrId => corrId,
3311: pName => 'INLINE_ATTACHMENT',
3312: pInAttr => dummy);
3313:
3314: sendAccessKey := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3315: pCorrId => corrId,
3316: pName => 'SEND_ACCESS_KEY',
3317: pInAttr => dummy);
3318:
3315: pCorrId => corrId,
3316: pName => 'SEND_ACCESS_KEY',
3317: pInAttr => dummy);
3318:
3319: stylesheetEnabled := wf_mailer_parameter.getValueForCorr(pNid => nid,
3320: pCorrId => corrId,
3321: pName => 'ENABLE_STYLESHEET',
3322: pInAttr => EnableStyleInAttr);
3323:
3322: pInAttr => EnableStyleInAttr);
3323:
3324: -- 5393647 - Parameter to control the text/html response
3325: -- template delimiter
3326: delimiter_string := wf_mailer_parameter.getValueForCorr(pNId => nid,
3327: pCorrId => corrId,
3328: pName => 'HTML_DELIMITER',
3329: pInAttr => dummy);
3330:
3330:
3331: setHtmlDelimiters(upper(trim(delimiter_string)));
3332:
3333: -- 4676402 Support for CC and BCC. These are not configuration parameters
3334: -- so the values can not be retrieved through the wf_mailer_parameter
3335: -- interface.
3336: -- The precedence will be only for normal notifications. Requests
3337: -- for more information will not be subject to the cc and bcc
3338: -- handling.
3367: -- They are not configurable at the message level because of the
3368: -- confusion caused with multiple mailers and especially those that
3369: -- share the same correlation ID. The value must be consisten in the
3370: -- PL/SQL layer as well as the Java layer.
3371: directResponse := WF_MAILER_PARAMETER.getValueForCorr(pCorrId => corrId,
3372: pName => 'DIRECT_RESPONSE');
3373:
3374: attachInlineImages := WF_MAILER_PARAMETER.GetValueForCorr (
3375: pCorrId => corrId,
3370: -- PL/SQL layer as well as the Java layer.
3371: directResponse := WF_MAILER_PARAMETER.getValueForCorr(pCorrId => corrId,
3372: pName => 'DIRECT_RESPONSE');
3373:
3374: attachInlineImages := WF_MAILER_PARAMETER.GetValueForCorr (
3375: pCorrId => corrId,
3376: pName => 'ATTACH_IMAGES');
3377: if inlineAtt = 'Y' then
3378: disposition := 'inline';
4155: -- 4628088 Send the RESET_NLS flag if one is defined
4156: -- at the message level.
4157: corrId := wf_event.getValueForParameter('Q_CORRELATION_ID',
4158: p_parameter_list);
4159: resetNls := WF_MAILER_PARAMETER.GetValueForCorr (pNid => p_event_key,
4160: pCorrId => corrId,
4161: pName => 'RESET_NLS',
4162: pInAttr => inAttr);
4163:
4242: when no_data_found then
4243: str := '';
4244: pos := length(str);
4245: dbms_lob.write(p_doc, pos, 1, str);
4246: nodename := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
4247: pCorrId => messageType,
4248: pName => 'NODENAME',
4249: pInAttr => inAttr);
4250:
4287:
4288: str := '';
4289: pos := length(str);
4290: dbms_lob.write(p_doc, pos, 1, str);
4291: nodename := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
4292: pCorrId => messageType,
4293: pName => 'NODENAME',
4294: pInAttr => inAttr);
4295:
4339: dbms_lob.write(p_doc, pos, 1, str);
4340:
4341: -- 4628088 Send the RESET_NLS flag if one is defined
4342: -- at the message level.
4343: resetNls := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
4344: pCorrId => messageType,
4345: pName => 'RESET_NLS',
4346: pInAttr => inAttr);
4347:
4699:
4700: hdrxmlPos := NewTag(hdrxml, hdrxmlPos, 'FROM', '', attrlist);
4701:
4702: -- fromName := '&#FROM';
4703: fromName := WF_MAILER_PARAMETER.GetValueForCorr (pCorrId => corrId,
4704: pName => 'FROM');
4705: fromName := replace(fromName, g_newLine);
4706: fromName := '';
4707: hdrxmlPos := NewTag(hdrxml, hdrxmlPos, 'NAME', fromName, attrlist);
4707: hdrxmlPos := NewTag(hdrxml, hdrxmlPos, 'NAME', fromName, attrlist);
4708: hdrxmlPos := SkipTag(hdrxml, 'NAME', hdrxmlPos, occurance);
4709:
4710: -- replyto := '&#REPLYTO';
4711: replyto := WF_MAILER_PARAMETER.GetValueForCorr (pCorrId => corrId,
4712: pName => 'REPLYTO');
4713: replyto := replace(replyto, g_newLine);
4714: replyto := '';
4715: hdrxmlPos := NewTag(hdrxml, hdrxmlPos, 'ADDRESS', replyto, attrlist);