Search Results ahl_prod_class

Overview

APPS.AHL_UMP_UF_PUB is the public PL/SQL interface package for processing utilization forecasts within the Oracle E-Business Suite Asset Lifecycle Management (AHL) product family. Its documented purpose is to process utilization forecast data for a Product Classification node, item, unit, or item instance, supporting the creation, modification, or deletion of utilization forecast records. The package is registered with a public API classification (PUB) and carries the display name "Utilization Forecast," with an active lifecycle status. Its ETRM metadata associates it with the business entity AHL_PROD_CLASS, which is directly relevant to searches such as "ahl_prod_class." The package is owned by APPS and is available in both Oracle EBS 12.1.1 and 12.2.2 environments.

Functionally, the package acts as a controlled entry point for external callers — forms, concurrent programs, and custom integrations — that need to persist utilization forecast header and detail information against items or product classification structures without directly manipulating the underlying AHL tables.

Key Procedures and Functions

ETRM 12.2.2 documents a single public procedure within this package:

• PROCESS_UTILIZATION_FORECAST — The primary public interface for submitting utilization forecast data. Given a utilization forecast header record and an associated table of detail records, the procedure validates the supplied data and performs the appropriate insert or update against the utilization forecast information. The documented source header comments indicate that it also accommodates deletion of utilization forecasts.

The procedure follows Oracle EBS API conventions, exposing the standard IN parameters p_api_version, p_init_msg_list, p_commit, and p_validation_level, together with the standard OUT parameters x_return_status, x_msg_count, and x_msg_data. It additionally accepts p_module_type, which identifies the front-end form interface; the documented default is 'JSP', and when this value is supplied the API clears all internal ID columns and performs validation based on the descriptive values from which IDs would otherwise be derived. The header and detail payloads are passed as IN OUT parameters using the private package types AHL_UMP_UF_PVT.uf_header_rec_type and AHL_UMP_UF_PVT.uf_detail_tbl_type, both of which are documented as required.

Tables Accessed

The ETRM metadata for AHL_UMP_UF_PUB lists no tables referenced through APPS synonyms, and the package is recorded as referenced by zero other packages. This indicates that the public package is a thin wrapper: the actual insert, update, and delete operations against the utilization forecast tables are performed by the companion private package AHL_UMP_UF_PVT, which the public procedure delegates to. Consumers should therefore treat AHL_UMP_UF_PUB as the supported interface layer rather than querying or modifying forecast tables directly.

Usage Notes

AHL_UMP_UF_PUB is typically invoked from the Oracle EBS Utilization Forecast forms in the Asset Lifecycle Management module, where the JSP-based module type drives ID resolution and validation behavior. Custom code and integrations should call PROCESS_UTILIZATION_FORECAST following standard EBS API invocation patterns: initialize the API version, honor the message list and commit flags, populate the header and detail record structures, and inspect x_return_status and the message stack before committing. Because row-level locking and concurrency control are handled internally by the private layer, callers should always check the return status rather than assuming success, and should avoid mixing direct DML on AHL utilization forecast tables with calls to this API. Coverage in ETRM is limited to the single documented procedure, so developers seeking additional entry points should review AHL_UMP_UF_PVT, which is not part of the supported public surface.