2597: debug_info := 'Delete records from rejection and interface tables';
2598:
2599: /* Delete invoices from interface */
2600: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2601: delete from ap_invoices_interface where invoice_id = p_invoice_id_table(i);
2602: /* Delete invoice lines from interface */
2603: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2604: delete from ap_invoice_lines_interface where invoice_id = p_invoice_id_table(i);
2605:
2606: /* Delete invoice rejections from the rejections table */
2607: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2608: delete from ap_interface_rejections
2609: where parent_id = p_invoice_id_table(i) and
2610: parent_table = 'AP_INVOICES_INTERFACE';
2611:
2612: /* Delete invoice lines rejections from the rejections table */
2613: forall i in nvl(p_invoice_line_id_table.first,0)..nvl(p_invoice_line_id_table.last,0)
2614: delete from ap_interface_rejections