[Home] [Help]
235: open csr_partyId_details; -- Enh 3299580
236: fetch csr_partyId_details into l_party_id;
237: close csr_partyId_details;
238: --
239: hr_person.generate_number(p_current_employee_flag
240: ,p_current_applicant_flag
241: ,NULL --p_current_npw_flag
242: ,p_national_identifier
243: ,p_business_group_id
254: --
255: -- Test current numbers are not used by
256: -- the system already.
257: --
258: hr_person.validate_unique_number(p_person_id =>p_person_id
259: , p_business_group_id => p_business_group_id
260: , p_employee_number => p_employee_number
261: , p_applicant_number => p_applicant_number
262: , p_npw_number => null --p_npw_number
281: and p_s_system_person_type = 'EX_EMP') then
282: --
283: -- Ensure no future person_type_changes.
284: --
285: if hr_person.chk_future_person_type(p_s_system_person_type
286: ,p_person_id
287: ,p_business_group_id
288: ,p_effective_start_date) then
289: fnd_message.set_name('PAY','HR_7193_PER_FUT_TYPE_EXISTS');
323: or p_s_system_person_type = 'EX_EMP')) then
324: --
325: -- Ensure no future person_type_changes.
326: --
327: if hr_person.chk_future_person_type(p_s_system_person_type
328: ,p_person_id
329: ,p_business_group_id
330: ,p_effective_start_date) then
331: fnd_message.set_name('PAY','HR_7193_PER_FUT_TYPE_EXISTS');
378: and p_s_system_person_type = 'EMP_APL')) then
379: --
380: -- Ensure no future person_type_changes.
381: --
382: if hr_person.chk_future_person_type(p_s_system_person_type
383: ,p_person_id
384: ,p_business_group_id
385: ,p_effective_start_date) then
386: fnd_message.set_name('PAY','HR_7193_PER_FUT_TYPE_EXISTS');
844: v_dummy INTEGER;
845: v_dummy_fpd date;
846: --
847: begin
848: hr_utility.set_location('hr_person.check_rehire',1);
849: --
850: -- Check if old PPS row exists
851: --
852: open old_pps_exists;