[Home] [Help]
PACKAGE BODY: APPS.HR_PERSON_EXTRA_INFO_API
Source
1 Package Body hr_person_extra_info_api as
2 /* $Header: pepeiapi.pkb 115.6 2002/12/11 13:53:50 pkakar ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hr_person_extra_info_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-----------------------< create_person_extra_info >------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_person_extra_info
13 (p_validate in boolean default false
14 ,p_person_id in number
15 ,p_information_type in varchar2
16 ,p_pei_attribute_category in varchar2 default null
17 ,p_pei_attribute1 in varchar2 default null
18 ,p_pei_attribute2 in varchar2 default null
19 ,p_pei_attribute3 in varchar2 default null
20 ,p_pei_attribute4 in varchar2 default null
21 ,p_pei_attribute5 in varchar2 default null
22 ,p_pei_attribute6 in varchar2 default null
23 ,p_pei_attribute7 in varchar2 default null
24 ,p_pei_attribute8 in varchar2 default null
25 ,p_pei_attribute9 in varchar2 default null
26 ,p_pei_attribute10 in varchar2 default null
27 ,p_pei_attribute11 in varchar2 default null
28 ,p_pei_attribute12 in varchar2 default null
29 ,p_pei_attribute13 in varchar2 default null
30 ,p_pei_attribute14 in varchar2 default null
31 ,p_pei_attribute15 in varchar2 default null
32 ,p_pei_attribute16 in varchar2 default null
33 ,p_pei_attribute17 in varchar2 default null
34 ,p_pei_attribute18 in varchar2 default null
35 ,p_pei_attribute19 in varchar2 default null
36 ,p_pei_attribute20 in varchar2 default null
37 ,p_pei_information_category in varchar2 default null
38 ,p_pei_information1 in varchar2 default null
39 ,p_pei_information2 in varchar2 default null
40 ,p_pei_information3 in varchar2 default null
41 ,p_pei_information4 in varchar2 default null
42 ,p_pei_information5 in varchar2 default null
43 ,p_pei_information6 in varchar2 default null
44 ,p_pei_information7 in varchar2 default null
45 ,p_pei_information8 in varchar2 default null
46 ,p_pei_information9 in varchar2 default null
47 ,p_pei_information10 in varchar2 default null
48 ,p_pei_information11 in varchar2 default null
49 ,p_pei_information12 in varchar2 default null
50 ,p_pei_information13 in varchar2 default null
51 ,p_pei_information14 in varchar2 default null
52 ,p_pei_information15 in varchar2 default null
53 ,p_pei_information16 in varchar2 default null
54 ,p_pei_information17 in varchar2 default null
55 ,p_pei_information18 in varchar2 default null
56 ,p_pei_information19 in varchar2 default null
57 ,p_pei_information20 in varchar2 default null
58 ,p_pei_information21 in varchar2 default null
59 ,p_pei_information22 in varchar2 default null
60 ,p_pei_information23 in varchar2 default null
61 ,p_pei_information24 in varchar2 default null
62 ,p_pei_information25 in varchar2 default null
63 ,p_pei_information26 in varchar2 default null
64 ,p_pei_information27 in varchar2 default null
65 ,p_pei_information28 in varchar2 default null
66 ,p_pei_information29 in varchar2 default null
67 ,p_pei_information30 in varchar2 default null
68 ,p_person_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_person_extra_info';
75 l_object_version_number per_people_extra_info.object_version_number%type;
76 l_person_extra_info_id per_people_extra_info.person_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_person_extra_info;
84 --
85 -- Call Before Process User Hook
86 --
87 begin
88 hr_person_extra_info_bk1.create_person_extra_info_b
89 (p_person_id => p_person_id,
90 p_information_type => p_information_type,
91 p_pei_attribute_category => p_pei_attribute_category,
92 p_pei_attribute1 => p_pei_attribute1,
93 p_pei_attribute2 => p_pei_attribute2,
94 p_pei_attribute3 => p_pei_attribute3,
95 p_pei_attribute4 => p_pei_attribute4,
96 p_pei_attribute5 => p_pei_attribute5,
97 p_pei_attribute6 => p_pei_attribute6,
98 p_pei_attribute7 => p_pei_attribute7,
99 p_pei_attribute8 => p_pei_attribute8,
100 p_pei_attribute9 => p_pei_attribute9,
101 p_pei_attribute10 => p_pei_attribute10,
102 p_pei_attribute11 => p_pei_attribute11,
103 p_pei_attribute12 => p_pei_attribute12,
104 p_pei_attribute13 => p_pei_attribute13,
105 p_pei_attribute14 => p_pei_attribute14,
106 p_pei_attribute15 => p_pei_attribute15,
107 p_pei_attribute16 => p_pei_attribute16,
108 p_pei_attribute17 => p_pei_attribute17,
109 p_pei_attribute18 => p_pei_attribute18,
110 p_pei_attribute19 => p_pei_attribute19,
111 p_pei_attribute20 => p_pei_attribute20,
112 p_pei_information_category => p_pei_information_category,
113 p_pei_information1 => p_pei_information1,
114 p_pei_information2 => p_pei_information2,
115 p_pei_information3 => p_pei_information3,
116 p_pei_information4 => p_pei_information4,
117 p_pei_information5 => p_pei_information5,
118 p_pei_information6 => p_pei_information6,
119 p_pei_information7 => p_pei_information7,
120 p_pei_information8 => p_pei_information8,
121 p_pei_information9 => p_pei_information9,
122 p_pei_information10 => p_pei_information10,
123 p_pei_information11 => p_pei_information11,
124 p_pei_information12 => p_pei_information12,
125 p_pei_information13 => p_pei_information13,
126 p_pei_information14 => p_pei_information14,
127 p_pei_information15 => p_pei_information15,
128 p_pei_information16 => p_pei_information16,
129 p_pei_information17 => p_pei_information17,
130 p_pei_information18 => p_pei_information18,
131 p_pei_information19 => p_pei_information19,
132 p_pei_information20 => p_pei_information20,
133 p_pei_information21 => p_pei_information21,
134 p_pei_information22 => p_pei_information22,
135 p_pei_information23 => p_pei_information23,
136 p_pei_information24 => p_pei_information24,
137 p_pei_information25 => p_pei_information25,
138 p_pei_information26 => p_pei_information26,
139 p_pei_information27 => p_pei_information27,
140 p_pei_information28 => p_pei_information28,
141 p_pei_information29 => p_pei_information29,
142 p_pei_information30 => p_pei_information30
143 );
144 exception
145 when hr_api.cannot_find_prog_unit then
146 hr_api.cannot_find_prog_unit_error
147 (p_module_name => 'CREATE_PERSON_EXTRA_INFO',
148 p_hook_type => 'BP'
149 );
150 end;
151 --
152 -- End of Before Process User Hook call
153 --
154 hr_utility.set_location(l_proc, 7);
155 --
156 -- Process Logic
157 --
158 pe_pei_ins.ins
159 (p_person_extra_info_id => l_person_extra_info_id
160 ,p_person_id => p_person_id
161 ,p_information_type => p_information_type
162 ,p_pei_attribute_category => p_pei_attribute_category
163 ,p_pei_attribute1 => p_pei_attribute1
164 ,p_pei_attribute2 => p_pei_attribute2
165 ,p_pei_attribute3 => p_pei_attribute3
166 ,p_pei_attribute4 => p_pei_attribute4
167 ,p_pei_attribute5 => p_pei_attribute5
168 ,p_pei_attribute6 => p_pei_attribute6
169 ,p_pei_attribute7 => p_pei_attribute7
170 ,p_pei_attribute8 => p_pei_attribute8
171 ,p_pei_attribute9 => p_pei_attribute9
172 ,p_pei_attribute10 => p_pei_attribute10
173 ,p_pei_attribute11 => p_pei_attribute11
174 ,p_pei_attribute12 => p_pei_attribute12
175 ,p_pei_attribute13 => p_pei_attribute13
176 ,p_pei_attribute14 => p_pei_attribute14
177 ,p_pei_attribute15 => p_pei_attribute15
178 ,p_pei_attribute16 => p_pei_attribute16
179 ,p_pei_attribute17 => p_pei_attribute17
180 ,p_pei_attribute18 => p_pei_attribute18
181 ,p_pei_attribute19 => p_pei_attribute19
182 ,p_pei_attribute20 => p_pei_attribute20
183 ,p_pei_information_category => p_pei_information_category
184 ,p_pei_information1 => p_pei_information1
185 ,p_pei_information2 => p_pei_information2
186 ,p_pei_information3 => p_pei_information3
187 ,p_pei_information4 => p_pei_information4
188 ,p_pei_information5 => p_pei_information5
189 ,p_pei_information6 => p_pei_information6
190 ,p_pei_information7 => p_pei_information7
191 ,p_pei_information8 => p_pei_information8
192 ,p_pei_information9 => p_pei_information9
193 ,p_pei_information10 => p_pei_information10
194 ,p_pei_information11 => p_pei_information11
195 ,p_pei_information12 => p_pei_information12
196 ,p_pei_information13 => p_pei_information13
197 ,p_pei_information14 => p_pei_information14
198 ,p_pei_information15 => p_pei_information15
199 ,p_pei_information16 => p_pei_information16
200 ,p_pei_information17 => p_pei_information17
201 ,p_pei_information18 => p_pei_information18
202 ,p_pei_information19 => p_pei_information19
203 ,p_pei_information20 => p_pei_information20
204 ,p_pei_information21 => p_pei_information21
205 ,p_pei_information22 => p_pei_information22
206 ,p_pei_information23 => p_pei_information23
207 ,p_pei_information24 => p_pei_information24
208 ,p_pei_information25 => p_pei_information25
209 ,p_pei_information26 => p_pei_information26
210 ,p_pei_information27 => p_pei_information27
211 ,p_pei_information28 => p_pei_information28
212 ,p_pei_information29 => p_pei_information29
213 ,p_pei_information30 => p_pei_information30
214 ,p_object_version_number => l_object_version_number
215 ,p_validate => false
216 );
217 p_object_version_number := l_object_version_number;
218 p_person_extra_info_id := l_person_extra_info_id;
219 --
220 hr_utility.set_location(l_proc, 8);
221 --
222 -- Call After Process User Hook
223 --
224 begin
225 hr_person_extra_info_bk1.create_person_extra_info_a
226 (p_person_extra_info_id => l_person_extra_info_id,
227 p_person_id => p_person_id,
228 p_information_type => p_information_type,
229 p_pei_attribute_category => p_pei_attribute_category,
230 p_pei_attribute1 => p_pei_attribute1,
231 p_pei_attribute2 => p_pei_attribute2,
232 p_pei_attribute3 => p_pei_attribute3,
233 p_pei_attribute4 => p_pei_attribute4,
234 p_pei_attribute5 => p_pei_attribute5,
235 p_pei_attribute6 => p_pei_attribute6,
236 p_pei_attribute7 => p_pei_attribute7,
237 p_pei_attribute8 => p_pei_attribute8,
238 p_pei_attribute9 => p_pei_attribute9,
239 p_pei_attribute10 => p_pei_attribute10,
240 p_pei_attribute11 => p_pei_attribute11,
241 p_pei_attribute12 => p_pei_attribute12,
242 p_pei_attribute13 => p_pei_attribute13,
243 p_pei_attribute14 => p_pei_attribute14,
244 p_pei_attribute15 => p_pei_attribute15,
245 p_pei_attribute16 => p_pei_attribute16,
246 p_pei_attribute17 => p_pei_attribute17,
247 p_pei_attribute18 => p_pei_attribute18,
248 p_pei_attribute19 => p_pei_attribute19,
249 p_pei_attribute20 => p_pei_attribute20,
250 p_pei_information_category => p_pei_information_category,
251 p_pei_information1 => p_pei_information1,
252 p_pei_information2 => p_pei_information2,
253 p_pei_information3 => p_pei_information3,
254 p_pei_information4 => p_pei_information4,
255 p_pei_information5 => p_pei_information5,
256 p_pei_information6 => p_pei_information6,
257 p_pei_information7 => p_pei_information7,
258 p_pei_information8 => p_pei_information8,
259 p_pei_information9 => p_pei_information9,
260 p_pei_information10 => p_pei_information10,
261 p_pei_information11 => p_pei_information11,
262 p_pei_information12 => p_pei_information12,
263 p_pei_information13 => p_pei_information13,
264 p_pei_information14 => p_pei_information14,
265 p_pei_information15 => p_pei_information15,
266 p_pei_information16 => p_pei_information16,
267 p_pei_information17 => p_pei_information17,
268 p_pei_information18 => p_pei_information18,
269 p_pei_information19 => p_pei_information19,
270 p_pei_information20 => p_pei_information20,
271 p_pei_information21 => p_pei_information21,
272 p_pei_information22 => p_pei_information22,
273 p_pei_information23 => p_pei_information23,
274 p_pei_information24 => p_pei_information24,
275 p_pei_information25 => p_pei_information25,
276 p_pei_information26 => p_pei_information26,
277 p_pei_information27 => p_pei_information27,
278 p_pei_information28 => p_pei_information28,
279 p_pei_information29 => p_pei_information29,
280 p_pei_information30 => p_pei_information30,
281 p_object_version_number => l_object_version_number
282 );
283 exception
284 when hr_api.cannot_find_prog_unit then
285 hr_api.cannot_find_prog_unit_error
286 (p_module_name => 'CREATE_PERSON_EXTRA_INFO',
287 p_hook_type => 'AP'
288 );
289 end;
290 --
291 -- End of After Process User Hook call
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_person_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_person_extra_info_id := null;
313 p_object_version_number := null;
317 when others then
314 --
315 hr_utility.set_location(' Leaving:'||l_proc, 12);
316 --
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_person_extra_info;
324 --
325 -- set in out parameters and set out parameters
326 --
327 p_person_extra_info_id := null;
328 p_object_version_number := null;
329 --
330 raise;
331 --
332 end create_person_extra_info;
333 --
334 -- ----------------------------------------------------------------------------
335 -- |-----------------------< update_person_extra_info >------------------------|
336 -- ----------------------------------------------------------------------------
337 --
338 procedure update_person_extra_info
339 (p_validate in boolean default false
340 ,p_person_extra_info_id in number
341 ,p_object_version_number in out nocopy number
342 ,p_pei_attribute_category in varchar2 default hr_api.g_varchar2
343 ,p_pei_attribute1 in varchar2 default hr_api.g_varchar2
344 ,p_pei_attribute2 in varchar2 default hr_api.g_varchar2
345 ,p_pei_attribute3 in varchar2 default hr_api.g_varchar2
346 ,p_pei_attribute4 in varchar2 default hr_api.g_varchar2
347 ,p_pei_attribute5 in varchar2 default hr_api.g_varchar2
348 ,p_pei_attribute6 in varchar2 default hr_api.g_varchar2
349 ,p_pei_attribute7 in varchar2 default hr_api.g_varchar2
350 ,p_pei_attribute8 in varchar2 default hr_api.g_varchar2
351 ,p_pei_attribute9 in varchar2 default hr_api.g_varchar2
352 ,p_pei_attribute10 in varchar2 default hr_api.g_varchar2
353 ,p_pei_attribute11 in varchar2 default hr_api.g_varchar2
354 ,p_pei_attribute12 in varchar2 default hr_api.g_varchar2
355 ,p_pei_attribute13 in varchar2 default hr_api.g_varchar2
356 ,p_pei_attribute14 in varchar2 default hr_api.g_varchar2
357 ,p_pei_attribute15 in varchar2 default hr_api.g_varchar2
358 ,p_pei_attribute16 in varchar2 default hr_api.g_varchar2
359 ,p_pei_attribute17 in varchar2 default hr_api.g_varchar2
360 ,p_pei_attribute18 in varchar2 default hr_api.g_varchar2
361 ,p_pei_attribute19 in varchar2 default hr_api.g_varchar2
362 ,p_pei_attribute20 in varchar2 default hr_api.g_varchar2
363 ,p_pei_information_category in varchar2 default hr_api.g_varchar2
364 ,p_pei_information1 in varchar2 default hr_api.g_varchar2
365 ,p_pei_information2 in varchar2 default hr_api.g_varchar2
366 ,p_pei_information3 in varchar2 default hr_api.g_varchar2
367 ,p_pei_information4 in varchar2 default hr_api.g_varchar2
368 ,p_pei_information5 in varchar2 default hr_api.g_varchar2
369 ,p_pei_information6 in varchar2 default hr_api.g_varchar2
370 ,p_pei_information7 in varchar2 default hr_api.g_varchar2
371 ,p_pei_information8 in varchar2 default hr_api.g_varchar2
372 ,p_pei_information9 in varchar2 default hr_api.g_varchar2
373 ,p_pei_information10 in varchar2 default hr_api.g_varchar2
374 ,p_pei_information11 in varchar2 default hr_api.g_varchar2
375 ,p_pei_information12 in varchar2 default hr_api.g_varchar2
376 ,p_pei_information13 in varchar2 default hr_api.g_varchar2
377 ,p_pei_information14 in varchar2 default hr_api.g_varchar2
378 ,p_pei_information15 in varchar2 default hr_api.g_varchar2
379 ,p_pei_information16 in varchar2 default hr_api.g_varchar2
380 ,p_pei_information17 in varchar2 default hr_api.g_varchar2
381 ,p_pei_information18 in varchar2 default hr_api.g_varchar2
382 ,p_pei_information19 in varchar2 default hr_api.g_varchar2
383 ,p_pei_information20 in varchar2 default hr_api.g_varchar2
384 ,p_pei_information21 in varchar2 default hr_api.g_varchar2
385 ,p_pei_information22 in varchar2 default hr_api.g_varchar2
386 ,p_pei_information23 in varchar2 default hr_api.g_varchar2
387 ,p_pei_information24 in varchar2 default hr_api.g_varchar2
388 ,p_pei_information25 in varchar2 default hr_api.g_varchar2
389 ,p_pei_information26 in varchar2 default hr_api.g_varchar2
390 ,p_pei_information27 in varchar2 default hr_api.g_varchar2
391 ,p_pei_information28 in varchar2 default hr_api.g_varchar2
392 ,p_pei_information29 in varchar2 default hr_api.g_varchar2
393 ,p_pei_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_person_extra_info';
399 l_object_version_number per_phones.object_version_number%TYPE;
400 l_ovn per_phones.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_person_extra_info;
408 --
409 -- Call Before Process User Hook
410 --
411 begin
415 p_pei_attribute1 => p_pei_attribute1,
412 hr_person_extra_info_bk2.update_person_extra_info_b
413 (p_person_extra_info_id => p_person_extra_info_id,
414 p_pei_attribute_category => p_pei_attribute_category,
416 p_pei_attribute2 => p_pei_attribute2,
417 p_pei_attribute3 => p_pei_attribute3,
418 p_pei_attribute4 => p_pei_attribute4,
419 p_pei_attribute5 => p_pei_attribute5,
420 p_pei_attribute6 => p_pei_attribute6,
421 p_pei_attribute7 => p_pei_attribute7,
422 p_pei_attribute8 => p_pei_attribute8,
423 p_pei_attribute9 => p_pei_attribute9,
424 p_pei_attribute10 => p_pei_attribute10,
425 p_pei_attribute11 => p_pei_attribute11,
426 p_pei_attribute12 => p_pei_attribute12,
427 p_pei_attribute13 => p_pei_attribute13,
428 p_pei_attribute14 => p_pei_attribute14,
429 p_pei_attribute15 => p_pei_attribute15,
430 p_pei_attribute16 => p_pei_attribute16,
431 p_pei_attribute17 => p_pei_attribute17,
432 p_pei_attribute18 => p_pei_attribute18,
433 p_pei_attribute19 => p_pei_attribute19,
434 p_pei_attribute20 => p_pei_attribute20,
435 p_pei_information_category => p_pei_information_category,
436 p_pei_information1 => p_pei_information1,
437 p_pei_information2 => p_pei_information2,
438 p_pei_information3 => p_pei_information3,
439 p_pei_information4 => p_pei_information4,
440 p_pei_information5 => p_pei_information5,
441 p_pei_information6 => p_pei_information6,
442 p_pei_information7 => p_pei_information7,
443 p_pei_information8 => p_pei_information8,
444 p_pei_information9 => p_pei_information9,
445 p_pei_information10 => p_pei_information10,
446 p_pei_information11 => p_pei_information11,
447 p_pei_information12 => p_pei_information12,
448 p_pei_information13 => p_pei_information13,
449 p_pei_information14 => p_pei_information14,
450 p_pei_information15 => p_pei_information15,
451 p_pei_information16 => p_pei_information16,
452 p_pei_information17 => p_pei_information17,
453 p_pei_information18 => p_pei_information18,
454 p_pei_information19 => p_pei_information19,
455 p_pei_information20 => p_pei_information20,
456 p_pei_information21 => p_pei_information21,
457 p_pei_information22 => p_pei_information22,
458 p_pei_information23 => p_pei_information23,
459 p_pei_information24 => p_pei_information24,
460 p_pei_information25 => p_pei_information25,
461 p_pei_information26 => p_pei_information26,
462 p_pei_information27 => p_pei_information27,
463 p_pei_information28 => p_pei_information28,
464 p_pei_information29 => p_pei_information29,
465 p_pei_information30 => p_pei_information30,
466 p_object_version_number => p_object_version_number
467 );
468 exception
469 when hr_api.cannot_find_prog_unit then
470 hr_api.cannot_find_prog_unit_error
471 (p_module_name => 'UPDATE_PERSON_EXTRA_INFO',
472 p_hook_type => 'BP'
473 );
474 end;
475 --
476 -- End of Before Process User Hook call
477 --
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 Person Extra Info details
486 --
487 pe_pei_upd.upd
488 (p_person_extra_info_id => p_person_extra_info_id
489 ,p_pei_attribute_category => p_pei_attribute_category
490 ,p_pei_attribute1 => p_pei_attribute1
491 ,p_pei_attribute2 => p_pei_attribute2
492 ,p_pei_attribute3 => p_pei_attribute3
493 ,p_pei_attribute4 => p_pei_attribute4
494 ,p_pei_attribute5 => p_pei_attribute5
495 ,p_pei_attribute6 => p_pei_attribute6
496 ,p_pei_attribute7 => p_pei_attribute7
497 ,p_pei_attribute8 => p_pei_attribute8
498 ,p_pei_attribute9 => p_pei_attribute9
499 ,p_pei_attribute10 => p_pei_attribute10
500 ,p_pei_attribute11 => p_pei_attribute11
501 ,p_pei_attribute12 => p_pei_attribute12
502 ,p_pei_attribute13 => p_pei_attribute13
503 ,p_pei_attribute14 => p_pei_attribute14
504 ,p_pei_attribute15 => p_pei_attribute15
505 ,p_pei_attribute16 => p_pei_attribute16
506 ,p_pei_attribute17 => p_pei_attribute17
507 ,p_pei_attribute18 => p_pei_attribute18
508 ,p_pei_attribute19 => p_pei_attribute19
509 ,p_pei_attribute20 => p_pei_attribute20
510 ,p_pei_information_category => p_pei_information_category
511 ,p_pei_information1 => p_pei_information1
512 ,p_pei_information2 => p_pei_information2
513 ,p_pei_information3 => p_pei_information3
514 ,p_pei_information4 => p_pei_information4
518 ,p_pei_information8 => p_pei_information8
515 ,p_pei_information5 => p_pei_information5
516 ,p_pei_information6 => p_pei_information6
517 ,p_pei_information7 => p_pei_information7
519 ,p_pei_information9 => p_pei_information9
520 ,p_pei_information10 => p_pei_information10
521 ,p_pei_information11 => p_pei_information11
522 ,p_pei_information12 => p_pei_information12
523 ,p_pei_information13 => p_pei_information13
524 ,p_pei_information14 => p_pei_information14
525 ,p_pei_information15 => p_pei_information15
526 ,p_pei_information16 => p_pei_information16
527 ,p_pei_information17 => p_pei_information17
528 ,p_pei_information18 => p_pei_information18
529 ,p_pei_information19 => p_pei_information19
530 ,p_pei_information20 => p_pei_information20
531 ,p_pei_information21 => p_pei_information21
532 ,p_pei_information22 => p_pei_information22
533 ,p_pei_information23 => p_pei_information23
534 ,p_pei_information24 => p_pei_information24
535 ,p_pei_information25 => p_pei_information25
536 ,p_pei_information26 => p_pei_information26
537 ,p_pei_information27 => p_pei_information27
538 ,p_pei_information28 => p_pei_information28
539 ,p_pei_information29 => p_pei_information29
540 ,p_pei_information30 => p_pei_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
550 hr_person_extra_info_bk2.update_person_extra_info_a
551 (p_person_extra_info_id => p_person_extra_info_id,
552 p_pei_attribute_category => p_pei_attribute_category,
553 p_pei_attribute1 => p_pei_attribute1,
554 p_pei_attribute2 => p_pei_attribute2,
555 p_pei_attribute3 => p_pei_attribute3,
556 p_pei_attribute4 => p_pei_attribute4,
557 p_pei_attribute5 => p_pei_attribute5,
558 p_pei_attribute6 => p_pei_attribute6,
559 p_pei_attribute7 => p_pei_attribute7,
560 p_pei_attribute8 => p_pei_attribute8,
561 p_pei_attribute9 => p_pei_attribute9,
562 p_pei_attribute10 => p_pei_attribute10,
563 p_pei_attribute11 => p_pei_attribute11,
564 p_pei_attribute12 => p_pei_attribute12,
565 p_pei_attribute13 => p_pei_attribute13,
566 p_pei_attribute14 => p_pei_attribute14,
567 p_pei_attribute15 => p_pei_attribute15,
568 p_pei_attribute16 => p_pei_attribute16,
569 p_pei_attribute17 => p_pei_attribute17,
570 p_pei_attribute18 => p_pei_attribute18,
571 p_pei_attribute19 => p_pei_attribute19,
572 p_pei_attribute20 => p_pei_attribute20,
573 p_pei_information_category => p_pei_information_category,
574 p_pei_information1 => p_pei_information1,
575 p_pei_information2 => p_pei_information2,
576 p_pei_information3 => p_pei_information3,
577 p_pei_information4 => p_pei_information4,
578 p_pei_information5 => p_pei_information5,
579 p_pei_information6 => p_pei_information6,
580 p_pei_information7 => p_pei_information7,
581 p_pei_information8 => p_pei_information8,
582 p_pei_information9 => p_pei_information9,
583 p_pei_information10 => p_pei_information10,
584 p_pei_information11 => p_pei_information11,
585 p_pei_information12 => p_pei_information12,
586 p_pei_information13 => p_pei_information13,
587 p_pei_information14 => p_pei_information14,
588 p_pei_information15 => p_pei_information15,
589 p_pei_information16 => p_pei_information16,
590 p_pei_information17 => p_pei_information17,
591 p_pei_information18 => p_pei_information18,
592 p_pei_information19 => p_pei_information19,
593 p_pei_information20 => p_pei_information20,
594 p_pei_information21 => p_pei_information21,
595 p_pei_information22 => p_pei_information22,
596 p_pei_information23 => p_pei_information23,
597 p_pei_information24 => p_pei_information24,
598 p_pei_information25 => p_pei_information25,
599 p_pei_information26 => p_pei_information26,
600 p_pei_information27 => p_pei_information27,
601 p_pei_information28 => p_pei_information28,
602 p_pei_information29 => p_pei_information29,
603 p_pei_information30 => p_pei_information30,
604 p_object_version_number => p_object_version_number
605 );
606 exception
607 when hr_api.cannot_find_prog_unit then
608 hr_api.cannot_find_prog_unit_error
609 (p_module_name => 'UPDATE_PERSON_EXTRA_INFO',
610 p_hook_type => 'AP'
611 );
612 end;
613 --
614 -- End of After Process User Hook call
615 --
616 -- When in validation only mode raise the Validate_Enabled exception
617 --
621 --
618 if p_validate then
619 raise hr_api.validate_enabled;
620 end if;
622 hr_utility.set_location(' Leaving:'||l_proc, 11);
623 exception
624 when hr_api.validate_enabled then
625 --
626 -- As the Validate_Enabled exception has been raised
627 -- we must rollback to the savepoint
628 --
629 ROLLBACK TO update_person_extra_info;
630 --
631 -- Only set output warning arguments
632 -- (Any key or derived arguments must be set to null
633 -- when validation only mode is being used.)
634 --
635 p_object_version_number := l_object_version_number;
636 --
637 hr_utility.set_location(' Leaving:'||l_proc, 12);
638 --
639 when others then
640 --
641 -- A validation or unexpected error has occurred
642 --
643 -- Added as part of the fix to bug 632479
644 --
645 ROLLBACK TO update_person_extra_info;
646 --
647 -- set in out parameters and set out parameters
648 --
649 p_object_version_number := l_ovn;
650 --
651 raise;
652 --
653 end update_person_extra_info;
654 --
655 --
656 -- ----------------------------------------------------------------------------
657 -- |-----------------------< delete_person_extra_info >------------------------|
658 -- ----------------------------------------------------------------------------
659 --
660 procedure delete_person_extra_info
661 (p_validate in boolean default false
662 ,p_person_extra_info_id in number
663 ,p_object_version_number in number
664 ) is
665 --
666 -- Declare cursors and local variables
667 --
668 l_proc varchar2(72) := g_package||'delete_person_extra_info';
669 --
670 begin
671 hr_utility.set_location('Entering:'|| l_proc, 5);
672 --
673 -- Issue a savepoint
674 --
675 savepoint delete_person_extra_info;
676 --
677 -- Call Before Process User Hook
678 --
679 begin
680 hr_person_extra_info_bk3.delete_person_extra_info_b
681 (p_person_extra_info_id => p_person_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_PERSON_EXTRA_INFO',
688 p_hook_type => 'BP'
689 );
690 end;
691 --
692 -- End of Before Process User Hook call
693 --
694 hr_utility.set_location(l_proc, 7);
695 --
696 -- Process Logic - Delete Person Extra Info details
697 --
698 pe_pei_del.del
699 (p_person_extra_info_id => p_person_extra_info_id
700 ,p_object_version_number => p_object_version_number
701 ,p_validate => false
702 );
703 --
704 hr_utility.set_location(l_proc, 8);
705 --
706 -- Call Before Process User Hook
707 --
708 begin
709 hr_person_extra_info_bk3.delete_person_extra_info_a
710 (p_person_extra_info_id => p_person_extra_info_id,
711 p_object_version_number => p_object_version_number
712 );
713 exception
714 when hr_api.cannot_find_prog_unit then
715 hr_api.cannot_find_prog_unit_error
716 (p_module_name => 'DELETE_PERSON_EXTRA_INFO',
717 p_hook_type => 'AP'
718 );
719 end;
720 --
721 -- End of After Process User Hook call
722 --
723 -- When in validation only mode raise the Validate_Enabled exception
724 --
725 if p_validate then
726 raise hr_api.validate_enabled;
727 end if;
728 --
729 hr_utility.set_location(' Leaving:'||l_proc, 11);
730 exception
731 when hr_api.validate_enabled then
732 --
733 -- As the Validate_Enabled exception has been raised
734 -- we must rollback to the savepoint
735 --
736 ROLLBACK TO delete_person_extra_info;
737 --
738 hr_utility.set_location(' Leaving:'||l_proc, 12);
739 --
740 when others then
741 --
742 -- A validation or unexpected error has occurred
743 --
744 -- Added as part of the fix to bug 632479
745 --
746 ROLLBACK TO delete_person_extra_info;
747 --
748 raise;
749 --
750 end delete_person_extra_info;
751 --
752 end hr_person_extra_info_api;