Search Results ghr_mto_int




Overview
Explore in AI Chat

Overview

GHR_MTO_INT is a mass transfer outbound interface package body in the APPS schema of Oracle E-Business Suite. Its purpose is to move HR and Oracle HRMS person, assignment, position, and related data between a source and destination business group or organization using the Mass Transfer Out functional flow. It acts as the technical engine that reads staged records from the GHR_INTERFACE family of tables, validates them against the GHR Mass Transfer configuration, and then writes the resulting rows into core PER and HR tables through the standard HR_API and GHR_API application interfaces. The package is classified as OTHER in the ETRM registry, indicating it is an internal supporting object rather than a public, documented API, though in practice it exposes a broad set of insert and update routines that perform the physical data movement.

Key Procedures and Functions

Twenty-eight documented procedures and functions are recorded for this package. The entry point is MASS_TRANSFER_OUT, which orchestrates the extraction and writing cycle. GET_TRANSFER_PARAMETERS loads the run-time parameters that govern the transfer, while SET_LOG_PROGRAM_NAME and LOG_MESSAGE manage the process log written to GHR_PROCESS_LOG_S for auditing and error reporting. The remaining procedures fall into paired INSERT and UPDATE families that target each entity in the transfer:

The procedures are deliberately granular so that individual entity types can be written in dependency order, and each delegates final validation and insertion to the corresponding GHR or HR API.

Tables Accessed

The package reads and writes the core human resources tables through APPS synonyms: PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENTS_F, PER_ADDRESSES, PER_PEOPLE_EXTRA_INFO, PER_ASSIGNMENT_EXTRA_INFO, PER_CONTACT_RELATIONSHIPS, PER_GRADES, PER_POSITION_DEFINITIONS, PER_POSITION_EXTRA_INFO, and HR_ALL_POSITIONS_F. Staging and control data reside in GHR_INTERFACE, GHR_INTERFACE_S, GHR_MASS_TRANSFERS, and GHR_PROCESS_LOG_S, while HR_LOCATION_EXTRA_INFO supplies location context. Several GHR public views, including GHR_MT_ASSIGNMENTS_F_V, GHR_MT_PEOPLE_F_V, GHR_MT_POSITIONS_V, and GHR_DUTY_STATIONS_V, are used for validated reads. The package also calls supporting APIs such as GHR_API, HR_API, GHR_HISTORY_FETCH, GHR_PAY_CALC, GHR_PA_REQUESTS_PKG, GHR_WGI_PKG, GHR_MSL_PKG, and GHR_PERSON_EXTRA_INFO_API, using DBMS_UTILITY and FND_PROFILE for diagnostics and configuration.

Usage Notes

GHR_MTO_INT is normally invoked indirectly by the Mass Transfer Out concurrent program and the associated Mass Transfer forms rather than being called directly by end users. It is referenced by twenty-three other packages, reflecting its role as a shared lower-level component. Because the procedures write transactional HR data, customizations should invoke the package only through the supported Mass Transfer flow so that validation, logging, and history capture remain intact. Direct calls are appropriate only for controlled data migration or extension scenarios where the calling code first populates the GHR_INTERFACE staging tables and confirms the correct business group context.