Search Results set_results_url

Overview

QA_RESULTS_WF_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. In the context of Oracle EBS 12.1.1 and 12.2.2, it serves as a workflow integration utility for the Quality Management (QA) module, specifically supporting the processing and notification of inspection results. The package bridges quality results data captured against inspection plans and their associated collection actions with the Oracle Workflow engine, allowing result information to be routed, surfaced, and acted upon through workflow-driven business processes. The object is classified as OTHER in the ETRM 12.2.2 metadata, indicating it is an internal supporting package rather than a formally published public API. It carries a VALID status and depends on the SYS STANDARD package, which is a normal base dependency for compiled PL/SQL units. The package is documented as being referenced by no other packages, confirming its role as a leaf-level consumer that is invoked directly rather than reused as a shared library.

Key Procedures and Functions

The documented package exposes two program units, both treated here by name and purpose only:

• PROCESS_UPDATES — Handles the processing of updates related to quality results. Its purpose is to evaluate result-related changes and drive the corresponding workflow actions, such as updating workflow attributes or advancing workflow activity status when inspection results change.
• SET_RESULTS_URL — Constructs and assigns the URL that points to the quality results view. This URL is typically embedded in workflow notification messages so that recipients can navigate directly from a Workflow notification to the relevant results in the QA application forms.

These two units together reflect the package's dual responsibility: applying result-driven workflow state changes and supplying navigable result links to workflow notifications.

Tables Accessed

The package references the following tables through APPS synonyms:

• QA_RESULTS — The central results table for the QA module. The package reads and writes result records to determine what has changed and to drive workflow processing.
• QA_PLANS — Stores inspection plan definitions. The package uses plan data to establish context for results, including plan identification associated with the affected results.
• QA_PLAN_CHAR_ACTION_OUTPUTS — Holds the outputs of collection plan characteristic actions. This table supports the mapping between plan-level actions and their generated outputs, informing how results updates should be processed.
• PLITBLM — The standard Oracle EBS PL/SQL index-by table used as a system-level object for temporary storage of identifier or varchar2 lists. Its presence indicates the package builds in-memory collections for set-based processing.

Usage Notes

QA_RESULTS_WF_PKG is typically invoked indirectly by the Quality Management application when inspection or collection results are generated, updated, or completed. Its functions are most commonly triggered in the context of workflow-enabled collection plan actions and result notifications. Because the package is not a published API and is referenced by no other packages, custom development should avoid calling it directly wherever a supported API or workflow event exists. Where integration requires programmatic invocation—such as in extensions or custom result-processing routines—developers should expect the package to be called during result submission or approval events, with SET_RESULTS_URL supplying notification navigation links and PROCESS_UPDATES applying the associated workflow state transitions.