APPS.PQH_CEF_BUS dependencies on HR_API

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

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

Line 123: and nvl(p_context,hr_api.g_varchar2)

119: (p_copy_entity_function_id => p_copy_entity_function_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_context,hr_api.g_varchar2)
124: <> nvl(pqh_cef_shd.g_old_rec.context,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if context value exists in pqh_copy_entity_contexts table

Line 124: <> nvl(pqh_cef_shd.g_old_rec.context,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_context,hr_api.g_varchar2)
124: <> nvl(pqh_cef_shd.g_old_rec.context,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if context value exists in pqh_copy_entity_contexts table
128: --

Line 198: and nvl(p_table_route_id,hr_api.g_number)

194: (p_copy_entity_function_id => p_copy_entity_function_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_table_route_id,hr_api.g_number)
199: <> nvl(pqh_cef_shd.g_old_rec.table_route_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if table_route_id value exists in pqh_table_route table

Line 199: <> nvl(pqh_cef_shd.g_old_rec.table_route_id,hr_api.g_number)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_table_route_id,hr_api.g_number)
199: <> nvl(pqh_cef_shd.g_old_rec.table_route_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if table_route_id value exists in pqh_table_route table
203: --

Line 270: <> nvl(pqh_cef_shd.g_old_rec.function_type_cd,hr_api.g_varchar2)

266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating
269: and p_function_type_cd
270: <> nvl(pqh_cef_shd.g_old_rec.function_type_cd,hr_api.g_varchar2)
271: or not l_api_updating)
272: and p_function_type_cd is not null then
273: --
274: -- check if value of lookup falls within lookup type.

Line 276: if hr_api.not_exists_in_hr_lookups

272: and p_function_type_cd is not null then
273: --
274: -- check if value of lookup falls within lookup type.
275: --
276: if hr_api.not_exists_in_hr_lookups
277: (p_lookup_type => 'PQH_ENTITY_FUNCTION_TYPE',
278: p_lookup_code => p_function_type_cd,
279: p_effective_date => p_effective_date) then
280: --