DBA Data[Home] [Help]

APPS.IRC_INTERVIEW_DETAILS_API dependencies on HR_API

Line 14: ,p_status in varchar2 default hr_api.g_varchar2

10: -- ----------------------------------------------------------------------------
11: --
12: procedure create_irc_interview_details
13: (p_validate in boolean default false
14: ,p_status in varchar2 default hr_api.g_varchar2
15: ,p_feedback in varchar2 default hr_api.g_varchar2
16: ,p_notes in varchar2 default hr_api.g_varchar2
17: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
18: ,p_category in varchar2 default hr_api.g_varchar2

Line 15: ,p_feedback in varchar2 default hr_api.g_varchar2

11: --
12: procedure create_irc_interview_details
13: (p_validate in boolean default false
14: ,p_status in varchar2 default hr_api.g_varchar2
15: ,p_feedback in varchar2 default hr_api.g_varchar2
16: ,p_notes in varchar2 default hr_api.g_varchar2
17: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
18: ,p_category in varchar2 default hr_api.g_varchar2
19: ,p_result in varchar2 default hr_api.g_varchar2

Line 16: ,p_notes in varchar2 default hr_api.g_varchar2

12: procedure create_irc_interview_details
13: (p_validate in boolean default false
14: ,p_status in varchar2 default hr_api.g_varchar2
15: ,p_feedback in varchar2 default hr_api.g_varchar2
16: ,p_notes in varchar2 default hr_api.g_varchar2
17: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
18: ,p_category in varchar2 default hr_api.g_varchar2
19: ,p_result in varchar2 default hr_api.g_varchar2
20: ,p_iid_information_category in varchar2 default hr_api.g_varchar2

Line 17: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2

13: (p_validate in boolean default false
14: ,p_status in varchar2 default hr_api.g_varchar2
15: ,p_feedback in varchar2 default hr_api.g_varchar2
16: ,p_notes in varchar2 default hr_api.g_varchar2
17: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
18: ,p_category in varchar2 default hr_api.g_varchar2
19: ,p_result in varchar2 default hr_api.g_varchar2
20: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
21: ,p_iid_information1 in varchar2 default hr_api.g_varchar2

Line 18: ,p_category in varchar2 default hr_api.g_varchar2

14: ,p_status in varchar2 default hr_api.g_varchar2
15: ,p_feedback in varchar2 default hr_api.g_varchar2
16: ,p_notes in varchar2 default hr_api.g_varchar2
17: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
18: ,p_category in varchar2 default hr_api.g_varchar2
19: ,p_result in varchar2 default hr_api.g_varchar2
20: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
21: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information2 in varchar2 default hr_api.g_varchar2

Line 19: ,p_result in varchar2 default hr_api.g_varchar2

15: ,p_feedback in varchar2 default hr_api.g_varchar2
16: ,p_notes in varchar2 default hr_api.g_varchar2
17: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
18: ,p_category in varchar2 default hr_api.g_varchar2
19: ,p_result in varchar2 default hr_api.g_varchar2
20: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
21: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information3 in varchar2 default hr_api.g_varchar2

Line 20: ,p_iid_information_category in varchar2 default hr_api.g_varchar2

16: ,p_notes in varchar2 default hr_api.g_varchar2
17: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
18: ,p_category in varchar2 default hr_api.g_varchar2
19: ,p_result in varchar2 default hr_api.g_varchar2
20: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
21: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information4 in varchar2 default hr_api.g_varchar2

Line 21: ,p_iid_information1 in varchar2 default hr_api.g_varchar2

17: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
18: ,p_category in varchar2 default hr_api.g_varchar2
19: ,p_result in varchar2 default hr_api.g_varchar2
20: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
21: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information5 in varchar2 default hr_api.g_varchar2

Line 22: ,p_iid_information2 in varchar2 default hr_api.g_varchar2

18: ,p_category in varchar2 default hr_api.g_varchar2
19: ,p_result in varchar2 default hr_api.g_varchar2
20: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
21: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information6 in varchar2 default hr_api.g_varchar2

Line 23: ,p_iid_information3 in varchar2 default hr_api.g_varchar2

19: ,p_result in varchar2 default hr_api.g_varchar2
20: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
21: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information7 in varchar2 default hr_api.g_varchar2

Line 24: ,p_iid_information4 in varchar2 default hr_api.g_varchar2

20: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
21: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information8 in varchar2 default hr_api.g_varchar2

Line 25: ,p_iid_information5 in varchar2 default hr_api.g_varchar2

21: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information9 in varchar2 default hr_api.g_varchar2

Line 26: ,p_iid_information6 in varchar2 default hr_api.g_varchar2

22: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information10 in varchar2 default hr_api.g_varchar2

Line 27: ,p_iid_information7 in varchar2 default hr_api.g_varchar2

23: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information11 in varchar2 default hr_api.g_varchar2

Line 28: ,p_iid_information8 in varchar2 default hr_api.g_varchar2

24: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information12 in varchar2 default hr_api.g_varchar2

Line 29: ,p_iid_information9 in varchar2 default hr_api.g_varchar2

25: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information13 in varchar2 default hr_api.g_varchar2

Line 30: ,p_iid_information10 in varchar2 default hr_api.g_varchar2

26: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information14 in varchar2 default hr_api.g_varchar2

Line 31: ,p_iid_information11 in varchar2 default hr_api.g_varchar2

27: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information15 in varchar2 default hr_api.g_varchar2

Line 32: ,p_iid_information12 in varchar2 default hr_api.g_varchar2

28: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information16 in varchar2 default hr_api.g_varchar2

Line 33: ,p_iid_information13 in varchar2 default hr_api.g_varchar2

29: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information17 in varchar2 default hr_api.g_varchar2

Line 34: ,p_iid_information14 in varchar2 default hr_api.g_varchar2

30: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information18 in varchar2 default hr_api.g_varchar2

Line 35: ,p_iid_information15 in varchar2 default hr_api.g_varchar2

31: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
39: ,p_iid_information19 in varchar2 default hr_api.g_varchar2

Line 36: ,p_iid_information16 in varchar2 default hr_api.g_varchar2

32: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
39: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
40: ,p_iid_information20 in varchar2 default hr_api.g_varchar2

Line 37: ,p_iid_information17 in varchar2 default hr_api.g_varchar2

33: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
39: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
40: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
41: ,p_event_id in number

Line 38: ,p_iid_information18 in varchar2 default hr_api.g_varchar2

34: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
39: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
40: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
41: ,p_event_id in number
42: ,p_interview_details_id out nocopy number

Line 39: ,p_iid_information19 in varchar2 default hr_api.g_varchar2

35: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
39: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
40: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
41: ,p_event_id in number
42: ,p_interview_details_id out nocopy number
43: ,p_object_version_number out nocopy number

Line 40: ,p_iid_information20 in varchar2 default hr_api.g_varchar2

36: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
39: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
40: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
41: ,p_event_id in number
42: ,p_interview_details_id out nocopy number
43: ,p_object_version_number out nocopy number
44: ,p_start_date out nocopy date

Line 98: when hr_api.cannot_find_prog_unit then

94: ,p_iid_information20 => p_iid_information20
95: ,p_event_id => p_event_id
96: );
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'create_irc_interview_details'
101: ,p_hook_type => 'BP'
102: );

Line 99: hr_api.cannot_find_prog_unit_error

95: ,p_event_id => p_event_id
96: );
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'create_irc_interview_details'
101: ,p_hook_type => 'BP'
102: );
103: end;

