Search Results populate_re_data_tag

Overview

PAY_US_PSD_GENERIC_EXTRACT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. It exists to support the "PSD Periodic Wage Listing Report" concurrent process, a United States payroll reporting requirement that produces wage listings for state and federal reporting purposes. The package supplies the generic database components used by that process to extract archived payroll data, validate it, and construct the XML elements that form the report output.

The header history shows the package was created in July 2012 (version 115.0, Bug 11712075) and was subsequently revised several times through November 2012. The bulk of the early revisions increased the number of employee XML tags emitted; later revisions added yearly reporting support and corrected a name-length issue affecting the GRE (Government Reporting Entity) name. The file is payuspsdgnxtract.pkh, and its version stamp (120.0.12020000.7) confirms it is the 12.2 code line.

Key Procedures and Functions

Seven procedures are documented for this package. Parameter lists are intentionally not reproduced here; their purposes are as follows.

• POPULATE_RA_DATA_TAG — Populates the XML tag that carries the Reporting Agent (RA) data record. The header comment identifies this as the procedure used to populate the tag for the RA Data Record.
• POPULATE_ARCH_TRANSMITTER — Constructs the XML element describing the archived transmitter information, accepting a payroll action identifier, tax unit identifier, date earned, and reporting year.
• POPULATE_RE_DATA_TAG — Populates the XML tag holding the Reporting Employer (RE) data record.
• POPULATE_ARCH_EMPLOYER — Builds the archived employer XML element used within the report payload.
• POPULATE_EE_DATA_TAG — Populates the XML tag for the employee (EE) data record. This is the procedure most frequently associated with the search term "populate_ee_data_tag," and it is the component that was repeatedly expanded across versions 115.2 through 115.5 to increase the number of employee XML tags.
• POPULATE_ARCH_EMPLOYEE — Constructs the archived employee XML element, drawing on the employee data assembled by the tag procedures.
• CONVERT_SPECIAL_CHAR — Converts or escapes special characters so that extracted payroll values can be safely embedded in XML output.

Tables Accessed

The package reads through APPS synonyms for the following objects. The Fast Formula archive tables — FF_ARCHIVE_ITEMS, FF_ARCHIVE_ITEM_CONTEXTS, and FF_CONTEXTS — provide the archived payroll balance and context values that the extract emits. FF_DATABASE_ITEMS supplies the definitions of the database items whose values are written into the XML tags. HR_ORGANIZATION_INFORMATION provides organization-level attributes, notably the employer and GRE naming data referenced in the version history. PER_ALL_ASSIGNMENTS_F and PAY_ASSIGNMENT_ACTIONS supply assignment and payroll action details for the employees included in the wage listing. DUAL is used for single-row constructs, and PLITBLM is the PL/SQL table used for in-memory collections during tag assembly.

Usage Notes

The package is not a form-level API. It is invoked in the context of the PSD Periodic Wage Listing Report concurrent program, which drives extraction of archived payroll data and generates the XML document required for periodic wage reporting. One other package in the EBS instance references it, indicating it is a helper layer rather than a standalone entry point. Because the package is declared AUTHID CURRENT_USER and its procedures are generic tag-population routines, custom code should invoke the report process rather than calling the tag procedures directly, unless extending the report to emit additional employee-level elements — the exact pattern followed by the 115.x revisions that increased the number of employee XML tags.