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_TAT_BUS dependencies on HR_API

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

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

Line 124: and nvl(p_template_id,hr_api.g_number)

120: (p_template_attribute_id => p_template_attribute_id,
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_template_id,hr_api.g_number)
125: <> nvl(pqh_tat_shd.g_old_rec.template_id,hr_api.g_number)
126: or not l_api_updating) then
127: --
128: -- check if template_id value exists in pqh_templates table

Line 125: <> nvl(pqh_tat_shd.g_old_rec.template_id,hr_api.g_number)

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_template_id,hr_api.g_number)
125: <> nvl(pqh_tat_shd.g_old_rec.template_id,hr_api.g_number)
126: or not l_api_updating) then
127: --
128: -- check if template_id value exists in pqh_templates table
129: --

Line 216: and nvl(p_attribute_id,hr_api.g_number)

212: (p_template_attribute_id => p_template_attribute_id,
213: p_object_version_number => p_object_version_number);
214: --
215: if (l_api_updating
216: and nvl(p_attribute_id,hr_api.g_number)
217: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
218: or not l_api_updating) then
219: --
220: -- check if attribute_id value exists in pqh_attributes table

Line 217: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)

213: p_object_version_number => p_object_version_number);
214: --
215: if (l_api_updating
216: and nvl(p_attribute_id,hr_api.g_number)
217: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
218: or not l_api_updating) then
219: --
220: -- check if attribute_id value exists in pqh_attributes table
221: --

Line 328: and nvl(p_attribute_id,hr_api.g_number)

324: p_object_version_number => p_object_version_number);
325: --
326: /**
327: if (l_api_updating
328: and nvl(p_attribute_id,hr_api.g_number)
329: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
330: or not l_api_updating) then
331: **/
332: --

Line 329: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)

325: --
326: /**
327: if (l_api_updating
328: and nvl(p_attribute_id,hr_api.g_number)
329: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
330: or not l_api_updating) then
331: **/
332: --
333: --

Line 397: and nvl(p_attribute_id,hr_api.g_number)

393: (p_template_attribute_id => p_template_attribute_id,
394: p_object_version_number => p_object_version_number);
395: --
396: if (l_api_updating
397: and nvl(p_attribute_id,hr_api.g_number)
398: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
399: or not l_api_updating) then
400: --
401: open c_template_leg_code;

Line 398: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)

394: p_object_version_number => p_object_version_number);
395: --
396: if (l_api_updating
397: and nvl(p_attribute_id,hr_api.g_number)
398: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
399: or not l_api_updating) then
400: --
401: open c_template_leg_code;
402: fetch c_template_leg_code into l_template_leg_code, l_template_name;

Line 475: <> nvl(pqh_tat_shd.g_old_rec.edit_flag,hr_api.g_varchar2)

471: p_object_version_number => p_object_version_number);
472: --
473: if (l_api_updating
474: and p_edit_flag
475: <> nvl(pqh_tat_shd.g_old_rec.edit_flag,hr_api.g_varchar2)
476: or not l_api_updating)
477: and p_edit_flag is not null then
478: --
479: -- check if value of lookup falls within lookup type.

Line 481: if hr_api.not_exists_in_hr_lookups

477: and p_edit_flag is not null then
478: --
479: -- check if value of lookup falls within lookup type.
480: --
481: if hr_api.not_exists_in_hr_lookups
482: (p_lookup_type => 'YES_NO',
483: p_lookup_code => p_edit_flag,
484: p_effective_date => p_effective_date) then
485: --

Line 543: <> nvl(pqh_tat_shd.g_old_rec.view_flag,hr_api.g_varchar2)

539: p_object_version_number => p_object_version_number);
540: --
541: if (l_api_updating
542: and p_view_flag
543: <> nvl(pqh_tat_shd.g_old_rec.view_flag,hr_api.g_varchar2)
544: or not l_api_updating)
545: and p_view_flag is not null then
546: --
547: -- check if value of lookup falls within lookup type.

Line 549: if hr_api.not_exists_in_hr_lookups

545: and p_view_flag is not null then
546: --
547: -- check if value of lookup falls within lookup type.
548: --
549: if hr_api.not_exists_in_hr_lookups
550: (p_lookup_type => 'YES_NO',
551: p_lookup_code => p_view_flag,
552: p_effective_date => p_effective_date) then
553: --

Line 611: <> nvl(pqh_tat_shd.g_old_rec.required_flag,hr_api.g_varchar2)

607: p_object_version_number => p_object_version_number);
608: --
609: if (l_api_updating
610: and p_required_flag
611: <> nvl(pqh_tat_shd.g_old_rec.required_flag,hr_api.g_varchar2)
612: or not l_api_updating)
613: and p_required_flag is not null then
614: --
615: -- check if value of lookup falls within lookup type.

Line 617: if hr_api.not_exists_in_hr_lookups

613: and p_required_flag is not null then
614: --
615: -- check if value of lookup falls within lookup type.
616: --
617: if hr_api.not_exists_in_hr_lookups
618: (p_lookup_type => 'YES_NO',
619: p_lookup_code => p_required_flag,
620: p_effective_date => p_effective_date) then
621: --