Search Results okc_rep_closeout_pvt




Overview
Explore in AI Chat

Overview

OKC_IMP_RECORD_TYPES is an APPS-owned PL/SQL package within the Oracle E-Business Suite Contracts (OKC) module, classified under the ETRM repository with an API classification of OTHER. Its name indicates a structural or declarative role: it defines the record type specifications used by the Contract Import (OKC_IMP) framework rather than exposing business transactions directly. The package provides the typed data structures that other import-related programs reference when staging, validating, and loading contract, party, contact, risk, and usage records into the repository schema. Because record type definitions must remain synchronized with the physical staging tables, OKC_IMP_RECORD_TYPES acts as the shared contract between the importer routines and the underlying OKC_REP_IMP_* interfaces. It holds VALID status in both EBS 12.1.1 and 12.2.2, and its dependency footprint ties it directly to the contract closeout and contract import processing chains.

Key Procedures and Functions

The ETRM metadata documents zero standalone procedures or functions for this package. This is consistent with its classification as a type-definition container: the package specification declares PL/SQL record types, and the package body carries the corresponding implementations only where required. No public callable interfaces are documented, and no parameter lists should be assumed. Consumers interact with the package by declaring variables of its record types, then assigning and passing those variables into other APIs. The practical entry points for contract import logic reside in the referencing packages—most relevantly OKC_REP_CLOSEOUT_PVT, which the user's search term points to—and not in OKC_IMP_RECORD_TYPES itself.

Tables Accessed

The package references six repository objects through APPS synonyms:

These dependencies confirm that the record types mirror both the permanent repository columns and the temporary import columns, allowing the import engine to move data consistently from staged rows into the contracts schema.

Usage Notes

OKC_IMP_RECORD_TYPES is not invoked directly from forms or concurrent programs; it is compiled and resolved at runtime by the packages that reference it. The ETRM metadata lists seven dependent programs: OKC_REP_CLOSEOUT_PVT, OKC_REP_CONTRACT_IMP_PUB, OKC_REP_CONTRACT_IMP_PVT, PON_CLM_OKC_INTEG_PKG, PO_CLOSEOUT_PVT, PO_DOCUMENT_CHECKS_PVT, and PO_MOD_CONTROL_PVT. This dependency set explains why a search for "okc_rep_closeout_pvt" surfaces this package: contract closeout processing calls the import record structures when validating or loading contract data. Any modification to the underlying OKC_REP_* staging or repository tables must be accompanied by a review of OKC_IMP_RECORD_TYPES, since mismatched record definitions will invalidate dependent packages. Custom code that extends the contract import process should reference the same record types to preserve compatibility with Oracle's delivered import and closeout logic.