57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: -- Delete the per_collective_agreements row.
62: --
63: delete from per_collective_agreements
64: where collective_agreement_id = p_rec.collective_agreement_id;
65: --
59: --
60: --
61: -- Delete the per_collective_agreements row.
62: --
63: delete from per_collective_agreements
64: where collective_agreement_id = p_rec.collective_agreement_id;
65: --
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: --
228: when hr_api.cannot_find_prog_unit then
229: --
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'per_collective_agreements'
232: ,p_hook_type => 'AD');
233: --
234: end;
235: --