APPS.PER_ZA_WSP_XML_GEN_PKG dependencies on DBMS_LOB

Line 1046: dbms_lob.createtemporary(p_xml, true);

1042: update_atr_data(rec.legal_entity_id, p_payroll_action_id);
1043: end loop;
1044:
1045: -- Update out variable p_xml and release xml dom
1046: dbms_lob.createtemporary(p_xml, true);
1047: xmldom.writeToClob(g_xml_dom, p_xml);
1048: xmldom.freeDocument(g_xml_dom);
1049: -- open the file p_xml
1050: -- Why ? In the Core wrapper package(PAY_XML_GEN_PKG) this is being closed

Line 1051: dbms_lob.open(p_xml, dbms_lob.lob_readonly);

1047: xmldom.writeToClob(g_xml_dom, p_xml);
1048: xmldom.freeDocument(g_xml_dom);
1049: -- open the file p_xml
1050: -- Why ? In the Core wrapper package(PAY_XML_GEN_PKG) this is being closed
1051: dbms_lob.open(p_xml, dbms_lob.lob_readonly);
1052:
1053: hr_utility.set_location('Leaving ' || l_proc, 10);
1054:
1055: -- hr_utility.trace_off;