Search Results pay_us_custom_sqwl_format_rec




Overview
Explore in AI Chat

Overview

PAY_US_CUSTOM_SQWL_FORMAT_REC is a PL/SQL package body owned by the APPS schema that supports the formatting of the United States Quarterly Wage Listing (SQWL) electronic wage report. The SQWL is the state-level wage reporting submission used to satisfy state unemployment insurance reporting obligations, and it requires that employer and employee wage data be rendered in a fixed, state-defined record layout. This package body encapsulates the custom formatting logic that converts Oracle Payroll data into those positional records, providing a customization point that is separate from the delivered Oracle reporting infrastructure.

The package is classified as OTHER in the ETRM metadata, indicating that it is not a public Oracle Payroll API and is not intended for general third-party invocation. Its body is reported as VALID at release 12.1.1 and 12.2.2, and it is not referenced by any other database object, confirming its role as a terminal formatting utility invoked directly by the reporting process rather than as a shared dependency.

Key Procedures and Functions

The documented package exposes two procedures:

  • FORMAT_SQWL_CUSTOM_EMPLOYER — Produces the employer-level portion of the quarterly wage listing record. It handles the header and employer identification segment of the state submission, drawing on federal tax and reporting utility data to populate the employer fields required by the state layout.
  • FORMAT_SQWL_CUSTOM_EMPLOYEE — Produces the employee-level portion of the quarterly wage listing record. It formats the individual worker wage and identification detail that follows the employer segment in the submission file.

Both procedures are customization hooks: the "CUSTOM" element of the package name signals that the delivered Oracle logic has been extended or overridden to meet a specific state's or employer's record specification. Parameter lists are not documented in the ETRM excerpt and are therefore not reproduced here.

Tables Accessed

The package references the following database objects through APPS synonyms:

  • PAY_US_FEDERAL_TAX_INFO_F — the Oracle Payroll federal tax information table. The package reads this table to obtain the employer-level tax identifiers and related federal reporting attributes needed to populate the SQWL employer header segment.
  • PAY_US_REPORTING_UTILS_PKG — a delivered reporting utility package that supplies shared extraction and formatting routines used by United States statutory reporting.
  • FND_GLOBAL — the Oracle Application Object Library global context package, used to resolve the runtime session context (such as business group and user) under which the formatting executes.
  • HR_UTILITY — a shared Human Resources utility package used for common date and value conversion operations.

The package also references the STANDARD package supplied by SYS. No writes to the documented tables are implied; the package is a read-and-format component.

Usage Notes

PAY_US_CUSTOM_SQWL_FORMAT_REC is invoked as part of the quarterly wage listing generation flow for United States payroll. It is normally called from the reporting process responsible for producing the SQWL submission file, where the two formatting procedures are executed in sequence to emit the employer segment followed by the employee wage detail. Because the object is not referenced by any other database object, it has no indirect callers and must be invoked explicitly.

Typical invocation paths include the Oracle Payroll statutory reporting concurrent programs and customer-authored reporting wrappers that require a state-specific SQWL layout. The dependency on FND_GLOBAL means the package must run inside an initialized Oracle EBS session with a valid application context; ad hoc execution from SQL*Plus outside an EBS session will not resolve the global context correctly.

Because the package is a custom delivery, it is not overwritten by standard Oracle patching, but it must be reviewed and revalidated after any upgrade to dependent objects such as PAY_US_FEDERAL_TAX_INFO_F or PAY_US_REPORTING_UTILS_PKG. Changes to state wage reporting formats require corresponding modification of the formatting procedures and subsequent recompilation of the package body.