Search Results create_exhibit_for_cdrl

Overview

OKC_CDRL_PVT is a private PL/SQL package body in the APPS schema that supports the Contract Deliverables (CDRL) feature set within Oracle E-Business Suite Contracts (OKC) and its integration with Oracle Purchasing. The package name derives from "Contract Data Requirements List" (CDRL), the structured mechanism by which contract terms define the deliverables a supplier must provide, together with their due dates, statuses, and associated document exhibits. As a PVT-classified (private) package, OKC_CDRL_PVT is not intended as a public integration API; it houses internal logic used by the public OKC_API layer and by CDRL-related workflows such as the creation and maintenance of exhibits tied to deliverables.

Its responsibilities span three areas: managing the relationship between CDRLs and exhibits (attachments/documents), generating CDRL identifiers and Exhibit/Line Item Numbers (ELINs), and maintaining status history for deliverables. The package is a member of the OKC contract authoring infrastructure and depends on OKC_API, OKC_DELIVERABLES, and several FND document-management packages.

Key Procedures and Functions

The package body exposes twelve documented procedures and functions. Two are exhibit-to-CDRL builders: COPY_CDRL_FOR_EXHIBIT and CREATE_EXHIBIT_FOR_CDRL establish the linkage in either direction between a deliverable and a Purchasing exhibit, with INS_EXB_AND_GET_DATAITEMNUM supporting exhibit insertion and retrieval of the data item number. SPECIFY_EXHIBITS_FOR_CDRLS applies exhibits across multiple CDRLs, while DELETE_DOC_EXHIBITS and DELETE_CDRL_FOR_EXHIBITS provide the corresponding removal paths.

Identifier and formatting logic is concentrated in GET_NEXT_CDRL_NUM, ELIN_TO_DECIMAL, and DECIMAL_TO_ELIN, which produce the next CDRL number and convert between human-readable ELIN text and its numeric representation. HAS_CDRLS and RETAIN_CDRLS_FOR_EXHIBITS support existence checks and retention of CDRL records when exhibits are reprocessed. The remaining documented routine, TO, is a short conversion helper. Notably, OKC_DELIVERABLE_ID_S is referenced for the deliverable identifier sequence.

Tables Accessed

The package reads and writes OKC_DELIVERABLES, the base table for contract deliverables, and OKC_DELIVERABLE_ID_S, used to obtain the next deliverable ID. OKC_DEL_STATUS_HISTORY records status transitions for deliverables, supporting auditability. On the document side, FND_ATTACHED_DOCUMENTS and FND_DOCUMENTS supply the attachment and document records that back exhibits. The DUAL pseudo-table supports trivial lookups, and PLITBLM is the PL/SQL table type used for internal collection handling. Additional FND packages (FND_ATTACHED_DOCUMENTS2_PKG, FND_ATTACHED_DOCUMENTS3_PKG, FND_GLOBAL, FND_LOG, FND_MSG_PUB, FND_API) provide attachment management, session context, logging, and error/message handling, while PON_EXHIBITS_PKG and PO_CLM_OKC_INTEG_PKG bridge the Contracts and Purchasing sides.

Usage Notes

OKC_CDRL_PVT is invoked indirectly through the Contract Terms and Deliverables UI and through the OKC_API public layer, rather than by direct calls in customer code. It is referenced by five other packages and is itself not referenced by any database object that ETRM lists, confirming its role as an internal implementation detail. Because it manipulates exhibits and attachments in concert with Purchasing packages, it participates in integration flows between OKC and PO. Customizations should avoid calling these private procedures directly; instead, use the supported OKC_API entry points, since the package signature and behavior are subject to change without notice between 12.1.1 and 12.2.2.