APPS.PER_JP_EMPDET_REPORT_PKG dependencies on DBMS_LOB

Line 231: dbms_lob.read( p_clob

227: ln_chars := 240;
228: ln_offset := 1;
229: LOOP
230: lc_buf := NULL;
231: dbms_lob.read( p_clob
232: , ln_chars
233: , ln_offset
234: , lc_buf
235: );

Line 1839: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);

1835: gb_debug := hr_utility.debug_enabled;
1836: IF gb_debug THEN
1837: hr_utility.set_location('Entering writetoclob',20);
1838: END IF;
1839: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1840: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1841: --
1842: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1843: LOOP

Line 1840: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);

1836: IF gb_debug THEN
1837: hr_utility.set_location('Entering writetoclob',20);
1838: END IF;
1839: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1840: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1841: --
1842: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1843: LOOP
1844: dbms_lob.writeAppend(g_xfdf_string

Line 1844: dbms_lob.writeAppend(g_xfdf_string

1840: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1841: --
1842: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1843: LOOP
1844: dbms_lob.writeAppend(g_xfdf_string
1845: ,LENGTH(vxmltable(ln_ctr_table).xmlstring)
1846: ,vxmltable(ln_ctr_table).xmlstring );
1847: END LOOP;
1848: --

Line 1850: dbms_lob.close(g_xfdf_string);

1846: ,vxmltable(ln_ctr_table).xmlstring );
1847: END LOOP;
1848: --
1849: p_write_xml := g_xfdf_string;
1850: dbms_lob.close(g_xfdf_string);
1851: IF gb_debug THEN
1852: hr_utility.set_location('Out of loop ',99);
1853: hr_utility.set_location('Leaving writetoclob',20);
1854: END IF;

Line 2000: dbms_lob.read(l_final_xml_string,ln_amount,ln_offset,lc_xml_string1);

1996: --
1997: BEGIN
1998: LOOP
1999: lc_xml_string1 := NULL;
2000: dbms_lob.read(l_final_xml_string,ln_amount,ln_offset,lc_xml_string1);
2001: pay_core_files.write_to_magtape_lob(lc_xml_string1);
2002: ln_offset := ln_offset + ln_amount;
2003: END LOOP;
2004: EXCEPTION

Line 2037: dbms_lob.read(lblob_image,ln_amount_blob,ln_offset_blob,lc_xml_raw);

2033: BEGIN
2034: LOOP
2035: lc_xml_raw := '';
2036: lc_xml_varchar := NULL;
2037: dbms_lob.read(lblob_image,ln_amount_blob,ln_offset_blob,lc_xml_raw);
2038: lc_xml_varchar := utl_raw.cast_to_varchar2(utl_encode.base64_encode(lc_xml_raw));
2039: pay_core_files.write_to_magtape_lob(lc_xml_varchar);
2040: ln_offset_blob := ln_offset_blob + ln_amount_blob;
2041: END LOOP;