Search Results pay_jp_ltax_imp_pkg




Overview
Explore in AI Chat

Overview

PAY_JP_LTAX_IMP_PKG is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite Japanese payroll localization layer. Its documented name, combining the PAY (Payroll), JP (Japan), and LTAX (Local Tax) tokens with the IMP (Import) descriptor, indicates that it supports the import and transfer of Japanese local tax information — most notably inhabitant tax (juminzei) data supplied by municipal authorities — into the Oracle Payroll data model. Japanese payroll legislation requires employers to collect and remit local inhabitant tax based on notices issued by local governments, and to reconcile those amounts against the employee's payroll assignments and element entries. The package is classified in the ETRM as an OTHER API rather than a public or private API, meaning it is intended primarily for internal use by other Oracle components and by Oracle-delivered concurrent programs rather than as a documented integration surface for third-party callers. Its status is VALID, confirming that it is a live, compiled object in the 12.1.1 and 12.2.2 file systems.

Key Procedures and Functions

The ETRM metadata documents eight named procedures and functions within the package. SET_FILE_PREFIX, SET_FILE_SUFFIX, SET_FILE_EXTENSION, and SET_FILE_SPLIT are configuration routines that control the naming and segmentation of the interface or output files used during a local tax import run, allowing the file layout expected by downstream processing to be parameterized. SET_DATETRACK_EEV governs data tracking behaviour associated with element entry values, which in Oracle Payroll is the mechanism by which the system records which columns or rows were touched during a processing run. SET_DETAIL_DEBUG enables or disables detailed debug output, supporting diagnosis of import failures. INIT performs the package's initialization logic, establishing session-level settings and state before the main processing is invoked. TRANSFER_IMP_LTAX_INFO_TO_BEE is the principal functional routine, moving imported local tax information into the BEE (Japan payroll calculation) layer, which is supported by the referenced PAY_JP_BEE_UTILITY_PKG. No parameter signatures are documented, so callers should treat these entry points as internal.

Tables Accessed

The documented table references show the package reading and writing core HR and Payroll entities. FND_CONCURRENT_PROCESSES, FND_CONCURRENT_REQUESTS, and FND_SESSIONS are used to identify the running concurrent request and session, a common pattern for logging and audit within payroll batch processes. HR_ASSIGNMENT_SETS and HR_ASSIGNMENT_SET_AMENDMENTS define the population of assignments in scope, since local tax updates must be applied to a defined set of employees. PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_PERIODS_OF_SERVICE, and PER_ADDRESSES supply the person, assignment, hire-date, and address attributes required to match an external tax record to the correct employee and municipality. PAY_ALL_PAYROLLS_F, PAY_BATCH_HEADERS, and PAY_ELEMENT_ENTRY_VALUES_F are the payroll-side objects into which the tax element entries and batch structures are written. PAY_JP_SWOT_NUMBERS holds the Japanese tax office reference number, while HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION provide legal employer and organization context.

Usage Notes

Given its API classification of OTHER and its reference to FND_CONCURRENT_PROCESSES and FND_CONCURRENT_REQUESTS, this package is most plausibly invoked from an Oracle-delivered Japanese payroll concurrent program that imports local tax data files and applies them to assignments. It is also referenced by dependent code within the same package body, which is consistent with an internal, modular design. The ETRM records zero other packages referencing it externally, so it should not be treated as a stable public interface. Customers extending Japanese local tax processing are advised to call the delivered concurrent program rather than the package directly, and to avoid referencing the INIT, SET_*, or TRANSFER_IMP_LTAX_INFO_TO_BEE routines in custom code, since their signatures and behaviour may change during patching.