Search Results qa_audit_pkg_w

Overview

QA_AUDIT_PKG_W is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Quality (QA) module. The "_W" suffix indicates that this package is a wrapper or worker companion to the core QA_AUDIT_PKG package. Its primary business function is to support the Quality Audits and quality data collection infrastructure within Oracle Quality, particularly around copying audit question definitions and tables between internal staging structures and persistent application tables. The package is documented as VALID and depends on JTF_VARCHAR2_TABLE_200, a standard EBS collection type used to pass arrays of VARCHAR2 values between PL/SQL layers, and on the base QA_AUDIT_PKG package itself. These dependencies confirm that QA_AUDIT_PKG_W acts as a bridging layer that formats, copies, or serializes audit question data before or after the core package processes it. In practice, such wrapper packages isolate data-transformation logic from business rules logic, allowing Oracle Quality to move audit content across organizational boundaries, interfaces, or staged collection structures without embedding that logic directly in the transactional package.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within QA_AUDIT_PKG_W. Four share the ROSETTA naming convention, which in Oracle EBS typically denotes a generic copy or transformation routine used to shuttle data between two structurally similar containers:

• ROSETTA_TABLE_COPY_IN_P2 — Copies data inward (from an external or staged source into a target structure) as part of a phase-2 processing step.
• ROSETTA_TABLE_COPY_OUT_P2 — Performs the reciprocal outward copy for phase-2 processing.
• ROSETTA_TABLE_COPY_IN_P3 — The phase-3 inward copy routine, typically invoked after earlier phases have prepared or filtered the data.
• ROSETTA_TABLE_COPY_OUT_P3 — The phase-3 outward copy routine.
• COPY_QUESTIONS — A business-level routine that copies audit question records, most likely between audit templates, collections, or staging areas, using the Rosetta copy helpers as its underlying mechanism.

Exact parameter lists are not exposed in the documented metadata; the descriptions above reflect the naming conventions and the package's stated dependencies. The phasing (P2, P3) suggests a multi-stage copy pipeline where each stage handles a distinct slice or transformation of the question data.

Tables Accessed

The documented table reference for this package is PLITBLM (accessed via an APPS synonym). PLITBLM is a standard Oracle Quality table associated with question and collection line definitions. QA_AUDIT_PKG_W reads from and writes to this table to persist or retrieve audit question data during the copy operations. No other base tables are listed in the ETRM dependency metadata, indicating that PLITBLM is the primary persistent store manipulated by the Rosetta copy routines and COPY_QUESTIONS, while the core QA_AUDIT_PKG handles additional audit-specific tables.

Usage Notes

QA_AUDIT_PKG_W is not referenced by any other documented package, so it is invoked as a top-level utility rather than as a shared library. Typical invocation paths include Oracle Quality forms that manage audit templates and question sets, concurrent programs that migrate or replicate audit definitions, and custom extensions that need to copy question data between audit structures. Because it depends on JTF_VARCHAR2_TABLE_200, callers passing scalar collections must use that EBS-standard type. Developers should call the public routines (COPY_QUESTIONS and the Rosetta copy procedures) rather than manipulating PLITBLM directly, since the package encapsulates the phased copy logic. As with all APPS-owned packages, any modification should be avoided in favor of supported APIs, and the package's VALID status in both 12.1.1 and 12.2.2 confirms consistent availability across these releases.