Line 182: when hr_api.cannot_find_prog_unit then

178: ,p_start_date => l_start_date
179: ,p_end_date => l_end_date
180: );
181: exception
182: when hr_api.cannot_find_prog_unit then
183: hr_api.cannot_find_prog_unit_error
184: (p_module_name => 'create_irc_interview_details'
185: ,p_hook_type => 'AP'
186: );

Line 183: hr_api.cannot_find_prog_unit_error

179: ,p_end_date => l_end_date
180: );
181: exception
182: when hr_api.cannot_find_prog_unit then
183: hr_api.cannot_find_prog_unit_error
184: (p_module_name => 'create_irc_interview_details'
185: ,p_hook_type => 'AP'
186: );
187: end;

Line 192: raise hr_api.validate_enabled;

188: --
189: -- When in validation only mode raise the Validate_Enabled exception
190: --
191: if p_validate then
192: raise hr_api.validate_enabled;
193: end if;
194: --
195: -- Set all IN OUT and OUT parameters with out values
196: --

Line 204: when hr_api.validate_enabled then

200: p_end_date := l_end_date;
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 70);
203: exception
204: when hr_api.validate_enabled then
205: --
206: -- As the Validate_Enabled exception has been raised
207: -- we must rollback to the savepoint
208: --

Line 245: ,p_status in varchar2 default hr_api.g_varchar2

