Search Results delete_rslt_and_spec_rslt_rows

Overview

GMD_RESULTS_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Process Manufacturing (OPM) Quality module family and is classified as a GRP (group) package, indicating that it consolidates shared business logic used by multiple public APIs and concurrent programs rather than exposing a formal public interface of its own. Its principal business function is the creation, maintenance, and evaluation of quality results and specification results. The package determines whether a test result falls within specification, associates test results with the correct specification versions, manages composite results derived from multiple samples, and produces specification matching data used throughout the quality lifecycle.

The object is reported as VALID in the ETRM metadata, confirming it is a compiled, active component of the application. It sits below the public API layer, referenced extensively by GMD_RESULTS_PUB, GMD_QUALITY_GRP, GMD_SAMPLES_PUB, and other packages, and it in turn depends on specification display views, sample tables, and quality test definition tables.

Key Procedures and Functions

The package documents 38 procedures and functions. The most significant groups are summarized below; parameter lists are deliberately omitted.

• Result row management: CREATE_RSLT_AND_SPEC_RSLT_ROWS and DELETE_RSLT_AND_SPEC_RSLT_ROWS create and remove the paired result and specification-result records that represent a test performed against a defined specification.
• Specification evaluation: COMPARE_RSLT_AND_SPEC, COMPARE_CMPST_RSLT_AND_SPEC, and RSLT_IS_IN_SPEC evaluate a numeric or attribute result against the applicable specification limits and return the in-specification determination. MAKE_TARGET_SPEC_THE_BASE_SPEC and USE_TARGET_SPEC_FOR_CMPST_RSLT control which specification version is treated as the comparison baseline, including for composite results.
• Test assignment to samples: ADD_TESTS_TO_SAMPLE, ADD_TEST_TO_SAMPLES, and ALL_REF_TESTS_EXIST_IN_SAMPLE attach specified quality tests to samples and verify that all referenced tests are present before processing proceeds.
• Specification version lookup: GET_CURRENT_EVENT_SPEC_DISP_ID resolves the currently effective event specification, while GET_RSLT_AND_SPEC_RSLT retrieves existing result and specification-result combinations.
• Composite handling: COMPOSITE_EXIST, SE_RECOMPOSITE_REQUIRED, RESULT_RECOMPOSITE_REQUIRED, CREATE_COMPOSITE_ROWS, and POPULATE_RESULT_DATA_POINTS support the creation of composite samples and the recalculation of composite results when underlying member results change.
• Supporting utilities: GET_SAMPLE_IDS_FOR_SE, NEXT_SEQ_IN_RESULT, and QC_MEAN provide sample retrieval, sequence numbering within a result, and statistical mean calculation respectively.

Tables Accessed

The package reads and writes through APPS synonyms. Core quality definition and transactional tables include GMD_QC_TESTS_B and GMD_QC_TESTS, GMD_QC_TEST_VALUES, GMD_SAMPLES, GMD_SPEC_TESTS_B, and the specification display views GMD_EVENT_SPEC_DISP and GMD_SAMPLE_SPEC_DISP. Composite processing involves GMD_COMPOSITE_RESULTS, GMD_COMPOSITE_RESULT_ASSOC, and GMD_COMPOSITE_SPEC_DISP. Specification version resolution draws on GMD_CUSTOMER_SPEC_VRS, GMD_INVENTORY_SPEC_VRS, and GMD_MONITORING_SPEC_VRS. Resource references CR_RSRC_DTL and CR_RSRC_MST are also accessed. These objects supply the test definitions, limits, sample context, and composite membership data needed to create and evaluate results.

Usage Notes

GMD_RESULTS_GRP is an internal group package and is not intended for direct invocation by end users or custom integrations. It is called by the public APIs GMD_RESULTS_PUB and GMD_SAMPLES_PUB, and by group packages including GMD_QUALITY_GRP, GMD_SPEC_MATCH_GRP, GMD_RESULT_TRANSFER_GRP, GMD_COA_DATA_OM_NEW, and GMD_QMDSC. In practice its logic executes whenever a user enters or modifies quality results in the OPM Quality results forms, runs specification matching, generates certificates of analysis, or executes composite result recalculation. Custom extensions should invoke the documented public packages rather than calling GMD_RESULTS_GRP directly, since its procedures are subject to change between patch levels and are unsupported as a public interface.