Results for “get_disabled_list”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WSH_DATA_PROTECTION is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It resides within the Oracle Shipping (WSH) module and is classified under the ETRM reference as an "OTHER" API type rather than a public or private interface. The package encapsulates the data protection logic used across the shipping and trip management sub-processes to ensure that delivery, trip, and trip stop records cannot be modified or deleted once they have reached a state where downstream transactional or accounting activity depends upon them.

This protection mechanism is essential in shipping execution because delivery legs, trips, and trip stops are frequently referenced by subsequent activities such as packing slip generation, delivery assignment, and validation routines. Allowing unguarded changes to these records would compromise shipment integrity, cause reconciliation failures, and potentially corrupt the linkage between shipping transactions and their downstream financial or inventory postings. The package body therefore acts as a guard layer that other WSH packages invoke before permitting updates or deletions.

Key Procedures and Functions

The documented API surface of WSH_DATA_PROTECTION exposes a single procedure named GET_DISABLED_LIST. This routine produces the list of records, actions, or fields that are currently disabled or protected from modification, based on the operational state of the underlying delivery, trip, or trip stop entities. Consumers use the returned list to determine which user interface controls should be rendered non-editable and which programmatic operations must be rejected. The ETRM metadata does not document additional parameters or overloads, so the description is intentionally limited to purpose rather than signature.

Tables Accessed

The package body references the following tables through APPS synonyms:

• WSH_DELIVERY_LEGS — holds the individual leg records of a delivery; the protection logic inspects leg status to determine whether a leg is frozen.
• WSH_NEW_DELIVERIES — the core delivery header repository; protection decisions depend on the delivery's lifecycle state.
• WSH_TRIPS — the trip header table; trips that have been confirmed or closed are subject to protection.
• WSH_TRIP_STOPS — the individual stops on a trip; these are guarded because changes to stops affect routing and delivery sequencing.
• PLITBLM — a public PL/SQL table used here as a general-purpose collection structure for returning or caching lists.

The package also depends on several sibling WSH packages including WSH_DELIVERY_LEGS_PVT, WSH_DELIVERY_VALIDATIONS, WSH_DETAILS_VALIDATIONS, WSH_PACKING_SLIPS_PVT, WSH_TRIP_STOPS_PVT, WSH_TRIP_VALIDATIONS, WSH_UTIL_CORE, and WSH_DEBUG_INTERFACE / WSH_DEBUG_SV for debug logging. Standard Oracle components FND_API, FND_MESSAGE, FND_MSG_PUB, and STANDARD are also referenced.

Usage Notes

WSH_DATA_PROTECTION is not referenced by any other database object directly per the ETRM dependency listing, indicating it is invoked internally by adjacent WSH packages rather than through external foreign key or trigger relationships. Typical invocation scenarios include the Oracle Shipping form (for example, the Ship Confirm and Trip Planning windows) where it determines field-level editability, as well as server-side validation routines that run before delivery or trip modifications are committed. Because the package is classified as "OTHER," it is not intended as a public integration API; however, customers and partners extending shipping behavior may call GET_DISABLED_LIST from custom PL/SQL, concurrent programs, or wrapper packages that replicate the standard shipping constraint rules. One documented package in the ETRM reference depends on WSH_DATA_PROTECTION, reinforcing its role as a shared protection service within the WSH schema.