Search Results offer_date_changed

Overview

APPS.OE_NEGOTIATE_WF is the Oracle Order Management negotiation workflow PL/SQL package responsible for driving and servicing the Oracle Workflow processes associated with quote and blanket sales agreement negotiation. In Oracle EBS 12.1.1 and 12.2.2, it acts as the bridge between the transactional negotiation entities (quotes and blankets) held in the ordering tables and the Workflow engine that governs the negotiation lifecycle: submission of a draft, internal and customer review, acceptance or rejection, update of negotiated status, and handling of expiration dates. The package exposes a combination of Workflow activity callback procedures — the standard itemtype, itemkey, actid, funcmode, resultout signature used by Workflow function activities — and business-level PL/SQL APIs used to advance or terminate a negotiation.

Its source header identifies the package as an internal, non-shipped ("noship") component, indicating it is intended for use by the EBS application rather than as a supported public API surface.

Key Procedures and Functions

The package contains 18 documented procedures, divided between Workflow activity callbacks and business operations.

• UPDATE_STATUS_LOST — Workflow callback that applies the outcome of a lost negotiation to the underlying document.
• NEGOTIATION_COMPLETE — Workflow callback marking the negotiation as complete.
• SUBMIT_DRAFT_INTERNAL / SUBMIT_DRAFT — Submission of a draft negotiation into the workflow process.
• CUSTOMER_ACCEPTANCE — Workflow callback evaluating the customer acceptance step.
• UPDATE_CUSTOMER_ACCEPTED / UPDATE_CUSTOMER_REJECTED — Apply the result of customer acceptance or rejection to the negotiation record.
• CHECK_EXPIRATION_DATE — Callback that evaluates whether the offer has passed its expiration date.
• OFFER_EXPIRED — Handles the outcome when an offer expires.
• SET_NEGOTIATE_HDR_DESCRIPTOR — Builds the header descriptor (display/document type) for the negotiation document.
• LOST — Business API marking a negotiation or order header as lost with reason type, code, and comments.
• CUSTOMER_ACCEPTED / CUSTOMER_REJECTED — Business APIs recording customer acceptance or rejection against a header.
• OFFER_DATE_CHANGED — Processes changes to offer dates.
• SET_HEADER_ATTRIBUTES / SET_HEADER_ATTRIBUTES_INTERNAL / SET_FINAL_EXPIRATION_DATE — Populate header attributes and finalize expiration dates on the negotiation.
• AT_CUSTOMER_ACCEPTANCE — Represents the workflow state at customer acceptance.

Tables Accessed

The package reads and writes through APPS synonyms of the following tables:

• OE_BLANKET_HEADERS_ALL — Blanket sales agreement header data for blanket negotiations.
• OE_ORDER_HEADERS_ALL / OE_ORDER_LINES_ALL — Order and quote header/line records updated as negotiation status changes.
• OE_TRANSACTION_TYPES_TL — Transaction type descriptions used in descriptor and attribute population.
• WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, WF_ITEM_ACTIVITY_STATUSES_H, WF_PROCESS_ACTIVITIES — Workflow item and activity status/history data used by the callbacks to read and update workflow state.

Usage Notes

OE_NEGOTIATE_WF is invoked primarily by Oracle Workflow as the implementation of negotiation workflow activities, and secondarily by Order Management forms and concurrent programs that submit drafts, record customer acceptance or rejection, or expire offers. It is referenced by three other packages within the APPS schema. Because the header classifies it as an internal component and it exposes the standard Workflow callback signatures, it should not be treated as a supported public API; customizations should avoid direct calls and instead rely on the documented negotiation APIs and workflow configuration.