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 PQH_RLM_SHD

Line 46: l_api_updating := pqh_rlm_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_rlm_shd.api_updating
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

Line 52: <> pqh_rlm_shd.g_old_rec.routing_list_member_id) then

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: --
56: pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_PK');

Line 56: pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_PK');

52: <> pqh_rlm_shd.g_old_rec.routing_list_member_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_PK');

62: if p_routing_list_member_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_PK');
67: --
68: end if;
69: --
70: end if;

Line 118: l_api_updating := pqh_rlm_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_rlm_shd.api_updating
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

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 142: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK2');

138: --
139: hr_utility.set_message(8302, 'PQH_INVALID_ROUTING_LIST');
140: hr_utility.raise_error;
141:
142: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK2');
143: --
144: end if;
145: --
146: close c1;

Line 202: l_api_updating := pqh_rlm_shd.api_updating

198: Begin
199: --
200: hr_utility.set_location('Entering:'||l_proc,5);
201: --
202: l_api_updating := pqh_rlm_shd.api_updating
203: (p_routing_list_member_id => p_routing_list_member_id,
204: p_object_version_number => p_object_version_number);
205: --
206: --

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 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 229: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');

225: -- table.
226: --
227: hr_utility.set_message(8302,'PQH_INVALID_ROLE');
228: hr_utility.raise_error;
229: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');
230: --
231: end if;
232: --
233: close c1;

Line 251: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');

247: -- table.
248: --
249: hr_utility.set_message(8302,'PQH_USER_NOT_OF_CUR_ROLE');
250: hr_utility.raise_error;
251: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');
252: --
253: end if;
254: --
255: close c2;

Line 310: l_api_updating := pqh_rlm_shd.api_updating

306: Begin
307: --
308: hr_utility.set_location('Entering:'||l_proc,5);
309: --
310: l_api_updating := pqh_rlm_shd.api_updating
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

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 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 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 391: l_api_updating := pqh_rlm_shd.api_updating

387: Begin
388: --
389: hr_utility.set_location('Entering:'||l_proc,5);
390: --
391: l_api_updating := pqh_rlm_shd.api_updating
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

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 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 466: l_api_updating := pqh_rlm_shd.api_updating

462: Begin
463: --
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: l_api_updating := pqh_rlm_shd.api_updating
467: (p_routing_list_member_id => p_routing_list_member_id,
468: p_object_version_number => p_object_version_number);
469: --
470: if (l_api_updating

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 558: l_api_updating := pqh_rlm_shd.api_updating

554: Begin
555: --
556: hr_utility.set_location('Entering:'||l_proc, 5);
557: --
558: l_api_updating := pqh_rlm_shd.api_updating
559: (p_routing_list_member_id => p_routing_list_member_id,
560: p_object_version_number => p_object_version_number);
561: --
562: if (l_api_updating

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 740: Procedure insert_validate(p_rec in pqh_rlm_shd.g_rec_type

736: --
737: -- ----------------------------------------------------------------------------
738: -- |---------------------------< insert_validate >----------------------------|
739: -- ----------------------------------------------------------------------------
740: Procedure insert_validate(p_rec in pqh_rlm_shd.g_rec_type
741: ,p_effective_date in date) is
742: --
743: l_proc varchar2(72) := g_package||'insert_validate';
744: --

Line 800: Procedure update_validate(p_rec in pqh_rlm_shd.g_rec_type

796: --
797: -- ----------------------------------------------------------------------------
798: -- |---------------------------< update_validate >----------------------------|
799: -- ----------------------------------------------------------------------------
800: Procedure update_validate(p_rec in pqh_rlm_shd.g_rec_type
801: ,p_effective_date in date) is
802: --
803: l_proc varchar2(72) := g_package||'update_validate';
804: --

Line 861: Procedure delete_validate(p_rec in pqh_rlm_shd.g_rec_type

857: --
858: -- ----------------------------------------------------------------------------
859: -- |---------------------------< delete_validate >----------------------------|
860: -- ----------------------------------------------------------------------------
861: Procedure delete_validate(p_rec in pqh_rlm_shd.g_rec_type
862: ,p_effective_date in date) is
863: --
864: l_proc varchar2(72) := g_package||'delete_validate';
865: --