Search Results query_lines

Overview

APPS.OE_NEGOTIATE_WF is the workflow-enabled PL/SQL package body that drives the negotiation life cycle of Oracle Order Management sales documents — specifically quotations and blankets in Oracle E-Business Suite 12.1.1 and 12.2.2. It provides the server-side logic invoked by the seeded negotiation workflow (item type OE_GLOBALS.G_WFI_NGO) to transition a document through draft submission, customer acceptance or rejection, expiration, loss, and final completion. In addition, the package supplies the Workflow function activities exposed to the process definition, allowing administrators to branch a negotiation process based on document state, expiration dates, and customer response. The package is classified as OTHER in the ETRM repository, indicating that it is an internal implementation package rather than a published open interface, and its procedures should be treated as Workflow activity handlers rather than standalone application programming interfaces.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions. The status-transition handlers include UPDATE_STATUS_LOST, which marks the negotiation as lost against the underlying quote or blanket; NEGOTIATION_COMPLETE, which finalizes a successfully concluded negotiation; and LOST, CUSTOMER_ACCEPTED, and CUSTOMER_REJECTED, which serve as Workflow result or function activities that evaluate and record the customer's decision.

The customer-response group comprises CUSTOMER_ACCEPTANCE, AT_CUSTOMER_ACCEPTANCE, UPDATE_CUSTOMER_ACCEPTED, and UPDATE_CUSTOMER_REJECTED, which persist the acceptance or rejection outcome and advance the workflow accordingly. Expiration handling is provided by CHECK_EXPIRATION_DATE, OFFER_EXPIRED, OFFER_DATE_CHANGED, and SET_FINAL_EXPIRATION_DATE, which evaluate offer validity windows and update the document when an offer lapses or is extended. Draft submission relies on SUBMIT_DRAFT and SUBMIT_DRAFT_INTERNAL. Header descriptor and attribute maintenance is performed by SET_NEGOTIATE_HDR_DESCRIPTOR, SET_HEADER_ATTRIBUTES, and SET_HEADER_ATTRIBUTES_INTERNAL. Each handler follows the standard Workflow PL/SQL signature (itemtype, itemkey, actid, funcmode, resultout) and, per the source excerpt, populates the message context with HEADER entity information before delegating to OE_ORDER_WF_UTIL and raising standard FND_API exceptions on error.

Tables Accessed

The package operates against the core Order Management tables exposed through APPS synonyms. OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL hold the quotation or blanket header and line records whose status and attributes are updated during negotiation, while OE_BLANKET_HEADERS_ALL supports the blanket-specific header data. OE_TRANSACTION_TYPES_TL is consulted to resolve sales document type codes and their translated descriptions. Workflow state is managed through WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, WF_ITEM_ACTIVITY_STATUSES_H, and WF_PROCESS_ACTIVITIES, which record the negotiation item, its current and historical activity statuses, and the process definition activities used to determine branching. Collectively these reads and writes ensure the business document and its workflow instance remain synchronized.

Usage Notes

OE_NEGOTIATE_WF is not intended for direct invocation by end users or custom batch programs. It is executed by the Oracle Workflow engine as the negotiation process runs, with the workflow background engine or online workflow processing supplying the itemtype, itemkey, actid, and funcmode parameters. The package is referenced by three other packages, confirming that internal Order Management components also call selected handlers during document maintenance. In 12.1.1 and 12.2.2 the file is shipped as OEXWNEGB.pls, so any customization should wrap the standard handlers rather than modify the seeded body, preserving supportability and upgrade safety.