DBA Data[Home] [Help]

APPS.AP_INVOICES_INTERFACE_PKG dependencies on AP_INTERFACE_REJECTIONS

Line 1373: DELETE FROM ap_interface_rejections

1369: -- Bug 2496745. Deleting the interface lines and rejections
1370: -- when the invoice is deleted.
1371:
1372: /* Delete invoice rejections from the rejections table */
1373: DELETE FROM ap_interface_rejections
1374: WHERE parent_id = X_INVOICE_ID AND
1375: parent_table = 'AP_INVOICES_INTERFACE';
1376:
1377: /* Delete invoice lines rejections from the rejections table */

Line 1378: DELETE FROM ap_interface_rejections

1374: WHERE parent_id = X_INVOICE_ID AND
1375: parent_table = 'AP_INVOICES_INTERFACE';
1376:
1377: /* Delete invoice lines rejections from the rejections table */
1378: DELETE FROM ap_interface_rejections
1379: WHERE parent_id IN (SELECT invoice_line_id
1380: FROM ap_invoice_lines_interface
1381: WHERE invoice_id = X_INVOICE_ID)
1382: and parent_table = 'AP_INVOICE_LINES_INTERFACE';