Search Results cp_note_title




Overview
Explore in AI Chat

Overview

APPS.PAY_PAYJPNUI_XMLP_PKG is a report-support package body associated with the Oracle Payroll Japanese statutory reporting solution in Oracle E-Business Suite. Its name follows the XML Publisher (XMLP) package naming convention, indicating that it serves as the data model / formula package backing a BI Publisher report. The UI prefix and the internal references to PAY_JP_REPORT_PKG and PAY_JP_BALANCE_PKG, together with the use of era-year conversion routines (TO_ERA), confirm that this package supports Japanese employee statutory reporting that must be rendered in the Japanese era calendar format (for example, formatting dates in era year, month, and day).

The package logically sanitizes report input values, converts Gregorian dates into era-based display strings, and exposes those derived values as report globals consumed by the XML Publisher layout. The cp_report_title search term maps directly to the package's CP_REPORT_TITLE_P function, which supplies the report heading.

Key Procedures and Functions

  • CF_DETAILS_DUMMYFORMULA — The principal computational function. It accepts assignment, effective, target, and birth date inputs and drives the derivation of UI number, target date, and date-of-birth globals; it also branches on report type to derive the qualified date. It relies on balance package entry-value lookups rather than direct table reads.
  • AFTERPFORM — Post-form (post-parameter) processing hook, invoked after the report parameter form is submitted.
  • BEFOREREPORT — Pre-execution hook used to initialize package state and globals before the report query runs.
  • AFTERREPORT — Post-execution hook for cleanup or finalization after report output is produced.
  • CP_UI_NUMBER_P — Returns the formatted Japanese UI (insurance) number global, assembled in the 4-6-1 grouping pattern.
  • CP_TARGET_DATE_P — Returns the era-formatted target date global (era year, month, day concatenated).
  • CP_DATE_OF_BIRTH_P — Returns the era-formatted date-of-birth global, prefixed with the era code
  • CP_QUALIFIED_DATE_P — Returns the era-formatted qualified date global, populated only when report type equals '3'.
  • CP_OUTPUT_DATE_GLOBAL_P — Returns the era-formatted output (print) date global.
  • CP_REPORT_TITLE_P — Returns the report title string used in the layout header.
  • CP_TARGET_DATE_TITLE_P — Returns the descriptive title accompanying the target date.
  • CP_NOTE_TITLE_P — Returns the title for the report note section.

Each CP_*_P function follows the standard XML Publisher pattern of exposing a package-level global as a report placeholder.

Tables Accessed

The ETRM metadata documents no direct table references via APPS synonyms. Data is obtained indirectly through the payroll balance API layer, specifically PAY_JP_BALANCE_PKG.GET_ENTRY_VALUE_CHAR and GET_ENTRY_VALUE_DATE, invoked against balance definition identifiers such as the UI number and qualified date inputs. These APIs resolve the underlying payroll balance and input value tables at runtime. The package also depends on PAY_JP_REPORT_PKG helper routines (including SUBSTRB2 and TO_ERA) for string and era-calendar manipulation.

Usage Notes

The package is not referenced by any other documented package, confirming it is a terminal, report-specific artifact. It is invoked through the Oracle Payroll Japanese statutory report concurrent program, with the XML Publisher engine calling BEFOREREPORT before data retrieval and AFTERREPORT afterward, while the CP_* functions populate placeholders in the RTF layout. The report type parameter governs conditional logic, including qualified date formatting. Customizations should treat the package as report metadata and avoid direct invocation, since its globals are populated only within the report execution lifecycle. The package conforms to the ETRM API classification OTHER, reflecting its non-standard, report-support role.