Search Results qa_skiplot_utility




Overview
Explore in AI Chat

Overview

QA_SKIPLOT_UTILITY is the core PL/SQL package body in the Oracle EBS Quality Management (QA) module that implements the skip lot inspection business logic. Skip lot processing allows an organization to reduce the frequency of incoming inspection for a supplier, item, or supplier-item combination once a defined number of consecutive lots have been accepted. Rather than inspecting every receipt, the system inspects only a calculated subset of lots, skipping the remainder. This package encapsulates the rules, state tracking, and workflow integration that drive that behavior across purchasing and receiving transactions.

The package is owned by the APPS schema and holds a VALID status in both Oracle EBS 12.1.1 and 12.2.2. Its API classification is OTHER, meaning it is an internal utility rather than a formal public API, though it is referenced by six other packages, indicating it is called from dependent QA processes such as QA_INSPECTION_PKG and QA_INSPECTION_WF rather than being invoked directly by end users.

Key Procedures and Functions

The package exposes 28 documented procedures and functions that fall into several functional groups.

Tables Accessed

The package reads and writes the core skip lot and QA configuration tables through APPS synonyms. QA_SKIPLOT_ASSOCIATION links skip lot plans to the entities they govern. QA_SKIPLOT_PROCESSES, QA_SKIPLOT_PROCESS_PLANS, and QA_SKIPLOT_PROCESS_PLAN_RULES define processes, their plans, and governing rules. QA_SKIPLOT_PLAN_STATES and QA_SKIPLOT_STATE_HISTORY store current and historical plan states. QA_SKIPLOT_RCV_RESULTS captures receiving inspection results, while QA_SKIPLOT_LOG and the QA_SKIPLOT_LOG_ID_S and QA_SKIPLOT_LOT_ID_S sequences support logging and lot identification. QA_PLANS and QA_CHARS provide plan and characteristic definitions, and MTL_PARAMETERS supplies inventory parameters. The package also references DUAL and the FND_API, FND_GLOBAL, FND_MESSAGE, and APP_EXCEPTION utilities for error handling and messaging.

Usage Notes

QA_SKIPLOT_UTILITY is typically invoked indirectly during receiving and inspection transactions rather than called directly. It is referenced by QA_INSPECTION_PKG and QA_INSPECTION_WF, meaning the inspection and workflow processes drive its execution when a receipt is evaluated against skip lot rules. Because it is not referenced by any database object itself, it acts as a supporting layer consumed by dependent QA packages, forms, and concurrent processes. Customizations should not modify this package directly; extensions should follow Oracle's recommended practice of wrapping or calling the supported dependent packages.