Search Results get_orgn_code

Overview

GMD_QC_LABELS_UTIL is the utility-layer PL/SQL package body owned by APPS in Oracle EBS Process Manufacturing (OPM) Quality. Its stated purpose, taken directly from the package header comment, is to serve as the utility layer for generating QC labels. The package encapsulates the data-gathering and formatting logic required to produce sample and quality control label output for laboratory and stability operations, isolating that logic from the concurrent program or calling layer that submits the request.

The package carries a documented revision history reflecting several generations of OPM development. It was originally written by H Verdding of OPM Development (EMEA), later modified for stability study support, and subsequently reworked for OPM Convergence. The convergence changes are significant: fields were redirected to their converged counterparts, most notably the sample generation parameter p_orgn_code was replaced by p_organization_id, and cursors were added to translate numeric identifiers into their display values. A later fix (Bug# 4612611, November 2005) removed the plant code from the output and added item, revision, and storage organization attributes. The current header revision is 120.5, dated 27 February 2006.

Key Procedures and Functions

The documented interface exposes a single public procedure, SAMPLE_GEN_SRS. It is structured as a standard concurrent-program entry point, returning errbuf and retcode OUT parameters alongside its business inputs. The business inputs select and constrain the samples to be labelled: an organization identifier, a from/to sample number range, an output delimiter, and stability-study selectors for variant and time point. The delimiter defaults to a comma, and the range and identifier parameters are optional, allowing the procedure to be called for a full organization or for a narrow slice of samples.

Internally the procedure declares a substantial set of local variables that reveal the label content it assembles: sample identifier, priority, retain-as disposition, source, batch number, form number and version, operation number and version, recipe number and version, routing number and version, customer name, operating unit, ship-to, order type, order number, order line, and supplier code. This confirms that the procedure builds a denormalized, label-ready projection of sample data rather than returning normalized rows.

Tables Accessed

The package reads across the OPM quality, stability, and inventory schemas. Sample and specification data come from GMD_SAMPLES, GMD_SPECIFICATIONS, and GMD_SPECIFICATIONS_B. Stability study attributes are drawn from GMD_STABILITY_STUDIES, GMD_SS_VARIANTS, and GMD_SS_TIME_POINTS. Resource and routing context comes from GMP_RESOURCE_INSTANCES. Organization and operating-unit display values are resolved through HR_ALL_ORGANIZATION_UNITS_TL and HR_ORGANIZATION_INFORMATION. Customer and ship-to details for labels are obtained from HZ_CUST_ACCOUNTS_ALL, HZ_CUST_SITE_USES_ALL, and HZ_PARTIES. Inventory and item attributes are sourced from MTL_SYSTEM_ITEMS_B, MTL_ITEM_LOCATIONS, and MTL_PARAMETERS. The use of the HZ and HR tables reflects the convergence changes described in the header history, translating legacy OPM code values into their converged display equivalents.

Usage Notes

SAMPLE_GEN_SRS is invoked as a concurrent program entry point, which accounts for its SRS-style errbuf/retcode signature and its use of optional parameters suitable for concurrent program parameter definitions. It is typically registered against a QC label printing concurrent program and submitted from the OPM Quality responsibility or from a label-generation form. Because the parameter set references p_organization_id rather than the legacy p_orgn_code, callers written against pre-convergence interfaces must be updated accordingly; the older plant-code parameter is no longer part of the signature. The package is not documented as being referenced by any other package, so custom code should call it directly rather than relying on it as a shared utility for other modules. No public functions are exposed beyond SAMPLE_GEN_SRS, and the remainder of the body consists of private helpers and cursors supporting that single entry point.