Search Results po_pb_lines_1




Overview
Explore in AI Chat

Overview

PO_PB_LINES_1 is an Oracle EBS PL/SQL package owned by the APPS schema, classified in the ETRM metadata as an "OTHER" API within the Oracle Purchasing module. The "PB" designation and the package's exposure of a single line-insertion routine identify it as a programmatic interface used during the creation of purchasing document lines — primarily blanket purchase agreement (BPA) lines released through the PO_PB_LINES_1 API surface. It provides a server-side mechanism for inserting a purchasing line record and resolving the associated item and line-type context in a controlled, reusable fashion rather than through direct table manipulation.

The package is marked VALID in the documented release set and remains available across Oracle EBS 12.1.1 and 12.2.2. Its dependency list is deliberately thin: it depends on SYS.STANDARD (the PL/SQL built-in package) and is referenced by APPS.PO_PB_LINES_1 itself, indicating a self-contained unit with no downstream package dependencies and no other EBS packages calling it. This makes it a leaf-level utility rather than a central orchestration API.

Key Procedures and Functions

The documented interface exposes one callable program unit:

  • INSERT_LINE — Inserts a purchasing document line. Based on its position within the PO_PB_LINES_1 package and the tables it references, this procedure accepts the identifying context for a line (such as the document or blanket header, line number, item, and line type) and performs the insert of the line row. ETRM does not publish the parameter list, and the exact argument signature should be confirmed against the package specification in the target instance (for example, by querying ALL_ARGUMENTS or describing the package) before invocation.

No other procedures or functions are documented for this package; the total documented surface is a single routine, reinforcing its narrow, single-purpose design.

Tables Accessed

The package references two tables through APPS synonyms:

  • MTL_SYSTEM_ITEMS — The master item definition table in Oracle Inventory. INSERT_LINE consults it to validate and resolve the inventory item being placed on the purchasing line, ensuring that the item identifier and item-based attributes are consistent with the master item record before the line is written.
  • PO_LINE_TYPES_B — The purchasing line type base table. INSERT_LINE reads this table to validate the line type applied to the new line, confirming that the supplied line type is a valid, enabled purchasing line type.

The package reads these reference tables for validation and derives line attributes from them; the actual line insertion is performed against the purchasing line structures associated with the calling process.

Usage Notes

PO_PB_LINES_1 is an internal Purchasing utility rather than a public advertised API. Because the metadata records zero packages referencing it and only a self-referential dependency, it is not invoked by other installed EBS packages in the documented instance; callers are external to the PL/SQL dependency chain. Typical invocation is therefore from Oracle Forms event logic during purchasing document entry, from concurrent programs that bulk-load lines, or from custom extensions and conversion routines that must create lines programmatically while honoring the same validation applied to the standard forms path.

Custom code invoking INSERT_LINE should resolve item and line-type values against MTL_SYSTEM_ITEMS and PO_LINE_TYPES_B first, since the procedure relies on those tables for validation and will fail or raise errors if the referenced entities are invalid or disabled. Because the parameter list is not published in ETRM, implementers must inspect the package specification in their specific 12.1.1 or 12.2.2 instance, and should wrap calls in standard exception handling so that validation failures surface cleanly to the calling form or concurrent program.