Results for “pay_payjpsqd_xmlp_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_PAYJPSQD_XMLP_PKG is a generated Oracle XML Publisher (BI Publisher) report package owned by the APPS schema. It underpins the Japanese statutory report identified in the source header as "PAYJPSQDS" (PAY: Payroll, JP: Japan, SQD: a Japanese filing form), which is the Japanese salary payment report and the associated magnetic media submission file. The package establishes the runtime context for the report—business group, reporting period, organization, and the submission serial number and preparation date drawn from the concurrent program—and it collects and formats the report-level "CP_" (concurrent program) global values that the report layout references during execution. It also exposes the standard gating functions BeforeReport and AfterReport, which the XML Publisher engine invokes to prepare values before the data model executes and to clean up state afterward.

Key Procedures and Functions

The metadata lists no separately documented procedures, so the following are drawn from the package specification itself. BeforeReport executes prior to the report's data queries, resolving the bound parameters and populating the CP_ pseudo-columns. The custom function cf_emp_record formula returns a record (line) identifier for each employee row, using assignment, effective date, name-in-kana, address, date of birth, and postal/country information to build the employee record key. AfterReport runs after the report completes to release or reset the package's session state. A family of getter functions—CP_WP_STD_MONTHLY_COMP_p, CP_SALARY_p, CP_MATERIAL_SALARY_p, and CP_SALARY_SUM_p—exposes the standard monthly compensation, salary, material salary, and salary sum values to the report template. The "g_si_sex_iv_id" search term relates to the CP_SI_SEX and CP_SI_SEX_CODE package globals, which hold the social insurance sex designation (text) and its single-character code and are surfaced to the report layout as its corresponding CP values.

Tables Accessed

No tables are documented as referenced via APPS synonyms in the supplied metadata. In practice, the report package's data model reads HR and payroll views and tables (employee, assignment, address, and payroll run/Japanese payroll report queries) to source the employee record information and monthly compensation values it places in the CP_ globals and the cf_emp_record formula. Because the metadata is limited, exact object names cannot be confirmed here.

Usage Notes

The package is not called directly by end users. It is generated and maintained by Oracle XML Publisher and is invoked automatically when the corresponding Japanese payroll concurrent program runs in Oracle EBS 12.1.1 or 12.2.2. The concurrent request supplies the business group, date range, organization, and serial number parameters declared in the specification, and the package formats those values—along with the social insurance sex code and the salary totals—for the report output and magnetic media file. Custom code should not call these functions directly; customization should target the report definition and template rather than the package, since the generated globals and getters are regenerated whenever the report is re-registered.