Search Results qa_inspection_wf




Overview
Explore in AI Chat

Overview

The APPS.QA_INSPECTION_WF package is a Quality Management workflow integration component within Oracle E-Business Suite. Its primary business function is to raise Oracle Workflow events that drive the sampling and inspection lifecycle associated with quality inspections. Specifically, the package serves as the bridge between the Quality application's sampling plan engine and the Oracle Workflow notification framework, enabling the system to communicate inspection status changes to interested parties through the standard EBS event and notification infrastructure.

In the Quality module, sampling plans determine how frequently incoming lots or items are subjected to full or reduced inspection. When the sampling engine determines that an inspection frequency must change, or that a lot qualifies for reduced inspection, a corresponding workflow event must be propagated so that downstream processes, notifications, and approval routing behave correctly. The QA_INSPECTION_WF package encapsulates this event-raising logic. It is registered in the APPS schema with a VALID status and is classified as an OTHER API, meaning it is not one of the primary open interfaces but is an internal integration utility exposed within the schema.

Key Procedures and Functions

The package exposes two documented procedures, both concerned with raising workflow events:

  • RAISE_FREQUENCY_CHANGE_EVENT — This procedure raises an Oracle Workflow event that signals a change to an inspection frequency determined by the sampling plan. It is invoked when the Quality application recalculates sampling frequency and needs to inform the workflow engine so that subsequent processing or notification can occur.
  • RAISE_REDUCED_INSPECTION_EVENT — This procedure raises a workflow event indicating that a lot or item has qualified for reduced inspection. Reduced inspection is a normal outcome of a favorable sampling history, and this procedure communicates that determination to the workflow layer.

Both procedures rely on the standard Workflow event API (WF_EVENT) to construct and dispatch events. The procedure signatures are not documented in the available metadata, so parameter lists are intentionally omitted here.

Tables Accessed

The package references the following tables via APPS synonyms:

  • QA_SS_NOTIFY_WORKFLOW_S — A Quality sampling-plan related table that stores notification or workflow routing information. The package reads from this table to determine the recipients or context for the workflow events it raises.
  • WF_PARAMETER_LIST_T — The standard Oracle Workflow parameter list table type used to build the event payload that is passed to the Workflow engine.
  • DUAL — Used for simple single-row SQL evaluations.

Usage Notes

QA_INSPECTION_WF is an internal integration package rather than a user-facing API. It is typically invoked indirectly by the Quality sampling and skip-lot processing logic whenever an inspection frequency change or a reduced inspection determination occurs. The documented dependency list confirms this: the package is referenced by QA_SAMPLING_PKG and QA_SKIPLOT_UTILITY, both of which drive sampling decisions and therefore need to raise the corresponding workflow events.

Because it participates in the Workflow event model, the package depends on the Workflow schema objects (including STANDARD and the workflow event infrastructure). Customizations should not call these procedures directly unless replicating the exact event payload expected by the Workflow subscription defined for the Quality events. Any such call must preserve the parameter list and event name constants used by the standard subscriptions; otherwise, downstream notifications and processing will fail silently or route incorrectly.