Search Results okc_fep_pvt




Overview
Explore in AI Chat

Overview

OKC_FEP_PVT is a private PL/SQL package body in the APPS schema that supports the function expression parameter framework within Oracle E-Business Suite's Contracts (OKC) module, part of the Enterprise Contracts / TCA architecture. The package provides the internal implementation layer for managing the OKC_FUNCTION_EXPR_PARAMS entity, which stores parameters used by function expressions embedded in contract terms, conditions, and clause logic. Function expressions allow contract authors and administrators to drive dynamic behavior in contract templates by referencing runtime values, and OKC_FEP_PVT supplies the row-level DML, validation, versioning, and concurrency handling required to keep that parameter data consistent. The "PVT" suffix indicates the package is classified as a private implementation package, meaning its procedures are intended for invocation by other OKC packages rather than by external callers. The documented metadata lists the package as VALID, and it is referenced by eight other database objects, underscoring its role as a shared internal utility within the Contracts expression engine.

Key Procedures and Functions

  • QC — A quality-control or sanity-check routine that validates the internal consistency of function expression parameter data, typically invoked during package initialization or debugging.
  • CHANGE_VERSION — Adjusts the version context for the parameter records, supporting contracts versioning semantics so that expression parameters remain aligned with the contract version being processed.
  • API_COPY — Copies function expression parameter rows from one logical context to another, commonly used when duplicating contract templates, clauses, or versions.
  • INSERT_ROW — Inserts new parameter rows into the underlying table via the entity's API layer.
  • LOCK_ROW — Performs row-level locking to serialize concurrent updates and enforce optimistic concurrency.
  • UPDATE_ROW — Updates existing parameter rows, applying attribute changes and audit tracking.
  • DELETE_ROW — Removes parameter rows, honoring referential integrity constraints.
  • VALIDATE_ROW — Applies business-rule validation to parameter attributes before DML is committed.
  • CREATE_VERSION — Generates a new version of the parameter set, preserving history for audit and rollback.
  • RESTORE_VERSION — Reinstates a prior version of the parameter data, supporting correction and reprocessing scenarios.

Collectively these routines form a complete CRUD-and-versioning API surface for the OKC_FUNCTION_EXPR_PARAMS entity.

Tables Accessed

The documented table references center on OKC_FUNCTION_EXPR_PARAMS and its associated objects: the history table OKC_FUNCTION_EXPR_PARAMS_H, the sequence OKC_FUNCTION_EXPR_PARAMS_S1, and the view OKC_FUNCTION_EXPR_PARAMS_V. The package also references FND_APPLICATION and PLITBLM (a PL/SQL table of BOOLEAN used internally), and reads DUAL for trivial queries. No direct writes to OKC_FUNCTION_EXPR_PARAMS are assumed; the package delegates to OKC_API, OKC_VERSION_PVT, OKC_P_UTIL, FND_API, and FND_GLOBAL for messaging, versioning, and environment context.

Usage Notes

OKC_FEP_PVT is not invoked directly by end users. It is called by other OKC packages — the metadata notes eight referencing objects — during contract creation, clause evaluation, template instantiation, and version management. Forms and concurrent programs in the Contracts module route parameter maintenance through higher-level public APIs, which in turn call these private procedures. Customizations should likewise call the supported public API layer rather than OKC_FEP_PVT directly, because private package signatures may change between releases such as 12.1.1 and 12.2.2 without public notification.