Search Results p_assignment_action_id

Overview

APPS.PAY_JP_ITWB_ARCHIVE_PKG is a Japanese localization payroll package within Oracle E-Business Suite that supports archiving and generation of the Japanese income tax withholding report, commonly referred to as the ITWB (Income Tax Withholding/Withholding Statement) output for expatriate and non-resident payroll processing. The package operates against assignment action records produced by the Oracle Payroll run process, extracting the calculated element entry results required to populate statutory Japanese withholding reporting elements such as YEA_ITX, REY_ITX, SAL_ITX, BON_ITX, and SPB_ITX, along with residency and remittance-related input values including ITX_TYPE, WITHHOLD_AGENT, and NRES_FLAG. Because the package is classified as OTHER rather than as a public API, it is intended for internal use by Oracle localization features, specifically the archive-rebuild processing of prior-period payroll actions used to reconstitute tax reporting data.

Key Procedures and Functions

• GET_FUZZY_PROC_TYPE — Determines the applicable processing type for an assignment action, allowing the package to resolve the context in which a given action was run before archiving data.
• RANGE_CURSOR — Defines the driving cursor used to iterate over the range of assignment actions and element entries eligible for archiving.
• ASSIGNMENT_ACTION_CREATION — Creates or repopulates assignment action records used as the archive target during the ITWB rebuild cycle.
• ARCHINIT — Initializes the archive run, typically setting global package state and cache variables ahead of the main archiving pass.
• ARCHIVE_DATA — Performs the primary extraction and archiving of payroll results relevant to Japanese withholding, drawing from element entry and input value tables.
• DEINITIALIZE_CODE — Cleans up global variables and package state after the archive completes.
• INIT_PACT — Initializes payroll action context, resolving the p_assignment_action_id scope used throughout the archive run.
• ARCHIVE_ASSACT — Archives data for a specific assignment action, keyed on the assignment action identifier.

The parameter p_assignment_action_id is the central input used to bind the archive to a specific assignment action record, ensuring the correct period and payroll context is targeted.

Tables Accessed

The package reads from and writes to a well-defined set of payroll and HR tables via APPS synonyms. It reads PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S to identify and create action records, PAY_ASSIGNMENT_ACTIONS_S for the action context, and PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_INPUT_VALUES_F, and PAY_LINK_INPUT_VALUES_F to obtain the calculated element results. Supporting lookups use PAY_ELEMENT_TYPES_F and PAY_ELEMENT_CLASSIFICATIONS to resolve element identity and classification, PAY_ACTION_INFORMATION and PAY_ACTION_INTERLOCKS for action sequencing, PAY_ALL_PAYROLLS_F and PAY_PAYROLL_ACTIONS for payroll and action context, HR_ASSIGNMENT_SET_AMENDMENTS for assignment scope, and HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION to resolve organization-level attributes such as withholding agent and location.

Usage Notes

This package is invoked internally by Oracle's Japanese payroll localization processing, typically during the archive or rebuild of prior income tax withholding data, rather than being called directly from a user-facing form. It is not referenced by any other package, confirming its role as a leaf processing module invoked by localization batch logic or concurrent program flow. Developers customizing Japanese payroll reporting may encounter this package when tracing errors tied to p_assignment_action_id, since invalid or missing assignment action identifiers cause the archive pass to fail during INIT_PACT or ARCHIVE_ASSACT. Direct invocation from custom code is not recommended, as the package classification is OTHER and the global variables it manipulates are not designed for concurrent or re-entrant execution.