Search Results update_instance_row

Overview

GMP_RESOURCE_DTL_PUB is the public PL/SQL interface for the Oracle Process Manufacturing (OPM) Plant Resources API, owned by the APPS schema and shipped with the GMP product. It exposes a supported, versioned entry point (m_api_version is declared as 1) for creating, updating, and deleting plant resource definitions and their associated resource instances in OPM. The package header is annotated with a public rep:scope and the business entity GMP_PLANT_RESOURCE, confirming its classification as a published API intended for external invocation rather than internal-only use. Its principal responsibility is to centralize the business logic and validation required to maintain plant resource data — spanning resource master detail, resource instances, availability, exceptions, and calibration attributes — so that callers do not write directly to the underlying tables. At runtime it is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user.

Key Procedures and Functions

The documented package exposes ten callable units addressing two related data domains: resource detail rows and resource instances.

• INSERT_RESOURCE_DTL — Creates a new plant resource, inserting a row into the plant resource detail table CR_RSRC_DTL. Per the embedded comment, it accepts the standard API parameters including p_api_version, p_init_msg_list, and p_commit.
• CHECK_DATA — Performs validation of resource detail input before insert or update processing.
• INSERT_DETAIL_ROWS — Handles insertion of dependent detail rows associated with a resource definition.
• UPDATE_RESOURCE_DTL — Modifies an existing plant resource record in the resource detail table.
• UPDATE_DETAIL_ROWS — Applies updates to the dependent detail rows of a resource.
• DELETE_RESOURCES — Removes plant resource definitions.
• CHECK_INSTANCE_DATA — Validates resource instance attributes prior to insert or update.
• INSERT_RESOURCE_INSTANCE — Creates a resource instance, corresponding to the insert_resource_instance search term. This procedure operates against the resource_instances_rec record type, whose fields include RESOURCE_ID, INSTANCE_ID, INSTANCE_NUMBER, VENDOR_ID, MODEL_NUMBER, SERIAL_NUMBER, TRACKING_NUMBER, effective dates, maintenance interval and last maintenance date, calibration frequency/period/item and calibration dates, certification data, and the standard WHO audit columns.
• UPDATE_INSTANCES — Updates one or more resource instances.
• UPDATE_INSTANCE_ROW — Updates a single resource instance row; the package also declares the update_tbl_type record/table structures (column name plus value) used to drive targeted column updates.

Tables Accessed

The package reads and writes a defined set of OPM and shared tables through APPS synonyms. CR_RSRC_DTL and CR_RSRC_MST hold the plant resource detail and master records. GMP_RESOURCE_INSTANCES and its _S (sequence/standards) counterpart store resource instance data, while GMP_RESOURCE_AVAIL and GMP_RSRC_UNAVAIL_MAN manage availability and unavailability. GMP_RSRC_EXCP_ASNMT holds resource exception assignments. BOM_CALENDARS and BOM_RESOURCES_S support scheduling and resource definitions. Validation and lookup logic reference IC_ITEM_MST, MTL_PARAMETERS, MTL_UNITS_OF_MEASURE, and PLITBLM. These tables collectively support resource definition, instance tracking, maintenance, calibration, and availability management.

Usage Notes

Because GMP_RESOURCE_DTL_PUB is a published API with no known inbound package dependencies (referenced by zero other packages in the metadata), it is typically invoked from OPM application forms, concurrent programs, or customer-written extensions that maintain plant resources and resource instances. Callers should always pass the API version constant, initialize the message list, and control commit behavior explicitly; error and validation messages are accessed through the standard message-list interface. Direct DML against the underlying tables should be avoided in favor of this API to preserve validation, audit column maintenance, and instance integrity. The package is active in both Oracle EBS 12.1.1 and 12.2.2, and the header revision log (120.7.12020000.2) reflects a 2012 build consistent with the 12.2 code line.