DBA Data[Home] [Help]

APPS.PAY_US_941_REPORT dependencies on DBMS_LOB

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

1474: IS
1475: l_xfdf_string CLOB;
1476: BEGIN
1477: hr_utility.set_location('Entered Procedure Write to clob ',100);
1478: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1479: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1480: -- if vXMLTable.count > 0 then
1481: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1482: LOOP

Line 1479: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

1475: l_xfdf_string CLOB;
1476: BEGIN
1477: hr_utility.set_location('Entered Procedure Write to clob ',100);
1478: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1479: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1480: -- if vXMLTable.count > 0 then
1481: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1482: LOOP
1483: dbms_lob.writeAppend(l_xfdf_string,

Line 1483: dbms_lob.writeAppend(l_xfdf_string,

1479: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1480: -- if vXMLTable.count > 0 then
1481: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1482: LOOP
1483: dbms_lob.writeAppend(l_xfdf_string,
1484: LENGTH(vXMLTable(ctr_table).xmlstring),
1485: vXMLTable(ctr_table).xmlstring );
1486: END LOOP;
1487: p_XML := l_xfdf_string;