DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_INTERNAL dependencies on HR_SP_PLACEMENT_API

Line 1599: hr_sp_placement_api.delete_spp

1595: if l_effective_end_date = p_validation_end_date then
1596: exit;
1597: end if;
1598:
1599: hr_sp_placement_api.delete_spp
1600: (p_effective_date => p_validation_start_date
1601: ,p_datetrack_mode => l_datetrack_mode
1602: ,p_placement_id => l_placement_id
1603: ,p_object_version_number => l_object_version_number

Line 2744: hr_sp_placement_api.delete_spp

2740: IF l_previous_id <> c_spp_record.placement_id THEN
2741: --
2742: hr_utility.set_location(l_proc,30);
2743: --
2744: hr_sp_placement_api.delete_spp
2745: (p_effective_date => c_spp_record.effective_start_date
2746: ,p_datetrack_mode => hr_api.g_zap
2747: ,p_placement_id => c_spp_record.placement_id
2748: ,p_object_version_number => c_spp_record.object_version_number

Line 2857: hr_sp_placement_api.delete_spp

2853: hr_utility.set_location(l_proc||'/'||c1_rec.effective_start_date,31);
2854: --
2855: l_object_version_number := c1_rec.object_version_number;
2856: --
2857: hr_sp_placement_api.delete_spp
2858: (p_effective_date => c1_rec.effective_start_date
2859: ,p_datetrack_mode => hr_api.g_delete_next_change
2860: ,p_placement_id => p_placement_id
2861: ,p_object_version_number => l_object_version_number

Line 3269: hr_sp_placement_api.update_spp(

3265: -- Therefore simply break it on validation end date.
3266: --
3267: hr_utility.set_location('ved spp found', 40);
3268: hr_utility.set_location('dt mode :'||l_datetrack_mode, 40);
3269: hr_sp_placement_api.update_spp(
3270: p_effective_date => p_validation_end_date+1
3271: ,p_datetrack_mode => l_datetrack_mode
3272: ,p_placement_id => l_placement_id
3273: ,p_object_version_number => l_object_version_number

Line 3297: hr_sp_placement_api.delete_spp(

3293: if p_validation_end_date > csr_rec.effective_end_date and
3294: csr_rec.effective_end_date <> hr_api.g_eot then
3295: --
3296: l_object_version_number := csr_rec.object_version_number;
3297: hr_sp_placement_api.delete_spp(
3298: p_effective_date => csr_rec.effective_start_date
3299: ,p_datetrack_mode => hr_api.g_delete_next_change
3300: ,p_placement_id => csr_rec.placement_id
3301: ,p_object_version_number => l_object_version_number

Line 3391: hr_sp_placement_api.delete_spp(

3387: -- effective_end_date of SPP record.
3388: if csr_spp_details%found and
3389: l_spp_eff_end_date <> hr_api.g_eot then
3390: --
3391: hr_sp_placement_api.delete_spp(
3392: p_effective_date => l_spp_eff_start_date
3393: ,p_datetrack_mode => p_datetrack_mode
3394: ,p_placement_id => l_placement_id
3395: ,p_object_version_number => l_object_version_number

Line 3560: hr_sp_placement_api.update_spp(

3556: end if;
3557: --
3558: close csr_future_records;
3559: --
3560: hr_sp_placement_api.update_spp(
3561: p_effective_date => p_validation_start_date
3562: ,p_datetrack_mode => l_datetrack_mode
3563: ,p_placement_id => p_placement_id
3564: ,p_object_version_number => l_object_version_number

Line 3602: hr_sp_placement_api.delete_spp(

3598: hr_utility.set_location(l_proc||'/'||csr_rec.object_version_number, 90);
3599: hr_utility.set_location(l_proc||'/'||csr_rec.effective_start_date, 100);
3600: end if;
3601: l_object_version_number := csr_rec.object_version_number;
3602: hr_sp_placement_api.delete_spp(
3603: p_effective_date => csr_rec.effective_start_date
3604: ,p_datetrack_mode => hr_api.g_delete_next_change
3605: ,p_placement_id => p_placement_id
3606: ,p_object_version_number => l_object_version_number

Line 3620: hr_sp_placement_api.update_spp(

3616: end loop;
3617: --
3618: else
3619: -- Normal case, performing UPDATE_OVERRIDE
3620: hr_sp_placement_api.update_spp(
3621: p_effective_date => p_validation_start_date
3622: ,p_datetrack_mode => p_datetrack_mode
3623: ,p_placement_id => p_placement_id
3624: ,p_object_version_number => l_object_version_number

Line 3646: hr_sp_placement_api.delete_spp(

3642: for rec_past_spp in csr_past_spp_details(l_placement_id => p_placement_id) loop
3643: --
3644: if rec_past_spp.effective_end_date <> hr_api.g_eot then
3645: l_object_version_number := rec_past_spp.object_version_number;
3646: hr_sp_placement_api.delete_spp(
3647: p_effective_date => p_validation_start_date - 1
3648: ,p_datetrack_mode => hr_api.g_delete_next_change
3649: ,p_placement_id => p_placement_id
3650: ,p_object_version_number => l_object_version_number

Line 3683: hr_sp_placement_api.delete_spp(

3679: if g_debug then
3680: hr_utility.set_location(l_proc, 140);
3681: hr_utility.set_location(l_proc||' ovn ='||l_previous_ovn, 150);
3682: end if;
3683: hr_sp_placement_api.delete_spp(
3684: p_effective_date => p_validation_start_date - 1
3685: ,p_datetrack_mode => hr_api.g_delete
3686: ,p_placement_id => p_placement_id
3687: ,p_object_version_number => l_previous_ovn

Line 3777: hr_sp_placement_api.delete_spp(

3773: hr_utility.set_location(l_proc, 30);
3774: end if;
3775: -- If the future SPP changes are existing after the validation_start_date
3776: -- then we need to delete all future changes
3777: hr_sp_placement_api.delete_spp(
3778: p_effective_date => p_validation_start_date
3779: ,p_datetrack_mode => hr_api.g_future_change
3780: ,p_placement_id => p_placement_id
3781: ,p_object_version_number => l_object_version_number

Line 3804: hr_sp_placement_api.delete_spp(

3800: hr_utility.set_location(l_proc, 50);
3801: hr_utility.set_location(l_proc||' ovn ='||l_object_version_number, 60);
3802: end if;
3803: --
3804: hr_sp_placement_api.delete_spp(
3805: p_effective_date => p_validation_start_date - 1
3806: ,p_datetrack_mode => hr_api.g_delete
3807: ,p_placement_id => p_placement_id
3808: ,p_object_version_number => l_object_version_number

Line 3946: hr_sp_placement_api.update_spp(

3942: hr_utility.set_location('dt mode :'||l_datetrack_mode, 20);
3943: --
3944: l_del_end_future_spp := TRUE;
3945: --
3946: hr_sp_placement_api.update_spp(
3947: p_effective_date => p_validation_end_date+1
3948: ,p_datetrack_mode => l_datetrack_mode
3949: ,p_placement_id => l_placement_id
3950: ,p_object_version_number => l_object_version_number

Line 3984: hr_sp_placement_api.update_spp(

3980: hr_utility.set_location('dt mode :'||l_datetrack_mode, 20);
3981: --
3982: l_del_end_future_spp := TRUE;
3983: --
3984: hr_sp_placement_api.update_spp(
3985: p_effective_date => p_validation_start_date
3986: ,p_datetrack_mode => l_datetrack_mode
3987: ,p_placement_id => l_placement_id
3988: ,p_step_id => l_min_step_id

Line 4047: hr_sp_placement_api.delete_spp(

4043: hr_utility.set_location('performing delete_spp',70);
4044: hr_utility.set_location('l_effective_start_date'||l_effective_start_date,399);
4045: --
4046: l_effective_date := l_effective_start_date;
4047: hr_sp_placement_api.delete_spp(
4048: p_effective_date => l_effective_date
4049: ,p_datetrack_mode => hr_api.g_delete_next_change
4050: ,p_placement_id => l_placement_id
4051: ,p_object_version_number => l_object_version_number

Line 4071: hr_sp_placement_api.update_spp(

4067: --
4068: -- fix for the bug 5160851
4069: -- added the following if condition.
4070: if (l_placement_id is not null ) then
4071: hr_sp_placement_api.update_spp(
4072: p_effective_date => p_validation_start_date
4073: ,p_datetrack_mode => hr_api.g_correction
4074: ,p_placement_id => l_placement_id
4075: ,p_step_id => l_min_step_id

Line 4162: hr_sp_placement_api.delete_spp

4158: hr_utility.set_location(l_proc, 30);
4159: --
4160: l_object_version_number := p_object_version_number;
4161: --
4162: hr_sp_placement_api.delete_spp
4163: (p_effective_date => p_effective_date
4164: ,p_datetrack_mode => hr_api.g_zap
4165: ,p_placement_id => p_placement_id
4166: ,p_object_version_number => l_object_version_number

Line 4185: hr_sp_placement_api.delete_spp

4181: l_previous_end_date;
4182: --
4183: hr_utility.set_location(l_proc||l_previous_ovn||'/'||l_previous_end_date, 50);
4184: --
4185: hr_sp_placement_api.delete_spp
4186: (p_effective_date => l_previous_end_date
4187: ,p_datetrack_mode => hr_api.g_delete
4188: ,p_placement_id => p_placement_id
4189: ,p_object_version_number => l_previous_ovn

Line 4203: hr_sp_placement_api.delete_spp

4199: hr_utility.set_location(l_proc, 50);
4200: --
4201: l_object_version_number := p_object_version_number;
4202: --
4203: hr_sp_placement_api.delete_spp
4204: (p_effective_date => p_effective_date -1
4205: ,p_datetrack_mode => hr_api.g_delete
4206: ,p_placement_id => p_placement_id
4207: ,p_object_version_number => l_object_version_number

Line 4237: hr_sp_placement_api.delete_spp

4233: --
4234: l_previous_id := c_future_spp.placement_id;
4235: l_object_version_number := c_future_spp.object_version_number;
4236: --
4237: hr_sp_placement_api.delete_spp
4238: (p_effective_date => c_future_spp.effective_start_date
4239: ,p_datetrack_mode => hr_api.g_zap
4240: ,p_placement_id => c_future_spp.placement_id
4241: ,p_object_version_number => l_object_version_number

Line 4571: hr_sp_placement_api.delete_spp(

4567: -- If the future SPP changes are existing and the
4568: -- validation_start_date is same as current SPP
4569: -- effective_start_date, then we need to delete
4570: -- all future changes
4571: hr_sp_placement_api.delete_spp(
4572: p_effective_date => p_validation_start_date
4573: ,p_datetrack_mode => hr_api.g_future_change
4574: ,p_placement_id => l_placement_id
4575: ,p_object_version_number => l_object_version_number

Line 4663: hr_sp_placement_api.update_spp(

4659: ,p_del_end_future_spp => l_del_end_future_spp);
4660: --
4661: else
4662: --
4663: hr_sp_placement_api.update_spp(
4664: p_effective_date => p_validation_start_date
4665: ,p_datetrack_mode => l_datetrack_mode
4666: ,p_placement_id => l_placement_id
4667: ,p_object_version_number => l_object_version_number