[Home] [Help]
PACKAGE BODY: APPS.HR_POSITION_EXTRA_INFO_API
Source
1 Package Body hr_position_extra_info_api as
2 /* $Header: pepoiapi.pkb 115.3 2002/12/11 10:32:22 eumenyio ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hr_position_extra_info_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |----------------------< create_position_extra_info >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_position_extra_info
13 (p_validate in boolean default false
14 ,p_position_id in number
15 ,p_information_type in varchar2
16 ,p_poei_attribute_category in varchar2 default null
17 ,p_poei_attribute1 in varchar2 default null
18 ,p_poei_attribute2 in varchar2 default null
19 ,p_poei_attribute3 in varchar2 default null
20 ,p_poei_attribute4 in varchar2 default null
21 ,p_poei_attribute5 in varchar2 default null
22 ,p_poei_attribute6 in varchar2 default null
23 ,p_poei_attribute7 in varchar2 default null
24 ,p_poei_attribute8 in varchar2 default null
25 ,p_poei_attribute9 in varchar2 default null
26 ,p_poei_attribute10 in varchar2 default null
27 ,p_poei_attribute11 in varchar2 default null
28 ,p_poei_attribute12 in varchar2 default null
29 ,p_poei_attribute13 in varchar2 default null
30 ,p_poei_attribute14 in varchar2 default null
31 ,p_poei_attribute15 in varchar2 default null
32 ,p_poei_attribute16 in varchar2 default null
33 ,p_poei_attribute17 in varchar2 default null
34 ,p_poei_attribute18 in varchar2 default null
35 ,p_poei_attribute19 in varchar2 default null
36 ,p_poei_attribute20 in varchar2 default null
37 ,p_poei_information_category in varchar2 default null
38 ,p_poei_information1 in varchar2 default null
39 ,p_poei_information2 in varchar2 default null
40 ,p_poei_information3 in varchar2 default null
41 ,p_poei_information4 in varchar2 default null
42 ,p_poei_information5 in varchar2 default null
43 ,p_poei_information6 in varchar2 default null
44 ,p_poei_information7 in varchar2 default null
45 ,p_poei_information8 in varchar2 default null
46 ,p_poei_information9 in varchar2 default null
47 ,p_poei_information10 in varchar2 default null
48 ,p_poei_information11 in varchar2 default null
49 ,p_poei_information12 in varchar2 default null
50 ,p_poei_information13 in varchar2 default null
51 ,p_poei_information14 in varchar2 default null
52 ,p_poei_information15 in varchar2 default null
53 ,p_poei_information16 in varchar2 default null
54 ,p_poei_information17 in varchar2 default null
55 ,p_poei_information18 in varchar2 default null
56 ,p_poei_information19 in varchar2 default null
57 ,p_poei_information20 in varchar2 default null
58 ,p_poei_information21 in varchar2 default null
59 ,p_poei_information22 in varchar2 default null
60 ,p_poei_information23 in varchar2 default null
61 ,p_poei_information24 in varchar2 default null
62 ,p_poei_information25 in varchar2 default null
63 ,p_poei_information26 in varchar2 default null
64 ,p_poei_information27 in varchar2 default null
65 ,p_poei_information28 in varchar2 default null
66 ,p_poei_information29 in varchar2 default null
67 ,p_poei_information30 in varchar2 default null
68 ,p_position_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_position_extra_info';
75 l_object_version_number per_position_extra_info.object_version_number%type;
76 l_position_extra_info_id per_position_extra_info.position_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_position_extra_info;
84 --
85 -- Call Before Process User Hook
86 --
87 begin
88 hr_position_extra_info_bk1.create_position_extra_info_b
89 (
90 p_position_id => p_position_id,
91 p_information_type => p_information_type,
92 p_poei_attribute_category => p_poei_attribute_category,
93 p_poei_attribute1 => p_poei_attribute1,
94 p_poei_attribute2 => p_poei_attribute2,
95 p_poei_attribute3 => p_poei_attribute3,
96 p_poei_attribute4 => p_poei_attribute4,
97 p_poei_attribute5 => p_poei_attribute5,
98 p_poei_attribute6 => p_poei_attribute6,
99 p_poei_attribute7 => p_poei_attribute7,
100 p_poei_attribute8 => p_poei_attribute8,
101 p_poei_attribute9 => p_poei_attribute9,
102 p_poei_attribute10 => p_poei_attribute10,
103 p_poei_attribute11 => p_poei_attribute11,
104 p_poei_attribute12 => p_poei_attribute12,
105 p_poei_attribute13 => p_poei_attribute13,
106 p_poei_attribute14 => p_poei_attribute14,
107 p_poei_attribute15 => p_poei_attribute15,
108 p_poei_attribute16 => p_poei_attribute16,
109 p_poei_attribute17 => p_poei_attribute17,
110 p_poei_attribute18 => p_poei_attribute18,
111 p_poei_attribute19 => p_poei_attribute19,
112 p_poei_attribute20 => p_poei_attribute20,
113 p_poei_information_category => p_poei_information_category,
114 p_poei_information1 => p_poei_information1,
115 p_poei_information2 => p_poei_information2,
116 p_poei_information3 => p_poei_information3,
117 p_poei_information4 => p_poei_information4,
118 p_poei_information5 => p_poei_information5,
119 p_poei_information6 => p_poei_information6,
120 p_poei_information7 => p_poei_information7,
121 p_poei_information8 => p_poei_information8,
122 p_poei_information9 => p_poei_information9,
123 p_poei_information10 => p_poei_information10,
124 p_poei_information11 => p_poei_information11,
125 p_poei_information12 => p_poei_information12,
126 p_poei_information13 => p_poei_information13,
127 p_poei_information14 => p_poei_information14,
128 p_poei_information15 => p_poei_information15,
129 p_poei_information16 => p_poei_information16,
130 p_poei_information17 => p_poei_information17,
131 p_poei_information18 => p_poei_information18,
132 p_poei_information19 => p_poei_information19,
133 p_poei_information20 => p_poei_information20,
134 p_poei_information21 => p_poei_information21,
135 p_poei_information22 => p_poei_information22,
136 p_poei_information23 => p_poei_information23,
137 p_poei_information24 => p_poei_information24,
138 p_poei_information25 => p_poei_information25,
139 p_poei_information26 => p_poei_information26,
140 p_poei_information27 => p_poei_information27,
141 p_poei_information28 => p_poei_information28,
142 p_poei_information29 => p_poei_information29,
143 p_poei_information30 => p_poei_information30
144 );
145 exception
146 when hr_api.cannot_find_prog_unit then
147 hr_api.cannot_find_prog_unit_error
148 (p_module_name => 'create_location_extra_info',
149 p_hook_type => 'BP'
150 );
151 end;
152 --
153 -- End of Before Process User Hook call
154 --
155 --
156 hr_utility.set_location(l_proc, 7);
157 --
158 -- Process Logic
159 --
160 pe_poi_ins.ins
161 (p_position_extra_info_id => l_position_extra_info_id
162 ,p_position_id => p_position_id
163 ,p_information_type => p_information_type
164 ,p_poei_attribute_category => p_poei_attribute_category
165 ,p_poei_attribute1 => p_poei_attribute1
166 ,p_poei_attribute2 => p_poei_attribute2
167 ,p_poei_attribute3 => p_poei_attribute3
168 ,p_poei_attribute4 => p_poei_attribute4
169 ,p_poei_attribute5 => p_poei_attribute5
170 ,p_poei_attribute6 => p_poei_attribute6
171 ,p_poei_attribute7 => p_poei_attribute7
172 ,p_poei_attribute8 => p_poei_attribute8
173 ,p_poei_attribute9 => p_poei_attribute9
174 ,p_poei_attribute10 => p_poei_attribute10
175 ,p_poei_attribute11 => p_poei_attribute11
176 ,p_poei_attribute12 => p_poei_attribute12
177 ,p_poei_attribute13 => p_poei_attribute13
178 ,p_poei_attribute14 => p_poei_attribute14
179 ,p_poei_attribute15 => p_poei_attribute15
180 ,p_poei_attribute16 => p_poei_attribute16
181 ,p_poei_attribute17 => p_poei_attribute17
182 ,p_poei_attribute18 => p_poei_attribute18
183 ,p_poei_attribute19 => p_poei_attribute19
184 ,p_poei_attribute20 => p_poei_attribute20
185 ,p_poei_information_category => p_poei_information_category
186 ,p_poei_information1 => p_poei_information1
187 ,p_poei_information2 => p_poei_information2
188 ,p_poei_information3 => p_poei_information3
189 ,p_poei_information4 => p_poei_information4
190 ,p_poei_information5 => p_poei_information5
191 ,p_poei_information6 => p_poei_information6
192 ,p_poei_information7 => p_poei_information7
193 ,p_poei_information8 => p_poei_information8
194 ,p_poei_information9 => p_poei_information9
195 ,p_poei_information10 => p_poei_information10
196 ,p_poei_information11 => p_poei_information11
197 ,p_poei_information12 => p_poei_information12
198 ,p_poei_information13 => p_poei_information13
199 ,p_poei_information14 => p_poei_information14
200 ,p_poei_information15 => p_poei_information15
201 ,p_poei_information16 => p_poei_information16
202 ,p_poei_information17 => p_poei_information17
203 ,p_poei_information18 => p_poei_information18
204 ,p_poei_information19 => p_poei_information19
205 ,p_poei_information20 => p_poei_information20
206 ,p_poei_information21 => p_poei_information21
207 ,p_poei_information22 => p_poei_information22
208 ,p_poei_information23 => p_poei_information23
209 ,p_poei_information24 => p_poei_information24
210 ,p_poei_information25 => p_poei_information25
211 ,p_poei_information26 => p_poei_information26
212 ,p_poei_information27 => p_poei_information27
213 ,p_poei_information28 => p_poei_information28
214 ,p_poei_information29 => p_poei_information29
215 ,p_poei_information30 => p_poei_information30
216 ,p_object_version_number => l_object_version_number
217 ,p_validate => false
218 );
219 p_object_version_number := l_object_version_number;
220 p_position_extra_info_id := l_position_extra_info_id;
221 --
222 hr_utility.set_location(l_proc, 8);
223 -- Call After Process User Hook
224 --
225 begin
226 hr_position_extra_info_bk1.create_position_extra_info_a
227 (
228 p_position_extra_info_id => l_position_extra_info_id,
229 p_object_version_number => l_object_version_number,
230 p_position_id => p_position_id,
231 p_information_type => p_information_type,
232 p_poei_attribute_category => p_poei_attribute_category,
233 p_poei_attribute1 => p_poei_attribute1,
234 p_poei_attribute2 => p_poei_attribute2,
235 p_poei_attribute3 => p_poei_attribute3,
236 p_poei_attribute4 => p_poei_attribute4,
237 p_poei_attribute5 => p_poei_attribute5,
238 p_poei_attribute6 => p_poei_attribute6,
239 p_poei_attribute7 => p_poei_attribute7,
240 p_poei_attribute8 => p_poei_attribute8,
241 p_poei_attribute9 => p_poei_attribute9,
242 p_poei_attribute10 => p_poei_attribute10,
243 p_poei_attribute11 => p_poei_attribute11,
244 p_poei_attribute12 => p_poei_attribute12,
245 p_poei_attribute13 => p_poei_attribute13,
246 p_poei_attribute14 => p_poei_attribute14,
247 p_poei_attribute15 => p_poei_attribute15,
248 p_poei_attribute16 => p_poei_attribute16,
249 p_poei_attribute17 => p_poei_attribute17,
250 p_poei_attribute18 => p_poei_attribute18,
251 p_poei_attribute19 => p_poei_attribute19,
252 p_poei_attribute20 => p_poei_attribute20,
253 p_poei_information_category => p_poei_information_category,
254 p_poei_information1 => p_poei_information1,
255 p_poei_information2 => p_poei_information2,
256 p_poei_information3 => p_poei_information3,
257 p_poei_information4 => p_poei_information4,
258 p_poei_information5 => p_poei_information5,
259 p_poei_information6 => p_poei_information6,
260 p_poei_information7 => p_poei_information7,
261 p_poei_information8 => p_poei_information8,
262 p_poei_information9 => p_poei_information9,
263 p_poei_information10 => p_poei_information10,
264 p_poei_information11 => p_poei_information11,
265 p_poei_information12 => p_poei_information12,
266 p_poei_information13 => p_poei_information13,
267 p_poei_information14 => p_poei_information14,
268 p_poei_information15 => p_poei_information15,
269 p_poei_information16 => p_poei_information16,
270 p_poei_information17 => p_poei_information17,
271 p_poei_information18 => p_poei_information18,
272 p_poei_information19 => p_poei_information19,
273 p_poei_information20 => p_poei_information20,
274 p_poei_information21 => p_poei_information21,
275 p_poei_information22 => p_poei_information22,
276 p_poei_information23 => p_poei_information23,
277 p_poei_information24 => p_poei_information24,
278 p_poei_information25 => p_poei_information25,
279 p_poei_information26 => p_poei_information26,
280 p_poei_information27 => p_poei_information27,
281 p_poei_information28 => p_poei_information28,
282 p_poei_information29 => p_poei_information29,
283 p_poei_information30 => p_poei_information30
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_position_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_position_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_position_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 p_position_extra_info_id := null;
324 p_object_version_number := null;
325 ROLLBACK TO create_position_extra_info;
326 --
327 raise;
328 --
329 end create_position_extra_info;
330 --
331 -- ----------------------------------------------------------------------------
332 -- |----------------------< update_position_extra_info >----------------------|
333 -- ----------------------------------------------------------------------------
334 --
335 procedure update_position_extra_info
336 (p_validate in boolean default false
337 ,p_position_extra_info_id in number
338 ,p_object_version_number in out nocopy number
342 ,p_poei_attribute3 in varchar2 default hr_api.g_varchar2
339 ,p_poei_attribute_category in varchar2 default hr_api.g_varchar2
340 ,p_poei_attribute1 in varchar2 default hr_api.g_varchar2
341 ,p_poei_attribute2 in varchar2 default hr_api.g_varchar2
343 ,p_poei_attribute4 in varchar2 default hr_api.g_varchar2
344 ,p_poei_attribute5 in varchar2 default hr_api.g_varchar2
345 ,p_poei_attribute6 in varchar2 default hr_api.g_varchar2
346 ,p_poei_attribute7 in varchar2 default hr_api.g_varchar2
347 ,p_poei_attribute8 in varchar2 default hr_api.g_varchar2
348 ,p_poei_attribute9 in varchar2 default hr_api.g_varchar2
349 ,p_poei_attribute10 in varchar2 default hr_api.g_varchar2
350 ,p_poei_attribute11 in varchar2 default hr_api.g_varchar2
351 ,p_poei_attribute12 in varchar2 default hr_api.g_varchar2
352 ,p_poei_attribute13 in varchar2 default hr_api.g_varchar2
353 ,p_poei_attribute14 in varchar2 default hr_api.g_varchar2
354 ,p_poei_attribute15 in varchar2 default hr_api.g_varchar2
355 ,p_poei_attribute16 in varchar2 default hr_api.g_varchar2
356 ,p_poei_attribute17 in varchar2 default hr_api.g_varchar2
357 ,p_poei_attribute18 in varchar2 default hr_api.g_varchar2
358 ,p_poei_attribute19 in varchar2 default hr_api.g_varchar2
359 ,p_poei_attribute20 in varchar2 default hr_api.g_varchar2
360 ,p_poei_information_category in varchar2 default hr_api.g_varchar2
361 ,p_poei_information1 in varchar2 default hr_api.g_varchar2
362 ,p_poei_information2 in varchar2 default hr_api.g_varchar2
363 ,p_poei_information3 in varchar2 default hr_api.g_varchar2
364 ,p_poei_information4 in varchar2 default hr_api.g_varchar2
365 ,p_poei_information5 in varchar2 default hr_api.g_varchar2
366 ,p_poei_information6 in varchar2 default hr_api.g_varchar2
367 ,p_poei_information7 in varchar2 default hr_api.g_varchar2
368 ,p_poei_information8 in varchar2 default hr_api.g_varchar2
369 ,p_poei_information9 in varchar2 default hr_api.g_varchar2
370 ,p_poei_information10 in varchar2 default hr_api.g_varchar2
371 ,p_poei_information11 in varchar2 default hr_api.g_varchar2
372 ,p_poei_information12 in varchar2 default hr_api.g_varchar2
373 ,p_poei_information13 in varchar2 default hr_api.g_varchar2
374 ,p_poei_information14 in varchar2 default hr_api.g_varchar2
375 ,p_poei_information15 in varchar2 default hr_api.g_varchar2
376 ,p_poei_information16 in varchar2 default hr_api.g_varchar2
377 ,p_poei_information17 in varchar2 default hr_api.g_varchar2
378 ,p_poei_information18 in varchar2 default hr_api.g_varchar2
379 ,p_poei_information19 in varchar2 default hr_api.g_varchar2
380 ,p_poei_information20 in varchar2 default hr_api.g_varchar2
381 ,p_poei_information21 in varchar2 default hr_api.g_varchar2
382 ,p_poei_information22 in varchar2 default hr_api.g_varchar2
383 ,p_poei_information23 in varchar2 default hr_api.g_varchar2
384 ,p_poei_information24 in varchar2 default hr_api.g_varchar2
385 ,p_poei_information25 in varchar2 default hr_api.g_varchar2
386 ,p_poei_information26 in varchar2 default hr_api.g_varchar2
387 ,p_poei_information27 in varchar2 default hr_api.g_varchar2
388 ,p_poei_information28 in varchar2 default hr_api.g_varchar2
389 ,p_poei_information29 in varchar2 default hr_api.g_varchar2
390 ,p_poei_information30 in varchar2 default hr_api.g_varchar2
391 ) is
392 --
393 -- Declare cursors and local variables
394 --
398 --
395 l_proc varchar2(72) := g_package||'update_position_extra_info';
396 l_object_version_number per_position_extra_info.object_version_number%TYPE;
397 l_temp_ovn number := p_object_version_number;
399 begin
400 hr_utility.set_location('Entering:'|| l_proc, 5);
401 --
402 -- Issue a savepoint
403 --
404 savepoint update_position_extra_info;
405 --
406 -- Call Before Process User Hook
407 --
408 begin
409 hr_position_extra_info_bk2.update_position_extra_info_b
410 (
411 p_position_extra_info_id => p_position_extra_info_id,
412 p_poei_attribute_category => p_poei_attribute_category,
413 p_poei_attribute1 => p_poei_attribute1,
414 p_poei_attribute2 => p_poei_attribute2,
415 p_poei_attribute3 => p_poei_attribute3,
416 p_poei_attribute4 => p_poei_attribute4,
417 p_poei_attribute5 => p_poei_attribute5,
418 p_poei_attribute6 => p_poei_attribute6,
419 p_poei_attribute7 => p_poei_attribute7,
420 p_poei_attribute8 => p_poei_attribute8,
421 p_poei_attribute9 => p_poei_attribute9,
422 p_poei_attribute10 => p_poei_attribute10,
423 p_poei_attribute11 => p_poei_attribute11,
424 p_poei_attribute12 => p_poei_attribute12,
425 p_poei_attribute13 => p_poei_attribute13,
426 p_poei_attribute14 => p_poei_attribute14,
427 p_poei_attribute15 => p_poei_attribute15,
428 p_poei_attribute16 => p_poei_attribute16,
429 p_poei_attribute17 => p_poei_attribute17,
430 p_poei_attribute18 => p_poei_attribute18,
431 p_poei_attribute19 => p_poei_attribute19,
432 p_poei_attribute20 => p_poei_attribute20,
433 p_poei_information_category => p_poei_information_category,
434 p_poei_information1 => p_poei_information1,
435 p_poei_information2 => p_poei_information2,
436 p_poei_information3 => p_poei_information3,
437 p_poei_information4 => p_poei_information4,
438 p_poei_information5 => p_poei_information5,
439 p_poei_information6 => p_poei_information6,
440 p_poei_information7 => p_poei_information7,
441 p_poei_information8 => p_poei_information8,
442 p_poei_information9 => p_poei_information9,
443 p_poei_information10 => p_poei_information10,
444 p_poei_information11 => p_poei_information11,
445 p_poei_information12 => p_poei_information12,
446 p_poei_information13 => p_poei_information13,
447 p_poei_information14 => p_poei_information14,
448 p_poei_information15 => p_poei_information15,
449 p_poei_information16 => p_poei_information16,
450 p_poei_information17 => p_poei_information17,
451 p_poei_information18 => p_poei_information18,
452 p_poei_information19 => p_poei_information19,
453 p_poei_information20 => p_poei_information20,
454 p_poei_information21 => p_poei_information21,
455 p_poei_information22 => p_poei_information22,
456 p_poei_information23 => p_poei_information23,
457 p_poei_information24 => p_poei_information24,
458 p_poei_information25 => p_poei_information25,
459 p_poei_information26 => p_poei_information26,
460 p_poei_information27 => p_poei_information27,
461 p_poei_information28 => p_poei_information28,
462 p_poei_information29 => p_poei_information29,
463 p_poei_information30 => p_poei_information30,
464 p_object_version_number => p_object_version_number
465 );
466 exception
470 p_hook_type => 'BP'
467 when hr_api.cannot_find_prog_unit then
468 hr_api.cannot_find_prog_unit_error
469 (p_module_name => 'update_position_extra_info',
471 );
472 end;
473 --
474 -- End of Before Process User Hook call
475 --
476 hr_utility.set_location(l_proc, 7);
477 --
478 -- Store the original ovn in case we rollback when p_validate is true
479 --
480 l_object_version_number := p_object_version_number;
481 --
482 -- Process Logic - Update Position Extra Info details
483 --
484 pe_poi_upd.upd
485 (p_position_extra_info_id => p_position_extra_info_id
486 ,p_poei_attribute_category => p_poei_attribute_category
487 ,p_poei_attribute1 => p_poei_attribute1
488 ,p_poei_attribute2 => p_poei_attribute2
489 ,p_poei_attribute3 => p_poei_attribute3
490 ,p_poei_attribute4 => p_poei_attribute4
491 ,p_poei_attribute5 => p_poei_attribute5
492 ,p_poei_attribute6 => p_poei_attribute6
493 ,p_poei_attribute7 => p_poei_attribute7
494 ,p_poei_attribute8 => p_poei_attribute8
495 ,p_poei_attribute9 => p_poei_attribute9
496 ,p_poei_attribute10 => p_poei_attribute10
497 ,p_poei_attribute11 => p_poei_attribute11
498 ,p_poei_attribute12 => p_poei_attribute12
499 ,p_poei_attribute13 => p_poei_attribute13
500 ,p_poei_attribute14 => p_poei_attribute14
501 ,p_poei_attribute15 => p_poei_attribute15
502 ,p_poei_attribute16 => p_poei_attribute16
503 ,p_poei_attribute17 => p_poei_attribute17
504 ,p_poei_attribute18 => p_poei_attribute18
505 ,p_poei_attribute19 => p_poei_attribute19
506 ,p_poei_attribute20 => p_poei_attribute20
507 ,p_poei_information_category => p_poei_information_category
508 ,p_poei_information1 => p_poei_information1
509 ,p_poei_information2 => p_poei_information2
510 ,p_poei_information3 => p_poei_information3
511 ,p_poei_information4 => p_poei_information4
512 ,p_poei_information5 => p_poei_information5
513 ,p_poei_information6 => p_poei_information6
514 ,p_poei_information7 => p_poei_information7
515 ,p_poei_information8 => p_poei_information8
516 ,p_poei_information9 => p_poei_information9
517 ,p_poei_information10 => p_poei_information10
518 ,p_poei_information11 => p_poei_information11
519 ,p_poei_information12 => p_poei_information12
520 ,p_poei_information13 => p_poei_information13
521 ,p_poei_information14 => p_poei_information14
522 ,p_poei_information15 => p_poei_information15
523 ,p_poei_information16 => p_poei_information16
524 ,p_poei_information17 => p_poei_information17
525 ,p_poei_information18 => p_poei_information18
529 ,p_poei_information22 => p_poei_information22
526 ,p_poei_information19 => p_poei_information19
527 ,p_poei_information20 => p_poei_information20
528 ,p_poei_information21 => p_poei_information21
530 ,p_poei_information23 => p_poei_information23
531 ,p_poei_information24 => p_poei_information24
532 ,p_poei_information25 => p_poei_information25
533 ,p_poei_information26 => p_poei_information26
534 ,p_poei_information27 => p_poei_information27
535 ,p_poei_information28 => p_poei_information28
536 ,p_poei_information29 => p_poei_information29
537 ,p_poei_information30 => p_poei_information30
538 ,p_object_version_number => p_object_version_number
539 ,p_validate => false
540 );
541 --
542 hr_utility.set_location(l_proc, 8);
543 --
544 -- Call After Process User Hook
545 --
546 begin
547 hr_position_extra_info_bk2.update_position_extra_info_a
548 (
549 p_position_extra_info_id => p_position_extra_info_id,
550 p_poei_attribute_category => p_poei_attribute_category,
551 p_poei_attribute1 => p_poei_attribute1,
552 p_poei_attribute2 => p_poei_attribute2,
553 p_poei_attribute3 => p_poei_attribute3,
554 p_poei_attribute4 => p_poei_attribute4,
555 p_poei_attribute5 => p_poei_attribute5,
556 p_poei_attribute6 => p_poei_attribute6,
557 p_poei_attribute7 => p_poei_attribute7,
558 p_poei_attribute8 => p_poei_attribute8,
559 p_poei_attribute9 => p_poei_attribute9,
560 p_poei_attribute10 => p_poei_attribute10,
561 p_poei_attribute11 => p_poei_attribute11,
562 p_poei_attribute12 => p_poei_attribute12,
563 p_poei_attribute13 => p_poei_attribute13,
564 p_poei_attribute14 => p_poei_attribute14,
565 p_poei_attribute15 => p_poei_attribute15,
566 p_poei_attribute16 => p_poei_attribute16,
567 p_poei_attribute17 => p_poei_attribute17,
568 p_poei_attribute18 => p_poei_attribute18,
569 p_poei_attribute19 => p_poei_attribute19,
570 p_poei_attribute20 => p_poei_attribute20,
571 p_poei_information_category => p_poei_information_category,
572 p_poei_information1 => p_poei_information1,
573 p_poei_information2 => p_poei_information2,
574 p_poei_information3 => p_poei_information3,
575 p_poei_information4 => p_poei_information4,
576 p_poei_information5 => p_poei_information5,
577 p_poei_information6 => p_poei_information6,
578 p_poei_information7 => p_poei_information7,
579 p_poei_information8 => p_poei_information8,
580 p_poei_information9 => p_poei_information9,
581 p_poei_information10 => p_poei_information10,
582 p_poei_information11 => p_poei_information11,
583 p_poei_information12 => p_poei_information12,
584 p_poei_information13 => p_poei_information13,
585 p_poei_information14 => p_poei_information14,
586 p_poei_information15 => p_poei_information15,
587 p_poei_information16 => p_poei_information16,
588 p_poei_information17 => p_poei_information17,
589 p_poei_information18 => p_poei_information18,
590 p_poei_information19 => p_poei_information19,
591 p_poei_information20 => p_poei_information20,
592 p_poei_information21 => p_poei_information21,
593 p_poei_information22 => p_poei_information22,
594 p_poei_information23 => p_poei_information23,
595 p_poei_information24 => p_poei_information24,
596 p_poei_information25 => p_poei_information25,
597 p_poei_information26 => p_poei_information26,
598 p_poei_information27 => p_poei_information27,
599 p_poei_information28 => p_poei_information28,
600 p_poei_information29 => p_poei_information29,
601 p_poei_information30 => p_poei_information30,
602 p_object_version_number => p_object_version_number
603 );
604 exception
605 when hr_api.cannot_find_prog_unit then
606 hr_api.cannot_find_prog_unit_error
607 (p_module_name => 'update_position_extra_info',
608 p_hook_type => 'AP'
609 );
610 end;
611 --
612 --
613 -- When in validation only mode raise the Validate_Enabled exception
614 --
615 if p_validate then
616 raise hr_api.validate_enabled;
617 end if;
618 --
619 hr_utility.set_location(' Leaving:'||l_proc, 11);
620 exception
621 when hr_api.validate_enabled then
622 --
623 -- As the Validate_Enabled exception has been raised
624 -- we must rollback to the savepoint
625 --
626 ROLLBACK TO update_position_extra_info;
627 --
628 -- Only set output warning arguments
629 -- (Any key or derived arguments must be set to null
630 -- when validation only mode is being used.)
631 --
632 p_object_version_number := l_object_version_number;
633 --
634 hr_utility.set_location(' Leaving:'||l_proc, 12);
635 --
636 when others then
637 --
638 -- A validation or unexpected error has occurred
639 --
640 -- Added as part of the fix to bug 632479
641 --
642 p_object_version_number := l_temp_ovn;
643 ROLLBACK TO update_position_extra_info;
644 --
645 raise;
646 --
647 end update_position_extra_info;
648 --
649 --
650 -- ----------------------------------------------------------------------------
651 -- |----------------------< delete_position_extra_info >----------------------|
652 -- ----------------------------------------------------------------------------
653 --
654 procedure delete_position_extra_info
655 (p_validate in boolean default false
656 ,p_position_extra_info_id in number
657 ,p_object_version_number in number
658 ) is
659 --
660 -- Declare cursors and local variables
661 --
662 l_proc varchar2(72) := g_package||'delete_position_extra_info';
663 --
664 begin
665 hr_utility.set_location('Entering:'|| l_proc, 5);
666 --
667 -- Issue a savepoint
668 --
669 savepoint delete_position_extra_info;
670 --
671 -- Call Before Process User Hook
672 --
673 begin
674 hr_position_extra_info_bk3.delete_position_extra_info_b
675 (
676 p_position_extra_info_id => p_position_extra_info_id,
677 p_object_version_number => p_object_version_number
678 );
679 exception
680 when hr_api.cannot_find_prog_unit then
681 hr_api.cannot_find_prog_unit_error
682 (p_module_name => 'delete_position_extra_info',
683 p_hook_type => 'BP'
684 );
685 end;
686 --
687 -- End of Before Process User Hook call
688 --
689 hr_utility.set_location(l_proc, 7);
690 --
691 -- Process Logic - Delete Position Extra Info details
692 --
693 pe_poi_del.del
694 (p_position_extra_info_id => p_position_extra_info_id
695 ,p_object_version_number => p_object_version_number
696 ,p_validate => false
697 );
698 --
699 hr_utility.set_location(l_proc, 8);
700 --
701 -- Call After Process User Hook
702 --
703 begin
704 hr_position_extra_info_bk3.delete_position_extra_info_a
705 (
706 p_position_extra_info_id => p_position_extra_info_id,
707 p_object_version_number => p_object_version_number
708 );
709 exception
710 when hr_api.cannot_find_prog_unit then
711 hr_api.cannot_find_prog_unit_error
712 (p_module_name => 'delete_position_extra_info',
713 p_hook_type => 'AP'
714 );
715 end;
716 --
717 -- When in validation only mode raise the Validate_Enabled exception
718 --
719 if p_validate then
720 raise hr_api.validate_enabled;
721 end if;
722 --
723 hr_utility.set_location(' Leaving:'||l_proc, 11);
724 exception
725 when hr_api.validate_enabled then
726 --
727 -- As the Validate_Enabled exception has been raised
728 -- we must rollback to the savepoint
729 --
730 ROLLBACK TO delete_position_extra_info;
731 --
732 hr_utility.set_location(' Leaving:'||l_proc, 12);
733 --
734 when others then
735 --
736 -- A validation or unexpected error has occurred
737 --
738 -- Added as part of the fix to bug 632479
739 --
740 ROLLBACK TO delete_position_extra_info;
741 --
742 raise;
743 --
744 end delete_position_extra_info;
745 --
746 end hr_position_extra_info_api;