241: --
242: procedure update_irc_interview_details
243: (p_validate in boolean default false
244: ,p_interview_details_id in number
245: ,p_status in varchar2 default hr_api.g_varchar2
246: ,p_feedback in varchar2 default hr_api.g_varchar2
247: ,p_notes in varchar2 default hr_api.g_varchar2
248: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
249: ,p_category in varchar2 default hr_api.g_varchar2

Line 246: ,p_feedback in varchar2 default hr_api.g_varchar2

242: procedure update_irc_interview_details
243: (p_validate in boolean default false
244: ,p_interview_details_id in number
245: ,p_status in varchar2 default hr_api.g_varchar2
246: ,p_feedback in varchar2 default hr_api.g_varchar2
247: ,p_notes in varchar2 default hr_api.g_varchar2
248: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
249: ,p_category in varchar2 default hr_api.g_varchar2
250: ,p_result in varchar2 default hr_api.g_varchar2

Line 247: ,p_notes in varchar2 default hr_api.g_varchar2

243: (p_validate in boolean default false
244: ,p_interview_details_id in number
245: ,p_status in varchar2 default hr_api.g_varchar2
246: ,p_feedback in varchar2 default hr_api.g_varchar2
247: ,p_notes in varchar2 default hr_api.g_varchar2
248: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
249: ,p_category in varchar2 default hr_api.g_varchar2
250: ,p_result in varchar2 default hr_api.g_varchar2
251: ,p_iid_information_category in varchar2 default hr_api.g_varchar2

Line 248: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2

244: ,p_interview_details_id in number
245: ,p_status in varchar2 default hr_api.g_varchar2
246: ,p_feedback in varchar2 default hr_api.g_varchar2
247: ,p_notes in varchar2 default hr_api.g_varchar2
248: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
249: ,p_category in varchar2 default hr_api.g_varchar2
250: ,p_result in varchar2 default hr_api.g_varchar2
251: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
252: ,p_iid_information1 in varchar2 default hr_api.g_varchar2

Line 249: ,p_category in varchar2 default hr_api.g_varchar2

245: ,p_status in varchar2 default hr_api.g_varchar2
246: ,p_feedback in varchar2 default hr_api.g_varchar2
247: ,p_notes in varchar2 default hr_api.g_varchar2
248: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
249: ,p_category in varchar2 default hr_api.g_varchar2
250: ,p_result in varchar2 default hr_api.g_varchar2
251: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
252: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
253: ,p_iid_information2 in varchar2 default hr_api.g_varchar2

Line 250: ,p_result in varchar2 default hr_api.g_varchar2

246: ,p_feedback in varchar2 default hr_api.g_varchar2
247: ,p_notes in varchar2 default hr_api.g_varchar2
248: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
249: ,p_category in varchar2 default hr_api.g_varchar2
250: ,p_result in varchar2 default hr_api.g_varchar2
251: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
252: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
253: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
254: ,p_iid_information3 in varchar2 default hr_api.g_varchar2

Line 251: ,p_iid_information_category in varchar2 default hr_api.g_varchar2

247: ,p_notes in varchar2 default hr_api.g_varchar2
248: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
249: ,p_category in varchar2 default hr_api.g_varchar2
250: ,p_result in varchar2 default hr_api.g_varchar2
251: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
252: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
253: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
254: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
255: ,p_iid_information4 in varchar2 default hr_api.g_varchar2

Line 252: ,p_iid_information1 in varchar2 default hr_api.g_varchar2

248: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
249: ,p_category in varchar2 default hr_api.g_varchar2
250: ,p_result in varchar2 default hr_api.g_varchar2
251: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
252: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
253: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
254: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
255: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
256: ,p_iid_information5 in varchar2 default hr_api.g_varchar2

Line 253: ,p_iid_information2 in varchar2 default hr_api.g_varchar2

249: ,p_category in varchar2 default hr_api.g_varchar2
250: ,p_result in varchar2 default hr_api.g_varchar2
251: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
252: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
253: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
254: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
255: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
256: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
257: ,p_iid_information6 in varchar2 default hr_api.g_varchar2

Line 254: ,p_iid_information3 in varchar2 default hr_api.g_varchar2

250: ,p_result in varchar2 default hr_api.g_varchar2
251: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
252: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
253: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
254: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
255: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
256: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
257: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
258: ,p_iid_information7 in varchar2 default hr_api.g_varchar2

Line 255: ,p_iid_information4 in varchar2 default hr_api.g_varchar2

251: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
252: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
253: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
254: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
255: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
256: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
257: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
258: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
259: ,p_iid_information8 in varchar2 default hr_api.g_varchar2

Line 256: ,p_iid_information5 in varchar2 default hr_api.g_varchar2

252: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
253: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
254: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
255: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
256: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
257: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
258: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
259: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
260: ,p_iid_information9 in varchar2 default hr_api.g_varchar2

Line 257: ,p_iid_information6 in varchar2 default hr_api.g_varchar2

253: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
254: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
255: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
256: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
257: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
258: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
259: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
260: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
261: ,p_iid_information10 in varchar2 default hr_api.g_varchar2

Line 258: ,p_iid_information7 in varchar2 default hr_api.g_varchar2

254: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
255: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
256: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
257: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
258: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
259: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
260: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
261: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
262: ,p_iid_information11 in varchar2 default hr_api.g_varchar2

Line 259: ,p_iid_information8 in varchar2 default hr_api.g_varchar2

255: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
256: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
257: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
258: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
259: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
260: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
261: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
262: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
263: ,p_iid_information12 in varchar2 default hr_api.g_varchar2

Line 260: ,p_iid_information9 in varchar2 default hr_api.g_varchar2

256: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
257: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
258: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
259: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
260: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
261: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
262: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
263: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
264: ,p_iid_information13 in varchar2 default hr_api.g_varchar2

Line 261: ,p_iid_information10 in varchar2 default hr_api.g_varchar2

257: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
258: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
259: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
260: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
261: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
262: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
263: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
264: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
265: ,p_iid_information14 in varchar2 default hr_api.g_varchar2

Line 262: ,p_iid_information11 in varchar2 default hr_api.g_varchar2

258: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
259: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
260: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
261: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
262: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
263: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
264: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
265: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
266: ,p_iid_information15 in varchar2 default hr_api.g_varchar2

Line 263: ,p_iid_information12 in varchar2 default hr_api.g_varchar2

259: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
260: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
261: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
262: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
263: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
264: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
265: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
266: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
267: ,p_iid_information16 in varchar2 default hr_api.g_varchar2

Line 264: ,p_iid_information13 in varchar2 default hr_api.g_varchar2

260: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
261: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
262: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
263: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
264: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
265: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
266: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
267: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
268: ,p_iid_information17 in varchar2 default hr_api.g_varchar2

Line 265: ,p_iid_information14 in varchar2 default hr_api.g_varchar2

261: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
262: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
263: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
264: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
265: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
266: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
267: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
268: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
269: ,p_iid_information18 in varchar2 default hr_api.g_varchar2

Line 266: ,p_iid_information15 in varchar2 default hr_api.g_varchar2

262: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
263: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
264: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
265: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
266: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
267: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
268: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
269: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
270: ,p_iid_information19 in varchar2 default hr_api.g_varchar2

Line 267: ,p_iid_information16 in varchar2 default hr_api.g_varchar2

263: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
264: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
265: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
266: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
267: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
268: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
269: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
270: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
271: ,p_iid_information20 in varchar2 default hr_api.g_varchar2

Line 268: ,p_iid_information17 in varchar2 default hr_api.g_varchar2

264: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
265: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
266: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
267: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
268: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
269: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
270: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
271: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
272: ,p_event_id in number

Line 269: ,p_iid_information18 in varchar2 default hr_api.g_varchar2

265: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
266: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
267: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
268: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
269: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
270: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
271: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
272: ,p_event_id in number
273: ,p_object_version_number in out nocopy number

Line 270: ,p_iid_information19 in varchar2 default hr_api.g_varchar2

266: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
267: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
268: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
269: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
270: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
271: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
272: ,p_event_id in number
273: ,p_object_version_number in out nocopy number
274: ,p_start_date out nocopy date

Line 271: ,p_iid_information20 in varchar2 default hr_api.g_varchar2

267: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
268: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
269: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
270: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
271: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
272: ,p_event_id in number
273: ,p_object_version_number in out nocopy number
274: ,p_start_date out nocopy date
275: ,p_end_date out nocopy date

Line 327: when hr_api.cannot_find_prog_unit then

323: ,p_iid_information20 => p_iid_information20
324: ,p_object_version_number => p_object_version_number
325: );
326: exception
327: when hr_api.cannot_find_prog_unit then
328: hr_api.cannot_find_prog_unit_error
329: (p_module_name => 'update_irc_interview_details'
330: ,p_hook_type => 'BP'
331: );

Line 328: hr_api.cannot_find_prog_unit_error

324: ,p_object_version_number => p_object_version_number
325: );
326: exception
327: when hr_api.cannot_find_prog_unit then
328: hr_api.cannot_find_prog_unit_error
329: (p_module_name => 'update_irc_interview_details'
330: ,p_hook_type => 'BP'
331: );
332: end;

Line 415: when hr_api.cannot_find_prog_unit then

411: ,p_iid_information20 => p_iid_information20
412: ,p_object_version_number => p_object_version_number
413: );
414: exception
415: when hr_api.cannot_find_prog_unit then
416: hr_api.cannot_find_prog_unit_error
417: (p_module_name => 'update_irc_interview_details'
418: ,p_hook_type => 'AP'
419: );

