Search Results csd_group_serial_number_pvt

Overview

CSD_GROUP_SERIAL_NUMBER_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a PVT (private) API. Its stated purpose, as recorded in the package header, is to provide the private APIs for creating, updating, and deleting serial numbers associated with repair groups in Oracle Depot Repair. The header comment explicitly notes that access is restricted to Oracle Depot Repair internal development, making this package an internal implementation layer rather than a supported public interface. The package declares AUTHID CURRENT_USER and carries a header revision of 115.5, dated 2002, reflecting its long-standing presence across the 12.1.1 and 12.2.2 releases.

The user search term "ib_flag" corresponds directly to a column declared in the package's central record type, SERIAL_NUMBER_Rec_Type. That record type defines the full attribute set used when creating and updating repair order serial numbers, and IB_FLAG is one of its members, typed as VARCHAR2(1). Field names in this record include MRO_SERIAL_NUMBER_ID, REPAIR_GROUP_ID, IB_FLAG, INVENTORY_ITEM_ID, SERIAL_NUMBER, and related attributes.

Key Procedures and Functions

• CREATE_SERIAL_NUMBER — Creates a new serial number record for a repair group, operating against the package's serial number record type and standard API parameters such as API version, initialization flag, commit flag, and validation level.
• UPDATE_SERIAL_NUMBER — Modifies an existing serial number record, including the IB_FLAG indicator.
• DELETE_SERIAL_NUMBER — Removes a serial number record.
• LOCK_SERIAL_NUMBER — Locks a serial number record to prevent concurrent modification.
• IS_IB_TRACKABLE — Evaluates whether a given item or serial number is Installed Base trackable; this is the function that consumes the IB_FLAG semantics referenced in the record type.
• IS_SERIALIZED — Determines whether the referenced inventory item is serial-controlled.
• VALIDATE_SERIAL_NUMBER — Performs validation of serial number data before persistence.
• IS_DUPLICATE_SERIAL_NUM — Checks for duplicate serial number entries.

Tables Accessed

The provided ETRM metadata does not enumerate the base tables referenced through APPS synonyms. Based on the documented column set, the package operates on the depot repair serial number entity identified by MRO_SERIAL_NUMBER_ID, linked to REPAIR_GROUP_ID, INVENTORY_ITEM_ID, and a customer product reference. Write operations focus on the serial number and repair group association rows, while read operations resolve item attributes to support the IS_SERIALIZED and IS_IB_TRACKABLE determinations.

Usage Notes

Because this is a private package, it is not intended for direct invocation by customer extensions. Within Oracle Depot Repair, it is called by the public Depot Repair APIs and by internal forms and processing logic that manage repair order serial numbers. Custom code should always call the supported public repair APIs instead of this private package, so that validation, locking, and Installed Base tracking behavior remain consistent. The IB_FLAG field signals Installed Base relevance and is interpreted by IS_IB_TRACKABLE during validation.