Search Results g_book_type_code

Overview

The APPS.IGI_IAC_REINSTATE_PKG package body is a component of the Oracle E-Business Suite International Assets and Cash (IAC) module, which extends the standard Oracle Assets (FA) functionality for global asset accounting and tax-book reporting. Its principal business function is to reverse, or reinstate, an asset retirement transaction that was previously processed, restoring the asset and its associated depreciation balances to their pre-retirement state. Reinstatement is required when a retirement was recorded in error, when disposal documentation is reversed, or when audit findings demand that a retired asset be returned to active service.

The package body is owned by APPS and is classified as OTHER within the ETRM repository. It is referenced by one other package, indicating that it operates as a lower-level utility invoked by higher-level IAC processing logic rather than being a standalone entry point. It is documented as exposing a single procedure, DO_IAC_REINSTATEMENT.

The source header ($Header: igiiarnb.pls 120.25.12020000.1 2012/06/27 ...) confirms the package is current as of the 12.2.2 code line and is maintained under the standard Oracle EBS configuration-management conventions. The package is relevant to release 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface consists of one procedure:

• DO_IAC_REINSTATEMENT — The single documented entry point. It performs the reinstatement of an asset retirement within the IAC framework, rebuilding the asset's transaction and depreciation position. The procedure relies on package-level global variables rather than a large explicit parameter list; among these globals is g_book_type_code, declared as igi_iac_transaction_headers.book_type_code%TYPE. Because the user query referenced g_book_type_code, it is worth noting that this global determines the depreciation book (book type) against which the reinstatement is evaluated and applied. Alongside it, the package maintains g_asset_id, g_retirement_id, and g_adj_prior_ret (the prior-retirement adjustment identifier), all anchored to columns on igi_iac_transaction_headers.

The package also declares a private record type, fa_reins_rec_info, which aggregates the attributes needed to process a reinstatement — including asset_id, book_type_code, transaction_header_id, transaction_type_code, transaction_date_entered, date_effective, mass_reference_id, transaction_subtype, asset_category_id, set_of_books_id, curr_period_counter, and eff_ret_period_counter. It further defines cursors such as c_fully_reserved, which checks FA_BOOKS for the fully reserved period counter, and c_fa_units_assigned, which obtains assigned units from distribution history. Logging globals using FND_LOG levels support diagnostic tracing.

Tables Accessed

The package reads and writes the following tables (through APPS synonyms):

• FA_BOOKS — Determines whether the asset is fully reserved and holds book-level asset balances.
• FA_ADDITIONS / FA_ADDITIONS_B — Source of asset descriptive and assignment data.
• FA_DEPRN_DETAIL / FA_DEPRN_PERIODS — Depreciation detail and period definitions used to restore depreciation after reinstatement.
• FA_DISTRIBUTION_HISTORY — Supplies units assigned and distribution records affecting reinstatement basis.
• FA_TRANSACTION_HEADERS — Standard asset transaction records reconciled against IAC counterpart rows.
• IGI_IAC_TRANSACTION_HEADERS / IGI_IAC_ADJUSTMENTS — The IAC-specific transaction header and adjustment entries created or reversed during reinstatement.
• IGI_IAC_ASSET_BALANCES / IGI_IAC_DET_BALANCES — IAC asset and detail balances updated to reflect the reinstated position.
• IGI_IAC_FA_DEPRN — The IAC depreciation bridge table reconciled with standard FA depreciation.

Usage Notes

The package is not a top-level API; it is invoked indirectly by higher-level IAC processing logic. Typical invocation paths include IAC reinstatement processing triggered from Oracle Assets forms, concurrent programs that reprocess IAC transactions, or custom extensions that must reverse a previously recorded retirement. Because the interface is a single procedure driven by package globals, callers cannot supply parameters directly; the global variables (including g_book_type_code, g_asset_id, and g_retirement_id) must be populated before the procedure is called, and this behavior should be treated as internal implementation rather than a supported public contract. Custom development should prefer the supported IAC APIs and avoid direct invocation. Organizations should validate any related customizations against the 12.1.1 and 12.2.2 code lines, since the package header reflects ongoing maintenance. Transaction changes performed here should be considered in the context of the corresponding GL postings.