Search Results override_dd_date

Overview

APPS.PAY_JP_ZENGIN_TAPE is the Oracle E-Business Suite payroll package that generates magnetic tape output for the Japanese Zengin payment format. The header comment inherited from its source lineage (pyjptpzn.pkb, version 115.3) still references the original BACS implementation on which the Zengin logic was modelled, but the object is owned by APPS and is delivered as part of the Oracle Payroll Japanese localization. Its core responsibility is to convert approved prepayment records into the fixed-format bank transfer file consumed by Japanese financial institutions through the Zengin clearing network, applying the formatting, header and trailer rules associated with that format. In EBS 12.1.1 and 12.2.2 the package is classified in the ETRM as OTHER and sits outside the standard public payroll APIs; it is invoked indirectly through the payroll actions framework rather than called by customers. The package works against the payroll action and assignment action model: a single payroll_action_id is passed on the first call, and legislative parameters such as SUBMISSION_NUMBER, MEDIA, MULTI_DAY and BUREAU are stored against the payroll action so that subsequent calls can reconstruct the run context, including whether the run covers a multi-day payment window.

Key Procedures and Functions

• AND — A helper routine used in the construction of SQL predicates. It allows the package to concatenate an additional condition onto a dynamically assembled WHERE clause, which is how optional selection criteria such as payroll, date range, payment type and organization payment method are layered onto the prepayment query only when the corresponding parameter is supplied.
• NEW_FORMULA — Supports formula handling within the tape generation flow. It is used to resolve or instantiate the fast formula definitions associated with the payment process, referencing the formula tables rather than hard-coding calculation logic in PL/SQL.
• GET_PROCESS_DATE — Returns the effective processing date for the Zengin run. This date is derived from the run parameters (including the start date and effective date) and is used to stamp the tape header and to select which prepayments fall inside the processing window, which is the basis for the multi-day run behaviour controlled by the MULTI_DAY legislative parameter.
• VALIDATE_PROCESS_DATE — Performs consistency checking on the supplied processing date before tape generation proceeds. It guards against invalid or out-of-range dates that would otherwise produce a file rejected by the clearing bank.

Tables Accessed

The package reads and writes payroll, payment and HR tables through APPS synonyms. PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS hold the run header and the per-assignment actions that drive processing. PAY_PRE_PAYMENTS supplies the payment records written to tape, with PAY_PERSONAL_PAYMENT_METHODS_F and PAY_ORG_PAYMENT_METHODS_F determining account and method details. PAY_EXTERNAL_ACCOUNTS, PAY_JP_BANKS and PAY_JP_BANK_BRANCHES provide the Japanese bank master and branch data required for Zengin routing fields. PAY_PAYMENT_TYPES, PAY_USER_COLUMNS, HR_SOFT_CODING_KEYFLEX, PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F supply payment classification, descriptive flexfield and employee/assignment context, while FF_FORMULAS_F and FND_SESSIONS support formula resolution and session context.

Usage Notes

PAY_JP_ZENGIN_TAPE is not a public API and is referenced by no other package in the ETRM. It is invoked by the payroll action framework when the Zengin magnetic tape payment process is submitted, typically from the Submit Payments or prepayments flow in Oracle Payroll for Japanese legislative installations. The first call receives the payroll_action_id; later calls read the stored legislative parameters to complete header, trailer and multi-day consolidation logic. Because output is a fixed-width bank file, any customisation should avoid altering formatting routines and instead extend selection through the documented parameters.