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