372: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
373: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
374: FOR cntr IN
375: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
376: lr_xml := utl_raw.cast_to_raw(
377: pay_payroll_xml_extract_pkg.g_xml_table(cntr));
378: ln_amt := utl_raw.length(lr_xml);
379:
380: dbms_lob.writeAppend(l_xml,
374: FOR cntr IN
375: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
376: lr_xml := utl_raw.cast_to_raw(
377: pay_payroll_xml_extract_pkg.g_xml_table(cntr));
378: ln_amt := utl_raw.length(lr_xml);
379:
380: dbms_lob.writeAppend(l_xml,
381: ln_amt,
382: lr_xml);
568: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
569: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
570: FOR cntr IN
571: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
572: lr_xml := utl_raw.cast_to_raw(
573: pay_payroll_xml_extract_pkg.g_xml_table(cntr));
574: ln_amt := utl_raw.length(lr_xml);
575:
576: dbms_lob.writeAppend(l_xml,
570: FOR cntr IN
571: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
572: lr_xml := utl_raw.cast_to_raw(
573: pay_payroll_xml_extract_pkg.g_xml_table(cntr));
574: ln_amt := utl_raw.length(lr_xml);
575:
576: dbms_lob.writeAppend(l_xml,
577: ln_amt,
578: lr_xml);