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