Search Results qp_oa_delayed_requests_pvt




Overview
Explore in AI Chat

Overview

QP_OA_Delayed_Requests_PVT is a private PL/SQL package in the Oracle E-Business Suite APPS schema that supports the Oracle Advanced Pricing (QP) module's delayed request processing framework. In Oracle EBS 12.1.1 and 12.2.2, Advanced Pricing relies heavily on bulk processing of pricing and qualifier-related operations, where requests originating from Order Management, Order Capture, or other integrated modules must be queued and resolved asynchronously rather than synchronously. This package provides the private execution engine that consumes rows staged in the delayed requests table and drives them through their processing lifecycle.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer. Combined with its "PVT" (private) API classification in the ETRM metadata, this confirms that the package is intended for internal consumption by other Advanced Pricing components rather than direct invocation by external or customer-written code. The single public PL/SQL entry point, Execute, is the workhorse procedure that reads a collection of delayed request rows and processes each one, returning granular error diagnostics to the caller.

Key Procedures and Functions

  • Execute — The only documented procedure in the package. It accepts a table-style input parameter (a collection of delayed request records) and processes that batch. Beyond returning control, it exposes five output parameters that report failure context: an error request type, an error entity identifier, an error entity code, an error type, and the standard return status plus return status text pair. These outputs allow the calling framework to pinpoint exactly which request in the batch failed and why, without aborting the remaining batch. The procedure does not raise exceptions directly for individual row failures; instead it communicates results through the OUT parameters, which is consistent with bulk-processing conventions in Advanced Pricing.

No other procedures or functions are documented in this package. Its scope is deliberately narrow, focused entirely on the execution of delayed request batches.

Tables Accessed

  • QP_FWK_DELAYED_REQUESTS — The primary staging table for delayed request processing. The package reads records from this table (via the input collection) and updates their processing status and error information as each request is handled. This is the central persistence point for the delayed request framework.
  • PLITBLM — A standard Oracle Applications PL/SQL table (index-by table) type used by the framework, referenced through an APPS synonym. It supports the in-memory collection handling that the Execute procedure requires when iterating over batches of delayed requests.

The package does not directly write to pricing or qualifier entity tables within its own scope; downstream processing invoked during request execution is responsible for those updates.

Usage Notes

QP_OA_Delayed_Requests_PVT is not a public API and should not be called from custom code, forms, or concurrent programs. It is invoked internally by the Advanced Pricing delayed request framework, typically from a concurrent program or scheduled worker that stages rows in QP_FWK_DELAYED_REQUESTS and then passes a collection of those rows into Execute. The caller is responsible for committing or rolling back based on the returned status and error outputs.

Because the package is private and version-specific, any custom integration should target the supported public Advanced Pricing APIs rather than this package. The header revision (120.0, dated 2005) indicates the package has remained stable across 12.1.1 and 12.2.2, and it is referenced by zero other documented packages, reinforcing its role as a leaf-level internal executor rather than a reusable library component.