Search Results pon_sourcing_api_grp




Overview
Explore in AI Chat

Overview

PON_SOURCING_API_GRP is an Oracle EBS PL/SQL package owned by the APPS schema that supports the Oracle Sourcing application. It is classified as a GRP (group) API, meaning it exposes procedural business logic rather than a full PL/SQL table-handler interface used for DML against a single base entity. The package is declared with AUTHID CURRENT_USER, so its unqualified references are resolved against the privileges of the invoking schema rather than the definer, which is typical of internal Oracle Applications group APIs designed to be called from other APPS-owned code and from custom extensions running with the calling user's authority.

Functionally, the package addresses validation associated with negotiation sourcing lines. Its source header ($Header: PONNELTS.pls 120.0 ...) indicates it was authored by the Oracle Sourcing development team. The single exposed entry point is a validation routine; the group naming convention and small surface area indicate it exists to centralize a specific cross-check used by other sourcing components rather than to provide general-purpose negotiation maintenance.

Key Procedures and Functions

The documented specification exposes one procedure:

  • val_neg_exists_for_line_type — Validates whether a negotiation exists for a given line type. It accepts a line type identifier as input and returns an out result indicator plus out error code and error message parameters, following the standard Oracle EBS concurrent/API error-reporting convention of returning a status value alongside a code and a translatable message.

No other procedures or functions are documented for this package, and no public function with a return value is declared. Because only the specification excerpt is documented, callers should not assume additional hidden entry points; all inter-package dependencies flow through this validation routine.

Tables Accessed

The only table documented as referenced through APPS synonyms is PON_AUCTION_ITEM_PRICES_ALL. This table stores auction (negotiation) item price records for sourcing events. Used in the context of val_neg_exists_for_line_type, the package queries these records to determine whether negotiation pricing data exists for the supplied line type, and the outcome is conveyed through the out parameters. The package does not appear in the documentation as writing to this table; its role is validation and determination only.

Usage Notes

This group API is invoked internally by other Oracle Sourcing components — the ETRM metadata records one other package that references it — and it is not intended as an end-user entry point. Typical invocation patterns are:

  • Called from other APPS PL/SQL packages during negotiation and line-type validation, before allowing a sourcing action to proceed.
  • Called from Oracle Forms-based Sourcing windows that must confirm the presence of negotiation data tied to a selected line type.
  • Potentially called from custom code and extensions that need the same validation rule the standard product enforces; custom callers should supply the line type identifier and check the returned result and error outputs rather than relying on exceptions.

Because the object is a group API with AUTHID CURRENT_USER, it is available in both 12.1.1 and 12.2.2, and its behavior depends on the invoking user's access to PON_AUCTION_ITEM_PRICES_ALL. Custom integrations should treat the procedure signature as fixed and avoid modifying the package, which is owned by Oracle and subject to patching.