Search Results gmd_status_pub




Overview
Explore in AI Chat

Overview

GMD_STATUS_PUB is a public PL/SQL API in the Oracle E-Business Suite Process Manufacturing (GMD) product family. Its purpose is to govern the lifecycle status of core process manufacturing entities — formulas, recipes, operations, routings, and recipe validity rules — by providing a validated, programmatic mechanism to transition an entity from one status to another. Rather than allowing direct updates to status columns, the package encapsulates the business rules that must be satisfied before a status change is permitted, ensuring that the integrity of the process manufacturing data model is preserved. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema, and it exposes a single documented public procedure, MODIFY_STATUS. The interface is versioned through the m_api_version constant, which is set to 1, and identifies itself through the m_pkg_name constant. The header carries the revision identifier $Header: GMDPSTSS.pls 120.0.12020000.2 2013/01/08, indicating that the shipped code is current for both the 12.1.1 and 12.2.2 releases. The package is classified as PUBLIC, suggesting it is intended as a supported integration point for external and custom callers rather than purely internal use.

Key Procedures and Functions

The documented interface consists of one procedure:

  • MODIFY_STATUS — Modifies the status of a specified entity after performing the required validations. The procedure accepts the entity identity through a combination of name, ID, number, and version, and takes a target status value as the destination of the transition. A p_ignore_flag parameter controls whether the status of an associated validity rule should be changed together with its parent recipe. The procedure returns the number of messages placed on the message stack, the message list itself, and a return status indicating success, error, or unexpected error. Standard API conventions apply, including an API version parameter and a flag to initialize the message list. The procedure is declared with defaults for the API version, message list initialization, and several entity identifiers, making it flexible across the different entity types it supports.

Tables Accessed

The package reads and writes a defined set of base tables through APPS synonyms. Entity definition data is held in GMD_RECIPES, GMD_RECIPES_B, GMD_ROUTINGS_B, GMD_OPERATIONS_B, GMD_OPERATION_ACTIVITIES, GMD_OPERATION_RESOURCES, and the formula structures FM_FORM_MST_B and FM_MATL_DTL. Item substitution information is drawn from GMD_ITEM_SUBSTITUTION_HDR_B, and item validation is supported by MTL_SYSTEM_ITEMS. The status framework itself relies on GMD_STATUS, GMD_STATUS_B, and GMD_STATUS_NEXT, which respectively provide the current status, the status definition, and the permissible status transitions. Recipe validity rules are read from GMD_RECIPE_VALIDITY_RULES. The package therefore validates the entity, checks the legal next status, applies the change, and propagates related updates where the ignore flag permits.

Usage Notes

MODIFY_STATUS is typically invoked whenever a change of status is required for a formula, recipe, operation, routing, or validity rule, such as moving a recipe from draft to released. It is called by Oracle forms and concurrent programs within the process manufacturing modules, and it is referenced by approximately ten other packages in the APPS schema, confirming its role as a shared service. Custom code integrating with process manufacturing should call this API rather than updating status columns directly, since the procedure enforces validations and maintains message stack diagnostics. Callers should supply the correct entity name, ID, number, and version for the target entity, inspect the return status and message count, and process the message list to surface validation failures.