58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: pqh_bre_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the pqh_bdgt_pool_realloctions row.
63: --
64: delete from pqh_bdgt_pool_realloctions
65: where reallocation_id = p_rec.reallocation_id;
66: --
60: pqh_bre_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the pqh_bdgt_pool_realloctions row.
63: --
64: delete from pqh_bdgt_pool_realloctions
65: where reallocation_id = p_rec.reallocation_id;
66: --
67: pqh_bre_shd.g_api_dml := false; -- Unset the api dml status
68: --
194: --
195: when hr_api.cannot_find_prog_unit then
196: --
197: hr_api.cannot_find_prog_unit_error
198: (p_module_name => 'PQH_BDGT_POOL_REALLOCTIONS'
199: ,p_hook_type => 'AD');
200: --
201: end;
202: --