APPS.POR_UTIL_PKG dependencies on DBMS_LOB

Line 6108: l_document_length := dbms_lob.GetLength(l_document);

6104: FROM fnd_lobs fl, fnd_documents fd, fnd_attached_documents fad
6105: WHERE fad.document_id = fd.document_id AND fd.media_id = fl.file_id
6106: AND fad.entity_name = 'REQ_HEADS' AND fad.pk1_value = l_document_id;
6107:
6108: l_document_length := dbms_lob.GetLength(l_document);
6109: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
6110: document_type :='application/pdf; name='|| l_filename;
6111:
6112: EXCEPTION

Line 6109: dbms_lob.copy(document, l_document, l_document_length, 1, 1);

6105: WHERE fad.document_id = fd.document_id AND fd.media_id = fl.file_id
6106: AND fad.entity_name = 'REQ_HEADS' AND fad.pk1_value = l_document_id;
6107:
6108: l_document_length := dbms_lob.GetLength(l_document);
6109: dbms_lob.copy(document, l_document, l_document_length, 1, 1);
6110: document_type :='application/pdf; name='|| l_filename;
6111:
6112: EXCEPTION
6113: WHEN OTHERS THEN

Line 6118: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));

6114: x_progress := 'POR_UTIL_PKG.pdf_attach_mipr - Exception ';
6115:
6116: document_type := 'text/html';
6117: l_message := fnd_message.get_string('PO', 'PO_PDF_FAILED');
6118: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
6119: END pdf_attach_mipr;
6120:
6121: PROCEDURE insert_action_in_mipr_history(p_document_id in number,
6122: p_action_code in varchar2,