Search Results g_block_count

Overview

APPS.PAY_PAYJPGMT_XMLP_PKG is a report logic package associated with an Oracle Payroll Japanese localization report identified in the source header as PAYJPGMT, generated on 2008/04/02. The package body encapsulates the PL/SQL logic executed by Oracle Reports at runtime in an Oracle E-Business Suite 12.1.1 or 12.2.2 environment, most notably within the BeforeReport trigger. Its purpose is to prepare the input parameters, global counters, and derived element identifiers required to produce a Japanese payroll government filing or magnetic media output file—indicated by the CP_MAGFILE_NAME and the '.mf' file extension logic used to construct the report output name.

The package is classified as OTHER in the ETRM catalog. It owns no documented public API procedures and is not referenced by any other packages, confirming it is a report-specific private implementation rather than a shared library routine.

Key Procedures and Functions

The only documented entry point is BeforeReport, a function returning BOOLEAN that runs prior to report data extraction. Within this function the following initialization work occurs:

• Captures the concurrent request ID from fnd_global.CONC_REQUEST_ID into P_CONC_REQUEST_ID.
• Derives the magnetic file name: when P_FILE_NAME is null, builds a name using a 'g' prefix and a zero-padded seven-digit request-derived number plus the '.mf' extension; otherwise uses the supplied P_FILE_NAME. The result is assigned to CP_MAGFILE_NAME.
• Initializes the global counters G_BLOCK_COUNT to 1 and G_REC_COUNT to 0. This is the object matching the user search term "g_block_count".
• Resolves legislation code and element type identifiers for the business group using pay_jp_balance_pkg, retrieving input value IDs for SI_SEX, and for the WP SMR element types PRIOR_SMR, REVISED_SMR, and APPLY_MTH.
• Conditionally, when P_DATE_EARNED is earlier than 2003/04/01, resolves the SANTEI element type and its associated payment day input value identifiers (PAY_BASE_DAYS_MAY, PAY_BASE_DAYS_JUN, PAY_BASE_DAYS_JUL).

Tables Accessed

The ETRM metadata documents no direct table references for this package. All data retrieval is delegated to the helper package PAY_JP_BALANCE_PKG, which resolves element type and input value identifiers against Payroll element configuration data (pay_element_types_f, pay_input_values_f and related date-tracked entities) for the specified business group and legislation code.

Usage Notes

This package is invoked exclusively as the supporting PL/SQL library for the PAYJPGMT Oracle Reports report, not as a standalone API. It is executed when the corresponding concurrent program is run from the Japanese Payroll responsibility. G_BLOCK_COUNT is a report-level global counter, typically incremented as each data block is emitted, and G_REC_COUNT tracks the number of records processed within the magnetic media file. Because these are package globals reset in BeforeReport, each concurrent request execution begins with a clean block and record count, ensuring the generated government submission file starts from a deterministic state.

Customizations should avoid altering the initialization sequence, since the derived identifiers and file name feed directly into downstream report queries.