60: --
61: -- Delete the where the effective start date is equal
62: -- to the validation end date.
63: --
64: delete from per_person_type_usages_f
65: where person_type_usage_id = p_rec.person_type_usage_id
66: and effective_start_date = p_validation_start_date;
67: --
68: Else
70: --
71: -- Delete the row(s) where the effective start date is greater than
72: -- or equal to the validation start date.
73: --
74: delete from per_person_type_usages_f
75: where person_type_usage_id = p_rec.person_type_usage_id
76: and effective_start_date >= p_validation_start_date;
77: --
78: End If;
341: );
342: exception
343: when hr_api.cannot_find_prog_unit then
344: hr_api.cannot_find_prog_unit_error
345: (p_module_name => 'PER_PERSON_TYPE_USAGES_F'
346: ,p_hook_type => 'AD'
347: );
348: end;
349: -- End of API User Hook for post_delete.