64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: --
67: --
68: -- Update the ghr_compl_adrs Row
69: --
70: update ghr_compl_adrs
71: set
72: compl_adr_id = p_rec.compl_adr_id
66: --
67: --
68: -- Update the ghr_compl_adrs Row
69: --
70: update ghr_compl_adrs
71: set
72: compl_adr_id = p_rec.compl_adr_id
73: ,complaint_id = p_rec.complaint_id
74: ,stage = p_rec.stage
224: --
225: when hr_api.cannot_find_prog_unit then
226: --
227: hr_api.cannot_find_prog_unit_error
228: (p_module_name => 'GHR_COMPL_ADRS'
229: ,p_hook_type => 'AU');
230: --
231: end;
232: