Search Results convert_into_xml

Overview

APPS.PER_US_VETS_100A_SINGLE_PKG is a United States–specific Oracle HRMS reporting package that supports generation of the VETS-100A Federal Contractor Report, the annual filing historically required by the U.S. Department of Labor for covered federal contractors and subcontractors. The package resides in the APPS schema and is classified as a standalone (OTHER) package rather than a public API; it is intended to be driven by Oracle's seeded concurrent program for VETS-100A reporting. Its role is to gather veteran-status and assignment information for a selected business group or hierarchy, evaluate the recency of each employee's veteran data, assemble the reporting rows, and render the results in both human-readable and structured XML form for downstream submission. The header references pervetss100a.pkb version 120.16, indicating the file has been maintained through multiple Oracle HRMS patch levels in the 11i and 12.x lineages.

Key Procedures and Functions

• GET_VETS100A_DATA — The main entry point, invoked as a concurrent program execution procedure. It accepts standard concurrent parameters (errbuf, retcode) plus a business group identifier, hierarchy and hierarchy version identifiers, a reporting date range, state, and flags controlling new-hire display, totals, and audit output. It drives the report by opening cursors over the general hierarchy (name, version number, entity, and node identifiers) and the underlying HR tables, then delegates formatting and output.
• CONVERT_INTO_XML — Produces the XML representation of the collected VETS-100A data. This routine is central to the reporting flow because the VETS-100A filing ultimately requires a structured electronic submission; the procedure transforms the internal cursor results into the XML document expected by the reporting output.
• CHECK_RECENT_OR_NOT — A helper function that returns a count used to determine whether an employee's veteran information is recent relative to the report end date. It queries PER_PEOPLE_EXTRA_INFO for the 'VETS 100A' information type and compares the stored information date against the report end date using a series of month-based intervals (0–12, 12–24, 24–36, and a 36-month adjustment of two days). If an error occurs, it returns zero, defensively suppressing failures.
• WRITE_TO_CONCURRENT_OUT — Writes formatted report lines to the concurrent program output file so the result is viewable from the Requests form and printable on the concurrent manager's output device.
• WRITE_TO_CONCURRENT_LOG — Writes diagnostic and status messages to the concurrent manager log, supporting debugging and auditability of report runs.

Tables Accessed

The package reads person and assignment facts from PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F, and period-of-service data from PER_PERIODS_OF_SERVICE. Veteran survey responses are held in PER_PEOPLE_EXTRA_INFO, filtered by the 'VETS 100A' information type, which is the core of the recency check. Location and establishment information comes from HR_LOCATIONS_ALL and HR_LOCATION_EXTRA_INFO, with organization attributes from HR_ORGANIZATION_INFORMATION. Hierarchical reporting structures are resolved through PER_GEN_HIERARCHY, PER_GEN_HIERARCHY_VERSIONS, and PER_GEN_HIERARCHY_NODES, allowing the report to be scoped to a business group, organization hierarchy, or hierarchy node. All references are made through APPS synonyms.

Usage Notes

PER_US_VETS_100A_SINGLE_PKG is not referenced by any other database package, confirming that it functions as a top-level reporting driver rather than a shared library. It is normally invoked through the seeded VETS-100A concurrent program, which supplies the business group, hierarchy, date range, state, and display parameters. Direct invocation from custom PL/SQL is possible by calling GET_VETS100A_DATA with the appropriate concurrent arguments, but such use should be confined to scheduled reporting because output is produced only through the concurrent manager's file and log writers. Because the package depends on the 'VETS 100A' information type in PER_PEOPLE_EXTRA_INFO, users must ensure that veteran survey data is populated and current; otherwise CHECK_RECENT_OR_NOT returns zero and employees are excluded from the applicable interval. The package is U.S. legislative reporting only and is not executed as part of normal HRMS transaction processing in releases 12.1.1 or 12.2.2.