Search Results gmd_effectivity_locked_status

Overview

GMDFMVAL_PUB is a public PL/SQL package in the APPS schema that provides centralized validation and lookup services for Oracle Process Manufacturing (OPM) formula and recipe data. In Oracle EBS 12.1.1 and 12.2.2, the package functions as a shared validation layer used by formula maintenance, recipe design, substitution processing, and migration utilities. Its API classification is PUB, indicating that it exposes a supported interface intended to be called by other application modules rather than being restricted to internal use.

The package consolidates the business rules that govern whether formula header, formula line, substitution list, and ingredient records may be inserted or updated, and it supplies the derived attribute values these records require. By isolating this logic in a single public package, OPM ensures consistent validation across the many forms, concurrent programs, and public APIs that manipulate formula and recipe structures.

Key Procedures and Functions

The documented interface contains 23 procedures and functions. The primary entry points are VALIDATE_INSERT_RECORD and VALIDATE_UPDATE_RECORD, which enforce insert-time and update-time business rules for formula and related records.

• GET_ELEMENT, GET_SUBSTITUTE_ITEMS, and GET_SUBSTITUTE_LINE_ITEM retrieve element and substitution data for a given formula or line context.
• COPY_FORMULA_SUBSTITUTION_LIST duplicates an existing substitution list, supporting formula copy operations.
• GET_LINE_QTY, GET_FORMULA_ID, GET_FORMULALINE_ID, and GET_ITEM_ID return identifying and quantity values for formula lines, items, and their internal keys.
• DETERMINE_PRODUCT resolves the product associated with a formula or recipe context.
• CHECK_REWORK_TYPE validates rework classification rules.
• FORMULA_CLASS_VAL, TYPE_VAL, COST_ALLOC_VAL, LOCKED_EFFECTIVITY_VAL, GMD_EFFECTIVITY_LOCKED_STATUS, CONVERTUOM_VAL, and DETAIL_LINE_VAL perform discrete attribute validations covering formula class, formula type, cost allocation, effectivity locking, unit-of-measure conversion, and detail line integrity.
• CHECK_EXPR_ITEMS validates expression items referenced by formula detail lines.

Tables Accessed

GMDFMVAL_PUB reads and validates against a defined set of OPM and Oracle Inventory tables through APPS synonyms. Formula master and detail data reside in FM_FORM_MST and FM_MATL_DTL, with formula classification in FM_FORM_CLS. Recipe definitions are held in GMD_RECIPES, GMD_RECIPES_B, and GMD_RECIPE_VALIDITY_RULES, the latter supporting effectivity date validation. Substitution structures are validated against GMD_FORMULA_SUBSTITUTION, GMD_FORMULA_SUBSTITUTION_S, GMD_ITEM_SUBSTITUTION_DTL, and GMD_ITEM_SUBSTITUTION_HDR_B. Cost component detail is read from CM_CMPT_DTL. Item validation and description lookups use MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_KFV, and MTL_ITEM_REVISIONS. FND_USER supplies user context for validation routines.

Usage Notes

The package is heavily reused across the OPM module. It is referenced by 18 other packages, including GMD_FORMULA_PUB, GMD_FORMULA_DETAIL_PUB, GMD_RECIPE_DATA_PUB, GMD_RECIPE_DESIGNER_PKG, GMD_RECIPE_HEADER_PVT, GMD_SUBSTITUTION_PUB, and the GMD migration utilities (GMD_FORM_MIGRATION, GMD_OPRN_MIGRATION, GMD_ROUT_MIGRATION, GMD_RECIPE_MIGRATION). Notably, the search term gme_api_grp appears in the dependency list: GME_API_GRP is referenced by GMDFMVAL_PUB, and GME_API_GRP in turn references GMDFMVAL_PUB, reflecting the shared validation contracts between the GME (process execution) and GMD (formula/recipe) API families. Batch-oriented packages such as GME_CREATE_BATCH_PVT, GME_REROUTE_BATCH_PVT, and GME_SCALE_BATCH_PVT also depend on it. It is typically invoked indirectly through these public APIs and their associated forms and concurrent programs, rather than being called directly; custom code extending OPM formula or recipe processing should call the higher-level GMD and GME APIs, which internally delegate validation to GMDFMVAL_PUB.