Search Results okc_rep_contracts

Overview

OKC_REP_UPD_CON_ADMIN_PVT is a private (PVT-classified) PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Contracts (OKC) repository module. Its documented purpose is to manage the assignment and update of the contract administrator manager on repository contracts. The package name decomposes to "OKC Repository Update Contract Administrator," indicating that it forms part of the internal server-side logic used by the Contracts Repository (also known as the Contract Terms Library / repository contracts) to change the administrative manager associated with one or more contracts. It is an internal helper package, intended for use by other EBS product code rather than by external integrators or end users, and it is classified as PVT — a private API. This package is valid in both Oracle EBS 12.1.1 and 12.2.2, with the documented metadata reflecting the 12.2.2 release.

Key Procedures and Functions

The package body documents a single public routine:

• UPDATE_CON_ADMIN_MANAGER — The core procedure used to update the contract administrator manager on repository contracts. It accepts context identifying the target contract(s) and the new administrative manager, then performs the necessary validation and data updates against the OKC repository contract tables. The procedure coordinates with the standard OKC_API layer and other EBS APIs to keep contract data consistent, and it may raise or log messages through the FND message and logging infrastructure when validation fails.

No parameter list is documented in the ETRM metadata, so the exact signatures are not reproduced here. The routine is not referenced by any other database object, confirming its role as a leaf-level private helper invoked by higher-level OKC package logic.

Tables Accessed

The package references a broad set of tables and views through APPS synonyms, organized as follows:

• Contract repository tables: OKC_REP_CONTRACTS, OKC_REP_CONTRACTS_ALL, OKC_REP_CONTRACT_PARTIES, OKC_BUS_DOC_TYPES_B, OKC_BUS_DOC_TYPES_TL, and OKC_TEMPLATE_USAGES — the primary targets for reading and updating contract header, party, and document-type information.
• Order and quote sources: OE_ORDER_HEADERS, OE_BLANKET_HEADERS, OE_TRANSACTION_TYPES_TL, ASO_QUOTE_HEADERS, and ASO_QUOTE_STATUSES_VL — used to link repository contracts back to their originating sales documents.
• Party and organization data: HZ_CUST_ACCOUNTS, HZ_PARTIES, HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, PER_ALL_PEOPLE_F, JTF_RS_SALESREPS, JTF_RS_RESOURCE_EXTNS_VL, and JTF_RS_GROUPS_TL — used to resolve and validate the contract administrator manager and related resource references.
• Foundation and utility objects: FND_USER, FND_LOOKUPS, FND_NEW_MESSAGES, FND_API, FND_FILE, FND_LOG, OKC_API, OKC_TERMS_UTIL_PVT, and PLITBLM — supporting user context, lookup values, error messaging, logging, and utility PL/SQL processing.

Usage Notes

Because OKC_REP_UPD_CON_ADMIN_PVT is a private package body and is not referenced by any other database object, it is not intended to be called directly by customers or external integrations. It is invoked internally by the Oracle Contracts application — typically in the context of the repository contract maintenance forms, contract administration workflows, or concurrent programs that reassign the administrator manager on repository contracts. Customizations and extensions should not call this package directly; instead, use the published OKC_API procedures, since private packages may change between releases without notice. When diagnosing contract administrator assignment issues on 12.1.1 or 12.2.2, trace invocations of UPDATE_CON_ADMIN_MANAGER through FND_LOG output to confirm the package executed and whether any validation errors were raised.