Search Results po_requisition_lines_pkg2




Overview
Explore in AI Chat

Overview

PO_REQUISITION_LINES_PKG2 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It forms part of the Purchasing (PO) module's internal processing layer, which governs requisition lifecycle operations within the Oracle Purchasing application. Its documented status is VALID in the ETRM repository, and it is classified as an OTHER API rather than a public, supported interface.

The package supports the persistence of requisition line data. Requisition lines represent the item-level demand captured by requesters before sourcing, approval, and conversion into purchase orders or other downstream documents. PO_REQUISITION_LINES_PKG2 supplies the procedural logic that inserts requisition line records into the underlying transactional tables, together with any associated descriptive flexfield attribute values. Because the package name carries no multi-org or interface suffix, it operates within the standard requisition processing flow rather than a batch import interface such as PO_REQ_LINES_INTERFACE.

Key Procedures and Functions

The ETRM metadata documents a single public program unit within this package:

  • INSERT_ROW — Inserts a requisition line record. This procedure encapsulates the insert logic against the requisition line base table, the multi-org view or its translation-layer counterpart, and the attribute values table used for descriptive flexfields. It is the sole documented entry point and is not described in the ETRM excerpt as a supported public API.

No parameter lists are documented in the available metadata; parameter details are intentionally not reproduced here. Consumers should inspect the package specification prior to invocation.

Tables Accessed

The documented tables referenced through APPS synonyms are:

Together these tables indicate that INSERT_ROW performs a coordinated write across the requisition line structure and its flexfield extension tables, rather than a single-table insert.

Usage Notes

PO_REQUISITION_LINES_PKG2 is an internal PL/SQL package, not a published API, and is not referenced by any other documented package in the ETRM repository. It is typically invoked indirectly by Oracle Purchasing forms and by higher-level requisition processing logic rather than called directly by external code. Direct invocation from custom code is discouraged, because Oracle does not document or guarantee the signature or behavior of internal packages and may change them during patching or upgrades.

For custom development requiring requisition line creation, use the supported public interfaces, such as the requisition import interface or the documented Purchasing APIs, instead of calling PO_REQUISITION_LINES_PKG2 directly. Diagnosis of requisition line insert failures is best performed through the standard purchasing error and diagnostic mechanisms. Its presence in the dependency chain of the requisition schema should nevertheless be understood when tracing how requisition line rows and their flexfield values are created.