APPS.PAY_DIRECT_DEPOSIT_XML dependencies on DBMS_LOB

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

111: *****************************************************************************/
112:
113: PROCEDURE WRITE_TO_MAGTAPE_LOB(p_blob BLOB) IS
114: BEGIN
115: IF dbms_lob.getLength (p_blob) IS NOT NULL THEN
116: pay_core_files.write_to_magtape_lob (p_blob);
117: END IF;
118: END WRITE_TO_MAGTAPE_LOB;
119:

Line 373: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);

369:
370: pay_payroll_xml_extract_pkg.load_xml('CE','DEPOSIT_DETAILS','');
371:
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));

Line 380: dbms_lob.writeAppend(l_xml,

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);
383:
384: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));

Line 391: dbms_lob.freeTemporary(l_xml);

387:
388: END IF;
389:
390: write_to_magtape_lob (l_xml);
391: dbms_lob.freeTemporary(l_xml);
392:
393: hr_utility_trace ('BLOB contents for assignment action '||
394: ln_assignment_action_id);
395: print_blob (pay_mag_tape.g_blob_value);

Line 569: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);

565: pay_payroll_xml_extract_pkg.load_xml('D','DEPOSIT_DATE',lv_dd_date);
566: pay_payroll_xml_extract_pkg.load_xml('D','CURRENCY',g_currency_code);
567:
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));

Line 576: dbms_lob.writeAppend(l_xml,

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);
579:
580: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));

Line 586: dbms_lob.freeTemporary(l_xml);

582: pay_payroll_xml_extract_pkg.g_xml_table.delete();
583:
584: END IF;
585: write_to_magtape_lob (l_xml);
586: dbms_lob.freeTemporary(l_xml);
587:
588: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;
589: ln_param_count := pay_payroll_xml_extract_pkg.g_custom_params.COUNT;
590: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name := 'p_xml_level';