Search Results default_prev_round_amend_lines




Overview
Explore in AI Chat

Overview

PON_CP_INTRFAC_TO_TRANSACTION is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an "OTHER" API. It supports the Oracle Sourcing (Oracle iProcurement/Sourcing) auction and negotiation functionality, specifically the movement of data from the auction interface tables into the transactional base tables used by the auction engine. In the EBS 12.1.1 and 12.2.2 code lines, the package provides the procedural bridge that transforms staged interface rows into fully realized auction lines, attribute groups, shipments, and payment records.

The package is a sibling of other PON_CP (Oracle Sourcing Concurrent Program) packages that process auction-related batch data. Its central responsibility is sequence-number generation for interface lines and attribute groups, together with synchronization routines that reconcile interface data with the PON_AUCTION_* transaction tables. The get_attr_group_seq_number function that prompted the user's search is one of the sequencing helpers that derive the ordering of attribute groups as interface rows are converted into auction transactions.

Key Procedures and Functions

The package exposes nine documented subprograms, divided into sequencing helpers and synchronization procedures:

  • DEFAULT_PREV_ROUND_AMEND_LINES — A procedure that applies default handling for lines amended in a previous auction round, establishing the prior-round amendment context for a given auction header and batch.
  • GET_NEXT_PE_SEQUENCE_NUMBER — Returns the next price-element sequence number for an auction line, used when assigning ordering to line-level price elements.
  • GET_SEQUENCE_NUMBER — Returns the sequence number for an interface line based on the batch, interface line identifier, and a template sequence number, providing fallback logic for ordering.
  • GET_ATTR_GROUP_SEQ_NUMBER — Returns the sequence number for an attribute group, taking the batch, interface line, attribute group name, and a template group sequence number. This is the function directly answering the user's search term.
  • GET_ATTR_DISP_SEQ_NUMBER — Returns the display sequence number for an attribute group, analogous to the group sequence helper but oriented toward display ordering.
  • SYNCH_FROM_INTERFACE — The principal synchronization procedure. It converts interface rows into auction transaction lines for a batch and auction header, returning the number of lines, maximum display line, last line close date, and a result indicator along with error code and message.
  • SYNCH_PAYMENTS_FROM_INTERFACE — Synchronizes payment information from the interface tables into transaction form, returning result, error code, and error message.
  • UPDATE_CONCURRENT_ERRORS — Updates concurrent processing error records for the batch and auction header, returning result, error code, and error message.

Tables Accessed

The package reads and writes a documented set of tables through APPS synonyms. The auction transaction side includes PON_AUCTION_HEADERS_ALL, PON_AUCTION_ATTRIBUTES, PON_ATTRIBUTE_SCORES, PON_AUCTION_ITEM_PRICES and PON_AUCTION_ITEM_PRICES_ALL, and PON_AUCTION_SHIPMENTS_ALL. These hold the negotiated line, attribute, price, and shipment records that the synchronization routines create or update.

The interface and configuration side includes PON_AUC_ATTRIBUTES_INTERFACE, PON_AUC_BIZRULES, PON_AUC_DOCTYPES, and PON_AUC_DOCTYPE_RULES, which supply the staged data and sourcing business rules driving the conversion. Supporting reference tables include FINANCIALS_SYSTEM_PARAMS_ALL, FND_ATTACHED_DOCUMENTS, FND_USER, HR_LOCATIONS_ALL, and MTL_UNITS_OF_MEASURE, providing system parameters, attachments, user identity, location, and unit-of-measure data required during line construction.

Usage Notes

PON_CP_INTRFAC_TO_TRANSACTION is invoked primarily by Oracle Sourcing concurrent programs that process auction interface batches. The SYNCH_FROM_INTERFACE and SYNCH_PAYMENTS_FROM_INTERFACE procedures are the entry points typically called in sequence during batch processing, with UPDATE_CONCURRENT_ERRORS used to record failures. The sequence-number functions are called internally during interface-to-transaction conversion, but may also be referenced by custom extensions or reports that need to reproduce the ordering logic applied to interface lines and attribute groups.

Because the package is classified as OTHER rather than a public API, Oracle does not guarantee interface stability. Customizations should treat these subprograms as internal, verify behavior against the specific EBS release, and avoid direct calls where a supported API exists. Version differences between 12.1.1 and 12.2.2 should be confirmed in each environment before reliance.