Search Results create_samples

Overview

The APPS.GMD_AUTO_SAMPLE_PKG package is a Process Manufacturing (OPM) Quality Management utility in Oracle E-Business Suite 12.1.1 and 12.2.2. It supports automatic sample creation associated with sampling events, so that quality samples are generated programmatically rather than through manual entry. The package is defined with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking user rather than the definer — appropriate for an API invoked from within the APPS schema context and from other application code. The package is classified as OTHER in ETRM metadata, indicating it is a supporting/utility API rather than a public documented business interface.

Key Procedures and Functions

The package exposes one documented program unit: create_samples. Based on the header signature, it accepts a sampling event row (x_sampling_event, typed as GMD_SAMPLING_EVENTS%ROWTYPE), a specification identifier (L_spec_id), a specification version identifier (L_spec_vr_id), and returns a status through an OUT NOCOPY varchar2 parameter (X_return_status). Its purpose is to create the sample records required for a given sampling event, resolving the applicable specification and specification version to determine which samples, dispositions, and monitoring records must be produced. The X_return_status output follows the standard OPM/APPS API convention for communicating success or failure to the caller. No additional functions are documented; callers should treat create_samples as the sole supported entry point.

Tables Accessed

The package reads and writes quality and specification data through APPS synonyms. Core transactional targets include GMD_SAMPLING_EVENTS, GMD_SAMPLES, GMD_SAMPLE_SPEC_DISP, and GMD_EVENT_SPEC_DISP, which record the events, generated samples, and their spec dispositions. Specification definition and version data come from GMD_SPECIFICATIONS_B and the version tables GMD_CUSTOMER_SPEC_VRS, GMD_INVENTORY_SPEC_VRS, GMD_MONITORING_SPEC_VRS, GMD_STABILITY_SPEC_VRS, GMD_SUPPLIER_SPEC_VRS, and GMD_WIP_SPEC_VRS. Sampling plan configuration is read from GMD_SAMPLING_PLANS_B, status descriptions from GMD_QC_STATUS_TL, and item context from MTL_SYSTEM_ITEMS_KFV. Together these tables provide the sampling rules, specification linkage, item identity, and QC status needed to generate samples correctly.

Usage Notes

GMD_AUTO_SAMPLE_PKG is typically invoked when a sampling event is recorded — whether through OPM Quality forms, a concurrent program, or custom PL/SQL. The caller populates a GMD_SAMPLING_EVENTS%ROWTYPE record along with the target specification and version IDs, then calls create_samples and inspects X_return_status before committing. Errors should be handled by checking the return status and rolling back on failure. Because the package is referenced by one other package, it may also be called indirectly by dependent OPM logic, so customizations should preserve its documented signature. As with all OTHER-classified OPM APIs, it is not part of Oracle's guaranteed public interface and should be used with appropriate regression testing during upgrades between 12.1.1 and 12.2.2.