Search Results okl_dsf_pvt




Overview
Explore in AI Chat

Overview

OKL_DSF_PVT is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It forms part of the Oracle Lease and Finance Management (OKL) module within the Enterprise Contracts and Trade Management (ETRM) product family. The package encapsulates the internal implementation logic supporting the OKL Data Source Functions entity, which governs the configuration of data source functions used by the lease management subsystem. Its classification as a PVT (private) API indicates that it is not intended to be called directly by external applications, forms, or concurrent programs; rather, it provides the underlying infrastructure invoked by the corresponding public API layer and related components. The package is documented as VALID in the ETRM 12.2.2 metadata, confirming that it compiles cleanly and that its dependencies resolve correctly in a supported environment. It notably does not reference or get referenced by any object outside the OKL/OKC dependency chain and is not invoked by any database object directly, reinforcing its role as a supporting, internal implementation unit.

Key Procedures and Functions

The package body exposes fifteen documented procedures and functions that collectively implement the standard Oracle EBS table-handling API pattern for the Data Source Functions entity.

  • QC — Serves as the quality-control check or query-cache routine used internally to validate or prepare data before persistence operations.
  • CHANGE_VERSION — Handles versioning of Data Source Functions records, supporting the entity's version-management requirements.
  • API_COPY — Copies existing Data Source Functions definitions, enabling replication of configuration records across contexts.
  • ADD_LANGUAGE — Inserts translated rows into the language-specific table, supporting multi-language deployments.
  • INSERT_ROW — Creates new Data Source Functions records in the base table.
  • LOCK_ROW — Acquires a row-level lock to prevent concurrent modification during update or delete operations.
  • UPDATE_ROW — Modifies existing Data Source Functions records.
  • DELETE_ROW — Removes Data Source Functions records.
  • VALIDATE_ROW — Performs business-rule validation prior to committing insert, update, or delete operations.
  • LOAD_SEED_ROW — Loads seed data, used during installation, patching, or setup to populate the entity with predefined configurations.

Additional documented routines (five of the fifteen) handle related internal helpers; the list above represents the primary externally meaningful entry points. No parameter lists are documented in the source metadata and are therefore not reproduced here.

Tables Accessed

The package operates on the following tables via APPS synonyms:

  • OKL_DATA_SRC_FNCTNS_B — The base (non-translated) table storing Data Source Functions records; the target of INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, and API_COPY.
  • OKL_DATA_SRC_FNCTNS_TL — The translation table holding language-specific descriptions, populated by ADD_LANGUAGE.
  • FND_LANGUAGES — Referenced to determine active or installed languages during language-row insertion and validation.
  • DUAL — Used for single-row queries typical of PL/SQL initialization and lookup logic.
  • PLITBLM — A PL/SQL table used in bulk or interim processing operations.

Usage Notes

OKL_DSF_PVT is invoked indirectly. It is referenced by eleven other packages (notably OKL_API, OKC_API, OKC_UTIL, OKC_P_UTIL, and OKL_ACCOUNTING_UTIL per the dependency listing) that call its procedures on behalf of higher-level application logic. It should never be called directly from Oracle Forms, concurrent programs, or custom extensions; customizations should instead call the corresponding public OKL API, which enforces the required validation and error-handling conventions. The package relies on standard EBS infrastructure including FND_API, FND_GLOBAL, and FND_LOAD_UTIL for message handling, context resolution, and seed-data loading. Because the object is not referenced by any database object and is tightly coupled to the OKL Data Source Functions entity, it remains an internal implementation artifact of the Lease and Finance Management module. Modifications to this package are unsupported and will be overwritten by patching.