APPS.PQH_CER_BUS dependencies on HR_API

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

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

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

188: (p_copy_entity_result_id => p_copy_entity_result_id,
189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and nvl(p_copy_entity_txn_id,hr_api.g_number)
193: <> nvl(pqh_cer_shd.g_old_rec.copy_entity_txn_id,hr_api.g_number)
194: or not l_api_updating) then
195: --
196: -- check if copy_entity_txn_id value exists in pqh_copy_entity_txns table

Line 193: <> nvl(pqh_cer_shd.g_old_rec.copy_entity_txn_id,hr_api.g_number)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and nvl(p_copy_entity_txn_id,hr_api.g_number)
193: <> nvl(pqh_cer_shd.g_old_rec.copy_entity_txn_id,hr_api.g_number)
194: or not l_api_updating) then
195: --
196: -- check if copy_entity_txn_id value exists in pqh_copy_entity_txns table
197: --

Line 264: <> nvl(pqh_cer_shd.g_old_rec.result_type_cd,hr_api.g_varchar2)

260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and p_result_type_cd
264: <> nvl(pqh_cer_shd.g_old_rec.result_type_cd,hr_api.g_varchar2)
265: or not l_api_updating)
266: and p_result_type_cd 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_result_type_cd 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 => 'PQH_GEN_STATUS',
272: p_lookup_code => p_result_type_cd,
273: p_effective_date => p_effective_date) then
274: --