APPS.PAY_NO_EOY_ARCHIVE dependencies on DBMS_LOB

Line 269: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

265: -- l_str1 := ' ';
266: -- l_str1 := ' ';
267: l_str1 := '' ;
268:
269: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
270: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
271: --
272: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
273: --

Line 270: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);

266: -- l_str1 := ' ';
267: l_str1 := '' ;
268:
269: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
270: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
271: --
272: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
273: --
274: IF g_xml_element_table.COUNT > 0 THEN

Line 272: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);

268:
269: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
270: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
271: --
272: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
273: --
274: IF g_xml_element_table.COUNT > 0 THEN
275: --
276: FOR table_counter IN g_xml_element_table.FIRST .. g_xml_element_table.LAST LOOP

Line 311: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);

307:
308:
309: END IF;
310: --
311: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);
312: --
313: END LOOP;
314: --
315: END IF;

Line 317: -- dbms_lob.writeappend(l_clob, LENGTH(l_str2), l_str2);

313: END LOOP;
314: --
315: END IF;
316: --
317: -- dbms_lob.writeappend(l_clob, LENGTH(l_str2), l_str2);
318: --
319: p_clob := l_clob;
320: --
321: EXCEPTION