APPS.PAY_US_XDO_REPORT dependencies on DBMS_LOB

Line 1778: DBMS_LOB.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);

1774: BEGIN
1775: l_proc_name := g_proc_name || 'WRITE_TO_CLOB';
1776: hr_utility.trace ('Entering '|| l_proc_name);
1777:
1778: DBMS_LOB.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1779: DBMS_LOB.open(l_xfdf_string,dbms_lob.lob_readwrite);
1780:
1781: IF vXMLTable.count > 0 THEN
1782: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

Line 1779: DBMS_LOB.open(l_xfdf_string,dbms_lob.lob_readwrite);

1775: l_proc_name := g_proc_name || 'WRITE_TO_CLOB';
1776: hr_utility.trace ('Entering '|| l_proc_name);
1777:
1778: DBMS_LOB.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1779: DBMS_LOB.open(l_xfdf_string,dbms_lob.lob_readwrite);
1780:
1781: IF vXMLTable.count > 0 THEN
1782: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
1783: dbms_lob.writeAppend(l_xfdf_string,

Line 1783: dbms_lob.writeAppend(l_xfdf_string,

1779: DBMS_LOB.open(l_xfdf_string,dbms_lob.lob_readwrite);
1780:
1781: IF vXMLTable.count > 0 THEN
1782: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
1783: dbms_lob.writeAppend(l_xfdf_string,
1784: LENGTH(vXMLTable(ctr_table).xmlstring),
1785: vXMLTable(ctr_table).xmlstring );
1786: END LOOP;
1787: END IF;

Line 1789: DBMS_LOB.createtemporary(p_xfdf_blob,TRUE);

1785: vXMLTable(ctr_table).xmlstring );
1786: END LOOP;
1787: END IF;
1788:
1789: DBMS_LOB.createtemporary(p_xfdf_blob,TRUE);
1790: clob_to_blob(l_xfdf_string,p_xfdf_blob);
1791:
1792: hr_utility.trace ('Leaving '|| l_proc_name);
1793: EXCEPTION

Line 1823: l_length_clob := dbms_lob.getlength(p_clob);

1819: BEGIN
1820: l_proc_name := g_proc_name || 'CLOB_TO_BLOB';
1821: hr_utility.trace ('Entering '|| l_proc_name);
1822:
1823: l_length_clob := dbms_lob.getlength(p_clob);
1824: l_offset := 1;
1825:
1826: WHILE l_length_clob > 0
1827: LOOP

Line 1836: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);

1832: ELSE
1833: l_chunk_len := l_buffer_len;
1834: END IF;
1835:
1836: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
1837: l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
1838: l_raw_length := utl_raw.length(l_raw_buffer); /* 7182157 */
1839: /*Commented the following trace sentence
1840: This used to create issues when we were asking

Line 1844: -- DBMS_LOB.writeappend(p_blob,l_chunk_len,l_raw_buffer); /* 7182157 */

1840: This used to create issues when we were asking
1841: traces from the customers
1842: */
1843: --hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1844: -- DBMS_LOB.writeappend(p_blob,l_chunk_len,l_raw_buffer); /* 7182157 */
1845: DBMS_LOB.writeappend(p_blob,l_raw_length,l_raw_buffer); /* 7182157 */
1846: l_offset := l_offset + l_chunk_len;
1847: l_length_clob := l_length_clob - l_chunk_len;
1848:

Line 1845: DBMS_LOB.writeappend(p_blob,l_raw_length,l_raw_buffer); /* 7182157 */

1841: traces from the customers
1842: */
1843: --hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1844: -- DBMS_LOB.writeappend(p_blob,l_chunk_len,l_raw_buffer); /* 7182157 */
1845: DBMS_LOB.writeappend(p_blob,l_raw_length,l_raw_buffer); /* 7182157 */
1846: l_offset := l_offset + l_chunk_len;
1847: l_length_clob := l_length_clob - l_chunk_len;
1848:
1849: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

Line 1849: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

1845: DBMS_LOB.writeappend(p_blob,l_raw_length,l_raw_buffer); /* 7182157 */
1846: l_offset := l_offset + l_chunk_len;
1847: l_length_clob := l_length_clob - l_chunk_len;
1848:
1849: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
1850: END LOOP;
1851:
1852: hr_utility.trace ('Leaving '|| l_proc_name);
1853: END CLOB_TO_BLOB;