Results for “update_actual_rsrc_usage”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.GME_API_PUB is the public API package for Oracle Process Manufacturing (OPM) batch processing within Oracle E-Business Suite. Its primary business function is to provide a stable, callable interface through which batch records, batch steps, resources, process parameters, material details, and reservations are created, updated, scaled, and rescheduled. The package encapsulates the transactional logic required to maintain the GME_BATCH_HEADER and related batch-step structures while also interacting with Oracle Inventory through material transaction and reservation tables.
As a public (PUB) API, GME_API_PUB is intended to be invoked by other application modules, concurrent programs, forms, and customer extensions rather than being called internally as a private helper. It sits at the boundary between process manufacturing execution activities and the underlying batch and inventory data model, providing controlled entry points that validate and persist batch-related changes. The object resides in the APPS schema and has a status of VALID in the documented ETRM metadata for release 12.2.2.
Key Procedures and Functions
The metadata documents 57 procedures and functions. Representative entries include:
- SAVE_BATCH — Persists changes to an existing batch header and associated batch data.
- CREATE_BATCH — Creates a new batch record in the batch header structure.
- CREATE_PHANTOM — Creates phantom batch records used for intermediate or non-stocked production.
- SCALE_BATCH — Adjusts batch quantities and associated component quantities to a new scale.
- THEORETICAL_YIELD_BATCH — Calculates or records theoretical yield for a batch.
- UPDATE_ACTUAL_RSRC_USAGE — Updates actual resource usage recorded against a batch.
- INSERT_INCR_ACTUAL_RSRC_TXN — Inserts incremental actual resource transactions.
- INSERT_TIMED_ACTUAL_RSRC_TXN — Inserts time-based actual resource transactions.
- START_CMPLT_ACTUAL_RSRC_TXN — Records start-complete actual resource transactions.
- END_CMPLT_ACTUAL_RSRC_TXN — Records end-complete actual resource transactions.
- RESCHEDULE_BATCH — Reschedules a batch to a new date or time.
- RESCHEDULE_STEP — Reschedules an individual batch step.
- CREATE_BATCH_RESERVATIONS — Creates inventory reservations at the batch level.
- CREATE_LINE_RESERVATIONS — Creates inventory reservations at the line level.
- INSERT_PROCESS_PARAMETER — Inserts a process parameter for a batch or step.
- UPDATE_PROCESS_PARAMETER — Updates an existing process parameter.
- DELETE_PROCESS_PARAMETER — Removes a process parameter.
- INSERT_STEP — Inserts a batch step.
- DELETE_STEP — Deletes a batch step.
Tables Accessed
GME_API_PUB reads and writes the core OPM batch tables through APPS synonyms: GME_BATCH_HEADER, GME_BATCH_STEPS, GME_BATCH_STEP_ACTIVITIES, GME_BATCH_STEP_RESOURCES, GME_MATERIAL_DETAILS, GME_PENDING_PRODUCT_LOTS, GME_PROCESS_PARAMETERS, and GME_RESOURCE_TXNS. These tables store batch definitions, step structure, step activities, resource consumption, material requirements, pending product lots, process parameters, and resource transaction history.
The package also touches Oracle Inventory tables: MTL_LOT_NUMBERS, MTL_MATERIAL_TRANSACTIONS, MTL_RESERVATIONS, and MTL_TRANSACTIONS_INTERFACE. These support lot validation, material transaction creation, reservation management, and interface-based transaction processing. Additionally, the package references CR_RSRC_DTL, CR_RSRC_MST, and GMD_OPERATIONS_B, which relate to resource definitions, resource master data, and operation definitions. The dependency list confirms reliance on FND_API for standard API error handling and on private packages GME_COMMON_PVT and GME_CREATE_STEP_PVT.
Usage Notes
GME_API_PUB is typically invoked from OPM batch maintenance forms, mobile transaction flows, spreadsheet updates, and concurrent programs that create or modify batch data. The metadata shows it is referenced by nine other packages, including GME_MAKE_TO_ORDER_PVT, GME_MOBILE_TXN, GMO_VBATCH_TASK_PVT, GMP_BATCH_WRAPPER_PKG, and GMD_SAMPLES_GRP, illustrating its role as a shared batch-processing service. Custom code should call the documented public procedures rather than manipulating the underlying GME_* and MTL_* tables directly, because the package enforces validation, reservation, and transaction interface logic required for data integrity.
-
PACKAGE: APPS.GME_API_PUB 12.1.1
-
PACKAGE: APPS.GME_API_PUB 12.2.2