Search Results rlm_extinterface_sv




Overview
Explore in AI Chat

Overview

WSH_RLM_INTERFACE is an APPS-owned PL/SQL package that serves as the interface layer between Oracle's Release Management (RLM) modules and the Warehouse Management (WSH) shipping and delivery tables. It is classified as an OTHER API within the ETRM repository and holds a VALID status on both Oracle EBS 12.1.1 and 12.2.2. The package provides a controlled access point through which RLM service packages — specifically RLM_EXTINTERFACE_SV, RLM_MANAGE_DEMAND_SV, and RLM_RD_SV — retrieve delivery-related quantities without issuing direct SQL against the underlying WSH tables. It depends on RLM_CORE_SV and the SYS.STANDARD package, confirming that it is subordinate to the core RLM service layer while also exposing its own routines back up to that layer for reuse. The object documented here is the package specification; a corresponding package body exists and contains the implementation of the published routines.

Key Procedures and Functions

The documented interface exposes a single public routine:

  • GET_IN_TRANSIT_QTY — Returns the in-transit quantity for delivery lines. This is the principal business function of the package: given the identification of a delivery detail or line, it calculates how much material is currently moving between shipping points and has not yet been received or confirmed at the destination. It is used by RLM extension and demand management logic to determine true in-transit balances for planning and release decisions.

No parameter lists are published in the ETRM metadata; callers should inspect the package specification in the target environment for the exact signature, as it may vary slightly between 12.1.1 and 12.2.2. The routine is invoked internally by the dependent service packages rather than being exposed directly on a form.

Tables Accessed

The package reads from the following tables via APPS synonyms:

  • WSH_DELIVERY_DETAILS — the primary source for delivery line records, including item, quantity, and status information used to compute in-transit amounts.
  • WSH_NEW_DELIVERIES — the delivery header table, providing the delivery-level context that associates detail lines with a shipment.
  • WSH_DELIVERY_LEGS — the individual legs of a delivery's journey; these determine whether a line has actually departed the source and is therefore genuinely in transit.
  • WSH_TRIP_STOPS — stop-level sequencing and status data that qualify in-transit calculations by confirming which stops have been completed.
  • PLITBLM — a PL/SQL index-by table used for bulk collection or temporary result storage within the routine, not a physical business entity.

No inserts, updates, or deletes are indicated by the documented reference set; the package is read-only with respect to these tables.

Usage Notes

WSH_RLM_INTERFACE is an internal supporting package rather than a user-facing API. It is referenced by RLM_EXTINTERFACE_SV, RLM_MANAGE_DEMAND_SV, and RLM_RD_SV, and it also references itself, indicating shared internal logic. Typical invocation occurs through RLM concurrent programs, demand management processing, and extension interface transactions that require real-time visibility of goods in transit. It is not attached to an Oracle Forms screen and should not be called directly from custom code unless the calling routine also participates in the same RLM processing flow. Because the package is dated and dependency-driven, any customization should preserve the GET_IN_TRANSIT_QTY contract to avoid breaking the three dependent service packages.