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';
1383:
1384: /* Delete invoice lines from interface */
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';
1383:
1384: /* Delete invoice lines from interface */
1385: DELETE FROM ap_invoice_lines_interface
1386: WHERE invoice_id = X_INVOICE_ID;
1381: WHERE invoice_id = X_INVOICE_ID)
1382: and parent_table = 'AP_INVOICE_LINES_INTERFACE';
1383:
1384: /* Delete invoice lines from interface */
1385: DELETE FROM ap_invoice_lines_interface
1386: WHERE invoice_id = X_INVOICE_ID;
1387:
1388: /* Delete invoices from interface */
1389: DELETE FROM AP_INVOICES_INTERFACE