Search Results create_sr_disp_link

Overview

APPS.AHL_PRD_DISP_UTIL_PVT is a private utility package within the Oracle E-Business Suite Advanced Product Catalog and product dispositioning module (AHL is the schema/application short name for the Complex Maintenance, Repair and Overhaul, or eAM/CMRO family, including disposition processing). The PVT (private) API classification indicates that this package is intended for internal use by the AHL product dispositioning framework rather than as a directly callable public interface. It provides supporting logic that complements the public AHL_PRD_DISPOSITION_PVT package, handling subsidiary operations such as resolving disposition lists, validating part-change dispositioning, materializing disposition material requirements, and linking service requests to disposition records.

The package is owned by APPS and holds a VALID status, and it sits within a layered dependency graph: it references AHL_PRD_DISPOSITION_PVT, FND_API (the standard Oracle Application Object Library API utilities), MTL_LOT_NUMBERS, and STANDARD. It is in turn referenced by the view AHL_PRD_DISPOSITIONS_V, by AHL_PRD_DISPOSITION_PVT, by its own wrapper AHL_PRD_DISP_UTIL_PVT_W, and by AHL_PRD_NONROUTINE_PVT. This dependency footprint confirms its role as a shared utility layer underpinning disposition processing screens and non-routine disposition workflows.

Key Procedures and Functions

The package exposes eight documented procedures and functions. GET_DISPOSITION_LIST returns the set of disposition definitions applicable to a given context, typically driving LOV or selection lists on disposition entry forms. GET_PART_CHANGE_DISPOSITION retrieves the disposition associated with a part change event, supporting part-change driven material handling. CREATE_DISP_MTL_REQUIREMENT creates a disposition material requirement record, translating a disposition decision into a physical material demand. GET_AVAILABLE_DISP_TYPES returns the disposition types valid for the current context. CREATE_SR_DISP_LINK establishes the association between a service request and a disposition record. GET_PRIMARY_SR_FLAG returns the flag indicating whether a service request is the primary one for the disposition. GET_WO_UNIT_ID returns the work order unit identifier associated with the dispositioned item. INSTALL_PART_CHANGE_VALID validates whether an installation part change is permitted, providing a boolean validation result consumed by callers.

These routines collectively cover the utility operations required around the main disposition API: list resolution, requirement creation, relationship linking, attribute lookup, and validation. No parameter lists are published in the ETRM metadata, and callers should rely on the wrapper package AHL_PRD_DISP_UTIL_PVT_W for any supported public access.

Tables Accessed

The package reads and writes a broad set of AHL and MTL tables through APPS synonyms. MTL_LOT_NUMBERS supplies lot and serial information needed when disposition decisions reference specific material lots. AHL_PRD_DISPOSITIONS_B and AHL_PRD_DISPOSITIONS_TL hold the base and translated disposition definitions. AHL_PRD_DISP_MTL_TXNS records disposition material transactions generated by CREATE_DISP_MTL_REQUIREMENT. AHL_PART_CHANGES and AHL_ITEM_ASSOCIATIONS_B support part-change scenarios. AHL_ITEM_GROUPS_B, AHL_MC_CONFIG_RELATIONS, AHL_MC_HEADERS_B, AHL_MC_PATH_POSITIONS, AHL_MC_PATH_POSITION_NODES, and AHL_MC_RELATIONSHIPS provide configuration and maintenance-path context used to validate and resolve dispositions. AHL_SCHEDULE_MATERIALS, AHL_VISITS_B, and AHL_VISIT_TASKS_B link disposition processing to scheduled work, visit headers, and visit tasks, enabling dispositions to be driven from visit-based service execution.

Usage Notes

Because AHL_PRD_DISP_UTIL_PVT is a PVT package, Oracle does not guarantee its signature across releases, and it should not be called directly from custom code. Supported invocation flows through AHL_PRD_DISP_DISPOSITION_PVT and the AHL_PRD_DISPOSITIONS_V view, which are used by the dispositioning forms and concurrent programs in the AHL module. Non-routine disposition processing (AHL_PRD_NONROUTINE_PVT) also depends on it. Customers extending disposition behavior should use the public wrapper AHL_PRD_DISP_UTIL_PVT_W or the public disposition API, and must validate any private dependency before patching or upgrading between EBS 12.1.1 and 12.2.2.