Search Results pon_auc_headers_all

Overview

PON_SOURCING_OPENAPI_GRP is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified as a Group (GRP) API. It provides the public interface layer that Oracle Sourcing exposes to Oracle Purchasing and related modules for the creation and validation of draft sourcing negotiations. In releases 12.1.1 and 12.2.2, the package serves as the bridge between the Purchasing application and the Sourcing negotiation data model, allowing external callers to convert interface data into fully formed draft negotiations without direct manipulation of Sourcing base tables.

The header comment identifies the package as a wrapper layer whose signature is intentionally kept compatible with Purchasing code, ensuring backward compatibility across patch levels. The package handles negotiation document numbering, URL generation for editing drafts, concurrency request tracking, and structured error reporting through result, error code, and error message out parameters.

Key Procedures and Functions

The documented interface comprises twelve named routines:

• CREATE_DRAFT_NEG_INTERFACE — Public wrapper over the private create_draft_neg_interface_pvt routine; produces a new draft negotiation number and document URL from interface data, returning SUCCESS or FAILURE with error details.
• VAL_AUC_HEADERS_INTERFACE — Validates header-level records staged in the auction headers interface table prior to conversion.
• VAL_AUC_ITEMS_INTERFACE — Validates item-level interface records associated with the negotiation.
• VAL_AUC_SHIPMENTS_INTERFACE — Validates shipment and delivery scheduling interface records.
• VAL_ATTACHMENTS_INTERFACE — Validates attachment metadata staged in the attachments interface tables.
• GET_TRADING_PARTNER_INFO — Retrieves trading partner information, resolving party and relationship data via HZ_PARTIES and HZ_RELATIONSHIPS.
• PURGE_INTERFACE_TABLE — Cleans up processed interface rows, controlled by the internal g_call_purge global flag.
• IS_CPA_INTEGRATION_ENABLED — Determines whether the CPA integration feature is active for the current configuration.
• GET_DISPLAY_LINE_NUMBER — Returns a formatted display line number for negotiation lines.
• PON_RENEG_SUPER_LARGE_NEG — Handles renegotiation of exceptionally large negotiations, supporting the multi-phase negotiation workflow.
• MAINTAIN_CLM_RELATIONS — Maintains CLM (Contract Lifecycle Management) relationship records linked to the negotiation.
• INITIALISE_GLOBALS — Private initialisation routine that seeds package-level state for a given interface id.

Tables Accessed

The package reads and writes the staging table PON_AUC_HEADERS_INTERFACE, the primary interface for header data, along with PON_ATTACHMENTS_INTERFACE and PON_ATTRIBUTES_INTERFACE for supporting negotiation content. Validation and enrichment routines consult FINANCIALS_SYSTEM_PARAMS_ALL, FND_PRODUCT_GROUPS, FND_CURRENCIES, FND_LOOKUP_VALUES, FND_DOCUMENT_CATEGORIES, FND_USER, HZ_PARTIES, HZ_RELATIONSHIPS, MTL_CATEGORIES_KFV, and MTL_UNITS_OF_MEASURE. Attachment handling draws on FND_ATTACHED_DOCUMENTS and FND_ATTACHED_DOCUMENTS_S.

Usage Notes

PON_SOURCING_OPENAPI_GRP is typically invoked from the Sourcing negotiation creation flow in Oracle Purchasing, from concurrent programs that process staged interface data, and from custom extensions requiring programmatic draft negotiation creation. The wrapper routine preserves signature compatibility with Purchasing code, so callers should reference CREATE_DRAFT_NEG_INTERFACE rather than the private variant. Because a user searching for pon_auc_headers_all is likely tracing how negotiation headers are populated, note that this package operates on the interface table PON_AUC_HEADERS_INTERFACE and the validation routines feed the conversion into the base headers structure. Custom integrations should validate staged rows through the VAL_* routines before invoking the creation API, and should honour the purge flag to avoid interface table growth.