Results for “get_rel_total”

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

Overview

PO_RELEASES_SV2 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an "OTHER" API under the ETRM documentation standard. Its name and object name indicate that it serves as a supplementary server-side view/logic package supporting the PO_RELEASES entity within Oracle Purchasing. Rather than acting as a primary public API for release creation, PO_RELEASES_SV2 provides supporting retrieval and reference logic used by other purchasing and order-management packages. The package's status is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, indicating it is an active, maintained object in the EBS codebase. Its primary business role is to expose header-level detail and supporting reference data needed when processing blanket purchase agreement releases and drop-ship transactions that reference those releases.

Key Procedures and Functions

The documented package exposes three procedures/functions in total:

• GET_PO_HEADER_DETAILS — Retrieves purchase order header-level detail associated with a release. This is the principal functional routine in the package, returning header information required by callers that need to resolve the parent PO context of a given release.
• NAME — A naming/identity routine, typically used to return a descriptive or label value associated with the package's data, or to standardize naming output for downstream consumers.
• (one additional documented procedure/function) — Listed in the procedure count of three but not individually enumerated in the excerpt.

Parameter lists are not documented in the ETRM metadata and therefore are not reproduced here. Consumers should inspect the package specification directly in the APPS schema for exact signatures.

Tables Accessed

The package reads from the following tables via APPS synonyms:

• PO_RELEASES — The core release entity; the primary source for release-specific attributes.
• PO_HEADERS — Supplies blanket agreement / purchase order header data resolved by GET_PO_HEADER_DETAILS.
• PO_LINE_LOCATIONS — Provides shipment and location-level detail for the associated release lines.
• FINANCIALS_SYSTEM_PARAMETERS — Supplies operating unit and financials setup context, ensuring the returned data respects the correct ledger/operating unit.
• HR_ALL_ORGANIZATION_UNITS — Resolves organization/operating unit naming for header detail.
• DUAL — Used for single-row utility queries and constant derivation.

These accesses are consistent with a header-detail retrieval utility rather than a transactional writer.

Usage Notes

PO_RELEASES_SV2 is referenced by four other packages, all in the APPS schema: OE_DROP_SHIP_PVT, OE_DS_PVT, OE_VALIDATE_LINE, and PO_RELEASES_V, as well as by itself. This dependency pattern shows the package is invoked primarily from Order Management drop-ship and line-validation code paths, and from the PO_RELEASES_V view, where release header detail must be resolved during order fulfillment and validation. It is not normally called directly from Oracle Purchasing forms or concurrent programs; instead it functions as an internal support layer behind purchasing and order-management flows. Custom code extending drop-ship or blanket-release processing should call the public API equivalents (for example PO_RELEASES_SV or the OE drop-ship PVT packages) rather than invoking PO_RELEASES_SV2 directly, since it carries an "OTHER" classification and no committed public interface guarantee.