Search Results pay_jp_def_report_pkg




Overview
Explore in AI Chat

Overview

APPS.PAY_JP_DEF_REPORT_PKG is a Japanese payroll localization package delivered with Oracle E-Business Suite. It supports the generation of statutory and internal payroll reports by producing structured XML output for a defined set of assignment actions. The package header, identified with the RCS header pyjpdefr.pkh 120.0, declares package-level global variables that carry payroll action identifiers, effective dates, business group and legislation context, assignment set identifiers, sort order, transaction status flags, and a call-type indicator distinguishing Social Security (SS) and Contribution Processing (CP) style executions. It further exposes globals such as g_show_tag, which controls whether XML tags are emitted, and g_ass_set_formula_id / g_ass_set_amendment_type, which govern assignment set filtering.

Consistent with its classification as OTHER in the ETRM repository, the package is not a public integration API. It is invoked internally by the Japanese payroll report pipeline and by concurrent processing logic rather than by customer-developed code.

Key Procedures and Functions

The package exposes nine documented program units. Their responsibilities are as follows:

  • RANGE_CURSOR — Defines the driving cursor that establishes the range of assignment actions to be processed for the report run.
  • ASSIGNMENT_ACTION_CREATION — Creates or resolves the assignment action records required as input to the report, including handling of the transfer payroll action identified through the generic parameter mechanism.
  • ARCHINIT — Initializes archive processing, preparing the archive payroll action and related context used by the report generation cycle.
  • GEN_XML_HEADER — Emits the XML header portion of the report output. The unit of this procedure is reflected in the package-level cursor csr_bg, which is documented as the unit of GEN_XML_HEADER.
  • GEN_XML_BODY — Produces the XML body, using the csr_emp cursor as its unit. This cursor assembles employee-level rows and emits TRANSFER_ACT_ID=P markup alongside the underlying assignment action identifier, with sort keys driven by g_sort_order (EMPLOYEE_NAME or EMPLOYEE_NUMBER) over kana name and employee number columns.
  • GEN_XML_FOOTER — Closes the XML document with any summary or footer content required by the report layout.
  • GEN_XML_SS — Handles the Social Security-specific XML generation path, selected through the call-type global.
  • ARCHIVE_DATA — Persists or archives the generated data associated with the payroll action.
  • DEINITIALIZE_CODE — Performs cleanup of package state at the end of the run.

Tables Accessed

The package reads and writes application tables through APPS synonyms:

Usage Notes

PAY_JP_DEF_REPORT_PKG is invoked in the context of Japanese payroll report generation, typically through concurrent programs and payroll action processing rather than direct form invocation. It is referenced by zero other packages in the ETRM repository, confirming that its callers are external to the PL/SQL package layer. Execution begins with initialization of the package globals (payroll action, effective date, business group, assignment set, sort order, and call type), followed by archive setup and assignment action creation/resolution, then sequential generation of XML header, body, optional Social Security content, and footer, and finally data archival and deinitialization. The g_show_tag flag can suppress tag emission for diagnostic or intermediate processing purposes. Because the package is not a public API, customizations should avoid direct dependency on its internals; any extension should instead operate on the underlying payroll action and assignment action data.