DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on AP_INVOICES_INTERFACE

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

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:

Line 2610: parent_table = 'AP_INVOICES_INTERFACE';

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