APPS.PAY_JP_UITE_REPORT_PKG dependencies on DBMS_LOB

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

572:
573: --
574: LOOP
575: lc_xml_string1 := NULL;
576: dbms_lob.read(l_final_xml_string,ln_amount,ln_offset,lc_xml_string1);
577: pay_core_files.write_to_magtape_lob(lc_xml_string1);
578: ln_offset := ln_offset + ln_amount ;
579: END LOOP;
580: --

Line 1393: dbms_lob.read( p_clob

1389: ln_chars := 240;
1390: ln_offset := 1;
1391: LOOP
1392: lc_buf := NULL;
1393: dbms_lob.read( p_clob
1394: , ln_chars
1395: , ln_offset
1396: , lc_buf
1397: );

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

1443: IF gb_debug THEN
1444: hr_utility.trace('Entering WRITETOCLOB');
1445: END IF;
1446: --
1447: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1448: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1449: --
1450: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1451: LOOP

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

1444: hr_utility.trace('Entering WRITETOCLOB');
1445: END IF;
1446: --
1447: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1448: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1449: --
1450: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1451: LOOP
1452: dbms_lob.writeAppend(g_xfdf_string

Line 1452: dbms_lob.writeAppend(g_xfdf_string

1448: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);
1449: --
1450: FOR ln_ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1451: LOOP
1452: dbms_lob.writeAppend(g_xfdf_string
1453: ,LENGTH(vxmltable(ln_ctr_table).xmlstring)
1454: ,vxmltable(ln_ctr_table).xmlstring );
1455: END LOOP;
1456: p_write_xml := g_xfdf_string;

Line 1462: dbms_lob.close(g_xfdf_string);

1458: IF gb_debug THEN
1459: hr_utility.set_location('Out of loop ', 99);
1460: END IF;
1461: --
1462: dbms_lob.close(g_xfdf_string);
1463: IF gb_debug THEN
1464: hr_utility.trace('Leaving WRITETOCLOB');
1465: END IF;
1466: --