APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on DBMS_LOB

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

4427: ret := dbms_sql.execute(csr);
4428: dbms_sql.close_cursor(csr);
4429:
4430: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
4431: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
4432: FOR cntr IN pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
4433: lr_xml := utl_raw.cast_to_raw(pay_payroll_xml_extract_pkg.g_xml_table(cntr));
4434: ln_amt := utl_raw.length(lr_xml);
4435:

Line 4436: dbms_lob.writeAppend(l_xml,

4432: FOR cntr IN pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
4433: lr_xml := utl_raw.cast_to_raw(pay_payroll_xml_extract_pkg.g_xml_table(cntr));
4434: ln_amt := utl_raw.length(lr_xml);
4435:
4436: dbms_lob.writeAppend(l_xml,
4437: ln_amt,
4438: lr_xml);
4439:
4440: hr_utility.trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));

Line 4443: dbms_lob.freeTemporary(l_xml);

4439:
4440: hr_utility.trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));
4441: END LOOP;
4442: p_xml := l_xml;
4443: dbms_lob.freeTemporary(l_xml);
4444: END IF;
4445:
4446: print_blob (p_xml);
4447: