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

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

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

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

119: (p_routing_list_member_id => p_routing_list_member_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_routing_list_id,hr_api.g_number)
124: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if routing_list_id value exists in pqh_routing_lists table

Line 124: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)

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

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

204: p_object_version_number => p_object_version_number);
205: --
206: --
207: if (l_api_updating
208: and (nvl(p_role_id,hr_api.g_number)
209: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
210: or nvl(p_user_id,hr_api.g_number)
211: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
212: or not l_api_updating) and

Line 209: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)

205: --
206: --
207: if (l_api_updating
208: and (nvl(p_role_id,hr_api.g_number)
209: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
210: or nvl(p_user_id,hr_api.g_number)
211: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
212: or not l_api_updating) and
213: (p_role_id is not null) then

Line 210: or nvl(p_user_id,hr_api.g_number)

206: --
207: if (l_api_updating
208: and (nvl(p_role_id,hr_api.g_number)
209: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
210: or nvl(p_user_id,hr_api.g_number)
211: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
212: or not l_api_updating) and
213: (p_role_id is not null) then
214: --

Line 211: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )

207: if (l_api_updating
208: and (nvl(p_role_id,hr_api.g_number)
209: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
210: or nvl(p_user_id,hr_api.g_number)
211: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
212: or not l_api_updating) and
213: (p_role_id is not null) then
214: --
215: -- check if role_id value exists in pqh_roles table and user is assigned to role

Line 315: and (nvl(p_routing_list_id,hr_api.g_number)

311: (p_routing_list_member_id => p_routing_list_member_id,
312: p_object_version_number => p_object_version_number);
313: --
314: if (l_api_updating
315: and (nvl(p_routing_list_id,hr_api.g_number)
316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)

Line 316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)

312: p_object_version_number => p_object_version_number);
313: --
314: if (l_api_updating
315: and (nvl(p_routing_list_id,hr_api.g_number)
316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)
320: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )

Line 317: or nvl(p_role_id,hr_api.g_number)

313: --
314: if (l_api_updating
315: and (nvl(p_routing_list_id,hr_api.g_number)
316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)
320: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
321: or not l_api_updating) and

Line 318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)

314: if (l_api_updating
315: and (nvl(p_routing_list_id,hr_api.g_number)
316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)
320: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
321: or not l_api_updating) and
322: (p_role_id is not null) then

Line 319: or nvl(p_user_id,hr_api.g_number)

315: and (nvl(p_routing_list_id,hr_api.g_number)
316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)
320: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
321: or not l_api_updating) and
322: (p_role_id is not null) then
323: --

Line 320: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )

316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)
320: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
321: or not l_api_updating) and
322: (p_role_id is not null) then
323: --
324: -- check if transaction_category_id and template_id value exists in pqh_templates table

Line 396: and (nvl(p_routing_list_id,hr_api.g_number)

392: (p_routing_list_member_id => p_routing_list_member_id,
393: p_object_version_number => p_object_version_number);
394: --
395: if (l_api_updating
396: and (nvl(p_routing_list_id,hr_api.g_number)
397: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
398: or nvl(p_seq_no,hr_api.g_number)
399: <> nvl(pqh_rlm_shd.g_old_rec.seq_no,hr_api.g_number))
400: or not l_api_updating) and

Line 397: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)

393: p_object_version_number => p_object_version_number);
394: --
395: if (l_api_updating
396: and (nvl(p_routing_list_id,hr_api.g_number)
397: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
398: or nvl(p_seq_no,hr_api.g_number)
399: <> nvl(pqh_rlm_shd.g_old_rec.seq_no,hr_api.g_number))
400: or not l_api_updating) and
401: (p_seq_no is not null) then

Line 398: or nvl(p_seq_no,hr_api.g_number)

394: --
395: if (l_api_updating
396: and (nvl(p_routing_list_id,hr_api.g_number)
397: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
398: or nvl(p_seq_no,hr_api.g_number)
399: <> nvl(pqh_rlm_shd.g_old_rec.seq_no,hr_api.g_number))
400: or not l_api_updating) and
401: (p_seq_no is not null) then
402: --

Line 399: <> nvl(pqh_rlm_shd.g_old_rec.seq_no,hr_api.g_number))

395: if (l_api_updating
396: and (nvl(p_routing_list_id,hr_api.g_number)
397: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
398: or nvl(p_seq_no,hr_api.g_number)
399: <> nvl(pqh_rlm_shd.g_old_rec.seq_no,hr_api.g_number))
400: or not l_api_updating) and
401: (p_seq_no is not null) then
402: --
403: --

Line 472: <> nvl(pqh_rlm_shd.g_old_rec.approver_flag,hr_api.g_varchar2)

468: p_object_version_number => p_object_version_number);
469: --
470: if (l_api_updating
471: and p_approver_flag
472: <> nvl(pqh_rlm_shd.g_old_rec.approver_flag,hr_api.g_varchar2)
473: or not l_api_updating)
474: and p_approver_flag is not null then
475: --
476: -- check if value of lookup falls within lookup type.

Line 478: if hr_api.not_exists_in_hr_lookups

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

Line 564: <> nvl(pqh_rlm_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

560: p_object_version_number => p_object_version_number);
561: --
562: if (l_api_updating
563: and p_enable_flag
564: <> nvl(pqh_rlm_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
565: or not l_api_updating)
566: and p_enable_flag is not null then
567: --
568: -- check if value of lookup falls within lookup type.

Line 570: if hr_api.not_exists_in_hr_lookups

566: and p_enable_flag is not null then
567: --
568: -- check if value of lookup falls within lookup type.
569: --
570: if hr_api.not_exists_in_hr_lookups
571: (p_lookup_type => 'YES_NO',
572: p_lookup_code => p_enable_flag,
573: p_effective_date => p_effective_date) then
574: --