APPS.PAY_DIRECT_DEPOSIT_XML dependencies on DBMS_LOB

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

107: *****************************************************************************/
108:
109: PROCEDURE WRITE_TO_MAGTAPE_LOB(p_blob BLOB) IS
110: BEGIN
111: IF dbms_lob.getLength (p_blob) IS NOT NULL THEN
112: pay_core_files.write_to_magtape_lob (p_blob);
113: END IF;
114: END WRITE_TO_MAGTAPE_LOB;
115:

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

356:
357: pay_payroll_xml_extract_pkg.load_xml('CE','DEPOSIT_DETAILS','');
358:
359: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
360: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
361: FOR cntr IN
362: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
363: lr_xml := utl_raw.cast_to_raw(
364: pay_payroll_xml_extract_pkg.g_xml_table(cntr));

Line 367: dbms_lob.writeAppend(l_xml,

363: lr_xml := utl_raw.cast_to_raw(
364: pay_payroll_xml_extract_pkg.g_xml_table(cntr));
365: ln_amt := utl_raw.length(lr_xml);
366:
367: dbms_lob.writeAppend(l_xml,
368: ln_amt,
369: lr_xml);
370:
371: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));

Line 378: dbms_lob.freeTemporary(l_xml);

374:
375: END IF;
376:
377: write_to_magtape_lob (l_xml);
378: dbms_lob.freeTemporary(l_xml);
379:
380: hr_utility_trace ('BLOB contents for assignment action '||
381: ln_assignment_action_id);
382: print_blob (pay_mag_tape.g_blob_value);

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

551: pay_payroll_xml_extract_pkg.load_xml('D','DEPOSIT_DATE',lv_dd_date);
552: pay_payroll_xml_extract_pkg.load_xml('D','CURRENCY',g_currency_code);
553:
554: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
555: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
556: FOR cntr IN
557: pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
558: lr_xml := utl_raw.cast_to_raw(
559: pay_payroll_xml_extract_pkg.g_xml_table(cntr));

Line 562: dbms_lob.writeAppend(l_xml,

558: lr_xml := utl_raw.cast_to_raw(
559: pay_payroll_xml_extract_pkg.g_xml_table(cntr));
560: ln_amt := utl_raw.length(lr_xml);
561:
562: dbms_lob.writeAppend(l_xml,
563: ln_amt,
564: lr_xml);
565:
566: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));

Line 572: dbms_lob.freeTemporary(l_xml);

568: pay_payroll_xml_extract_pkg.g_xml_table.delete();
569:
570: END IF;
571: write_to_magtape_lob (l_xml);
572: dbms_lob.freeTemporary(l_xml);
573:
574: pay_payroll_xml_extract_pkg.g_custom_params.DELETE;
575: ln_param_count := pay_payroll_xml_extract_pkg.g_custom_params.COUNT;
576: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_name := 'p_xml_level';