47: (p_budget_element_id => p_budget_element_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_budget_element_id,hr_api.g_number)
52: <> pqh_bel_shd.g_old_rec.budget_element_id) then
53: --
54: -- raise error as PK has changed
55: --
119: (p_budget_element_id => p_budget_element_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_budget_set_id,hr_api.g_number)
124: <> nvl(pqh_bel_shd.g_old_rec.budget_set_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if budget_set_id value exists in pqh_budget_sets table
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_budget_set_id,hr_api.g_number)
124: <> nvl(pqh_bel_shd.g_old_rec.budget_set_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if budget_set_id value exists in pqh_budget_sets table
128: --
174: (p_budget_element_id => p_budget_element_id,
175: p_object_version_number => p_object_version_number);
176: --
177: if (l_api_updating
178: and nvl(p_element_type_id,hr_api.g_number)
179: <> nvl(pqh_bel_shd.g_old_rec.element_type_id,hr_api.g_number)
180: or not l_api_updating) then
181:
182: --
175: p_object_version_number => p_object_version_number);
176: --
177: if (l_api_updating
178: and nvl(p_element_type_id,hr_api.g_number)
179: <> nvl(pqh_bel_shd.g_old_rec.element_type_id,hr_api.g_number)
180: or not l_api_updating) then
181:
182: --
183: -- check if element_type_id value exists in pay_element_types_f table