APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on DBMS_LOB

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

886: ret := dbms_sql.execute(csr);
887: dbms_sql.close_cursor(csr);
888:
889: IF g_xml_table.count() <> 0 THEN
890: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
891: FOR cntr IN g_xml_table.first()..g_xml_table.last() LOOP
892: lr_xml := utl_raw.cast_to_raw(g_xml_table(cntr));
893: ln_amt := utl_raw.length(lr_xml);
894:

Line 895: dbms_lob.writeAppend(l_xml,

891: FOR cntr IN g_xml_table.first()..g_xml_table.last() LOOP
892: lr_xml := utl_raw.cast_to_raw(g_xml_table(cntr));
893: ln_amt := utl_raw.length(lr_xml);
894:
895: dbms_lob.writeAppend(l_xml,
896: ln_amt,
897: lr_xml);
898:
899: hr_utility_trace (g_xml_table(cntr));

Line 902: dbms_lob.freeTemporary(l_xml);

898:
899: hr_utility_trace (g_xml_table(cntr));
900: END LOOP;
901: p_xml := l_xml;
902: dbms_lob.freeTemporary(l_xml);
903: END IF;
904:
905: print_blob (p_xml);
906:

Line 1003: dbms_lob.createTemporary (l_xml,

999: END LOOP;
1000: END IF;
1001:
1002: IF p_action_inf_id_tab.count() > 0 THEN
1003: dbms_lob.createTemporary (l_xml,
1004: TRUE,
1005: dbms_lob.SESSION);
1006: FOR cntr_arch_rec IN
1007: p_action_inf_id_tab.first()..p_action_inf_id_tab.last()

Line 1005: dbms_lob.SESSION);

1001:
1002: IF p_action_inf_id_tab.count() > 0 THEN
1003: dbms_lob.createTemporary (l_xml,
1004: TRUE,
1005: dbms_lob.SESSION);
1006: FOR cntr_arch_rec IN
1007: p_action_inf_id_tab.first()..p_action_inf_id_tab.last()
1008: LOOP
1009: l_last_param := pay_payroll_xml_extract_pkg.g_custom_params.last();

Line 1031: dbms_lob.append(l_xml,

1027: NULL,
1028: p_document_type,
1029: l_xml_temp);
1030:
1031: dbms_lob.append(l_xml,
1032: l_xml_temp);
1033:
1034: /* Remove the parameter 'action_information_id' before the next
1035: iteration (or returning to the calling program). Calling

Line 1042: dbms_lob.freeTemporary(l_xml);

1038: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1039: pay_payroll_xml_extract_pkg.g_custom_params.last());
1040: END LOOP;
1041: p_xml := l_xml;
1042: dbms_lob.freeTemporary(l_xml);
1043: END IF;
1044:
1045: hr_utility_trace ('Leaving '||l_proc_name);
1046: