Search Results po_requisition_lines_pkg




Overview
Explore in AI Chat

Overview

PO_REQUISITION_LINES_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It encapsulates low-level validation and maintenance logic for records held in the purchasing requisition lines entity. In the Oracle EBS procurement flow, requisition lines represent the individual requested items, quantities, and delivery details that precede the creation of a purchase order. This package provides reusable server-side routines that enforce data integrity and support controlled updates to those lines, isolating this logic from the calling forms and concurrent programs.

The package is classified under the ETRM API classification OTHER. Its status is VALID in the documented environment. Dependency metadata records that it is a compiled package with both a specification and a body, and that it depends solely on the SYS.STANDARD package referenced through the SYS schema. It is not recorded as being referenced by any other package, indicating it is primarily a leaf-level utility used by application forms or direct invocations rather than a shared framework component.

Key Procedures and Functions

The documented metadata identifies two callable units within the package:

  • CHECK_UNIQUE — A validation routine that verifies the uniqueness of requisition line data before it is committed. This supports enforcement of business rules that prevent duplicate or conflicting line records from being saved. As its name indicates, it performs a uniqueness check and returns a result to the caller rather than modifying data.
  • UPDATE_ROW — A maintenance routine that performs an update against a requisition line row. It centralizes the logic required to modify an existing line record, ensuring that the update is applied consistently with the package's validation rules.

No parameter lists are documented for these units and none are inferred here. Their names and documented behavior indicate a validation/update pairing typical of Oracle Forms-based maintenance blocks.

Tables Accessed

The documented table references, resolved through APPS synonyms, are:

  • PO_REQUISITION_LINES — The base table storing individual requisition line records. CHECK_UNIQUE reads this table to test for existing matching rows, and UPDATE_ROW writes to it to apply changes to a targeted line.
  • DUAL — The Oracle single-row utility table, typically used for evaluating expressions or performing lightweight checks within PL/SQL logic.

These references confirm the package's scope: it reads and writes only the requisition lines table, keeping its responsibility narrowly focused on line-level integrity and updates.

Usage Notes

PO_REQUISITION_LINES_PKG is typically invoked from the Requisition entry forms (such as the Purchasing Requisition form) during the save and validation cycle, where CHECK_UNIQUE and UPDATE_ROW are called behind the line block to validate and persist line changes. It may also be called from custom PL/SQL extensions, concurrent programs, or workflow activities that need to enforce the same uniqueness rules or perform controlled line updates without replicating the logic. Because it references no external application packages and is referenced by no other package, direct invocation from form triggers or custom code is the expected pattern. Developers running customizations on Oracle EBS 12.1.1 or 12.2.2 should treat these procedures as internal application programming interfaces: call them where behavior parity with the standard form is required, and avoid reimplementing uniqueness or update rules independently.