Search Results update_user_text

Overview

OE_CHG_ORDER_PVT is a private (PVT) PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Order Management (OE) module and functions as an internal engine for maintaining order change history and audit trail records. Its central role is to capture the before and after image of header, line, sales credit, and price adjustment data whenever a change is applied to an order, and to coordinate the change order workflow that routes order modifications through Oracle Workflow. The package is classified as PVT, indicating it is not a public API and is not supported for direct invocation by external or custom code. It is tightly coupled with OE_ORDER_PUB, from which it consumes order data structures and processing logic.

Key Procedures and Functions

The package exposes twelve documented program units. Their documented purposes are:

• START_CHANGEORDERFLOW — Initiates the change order workflow for an order undergoing modification.
• CREATE_CHGORDERWORKITEM — Creates the workflow item associated with the change order process.
• GENERATE_PLSQLDOC — Generates PL/SQL documentation metadata for the package.
• UPDATE_USER_TEXT — Maintains the user-entered change description or reason text associated with a change.
• UPDATE_ORDER_NUMBER — Records changes to the order number field in the history tables.
• RECORDLINEHIST — Inserts line-level history records into OE_ORDER_LINES_HISTORY.
• RECORDHEADERHIST — Inserts header-level history records into OE_ORDER_HEADER_HISTORY.
• RECORDHSCREDITHIST — Records header-level sales credit history into OE_SALES_CREDIT_HISTORY.
• RECORDLSCREDITHIST — Records line-level sales credit history into the sales credit history structure.
• RECORDHPADJHIST — Captures header-level price adjustment history into OE_PRICE_ADJS_HISTORY.
• RECORDLPADJHIST — Captures line-level price adjustment history into OE_PRICE_ADJS_HISTORY.
• RESET_AUDIT_HISTORY_FLAGS — Resets the internal audit history flags that control whether history records are written for a given transaction.

Tables Accessed

Through APPS synonyms, the package interacts with the following documented tables:

• OE_ORDER_HEADER_HISTORY — stores historical header snapshots written by RECORDHEADERHIST.
• OE_ORDER_LINES_HISTORY — stores historical line snapshots written by RECORDLINEHIST.
• OE_SALES_CREDIT_HISTORY — stores sales credit history for header and line changes.
• OE_PRICE_ADJS_HISTORY — stores price adjustment history at header and line level.
• FND_USER — resolves the user identity recorded against historical changes.
• IBY_CREDITCARD_H — holds credit card history related to order changes.
• OE_WF_KEY_S — the Order Management workflow key sequence used when creating change order workflow items.
• DUAL, HTF, PLITBLM — utility references used for PL/SQL documentation generation and generic processing.

Usage Notes

OE_CHG_ORDER_PVT is invoked internally by Order Management utilities rather than by end users or custom integrations. The ETRM metadata confirms it is referenced by nine packages: OE_HEADER_ADJ_UTIL, OE_HEADER_SCREDIT_UTIL, OE_HEADER_UTIL, OE_LINE_ADJ_UTIL, OE_LINE_SCREDIT_UTIL, OE_LINE_UTIL, OE_SALES_CAN_UTIL, OE_SPLIT_UTIL, and OE_VERSIONING_UTIL, in addition to a self-reference. These callers correspond to the standard order maintenance operations—order entry and update, sales credit changes, price adjustment changes, line splitting, versioning, and sales order cancellation. History recording is typically triggered from the Oracle Order Management forms when a user commits a change, and change order workflow processing is started for orders that require approval routing. Because the package is a PVT object, Oracle does not support direct calls from custom code; developers requiring order change functionality should use the public OE_ORDER_PUB APIs instead. The object must remain VALID and must be recompiled after relevant patches, as invalidating it can prevent order history from being written and change order workflows from starting.