APPS.PAY_NO_UNION_DUES dependencies on DBMS_LOB

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

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

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

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

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

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

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

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