APPS.PQH_CEA_BUS dependencies on HR_API

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

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

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

119: (p_copy_entity_attrib_id => p_copy_entity_attrib_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_copy_entity_txn_id,hr_api.g_number)
124: <> nvl(pqh_cea_shd.g_old_rec.copy_entity_txn_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if copy_entity_txn_id value exists in pqh_copy_entity_txns table

Line 124: <> nvl(pqh_cea_shd.g_old_rec.copy_entity_txn_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_copy_entity_txn_id,hr_api.g_number)
124: <> nvl(pqh_cea_shd.g_old_rec.copy_entity_txn_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if copy_entity_txn_id value exists in pqh_copy_entity_txns table
128: --

Line 195: <> nvl(pqh_cea_shd.g_old_rec.row_type_cd,hr_api.g_varchar2)

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

Line 201: if hr_api.not_exists_in_hr_lookups

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