Search Results ahl_ltp_reqst_matrl_pvt




Overview
Explore in AI Chat

Overview

APPS.AHL_LTP_REQST_MATRL_PUB is a public PL/SQL package within the Oracle Enterprise Asset Management (eAM) / Maintenance Management product family, specifically belonging to the AHL (Asset Health and Lifecycle) module schema. The AHL application underpins Oracle's Enterprise Asset Management and Complex Maintenance, Repair, and Overhaul (CMRO) functionality. The "LTP" segment of the package name refers to the Long Term Planning (LTP) feature set, which supports strategic planning of material requirements across maintenance and overhaul activities. The "REQST_MATRL" segment denotes "Requested Materials," indicating that the package handles the creation, processing, and update of material requirement records generated during long-term planning simulations and schedules.

The package carries a PUB (public) API classification, which signifies that it is exposed for external consumption by other application modules, forms, or customer extensions. Its public API designation contrasts it with its companion private package, AHL_LTP_REQST_MATRL_PVT, which contains the internal implementation logic and is not intended for direct invocation. The package holds a VALID status in the ETRM 12.2.2 metadata, confirming that it compiles cleanly and is operational in the environment.

Key Procedures and Functions

The package exposes two documented procedures, both central to the processing of long-term planning material requirements:

  • UPDATE_PLANNED_MATERIALS — This procedure is responsible for applying changes to existing planned material requirement records. It supports modifications to material quantities, dates, or other attributes associated with a planning scenario, allowing planners or upstream processes to revise the material demand picture reflected in the LTP records.
  • PROCESS_PLANNED_MATERIALS — This procedure drives the processing of planned material requirements, typically transforming or validating them in preparation for downstream consumption. It serves as the engine that moves material requirement data through the planning lifecycle, potentially creating or updating the persistent records that represent requested materials.

Both procedures follow the universal Oracle EBS API conventions inherited from FND_API, including standardized parameter patterns for return status, error messaging, and initialization of the API context.

Tables Accessed

The package accesses the table synonym PLITBLM, which is referenced through APPS-owned synonym resolution. In the AHL schema, PLITBLM corresponds to the base table storing planned material line item details used by long-term planning. The package reads from and writes to this table to persist planned material requirement rows, updating quantities and processing states as the planning workflow progresses. It is through PLITBLM that the procedures connect the planning simulation output to the tangible material demand records visible to planners and downstream procurement or inventory processes.

Usage Notes

APPS.AHL_LTP_REQST_MATRL_PUB is invoked programmatically rather than through direct user interaction. The ETRM dependency data shows it is referenced by three other packages: AHL_LTP_REQST_MATRL_PUB_W, which is the standard Oracle EBS wrapper package generated to expose the API to non-PL/SQL callers such as Forms or concurrent programs; AHL_LTP_REQST_MATRL_PVT, the private implementation package; and via those, higher-level LTP orchestration logic. In practice, the package is triggered during long-term planning runs, when material requirements for maintenance or overhaul work orders are generated or recalculated, and when planners adjust planned material values through the relevant eAM planning forms or concurrent processes. Custom integrations should invoke the public procedures through the wrapper package and adhere to the standard FND_API return-status handling to ensure error propagation is consistent with Oracle's supported extension patterns.