Line 416: hr_api.cannot_find_prog_unit_error

412: ,p_object_version_number => p_object_version_number
413: );
414: exception
415: when hr_api.cannot_find_prog_unit then
416: hr_api.cannot_find_prog_unit_error
417: (p_module_name => 'update_irc_interview_details'
418: ,p_hook_type => 'AP'
419: );
420: end;

Line 425: raise hr_api.validate_enabled;

421: --
422: -- When in validation only mode raise the Validate_Enabled exception
423: --
424: if p_validate then
425: raise hr_api.validate_enabled;
426: end if;
427: --
428: -- Set all IN OUT and OUT parameters with out values
429: --

Line 436: when hr_api.validate_enabled then

432: p_end_date := l_end_date;
433: --
434: hr_utility.set_location(' Leaving:'||l_proc, 70);
435: exception
436: when hr_api.validate_enabled then
437: --
438: -- As the Validate_Enabled exception has been raised
439: -- we must rollback to the savepoint
440: --

Line 640: when hr_api.validate_enabled then

636: --
637: --
638: hr_utility.set_location(' Leaving:'||l_proc, 20);
639: exception
640: when hr_api.validate_enabled then
641: --
642: -- As the Validate_Enabled exception has been raised
643: -- we must rollback to the savepoint
644: --