Search Results pay_jp_ltax_efile_pkg




Overview
Explore in AI Chat

Overview

The APPS.PAY_JP_LTAX_EFILE_PKG package is a Japanese localisation component within the Oracle E-Business Suite Payroll module. Its name combines the PAY application prefix, the JP (Japan) country indicator, and the "LTAX_EFILE" token, which denotes local tax electronic filing. The package therefore provides the server-side processing foundation for the Japanese local tax (resident tax, or juminzei) electronic filing feature, which produces the statutory declaration media that employers submit to municipal authorities on behalf of their employees. In the Oracle EBS 12.1.1 and 12.2.2 releases the package carries an ETRM API classification of OTHER, indicating that it is an internal, feature-specific utility rather than a public or supported integration API. The single documented entry point, RUN_FORMULA, is consistent with a design in which the greater part of the computation logic is not hard-coded in PL/SQL, but is instead delegated to Oracle FastFormula, allowing localisation-specific tax rules to be maintained and versioned outside the compiled package body.

Key Procedures and Functions

The ETRM metadata documents exactly one callable program unit in the package specification:

  • run_formula — The sole declared procedure. Its purpose is to invoke and execute the FastFormula (or set of FastFormulas) associated with Japanese local tax electronic filing. Rather than performing tax calculations directly, the procedure acts as a driving routine that resolves the appropriate formula definition, supplies the required database context, evaluates the formula, and returns or persists the resulting values so that the e-filing output can subsequently be generated. The specification declares the procedure without visible parameters in the published header extract; parameter detail should be confirmed against the installed package specification for the specific patch level in use.

Tables Accessed

The documented table references illustrate how broadly the procedure reaches across the payroll and HR schema to assemble a filing data set:

Usage Notes

Because the package is classified as OTHER and reports no dependent packages, it should be treated as an internal building block invoked by the Japanese payroll localisation flow rather than called directly from customer code. The "run_formula" search term aligns it with the FastFormula execution pattern: the procedure is most likely driven from a concurrent program or from the payroll localisation user interface at the point where local tax e-filing data is prepared. Typical invocation is therefore indirect — a concurrent manager request, a payroll action completion step, or an internal package call — which resolves the formula, evaluates it against the selected payroll action, and makes the results available for file generation. Custom implementations should not call RUN_FORMULA without confirming its signature and post-conditions against the installed 12.1.1 or 12.2.2 specification, as the published header is version-stamped to the original 2007 release. Customers requiring local tax e-filing functionality should use the standard Oracle-provided payroll processes and any documented localisation setup rather than invoking this package directly.