Search Results ssa_sqwl

Overview

APPS.PAY_US_MMREF_FUNCTION_PKG is a PL/SQL package body in Oracle E-Business Suite that supports the generation of magnetic media (magtape) W-2 and year-end legislative reports for United States payroll. Its header comment identifies its primary purpose as supporting MMREF (Magnetic Media Reporting and Electronic Filing) format output while incorporating "magtape resilience" and the newer end-of-year design introduced for US statutory reporting. The package was created in January 2002 and evolved through a series of versioned changes driven by legislative and defect requirements, including SUI (State Unemployment Insurance) quarterly wage listing (SQWL) reporting, city and local tax reporting, and annual SSA/ICESA reporting formats.

Although the user search term "ssa_sqwl" does not itself appear as an object name, it reflects the functional domain of this package: Social Security Administration reporting and State Quarterly Wage Listing reporting. The package's history shows direct involvement in SSA hour calculations (version 115.7) and SQWL-specific logic such as exclusion of sick hours for Washington SQWL (version 115.9, bug 2873584) and negative-hour checking for non-MMREF states (version 115.9, bug 2985476). The package thus acts as a computation and data-extraction layer beneath the US payroll year-end and quarterly reporting programs.

Key Procedures and Functions

• GET_HOURS_WORKED — Calculates and returns hours worked for reporting purposes. The package history records its addition in version 115.1, subsequent modification to pass new SUI hours-by-state balances (bug 2442629), removal of padding in NH hours calculation (version 115.2), and the addition of SSA, ICESA, and New Jersey formula hour calculations (version 115.7). It is central to state and federal hour reporting on magtape output.
• GET_SQWL_EXTRA_INFO — Created in version 115.6 (bug 2873551) to calculate the SUI_ER_SUBJ_WHABLE and SUI_ER_PRE_TAX values required for State Quarterly Wage Listing reporting. Later enhanced to split the GET_ARCHIVED_VALUE cursor (version 115.10) and to include additional OUT parameters (version 115.12, bug 3334497). It supplies employer-level SUI taxable and pre-tax amounts used on SQWL magnetic media.
• GET_CITY_VALUES — Supports local and city tax reporting on magtape. The history notes a change (version 115.3) to derive Rita/CCA city codes from pay_us_city_tax_info_f.city_information1 beginning at the sixth character position, generalizing local magtape handling. It is used to populate locality tax identifiers on the output file.

Tables Accessed

The package references several APPS synonyms. PAY_US_CITY_NAMES and PAY_US_CITY_TAX_INFO_F provide city and local tax jurisdiction data, including the city_information1 attribute used by GET_CITY_VALUES. FF_ARCHIVE_ITEMS, FF_DATABASE_ITEMS, and FF_USER_ENTITIES belong to the FastFormula infrastructure and are used to retrieve archived or database item values, notably through the GET_ARCHIVED_VALUE cursor employed by GET_SQWL_EXTRA_INFO. PAY_ASSIGNMENT_ACTIONS supplies assignment-level action context for processing payroll records. PLITBLM is the Oracle Applications PL/SQL index-by table (string) utility type package used for in-memory collections and parameter handling, consistent with the "nocopy" hint noted for OUT and IN OUT parameters in version 115.4.

Usage Notes

This package is documented as APPS-owned with an API classification of OTHER, meaning it is not a formally supported public API and should be treated as an internal implementation object. It is referenced by zero other packages, indicating that its callers are external to the PL/SQL package dependency graph — typically the US payroll year-end and quarterly magnetic media concurrent programs, and possibly report or archive utilities that invoke its functions to assemble MMREF, SSA, and SQWL output records. Because the functions are designed around legislative formatting and hours/tax computation, they are invoked during year-end W-2 processing and quarterly SUI filing runs rather than during ordinary payroll calculation. Customizations should avoid direct dependency on this package where possible; when extension is required, the documented behavior should be validated against the specific EBS release (12.1.1 or 12.2.2) since the header reflects a 120.1 file version.