[Home] [Help]
3718: dbms_lob.createTemporary(clob_loc, false, dbms_lob.call);
3719: Wf_Notification.GetAttrCLOB(nid, aname, wf_notification.doc_html,
3720: clob_loc, doctype, attr_name);
3721: if (doctype is not null) then
3722: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);
3723: end if;
3724: -- We have the document. Now determine the output method. HTML documents can be output as
3725: -- they are. Binary documents can only be downloaded
3726: if l_mime_type in (wf_notification.doc_text, wf_notification.doc_html) then
3750: -- Decode base64 encoded content
3751: if (upper(trim(l_encoding)) = 'BASE64') then
3752: dbms_lob.createTemporary(blob_loc, FALSE, dbms_lob.call);
3753:
3754: wf_mail_util.decodeBLOB(clob_loc, blob_loc);
3755: -- owa_util.mime_header(doctype, FALSE);
3756: -- Write appropriate headers before downloading the document
3757: if (l_filename is null or l_filename = '') then
3758: l_filename := aname || '.' || l_extension;
3783: dbms_lob.createTemporary(blob_loc, false, dbms_lob.call);
3784: Wf_Notification.GetAttrBLOB(nid, aname, wf_notification.doc_html,
3785: blob_loc, doctype, attr_name);
3786: if (doctype is not null) then
3787: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);
3788: end if;
3789: if (l_filename is null or l_filename = '') then
3790: l_filename := aname || '.' || l_extension;
3791: end if;