[Home] [Help]
PACKAGE BODY: APPS.IRC_INTERVIEW_DETAILS_API
Source
1 PACKAGE BODY IRC_INTERVIEW_DETAILS_API as
2 /* $Header: iriidapi.pkb 120.0 2007/12/10 09:17:54 mkjayara noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' irc_interview_details_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-------------------------< create_irc_interview_details >--------------------|
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
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
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
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
45 ,p_end_date out nocopy date
46 ) is
47 --
48 -- Declare cursors and local variables
49 --
50 l_proc varchar2(72) := g_package||'create_irc_interview_details';
51 l_interview_details_id number;
52 l_object_version_number number;
53 l_start_date date;
54 l_end_date date;
55 l_swi_package_name varchar2(30) := 'IRC_INTERVIEW_DETAILS_SWI';
56 l_effective_date date;
57 begin
58 hr_utility.set_location('Entering:'|| l_proc, 10);
59 --
60 -- Issue a savepoint
61 --
62 savepoint create_irc_interview_details;
63 --
64 -- Call Before Process User Hook
65 --
66 begin
67 irc_interview_details_bk1.create_irc_interview_details_b
68 (p_status => p_status
69 ,p_feedback => p_feedback
70 ,p_notes => p_notes
71 ,p_notes_to_candidate => p_notes_to_candidate
72 ,p_category => p_category
73 ,p_result => p_result
74 ,p_iid_information_category => p_iid_information_category
75 ,p_iid_information1 => p_iid_information1
76 ,p_iid_information2 => p_iid_information2
77 ,p_iid_information3 => p_iid_information3
78 ,p_iid_information4 => p_iid_information4
79 ,p_iid_information5 => p_iid_information5
80 ,p_iid_information6 => p_iid_information6
81 ,p_iid_information7 => p_iid_information7
82 ,p_iid_information8 => p_iid_information8
83 ,p_iid_information9 => p_iid_information9
84 ,p_iid_information10 => p_iid_information10
85 ,p_iid_information11 => p_iid_information11
86 ,p_iid_information12 => p_iid_information12
87 ,p_iid_information13 => p_iid_information13
88 ,p_iid_information14 => p_iid_information14
89 ,p_iid_information15 => p_iid_information15
90 ,p_iid_information16 => p_iid_information16
91 ,p_iid_information17 => p_iid_information17
92 ,p_iid_information18 => p_iid_information18
93 ,p_iid_information19 => p_iid_information19
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 );
103 end;
104 --
105 -- Process Logic
106 --
107 -- Set the effective date to the sysdate
108 l_effective_date := sysdate;
109
110 irc_iid_ins.ins(p_effective_date => l_effective_date
111 ,p_status => p_status
112 ,p_feedback => p_feedback
113 ,p_notes => p_notes
114 ,p_notes_to_candidate => p_notes_to_candidate
115 ,p_category => p_category
116 ,p_result => p_result
117 ,p_iid_information_category => p_iid_information_category
118 ,p_iid_information1 => p_iid_information1
119 ,p_iid_information2 => p_iid_information2
120 ,p_iid_information3 => p_iid_information3
121 ,p_iid_information4 => p_iid_information4
122 ,p_iid_information5 => p_iid_information5
123 ,p_iid_information6 => p_iid_information6
124 ,p_iid_information7 => p_iid_information7
125 ,p_iid_information8 => p_iid_information8
126 ,p_iid_information9 => p_iid_information9
127 ,p_iid_information10 => p_iid_information10
128 ,p_iid_information11 => p_iid_information11
129 ,p_iid_information12 => p_iid_information12
130 ,p_iid_information13 => p_iid_information13
131 ,p_iid_information14 => p_iid_information14
132 ,p_iid_information15 => p_iid_information15
133 ,p_iid_information16 => p_iid_information16
134 ,p_iid_information17 => p_iid_information17
135 ,p_iid_information18 => p_iid_information18
136 ,p_iid_information19 => p_iid_information19
137 ,p_iid_information20 => p_iid_information20
138 ,p_event_id => p_event_id
139 ,p_interview_details_id => l_interview_details_id
140 ,p_object_version_number => l_object_version_number
141 ,p_start_date => l_start_date
142 ,p_end_date => l_end_date
143 );
144 -- Call After Process User Hook
145 --
146 begin
147 irc_interview_details_bk1.create_irc_interview_details_a
148 (p_interview_details_id => l_interview_details_id
149 ,p_status => p_status
150 ,p_feedback => p_feedback
151 ,p_notes => p_notes
152 ,p_notes_to_candidate => p_notes_to_candidate
153 ,p_category => p_category
154 ,p_result => p_result
155 ,p_iid_information_category => p_iid_information_category
156 ,p_iid_information1 => p_iid_information1
157 ,p_iid_information2 => p_iid_information2
158 ,p_iid_information3 => p_iid_information3
159 ,p_iid_information4 => p_iid_information4
160 ,p_iid_information5 => p_iid_information5
161 ,p_iid_information6 => p_iid_information6
162 ,p_iid_information7 => p_iid_information7
163 ,p_iid_information8 => p_iid_information8
164 ,p_iid_information9 => p_iid_information9
165 ,p_iid_information10 => p_iid_information10
166 ,p_iid_information11 => p_iid_information11
167 ,p_iid_information12 => p_iid_information12
168 ,p_iid_information13 => p_iid_information13
169 ,p_iid_information14 => p_iid_information14
170 ,p_iid_information15 => p_iid_information15
171 ,p_iid_information16 => p_iid_information16
172 ,p_iid_information17 => p_iid_information17
173 ,p_iid_information18 => p_iid_information18
174 ,p_iid_information19 => p_iid_information19
175 ,p_iid_information20 => p_iid_information20
176 ,p_event_id => p_event_id
177 ,p_object_version_number => l_object_version_number
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 );
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 --
197 p_interview_details_id := l_interview_details_id;
198 p_object_version_number := l_object_version_number;
199 p_start_date := l_start_date;
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 --
209 rollback to create_irc_interview_details;
210 --
211 -- Reset IN OUT parameters and set OUT parameters
212 -- (Any key or derived arguments must be set to null
213 -- when validation only mode is being used.)
214 --
215 p_interview_details_id := null;
216 p_object_version_number := null;
217 p_start_date := null;
218 p_end_date := null;
219 hr_utility.set_location(' Leaving:'||l_proc, 80);
220 when others then
221 --
222 -- A validation or unexpected error has occured
223 --
224 rollback to create_irc_interview_details;
225 --
226 -- Reset IN OUT parameters and set all
227 -- OUT parameters, including warnings, to null
228 --
229 p_interview_details_id := null;
230 p_object_version_number := null;
231 p_start_date := null;
232 p_end_date := null;
233 hr_utility.set_location(' Leaving:'||l_proc, 90);
234 raise;
235 end create_irc_interview_details;
236 --
237 --
238 -- ----------------------------------------------------------------------------
239 -- |-----------------------< update_irc_interview_details >----------------------|
240 -- ----------------------------------------------------------------------------
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
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
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
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
276 ) is
277 --
278 -- Declare cursors and local variables
279 --
280 l_object_version_number number;
281 l_start_date date;
282 l_end_date date;
283 l_effective_date date;
284 l_proc varchar2(72) := g_package||'update_irc_interview_details';
285 begin
286 hr_utility.set_location('Entering:'|| l_proc, 10);
287 --
288 -- Issue a savepoint
289 --
290 savepoint update_irc_interview_details;
291 --
292 -- Call Before Process User Hook
293 --
294 begin
295 irc_interview_details_bk2.update_irc_interview_details_b
296 (p_interview_details_id => p_interview_details_id
297 ,p_status => p_status
298 ,p_feedback => p_feedback
299 ,p_notes => p_notes
300 ,p_notes_to_candidate => p_notes_to_candidate
301 ,p_category => p_category
302 ,p_result => p_result
303 ,p_iid_information_category => p_iid_information_category
304 ,p_iid_information1 => p_iid_information1
305 ,p_iid_information2 => p_iid_information2
306 ,p_iid_information3 => p_iid_information3
307 ,p_iid_information4 => p_iid_information4
308 ,p_iid_information5 => p_iid_information5
309 ,p_iid_information6 => p_iid_information6
310 ,p_iid_information7 => p_iid_information7
311 ,p_iid_information8 => p_iid_information8
312 ,p_iid_information9 => p_iid_information9
313 ,p_iid_information10 => p_iid_information10
314 ,p_iid_information11 => p_iid_information11
315 ,p_iid_information12 => p_iid_information12
316 ,p_iid_information13 => p_iid_information13
317 ,p_iid_information14 => p_iid_information14
318 ,p_iid_information15 => p_iid_information15
319 ,p_iid_information16 => p_iid_information16
320 ,p_iid_information17 => p_iid_information17
321 ,p_iid_information18 => p_iid_information18
322 ,p_iid_information19 => p_iid_information19
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 );
332 end;
333 --
334 -- Process Logic
335 --
336 -- Set the effective date to the sysdate
337 l_effective_date := sysdate;
338 l_object_version_number := p_object_version_number;
339 if p_interview_details_id is null then
340 -- RAISE ERROR SAYING INVALID INTERVIEW_DETAILS_ID
341 fnd_message.set_name('PER', 'IRC_INV_INT_DET_ID');
342 fnd_message.raise_error;
343 end if;
344 irc_iid_upd.upd(p_effective_date => l_effective_date
345 ,p_datetrack_mode => 'UPDATE'
346 ,p_interview_details_id => p_interview_details_id
347 ,p_object_version_number => l_object_version_number
348 ,p_status => p_status
349 ,p_feedback => p_feedback
350 ,p_notes => p_notes
351 ,p_notes_to_candidate => p_notes_to_candidate
352 ,p_category => p_category
353 ,p_result => p_result
354 ,p_iid_information_category => p_iid_information_category
355 ,p_iid_information1 => p_iid_information1
356 ,p_iid_information2 => p_iid_information2
357 ,p_iid_information3 => p_iid_information3
358 ,p_iid_information4 => p_iid_information4
359 ,p_iid_information5 => p_iid_information5
360 ,p_iid_information6 => p_iid_information6
361 ,p_iid_information7 => p_iid_information7
362 ,p_iid_information8 => p_iid_information8
363 ,p_iid_information9 => p_iid_information9
364 ,p_iid_information10 => p_iid_information10
365 ,p_iid_information11 => p_iid_information11
366 ,p_iid_information12 => p_iid_information12
367 ,p_iid_information13 => p_iid_information13
368 ,p_iid_information14 => p_iid_information14
369 ,p_iid_information15 => p_iid_information15
370 ,p_iid_information16 => p_iid_information16
371 ,p_iid_information17 => p_iid_information17
372 ,p_iid_information18 => p_iid_information18
373 ,p_iid_information19 => p_iid_information19
374 ,p_iid_information20 => p_iid_information20
375 ,p_event_id => p_event_id
376 ,p_start_date => l_start_date
377 ,p_end_date => l_end_date
378 );
379 --
380 -- Call After Process User Hook
381 --
382 begin
383 irc_interview_details_bk2.update_irc_interview_details_a
384 (p_interview_details_id => p_interview_details_id
385 ,p_status => p_status
386 ,p_feedback => p_feedback
387 ,p_notes => p_notes
388 ,p_notes_to_candidate => p_notes_to_candidate
389 ,p_category => p_category
390 ,p_result => p_result
391 ,p_iid_information_category => p_iid_information_category
392 ,p_iid_information1 => p_iid_information1
393 ,p_iid_information2 => p_iid_information2
394 ,p_iid_information3 => p_iid_information3
395 ,p_iid_information4 => p_iid_information4
396 ,p_iid_information5 => p_iid_information5
397 ,p_iid_information6 => p_iid_information6
398 ,p_iid_information7 => p_iid_information7
399 ,p_iid_information8 => p_iid_information8
400 ,p_iid_information9 => p_iid_information9
401 ,p_iid_information10 => p_iid_information10
402 ,p_iid_information11 => p_iid_information11
403 ,p_iid_information12 => p_iid_information12
404 ,p_iid_information13 => p_iid_information13
405 ,p_iid_information14 => p_iid_information14
406 ,p_iid_information15 => p_iid_information15
407 ,p_iid_information16 => p_iid_information16
408 ,p_iid_information17 => p_iid_information17
409 ,p_iid_information18 => p_iid_information18
410 ,p_iid_information19 => p_iid_information19
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 );
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 --
430 p_object_version_number := l_object_version_number;
431 p_start_date := l_start_date;
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 --
441 rollback to update_irc_interview_details;
442 --
443 -- Reset IN OUT parameters and set OUT parameters
444 -- (Any key or derived arguments must be set to null
445 -- when validation only mode is being used.)
446 --
447 p_start_date := null;
448 p_end_date := null;
449 hr_utility.set_location(' Leaving:'||l_proc, 80);
450 when others then
451 --
452 -- A validation or unexpected error has occured
453 --
454 rollback to update_irc_interview_details;
455 --
456 -- Reset IN OUT parameters and set all
457 -- OUT parameters, including warnings, to null
458 --
459 p_start_date := null;
460 p_end_date := null;
461 hr_utility.set_location(' Leaving:'||l_proc, 90);
462 raise;
463 end update_irc_interview_details;
464 --
465 end irc_interview_details_api;