Search Results cse_asset_util_pkg




Overview
Explore in AI Chat

Overview

APPS.CSE_ASSET_UTIL_PKG is a utility package within the Oracle Enterprise Asset Management (eAM) and Enterprise Asset Management for Projects (eAM/CSE) module of Oracle E-Business Suite. Its principal purpose is to centralize the logic required to validate, resolve, and prepare asset-related data before that data is consumed by the higher-level eAM asset lifecycle packages. In release 12.1.1 and 12.2.2, the package acts as a shared utility layer that abstracts common attribute derivation tasks — such as determining an asset category, book type, or depreciation expense charge account — so that the calling packages responsible for asset creation, movement, retirement, and invoice-to-asset processing do not duplicate this logic.

The package is classified as an "OTHER" API object rather than a public or private API, indicating that it is intended primarily for internal use by other CSE packages rather than for direct invocation by external applications. Its status is marked VALID in the APPS schema.

Key Procedures and Functions

The package exposes 28 documented procedures and functions. These are organized around asset attribute resolution and transaction processing helpers:

The dependency list confirms reliance on FND_API for the standard API error and message framework and on CSE_DATASTRUCTURES_PUB for shared PL/SQL record and table types.

Tables Accessed

Through APPS synonyms, the package reads and writes several core tables. CSI_ITEM_INSTANCES, CSI_ITEM_INSTANCES_H, CSI_I_ASSETS, CSI_TRANSACTIONS, CSI_TXN_TYPES, CSI_T_TRANSACTION_LINES, CSI_T_TXN_LINE_DETAILS, CSI_SOURCE_IB_TYPES, and CSI_IB_TXN_TYPES provide the eAM instance, asset, and transaction context. FA_MASS_ADDITIONS and FA_BOOK_CONTROLS are referenced for Fixed Assets integration, specifically the mass additions staging table and book control attributes. AP_INVOICE_DISTRIBUTIONS_ALL, AP_SELF_ASSESSED_TAX_DIST_ALL, and AP_SYSTEM_PARAMETERS supply Payables-side cost and tax information used when deriving item cost and payables accounting. CSI_A_LOCATIONS and CSI_I_ASSETS support location and asset attribute resolution.

Usage Notes

CSE_ASSET_UTIL_PKG is not typically invoked directly from a form or concurrent program. Instead, it is called by nine higher-level packages, including CSE_ASSET_CREATION_PKG, CSE_ASSET_MOVE_PKG, CSE_ASSET_WIP_PKG, CSE_FAC_INSERVICE_PKG, CSE_AP_PA_PKG, CSE_IPV_FA_PKG, CSE_PO_RECEIPT_INTO_PROJECT, and CSE_PROJ_ITEM_IN_SRV_PKG. These callers span asset creation, asset movement, work-in-process, in-service, invoice-to-asset, and receipt-into-project business flows. Customizations should therefore avoid modifying the package directly and should instead rely on documented procedures or Oracle-supported extension points, since changes can affect all dependent eAM asset lifecycle processes.