Search Results process_user_attrs_data

Overview

The APPS.PON_ATTR_MAPPING package is a PL/SQL API within the Oracle E-Business Suite Sourcing (Oracle Sourcing / Oracle iProcurement sourcing) module, owned by the APPS schema and classified as OTHER in the ETRM repository for releases 12.1.1 and 12.2.2. Its core responsibility is to manage the mapping of user-defined attributes associated with auction headers and bid lines, and to persist or synchronize the values supplied against those attributes. In the Sourcing data model, an auction (negotiation) can carry configurable "user attributes" whose definition is stored in PON_AUCTION_ATTRIBUTES and mapped through PON_AUCTION_ATTR_MAPPING_B. This package provides the runtime logic that takes raw attribute data captured during a bid or auction and validates, transforms, and writes it to the correct underlying columns or structures. It declares a single constant, G_DELIMITER (value '$_$'), which is used to delimit concatenated attribute segments during parsing and processing.

Key Procedures and Functions

The package exposes two public procedures:

• PROCESS_USER_ATTRS_DATA — Processes user attribute data for a given auction header and bid number. It accepts an auction header identifier and a bid number, and returns a status and error message through OUT parameters. This procedure is the primary entry point invoked when attribute values captured for a bid need to be validated against their mappings and committed to the appropriate storage.
• SYNC_USER_ATTRS_DATA — Synchronizes user attribute data for a given auction header and vendor. It accepts an auction header identifier and a vendor identifier together with return status and error message OUT parameters. It is used to reconcile attribute values between the auction definition and vendor-specific records (for example, supplier or supplier site data derived from the mapping).

Both procedures follow the standard EBS API convention of returning x_return_status and x_err_msg, allowing callers to detect success or capture diagnostic text.

Tables Accessed

The package reads and writes a broad set of Sourcing and Trading Community tables through APPS synonyms:

• Sourcing core: PON_AUCTION_HEADERS_ALL, PON_AUCTION_ATTRIBUTES, and PON_AUCTION_ATTR_MAPPING_B supply the auction, attribute definition, and mapping metadata that drive processing.
• Trading Community / suppliers: AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL, HZ_PARTIES, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, HZ_LOCATIONS, HR_LOCATIONS_ALL, HZ_CODE_ASSIGNMENTS, and HZ_CLASS_CODE_RELATIONS provide supplier, site, location, and classification values that may be mapped into user attributes.
• Inventory: MTL_SYSTEM_ITEMS_B supplies item information where attributes reference items.
• Setup: EGO_OBJ_AG_ASSOCS_B (attribute group associations) and FINANCIALS_SYSTEM_PARAMS_ALL (financials system parameters) support attribute-group resolution and organizational context.

Usage Notes

PON_ATTR_MAPPING is an internal Sourcing API rather than a standalone concurrent program. It is typically invoked from the Sourcing/negotiation business logic, from Oracle Forms-based setup or bid entry screens, or from other PL/SQL packages that manage auction attributes — the ETRM metadata records that it is referenced by one other package. Customizations should call PROCESS_USER_ATTRS_DATA after bid attribute values are captured and SYNC_USER_ATTRS_DATA when vendor-specific attribute data must be reconciled, always checking x_return_status before proceeding. Because the package is declared AUTHID CURRENT_USER, execution privileges and synonym resolution depend on the calling schema. The delimiter constant G_DELIMITER indicates that multi-valued attributes are concatenated and parsed internally, so values should not be altered between capture and API invocation.