APPS.GHR_PDH_BUS dependencies on HR_API

Line 33: if nvl(p_rec.position_description_id,hr_api.g_number)

29: hr_utility.set_message('STEP', '20');
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;

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 38: if nvl(p_rec.groupbox_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)
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;

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 43: if nvl(p_rec.routing_list_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)
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;

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 49: if nvl(p_rec.routing_seq_number,hr_api.g_number)

45: l_argument := 'routing_list_id';
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;

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 55: -- if nvl(p_rec.nature_of_action_id,hr_api.g_number)

51: l_argument := 'routing_seq_number';
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;

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 64: hr_api.argument_changed_error

60: hr_utility.set_location(l_proc,40);
61: --
62: exception
63: when l_error then
64: hr_api.argument_changed_error
65: (p_api_name => l_proc
66: ,p_argument => l_argument);
67: when others then
68: raise;

Line 117: hr_api.mandatory_arg_error

113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Check mandatory parameters have been set
116: --
117: hr_api.mandatory_arg_error
118: (p_api_name => l_proc
119: ,p_argument => 'position_description_id'
120: ,p_argument_value => p_position_description_id
121: );

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 138: <> nvl(p_position_description_id,hr_api.g_number))

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
142: hr_utility.set_location(l_proc, 40);

Line 210: hr_api.mandatory_arg_error

206: begin
207: hr_utility.set_location('Entering:'|| l_proc, 1);
208: --
209: -- Check mandatory parameters have been set
210: hr_api.mandatory_arg_error
211: (p_api_name => l_proc
212: ,p_argument => 'position_description_id'
213: ,p_argument_value => p_position_description_id
214: );

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 225: <> nvl(p_groupbox_id,hr_api.g_number))

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);
229: --

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 324: <> nvl(p_user_name,hr_api.g_varchar2))

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: --
328: hr_utility.set_location(l_proc, 2);

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 418: <> nvl(p_routing_list_id,hr_api.g_number))

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
422: hr_utility.set_location(l_proc, 40);

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 499: <> nvl(p_routing_seq_number,hr_api.g_number))

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);
503: --