Search Results hr_loc_del




Overview
Explore in AI Chat

Overview

HR_LOC_DEL is an internal Oracle E-Business Suite package owned by the APPS schema that supports deletion processing for HR location records. In Oracle EBS 12.1.1 and 12.2.2, locations are defined and maintained through the HR_LOCATIONS_ALL table, and the Location form and the HR_LOCATION_API package layer provide the supported interfaces for creating and updating those rows. HR_LOC_DEL exists beneath that layer to perform the physical removal of location data when a location record is deleted. Its role is therefore narrowly scoped: it encapsulates the delete-time logic required to keep the location model consistent, rather than providing the general-purpose create and update functionality handled by HR_LOCATION_API.

The package is documented in ETRM with a status of VALID. Its dependency metadata identifies a reference to HR_LOC_SHD, the shadow (history/audit) table associated with HR locations, indicating that deletion activity is coordinated with the audit shadow table, and a dependency on the SYS.STANDARD package for standard PL/SQL support. It is referenced by HR_LOCATION_API and by itself, confirming that the public location API delegates deletion work to this package.

Key Procedures and Functions

Five documented program units are associated with HR_LOC_DEL: DELETE_DML, PRE_DELETE, POST_DELETE, and DEL.

  • PRE_DELETE — Performs the preparatory steps that must occur before the location row is physically removed. This typically includes validation and any setup needed so that dependent or audit processing can complete correctly.
  • DELETE_DML — Contains the actual DML operation against the location table, executing the delete of the target location record.
  • POST_DELETE — Handles processing that must follow the delete, such as cleanup or propagation of the deletion to associated structures.
  • DEL — The coordinating entry point that drives the deletion sequence, invoking the pre-delete, DML, and post-delete phases in the appropriate order.

Parameter lists are not published in the available metadata; callers should determine signatures from the package specification in the target environment rather than assuming argument order or optionality.

Tables Accessed

The documented table reference for HR_LOC_DEL is HR_LOCATIONS_ALL, accessed through APPS synonyms. HR_LOCATIONS_ALL is the base table holding location definitions, including address, shipping, receiving, and inventory-related attributes, and it is the table from which the delete occurs. The dependency listing also shows a reference to HR_LOC_SHD, the shadow table used for auditing and tracking changes to location records. Coordination with HR_LOC_SHD ensures that delete activity is reflected in the location audit trail, preserving historical change information even after the operative row is removed.

Usage Notes

HR_LOC_DEL is not intended to be called directly by end users or by custom code as a primary interface. The documented dependency shows that HR_LOCATION_API references HR_LOC_DEL, meaning the supported path for location maintenance is through HR_LOCATION_API, which in turn invokes this package for delete operations. In a standard EBS 12.1.1 or 12.2.2 environment, deletions of locations surface through the Location form and through the API layer; the delete-time hooks in HR_LOC_DEL run as part of that flow. Because the package touches HR_LOCATIONS_ALL directly with DML and interacts with the location shadow table, custom development that bypasses HR_LOCATION_API and calls HR_LOC_DEL or performs direct SQL on HR_LOCATIONS_ALL risks leaving audit data, foreign-key dependents, or application-level validations inconsistent. Customizations should invoke the public API, and any direct use of HR_LOC_DEL should be treated as an unsupported, high-risk operation requiring explicit review of dependent objects such as inventory and shipping references.