Search Results cp_month

Overview

APPS.PAY_PAYJPLTX_XMLP_PKG is an Oracle E-Business Suite PL/SQL package that underpins the Japanese local tax reporting concurrent program in Oracle Payroll (PAY). The package name follows the standard Oracle Reports integration convention: the PAYJPLTX report, executed from its XML Publisher (.rdf/.xml) definition, delegates its BeforeReport, AfterReport, and group-level formula logic to this package. Its primary business purpose is to construct and format Japanese year-end and monthly local tax (住民税 / 市町村民税) remittance data, including per-employee residence tax, lump-sum (普通徴収) amounts, and split special-collection components.

The variable CP_YEAR (referenced in the user query as cp_year_p) is one of the package's global package-level variables that carries the reporting year from the concurrent program parameters into the report layout. It directly drives which tax year's data is selected and displayed on the Japanese local tax output file.

Key Procedures and Functions

The documented source exposes the following program units. Well-known PL/SQL Reports callback patterns are:

• BeforeReport — Returns BOOLEAN; invoked by the Oracle Reports engine prior to data retrieval to initialise package globals (including CP_YEAR, CP_MONTH, CP_ERA_CODE) from the concurrent request parameters.
• AfterReport — Returns BOOLEAN; runs at report completion, typically to reset package state or release resources.
• cf_body_masterformula — Master-group formula that aggregates body-level local tax, special-collection, and lump-sum totals for a district or employee group.
• cf_headerformula — Header-level formula that composes the payroll office/client/bank header block for the Japanese local tax file.
• cf_body_detailsformula — Detail-level formula computing per-record local tax amounts (LTAX, LTAX_LUMPSUM, SP_LTAX, SP_LTAX_SHI, SP_LTAX_TO) shown on each row.
• CP_BODY_LTAX_COUNT_p, CP_BODY_SP_LTAX_COUNT_p, CP_BANK_CODE_p, CP_MAGFILE_NAME_p, CP_LTAX_TOTAL_p, CP_LTAX_TOTAL_COUNT_p — Getter/accessor functions returning the current value of the corresponding package global (e.g., the count of body local tax rows, the bank code, the magnetic media file name, cumulative totals). Reporting placeholders call the *_p functions so layout fields reflect runtime state.

Tables Accessed

The ETRM metadata records no tables referenced via APPS synonyms for this package; all business data retrieval is performed through the report's SQL query, not through the PL/SQL package itself. The package is essentially a state container plus callback logic layer. Underlying data for the report is drawn (via the report query) from Payroll Japanese local tax tables such as PAY_JP_LOCAL_TAX_DETAILS and standard PAY_PAYROLL_ACTIONS / PER_ALL_PEOPLE_F rows, but this package does not declare direct SQL access to them per the documented metadata.

Usage Notes

PAY_PAYJPLTX_XMLP_PKG is invoked exclusively through the Japanese Local Tax concurrent program/report. It is not an API that developers should call directly. In Oracle EBS 12.1.1 and 12.2.2 it resides in the APPS schema and is compiled with the standard PAY product build. The package-level variable CP_YEAR is populated by BeforeReport from the request parameter of the corresponding report, and its accessor, referenced around the cp_year_p search token, allows the layout to print the correct tax year on each page. Customisations should avoid modifying this seeded package; the supported extension path is to clone the concurrent program definition or use the Oracle Reports after-parameter form trigger and an XML Publisher template override.