Search Results complete_negotiation

Overview

OE_QUOTE_UTIL is a utility package body in the Oracle Order Management (OM) module of Oracle E-Business Suite, owned by the APPS schema. It is classified in the ETRM repository as a UTIL (utility) API, meaning it is not a full public business API in the same sense as OE_ORDER_PUB, but instead encapsulates internal processing logic invoked by other OM packages and forms. Its primary business purpose is to finalize, or "complete," a negotiation — the quotation-stage representation of an order that has not yet progressed to a firm sales order. In quote and negotiation workflows, Order Management stores header and line data in the same OE_ORDER_HEADERS_ALL / OE_ORDER_LINES_ALL structures used for orders, distinguished by order category and type. Completing a negotiation transitions that quotation through the internal update pipeline so that pricing, adjustments, and associated data are persisted consistently.

Key Procedures and Functions

The package body documentation lists a single public procedure:

• COMPLETE_NEGOTIATION — Accepts a header identifier for the negotiation and returns standard API status outputs (return status, message count, message data). Its purpose is to drive the completion of a quotation/negotiation record, coordinating the header and line updates required to bring the negotiation to its completed state. Internally, it begins by raising the API status to success and then locks the order header and associated lines through OE_Header_Util.Lock_Row, ensuring that no concurrent modification occurs while the completion logic executes. The procedure declares an extensive set of OE_Order_PUB record and table types — header, line, adjustment, price attribute, adjustment association, sales credit, lot/serial, and payment structures — plus an OE_Order_PUB action request table and an OE_GLOBALS control record, indicating that the completion logic gathers and processes the full set of order entities before applying changes. Debug tracing is conditionally emitted through OE_DEBUG_PUB when the global debug level is greater than zero. No parameter list beyond the documented signature should be assumed; the procedure's contract is defined by its header identifier input and its three standard output parameters.

Tables Accessed

The ETRM metadata records a single referenced table via APPS synonyms: PLITBLM. This is a temporary/interim work table used within Order Management processing to stage line-level data during internal operations. Because OE_QUOTE_UTIL operates primarily through the OE_ORDER_PUB public API structures and the OE_HEADER_UTIL utility, its persistent writes to sales order header and line tables are performed indirectly, through those called APIs rather than through direct DML in this package. The locking call to OE_Header_Util.Lock_Row reads and locks the order header and lines by header identifier, which is the mechanism by which the negotiation's underlying rows in the order tables are secured before completion.

Usage Notes

OE_QUOTE_UTIL is referenced by nine other packages in the ETRM repository, confirming its role as an internal utility consumed by higher-level OM processing rather than a directly called public API. In Oracle EBS 12.1.1 and 12.2.2, such negotiation-completion logic is typically reached from the Order Management quotation windows and from the Order Management order/quote processing flows, where completing a quote triggers the underlying finalization routine. Custom code should generally not invoke COMPLETE_NEGOTIATION directly; instead, the supported OE_ORDER_PUB APIs or the standard OM forms and concurrent processes should be used, as this utility assumes the caller has already established the appropriate context and locking. When troubleshooting quote completion, DBAs and developers enable OE_DEBUG_PUB output to trace entry into Complete_Negotiation and observe the locking and status flow.