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