APPS.PQH_BVR_BUS dependencies on HR_API

Line 51: and nvl(p_budget_version_id,hr_api.g_number)

47: (p_budget_version_id => p_budget_version_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_budget_version_id,hr_api.g_number)
52: <> pqh_bvr_shd.g_old_rec.budget_version_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 123: and nvl(p_budget_id,hr_api.g_number)

119: (p_budget_version_id => p_budget_version_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_budget_id,hr_api.g_number)
124: <> nvl(pqh_bvr_shd.g_old_rec.budget_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_budget_id is not null then
127: --

Line 124: <> nvl(pqh_bvr_shd.g_old_rec.budget_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_budget_id,hr_api.g_number)
124: <> nvl(pqh_bvr_shd.g_old_rec.budget_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_budget_id is not null then
127: --
128: -- check if budget_id value exists in pqh_budgets table

Line 196: <> nvl(pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd,hr_api.g_varchar2)

192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and p_xfer_to_other_apps_cd
196: <> nvl(pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd,hr_api.g_varchar2)
197: or not l_api_updating)
198: and p_xfer_to_other_apps_cd is not null then
199: --
200: -- check if value of lookup falls within lookup type.

Line 202: if hr_api.not_exists_in_hr_lookups

198: and p_xfer_to_other_apps_cd is not null then
199: --
200: -- check if value of lookup falls within lookup type.
201: --
202: if hr_api.not_exists_in_hr_lookups
203: (p_lookup_type => 'YES_NO',
204: p_lookup_code => p_xfer_to_other_apps_cd,
205: p_effective_date => p_effective_date) then
206: --

Line 264: <> nvl(pqh_bvr_shd.g_old_rec.transfered_to_gl_flag,hr_api.g_varchar2)

260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and p_transfered_to_gl_flag
264: <> nvl(pqh_bvr_shd.g_old_rec.transfered_to_gl_flag,hr_api.g_varchar2)
265: or not l_api_updating)
266: and p_transfered_to_gl_flag is not null then
267: --
268: -- check if value of lookup falls within lookup type.

Line 270: if hr_api.not_exists_in_hr_lookups

266: and p_transfered_to_gl_flag is not null then
267: --
268: -- check if value of lookup falls within lookup type.
269: --
270: if hr_api.not_exists_in_hr_lookups
271: (p_lookup_type => 'YES_NO',
272: p_lookup_code => p_transfered_to_gl_flag,
273: p_effective_date => p_effective_date) then
274: --