Search Results po_line_locations_pkg_s2




Overview
Explore in AI Chat

Overview

PO_LINE_LOCATIONS_PKG_S2 is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, documented as VALID under the ETRM 12.2.2 metadata set. It is classified as an OTHER API, meaning it is not a published, customer-facing interface such as the PL/SQL APIs exposed through PO_LINE_LOCATIONS_PKG, but rather an internal worker package used by the purchasing schema to perform row-level maintenance on purchasing document shipments and distributions.

In Oracle Purchasing, the PO_LINE_LOCATIONS_ALL table stores the shipment and distribution lines beneath a purchase order or release line, holding quantity, price, need-by date, receipt routing, and accounting distribution attributes. This package encapsulates the low-level DML that the purchasing forms and supporting APIs perform against those rows. The companion package PO_SHIPMENTS_SV4 — a forms-support package in the purchasing suite — is the documented caller, which indicates the package is invoked when a user changes or removes shipment records on a purchasing document.

Key Procedures and Functions

The ETRM metadata documents two procedures for this package.

  • UPDATE_ROW — Persists modifications to an existing shipment or distribution row. It is the internal write path for attribute changes made through the purchasing user interface or through higher-level APIs, ensuring the affected PO_LINE_LOCATIONS record reflects the current quantity, price, schedule, and related shipment attributes.
  • DELETE_ROW — Removes a shipment or distribution row that is no longer required. It handles the physical or logical removal of the record so that parent line and header totals and downstream referencing entities remain consistent.

Because this is a private helper package, its procedures are not intended for direct invocation by external code. No parameter signatures are documented in the ETRM record above.

Tables Accessed

The package works against two documented tables, referenced through APPS synonyms:

  • PO_LINE_LOCATIONS — the base purchasing table holding shipment and distribution rows. It is the primary target of both UPDATE_ROW and DELETE_ROW operations. PO_LINE_LOCATIONS_ALL is the datamerged view over this base table, presenting the multi-organization (operating unit) perspective. Because the metadata lists both objects, the package reads and writes the base table while callers typically address the _ALL view when operating across organizations.

No other tables are documented as direct dependencies, indicating the package's scope is deliberately narrow: it performs row maintenance and leaves derived calculations to its callers and companion packages.

Usage Notes

PO_LINE_LOCATIONS_PKG_S2 is not a public API and should not be called directly from custom code. It is invoked by PO_SHIPMENTS_SV4, the forms-support package used by the Oracle Purchasing shipment entry window, which confirms that the package fires during interactive shipment maintenance rather than from concurrent programs. Customizations that need to update or delete purchasing shipments should use the supported purchasing APIs, such as PO_LINE_LOCATIONS_PKG or the PO_SHIPMENTS_* interfaces, rather than this private worker. Direct use risks bypassing the validation, currency, and multi-organization logic applied by the supported interfaces, and the package's internal contract may change between releases. The presence of STANDARD in its dependency list indicates only standard PL/SQL runtime usage.