Search Results get_disabled_list

Overview

WSH_PACKING_SLIPS_PVT is a private PL/SQL package in the Oracle E-Business Suite Shipping (WSH) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. It provides the procedural foundation for creating, maintaining, and removing packing slip records associated with outbound delivery entities. Packing slips are the physical documents that accompany shipped goods and enumerate the contents of a delivery; this package encapsulates the low-level data manipulation for the underlying packing slip entity, allowing higher-level Shipping APIs and forms to persist packing slip information without directly manipulating base tables.

The package is classified as a PVT (private) API in the ETRM 12.2.2 repository, meaning it is intended for internal consumption by Oracle Shipping components and dependent packages rather than as a public integration surface. The documented source header indicates an origin file WSHPSTHS.pls with a version lineage extending to 2002, confirming the object's long-standing role within the Shipping transaction infrastructure across release 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes four documented procedures:

• UPDATE_ROW — Modifies an existing packing slip record. It accepts a standard API parameter set (API version, initialization of the message list, commit flag, and validation level, with return status, message count, and message data as outputs) together with entity identification and descriptive attributes such as entity name, entity ID, document type, reason of transport, description, and document number.
• INSERT_ROW — Creates a new packing slip record. In addition to entity and document attributes, it captures application ID and location ID, and returns the generated document number through an IN OUT parameter. Return status, message count, and message data are conveyed as IN OUT parameters.
• DELETE_ROW — Removes a packing slip record identified by entity ID, document type, and document number, using the same standard API control parameters as UPDATE_ROW.
• GET_DISABLED_LIST — A query utility that, given a delivery ID and a list type, returns the set of disabled field names. When the list type is 'FORM' it returns form field names; when 'TABLE' it returns table column names. This supports dynamic UI behavior in the Shipping packing slip form.

All procedures follow the Oracle Applications API conventions, returning status and message information to the caller.

Tables Accessed

The package interacts with the following documented tables through APPS synonyms:

• WSH_NEW_DELIVERIES — The core delivery entity table; packing slips are associated with deliveries, so this table supplies and validates the delivery context for insert, update, and delete operations.
• HR_ORGANIZATION_INFORMATION — Provides organization-level information, typically used to resolve the shipping organization and its associated attributes for the packing slip entity.
• PLITBLM — A PL/SQL index-by table used for message handling and bulk collection operations within the API framework.

Usage Notes

WSH_PACKING_SLIPS_PVT is referenced by two other packages in the Shipping schema, which invoke its procedures to persist packing slip data as part of delivery confirmation, manifesting, and document generation flows. It is not intended for direct invocation by external integrations; customers requiring packing slip manipulation should use supported public Shipping APIs or the Packing Slip form itself. Because the package is declared as a private API and its procedures bypass some higher-level validation performed by public APIs, direct calls risk inconsistent data and are unsupported. Custom code should treat WSH_PACKING_SLIPS_PVT as an internal implementation detail subject to change between patches and releases.