Search Results pay_jp_itax_dpnt_interface_pkg




Overview
Explore in AI Chat

Overview

PAY_JP_ITAX_DPNT_INTERFACE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports Japanese payroll processing, specifically the interface of dependent information used in Japanese income tax (Shotokuzei) calculations. In the Oracle HRMS localization for Japan, payroll administrators maintain dependent declarations that drive tax exemptions, deductions, and year-end adjustment (Nencho Chosei) processing. This package provides the programmatic bridge that moves dependent tax data captured outside the standard payroll element entry path into the structures required by the Japanese payroll engine. It is classified as an OTHER API in the ETRM repository, indicating it is not a formally published open interface but is nonetheless a stable, deployable object referenced within the Japanese payroll processing chain. The package is marked VALID in the APPS schema and depends only on the SYS STANDARD package plus the tables and synonyms listed below, reflecting a narrowly scoped utility role rather than a broad business API.

Key Procedures and Functions

The ETRM metadata documents a single public procedure for this package:

  • TRANSFER_FROM_CEI_TO_BEE — Transfers dependent income tax declaration data from the CEI (Common Employee Interface / external declaration capture) staging structures into the BEE (Business/Employee Element Entry) representation consumed by Oracle Payroll. In practice this procedure reads staged dependent declaration records, resolves the appropriate Japanese income tax element types and their input values, and creates or updates the corresponding element entries for the assignment. It serves as the data movement routine that reconciles externally supplied dependent counts and amounts with the payroll engine's element entry model.

No additional documented functions or procedures are exposed in the ETRM record. Parameter lists are not published in the metadata and should be confirmed against the live package specification in the target environment before invoking the routine from custom code.

Tables Accessed

The package references the following tables through APPS synonyms:

  • FND_SESSIONS — Provides session context for the transferring process, typically used to validate or stamp the runtime session during interface execution.
  • HR_ASSIGNMENT_SETS — Identifies the assignment populations affected by the transfer, ensuring element entries are created for the correct employee assignments.
  • PAY_BATCH_HEADERS — Supports batch-level context, allowing transfers to be grouped or tracked under a payroll batch.
  • PAY_ELEMENT_TYPES_F and PAY_ELEMENT_TYPES_F_TL — Resolve the Japanese income tax element types (and their translated names) that dependent declarations map to.
  • PAY_INPUT_VALUES_F — Supplies the input value definitions for those element types, such as dependent counts or deduction amounts, which the procedure populates as element entry input values.
  • PLITBLM — An Oracle Payroll localization table used for storing localized payroll computation data; in the Japanese context it supports storage of dependent tax declaration details.

Usage Notes

This package is typically invoked from Japanese payroll localization flows rather than directly by end users. It may be called by concurrent programs, by Japanese year-end adjustment processes, or by custom interfaces that load dependent tax declaration files before payroll runs. The package is not referenced by other documented packages (0 references in ETRM), so dependencies flow one way: custom code or localization programs call into this package rather than the reverse. Because ETRM does not publish signatures, implementers should inspect the package specification in the target 12.1.1 or 12.2.2 instance, confirm the procedure parameters, and test in a controlled environment before use. The package is release-independent across 12.1.1 and 12.2.2 since it resides in the APPS schema and relies on core HRMS tables whose structures are stable across those releases.