APPS.WFA_HTML dependencies on DBMS_LOB

Line 3718: dbms_lob.createTemporary(clob_loc, false, dbms_lob.call);

3714: doctext := wf_notification.getattrdoc(nid, aname,wf_notification.doc_html);
3715:
3716: -- if the attribute wasn't translated then try to translate for plsqlclobs.
3717: if doctext = '&'||aname then
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);

Line 3738: lobsize := dbms_lob.getlength(clob_loc);

3734: wfa_sec.Header(FALSE, '',wf_core.translate('WFITD_ATTR_TYPE_DOCUMENT'),
3735: TRUE);
3736: htp.br;
3737:
3738: lobsize := dbms_lob.getlength(clob_loc);
3739: amount := 32000;
3740: wf_notification.clob_chunk := 0;
3741: while not (end_of_text) loop
3742: wf_notification.readattrclob(nid, aname, doctext, end_of_text);

Line 3752: dbms_lob.createTemporary(blob_loc, FALSE, dbms_lob.call);

3748: -- BINARY Document
3749: if (l_encoding is not null) 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

Line 3762: htp.p('Content-length: ' || dbms_lob.getlength(blob_loc));

3758: l_filename := aname || '.' || l_extension;
3759: end if;
3760: htp.p('Content-type: '||l_mime_type);
3761: htp.p('Content-Disposition: attachment; filename="'||l_filename||'"');
3762: htp.p('Content-length: ' || dbms_lob.getlength(blob_loc));
3763: htp.p('');
3764: -- owa_util.http_header_close;
3765:
3766: wpg_docload.download_file(blob_loc);

Line 3767: dbms_lob.freeTemporary(blob_loc);

3763: htp.p('');
3764: -- owa_util.http_header_close;
3765:
3766: wpg_docload.download_file(blob_loc);
3767: dbms_lob.freeTemporary(blob_loc);
3768: end if;
3769: else
3770: -- This provides limited binary document support. It assumes that the document in
3771: -- stored as raw in varchar.

Line 3773: lobsize := dbms_lob.getlength(clob_loc);

3769: else
3770: -- This provides limited binary document support. It assumes that the document in
3771: -- stored as raw in varchar.
3772: owa_util.mime_header(l_mime_type, TRUE);
3773: lobsize := dbms_lob.getlength(clob_loc);
3774: amount := 32000;
3775: wf_notification.clob_chunk := 0;
3776: while not (end_of_text) loop
3777: wf_notification.readattrclob(nid, aname, doctext, end_of_text);

Line 3783: dbms_lob.createTemporary(blob_loc, false, dbms_lob.call);

3779: end loop;
3780: end if;
3781: else
3782: -- attr_name is null try for a PLSQLBLOB document
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);

Line 3795: htp.p('Content-length: ' || dbms_lob.getlength(blob_loc));

3791: end if;
3792: -- owa_util.mime_header(doctype, FALSE);
3793: htp.p('Content-type: '||l_mime_type);
3794: htp.p('Content-Disposition: attachment; filename="'||l_filename||'"');
3795: htp.p('Content-length: ' || dbms_lob.getlength(blob_loc));
3796: htp.p('');
3797: -- owa_util.http_header_close;
3798:
3799: wpg_docload.download_file(blob_loc);

Line 3800: dbms_lob.freeTemporary(blob_loc);

3796: htp.p('');
3797: -- owa_util.http_header_close;
3798:
3799: wpg_docload.download_file(blob_loc);
3800: dbms_lob.freeTemporary(blob_loc);
3801: end if;
3802:
3803: else
3804: -- Set page title