827: x_return_status := FND_API.G_RET_STS_SUCCESS;
828:
829: DELETE FROM ap_invoice_lines_interface aili
830: WHERE EXISTS (SELECT 1
831: FROM ap_invoices_interface aii
832: WHERE aii.invoice_id = aili.invoice_id
833: AND aii.group_id = p_group_id);
834:
835: DELETE FROM ap_invoices_interface aii
831: FROM ap_invoices_interface aii
832: WHERE aii.invoice_id = aili.invoice_id
833: AND aii.group_id = p_group_id);
834:
835: DELETE FROM ap_invoices_interface aii
836: WHERE aii.group_id = p_group_id;
837: EXCEPTION
838: WHEN OTHERS THEN
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;