Search Results oks_cod_pvt




Overview
Explore in AI Chat

Overview

OKS_COD_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle Service (OKS) module's "Change Order Details" processing, associated with service contracts and their change orders. The package is classified as a PVT (private) API, meaning it is not intended to be called directly by external consumers and instead provides the internal implementation layer for the OKS service contract change-order functionality. It encapsulates the low-level data manipulation, validation, locking, and versioning logic required to maintain change order records against the underlying order detail tables.

The package depends on several shared EBS components, including FND_API, FND_GLOBAL, FND_MSG_PUB, APP_EXCEPTIONS, OKC_API, and OKC_P_UTIL, indicating that it follows Oracle's standard API error-handling and messaging conventions and integrates with the core contracts (OKC) infrastructure. As of ETRM 12.2.2 documentation, the package is VALID and exposes 18 documented procedures and functions. It is referenced by seven other database objects, confirming its role as a supporting layer within the OKS change-order stack.

Key Procedures and Functions

The documented subprograms cover standard private API operations plus specialized change-order routines:

  • QC — A quality-control or consistency check routine used internally to verify data integrity before committing change-order operations.
  • CHANGE_VERSION — Manages versioning of change-order records, ensuring that successive changes to an order are tracked as distinct versions.
  • API_COPY — Copies change-order data, typically to create a new versioned or duplicated record during change-order processing.
  • INSERT_ROW — Inserts new change-order detail rows into the underlying tables.
  • LOCK_ROW — Acquires a lock on a change-order row to prevent concurrent modification.
  • UPDATE_ROW — Updates existing change-order detail records.
  • DELETE_ROW — Removes change-order detail records.
  • VALIDATE_ROW — Performs business-rule validation on a change-order row prior to insert, update, or delete.

The remaining documented routines follow the same private-API pattern and support these core operations. None of the documented subprograms are exposed as public API entry points.

Tables Accessed

The package operates primarily against the OKS_K_ORDER_DETAILS table and its view OKS_K_ORDER_DETAILS_V, both referenced through APPS synonyms. OKS_K_ORDER_DETAILS stores the order detail lines that constitute a service contract change order, and the view provides a read-oriented projection used during validation, locking, and copying logic. The PLITBLM reference is a standard Oracle internal table type used for PL/SQL collection handling rather than application data. Access patterns include SELECT, INSERT, UPDATE, and DELETE, consistent with the INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW subprograms.

Usage Notes

Because OKS_COD_PVT is a private package, it is not invoked directly by Oracle Forms, concurrent programs, or custom code. Instead, it is called by higher-level public OKS APIs and internal OKS processing routines that manage service contract change orders. The seven objects that reference it act as its callers, delegating row-level DML, validation, and versioning to this package. Administrators and developers diagnosing change-order issues should treat OKS_COD_PVT as an implementation detail: troubleshooting generally begins at the public OKS API layer, with this package visible through dependency tracing or PL/SQL stack traces. Modifying or calling it directly is not supported, and any customization should target the public API surface instead.