Search Results has_cdrls

Overview

OKC_CDRL_PVT is a private PL/SQL package in the APPS schema that supports Oracle Contract Terms and Deliverables functionality within Oracle E-Business Suite 12.1.1 and 12.2.2. The package name reflects its two central concepts: Contract Deliverables (CDRL) and deliverables associated with contract exhibits. It provides the internal programmatic infrastructure behind the public CDRL APIs, enabling applications to create, copy, retain, and delete deliverable lines and the exhibit structures that carry them.

Classified as a "PVT" (private) API package, OKC_CDRL_PVT is not intended for direct invocation by external developers. Its procedures and functions are consumed by its companion public packages (OKC_CDRL_PVT_W), by deliverable processing logic, and by purchasing modules that manage contract exhibits. The package follows the standard EBS API conventions, including a dependency on FND_API for message handling and return-status propagation.

Key Procedures and Functions

The ETRM metadata documents twelve procedures and functions. Their names indicate the operations performed:

• COPY_CDRL_FOR_EXHIBIT — Copies deliverable (CDRL) records so that they are associated with a specific exhibit.
• CREATE_EXHIBIT_FOR_CDRL — Creates an exhibit structure to hold a CDRL.
• INSERT_EXB_AND_GET_DATAITEMNUM (documented as INS_EXB_AND_GET_DATAITEMNUM) — Inserts an exhibit and returns the associated data item number.
• SPECIFY_EXHIBITS_FOR_CDRLS — Associates one or more exhibits with the specified CDRLs.
• DELETE_CDRL_FOR_EXHIBITS — Removes the CDRL records tied to exhibits.
• DELETE_DOC_EXHIBITS — Deletes document exhibits.
• RETAIN_CDRLS_FOR_EXHIBITS — Preserves CDRL associations across exhibit operations.
• HAS_CDRLS — Predicate returning whether CDRLs exist for a given context.
• GET_NEXT_CDRL_NUM — Retrieves the next available CDRL number.
• ELIN_TO_DECIMAL — Converts an exhibit line number (ELIN) to a decimal value.
• DECIMAL_TO_ELIN — Performs the inverse conversion from decimal to ELIN.
• TO — A helper routine (likely a conversion or validation utility) referenced in the documented procedure list.

Tables Accessed

Via APPS synonyms, the package operates on the core contract deliverables data model:

• OKC_DELIVERABLES — The primary table holding deliverable definitions; created, copied, retained, and deleted by the package.
• OKC_DELIVERABLE_ID_S — The sequence generating unique deliverable identifiers.
• OKC_DEL_STATUS_HISTORY — Status transition history for deliverables, maintained as changes occur.
• FND_DOCUMENTS and FND_ATTACHED_DOCUMENTS — The standard attachments model, used when document exhibits are created or removed.
• DUAL — Used for single-row utility queries.
• PLITBLM — A PL/SQL table type helper, typically for bulk operations or numeric conversion support.

Usage Notes

OKC_CDRL_PVT is invoked indirectly rather than by end users. The ETRM dependency report shows it is referenced by OKC_CDRL_PVT_W (the public wrapper), OKC_DELIVERABLE_PROCESS_PVT, PON_EXHIBITS_PKG, PO_AUTOCREATE_POSTPROC_PVT, and PO_EXHIBITS_PVT. This places the package at the intersection of contract deliverables and purchasing exhibit processing. It is typically triggered during contract creation or amendment, exhibit generation, and purchasing document automation where deliverables must be attached, copied, or removed. Because the package calls FND_API and STANDARD, callers should expect standard API return statuses and message handling. Custom code should use the public wrapper package instead of calling OKC_CDRL_PVT directly, since the private API signature may change between releases.