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