Search Results trailer_record

Overview

APPS.PAY_JP_MAGTAPE_FORMAT_PKG is a Japanese localization package within Oracle E-Business Suite Payroll that supports the generation of magnetic tape (magtape) payment files for Japanese bank transfers. The package forms the formatting layer of a two-part design: PAY_JP_MAGTAPE_PKG defines the record structures (header, data, and trailer), while PAY_JP_MAGTAPE_FORMAT_PKG converts those structured records into the flat, fixed-position character strings required by the Japanese Zengin (bank transfer) file specification. The package is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling schema rather than the package owner, a common convention in Oracle HRMS/Payroll localization code. The header comment (payjpmgf.pkh 115.1) indicates the package is "noship," reflecting that it is a localization-specific component shipped only with the Japanese product installation.

Key Procedures and Functions

• HEADER_RECORD — Converts a header structure (pay_jp_magtape_pkg.header) into the formatted header character string placed at the beginning of the magtape output, carrying file-level identification such as the originating bank and processing date.
• DATA_RECORD — Converts a data structure (pay_jp_magtape_pkg.data) into the formatted detail line representing an individual employee payment instruction.
• TRAILER_RECORD — Converts a trailer structure (pay_jp_magtape_pkg.trailer) into the formatted trailer string carrying control totals for the file.
• END_RECORD — Returns the end-of-file record string that terminates the magtape output. end_record is the specific function users search for when troubleshooting file termination, record count reconciliation, or trailer/end-record placement issues.
• DELIMITER_TYPE — Defines the delimiter type used when assembling or parsing formatted records.

All formatting functions return VARCHAR2. Complete parameter lists are not reproduced in the documented metadata; only the intent of each routine is described here.

Tables Accessed

Through APPS synonyms the package references configuration and setup data rather than transaction balances: FND_APPLICATION, FND_APPLICATION_TL, and FND_PRODUCT_INSTALLATIONS are used to resolve application identity and confirm product installation; PAY_JP_BANKS supplies Japanese bank and branch definition data used to populate file identification fields; and PAY_ORG_PAYMENT_METHODS_F provides the organization-level payment method configuration that governs whether and how a magtape file is produced. Employee-level payment values are supplied by the calling process rather than read directly by this formatting package.

Usage Notes

PAY_JP_MAGTAPE_FORMAT_PKG is not intended for direct end-user invocation. It is called by the Japanese magtape generation program within the Oracle Payroll payment process when the organization's payment method requires bank transfer via magnetic media. This sequence applies across both 12.1.1 and 12.2.2, as the underlying localization package structure is unchanged between these releases. Developers performing diagnostics on a malformed or truncated file, particularly a missing or misplaced end record, should inspect this package and the companion PAY_JP_MAGTAPE_PKG: it is the authoritative location for record layout, delimiter handling, and end-of-file termination logic. Because no other documented packages reference it, its invocation is expected to come from concurrent-program or payment-process code rather than from dependent PL/SQL APIs.