Search Results po_val_price_diffs2




Overview
Explore in AI Chat

Overview

PO_VAL_PRICE_DIFFS2 is a validation package in the Oracle E-Business Suite Purchasing module, owned by the APPS schema and defined with AUTHID CURRENT_USER. Its business function is to enforce the integrity and correctness of price differential definitions captured against purchasing documents and document styles in Oracle Purchasing. Price differentials are the rules that determine how the price of a configured or styled item is adjusted relative to a base price, and they carry attributes such as differential type, entity type, multiplier, and minimum and maximum multiplier bounds. This package validates those attributes before a price differential record is committed, ensuring that only consistent and correctly structured differential data reaches the purchasing tables.

The package is one of the validation routines invoked by the Oracle Purchasing document validation framework, and according to the documented metadata it is referenced by one other package. It is a sibling of the price differential validation logic in PO_VAL_PRICE_DIFFS and is organized as a set of focused validation procedures rather than a single monolithic entry point.

Key Procedures and Functions

The package exposes seven documented procedures. Each accepts PL/SQL collection parameters, typically PO_TBL_NUMBER and PO_TBL_VARCHAR30 tables, reflecting the framework's practice of validating rows in bulk, and returns results either through a result set identifier or a PO_VALIDATION_RESULTS_TYPE structure.

  • PRICE_TYPE — Validates the price type attribute associated with the rows being processed.
  • MULTIPLE_PRICE_DIFF — Validates the combination of price differential rows supplied, using identifier, price type, entity type, and entity identifier collections as input.
  • ENTITY_TYPE — Validates the entity type value, taking the document type as an additional input and returning validation results.
  • MULTIPLIER — Validates the multiplier value defined on the price differential.
  • MIN_MULTIPLIER — Validates the minimum multiplier bound.
  • MAX_MULTIPLIER — Validates the maximum multiplier bound.
  • STYLE_RELATED_INFO — Validates style-related information by identifier and style identifier.

Tables Accessed

The package operates against the following documented tables and synonyms:

  • PO_PRICE_DIFFERENTIALS — the primary price differential definition table validated by this package.
  • PO_PRICE_DIFF_DRAFT — the draft or staging copy of price differential data.
  • PO_DOC_STYLE_HEADERS — document style headers, consulted for style-related validation.
  • PO_SESSION_GT — a session-scoped global temporary table used to hold working data during validation.
  • PO_VALIDATION_RESULTS_GT — the global temporary table that stores validation outcomes.
  • DUAL — used for scalar evaluations.
  • PLITBLM — the PL/SQL table (index-by table) used as a collection type underlying the bulk validation parameters.

Usage Notes

PO_VAL_PRICE_DIFFS2 is an internal validation package and is not intended to be called directly by end users. It is typically invoked by the Oracle Purchasing validation framework, which drives the collection-based procedures during the save or validation cycle of purchasing documents such as quotations and blanket agreements that use styled or configured items. The MULTIPLE_PRICE_DIFF procedure is the entry point most relevant when multiple differential lines must be evaluated together for consistency, which is the scenario commonly associated with a "multiple price diff" search.

Customizations should treat this package as framework-owned. Extensions that must validate or derive price differentials should normally be implemented through supported APIs and personalizations rather than by modifying or directly calling these procedures, because their signatures and collection types are tied to the internal validation infrastructure and may change between patch levels and releases such as 12.1.1 and 12.2.2.