Search Results init_globals




Overview

APPS.PAY_JP_PAYSLIP_ARCHIVE is a Japanese localization package within Oracle E-Business Suite Payroll (Oracle HRMS). Its business function is to archive payslip data for Japanese payroll processing, generating the archived payslip records that employees and payroll administrators rely upon for historical retrieval and statutory reporting. The package is version-controlled at $Header: pyjpparc.pkb 120.8 2011/01/19, indicating maintenance through the 12.x release line and applicability to both 12.1.1 and 12.2.2 environments. The package is classified as OTHER in the ETRM metadata, meaning it is not exposed as a public PL/SQL API but is invoked internally through the Oracle Payroll action-execution framework. The presence of the ARCHINIT, RANGE_CURSOR, ACTION_CREATION, ARCHIVE_CODE, and DEINITIALIZATION_CODE routines indicates that it is implemented as a standard payroll archive process built around the PAY_ACTION_INFORMATION / PAY_ASSIGNMENT_ACTIONS model, where a concurrent program drives assignment-level processing through the range cursor and action-creation callback pattern. The user search term "init_globals" corresponds to a common naming convention in such packages: a global initialization procedure referenced in the package body header, where the package defines global variables representing concurrent program parameters (payroll action ID, business group ID, effective date, consolidation set, payment date, and payslip label) that are populated at the start of a run and consumed by the subsequent range and archive routines. These globals form the runtime context for the archive operation, ensuring each payslip generated carries the correct payroll, consolidation set, and effective date.

Key Procedures and Functions

  • ARCHINIT — Initialization routine for the archive process. It establishes the runtime environment and populates the package-level global variables (payroll action ID, business group ID, effective date, payroll ID, consolidation set, payment date, and payslip label) that drive all subsequent processing.
  • RANGE_CURSOR — Defines the cursor over the assignments or payroll actions to be archived within the concurrent program's chunk range, supporting the standard payroll action parameter model.
  • ACTION_CREATION — Creates the action rows (assignment actions) corresponding to each assignment selected by the range cursor, integrating with the payroll action framework so the archive run is traceable.
  • ARCHIVE_CODE — Core archive logic that assembles and writes the Japanese payslip data, resolving defined balances and payslip net pay for the processed assignments.
  • DEINITIALIZATION_CODE — Cleanup routine that releases globals and finalizes the concurrent request upon completion of the archive run.

Tables Accessed

The package reads organization and payroll configuration through HR_ORGANIZATION_INFORMATION, HR_ORG_INFORMATION_TYPES, PAY_ORG_PAYMENT_METHODS_F, PAY_ORG_PAYMENT_METHODS_F_TL, and PAY_EXTERNAL_ACCOUNTS. Payroll action and assignment processing uses PAY_ACTION_INFORMATION, PAY_ACTION_INTERLOCKS, PAY_ASSIGNMENT_ACTIONS, and PAY_ASSIGNMENT_ACTIONS_S. Balance and earnings data come from PAY_BALANCE_FEEDS_F, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPES_F_TL, and PAY_INPUT_VALUES_F. Japanese bank payment details are resolved via PAY_JP_BANKS and PAY_JP_BANK_BRANCHES. The body additionally references HR_JP_ID_PKG to resolve defined balance IDs (allowance, taxable earnings, social insurance premium, income tax, year-end tax adjustment, and payslip net pay) and balance type IDs used in the archive calculations.

Usage Notes

This package is not a public API; it is invoked by the Japanese payslip archive concurrent program within Oracle Payroll. It is referenced by zero other PL/SQL packages, so custom code should not call it directly. Customizations should instead target the underlying balance definitions or concurrent program parameters. Because the header reflects patch level 120.8, administrators on 12.1.1 and 12.2.2 should verify the installed file version after applying Japanese payroll patches, as the defined balance dimensions (corrected to _ASG_YTD per Bug 5401179) directly affect year-to-date payslip figures.