Search Results okl_execute_formula_pvt_w




Overview
Explore in AI Chat

Overview

The APPS.OKL_EXECUTE_FORMULA_PVT_W package body is a wrapper companion to the core Oracle Lease and Finance Management (OLFM/ETRM) formula execution engine, OKL_EXECUTE_FORMULA_PVT. In Oracle EBS 12.1.1 and 12.2.2, Oracle Lease Management supports user-definable formulas that drive calculations such as interest accrual, payment streams, residual values, and pricing adjustments. The _PVT_W suffix denotes a private wrapper generated and maintained by Oracle's Rosetta design tooling. Its role is to isolate the business logic contained in the base _PVT package from the plumbing required to marshal PL/SQL records and collections across interface boundaries, particularly between the OLFM Java middle tier and the database tier.

The package is classified as API type OTHER and is not referenced by any other database object, confirming that it is an internally consumed wrapper rather than a public integration point.

Key Procedures and Functions

The package exposes six documented programs, of which two are functional and four are Rosetta-generated data-transfer utilities:

  • EXECUTE — The functional entry point. It accepts a formula definition and evaluates it, returning the computed result. Internally it delegates to the corresponding routine in OKL_EXECUTE_FORMULA_PVT, handling the conversion of structured collection types before and after the call.
  • ROSETTA_TABLE_COPY_IN_P23 — Copies a PL/SQL associative-array (index-by table) inbound from the caller's format into the internal representation expected by the base package. The _P23 suffix identifies the specific generated copy variant.
  • ROSETTA_TABLE_COPY_OUT_P23 — Performs the reverse conversion, transferring results from the internal table structure back to the caller-supplied collection.
  • ROSETTA_TABLE_COPY_IN_P25 — A second inbound copy variant, generated for a different collection signature or direction, used where the payload structure differs.
  • ROSETTA_TABLE_COPY_OUT_P25 — The corresponding outbound copy routine for the P25 variant.

No parameter lists are documented; the procedures should be understood solely by their copy-in/copy-out and execution roles.

Tables Accessed

The only documented table reference is PLITBLM, accessed through an APPS synonym. PLITBLM is a standard Oracle database dictionary object used by the PL/SQL runtime to render error messages and stack-frame information. Its presence indicates that the package raises or propagates exceptions and relies on the standard error-message facility rather than maintaining any application data of its own.

Beyond this, the dependency list references package types only: FND_API (for the standard API result and message conventions), the JTF collection types JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_200, JTF_VARCHAR2_TABLE_300, and JTF_VARCHAR2_TABLE_800, and the base package OKL_EXECUTE_FORMULA_PVT. No OLFM business tables are touched directly.

Usage Notes

This package is not intended for direct invocation by customers or implementers. It is called by Oracle's own OLFM framework when formula execution must cross the PL/SQL-to-Java boundary, where collection formats differ between the two layers. The _P23 and _P25 routines perform the marshalling so that EXECUTE can operate on the base package's native structures.

Because the object is a private wrapper, its signature may change between patch levels without notice. Customizations should target OKL_EXECUTE_FORMULA_PVT, and any code that currently references OKL_EXECUTE_FORMULA_PVT_W should be reviewed before upgrades. It appears in dependencies for one other package, reinforcing that its consumers are Oracle-internal rather than part of the documented extension surface.