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.
-
APPS.FND_UMS_ANALYSIS_ENGINE SQL Statements
12.2.2
-
APPS.FND_UMS_ANALYSIS_ENGINE SQL Statements
12.1.1
-
PACKAGE BODY: APPS.PAY_JP_PAYSLIP_ARCHIVE
12.2.2
-
PACKAGE BODY: APPS.BIL_DO_L1_OPPTY_SUMRY_PKG
12.1.1
-
PACKAGE BODY: APPS.ALR_DBTRIGGER
12.2.2
-
PACKAGE BODY: APPS.ALR_DBTRIGGER
12.1.1
-
PACKAGE BODY: APPS.PAY_JP_PAYSLIP_ARCHIVE
12.1.1
-
PACKAGE BODY: APPS.BIL_DO_L1_BASE_GRP_PKG
12.1.1
-
PACKAGE BODY: APPS.BIL_DO_L1_LD_OPPTY_DLY_PKG
12.1.1
-
PACKAGE BODY: APPS.QA_AUDIT_PKG
12.1.1
-
PACKAGE: APPS.HXC_TIMECARD_UTILITIES
12.1.1
-
PACKAGE BODY: APPS.QA_AUDIT_PKG
12.2.2
-
APPS.ALR_DBTRIGGER SQL Statements
12.1.1
-
APPS.ALR_DBTRIGGER SQL Statements
12.2.2
-
PACKAGE: APPS.HXC_TIMECARD_UTILITIES
12.2.2
-
PACKAGE BODY: APPS.FND_FLEX_EXT
12.2.2
-
PACKAGE BODY: APPS.FND_UMS_ANALYSIS_ENGINE
12.2.2
-
PACKAGE BODY: APPS.FND_UMS_ANALYSIS_ENGINE
12.1.1
-
APPS.PO_DOCUMENT_UPDATE_PVT SQL Statements
12.1.1
-
PACKAGE: APPS.FND_FLEX_SERVER1
12.2.2
-
PACKAGE: APPS.FND_FLEX_SERVER1
12.1.1
-
PACKAGE: APPS.PA_FP_CALC_PLAN_PKG
12.1.1
-
PACKAGE BODY: APPS.FND_FLEX_KEYVAL
12.1.1
-
APPS.BIL_DO_L1_LD_OPPTY_DLY_PKG dependencies on FND_GLOBAL
12.1.1
-
APPS.BIL_DO_L1_OPPTY_SUMRY_PKG dependencies on FND_GLOBAL
12.1.1
-
APPS.PO_DOCUMENT_UPDATE_PVT SQL Statements
12.2.2
-
PACKAGE: APPS.PA_FP_CALC_PLAN_PKG
12.2.2
-
PACKAGE BODY: APPS.FND_FLEX_EXT
12.1.1
-
APPS.BIL_DO_L1_BASE_GRP_PKG dependencies on FND_GLOBAL
12.1.1
-
PACKAGE BODY: APPS.FND_FLEX_KEYVAL
12.2.2
-
PACKAGE BODY: APPS.HXC_TIMECARD_UTILITIES
12.1.1
-
PACKAGE: APPS.BEN_EVALUATE_RATE_PROFILES
12.1.1
-
PACKAGE: APPS.BEN_EVALUATE_RATE_PROFILES
12.2.2
-
APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_DETERMINE_RATES
12.1.1
-
APPS.FND_UMS_ANALYSIS_ENGINE dependencies on AD_APPL_TOPS
12.2.2
-
APPS.HXC_TIMECARD_UTILITIES dependencies on HXC_BLOCK_TABLE_TYPE
12.1.1
-
APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_DETERMINE_RATES
12.2.2
-
APPS.HXC_TIMECARD_UTILITIES dependencies on HXC_TIME_BUILDING_BLOCKS
12.1.1
-
APPS.HXC_TIMECARD_UTILITIES dependencies on HXC_MESSAGE_TABLE_TYPE
12.1.1
-
APPS.FND_UMS_ANALYSIS_ENGINE dependencies on AD_APPL_TOPS
12.1.1
-
APPS.HXC_TIMECARD_UTILITIES dependencies on HXC_BLOCK_TABLE_TYPE
12.2.2
-
APPS.HXC_TIMECARD_UTILITIES dependencies on HXC_MESSAGE_TABLE_TYPE
12.2.2
-
PACKAGE BODY: APPS.HXC_TIMECARD_UTILITIES
12.2.2
-
APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_EVALUATE_RATE_PROFILES
12.1.1
-
APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_EVALUATE_RATE_PROFILES
12.2.2
-
APPS.HXC_TIMECARD_UTILITIES dependencies on HXC_TIME_BUILDING_BLOCKS
12.2.2
-
APPS.QA_AUDIT_PKG dependencies on DBMS_SQL
12.2.2
-
APPS.FND_FLEX_EXT dependencies on FND_FLEX_SERVER1
12.2.2
-
APPS.QA_AUDIT_PKG dependencies on DBMS_SQL
12.1.1
-
APPS.FND_FLEX_EXT dependencies on FND_FLEX_SERVER
12.2.2