Search Results okc_scn_pvt




Overview
Explore in AI Chat

Overview

The OKC_SCN_PVT package body in the APPS schema is a private (PVT) implementation package within the Oracle E-Business Suite Contract Management (OKC) module. It serves as the low-level data access and manipulation layer for contract sections — the structured clauses, articles, and text segments that comprise the body of a contract document. The package encapsulates the DML logic, concurrency control, versioning, and multilingual handling required to maintain section data consistently across the OKC_SECTIONS tables, shielding callers from direct table operations. Its "PVT" classification indicates it is invoked by the public OKC_API layer rather than by external consumers directly.

Key Procedures and Functions

The package exposes the following documented procedures:

  • INSERT_ROW — Creates a new section record, populating the base, translated, and history tables as required.
  • UPDATE_ROW — Modifies existing section attributes with appropriate locking and audit-trail maintenance.
  • DELETE_ROW — Removes a section record, coordinating deletes across dependent translated and historical rows.
  • LOCK_ROW — Obtains a row-level lock to serialize concurrent updates and preserve data integrity.
  • VALIDATE_ROW — Applies business validation rules prior to persistence, raising errors via the FND_API and APP_EXCEPTIONS framework.
  • ADD_LANGUAGE — Inserts translated section content into the TL tables for additional installed languages.
  • CREATE_VERSION — Snapshots current section data into the version history to support contract versioning.
  • RESTORE_VERSION — Reinstates a previously captured section version, supporting rollback and amendment workflows.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • OKC_SECTIONS_B — Base table holding language-independent section attributes.
  • OKC_SECTIONS_TL — Translation table storing language-specific section text.
  • OKC_SECTIONS_BH / OKC_SECTIONS_TLH — History tables used by the versioning procedures.
  • OKC_K_HEADERS_B — Contract header data, referenced to associate sections with their parent contract.
  • FND_LANGUAGES — Installed language definitions used by ADD_LANGUAGE.
  • FND_LOOKUP_VALUES — Reference values for validation of coded section attributes.
  • PLITBLM — The standard PL/SQL table/index-by structure used for in-memory processing.

Helper packages referenced include FND_API, FND_GLOBAL, FND_PROFILE, OKC_API, OKC_UTIL, OKC_P_UTIL, OKC_VERSION_PVT, OKC_DEBUG, and APP_EXCEPTIONS. OKC_SECTIONS_V is also referenced.

Usage Notes

OKC_SCN_PVT is not invoked directly by end users or external integrations. It is called from within the OKC public API layer (notably OKC_API) and is referenced by five other packages. Typical invocation paths include the Contract Authoring forms, where section edits, insertions, and deletions trigger the corresponding procedures; concurrent programs and versioning activities that call CREATE_VERSION and RESTORE_VERSION; and multilingual deployments where ADD_LANGUAGE backfills translated content. Because the package leverages FND_API for error handling, callers should expect standard EBS API error and message conventions. Direct custom calls should be avoided in favor of the supported public OKC_API interfaces to preserve validation, locking, and versioning behavior across releases 12.1.1 and 12.2.2.