Search Results specify_exhibits_for_cdrls

Overview

OKC_CDRL_PVT_W is a PL/SQL wrapper package in the Oracle Contracts (OKC) module of Oracle E-Business Suite, designed to expose the private API OKC_CDRL_PVT to external and internal callers through a well-defined, invoker-rights interface (AUTHID CURRENT_USER). Its principal business purpose is to associate CDRLs (Contract Data Requirements List entries) with exhibits, thereby governing which contractual deliverables are tied to specific documents, document classes, document types, and document versions. The suffix "_W" denotes the conventional Oracle EBS wrapper layer that sits above the private package, handling public API declarations, multitenant-aware table conversion, and message-stack plumbing so that callers do not interact directly with the underlying private implementation.

The package was last updated under version 120.0.12020000.1 (2013/02/19), consistent with the 12.1.1 and 12.2.2 releases. It registers with Oracle ETRM as an OTHER-classification API and is referenced by no other documented packages, indicating it functions as a terminal entry point rather than a reusable internal utility.

Key Procedures and Functions

Five procedures are documented. Four are Rosetta table-conversion utilities generated to marshal PL/SQL collection types across the API boundary:

• ROSETTA_TABLE_COPY_IN_P0 – Converts an inbound JTF_VARCHAR2_TABLE_100 into the OKC_CDRL_PVT.exhibit_tbl_type collection used internally for exhibit identifiers.
• ROSETTA_TABLE_COPY_OUT_P0 – Performs the reverse mapping, returning exhibit data from the private collection type to a JTF_VARCHAR2_TABLE_100 out parameter.
• ROSETTA_TABLE_COPY_IN_P1 – Converts an inbound JTF_NUMBER_TABLE into OKC_CDRL_PVT.deliverable_tbl_type for numeric deliverable identifiers.
• ROSETTA_TABLE_COPY_OUT_P1 – Returns deliverable identifiers from the private collection type back to a JTF_NUMBER_TABLE.

SPECIFY_EXHIBITS_FOR_CDRLS is the substantive public API. It accepts a CDRL identifier collection (p_cdrl_tbl) together with exhibit and document-attribute inputs (p_exhibit_code, p_doc_class, p_doc_type, p_doc_id, p_doc_version), a processing mode, standard API versioning, initialization, and commit flags, and returns the standard EBS message-stack outputs (x_msg_data, x_msg_count, x_return_status). Its purpose is to establish, in bulk, the exhibit associations for the identified CDRLs.

Tables Accessed

The only documented table referenced through APPS synonyms is PLITBLM, the PL/SQL interface table used by the Rosetta conversion layer to persist or stage collection elements during inbound and outbound type mapping. Because the substantive DML for CDRL-exhibit relationships is encapsulated in the private package OKC_CDRL_PVT (which this wrapper calls), the metadata lists no additional base tables; any writes to the CDRL and exhibit entities occur downstream of this layer.

Usage Notes

OKC_CDRL_PVT_W is invoked programmatically rather than directly by end users. Typical callers include Oracle Contracts forms and related OKC UI flows that manage CDRL and exhibit assignments, concurrent programs performing bulk CDRL maintenance, and custom extensions or integration interfaces that need to attach exhibits to CDRLs in volume. Because the API is AUTHID CURRENT_USER, callers must possess appropriate privileges on the underlying objects, and standard EBS API conventions apply: pass FND_API.G_TRUE for p_init_msg_list and p_commit only at the outermost transactional boundary, inspect x_return_status before relying on downstream changes, and retrieve accumulated messages via x_msg_count and x_msg_data. The p_mode parameter governs which document-attribute columns are applied versus preserved. Callers should treat this package as the supported public surface and never invoke OKC_CDRL_PVT directly, since the wrapper ensures correct collection marshalling and message handling across releases.