APPS.HR_ASSIGNMENT_INTERNAL dependencies on HR_SP_PLACEMENT_API

Line 1500: hr_sp_placement_api.delete_spp

1496: if l_effective_end_date = p_validation_end_date then
1497: exit;
1498: end if;
1499:
1500: hr_sp_placement_api.delete_spp
1501: (p_effective_date => p_validation_start_date
1502: ,p_datetrack_mode => l_datetrack_mode
1503: ,p_placement_id => l_placement_id
1504: ,p_object_version_number => l_object_version_number

Line 2611: hr_sp_placement_api.delete_spp

2607: IF l_previous_id <> c_spp_record.placement_id THEN
2608: --
2609: hr_utility.set_location(l_proc,30);
2610: --
2611: hr_sp_placement_api.delete_spp
2612: (p_effective_date => c_spp_record.effective_start_date
2613: ,p_datetrack_mode => hr_api.g_zap
2614: ,p_placement_id => c_spp_record.placement_id
2615: ,p_object_version_number => c_spp_record.object_version_number

Line 2724: hr_sp_placement_api.delete_spp

2720: hr_utility.set_location(l_proc||'/'||c1_rec.effective_start_date,31);
2721: --
2722: l_object_version_number := c1_rec.object_version_number;
2723: --
2724: hr_sp_placement_api.delete_spp
2725: (p_effective_date => c1_rec.effective_start_date
2726: ,p_datetrack_mode => hr_api.g_delete_next_change
2727: ,p_placement_id => p_placement_id
2728: ,p_object_version_number => l_object_version_number

Line 3136: hr_sp_placement_api.update_spp(

3132: -- Therefore simply break it on validation end date.
3133: --
3134: hr_utility.set_location('ved spp found', 40);
3135: hr_utility.set_location('dt mode :'||l_datetrack_mode, 40);
3136: hr_sp_placement_api.update_spp(
3137: p_effective_date => p_validation_end_date+1
3138: ,p_datetrack_mode => l_datetrack_mode
3139: ,p_placement_id => l_placement_id
3140: ,p_object_version_number => l_object_version_number

Line 3164: hr_sp_placement_api.delete_spp(

3160: if p_validation_end_date > csr_rec.effective_end_date and
3161: csr_rec.effective_end_date <> hr_api.g_eot then
3162: --
3163: l_object_version_number := csr_rec.object_version_number;
3164: hr_sp_placement_api.delete_spp(
3165: p_effective_date => csr_rec.effective_start_date
3166: ,p_datetrack_mode => hr_api.g_delete_next_change
3167: ,p_placement_id => csr_rec.placement_id
3168: ,p_object_version_number => l_object_version_number

Line 3258: hr_sp_placement_api.delete_spp(

3254: -- effective_end_date of SPP record.
3255: if csr_spp_details%found and
3256: l_spp_eff_end_date <> hr_api.g_eot then
3257: --
3258: hr_sp_placement_api.delete_spp(
3259: p_effective_date => l_spp_eff_start_date
3260: ,p_datetrack_mode => p_datetrack_mode
3261: ,p_placement_id => l_placement_id
3262: ,p_object_version_number => l_object_version_number

Line 3427: hr_sp_placement_api.update_spp(

3423: end if;
3424: --
3425: close csr_future_records;
3426: --
3427: hr_sp_placement_api.update_spp(
3428: p_effective_date => p_validation_start_date
3429: ,p_datetrack_mode => l_datetrack_mode
3430: ,p_placement_id => p_placement_id
3431: ,p_object_version_number => l_object_version_number

Line 3469: hr_sp_placement_api.delete_spp(

3465: hr_utility.set_location(l_proc||'/'||csr_rec.object_version_number, 90);
3466: hr_utility.set_location(l_proc||'/'||csr_rec.effective_start_date, 100);
3467: end if;
3468: l_object_version_number := csr_rec.object_version_number;
3469: hr_sp_placement_api.delete_spp(
3470: p_effective_date => csr_rec.effective_start_date
3471: ,p_datetrack_mode => hr_api.g_delete_next_change
3472: ,p_placement_id => p_placement_id
3473: ,p_object_version_number => l_object_version_number

Line 3487: hr_sp_placement_api.update_spp(

3483: end loop;
3484: --
3485: else
3486: -- Normal case, performing UPDATE_OVERRIDE
3487: hr_sp_placement_api.update_spp(
3488: p_effective_date => p_validation_start_date
3489: ,p_datetrack_mode => p_datetrack_mode
3490: ,p_placement_id => p_placement_id
3491: ,p_object_version_number => l_object_version_number

Line 3513: hr_sp_placement_api.delete_spp(

3509: for rec_past_spp in csr_past_spp_details(l_placement_id => p_placement_id) loop
3510: --
3511: if rec_past_spp.effective_end_date <> hr_api.g_eot then
3512: l_object_version_number := rec_past_spp.object_version_number;
3513: hr_sp_placement_api.delete_spp(
3514: p_effective_date => p_validation_start_date - 1
3515: ,p_datetrack_mode => hr_api.g_delete_next_change
3516: ,p_placement_id => p_placement_id
3517: ,p_object_version_number => l_object_version_number

Line 3550: hr_sp_placement_api.delete_spp(

3546: if g_debug then
3547: hr_utility.set_location(l_proc, 140);
3548: hr_utility.set_location(l_proc||' ovn ='||l_previous_ovn, 150);
3549: end if;
3550: hr_sp_placement_api.delete_spp(
3551: p_effective_date => p_validation_start_date - 1
3552: ,p_datetrack_mode => hr_api.g_delete
3553: ,p_placement_id => p_placement_id
3554: ,p_object_version_number => l_previous_ovn

Line 3644: hr_sp_placement_api.delete_spp(

3640: hr_utility.set_location(l_proc, 30);
3641: end if;
3642: -- If the future SPP changes are existing after the validation_start_date
3643: -- then we need to delete all future changes
3644: hr_sp_placement_api.delete_spp(
3645: p_effective_date => p_validation_start_date
3646: ,p_datetrack_mode => hr_api.g_future_change
3647: ,p_placement_id => p_placement_id
3648: ,p_object_version_number => l_object_version_number

Line 3671: hr_sp_placement_api.delete_spp(

3667: hr_utility.set_location(l_proc, 50);
3668: hr_utility.set_location(l_proc||' ovn ='||l_object_version_number, 60);
3669: end if;
3670: --
3671: hr_sp_placement_api.delete_spp(
3672: p_effective_date => p_validation_start_date - 1
3673: ,p_datetrack_mode => hr_api.g_delete
3674: ,p_placement_id => p_placement_id
3675: ,p_object_version_number => l_object_version_number

Line 3813: hr_sp_placement_api.update_spp(

3809: hr_utility.set_location('dt mode :'||l_datetrack_mode, 20);
3810: --
3811: l_del_end_future_spp := TRUE;
3812: --
3813: hr_sp_placement_api.update_spp(
3814: p_effective_date => p_validation_end_date+1
3815: ,p_datetrack_mode => l_datetrack_mode
3816: ,p_placement_id => l_placement_id
3817: ,p_object_version_number => l_object_version_number

Line 3851: hr_sp_placement_api.update_spp(

3847: hr_utility.set_location('dt mode :'||l_datetrack_mode, 20);
3848: --
3849: l_del_end_future_spp := TRUE;
3850: --
3851: hr_sp_placement_api.update_spp(
3852: p_effective_date => p_validation_start_date
3853: ,p_datetrack_mode => l_datetrack_mode
3854: ,p_placement_id => l_placement_id
3855: ,p_step_id => l_min_step_id

Line 3914: hr_sp_placement_api.delete_spp(

3910: hr_utility.set_location('performing delete_spp',70);
3911: hr_utility.set_location('l_effective_start_date'||l_effective_start_date,399);
3912: --
3913: l_effective_date := l_effective_start_date;
3914: hr_sp_placement_api.delete_spp(
3915: p_effective_date => l_effective_date
3916: ,p_datetrack_mode => hr_api.g_delete_next_change
3917: ,p_placement_id => l_placement_id
3918: ,p_object_version_number => l_object_version_number

Line 3938: hr_sp_placement_api.update_spp(

3934: --
3935: -- fix for the bug 5160851
3936: -- added the following if condition.
3937: if (l_placement_id is not null ) then
3938: hr_sp_placement_api.update_spp(
3939: p_effective_date => p_validation_start_date
3940: ,p_datetrack_mode => hr_api.g_correction
3941: ,p_placement_id => l_placement_id
3942: ,p_step_id => l_min_step_id

Line 4029: hr_sp_placement_api.delete_spp

4025: hr_utility.set_location(l_proc, 30);
4026: --
4027: l_object_version_number := p_object_version_number;
4028: --
4029: hr_sp_placement_api.delete_spp
4030: (p_effective_date => p_effective_date
4031: ,p_datetrack_mode => hr_api.g_zap
4032: ,p_placement_id => p_placement_id
4033: ,p_object_version_number => l_object_version_number

Line 4052: hr_sp_placement_api.delete_spp

4048: l_previous_end_date;
4049: --
4050: hr_utility.set_location(l_proc||l_previous_ovn||'/'||l_previous_end_date, 50);
4051: --
4052: hr_sp_placement_api.delete_spp
4053: (p_effective_date => l_previous_end_date
4054: ,p_datetrack_mode => hr_api.g_delete
4055: ,p_placement_id => p_placement_id
4056: ,p_object_version_number => l_previous_ovn

Line 4070: hr_sp_placement_api.delete_spp

4066: hr_utility.set_location(l_proc, 50);
4067: --
4068: l_object_version_number := p_object_version_number;
4069: --
4070: hr_sp_placement_api.delete_spp
4071: (p_effective_date => p_effective_date -1
4072: ,p_datetrack_mode => hr_api.g_delete
4073: ,p_placement_id => p_placement_id
4074: ,p_object_version_number => l_object_version_number

Line 4104: hr_sp_placement_api.delete_spp

4100: --
4101: l_previous_id := c_future_spp.placement_id;
4102: l_object_version_number := c_future_spp.object_version_number;
4103: --
4104: hr_sp_placement_api.delete_spp
4105: (p_effective_date => c_future_spp.effective_start_date
4106: ,p_datetrack_mode => hr_api.g_zap
4107: ,p_placement_id => c_future_spp.placement_id
4108: ,p_object_version_number => l_object_version_number

Line 4438: hr_sp_placement_api.delete_spp(

4434: -- If the future SPP changes are existing and the
4435: -- validation_start_date is same as current SPP
4436: -- effective_start_date, then we need to delete
4437: -- all future changes
4438: hr_sp_placement_api.delete_spp(
4439: p_effective_date => p_validation_start_date
4440: ,p_datetrack_mode => hr_api.g_future_change
4441: ,p_placement_id => l_placement_id
4442: ,p_object_version_number => l_object_version_number

Line 4530: hr_sp_placement_api.update_spp(

4526: ,p_del_end_future_spp => l_del_end_future_spp);
4527: --
4528: else
4529: --
4530: hr_sp_placement_api.update_spp(
4531: p_effective_date => p_validation_start_date
4532: ,p_datetrack_mode => l_datetrack_mode
4533: ,p_placement_id => l_placement_id
4534: ,p_object_version_number => l_object_version_number