Search Results post_result_with_no_validation

Overview

QA_MQA_RESULTS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms part of the Oracle Quality (QA) module's server-side infrastructure and is classified under the ETRM as an OTHER API, meaning it is an internal technical utility rather than a formally published public API. Its principal business function is to manage the lifecycle of quality results — the individual measurement, test, or collection outcomes captured against a quality collection plan and associated with a quality result record.

The package centralises the logic for creating, persisting, and removing quality results so that multiple callers across the Quality application share a single controlled code path. In the ETRM metadata the package is recorded as VALID and is documented with six callable subprograms, together with dependencies on SYS.STANDARD and references to the PLITBLM table via APPS synonyms.

Key Procedures and Functions

• POST_RESULT — The primary entry point for writing a quality result. It performs the validation and processing required before a result is committed to the quality results schema.
• POST_RESULT_WITH_NO_VALIDATION — A variant of POST_RESULT that bypasses the standard validation checks. It is intended for internal callers that have already validated the data, such as bulk loads or upstream processing that has applied its own rules.
• DELETE_RESULT — Removes a single quality result, applying the deletion semantics appropriate to an individual result record.
• DELETE_RESULTS — The set-based counterpart to DELETE_RESULT, removing multiple results in a single operation and typically used when a collection, plan, or parent entity is being cleared.
• COMMIT_RESULTS — Issues the database commit for results processed within the package's session, allowing callers to control when the work becomes durable.

The ETRM documentation records six subprograms in total; the five named above are the documented procedures and functions exposed by this package. Parameter lists are not published in the ETRM extract and should not be assumed.

Tables Accessed

The documented table reference for QA_MQA_RESULTS is PLITBLM, accessed through an APPS synonym. PLITBLM is a standard Oracle EBS PL/SQL-indexed global temporary table used for bulk result handling. The package is therefore designed to stage and manipulate sets of result rows in memory before they are posted to the permanent quality tables. The dependency metadata also records references to SYS.STANDARD, reflecting the package's use of standard PL/SQL constructs. The metadata does not enumerate the permanent base tables (for example, the QA results and result-value tables) that POST_RESULT ultimately populates.

Usage Notes

QA_MQA_RESULTS is an internal package and is not a published integration point. It is referenced by one other package in the EBS code base, QA_PARENT_CHILD_PKG, which indicates that parent/child and hierarchical result processing in the Quality module relies on it. Callers are expected to be other Quality application packages, Oracle Quality forms, or concurrent programs that create and delete results on behalf of the user.

Custom code should treat this package as subject to change between releases and should favour documented public Quality APIs. Where it is invoked, the typical pattern is to stage result data, call POST_RESULT or POST_RESULT_WITH_NO_VALIDATION for each result, and then invoke COMMIT_RESULTS to make the changes permanent, with DELETE_RESULT and DELETE_RESULTS used to reverse or clear results. This object is present in both Oracle EBS 12.1.1 and 12.2.2, where it retains the APPS owner and VALID status.