Search Results okl_subsidy_process_pvt_w




Overview
Explore in AI Chat

Overview

The APPS.OKL_SUBSIDY_PROCESS_PVT_W package body is an Oracle E-Business Suite (EBS) private API belonging to the Oracle Lease and Finance Management (OKL) module, part of the broader Enterprise Contracts and ETRM (Enterprise Transaction and Revenue Management) stack. It is a wrapper-style private package built around the core business logic package OKL_SUBSIDY_PROCESS_PVT, providing a standardized "W" (wrapper) interface through which the public API layer can invoke subsidy processing operations without directly exposing internal PL/SQL structures. In the context of EBS 12.1.1 and 12.2.2, this object is delivered in the APPS schema with a VALID status, indicating it is a supported, compiled component of the ETRM application.

The package's principal business function is to calculate and process subsidy amounts associated with lease and finance contracts. Subsidies in lease management represent amounts contributed by third parties (such as vendors or manufacturers) to reduce the cost of a leased asset, and these figures must be derived and allocated correctly across contract, asset, and partial-subsidy dimensions.

Key Procedures and Functions

The package exposes six documented procedures/functions, comprising the Rosetta table-conversion utilities and the core subsidy computation routines:

  • ROSETTA_TABLE_COPY_IN_P1 — Copies incoming data into Rosetta (JTF) PL/SQL table structures, converting client-side collections into the internal table formats expected by the business logic.
  • ROSETTA_TABLE_COPY_OUT_P1 — Performs the reverse operation, copying internal Rosetta table data back out for consumption by the calling layer.
  • GET_SUBSIDY_AMOUNT — Returns the total calculated subsidy amount for a given processing context.
  • GET_ASSET_SUBSIDY_AMOUNT — Derives the subsidy amount attributable to a specific asset within the lease.
  • GET_CONTRACT_SUBSIDY_AMOUNT — Calculates the subsidy amount at the contract level.
  • GET_PARTIAL_SUBSIDY_AMOUNT — Computes a partial subsidy figure, typically used when only a portion of the asset or contract qualifies for subsidy treatment.

The Rosetta routines are paired conversion helpers, reflecting the standard OKL pattern of marshaling data between external and internal representations.

Tables Accessed

The only documented table reference is PLITBLM, accessed via an APPS synonym. PLITBLM (PL/SQL Integer Table, Binary/Long type) is a standard Oracle tooling table used to support bulk PL/SQL collection handling and migration of nested-table contents. Its presence here is consistent with the Rosetta table-copy routines, which move bulk data through PL/SQL table structures during subsidy processing. No other base tables are documented as directly referenced.

Usage Notes

This package is not referenced by any other database object and is classified as OTHER in the API taxonomy, marking it as a private implementation detail rather than a public entry point. It is typically invoked indirectly through the public wrapper/public API surface of OKL_SUBSIDY_PROCESS_PVT rather than called directly by forms, concurrent programs, or custom code. Developers extending or debugging subsidy calculations may encounter it when tracing call stacks or examining dependency chains. Because it is a private component, direct invocation is discouraged; the documented dependency chain (FND_API, OKL_API, OKL_SUBSIDY_PROCESS_PVT) confirms it conforms to standard EBS API error-handling conventions. Custom development should target the corresponding public API instead.