Search Results oe_process_requisition_pvt




Overview
Explore in AI Chat

Overview

OE_PROCESS_REQUISITION_PVT is a private PL/SQL package in the APPS schema that supports the processing of internal requisitions within Oracle Order Management. In Oracle EBS 12.1.1 and 12.2.2, an internal requisition represents a request from one internal organization to another for goods, and such requisitions flow into Order Management as sales order demand. This package provides the internal processing logic that converts an eligible requisition into or synchronizes it with an order, and prepares associated workflow notifications. It is classified as a PVT package, indicating it is an internal (private) API intended for use by other Oracle EBS application code rather than as a public, supported integration interface.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within this package:

  • SET_ORG_CONTEXT — Establishes the organizational context required before subsequent processing executes reliably. It ensures the correct operating unit or inventory organization context is set for the session so that internal requisition and order data are read and written against the right organization.
  • UPDATE_INTERNAL_REQUISITION — Performs the core update logic on internal requisition records, reconciling requisition data with its corresponding order information and reflecting the appropriate status or linkage.
  • PREPARE_NOTIFICATION — Builds and prepares the notification content used to communicate the outcome of requisition processing to the relevant users, working in conjunction with Oracle Workflow.

The metadata does not document parameter lists; parameters should not be assumed and the package is not intended for direct invocation.

Tables Accessed

The package reads from and writes to the following tables (referenced through APPS synonyms):

Usage Notes

Because OE_PROCESS_REQUISITION_PVT is a private package, it is not a supported public API and should not be called directly by custom code. It is referenced by the OE_DELAYED_REQUISITION_UTIL package, and it references/ is referenced by itself internally. It is typically invoked indirectly through internal requisition processing flows driven by Order Management and Oracle Workflow, such as processing delayed requests and generating notifications. Customizations should rely on the supported public APIs (for example, Order Management and Purchasing requisition APIs) rather than this internal package. The package status is VALID, and its dependency on STANDARD and SYS confirms standard PL/SQL library usage.