65: end if;
66: --
67: hxc_rtc_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Delete the hxc_retrieval_rule_comps row.
70: --
71: delete from hxc_retrieval_rule_comps
72: where retrieval_rule_comp_id = p_rec.retrieval_rule_comp_id;
73: --
67: hxc_rtc_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Delete the hxc_retrieval_rule_comps row.
70: --
71: delete from hxc_retrieval_rule_comps
72: where retrieval_rule_comp_id = p_rec.retrieval_rule_comp_id;
73: --
74: hxc_rtc_shd.g_api_dml := false; -- Unset the api dml status
75: --
197: --
198: when hr_api.cannot_find_prog_unit then
199: --
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'HXC_RETRIEVAL_RULE_COMPS'
202: ,p_hook_type => 'AD');
203: --
204: end;
205: --