Search Results decode_value

Overview

APPS.PAY_PAYJPWTM_XMLP_PKG is the generated PL/SQL package body that backs an Oracle E-Business Suite XML Publisher (XMLP) concurrent program report for Japanese payroll. The package name suffix PAYJPWTM identifies it as belonging to the Oracle Payroll (PAY) product with a Japan (JP) localization, and the XMLP_PKG convention indicates it is the report logic holder produced by the XML Publisher report registration process. Its business purpose is to resolve runtime report parameters and assemble the data set that the report template consumes, in this case for a payroll withholding tax or tax-withholding archive report tied to payroll action type JPTW.

Key Procedures and Functions

The documented package exposes two program units within the body, though ETRM lists zero formally registered procedures, reflecting its status as a generated report package rather than a reusable API.

• AFTERPFORM — The standard XML Publisher "after parameter form" hook. It is invoked after the concurrent program parameter form is submitted and before the report query executes. It computes the effective date range from the P_YEAR parameter (building P_START_DATE as January 1 and P_END_DATE as the following December 31 via ADD_MONTHS(...,12)-1), resolves the withholding-agent input value through HR_JP_ID_PKG.INPUT_VALUE_ID using the COM_ITX_INFO and WITHHOLD_AGENT lookup keys, and concatenates up to six inter-company tax organization IDs into a single delimited string. It also opens an internal cursor (CSR_USE_ARCHIVE_FLAG) to detect whether an archive-mode payroll action exists for the reporting period.
• CONCATENATE — A helper function that appends a numeric value to an accumulating text buffer with a configurable separator (defaulting to a comma). It is used by AFTERPFORM to produce the L_CONCAT_ORGS string that is passed forward to the report's after-parameter trigger or bind variables.

Tables Accessed

The only table documented in the excerpt is PAY_PAYROLL_ACTIONS (aliased PPA), read through the APPS synonym. It is queried in the archive-flag cursor filtered on REPORT_TYPE = 'JPTW', REPORT_QUALIFIER = 'JP', REPORT_CATEGORY = 'ARCHIVE', a date range between P_START_DATE and P_END_DATE, matching business group, and ACTION_TYPE = 'X'. The query returns a single 'Y' from DUAL when a matching archive action exists, which drives conditional logic in the report. No DML is performed against this table; access is read-only. Additional data retrieval is delegated to the report's own query, not shown here.

Usage Notes

This package is not intended for direct invocation by custom code. It is registered as the report logic for the associated XML Publisher concurrent program and is executed by the Oracle Payroll concurrent manager when the report is submitted, using the standard AFTERPFORM/parameter resolution lifecycle. In EBS 12.1.1 and 12.2.2 the package resides in the APPS schema and is versioned under a $Header revision (here 120.3, dated 2008). The decode_value search term commonly associated with such reports refers to the token-substitution mechanism used inside the XML template to translate coded values returned by the query; however, the decode logic itself is not implemented in this package body, which focuses on parameter derivation and the concatenation of organization identifiers.