Search Results hr_input_values




Overview
Explore in AI Chat

Overview

The APPS.HR_INPUT_VALUES package body is a core Oracle E-Business Suite payroll construct that manages element input values — the individual data fields defined for a payroll element and supplied at the assignment, link, or element-entry level. Each payroll element (for example, a salary, bonus, or deduction) exposes one or more input values that drive formula processing. This package encapsulates the validation and persistence logic that governs how those input values behave within Oracle Payroll. It is validated and installed in the APPS schema in both EBS 12.1.1 and 12.2.2 and is classified in the ETRM as an API of type OTHER, indicating that it is an internal payroll utility package rather than a formally published public API.

The package provides the business rules that determine whether an input value entry is valid, whether it should be defaulted, whether it can be deleted or updated, and how third-party writes to input values are performed. It therefore sits behind the payroll element and input value forms used during payroll setup and processing.

Key Procedures and Functions

The ETRM documents eleven procedures and functions within this package body:

  • NAME — a package-level function returning the package name, used for diagnostic and error-reporting purposes.
  • CHK_ENTRY_DEFAULT — checks whether an input value is subject to defaulting at entry time.
  • CHK_LINK_HOT_DEFAULTS — validates "hot default" input values defined at the element link level.
  • CHK_HOT_DEFAULTS — validates hot default input values defined on the element itself.
  • CHK_DEL_INPUT_VALUES — verifies whether an input value may be deleted, enforcing referential and payroll integrity rules.
  • CHK_FIELD_UPDATE — determines whether a given input value field may be updated in the current context.
  • GET_PAY_VALUE_NAME — retrieves the display or database name associated with a payroll input value.
  • CHK_UPD_INPUT_VALUES — validates an update operation against existing input value records.
  • INS_3P_INPUT_VALUES — inserts input values on behalf of a third-party (external) process.
  • UPD_3P_INPUT_VALUES — updates input values on behalf of a third-party process.
  • DEL_3P_INPUT_VALUES — deletes input values on behalf of a third-party process.

Two private functions, HRDYNDBI and HR_UTILITY, are also referenced internally to support dynamic binding and utility validation.

Tables Accessed

The package reads and writes a broad set of payroll tables through APPS synonyms. Central to its operation are PAY_INPUT_VALUES_F, PAY_INPUT_VALUES_F_TL (the translatable input value definitions), and PAY_LINK_INPUT_VALUES_F with PAY_LINK_INPUT_VALUES_S, which hold input value definitions at the element link level. Runtime and transactional data are handled through PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_RUN_RESULTS, and PAY_RUN_RESULT_VALUES. Setup and rule tables referenced include PAY_ELEMENT_LINKS_F, PAY_FORMULA_RESULT_RULES_F, PAY_BACKPAY_RULES, PAY_ASSIGNMENT_ACTIONS, and PAY_PAYROLL_ACTIONS. Validation lookups draw on HR_LOOKUPS and PER_ABSENCE_ATTENDANCE_TYPES, while HR_BALANCES and HR_UTILITY supply balance-related and generic utility logic. DUAL is used for singleton evaluations.

Usage Notes

HR_INPUT_VALUES is not a public API and is not referenced by any database object outside the APPS schema; it is consumed internally by the payroll forms and by the 22 packages that call it. It is invoked during element and input value setup in the Payroll element forms and during payroll processing when element entries feed formula evaluation. The third-party procedures (INS_3P_INPUT_VALUES, UPD_3P_INPUT_VALUES, DEL_3P_INPUT_VALUES) exist to allow external systems to write input values through a controlled path rather than against the tables directly. Custom implementations should avoid calling this package directly; the supported interfaces are Oracle Payroll APIs such as PAY_ELEMENT_ENTRY_API, which in turn invoke the validation logic encapsulated here.