Search Results delete_order

Overview

APPS.OE_ORDER_IMPORT_UTIL_PVT is a private (PVT) PL/SQL package body within the Oracle Order Management module of Oracle E-Business Suite, documented for releases 12.1.1 and 12.2.2. It provides utility services that support the Order Import process, the batch mechanism by which order, quotation, and return data supplied through external interfaces is validated and converted into Oracle Order Management sales orders. Because the package is classified as Private, it is not exposed as a public integration API; it is intended for internal use by the Order Import processing logic and by other packages within the Order Management schema that coordinate the import cycle.

The package operates directly against the Order Import open interface tables. Its principal role is to manage the cleanup and maintenance of staging records so that re-processing, retry, and error-handling scenarios behave correctly. Operations include deleting stale or rejected interface rows and removing diagnostic messages associated with prior import attempts, which prevents duplicate processing when a source document is resubmitted under the same identifying key.

Key Procedures and Functions

• DELETE_ORDER — The core deletion routine, and the object most commonly associated with the delete_order search term. It removes the interface staging rows that correspond to a specific order import event. Identification of the rows to delete relies on a composite business key: request ID, order source, original system document reference, sold-to organization (both ID and name), and change sequence. Null-safe comparisons against FND_API.G_MISS_NUM and FND_API.G_MISS_CHAR ensure that records stored with missing or placeholder values are matched consistently. The procedure reports its outcome through a return status output parameter.
• DELETE_MESSAGES — Removes message records generated by previous import runs, supporting error-resolution cycles in which an existing record must be corrected and re-imported without residual messages being reported against it.
• GET_LINE_INDEX — Retrieves the line index associated with an imported order line, assisting downstream processing that must locate and correlate line-level staging records during order construction.

Tables Accessed

The package writes to and reads from the principal Order Import interface tables. OE_ACTIONS_INTERFACE, OE_RESERVTNS_INTERFACE, OE_CREDITS_INTERFACE, OE_PAYMENTS_INTERFACE, OE_PRICE_ADJS_INTERFACE, and OE_PRICE_ATTS_INTERFACE hold transactional detail staged for import, while OE_HEADERS_INTERFACE, OE_LINES_INTERFACE, and OE_LOTSERIALS_INTERFACE carry header, line, and lot/serial information. The DELETE_ORDER procedure, as documented, issues deletes against OE_ACTIONS_INTERFACE and OE_RESERVTNS_INTERFACE using the composite key described above. PLITBLM is used as a PL/SQL index-by table type for internal collections. Access to these tables is performed through APPS synonyms, consistent with the private-API scope of the package.

Usage Notes

OE_ORDER_IMPORT_UTIL_PVT is invoked indirectly rather than through direct calls from forms or end-user concurrent programs. It is referenced by two other documented packages, which drive Order Import processing and call these utilities to clean up staging data before and after import attempts. Typical invocation occurs during Order Import concurrent program runs, when an order source submits a document, fails validation, and is later corrected and resubmitted under the same original system document reference; the deletion logic ensures the prior interface rows do not survive to create duplicate or conflicting orders. Custom extensions should not call this private package directly. Integrators requiring cancellation or deletion of imported orders should use the public Order Management APIs, such as OE_ORDER_PUB, which handle validation, return status, and application of business rules; the private utilities assume that calling context and perform unconditional set-based deletes for which no standard error stack is maintained.