[Home] [Help]
PACKAGE BODY: APPS.HR_ELC_CANDIDATE_API
Source
1 Package Body hr_elc_candidate_api as
2 /* $Header: peecaapi.pkb 115.4 2002/12/10 16:46:24 pkakar noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hr_elc_candidate_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |--------------------------< create_election_candidate >--------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_election_candidate
13 (p_validate in boolean default false
14 ,p_business_group_id in number
15 ,p_person_id in number
16 ,p_election_id in number
17 ,p_rank in number
18 ,p_role_id in number
19 ,p_attribute_category in varchar2 default null
20 ,p_attribute1 in varchar2 default null
21 ,p_attribute2 in varchar2 default null
22 ,p_attribute3 in varchar2 default null
23 ,p_attribute4 in varchar2 default null
24 ,p_attribute5 in varchar2 default null
25 ,p_attribute6 in varchar2 default null
26 ,p_attribute7 in varchar2 default null
27 ,p_attribute8 in varchar2 default null
28 ,p_attribute9 in varchar2 default null
29 ,p_attribute10 in varchar2 default null
30 ,p_attribute11 in varchar2 default null
31 ,p_attribute12 in varchar2 default null
32 ,p_attribute13 in varchar2 default null
33 ,p_attribute14 in varchar2 default null
34 ,p_attribute15 in varchar2 default null
35 ,p_attribute16 in varchar2 default null
36 ,p_attribute17 in varchar2 default null
37 ,p_attribute18 in varchar2 default null
38 ,p_attribute19 in varchar2 default null
39 ,p_attribute20 in varchar2 default null
40 ,p_attribute21 in varchar2 default null
41 ,p_attribute22 in varchar2 default null
42 ,p_attribute23 in varchar2 default null
43 ,p_attribute24 in varchar2 default null
44 ,p_attribute25 in varchar2 default null
45 ,p_attribute26 in varchar2 default null
46 ,p_attribute27 in varchar2 default null
47 ,p_attribute28 in varchar2 default null
48 ,p_attribute29 in varchar2 default null
49 ,p_attribute30 in varchar2 default null
50 ,p_candidate_info_category in varchar2 default null
51 ,p_candidate_information1 in varchar2 default null
52 ,p_candidate_information2 in varchar2 default null
53 ,p_candidate_information3 in varchar2 default null
54 ,p_candidate_information4 in varchar2 default null
55 ,p_candidate_information5 in varchar2 default null
56 ,p_candidate_information6 in varchar2 default null
57 ,p_candidate_information7 in varchar2 default null
58 ,p_candidate_information8 in varchar2 default null
59 ,p_candidate_information9 in varchar2 default null
60 ,p_candidate_information10 in varchar2 default null
61 ,p_candidate_information11 in varchar2 default null
62 ,p_candidate_information12 in varchar2 default null
63 ,p_candidate_information13 in varchar2 default null
64 ,p_candidate_information14 in varchar2 default null
65 ,p_candidate_information15 in varchar2 default null
66 ,p_candidate_information16 in varchar2 default null
67 ,p_candidate_information17 in varchar2 default null
68 ,p_candidate_information18 in varchar2 default null
69 ,p_candidate_information19 in varchar2 default null
70 ,p_candidate_information20 in varchar2 default null
71 ,p_candidate_information21 in varchar2 default null
72 ,p_candidate_information22 in varchar2 default null
73 ,p_candidate_information23 in varchar2 default null
74 ,p_candidate_information24 in varchar2 default null
75 ,p_candidate_information25 in varchar2 default null
76 ,p_candidate_information26 in varchar2 default null
77 ,p_candidate_information27 in varchar2 default null
78 ,p_candidate_information28 in varchar2 default null
79 ,p_candidate_information29 in varchar2 default null
80 ,p_candidate_information30 in varchar2 default null
81 ,p_election_candidate_id out nocopy number
82 ,p_object_version_number out nocopy number
83 ) is
84 --
85 -- Declare cursors and local variables
86 --
87
88 l_proc varchar2(72) := g_package||'create_election_candidate';
89 l_election_candidate_id per_election_candidates.election_candidate_id%TYPE;
90 l_object_version_number per_election_candidates.object_version_number%TYPE;
91 begin
92 hr_utility.set_location('Entering:'|| l_proc, 10);
93 --
94 -- Issue a savepoint
95 --
96 savepoint create_election_candidate;
97 --
98 -- Truncate the time portion from all IN date parameters
99 --
100
101 --
102 -- Call Before Process User Hook
103 --
104 begin
105 hr_elc_candidate_api_bk1.create_election_candidate_b
106 (p_business_group_id => p_business_group_id
107 ,p_person_id => p_person_id
108 ,p_election_id => p_election_id
109 ,p_rank => p_rank
110 ,p_role_id => p_role_id
111 ,p_attribute_category => p_attribute_category
112 ,p_attribute1 => p_attribute1
113 ,p_attribute2 => p_attribute2
114 ,p_attribute3 => p_attribute3
115 ,p_attribute4 => p_attribute4
116 ,p_attribute5 => p_attribute5
117 ,p_attribute6 => p_attribute6
118 ,p_attribute7 => p_attribute7
119 ,p_attribute8 => p_attribute8
120 ,p_attribute9 => p_attribute9
121 ,p_attribute10 => p_attribute10
122 ,p_attribute11 => p_attribute11
123 ,p_attribute12 => p_attribute12
124 ,p_attribute13 => p_attribute13
125 ,p_attribute14 => p_attribute14
126 ,p_attribute15 => p_attribute15
127 ,p_attribute16 => p_attribute16
128 ,p_attribute17 => p_attribute17
129 ,p_attribute18 => p_attribute18
130 ,p_attribute19 => p_attribute19
131 ,p_attribute20 => p_attribute20
132 ,p_attribute21 => p_attribute21
133 ,p_attribute22 => p_attribute22
134 ,p_attribute23 => p_attribute23
135 ,p_attribute24 => p_attribute24
136 ,p_attribute25 => p_attribute25
137 ,p_attribute26 => p_attribute26
138 ,p_attribute27 => p_attribute27
139 ,p_attribute28 => p_attribute28
140 ,p_attribute29 => p_attribute29
141 ,p_attribute30 => p_attribute30
142 ,p_candidate_info_category => p_candidate_info_category
143 ,p_candidate_information1 => p_candidate_information1
144 ,p_candidate_information2 => p_candidate_information2
145 ,p_candidate_information3 => p_candidate_information3
146 ,p_candidate_information4 => p_candidate_information4
147 ,p_candidate_information5 => p_candidate_information5
148 ,p_candidate_information6 => p_candidate_information6
149 ,p_candidate_information7 => p_candidate_information7
150 ,p_candidate_information8 => p_candidate_information8
151 ,p_candidate_information9 => p_candidate_information9
152 ,p_candidate_information10 => p_candidate_information10
153 ,p_candidate_information11 => p_candidate_information11
154 ,p_candidate_information12 => p_candidate_information12
155 ,p_candidate_information13 => p_candidate_information13
156 ,p_candidate_information14 => p_candidate_information14
157 ,p_candidate_information15 => p_candidate_information15
158 ,p_candidate_information16 => p_candidate_information16
159 ,p_candidate_information17 => p_candidate_information17
160 ,p_candidate_information18 => p_candidate_information18
161 ,p_candidate_information19 => p_candidate_information19
162 ,p_candidate_information20 => p_candidate_information20
163 ,p_candidate_information21 => p_candidate_information21
164 ,p_candidate_information22 => p_candidate_information22
165 ,p_candidate_information23 => p_candidate_information23
166 ,p_candidate_information24 => p_candidate_information24
167 ,p_candidate_information25 => p_candidate_information25
168 ,p_candidate_information26 => p_candidate_information26
169 ,p_candidate_information27 => p_candidate_information27
170 ,p_candidate_information28 => p_candidate_information28
171 ,p_candidate_information29 => p_candidate_information29
172 ,p_candidate_information30 => p_candidate_information30);
173 exception
174 when hr_api.cannot_find_prog_unit then
175 hr_api.cannot_find_prog_unit_error
176 (p_module_name => 'create_election_candidate_b'
177 ,p_hook_type => 'BP'
178 );
179 end;
180 --
181 -- Validation in addition to Row Handlers
182 --
183
184 --
185 -- Process Logic
186 --
187 per_eca_ins.ins
188 (p_business_group_id => p_business_group_id
189 ,p_election_id => p_election_id
190 ,p_person_id => p_person_id
191 ,p_rank => p_rank
192 ,p_role_id => p_role_id
193 ,p_attribute_category => p_attribute_category
194 ,p_attribute1 => p_attribute1
195 ,p_attribute2 => p_attribute2
196 ,p_attribute3 => p_attribute3
197 ,p_attribute4 => p_attribute4
198 ,p_attribute5 => p_attribute5
199 ,p_attribute6 => p_attribute6
200 ,p_attribute7 => p_attribute7
201 ,p_attribute8 => p_attribute8
202 ,p_attribute9 => p_attribute9
203 ,p_attribute10 => p_attribute10
204 ,p_attribute11 => p_attribute11
205 ,p_attribute12 => p_attribute12
206 ,p_attribute13 => p_attribute13
207 ,p_attribute14 => p_attribute14
208 ,p_attribute15 => p_attribute15
209 ,p_attribute16 => p_attribute16
210 ,p_attribute17 => p_attribute17
211 ,p_attribute18 => p_attribute18
212 ,p_attribute19 => p_attribute19
213 ,p_attribute20 => p_attribute20
214 ,p_attribute21 => p_attribute21
215 ,p_attribute22 => p_attribute22
216 ,p_attribute23 => p_attribute23
217 ,p_attribute24 => p_attribute24
218 ,p_attribute25 => p_attribute25
219 ,p_attribute26 => p_attribute26
220 ,p_attribute27 => p_attribute27
221 ,p_attribute28 => p_attribute28
222 ,p_attribute29 => p_attribute29
223 ,p_attribute30 => p_attribute30
224 ,p_candidate_info_category => p_candidate_info_category
225 ,p_candidate_information1 => p_candidate_information1
226 ,p_candidate_information2 => p_candidate_information2
227 ,p_candidate_information3 => p_candidate_information3
228 ,p_candidate_information4 => p_candidate_information4
229 ,p_candidate_information5 => p_candidate_information5
230 ,p_candidate_information6 => p_candidate_information6
231 ,p_candidate_information7 => p_candidate_information7
232 ,p_candidate_information8 => p_candidate_information8
233 ,p_candidate_information9 => p_candidate_information9
234 ,p_candidate_information10 => p_candidate_information10
235 ,p_candidate_information11 => p_candidate_information11
236 ,p_candidate_information12 => p_candidate_information12
237 ,p_candidate_information13 => p_candidate_information13
238 ,p_candidate_information14 => p_candidate_information14
239 ,p_candidate_information15 => p_candidate_information15
240 ,p_candidate_information16 => p_candidate_information16
241 ,p_candidate_information17 => p_candidate_information17
242 ,p_candidate_information18 => p_candidate_information18
243 ,p_candidate_information19 => p_candidate_information19
244 ,p_candidate_information20 => p_candidate_information20
245 ,p_candidate_information21 => p_candidate_information21
246 ,p_candidate_information22 => p_candidate_information22
247 ,p_candidate_information23 => p_candidate_information23
248 ,p_candidate_information24 => p_candidate_information24
249 ,p_candidate_information25 => p_candidate_information25
250 ,p_candidate_information26 => p_candidate_information26
251 ,p_candidate_information27 => p_candidate_information27
252 ,p_candidate_information28 => p_candidate_information28
253 ,p_candidate_information29 => p_candidate_information29
254 ,p_candidate_information30 => p_candidate_information30
255 ,p_election_candidate_id => l_election_candidate_id
256 ,p_object_version_number => l_object_version_number);
257
258
259
260 --
261 -- Call After Process User Hook
262 --
263 begin
264 hr_elc_candidate_api_bk1.create_election_candidate_a
265 (p_business_group_id => p_business_group_id
266 ,p_election_id => p_election_id
267 ,p_person_id => p_person_id
268 ,p_rank => p_rank
269 ,p_role_id => p_role_id
270 ,p_attribute_category => p_attribute_category
271 ,p_attribute1 => p_attribute1
272 ,p_attribute2 => p_attribute2
273 ,p_attribute3 => p_attribute3
274 ,p_attribute4 => p_attribute4
275 ,p_attribute5 => p_attribute5
276 ,p_attribute6 => p_attribute6
277 ,p_attribute7 => p_attribute7
278 ,p_attribute8 => p_attribute8
279 ,p_attribute9 => p_attribute9
280 ,p_attribute10 => p_attribute10
281 ,p_attribute11 => p_attribute11
282 ,p_attribute12 => p_attribute12
283 ,p_attribute13 => p_attribute13
284 ,p_attribute14 => p_attribute14
285 ,p_attribute15 => p_attribute15
286 ,p_attribute16 => p_attribute16
287 ,p_attribute17 => p_attribute17
288 ,p_attribute18 => p_attribute18
289 ,p_attribute19 => p_attribute19
290 ,p_attribute20 => p_attribute20
291 ,p_attribute21 => p_attribute21
292 ,p_attribute22 => p_attribute22
293 ,p_attribute23 => p_attribute23
294 ,p_attribute24 => p_attribute24
295 ,p_attribute25 => p_attribute25
296 ,p_attribute26 => p_attribute26
297 ,p_attribute27 => p_attribute27
298 ,p_attribute28 => p_attribute28
299 ,p_attribute29 => p_attribute29
300 ,p_attribute30 => p_attribute30
301 ,p_candidate_info_category => p_candidate_info_category
302 ,p_candidate_information1 => p_candidate_information1
303 ,p_candidate_information2 => p_candidate_information2
304 ,p_candidate_information3 => p_candidate_information3
305 ,p_candidate_information4 => p_candidate_information4
306 ,p_candidate_information5 => p_candidate_information5
307 ,p_candidate_information6 => p_candidate_information6
308 ,p_candidate_information7 => p_candidate_information7
309 ,p_candidate_information8 => p_candidate_information8
310 ,p_candidate_information9 => p_candidate_information9
311 ,p_candidate_information10 => p_candidate_information10
312 ,p_candidate_information11 => p_candidate_information11
313 ,p_candidate_information12 => p_candidate_information12
314 ,p_candidate_information13 => p_candidate_information13
315 ,p_candidate_information14 => p_candidate_information14
316 ,p_candidate_information15 => p_candidate_information15
317 ,p_candidate_information16 => p_candidate_information16
318 ,p_candidate_information17 => p_candidate_information17
319 ,p_candidate_information18 => p_candidate_information18
320 ,p_candidate_information19 => p_candidate_information19
321 ,p_candidate_information20 => p_candidate_information20
322 ,p_candidate_information21 => p_candidate_information21
323 ,p_candidate_information22 => p_candidate_information22
324 ,p_candidate_information23 => p_candidate_information23
325 ,p_candidate_information24 => p_candidate_information24
326 ,p_candidate_information25 => p_candidate_information25
327 ,p_candidate_information26 => p_candidate_information26
328 ,p_candidate_information27 => p_candidate_information27
329 ,p_candidate_information28 => p_candidate_information28
330 ,p_candidate_information29 => p_candidate_information29
331 ,p_candidate_information30 => p_candidate_information30
332 ,p_election_candidate_id => l_election_candidate_id
333 ,p_object_version_number => l_object_version_number);
334
335
336 exception
337 when hr_api.cannot_find_prog_unit then
338 hr_api.cannot_find_prog_unit_error
339 (p_module_name => 'create_election_candidate_a'
340 ,p_hook_type => 'AP'
341 );
342 end;
343 --
344 -- When in validation only mode raise the Validate_Enabled exception
345 --
346 if p_validate then
347 raise hr_api.validate_enabled;
348 end if;
349 --
350 -- Set all output arguments
351 --
352 p_election_candidate_id := l_election_candidate_id;
353 p_object_version_number := l_object_version_number;
354 --
355 hr_utility.set_location(' Leaving:'||l_proc, 70);
356 exception
357 when hr_api.validate_enabled then
358 --
359 -- As the Validate_Enabled exception has been raised
360 -- we must rollback to the savepoint
361 --
362 rollback to create_election_candidate;
363 --
364 -- Only set output warning arguments
365 -- (Any key or derived arguments must be set to null
366 -- when validation only mode is being used.)
367 --
368 p_election_candidate_id := null;
369 p_object_version_number := null;
370 hr_utility.set_location(' Leaving:'||l_proc, 80);
371 when others then
372 --
373 -- A validation or unexpected error has occured
374 --
375 rollback to create_election_candidate;
376 --
377 -- set in out parameters and set out parameters
378 --
379 p_election_candidate_id := null;
380 p_object_version_number := null;
381 --
382 hr_utility.set_location(' Leaving:'||l_proc, 90);
383 raise;
384 end create_election_candidate;
385 --
386
387 --
388 -- ----------------------------------------------------------------------------
389 -- |--------------------------< update_election_candidate >--------------------------|
390 -- ----------------------------------------------------------------------------
391 --
392 procedure update_election_candidate
393 (p_validate in boolean default false
394 ,p_election_candidate_id in number
395 ,p_object_version_number in out nocopy number
396 ,p_business_group_id in number default hr_api.g_number
397 ,p_person_id in number default hr_api.g_number
398 ,p_election_id in number default hr_api.g_number
399 ,p_rank in number default hr_api.g_number
400 ,p_role_id in number default hr_api.g_number
401 ,p_attribute_category in varchar2 default hr_api.g_varchar2
402 ,p_attribute1 in varchar2 default hr_api.g_varchar2
403 ,p_attribute2 in varchar2 default hr_api.g_varchar2
404 ,p_attribute3 in varchar2 default hr_api.g_varchar2
405 ,p_attribute4 in varchar2 default hr_api.g_varchar2
406 ,p_attribute5 in varchar2 default hr_api.g_varchar2
407 ,p_attribute6 in varchar2 default hr_api.g_varchar2
408 ,p_attribute7 in varchar2 default hr_api.g_varchar2
409 ,p_attribute8 in varchar2 default hr_api.g_varchar2
410 ,p_attribute9 in varchar2 default hr_api.g_varchar2
411 ,p_attribute10 in varchar2 default hr_api.g_varchar2
412 ,p_attribute11 in varchar2 default hr_api.g_varchar2
413 ,p_attribute12 in varchar2 default hr_api.g_varchar2
414 ,p_attribute13 in varchar2 default hr_api.g_varchar2
415 ,p_attribute14 in varchar2 default hr_api.g_varchar2
416 ,p_attribute15 in varchar2 default hr_api.g_varchar2
417 ,p_attribute16 in varchar2 default hr_api.g_varchar2
418 ,p_attribute17 in varchar2 default hr_api.g_varchar2
419 ,p_attribute18 in varchar2 default hr_api.g_varchar2
420 ,p_attribute19 in varchar2 default hr_api.g_varchar2
421 ,p_attribute20 in varchar2 default hr_api.g_varchar2
422 ,p_attribute21 in varchar2 default hr_api.g_varchar2
423 ,p_attribute22 in varchar2 default hr_api.g_varchar2
424 ,p_attribute23 in varchar2 default hr_api.g_varchar2
425 ,p_attribute24 in varchar2 default hr_api.g_varchar2
426 ,p_attribute25 in varchar2 default hr_api.g_varchar2
427 ,p_attribute26 in varchar2 default hr_api.g_varchar2
428 ,p_attribute27 in varchar2 default hr_api.g_varchar2
429 ,p_attribute28 in varchar2 default hr_api.g_varchar2
430 ,p_attribute29 in varchar2 default hr_api.g_varchar2
431 ,p_attribute30 in varchar2 default hr_api.g_varchar2
432 ,p_candidate_info_category in varchar2 default hr_api.g_varchar2
433 ,p_candidate_information1 in varchar2 default hr_api.g_varchar2
434 ,p_candidate_information2 in varchar2 default hr_api.g_varchar2
435 ,p_candidate_information3 in varchar2 default hr_api.g_varchar2
436 ,p_candidate_information4 in varchar2 default hr_api.g_varchar2
437 ,p_candidate_information5 in varchar2 default hr_api.g_varchar2
438 ,p_candidate_information6 in varchar2 default hr_api.g_varchar2
439 ,p_candidate_information7 in varchar2 default hr_api.g_varchar2
440 ,p_candidate_information8 in varchar2 default hr_api.g_varchar2
441 ,p_candidate_information9 in varchar2 default hr_api.g_varchar2
442 ,p_candidate_information10 in varchar2 default hr_api.g_varchar2
443 ,p_candidate_information11 in varchar2 default hr_api.g_varchar2
444 ,p_candidate_information12 in varchar2 default hr_api.g_varchar2
445 ,p_candidate_information13 in varchar2 default hr_api.g_varchar2
446 ,p_candidate_information14 in varchar2 default hr_api.g_varchar2
447 ,p_candidate_information15 in varchar2 default hr_api.g_varchar2
448 ,p_candidate_information16 in varchar2 default hr_api.g_varchar2
449 ,p_candidate_information17 in varchar2 default hr_api.g_varchar2
450 ,p_candidate_information18 in varchar2 default hr_api.g_varchar2
451 ,p_candidate_information19 in varchar2 default hr_api.g_varchar2
452 ,p_candidate_information20 in varchar2 default hr_api.g_varchar2
453 ,p_candidate_information21 in varchar2 default hr_api.g_varchar2
454 ,p_candidate_information22 in varchar2 default hr_api.g_varchar2
455 ,p_candidate_information23 in varchar2 default hr_api.g_varchar2
456 ,p_candidate_information24 in varchar2 default hr_api.g_varchar2
457 ,p_candidate_information25 in varchar2 default hr_api.g_varchar2
458 ,p_candidate_information26 in varchar2 default hr_api.g_varchar2
459 ,p_candidate_information27 in varchar2 default hr_api.g_varchar2
460 ,p_candidate_information28 in varchar2 default hr_api.g_varchar2
461 ,p_candidate_information29 in varchar2 default hr_api.g_varchar2
462 ,p_candidate_information30 in varchar2 default hr_api.g_varchar2
463 ) is
464 --
465 -- Declare cursors and local variables
466 --
467
468 l_proc varchar2(72) := g_package||'create_election_candidate';
469 l_object_version_number per_election_candidates.object_version_number%TYPE;
470 l_ovn per_election_candidates.object_version_number%TYPE := p_object_version_number;
471
472
473 begin
474 hr_utility.set_location('Entering:'|| l_proc, 10);
475 --
476 -- Issue a savepoint
477 --
478 savepoint update_election_candidate;
479 --
480 -- Truncate the time portion from all IN date parameters
481 --
482 -- Store OVN passed in
483 l_object_version_number := p_object_version_number;
484 --
485 -- Call Before Process User Hook
486 --
487 begin
488 hr_elc_candidate_api_bk2.update_election_candidate_b
489 (p_election_candidate_id => p_election_candidate_id
490 ,p_object_version_number => l_object_version_number
491 ,p_business_group_id => p_business_group_id
492 ,p_person_id => p_person_id
493 ,p_election_id => p_election_id
494 ,p_rank => p_rank
495 ,p_role_id => p_role_id
496 ,p_attribute_category => p_attribute_category
497 ,p_attribute1 => p_attribute1
498 ,p_attribute2 => p_attribute2
499 ,p_attribute3 => p_attribute3
500 ,p_attribute4 => p_attribute4
501 ,p_attribute5 => p_attribute5
502 ,p_attribute6 => p_attribute6
503 ,p_attribute7 => p_attribute7
504 ,p_attribute8 => p_attribute8
505 ,p_attribute9 => p_attribute9
506 ,p_attribute10 => p_attribute10
507 ,p_attribute11 => p_attribute11
508 ,p_attribute12 => p_attribute12
509 ,p_attribute13 => p_attribute13
510 ,p_attribute14 => p_attribute14
511 ,p_attribute15 => p_attribute15
512 ,p_attribute16 => p_attribute16
513 ,p_attribute17 => p_attribute17
514 ,p_attribute18 => p_attribute18
515 ,p_attribute19 => p_attribute19
516 ,p_attribute20 => p_attribute20
517 ,p_attribute21 => p_attribute21
518 ,p_attribute22 => p_attribute22
519 ,p_attribute23 => p_attribute23
520 ,p_attribute24 => p_attribute24
521 ,p_attribute25 => p_attribute25
522 ,p_attribute26 => p_attribute26
523 ,p_attribute27 => p_attribute27
524 ,p_attribute28 => p_attribute28
525 ,p_attribute29 => p_attribute29
526 ,p_attribute30 => p_attribute30
527 ,p_candidate_info_category => p_candidate_info_category
528 ,p_candidate_information1 => p_candidate_information1
529 ,p_candidate_information2 => p_candidate_information2
530 ,p_candidate_information3 => p_candidate_information3
531 ,p_candidate_information4 => p_candidate_information4
532 ,p_candidate_information5 => p_candidate_information5
533 ,p_candidate_information6 => p_candidate_information6
534 ,p_candidate_information7 => p_candidate_information7
535 ,p_candidate_information8 => p_candidate_information8
536 ,p_candidate_information9 => p_candidate_information9
537 ,p_candidate_information10 => p_candidate_information10
538 ,p_candidate_information11 => p_candidate_information11
539 ,p_candidate_information12 => p_candidate_information12
540 ,p_candidate_information13 => p_candidate_information13
541 ,p_candidate_information14 => p_candidate_information14
542 ,p_candidate_information15 => p_candidate_information15
543 ,p_candidate_information16 => p_candidate_information16
544 ,p_candidate_information17 => p_candidate_information17
545 ,p_candidate_information18 => p_candidate_information18
546 ,p_candidate_information19 => p_candidate_information19
547 ,p_candidate_information20 => p_candidate_information20
548 ,p_candidate_information21 => p_candidate_information21
549 ,p_candidate_information22 => p_candidate_information22
550 ,p_candidate_information23 => p_candidate_information23
551 ,p_candidate_information24 => p_candidate_information24
552 ,p_candidate_information25 => p_candidate_information25
553 ,p_candidate_information26 => p_candidate_information26
554 ,p_candidate_information27 => p_candidate_information27
555 ,p_candidate_information28 => p_candidate_information28
556 ,p_candidate_information29 => p_candidate_information29
557 ,p_candidate_information30 => p_candidate_information30);
558 exception
559 when hr_api.cannot_find_prog_unit then
560 hr_api.cannot_find_prog_unit_error
561 (p_module_name => 'update_election_candidate_b'
562 ,p_hook_type => 'BP'
563 );
564 end;
565 --
566 -- Validation in addition to Row Handlers
567 --
568
569 --
570 -- Process Logic
571 --
572 per_eca_upd.upd
573 (p_election_candidate_id => p_election_candidate_id
574 ,p_object_version_number => l_object_version_number
575 ,p_business_group_id => p_business_group_id
576 ,p_election_id => p_election_id
577 ,p_person_id => p_person_id
578 ,p_rank => p_rank
579 ,p_role_id => p_role_id
580 ,p_attribute_category => p_attribute_category
581 ,p_attribute1 => p_attribute1
582 ,p_attribute2 => p_attribute2
583 ,p_attribute3 => p_attribute3
584 ,p_attribute4 => p_attribute4
585 ,p_attribute5 => p_attribute5
586 ,p_attribute6 => p_attribute6
587 ,p_attribute7 => p_attribute7
588 ,p_attribute8 => p_attribute8
589 ,p_attribute9 => p_attribute9
590 ,p_attribute10 => p_attribute10
591 ,p_attribute11 => p_attribute11
592 ,p_attribute12 => p_attribute12
593 ,p_attribute13 => p_attribute13
594 ,p_attribute14 => p_attribute14
595 ,p_attribute15 => p_attribute15
596 ,p_attribute16 => p_attribute16
597 ,p_attribute17 => p_attribute17
598 ,p_attribute18 => p_attribute18
599 ,p_attribute19 => p_attribute19
600 ,p_attribute20 => p_attribute20
601 ,p_attribute21 => p_attribute21
602 ,p_attribute22 => p_attribute22
603 ,p_attribute23 => p_attribute23
604 ,p_attribute24 => p_attribute24
605 ,p_attribute25 => p_attribute25
606 ,p_attribute26 => p_attribute26
607 ,p_attribute27 => p_attribute27
608 ,p_attribute28 => p_attribute28
609 ,p_attribute29 => p_attribute29
610 ,p_attribute30 => p_attribute30
611 ,p_candidate_info_category => p_candidate_info_category
612 ,p_candidate_information1 => p_candidate_information1
613 ,p_candidate_information2 => p_candidate_information2
614 ,p_candidate_information3 => p_candidate_information3
615 ,p_candidate_information4 => p_candidate_information4
616 ,p_candidate_information5 => p_candidate_information5
617 ,p_candidate_information6 => p_candidate_information6
618 ,p_candidate_information7 => p_candidate_information7
619 ,p_candidate_information8 => p_candidate_information8
620 ,p_candidate_information9 => p_candidate_information9
621 ,p_candidate_information10 => p_candidate_information10
622 ,p_candidate_information11 => p_candidate_information11
623 ,p_candidate_information12 => p_candidate_information12
624 ,p_candidate_information13 => p_candidate_information13
625 ,p_candidate_information14 => p_candidate_information14
626 ,p_candidate_information15 => p_candidate_information15
627 ,p_candidate_information16 => p_candidate_information16
628 ,p_candidate_information17 => p_candidate_information17
629 ,p_candidate_information18 => p_candidate_information18
630 ,p_candidate_information19 => p_candidate_information19
631 ,p_candidate_information20 => p_candidate_information20
632 ,p_candidate_information21 => p_candidate_information21
633 ,p_candidate_information22 => p_candidate_information22
634 ,p_candidate_information23 => p_candidate_information23
635 ,p_candidate_information24 => p_candidate_information24
636 ,p_candidate_information25 => p_candidate_information25
637 ,p_candidate_information26 => p_candidate_information26
638 ,p_candidate_information27 => p_candidate_information27
639 ,p_candidate_information28 => p_candidate_information28
640 ,p_candidate_information29 => p_candidate_information29
641 ,p_candidate_information30 => p_candidate_information30);
642
643
644 --
645 -- Call After Process User Hook
646 --
647 begin
648 hr_elc_candidate_api_bk2.update_election_candidate_a
649 (p_election_candidate_id => p_election_candidate_id
650 ,p_object_version_number => l_object_version_number
651 ,p_business_group_id => p_business_group_id
652 ,p_election_id => p_election_id
653 ,p_person_id => p_person_id
654 ,p_rank => p_rank
655 ,p_role_id => p_role_id
656 ,p_attribute_category => p_attribute_category
657 ,p_attribute1 => p_attribute1
658 ,p_attribute2 => p_attribute2
659 ,p_attribute3 => p_attribute3
660 ,p_attribute4 => p_attribute4
661 ,p_attribute5 => p_attribute5
662 ,p_attribute6 => p_attribute6
663 ,p_attribute7 => p_attribute7
664 ,p_attribute8 => p_attribute8
665 ,p_attribute9 => p_attribute9
666 ,p_attribute10 => p_attribute10
667 ,p_attribute11 => p_attribute11
668 ,p_attribute12 => p_attribute12
669 ,p_attribute13 => p_attribute13
670 ,p_attribute14 => p_attribute14
671 ,p_attribute15 => p_attribute15
672 ,p_attribute16 => p_attribute16
673 ,p_attribute17 => p_attribute17
674 ,p_attribute18 => p_attribute18
675 ,p_attribute19 => p_attribute19
676 ,p_attribute20 => p_attribute20
677 ,p_attribute21 => p_attribute21
678 ,p_attribute22 => p_attribute22
679 ,p_attribute23 => p_attribute23
680 ,p_attribute24 => p_attribute24
681 ,p_attribute25 => p_attribute25
682 ,p_attribute26 => p_attribute26
683 ,p_attribute27 => p_attribute27
684 ,p_attribute28 => p_attribute28
685 ,p_attribute29 => p_attribute29
686 ,p_attribute30 => p_attribute30
687 ,p_candidate_info_category => p_candidate_info_category
688 ,p_candidate_information1 => p_candidate_information1
689 ,p_candidate_information2 => p_candidate_information2
690 ,p_candidate_information3 => p_candidate_information3
691 ,p_candidate_information4 => p_candidate_information4
692 ,p_candidate_information5 => p_candidate_information5
693 ,p_candidate_information6 => p_candidate_information6
694 ,p_candidate_information7 => p_candidate_information7
695 ,p_candidate_information8 => p_candidate_information8
696 ,p_candidate_information9 => p_candidate_information9
697 ,p_candidate_information10 => p_candidate_information10
698 ,p_candidate_information11 => p_candidate_information11
699 ,p_candidate_information12 => p_candidate_information12
700 ,p_candidate_information13 => p_candidate_information13
701 ,p_candidate_information14 => p_candidate_information14
702 ,p_candidate_information15 => p_candidate_information15
703 ,p_candidate_information16 => p_candidate_information16
704 ,p_candidate_information17 => p_candidate_information17
705 ,p_candidate_information18 => p_candidate_information18
706 ,p_candidate_information19 => p_candidate_information19
707 ,p_candidate_information20 => p_candidate_information20
708 ,p_candidate_information21 => p_candidate_information21
709 ,p_candidate_information22 => p_candidate_information22
710 ,p_candidate_information23 => p_candidate_information23
711 ,p_candidate_information24 => p_candidate_information24
712 ,p_candidate_information25 => p_candidate_information25
713 ,p_candidate_information26 => p_candidate_information26
714 ,p_candidate_information27 => p_candidate_information27
715 ,p_candidate_information28 => p_candidate_information28
716 ,p_candidate_information29 => p_candidate_information29
717 ,p_candidate_information30 => p_candidate_information30
718 );
719 exception
720 when hr_api.cannot_find_prog_unit then
721 hr_api.cannot_find_prog_unit_error
722 (p_module_name => 'update_election_candidate_a'
723 ,p_hook_type => 'AP'
724 );
725 end;
726 --
727 -- When in validation only mode raise the Validate_Enabled exception
728 --
729 if p_validate then
730 raise hr_api.validate_enabled;
731 end if;
732 --
733 -- Set all output arguments
734 --
735 p_object_version_number := l_object_version_number;
736 --
737 hr_utility.set_location(' Leaving:'||l_proc, 70);
738 exception
739 when hr_api.validate_enabled then
740 --
741 -- As the Validate_Enabled exception has been raised
742 -- we must rollback to the savepoint
743 --
744 rollback to update_election_candidate;
745 --
746 -- Only set output warning arguments
747 -- (Any key or derived arguments must be set to null
748 -- when validation only mode is being used.)
749 --
750 p_object_version_number := null;
751 hr_utility.set_location(' Leaving:'||l_proc, 80);
752 when others then
753 --
754 -- A validation or unexpected error has occured
755 --
756 rollback to update_election_candidate;
757 --
758 -- set in out parameters and set out parameters
759 --
760 p_object_version_number := l_ovn;
761 --
762 hr_utility.set_location(' Leaving:'||l_proc, 90);
763 raise;
764 end update_election_candidate;
765 --
766 -- |---------------------------< delete_election_candidate >--------------------------|
767 -- ----------------------------------------------------------------------------
768 --
769 procedure delete_election_candidate
770 (p_validate in boolean default false
771 ,p_election_candidate_id in number
772 ,p_object_version_number in out nocopy number
773 ) is
774 --
775 -- Declare cursors and local variables
776 --
777 l_proc varchar2(72) := g_package||'delete_election_candidate';
778 l_object_version_number per_election_candidates.object_version_number%TYPE;
779 l_ovn per_election_candidates.object_version_number%TYPE := p_object_version_number;
780 --
781 begin
782 --
783 hr_utility.set_location('Entering:'|| l_proc, 10);
784 --
785 -- Issue a savepoint if operating in validation only mode
786 --
787 savepoint delete_election_candidate;
788 --
789 hr_utility.set_location(l_proc, 20);
790 --
791 -- Process Logic
792 --
793 hr_utility.set_location(l_proc, 30);
794 --
795 l_object_version_number := p_object_version_number;
796 --
797 begin
798 --
799 -- Start of API User Hook for the before hook of delete_election_candidate
800 --
801 hr_elc_candidate_api_bk3.delete_election_candidate_b
802 (p_election_candidate_id => p_election_candidate_id
803 ,p_object_version_number => l_object_version_number
804 );
805 --
806 exception
807 when hr_api.cannot_find_prog_unit then
808 hr_api.cannot_find_prog_unit_error
809 (p_module_name => 'delete_election_candidate_b'
810 ,p_hook_type => 'BP'
811 );
812 --
813 -- End of API User Hook for the before hook of delete_election_candidate
814 --
815 end;
816 --
817 per_eca_del.del
818 (p_election_candidate_id => p_election_candidate_id
819 ,p_object_version_number => l_object_version_number
820 );
821 --
822 begin
823 --
824 -- Start of API User Hook for the after hook of delete_contract
825 --
826 hr_elc_candidate_api_bk3.delete_election_candidate_a
827 (p_election_candidate_id => p_election_candidate_id
828 ,p_object_version_number => l_object_version_number
829 );
830 exception
831 when hr_api.cannot_find_prog_unit then
832 hr_api.cannot_find_prog_unit_error
833 (p_module_name => 'delete_election_candidate_a'
834 ,p_hook_type => 'AP'
835 );
836 --
837 end;
838 --
839 hr_utility.set_location(l_proc, 60);
840 --
841 -- When in validation only mode raise the Validate_Enabled exception
842 --
843 p_object_version_number := l_object_version_number;
844 --
845 if p_validate then
846 raise hr_api.validate_enabled;
847 end if;
848 --
849 -- Set all output arguments (returned by some dt modes only)
850 --
851 p_object_version_number := l_object_version_number;
852 --
853 hr_utility.set_location(' Leaving:'||l_proc, 70);
854 --
855 exception
856 --
857 when hr_api.validate_enabled then
858 --
859 -- As the Validate_Enabled exception has been raised
860 -- we must rollback to the savepoint --
861 ROLLBACK TO delete_election_candidate;
862 --
863 -- Only set output warning arguments
864 -- (Any key or derived arguments must be set to null
865 -- when validation only mode is being used.)
866 --
867 p_object_version_number := null;
868 --
869 when others then
870 --
871 -- A validation or unexpected error has occured
872 --
873 ROLLBACK TO delete_election_candidate;
874 --
875 -- set in out parameters and set out parameters
876 --
877 p_object_version_number := l_ovn;
878 raise;
879 --
880 end delete_election_candidate;
881 --
882
883 end hr_elc_candidate_api;