[Home] [Help]
1193: per_asg_del.del
1194: (p_assignment_id => l_assignment.assignment_id
1195: ,p_object_version_number => l_assignment.object_version_number
1196: ,p_effective_date => l_assignment.effective_start_date --p_date_end+1
1197: ,p_datetrack_mode => hr_api.g_zap
1198: ,p_effective_start_date => l_effective_start_date
1199: ,p_effective_end_date => l_effective_end_date
1200: ,p_business_group_id => l_business_group_id
1201: ,p_validation_start_date => l_validation_start_date
2434: select application_id, date_end
2435: from per_applications
2436: where person_id = p_person_id
2437: and application_id <> p_application_id
2438: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
2439:
2440: cursor fpt_person_rec is
2441: select effective_start_date,effective_end_date
2442: from per_all_people_f per, per_person_types ppt
2494: end loop;
2495:
2496: -- Extending the current APL record till EOT
2497: update per_person_type_usages_f
2498: set effective_end_date = hr_api.g_eot
2499: where person_id = p_person_id
2500: and effective_start_date = p_date_received
2501: and person_type_id = l_person_type_id1;
2502:
2544: where person_id = p_person_id
2545: and assignment_id = asg_rec.assignment_id
2546: and assignment_type = 'A';
2547:
2548: if l_apl_end_date = hr_api.g_eot then
2549: l_apl_end_date := null;
2550: end if;
2551:
2552: -- checking whether an APL exists on this date
2572: raise;
2573: end;
2574: else
2575:
2576: if nvl(l_current_apl_end_date,hr_api.g_eot) < nvl(l_apl_end_date,hr_api.g_eot) then
2577:
2578: update per_applications
2579: set date_end = l_apl_end_date
2580: where person_id = p_person_id
2702: -- null;
2703: --end if;
2704: --if nvl(l_person_type_id,-1) <> p_person_type_id then
2705: -- if p_date_end +1 = l_start_date then
2706: -- l_update_mode := hr_api.g_correction;
2707: -- end if;
2708: -- hr_per_type_usage_internal.maintain_person_type_usage
2709: -- ( p_effective_date => p_Date_End+1
2710: -- ,p_person_id => p_Person_id