Search Results write_data

Overview

PAY_ASG_DEBUG_PKG is an Oracle EBS Payroll (PAY) schema package owned by APPS and classified as OTHER within the ETRM documentation repository for release 12.2.2 (and compatible with 12.1.1). Its documented purpose is to produce a diagnostic or output file for an assignment (employee or applicant assignment record) in a user-specified format, with HTML identified as the supported output format. The package name and the single documented procedure write_data indicate a debugging utility rather than a core payroll business-processing routine. It assembles the most relevant assignment-level payroll configuration and derived tax data for a given assignment and renders that data into a readable report, allowing support analysts, payroll administrators, or implementers to inspect the effective payroll setup and tax rules that apply to a specific assignment at a point in time.

Key Procedures and Functions

The package exposes a single documented procedure, WRITE_DATA. As declared in the package specification, WRITE_DATA accepts an errbuf out parameter, a retcode out parameter, and an input parameter named p_assignment_id that identifies the assignment to be reported on. This is the standard Oracle concurrent program interface (errbuf/retcode) plus a single business argument, which strongly suggests WRITE_DATA is designed to be invoked directly from a concurrent program or a report definition.

• WRITE_DATA — Accepts a concurrent-manager error buffer and return code, together with an assignment identifier, and writes the debug output for that assignment. The procedure drives the query of assignment, element, and tax configuration data and formats the result as HTML.

No other procedures or functions are documented for this package; the specification contains only WRITE_DATA.

Tables Accessed

The package reads from a set of core Payroll and HR tables via APPS synonyms:

• PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F — retrieve the element entry header and input values attached to the assignment, showing which earnings and deductions exist and their input values.
• PAY_ELEMENT_LINKS_F and PAY_ELEMENT_TYPES_F — identify the elements eligible for the assignment and their classifications, yielding the effective element configuration.
• PAY_US_EMP_FED_TAX_RULES_F, PAY_US_EMP_STATE_TAX_RULES_F, PAY_US_EMP_CITY_TAX_RULES_F, PAY_US_EMP_COUNTY_TAX_RULES_F — capture the US federal, state, city, and county tax rules applicable to the assignment, indicating the package is oriented toward US payroll tax debugging.
• PER_ADDRESSES — resolves address data associated with the assignment or its tax jurisdictions.
• PER_PAY_BASES — supplies pay basis information that governs the assignment's payroll frequency and calculation basis.

Usage Notes

PAY_ASG_DEBUG_PKG is not referenced by any other package (referenced-by count 0), so it functions as a leaf-level diagnostic utility. It is typically invoked as a concurrent program, either from a standard Oracle Payroll debug or "Assignment Debug" request, or from a custom concurrent program registered against WRITE_DATA. Because the procedure conforms to the concurrent manager signature (errbuf, retcode, p_assignment_id), the assignment identifier can be supplied as a concurrent program parameter. The output HTML file is useful during payroll implementation, post-implementation support, and tax troubleshooting, since it consolidates element entries, element links, pay basis, addresses, and multi-level US tax rules for one assignment. The package carries a $Header dated 2005, indicating long-standing stability and no expected changes; it should be treated as a diagnostic tool rather than a supported extension point, and any custom invocation should reference the APPS synonym to respect the schema design.