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