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.GHR_PRH_BUS dependencies on GHR_PRH_SHD

Line 11: Procedure chk_non_updateable_args(p_rec in ghr_prh_shd.g_rec_type) is

7: --
8: g_package varchar2(33) := ' ghr_prh_bus.'; -- Global package name
9:
10:
11: Procedure chk_non_updateable_args(p_rec in ghr_prh_shd.g_rec_type) is
12: --
13: l_proc varchar2(72) ;
14: l_error exception;
15: l_argument varchar2(30);

Line 24: if not ghr_prh_shd.api_updating

20: --
21: -- Only proceed with validation of a row exists for
22: -- the current record in the HR schema
23: --
24: if not ghr_prh_shd.api_updating
25: (p_pa_routing_history_id => p_rec.pa_routing_history_id
26: ,p_object_version_number => p_rec.object_version_number
27: ) then
28: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 35: <> nvl(ghr_prh_shd.g_old_rec.pa_request_id,hr_api.g_number) then

31: end if;
32: hr_utility.set_location(l_proc,30);
33: --
34: if nvl(p_rec.pa_request_id,hr_api.g_number)
35: <> nvl(ghr_prh_shd.g_old_rec.pa_request_id,hr_api.g_number) then
36: l_argument := 'pa_request_id';
37: raise l_error;
38: end if;
39: /*if nvl(p_rec.groupbox_id,hr_api.g_number)

Line 40: <> nvl(ghr_prh_shd.g_old_rec.groupbox_id,hr_api.g_number) then

36: l_argument := 'pa_request_id';
37: raise l_error;
38: end if;
39: /*if nvl(p_rec.groupbox_id,hr_api.g_number)
40: <> nvl(ghr_prh_shd.g_old_rec.groupbox_id,hr_api.g_number) then
41: l_argument := 'groupbox_id';
42: raise l_error;
43: end if;
44: */

Line 46: <> nvl(ghr_prh_shd.g_old_rec.routing_list_id,hr_api.g_number) then

42: raise l_error;
43: end if;
44: */
45: if nvl(p_rec.routing_list_id,hr_api.g_number)
46: <> nvl(ghr_prh_shd.g_old_rec.routing_list_id,hr_api.g_number) then
47: l_argument := 'routing_list_id';
48: raise l_error;
49: end if;
50:

Line 52: <> nvl(ghr_prh_shd.g_old_rec.routing_seq_number,hr_api.g_number) then

48: raise l_error;
49: end if;
50:
51: if nvl(p_rec.routing_seq_number,hr_api.g_number)
52: <> nvl(ghr_prh_shd.g_old_rec.routing_seq_number,hr_api.g_number) then
53: l_argument := 'routing_seq_number';
54: raise l_error;
55: end if;
56:

Line 58: <> nvl(ghr_prh_shd.g_old_rec.nature_of_action_id,hr_api.g_number) then

54: raise l_error;
55: end if;
56:
57: /* if nvl(p_rec.nature_of_action_id,hr_api.g_number)
58: <> nvl(ghr_prh_shd.g_old_rec.nature_of_action_id,hr_api.g_number) then
59: l_argument := 'nature_of_action_id';
60: raise l_error;
61: end if;
62: */

Line 133: l_api_updating := ghr_prh_shd.api_updating

129: -- a) The current g_old_rec is current and
130: -- b) The routing status value has changed
131: -- c) a record is being inserted
132: --
133: l_api_updating := ghr_prh_shd.api_updating
134: (p_pa_routing_history_id => p_pa_routing_history_id
135: ,p_object_version_number => p_object_version_number
136: );
137: hr_utility.set_location(l_proc, 30);

Line 140: and nvl(ghr_prh_shd.g_old_rec.pa_request_id, hr_api.g_number)

136: );
137: hr_utility.set_location(l_proc, 30);
138: --
139: if ((l_api_updating
140: and nvl(ghr_prh_shd.g_old_rec.pa_request_id, hr_api.g_number)
141: <> nvl(p_pa_request_id,hr_api.g_number))
142: or
143: (NOT l_api_updating))
144: then

Line 154: ghr_prh_shd.constraint_error(p_constraint_name => 'GHR_PA_ROUTING_HIST_FK1');

150: l_exists := TRUE;
151: exit;
152: end loop;
153: if not l_exists then
154: ghr_prh_shd.constraint_error(p_constraint_name => 'GHR_PA_ROUTING_HIST_FK1');
155: end if;
156: end if;
157: --
158: hr_utility.set_location(' Leaving:'|| l_proc, 3);

Line 224: l_api_updating := ghr_prh_shd.api_updating

