Search Results g_asset_number

Overview

APPS.FA_CUA_MASS_EXT_RET_PKG is an Oracle E-Business Suite Fixed Assets package body responsible for processing mass external retirements. The package provides the PL/SQL implementation behind the Mass External Retirement business flow, allowing a set of assets to be retired in a single batch rather than through individual retirement transactions. The "CUA" infix denotes that the package belongs to the external retirement / additions extensions used to load and validate asset retirements originating outside the standard Fixed Assets form flow. The package body opens by declaring a block of global variables that mirror the columns of FA_MASS_EXT_RETIREMENTS, including Mass_External_Retire_Id, Book_Type_Code, Batch_Name, Asset_Id, Transaction_Name, Date_Retired, Cost_Retired, Retirement_Prorate_Convention, Units, Cost_Of_Removal, Proceeds_Of_Sale, Retirement_Type_Code, Reference_Num, Sold_To, Trade_In_Asset_Id, Stl_Method_Code, Stl_Life_In_Months, Stl_Deprn_Amount, and the ITC recapture attributes Itc_Recaptured and Itc_Recapture_Id.

The user search term g_asset_number corresponds directly to one of these global variables, declared as G_Asset_Number fa_additions_b.asset_number%TYPE. This global holds the user-visible asset number while the package processes a retirement record, bridging the internal Asset_Id key to the asset number displayed and entered on the Mass External Retirements interface.

Key Procedures and Functions

The documented package exposes three program units:

• MASS_EXT_RETIRE — The principal processing routine. It drives the mass external retirement logic, consuming the global variables populated from FA_MASS_EXT_RETIREMENTS and applying the retirement to the affected asset books. It is the entry point called to retire a batch of assets.
• PURGE — A housekeeping routine used to remove processed mass external retirement rows and associated staging data once the batch has been applied, keeping the interface and retirement tables clean.
• WRITE_MESSAGE — A diagnostic / messaging utility used to surface processing messages to the caller, typically for error handling and reporting during a mass retirement run.

No parameter lists are documented and none are inferred here; the procedures are described solely by their functional role within the package.

Tables Accessed

The package reads and writes a defined set of Fixed Assets tables through APPS synonyms:

• FA_MASS_EXT_RETIREMENTS — The driving interface/staging table; the global variables mirror its columns and supply the retirement data consumed by MASS_EXT_RETIRE.
• FA_ADDITIONS_B — Source of asset master information, including the asset number held in G_Asset_Number.
• FA_BOOKS and FA_BOOK_CONTROLS — Retrieve book-level cost, depreciation, and set-of-books context for the retirement.
• FA_RETIREMENTS and FA_EXT_INV_RETIREMENTS — Target tables where applied retirement records, including ITC recapture details, are written.
• FA_ASSET_HISTORY — Provides current units and historical balances used when computing retirement amounts (G_Current_Units).
• FA_DISTRIBUTION_HISTORY and FA_ASSET_INVOICES — Support distribution and invoice-related validation of the retired asset.
• FA_LOOKUPS — Validation of lookup-driven codes such as retirement type and prorate conventions.
• FND_CURRENCIES — Currency validation using G_Currency_Code.
• PLITBLM — A standard EBS utility table used in message handling.

Usage Notes

FA_CUA_MASS_EXT_RET_PKG is not referenced by any other package, indicating it is invoked directly rather than through internal dependency chains. It is typically called from the Fixed Assets Mass External Retirements concurrent program or from the associated external retirement entry forms, where a batch of externally sourced assets is loaded and processed. Because the package maintains global state across its procedures, callers should ensure a single-threaded invocation per batch and reinitialize globals between runs. The presence of PURGE confirms that the staging rows in FA_MASS_EXT_RETIREMENTS are intended to be periodically cleared after successful processing. The G_Asset_Number global (declared from FA_ADDITIONS_B.asset_number) is central to user-facing error messages generated via WRITE_MESSAGE, allowing failed retirements to be reported by asset number rather than internal ID.