APPS.PQH_PTE_BUS dependencies on HR_API

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

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

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

119: (p_ptx_extra_info_id => p_ptx_extra_info_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_position_transaction_id,hr_api.g_number)
124: <> nvl(pqh_pte_shd.g_old_rec.position_transaction_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if position_transaction_id value exists in pqh_position_transactions table

Line 124: <> nvl(pqh_pte_shd.g_old_rec.position_transaction_id,hr_api.g_number)

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

Line 198: and nvl(p_information_type,hr_api.g_varchar2)

194: (p_ptx_extra_info_id => p_ptx_extra_info_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_information_type,hr_api.g_varchar2)
199: <> nvl(pqh_pte_shd.g_old_rec.information_type,hr_api.g_varchar2)
200: or not l_api_updating) then
201: --
202: -- check if information_type value exists in per_position_info_types table

Line 199: <> nvl(pqh_pte_shd.g_old_rec.information_type,hr_api.g_varchar2)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_information_type,hr_api.g_varchar2)
199: <> nvl(pqh_pte_shd.g_old_rec.information_type,hr_api.g_varchar2)
200: or not l_api_updating) then
201: --
202: -- check if information_type value exists in per_position_info_types table
203: --