Search Results process_delayed_requests

Overview

The QP_DELAYED_REQUESTS_PVT package is a private (PVT) PL/SQL API within the Oracle E-Business Suite Advanced Pricing module (QP schema). It implements the deferred request queue used by Oracle Pricing to decouple the submission of pricing-related work from its actual processing. When pricing events occur — such as list line modifications, qualifier changes, or price list updates — the application records a lightweight request into a queue rather than executing the full business logic inline. The package is responsible for logging those requests, de-duplicating them against existing entries, removing them when no longer valid, and ultimately dispatching them for processing.

The package is declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking session rather than its owner. It is classified as a private API, so Oracle does not guarantee its signature for external consumption, though it remains widely referenced internally. The documented metadata indicates that QP_DELAYED_REQUESTS_PVT is referenced by 33 other packages, confirming its central role in the delayed request infrastructure of Advanced Pricing.

Key Procedures and Functions

The package exposes nine documented procedures and functions:

• LOG_REQUEST — The primary entry point for enqueuing a delayed request. It searches for an existing request using the combined key of entity_code, entity_id, request_type, and request_unique_key1 through request_unique_key5. If a matching request exists, it is updated with the new values; otherwise a new request is inserted into the queue. The procedure accepts a large set of generic parameters (p_param1 through p_param23) that carry request-specific payload data.
• CHECK_FOR_REQUEST — Determines whether a request already exists for a given entity, request type, and unique key combination, allowing callers to avoid redundant queue entries.
• DELETE_REQUEST — Removes a specific request from the delayed request queue.
• CLEAR_REQUEST — Clears or resets a queued request, typically after successful processing or when the request is superseded.
• PROCESS_REQUEST — Processes an individual delayed request, dispatching the associated business logic.
• PROCESS_REQUEST_FOR_ENTITY — Processes all delayed requests associated with a particular entity.
• PROCESS_REQUEST_FOR_REQTYPE — Processes all delayed requests matching a specified request type.
• PROCESS_DELAYED_REQUESTS — The top-level driver that iterates the queue and processes pending delayed requests. This is the procedure most commonly searched for, as it represents the bulk-processing entry point.
• DELETE_REQS_FOR_DELETED_ENTITY — Removes queued requests belonging to an entity that has itself been deleted, preventing orphaned queue entries.

Tables Accessed

The package operates against the pricing list line tables through APPS synonyms. QP_LIST_LINES stores price list line records and is the principal target of the pricing logic triggered by processed requests. PLITBLM is a pricing list line index or API helper table used during line manipulation. Together these tables support the list line maintenance work that deferred requests ultimately drive.

Usage Notes

QP_DELAYED_REQUESTS_PVT is invoked internally by Advanced Pricing forms, concurrent programs, and dependent pricing packages whenever deferred processing is required. PROCESS_DELAYED_REQUESTS is typically called from a concurrent program or scheduled batch that drains the queue. Because the package is classified PVT, customizations should call it with caution; the safest approach is to log requests via LOG_REQUEST and allow the standard processing drivers to execute them. Direct invocation of processing procedures is warranted only when the surrounding transaction context, such as entity locks, has been established.