APPS.PQH_CET_BUS dependencies on HR_API

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

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

Line 211: and nvl(p_txn_category_attribute_id,hr_api.g_number)

207: (p_copy_entity_txn_id => p_copy_entity_txn_id,
208: p_object_version_number => p_object_version_number);
209: --
210: if (l_api_updating
211: and nvl(p_txn_category_attribute_id,hr_api.g_number)
212: <> nvl(pqh_cet_shd.g_old_rec.txn_category_attribute_id,hr_api.g_number)
213: or not l_api_updating) then
214: --
215: -- check if txn_category_attribute_id value exists in pqh_special_attributes table

Line 212: <> nvl(pqh_cet_shd.g_old_rec.txn_category_attribute_id,hr_api.g_number)

208: p_object_version_number => p_object_version_number);
209: --
210: if (l_api_updating
211: and nvl(p_txn_category_attribute_id,hr_api.g_number)
212: <> nvl(pqh_cet_shd.g_old_rec.txn_category_attribute_id,hr_api.g_number)
213: or not l_api_updating) then
214: --
215: -- check if txn_category_attribute_id value exists in pqh_special_attributes table
216: --

Line 286: and nvl(p_context_business_group_id,hr_api.g_number)

282: (p_copy_entity_txn_id => p_copy_entity_txn_id,
283: p_object_version_number => p_object_version_number);
284: --
285: if (l_api_updating
286: and nvl(p_context_business_group_id,hr_api.g_number)
287: <> nvl(pqh_cet_shd.g_old_rec.context_business_group_id,hr_api.g_number)
288: or not l_api_updating) then
289: --
290: -- check if context_business_group_id value exists in per_business_groups table

Line 287: <> nvl(pqh_cet_shd.g_old_rec.context_business_group_id,hr_api.g_number)

283: p_object_version_number => p_object_version_number);
284: --
285: if (l_api_updating
286: and nvl(p_context_business_group_id,hr_api.g_number)
287: <> nvl(pqh_cet_shd.g_old_rec.context_business_group_id,hr_api.g_number)
288: or not l_api_updating) then
289: --
290: -- check if context_business_group_id value exists in per_business_groups table
291: --

Line 361: and nvl(p_transaction_category_id,hr_api.g_number)

357: (p_copy_entity_txn_id => p_copy_entity_txn_id,
358: p_object_version_number => p_object_version_number);
359: --
360: if (l_api_updating
361: and nvl(p_transaction_category_id,hr_api.g_number)
362: <> nvl(pqh_cet_shd.g_old_rec.transaction_category_id,hr_api.g_number)
363: or not l_api_updating) then
364: --
365: -- check if transaction_category_id value exists in pqh_transaction_categories table

Line 362: <> nvl(pqh_cet_shd.g_old_rec.transaction_category_id,hr_api.g_number)

358: p_object_version_number => p_object_version_number);
359: --
360: if (l_api_updating
361: and nvl(p_transaction_category_id,hr_api.g_number)
362: <> nvl(pqh_cet_shd.g_old_rec.transaction_category_id,hr_api.g_number)
363: or not l_api_updating) then
364: --
365: -- check if transaction_category_id value exists in pqh_transaction_categories table
366: --

Line 433: <> nvl(pqh_cet_shd.g_old_rec.replacement_type_cd,hr_api.g_varchar2)

429: p_object_version_number => p_object_version_number);
430: --
431: if (l_api_updating
432: and p_replacement_type_cd
433: <> nvl(pqh_cet_shd.g_old_rec.replacement_type_cd,hr_api.g_varchar2)
434: or not l_api_updating)
435: and p_replacement_type_cd is not null then
436: --
437: -- check if value of lookup falls within lookup type.

Line 439: if hr_api.not_exists_in_hr_lookups

435: and p_replacement_type_cd is not null then
436: --
437: -- check if value of lookup falls within lookup type.
438: --
439: if hr_api.not_exists_in_hr_lookups
440: (p_lookup_type => 'PQH_GEN_REPL_TYPE',
441: p_lookup_code => p_replacement_type_cd,
442: p_effective_date => p_effective_date) then
443: --