Search Results break_end_ge_blanket_start

Overview

PO_VAL_PRICE_BREAKS is a server-side PL/SQL validation package in the Oracle E-Business Suite Purchasing (PO) module, owned by the APPS schema and classified as a non-public (OTHER) API. Its business function is to validate price break lines entered against blanket purchase agreements and similar sourcing documents. Price breaks define quantity- or date-banded pricing tiers on an agreement line, and the integrity of these tiers is essential to downstream purchasing activity such as releases, auto-sourcing, and requisition-to-order flows. The package encapsulates the row-level and cross-row validation rules that govern acceptable price break attributes, ensuring that quantity ranges, date ranges, discounts, and price overrides are internally consistent and remain within the boundaries of the parent blanket agreement.

The package name and procedures appear in the Oracle EBS 12.1.1 and 12.2.2 codelines. In 12.2.2 it is catalogued as an ETRM-documented object under the APPS owner with eleven documented procedures.

Key Procedures and Functions

The package exposes eleven documented procedures. Each returns validation outcome through an x_results parameter (a PO_VALIDATION_RESULTS_TYPE record) and an x_result_type flag. The procedures fall into three functional groups.

• AT_LEAST_ONE_REQUIRED_FIELD — Confirms that at least one mandatory identifying or qualifying field is supplied for the price break row, returning an error when the row is insufficiently defined.
• PRICE_DISCOUNT_IN_PERCENT — Validates that the price discount value is expressed as a valid percentage.
• PRICE_OVERRIDE_GT_ZERO — Verifies that a price override, when entered, is greater than zero.
• QUANTITY_GE_ZERO — Checks that the price break quantity is zero or positive.
• START_DATE_LE_END_DATE — Enforces that the price break start date does not fall after its end date.
• BREAK_START_GE_BLANKET_START — Ensures that the price break start date is on or after the parent blanket agreement's start date.
• BREAK_START_LE_BLANKET_END — Ensures that the price break start date does not exceed the blanket agreement's end date.
• BREAK_START_LE_EXPIRATION — Ensures the price break start date does not exceed the applicable expiration date.
• BREAK_END_LE_EXPIRATION — Ensures the price break end date does not exceed the applicable expiration date.
• BREAK_END_GE_BLANKET_START — Ensures the price break end date is on or after the blanket agreement's start date.
• BREAK_END_LE_BLANKET_END — Ensures the price break end date does not extend beyond the blanket agreement's end date.

Tables Accessed

The documented table reference for this package is the APPS synonym PLITBLM. This synonym provides the package with access to the price break data against which the validation procedures operate, allowing the date, quantity, discount, and price override attributes to be checked in context. Broader integration typically also consults the base purchasing tables (for example PO_LINES and PO_LINE_LOCATIONS) that carry the parent agreement dates and identifiers, but the ETRM metadata documents PLITBLM as the referenced table.

Usage Notes

PO_VAL_PRICE_BREAKS is invoked during entry and maintenance of price break information in the Purchasing forms, and it is referenced by one other package in the APPS schema, indicating that it participates in a wider validation framework rather than being called in isolation. The package is an internal validation component: it is not a documented public API intended for direct customer callout, though it may be reached indirectly through the standard Purchasing UI and through custom code that performs equivalent price break validation. The PO_VALIDATION_RESULTS_TYPE parameter, which is the object referenced in the user's search, is the shared results structure used to accumulate and return validation errors and messages, consistent with the pattern used across the PO_VAL_* family of validation packages. Because the routines rely on this ETRM-managed type, integrations should reference the same structure when consuming results returned by the package.