APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on DBMS_LOB

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

77: *****************************************************************************/
78:
79: PROCEDURE WRITE_TO_MAGTAPE_LOB(p_blob BLOB) IS
80: BEGIN
81: IF dbms_lob.getLength (p_blob) IS NOT NULL THEN
82: pay_core_files.write_to_magtape_lob (p_blob);
83: END IF;
84: END WRITE_TO_MAGTAPE_LOB;
85:

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

991: ,ltr_xml_dummy_tab
992: ,lv_legislation_code) ; /* bug 13773808*/
993: hr_utility.trace('After Calling generate_xml_dummy');
994:
995: dbms_lob.createTemporary(l_xml_dummy, true, dbms_lob.session);
996:
997: FOR cntr IN ltr_xml_dummy_tab.first()..ltr_xml_dummy_tab.last()
998: LOOP
999: hr_utility.trace('Accessing..' || ltr_xml_dummy_tab(cntr));

Line 1004: dbms_lob.writeAppend(l_xml_dummy,

1000:
1001: lr_xml_dummy := utl_raw.cast_to_raw(ltr_xml_dummy_tab(cntr));
1002: ln_amt_dummy := utl_raw.length(lr_xml_dummy);
1003:
1004: dbms_lob.writeAppend(l_xml_dummy,
1005: ln_amt_dummy,
1006: lr_xml_dummy);
1007: END LOOP;
1008:

Line 1028: dbms_lob.freeTemporary(l_xml_dummy);

1024: WHEN OTHERS THEN
1025: hr_utility.trace('Update Unsuccessful..');
1026: END;
1027: print_blob(pay_mag_tape.g_blob_value);
1028: dbms_lob.freeTemporary(l_xml_dummy);
1029:
1030: END IF;
1031:
1032: hr_utility.trace('Leaving pay_archive_chequewriter.generate_xml');