Search Results getcsi_attribute_id

Overview

The APPS.AHL_PRD_SERN_CHANGE_PVT package body is a private (PVT) API within the Oracle EBS Product Lifecycle Management (PLM) and Advanced Supply Chain suite, operating under the AHL (Product Development / Genealogy) application schema. Its core business function is to manage changes to serial numbers (serial tags) associated with item instances tracked through Oracle's Complex Maintenance, Repair, and Overhaul (CMRO) and enterprise asset management flows. Specifically, the package supports the reassignment, re-identification, and attribute maintenance of serialized units, ensuring that the relationship between an item instance (CSI_ITEM_INSTANCES), its serial number record (MTL_SERIAL_NUMBERS), and the associated extended attributes remains consistent. The package is classified as private, meaning it is intended to be invoked by other packages rather than directly by end users or forms — the ETRM metadata indicates it is referenced by five other packages. Because the user search term was "getcsi_attribute_id", note that the source excerpt contains closely related helper logic: GetCSI_Transaction_ID and GetCSI_Attribute_ID, which resolve CSI transaction type and attribute identifiers respectively.

Key Procedures and Functions

The ETRM metadata documents three procedures/functions in this package:

• GET_SERIALTAG_CODE — Retrieves the serial tag code value associated with a serialized unit, providing the standardized tag identifier used to categorize the serial number within the AHL genealogy model.
• GET_SERIALTAG_MEANING — Returns the descriptive meaning (display text) corresponding to a serial tag code, enabling user-readable labeling of serial tag values.
• PROCESS_SERIALNUM_CHANGE — The primary driver procedure that performs the serial number change operation, orchestrating validation, CSI attribute/transaction resolution, and the update of the affected item instance, serial number, and configuration records.

The source excerpt additionally reveals two local helper procedures: GetCSI_Transaction_ID, which resolves a transaction_type_id from CSI_TXN_TYPES by matching source application 'AHL' and a supplied transaction code, raising AHL__TXNCODE_INVALID when not found; and GetCSI_Attribute_ID, which queries CSI_I_EXTENDED_ATTRIBS for a global-level attribute ID matching a supplied attribute code. These helpers embody the "GetCSI" naming pattern the user searched for and underpin the attribute resolution logic used by PROCESS_SERIALNUM_CHANGE.

Tables Accessed

The package reads and writes the following documented tables (via APPS synonyms):

• MTL_SERIAL_NUMBERS — The central serial number repository; the primary target of serial tag change operations.
• CSI_ITEM_INSTANCES — Item instance master records linking serialized instances to items.
• CSI_I_EXTENDED_ATTRIBS / CSI_IEA_VALUES — Extended attribute definitions and their instance values, used for CSI attribute resolution.
• CSI_II_RELATIONSHIPS — Relationships between item instances, maintained when serial associations change.
• CSI_TXN_TYPES and FND_APPLICATION — Used to resolve CSI transaction type identifiers for AHL-sourced transactions.
• AHL_UNIT_CONFIG_HEADERS and AHL_WORKORDERS — AHL configuration and work order context affected by serial changes.
• MTL_RESERVATIONS and MTL_SYSTEM_ITEMS_KFV — Reservation and item flexfield validation.

Usage Notes

As a private package, AHL_PRD_SERN_CHANGE_PVT is invoked indirectly. It is typically called from the AHL serial number change UI (Oracle Forms) through its public wrapper, from concurrent programs performing bulk serial reassignment, and from custom extensions that must programmatically alter serial tags while preserving CSI attribute and relationship integrity. The presence of FND_MESSAGE/FND_MSG_PUB calls indicates errors are surfaced through the standard EBS message stack. Developers integrating with this package should rely on the public API layer rather than calling PVT procedures directly, since signatures may change between 12.1.1 and 12.2.2.