Search Results is_serialized

Overview

APPS.CSD_GROUP_SERIAL_NUMBER_PVT is a private PL/SQL package body within the Oracle Depot Repair module of Oracle E-Business Suite. As its header comment states, the package "contains the private APIs for creating, updating, deleting, locking serial numbers," and access is explicitly "restricted to Oracle Depot Repair Internal Development." It exists to support the Serial Number Capture Screen and related grouped serial number processing used during depot repair order entry and execution. The package is classified as PVT (private API), meaning it is not a published or supported public interface and should not be called directly by customer extensions. The package body is associated with the source file csdvsrnb.pls and carries the package-level constant G_PKG_NAME set to 'CSD_GROUP_SERIAL_NUMBER_PVT'. It also captures FND_GLOBAL session context — user ID, concurrent login ID, request ID, program ID, and program application ID — together with a debug level sourced from CSD_GEN_UTILITY_PVT, supporting standard EBS error handling, message stacking, and debugging conventions.

Key Procedures and Functions

The package exposes eight documented procedures and functions. No parameter lists are reproduced here; the descriptions reflect the documented purpose of each unit as derived from the ETRM metadata and package header comments.

• CREATE_SERIAL_NUMBER — Creates serial number records entered through the Serial Number Capture Screen. According to the package notes, the API "will create a Serial Numbers entered via the Serial Number Capture Screen," and the values are validated against Oracle Installed Base (IB) or Service Inventory where the user has opted for that validation.
• UPDATE_SERIAL_NUMBER — Modifies existing grouped serial number data maintained by Depot Repair, applying the same validation discipline used during creation.
• DELETE_SERIAL_NUMBER — Removes serial number records created or maintained through this private API layer.
• LOCK_SERIAL_NUMBER — Applies a locking operation to serial number records, preventing concurrent modification while repair transactions are in progress.
• IS_IB_TRACKABLE — Determines whether a given item is trackable in Oracle Installed Base, supporting the validation decision of whether IB checks must be performed.
• IS_SERIALIZED — Determines whether an item is serialized under the inventory model, used to decide whether serial number capture and validation is applicable.
• VALIDATE_SERIAL_NUMBER — The validation routine that verifies a supplied serial number. This is the primary unit surfaced when users search for "validate_serial_number," and it underpins the validation flow referenced for CREATE_SERIAL_NUMBER against IB or Service Inventory.
• IS_DUPLICATE_SERIAL_NUM — Checks whether a serial number already exists for the relevant context, preventing duplicate registrations.

Tables Accessed

The ETRM metadata does not enumerate specific base tables or APPS synonyms referenced by this package body; the "tables referenced" list is empty in the supplied documentation. Functionally, the procedures operate on grouped serial number data within the Depot Repair schema, and the validation logic interacts conceptually with Oracle Installed Base and Service Inventory data when the caller selects IB-based validation. Because the package is private and its underlying table access is not documented here, no specific table names should be inferred or assumed.

Usage Notes

CSD_GROUP_SERIAL_NUMBER_PVT is invoked internally by Oracle Depot Repair application code — most notably the Serial Number Capture Screen flow — and is not intended for external or customer-written calls. In the documented metadata it is referenced by zero other packages, which is consistent with its role as a leaf-level private worker invoked directly from the Depot Repair user interface layer rather than from shared PL/SQL wrappers. The public-facing serial number validation available to customers should be used in preference to this package. The routine most frequently targeted by searches for "validate_serial_number" is VALIDATE_SERIAL_NUMBER, but because the package is private and unsupported, custom code should rely on supported public APIs instead. Behavior is consistent across the 12.1.1 and 12.2.2 releases described, as the package body header reflects a long-stable lineage (source version 120.1.12000000.2).