APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on DBMS_LOB

Line 1069: dbms_lob.createtemporary(p_xml,FALSE,DBMS_LOB.CALL);

1065: l_xfdf_string clob;
1066: l_str1 varchar2(6000);
1067: begin
1068: hr_utility.set_location('Entered Procedure Write to clob ',100);
1069: dbms_lob.createtemporary(p_xml,FALSE,DBMS_LOB.CALL);
1070: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
1071: if vXMLTable.count > 0 then
1072: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
1073: -- Bug 4705094

Line 1070: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);

1066: l_str1 varchar2(6000);
1067: begin
1068: hr_utility.set_location('Entered Procedure Write to clob ',100);
1069: dbms_lob.createtemporary(p_xml,FALSE,DBMS_LOB.CALL);
1070: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
1071: if vXMLTable.count > 0 then
1072: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
1073: -- Bug 4705094
1074: l_str1 := TO_UTF8(vXMLTable(ctr_table).xmlString);

Line 1075: dbms_lob.writeAppend( p_xml, length(l_str1), l_str1 );

1071: if vXMLTable.count > 0 then
1072: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
1073: -- Bug 4705094
1074: l_str1 := TO_UTF8(vXMLTable(ctr_table).xmlString);
1075: dbms_lob.writeAppend( p_xml, length(l_str1), l_str1 );
1076: END LOOP;
1077: end if;
1078: --DBMS_LOB.CREATETEMPORARY(p_xml,TRUE);
1079: --clob_to_blob(l_xfdf_string,p_xml);

Line 1078: --DBMS_LOB.CREATETEMPORARY(p_xml,TRUE);

1074: l_str1 := TO_UTF8(vXMLTable(ctr_table).xmlString);
1075: dbms_lob.writeAppend( p_xml, length(l_str1), l_str1 );
1076: END LOOP;
1077: end if;
1078: --DBMS_LOB.CREATETEMPORARY(p_xml,TRUE);
1079: --clob_to_blob(l_xfdf_string,p_xml);
1080: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
1081: EXCEPTION
1082: WHEN OTHERS then