Search Results update_line_price

Overview

PO_SOURCING2_SV is a server-side PL/SQL package in the Oracle E-Business Suite sourcing module, owned by APPS and classified as an "OTHER" API. It provides the core pricing engine used during sourcing and purchasing document entry, resolving supplier price breaks, shipment-level prices, and line prices for purchase orders, quotations, and related sourcing documents. The package is delivered as a package body (POXSCS2B.pls), with the latest documented version at 120.5.12010000.2, and it is invoked broadly across the procurement stack — it is referenced by 13 other packages, making it a shared dependency for price derivation logic rather than a standalone utility.

Key Procedures and Functions

The documented interface exposes 15 named procedures and functions. The principal entry points are:

• NAME — the package-level identifier entry associated with the body.
• GET_BREAK_PRICE — returns the applicable price for a given order quantity, ship-to organization, ship-to location, PO line, cumulative flag, need-by date, and line location. It is overloaded: a scalar function returns the price directly, while a procedural form returns the price break identifier, price, and return status. Internally the function delegates to the overloaded procedure, passing an API version of 1.0 and returning the resolved price. This is the mechanism that drives quantity-based price break selection.
• UPDATE_LINE_PRICE — the procedure associated with the user search term "update_line_price." It applies or refreshes the derived price on a purchasing document line, ensuring the line carries the correct price following price break evaluation or sourcing changes.
• GET_SHIPMENT_PRICE — resolves the price at the shipment (line location) level, supporting pricing that varies by ship-to destination or delivery.

The package also declares debug controls (G_FND_DEBUG from the AFLOG_ENABLED profile, plus PO_DEBUG flags) and an FPJ custom price extension region, indicating that price calculation can be extended or instrumented through profile-driven switches.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• PO_HEADERS / PO_HEADERS_ALL — header context for the sourcing or purchasing document.
• PO_LINES / PO_LINES_ALL — line-level attributes and the line price maintained by UPDATE_LINE_PRICE.
• PO_LINE_LOCATIONS / PO_LINE_LOCATIONS_ALL — shipment-level data used by GET_SHIPMENT_PRICE and the line location input to GET_BREAK_PRICE.
• MTL_SYSTEM_ITEMS — item attributes that influence price derivation.
• PO_QUOTATION_APPROVALS_ALL — quotation approval records relevant to sourcing price resolution.

Usage Notes

PO_SOURCING2_SV is not a user-facing API; it is invoked from Oracle Forms (primarily the Purchasing and Sourcing document entry forms), from concurrent programs that recalculate document prices, and from custom code that must reproduce EBS pricing behavior. Because 13 other packages depend on it, modifications should be treated as high-impact. Note that documented API contracts, including parameter lists for the overloaded GET_BREAK_PRICE variants, remain the authoritative reference; custom extensions should call the public entry points rather than embed equivalent logic.