Search Results get_to_status




Overview
Explore in AI Chat

Overview

GMD_SS_ERES_PKG is a small utility package in the Oracle EBS Process Manufacturing (OPM) Quality module, owned by APPS and classified as OTHER (a non-public, internal helper rather than a published PL/SQL API). Its name associates it with the OPM stability study / sampling event feature set (the GMD schema prefix and the ERES reference). The body contains only two procedures, both of which are read-only lookup routines: one resolves a target status description for a workflow-style status transition, and the other resolves a resource description from a sampling event. The package therefore serves as a presentation-support layer, supplying descriptive text to a caller (typically a form or report) that already holds numeric identifiers.

Key Procedures and Functions

  • GET_TO_STATUS — Accepts an input status code and returns the description ("meaning") of the corresponding target status. Internally it maps a source status to a target status: 400 (Requesting Approval) maps to 200, 700 (Requesting Launch) maps to 500, and 1000 (Requesting Cancel) maps to 900. The resulting code is used to fetch the translated meaning from the stability status translation table, filtered by entity type STABILITY and the session language.
  • GET_RESOURCE_DESC — Accepts a sampling event identifier and returns the associated resource description. This is the procedure referenced by the search term "get_resource_desc". It joins the resource master, resource detail, resource instance, and sampling event tables, and enforces activity and soft-delete constraints before returning a single description value.

Both procedures use OUT NOCOPY VARCHAR2 parameters, a convention typical of internal helpers where the returned text is a display label rather than a transactional value.

Tables Accessed

  • GMD_QC_STATUS_TL — the translated status meanings for quality/stability statuses; read by GET_TO_STATUS.
  • GMD_SAMPLING_EVENTS — the driving table for GET_RESOURCE_DESC, supplying the organization code, resource, and instance identifiers for a given sampling event.
  • CR_RSRC_MST — the resource master, providing the resource description text.
  • CR_RSRC_DTL — the resource detail, used to relate resource to organization and to filter out deleted resources.
  • GMP_RESOURCE_INSTANCES — the resource instance, joined to confirm the instance is active (inactive_ind = 0).

All access is read-only; the package performs no inserts, updates, or deletes.

Usage Notes

The package is not referenced by any other documented package, indicating it is invoked directly by a client rather than through a call chain. It is most likely called from OPM stability study or sampling event forms, where a user selects a sampling event and the form displays the corresponding resource description and next status label. Because the procedures are defined in the package body without a listed specification, they should be treated as internal implementation and not as a supported integration API. No error handling or NO_DATA_FOUND protection is present in the documented source, so callers must tolerate a NULL return when the cursor finds no matching row. The package carries a 2003 header and version 115.1, reflecting an older OPM code line that has been carried forward into EBS 12.1.1 and 12.2.2.