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

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

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

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

119: (p_role_template_id => p_role_template_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_template_id,hr_api.g_number)
124: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_template_id is not null then
127: --

Line 124: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number)

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

Line 199: and nvl(p_transaction_category_id,hr_api.g_number)

195: (p_role_template_id => p_role_template_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_transaction_category_id,hr_api.g_number)
200: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if transaction_category_id value exists in pqh_transaction_categories table

Line 200: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_transaction_category_id,hr_api.g_number)
200: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if transaction_category_id value exists in pqh_transaction_categories table
204: --

Line 274: and nvl(p_role_id,hr_api.g_number)

270: (p_role_template_id => p_role_template_id,
271: p_object_version_number => p_object_version_number);
272: --
273: if (l_api_updating
274: and nvl(p_role_id,hr_api.g_number)
275: <> nvl(pqh_rtm_shd.g_old_rec.role_id,hr_api.g_number)
276: or not l_api_updating) then
277: --
278: -- check if role_id value exists in pqh_roles table

Line 275: <> nvl(pqh_rtm_shd.g_old_rec.role_id,hr_api.g_number)

271: p_object_version_number => p_object_version_number);
272: --
273: if (l_api_updating
274: and nvl(p_role_id,hr_api.g_number)
275: <> nvl(pqh_rtm_shd.g_old_rec.role_id,hr_api.g_number)
276: or not l_api_updating) then
277: --
278: -- check if role_id value exists in pqh_roles table
279: --

Line 352: <> nvl(pqh_rtm_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating
351: and p_enable_flag
352: <> nvl(pqh_rtm_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
353: or not l_api_updating) then
354: --
355: -- check if value of lookup falls within lookup type.
356: --

Line 358: if hr_api.not_exists_in_hr_lookups

354: --
355: -- check if value of lookup falls within lookup type.
356: --
357: --
358: if hr_api.not_exists_in_hr_lookups
359: (p_lookup_type => 'YES_NO',
360: p_lookup_code => p_enable_flag,
361: p_effective_date => p_effective_date) then
362: --

Line 489: and (nvl(p_transaction_category_id,hr_api.g_number)

485: (p_role_template_id => p_role_template_id,
486: p_object_version_number => p_object_version_number);
487: --
488: if (l_api_updating
489: and (nvl(p_transaction_category_id,hr_api.g_number)
490: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)
491: or nvl(p_template_id,hr_api.g_number)
492: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number) )
493: or not l_api_updating) and

Line 490: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)

486: p_object_version_number => p_object_version_number);
487: --
488: if (l_api_updating
489: and (nvl(p_transaction_category_id,hr_api.g_number)
490: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)
491: or nvl(p_template_id,hr_api.g_number)
492: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number) )
493: or not l_api_updating) and
494: (p_transaction_category_id is not null

Line 491: or nvl(p_template_id,hr_api.g_number)

487: --
488: if (l_api_updating
489: and (nvl(p_transaction_category_id,hr_api.g_number)
490: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)
491: or nvl(p_template_id,hr_api.g_number)
492: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number) )
493: or not l_api_updating) and
494: (p_transaction_category_id is not null
495: or p_template_id is not null) then

Line 492: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number) )

488: if (l_api_updating
489: and (nvl(p_transaction_category_id,hr_api.g_number)
490: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)
491: or nvl(p_template_id,hr_api.g_number)
492: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number) )
493: or not l_api_updating) and
494: (p_transaction_category_id is not null
495: or p_template_id is not null) then
496: --

Line 569: if nvl(p_rec.transaction_category_id,hr_api.g_number) <>

565: end if;
566: --
567: hr_utility.set_location('Leaving:'||l_proc,20);
568:
569: if nvl(p_rec.transaction_category_id,hr_api.g_number) <>
570: nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number) then
571: l_argument := 'transaction_category_id';
572: raise l_error;
573: end if;

Line 570: nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number) then

566: --
567: hr_utility.set_location('Leaving:'||l_proc,20);
568:
569: if nvl(p_rec.transaction_category_id,hr_api.g_number) <>
570: nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number) then
571: l_argument := 'transaction_category_id';
572: raise l_error;
573: end if;
574: hr_utility.set_location(l_proc,30);

Line 577: hr_api.argument_changed_error

573: end if;
574: hr_utility.set_location(l_proc,30);
575: exception
576: when l_error then
577: hr_api.argument_changed_error
578: (p_api_name => l_proc
579: ,p_argument => l_argument
580: );
581: when others then