APPS.PAY_NO_UNION_DUES dependencies on DBMS_LOB

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

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

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

925: l_xfdf_string clob;
926: begin
927:
928: dbms_lob.createtemporary(p_xml,false,dbms_lob.call);
929: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
930: if xml_tab.count > 0 then
931: for ctr_table in xml_tab.first .. xml_tab.last loop
932: dbms_lob.writeappend( p_xml, length(xml_tab(ctr_table).xmlstring), xml_tab(ctr_table).xmlstring );
933: end loop;

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

928: dbms_lob.createtemporary(p_xml,false,dbms_lob.call);
929: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
930: if xml_tab.count > 0 then
931: for ctr_table in xml_tab.first .. xml_tab.last loop
932: dbms_lob.writeappend( p_xml, length(xml_tab(ctr_table).xmlstring), xml_tab(ctr_table).xmlstring );
933: end loop;
934: end if;
935: --dbms_lob.createtemporary(p_xml,true);
936: --clob_to_blob(l_xfdf_string,p_xml);

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

931: for ctr_table in xml_tab.first .. xml_tab.last loop
932: dbms_lob.writeappend( p_xml, length(xml_tab(ctr_table).xmlstring), xml_tab(ctr_table).xmlstring );
933: end loop;
934: end if;
935: --dbms_lob.createtemporary(p_xml,true);
936: --clob_to_blob(l_xfdf_string,p_xml);
937: exception
938: when others then
939: hr_utility.trace('sqleerm ' || sqlerrm);