Search Results validate_plsl_rec

Overview

APPS.CSP_PACK_SERIAL_LOTS_PVT is a private PL/SQL API package belonging to the CSP (Pack) module of Oracle E-Business Suite. It encapsulates the validation and maintenance logic for the CSP_PACK_SERIAL_LOTS entity, which stores the association between packlist lines and the specific serial numbers and lot numbers that are shipped or packed against them. In the shipping and packing execution flow, a packlist line may be fulfilled by one or more inventory lots and/or serial-controlled units. The CSP_PACK_SERIAL_LOTS table records each such allocation, linking it to an organization, inventory item, packlist line, and quantity.

This package is classified as PVT (private), meaning it is intended for internal use by other CSP-layer APIs and is not part of the supported public interface exposed to customers or third-party integrators. It declares AUTHID CURRENT_USER, so its SQL executes with the privileges of the calling schema. The package also defines the plsl_Rec_Type record and the plsl_Tbl_Type PL/SQL table, both of which mirror the columns of CSP_PACK_SERIAL_LOTS (PACKLIST_SERIAL_LOT_ID, PACKLIST_LINE_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, QUANTITY, LOT_NUMBER, SERIAL_NUMBER, and the standard WHO columns), defaulting to FND_API.G_MISS_* values so that calling programs can distinguish "not supplied" from a genuine null or zero.

Key Procedures and Functions

• CREATE_PACK_SERIAL_LOTS — Inserts a new pack serial/lot association record, typically driven by the plsl record type.
• UPDATE_PACK_SERIAL_LOTS — Modifies an existing pack serial/lot row, for example when quantities are corrected.
• DELETE_PACK_SERIAL_LOTS — Removes a pack serial/lot association from the packlist line.
• VALIDATE_PL_SERIAL_LOT_ID — Validates the primary key PACKLIST_SERIAL_LOT_ID. This is the routine the user searched for; it confirms that the supplied identifier exists and is usable before create/update/delete processing continues.
• VALIDATE_PACKLIST_LINE_ID — Confirms the referenced packlist line is valid.
• VALIDATE_ORGANIZATION_ID — Confirms the organization context is valid.
• VALIDATE_INVENTORY_ITEM_ID — Confirms the inventory item is valid.
• VALIDATE_QUANTITY — Checks that the quantity value is acceptable and consistent with the line.
• VALIDATE_LOT_NUMBER — Validates lot number data for lot-controlled items.
• VALIDATE_SERIAL_NUMBER — Validates serial number data for serial-controlled items.
• VALIDATE_PLSL_REC — Performs field-level validation across a single plsl record using the G_MISS defaults to skip unsupplied attributes.
• VALIDATE_PACK_SERIAL_LOTS — Orchestrates the full validation sequence prior to persistence.

Tables Accessed

The documented dependencies reference DBMS_SQL and DUAL via APPS synonyms. DBMS_SQL indicates dynamic SQL is used inside the validation logic, and DUAL supports scalar lookups. Practically, the validation routines resolve the underlying CSP_PACK_SERIAL_LOTS, packlist, organization, and inventory master data when performing their checks.

Usage Notes

Because the package is private, it is invoked internally by other CSP-layer programs and is referenced by two other packages in the ETRM catalog. It is most commonly reached from the Oracle Shipping/Receiving forms when packing serial- or lot-controlled items, or from concurrent programs and custom extensions that need to write pack serial/lot associations. Custom code should prefer the public shipping APIs and treat CSP_PACK_SERIAL_LOTS_PVT as an implementation detail.