APPS.PAY_NO_SUPPORT_ORDER dependencies on DBMS_LOB

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

1276: l_xfdf_string clob;
1277:
1278: BEGIN
1279:
1280: dbms_lob.createtemporary(p_xml,false,dbms_lob.call);
1281: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
1282:
1283: if xml_tab.count > 0 then
1284: for ctr_table in xml_tab.first .. xml_tab.last loop

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

1277:
1278: BEGIN
1279:
1280: dbms_lob.createtemporary(p_xml,false,dbms_lob.call);
1281: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
1282:
1283: if xml_tab.count > 0 then
1284: for ctr_table in xml_tab.first .. xml_tab.last loop
1285: dbms_lob.writeappend( p_xml, length(xml_tab(ctr_table).xmlstring), xml_tab(ctr_table).xmlstring );

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

1281: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
1282:
1283: if xml_tab.count > 0 then
1284: for ctr_table in xml_tab.first .. xml_tab.last loop
1285: dbms_lob.writeappend( p_xml, length(xml_tab(ctr_table).xmlstring), xml_tab(ctr_table).xmlstring );
1286: end loop;
1287: end if;
1288:
1289: --dbms_lob.createtemporary(p_xml,true);

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

1285: dbms_lob.writeappend( p_xml, length(xml_tab(ctr_table).xmlstring), xml_tab(ctr_table).xmlstring );
1286: end loop;
1287: end if;
1288:
1289: --dbms_lob.createtemporary(p_xml,true);
1290: --clob_to_blob(l_xfdf_string,p_xml);
1291:
1292: exception
1293: when others then