[Home] [Help]
874: end transfer_person_in;
875:
876: --
877: -- For all rows in ghr_mt_people_f_v where mt_status = 'Y' and
878: -- name = ghr_mass_transfers.name do the following:
879: -- 1. create an applicant
880: -- 2. accept the applicant
881: -- 3. copy information from the row into person and person analysis
882: -- ddf's
895: -- transfer name, last_name, and national_identifier (ssn) is
896: -- expected to be unique.
897: --
898: -- Parameters:
899: -- p_transfer_id: id of row in ghr_mass_transfers containing
900: -- transfer information
901: -- p_business_group_id: identifies the business group
902: --
903: procedure mass_transfer_in(p_errbuf out NOCOPY varchar2,
910:
911: l_person_type_id per_person_types.person_type_id%type;
912: l_person_type_mti per_person_types.user_person_type%type;
913: l_person_type_mti_id per_person_types.person_type_id%type;
914: l_transfer_name ghr_mass_transfers.name%type;
915: l_effective_date ghr_mass_transfers.effective_date%type;
916: l_person_row ghr_mt_people_f_v%rowtype;
917: l_result varchar2(1);
918: l_person_id per_people_f.person_id%type;
911: l_person_type_id per_person_types.person_type_id%type;
912: l_person_type_mti per_person_types.user_person_type%type;
913: l_person_type_mti_id per_person_types.person_type_id%type;
914: l_transfer_name ghr_mass_transfers.name%type;
915: l_effective_date ghr_mass_transfers.effective_date%type;
916: l_person_row ghr_mt_people_f_v%rowtype;
917: l_result varchar2(1);
918: l_person_id per_people_f.person_id%type;
919: l_inter_bg_transfer varchar2(1);
967: if l_effective_date is null then
968: ghr_mto_int.log_message(
969: p_procedure => l_proc_name,
970: p_message => 'Failed to get Transfer In information from'||
971: 'GHR_MASS_TRANSFERS for mass_transfer_id:'||
972: p_transfer_id);
973:
974: hr_utility.set_message(8301, 'GHR_38534_MT_ID_ERR');
975: hr_utility.raise_error;