58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: --
62: -- Delete the ghr_compl_agency_appeals row.
63: --
64: delete from ghr_compl_agency_appeals
65: where compl_agency_appeal_id = p_rec.compl_agency_appeal_id;
66: --
60: --
61: --
62: -- Delete the ghr_compl_agency_appeals row.
63: --
64: delete from ghr_compl_agency_appeals
65: where compl_agency_appeal_id = p_rec.compl_agency_appeal_id;
66: --
67: --
68: --
197: --
198: when hr_api.cannot_find_prog_unit then
199: --
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'GHR_COMPL_AGENCY_APPEALS'
202: ,p_hook_type => 'AD');
203: --
204: end;
205: --