Search Results po_req_lines_sv




Overview
Explore in AI Chat

Overview

PO_REQ_LINES_SV is a server-side validation package in the APPS schema of Oracle E-Business Suite, classified as an OTHER API. Its name follows Oracle's naming convention where the "SV" suffix denotes a "Server Validation" package — code dedicated to enforcing business rules, data integrity checks, and referential validation for requisition line data before it is committed to the database. The package operates within the Purchasing (PO) module and is a core component of the requisition authoring and maintenance infrastructure used by Oracle Purchasing and iProcurement.

The package exposes 17 documented procedures and functions, including NAMES and NAME, which are internal naming/helper utilities. Its primary responsibility is to validate requisition line attributes — quantities, item references, distributions, and delivery information — so that invalid or inconsistent data does not reach the PO_REQUISITION_LINES_ALL and related base tables. Because it is registered as VALID in both 12.1.1 and 12.2.2, the object remains available and supported across the two releases with consistent behaviour.

Key Procedures and Functions

The ETRM metadata documents 17 procedures/functions. Only two are identified by name in the excerpt:

  • NAMES — a naming or reference helper routine, typically used to derive or format a descriptive name/label for requisition line validation logic.
  • NAME — a companion utility that returns a single name value, likely used by NAMES.

The remaining procedures are not individually enumerated in the metadata. Based on the package's role as a server validation unit, they logically cover field-level validation of requisition line, requisition distribution, and delivery attributes. Parameter lists are not documented and are deliberately not reproduced here.

Tables Accessed

PO_REQ_LINES_SV reads and writes the following tables via APPS synonyms:

Usage Notes

PO_REQ_LINES_SV is referenced by 16 other packages, indicating it is a shared validation dependency rather than a standalone entry point. Its callers include PO_REQUISITION_LINES_PKG, PO_REQUISITION_LINES_PKG1, and PO_REQUISITION_LINES_PKG2, PO_REQ_LINES_SV1, PO_REQS_CONTROL_SV, PO_RELEASES_SV, PO_DOCUMENT_ACTION_UTIL, PO_RCO_VALIDATION_PVT, PO_LINE_LOCATIONS_DRAFT_PVT, and PO_SHIPMENTS_SV4.

The package is invoked indirectly when requisition lines are created or modified through the Requisition form, iProcurement, or autocreate flows, and by concurrent programs and custom PL/SQL that perform requisition data validation. Customizations should call the documented (and any exposed) validation routines rather than duplicating business rule logic, to remain compatible with the internal validation hierarchy.