Search Results pay_us_loc_change




Overview
Explore in AI Chat

Overview

PAY_US_LOC_CHANGE is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports the processing of employee location changes for United States payroll and tax reporting. The package is classified under the ETRM as an "OTHER" API, meaning it is not a formally published public interface but is instead an internal utility used primarily by concurrent programs and related payroll processes. Its principal business function is to reconcile and propagate employee assignment and location data changes so that tax unit assignments, soft coding flexfield values, and payroll report totals remain consistent. Because employee relocation frequently triggers changes in state, local, and municipal tax jurisdiction, this package serves as the mechanism by which such changes are identified, staged, and applied within Oracle Payroll for US-based employees.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions within this package body:

  • CNT_PRINT_REPORT — Controls the counting and printing of the report output associated with the location change process. It is typically responsible for determining whether report output should be produced and for driving the formatted output of the processing results.
  • GET_INSERT_VALUES — Retrieves and assembles the values required for insertion into the staging or temporary structures used during processing. It serves as the data-gathering step that feeds subsequent insert operations.
  • PUT_INTO_TEMP_TABLE — Inserts the gathered values into a temporary holding table, enabling the package to batch and stage location change records before they are committed to their final destinations or reported upon.
  • UPDATE_TAX — Applies tax-related updates resulting from the employee location change, ensuring that tax unit and jurisdiction references reflect the new location assignment.

These procedures collectively form a pipeline: values are gathered, staged, tax implications are applied, and results are reported.

Tables Accessed

The package references several documented tables through APPS synonyms. HR_SOFT_CODING_KEYFLEX is used to read or validate soft coding flexfield segments associated with assignments and locations. PAY_US_RPT_TOTALS stores aggregated payroll reporting totals for US legislation and is used to record or reconcile totals affected by the location change. PER_ALL_ASSIGNMENTS_F, the effective-dated assignments table, is queried and potentially updated to reflect the changed location and related tax attributes for affected employees. DUAL is referenced for standard single-row PL/SQL logic. Additional dependencies documented in the ETRM include HR_LOCATIONS, HR_ORGANIZATION_UNITS, HR_TAX_UNITS_V, PAY_US_EMP_DT_TAX_RULES, and PER_PEOPLE_F, which supply location, organization, tax unit, and person-level data.

Usage Notes

PAY_US_LOC_CHANGE is not referenced by any other database object, indicating it is invoked directly rather than being called by dependent packages. In practice, packages of this class are typically invoked from concurrent programs or from custom code executed during mass employee location updates, such as when a workforce relocates between tax jurisdictions. The package relies on FND_CONCURRENT and FND_REQUEST for concurrent request submission logic, confirming that it is designed to run within the concurrent manager framework. Administrators and developers should treat this package as an internal implementation object rather than a supported public API; any custom code calling it must be validated carefully during upgrades between releases such as 12.1.1 and 12.2.2, since internal payroll packages may change without notice.