Search Results g_request

Overview

WIP_WIP_ENTITIES_UTIL is a utility package in the Oracle E-Business Suite Work in Process (WIP) module, owned by the APPS schema and classified as a UTIL (utility) object within ETRM. Its purpose is to encapsulate the low-level persistence and record-manipulation logic associated with the WIP_ENTITIES table, which stores work order and job header information. The package provides standardized routines for inserting, updating, deleting, querying, and locking work order entity rows, allowing higher-level WIP business logic and public APIs to operate against WIP_ENTITIES without duplicating boilerplate DML code.

A notable characteristic of this package is its use of global constants to represent attribute positions within the Wip_Entities_Rec_Type record structure defined in WIP_Work_Order_PUB. These constants map attribute names to numeric indices, including G_CREATED_BY, G_CREATION_DATE, G_DESCRIPTION, G_ENTITY_TYPE, G_LAST_UPDATED_BY, G_LAST_UPDATE_DATE, G_LAST_UPDATE_LOGIN, G_ORGANIZATION, G_PRIMARY_ITEM, G_PROGRAM_APPLICATION, G_PROGRAM, G_PROGRAM_UPDATE_DATE, G_REQUEST, G_WIP_ENTITY, G_WIP_ENTITY_NAME, and G_MAX_ATTR_ID. The presence of G_REQUEST (constant value 13) reflects the standard EBS audit convention of tracking the concurrent request identifier that created or last modified a row.

Key Procedures and Functions

The package exposes seven documented routines. Each is designed to operate on records of type WIP_Work_Order_PUB.Wip_Entities_Rec_Type.

• Complete_Record — populates or completes a Wip_Entities record, typically filling in audit and default attributes, by comparing the incoming record against an existing (old) record.
• Convert_Miss_To_Null — normalizes a work order entity record by converting missing or sentinel values to NULL, ensuring consistency before DML is performed.
• Update_Row — updates the WIP_ENTITIES row corresponding to the supplied record.
• Insert_Row — inserts a new WIP_ENTITIES row from the supplied record.
• Delete_Row — deletes the work order entity identified by a wip_entity_id.
• Query_Row — retrieves a single WIP_ENTITIES row, keyed by wip_entity_id, and returns it as a Wip_Entities_Rec_Type record.
• Lock_Row — acquires a row-level lock on the corresponding WIP_ENTITIES row and returns status, supporting optimistic concurrency control within the calling transaction.

Tables Accessed

According to the ETRM metadata, the only table referenced through APPS synonyms is WIP_ENTITIES. All documented DML and query operations target this table. WIP_ENTITIES holds the defining attributes of discrete work orders and repetitive schedules, and this utility package is the persistence layer through which the public WIP work order API reads and writes those attributes. No other tables are documented as being accessed by this package.

Usage Notes

This package is an internal utility rather than an end-user-facing API. It is normally invoked indirectly by the WIP_Work_Order_PUB public API and by other WIP packages that need to persist work order entity records. ETRM indicates it is referenced by three other packages. Because it operates directly against WIP_ENTITIES and relies on the WIP_Work_Order_PUB record type, custom code should generally call the public API (WIP_Work_Order_PUB) rather than this utility directly, and any direct invocation must supply a fully populated Wip_Entities_Rec_Type and observe the G_REQUEST audit constant for concurrent request tracking.