Results for “po_negotiations_sv2”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PO_NEGOTIATIONS_SV2 is a PL/SQL package in the APPS schema of Oracle E-Business Suite that provides the core server-side logic for Oracle Sourcing and sourcing-related negotiation activity within the Purchasing module. Its designation as a "SV" (server-side validation or service) package reflects its role as an internal business logic layer invoked by higher-level APIs and workflow processes rather than as a direct user-facing interface. The package handles critical operations associated with negotiation lines, bid/auction attribute propagation, sourcing pay item attachments, and the conversion of text data into Oracle Attachment Framework records. In releases 12.1.1 and 12.2.2, the package remains a VALID object in the ETRM registry, confirming active use in both the on-premise and reference architectures. It is classified under the "OTHER" API classification, indicating it is not a formally published, supported public API and is therefore intended for internal EBS consumption by dependent packages and concurrent programs.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within the package, though the excerpt exposes a subset of names. The documented members include:

• NAME — A member that returns or exposes the package's identifying name for dependency and registration purposes.
• CONVERT_TEXT_TO_ATTACHMENT — Converts plain text supplied by a caller into a properly structured attachment record within the Oracle Attachment Framework, associating the resulting document with the relevant sourcing entity.
• CONVERT_TEXT_TO_ATTACH_CLOB — The CLOB-aware variant of the conversion routine, used when the source text exceeds the size limits of standard VARCHAR2 storage and must be persisted as a character large object.
• COPY_SOURCING_PAYITEM_ATTS — Copies sourcing pay item attributes between negotiation structures, typically invoked when negotiating lines are duplicated, revised, or created from a template.

Because these are internal routines, parameter signatures are not published in the ETRM documentation and should not be assumed.

Tables Accessed

The package reads and writes across several functional areas. Core purchasing structures include PO_LINES_ALL, the base table for purchase order and negotiation lines, and PO_DISTRIBUTIONS_INTERFACE, used during interface import of distributions. Attachment processing relies on the FND_DOCUMENTS family — FND_DOCUMENTS, FND_DOCUMENTS_TL, FND_DOCUMENTS_SHORT_TEXT, FND_DOCUMENTS_LONG_TEXT, FND_DOCUMENT_CATEGORIES, FND_ATTACHED_DOCUMENTS, FND_ATTACHED_DOCUMENTS_S, and FND_LOBS — which together supply the metadata, translated descriptions, text storage, and binary content for attachment records. Sourcing-specific attributes are drawn from PON_AUCTION_ATTRIBUTES and PON_BID_ATTRIBUTE_VALUES. Supporting reference data comes from MTL_SYSTEM_ITEMS, HR_LOCATIONS_ALL, and FINANCIALS_SYSTEM_PARAMETERS.

Usage Notes

PO_NEGOTIATIONS_SV2 is not invoked directly by end users through a form. Instead it is referenced by dependent application packages — PO_AUTOCREATE_POSTPROC_PVT, PO_AUTO_LINE_PROCESS_PVT, PO_INTERFACE_S, PO_SOURCING_PVT, and recursively within itself. This dependency pattern indicates the package sits beneath the sourcing and autocreate processing flows, executing as part of larger concurrent program runs, workflow background processes, and interface import cycles. The recursive self-reference observed in the ETRM tree underscores its use of shared internal utility routines. Because it is classified as OTHER and not a supported public API, custom code should not call PO_NEGOTIATIONS_SV2 directly; upgrades or patches may alter its internal behavior without notice. Customizations that require negotiation or attachment conversion logic should instead be routed through supported public APIs or the dependent packages listed above.