APPS.PQH_BDT_BUS dependencies on HR_API

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

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

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

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

Line 124: <> nvl(pqh_bdt_shd.g_old_rec.grade_id,hr_api.g_number)

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

Line 199: and nvl(p_job_id,hr_api.g_number)

195: (p_budget_detail_id => p_budget_detail_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_job_id,hr_api.g_number)
200: <> nvl(pqh_bdt_shd.g_old_rec.job_id,hr_api.g_number)
201: or not l_api_updating) and
202: p_job_id is not null then
203: --

Line 200: <> nvl(pqh_bdt_shd.g_old_rec.job_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_job_id,hr_api.g_number)
200: <> nvl(pqh_bdt_shd.g_old_rec.job_id,hr_api.g_number)
201: or not l_api_updating) and
202: p_job_id is not null then
203: --
204: -- check if job_id value exists in per_jobs table

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

271: (p_budget_detail_id => p_budget_detail_id,
272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating
275: and nvl(p_budget_version_id,hr_api.g_number)
276: <> nvl(pqh_bdt_shd.g_old_rec.budget_version_id,hr_api.g_number)
277: or not l_api_updating) and
278: p_budget_version_id is not null then
279: --

Line 276: <> nvl(pqh_bdt_shd.g_old_rec.budget_version_id,hr_api.g_number)

272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating
275: and nvl(p_budget_version_id,hr_api.g_number)
276: <> nvl(pqh_bdt_shd.g_old_rec.budget_version_id,hr_api.g_number)
277: or not l_api_updating) and
278: p_budget_version_id is not null then
279: --
280: -- check if budget_version_id value exists in pqh_budget_versions table

Line 351: and nvl(p_organization_id,hr_api.g_number)

347: (p_budget_detail_id => p_budget_detail_id,
348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating
351: and nvl(p_organization_id,hr_api.g_number)
352: <> nvl(pqh_bdt_shd.g_old_rec.organization_id,hr_api.g_number)
353: or not l_api_updating) and
354: p_organization_id is not null then
355: --

Line 352: <> nvl(pqh_bdt_shd.g_old_rec.organization_id,hr_api.g_number)

348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating
351: and nvl(p_organization_id,hr_api.g_number)
352: <> nvl(pqh_bdt_shd.g_old_rec.organization_id,hr_api.g_number)
353: or not l_api_updating) and
354: p_organization_id is not null then
355: --
356: -- check if organization_id value exists in hr_organization_units table

Line 425: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)

421: p_object_version_number => p_object_version_number);
422: --
423: if (l_api_updating
424: and p_budget_unit3_value_type_cd
425: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)
426: or not l_api_updating)
427: and p_budget_unit3_value_type_cd is not null then
428: --
429: -- check if value of lookup falls within lookup type.

Line 431: if hr_api.not_exists_in_hr_lookups

427: and p_budget_unit3_value_type_cd is not null then
428: --
429: -- check if value of lookup falls within lookup type.
430: --
431: if hr_api.not_exists_in_hr_lookups
432: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
433: p_lookup_code => p_budget_unit3_value_type_cd,
434: p_effective_date => p_effective_date) then
435: --

Line 493: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)

489: p_object_version_number => p_object_version_number);
490: --
491: if (l_api_updating
492: and p_budget_unit2_value_type_cd
493: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)
494: or not l_api_updating)
495: and p_budget_unit2_value_type_cd is not null then
496: --
497: -- check if value of lookup falls within lookup type.

Line 499: if hr_api.not_exists_in_hr_lookups

495: and p_budget_unit2_value_type_cd is not null then
496: --
497: -- check if value of lookup falls within lookup type.
498: --
499: if hr_api.not_exists_in_hr_lookups
500: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
501: p_lookup_code => p_budget_unit2_value_type_cd,
502: p_effective_date => p_effective_date) then
503: --

Line 561: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)

557: p_object_version_number => p_object_version_number);
558: --
559: if (l_api_updating
560: and p_budget_unit1_value_type_cd
561: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)
562: or not l_api_updating)
563: and p_budget_unit1_value_type_cd is not null then
564: --
565: -- check if value of lookup falls within lookup type.

Line 567: if hr_api.not_exists_in_hr_lookups

563: and p_budget_unit1_value_type_cd is not null then
564: --
565: -- check if value of lookup falls within lookup type.
566: --
567: if hr_api.not_exists_in_hr_lookups
568: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
569: p_lookup_code => p_budget_unit1_value_type_cd,
570: p_effective_date => p_effective_date) then
571: --