Search Results pay_us_user_init_dedn




Overview
Explore in AI Chat

Overview

PAY_US_USER_INIT_DEDN is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified in the ETRM repository as an OTHER API rather than a published public interface. Its name and dependency footprint identify it as a US-specific payroll utility that supports the creation and removal of user-defined initialization templates for deductions and other payroll elements. In Oracle Payroll, an element template acts as a reusable blueprint: it pre-populates the element type definition, its input values, balance feeds, iterative rules, and associated classifications so that a deduction can be created consistently across legislations and business groups. The PAY_US_USER_INIT_DEDN package provides the programmatic mechanism by which templates designated as "user init" are generated and later removed for the US legislation.

The package is a leaf-level utility rather than an end-user API. It is positioned beneath the higher-level wrapper PAY_US_DEDN_TEMPLATE_WRAPPER, which is the only other package documented as referencing it, and it in turn relies solely on SYS.STANDARD, indicating that its logic is largely expressed through declarative SQL against the payroll tables rather than through calls to other application APIs. The metadata records its status as VALID under both EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

  • CREATE_USER_INIT_TEMPLATE — Creates a user initialization template for US payroll deductions. The procedure assembles the template header and its associated element definition, input values, balance feeds, classifications, and iterative rules so that the resulting element template can be applied to generate payroll elements.
  • DELETE_USER_INIT_TEMPLATE — Removes a previously created user initialization template, reversing the records inserted by the create routine. It is typically invoked during setup revision or environment cleanup so that obsolete templates do not remain available for element creation.

Both procedures are exposed from the package specification. Parameter lists are not published in the ETRM documentation and should be verified against the live package source before use in custom code.

Tables Accessed

The documented table access reflects the full breadth of a payroll element template definition. Element definition data is held in PAY_ELEMENT_TYPES_F, PAY_ELEMENT_CLASSIFICATIONS, PAY_ELEMENT_TEMPLATES, and PAY_INPUT_VALUES_F. Balance-related configuration is drawn from PAY_BALANCE_TYPES, PAY_BALANCE_CLASSIFICATIONS, PAY_BALANCE_DIMENSIONS, PAY_BALANCE_FEEDS_F, and PAY_DEFINED_BALANCES, which together determine how the generated deduction feeds balances. Rules and formulas are sourced from PAY_ITERATIVE_RULES_F, PAY_ITERATIVE_RULES_S, FF_FORMULAS_F, and FF_GLOBALS_F. Benefit linkage is provided through BEN_BENEFIT_CLASSIFICATIONS, while FND_SESSIONS supplies session context for the creating user. These tables are referenced through APPS synonyms.

Usage Notes

PAY_US_USER_INIT_DEDN is not a form-level or concurrent-program-level API in its own right. It is invoked indirectly through PAY_US_DEDN_TEMPLATE_WRAPPER, which serves as the supported entry point for template creation and deletion in the US payroll flow. Direct calls from custom code are possible but carry risk, because the package performs multi-table inserts and deletes without the validation and error handling expected of a published API. Developers extending or troubleshooting deduction template behavior should first review the wrapper, then inspect this package to understand the underlying data operations. The SQL statements section of the package body is the authoritative source for the exact column mappings and ordering applied during template creation.