Search Results validate_attributes_api




Overview
Explore in AI Chat

Overview

PON_AUC_INTERFACE_TABLE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Sourcing (formerly Oracle iProcurement Sourcing / Auctions) bulk-upload interface. Its purpose is to validate and transform rows staged in the PON auction interface tables before those rows are promoted into the production Oracle Sourcing base tables. The package is one stage of the multi-step interface pipeline that begins when a buyer or external system loads auction headers, attributes, price elements, price differentials, and requirement lines into the PON_AUC_* staging tables, and ends when the validated data is moved into PON_AUCTION_HEADERS_ALL and its dependent tables.

The package is classified as OTHER, meaning it is not a published open interface API for external callers, but it is invoked internally by the Sourcing interface concurrent programs and by other packages (the metadata indicates it is referenced by one other package). The most commonly searched entry point, VALIDATE_ATTRIBUTES, is the routine that checks auction attribute rows in the interface tables against relational data such as attribute definitions, lookup values, and party preferences, returning errors to the interface error table when validation fails.

Key Procedures and Functions

The package exposes twelve documented procedures across its public specification and companion API layers:

  • VALIDATE_PRICE_ELEMENTS — validates price element rows staged for a given source and batch, applying currency precision and numeric decimal rules passed in by the caller.
  • VALIDATE_HEADER_ATTRIBUTES — validates header-level attribute data for a batch and party, ensuring required header attributes are present and consistent.
  • VALIDATE_ATTRIBUTES — the primary attribute validation routine. Two overloads exist: one accepts a p_attr_type_header BOOLEAN flag that scopes validation to header versus line attributes, and a second overload validates the full attribute set for the batch.
  • VALIDATE_HEADER_ATTRIBUTES_API and VALIDATE_ATTRIBUTES_API — API-layer wrappers providing the standard callable entry points used by the interface programs.
  • VALIDATE_REQUIREMENT — validates requirement lines associated with the auction batch.
  • VALIDATE_PRICE_DIFFERENTIALS — checks price differential rows loaded for the batch.
  • ADD_TEMPLATE_PRICE_ELEMENTS — copies price elements from an auction template onto a newly created auction header.
  • ADD_TEMPLATE_ATTRIBUTES — copies attribute definitions from a template into the interface data for the batch.
  • ADD_IP_DESCRIPTORS — adds item descriptor records to the interface for the auction header.
  • INSERT_ERROR_INTERFACE — writes validation failures into PON_INTERFACE_ERRORS so they can be reviewed and corrected.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

These reads supply validation context (lookups, scoring rules, allowed document types, party preferences), while the interface tables hold the rows being validated and PON_INTERFACE_ERRORS receives any rejected rows.

Usage Notes

PON_AUC_INTERFACE_TABLE_PKG is not intended for direct ad-hoc customer invocation. It is called by the Oracle Sourcing interface concurrent programs and by the package(s) that orchestrate the auction load, in the sequence: load staging rows, call ADD_TEMPLATE_* to seed defaults, call VALIDATE_* routines, and finally promote the surviving rows. Because the API-layer procedures (VALIDATE_ATTRIBUTES_API, VALIDATE_HEADER_ATTRIBUTES_API) are the supported wrappers, custom code that must re-trigger attribute validation after correcting staging rows should call those wrappers rather than the internal validate routines. All behavior is identical between EBS 12.1.1 and 12.2.2, as this package's signature and header (PONAITS.pls 120.0) have not changed across those releases.