APPS.AHL_OSP_PO_REQ_PVT dependencies on PO_HEADERS_INTERFACE

Line 396: DELETE FROM PO_HEADERS_INTERFACE WHERE

392: ELSIF(l_status = G_OSP_SUB_FAILED_STATUS and l_old_intf_header_id IS NOT NULL) THEN
393: -- Earlier, User tried to create a PO (not a requisition) and that failed.
394: DELETE FROM PO_INTERFACE_ERRORS WHERE
395: INTERFACE_HEADER_ID = l_old_intf_header_id;
396: DELETE FROM PO_HEADERS_INTERFACE WHERE
397: INTERFACE_HEADER_ID = l_old_intf_header_id;
398: DELETE FROM PO_LINES_INTERFACE WHERE
399: INTERFACE_HEADER_ID = l_old_intf_header_id;
400: END IF;