eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_SAT_BUS dependencies on HR_API

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

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

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

119: (p_special_attribute_id => p_special_attribute_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_sat_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_sat_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_sat_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_txn_category_attribute_id,hr_api.g_number)

194: (p_special_attribute_id => p_special_attribute_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_txn_category_attribute_id,hr_api.g_number)
199: <> nvl(pqh_sat_shd.g_old_rec.txn_category_attribute_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if txn_category_attribute_id value exists in pqh_txn_category_attributes table

Line 199: <> nvl(pqh_sat_shd.g_old_rec.txn_category_attribute_id,hr_api.g_number)

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

Line 270: <> nvl(pqh_sat_shd.g_old_rec.key_attribute_type,hr_api.g_varchar2)

266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating
269: and p_key_attribute_type
270: <> nvl(pqh_sat_shd.g_old_rec.key_attribute_type,hr_api.g_varchar2)
271: or not l_api_updating)
272: and p_key_attribute_type 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_key_attribute_type 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_ATTRIBUTE_TYPE_CD',
278: p_lookup_code => p_key_attribute_type,
279: p_effective_date => p_effective_date) then
280: --

Line 337: <> nvl(pqh_sat_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating
336: and p_enable_flag
337: <> nvl(pqh_sat_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
338: or not l_api_updating)
339: and p_enable_flag is not null then
340: --
341: -- check if value of lookup falls within lookup type.

Line 343: if hr_api.not_exists_in_hr_lookups

339: and p_enable_flag is not null then
340: --
341: -- check if value of lookup falls within lookup type.
342: --
343: if hr_api.not_exists_in_hr_lookups
344: (p_lookup_type => 'YES_NO',
345: p_lookup_code => p_enable_flag,
346: p_effective_date => p_effective_date) then
347: --

Line 405: <> nvl(pqh_sat_shd.g_old_rec.attribute_type_cd,hr_api.g_varchar2)

401: p_object_version_number => p_object_version_number);
402: --
403: if (l_api_updating
404: and p_attribute_type_cd
405: <> nvl(pqh_sat_shd.g_old_rec.attribute_type_cd,hr_api.g_varchar2)
406: or not l_api_updating)
407: and p_attribute_type_cd is not null then
408: --
409: -- check if value of lookup falls within lookup type.

Line 411: if hr_api.not_exists_in_hr_lookups

407: and p_attribute_type_cd is not null then
408: --
409: -- check if value of lookup falls within lookup type.
410: --
411: if hr_api.not_exists_in_hr_lookups
412: (p_lookup_type => 'PQH_ATTRIBUTE_TYPE_CD',
413: p_lookup_code => p_attribute_type_cd,
414: p_effective_date => p_effective_date) then
415: --