Search Results get_po_line_number
Overview
GMD_QC_ERES_UTILS is a group-layer PL/SQL utility package owned by APPS within the Oracle E-Business Suite Process Manufacturing (OPM) Quality Management module. Its primary purpose is to support electronic records and electronic signatures (ERES) compliance for quality results entities, particularly specifications, specification versions, and their associated status transitions. The package provides the procedural plumbing required to enforce 21 CFR Part 11-style electronic signature rules, validate specification state changes, and resolve descriptive attributes (names, codes, descriptions) from primary key identifiers stored in the underlying Quality tables.
The package header comment identifies it as containing "group layer APIs for Results Entity," and its original authorship traces to Chetan Nagar in August 2002, with later additions by RLNAGARA in November 2005 covering three helper procedures. The package carries the standard Oracle copyright notice and was last modified under patchset 120.4. In EBS 12.1.1 and 12.2.2 the package remains classified as OTHER under the ETRM API registry, and it is referenced by zero other packages, indicating it is a terminal utility layer consumed directly by forms, workflows, or custom extensions rather than a shared API hub.
Key Procedures and Functions
The documented interface exposes 42 procedures and functions. The most prominent include:
- SET_SPEC_STATUS — transitions a specification between defined lifecycle statuses.
- SET_SPEC_VR_STATUS — applies a status change to a specific specification version identified by entity type.
- UPDATE_VR_STATUS — internal status update routine for version records.
- CHEK_SPEC_VALIDITY_ERES — validation function that determines whether a specification is eligible for a target status when ERES rules apply.
- ESIG_REQUIRED — determines whether an electronic signature is mandated for a given event, event key, and target status.
- GET_ORGN_NAME / GET_ORG_NAME — resolve organization codes to descriptive names.
- GET_USER_NAME — resolves an FND_USER identifier to a display name for signature and audit rendering.
- GET_TEST_METHOD_CODE / GET_TEST_METHOD_DESC — return the code and description of a quality test method from its ID.
- GET_CUST_NAME / GET_SUPP_CODE / GET_SUPP_NAME / GET_SUPP_SITE_NAME — resolve customer and supplier identifiers to their descriptive attributes.
- GET_SHIP_TO_SITE_NAME — returns the ship-to site description for a given identifier.
- GET_ORDER_NUMBER / GET_ORDER_TYPE / GET_ORDER_LINE — extract sales order context used in quality result records.
- GET_PO_NUMBER / GET_PO_LINE_NUMBER — return purchasing document context.
- GET_YES_NO, GET_ITEM_UOM_CALC, GET_DECIMAL_VALUE — the three helper procedures added in 2005 for lookups and numeric formatting.
Tables Accessed
The package operates on OPM Quality base tables accessed through APPS synonyms. Specification and version records are read and updated via GMD_SPECIFICATIONS, GMD_SPECIFICATIONS_B, GMD_CUSTOMER_SPEC_VRS, GMD_INVENTORY_SPEC_VRS, GMD_MONITORING_SPEC_VRS, GMD_STABILITY_SPEC_VRS, and GMD_STABILITY_STUDIES_B. Change and disposition workflow data resides in GMD_CHANGE_DISPOSITION and GMD_COMPOSITE_SPEC_DISP. Test definitions come from GMD_QC_TESTS, GMD_TEST_METHODS, and GMD_SPEC_TESTS, while overall QC state is tracked in GMD_QC_STATUS. User identity for signature capture is pulled from FND_USER.
Usage Notes
Because the package is referenced by no other package, it is invoked directly from Quality Management forms, ERES signature dialogs, and custom extensions rather than through a shared API stack. The status-transition procedures are typically called when a user signs a specification or version change, with ESIG_REQUIRED and CHEK_SPEC_VALIDITY_ERES evaluated first to determine whether a signature challenge is required. The GET_* functions are convenience resolvers used when constructing audit trail displays, validation messages, or report output, allowing forms to render descriptions from stored IDs without embedding direct SQL against the GMD_* tables. When extending the package, developers should preserve the ERES validation order — validity check, signature requirement check, then status update — to maintain regulatory audit integrity.