Search Results validate_subsidy

Overview

OKL_SUBSIDY_PVT is a private (PVT-classified) PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the subsidy functionality within Oracle Lease and Finance Management (OKL). Under the ETRM 12.1.1 and 12.2.2 releases, this package operates alongside the public API layer to manage subsidy records and their associated criteria, which are used to model vendor-funded or program-funded concessions applied to lease contracts. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, which is characteristic of the lower-level private implementation packages in the OKL product family.

The package builds directly on subtype definitions imported from the sibling private packages OKL_SUB_PVT and OKL_SUC_PVT, reusing the subsidy record and table type definitions (subv_rec_type, subv_tbl_type, sucv_rec_type, sucv_tbl_type). This design indicates that OKL_SUBSIDY_PVT acts as a coordination layer over subsidy header data and subsidy criteria data simultaneously. The header carries global message constants from OKL_API, including standard error tokens such as G_REQUIRED_VALUE, G_INVALID_VALUE, G_RECORD_LOGICALLY_DELETED, and G_UNEXPECTED_ERROR, along with a global G_EXCEPTION_HALT_VALIDATION exception used to short-circuit validation when a fatal condition is detected.

Key Procedures and Functions

The package exposes 21 documented procedures and functions organized into three functional groups:

• Subsidy header operations: CREATE_SUBSIDY, UPDATE_SUBSIDY, DELETE_SUBSIDY, LOCK_SUBSIDY, and VALIDATE_SUBSIDY. These provide the core insert, modify, remove, and concurrency-locking operations for subsidy header rows, with VALIDATE_SUBSIDY performing the business-rule checks that the user searched for. It is the routine that enforces required values, referential integrity, and subsidy-specific validation logic before a subsidy can be saved or used.
• Subsidy criteria operations: CREATE_SUBSIDY_CRITERIA, UPDATE_SUBSIDY_CRITERIA, DELETE_SUBSIDY_CRITERIA, LOCK_SUBSIDY_CRITERIA, and VALIDATE_SUBSIDY_CRITERIA. These mirror the header operations for the criteria child records that define the qualifying conditions attached to a subsidy.
• Language and utility operations: ADD_LANGUAGE, which inserts translated (language-specific) rows for subsidy and criteria data into the corresponding _TL tables in accordance with Oracle's multi-language support (MLS) architecture.

The presence of paired LOCK and VALIDATE routines for both header and criteria entities confirms that this package is designed to be called from Oracle Forms-based maintenance screens, where record locking and validation are performed before the form commits.

Tables Accessed

The package reads and writes the base subsidy table OKL_SUBSIDIES_B, accessed through an APPS synonym, which stores the subsidy header records (identifier, name, amount, status, and related attributes). ADD_LANGUAGE additionally references the multi-language translation structures associated with subsidy data. The package also references WF_PARAMETER_LIST_T, the Workflow parameter list type used by the Oracle Workflow engine, indicating that subsidy processing can raise or be driven by workflow events. The subtype definitions sourced from OKL_SUB_PVT and OKL_SUC_PVT imply indirect manipulation of the subsidy criteria tables managed by those packages.

Usage Notes

Because this is a private package, it is not intended for direct invocation by external customizations; the supported entry points for subsidy creation and maintenance are the corresponding public APIs. OKL_SUBSIDY_PVT is invoked internally by the Oracle Lease and Finance Management subsidy setup forms, and it is referenced by two other packages within the OKL schema, which call it to persist or validate subsidy data as part of larger transactions. Customer extensions should avoid calling OKL_SUBSIDY_PVT directly, since its signature and behavior may change between patch levels without notice.