Search Results pay_jp_itax_archive_pkg
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.
-
PACKAGE: APPS.PAY_JP_ITAX_ARCHIVE_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PAY_JP_ITAX_ARCHIVE_PKG, status:VALID,
-
PACKAGE: APPS.PAY_JP_ITAX_ARCHIVE_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PAY_JP_ITAX_ARCHIVE_PKG, status:VALID,
-
PACKAGE: APPS.PAY_JP_ITAX_ARCHIVE_PKG
12.1.1
-
PACKAGE: APPS.PAY_JP_ITAX_ARCHIVE_PKG
12.2.2
-
PACKAGE BODY: APPS.PAY_JP_ITAX_ARCHIVE_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_JP_ITAX_ARCHIVE_PKG, status:VALID,
-
PACKAGE BODY: APPS.PAY_JP_ITAX_ARCHIVE_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_JP_ITAX_ARCHIVE_PKG, status:VALID,
-
PACKAGE: APPS.PAY_JP_WIC_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PAY_JP_WIC_PKG, status:VALID,
-
PACKAGE: APPS.PAY_JP_WIC_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PAY_JP_WIC_PKG, status:VALID,
-
PACKAGE: APPS.HR_JP_STANDARD_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:HR_JP_STANDARD_PKG, status:VALID,
-
PACKAGE: APPS.PER_JP_CTR_UTILITY_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_JP_CTR_UTILITY_PKG, status:VALID,
-
PACKAGE: APPS.PER_JP_CTR_UTILITY_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_JP_CTR_UTILITY_PKG, status:VALID,
-
PACKAGE: APPS.HR_JP_STANDARD_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:HR_JP_STANDARD_PKG, status:VALID,
-
PACKAGE: APPS.PY_ROLLBACK_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PY_ROLLBACK_PKG, status:VALID,
-
PACKAGE: APPS.PY_ROLLBACK_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PY_ROLLBACK_PKG, status:VALID,
-
TYPE: APPS.FND_TABLE_OF_NUMBER
12.2.2
owner:APPS, object_type:TYPE, object_name:FND_TABLE_OF_NUMBER, status:VALID,
-
VIEW: APPS.PAY_JP_WIC_ASSACTS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PAY.PAY_JP_WIC_ASSACTS_V, object_name:PAY_JP_WIC_ASSACTS_V, status:VALID,
-
VIEW: APPS.PAY_JP_WIC_ASSACTS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PAY.PAY_JP_WIC_ASSACTS_V, object_name:PAY_JP_WIC_ASSACTS_V, status:VALID,
-
TYPE: APPS.FND_TABLE_OF_NUMBER
12.1.1
owner:APPS, object_type:TYPE, object_name:FND_TABLE_OF_NUMBER, status:VALID,
-
VIEW: APPS.PAY_JP_ITAX_ARCH_V2
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PAY.PAY_JP_ITAX_ARCH_V2, object_name:PAY_JP_ITAX_ARCH_V2, status:VALID,
-
VIEW: APPS.PAY_JP_ITAX_ARCH_V2
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PAY.PAY_JP_ITAX_ARCH_V2, object_name:PAY_JP_ITAX_ARCH_V2, status:VALID,
-
VIEW: APPS.PAY_JP_ITAX_PERSON_V2
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PAY.PAY_JP_ITAX_PERSON_V2, object_name:PAY_JP_ITAX_PERSON_V2, status:VALID,
-
VIEW: APPS.PAY_JP_ITAX_PERSON_V2
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PAY.PAY_JP_ITAX_PERSON_V2, object_name:PAY_JP_ITAX_PERSON_V2, status:VALID,
-
PACKAGE: APPS.PAY_ACTION_INFORMATION_API
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PAY_ACTION_INFORMATION_API, status:VALID,
-
VIEW: APPS.PAY_JP_ITAX_OTHER2_V2
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PAY.PAY_JP_ITAX_OTHER2_V2, object_name:PAY_JP_ITAX_OTHER2_V2, status:VALID,
-
VIEW: APPS.PAY_JP_ITAX_OTHER2_V2
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PAY.PAY_JP_ITAX_OTHER2_V2, object_name:PAY_JP_ITAX_OTHER2_V2, status:VALID,
-
PACKAGE: APPS.PAY_ACTION_INFORMATION_API
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PAY_ACTION_INFORMATION_API, status:VALID,
-
PACKAGE: APPS.PAY_CORE_UTILS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PAY_CORE_UTILS, status:VALID,
-
PACKAGE: APPS.HR_NONRUN_ASACT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:HR_NONRUN_ASACT, status:VALID,
-
SYNONYM: APPS.PAY_ASSIGNMENT_ACTIONS_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PAY_ASSIGNMENT_ACTIONS_S, status:VALID,
-
PACKAGE: APPS.PAY_CORE_UTILS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PAY_CORE_UTILS, status:VALID,
-
APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on PAY_JP_ITAX_ARCHIVE_PKG
12.1.1
-
SYNONYM: APPS.PAY_ALL_PAYROLLS_F
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PAY_ALL_PAYROLLS_F, status:VALID,
-
APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on PAY_JP_ITAX_ARCHIVE_PKG
12.2.2
-
PACKAGE: APPS.HR_NONRUN_ASACT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:HR_NONRUN_ASACT, status:VALID,
-
SYNONYM: APPS.PAY_ALL_PAYROLLS_F
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PAY_ALL_PAYROLLS_F, status:VALID,
-
SYNONYM: APPS.PAY_ACTION_INFORMATION
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PAY_ACTION_INFORMATION, status:VALID,
-
SYNONYM: APPS.PAY_ASSIGNMENT_ACTIONS_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PAY_ASSIGNMENT_ACTIONS_S, status:VALID,
-
SYNONYM: APPS.PER_ADDRESSES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PER_ADDRESSES, status:VALID,
-
PACKAGE BODY: APPS.PAY_JP_ITAX_ARCHIVE_PKG
12.1.1
-
SYNONYM: APPS.PER_ADDRESSES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_ADDRESSES, status:VALID,
-
SYNONYM: APPS.PAY_ACTION_INFORMATION
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PAY_ACTION_INFORMATION, status:VALID,
-
PACKAGE BODY: APPS.PAY_JP_ITAX_ARCHIVE_PKG
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
-
SYNONYM: APPS.PAY_ASSIGNMENT_ACTIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PAY_ASSIGNMENT_ACTIONS, status:VALID,
-
PACKAGE: APPS.FND_NUMBER
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_NUMBER, status:VALID,
-
SYNONYM: APPS.PAY_PAYROLL_ACTIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PAY_PAYROLL_ACTIONS, status:VALID,
-
SYNONYM: APPS.HR_ALL_ORGANIZATION_UNITS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:HR_ALL_ORGANIZATION_UNITS, status:VALID,