APPS.PER_JP_WRKREG_REPORT_PKG dependencies on DBMS_LOB

Line 225: dbms_lob.read( p_clob

221: ln_chars := 240;
222: ln_offset := 1;
223: LOOP
224: lc_buf := NULL;
225: dbms_lob.read( p_clob
226: , ln_chars
227: , ln_offset
228: , lc_buf
229: );

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

1533: THEN
1534: hr_utility.trace('Entering WRITETOCLOB');
1535: END IF;
1536: --
1537: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1538: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1539: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1540: LOOP
1541: dbms_lob.writeAppend(g_xfdf_string

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

1534: hr_utility.trace('Entering WRITETOCLOB');
1535: END IF;
1536: --
1537: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1538: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1539: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1540: LOOP
1541: dbms_lob.writeAppend(g_xfdf_string
1542: ,LENGTH(vxmltable(ln_ctr_table).xmlstring)

Line 1541: dbms_lob.writeAppend(g_xfdf_string

1537: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1538: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1539: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1540: LOOP
1541: dbms_lob.writeAppend(g_xfdf_string
1542: ,LENGTH(vxmltable(ln_ctr_table).xmlstring)
1543: ,vxmltable(ln_ctr_table).xmlstring );
1544: END LOOP;
1545: p_write_xml := g_xfdf_string;

Line 1552: dbms_lob.close(g_xfdf_string);

1548: THEN
1549: hr_utility.set_location('Out of loop ', 99);
1550: END IF;
1551: --
1552: dbms_lob.close(g_xfdf_string);
1553: IF gb_debug
1554: THEN
1555: hr_utility.trace('Leaving WRITETOCLOB');
1556: END IF;

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

1683: ln_amount := 500;
1684: --
1685: LOOP
1686: lc_xml_string1 := NULL;
1687: dbms_lob.read(l_final_xml_string,ln_amount,ln_offset,lc_xml_string1);
1688: pay_core_files.write_to_magtape_lob(lc_xml_string1);
1689: ln_offset := ln_offset + ln_amount ;
1690: END LOOP;
1691: --