Search Results okc_process_defs_s1




Overview
Explore in AI Chat

Overview

OKC_PDF_PVT is a private PL/SQL package body in the APPS schema that supports Oracle E-Business Suite's Contracts (OKC) module, specifically the PDF and process-definition processing infrastructure introduced with the Contracts Core / ETRM (Enterprise Transaction and Records Management) functionality. The package is classified as a PVT (private) API, meaning it is not intended for direct invocation by external callers but rather serves as the internal implementation layer for the public OKC_API and related OKC packages. Its primary business function is to manage the storage, retrieval, and lifecycle of contract process definitions — the configurable metadata that drives document generation, clause assembly, and PDF output for contract templates. The package depends on foundational EBS infrastructure such as FND_API, FND_GLOBAL, FND_PROFILE, and FND_LOOKUPS, confirming that it participates in the standard EBS API error-handling, multi-org, and language-dependent lookup frameworks.

Key Procedures and Functions

The package body exposes 14 procedures and functions, of which nine are documented by name. QC performs an internal quality or consistency check over process-definition data. CHANGE_VERSION manages version stamping or increments the version identifier associated with a process definition record. API_COPY duplicates an existing process definition, supporting the common EBS pattern of "copy from" template creation. ADD_LANGUAGE inserts translation rows into the language-dependent tables. INSERT_ROW, UPDATE_ROW, and DELETE_ROW provide the standard DML wrapper operations, each encapsulating row-level persistence with the appropriate FND_API success/failure return conventions. LOCK_ROW acquires a row-level lock to enforce optimistic concurrency control during multi-user editing of process definitions. VALIDATE_ROW applies business-rule validation before an insert or update is committed. Parameter lists are deliberately not documented in the ETRM metadata; callers should rely on the corresponding public wrapper in OKC_API rather than invoking these private entry points directly.

Tables Accessed

The package references several tables via APPS synonyms. OKC_PROCESS_DEFS_B is the base (non-translated) table holding process-definition header data; OKC_PROCESS_DEFS_TL holds the language-dependent description and name columns for each definition. OKC_PROCESS_DEFS_S1 is the sequence used to generate primary keys for new process-definition rows — this is the object matched by the search term "okc_process_defs_s1" — and is invoked inside INSERT_ROW. OKC_PROCESS_DEFS_V is a view that joins the base and TL tables for read access. FND_APPLICATION and FND_LANGUAGES supply application-registration and installed-language context, while DUAL and PLITBLM serve as the standard SYS/PL/SQL utility references. The package also reads from FND_LOOKUPS and FND_PROFILE for configuration values, and calls into OKC_API, OKC_P_UTIL, OKC_UTIL, APP_EXCEPTIONS, and FND_GLOBAL to complete its work.

Usage Notes

OKC_PDF_PVT is not referenced by any database object according to the ETRM dependency report, and it is described as referenced by four other packages. In practice this means invocation occurs through the Contracts forms (such as the Contract Terms and Process Definition setup screens) and through concurrent programs that regenerate or migrate PDF templates. Because the package is flagged as private (PVT) and depends on FND_GLOBAL for session context, it must be called with a valid FND_SESSION established — typically from within an EBS forms session or a concurrent-program run initiated by the Applications Concurrent Manager. Custom code should call the public OKC_API wrappers rather than OKC_PDF_PVT directly; direct calls bypass the intended encapsulation and risk invalidating the process-definition sequence or versioning state. The package is documented as VALID in both 12.1.1 and 12.2.2, and behavior across those releases is consistent with the ETRM 12.2.2 metadata cited above.