Search Results update_scheduling_results

Overview

The PL/SQL package body APPS.AHL_LTP_ASCP_ORDERS_PVT is a private (PVT) API within the Oracle E-Business Suite Advanced Planning and Scheduling integration layer for Oracle Enterprise Asset Management (EAM), specifically the asset scheduling and materials planning components. Its principal business function is to receive scheduling results returned from APS (Advanced Planning and Scheduling) and to write the confirmed or revised scheduled dates back into the EAM schedule materials tables. The package therefore acts as the inbound interface that reconciles APS-planning output with the scheduled material demands maintained in EBS.

The package is owned by the APPS schema and is classified as a private package, indicating that it is intended for internal consumption by other components of the AHL (Asset Lifecycle / Enterprise Asset Management) module rather than as a publicly callable integration API. It is documented as referenced by one other package, confirming its role as a subordinate utility within a larger scheduling flow.

Key Procedures and Functions

• UPDATE_SCHEDULING_RESULTS — The single documented procedure exposed by this package body. Its stated function is to update the scheduled materials records with scheduled dates originating from APS. The procedure follows the standard ETRM API convention, accepting the customary API version, initialization message list, commit, and validation level parameters, together with an inbound scheduling orders collection that carries the APS-supplied scheduling data. It returns the standard x_return_status out parameter. The procedure declares a local cursor (Check_Sched_Mat_Cur) that validates the existence of a given scheduled material row by its primary key before the update is applied, and it opens with a savepoint and API message-list initialization consistent with the EBS API framework.

Tables Accessed

• AHL_SCHEDULE_MATERIALS — The primary target of this package. The procedure reads this table to confirm that a scheduled material record exists (via the scheduled_material_id key) and then updates the schedule date columns with the values supplied by APS. This table holds the material requirements generated for asset maintenance work orders.
• PLITBLM — A standard Oracle Applications table used by the message-handling infrastructure underlying the FND_API message stack. Access to this table supports the API's message accumulation and retrieval facilities rather than any business logic.

Usage Notes

This package is not intended to be invoked directly by end users or by arbitrary custom code. It is a private interface and is normally called by the parent scheduling package that orchestrates the APS round trip — that is, the component responsible for exporting scheduling data to the advanced planner and then consuming the planner's response. In that flow, UPDATE_SCHEDULING_RESULTS is called with the collection of scheduled orders returned from APS so that the affected AHL_SCHEDULE_MATERIALS rows reflect the new committed dates.

Because the procedure adheres to the ETRM API standards, callers are expected to honor the p_commit convention: when set to FND_API.G_FALSE, the caller retains control of the transaction boundary and must commit or roll back explicitly; the procedure issues a savepoint at entry to support this behavior. Callers should also inspect x_return_status and drain the message stack when the return status indicates error or unexpected conditions.

For Oracle EBS 12.1.1 and 12.2.2, no functional difference in this package's behavior is documented; the object remains an internal APS-to-EAM scheduling update routine. Customizations should avoid modifying the package body directly and should instead extend the surrounding scheduling flow through supported extension points, since the private status of the package means its interface is not guaranteed across patches.