Search Results transfer_contact_title




Overview
Explore in AI Chat

Overview

The APPS.PAY_MWS_MAGTAPE_REPORTING package is a PL/SQL server-side component within Oracle E-Business Suite that supports the reporting and extraction of magnetic media (magtape) data associated with US payroll tax filing requirements. Its primary role is to assemble the header, transmitter, and state-level context information required to produce magnetic media submissions to tax authorities, typically in legacy fixed-format tape or file layouts. The package operates in conjunction with the broader MWS (Magnetic Media Submission) framework, which historically governed federal and state tax reporting formats such as those used for W-2 and quarterly tax returns.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the defining owner, which is significant for concurrent program execution and security context. The source excerpt shows cursors such as us_mws_transmitter and us_mws_state that retrieve taxpayer and transmitter attributes from HR_TAX_UNITS_V, HR_WORKSITE_V, and PAY_STATE_RULES, populating parameters such as TRANSFER_CONTACT_TITLE, TRANSFER_TAPE_MEDIUM, TRANSFER_FIPS_CODE, and related transmitter identifiers. These parameters are consumed downstream by the magtape generation logic.

Key Procedures and Functions

  • RUN_MAGTAPE — The principal driver procedure that orchestrates the magnetic media reporting process. It coordinates the setup of transmitter, state, and employee context and invokes the generation logic.
  • RUN — A supporting execution routine that performs the core processing steps required to assemble the report content, relying on the context established by the cursors and helper calls.
  • REDO — A reprocessing routine intended to regenerate output, typically invoked when a prior magtape run must be repeated or corrected without altering the underlying data.
  • GENERATE_PEOPLE_LIST — Builds the list of employees (assignments) to be included in the magnetic media output, applying the relevant selection criteria for the reporting period and tax unit.

These procedures are documented without explicit parameter lists in the ETRM metadata; parameter configuration is generally supplied through the magtape parameter framework (PAY_MAGTAPE_GENERIC.get_parameter_value) rather than positional arguments.

Tables Accessed

  • HR_ORGANIZATION_INFORMATION — Supplies organization-level attributes used to derive transmitter and reporting entity context.
  • HR_SOFT_CODING_KEYFLEX — Provides descriptive flexfield key flexfield combinations associated with the reporting organization.
  • PAY_ASSIGNMENT_ACTIONS — Identifies assignment-level actions to determine which employees are active and reportable for the period.
  • PAY_PAYROLL_ACTIONS — Defines the payroll action context for the reporting run.
  • PAY_STATE_RULES — Delivers state-specific rules, including FIPS codes and state tax parameters, as shown in the us_mws_state cursor.
  • PAY_DEFINED_BALANCES — Supplies balance values used to compute reportable amounts.

Usage Notes

The package is typically invoked from the Magnetic Media Submission concurrent program or related payroll reporting forms within Oracle Payroll. It may also be called from custom code that extends state or federal magtape reporting. Because it depends on the MWS parameter framework, an execution context (business group, tax unit, and state) must be established before the procedures are run. It is referenced by at least one other package, indicating integration within the wider MWS processing chain. The object is classified as OTHER in ETRM, reflecting its supporting rather than public API role.