Search Results create_us_applicant

Overview

GHR_MTI_INT is the integration-layer package body within the Oracle E-Business Suite HRMS mass transfer infrastructure. Its name reflects its role as the "Mass Transfer Interface" component, operating in tandem with the GHR_MTO_INT (Mass Transfer Out) and the GHR_MT_PEOPLE_F_V interface view. The package encapsulates the low-level logic required to validate, stage, and process person records that are being moved between business groups or legislative data groups using the Mass Transfer functionality. In the context of the 12.1.1 and 12.2.2 releases, the package governs how candidate rows sourced from the GHR_MT_PEOPLE_F_V interface view are checked and marked with a transfer status, ensuring that only well-formed records proceed to downstream processing. The search term create_us_applicant relates to the applicant-creation flow that consumes validated person rows, since a person's last name and person identifier are prerequisites for creating an applicant record.

Key Procedures and Functions

• MASS_TRANSFER_IN — The single documented public procedure and the principal entry point for inbound mass transfer processing. It drives the transfer of staged person rows into the target business group, invoking the internal validation and status-setting logic that the package body defines.
• report_state (private function) — Accepts a Boolean and a message string and returns the message concatenated with "TRUE" or "FALSE". Used purely for diagnostic tracing of internal state.
• ck_parameter_list (private function) — Validates a person row from GHR_MT_PEOPLE_F_V. Returns FALSE when last_name is null, because a last name is required to create an applicant, and returns FALSE when mt_person_id is null, since the person identifier is needed to distinguish like-named individuals and to locate all interface rows for that person.
• set_transfer_status (private procedure) — Updates GHR_MT_PEOPLE_F_V, setting mt_status to the supplied status code for the row matching the transfer name, last name, and person identifier. It raises an application error via hr_utility.raise_error on failure.

Tables Accessed

• GHR_MT_PEOPLE_F_V — The central interface view; rows are read for validation and updated with transfer status codes.
• GHR_MASS_TRANSFERS — Holds the mass transfer definition driving the transfer run.
• PER_ALL_PEOPLE_F — The base person record against which applicant and assignment data is resolved.
• PER_PERSON_TYPES — Determines whether the person qualifies as an applicant or employee during transfer.
• PER_ASSIGNMENT_STATUS_TYPES — Supplies valid assignment status values applied to transferred assignments.
• PER_PEOPLE_EXTRA_INFO — Stores supplementary person-level attributes carried through the transfer.
• FND_ID_FLEX_STRUCTURES_TL — Provides the translated key flexfield structure definitions used for descriptive flexfield handling.

Usage Notes

GHR_MTI_INT is not typically called directly from a form. It is invoked behind the scenes by the Mass Transfer concurrent program and by the GHR mass transfer user interface during the transfer execution phase. The package is referenced by no other documented packages, confirming that it occupies a leaf position in the dependency tree and depends only on standard HRMS utilities such as HR_UTILITY and GHR_MTO_INT. Customizations that need to trigger inbound mass transfer processing should reference MASS_TRANSFER_IN rather than the private helpers. Because status updates are committed through GHR_MT_PEOPLE_F_V, the calling process must establish the correct transfer name and person identifier context prior to invocation. The heavy use of hr_utility.set_location indicates the package is intended for debug tracing when HR diagnostics are enabled.