Search Results get_pseudo_enabled




Overview
Explore in AI Chat

Overview

APPS.HR_LEGISLATION is a core Oracle EBS Human Resources (HR) package that provides legislative-level infrastructure for the Oracle Payroll and HRMS data model. Its primary responsibility is to install and maintain the relationship between Oracle applications, business groups, and the legislation-specific database records that govern payroll and HR processing. In Oracle EBS 12.1.1 and 12.2.2 the package acts as a low-level "installer" and utility layer that seeds, validates, and reconciles the legislative configuration required before payroll and HR functionality can operate. It also exposes trace facilities that support diagnostic investigation of HR/payroll run processing behavior. The package status is VALID in the ETRM registry and it is owned by the APPS schema, which is consistent with its role as shared, cross-application infrastructure rather than end-user application logic.

Key Procedures and Functions

The documented API surface contains eight procedures and functions. Purpose descriptions follow the ETRM classification rather than any invented signature:

  • INSTALL — Installation entry point used to seed or configure the legislative data structures required by the HR/Payroll product set.
  • HRRUNPRC_TRACE_ON — Enables trace output for HR run processing, supporting diagnosis of payroll/HR run behavior.
  • HRRUNPRC_TRACE_OFF — Disables the HR run processing trace enabled by HRRUNPRC_TRACE_ON.
  • INSERT_HR_STU_EXCEPTIONS — Inserts setup/exception records used by HR setup data validation.
  • MUNGE_SEQUENCE — Utility that adjusts or normalizes sequence values within legislative setup data.
  • PSEUDO_SEED_DATA_CLASH — Detects or reports clashes between pseudo seed data and existing legislative rows.
  • GET_PSEUDO_ENABLED — Returns whether pseudo seed processing is enabled for the current context.

These procedures are classified as OTHER APIs, meaning they are internal utilities rather than supported public business APIs. They are not intended for direct customer invocation.

Tables Accessed

The package reads and writes a defined set of HRMS and Flexfield (FF) tables via APPS synonyms. The FF tables — FF_COMPILED_INFO_F, FF_DATABASE_ITEMS, FF_FDI_USAGES_F, FF_FORMULAS_F, FF_ROUTES, and FF_USER_ENTITIES — are the Oracle FastFormula metadata store, reflecting the tight coupling between legislation and payroll formula definitions. The FND tables FND_APPLICATION, FND_LANGUAGES, FND_LOOKUP_VALUES, and FND_PRODUCT_INSTALLATIONS supply application registration, language, lookup, and installation status context. HR tables HR_APPLICATION_OWNERSHIPS, HR_DM_DATABASES, HR_LEGISLATION_SUBGROUPS, HR_ORG_INFORMATION_TYPES, and HR_ORG_INFO_TYPES_BY_CLASS define legislative subgroupand organizational information type configuration. Together these tables allow the package to verify and seed legislative setup and keep it consistent with installed products.

Usage Notes

HR_LEGISLATION is invoked primarily during HRMS installation, patching, and upgrade activities, and by other internal packages. It is referenced by FF_DATA_DICT and by the dependent packages HR_LEGISLATION_BENEFITS, HR_LEGISLATION_ELEMENTS, and HR_LEGISLATION_LOCAL, which extend its legislative handling into benefits, payroll elements, and localization. PAY_IP_STARTUP_UTIL also depends on it, indicating involvement in payroll startup processing. Customers should not call these APIs directly from forms or custom code; they are executed by Oracle's installation and concurrent processing infrastructure, and in the case of the trace procedures, by support and diagnostic sessions.