Search Results qpr_pn_response_approvals_s

Overview

APPS.QPR_DEAL_APPROVALS_PVT is a private PL/SQL package body that implements the internal approval-handling logic for Oracle E-Business Suite's Quoting and Proposal Management (QPR) module, part of the Advanced Pricing and Trade Management/ETRM family of applications. Its responsibility is to manage the lifecycle of deal and quote approvals, specifically the approval records that represent responses to approval requests, compliance verification, user approval actions, and the synchronization of approval states between the transactional tables and the Oracle Approvals Management (AME) engine. As a "PVT" (private) classified API, the package is not intended as a public integration point; it is invoked by public wrapper packages and by workflow/notification infrastructure. The package body is documented as VALID and depends on AME_API2, AME_UTIL, FND_API, FND_GLOBAL, FND_USER, QPR_WKFL_UTIL, and the QPR approval tables, confirming that it bridges QPR transaction data with the AME approval framework and the Oracle Workflow notification subsystem.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents seven procedures/functions whose names correspond to distinct phases of the approval cycle:

• INIT_APPROVALS — Initializes approval records for a quotation or deal when the approval process begins, establishing the baseline rows that subsequent AME and workflow processing will update.
• CHECK_COMPLIANCE — Evaluates whether the transaction meets the configured approval/compliance rules prior to or during approval routing.
• PROCESS_USER_ACTION — Handles the outcome of an approver's response (for example, approve or reject) and applies the resulting state change to the approval records and transaction.
• SYNCH_APPROVALS — Reconciles QPR approval records with the AME approval status, keeping the application tables consistent with the external approval engine.
• PROCESS_STUCK_NOTIFICATIONS — Identifies and processes approval workflow notifications that have stalled, supporting recovery or escalation of incomplete approvals.
• CLEAR_ACTION_HISTORY — Removes or resets historical approval action data, supporting cleanup and re-approval scenarios.

A seventh documented entry, QPR_DEAL_APPROVALS_PVT (the package itself), appears in the dependency listing as a self-reference. No parameter lists are asserted here, consistent with the available metadata.

Tables Accessed

The package reads and writes the QPR approval tables through APPS synonyms:

• QPR_PN_RESPONSE_HDRS — Header-level response records for quote/deal approvals.
• QPR_PN_RESPONSE_APPROVALS — The approval action lines associated with each response header.
• QPR_PN_RESPONSE_APPROVALS_S — The corresponding sequence/primary-key generation source, which explains why a search for this object routes to the package that maintains those records.
• FND_USER and FND_APPLICATION — Resolve the acting approver and the owning application context.
• DUAL and PLITBLM — Standard single-row selection and PL/SQL index-by table support used for internal processing.

Usage Notes

Because this is a private package body, it is invoked indirectly: through the QPR approval public APIs, from Oracle Workflow function activity definitions tied to approval notifications, and from the AME integration layer. The SYSTEM-dependent references to AME_API2 and AME_UTIL confirm that the package participates in the AME-driven approval engine rather than implementing approval logic independently. Two other database packages reference it, and it is not referenced by forms directly, reinforcing that its consumers are other PL/SQL units and workflow. The presence of PROCESS_STUCK_NOTIFICATIONS suggests it may also be exercised by a concurrent program or scheduled process that sweeps stalled approvals. Customizations should call the supported public wrapper rather than QPR_DEAL_APPROVALS_PVT directly, since its signature and behavior may change between 12.1.1 and 12.2.2 patch levels.