Search Results query_deprn_detail




Overview
Explore in AI Chat

Overview

FA_QUERY_BALANCES_PKG is a public PL/SQL package in the Oracle E-Business Suite Fixed Assets (FA) module, owned by the APPS schema. Its principal business function is to return asset balance information for a given asset and depreciation book without requiring the caller to open and hold cursors against the underlying Fixed Assets balance tables. The package consolidates cost, depreciation reserve, revaluation reserve, year-to-date and life-to-date depreciation, production, amortization, bonus depreciation, and adjusted-cost figures into a single API call, and it also exposes lower-level routines that operate directly on the FA_STD_TYPES.FA_DEPRN_ROW_STRUCT record structure.

The package is classified in ETRM as an "OTHER" API rather than a formally supported business API, which is consistent with its role as an internal query service used by other Fixed Assets programs. In 12.1.1 the package source carries a header revision of 120.1 dated 24-JUN-2005, and the same body is shipped in 12.2.2 with the additional documentation metadata described here. According to ETRM, the package is referenced by 19 other packages, confirming that it is a shared utility rather than an end-user entry point.

Key Procedures and Functions

ETRM documents seven procedures and functions in this package. Parameter lists are not reproduced here; the descriptions below describe purpose only.

  • QUERY_BALANCES — The primary public entry point. It accepts an asset identifier, a depreciation book, and optional period counter, distribution identifier, run mode, and transaction header identifier, and returns a large set of OUT parameters covering cost (X_COST), depreciation reserve (X_DEPRN_RSV), revaluation reserve (X_REVAL_RSV), year-to-date depreciation (X_YTD_DEPRN), year-to-date and revaluation depreciation expense, revaluation amortization, production amounts (period, YTD, and life-to-date), adjusted cost, revaluation amortization basis, bonus rate, depreciation source code, an adjusted flag, and bonus depreciation reserve, YTD, and amount values.
  • QUERY_BALANCES_INT — An internal variant of the same query logic that populates an FA_DEPRN_ROW_STRUCT row rather than individual scalar OUT parameters. It takes a run mode, debug flag, calling function name, and transaction header identifier, and returns a success flag plus the populated depreciation row.
  • ADD_ADJ_TO_DEPRN — Applies adjustment information from an adjustment row (SOURCE) to a destination depreciation row (DEST) for a specified MRC set of books type. Used to merge adjustment values into a depreciation record before it is returned to the caller.
  • QUERY_DEPRN_SUMMARY — Returns depreciation summary information for an asset and book, drawing on the FA_DEPRN_SUMMARY and FA_MC_DEPRN_SUMMARY tables.
  • QUERY_DEPRN_DETAIL — Returns depreciation detail information, reading from FA_DEPRN_DETAIL and FA_MC_DEPRN_DETAIL. This is the routine identified by the search term "query_deprn_detail."
  • GET_PERIOD_INFO — Retrieves period information for a book, including the current period counter, current fiscal year, and number of periods in the fiscal year, along with a success flag.
  • GET_ADJUSTMENTS_INFO — Returns adjustment information for an asset, based on the FA_ADJUSTMENTS and FA_MC_ADJUSTMENTS tables.

Tables Accessed

Through APPS synonyms the package reads FA_ADJUSTMENTS and FA_MC_ADJUSTMENTS for adjustment amounts, FA_BOOKS and FA_MC_BOOKS for book definitions and reporting currency context, FA_BOOK_CONTROLS for the current depreciation period and book control state, FA_CALENDAR_TYPES for fiscal calendar configuration, FA_DEPRN_DETAIL and FA_MC_DEPRN_DETAIL for period-level depreciation expense detail, FA_DEPRN_PERIODS for period and fiscal year information, FA_DEPRN_SUMMARY and FA_MC_DEPRN_SUMMARY for summarized asset balances, and FA_TRANSACTION_HEADERS when a transaction header identifier is supplied. The package is a query service; the accumulated data it returns is intended for read-mostly consumption by Fixed Assets forms, concurrent programs, and reporting logic.

Usage Notes

FA_QUERY_BALANCES_PKG is ordinarily invoked from within other Fixed Assets packages and from Fixed Assets forms that need on-demand asset balance values. QUERY_BALANCES is the appropriate call when scalar balance figures are required; QUERY_BALANCES_INT is appropriate when the caller already works with FA_DEPRN_ROW_STRUCT records. Query calls accept the FA_API_TYPES.log_level_rec_type logging parameter, allowing diagnostic logging to be enabled without changing the call signature. Because the package is classified as OTHER rather than a supported API, customizations that call it should be prepared to re-validate behavior during patching or upgrade, particularly where the package is called across the 12.1.1 to 12.2.2 boundary.