Search Results get_global_value

Overview

APPS.PAY_PAYJPSMT_XMLP_PKG is a PL/SQL package body that underpins the Oracle EBS Japanese payroll statutory report identified internally as "Notification of Santei Checklist" (Santei is the Japanese social insurance remuneration reporting obligation). The package serves as the report logic container for an XML Publisher (XMLP)-based concurrent program in the Oracle Payroll module, and its header comment confirms its payroll jurisdiction scope: PAYJPSMTB.pls, last revised in 2008, is a Japan-localized (JP) payroll object. Its principal business purpose is to gather and derive the runtime parameters required to generate the Santei notification file, including a Japanese-standard "magfile" (Magnetic Media / e-file) output name, and to expose derived values as report globals consumed by the report template.

The package contains no independently documented procedures or functions in the ETRM 12.2.2 metadata, and no referenced APPS synonym tables are recorded. Its design is therefore best understood through the BeforeReport function body shown in the source excerpt.

Key Procedures and Functions

The metadata lists zero documented procedures or functions. The excerpted source, however, exposes one substantive routine:

• BeforeReport — a report trigger function that returns a boolean and executes prior to report rendering. It initializes report globals and derived parameters: it formats P_DATE_EARNED, P_DATE_FROM, and P_DATE_TO into display strings, assigns P_CONC_REQUEST_ID from FND_GLOBAL.conc_request_id, computes or accepts the output magfile name (CP_MAGFILE_NAME), and resets block and record counters (G_BLOCK_COUNT, G_REC_COUNT). It then resolves legislation code and element type identifiers for Santei-related payroll elements, and derives the input value identifiers for sex information, prior and revised standard monthly remuneration (SMR), and the SMR application month. It also selects the correct element type based on whether the earned date precedes 1 April 2003.

Note that the user search term "get_global_value" does not correspond to any routine declared in this package; global access here is achieved by direct assignment to package-level report globals (the G_* and CP_/LP_ variables) rather than via a generic get_global_value helper.

Tables Accessed

The ETRM metadata records no tables referenced via APPS synonyms for this package. From the excerpted source, data access is performed indirectly through the payroll balance package pay_jp_balance_pkg, which supplies the legislation code, element type identifiers, and input value identifiers consumed by the report. Direct SQL against payroll tables, if any, is not evidenced in the provided fragment.

Usage Notes

This package is invoked as the report logic for the "Notification of Santei Checklist" XML Publisher concurrent program within Oracle Payroll (Japan legislation). It is not a general-purpose API and is unlikely to be referenced by other packages (ETRM reports zero referencing packages). Because it is generated in the XMLP report package style, its parameters and globals are bound to the report template and to the concurrent program's parameter form. Custom coding against this package should be avoided; the supported integration points are the underlying public payroll balance APIs and the standard concurrent program submission.