Results for “pay_jp_zengin_tape”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_JP_ZENGIN_TAPE is an Oracle E-Business Suite PL/SQL package that belongs to the Oracle Payroll product family and serves the Japanese localization of Oracle HRMS. Its purpose is to generate magnetic tape files in the Zengin format, the standard Japanese interbank payment file specification used for domestic funds transfers. The package implements the tape format logic required to translate payroll payment instructions held in Oracle Payroll into a flat file that a Japanese bank can accept for salary and vendor disbursements.

The package header, dated from the original Oracle Corporation (UK) Ltd codebase, describes a design in which one PL/SQL package is written for each magnetic tape format. The package contains all cursors and procedures needed for the particular format, and a stored procedure provides the top-level control flow for file generation. This procedure is called before each execution of a payroll formula, receiving parameters returned as the results of the previous formula execution and setting parameters required by the next formula. The interface between the external file-generation process and the stored procedure relies heavily on PL/SQL tables, with a one-based contiguous index scheme in which the first element of each value table stores the number of available elements.

Key Procedures and Functions

ETRM documents four procedures and functions in APPS.PAY_JP_ZENGIN_TAPE:

• NEW_FORMULA — Establishes or initializes the formula context for the Zengin tape generation run, preparing the stored procedure state before formula execution proceeds.
• GET_PROCESS_DATE — Returns the process date used to stamp and sequence the generated Zengin tape records, ensuring the output file reflects the correct payment effective date.
• VALIDATE_PROCESS_DATE — Performs validation on the supplied or derived process date, guarding against invalid dates being written into the tape file.
• AND — A helper routine supporting conditional evaluation within the package's formula-driven control flow.

The procedures operate in concert with the formula execution framework described in the package header, where the calling process passes and receives indexed PL/SQL table parameters.

Tables Accessed

The package references the following tables through APPS synonyms. Payment and assignment data are read from PAY_ASSIGNMENT_ACTIONS, PAY_PRE_PAYMENTS, PAY_PERSONAL_PAYMENT_METHODS_F, PAY_ORG_PAYMENT_METHODS_F, PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F. Payroll run context is obtained from PAY_PAYROLL_ACTIONS, PAY_PAYMENT_TYPES and FND_SESSIONS. Japanese banking detail, essential for Zengin routing and account identification, comes from PAY_JP_BANKS and PAY_JP_BANK_BRANCHES. Payment instruction detail is drawn from PAY_EXTERNAL_ACCOUNTS and HR_SOFT_CODING_KEYFLEX, while FF_FORMULAS_F and PAY_USER_COLUMNS support the formula-driven parameter interface.

Usage Notes

PAY_JP_ZENGIN_TAPE is invoked indirectly through the Oracle Payroll payment process rather than by end users. It is driven by the magnetic tape generation framework in which payroll formulas call the package for each record type in the Zengin file structure. The package is referenced by zero other packages, confirming that it sits at the top of its own call hierarchy and is entered from the external file-generation program. Customers subject to Japanese statutory payment formats use it during prepayment and payment processing for Japanese payrolls. Customizations should avoid modifying the package directly, as it is supplied as an Oracle-owned object; extensions are better implemented through supported formula and payment method configuration.