Search Results over_70_check




Overview
Explore in AI Chat

Overview

APPS.HR_DISCOVERER is a PL/SQL package within the Oracle E-Business Suite Human Resources (HR) module. It belongs to the Oracle HRMS date-tracking and eligibility engine commonly associated with Oracle Discoverer-based HR reporting and legislative compliance checks. The package is declared with AUTHID CURRENT_USER, meaning its unqualified references resolve under the privileges of the invoking schema rather than the package owner, a characteristic intended to support controlled execution across reporting and analytical interfaces. The header source artifact (hrdiscov.pkh) dates to Release 11.5.3 vintage and remains shipped through EBS 12.1.1 and 12.2.2.

Its primary business purpose is to compute derived HR attributes — continuous service duration, statutory age-threshold screening, and end-date validation — and to retrieve actual-versus-budgeted workforce costing values for a given organizational and assignment context. These computations support workforce analysis, statutory reporting (for example, retirement-age flagging), and budget reconciliation in HR reporting tooling.

Key Procedures and Functions

  • TIME_IN — Returns a numeric value representing time-in-service or elapsed assignment duration, derived from the supplied assignment identifier and a mode indicator, with an optional termination flag. It is the package's core service-tenure computation routine.
  • OVER_70_CHECK — Returns a numeric indicator used to test whether a given date of birth breaches the seventy-year age threshold. It is defined WNDS (Write No Database State), confirming that it performs pure computation without modifying database state.
  • CHECK_END_DATE — Accepts an end date and returns a validated end date, applying HR date-validation rules. It is declared with PRAGMA RESTRICT_REFERENCES (WNDS, WNPS), making it callable from SQL and from constrained contexts such as function-based indexes.
  • GET_ACTUAL_BUDGET_VALUES — Returns a numeric actual or budgeted value for a combination of business unit, business group, organization, job, position, grade, and a start/end date range, with an input actual-value parameter. It supports workforce cost and establishment reconciliation reporting.

Tables Accessed

  • PER_ASSIGNMENT_STATUS_TYPES — Referenced via an APPS synonym to resolve assignment status classifications, which govern which assignments are considered active or eligible during time-in-service and status-derived calculations.
  • PER_PERIODS_OF_SERVICE — The core periods-of-service table, used to derive service start and end boundaries that underpin TIME_IN and CHECK_END_DATE processing.

Usage Notes

HR_DISCOVERER is best understood as a helper library for HR reporting and analytical surfaces — the "discovery tool" layer of Oracle HRMS. It is referenced by 21 other packages in the APPS schema, indicating that it is invoked indirectly through higher-level HR business logic rather than being exposed to end users directly. Typical call sites include Discoverer worksheet calculations, HRMS concurrent programs that render workforce metrics, and custom PL/SQL that needs standardized service-duration or age-eligibility results.

Because TIME_IN and GET_ACTUAL_BUDGET_VALUES are declared without RESTRICT_REFERENCES pragmas (an earlier generation's pragma line is commented out), they should not be called from SQL statements where side effects are restricted; call them from PL/SQL instead. CHECK_END_DATE and OVER_70_CHECK carry pragmas and are safe in SQL context. As with all APPS-schema packages, customers should treat HR_DISCOVERER as internal Oracle API and avoid modifying it.