[Home] [Help]
PACKAGE BODY: APPS.BEN_ELP_EXTRA_INFO_API
Source
1 Package Body ben_elp_extra_info_api as
2 /* $Header: beeliapi.pkb 115.0 2003/09/23 10:17:54 hmani noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_elp_extra_info_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |----------------------< create_elp_extra_info >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_elp_extra_info
13 (p_validate in boolean default false
14 ,p_eligy_prfl_id in number
15 ,p_information_type in varchar2
16 ,p_eli_attribute_category in varchar2 default null
17 ,p_eli_attribute1 in varchar2 default null
18 ,p_eli_attribute2 in varchar2 default null
19 ,p_eli_attribute3 in varchar2 default null
20 ,p_eli_attribute4 in varchar2 default null
21 ,p_eli_attribute5 in varchar2 default null
22 ,p_eli_attribute6 in varchar2 default null
23 ,p_eli_attribute7 in varchar2 default null
24 ,p_eli_attribute8 in varchar2 default null
25 ,p_eli_attribute9 in varchar2 default null
26 ,p_eli_attribute10 in varchar2 default null
27 ,p_eli_attribute11 in varchar2 default null
28 ,p_eli_attribute12 in varchar2 default null
29 ,p_eli_attribute13 in varchar2 default null
30 ,p_eli_attribute14 in varchar2 default null
31 ,p_eli_attribute15 in varchar2 default null
32 ,p_eli_attribute16 in varchar2 default null
33 ,p_eli_attribute17 in varchar2 default null
34 ,p_eli_attribute18 in varchar2 default null
35 ,p_eli_attribute19 in varchar2 default null
36 ,p_eli_attribute20 in varchar2 default null
37 ,p_eli_information_category in varchar2 default null
38 ,p_eli_information1 in varchar2 default null
39 ,p_eli_information2 in varchar2 default null
40 ,p_eli_information3 in varchar2 default null
41 ,p_eli_information4 in varchar2 default null
42 ,p_eli_information5 in varchar2 default null
43 ,p_eli_information6 in varchar2 default null
44 ,p_eli_information7 in varchar2 default null
45 ,p_eli_information8 in varchar2 default null
46 ,p_eli_information9 in varchar2 default null
47 ,p_eli_information10 in varchar2 default null
48 ,p_eli_information11 in varchar2 default null
49 ,p_eli_information12 in varchar2 default null
50 ,p_eli_information13 in varchar2 default null
51 ,p_eli_information14 in varchar2 default null
52 ,p_eli_information15 in varchar2 default null
53 ,p_eli_information16 in varchar2 default null
54 ,p_eli_information17 in varchar2 default null
55 ,p_eli_information18 in varchar2 default null
56 ,p_eli_information19 in varchar2 default null
57 ,p_eli_information20 in varchar2 default null
58 ,p_eli_information21 in varchar2 default null
59 ,p_eli_information22 in varchar2 default null
60 ,p_eli_information23 in varchar2 default null
61 ,p_eli_information24 in varchar2 default null
62 ,p_eli_information25 in varchar2 default null
63 ,p_eli_information26 in varchar2 default null
64 ,p_eli_information27 in varchar2 default null
65 ,p_eli_information28 in varchar2 default null
66 ,p_eli_information29 in varchar2 default null
67 ,p_eli_information30 in varchar2 default null
68 ,p_elp_extra_info_id out nocopy number
69 ,p_object_version_number out nocopy number
70 ) is
71 --
72 -- Declare cursors and local variables
73 --
74 l_proc varchar2(72) := g_package||'create_elp_extra_info';
75 l_object_version_number ben_elp_extra_info.object_version_number%type;
76 l_elp_extra_info_id ben_elp_extra_info.elp_extra_info_id%type;
77 --
78 begin
79 hr_utility.set_location('Entering:'|| l_proc, 5);
80 --
81 -- Issue a savepoint
82 --
83 savepoint create_elp_extra_info;
84 --
85 -- Call Before Process User Hook
86 --
87 begin
88
89 ben_elp_extra_info_bk1.create_elp_extra_info_b
90 (
91 p_information_type => p_information_type,
92 p_eligy_prfl_id => p_eligy_prfl_id,
93 p_eli_attribute_category => p_eli_attribute_category,
94 p_eli_attribute1 => p_eli_attribute1,
95 p_eli_attribute2 => p_eli_attribute2,
96 p_eli_attribute3 => p_eli_attribute3,
97 p_eli_attribute4 => p_eli_attribute4,
98 p_eli_attribute5 => p_eli_attribute5,
99 p_eli_attribute6 => p_eli_attribute6,
100 p_eli_attribute7 => p_eli_attribute7,
101 p_eli_attribute8 => p_eli_attribute8,
102 p_eli_attribute9 => p_eli_attribute9,
103 p_eli_attribute10 => p_eli_attribute10,
104 p_eli_attribute11 => p_eli_attribute11,
105 p_eli_attribute12 => p_eli_attribute12,
106 p_eli_attribute13 => p_eli_attribute13,
107 p_eli_attribute14 => p_eli_attribute14,
108 p_eli_attribute15 => p_eli_attribute15,
109 p_eli_attribute16 => p_eli_attribute16,
110 p_eli_attribute17 => p_eli_attribute17,
111 p_eli_attribute18 => p_eli_attribute18,
112 p_eli_attribute19 => p_eli_attribute19,
113 p_eli_attribute20 => p_eli_attribute20,
114 p_eli_information_category => p_eli_information_category,
115 p_eli_information1 => p_eli_information1,
116 p_eli_information2 => p_eli_information2,
117 p_eli_information3 => p_eli_information3,
118 p_eli_information4 => p_eli_information4,
119 p_eli_information5 => p_eli_information5,
120 p_eli_information6 => p_eli_information6,
121 p_eli_information7 => p_eli_information7,
122 p_eli_information8 => p_eli_information8,
123 p_eli_information9 => p_eli_information9,
124 p_eli_information10 => p_eli_information10,
125 p_eli_information11 => p_eli_information11,
126 p_eli_information12 => p_eli_information12,
127 p_eli_information13 => p_eli_information13,
128 p_eli_information14 => p_eli_information14,
129 p_eli_information15 => p_eli_information15,
130 p_eli_information16 => p_eli_information16,
131 p_eli_information17 => p_eli_information17,
132 p_eli_information18 => p_eli_information18,
133 p_eli_information19 => p_eli_information19,
134 p_eli_information20 => p_eli_information20,
135 p_eli_information21 => p_eli_information21,
136 p_eli_information22 => p_eli_information22,
137 p_eli_information23 => p_eli_information23,
138 p_eli_information24 => p_eli_information24,
139 p_eli_information25 => p_eli_information25,
140 p_eli_information26 => p_eli_information26,
141 p_eli_information27 => p_eli_information27,
142 p_eli_information28 => p_eli_information28,
143 p_eli_information29 => p_eli_information29,
144 p_eli_information30 => p_eli_information30
145 );
146 exception
147 when hr_api.cannot_find_prog_unit then
148 hr_api.cannot_find_prog_unit_error
149 (p_module_name => 'create_elp_extra_info',
150 p_hook_type => 'BP'
151 );
152 end;
153 --
154 -- End of Before Process User Hook call
155 hr_utility.set_location(l_proc, 7);
156 --
157 -- Process Logic
158 --
159 ben_eli_ins.ins
160 (p_elp_extra_info_id => l_elp_extra_info_id
161 ,p_eligy_prfl_id => p_eligy_prfl_id
162 ,p_information_type => p_information_type
163 ,p_eli_attribute_category => p_eli_attribute_category
164 ,p_eli_attribute1 => p_eli_attribute1
165 ,p_eli_attribute2 => p_eli_attribute2
166 ,p_eli_attribute3 => p_eli_attribute3
167 ,p_eli_attribute4 => p_eli_attribute4
168 ,p_eli_attribute5 => p_eli_attribute5
169 ,p_eli_attribute6 => p_eli_attribute6
170 ,p_eli_attribute7 => p_eli_attribute7
171 ,p_eli_attribute8 => p_eli_attribute8
172 ,p_eli_attribute9 => p_eli_attribute9
173 ,p_eli_attribute10 => p_eli_attribute10
174 ,p_eli_attribute11 => p_eli_attribute11
175 ,p_eli_attribute12 => p_eli_attribute12
176 ,p_eli_attribute13 => p_eli_attribute13
177 ,p_eli_attribute14 => p_eli_attribute14
178 ,p_eli_attribute15 => p_eli_attribute15
179 ,p_eli_attribute16 => p_eli_attribute16
180 ,p_eli_attribute17 => p_eli_attribute17
181 ,p_eli_attribute18 => p_eli_attribute18
182 ,p_eli_attribute19 => p_eli_attribute19
183 ,p_eli_attribute20 => p_eli_attribute20
184 ,p_eli_information_category => p_eli_information_category
185 ,p_eli_information1 => p_eli_information1
186 ,p_eli_information2 => p_eli_information2
187 ,p_eli_information3 => p_eli_information3
188 ,p_eli_information4 => p_eli_information4
189 ,p_eli_information5 => p_eli_information5
190 ,p_eli_information6 => p_eli_information6
191 ,p_eli_information7 => p_eli_information7
192 ,p_eli_information8 => p_eli_information8
193 ,p_eli_information9 => p_eli_information9
194 ,p_eli_information10 => p_eli_information10
195 ,p_eli_information11 => p_eli_information11
196 ,p_eli_information12 => p_eli_information12
197 ,p_eli_information13 => p_eli_information13
198 ,p_eli_information14 => p_eli_information14
199 ,p_eli_information15 => p_eli_information15
200 ,p_eli_information16 => p_eli_information16
201 ,p_eli_information17 => p_eli_information17
202 ,p_eli_information18 => p_eli_information18
203 ,p_eli_information19 => p_eli_information19
204 ,p_eli_information20 => p_eli_information20
205 ,p_eli_information21 => p_eli_information21
206 ,p_eli_information22 => p_eli_information22
207 ,p_eli_information23 => p_eli_information23
208 ,p_eli_information24 => p_eli_information24
209 ,p_eli_information25 => p_eli_information25
210 ,p_eli_information26 => p_eli_information26
211 ,p_eli_information27 => p_eli_information27
212 ,p_eli_information28 => p_eli_information28
213 ,p_eli_information29 => p_eli_information29
214 ,p_eli_information30 => p_eli_information30
215 ,p_object_version_number => l_object_version_number
216 ,p_validate => false
217 );
218 p_object_version_number := l_object_version_number;
219 p_elp_extra_info_id := l_elp_extra_info_id;
220 --
221 hr_utility.set_location(l_proc, 8);
222 --
223 -- Call After Process User Hook
224 --
225 begin
226 ben_elp_extra_info_bk1.create_elp_extra_info_a
227 (
228 p_elp_extra_info_id => l_elp_extra_info_id,
229 p_information_type => p_information_type,
230 p_eligy_prfl_id => p_eligy_prfl_id,
231 p_eli_attribute_category => p_eli_attribute_category,
232 p_eli_attribute1 => p_eli_attribute1,
233 p_eli_attribute2 => p_eli_attribute2,
234 p_eli_attribute3 => p_eli_attribute3,
235 p_eli_attribute4 => p_eli_attribute4,
236 p_eli_attribute5 => p_eli_attribute5,
237 p_eli_attribute6 => p_eli_attribute6,
238 p_eli_attribute7 => p_eli_attribute7,
239 p_eli_attribute8 => p_eli_attribute8,
240 p_eli_attribute9 => p_eli_attribute9,
241 p_eli_attribute10 => p_eli_attribute10,
242 p_eli_attribute11 => p_eli_attribute11,
243 p_eli_attribute12 => p_eli_attribute12,
244 p_eli_attribute13 => p_eli_attribute13,
245 p_eli_attribute14 => p_eli_attribute14,
246 p_eli_attribute15 => p_eli_attribute15,
247 p_eli_attribute16 => p_eli_attribute16,
248 p_eli_attribute17 => p_eli_attribute17,
249 p_eli_attribute18 => p_eli_attribute18,
250 p_eli_attribute19 => p_eli_attribute19,
251 p_eli_attribute20 => p_eli_attribute20,
252 p_eli_information_category => p_eli_information_category,
253 p_eli_information1 => p_eli_information1,
254 p_eli_information2 => p_eli_information2,
255 p_eli_information3 => p_eli_information3,
256 p_eli_information4 => p_eli_information4,
257 p_eli_information5 => p_eli_information5,
258 p_eli_information6 => p_eli_information6,
259 p_eli_information7 => p_eli_information7,
260 p_eli_information8 => p_eli_information8,
261 p_eli_information9 => p_eli_information9,
262 p_eli_information10 => p_eli_information10,
263 p_eli_information11 => p_eli_information11,
264 p_eli_information12 => p_eli_information12,
265 p_eli_information13 => p_eli_information13,
266 p_eli_information14 => p_eli_information14,
267 p_eli_information15 => p_eli_information15,
268 p_eli_information16 => p_eli_information16,
269 p_eli_information17 => p_eli_information17,
270 p_eli_information18 => p_eli_information18,
271 p_eli_information19 => p_eli_information19,
272 p_eli_information20 => p_eli_information20,
273 p_eli_information21 => p_eli_information21,
274 p_eli_information22 => p_eli_information22,
275 p_eli_information23 => p_eli_information23,
276 p_eli_information24 => p_eli_information24,
277 p_eli_information25 => p_eli_information25,
278 p_eli_information26 => p_eli_information26,
279 p_eli_information27 => p_eli_information27,
280 p_eli_information28 => p_eli_information28,
281 p_eli_information29 => p_eli_information29,
282 p_eli_information30 => p_eli_information30,
283 p_object_version_number => l_object_version_number
284 );
285 exception
286 when hr_api.cannot_find_prog_unit then
287 hr_api.cannot_find_prog_unit_error
288 (p_module_name => 'create_elp_extra_info',
289 p_hook_type => 'AP'
290 );
291 end;
292 --
293 -- When in validation only mode raise the Validate_Enabled exception
294 --
295 if p_validate then
296 raise hr_api.validate_enabled;
297 end if;
298 --
299 hr_utility.set_location(' Leaving:'||l_proc, 11);
300 exception
301 when hr_api.validate_enabled then
302 --
303 -- As the Validate_Enabled exception has been raised
304 -- we must rollback to the savepoint
305 --
306 ROLLBACK TO create_elp_extra_info;
307 --
308 -- Only set output warning arguments
309 -- (Any key or derived arguments must be set to null
310 -- when validation only mode is being used.)
311 --
312 p_elp_extra_info_id := null;
313 p_object_version_number := null;
314 --
315 hr_utility.set_location(' Leaving:'||l_proc, 12);
316 --
317 when others then
318 --
319 -- A validation or unexpected error has occurred
320 --
321 -- Added as part of the fix to bug 632479
322 --
323 ROLLBACK TO create_elp_extra_info;
324 --
325 -- set in out parameters and set out parameters
326 --
330 raise;
327 p_elp_extra_info_id := null;
328 p_object_version_number := null;
329 --
331 --
332 end create_elp_extra_info;
333 --
334 -- ----------------------------------------------------------------------------
335 -- |----------------------< update_elp_extra_info >----------------------|
336 -- ----------------------------------------------------------------------------
337 --
338 procedure update_elp_extra_info
339 (p_validate in boolean default false
340 ,p_elp_extra_info_id in number
341 ,p_object_version_number in out nocopy number
342 ,p_eli_attribute_category in varchar2 default hr_api.g_varchar2
343 ,p_eli_attribute1 in varchar2 default hr_api.g_varchar2
344 ,p_eli_attribute2 in varchar2 default hr_api.g_varchar2
345 ,p_eli_attribute3 in varchar2 default hr_api.g_varchar2
346 ,p_eli_attribute4 in varchar2 default hr_api.g_varchar2
347 ,p_eli_attribute5 in varchar2 default hr_api.g_varchar2
348 ,p_eli_attribute6 in varchar2 default hr_api.g_varchar2
349 ,p_eli_attribute7 in varchar2 default hr_api.g_varchar2
350 ,p_eli_attribute8 in varchar2 default hr_api.g_varchar2
351 ,p_eli_attribute9 in varchar2 default hr_api.g_varchar2
352 ,p_eli_attribute10 in varchar2 default hr_api.g_varchar2
353 ,p_eli_attribute11 in varchar2 default hr_api.g_varchar2
354 ,p_eli_attribute12 in varchar2 default hr_api.g_varchar2
355 ,p_eli_attribute13 in varchar2 default hr_api.g_varchar2
356 ,p_eli_attribute14 in varchar2 default hr_api.g_varchar2
357 ,p_eli_attribute15 in varchar2 default hr_api.g_varchar2
358 ,p_eli_attribute16 in varchar2 default hr_api.g_varchar2
359 ,p_eli_attribute17 in varchar2 default hr_api.g_varchar2
360 ,p_eli_attribute18 in varchar2 default hr_api.g_varchar2
361 ,p_eli_attribute19 in varchar2 default hr_api.g_varchar2
362 ,p_eli_attribute20 in varchar2 default hr_api.g_varchar2
363 ,p_eli_information_category in varchar2 default hr_api.g_varchar2
364 ,p_eli_information1 in varchar2 default hr_api.g_varchar2
365 ,p_eli_information2 in varchar2 default hr_api.g_varchar2
366 ,p_eli_information3 in varchar2 default hr_api.g_varchar2
367 ,p_eli_information4 in varchar2 default hr_api.g_varchar2
368 ,p_eli_information5 in varchar2 default hr_api.g_varchar2
369 ,p_eli_information6 in varchar2 default hr_api.g_varchar2
370 ,p_eli_information7 in varchar2 default hr_api.g_varchar2
371 ,p_eli_information8 in varchar2 default hr_api.g_varchar2
372 ,p_eli_information9 in varchar2 default hr_api.g_varchar2
373 ,p_eli_information10 in varchar2 default hr_api.g_varchar2
374 ,p_eli_information11 in varchar2 default hr_api.g_varchar2
375 ,p_eli_information12 in varchar2 default hr_api.g_varchar2
376 ,p_eli_information13 in varchar2 default hr_api.g_varchar2
377 ,p_eli_information14 in varchar2 default hr_api.g_varchar2
378 ,p_eli_information15 in varchar2 default hr_api.g_varchar2
379 ,p_eli_information16 in varchar2 default hr_api.g_varchar2
380 ,p_eli_information17 in varchar2 default hr_api.g_varchar2
381 ,p_eli_information18 in varchar2 default hr_api.g_varchar2
382 ,p_eli_information19 in varchar2 default hr_api.g_varchar2
383 ,p_eli_information20 in varchar2 default hr_api.g_varchar2
384 ,p_eli_information21 in varchar2 default hr_api.g_varchar2
385 ,p_eli_information22 in varchar2 default hr_api.g_varchar2
386 ,p_eli_information23 in varchar2 default hr_api.g_varchar2
387 ,p_eli_information24 in varchar2 default hr_api.g_varchar2
388 ,p_eli_information25 in varchar2 default hr_api.g_varchar2
389 ,p_eli_information26 in varchar2 default hr_api.g_varchar2
390 ,p_eli_information27 in varchar2 default hr_api.g_varchar2
391 ,p_eli_information28 in varchar2 default hr_api.g_varchar2
392 ,p_eli_information29 in varchar2 default hr_api.g_varchar2
393 ,p_eli_information30 in varchar2 default hr_api.g_varchar2
394 ) is
395 --
396 -- Declare cursors and local variables
397 --
398 l_proc varchar2(72) := g_package||'update_elp_extra_info';
399 l_object_version_number ben_elp_extra_info.object_version_number%TYPE;
400 l_ovn ben_elp_extra_info.object_version_number%TYPE := p_object_version_number;
401 --
402 begin
403 hr_utility.set_location('Entering:'|| l_proc, 5);
404 --
405 -- Issue a savepoint
406 --
407 savepoint update_elp_extra_info;
408 --
409 -- Call Before Process User Hook
410 --
411 begin
412 ben_elp_extra_info_bk2.update_elp_extra_info_b
413 (
414 p_elp_extra_info_id => p_elp_extra_info_id,
415 p_eli_attribute_category => p_eli_attribute_category,
416 p_eli_attribute1 => p_eli_attribute1,
417 p_eli_attribute2 => p_eli_attribute2,
418 p_eli_attribute3 => p_eli_attribute3,
419 p_eli_attribute4 => p_eli_attribute4,
420 p_eli_attribute5 => p_eli_attribute5,
421 p_eli_attribute6 => p_eli_attribute6,
422 p_eli_attribute7 => p_eli_attribute7,
423 p_eli_attribute8 => p_eli_attribute8,
424 p_eli_attribute9 => p_eli_attribute9,
425 p_eli_attribute10 => p_eli_attribute10,
426 p_eli_attribute11 => p_eli_attribute11,
427 p_eli_attribute12 => p_eli_attribute12,
428 p_eli_attribute13 => p_eli_attribute13,
429 p_eli_attribute14 => p_eli_attribute14,
433 p_eli_attribute18 => p_eli_attribute18,
430 p_eli_attribute15 => p_eli_attribute15,
431 p_eli_attribute16 => p_eli_attribute16,
432 p_eli_attribute17 => p_eli_attribute17,
434 p_eli_attribute19 => p_eli_attribute19,
435 p_eli_attribute20 => p_eli_attribute20,
436 p_eli_information_category => p_eli_information_category,
437 p_eli_information1 => p_eli_information1,
438 p_eli_information2 => p_eli_information2,
439 p_eli_information3 => p_eli_information3,
440 p_eli_information4 => p_eli_information4,
441 p_eli_information5 => p_eli_information5,
442 p_eli_information6 => p_eli_information6,
443 p_eli_information7 => p_eli_information7,
444 p_eli_information8 => p_eli_information8,
445 p_eli_information9 => p_eli_information9,
446 p_eli_information10 => p_eli_information10,
447 p_eli_information11 => p_eli_information11,
448 p_eli_information12 => p_eli_information12,
449 p_eli_information13 => p_eli_information13,
450 p_eli_information14 => p_eli_information14,
451 p_eli_information15 => p_eli_information15,
452 p_eli_information16 => p_eli_information16,
453 p_eli_information17 => p_eli_information17,
454 p_eli_information18 => p_eli_information18,
455 p_eli_information19 => p_eli_information19,
456 p_eli_information20 => p_eli_information20,
457 p_eli_information21 => p_eli_information21,
458 p_eli_information22 => p_eli_information22,
459 p_eli_information23 => p_eli_information23,
460 p_eli_information24 => p_eli_information24,
461 p_eli_information25 => p_eli_information25,
462 p_eli_information26 => p_eli_information26,
463 p_eli_information27 => p_eli_information27,
464 p_eli_information28 => p_eli_information28,
465 p_eli_information29 => p_eli_information29,
466 p_eli_information30 => p_eli_information30,
467 p_object_version_number => p_object_version_number
468 );
469 exception
470 when hr_api.cannot_find_prog_unit then
471 hr_api.cannot_find_prog_unit_error
472 (p_module_name => 'update_elp_extra_info',
473 p_hook_type => 'BP'
474 );
475 end;
476 --
477 -- End of Before Process User Hook call
478 --
479 hr_utility.set_location(l_proc, 7);
480 --
481 -- Store the original ovn in case we rollback when p_validate is true
482 --
483 l_object_version_number := p_object_version_number;
484 --
485 -- Process Logic - Update elp Extra Info details
486 --
487 ben_eli_upd.upd
488 (p_elp_extra_info_id => p_elp_extra_info_id
489 ,p_eli_attribute_category => p_eli_attribute_category
490 ,p_eli_attribute1 => p_eli_attribute1
491 ,p_eli_attribute2 => p_eli_attribute2
492 ,p_eli_attribute3 => p_eli_attribute3
493 ,p_eli_attribute4 => p_eli_attribute4
494 ,p_eli_attribute5 => p_eli_attribute5
495 ,p_eli_attribute6 => p_eli_attribute6
496 ,p_eli_attribute7 => p_eli_attribute7
497 ,p_eli_attribute8 => p_eli_attribute8
498 ,p_eli_attribute9 => p_eli_attribute9
499 ,p_eli_attribute10 => p_eli_attribute10
500 ,p_eli_attribute11 => p_eli_attribute11
501 ,p_eli_attribute12 => p_eli_attribute12
502 ,p_eli_attribute13 => p_eli_attribute13
503 ,p_eli_attribute14 => p_eli_attribute14
504 ,p_eli_attribute15 => p_eli_attribute15
505 ,p_eli_attribute16 => p_eli_attribute16
506 ,p_eli_attribute17 => p_eli_attribute17
507 ,p_eli_attribute18 => p_eli_attribute18
508 ,p_eli_attribute19 => p_eli_attribute19
509 ,p_eli_attribute20 => p_eli_attribute20
510 ,p_eli_information_category => p_eli_information_category
511 ,p_eli_information1 => p_eli_information1
512 ,p_eli_information2 => p_eli_information2
513 ,p_eli_information3 => p_eli_information3
514 ,p_eli_information4 => p_eli_information4
515 ,p_eli_information5 => p_eli_information5
516 ,p_eli_information6 => p_eli_information6
517 ,p_eli_information7 => p_eli_information7
518 ,p_eli_information8 => p_eli_information8
519 ,p_eli_information9 => p_eli_information9
520 ,p_eli_information10 => p_eli_information10
521 ,p_eli_information11 => p_eli_information11
522 ,p_eli_information12 => p_eli_information12
523 ,p_eli_information13 => p_eli_information13
524 ,p_eli_information14 => p_eli_information14
525 ,p_eli_information15 => p_eli_information15
526 ,p_eli_information16 => p_eli_information16
527 ,p_eli_information17 => p_eli_information17
528 ,p_eli_information18 => p_eli_information18
529 ,p_eli_information19 => p_eli_information19
530 ,p_eli_information20 => p_eli_information20
531 ,p_eli_information21 => p_eli_information21
532 ,p_eli_information22 => p_eli_information22
533 ,p_eli_information23 => p_eli_information23
534 ,p_eli_information24 => p_eli_information24
535 ,p_eli_information25 => p_eli_information25
536 ,p_eli_information26 => p_eli_information26
537 ,p_eli_information27 => p_eli_information27
538 ,p_eli_information28 => p_eli_information28
539 ,p_eli_information29 => p_eli_information29
540 ,p_eli_information30 => p_eli_information30
541 ,p_object_version_number => p_object_version_number
542 ,p_validate => false
543 );
544 --
545 hr_utility.set_location(l_proc, 8);
546 --
547 -- Call After Process User Hook
548 --
549 begin
553 p_eli_attribute_category => p_eli_attribute_category,
550 ben_elp_extra_info_bk2.update_elp_extra_info_a
551 (
552 p_elp_extra_info_id => p_elp_extra_info_id,
554 p_eli_attribute1 => p_eli_attribute1,
555 p_eli_attribute2 => p_eli_attribute2,
556 p_eli_attribute3 => p_eli_attribute3,
557 p_eli_attribute4 => p_eli_attribute4,
558 p_eli_attribute5 => p_eli_attribute5,
559 p_eli_attribute6 => p_eli_attribute6,
560 p_eli_attribute7 => p_eli_attribute7,
561 p_eli_attribute8 => p_eli_attribute8,
562 p_eli_attribute9 => p_eli_attribute9,
563 p_eli_attribute10 => p_eli_attribute10,
564 p_eli_attribute11 => p_eli_attribute11,
565 p_eli_attribute12 => p_eli_attribute12,
566 p_eli_attribute13 => p_eli_attribute13,
567 p_eli_attribute14 => p_eli_attribute14,
568 p_eli_attribute15 => p_eli_attribute15,
569 p_eli_attribute16 => p_eli_attribute16,
570 p_eli_attribute17 => p_eli_attribute17,
571 p_eli_attribute18 => p_eli_attribute18,
572 p_eli_attribute19 => p_eli_attribute19,
573 p_eli_attribute20 => p_eli_attribute20,
574 p_eli_information_category => p_eli_information_category,
575 p_eli_information1 => p_eli_information1,
576 p_eli_information2 => p_eli_information2,
577 p_eli_information3 => p_eli_information3,
578 p_eli_information4 => p_eli_information4,
579 p_eli_information5 => p_eli_information5,
580 p_eli_information6 => p_eli_information6,
581 p_eli_information7 => p_eli_information7,
582 p_eli_information8 => p_eli_information8,
583 p_eli_information9 => p_eli_information9,
584 p_eli_information10 => p_eli_information10,
585 p_eli_information11 => p_eli_information11,
586 p_eli_information12 => p_eli_information12,
587 p_eli_information13 => p_eli_information13,
588 p_eli_information14 => p_eli_information14,
589 p_eli_information15 => p_eli_information15,
590 p_eli_information16 => p_eli_information16,
591 p_eli_information17 => p_eli_information17,
592 p_eli_information18 => p_eli_information18,
593 p_eli_information19 => p_eli_information19,
594 p_eli_information20 => p_eli_information20,
595 p_eli_information21 => p_eli_information21,
596 p_eli_information22 => p_eli_information22,
597 p_eli_information23 => p_eli_information23,
598 p_eli_information24 => p_eli_information24,
599 p_eli_information25 => p_eli_information25,
600 p_eli_information26 => p_eli_information26,
601 p_eli_information27 => p_eli_information27,
602 p_eli_information28 => p_eli_information28,
603 p_eli_information29 => p_eli_information29,
604 p_eli_information30 => p_eli_information30,
605 p_object_version_number => p_object_version_number
606 );
607 exception
608 when hr_api.cannot_find_prog_unit then
609 hr_api.cannot_find_prog_unit_error
610 (p_module_name => 'update_elp_extra_info',
611 p_hook_type => 'AP'
612 );
613 end;
614 --
615 -- When in validation only mode raise the Validate_Enabled exception
616 --
617 if p_validate then
618 raise hr_api.validate_enabled;
619 end if;
620 --
621 hr_utility.set_location(' Leaving:'||l_proc, 11);
622 exception
623 when hr_api.validate_enabled then
624 --
625 -- As the Validate_Enabled exception has been raised
626 -- we must rollback to the savepoint
627 --
628 ROLLBACK TO update_elp_extra_info;
629 --
630 -- Only set output warning arguments
631 -- (Any key or derived arguments must be set to null
632 -- when validation only mode is being used.)
633 --
634 p_object_version_number := l_object_version_number;
635 --
636 hr_utility.set_location(' Leaving:'||l_proc, 12);
637 --
638 when others then
639 --
640 -- A validation or unexpected error has occurred
641 --
642 -- Added as part of the fix to bug 632479
643 --
644 ROLLBACK TO update_elp_extra_info;
645 --
646 -- set in out parameters and set out parameters
647 --
648 p_object_version_number := l_ovn;
649 --
650 raise;
651 --
652 end update_elp_extra_info;
653 --
654 --
655 -- ----------------------------------------------------------------------------
656 -- |----------------------< delete_elp_extra_info >----------------------|
657 -- ----------------------------------------------------------------------------
658 --
659 procedure delete_elp_extra_info
660 (p_validate in boolean default false
661 ,p_elp_extra_info_id in number
662 ,p_object_version_number in number
663 ) is
664 --
665 -- Declare cursors and local variables
666 --
667 l_proc varchar2(72) := g_package||'delete_elp_extra_info';
668 --
669 begin
670 hr_utility.set_location('Entering:'|| l_proc, 5);
671 --
672 -- Issue a savepoint
673 --
674 savepoint delete_elp_extra_info;
675 --
676 -- Call Before Process User Hook
677 --
678 begin
679 ben_elp_extra_info_bk3.delete_elp_extra_info_b
680 (
681 p_elp_extra_info_id => p_elp_extra_info_id,
682 p_object_version_number => p_object_version_number
683 );
684 exception
685 when hr_api.cannot_find_prog_unit then
686 hr_api.cannot_find_prog_unit_error
687 (p_module_name => 'delete_elp_extra_info',
688 p_hook_type => 'BP'
689 );
690 end;
691 --
692 hr_utility.set_location(l_proc, 7);
693 --
694 -- Process Logic - Delete elp Extra Info details
695 --
696 ben_eli_del.del
697 (p_elp_extra_info_id => p_elp_extra_info_id
698 ,p_object_version_number => p_object_version_number
699 ,p_validate => false
700 );
701 --
702 hr_utility.set_location(l_proc, 8);
703 --
704 -- Call After Process User Hook
705 --
706 begin
707 ben_elp_extra_info_bk3.delete_elp_extra_info_a
708 (
709 p_elp_extra_info_id => p_elp_extra_info_id,
710 p_object_version_number => p_object_version_number
711 );
712 exception
713 when hr_api.cannot_find_prog_unit then
714 hr_api.cannot_find_prog_unit_error
715 (p_module_name => 'delete_elp_extra_info',
716 p_hook_type => 'AP'
717 );
718 end;
719 --
720 -- When in validation only mode raise the Validate_Enabled exception
721 --
722 if p_validate then
723 raise hr_api.validate_enabled;
724 end if;
725 --
726 hr_utility.set_location(' Leaving:'||l_proc, 11);
727 exception
728 when hr_api.validate_enabled then
729 --
730 -- As the Validate_Enabled exception has been raised
731 -- we must rollback to the savepoint
732 --
733 ROLLBACK TO delete_elp_extra_info;
734 --
735 hr_utility.set_location(' Leaving:'||l_proc, 12);
736 --
737 when others then
738 --
739 -- A validation or unexpected error has occurred
740 --
741 -- Added as part of the fix to bug 632479
742 --
743 ROLLBACK TO delete_elp_extra_info;
744 --
745 raise;
746 --
747 end delete_elp_extra_info;
748 --
749 end ben_elp_extra_info_api;