Search Results fetch_entry

Overview

PAY_JP_ISDF_ARCHIVE_PKG is an Oracle E-Business Suite payroll package owned by APPS that supports the Japanese Income Security Deduction Form (ISDF) archive process. Its purpose is to archive historic assignment-level insurance and premium information held in Oracle HRMS and Oracle Payroll tables into a retention structure, so that prior-period statutory reporting data remains available even after payroll and HR records have been purged, reorganized, or superseded by later changes. The package is specific to the Japanese localization (PAY_JP) and is classified as OTHER rather than a public or private API, meaning it is intended for internal use by the localization rather than as a supported customer-facing interface.

Key Procedures and Functions

The package exposes ten documented procedures and functions. Their declared purposes are as follows:

• RANGE_CURSOR — Provides the driving cursor used to select the population of records subject to archiving for a given processing run.
• ASSIGNMENT_ACTION_CREATION — Creates the assignment action rows required to drive payroll processing for the archived or reprocessed assignment records.
• ARCHINIT — Performs initialization for the archive process, establishing the working environment and package-level state before archiving begins.
• ARCHIVE_DATA — The main archive routine that copies qualifying assignment and payroll data into the archive destination tables.
• DEINITIALIZE_CODE — Releases package state and performs cleanup after archiving completes.
• INIT_PACT — Initializes payroll action context, identifying or creating the payroll action under which archived data is processed.
• INIT_ASSACT — Initializes assignment action context, resolving the assignment action records tied to the archive run.
• EE_DATETRACK_UPDATE_MODE — Sets or returns the mode used to update the DateTrack (effective-dating) mode applied to employee (EE) assignment records during the archive operation. This is the entry point commonly matched when searching for the ee_datetrack_update_mode initialization string.
• FETCH_ENTRY — Retrieves individual element entry records to be processed within the archive loop.
• ARCHIVE_ASSACT — Archives assignment action data, writing the assignment action records and their associated entries to the retention structure.

The package additionally declares two package-level variables, g_archive_default_flag and g_copy_archive_pact_id, together with PL/SQL record types t_li_info_rec and t_ai_info_rec that carry assignment extra information and organization information attributes through the archive logic.

Tables Accessed

The package references the following objects through APPS synonyms: HR_ORGANIZATION_INFORMATION, PER_ASSIGNMENT_EXTRA_INFO, PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_ADDRESSES, PAY_ALL_PAYROLLS_F, PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, FF_DATABASE_ITEMS, FF_FORMULAS_F, and HR_ALL_ORGANIZATION_UNITS. The HRMS tables supply the employee, assignment, address, and extra-information (insurance class, contractor, beneficiary, premium) attributes defined in the record types, while the Payroll tables supply element entries, entry values, element links, assignment actions, and payroll actions that constitute the archived payroll facts. The FastFormula tables are read to resolve formula definitions used when recalculating premium balances.

Usage Notes

Because this is an OTHER-classified localization package, it is not exposed as a general-purpose API. It is typically invoked from the Japanese payroll localization concurrent programs or from the archive processing logic that manages ISDF reporting retention, and it is referenced by one other package within the applications schema. Calls follow the pattern of ARCHINIT, then INIT_PACT and INIT_ASSACT, followed by ARCHIVE_DATA and ARCHIVE_ASSACT, and finally DEINITIALIZE_CODE. The ee_datetrack_update_mode entry point is used internally to control the effective-dating mode applied when employee assignment rows are written during archiving. Custom code should not call this package directly; it should instead use the supported concurrent program or localization interface that wraps it.