Search Results check_recent_or_not

Overview

APPS.PER_VETS_MAG_100A_REPORT is a PL/SQL package within the Oracle E-Business Suite Human Resources (Oracle HRMS) module, defined with AUTHID CURRENT_USER. It supports a specialized regulatory reporting requirement historically associated with United States Veterans' Employment and Training Service (VETS) reporting obligations. The "MAG 100A" designation refers to a VETS reporting format used by federal contractors to file the annual VETS-100A report, which captures information on the employment of veterans across business establishments. The package produces a hierarchical report spanning a date range, driven by organization hierarchy and business group parameters. Though the underlying VETS-100A report was retired by federal agencies in favor of the VETS-4212, this package remains shipped in 12.1.1 and 12.2.2 installations for backward compatibility and historical reporting. The package header retains a Bug#8974111 modification note and headers dated 2012, consistent with its maintenance lifecycle.

Key Procedures and Functions

• VETS_MAG_REPORT — The primary public procedure. It accepts an error buffer and return code (standard concurrent program OUT parameters), a start and end date, a hierarchy identifier and hierarchy version identifier, a business group identifier, and an "all establishments" flag. Its purpose is to compile and emit the VETS/MAG-100A report data, scoped by the supplied date range, hierarchy, and business group, optionally consolidating across all establishments. The error buffer and return code support concurrent manager error handling, indicating it is designed to run as a concurrent program.
• CHECK_RECENT_OR_NOT — A public function added under Bug#8974111. It takes a person identifier and a report end date and returns a numeric indicator. Its documented purpose is to classify whether a person's data qualifies as "recent" relative to the report end date, a common pattern for veteran or service status validations tied to eligibility windows.

The package exposes no additional documented procedures or functions. It is not referenced by any other package, confirming it is invoked directly rather than as a shared library dependency.

Tables Accessed

• PER_ALL_PEOPLE_F — Core person/employee records; supplies the population base for the report.
• PER_ALL_ASSIGNMENTS_F — Assignment details linking people to organizations, jobs, and periods.
• HR_ALL_ORGANIZATION_UNITS — Organization and establishment definitions used to scope hierarchy reporting.
• HR_ORGANIZATION_INFORMATION — Organization classifications and attributes relevant to establishment filtering.
• HR_LOCATIONS_ALL and HR_LOCATION_EXTRA_INFO — Location and location-specific descriptive data used to satisfy report fields.
• PER_GEN_HIERARCHY_NODES — The generic hierarchy structure underpinning the hierarchy and version parameters.
• PER_JOBS — Job definitions to categorize report groupings.
• PER_PEOPLE_EXTRA_INFO — Descriptive flexfield and extra information, typically carrying veteran or protected-veteran status attributes.
• PER_PERIODS_OF_SERVICE — Periods of service supporting "recent" determinations used by the eligibility function.

Usage Notes

This package is normally executed through a concurrent program registered against the VETS_MAG_REPORT procedure, with the error buffer, return code, and user parameters supplied automatically by the concurrent manager. Parameters such as hierarchy ID, hierarchy version ID, business group, and the all-establishments flag are entered at submission time. Direct custom invocation is possible but requires the caller to supply non-defaulted parameters explicitly. The CHECK_RECENT_OR_NOT function is most useful when embedded in report logic or custom extensions needing per-person recency evaluation against a report cutoff date.