64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: --
67: --
68: -- Update the ghr_compl_agency_appeals Row
69: --
70: update ghr_compl_agency_appeals
71: set
72: compl_agency_appeal_id = p_rec.compl_agency_appeal_id
66: --
67: --
68: -- Update the ghr_compl_agency_appeals Row
69: --
70: update ghr_compl_agency_appeals
71: set
72: compl_agency_appeal_id = p_rec.compl_agency_appeal_id
73: ,complaint_id = p_rec.complaint_id
74: ,appeal_date = p_rec.appeal_date
277: --
278: when hr_api.cannot_find_prog_unit then
279: --
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'GHR_COMPL_AGENCY_APPEALS'
282: ,p_hook_type => 'AU');
283: --
284: end;
285: --