Search Results okc_process_def_parms_s1




Overview
Explore in AI Chat

Overview

OKC_PDP_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Contracts (OKC) module, specifically the Process Definition Parameters (PDP) feature. The "PVT" suffix designates this as an internal, private API package that is invoked by the public OKC_API layer rather than directly by external callers. In EBS 12.1.1 and 12.2.2, the package provides the core data management logic for process definition parameters — the configurable attributes that drive contract process workflows such as approval, signature, and fulfillment routing. It centralizes row-level insert, update, delete, lock, validation, and translation handling for the OKC_PROCESS_DEF_PARMS tables, enforcing the multi-language and multi-version semantics required by Oracle's table-handler (TAPI-style) pattern.

Key Procedures and Functions

  • INSERT_ROW — Creates a new process definition parameter record, populating the base table and driving the corresponding translation rows.
  • UPDATE_ROW — Modifies an existing parameter definition, including its translated descriptive columns.
  • DELETE_ROW — Removes a process definition parameter and its associated translation rows.
  • LOCK_ROW — Acquires a database lock on a parameter row, supporting concurrent edit and multi-user update integrity.
  • VALIDATE_ROW — Performs business-rule validation on parameter data prior to commit; the standard validation entry point for the table handler.
  • ADD_LANGUAGE — Inserts translation (TL) rows for a parameter when a new language is installed or when a translation is missing.
  • API_COPY — Duplicates process definition parameter data, typically when copying a process definition or its configuration.
  • CHANGE_VERSION — Manages version changes for parameter records, supporting the versioning behavior of contract process definitions.
  • QC — Quality-check utility, typically used as a diagnostic helper to verify row conformance or validate internal consistency.

The package also exposes related internal helpers listed in the metadata (14 documented procedures/functions total), all serving the same table-handler and translation-management role.

Tables Accessed

  • OKC_PROCESS_DEF_PARMS_B — The base (non-translated) table holding process definition parameter definitions; the primary insert/update/delete target.
  • OKC_PROCESS_DEF_PARMS_TL — The translation table storing language-specific parameter descriptions; maintained via ADD_LANGUAGE.
  • OKC_PROCESS_DEF_PARMS_S1 — A sequence used to generate primary keys for new parameter rows.
  • FND_APPLICATION — Lookup of the owning application context for the parameter data.
  • FND_LANGUAGES — Reference for the installed/active languages used in translation handling.
  • DUAL and PLITBLM — Utility access for scalar selection and PL/SQL table-of-varchar operations.

The package additionally depends on OKC_PROCESS_DEFS_V and OKC_PROCESS_DEF_PARAMETERS_V for validation context, and on the OKC_API, OKC_P_UTIL, OKC_UTIL, FND_API, FND_GLOBAL, FND_PROFILE, FND_LANGUAGES, and APP_EXCEPTIONS packages for messaging, profile lookups, and error handling.

Usage Notes

Because OKC_PDP_PVT is a private package, it is not referenced by any database object in the ETRM dependency listing and should not be called directly. It is invoked indirectly through the public OKC_API contract API, which in turn is called by the Oracle Contracts forms, concurrent programs, and any custom extensions that use the supported OKC public APIs to create or maintain process definitions. Four other packages reference OKC_PDP_PVT internally.

Use this package only through supported OKC_API entry points. Direct calls bypass the validation and versioning guarantees enforced by the public layer and are unsupported for upgrades or patching. When customizing or troubleshooting process definition parameter behavior, inspect OKC_API calls and the OKC_PROCESS_DEF_PARMS_* tables rather than this private body.