DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on AP_INVOICES_INTERFACE

Line 2606: delete from ap_invoices_interface where invoice_id = p_invoice_id_table(i);

2602: debug_info := 'Delete records from rejection and interface tables';
2603:
2604: /* Delete invoices from interface */
2605: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2606: delete from ap_invoices_interface where invoice_id = p_invoice_id_table(i);
2607: /* Delete invoice lines from interface */
2608: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2609: delete from ap_invoice_lines_interface where invoice_id = p_invoice_id_table(i);
2610:

Line 2615: parent_table = 'AP_INVOICES_INTERFACE';

2611: /* Delete invoice rejections from the rejections table */
2612: forall i in nvl(p_invoice_id_table.first,0)..nvl(p_invoice_id_table.last,0)
2613: delete from ap_interface_rejections
2614: where parent_id = p_invoice_id_table(i) and
2615: parent_table = 'AP_INVOICES_INTERFACE';
2616:
2617: /* Delete invoice lines rejections from the rejections table */
2618: forall i in nvl(p_invoice_line_id_table.first,0)..nvl(p_invoice_line_id_table.last,0)
2619: delete from ap_interface_rejections