Search Results hr_legislation_local




Overview
Explore in AI Chat

Overview

HR_LEGISLATION_LOCAL is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It operates as a supporting utility for the Oracle HRMS localization and legislation framework, which governs how payroll and human-resources rules vary by legislative jurisdiction (for example, United States, Canada, or other localizations). The package carries an ETRM API classification of OTHER, indicating that it is not a public, documented business API intended for direct customer invocation but rather an internal component used to install, seed, and translate legislative data during setup, cloning, and localization maintenance operations.

Its primary role centres on the installation of legislation-specific configuration — particularly United States and Canadian element and balance definitions — and on resolving derived payroll information such as element balance context. Because it writes to legislative, tax, report, and balance metadata tables, the package is central to ensuring that a newly provisioned or upgraded EBS instance receives the correct statutory configuration.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within this package:

  • INSTALL — The principal installation driver, responsible for populating legislation-level configuration records for the applicable localization during setup or upgrade.
  • INSTALL_US_NEW — A specialized variant that installs United States-specific legislative and element definitions, reflecting the periodic additions Oracle delivers for US payroll and tax structures.
  • DECODE_ELMNT_BAL_INFORMATION — Resolves or decodes balance-related information for a payroll element, supporting the mapping between element definitions and the balance types they feed.
  • TRANSLATE_US_ELE_DEV_DF — Translates United States element developer descriptive flexfield (DF) content, enabling localized or language-specific rendering of element metadata.
  • TRANSLATE_CA_ELE_DEV_DF — Performs the equivalent translation function for Canadian element developer descriptive flexfield content.

Only the procedure and function names are documented; parameter lists are not exposed in the metadata and should not be assumed.

Tables Accessed

The package reads and writes through APPS synonyms across several functional areas:

Usage Notes

HR_LEGISLATION_LOCAL is referenced by the APPS.HR_LEGISLATION package, which is the more commonly encountered legislation-handling component, and by one other tracked package. It is therefore normally invoked indirectly — during HRMS legislation installation, patching, or upgrade processing — rather than from end-user forms or concurrent programs. Custom code should not call this package directly unless replicating an Oracle-supported installation path, since its routines assume a controlled setup sequence and write to seeded legislative tables. Any diagnostic or troubleshooting activity should treat it as an internal dependency and consult Oracle support documentation before direct execution.