48: --
49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: -- Delete the per_phones row.
53: --
54: delete from per_phones
55: where phone_id = p_rec.phone_id;
56: --
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: -- Delete the per_phones row.
53: --
54: delete from per_phones
55: where phone_id = p_rec.phone_id;
56: --
57: hr_utility.set_location(' Leaving:'||l_proc, 10);
58: --
196: );
197: exception
198: when hr_api.cannot_find_prog_unit then
199: hr_api.cannot_find_prog_unit_error
200: (p_module_name => 'PER_PHONES'
201: ,p_hook_type => 'AD'
202: );
203: end;
204: -- End of API User Hook for post_delete.