Search Results process_sr_mr_associations

Overview

APPS.AHL_UMP_SR_GRP is a Group Hook API package body in the Oracle E-Business Suite Discrete Manufacturing/Enterprise Asset Management family. It serves as a public entry point for Service Request post-insert internal hooks, enabling Oracle's Unit Maintenance Plans (UMP) functionality to respond automatically when a Service Request is created. The package acts as a thin organizational wrapper: it exposes public procedures that delegate substantive business logic to the corresponding private API, specifically AHL_UMP_SR_PVT, and manages the FND_LOG instrumentation and FND_API return-status conventions characteristic of Oracle's public API framework. In this sense, AHL_UMP_SR_GRP is best understood as the "Group" (GRP) classification counterpart to a "Private" (PVT) package — it validates entry conditions, emits debug logging, initializes return status, and hands off processing to the private layer.

Key Procedures and Functions

• CREATE_SR_UNIT_EFFECTIVITY — Group Hook API that creates a Service Request type unit effectivity record. It is called by the CMRO type Service Request as a Post Insert Internal hook. The procedure retrieves Service Request details through CS_SERVICEREQUEST_PVT.USER_HOOKS_REC and delegates the actual effectivity creation to AHL_UMP_SR_PVT.Create_SR_Unit_Effectivity, returning the outcome via an OUT return-status parameter.
• PROCESS_SR_UPDATES — Documented public procedure that handles Service Request update processing for UMP integration, allowing the unit maintenance plan logic to react to changes on an existing Service Request.
• PROCESS_SR_MR_ASSOCIATIONS — Documented public procedure that processes associations between Service Requests and Maintenance/Repair (MR) records, ensuring the UMP structure reflects the linkage when such associations are established.

Tables Accessed

The ETRM metadata documents no direct table references for this package body. This is consistent with its role as a delegation layer: all table access occurs within AHL_UMP_SR_PVT and the underlying AHL unit maintenance plan schema objects. The only data structure explicitly referenced in the source is CS_SERVICEREQUEST_PVT.USER_HOOKS_REC, a PL/SQL record populated by the Service Request framework that carries the Service Request context into the hook. Because the package relies on APPS synonyms indirectly through the private API, no direct base-table dependencies are recorded against AHL_UMP_SR_GRP itself.

Usage Notes

AHL_UMP_SR_GRP is not intended to be invoked directly by end users. Its primary execution path is through the Service Request internal hook mechanism: when a CMRO type Service Request is inserted, the Service framework calls Create_SR_Unit_Effectivity as a post-insert hook, at which point the package calls the private API to build the unit effectivity record. The ETRM metadata records zero dependent packages, reflecting its position as a leaf-level hook entry point rather than a shared utility. Customizations and extensions should not modify this package; instead, customers should extend hooks through the supported Service Request hook framework or call AHL_UMP_SR_PVT directly where documented. Debug output is controlled through FND_LOG using the G_CURRENT_RUNTIME_LEVEL threshold and the G_LOG_PREFIX 'ahl.plsql.AHL_UMP_SR_GRP', so tracing can be enabled at PROCEDURE and EVENT levels to diagnose hook firing and return status during troubleshooting.