Search Results no_neg_balance

Overview

QLTINVCB is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Quality (QLT) product family and, based on its naming and the declared AUTHID CURRENT_USER clause, functions as a control-layer or business-rule validation package rather than a general-purpose utility. Its central responsibility is to evaluate inventory control settings — organization, subinventory, and item level controls together with restriction and negative-balance flags — and to determine whether a proposed inventory transaction is permitted before it is allowed to proceed.

The package is classified as OTHER in the ETRM repository, indicating that it is not an externally published or customer-facing API, but an internal helper invoked by higher-level inventory and quality processing logic. It exposes two documented program units: the function NO_NEG_BALANCE and the function CONTROL.

Key Procedures and Functions

• NO_NEG_BALANCE — A Boolean-returning function that evaluates whether a negative balance situation is prohibited for the given context. It accepts a restriction flag, a negative-balance flag, and an action indicator, and returns TRUE or FALSE to communicate whether the operation respects the no-negative-balance constraint. It carries a PRAGMA RESTRICT_REFERENCES declaration for WNDS and WNPS, confirming it performs no database writes and no package-state writes.
• CONTROL — A numeric-returning function that acts as the primary control-checking entry point. It accepts organization, subinventory, and item control parameters together with restriction, negative-balance, and action parameters, all defaulted to NULL. Its return value signals the outcome of the control evaluation, allowing callers to branch on the result. Like NO_NEG_BALANCE, it is declared with RESTRICT_REFERENCES for WNDS and WNPS, reinforcing that it is a read-only evaluator.

Tables Accessed

The ETRM metadata for this object does not enumerate any tables referenced through APPS synonyms. Consistent with its read-only pragmas, the package is expected to read control-definition data — such as organization, subinventory, and item control records — rather than to write transactional data. Because no table list is documented, integrators should treat the package as a decision provider whose underlying data dependencies are internal and subject to change, and should not assume stable table-level coupling.

Usage Notes

QLTINVCB is referenced by four other packages, indicating it is invoked as a subordinate validation routine within larger inventory and quality workflows rather than being called directly from forms or concurrent programs. Its WNDS/WNPS pragmas make it safe for use inside SQL statements and in contexts where no side effects are permitted, such as function-based indexes or query predicates. The AUTHID CURRENT_USER declaration means privilege resolution follows the invoking schema, so any caller must itself hold appropriate access to underlying objects.

Customizations that rely on this package should call CONTROL for consolidated control evaluation and NO_NEG_BALANCE for targeted negative-balance checks, handling the Boolean and numeric return values accordingly. Because the package is not an ETRM-published API, its signature should be treated as internal, and any dependency should be validated against the target release before deployment.