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_PDH_BUS dependencies on GHR_PDH_SHD

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

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

Line 23: if not ghr_pdh_shd.api_updating

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

Line 34: <> nvl(ghr_pdh_shd.g_old_rec.position_description_id,hr_api.g_number) then

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

Line 39: <> nvl(ghr_pdh_shd.g_old_rec.groupbox_id,hr_api.g_number) then

35: l_argument := 'position_description_id';
36: raise l_error;
37: end if;
38: if nvl(p_rec.groupbox_id,hr_api.g_number)
39: <> nvl(ghr_pdh_shd.g_old_rec.groupbox_id,hr_api.g_number) then
40: l_argument := 'groupbox_id';
41: raise l_error;
42: end if;
43: if nvl(p_rec.routing_list_id,hr_api.g_number)

Line 44: <> nvl(ghr_pdh_shd.g_old_rec.routing_list_id,hr_api.g_number) then

40: l_argument := 'groupbox_id';
41: raise l_error;
42: end if;
43: if nvl(p_rec.routing_list_id,hr_api.g_number)
44: <> nvl(ghr_pdh_shd.g_old_rec.routing_list_id,hr_api.g_number) then
45: l_argument := 'routing_list_id';
46: raise l_error;
47: end if;
48:

Line 50: <> nvl(ghr_pdh_shd.g_old_rec.routing_seq_number,hr_api.g_number) then

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

Line 56: -- <> nvl(ghr_pdh_shd.g_old_rec.nature_of_action_id,hr_api.g_number) then

52: raise l_error;
53: end if;
54:
55: -- if nvl(p_rec.nature_of_action_id,hr_api.g_number)
56: -- <> nvl(ghr_pdh_shd.g_old_rec.nature_of_action_id,hr_api.g_number) then
57: -- l_argument := 'nature_of_action_id';
58: -- raise l_error;
59: -- end if;
60: hr_utility.set_location(l_proc,40);

Line 130: l_api_updating := ghr_pdh_shd.api_updating

126: -- a) The current g_old_rec is current and
127: -- b) The routing status value has changed
128: -- c) a record is being inserted
129: --
130: l_api_updating := ghr_pdh_shd.api_updating
131: (p_pd_routing_history_id => p_pd_routing_history_id
132: ,p_object_version_number => p_object_version_number
133: );
134: hr_utility.set_location(l_proc, 30);

Line 137: and nvl(ghr_pdh_shd.g_old_rec.position_description_id, hr_api.g_number)

133: );
134: hr_utility.set_location(l_proc, 30);
135: --
136: if ((l_api_updating
137: and nvl(ghr_pdh_shd.g_old_rec.position_description_id, hr_api.g_number)
138: <> nvl(p_position_description_id,hr_api.g_number))
139: or
140: (NOT l_api_updating))
141: then

Line 151: ghr_pdh_shd.constraint_error(p_constraint_name => 'GHR_PD_ROUTING_HIST_FK1');

147: l_exists := TRUE;
148: exit;
149: end loop;
150: if not l_exists then
151: ghr_pdh_shd.constraint_error(p_constraint_name => 'GHR_PD_ROUTING_HIST_FK1');
152: end if;
153: end if;
154: --
155: hr_utility.set_location(' Leaving:'|| l_proc, 3);

Line 220: l_api_updating := ghr_pdh_shd.api_updating

216: -- a) The current g_old_rec is current and
217: -- b) routing_seq_number has changed
218: -- c) A record is being inserted
219: --
220: l_api_updating := ghr_pdh_shd.api_updating
221: (p_pd_routing_history_id => p_pd_routing_history_id
222: ,p_object_version_number => p_object_version_number);
223: --
224: if ((l_api_updating and nvl(ghr_pdh_shd.g_old_rec.groupbox_id,hr_api.g_number)

Line 224: if ((l_api_updating and nvl(ghr_pdh_shd.g_old_rec.groupbox_id,hr_api.g_number)

220: l_api_updating := ghr_pdh_shd.api_updating
221: (p_pd_routing_history_id => p_pd_routing_history_id
222: ,p_object_version_number => p_object_version_number);
223: --
224: if ((l_api_updating and nvl(ghr_pdh_shd.g_old_rec.groupbox_id,hr_api.g_number)
225: <> nvl(p_groupbox_id,hr_api.g_number))
226: or (NOT l_api_updating)) then
227: --
228: hr_utility.set_location(l_proc, 2);

Line 317: l_api_updating := ghr_pdh_shd.api_updating

313: -- a) The current g_old_rec is current and
314: -- b) routing_user_name has changed
315: -- c) A record is being inserted
316: --
317: l_api_updating := ghr_pdh_shd.api_updating
318: (p_pd_routing_history_id => p_pd_routing_history_id
319: ,p_object_version_number => p_object_version_number
320: );
321:

Line 323: if ((l_api_updating and nvl(ghr_pdh_shd.g_old_rec.user_name,hr_api.g_varchar2)

319: ,p_object_version_number => p_object_version_number
320: );
321:
322: --
323: if ((l_api_updating and nvl(ghr_pdh_shd.g_old_rec.user_name,hr_api.g_varchar2)
324: <> nvl(p_user_name,hr_api.g_varchar2))
325: or (NOT l_api_updating)) then
326:
327: --

Line 410: l_api_updating := ghr_pdh_shd.api_updating

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

Line 417: and nvl(ghr_pdh_shd.g_old_rec.routing_list_id, hr_api.g_number)

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

Line 431: ghr_pdh_shd.constraint_error(p_constraint_name => 'GHR_PD_ROUTING_HIST_FK2');

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

Line 494: l_api_updating := ghr_pdh_shd.api_updating

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

Line 498: if ((l_api_updating and nvl(ghr_pdh_shd.g_old_rec.routing_seq_number,hr_api.g_number)

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

Line 527: (p_rec in ghr_pdh_shd.g_rec_type

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

Line 586: (p_rec in ghr_pdh_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_pdh_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_pdh_shd.g_rec_type) is

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