APPS.GHR_PRH_BUS dependencies on HR_API

Line 34: if nvl(p_rec.pa_request_id,hr_api.g_number)

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

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

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

41: l_argument := 'groupbox_id';
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;

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

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

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

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

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

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

Line 120: hr_api.mandatory_arg_error

116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: --
118: -- Check mandatory parameters have been set
119: --
120: hr_api.mandatory_arg_error
121: (p_api_name => l_proc
122: ,p_argument => 'pa_request_id'
123: ,p_argument_value => p_pa_request_id
124: );

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

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

Line 214: hr_api.mandatory_arg_error

210: l_proc := g_package||'chk_groupbox_id';
211: hr_utility.set_location('Entering:'|| l_proc, 1);
212: --
213: -- Check mandatory parameters have been set
214: hr_api.mandatory_arg_error
215: (p_api_name => l_proc
216: ,p_argument => 'pa_request_id'
217: ,p_argument_value => p_pa_request_id
218: );

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

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

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

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

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

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

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

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