Results for “pay_jp_itax_archive_pkg”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_JP_ITAX_ARCHIVE_PKG is an Oracle EBS Payroll package owned by the APPS schema and classified as an "OTHER" API in the ETRM repository. It supports the Japanese localization of Oracle Payroll, specifically the archiving of income tax (shotokuzei) reporting data associated with payroll runs. Japanese payroll processing requires periodic submission of income tax withholding and year-end adjustment (nenmatsu chosei) data to tax authorities, and payroll administrators must retain historical records of these submissions. This package provides the archive routine that captures the relevant assignment-level and payroll-level information at the point of a payroll action, preserving a snapshot for statutory retention and audit purposes.
Key Procedures and Functions
The package exposes five documented entry points, which follow the standard Oracle Payroll business-process hook naming convention (initialization, range, assignment action, processing, and deinitialization):
- INITIALIZATION_CODE — Invoked once at the start of the payroll action processing cycle. It is intended to set up any session-level context or working storage required before individual assignments are processed.
- RANGE_CODE — Defines the action-level or range-level setup for the payroll run, allowing the archive logic to establish parameters that apply to the whole set of assignments handled within the action.
- ASSIGNMENT_ACTION_CODE — Executed for each assignment action within the payroll run. This is the core hook where income tax archive records are likely written or accumulated based on the calculated results.
- ARCHIVE_CODE — Performs the final archiving step, consolidating and persisting the collected income tax data for the payroll action.
- DEINITIALIZATION_CODE — Called after processing completes, to release resources and finalize the archive cycle.
Tables Accessed
The package operates across a range of Oracle HRMS and Payroll tables, accessed through APPS synonyms:
- PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, PAY_ACTION_INFORMATION — provide the payroll run context, including action status, dates, and parameters.
- PAY_ALL_PAYROLLS_F — supplies payroll definition data (name, period, tax-related attributes).
- PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F — supply the employee and assignment records whose tax data is being archived.
- HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION — provide organization and legal-employer details required for tax reporting.
- PER_ADDRESSES — supplies address data for tax filings.
- DUAL and PLITBLM — used for PL/SQL utility operations (PLITBLM is the standard PL/SQL table/cursor buffer utility).
Usage Notes
PAY_JP_ITAX_ARCHIVE_PKG is not referenced by any other package and is therefore not part of a broader internal dependency chain. It is normally invoked indirectly, through the Oracle Payroll business group or payroll action configuration, where the package name is attached as a code hook (INITIALIZATION_CODE, RANGE_CODE, ASSIGNMENT_ACTION_CODE, ARCHIVE_CODE, DEINITIALIZATION_CODE) on the payroll action. The package is also referenced by the ALR action parameter and the "Referenced by" list contains only itself, indicating no downstream consumers.
Because it is a Japanese-localization artifact, it appears only in environments where the Japanese legislative extension has been applied. Customers upgrading from 12.1.1 to 12.2.2 should not need to modify it directly. Custom code should not call its procedures explicitly; instead, the package is expected to run as part of the standard payroll action cycle.
-
SYNONYM: APPS.PER_ADDRESSES 12.1.1
-
SYNONYM: APPS.PER_ADDRESSES 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
SYNONYM: PUBLIC.DUAL 12.2.2
-
SYNONYM: PUBLIC.PLITBLM 12.1.1
-
SYNONYM: PUBLIC.DUAL 12.1.1
-
SYNONYM: PUBLIC.PLITBLM 12.2.2
-
12.2.2 DBA Data 12.2.2