Search Results insert_into_history_chgsubmit

Overview

PO_REQCHANGEREQUESTWF_PVT is a private PL/SQL package in the APPS schema that supports the Oracle Purchasing requisition change request workflow. Its central role is to manage the approval, acceptance, rejection, and cancellation lifecycle for changes submitted against existing requisitions. When a buyer or requester modifies a requisition, the resulting change request must pass through a workflow-driven process; this package encapsulates that logic so the workflow activities can call a stable, well-defined API rather than operating directly on base tables.

The package is classified as a PVT (private) API, meaning it is not part of Oracle's documented public interface. It is invoked internally by other Purchasing packages and by Oracle Workflow. The ETRM metadata lists 71 documented procedures and functions, indicating a broad responsibility set spanning requisition change submission, buyer response handling, approval determination, and cancellation processing. Its position in the dependency graph — referenced by PO_DOCUMENT_CANCEL_PVT and PO_RCO_VALIDATION_PVT, and referencing FND_API — confirms that it participates in both the document cancellation framework and the requisition change order validation path.

Key Procedures and Functions

The documented entry points fall into several functional clusters:

• Change submission and history: INSERT_INTO_HISTORY_CHGSUBMIT, SET_CHANGE_MGR_PRE_APP, SET_CHANGE_MGR_APP, UPDATE_REQ_CHANGE_FLAG, and COMPARE_REVISION support capturing the change request, recording history, and comparing revisions of the requisition.
• Approval determination: REQ_CHANGE_NEEDS_APPROVAL, IS_DOC_APPROVED, SET_DOC_IN_PROCESS, and ANY_CANCELLATION_CHANGE evaluate whether a change requires approval and track the document's workflow state.
• Buyer response handling: START_PROCESS_BUY_RESPONSE_WF, START_PROCESSBUYERRESPONSEWF, INSERT_BUYER_ACTION_HISTORY, RECORD_BUYER_REJECTION, RECORD_BUYER_ACCEPTANCE, PROCESS_BUYER_REJECTION, and REQ_CHANGE_RESPONDED initiate and record the buyer's response to a change request.
• Acceptance and cancellation: PROCESS_CANCEL_ACCEPTANCE, CHANGE_ACCEPTANCE_EXISTS, PROCESS_CHANGE_ACCEPTANCE, and PROCESS_CANCELLED_REQ_LINES handle acceptance of changes and the cancellation of requisition lines.

Collectively these procedures drive the state transitions of the change request through the workflow, persisting the outcomes to history and flagging the requisition accordingly.

Tables Accessed

The package reads and writes a wide set of core Purchasing, Order Management, and inventory tables, accessed through APPS synonyms:

• Purchasing documents: PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTIONS_ALL hold the requisition, line, shipment, and distribution data affected by the change.
• Change tracking: PO_CHANGE_REQUESTS and PO_ACTION_HISTORY store the change request record and the audit trail of buyer and system actions.
• Order Management: OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL support changes originating from or linked to sales order demand.
• Inventory and supply: MTL_SUPPLY, MTL_SYSTEM_ITEMS_B, and MTL_UNITS_OF_MEASURE provide supply information, item attributes, and unit of measure validation.
• Encumbrance and currency: PO_ENCUMBRANCE_GT, FND_CURRENCIES, and FINANCIALS_SYSTEM_PARAMS_ALL support encumbrance adjustments and currency handling.
• Security and reference: FND_USER identifies the actors submitting or responding to changes.

Usage Notes

PO_REQCHANGEREQUESTWF_PVT is not intended for direct invocation by end users or custom applications. It is called internally by Oracle Workflow processes and by other Purchasing packages, notably PO_DOCUMENT_CANCEL_PVT and PO_RCO_VALIDATION_PVT. Custom code should use the corresponding public APIs rather than calling this package directly, as its signature and behavior are private and subject to change across releases. When troubleshooting requisition change request workflow issues in EBS 12.1.1 or 12.2.2, DBAs and developers can trace execution through this package to determine how approval, acceptance, or cancellation decisions were recorded.