Search Results pay_jp_balance_view_pkg




Overview
Explore in AI Chat

Overview

PAY_JP_BALANCE_VIEW_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that serves as the balance aggregation and view-building engine for the Oracle Payroll Japanese localization (Payroll JP). Its principal business function is to consolidate payroll balance results — derived from defined balances, balance dimensions, payroll actions, assignment actions, and time periods — into queryable structures that expose employee-level, period-level, and dimension-level balance information for the Japanese payroll statutory reporting requirements. The package is classified as OTHER in the ETRM registry, indicating that it is not published as an open public API and is intended for internal consumption by dependent views and localization logic rather than direct customer invocation.

Key Procedures and Functions

The ETRM documentation records a single documented procedure or function: GET_VALUE (the metadata note of "4 total" reflects overloads or related entries under the same name rather than four distinctly named callables). GET_VALUE is the accessor routine through which dependent database views retrieve a computed balance value for a given combination of assignment, balance, dimension, and time period context. Because the package is designed to feed views rather than applications, GET_VALUE encapsulates the lookup and aggregation logic so that each calling view does not need to duplicate the balance-derivation rules.

No parameter lists are documented in the ETRM registry, and none should be assumed. Consumers interact with this package almost exclusively indirectly through the views that wrap GET_VALUE.

Tables Accessed

The package reads from six APPS tables, each accessed through APPS synonyms. These tables represent the standard Oracle Payroll and HR balance model, with a Japanese localization focus:

  • PAY_DEFINED_BALANCES — defines the balance identifiers and their calculation rules that the package resolves when returning a value.
  • PAY_BALANCE_DIMENSIONS — supplies the dimensional context (for example, assignment-level or period-level aggregation) against which balances are calculated.
  • PER_TIME_PERIODS — provides the effective period boundaries used to constrain balance lookups to the correct payroll period.
  • PAY_PAYROLL_ACTIONS — identifies the payroll run actions whose results are being summarized.
  • PAY_ASSIGNMENT_ACTIONS — links individual assignment processing results to the relevant payroll action and period.
  • PER_ALL_ASSIGNMENTS_F — the dated assignment record supplying the employee-assignment context for the returned value.

These tables are read, not modified; the package performs no DML against them per the documented dependency information.

Usage Notes

PAY_JP_BALANCE_VIEW_PKG is referenced by three documented objects: the views PAY_JP_BAL_MATRIX_BY_ACT_V, PAY_JP_BAL_MATRIX_BY_DATE_V, and PAY_JP_PAYJPDMW_VALUES_V. These views present Japanese payroll balance matrices sliced respectively by payroll action and by date, plus a values view used in statutory data management (DMW) output. Administrators and localization consultants encounter this package indirectly whenever these balance views are queried.

The package is not intended for direct invocation from Oracle Forms, concurrent programs, or customer custom code. Because it is classified as OTHER and carries no documented public API contract, Oracle does not guarantee backward compatibility of its signature across patches or upgrades. The object status is VALID in both Oracle EBS 12.1.1 and 12.2.2, with no editioning or Online Patching (AD_ZD) differentiation beyond standard APPS synonym resolution. Customizations should therefore query the dependent views rather than the package itself, preserving upgrade safety.