Search Results oeheader_to_mtlsales




Overview
Explore in AI Chat

Overview

QA_RESULTS_INTERFACE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the import of quality results into Oracle Quality from external source systems. Its primary role is to broker the interface between incoming inspection, receiving, purchasing, and order-management data and the Quality module's collection plan and results infrastructure. In the 12.1.1 and 12.2.2 code lines the package is classified as an "OTHER" API, meaning it is not a released public interface but is nevertheless invoked by Oracle's own import programs and integration flows. The package assembles dynamic SQL for various quality collection sources — supplier shipments, outside processing, order management, and fixed assets — and orchestrates row-level import processing through a start/end bracketing mechanism. The end_import_row element referenced in the search is a companion to start_import_row and signals the completion of a single imported quality results row.

Key Procedures and Functions

  • START_IMPORT_ROW — Opens an import row for processing, accepting a process status, operating unit (org_id), and plan identifier, and returning script buffers used to accumulate the row's SQL.
  • END_IMPORT_ROW — Closes the current import row, taking the script and tail script buffers plus a no_error flag that indicates whether the row completed without error.
  • ADD_ELEMENT_VALUE — Adds an individual collection element value to the row being built, returning a numeric status.
  • BUILD_OSP_VQR_SQL — Builds the validation query SQL for outside processing supplier quality results based on plan, item, PO, vendor, and related attributes.
  • BUILD_SHIPMENT_VQR_SQL — Builds the validation query SQL for shipment-based quality results, filtering on supplier, PO line, shipment, ship-to, and UOM attributes.
  • BUILD_OM_VQR_SQL — Constructs the validation query SQL for order management quality results.
  • BUILD_ASSET_VQR_SQL — Constructs the validation query SQL for asset-related quality results.
  • BUILD_VQR_SQL — Generic dispatcher/builder for validation query SQL across supported source types.
  • GET_PLAN_VQR_SQL — Retrieves the validation query SQL associated with a given collection plan.
  • COMMIT_ROWS — Commits successfully processed import rows.
  • ROLLBACK_ROWS — Rolls back the current import batch on failure.
  • OEHEADER_TO_MTLSALES — Maps order management header context to material sales context during import.

Tables Accessed

Through APPS synonyms the package reads and writes quality configuration and transactional tables. QA_PLANS, QA_CHARS, and QA_PLAN_CHARS supply collection plan definitions, elements (characteristics), and plan-element associations. QA_TXN_COLLECTION_TRIGGERS governs which transactions trigger quality collection. QA_RESULTS-related staging and the PLITBLM table hold imported row data and script buffers during processing. OE_ORDER_HEADERS_ALL, OE_TRANSACTION_TYPES_TL, and MTL_SALES_ORDERS provide order-management context, while MTL_PARAMETERS supplies operating unit defaults. FND_LANGUAGES supports translated lookups for order transaction types.

Usage Notes

The package is normally invoked by Oracle's Quality results import concurrent programs and by the Oracle Quality forms during collection import. Because it is an "OTHER"-classified API, custom integrations should treat it as an internal interface subject to change across patch levels. It is referenced by three other packages within the Quality application family. Developers embedding the import logic in custom code must call START_IMPORT_ROW and END_IMPORT_ROW as a matched pair, accumulate element values with ADD_ELEMENT_VALUE, and finalize the batch with COMMIT_ROWS or ROLLBACK_ROWS to preserve transactional integrity.