59: )
60: THEN
61: IF p_race_code IS NULL OR
62: p_race_code = 'N' OR
63: hr_api.not_exists_in_hr_lookups
64: (p_effective_date => p_effective_date
65: ,p_lookup_type => 'ZA_RACE'
66: ,p_lookup_code => p_race_code
67: )
260: hr_utility.set_location(l_proc,1);
261:
262: -- If the person type id was not passed
263: --
264: IF p_person_type_id = hr_api.g_number THEN
265: hr_utility.set_location(l_proc,2);
266: -- Find the person's person type
267: --
268: OPEN c_person_person_type;
274: END IF;
275:
276: -- if the race field was not updated
277: --
278: IF p_per_information4 = hr_api.g_varchar2 THEN
279: hr_utility.set_location(l_proc,4);
280: -- find the person's race
281: --
282: OPEN c_person_race;