Search Results delete_operation_resources




Overview
Explore in AI Chat

Overview

The APPS.GMD_OPERATION_RESOURCES_PUB package is a public PL/SQL API within the Oracle E-Business Suite Process Manufacturing (OPM) product family, identified by the product code GMD. It provides the supported programmatic interface for maintaining operation resources — the labor, equipment, and machine assets consumed at a routing operation during production. The package header header comment (version 120.1.12010000.1, dated 2008/07/24) declares its scope explicitly: it is used to create, update, and delete operation resources, and it defines and implements the procedures and datatypes required to perform those actions. The ETRM repository classifies the package as public, active, and forward compatible, with a business entity association to GMD_OPERATION and a display name of "Operation Resources package." Because the package is a public API, it encapsulates the validation and DML logic required to keep operation resource records consistent with their parent operations, the underlying resource master, cost analysis classifications, and unit-of-measure definitions.

The package also publishes the resources_rec_type record type, which mirrors the structure of the GMD_OPERATION_RESOURCES table. Its fields include OPRN_LINE_ID, RESOURCES, RESOURCE_USAGE, RESOURCE_COUNT (default 1), RESOURCE_USAGE_UOM, PROCESS_QTY, RESOURCE_PROCESS_UOM, PRIM_RSRC_IND, SCALE_TYPE (default 1), COST_ANALYSIS_CODE, COST_CMPNTCLS_ID, OFFSET_INTERVAL (default 0), MIN_CAPACITY, MAX_CAPACITY, RESOURCE_CAPACITY_UOM, and the standard ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 descriptive flexfield columns. Callers populate this record to pass operation resource attributes into the API.

Key Procedures and Functions

ETRM documents three public procedures for this package:

  • INSERT_OPERATION_RESOURCES — Creates new operation resource records for a production operation. It accepts the resource record type and persists a new row in GMD_OPERATION_RESOURCES, validating the referenced resource and UOM values in the process.
  • UPDATE_OPERATION_RESOURCES — Modifies existing operation resource records, supporting changes to resource usage, counts, capacity bounds, cost analysis assignments, and descriptive flexfield attributes.
  • DELETE_OPERATION_RESOURCES — Removes operation resource records. This is the procedure most frequently sought under the search term delete_operation_resources, and it provides the supported mechanism for programmatically detaching a resource from an operation without direct table DML.

The record payload is shared across all three procedures, allowing a caller to read a record, modify selected fields, and pass it back for update. Parameter lists are not reproduced here; consult the package specification in the EBS instance for exact signatures.

Tables Accessed

The package reads and writes GMD_OPERATION_RESOURCES, the primary table for operation resource definitions, and references GMD_OPERATION_ACTIVITIES and GMD_OPERATIONS to validate the parent operation context. Resource master data is validated against CR_RSRC_MST, while activity and cost classifications are resolved through CM_ALYS_MST (cost analysis) and CM_CMPT_MST (cost component class). Unit-of-measure values such as resource usage UOM, process UOM, and capacity UOM are validated against MTL_UNITS_OF_MEASURE. FM_ACTV_MST provides activity master information, and PLITBLM supplies the standard EBS multirate or language translation support used in OPM APIs.

Usage Notes

The package is invoked from OPM routing and operation maintenance forms, batch and concurrent processing, and custom extensions that must create or maintain operation resources without bypassing API validation. It is referenced by four other packages in the ETRM inventory, indicating it forms part of a wider dependency chain in the process manufacturing APIs. Custom code should call the public procedures rather than performing direct inserts, updates, or deletes against GMD_OPERATION_RESOURCES, since the API enforces referential and business validation. Both EBS 12.1.1 and 12.2.2 share the same package specification lineage (120.1.12010000.1), and the package is designated compatible and active in the ETRM repository.