Search Results mtl_gen_object_id_s




Overview
Explore in AI Chat

Overview

WSMPDJOB is a stored PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. The naming convention and dependency profile indicate that it belongs to the Oracle Warehouse Management (WMS) family of packages, with a specific focus on work-in-process discrete job records. The "PDJOB" component of the name refers to Process/Discrete Job processing, and the package is classified under the ETRM "OTHER" API category, meaning it is a supporting internal package rather than a published, external-facing API.

Functionally, WSMPDJOB acts as a thin data manipulation layer that maintains the linkage between WIP discrete jobs, WIP entities, and the MTL_GEN_OBJECT_ID_S key-flex surrogate sequence. The business purpose of the package is to preserve referential integrity between the WIP execution tables and the generic object identifier sequence used throughout the Warehouse Management module, ensuring that each WIP entity is assigned a consistent, resolvable internal identifier across related application objects.

Key Procedures and Functions

The documented package exposes two procedures:

  • INSERT_ROW — Creates a new row in the target WIP structure while resolving the underlying surrogate object key from MTL_GEN_OBJECT_ID_S. This procedure is the entry point used when a new discrete job or WIP entity record must be registered with the Warehouse Management layer and must carry a valid generic object identifier.
  • UPDATE_ROW — Modifies an existing row previously created through the insert path. It applies changes to the stored WIP job or entity attributes while preserving the established object identifier assignment, so that downstream references remain valid after attribute corrections.

ETRM does not document parameter signatures or exception behavior for either procedure; the package is treated as an internal utility and its interface should be considered non-public.

Tables Accessed

The package references three database objects, all resolved through APPS synonyms:

  • MTL_GEN_OBJECT_ID_S — The generic object identifier sequence. This is the object the user searched for; WSMPDJOB consumes it to obtain unique surrogate identifiers for the rows it inserts. It is a sequence, not a table, and is queried via the standard NEXTVAL mechanism during INSERT_ROW execution.
  • WIP_DISCRETE_JOBS — Stores the discrete job header records. INSERT_ROW and UPDATE_ROW operate against this table to persist or amend job-level attributes.
  • WIP_ENTITIES — The WIP entity table that groups job and repetitive schedule entities under a common identifier. The package links this entity to the generated object identifier so that WMS operations can locate the correct entity context.

Usage Notes

WSMPDJOB is not referenced by any other database object in the documented dependency graph. Because no package, view, trigger, or form dependency is recorded, invocation is expected to be direct — either from Oracle Forms-based WMS/WIP transactions, from concurrent programs executing WMS-internal logic, or from custom extensions written by implementers who need to insert or update WIP discrete job records while maintaining object identifier consistency.

Custom developers should exercise caution: the package is classified as an internal "OTHER" API and carries no documented parameter contract. Oracle may change its internal structure between 12.1.1 and 12.2.2 without notice. Direct calls should be avoided where a supported public WIP or WMS API exists; WSMPDJOB should generally be treated as implementation detail reached through higher-level transactional flows.