Search Results pay_input_values_pkg




Overview
Explore in AI Chat

Overview

PAY_INPUT_VALUES_PKG is the PL/SQL package body owned by the APPS schema that encapsulates the business logic governing Payroll element input values within Oracle E-Business Suite 12.1.1 and 12.2.2. Input values define the individual data fields that a payroll element exposes to users, formulas, and link definitions — for example, hours worked, rate, or amount. This package provides the server-side validation, translation handling, and DML operations that the Payroll element setup forms and related APIs depend upon. It centralizes the rules that determine whether an input value may be created, modified, or deleted, and it enforces referential integrity against element types, element links, and dependent payroll constructs such as balance types, accrual plans, backpay rules, and formula result rules. Because the object carries an API classification of OTHER, it is not a formally published public API, but it is referenced by 27 other packages in the applications schema, indicating that it functions as a shared internal utility for input value maintenance.

Key Procedures and Functions

The package exposes twenty documented procedures and functions. An initial group performs validation and diagnostic checks: VALIDATE_TRANSLATION, SET_TRANSLATION_GLOBALS, NO_DEFAULT_AT_LINK, and ELEMENT_ENTRY_NEEDS_DEFAULT verify that translation rows and default values conform to element entry requirements. A second group governs deletion eligibility: PARENT_DELETED, CANT_DELETE_ALL_INPUT_VALUES, DELETION_ALLOWED, and NO_OF_INPUT_VALUES ensure that input values cannot be removed while dependent element links or entry values exist, and that at least one input value remains. Several error-oriented helpers — DATE_EFFECTIVELY_UPDATED, NAME_NOT_UNIQUE, and MANDATORY_IN_FUTURE — detect datetrack conflicts, duplicate names, and timing problems with mandatory flags. The core DML routines are INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW, which manipulate the base and translation tables. Translation support is completed by ADD_LANGUAGE and TRANSLATE_ROW. Finally, RECREATE_DB_ITEMS rebuilds database items, and DECODE_VSET_VALUE and DECODE_VSET_MEANING resolve value set lookups.

Tables Accessed

The package reads and writes the core input value entities: PAY_INPUT_VALUES_F, PAY_INPUT_VALUES_F_TL, and PAY_INPUT_VALUES_S, together with PAY_LINK_INPUT_VALUES_F and PAY_ELEMENT_LINKS_F. Validation against the broader element model draws on PAY_ELEMENT_TYPES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_FORMULA_RESULT_RULES_F, PAY_BALANCE_TYPES, PAY_ACCRUAL_PLANS, PAY_BACKPAY_RULES, PAY_NET_CALCULATION_RULES, PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PAY_RUN_RESULTS, and PAY_RUN_RESULT_VALUES. Reference and utility data come from FND_LANGUAGES, FND_LOOKUP_VALUES, HR_LOOKUPS, HR_APPLICATION_OWNERSHIPS, PER_PAY_BASES, and PER_ABSENCE_ATTENDANCE_TYPES. Supporting PL/SQL dependencies include HR_GENERAL, HR_UTILITY, HR_CHKFMT, FF_DBI_UTILS_PKG, PAY_LINK_INPUT_VALUES_PKG, PAY_DYNDBI_CHANGES_PKG, DT_API, FND_MESSAGE, and FND_PROFILE.

Usage Notes

This package is invoked indirectly by the Payroll element and element link setup forms, by datetrack and translation processing, and by concurrent programs that regenerate database items. Custom code should treat it as an internal component rather than a supported public API, and should prefer documented element configuration APIs where available.