Search Results date_track

Overview

HR_LOCATION_API is the Oracle Application Object Library (APPS) PL/SQL package responsible for the creation, maintenance, and removal of HR location records within Oracle E-Business Suite. Locations represent physical or logical sites used across HR, payroll, inventory, purchasing, and legal-entity processing. The package provides the supported programmatic interface for inserting and updating rows in the HR_LOCATIONS tables, thereby centralizing business-rule validation, key-flexfield and descriptive-flexfield handling, multi-lingual (translated) address data, and the association of locations with legal addresses. In Oracle EBS 12.1.x and 12.2.x the object is shipped with status VALID and is classified by ETRM as an API, indicating that it is intended for supported external invocation rather than internal-only use. Because so many downstream products depend on a consistent, validated location record, HR_LOCATION_API acts as a controlled gateway that protects data integrity for all consumers of location information.

Key Procedures and Functions

The documented interface comprises eight procedures. They fall into three functional groups.

• Core location maintenance — CREATE_LOCATION and UPDATE_LOCATION perform the primary insertion and modification of location records, including address, name, and associated attributes. DELETE_LOCATION removes an existing location record, applying the package's validation to determine whether the record may be deleted.
• Legal address handling — CREATE_LOCATION_LEGAL_ADR and UPDATE_LOCATION_LEGAL_ADR create and maintain the legal-address representation of a location. ENABLE_LOCATION_LEGAL_ADR and DISABLE_LOCATION_LEGAL_ADR toggle whether a location participates in legal-address processing, which is relevant to legal-entity and tax-reporting configurations.
• Translation support — SET_TRANSLATION_GLOBALS establishes the global context used when creating or updating translated (multi-language) location information in the TL table.

No parameter lists are enumerated in the source metadata; callers should consult the packaged specification for the current signature applicable to their release.

Tables Accessed

The package operates against two documented tables, referenced through APPS synonyms:

• HR_LOCATIONS_ALL — the base table holding the operational location record, including address, name, and the location's identifying attributes. CREATE_LOCATION, UPDATE_LOCATION, and DELETE_LOCATION read and write this table.
• HR_LOCATIONS_ALL_TL — the translation table that stores language-specific versions of descriptive and address information. Translation procedures and SET_TRANSLATION_GLOBALS interact with this table to maintain multi-lingual location content.

Together these two tables constitute the location master data managed by the API.

Usage Notes

HR_LOCATION_API is the recommended entry point whenever a location must be created, changed, or removed programmatically. It is typically invoked from:

• Oracle Forms — the standard HR location form and other forms that maintain location data call the API rather than performing direct DML.
• Concurrent programs and data loaders — the package is referenced by thirteen dependent packages, including HRDPP_CREATE_LOCATION, HRDPP_UPDATE_LOCATION, POR_LOAD_LOCATION, HR_IN_LOCATION_API, and CSP_SHIP_TO_ADDRESS_PVT, indicating use in data-pump, purchasing, and shipping-address processes.
• Custom code — customer extensions should call the API, not the base tables, so that business rules, flexfield derivation, and translation handling remain consistent with Oracle-supplied processing.

Callers should supply a valid session context (including the effective date and business group) as required by the underlying HR_API layer, since HR_LOCATION_API depends on APPS.HR_API and SYS.STANDARD. Because the package is classified as an API and remains VALID in both 12.1.1 and 12.2.2, it is a stable integration point across these releases, though the 12.2 online-patching architecture does not alter its documented calling model.