Search Results okc_ctc_pvt




Overview
Explore in AI Chat

Overview

OKC_CTC_PVT is a private PL/SQL package body in the APPS schema that implements the low-level data access and versioning logic for Oracle Contract Terms and Conditions contact records. In Oracle EBS 12.1.1 and 12.2.2, contacts are stored in OKC_CONTACTS and audited in OKC_CONTACTS_H, and they participate in the same versioning framework used across the Contracts (OKC) module. This package is classified as a PVT (private) API, meaning it is intended for internal consumption by the OKC public APIs and concurrent processes rather than by external integrations.

The package encapsulates row-level insert, update, delete, and lock operations, contact validation, version creation and restoration, and the maintenance of a denormalized status/version code. It is referenced by 26 other database objects, confirming its role as a foundational utility layer, while it is not itself referenced by any object outside this dependency chain. It relies on FND_API for the standard EBS API error-handling and return-status conventions, FND_GLOBAL and FND_PROFILE for session context, and OKC_API, OKC_VERSION_PVT, OKC_UTIL, OKC_P_UTIL, and OKC_DEBUG for shared contract logic and diagnostics.

Key Procedures and Functions

  • QC — Quality-check helper used to evaluate or signal validation conditions within the package's flow.
  • CHANGE_VERSION — Adjusts the version context for a contact record, supporting the OKC versioning model.
  • API_COPY — Copies contact data, typically as part of version duplication or object copy operations.
  • INSERT_ROW — Inserts a new contact row and its corresponding history record.
  • LOCK_ROW — Acquires a lock on a contact row to enforce concurrency control.
  • UPDATE_ROW — Updates an existing contact row and writes the audit trail to the _H table.
  • DELETE_ROW — Removes a contact row, respecting the OKC deletion and versioning rules.
  • VALIDATE_ROW — Performs pre-write validation of contact attributes and mandatory columns.
  • UPDATE_CONTACT_STECODE — Maintains the denormalized status code column on the contact record.
  • INSERT_ROW_UPG — Specialized insert path used during upgrade or data migration processing.
  • CREATE_VERSION — Creates a new version of the contact, delegating to OKC_VERSION_PVT.
  • RESTORE_VERSION — Restores a contact to a previously saved version.

The remaining documented routines follow the same private-row-handler pattern and are invoked in sequence by the public OKC contact APIs.

Tables Accessed

  • OKC_CONTACTS / OKC_CONTACTS_H — Primary transactional and history tables for contract contact records.
  • OKC_CONTACT_SOURCES — Defines the source or origin of a contact, used in validation.
  • OKC_K_HEADERS_ALL_B — Contract header base table, providing the parent contract context.
  • OKC_K_PARTY_ROLES_B — Party role assignments linked to contacts.
  • OKC_STATUSES_B — Status lookup referenced by UPDATE_CONTACT_STECODE.
  • DBMS_SQL, PLITBLM, USER_TAB_COLUMNS — Dynamic SQL and metadata utilities used for generic column handling.

Usage Notes

OKC_CTC_PVT is not exposed to end users directly. It is invoked indirectly through OKC public APIs (OKC_API and related public packages) when users create, modify, or version contract contacts in the Contracts workbench forms, and during concurrent programs that process contact data. Customizations should call the supported public OKC APIs rather than this private package, because its signature and internal behavior may change between 12.1.1 and 12.2.2. The presence of INSERT_ROW_UPG indicates historical use in upgrade and data-migration scripts, where direct invocation may still be observed in legacy code.