Search Results ahl_operation_resources_s

Overview

APPS.AHL_PP_RESRC_REQUIRE_PVT is a private (PVT) PL/SQL package body within the Oracle EBS Enterprise Asset Management / Asset Lifecycle family of modules (AHL schema prefix). It belongs to the Production Planning and resource-requirement engine that links Asset Maintenance work orders to the discrete manufacturing and Bills of Material resource definitions used during scheduling and costing. Specifically, this package encapsulates the business logic that determines what resources — departments, resource instances, units of measure, and associated capacity — are required to fulfil a maintenance work order and its operations. It is a private companion package, meaning its procedures are intended to be called by the corresponding public wrapper (typically AHL_PP_RESRC_REQUIRE_PUB) and by other internal AHL packages rather than directly by end-user forms or external integrations. The package originated around release 11i and was carried forward into 12.1.1 and 12.2.2; the embedded header comment (120.12.12010000.4, dated 2008) confirms its lineage. A search for the term total_duration typically surfaces this object because resource-requirement calculations accumulate standard operation durations across operations to derive an overall resource requirement duration, which is then compared against available capacity.

Key Procedures and Functions

ETRM documents two entry points for this package body:

• PROCESS_RESRC_REQUIRE — The principal driver procedure. It orchestrates the creation, update, and removal of resource requirements against a work order. It validates input, resolves lookup values (via the internal helper Check_Lookup_Name_Or_Id), and applies the resource-requirement rows to the AHL operation-resource tables. This is the routine invoked when a work order's resource demand must be (re)calculated.
• EXPAND_MASTER_WO_DATES — Expands or derives the date boundaries associated with a master work order so that resource requirements for child operations can be time-phased across the correct scheduling horizon. This supports duration and capacity roll-up, which is the area where total_duration values are relevant.

The source excerpt also references locally declared procedures such as Create_Resrc_Require, Update_Resrc_Require, Get_Resource_Requirement, and Remove_Resource_Requirement, which collectively implement CRUD semantics over resource requirements.

Tables Accessed

The package reads and writes across Asset Maintenance and discrete manufacturing tables. On the AHL side it uses AHL_OPERATION_RESOURCES and AHL_OPERATION_RESOURCES_S (resource requirement definitions and their translated/secure variants), AHL_WORKORDERS, AHL_WORKORDER_OPERATIONS, AHL_VISITS_B and AHL_VISIT_TASKS_B (maintenance scheduling context), AHL_WORK_ASSIGNMENTS, and AHL_WO_OPERATIONS_TXNS_S (transactional history). On the manufacturing side it references BOM_RESOURCES, BOM_DEPARTMENT_RESOURCES, and BOM_DEPT_RES_INSTANCES to obtain standard resource and capacity definitions, MTL_UNITS_OF_MEASURE for unit conversion, and WIP_DISCRETE_JOBS, WIP_OPERATIONS, and WIP_COST_TXN_INTERFACE for cost and job context. These tables supply the duration, rate, and capacity inputs needed to compute total resource requirements.

Usage Notes

Because the package is classified PVT, it is not a public API. It is referenced by seven other AHL packages and is normally reached through the public resource-requirement API or through the maintenance work-order forms when a user saves or reschedules a work order. Concurrent programs that process or cost maintenance work orders may also invoke it indirectly. Custom code should never call AHL_PP_RESRC_REQUIRE_PVT directly; developers should instead use the documented public wrapper, since private signatures can change between patch levels (12.1.1 versus 12.2.2). Debugging is controlled through AHL_DEBUG_PUB, and failures are surfaced via the standard x_return_status conventions returned by the calling public API.