Search Results igi_iac_adj_amort_pkg
Overview
IGI_IAC_ADJ_AMORT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that forms part of the IGI (International Governmental/Public Sector) Fixed Assets adjustment and amortization functionality. Specifically, it belongs to the IGI_IAC (International Assets - Adjustments/Amortization Charges) module, which extends Oracle Assets with additional processing for asset adjustments, depreciation, and revaluation tracking.
The package serves a specialized business function: it handles the amortization of depreciation adjustments and revaluations recorded against fixed assets. When an asset adjustment is applied, the resulting financial impact is not always posted in a single period; instead, it must be amortized over time. This package encapsulates the logic that performs that amortization, generating the necessary depreciation detail and distribution records tied to an adjustment history entry. It also supports the revaluation workflow, which adjusts asset book values in accordance with accounting standards. By centralizing this logic in a package, Oracle ensures consistent treatment of adjustment amortization across concurrent programs, forms, and other calling modules.
Key Procedures and Functions
The metadata documents a single public function within the package specification:
- DO_AMORT_DEPRN_REVAL — The core routine of the package. Based on its name and the parameter types referenced in the specification, it performs amortization of depreciation and revaluation amounts associated with an asset adjustment. It accepts an asset adjustment information structure, a distribution information table, an adjustment history row, and an event identifier (noted as R12 uptake, indicating the event-driven architecture introduced in Release 12). The function returns a BOOLEAN, signaling success or failure of the amortization process so that the caller can branch on the result.
The function is the sole documented entry point; internal helpers, if any, are not part of the public specification and are therefore not exposed or described here.
Tables Accessed
The package reads from and writes to a set of IGI and Oracle Assets tables, as documented through APPS synonyms:
- IGI_IAC_ADJUSTMENTS_HISTORY — Provides adjustment history rows that drive the amortization; the ROWTYPE parameter draws from this table.
- IGI_IAC_ADJUSTMENTS and IGI_IAC_TRANSACTION_HEADERS — Store adjustment definitions and their originating transaction groupings.
- IGI_IAC_ASSET_BALANCES and IGI_IAC_DET_BALANCES — Hold asset-level and detail-level balances updated by the amortization.
- IGI_IAC_FA_DEPRN — The IGI extension of depreciation information, written during amortization.
- FA_ADDITIONS, FA_BOOKS, and FA_DEPRN_DETAIL — Core Oracle Assets tables supplying asset, book, and depreciation detail context, and receiving depreciation detail output.
- PLITBLM — A standard Oracle Applications table used for PL/SQL message/error logging.
Usage Notes
IGI_IAC_ADJ_AMORT_PKG is not intended for direct end-user invocation. It is typically called by other IGI_IAC packages and concurrent programs that manage asset adjustments, depreciation runs, and revaluation cycles. The metadata indicates it is referenced by at least one other package, confirming an internal dependency chain.
Because the routine operates on event identifiers, it aligns with Release 12's event-based transaction model, meaning it may be triggered as part of a larger adjustment approval or posting flow. Customer extension code that calls this package should respect its BOOLEAN return contract and ensure that prerequisite records exist in the adjustment history and distribution structures before invocation.
-
PACKAGE: APPS.IGI_IAC_ADJ_AMORT_PKG
12.1.1
-
PACKAGE: APPS.IGI_IAC_ADJ_AMORT_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_ADJ_AMORT_PKG, status:VALID,
-
SYNONYM: APPS.IGI_IAC_ADJUSTMENTS_HISTORY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_ADJUSTMENTS_HISTORY, status:VALID,
-
PACKAGE BODY: APPS.IGI_IAC_ADJ_AMORT_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_IAC_ADJ_AMORT_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_ADJ_AMORT_PKG
12.2.2
-
PACKAGE: APPS.IGI_IAC_ADJ_AMORT_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_ADJ_AMORT_PKG, status:VALID,
-
SYNONYM: APPS.IGI_IAC_ADJUSTMENTS_HISTORY
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_ADJUSTMENTS_HISTORY, status:VALID,
-
PACKAGE BODY: APPS.IGI_IAC_ADJ_AMORT_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_IAC_ADJ_AMORT_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_TYPES
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_TYPES, status:VALID,
-
PACKAGE: APPS.IGI_IAC_TYPES
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_TYPES, status:VALID,
-
PACKAGE: APPS.IGI_IAC_ADJ_COST_REVAL_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_ADJ_COST_REVAL_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_ADJUSTMENTS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_ADJUSTMENTS_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_FA_DEPRN_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_FA_DEPRN_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_TRANS_HEADERS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_TRANS_HEADERS_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_ADJ_COST_REVAL_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_ADJ_COST_REVAL_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_FA_DEPRN_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_FA_DEPRN_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_ADJUSTMENTS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_ADJUSTMENTS_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_DET_BALANCES_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_DET_BALANCES_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_DET_BALANCES_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_DET_BALANCES_PKG, status:VALID,
-
SYNONYM: APPS.IGI_IAC_FA_DEPRN
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_FA_DEPRN, status:VALID,
-
PACKAGE BODY: APPS.IGI_IAC_ADJ_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_IAC_ADJ_PKG, status:VALID,
-
PACKAGE BODY: APPS.IGI_IAC_ADJ_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_IAC_ADJ_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_TRANS_HEADERS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_TRANS_HEADERS_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_ASSET_BALANCES_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_ASSET_BALANCES_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_ASSET_BALANCES_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_ASSET_BALANCES_PKG, status:VALID,
-
SYNONYM: APPS.IGI_IAC_ADJUSTMENTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_ADJUSTMENTS, status:VALID,
-
SYNONYM: APPS.IGI_IAC_FA_DEPRN
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_FA_DEPRN, status:VALID,
-
SYNONYM: APPS.IGI_IAC_ASSET_BALANCES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_ASSET_BALANCES, status:VALID,
-
SYNONYM: APPS.IGI_IAC_ASSET_BALANCES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_ASSET_BALANCES, status:VALID,
-
SYNONYM: APPS.IGI_IAC_ADJUSTMENTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_ADJUSTMENTS, status:VALID,
-
SYNONYM: APPS.IGI_IAC_DET_BALANCES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_DET_BALANCES, status:VALID,
-
PACKAGE: APPS.IGI_IAC_COMMON_UTILS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_COMMON_UTILS, status:VALID,
-
PACKAGE: APPS.IGI_IAC_COMMON_UTILS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_COMMON_UTILS, status:VALID,
-
SYNONYM: APPS.IGI_IAC_DET_BALANCES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_DET_BALANCES, status:VALID,
-
SYNONYM: APPS.IGI_IAC_TRANSACTION_HEADERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_TRANSACTION_HEADERS, status:VALID,
-
SYNONYM: APPS.IGI_IAC_TRANSACTION_HEADERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_IAC_TRANSACTION_HEADERS, status:VALID,
-
SYNONYM: APPS.FA_DEPRN_DETAIL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FA_DEPRN_DETAIL, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
12.2.2 DBA Data
12.2.2
-
PACKAGE: APPS.IGI_IAC_DEBUG_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_DEBUG_PKG, status:VALID,
-
PACKAGE: APPS.IGI_IAC_DEBUG_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_IAC_DEBUG_PKG, status:VALID,
-
SYNONYM: APPS.FA_DEPRN_DETAIL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FA_DEPRN_DETAIL, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.1.1 DBA Data
12.1.1
-
SYNONYM: APPS.FA_ADDITIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FA_ADDITIONS, status:VALID,
-
SYNONYM: APPS.FA_ADDITIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FA_ADDITIONS, status:VALID,
-
PACKAGE: APPS.FA_SRVR_MSG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FA_SRVR_MSG, status:VALID,
-
PACKAGE: APPS.FA_SRVR_MSG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FA_SRVR_MSG, status:VALID,
-
APPS.IGI_IAC_ADJ_PKG dependencies on IGI_IAC_ADJ_AMORT_PKG
12.1.1
-
APPS.IGI_IAC_ADJ_AMORT_PKG dependencies on IGI_IAC_ADJ_AMORT_PKG
12.1.1