220: -- a) The current g_old_rec is current and
221: -- b) routing_seq_number has changed
222: -- c) A record is being inserted
223: --
224: l_api_updating := ghr_prh_shd.api_updating
225: (p_pa_routing_history_id => p_pa_routing_history_id
226: ,p_object_version_number => p_object_version_number);
227: --
228: if ((l_api_updating and nvl(ghr_prh_shd.g_old_rec.groupbox_id,hr_api.g_number)

Line 228: if ((l_api_updating and nvl(ghr_prh_shd.g_old_rec.groupbox_id,hr_api.g_number)

224: l_api_updating := ghr_prh_shd.api_updating
225: (p_pa_routing_history_id => p_pa_routing_history_id
226: ,p_object_version_number => p_object_version_number);
227: --
228: if ((l_api_updating and nvl(ghr_prh_shd.g_old_rec.groupbox_id,hr_api.g_number)
229: <> nvl(p_groupbox_id,hr_api.g_number))
230: or (NOT l_api_updating)) then
231: --
232: hr_utility.set_location(l_proc, 2);

Line 314: l_api_updating := ghr_prh_shd.api_updating

310: -- a) The current g_old_rec is current and
311: -- b) routing_user_name has changed
312: -- c) A record is being inserted
313: --
314: l_api_updating := ghr_prh_shd.api_updating
315: (p_pa_routing_history_id => p_pa_routing_history_id
316: ,p_object_version_number => p_object_version_number
317: );
318:

Line 320: if ((l_api_updating and nvl(ghr_prh_shd.g_old_rec.user_name,hr_api.g_varchar2)

316: ,p_object_version_number => p_object_version_number
317: );
318:
319: --
320: if ((l_api_updating and nvl(ghr_prh_shd.g_old_rec.user_name,hr_api.g_varchar2)
321: <> nvl(p_user_name,hr_api.g_varchar2))
322: or (NOT l_api_updating)) then
323:
324: --

Line 411: l_api_updating := ghr_prh_shd.api_updating

407: -- a) The current g_old_rec is current and
408: -- b) The routing status value has changed
409: -- c) a record is being inserted
410: --
411: l_api_updating := ghr_prh_shd.api_updating
412: (p_pa_routing_history_id => p_pa_routing_history_id
413: ,p_object_version_number => p_object_version_number
414: );
415: hr_utility.set_location(l_proc, 30);

Line 418: and nvl(ghr_prh_shd.g_old_rec.routing_list_id, hr_api.g_number)

414: );
415: hr_utility.set_location(l_proc, 30);
416: --
417: if ((l_api_updating
418: and nvl(ghr_prh_shd.g_old_rec.routing_list_id, hr_api.g_number)
419: <> nvl(p_routing_list_id,hr_api.g_number))
420: or
421: (NOT l_api_updating))
422: then

Line 432: ghr_prh_shd.constraint_error(p_constraint_name => 'GHR_PA_ROUTING_HIST_FK2');

428: for rec in c_rout_list_id loop
429: l_exists := true;
430: end loop;
431: if not l_exists then
432: ghr_prh_shd.constraint_error(p_constraint_name => 'GHR_PA_ROUTING_HIST_FK2');
433: end if;
434: end if;
435: end if;
436: --

Line 495: l_api_updating := ghr_prh_shd.api_updating

491: -- a) The current g_old_rec is current and
492: -- b) routing_seq_number has changed
493: -- c) A record is being inserted
494: --
495: l_api_updating := ghr_prh_shd.api_updating
496: (p_pa_routing_history_id => p_pa_routing_history_id
497: ,p_object_version_number => p_object_version_number);
498: --
499: if ((l_api_updating and nvl(ghr_prh_shd.g_old_rec.routing_seq_number,hr_api.g_number)

Line 499: if ((l_api_updating and nvl(ghr_prh_shd.g_old_rec.routing_seq_number,hr_api.g_number)

495: l_api_updating := ghr_prh_shd.api_updating
496: (p_pa_routing_history_id => p_pa_routing_history_id
497: ,p_object_version_number => p_object_version_number);
498: --
499: if ((l_api_updating and nvl(ghr_prh_shd.g_old_rec.routing_seq_number,hr_api.g_number)
500: <> nvl(p_routing_seq_number,hr_api.g_number))
501: or (NOT l_api_updating)) then
502: --
503: hr_utility.set_location(l_proc, 2);

Line 528: (p_rec in ghr_prh_shd.g_rec_type

524: -- ----------------------------------------------------------------------------
525: -- |---------------------------< insert_validate >----------------------------|
526: -- ----------------------------------------------------------------------------
527: Procedure insert_validate
528: (p_rec in ghr_prh_shd.g_rec_type
529: )is
530: --
531: l_proc varchar2(72) := g_package||'insert_validate';
532: --

Line 586: (p_rec in ghr_prh_shd.g_rec_type

582: -- ----------------------------------------------------------------------------
583: --Note : identify all non_updateable args and remove code where necessary
584:
585: Procedure update_validate
586: (p_rec in ghr_prh_shd.g_rec_type
587: )is
588: --
589: l_proc varchar2(72) := g_package||'update_validate';
590: --

Line 624: Procedure delete_validate(p_rec in ghr_prh_shd.g_rec_type) is

620:
621: -- ----------------------------------------------------------------------------
622: -- |---------------------------< delete_validate >----------------------------|
623: -- ----------------------------------------------------------------------------
624: Procedure delete_validate(p_rec in ghr_prh_shd.g_rec_type) is
625: --
626: l_proc varchar2(72) := g_package||'delete_validate';
627: --
628: Begin