Search Results ahl_ltp_space_assign_pvt




Overview
Explore in AI Chat

Overview

The APPS.AHL_LTP_SPACE_ASSIGN_PVT package is a private PL/SQL API belonging to the Oracle Enterprise Asset Management / Asset Lifecycle Management family of products supported by the AHL (Complex Maintenance, Repair, and Overhaul) schema. It governs the assignment of physical spaces to visits within an organization — for example, allocating a maintenance bay, hangar, dock, or workshop slot to a scheduled visit. The package encapsulates the business rules that validate space availability, check capability and department constraints, and persist the resulting assignments. Because it is classified as a private (PVT) package rather than a public API, it is not intended for direct invocation by external or customer code; it is consumed internally by other AHL packages and by the forms and concurrent processes that drive visit scheduling. The header source, dated 2003, uses AUTHID CURRENT_USER and defines a SPACE_ASSIGNMENT_REC record type mirroring the columns of the AHL_SPACE_ASSIGNMENTS entity, including the standard WHO columns and a fifteen-attribute descriptive flexfield block.

Key Procedures and Functions

Six documented procedures comprise the package's functional surface, all centred on the lifecycle of a space assignment:

  • CREATE_SPACE_ASSIGNMENT — Creates a new space assignment linking a visit to a specific space, honouring the standard API parameter conventions (p_api_version, p_init_msg_list, p_commit, p_validation_level, p_module_type) and returning x_return_status.
  • UPDATE_SPACE_ASSIGNMENT — Modifies an existing assignment, for example to move a visit to a different space or to refresh assignment attributes.
  • DELETE_SPACE_ASSIGNMENT — Removes an assignment, releasing the space for reuse.
  • SCHEDULE_VISIT — Drives the scheduling action that places a visit into the resource and space schedule.
  • UNSCHEDULE_VISIT — Reverses scheduling, unscheduling the visit and freeing related space commitments.
  • VALIDATE_SPACES_WITH_VISIT — Performs validation between candidate spaces and a visit, confirming that the space satisfies the visit's requirements before assignment.

No parameter lists beyond the documented standard conventions are asserted here; the source excerpt confirms only the standard IN and OUT parameters.

Tables Accessed

The package reads and writes through APPS synonyms. Core transactional tables include AHL_SPACE_ASSIGNMENTS and its _S shadow table, AHL_SPACES_B, AHL_VISITS_B, and AHL_SPACE_CAPABILITIES (used during validation to confirm a space can support the visit). AHL_SPACE_UNAVAILABLE_B is consulted to detect blackout periods. AHL_DEPARTMENT_SHIFTS, BOM_DEPARTMENTS, and HR_ALL_ORGANIZATION_UNITS supply organisational and shift context. DUAL supports scalar queries, and PLITBLM is used for bulk processing of identifier collections.

Usage Notes

Being a PVT package, AHL_LTP_SPACE_ASSIGN_PVT is invoked indirectly — typically from the AHL visit scheduling forms, from concurrent programs that process visit scheduling, and from the two documented packages that reference it. Customisations should call the corresponding public API rather than this package directly, as its signature and internal logic may change between releases without notice. In the context of the search term "lsc territory switcher," this package is unrelated to territory switching; it belongs strictly to the LTP (Long Term Planning) space-assignment domain within AHL.