APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on DBMS_LOB

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

1103: ret := dbms_sql.execute(csr);
1104: dbms_sql.close_cursor(csr);
1105:
1106: IF g_xml_table.count() <> 0 THEN
1107: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
1108: FOR cntr IN g_xml_table.first()..g_xml_table.last() LOOP
1109: lr_xml := utl_raw.cast_to_raw(g_xml_table(cntr));
1110: ln_amt := utl_raw.length(lr_xml);
1111:

Line 1112: dbms_lob.writeAppend(l_xml,

1108: FOR cntr IN g_xml_table.first()..g_xml_table.last() LOOP
1109: lr_xml := utl_raw.cast_to_raw(g_xml_table(cntr));
1110: ln_amt := utl_raw.length(lr_xml);
1111:
1112: dbms_lob.writeAppend(l_xml,
1113: ln_amt,
1114: lr_xml);
1115:
1116: hr_utility_trace (g_xml_table(cntr));

Line 1119: dbms_lob.freeTemporary(l_xml);

1115:
1116: hr_utility_trace (g_xml_table(cntr));
1117: END LOOP;
1118: p_xml := l_xml;
1119: dbms_lob.freeTemporary(l_xml);
1120: END IF;
1121:
1122: print_blob (p_xml);
1123:

Line 1220: dbms_lob.createTemporary (l_xml,

1216: END LOOP;
1217: END IF;
1218:
1219: IF p_action_inf_id_tab.count() > 0 THEN
1220: dbms_lob.createTemporary (l_xml,
1221: TRUE,
1222: dbms_lob.SESSION);
1223: FOR cntr_arch_rec IN
1224: p_action_inf_id_tab.first()..p_action_inf_id_tab.last()

Line 1222: dbms_lob.SESSION);

1218:
1219: IF p_action_inf_id_tab.count() > 0 THEN
1220: dbms_lob.createTemporary (l_xml,
1221: TRUE,
1222: dbms_lob.SESSION);
1223: FOR cntr_arch_rec IN
1224: p_action_inf_id_tab.first()..p_action_inf_id_tab.last()
1225: LOOP
1226: l_last_param := pay_payroll_xml_extract_pkg.g_custom_params.last();

Line 1248: dbms_lob.append(l_xml,

1244: NULL,
1245: p_document_type,
1246: l_xml_temp);
1247:
1248: dbms_lob.append(l_xml,
1249: l_xml_temp);
1250:
1251: /* Remove the parameter 'action_information_id' before the next
1252: iteration (or returning to the calling program). Calling

Line 1259: dbms_lob.freeTemporary(l_xml);

1255: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1256: pay_payroll_xml_extract_pkg.g_custom_params.last());
1257: END LOOP;
1258: p_xml := l_xml;
1259: dbms_lob.freeTemporary(l_xml);
1260: END IF;
1261:
1262: hr_utility_trace ('Leaving '||l_proc_name);
1263:

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

1658: ret := dbms_sql.execute(csr);
1659: dbms_sql.close_cursor(csr);
1660:
1661: IF g_xml_table.count() <> 0 THEN
1662: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
1663: FOR cntr IN g_xml_table.first()..g_xml_table.last() LOOP
1664: lr_xml := utl_raw.cast_to_raw(g_xml_table(cntr));
1665: ln_amt := utl_raw.length(lr_xml);
1666:

Line 1667: dbms_lob.writeAppend(l_xml,

1663: FOR cntr IN g_xml_table.first()..g_xml_table.last() LOOP
1664: lr_xml := utl_raw.cast_to_raw(g_xml_table(cntr));
1665: ln_amt := utl_raw.length(lr_xml);
1666:
1667: dbms_lob.writeAppend(l_xml,
1668: ln_amt,
1669: lr_xml);
1670:
1671: hr_utility_trace (g_xml_table(cntr));

Line 1674: dbms_lob.freeTemporary(l_xml);

1670:
1671: hr_utility_trace (g_xml_table(cntr));
1672: END LOOP;
1673: p_xml := l_xml;
1674: dbms_lob.freeTemporary(l_xml);
1675: END IF;
1676:
1677: print_blob (p_xml);
1678: