APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on HR_API

Line 831: where nvl(b.effective_end_date,hr_api.g_eot)

827: AND ((a.effective_start_date = p_primary_date
828: and a.primary_flag <> 'Y'
829: and not exists ( select b.assignment_id
830: from per_all_assignments_f b
831: where nvl(b.effective_end_date,hr_api.g_eot)
832: = (p_primary_date-1)
833: and b.assignment_id = a.assignment_id) )
834: OR a.effective_start_date > p_primary_date );
835: -- Bug 2964027 ends here.

Line 1597: where nvl(b.effective_end_date,hr_api.g_eot)

1593: AND ((a.effective_start_date = p_date_start
1594: and a.primary_flag <> 'Y'
1595: and not exists ( select b.assignment_id
1596: from per_all_assignments_f b
1597: where nvl(b.effective_end_date,hr_api.g_eot)
1598: = (p_date_start-1)
1599: and b.assignment_id = a.assignment_id) )
1600: OR a.effective_start_date > p_date_start );
1601:

Line 5423: ,p_datetrack_mode => hr_api.g_zap

5419: hr_per_type_usage_internal.delete_person_type_usage
5420: (p_validate => FALSE
5421: ,p_person_type_usage_id => l_person_type_usage_id
5422: ,p_effective_date => p_effective_date
5423: ,p_datetrack_mode => hr_api.g_zap
5424: ,p_object_version_number => l_object_version_number
5425: ,p_effective_start_date => l_effective_start_date
5426: ,p_effective_end_date => l_effective_end_date);
5427: --

Line 5484: ,p_datetrack_mode => hr_api.g_zap

5480: hr_per_type_usage_internal.delete_person_type_usage
5481: (p_validate => FALSE
5482: ,p_person_type_usage_id => l_person_type_usage_id
5483: ,p_effective_date => p_effective_date
5484: ,p_datetrack_mode => hr_api.g_zap
5485: ,p_object_version_number => l_object_version_number
5486: ,p_effective_start_date => l_effective_start_date
5487: ,p_effective_end_date => l_effective_end_date);
5488: --

Line 5518: ,p_datetrack_mode => hr_api.g_zap

5514: hr_per_type_usage_internal.delete_person_type_usage
5515: (p_validate => FALSE
5516: ,p_person_type_usage_id => l_person_type_usage_id
5517: ,p_effective_date => p_effective_date
5518: ,p_datetrack_mode => hr_api.g_zap
5519: ,p_object_version_number => l_object_version_number
5520: ,p_effective_start_date => l_effective_start_date
5521: ,p_effective_end_date => l_effective_end_date);
5522: --

Line 5572: hr_api.mandatory_arg_error

5568: hr_utility.set_location('Entering:'|| l_proc, 10);
5569: --
5570: -- Ensure that all the mandatory parameter are not null
5571: --
5572: hr_api.mandatory_arg_error
5573: (p_api_name => l_proc
5574: ,p_argument => 'person_id'
5575: ,p_argument_value => p_person_id);
5576: --