Search Results set_print_options

Overview

APPS.PAY_CORE_XDO_UTILS is a Payroll-internal PL/SQL utility package that supports the archive and de-initialization lifecycle of Oracle EBS payroll reporting and BI Publisher (XML Publisher / XDO) output. It forms part of the Oracle Payroll "core" utility layer, alongside packages such as PAY_CORE_UTILS, and is invoked by payroll batch processes that generate or archive report output, typically during the final phases of a payroll action when concurrent request output must be finalized and its corresponding template and report definitions are no longer needed. The package body header ($Header: paycorexdoutil.pkb 120.0.12000000.1, dated 2007) indicates it is an Oracle-owned, non-shipped-interface object intended for internal use only.

In Oracle EBS 12.1.1 and 12.2.2, the package operates within the XML Publisher/XDO architecture, resolving template codes to template names, retrieving the concurrent program and application short name associated with a payroll action, and iterating over the report definitions linked to a given report group and category. The search term "set_print_options" relates to the print and output handling that this package facilitates when payroll report output is archived and its print options are applied via the underlying XDO and FND concurrent request machinery.

Key Procedures and Functions

• ARCHIVE_DEINIT — The principal documented procedure. It accepts a payroll action identifier and performs the de-initialization work required after payroll report output has been archived. Using cursors defined in the body, it resolves the request identifier from PAY_PAYROLL_ACTIONS, derives the application short name and application ID, resolves the template name from the template code, and iterates the report definitions, levels, types, and variables associated with the payroll action's report group and report category. This data feeds the subsequent archive and print-option processing performed by the XDO and concurrent request layer.
• STANDARD_DEINIT — The second documented procedure. It performs the standard de-initialization cleanup for the package, complementing ARCHIVE_DEINIT by handling the non-archive teardown path. Together the two procedures provide the paired entry points used by payroll report generation flows to release state and finalize output.

Tables Accessed

The package reads and processes data across the following documented tables (via APPS synonyms):

• PAY_PAYROLL_ACTIONS — source of the request identifier and legislative parameters used to drive report selection.
• PAY_REPORT_GROUPS, PAY_REPORT_DEFINITIONS, PAY_REPORT_CATEGORIES, PAY_REPORT_CATEGORY_COMPONENTS, PAY_REPORT_VARIABLES — the payroll report configuration hierarchy from which report definitions, types, levels, and style sheet variables are resolved.
• PAY_ASSIGNMENT_ACTIONS, PAY_FILE_DETAILS — payroll action output and file detail records touched during archive/de-initialization.
• FND_CONCURRENT_REQUESTS, FND_CONCURRENT_PROGRAMS — used to resolve the concurrent program and application short name for the payroll action's request.
• XDO_TEMPLATES_B, XDO_TEMPLATES_TL — the XML Publisher template base and translation tables, used to map template codes to template names.
• DBMS_LOCK, PLITBLM — Oracle-supplied packages used for locking and PL/SQL table manipulation during processing.

Usage Notes

PAY_CORE_XDO_UTILS is not a user-facing API. It is invoked internally by Oracle Payroll concurrent programs and by three other packages that reference it, generally during the archive and post-processing stages of payroll report generation. Because the procedures depend on the state established by a payroll action and its concurrent request, they must be called in the correct sequence relative to payroll action initialization and report generation. The package is not documented for direct customer invocation, and any customization should be limited to the supported payroll reporting extension points rather than calling these procedures directly. In 12.1.1 and 12.2.2 the package behaves identically, as its header version 120.0.12000000.1 predates the 12.2 online patching model and contains no editioning-specific logic.