APPS.PAY_NO_TAX_LEVY dependencies on DBMS_LOB

Line 933: dbms_lob.createtemporary(p_xml,false,dbms_lob.call);

929:
930: procedure write_to_clob (p_xml out nocopy clob) is
931: l_xfdf_string clob;
932: begin
933: dbms_lob.createtemporary(p_xml,false,dbms_lob.call);
934: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
935: if xml_tab.count > 0 then
936: for ctr_table in xml_tab.first .. xml_tab.last loop
937: dbms_lob.writeappend( p_xml, length(xml_tab(ctr_table).xmlstring), xml_tab(ctr_table).xmlstring );

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

930: procedure write_to_clob (p_xml out nocopy clob) is
931: l_xfdf_string clob;
932: begin
933: dbms_lob.createtemporary(p_xml,false,dbms_lob.call);
934: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
935: if xml_tab.count > 0 then
936: for ctr_table in xml_tab.first .. xml_tab.last loop
937: dbms_lob.writeappend( p_xml, length(xml_tab(ctr_table).xmlstring), xml_tab(ctr_table).xmlstring );
938: end loop;

Line 937: dbms_lob.writeappend( p_xml, length(xml_tab(ctr_table).xmlstring), xml_tab(ctr_table).xmlstring );

933: dbms_lob.createtemporary(p_xml,false,dbms_lob.call);
934: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
935: if xml_tab.count > 0 then
936: for ctr_table in xml_tab.first .. xml_tab.last loop
937: dbms_lob.writeappend( p_xml, length(xml_tab(ctr_table).xmlstring), xml_tab(ctr_table).xmlstring );
938: end loop;
939: end if;
940: --dbms_lob.createtemporary(p_xml,true);
941: --clob_to_blob(l_xfdf_string,p_xml);

Line 940: --dbms_lob.createtemporary(p_xml,true);

936: for ctr_table in xml_tab.first .. xml_tab.last loop
937: dbms_lob.writeappend( p_xml, length(xml_tab(ctr_table).xmlstring), xml_tab(ctr_table).xmlstring );
938: end loop;
939: end if;
940: --dbms_lob.createtemporary(p_xml,true);
941: --clob_to_blob(l_xfdf_string,p_xml);
942: exception
943: when others then
944: hr_utility.trace('sqleerm ' || sqlerrm);