APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on DBMS_LOB

Line 54: IF dbms_lob.getLength (p_blob) IS NOT NULL THEN

50: *****************************************************************************/
51:
52: PROCEDURE WRITE_TO_MAGTAPE_LOB(p_blob BLOB) IS
53: BEGIN
54: IF dbms_lob.getLength (p_blob) IS NOT NULL THEN
55: pay_core_files.write_to_magtape_lob (p_blob);
56: END IF;
57: END WRITE_TO_MAGTAPE_LOB;
58:

Line 717: dbms_lob.createTemporary(l_xml_dummy, true, dbms_lob.session);

713: ,l_national_identifier
714: ,ltr_xml_dummy_tab) ;
715: hr_utility.trace('After Calling generate_xml_dummy');
716:
717: dbms_lob.createTemporary(l_xml_dummy, true, dbms_lob.session);
718:
719: FOR cntr IN ltr_xml_dummy_tab.first()..ltr_xml_dummy_tab.last()
720: LOOP
721: hr_utility.trace('Accessing..' || ltr_xml_dummy_tab(cntr));

Line 726: dbms_lob.writeAppend(l_xml_dummy,

722:
723: lr_xml_dummy := utl_raw.cast_to_raw(ltr_xml_dummy_tab(cntr));
724: ln_amt_dummy := utl_raw.length(lr_xml_dummy);
725:
726: dbms_lob.writeAppend(l_xml_dummy,
727: ln_amt_dummy,
728: lr_xml_dummy);
729: END LOOP;
730:

Line 750: dbms_lob.freeTemporary(l_xml_dummy);

746: WHEN OTHERS THEN
747: hr_utility.trace('Update Unsuccessful..');
748: END;
749: print_blob(pay_mag_tape.g_blob_value);
750: dbms_lob.freeTemporary(l_xml_dummy);
751:
752: END IF;
753:
754: hr_utility.trace('Leaving pay_archive_chequewriter.generate_xml');