Search Results insert_misc

Overview

APPS.GHR_MTO_INT is an Oracle E-Business Suite PL/SQL package that implements the internal integration layer for the Mass Transfer Out (MTO) process within Oracle HRMS. Its principal business function is to extract person, assignment, address, position, and related human-resources records from the source business group and stage them for transfer to a destination business group or environment. The package name carries the "_INT" suffix, signaling that it is an internal package not intended for direct customer calls; it is invoked by the public mass-transfer APIs and concurrent processes that drive the Mass Transfer feature.

The package is declared AUTHID CURRENT_USER and carries a 2003 header (ghmtoint.pkh 115.7), reflecting its long-standing role in the HRMS mass transfer architecture. It contains 28 documented procedures and functions and is referenced by 23 other packages, confirming its position as a shared utility within the HR mass-transfer stack.

Key Procedures and Functions

The metadata documents 28 procedures and functions. The principal ones include:

• GET_TRANSFER_PARAMETERS — Retrieves the transfer name, effective date, and inter-business-group indicator for a given mass transfer identifier, supplying the driving parameters for subsequent inserts.
• SET_LOG_PROGRAM_NAME and LOG_MESSAGE — Provide diagnostic logging used throughout the transfer process, controlled by the package-level logging flags (g_log_enabled, g_dbms_output).
• MASS_TRANSFER_OUT — The top-level driver that orchestrates the outbound transfer for a specified transfer and person.
• INSERT_PEOPLE_F, INSERT_PEOPLE_EI, INSERT_SPECIAL_INFO, INSERT_ADDRESS — Insert person, extra information, special information, and address records respectively. INSERT_ADDRESS includes optional contact name and contact type parameters for contact-address rows.
• INSERT_ASSIGNMENT_F, INSERT_ASSIGNMENT_EI — Insert assignment and assignment extra-information rows.
• INSERT_POSITION, INSERT_POSITION_EI, INSERT_POSITION_DEFS — Insert position records, position extra information, and position definitions.
• INSERT_ELEMENT_ENTRIES — Inserts payroll element entries associated with the transferred assignments.
• INSERT_MISC — The procedure the user searched for; it handles insertion of miscellaneous or residual staging records that do not fall under the other categorized insert routines. In ETRM 12.2.2 documentation it is listed as a distinct documented procedure, though its exact column mapping is not detailed in the available metadata.

Mirror-image update routines (UPDATE_PEOPLE_F, UPDATE_PEOPLE_EI, UPDATE_SPECIAL_INFO, UPDATE_ADDRESS, UPDATE_ASSIGNMENT_F, and related) handle cases where staging records already exist and must be refreshed rather than created.

Tables Accessed

The package reads and writes HRMS base and interface tables through APPS synonyms. Person-level operations touch PER_ALL_PEOPLE_F and PER_PEOPLE_EXTRA_INFO. Assignment operations touch PER_ALL_ASSIGNMENTS_F and PER_ASSIGNMENT_EXTRA_INFO. Address and contact operations touch PER_ADDRESSES and PER_CONTACT_RELATIONSHIPS. Position handling uses HR_ALL_POSITIONS_F, PER_POSITION_DEFINITIONS, PER_POSITION_EXTRA_INFO, and HR_LOCATION_EXTRA_INFO. Grade validation reads PER_GRADES. The staging and control tables GHR_INTERFACE, GHR_INTERFACE_S, GHR_MASS_TRANSFERS, and GHR_PROCESS_LOG_S hold the extracted rows, sequence keys, mass-transfer definition, and process log entries that drive and audit the transfer.

Usage Notes

GHR_MTO_INT is not called directly by end users. It is invoked from the Oracle HRMS Mass Transfer concurrent programs and public APIs that perform outbound transfers between business groups. Because it is AUTHID CURRENT_USER and referenced by 23 packages, any customizations should treat it as internal and call the supported public mass-transfer APIs instead. Logging can be directed through DBMS_OUTPUT or HR_UTILITY.SET_LOCATION depending on the g_dbms_output flag, which is useful when diagnosing staging failures.