Search Results get_po_release_id

Overview

PO_RELEASES_SV4 is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite Purchasing. It encapsulates the business logic that governs the creation, validation, and querying of blanket and scheduled release documents on top of an existing blanket purchase agreement. The package declares AUTHID CURRENT_USER and is classified in ETRM as an "OTHER" API, meaning it is an internal server-side utility rather than a formally published public interface. Its responsibilities include deriving the next release number for a new release, validating release dates, enforcing document number uniqueness, and validating approval status before a release is committed. It also supports the post-query retrieval of release-level attributes used when a release is displayed or processed.

Key Procedures and Functions

The header change history identifies the original author as KPOWELL and places the earliest creation activity in April. The ETRM metadata documents six procedures and functions in total, of which the following are named:

• NAME — The package-level identifier entry reflecting the package name, PO_RELEASES_SV4.
• GET_RELEASE_NUM — Returns the next release number to be assigned to a blanket or scheduled release. Its algorithm inspects the maximum release number already created for the associated planned or blanket purchase order; where no maximum exists, the release number is initialized to 1.
• GET_PO_RELEASE_ID — Retrieves the unique identifier for an existing release record, supporting downstream processing that requires the release primary key.
• VAL_RELEASE_DATE — Validates the release date supplied for a release document against the applicable business rules before the record is accepted.
• VAL_DOC_NUM_UNIQUE — Confirms that the document number proposed for a release is unique, preventing duplicate release documents.
• VAL_APPROVAL_STATUS — Validates the approval status associated with a release, ensuring only releases in an approved or otherwise valid state proceed.
• RELEASE_POST_QUERY — A post-query procedure that returns release attributes including the release identifier, total amounts, encumbered flag, release type, ship-via code, and ship-to organization code, along with agreement status, freight terms, FOB, and pay-on display values.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• PO_RELEASES — The primary entity, holding release header records created against blanket agreements.
• PO_HEADERS — The parent blanket or planned purchase order used to derive release numbering and document context.
• PO_LINE_LOCATIONS — Shipment and location detail associated with the release lines.
• MTL_PARAMETERS — Inventory organization parameters used to resolve ship-to and receiving defaults.
• HR_ORGANIZATION_INFORMATION — Organization classification data, including ship-to organization details.
• FINANCIALS_SYSTEM_PARAMETERS — Financials setup values governing defaulting and validation behavior.

Usage Notes

PO_RELEASES_SV4 is invoked from the Purchasing forms layer when a buyer creates or modifies a blanket or scheduled release, and may also be called from concurrent programs and custom extensions that automate release creation. Because it is classified as an OTHER API rather than a public interface, Oracle does not guarantee its signature across releases, and the change history shows the source has been patched over time (for example, the header references version 115.4 dated 21 January 2004). Custom code should treat the package as internal, prefer supported public APIs, and verify procedure signatures against the installed release before depending on them. The absence of a documented version number matching the searched "6.42.64" string indicates that this value does not correspond to a PO_RELEASES_SV4 source version in the ETRM record.