Search Results get_resource_info

Overview

GMD_OPERATION_RESOURCES_PVT is the private implementation package for operation resource maintenance within the Oracle E-Business Suite Process Manufacturing (OPM) product family. Operation resources represent the machines, labor, equipment, and other capacity-bearing assets consumed at a specific operation activity on a routing. In ETRM terms, they are the resource-level detail attached to a routing operation, and they drive cost rollups, capacity planning, and shop floor scheduling.

The package body carries the header identifier GMDVOPRB.pls and was originally authored in September 2002, with subsequent bug-driven revisions in November 2002 and February 2004. It is classified as a Private API (API classification: PVT), meaning it is not intended for direct invocation from external or customer-written code. The public counterpart, GMD_OPERATION_RESOURCES_PUB, exposes the supported entry points, while this private package encapsulates the low-level DML, validation logic, and commit semantics. Its stated purpose, per the embedded documentation, is to contain the private procedures used to create, modify, and delete operation resources.

Key Procedures and Functions

The documented API surface comprises three procedures:

• INSERT_OPERATION_RESOURCES — Creates one or more operation resource rows for a given operation activity. The embedded source shows it accepts an operation line identifier (p_oprn_line_id) and a PL/SQL table of resource records typed as GMD_OPERATION_RESOURCES_PUB.gmd_oprn_resources_tbl_ty, supporting bulk insertion of resource assignments against a routing operation.
• UPDATE_OPERATION_RESOURCES — Modifies existing operation resource records, allowing changes to resource assignments such as usage, basis, or associated activity detail without re-creating the parent routing operation.
• DELETE_OPERATION_RESOURCE — Removes an operation resource assignment, typically invoked when a resource is no longer required at a given operation.

The body also declares a private helper function, set_debug_flag, which returns 'Y' or 'N' based on whether the current FND_LOG runtime level meets or exceeds FND_LOG.LEVEL_PROCEDURE. This replaced a prior call to FND_PROFILE.VALUE('AFLOG_ENABLED') under Bug 3222090 and provides controlled diagnostic output during execution.

Tables Accessed

• GMD_OPERATION_ACTIVITIES — The parent routing operation activity record; the insert procedure takes oprn_line_id as a foreign-key reference to this table. It is read to validate the target operation and written to via cascade relationships when resources change.
• GMD_OPERATION_RESOURCES — The primary target table, holding the resource assignments for each operation activity; it receives all inserts, updates, and deletes issued by this package.
• GMD_ACTIVITIES — The activity master that defines the type of resource (for example, machine or labor) used to validate resource rows.
• PLITBLM — The standard Oracle EBS PL/SQL table-to-database index-by table utility, referenced for handling the PL/SQL table parameters passed into the bulk procedures.

Usage Notes

This package should not be called directly by customers; it is invoked internally by GMD_OPERATION_RESOURCES_PUB, which is referenced by one other package in the ETRM metadata. Typical callers include OPM routing and recipe maintenance forms (such as the Operation Resources window within the Routings/Recipes responsibility) and any concurrent or batch program that bulk-loads routing resource assignments. Because it is a private package, custom extensions should target the _PUB layer and let it delegate to this body. The forward-declared set_debug_flag and the FND_LOG-based logging indicate that diagnostic tracing is available when the profile or log level is elevated, but no functional behavior depends on it. As with all EBS 12.1.1 and 12.2.2 database objects, any change requires the package to be compiled against the APPS schema after applying the relevant patch level.