Search Results vat_calc_amt




Overview
Explore in AI Chat

Overview

APPS.AP_OPEN_BAL_REV_RPT_PKG is a PL/SQL package whose body resides in the APOBRRPB.pls script under the APPS schema. Its documented purpose is to support the Oracle Payables Open Balances Revaluation Report, a reporting process that revalues open accounts payable balances using foreign exchange rates and produces a report of the resulting revaluation amounts. The package body carries the header identifier $Header: APOBRRPB.pls 120.5.12020000.2 2012/07/13 12:13:30 mkmeda ship $ and is classified in ETRM as an OTHER API (not a public, exposed API). It was originally created on 21-FEB-2007 by Praveen Gollu (version 1.0) and modified on 25-JAN-2008 by Sandeep G under fix for Bug #6773558.

The package depends on Oracle General Ledger and HR operating unit data to establish the reporting context. In its BEFOREREPORT logic it resolves the ledger and functional currency for the current operating unit, queries GL_LEDGERS and HR_OPERATING_UNITS, and falls back to FND_GLOBAL.ORG_ID when the passed organization identifier is null (referencing Bug #9564002 and Bug #9725033). This establishes the exchange rate type and currency context needed for subsequent revaluation calculations.

Key Procedures and Functions

  • BEFOREREPORT — Initialization function that returns a BOOLEAN. It resolves the organization identifier, ledger identifier, functional currency, and operating unit name, and prepares the exchange rate type context for the report. This is where the searched term exch_rate first appears, since it declares the local variable for exchange rate type and the exception ex_exchange_rate_type.
  • EXCH_RATE_CALC — Performs the exchange rate calculation used to revalue open balances. This procedure is the direct consumer of the exch_rate lookup logic central to the report.
  • AMTDUEFILTER — Applies filtering to determine which amounts are due for consideration in the revaluation report, isolating the relevant open balance records.
  • AMTDUEREVAL — Computes the revaluation result for amounts due, converting open balances using the calculated rates.
  • VAT_CALC_AMT — Calculates the tax (VAT) amount associated with the revaluation, ensuring tax components are handled consistently with the revalued balances.

Five documented procedures and functions are exposed in ETRM. Parameter lists are not enumerated in the metadata and should not be inferred.

Tables Accessed

  • GL_DAILY_RATES — Referenced through an APPS synonym. Provides the exchange rate values consumed by EXCH_RATE_CALC when translating open balances into the functional currency. This table is the principal data source for the searched term exch_rate.
  • GL_LEDGERS — Also referenced via an APPS synonym. Read during BEFOREREPORT to obtain the ledger identifier and functional currency code, which anchor all subsequent rate and revaluation logic.

Usage Notes

AP_OPEN_BAL_REV_RPT_PKG is an internal supporting package rather than a publicly callable API. ETRM records zero other packages referencing it, indicating it is invoked through the Payables Open Balances Revaluation Report concurrent program or its associated report driver rather than by external custom code. The BEFOREREPORT function follows the standard Oracle Reports Before Report trigger pattern, making it the entry point for setup and validation. Because the package relies on FND_GLOBAL.ORG_ID and HR_OPERATING_UNITS, correct multi-org context is essential; callers should ensure an operating unit is set before invocation. No parameters or return signatures are documented in the metadata beyond those shown, and implementers should treat the package as release-specific (12.1.1 and 12.2.2) internal functionality.