Search Results lock_formula_record




Overview
Explore in AI Chat

Overview

GMD_SPREADSHEET_UPDATE is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, part of the Process Manufacturing (OPM) product family. It supports the spreadsheet-based editing and updating of process formulas and batches through Oracle's desktop integration framework. When a user opens a formula or batch in a spreadsheet application, edits the data, and uploads the changes back to the E-Business Suite, this package performs the server-side record-level concurrency validation and the transactional update of the affected records.

The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the calling schema rather than the definer. The header comment ($Header: GMDSPUPS.pls 120.1 2005/07/14 ...) indicates the source file has been stable since a 2005 revision, so behavior is consistent across EBS 12.1.1 and 12.2.2. The package is not referenced by any other documented package, confirming it is a top-level API invoked directly by the spreadsheet integration layer rather than a building block for other OPM logic.

Key Procedures and Functions

All eight documented procedures return status through an OUT NOCOPY X_return_status parameter, the standard EBS API convention for reporting success or failure to the caller.

  • LOCK_FORMULA_HDR — Acquires a concurrency lock on a formula header, validating the caller's copy against the last update date.
  • LOCK_FORMULA_DTL — Locks an individual formula detail (line) record, keyed by formula line ID.
  • LOCK_FORMULA_RECORD — Locks the formula record as a whole, keyed by formula ID, for cases where header and detail are validated together.
  • LOCK_BATCH_HDR — Locks a batch header record, validating the last update date.
  • LOCK_BATCH_DTL — Locks a batch material detail line, keyed by material detail ID.
  • LOCK_BATCH_RECORD — Locks a batch record as a whole, keyed by batch ID.
  • UPDATE_BATCH — Applies pending changes to the batch identified by batch ID.
  • UPDATE_ALLOCATION — Updates allocation information for a specific batch material detail line, taking plant, batch, material detail, and line type as its inputs.

Tables Accessed

The package reads and writes the core OPM formula and batch tables through APPS synonyms. Formula structures reside in FM_FORM_MST (formula header) and FM_MATL_DTL (formula material lines). Batch data resides in GME_BATCH_HEADER and GME_BATCH_STEPS (steps), with batch material lines in GME_MATERIAL_DETAILS. Interface and global temporary tables — GMD_MATERIAL_DETAILS_GTMP, GMD_MATERIAL_HEADER_GTMP, GME_INVENTORY_TXNS_GTMP, and GME_PENDING_PRODUCT_LOTS — carry spreadsheet-uploaded data into the update logic and hold pending lot and inventory transaction information. Supporting validation references include MTL_SYSTEM_ITEMS_B (item definitions), MTL_ITEM_REVISIONS, MTL_RESERVATIONS, and MTL_TRANSACTION_LOT_NUMBERS. Together these reads support item, revision, reservation, and lot validation during upload.

Usage Notes

GMD_SPREADSHEET_UPDATE is invoked by the OPM spreadsheet integration (desktop integration) when users upload edited formula or batch data. It is not intended for direct ad hoc execution. Custom code should treat it as an internal API: the lock procedures should be called before updates to enforce concurrency, and callers must honor the returned status value. Because the package runs AUTHID CURRENT_USER and has not been revised since 2005, integrators should verify behavior against their specific EBS release rather than assume feature changes between 12.1.1 and 12.2.2.