APPS.WFA_HTML dependencies on DBMS_LOB

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

1588: doctext := wf_notification.getattrdoc(nid, aname,wf_notification.doc_html);
1589:
1590: -- if the attribute wasn't translated then try to translate for plsqlclobs.
1591: if doctext = '&'||aname then
1592: dbms_lob.createTemporary(clob_loc, false, dbms_lob.call);
1593: Wf_Notification.GetAttrCLOB(nid, aname, wf_notification.doc_html,
1594: clob_loc, doctype, attr_name);
1595: if (doctype is not null) then
1596: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);

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

1608: wfa_sec.Header(FALSE, '',wf_core.translate('WFITD_ATTR_TYPE_DOCUMENT'),
1609: TRUE);
1610: htp.br;
1611:
1612: lobsize := dbms_lob.getlength(clob_loc);
1613: amount := 32000;
1614: wf_notification.clob_chunk := 0;
1615: while not (end_of_text) loop
1616: wf_notification.readattrclob(nid, aname, doctext, end_of_text);

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

1622: -- BINARY Document
1623: if (l_encoding is not null) then
1624: -- Decode base64 encoded content
1625: if (upper(trim(l_encoding)) = 'BASE64') then
1626: dbms_lob.createTemporary(blob_loc, FALSE, dbms_lob.call);
1627:
1628: wf_mail_util.decodeBLOB(clob_loc, blob_loc);
1629: -- owa_util.mime_header(doctype, FALSE);
1630: -- Write appropriate headers before downloading the document

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

1632: l_filename := aname || '.' || l_extension;
1633: end if;
1634: htp.p('Content-type: '||l_mime_type);
1635: htp.p('Content-Disposition: attachment; filename="'||l_filename||'"');
1636: htp.p('Content-length: ' || dbms_lob.getlength(blob_loc));
1637: htp.p('');
1638: -- owa_util.http_header_close;
1639:
1640: wpg_docload.download_file(blob_loc);

Line 1641: dbms_lob.freeTemporary(blob_loc);

1637: htp.p('');
1638: -- owa_util.http_header_close;
1639:
1640: wpg_docload.download_file(blob_loc);
1641: dbms_lob.freeTemporary(blob_loc);
1642: end if;
1643: else
1644: -- This provides limited binary document support. It assumes that the document in
1645: -- stored as raw in varchar.

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

1643: else
1644: -- This provides limited binary document support. It assumes that the document in
1645: -- stored as raw in varchar.
1646: owa_util.mime_header(l_mime_type, TRUE);
1647: lobsize := dbms_lob.getlength(clob_loc);
1648: amount := 32000;
1649: wf_notification.clob_chunk := 0;
1650: while not (end_of_text) loop
1651: wf_notification.readattrclob(nid, aname, doctext, end_of_text);

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

1653: end loop;
1654: end if;
1655: else
1656: -- attr_name is null try for a PLSQLBLOB document
1657: dbms_lob.createTemporary(blob_loc, false, dbms_lob.call);
1658: Wf_Notification.GetAttrBLOB(nid, aname, wf_notification.doc_html,
1659: blob_loc, doctype, attr_name);
1660: if (doctype is not null) then
1661: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);

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

1665: end if;
1666: -- owa_util.mime_header(doctype, FALSE);
1667: htp.p('Content-type: '||l_mime_type);
1668: htp.p('Content-Disposition: attachment; filename="'||l_filename||'"');
1669: htp.p('Content-length: ' || dbms_lob.getlength(blob_loc));
1670: htp.p('');
1671: -- owa_util.http_header_close;
1672:
1673: wpg_docload.download_file(blob_loc);

Line 1674: dbms_lob.freeTemporary(blob_loc);

1670: htp.p('');
1671: -- owa_util.http_header_close;
1672:
1673: wpg_docload.download_file(blob_loc);
1674: dbms_lob.freeTemporary(blob_loc);
1675: end if;
1676:
1677: else
1678: -- Set page title