Search Results is_balance_valid_before_add

Overview

OKL_ASSET_SUBSIDY_PVT is a private (PVT) PL/SQL package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, owned by the APPS schema. It encapsulates the core business logic required to create, maintain, validate, and calculate asset subsidies and subsidy pools attached to lease and finance contracts. Subsidies represent monetary contributions—typically from a vendor or third party—that reduce the cost or obligation associated with a leased asset. Because the package is classified as PVT, it is not exposed as a public API; it is invoked internally by the public OKL asset subsidy APIs, by the subsidy maintenance forms, and by other dependent packages (the metadata records that it is referenced by ten other packages).

The package declares global record and table types (asb_rec_type, asb_tbl_type) that mirror the OKL_ASSET_SUBSIDIES_UV view, plus line-style and stream-type constants that identify the 'SUBSIDY' line and stream classes. These global structures allow the private procedures to pass subsidy data consistently between validation, calculation, and DML operations within a single logical transaction.

Key Procedures and Functions

The package exposes twenty-one documented procedures and functions. They fall into several functional groups.

• VALIDATE_SUBSIDY_APPLICABILITY — the entry point most commonly associated with subsidy eligibility. It determines whether a subsidy may be applied to a given asset/contract context before any DML is attempted.
• VALIDATE_SUBSIDY_POOL_APPLIC — validates whether a subsidy can be applied to a subsidy pool.
• IS_SUB_ASSOC_WITH_POOL — checks whether a given subsidy is associated with a specified pool.
• IS_SUB_POOL_ACTIVE / IS_SUB_POOL_ACTIVE_BY_DATE — determine whether a subsidy pool is currently active, optionally evaluated as of a supplied date.
• IS_SUB_POOL_CONV_RATE_VALID — verifies that the conversion rate associated with a subsidy pool is valid.
• IS_BALANCE_VALID_BEFORE_ADD / IS_BALANCE_VALID_AFTER_ADD — enforce balance integrity before and after a subsidy is added to a pool.
• CREATE_ASSET_SUBSIDY / UPDATE_ASSET_SUBSIDY / DELETE_ASSET_SUBSIDY — perform the DML operations for asset subsidy records.
• VALIDATE_ASSET_SUBSIDY — performs comprehensive validation of an asset subsidy record.
• CALCULATE_ASSET_SUBSIDY — computes subsidy amounts, including any override amounts, for the asset subsidy record.

Tables Accessed

The package reads and writes several OKL, OKC, and HZ tables through APPS synonyms. Contract data is drawn from OKC_K_HEADERS_B and OKC_K_LINES_B, which anchor subsidies to contract headers and lines. Subsidy definitions are read from OKL_SUBSIDIES_B and OKL_SUBSIDIES_TL (the translated name/description columns), while OKL_SUBSIDY_POOLS_B holds pool definitions used by the pool-validation routines. Stream type information comes from OKL_STRM_TYPE_B. Customer and party data are resolved through HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNTS_ALL, HZ_PARTIES, HZ_LOCATIONS, HZ_PARTY_SITES, and HZ_PARTY_SITE_USES, and contact information through OKC_CONTACTS. Error and diagnostic information is written to FND_NEW_MESSAGES and FND_LOG_MESSAGES.

Usage Notes

OKL_ASSET_SUBSIDY_PVT is not called directly from client code. It is invoked by the public asset subsidy API layer, by the Oracle Forms-based subsidy maintenance screens, and by the ten dependent packages identified in the metadata. Because it is a private package, its signature and behavior are subject to change between releases and should not be relied upon by customizations. Custom code requiring subsidy validation or calculation should use the corresponding public OKL APIs, which in turn delegate to this package. When debugging subsidy applicability errors, DBAs can inspect FND_LOG_MESSAGES and FND_NEW_MESSAGES for diagnostic output produced by the validation routines.