Search Results wip_job_schedule_interface_s




Overview
Explore in AI Chat

Overview

WSMPJITH is an APPS-owned PL/SQL package body classified under the OTHER API category in Oracle E-Business Suite. Its role is to bridge Oracle's Work in Process (WIP) job scheduling interface with the lot-based job model used by process manufacturing and shop floor execution. Specifically, the package moves data between a staging structure represented by WSM_LOT_JOB_INTERFACE and the standard WIP_JOB_SCHEDULE_INTERFACE table, which is the seeded interface consumed by the WIP scheduling manager. The package therefore acts as a translation and maintenance layer: it deposits lot-associated job schedule records into the WIP interface, and it removes records from that interface once they are no longer needed. Because the object is a package body, its logic is only reachable through the package specification WSMPJITH, and the dependency report confirms the package body depends on itself and is not referenced by any other database object — it is a top-level integration utility invoked directly by application code or concurrent processing rather than being called by other PL/SQL units.

Key Procedures and Functions

Two documented procedures constitute the public behavior of this package:

  • COPY_TO_WJSI — Populates the WIP job schedule interface. The name indicates the procedure copies records into WIP_JOB_SCHEDULE_INTERFACE (abbreviated WJSI). It is the mechanism by which lot job data held in the WSM lot job interface is written into the standard WIP scheduling interface so that the WIP scheduler can process it as it would any other scheduled job record.
  • DELETE_FROM_WJSI — Removes records from the WIP job schedule interface. This procedure is used to clean up interface rows, typically after successful processing or to correct previously staged data before a fresh load. The remaining parameter lists are not documented in the ETRM metadata and must be confirmed against the live package specification in the target instance.

Tables Accessed

The package reads and writes the following documented objects, all referenced through APPS synonyms:

  • WSM_LOT_JOB_INTERFACE — the source staging table for lot-related job information that COPY_TO_WJSI transfers into the WIP interface.
  • WIP_JOB_SCHEDULE_INTERFACE and WIP_JOB_SCHEDULE_INTERFACE_S — the standard WIP interface table and its sequence, the destination of COPY_TO_WJSI and the target of DELETE_FROM_WJSI.
  • WIP_ENTITIES_S — the sequence supplying entity identifiers for WIP records created during the copy operation.
  • WIP_INTERFACE_ERRORS — the standard error repository where interface validation failures are logged for later review.
  • BOM_REVISIONS — accessed to resolve bill of material revision information associated with the staged job data.
  • DUAL — used for single-row SQL evaluations and sequence selection.

Usage Notes

WSMPJITH is not referenced by any other database object, so it is not embedded in a larger PL/SQL call chain. It is invoked directly — typically from a concurrent program or custom integration routine that stages lot job records in WSM_LOT_JOB_INTERFACE and then calls COPY_TO_WJSI to hand them to the WIP scheduler. DELETE_FROM_WJSI supports corrective or post-processing cleanup. Because the interface tables are shared with Oracle's standard scheduling flow, any custom caller must respect the standard validation and error-handling expectations of the WIP job schedule interface, and errors surfaced through WIP_INTERFACE_ERRORS should be monitored. Before use in a 12.1.1 or 12.2.2 instance, developers should verify the current parameter signatures in the package specification, as the ETRM record does not document them.