Search Results select_assets

Overview

APPS.FA_CUA_DERIVE_ASSET_ATTR_PKG is a PL/SQL package within the Oracle E-Business Suite Fixed Assets (FA) module. It operates in the CUA (Corporate / Universal Accounting) custom layer of FA, supporting mass maintenance of asset attributes and the derivation of asset attribute values used by related CUA packages. The package is classified under the generic API category "OTHER," indicating that it is not a public, supported open interface but an internal helper invoked by other EBS components. In Oracle EBS 12.1.1 and 12.2.2 the object is registered as VALID in the APPS schema, and its dependency footprint confirms its role as a shared utility for asset attribute derivation and mass update processing, referenced by FA_CUA_ASSET_APIS, FA_CUA_HR_RETIREMENTS_PKG, and FA_ASSET_HIERARCHY_PVT.

Key Procedures and Functions

• SELECT_ASSETS — Populates a collection of assets that match the criteria supplied by the calling process. This procedure underpins the asset selection used both for hierarchy processing and for mass update routines, allowing callers to obtain a working set of asset identifiers before deriving or changing attributes.
• INSERT_MASS_UPDATE_BATCH_HDRS — Creates the header record of a Fixed Assets mass update batch. It writes the batch-level definition, including the attributes to be changed and the scope of the mass update, so that the associated batch lines can be processed.
• INSERT_MASS_UPDATE_BATCH_DTLS — Inserts the detail (line) records for a mass update batch, associating individual assets with the batch header created by INSERT_MASS_UPDATE_BATCH_HDRS. This forms the row-level work list that the FA mass update programs subsequently act upon.

Tables Accessed

The package references the following tables through APPS synonyms, consistent with the documented ETRM dependency list:

• FA_ADDITIONS — the master asset table, read to derive and validate asset attributes and to obtain asset identifiers for selection.
• FA_BOOKS and FA_BOOK_CONTROLS — read to resolve depreciation book context and the control settings that govern attribute derivation and mass update processing.
• FA_ASSET_HIERARCHY — used in conjunction with the hierarchy package to derive attributes for assets organized in parent/child relationships.
• FA_MASS_UPDATE_BATCH_HEADERS and FA_MASS_UPDATE_BATCH_HDRS_S — the batch header table and its sequence, written by INSERT_MASS_UPDATE_BATCH_HDRS.
• FA_MASS_UPDATE_BATCH_DETAILS — the batch line table, written by INSERT_MASS_UPDATE_BATCH_DTLS.
• DUAL and PLITBLM — utility references; PLITBLM is the standard PL/SQL index-by table used for passing collections between PL/SQL and callers.

Usage Notes

FA_CUA_DERIVE_ASSET_ATTR_PKG is not intended for direct invocation by end users or external interfaces. It is called internally by FA_CUA_ASSET_APIS, FA_CUA_HR_RETIREMENTS_PKG, and FA_ASSET_HIERARCHY_PVT, and it also references FA_API_TYPES, confirming that it participates in the FA API type infrastructure. In practice it is invoked when a user runs Fixed Assets mass maintenance or asset hierarchy operations that require attribute derivation, and when the CUA asset APIs prepare batch processing. The package's procedures are typically reached through the Fixed Assets application forms or through the batch programs that those forms launch. Customizations and extensions should avoid calling these procedures directly, because they assume the caller has already established the correct FA context and collection structures; supported integration points for asset data remain the documented FA open interfaces. As with all APPS-schema FA packages, changes should be applied and validated against the specific EBS release (12.1.1 or 12.2.2) in use, since internal signatures are not guaranteed to remain stable across patch levels.