Search Results get_ue_mr_status_code
Overview
APPS.AHL_COMPLETIONS_PVT is a private PL/SQL package within the Oracle Enterprise Asset Management (eAM) and Complex Maintenance, Repair, and Overhaul (CMRO) product family, operating under the AHL application schema. The "PVT" API classification indicates that this is an internal, private API layer rather than a public integration interface; it is intended to be called by sibling private packages, public wrapper packages, and Oracle-maintained views rather than directly by external applications or custom code. Its principal business function is to manage the lifecycle completion of maintenance work orders, operations, and maintenance repair (MR) instances, including sign-off, deferral, closure, and reset of counter and status data associated with maintainable assets.
In EBS 12.1.1 and 12.2.2, this package forms part of the transactional backbone supporting eAM work order execution. It encapsulates the business rules that determine whether a work order or operation may be completed, records the completion and sign-off transactions, propagates completion status to master work orders and MR instances, and orchestrates related updates across visits, unit accomplishments, and material transaction records.
Key Procedures and Functions
The package exposes 22 documented procedures and functions that fall into several functional groupings.
- Completion: COMPLETE_OPERATION, COMPLETE_WORKORDER, COMPLETE_MASTER_WO, and COMPLETE_MR_INSTANCE perform the core completion transactions for individual operations, work orders, master work orders, and maintenance repair instances respectively.
- Closure and Deferral: CLOSE_WORKORDERS, CLOSE_VISIT, and DEFER_WORKORDER handle closure of work orders and visits and deferral of work orders for later execution.
- Sign-off: SIGNOFF_MR_INSTANCE records user sign-off against an MR instance, supported by validation helpers IS_SIGNOFF_DATE_OVERLAPPING and IS_SIGNOFF_UPDATE_USER.
- Status and Validation: VALIDATE_QA_STATUS, GET_MR_STATUS, GET_UE_MR_STATUS_CODE, IS_COMPLETE_ENABLED, and ARE_ALL_OPERATIONS_COMPLETE return or verify completion and quality-assurance status, determining eligibility for completion actions.
- Date Derivation: GET_DEFAULT_OP_ACTUAL_DATES, GET_OP_ACTUAL_DATES, and GET_DEFAULT_WO_ACTUAL_DATES derive actual start and end dates for operations and work orders.
- Counter Management: GET_RESET_COUNTERS and RESET_COUNTERS retrieve and reset usage counters relevant to maintenance scheduling.
Tables Accessed
The package reads and writes a broad set of APPS-synonym tables central to eAM execution. Work order and operation data reside in AHL_WORKORDERS and AHL_WORKORDER_OPERATIONS, while AHL_WORKORDER_TXNS and AHL_WORKORDER_MTL_TXNS capture transactional and material movement records generated during completion. Maintenance repair instance data is held in AHL_MR_HEADERS_B and AHL_MR_EFFECTIVITIES, with relationships and accomplishments recorded in AHL_UE_RELATIONSHIPS and AHL_UNIT_ACCOMPLISHMNTS. Unit configuration and effectivity information is sourced from AHL_UNIT_CONFIG_HEADERS and AHL_UNIT_EFFECTIVITIES_B, and deferral data from AHL_UNIT_DEFERRALS_B. Visit-level completion draws on AHL_VISITS_B and AHL_VISIT_TASKS_B. Supporting inventory and resource references include BOM_RESOURCES and MTL_LOT_NUMBERS.
Usage Notes
Because AHL_COMPLETIONS_PVT is a private API, it is not intended for direct invocation from customer-written code. It is referenced by 22 other packages and views, including AHL_PRD_WORKORDER_PUB, AHL_PRD_WORKORDER_PVT, AHL_WORKORDER_SEARCH_PUB, and AHL_OSP_ACCOMP_PVT, which act as the public-facing entry points for work order and completion processing. Several views, such as AHL_ALL_WORKORDERS_V, AHL_WORKORDERS_V, and AHL_MR_INSTANCES_V, depend on it. In practice, the package is invoked indirectly when users complete operations or work orders through eAM forms, run concurrent programs that process completions and closures, or execute Oracle-delivered public APIs that delegate to this layer. Customizations should target the appropriate public API rather than AHL_COMPLETIONS_PVT.