Search Results get_res_transacted_hours
Overview
APPS.AHL_PRD_UTIL_PKG is a utility and helper package within the Oracle EBS Enterprise Asset Management (eAM) module, specifically supporting the Complex Maintenance, Repair, and Overhaul (CMRO) Execution module. The package header (AHLUPRDS.pls, version 120.7) identifies its purpose as providing shared validation, eligibility, and calculation routines consumed throughout the CMRO execution flow — work order processing, operation and resource tracking, unit locking, material status verification, and role-based access checks. It is an OTHER-classified API rather than a formal public interface, meaning it is intended primarily for internal use by other eAM/CMRO packages and forms rather than as a standalone integration point. The package exposes 25 documented procedures and functions and is referenced by 20 other packages, confirming its role as a foundational dependency layer in the CMRO technology stack. It is unchanged in its core behavior across 12.1.1 and 12.2.2, as the source header dates to 2007 and the object remains a standard APPS-owned synonym-resolved package.
Key Procedures and Functions
The documented entry points fall into three functional groups.
- Validation routines: VALIDATE_LOCATORS verifies that a locator belongs to a given organization and subinventory. VALIDATE_CONDITION and VALIDATE_REASON check the validity of condition and reason references. VALIDATE_MATERIAL_STATUS confirms that a material status is permitted for an organization, subinventory, and condition combination. Each returns a standard return status and message data.
- Eligibility predicates: IS_UNIT_LOCKED determines whether a unit (identified by work order, MR, visit, or item instance) is locked. IS_WO_UPDATABLE, IS_OP_UPDATABLE, IS_WO_COMPLETABLE, IS_WO_CANCEL_ALLOWED, and IS_RESTXN_ALLOWED return FND_API.G_TRUE/G_FALSE flags governing whether a work order, operation, or resource transaction may proceed. IS_MR_QA_ENABLED, IS_PARTCHANGE_ENABLED, and ISDELASG_ENABLED test whether specific CMRO features are enabled.
- Calculation and date routines: GET_OP_TOTALHOURS_ASSIGNED, GET_RES_TOTALHOURS_ASSIGNED, GET_OP_TRANSACTED_HOURS, and GET_RES_TRANSACTED_HOURS aggregate assigned and transacted hours at operation and resource level. GET_OP_ASSIGNED_START_DATE and GET_OP_ASSIGNED_END_DATE return scheduled operation dates. HR_TO_DURATION converts an hours value into a duration representation.
Tables Accessed
The package reads and writes across CMRO and shared logistics tables via APPS synonyms. AHL_WORKORDERS, AHL_WORKORDER_OPERATIONS, AHL_WORK_ASSIGNMENTS, AHL_OPERATION_RESOURCES, and AHL_RT_OPER_RESOURCES supply work order, operation, assignment, and resource-transaction data used by the eligibility and hour-calculation routines. AHL_RESOURCES and AHL_RESOURCE_MAPPINGS resolve resource definitions. AHL_MR_HEADERS_B, AHL_VISITS_B, AHL_VISIT_TASKS_B, AHL_UNIT_CONFIG_HEADERS, and AHL_UNIT_EFFECTIVITIES_B support unit, visit, and configuration validation for the locking and locator checks. MTL_SECONDARY_INVENTORIES and MTL_MATERIAL_STATUSES are referenced by VALIDATE_LOCATORS and VALIDATE_MATERIAL_STATUS for subinventory and material status validation. BOM_RESOURCES provides bill-of-material resource context.
Usage Notes
AHL_PRD_UTIL_PKG is invoked internally by CMRO execution packages rather than directly by end users. Forms in the eAM/CMRO responsibility call the parent packages that in turn invoke these helpers to validate user input, enforce work order and operation state rules, and compute displayed hours and dates. Concurrent programs processing work orders, resource transactions, and visit tasks rely on the eligibility predicates to gate processing. Because the package uses NOCOPY OUT parameters for return status and message data, callers must follow the standard FND_API error-handling convention, inspecting X_RETURN_STATUS before consuming X_MSG_DATA. Custom code extending CMRO should treat this package as a private utility and, where possible, call the formally documented public APIs of the parent packages instead of invoking AHL_PRD_UTIL_PKG directly, since signature changes are governed only by Oracle's internal versioning of AHLUPRDS.pls.