Search Results update_desc

Overview

The PL/SQL package body APPS.FA_ASSET_DESC_PUB is a public-API component of the Oracle E-Business Suite Fixed Assets module, shipped with the 12.1.1 and 12.2.2 releases. It exposes a controlled, validated entry point for maintaining descriptive and category attributes of an asset without requiring callers to manipulate the underlying Fixed Assets base tables directly. The package is classified as a PUB API and is documented against the ETRM 12.2.2 repository with owner APPS.

Its principal business purpose is to allow an asset's descriptive information — descriptions, warranty data, and category references — to be created or amended through a single supported interface that performs validation, derives defaulting values, and raises standard FND_API–compliant return status and message data. The package header identifies the API as "Update Asset Description API" at version 1.0, indicating the original and still-current public interface definition for this object.

Key Procedures and Functions

The package publishes three documented procedures. Private helper routines, including update_row and initialize_category_df, support the internal update logic and category defaulting but are not part of the public contract.

• UPDATE_DESC — The core public entry point for modifying descriptive information on a single asset. It accepts the standard Oracle API parameters (API version, initialization flag, commit flag, validation level, plus the standard return status, message count, and message data outputs), a transaction record, an asset header record, and both a new asset description record and a new asset category record. The procedure validates the incoming data, applies the changes, and reports success or failure through the standard status outputs. It is the procedure most directly associated with the search term do_retirement_desc_update, which corresponds to the retirement-related path within the description update family.
• UPDATE_INVOICE_DESC — Updates description attributes in the invoicing context, providing the same validated, message-driven behaviour for description maintenance triggered from invoice-related processing.
• UPDATE_RETIREMENT_DESC — Updates description attributes associated with a retirement transaction, allowing descriptive information for retired or partially retired assets to be maintained through the supported API rather than by direct SQL.

Each procedure follows the uniform FND_API convention for error handling and logging, using the package-level log level record to control diagnostic output.

Tables Accessed

The package reads and writes the following Fixed Assets tables through APPS synonyms:

• FA_BOOKS — Holds the asset distribution and book-level balances; read for validation and context when applying descriptive changes.
• FA_BOOK_CONTROLS — Defines the accounting rules and control settings for each book; consulted to validate the books affected by the update.
• FA_MC_BOOKS_RATES — Stores multi-currency rates and book conversion information used when book relationships must be validated.
• FA_SYSTEM_CONTROLS — Provides system-level defaults and options, such as the depreciation calendar and defaulting behaviour, that influence the update.
• PLITBLM — The standard Oracle EBS messages table, used to retrieve and format error and informational message text.

Usage Notes

The package is invoked from Fixed Assets forms, concurrent processing, and custom extensions that need to alter asset descriptions under supported validation. It is referenced by five other packages in the environment, indicating it functions as a shared lower-level service within the Fixed Assets API stack.

Callers should supply the standard API parameters, set p_commit appropriately to control transaction boundaries, and always inspect x_return_status and the retrieved message stack. Direct table updates should be avoided in favour of this public API, which ensures consistency with the surrounding validation and concurrency logic.