Search Results delete_exhibits

Overview

APPS.PO_CLM_OKC_INTEG_PKG is a PL/SQL package body that provides the integration layer between Oracle Purchasing contracting functionality and Oracle Contracts (OKC) terminology data. Its name reflects the CLM (Contract Lifecycle Management) and OKC (Oracle Knowledge/Contracts) integration responsibility within the Procurement module. The package acts as a thin wrapper that delegates core processing to underlying private APIs, in this case PO_EXHIBITS_PVT, while supplying standardized logging through PO_LOG. This design isolates the calling application from the mechanics of exhibit maintenance and closeout workflow initiation.

The package is classified as OTHER in the ETRM metadata, indicating it is not exposed as a formal public API set but is used internally by Procurement and Contracts components. It contains three documented procedures: INSERT_EXHIBITS, DELETE_EXHIBITS, and START_CLOSEOUT_WF_PROCESS.

Key Procedures and Functions

• INSERT_EXHIBITS — Inserts exhibits for a given document when they do not already exist for that document. The procedure accepts array-based parameters covering document type, document identifier, exhibit name, exhibit description, CDRL flag, and revision number, and returns a status and message. Documented behavior shows it delegates to PO_EXHIBITS_PVT.insert_exhibits. This procedure is the counterpart to the delete_exhibits operation.
• DELETE_EXHIBITS — Removes exhibits associated with a given document. This is the procedure most often referenced in troubleshooting contexts for exhibit cleanup and is the object directly matching the search term "delete_exhibits". It supports removal of exhibit records that are no longer required for the contracting document.
• START_CLOSEOUT_WF_PROCESS — Initiates the closeout workflow process for contracting documents, enabling Oracle Workflow driven closeout processing from within the Procurement integration layer.

Each procedure follows the package convention of invoking PO_LOG procedures for begin and end trace logging, controlled by the PO_LOG.d_proc flag, with a module name derived through PO_LOG.get_package_base.

Tables Accessed

The ETRM metadata does not enumerate specific tables accessed directly by this package. Because PO_CLM_OKC_INTEG_PKG functions as a delegating wrapper, the underlying data manipulation is performed by PO_EXHIBITS_PVT and related private APIs. Exhibit data is therefore persisted against the document entity identified by the document type and document identifier passed into the procedures. The absence of explicit table references in the metadata is consistent with the package's role as a coordination layer rather than a direct table interface.

Usage Notes

• The package is referenced by two other packages in the documented metadata, confirming its role as a shared integration point rather than an end-user entry point.
• It is typically invoked from Contract Lifecycle Management and Oracle Contracts integration flows where exhibit records must be created, removed, or closed out in conjunction with a Purchasing document.
• Because it is not classified as a formal public API, custom code should call the supported private APIs such as PO_EXHIBITS_PVT directly, or use the documented entry points where available, rather than relying on this wrapper.
• Version header information (120.0.12020000.7, dated 2013/02/27) indicates active maintenance through the 12.2.x release line, making it applicable in both Oracle EBS 12.1.1 and 12.2.2 environments.
• When troubleshooting exhibit deletion issues, the DELETE_EXHIBITS procedure and its delegate PO_EXHIBITS_PVT should both be examined, along with PO_LOG trace output enabled at the procedure level.