Search Results ncm_approve




Overview
Explore in AI Chat

Overview

QA_ERES_DEFER is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports deferred electronic signature (eSig / ERES) post-processing within the Quality Management service family. In regulated environments, Oracle EBS requires that certain approval actions be captured under 21 CFR Part 11 compliant electronic signature controls. Rather than updating the underlying business record at the moment the signature is applied, the application defers the status update and records the intent through the EDR (eSignature Deferred Response) framework. QA_ERES_DEFER provides the Post Operation APIs that execute after the eSignature has been captured and validated, applying the resulting approval status to the relevant object.

The package header identifies it as the "Post Operation APIs used for eSig Deferred Approval," and its procedures are invoked after the signature transaction completes in order to commit the corresponding status change. The package addresses two functional areas: Quality specifications and Nonconformance/Corrective Action (NCM, Disposition, and CAR) records. The R12 ERES Support in Service Family enhancement (Bug 4345768) extended the package to cover QA Results collections and occurrences.

Key Procedures and Functions

  • SPEC_STATUS_UPDATE — Post Operation API that updates the status of a specification following deferred eSignature approval.
  • NCM_APPROVE — Updates the approval status of a logged Nonconformance (NCM).
  • NCM_DETAIL_APPROVE — Updates the approval status of an NCM detail record.
  • DISP_APPROVE — Updates the approval status of a logged Disposition.
  • DISP_DETAIL_APPROVE — Updates the approval status of a Disposition detail record.
  • CAR_REVIEW_APPROVE — Updates the approval status of a Corrective Action Request (CAR) review.
  • CAR_IMPL_APPROVE — Updates the approval status of a CAR implementation.
  • QA_OCCURRENCE_APPROVE — Added for R12 ERES support; updates the approval status of a QA Results occurrence.
  • QA_COLLECTION_APPROVE — Added for R12 ERES support; updates the approval status of a QA Results collection.

The header excerpt also lists a tenth procedure, whose full signature is truncated in the documentation. The nine procedures above are those fully identified in the ETRM metadata.

Tables Accessed

Two tables are documented as referenced through APPS synonyms:

  • EDR_PSIG_DOCUMENTS — The eSignature deferred-response document table, which stores the electronic signature records that drive deferred approval processing. QA_ERES_DEFER reads this table to determine which signature event is being finalized and to associate the signed action with the target business object.
  • QA_RESULTS — The Quality Results table, updated by QA_OCCURRENCE_APPROVE and QA_COLLECTION_APPROVE to reflect the deferred approval status of QA results data.

Usage Notes

QA_ERES_DEFER is classified as an OTHER API rather than a public, externally supported interface. It is not intended for direct invocation by custom code. Instead, the package is called internally by the eSignature deferred-approval framework as a post-operation step: the user applies an electronic signature to a Quality record, the signature is captured and stored, and the framework then invokes the appropriate QA_ERES_DEFER procedure to apply the resulting status change to the specification, NCM, disposition, CAR, or QA results record.

The procedures are therefore triggered indirectly through Quality Management forms and related concurrent processing that participate in the ERES deferred-signature flow. Because the package is referenced by zero other packages per the documented metadata, it functions as a terminal action layer in the deferred approval chain rather than as a shared utility. Customizations that require equivalent behavior should integrate through the supported eSignature framework rather than calling these procedures directly, since the internal contract may change between releases.