Results for “ghr_mti_app”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GHR_MTI_APP is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Human Resources "Mass Transfer" and related Mass Information (MTI) processing framework. It is most closely associated with the U.S. federal Standard Form 52 (SF-52, Request for Personnel Action) integration, providing the database-side logic required to evaluate an employee's eligibility for a personnel action and to populate the request records that drive the mass transfer of employees into new positions, organizations, or assignments. In EBS 12.1.1 and 12.2.2, the package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking session rather than the definer, which is characteristic of packages intended to be called from within the HRMS security context that already holds the appropriate grants on the underlying GHR and PER tables.

The package includes a user-defined exception, mass_error, which allows calling programs to trap error conditions raised during mass transfer processing in a controlled manner rather than relying solely on generic Oracle error handling.

Key Procedures and Functions

• POPULATE_AND_CREATE_52 — The principal driver procedure. It creates and populates SF-52 request records for a specified business group, mass transfer name and ID, and effective date, using a standard concurrent-program style interface (error buffer and return code outputs). It is the entry point most commonly associated with a concurrent program submission.
• CHECK_ELIGIBILITY — A boolean function that determines whether a given person is eligible for processing as of a supplied effective date. It returns TRUE or FALSE and is used to filter the population before records are created.
• ASSIGN_TO_SF52_REC — A procedure that assembles and writes a single SF-52 record for one person. Its parameter list enumerates the many federal personnel data elements required on the form, including personal identifiers, position and job details, pay plan and grade, veterans preference, tenure, FLSA category, duty station, citizenship, and related assignment attributes.
• PR — A documented private or supplementary routine referenced in the ETRM metadata. Its exact role is not expanded in the available source excerpt, so it should be treated as an internal helper supporting the SF-52 population flow.

Tables Accessed

The package reads and writes several HRMS and GHR tables via APPS synonyms:

• GHR_MASS_TRANSFERS — stores the definition of the mass transfer batch being processed; used to resolve the transfer context.
• GHR_PA_REQUESTS and GHR_PA_REQUEST_EXTRA_INFO — hold the personnel action request headers and their additional attribute information, populated by POPULATE_AND_CREATE_52 and ASSIGN_TO_SF52_REC.
• PER_PEOPLE_EXTRA_INFO and PER_POSITION_EXTRA_INFO — supply and store person-level and position-level descriptive flexfield or extra information needed to complete the SF-52 record.

Usage Notes

GHR_MTI_APP is typically invoked from Oracle HRMS concurrent programs or from the mass transfer setup forms rather than called directly by end users. Because it is registered as an API classified as OTHER, it is intended to be called from server-side PL/SQL within the APPS environment. The package is referenced by one other package, indicating it is part of a small dependency chain in the mass information processing area. Customizations should respect the AUTHID CURRENT_USER behavior and the existing mass_error exception handling, and any direct call should supply a valid business group, mass transfer ID and name, and effective date.