Search Results write_to_concurrent_out

Overview

APPS.PER_US_VETS_100A_LIST_PKG is a United States statutory reporting package within Oracle E-Business Suite Human Resources (Oracle HRMS). Its purpose is to generate the VETS-100A report — the U.S. Department of Labor Veterans' Employment and Training Service filing that covered federal contractors and subcontractors for reporting years through 2013 (the report was subsequently replaced by the VETS-4212). The package assembles the veteran-employment data required by that filing across a specified business group, organizational hierarchy, and date range, then emits the results to the concurrent manager's output and log streams.

The package was last updated under the source control header pervetsl100a.pkh 120.2.12020000.1 (June 2012), and the presence of a bug-fix reference (Bug#8974111) indicates the code has been maintained to correct reporting behavior. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, which is typical for EBS concurrent report seed data owned by APPS.

Key Procedures and Functions

• GET_VETS100A_DATA — the main concurrent-program entry point. It carries the standard concurrent parameters (errbuf, retcode) plus inputs for business group, hierarchy, hierarchy version, start and end dates, state, new-hire inclusion, totals, and audit-report flags. It drives extraction of the reporting population and controls the shape of the output.
• CONVERT_INTO_XML — a helper that formats a name/value pair of a supplied type into XML markup, supporting the structured electronic layout of the VETS-100A output.
• CHECK_RECENT_OR_NOT — added for Bug#8974111; evaluates a person against the report end date to determine whether the individual qualifies as a recent hire or falls into a comparable exclusion window.
• WRITE_TO_CONCURRENT_OUT — writes a text line to the concurrent program output file.
• WRITE_TO_CONCURRENT_LOG — writes a text line to the concurrent program log file for diagnostics.

Tables Accessed

The package reads person and assignment data from PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F, and location data from HR_LOCATIONS_ALL and HR_LOCATION_EXTRA_INFO, which supply the work-site and state filtering used by the VETS-100A. HR_ORGANIZATION_INFORMATION and PER_PERIODS_OF_SERVICE provide organizational and service-history context for veteran categorization. Hierarchical reporting is supported through PER_GEN_HIERARCHY, PER_GEN_HIERARCHY_NODES, and PER_GEN_HIERARCHY_VERSIONS; veteran-specific attributes are drawn from PER_PEOPLE_EXTRA_INFO. DUAL is used for single-row lookups and constants. Access is made through APPS synonyms.

Usage Notes

This package is not referenced by any other package; it is invoked directly, most commonly as the underlying PL/SQL for the seeded VETS-100A concurrent program in Oracle HRMS. Administrators run it from the Submit Requests form, supplying business group, hierarchy, and reporting period. Because of the AUTHID CURRENT_USER clause and the standard errbuf/retcode signature, it can also be called from custom concurrent programs or external scheduling tools. Note that for the user's search context ("quicksilver veterinary services"), this object is unrelated to the search string.