Search Results get_date_value

Overview

PAY_JP_YEA_BAL_ADJ_PKG is an Oracle E-Business Suite payroll package owned by the APPS schema and classified under the "OTHER" API category. Its name identifies it as a Japanese localization component supporting Year-End Adjustment (YEA) processing, specifically the balance adjustment logic required when an employer reconciles an employee's estimated annual tax liability against actual paid amounts at the close of the tax year. In Japan, the year-end adjustment (年末調整) is a statutory payroll obligation, and Oracle's localization delivers this capability through dedicated Japanese payroll packages. This package provides the runtime glue between the Oracle Payroll formula engine and the YEA balance adjustment business rules, allowing payroll runs to resolve the correct formula, execute it for a given assignment action, and interpret typed return values produced by that formula.

Key Procedures and Functions

• GET_FORMULA_NAME — Returns the name of the formula to be used for year-end balance adjustment, resolved using business group, payroll, and effective date context. This supports effective-dated formula selection so that the correct formula version is chosen for the payroll period being processed.
• CALL_FORMULA — Executes the identified formula in the context of a specific payroll action, assignment, assignment action, element entry, and element type, taking the date earned and returning a numeric result. It is the principal entry point for applying YEA balance adjustment calculations to an assignment.
• GET_NUMBER_VALUE — Returns a number from the formula result context. This is the function associated with the user's search term and serves as the typed accessor for numeric outputs produced during formula execution.
• GET_TEXT_VALUE — Returns a varchar2 result from the formula context, used for character-based formula outputs.
• GET_DATE_VALUE — Returns a date result from the formula context, used where the formula produces date-typed data.

The three typed accessors (GET_NUMBER_VALUE, GET_TEXT_VALUE, GET_DATE_VALUE) follow a common Oracle Payroll pattern: a formula is executed once via CALL_FORMULA, after which individual result values are retrieved by data type. This avoids repeated formula execution and keeps the calling code readable.

Tables Accessed

• FF_FORMULAS_F and FF_FORMULAS_F_TL — the formula definition and translated formula name tables, queried by GET_FORMULA_NAME to resolve the appropriate YEA formula for the given business group, payroll, and effective date.
• HR_ORGANIZATION_INFORMATION — organization-level configuration data used to derive business group and legislative context.
• PAY_ALL_PAYROLLS_F — payroll definition data, used to validate and contextualize the payroll identifier passed into the package.
• PAY_PAYROLL_ACTIONS — the payroll action being processed, providing the runtime context for CALL_FORMULA.
• PLITBLM — the payroll internal table (PL/SQL index-by table structure) used to pass formula input and output values between the package and the formula engine.

Usage Notes

This package is not referenced by any other documented package (referenced-by count of zero), which indicates it is invoked directly by Oracle Payroll's Japanese localization runtime, by year-end adjustment concurrent programs, or by customer extensions rather than being a shared utility. It is typically called during the Japanese YEA payroll process, after the ordinary payroll run has accumulated the year's earnings and tax deductions, when the balance adjustment must be computed per assignment. Because the package depends on PLITBLM-based formula context, callers must supply a valid payroll action and assignment action identifier; the typed accessors are then used to read results. The package carries a 2006 header revision (120.0) and is available in both EBS 12.1.1 and 12.2.2, with behavior governed by the active YEA formula configuration in the business group.