[Home] [Help]
62: end if;
63: --
64: hxc_apc_shd.g_api_dml := true; -- Set the api dml status
65: --
66: -- Delete the hxc_approval_period_comps row.
67: --
68: delete from hxc_approval_period_comps
69: where approval_period_comp_id = p_rec.approval_period_comp_id;
70: --
64: hxc_apc_shd.g_api_dml := true; -- Set the api dml status
65: --
66: -- Delete the hxc_approval_period_comps row.
67: --
68: delete from hxc_approval_period_comps
69: where approval_period_comp_id = p_rec.approval_period_comp_id;
70: --
71: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
72: --
190: --
191: when hr_api.cannot_find_prog_unit then
192: --
193: hr_api.cannot_find_prog_unit_error
194: (p_module_name => 'HXC_APPROVAL_PERIOD_COMPS'
195: ,p_hook_type => 'AD');
196: --
197: end;
198: --