Search Results vets_mag_report

Overview

PER_VETS_MAG_REPORT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM API classification type "OTHER." The name, parameter set, and referenced tables indicate that it supports the U.S. Department of Veterans Affairs (VA) Veterans Employment and Training Service (VETS) Military Apprenticeship Grant (MAG) reporting requirement. The package produces a structured report of employees participating in apprenticeship or on-the-job training programs, drawing date-ranged data from Oracle Human Resources and presenting results filtered by organization hierarchy, business group, and establishment. It is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking session rather than as the package owner, a design typical of report-generating packages exposed to concurrent processing. The package header carries the internal revision identifier pevetmag.pkh 120.0.12010000.1 (2008/07/28), which places its base development in the R12 code line and indicates continuing availability through 12.1.1 and 12.2.2 maintained releases.

Key Procedures and Functions

The package exposes a single documented procedure:

• VETS_MAG_REPORT — The sole entry point, implemented as a concurrent-program style procedure. Its signature includes the standard concurrent manager output parameters errbuf (OUT NOCOPY VARCHAR2) and retcode (OUT NOCOPY NUMBER), followed by report-specific inputs: a start date and end date (VARCHAR2), a hierarchy identifier and hierarchy version identifier (NUMBER), a business group identifier (NUMBER), and an "all establishments" flag (VARCHAR2). The errbuf/retcode pair confirms the procedure is designed to return completion status and error text to the concurrent manager rather than to a calling form. No other public procedures or functions are documented for this package.

Tables Accessed

ETRM metadata records the following APPS synonyms as referenced objects, all consulted in read-only fashion to assemble the report:

• HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION — organization definitions and their descriptive/classification attributes, used to resolve establishments and hierarchy membership.
• HR_LOCATIONS_ALL and HR_LOCATION_EXTRA_INFO — address and supplementary location details for reporting establishments.
• PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — the dated person and assignment records that identify employees active within the report period.
• PER_PERIODS_OF_SERVICE — hire and service dates used to determine eligibility and tenure during the reporting window.
• PER_JOBS — job definitions, used to classify apprenticeship or training positions.
• PER_GEN_HIERARCHY_NODES — the generic hierarchy structure that drives the p_hierarchy_id and p_hierarchy_version_id filtering logic.

Usage Notes

PER_VETS_MAG_REPORT is not referenced by any other documented package, so it functions as a terminal consumer of HR data rather than a shared library. Its parameter profile mirrors a concurrent program definition: date range, hierarchy, hierarchy version, business group, and an all-establishments toggle. It is therefore normally registered and run as a concurrent program from the Reports or Requests responsibility, with the concurrent manager supplying errbuf and retcode. Custom code may also invoke it directly, provided the caller passes valid hierarchy and business group identifiers for the target legislation and supplies adequately sized output variables. Because the package is AUTHID CURRENT_USER, the invoker must have the necessary privileges on the underlying HR tables and APPS synonyms. Organizations subject to VETS reporting should schedule it for the required reporting period and archive the output for regulatory submission.