DBA Data[Home] [Help]

APPS.IRC_INTERVIEW_DETAILS_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

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

Line 13: ,p_status 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

Line 14: ,p_feedback 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

Line 15: ,p_notes 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

Line 16: ,p_notes_to_candidate 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

Line 17: ,p_category 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

Line 18: ,p_result 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

Line 19: ,p_iid_information_category 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

Line 20: ,p_iid_information1 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

Line 21: ,p_iid_information2 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

Line 22: ,p_iid_information3 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

Line 23: ,p_iid_information4 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

Line 24: ,p_iid_information5 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

Line 25: ,p_iid_information6 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

Line 26: ,p_iid_information7 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

Line 27: ,p_iid_information8 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

Line 28: ,p_iid_information9 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

Line 29: ,p_iid_information10 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

Line 30: ,p_iid_information11 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

Line 31: ,p_iid_information12 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

Line 32: ,p_iid_information13 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

Line 33: ,p_iid_information14 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

Line 34: ,p_iid_information15 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

Line 35: ,p_iid_information16 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

Line 36: ,p_iid_information17 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

Line 37: ,p_iid_information18 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
41: ,p_interview_details_id in number

Line 38: ,p_iid_information19 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
42: ,p_object_version_number out nocopy number

Line 39: ,p_iid_information20 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
43: ,p_start_date out nocopy date

Line 73: hr_api.constant_to_boolean

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

Line 176: (p_validate in number default hr_api.g_false_num

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

Line 178: ,p_status 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

Line 179: ,p_feedback 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

Line 180: ,p_notes 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

Line 181: ,p_notes_to_candidate 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

Line 182: ,p_category 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

Line 183: ,p_result 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

Line 184: ,p_iid_information_category 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

Line 185: ,p_iid_information1 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

Line 186: ,p_iid_information2 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

Line 187: ,p_iid_information3 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

Line 188: ,p_iid_information4 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

Line 189: ,p_iid_information5 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

Line 190: ,p_iid_information6 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

Line 191: ,p_iid_information7 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

Line 192: ,p_iid_information8 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

Line 193: ,p_iid_information9 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

Line 194: ,p_iid_information10 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

Line 195: ,p_iid_information11 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

Line 196: ,p_iid_information12 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

Line 197: ,p_iid_information13 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

Line 198: ,p_iid_information14 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

Line 199: ,p_iid_information15 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

Line 200: ,p_iid_information16 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

Line 201: ,p_iid_information17 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

Line 202: ,p_iid_information18 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
206: ,p_object_version_number in out nocopy number

Line 203: ,p_iid_information19 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
207: ,p_start_date out nocopy date

Line 204: ,p_iid_information20 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
208: ,p_end_date out nocopy date

Line 238: hr_api.constant_to_boolean

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