Search Results get_organization_name_address




Overview
Explore in AI Chat

Overview

APPS.PAY_US_GET_ITEM_DATA_PKG is a PL/SQL package body in Oracle E-Business Suite (12.1.1 / 12.2.2) that supports the generation of US legislative magnetic media reports, specifically the W-2, W-2C, and SQWL (State Quarterly Wage Listing) returns. Its stated purpose is to derive and validate the data elements required when these year-end reports are written to magnetic tape or file. The package is classified under Oracle's ETRM as OTHER (not a public API), and it is referenced by the package PAY_US_REPORTING_UTILS_PKG, which drives the reporting flow.

The principal data derived by the package covers four categories: contact person information, employer address, employee address, and contact person address. A recurring theme in the package history is the resolution of "multiple primary address" scenarios, particularly where an employee has terminated and subsequently changed address, which previously produced misleading error messages on the W-2 Register. Subsequent versions (115.2 through 115.10) added the country short name to the person_name_address record structure, restricted address cursors to assignments of type 'E' (Employee), and corrected joins against FND_TERRITORIES and FND_TERRITORIES_TL using the user's language.

Key Procedures and Functions

  • GET_CONTACT_PERSON_INFO — Derives the contact person details required on W-2 / SQWL output, sourced from person and assignment data.
  • GET_MMREF_EMPLOYEE_ADDRESS — Returns the employee (recipient) address in the format required for magnetic media reporting.
  • GET_MMREF_EMPLOYER_ADDRESS — Returns the employer address for the same magnetic media output.
  • GET_PERSON_NAME_ADDRESS — The function most frequently associated with the search term; it resolves a person's name together with the associated address, handling the multiple-address condition for terminated employees whose address changed after termination.
  • GET_ORGANIZATION_NAME_ADDRESS — Returns the organization name and its address, typically for the employer or a related legal entity.
  • GET_CPROG_PARAMETER_VALUE — Retrieves the value of a concurrent program parameter, allowing the reporting logic to respond to runtime report selections.

Tables Accessed

The package reads from the following APPS synonyms: PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F for person and assignment records, filtered to assignment type 'E'; PER_ADDRESSES and HR_LOCATIONS_ALL for address data; FND_TERRITORIES and FND_TERRITORIES_TL for territory and country short name resolution; HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, and HR_ALL_POSITIONS_F for organization and position detail; PER_PHONES for telephone information on contact records; and PAY_PAYROLL_ACTIONS for payroll action context. These reads supply the validated fields written into the W-2 and SQWL report records.

Usage Notes

PAY_US_GET_ITEM_DATA_PKG is not intended to be called directly by customers or custom code. It is invoked internally by PAY_US_REPORTING_UTILS_PKG, which is referenced by ten other packages in the year-end reporting subsystem, and it executes in the context of the US W-2 / SQWL concurrent programs. Customers influence its behavior indirectly through the parameters passed to those concurrent programs (surfaced by GET_CPROG_PARAMETER_VALUE) and through the completeness of person, assignment, and address data in the HR tables. Because address resolution depends on language-specific territory joins, the effective user's language environment must be set correctly for correct country short names to appear on output.