Search Results okl_fpr_pvt




Overview
Explore in AI Chat

Overview

OKL_FPR_PVT is a private PL/SQL package in the APPS schema that belongs to the Oracle Enterprise Contracts (formerly Oracle Lease and Finance Management, OKL) module within Oracle E-Business Suite. The package name follows the ETRM convention where the _PVT suffix designates a private implementation package that is not intended for direct invocation by external consumers. It provides the underlying procedural logic for maintaining the OKL_FNCTN_PRMTRS entity, which stores function parameter definitions used by the Oracle Lease Management setup and calculation engines. The package isolates low-level row manipulation, validation, and seed-data loading for these parameters so that the corresponding public and secondary packages can delegate that work to a single controlled implementation layer. Its existence as a VALID object confirms it is deployed and compiled in the target release.

Key Procedures and Functions

The documented procedures reflect the standard ETRM private-package pattern:

  • INSERT_ROW — Inserts a new function-parameter record, applying the package's defaulting and validation conventions.
  • UPDATE_ROW — Modifies an existing parameter record, typically maintaining WHO columns and version tracking.
  • DELETE_ROW — Removes a parameter record.
  • LOCK_ROW — Acquires the row lock required before an update or delete operation.
  • VALIDATE_ROW — Performs the business-rule checks applied to a parameter row before it is committed.
  • CHANGE_VERSION — Manages version stamping, used to keep the parameter definitions consistent across concurrent updates.
  • API_COPY — Copies function-parameter definitions, supporting duplication or setup cloning scenarios.
  • ADD_LANGUAGE — Creates translated rows in the TL table for supported languages.
  • LOAD_SEED_ROW — Loads seeded setup data shipped by Oracle during installation or upgrade.
  • QC — A quality-control routine that checks the integrity of the parameter data maintained by the package.

Tables Accessed

The package operates against the function-parameter tables, reached through APPS synonyms:

  • OKL_FNCTN_PRMTRS_B — The base table holding the function parameter definitions; this is the primary insert/update/delete target.
  • OKL_FNCTN_PRMTRS_TL — The translation table holding language-specific text, written by ADD_LANGUAGE and read through the _V view.
  • FND_LANGUAGES — The language repository consulted by ADD_LANGUAGE to determine valid installed languages.
  • PLITBLM — The PL/SQL index-by table used for set-based bulk processing within the package.

The dependency list additionally shows reliance on FND_API for the standard API error and message handling framework and OKC_API for contract-related common services, consistent with OKL's placement within the Enterprise Contracts family.

Usage Notes

Because OKL_FPR_PVT is a private package, it is not called directly from forms, concurrent programs, or customer extensions. It is invoked indirectly through OKL_FNCTN_PRMTRS_PUB, OKL_FNCTN_PRMTRS_PUB_W, OKL_SETUPDSFPARAMETERS_PUB, OKL_SETUPDSFPARAMETERS_PVT, and OKL_SETUPFUNCTIONS_PVT, along with their associated wrapper packages. The eight packages that reference it form the public entry layer for function-parameter and setup configuration. Customizations should target the public packages rather than OKL_FPR_PVT, since Oracle may change private package signatures between patch levels without notice. The presence of LOAD_SEED_ROW indicates the package also participates in seeded setup loading during installation and upgrade cycles.