Search Results calc_qv

Overview

APPS.AP_FUNDS_CONTROL_PKG is a PL/SQL package within the Oracle E-Business Suite Payables (AP) module that implements funds control and budgetary validation logic for invoice processing. Its primary business function is to determine whether sufficient funds or budget authority exist before an invoice, invoice distribution, or related accounting event is approved and posted. In public sector and encumbrance-enabled implementations, this package is central to enforcing budgetary control so that expenditures cannot exceed authorized appropriations. The package status is VALID and it is owned by the APPS schema, placing it among the standard delivered APIs and internal packages used by Payables.

The user search term "ap_approval_pkg" is directly relevant: AP_FUNDS_CONTROL_PKG references AP_APPROVAL_PKG and is itself referenced by AP_APPROVAL_PKG, forming a tightly coupled relationship in the invoice approval cycle. AP_FUNDS_CONTROL_PKG also references PSA_AP_BC_PVT, which connects it to Oracle Public Sector Budgetary Control functionality.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents seven procedures and functions, classified as OTHER API category:

• FUNDS_RESERVE — Reserves funds against the applicable budget or encumbrance balance when an invoice or distribution requires validation.
• GET_ERV_CCID — Retrieves the Expense Reimbursement Voucher related code combination identifier used in funds control accounting.
• ENCUM_UNPROCESSED_EVENTS_DEL — Deletes unprocessed encumbrance events, supporting cleanup of pending budgetary events.
• CALC_QV — Calculates quantities or quantitative validation values used in funds checking calculations.
• CALC_AV — Calculates available values, contributing to the derivation of available funds or budget balances.
• FUNDS_CHECK — Performs the core funds availability check determining whether a transaction can proceed.
• FUNDS_CHECK_PROCESSOR — Orchestrates the funds check process, likely invoking the supporting calculation routines.

No parameter lists are documented in the source metadata, and none are asserted here.

Tables Accessed

The package accesses a broad set of Payables and system parameter tables through APPS synonyms, including AP_INVOICES and AP_INVOICES_ALL for invoice header data, AP_INVOICE_DISTRIBUTIONS and AP_INVOICE_DISTRIBUTIONS_ALL for distribution lines, AP_INVOICE_LINES and AP_INVOICE_LINES_ALL for line detail, and AP_BATCHES for invoice batch context. It also reads AP_HOLDS and AP_HOLD_CODES to evaluate hold conditions that may block funds reservation, AP_PREPAY_APP_DISTS and AP_PREPAY_HISTORY_ALL for prepayment application data, and AP_SELF_ASSESSED_TAX_DIST_ALL for self-assessed tax distributions. System-level parameters are drawn from AP_SYSTEM_PARAMETERS, FINANCIALS_SYSTEM_PARAMETERS, and FINANCIALS_SYSTEM_PARAMS_ALL, which govern funds control and budgetary behavior.

Usage Notes

AP_FUNDS_CONTROL_PKG is typically invoked indirectly rather than called directly by end users. It is referenced by four other packages, notably AP_APPROVAL_PKG and AP_APPROVAL_MATCHED_PKG, meaning it executes as part of the standard invoice approval and matching workflow. When the Payables Invoice Workbench or approval concurrent programs process an invoice requiring budgetary validation, these calling packages delegate funds control logic here. Custom code should generally call the higher-level approval APIs rather than this package directly, since AP_FUNDS_CONTROL_PKG operates as an internal supporting component. Developers extending Payables funds control should treat it as a dependent package whose behavior is driven by the approval cycle.