APPS.PAY_JP_IWHT_REPORT_PKG dependencies on DBMS_LOB

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

598:
599: --
600: LOOP
601: lc_xml_string1 := NULL;
602: dbms_lob.read(l_final_xml_string,ln_amount,ln_offset,lc_xml_string1);
603: pay_core_files.write_to_magtape_lob(lc_xml_string1);
604: ln_offset := ln_offset + ln_amount ;
605: END LOOP;
606: --

Line 1321: dbms_lob.read( p_clob

1317: ln_chars := 240;
1318: ln_offset := 1;
1319: LOOP
1320: lc_buf := NULL;
1321: dbms_lob.read( p_clob
1322: , ln_chars
1323: , ln_offset
1324: , lc_buf
1325: );

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

1371: IF gb_debug THEN
1372: hr_utility.trace('Entering WRITETOCLOB');
1373: END IF;
1374: --
1375: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1376: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1377: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1378: LOOP
1379: dbms_lob.writeAppend(g_xfdf_string

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

1372: hr_utility.trace('Entering WRITETOCLOB');
1373: END IF;
1374: --
1375: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1376: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1377: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1378: LOOP
1379: dbms_lob.writeAppend(g_xfdf_string
1380: ,LENGTH(vxmltable(ln_ctr_table).xmlstring)

Line 1379: dbms_lob.writeAppend(g_xfdf_string

1375: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1376: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1377: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1378: LOOP
1379: dbms_lob.writeAppend(g_xfdf_string
1380: ,LENGTH(vxmltable(ln_ctr_table).xmlstring)
1381: ,vxmltable(ln_ctr_table).xmlstring );
1382: END LOOP;
1383: p_write_xml := g_xfdf_string;

Line 1389: dbms_lob.close(g_xfdf_string);

1385: IF gb_debug THEN
1386: hr_utility.set_location('Out of loop ', 99);
1387: END IF;
1388: --
1389: dbms_lob.close(g_xfdf_string);
1390: IF gb_debug THEN
1391: hr_utility.trace('Leaving WRITETOCLOB');
1392: END IF;
1393: --