Search Results g_batch_id

Overview

PON_CP_INTRFAC_TO_TRANSACTION is an Oracle E-Business Suite package body owned by APPS that supports the Oracle Sourcing (PON) module, specifically the Contract/Price negotiation and auction upload functionality. Its primary business function is to transfer data staged in the interface tables (principally PON_AUC_ATTRIBUTES_INTERFACE and related interface structures) into the transactional auction tables that the Sourcing application actually uses. In practical terms, it converts rows uploaded from a supplier or buyer spreadsheet into live auction attributes, price elements, price factors, and shipment records. The package header reflects a 120.26 revision dated 2007, which places it squarely in the code line shared by EBS 12.1.1 and 12.2.2. The user search term "interface_attribute" maps directly to the package's core responsibility: moving attribute data from the interface staging area into the PON_AUCTION_ATTRIBUTES and related transaction tables.

Key Procedures and Functions

• DEFAULT_PREV_ROUND_AMEND_LINES — Establishes default values for lines carried over from a previous auction round during amendment processing, reconciling prior-round line numbering with the current batch.
• GET_NEXT_PE_SEQUENCE_NUMBER — Returns the next available price element sequence number, driven by the global g_price_element_seq_number and the constant increment of 10, ensuring unique ordering of price element rows.
• GET_SEQUENCE_NUMBER — Computes and returns sequence numbers used for internal line numbering, referencing the global g_cur_internal_line_num and g_max_attribute_seq_num.
• GET_ATTR_GROUP_SEQ_NUMBER — Derives the sequence number for an attribute group, supporting the initialization of default attribute groups and section names.
• GET_ATTR_DISP_SEQ_NUMBER — Determines the display sequence number for an attribute so that attributes appear in the intended order on the auction user interface.
• SYNCH_FROM_INTERFACE — The principal synchronization routine that reads staged interface rows and writes them to the transactional auction attribute, price, and shipment tables.
• SYNCH_PAYMENTS_FROM_INTERFACE — Synchronizes payment-related interface data, applying the appropriate action codes (add, update, or delete) to the target tables.
• UPDATE_CONCURRENT_ERRORS — Records or updates error information generated during interface processing so that concurrent program runs report failures accurately.

Tables Accessed

The package writes primarily to PON_AUCTION_ATTRIBUTES, PON_ATTRIBUTE_SCORES, PON_AUCTION_ITEM_PRICES (and the _ALL variant), and PON_AUCTION_SHIPMENTS_ALL, which together form the transactional auction model. It reads interface data from PON_AUC_ATTRIBUTES_INTERFACE. Supporting configuration and reference lookups include PON_AUCTION_HEADERS_ALL, PON_AUC_BIZRULES, PON_AUC_DOCTYPES, and PON_AUC_DOCTYPE_RULES. Additional validation and setup tables include FINANCIALS_SYSTEM_PARAMS_ALL, FND_ATTACHED_DOCUMENTS, FND_USER, HR_LOCATIONS_ALL, and MTL_UNITS_OF_MEASURE.

Usage Notes

This package is invoked from the Oracle Sourcing upload and synchronized-auction flow, typically triggered by a concurrent program or a UI action that processes an uploaded spreadsheet batch. Two other packages reference it, indicating it forms part of a shared Sourcing framework rather than being called directly by end users. It self-references the profile option AFLOG_ENABLED for debug logging, so administrators should enable FND debug to trace interface processing errors.