Search Results input_value_change

Overview

APPS.PAY_DYNDBI_CHANGES_PKG is a PL/SQL package body in the Oracle E-Business Suite Payroll (PAY) schema whose remit is the management of pending dynamic database item (DBI) changes. A dynamic database item is a payroll element input value whose value is derived at runtime from a database query rather than being entered or calculated conventionally. When an administrator reconfigures the underlying definition of such an item — for example by altering the element's type, the associated balance type, the input value itself, or a balance dimension — the affected definitions must be reconciled before payroll processing can rely on them. PAY_DYNDBI_CHANGES_PKG performs that reconciliation, staging the required changes in the PAY_DYNDBI_CHANGES table and subsequently applying them to the operative definitions held in PAY_DEFINED_BALANCES and PAY_INPUT_VALUES_F.

Key Procedures and Functions

The documented interface of the package comprises eight procedures, organised as four functional pairs plus their deletion counterparts.

• INSERT_ROW — records a single change request in the change tracking table, establishing the unit of work that the remaining routines consume.
• INSERT_ROWS — the bulk equivalent, registering multiple change requests in a single invocation, which is the expected path for a mass reconfiguration of dynamic database items.
• ELEMENT_TYPE_CHANGE — handles the reconciliation required when the element type associated with a dynamic database item is altered.
• BALANCE_TYPE_CHANGE — processes changes to the balance type underlying a dynamic database item, ensuring the balance feeding the item remains consistent with its definition.
• INPUT_VALUE_CHANGE — applies amendments to the input value definition used by the dynamic database item, updating the input value record accordingly.
• BALANCE_DIMENSION_CHANGE — manages changes to the balance dimension referenced by the dynamic database item, which governs the level at which the balance is accumulated.
• DELETE_ROW — removes an individual staged change record, typically once the change has been applied or has been cancelled.
• DELETE_ROWS — the bulk deletion counterpart, clearing multiple staged records in one call.

Tables Accessed

The dependency metadata identifies PAY_DYNDBI_CHANGES as the central working table — the transient store of pending modifications that the insertion, change and deletion routines populate and purge. PAY_DEFINED_BALANCES is the repository of defined balance records that must be kept aligned when balance type or dimension changes are applied. PAY_INPUT_VALUES_F holds the input value definitions referenced by dynamic database items and is updated by the input value change routine. DUAL is referenced for single-row PL/SQL evaluations, and DBMS_SQL indicates that the package constructs and executes dynamic SQL at runtime — consistent with the need to rebuild database item queries whose column and table references vary with the change being applied. PLITBLM and STANDARD are standard PL/SQL dependencies. The metadata records that the package references PAY_DYNDBI_CHANGES_PKG itself, and that it is not referenced by any other database object, although the documented interface lists five dependent packages elsewhere in the reference set.

Usage Notes

Because the object is an internal payroll utility rather than a public API, it is not intended for direct invocation from forms or concurrent programs by end users. It is typically driven by the Oracle Payroll dynamic database item maintenance flow, where the administrator's configuration change on a dynamic database item causes the change to be captured and the corresponding reconciliation routine to run. Custom code that needs to manipulate dynamic database item definitions should treat the package as internal and rely on the supported Payroll APIs instead. In Oracle EBS 12.1.1 and 12.2.2 the package body is shipped with a VALID status in the APPS schema; its correctness is prerequisite to payroll runs that depend on dynamic database items resolving to accurate, current values.