Search Results get_invoice_amount

Overview

APPS.AP_TRIAL_BALANCE_PKG is a server-side PL/SQL package in Oracle E-Business Suite Payables (AP) that supports the Accounts Payable Trial Balance reporting process. The package assembles and maintains the AP trial balance data set, which presents outstanding liability balances by accounting period and reporting entity, and identifies future-dated and negative-balance conditions that affect period-end reporting integrity. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the defining schema, allowing it to operate consistently within the APPS runtime environment.

The package header carries the version identifier $Header: aptrbals.pls 120.1 2004/10/29 19:05:56 pjena noship $, confirming it as a long-standing component of the Payables reporting infrastructure used across Oracle EBS 12.1.1 and 12.2.2. Its logic intersects with the Subledger Accounting (XLA) and Payables Accounting (AP_AE) table families, reflecting the 12.x transition of AP accounting events into the XLA/GL transfer architecture.

Key Procedures and Functions

• PROCESS_TRIAL_BALANCE — Primary driver that coordinates trial balance processing for a given accounting date, reporting entity, and organization filter set, invoking subordinate routines and honoring the negative-balance-only and debug switches.
• INSERT_AP_TRIAL_BAL — Overloaded routine (two variants distinguished by the presence of a from-date parameter) that populates AP_TRIAL_BAL with computed balance rows.
• INSERT_FUTURE_DATED — Overloaded routine (two variants) that captures future-dated accounting entries so they can be surfaced or excluded appropriately in trial balance output.
• PROCESS_NEG_BAL — Evaluates and processes records exhibiting negative liability balances for the supplied request.
• USE_FUTURE_DATED — Determines whether future-dated transactions should be included based on organization context and the debug switch.
• INSERT_AP_LIABILITY_BALANCE — Populates AP_LIABILITY_BALANCE, providing the underlying liability balance detail consumed by the reporting process.
• UPDATE_TRIAL_BALANCE_FLAG — Updates status or indicator flags on trial balance records during processing.
• IS_REPORTING_BOOKS — Returns whether the current context involves reporting books, gating certain processing paths.
• GET_BASE_CURRENCY_CODE — Retrieves the base (functional) currency code relevant to the reporting entity or ledger context; this routine is commonly referenced by developers extending or debugging trial balance logic.
• GET_INVOICE_AMOUNT — Returns the invoice amount used in balance derivations.

Tables Accessed

The package reads and writes through APPS synonyms against: XLA_GL_TRANSFER_BATCHES_ALL (subledger-to-GL transfer run identification, including the GL transfer run ID collection type declared in the header); AP_ACCOUNTING_EVENTS_ALL, AP_AE_HEADERS_ALL, and AP_AE_LINES_ALL (Payables accounting event and distribution detail); AP_LIABILITY_BALANCE (liability balance storage); AP_SYSTEM_PARAMETERS_ALL (system configuration such as ledger and currency defaults); and AP_TRIAL_BAL (the trial balance result table). No other packages are documented as referencing AP_TRIAL_BALANCE_PKG, indicating it is a top-level report-serving component.

Usage Notes

AP_TRIAL_BALANCE_PKG is typically invoked by the Payables Trial Balance concurrent program, which supplies the request ID, accounting date, reporting entity, and organization WHERE-clause fragments passed as string parameters. Because the functions return BOOLEAN, the package is not directly callable from SQL or from Oracle Forms triggers without wrapper logic; it is intended for PL/SQL invocation. Custom extensions that require the functional currency for a trial balance context should call GET_BASE_CURRENCY_CODE rather than re-deriving currency from ledger tables, ensuring consistency with the packaged reporting logic.