Search Results get_partial_subsidy_amount

Overview

OKL_SUBSIDY_PROCESS_PVT_W is an Oracle E-Business Suite PL/SQL wrapper package owned by the APPS schema, classified in ETRM as an OTHER API object. Its source header identifies it as part of the Oracle Lease Management (OKL) module, with the original revision dated 2003, reflecting its heritage in early Oracle Contracts/Leasing releases. The package serves as the Web (W) interface layer for the private subsidy processing business logic encapsulated in OKL_SUBSIDY_PROCESS_PVT. In Oracle EBS architecture, "_PVT" denotes a private package intended for internal use, and the "_W" suffix indicates a wrapper that adapts the private API for invocation through web-enabled or Rosetta-style table conversion mechanisms.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, a standard pattern for public APIs that access data through APPS synonyms while respecting the caller's session context. It is referenced by zero other packages per the ETRM metadata, indicating it is a leaf-level entry point invoked directly by forms, concurrent programs, or custom code rather than serving as a shared utility.

Key Procedures and Functions

The package exposes six documented procedures and functions, aligned with two functional groupings: table marshalling and subsidy amount computation.

• ROSETTA_TABLE_COPY_IN_P1 — Transfers PL/SQL table data inbound, converting a set of JTF_*_TABLE collections into the private package's ASBV_TBL_TYPE structure. It accepts scalar, date, and number/varchar table arguments for both header-level and line-level subsidy attributes.
• ROSETTA_TABLE_COPY_OUT_P1 — The reciprocal outbound operation, mapping records from OKL_SUBSIDY_PROCESS_PVT.ASBV_TBL_TYPE back into JTF scalar, date, and varchar2 table collections for consumption by the caller.
• GET_SUBSIDY_AMOUNT — Retrieves a general subsidy amount, serving as the base calculation entry point for subsidy processing.
• GET_ASSET_SUBSIDY_AMOUNT — Returns the subsidy amount attributable to a specific leased asset, used where subsidy treatment varies by asset within a contract.
• GET_CONTRACT_SUBSIDY_AMOUNT — Returns the total subsidy amount applicable to a contract as a whole.
• GET_PARTIAL_SUBSIDY_AMOUNT — The function corresponding to the user's search term. It computes a partial subsidy amount, typically relevant when only a portion of a contract, asset, or period qualifies for subsidy. Parameter lists are not documented in the available metadata; developers should inspect the package specification in the database for the authoritative signature.

Tables Accessed

Per the ETRM metadata, the package references one table through APPS synonyms: PLITBLM. This is a PL/SQL index-organized table definition used as a column/attribute template within the Oracle Leasing data model. It supports the ASBV (asset-based subsidy value) structure consumed by the Rosetta copy procedures, functioning as the structural anchor for the subsidy attribute collections marshalled in and out of the private package. No other base tables are documented as directly referenced.

Usage Notes

OKL_SUBSIDY_PROCESS_PVT_W is not intended for general application calls. It is typically invoked by Oracle Lease Management forms and concurrent programs that need to compute subsidy amounts during contract booking, asset assignment, or subsidy reconciliation, and by custom PL/SQL code that requires programmatic access to the same calculations. Because the package is AUTHID CURRENT_USER and is documented as referenced by zero other packages, integrators should treat it as a low-level entry point and wrap calls in their own exception handling. When invoking GET_PARTIAL_SUBSIDY_AMOUNT or its siblings, confirm the exact parameter signature from the package specification in the target environment, as ETRM does not publish argument lists. This behavior is consistent across 12.1.1 and 12.2.2, where the object remains an APPS-owned private wrapper.