47: (p_budget_set_id => p_budget_set_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_budget_set_id,hr_api.g_number)
52: <> pqh_bst_shd.g_old_rec.budget_set_id) then
53: --
54: -- raise error as PK has changed
55: --
119: (p_budget_set_id => p_budget_set_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_budget_period_id,hr_api.g_number)
124: <> nvl(pqh_bst_shd.g_old_rec.budget_period_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if budget_period_id value exists in pqh_budget_periods table
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_budget_period_id,hr_api.g_number)
124: <> nvl(pqh_bst_shd.g_old_rec.budget_period_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if budget_period_id value exists in pqh_budget_periods table
128: --
194: (p_budget_set_id => p_budget_set_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_dflt_budget_set_id,hr_api.g_number)
199: <> nvl(pqh_bst_shd.g_old_rec.dflt_budget_set_id,hr_api.g_number)
200: or not l_api_updating) and
201: p_dflt_budget_set_id is not null then
202: --
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_dflt_budget_set_id,hr_api.g_number)
199: <> nvl(pqh_bst_shd.g_old_rec.dflt_budget_set_id,hr_api.g_number)
200: or not l_api_updating) and
201: p_dflt_budget_set_id is not null then
202: --
203: -- check if dflt_budget_set_id value exists in pqh_dflt_budget_sets table
267: p_object_version_number => p_object_version_number);
268: --
269: if (l_api_updating
270: and p_budget_unit3_value_type_cd
271: <> nvl(pqh_bst_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)
272: or not l_api_updating)
273: and p_budget_unit3_value_type_cd is not null then
274: --
275: -- check if value of lookup falls within lookup type.
273: and p_budget_unit3_value_type_cd is not null then
274: --
275: -- check if value of lookup falls within lookup type.
276: --
277: if hr_api.not_exists_in_hr_lookups
278: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
279: p_lookup_code => p_budget_unit3_value_type_cd,
280: p_effective_date => p_effective_date) then
281: --
335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating
338: and p_budget_unit2_value_type_cd
339: <> nvl(pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)
340: or not l_api_updating)
341: and p_budget_unit2_value_type_cd is not null then
342: --
343: -- check if value of lookup falls within lookup type.
341: and p_budget_unit2_value_type_cd is not null then
342: --
343: -- check if value of lookup falls within lookup type.
344: --
345: if hr_api.not_exists_in_hr_lookups
346: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
347: p_lookup_code => p_budget_unit2_value_type_cd,
348: p_effective_date => p_effective_date) then
349: --
403: p_object_version_number => p_object_version_number);
404: --
405: if (l_api_updating
406: and p_budget_unit1_value_type_cd
407: <> nvl(pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)
408: or not l_api_updating)
409: and p_budget_unit1_value_type_cd is not null then
410: --
411: -- check if value of lookup falls within lookup type.
409: and p_budget_unit1_value_type_cd is not null then
410: --
411: -- check if value of lookup falls within lookup type.
412: --
413: if hr_api.not_exists_in_hr_lookups
414: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
415: p_lookup_code => p_budget_unit1_value_type_cd,
416: p_effective_date => p_effective_date) then
417: --