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