Results for “delete_revised_item”
5 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.ENG_CANCEL_ECO package is an engineering change management utility within Oracle E-Business Suite that supports the cancellation and cleanup of Engineering Change Orders (ECOs) and their associated revised structure records. In the Oracle EBS 12.1.1 and 12.2.2 releases, engineering change orders drive revisions to items, bills of material, routings, and related engineering data. When an ECO is abandoned, backed out, or must be removed before release, the revised item, component, and operation records staged by the ECO workflow require controlled deletion. ENG_CANCEL_ECO centralizes this logic, providing a single API surface through which ECO cancellation and the deletion of revised/pending structure rows are performed.
The package is declared AUTHID CURRENT_USER, meaning that it executes with the privileges of the calling schema rather than the defining owner. The header ($Header: ENGCNCLS.pls 120.1.12020000.2) indicates a shipping production file, with later bug fixes incorporated for revised-item deletion and pending-structure cleanup.
Key Procedures and Functions
- CANCEL_ECO — Cancels an engineering change order for a given organization and change order number, recording the acting user and login context.
- CANCEL_REVISED_ITEM — Cancels a specific revised item associated with a bill sequence and change order, accepting the revised item sequence identifier and user context.
- CANCEL_REVISED_COMPONENT — Cancels an individual revised component record, taking the component sequence identifier, user, login, and a comment.
- CHANGE_ATT_STATUS — Updates the status of attachment changes tied to an engineering change, accepting the change identifier and user context.
- DELETE_REVISED_ITEM — Added under bug 7659653, this procedure removes a revised item record identified by its revised item sequence, providing the deletion mechanism that users commonly reference when searching for delete_revised_item.
- DELETE_PENDING_STRUCTURE — Added under bug 8442146, removes pending structure rows associated with a revised item sequence.
Parameter lists are intentionally not reproduced here; only the documented signatures exist in the package specification.
Tables Accessed
Through APPS synonyms, the package reads and writes engineering and manufacturing structures. The primary engineering tables are ENG_ENGINEERING_CHANGES, ENG_REVISED_ITEMS, ENG_REVISED_COMPONENTS, ENG_REVISED_OPERATIONS, and ENG_ATTACHMENT_CHANGES, which hold the ECO and its staged revisions. Structure and routing tables include BOM_STRUCTURES_B, BOM_COMPONENTS_B, BOM_SUBSTITUTE_COMPONENTS, BOM_REFERENCE_DESIGNATORS, BOM_OPERATIONAL_ROUTINGS, BOM_OPERATION_SEQUENCES, BOM_OPERATION_RESOURCES, and BOM_SUB_OPERATION_RESOURCES. Item master data is read from EGO_MTL_SY_ITEMS_EXT_B and EGO_MTL_SY_ITEMS_EXT_TL. These accesses enforce referential integrity when revised items, components, operations, and pending structure rows are removed.
Usage Notes
ENG_CANCEL_ECO is typically invoked indirectly through the Oracle Engineering and Bills of Material forms during ECO cancellation and revised-item deletion actions, and by concurrent programs or workflow background processes that reconcile ECO state. The presence of user_id and login parameters confirms it is intended to be called within an authenticated Forms or concurrent session context that already establishes organization and user identity.
Because the package is classified as a released EBS API (OTHER), custom code and extensions may call DELETE_REVISED_ITEM and related procedures directly. Callers must supply valid revised item or component sequence identifiers, ensure the ECO is in a cancellable state, and commit or roll back the transaction explicitly, as the package performs DML without autonomous transaction control. The package is referenced by two other packages, reflecting its use as a shared low-level utility in the engineering change dependency chain.
-
PACKAGE: APPS.ENG_CANCEL_ECO 12.2.2
-
PACKAGE: APPS.ENG_CANCEL_ECO 12.2.2