8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_irc_interview_details >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_irc_interview_details
12: (p_validate in number default hr_api.g_false_num
13: ,p_status in varchar2 default hr_api.g_varchar2
14: ,p_feedback in varchar2 default hr_api.g_varchar2
15: ,p_notes in varchar2 default hr_api.g_varchar2
16: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
9: -- |-------------------------< create_irc_interview_details >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_irc_interview_details
12: (p_validate in number default hr_api.g_false_num
13: ,p_status in varchar2 default hr_api.g_varchar2
14: ,p_feedback in varchar2 default hr_api.g_varchar2
15: ,p_notes in varchar2 default hr_api.g_varchar2
16: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
17: ,p_category in varchar2 default hr_api.g_varchar2
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_irc_interview_details
12: (p_validate in number default hr_api.g_false_num
13: ,p_status in varchar2 default hr_api.g_varchar2
14: ,p_feedback in varchar2 default hr_api.g_varchar2
15: ,p_notes in varchar2 default hr_api.g_varchar2
16: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
17: ,p_category in varchar2 default hr_api.g_varchar2
18: ,p_result in varchar2 default hr_api.g_varchar2
11: PROCEDURE create_irc_interview_details
12: (p_validate in number default hr_api.g_false_num
13: ,p_status in varchar2 default hr_api.g_varchar2
14: ,p_feedback in varchar2 default hr_api.g_varchar2
15: ,p_notes in varchar2 default hr_api.g_varchar2
16: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
17: ,p_category in varchar2 default hr_api.g_varchar2
18: ,p_result in varchar2 default hr_api.g_varchar2
19: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
12: (p_validate in number default hr_api.g_false_num
13: ,p_status in varchar2 default hr_api.g_varchar2
14: ,p_feedback in varchar2 default hr_api.g_varchar2
15: ,p_notes in varchar2 default hr_api.g_varchar2
16: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
17: ,p_category in varchar2 default hr_api.g_varchar2
18: ,p_result in varchar2 default hr_api.g_varchar2
19: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
20: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
13: ,p_status in varchar2 default hr_api.g_varchar2
14: ,p_feedback in varchar2 default hr_api.g_varchar2
15: ,p_notes in varchar2 default hr_api.g_varchar2
16: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
17: ,p_category in varchar2 default hr_api.g_varchar2
18: ,p_result in varchar2 default hr_api.g_varchar2
19: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
20: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
21: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
14: ,p_feedback in varchar2 default hr_api.g_varchar2
15: ,p_notes in varchar2 default hr_api.g_varchar2
16: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
17: ,p_category in varchar2 default hr_api.g_varchar2
18: ,p_result in varchar2 default hr_api.g_varchar2
19: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
20: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
21: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
15: ,p_notes in varchar2 default hr_api.g_varchar2
16: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
17: ,p_category in varchar2 default hr_api.g_varchar2
18: ,p_result in varchar2 default hr_api.g_varchar2
19: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
20: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
21: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
16: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
17: ,p_category in varchar2 default hr_api.g_varchar2
18: ,p_result in varchar2 default hr_api.g_varchar2
19: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
20: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
21: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
17: ,p_category in varchar2 default hr_api.g_varchar2
18: ,p_result in varchar2 default hr_api.g_varchar2
19: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
20: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
21: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
18: ,p_result in varchar2 default hr_api.g_varchar2
19: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
20: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
21: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
19: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
20: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
21: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
20: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
21: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
21: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
22: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
23: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
24: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
25: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
26: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
27: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
28: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
29: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
30: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
31: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
39: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
32: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
33: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
39: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
40: ,p_event_id in number
33: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
34: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
39: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
40: ,p_event_id in number
41: ,p_interview_details_id in number
34: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
35: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
39: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
40: ,p_event_id in number
41: ,p_interview_details_id in number
42: ,p_object_version_number out nocopy number
35: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
36: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
37: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
38: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
39: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
40: ,p_event_id in number
41: ,p_interview_details_id in number
42: ,p_object_version_number out nocopy number
43: ,p_start_date out nocopy date
69: --
70: -- Convert constant values to their corresponding boolean value
71: --
72: l_validate :=
73: hr_api.constant_to_boolean
74: (p_constant_value => p_validate);
75: --
76: -- Register Surrogate ID or user key values
77: --
172: -- ----------------------------------------------------------------------------
173: -- |-------------------------< update_irc_interview_details >--------------------|
174: -- ----------------------------------------------------------------------------
175: PROCEDURE update_irc_interview_details
176: (p_validate in number default hr_api.g_false_num
177: ,p_interview_details_id in number
178: ,p_status in varchar2 default hr_api.g_varchar2
179: ,p_feedback in varchar2 default hr_api.g_varchar2
180: ,p_notes in varchar2 default hr_api.g_varchar2
174: -- ----------------------------------------------------------------------------
175: PROCEDURE update_irc_interview_details
176: (p_validate in number default hr_api.g_false_num
177: ,p_interview_details_id in number
178: ,p_status in varchar2 default hr_api.g_varchar2
179: ,p_feedback in varchar2 default hr_api.g_varchar2
180: ,p_notes in varchar2 default hr_api.g_varchar2
181: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
182: ,p_category in varchar2 default hr_api.g_varchar2
175: PROCEDURE update_irc_interview_details
176: (p_validate in number default hr_api.g_false_num
177: ,p_interview_details_id in number
178: ,p_status in varchar2 default hr_api.g_varchar2
179: ,p_feedback in varchar2 default hr_api.g_varchar2
180: ,p_notes in varchar2 default hr_api.g_varchar2
181: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
182: ,p_category in varchar2 default hr_api.g_varchar2
183: ,p_result in varchar2 default hr_api.g_varchar2
176: (p_validate in number default hr_api.g_false_num
177: ,p_interview_details_id in number
178: ,p_status in varchar2 default hr_api.g_varchar2
179: ,p_feedback in varchar2 default hr_api.g_varchar2
180: ,p_notes in varchar2 default hr_api.g_varchar2
181: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
182: ,p_category in varchar2 default hr_api.g_varchar2
183: ,p_result in varchar2 default hr_api.g_varchar2
184: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
177: ,p_interview_details_id in number
178: ,p_status in varchar2 default hr_api.g_varchar2
179: ,p_feedback in varchar2 default hr_api.g_varchar2
180: ,p_notes in varchar2 default hr_api.g_varchar2
181: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
182: ,p_category in varchar2 default hr_api.g_varchar2
183: ,p_result in varchar2 default hr_api.g_varchar2
184: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
185: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
178: ,p_status in varchar2 default hr_api.g_varchar2
179: ,p_feedback in varchar2 default hr_api.g_varchar2
180: ,p_notes in varchar2 default hr_api.g_varchar2
181: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
182: ,p_category in varchar2 default hr_api.g_varchar2
183: ,p_result in varchar2 default hr_api.g_varchar2
184: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
185: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
186: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
179: ,p_feedback in varchar2 default hr_api.g_varchar2
180: ,p_notes in varchar2 default hr_api.g_varchar2
181: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
182: ,p_category in varchar2 default hr_api.g_varchar2
183: ,p_result in varchar2 default hr_api.g_varchar2
184: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
185: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
186: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
187: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
180: ,p_notes in varchar2 default hr_api.g_varchar2
181: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
182: ,p_category in varchar2 default hr_api.g_varchar2
183: ,p_result in varchar2 default hr_api.g_varchar2
184: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
185: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
186: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
187: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
188: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
181: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
182: ,p_category in varchar2 default hr_api.g_varchar2
183: ,p_result in varchar2 default hr_api.g_varchar2
184: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
185: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
186: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
187: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
188: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
189: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
182: ,p_category in varchar2 default hr_api.g_varchar2
183: ,p_result in varchar2 default hr_api.g_varchar2
184: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
185: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
186: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
187: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
188: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
189: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
190: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
183: ,p_result in varchar2 default hr_api.g_varchar2
184: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
185: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
186: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
187: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
188: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
189: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
190: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
191: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
184: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
185: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
186: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
187: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
188: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
189: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
190: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
191: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
192: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
185: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
186: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
187: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
188: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
189: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
190: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
191: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
192: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
193: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
186: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
187: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
188: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
189: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
190: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
191: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
192: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
193: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
194: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
187: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
188: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
189: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
190: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
191: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
192: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
193: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
194: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
195: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
188: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
189: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
190: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
191: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
192: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
193: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
194: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
195: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
196: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
189: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
190: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
191: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
192: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
193: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
194: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
195: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
196: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
197: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
190: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
191: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
192: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
193: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
194: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
195: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
196: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
197: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
198: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
191: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
192: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
193: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
194: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
195: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
196: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
197: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
198: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
199: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
192: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
193: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
194: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
195: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
196: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
197: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
198: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
199: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
200: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
193: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
194: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
195: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
196: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
197: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
198: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
199: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
200: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
201: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
194: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
195: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
196: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
197: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
198: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
199: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
200: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
201: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
202: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
195: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
196: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
197: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
198: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
199: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
200: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
201: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
202: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
203: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
196: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
197: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
198: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
199: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
200: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
201: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
202: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
203: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
204: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
197: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
198: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
199: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
200: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
201: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
202: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
203: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
204: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
205: ,p_event_id in number
198: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
199: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
200: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
201: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
202: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
203: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
204: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
205: ,p_event_id in number
206: ,p_object_version_number in out nocopy number
199: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
200: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
201: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
202: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
203: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
204: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
205: ,p_event_id in number
206: ,p_object_version_number in out nocopy number
207: ,p_start_date out nocopy date
200: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
201: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
202: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
203: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
204: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
205: ,p_event_id in number
206: ,p_object_version_number in out nocopy number
207: ,p_start_date out nocopy date
208: ,p_end_date out nocopy date
234: --
235: -- Convert constant values to their corresponding boolean value
236: --
237: l_validate :=
238: hr_api.constant_to_boolean
239: (p_constant_value => p_validate);
240: --
241: -- Register Surrogate ID or user key values
242: --