Results for “wip_entities_s”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.WIP_DISCRETE_J_PKG is a PL/SQL package body in the Oracle E-Business Suite Applications schema that supports the maintenance of discrete job records within Oracle Work in Process. The package is oriented around row-level data manipulation against the WIP discrete job and work-in-process entity tables, and it is classified as OTHER rather than as a formal public API. Its documented status is VALID, and the package body is not referenced by any other database object, which indicates that it is invoked from external context such as forms, concurrent processing, or custom extension code rather than through inter-package dependency chains.

The package is closely associated with the WIP_ENTITIES and WIP_ENTITIES_S tables, which store the entity records that identify discrete jobs, and with WIP_DISCRETE_JOBS, which carries the discrete job header attributes. The user search term wip_entities_s aligns directly with the WIP_ENTITIES_S reference documented for this package, confirming that the package participates in the sequence number and entity-key generation logic used when discrete job entities are created and updated.

Key Procedures and Functions

The ETRM metadata documents two procedures in this package body:

• INSERT_ROW — Inserts a new discrete job row into the WIP entity and discrete job structures. It is the entry point used when a new discrete job entity must be created, including the assignment of the entity object identifier required by the WIP entity model.
• UPDATE_ROW — Updates an existing discrete job row. It supports modification of previously created discrete job records, applying changes to the WIP entity and discrete job attributes maintained by this package.

No parameter lists are documented in the available metadata, and the procedures should be treated as internal row handlers rather than as a published interface.

Tables Accessed

The documented table references are:

• MTL_GEN_OBJECT_ID_S — Supplies generated object identifiers used to key WIP entities. Access occurs through the APPS synonym, indicating integration with the Oracle object ID generation mechanism.
• WIP_DISCRETE_JOBS — The primary discrete job table, holding job header information that INSERT_ROW and UPDATE_ROW populate and maintain.
• WIP_ENTITIES — Stores work-in-process entity records that link discrete jobs to the broader WIP entity model.
• WIP_ENTITIES_S — The sequence object associated with WIP entity key generation, referenced when new entity rows are inserted.
• DUAL — A standard reference used for singleton evaluations and sequence or identity retrieval within PL/SQL.
• STANDARD — The standard Oracle PL/SQL package available for general runtime support.

Together, these dependencies show that the package writes discrete job data while reading key-generation objects.

Usage Notes

Because WIP_DISCRETE_J_PKG is not referenced by any other database object, it is not part of a documented package-to-package call path. It is most likely invoked from Oracle Forms or from custom PL/SQL that needs to create or amend discrete job records directly. In EBS 12.1.1 and 12.2.2, direct manipulation of WIP base tables outside the supported WIP APIs carries upgrade and data integrity risk; therefore, this package should be treated as an implementation detail of the discrete job maintenance flow rather than as a recommended integration point. Developers searching for wip_entities_s should understand that the sequence and its associated logic are exercised here primarily during the insert path, while update activity touches the discrete job and entity rows already created.