APPS.PO_NEGOTIATIONS_SV2 dependencies on DBMS_LOB

Line 1776: l_lang_context integer := DBMS_LOB.DEFAULT_LANG_CTX;

1772: l_pk2 NUMBER;
1773: l_blob_text BLOB;
1774: l_dest_offset integer := 1;
1775: l_source_offset integer := 1;
1776: l_lang_context integer := DBMS_LOB.DEFAULT_LANG_CTX;
1777: l_warning integer := DBMS_LOB.WARN_INCONVERTIBLE_CHAR;
1778: l_file_name VARCHAR2(240);
1779: l_file_extn VARCHAR2(5) := 'htm';
1780: l_file_charset VARCHAR2(50) := 'UTF8';

Line 1777: l_warning integer := DBMS_LOB.WARN_INCONVERTIBLE_CHAR;

1773: l_blob_text BLOB;
1774: l_dest_offset integer := 1;
1775: l_source_offset integer := 1;
1776: l_lang_context integer := DBMS_LOB.DEFAULT_LANG_CTX;
1777: l_warning integer := DBMS_LOB.WARN_INCONVERTIBLE_CHAR;
1778: l_file_name VARCHAR2(240);
1779: l_file_extn VARCHAR2(5) := 'htm';
1780: l_file_charset VARCHAR2(50) := 'UTF8';
1781: l_file_content_type VARCHAR2(50) := 'text/html';

Line 1819: DBMS_LOB.CREATETEMPORARY(l_blob_text,true);

1815: , x_media_id => l_media_id -- IN/OUT
1816: , x_file_name => l_file_name
1817: );
1818: -- Insert into FND_LOBS ------------------------------------
1819: DBMS_LOB.CREATETEMPORARY(l_blob_text,true);
1820: DBMS_LOB.CONVERTTOBLOB(l_blob_text,p_clob_text,DBMS_LOB.LOBMAXSIZE,l_dest_offset,l_source_offset,DBMS_LOB.DEFAULT_CSID,l_lang_context,l_warning);
1821: INSERT INTO fnd_lobs(file_id,
1822: file_name,
1823: file_content_type,

Line 1820: DBMS_LOB.CONVERTTOBLOB(l_blob_text,p_clob_text,DBMS_LOB.LOBMAXSIZE,l_dest_offset,l_source_offset,DBMS_LOB.DEFAULT_CSID,l_lang_context,l_warning);

1816: , x_file_name => l_file_name
1817: );
1818: -- Insert into FND_LOBS ------------------------------------
1819: DBMS_LOB.CREATETEMPORARY(l_blob_text,true);
1820: DBMS_LOB.CONVERTTOBLOB(l_blob_text,p_clob_text,DBMS_LOB.LOBMAXSIZE,l_dest_offset,l_source_offset,DBMS_LOB.DEFAULT_CSID,l_lang_context,l_warning);
1821: INSERT INTO fnd_lobs(file_id,
1822: file_name,
1823: file_content_type,
1824: file_data,