Search Results hr_user_dedn_drv




Overview
Explore in AI Chat

Overview

APPS.HR_USER_DEDN_DRV is a PL/SQL package in the Oracle E-Business Suite database, owned by the APPS schema and classified as VALID in both Oracle EBS 12.1.1 and 12.2.2. It supports the Oracle Payroll and Oracle Human Resources deduction and benefits infrastructure, specifically the process by which user-defined deduction templates are generated and made available for assignment to employees. Deductions in Oracle Payroll are configured as elements and balance types; a "deduction template" is a preconfigured collection of formulas and element definitions that allows a template to be copied and instantiated for a specific deduction setup, including the associated formula, balance, and input values.

In the ETRM documentation, the package is recorded with an API classification of OTHER. This means the package is not exposed as a formal public API in the technical reference manual sense; it is an internal building block invoked by higher-level routines rather than called directly by integrators.

The functional purpose of HR_USER_DEDN_DRV is to drive the insertion and validation logic required to create a deduction template entry in the payroll configuration tables. It acts as a driver routine, orchestrating reads from formula, balance type, element type, and input value definitions, and then performing the template insertion.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents one procedure or function on this package:

  • INS_DEDUCTION_TEMPLATE — Inserts a deduction template record. Its role is to create the template definition that ties a deduction element to the formulas and balance types that govern its calculation and feeding behavior. The procedure encapsulates the validation and insertion logic so that the higher-level deduction setup process does not have to write directly to the underlying configuration tables.

No parameter lists are documented in the ETRM extract, and parameter details should not be assumed. The single documented entry confirms the package is narrowly scoped to deduction template insertion rather than a broad library of deduction utilities.

Tables Accessed

The documented dependencies reference the following tables via APPS synonyms:

  • FF_FORMULAS_F — The formula definition table, holding the header record for each payroll formula. Read to resolve the formula attached to the deduction template.
  • FF_FORMULAS_S — The formula details/sub-entity table, holding the formula text and associated attributes used in calculation.
  • PAY_BALANCE_TYPES — Balance type definitions. Read to validate and reference the balances the deduction feeds or consumes.
  • PAY_ELEMENT_TYPES_F — Element type definitions, used to link the deduction template to the payroll element it will generate.
  • PAY_INPUT_VALUES_F — Input value definitions for elements, used to establish the entry values available on the generated deduction element.

The package also references SYS.STANDARD, which is a PL/SQL language dependency rather than an application table.

Usage Notes

HR_USER_DEDN_DRV is referenced by PAY_US_DEDN_TEMPLATE_WRAPPER, a United States payroll deduction template wrapper. This confirms the package is invoked indirectly through the US payroll deduction setup flow, which is exposed through the Oracle Payroll/HR forms and the related deduction template concurrent or form-driven process. The package is also self-referential, appearing in its own dependency list.

Because the API classification is OTHER, this package should be treated as internal. Custom integrators typically create deductions through the supported element and formula setup forms or through the public element entry APIs rather than calling INS_DEDUCTION_TEMPLATE directly. Direct invocation risks bypassing validation that the wrapper performs. In upgrade or customization reviews, the key consideration is the dependency chain from PAY_US_DEDN_TEMPLATE_WRAPPER to HR_USER_DEDN_DRV and onward to the FF_FORMULAS and PAY_* definitions tables, since any change to formula or element type structures can affect the insertion logic.