Search Results retro_change_shipment

Overview

The APPS.PO_LINES_SV2 package body is a server-side PL/SQL object in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema and reported with a status of VALID. Within the Oracle Purchasing module, it belongs to the family of "SV" (server validation / server-side processing) APIs that encapsulate the business logic governing purchasing document lines. The package body serves as the executable implementation counterpart to the PO_LINES_SV2 package specification, providing the internal routines that Oracle Purchasing forms, concurrent programs, and dependent application program interfaces invoke when validating, defaulting, or maintaining line-level data on purchase orders and releases.

Its role is primarily supportive: rather than exposing a broad public API such as PO_LINES_SV1 or the PO_LINES_APIs family, PO_LINES_SV2 concentrates on a narrow set of internal validation and processing operations used during line entry and shipment changes. The ETRM metadata classifies this package's API purpose as OTHER, indicating it is not one of the primary documented public interfaces but a helper or internal package.

Key Procedures and Functions

The documented package metadata identifies three procedures or functions:

• NAME — A routine that returns or handles the programmatic name associated with the package or process, used by Oracle Purchasing processing to identify the invoking logic. Its exact signature is not documented in the available metadata.
• RETRO_CHANGE_SHIPMENT — The principal documented routine, responsible for applying retroactive changes to purchase order shipment (line location) information. This supports scenarios in which shipment details such as quantity, price, or date attributes are altered after the line has been recorded, and associated line location records must be updated consistently.
• A third procedure or function is documented but its name is not disclosed in the excerpt. Only the two named routines above can be described with confidence.

No parameter lists are documented, and none are inferred here.

Tables Accessed

The package operates against the core Oracle Purchasing line and shipment tables, referenced through APPS synonyms:

• PO_LINES / PO_LINES_ALL — The base and multi-organization views of purchase order lines. The package reads and updates line attribute data, including price and quantity, when shipment changes require line synchronization.
• PO_LINE_LOCATIONS — The shipment-level table storing schedule and shipment details. RETRO_CHANGE_SHIPMENT directly manipulates this table to propagate retroactive changes.
• PO_MESSAGE_S — Referenced as a dependency, used for message lookup and error reporting within the package's validation logic.
• FND_GLOBAL — Supplies session context such as user ID, responsibility, and login information used for auditing and access control during processing.

Usage Notes

PO_LINES_SV2 is not referenced by any other database object, and the metadata records no inbound dependency beyond its own specification. This suggests it is invoked from Oracle Purchasing forms or internal processing rather than being called by other stored packages. It is typically executed when a user modifies shipment or line details on an existing purchase order, or during concurrent processing that requires retroactive shipment adjustment, including price and quantity corrections with downstream distribution impact.

Because it is not a public API, customizations should avoid direct calls unless Oracle documentation explicitly permits them; standard practice is to reach line and shipment maintenance through the supported PO_LINES_APIs or the Purchasing forms. Developers tracing "po_lines_sv2" in the EBS data dictionary should treat it as an internal validation and shipment-change helper whose primary accountable routine is RETRO_CHANGE_SHIPMENT.