Search Results create_lines

Overview

ENG_ICMDB_APIS_UTIL is a utility PL/SQL package owned by the APPS schema that forms part of the Oracle Engineering (ENG) module's change management infrastructure, specifically the ICMDB (Item Change Management Database) application programming interface layer. Its primary business function is to support the programmatic manipulation of engineering change objects and their associated change lines, which are the individual item, bill of material, or routing records affected by an engineering change order (ECO). In Oracle EBS 12.1.1 and 12.2.2, engineering change management relies on a layered architecture in which database-level packages such as this one expose controlled entry points for creating and status-transitioning change records. ENG_ICMDB_APIS_UTIL abstracts these operations so that callers—whether other EBS APIs, workflow activities, or custom extensions—do not manipulate the underlying change tables directly. Dividing the API surface into a small number of well-defined procedures reflects the utility classification assigned to this package: it provides reusable building blocks rather than an end-user-facing feature set.

Key Procedures and Functions

Two procedures are documented within the package specification:

• CREATE_LINES — This procedure creates the change line records associated with a given engineering change. It accepts a change identifier as input and returns standard EBS API status information (return status, message count, and message data) to the caller. This is the procedure most directly relevant to searches for "create_lines," as it represents the supported mechanism for generating the line-level detail of a change order programmatically. By centralising line creation here, the package ensures that validation, defaulting, and referential integrity rules are applied consistently regardless of the calling context.
• UPDATE_APPROVAL_STATUS — This procedure updates the approval status of a change. It accepts the change identifier, a base change management type code, a new approval status code, and a workflow status code as inputs, and likewise returns the standard return status, message count, and message data out parameters. It allows callers to advance or otherwise modify the approval state of a change in coordination with the change management type and the workflow engine.

Both procedures follow the conventional Oracle EBS API error-handling pattern, where the out parameters carry success or failure information that callers are expected to inspect after each invocation.

Tables Accessed

The ETRM metadata for this object does not enumerate the specific tables referenced. Given its role in engineering change management, the package operates against the change management tables accessed through APPS synonyms, including the change header and change line entities that store ECO definitions and the affected objects. Because the documentation lists no explicit table dependencies, implementers should treat the data model as internal and interact only through the published procedures. The "Referenced by 1 other packages" note in the metadata confirms that this utility is itself consumed by higher-level API code, reinforcing that direct table access is neither required nor recommended.

Usage Notes

ENG_ICMDB_APIS_UTIL is typically invoked from other PL/SQL API packages, from Oracle Workflow activities that drive the engineering change lifecycle, and from custom code extending ECO processing. Custom callers should invoke CREATE_LINES after a change header exists, and should call UPDATE_APPROVAL_STATUS when transitioning approval state, always checking the returned status parameters and logging x_msg_data on failure. Because these procedures are part of a released API surface, they should be called as published rather than modified, and any custom logic should be layered above them to preserve upgrade safety across 12.1.1 and 12.2.2.