Results for “val_line_delete”

30 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PO_LINES_SV is a server-side PL/SQL package in the Oracle E-Business Suite Purchasing module (APPS schema) that exposes line-level Application Program Interfaces (APIs) for purchase order, RFQ, and quotation lines. It is declared AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling user rather than the package owner. The package header carries the identifier $Header: POXPOL1S.pls 120.3 2009/06/01 and is owned by Melissa Snyder, with an initial creation date of 05-MAY-95. In the EBS 12.1.1 and 12.2.2 file systems the packaged body ships as POXPOL1S.pls.

Its purpose is to centralize the validation and maintenance logic that governs the lifecycle of individual document lines — creation, uniqueness checking, deletion, approval-status validation, and released-quantity maintenance — so that Oracle Forms, concurrent programs, and third-party extensions all apply identical business rules against the same underlying tables.

Key Procedures and Functions

The header documents ten public subprograms. Those referenced in the ETRM metadata and the source excerpt include:

  • get_line_num() — returns the next available line number for a document, driving the line-numbering sequence used when a line is appended.
  • val_line_num_unique() — validates that a proposed line number is not already in use for the given document, preventing duplicate line identifiers.
  • delete_line() — verifies that deletion is permitted for a PO, RFQ, or Quote line (based on the X_type_lookup_code), deletes the line, and cascades the deletion to its children. It accepts a p_skip_validation switch (defaulted to NULL) used by HTML Agreements in R12.
  • delete_all_lines() and delete_children() — remove every child record beneath a selected line, and then the line itself.
  • val_delete() — the deletion-authorization check invoked by the delete routines.
  • val_update() — validates a line before it is modified.
  • val_approval_status() — confirms that the line's approval status permits the requested operation.
  • update_released_quantity() — maintains the released-quantity figure on the line as receipts and releases are processed.
  • VAL_LINE_DELETE — a documented procedure complementing the deletion validation path.

Tables Accessed

The package operates exclusively through APPS synonyms against the core Purchasing tables:

  • PO_HEADERS_ALL — parent header row referenced to establish document context and type.
  • PO_LINES_ALL — the primary line table read and updated during validation, numbering, and release-quantity maintenance.
  • PO_LINES — the operative view of line data used by the APIs.
  • PO_LINE_LOCATIONS — shipment/schedule children removed when a line is deleted.
  • PO_LINE_UCAS — usage-assignment records tied to the line and cleaned up on deletion.
  • PO_DOCUMENT_TYPES — consulted to resolve the document type behind the type lookup code and to apply the correct rule set.

Usage Notes

PO_LINES_SV is not invoked directly by end users. It is called from the Purchasing forms (POXPOEPO and related), the AutoCreate and Agreements flows, and from concurrent programs that perform line-level maintenance. Because the ETRM classification is OTHER rather than a supported public API, custom code should treat it as an internal interface: call it only after the standard header-level APIs (such as PO_HEADERS_SV) have established the document, and pass the correct type lookup code so that PO, RFQ, and Quote branches are selected properly. The metadata records five packages referencing PO_LINES_SV, and the current 12.2.2 signature maintains the p_skip_validation parameter introduced for HTML Agreements in R12.