Search Results gme_create_batch_pvt
Overview
The APPS.GME_CREATE_BATCH_PVT package is a private (PVT-classified) PL/SQL API within the Oracle E-Business Suite Process Manufacturing (OPM/GME) module. Its principal business function is to create and maintain batch records in the GME_BATCH_HEADER and related step, material, and text tables. Batches in Process Manufacturing represent discrete production runs of a recipe or formula, capturing the WIP entity that drives material consumption, step execution, and yield accounting.
Operating in Oracle EBS 12.1.1 and 12.2.2 against schema APPS, the package sits between higher-level public APIs and the underlying batch data model. It depends on FND_API for the standard API error/return convention, on GME_BATCH_HEADER, and on GME_COMMON_PVT for shared batch subsystem logic. The object is documented as VALID and carries a PVT classification, indicating it is intended for internal consumption rather than direct customer invocation.
Key Procedures and Functions
Four documented subprograms constitute the package interface:
- CONSTRUCT_BATCH_HEADER — Builds or populates the batch header record structure from the supplied recipe, organization, and batch context, assembling the data prior to persistence.
- VALIDATE_WIP_ENTITY — Verifies the WIP entity/batch context (organization, recipe, or entity identifiers) before creation proceeds, enforcing business consistency.
- CREATE_BATCH — Performs the actual batch creation, inserting into the header and deriving downstream step, material, and text records from the applicable recipe.
- UPDATE_STEP_MTQ — Updates the material quantity (MTQ) associated with a batch step, supporting adjustments to step-level material requirements after batch creation.
Parameter lists are not documented in the ETRM metadata and are therefore not reproduced here.
Tables Accessed
The package reads from recipe-definition tables and writes to batch-instance tables, all via APPS synonyms:
- Recipe/formula master: GMD_RECIPES, GMD_RECIPES_B, GMD_RECIPE_VALIDITY_RULES.
- Formula process data: FM_FORM_MST, FM_MATL_DTL, FM_ROUT_DTL, FM_ROUT_HDR, FM_TEXT_TBL.
- Batch creation targets: GME_BATCH_HEADER, GME_BATCH_STEPS, GME_BATCH_STEP_ITEMS, GME_MATERIAL_DETAILS.
- Text and parameters: GME_TEXT_HEADER, GME_TEXT_TABLE, GME_PARAMETERS.
Usage Notes
GME_CREATE_BATCH_PVT is invoked indirectly. The documented referencers are GME_API_MAIN, GME_API_GRP, GME_CONVERT_FPO_PVT, and GME_PHANTOM_PVT, meaning batch creation is reached through public API entry points, flow-schedule/FPO conversion, and phantom processing rather than by custom code directly. Customizations should call the supported public GME APIs; direct invocation of this private package risks unsupported behavior across releases.
-
PACKAGE: APPS.GME_CREATE_BATCH_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GME_CREATE_BATCH_PVT, status:VALID,
-
PACKAGE: APPS.GME_CREATE_BATCH_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GME_CREATE_BATCH_PVT, status:VALID,
-
PACKAGE BODY: APPS.GME_CREATE_BATCH_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GME_CREATE_BATCH_PVT, status:VALID,
-
PACKAGE BODY: APPS.GME_CREATE_BATCH_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GME_CREATE_BATCH_PVT, status:VALID,
-
PACKAGE: APPS.GME_TEXT_DBL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GME_TEXT_DBL, status:VALID,
-
PACKAGE: APPS.GME_TEXT_DBL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GME_TEXT_DBL, status:VALID,
-
PACKAGE: APPS.GME_CREATE_BATCH_PVT
12.2.2
-
PACKAGE: APPS.GMD_RECIPE_DATA_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GMD_RECIPE_DATA_PUB, status:VALID,
-
PACKAGE: APPS.GME_CREATE_BATCH_PVT
12.1.1
-
PACKAGE: APPS.GME_RESCHEDULE_BATCH_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GME_RESCHEDULE_BATCH_PVT, status:VALID,
-
PACKAGE: APPS.GMO_DISPENSE_GRP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GMO_DISPENSE_GRP, status:VALID,
-
SYNONYM: APPS.FM_TEXT_TBL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FM_TEXT_TBL, status:VALID,
-
PACKAGE BODY: APPS.GME_PHANTOM_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GME_PHANTOM_PVT, status:VALID,
-
PACKAGE BODY: APPS.GME_PHANTOM_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GME_PHANTOM_PVT, status:VALID,
-
SYNONYM: APPS.GME_TEXT_HEADER
12.1.1
owner:APPS, object_type:SYNONYM, object_name:GME_TEXT_HEADER, status:VALID,
-
PACKAGE: APPS.GME_FPL_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GME_FPL_PVT, status:VALID,
-
PACKAGE: APPS.GME_FPL_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GME_FPL_PVT, status:VALID,
-
PACKAGE: APPS.GME_SCALE_BATCH_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GME_SCALE_BATCH_PVT, status:VALID,
-
SYNONYM: APPS.GME_TEXT_TABLE
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GME_TEXT_TABLE, status:VALID,
-
PACKAGE: APPS.GME_MOVE_ORDERS_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GME_MOVE_ORDERS_PVT, status:VALID,
-
PACKAGE: APPS.GME_UPDATE_STEP_QTY_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GME_UPDATE_STEP_QTY_PVT, status:VALID,
-
PACKAGE: APPS.GMO_VBATCH_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GMO_VBATCH_GRP, status:VALID,
-
PACKAGE: APPS.GMD_RECIPE_DATA_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GMD_RECIPE_DATA_PUB, status:VALID,
-
SYNONYM: APPS.FM_TEXT_TBL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FM_TEXT_TBL, status:VALID,
-
PACKAGE: APPS.GME_SCALE_BATCH_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GME_SCALE_BATCH_PVT, status:VALID,
-
PACKAGE: APPS.GMP_CALENDAR_API
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GMP_CALENDAR_API, status:VALID,
-
SYNONYM: APPS.GME_PARAMETERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:GME_PARAMETERS, status:VALID,
-
SYNONYM: APPS.GME_PARAMETERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GME_PARAMETERS, status:VALID,
-
PACKAGE: APPS.GMP_CALENDAR_API
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GMP_CALENDAR_API, status:VALID,
-
SYNONYM: APPS.GME_TEXT_TABLE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:GME_TEXT_TABLE, status:VALID,
-
SYNONYM: APPS.GME_TEXT_HEADER
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GME_TEXT_HEADER, status:VALID,
-
PACKAGE: APPS.GME_PHANTOM_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GME_PHANTOM_PVT, status:VALID,
-
PACKAGE: APPS.GME_PHANTOM_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GME_PHANTOM_PVT, status:VALID,
-
PACKAGE: APPS.GMD_VALIDITY_RULES
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GMD_VALIDITY_RULES, status:VALID,
-
PACKAGE: APPS.GMO_DISPENSE_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GMO_DISPENSE_GRP, status:VALID,
-
PACKAGE: APPS.GMD_VALIDITY_RULES
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GMD_VALIDITY_RULES, status:VALID,
-
PACKAGE: APPS.GMO_VBATCH_GRP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GMO_VBATCH_GRP, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
PACKAGE: APPS.GMD_COMMON_SCALE
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GMD_COMMON_SCALE, status:VALID,
-
PACKAGE: APPS.GME_RESCHEDULE_BATCH_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GME_RESCHEDULE_BATCH_PVT, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
PACKAGE: APPS.GME_VALIDATE_FLEX_FLD_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GME_VALIDATE_FLEX_FLD_PVT, status:VALID,
-
PACKAGE: APPS.GMDFMVAL_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GMDFMVAL_PUB, status:VALID,
-
PACKAGE: APPS.GME_VALIDATE_FLEX_FLD_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GME_VALIDATE_FLEX_FLD_PVT, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
12.2.2 DBA Data
12.2.2
-
PACKAGE: APPS.GME_CREATE_STEP_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GME_CREATE_STEP_PVT, status:VALID,
-
PACKAGE: APPS.GME_CREATE_STEP_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GME_CREATE_STEP_PVT, status:VALID,
-
PACKAGE: APPS.GME_MATERIAL_DETAILS_DBL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GME_MATERIAL_DETAILS_DBL, status:VALID,
-
PACKAGE: APPS.GME_MOVE_ORDERS_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GME_MOVE_ORDERS_PVT, status:VALID,