Search Results basic_pension_num

Overview

APPS.PAY_PAYJPCAD_XMLP_PKG is a report-support package body associated with the Oracle Payroll Japanese legislative reporting infrastructure in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to prepare and format data required for the Japanese payroll magnetic media output — specifically the "CAD" file used for statutory Japanese payroll reporting. The package acts as the PL/SQL logic layer for an Oracle Reports (XML Publisher) concurrent program, supplying report-level entry points, formula columns, and global state used during report execution.

The package is owned by APPS and is classified as OTHER under ETRM. The header comment (PAYJPCADB.pls 120.0, 2007/12/13) indicates a long-standing file that has been stable across releases. The central concern of the code is the generation of a magnetic media file name (the magfile) and the preparation of date and element identifier values consumed by the report layout.

Key Procedures and Functions

The ETRM metadata documents zero discrete procedures or functions, but the source excerpt reveals the two primary entry points:

• BeforeReport — The Oracle Reports "Before Report" trigger function. It initialises global counters (G_REC_COUNT, G_FD_COUNT, G_FD_SERIAL_NUMBER, G_COUNT_OF_RECORD, G_HEADER_OUT), captures the concurrent request ID, and derives the magnetic media file name. When P_FILE_NAME is null, the file name is synthesised as a character "c" concatenated with a zero-padded seven-digit suffix derived from the concurrent request ID, followed by the ".mf" extension; otherwise the user-supplied P_FILE_NAME is used. This is directly relevant to the search term cp_magfile_name, which corresponds to the report-level parameter/bind that carries this computed magnetic file name into the output. The function also converts the prepare date into era, year, month, and day components, pads the year, month, and day into two-digit character globals, and resolves the legislation code and the BASIC_PENSION_NUM input value ID for the COM_SI_INFO element type.
• cf_emp_recordformula — A formula column function that assembles an employee record from assignment, address (current and previous, including Kana variants), date of birth, postal code, country, and Working Permit number inputs, returning the formatted employee record string used by the report.

Tables Accessed

The ETRM metadata lists no tables referenced via APPS synonyms. From the source, the package reads PER_BUSINESS_GROUPS.LEGISLATION_CODE (via %TYPE anchoring and the get_legislation_code call) and obtains the BASIC Pension input value identifier through PAY_JP_BALANCE_PKG. The heavy lifting of legislation and element lookups is delegated to PAY_JP_BALANCE_PKG, and date decomposition to PAY_JP_REPORT_PKG. Legacy HR_STANDARD.EVENT logging is present but commented out.

Usage Notes

This package is invoked implicitly by the Oracle Reports runtime when the associated Japanese payroll CAD concurrent program is executed. It is not intended for direct invocation from forms or custom code; all interactions occur through report triggers and formula columns within the APPS schema. The derived global magfile_name is consumed by the report's after-report or file-output logic to name the generated magnetic media file, ensuring uniqueness by tying the name to the concurrent request ID. Environments upgrading from 12.1.1 to 12.2.2 should treat this package as part of the standard Japanese payroll localisation and avoid modification, relying instead on the report parameters P_FILE_NAME, P_PREPARE_DATE, and P_BUSINESS_GROUP_ID to control behaviour.