[Home] [Help]
PACKAGE BODY: APPS.PQP_VEH_ALLOC_EXTRA_INFO_API
Source
1 Package Body PQP_VEH_ALLOC_EXTRA_INFO_API as
2 /* $Header: pqvaiapi.pkb 120.0.12010000.2 2008/08/08 07:17:43 ubhat ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' PQP_VEH_ALLOC_EXTRA_INFO_API.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |--------------------< CREATE_VEH_ALLOC_EXTRA_INFO >--------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_veh_alloc_extra_info
13 (p_validate in boolean default false
14 ,p_vehicle_allocation_id in number
15 ,p_information_type in varchar2
16 ,p_vaei_attribute_category in varchar2
17 ,p_vaei_attribute1 in varchar2
18 ,p_vaei_attribute2 in varchar2
19 ,p_vaei_attribute3 in varchar2
20 ,p_vaei_attribute4 in varchar2
21 ,p_vaei_attribute5 in varchar2
22 ,p_vaei_attribute6 in varchar2
23 ,p_vaei_attribute7 in varchar2
24 ,p_vaei_attribute8 in varchar2
25 ,p_vaei_attribute9 in varchar2
26 ,p_vaei_attribute10 in varchar2
27 ,p_vaei_attribute11 in varchar2
28 ,p_vaei_attribute12 in varchar2
29 ,p_vaei_attribute13 in varchar2
30 ,p_vaei_attribute14 in varchar2
31 ,p_vaei_attribute15 in varchar2
32 ,p_vaei_attribute16 in varchar2
33 ,p_vaei_attribute17 in varchar2
34 ,p_vaei_attribute18 in varchar2
35 ,p_vaei_attribute19 in varchar2
36 ,p_vaei_attribute20 in varchar2
37 ,p_vaei_information_category in varchar2
38 ,p_vaei_information1 in varchar2
39 ,p_vaei_information2 in varchar2
40 ,p_vaei_information3 in varchar2
41 ,p_vaei_information4 in varchar2
42 ,p_vaei_information5 in varchar2
43 ,p_vaei_information6 in varchar2
44 ,p_vaei_information7 in varchar2
45 ,p_vaei_information8 in varchar2
46 ,p_vaei_information9 in varchar2
47 ,p_vaei_information10 in varchar2
48 ,p_vaei_information11 in varchar2
49 ,p_vaei_information12 in varchar2
50 ,p_vaei_information13 in varchar2
51 ,p_vaei_information14 in varchar2
52 ,p_vaei_information15 in varchar2
53 ,p_vaei_information16 in varchar2
54 ,p_vaei_information17 in varchar2
55 ,p_vaei_information18 in varchar2
56 ,p_vaei_information19 in varchar2
57 ,p_vaei_information20 in varchar2
58 ,p_vaei_information21 in varchar2
59 ,p_vaei_information22 in varchar2
60 ,p_vaei_information23 in varchar2
61 ,p_vaei_information24 in varchar2
62 ,p_vaei_information25 in varchar2
63 ,p_vaei_information26 in varchar2
64 ,p_vaei_information27 in varchar2
65 ,p_vaei_information28 in varchar2
66 ,p_vaei_information29 in varchar2
67 ,p_vaei_information30 in varchar2
68 ,p_request_id in number
69 ,p_program_application_id in number
70 ,p_program_id in number
71 ,p_program_update_date in date
72 ,p_veh_alloc_extra_info_id out nocopy number
73 ,p_object_version_number out nocopy number
74 )
75 IS
76 --
77 -- Declare cursors and local variables
78 --
79 l_in_out_parameter number;
80 l_effective_date date;
81 l_proc varchar2(72) := g_package||'CREATE_VEH_ALLOC_EXTRA_INFO';
82 begin
83 hr_utility.set_location('Entering:'|| l_proc, 10);
84 --
85 -- Issue a savepoint
86 --
87 savepoint CREATE_VEH_ALLOC_EXTRA_INFO;
88 --
89 -- Remember IN OUT parameter IN values
90 --
91
92 --
93 -- Truncate the time portion from all IN date parameters
94 --
95
96 --
97 -- Call Before Process User Hook
98 --
99 begin
100 pqp_veh_alloc_extra_info_bk1.create_veh_alloc_extra_info_b
101 ( p_vehicle_allocation_id =>p_vehicle_allocation_id
102 ,p_information_type =>p_information_type
103 ,p_vaei_attribute_category =>p_vaei_attribute_category
104 ,p_vaei_attribute1 =>p_vaei_attribute1
105 ,p_vaei_attribute2 =>p_vaei_attribute2
106 ,p_vaei_attribute3 =>p_vaei_attribute3
107 ,p_vaei_attribute4 =>p_vaei_attribute4
108 ,p_vaei_attribute5 =>p_vaei_attribute5
109 ,p_vaei_attribute6 =>p_vaei_attribute6
110 ,p_vaei_attribute7 =>p_vaei_attribute7
111 ,p_vaei_attribute8 =>p_vaei_attribute8
112 ,p_vaei_attribute9 =>p_vaei_attribute9
113 ,p_vaei_attribute10 =>p_vaei_attribute10
114 ,p_vaei_attribute11 =>p_vaei_attribute11
115 ,p_vaei_attribute12 =>p_vaei_attribute12
116 ,p_vaei_attribute13 =>p_vaei_attribute13
117 ,p_vaei_attribute14 =>p_vaei_attribute14
118 ,p_vaei_attribute15 =>p_vaei_attribute15
119 ,p_vaei_attribute16 =>p_vaei_attribute16
120 ,p_vaei_attribute17 =>p_vaei_attribute17
121 ,p_vaei_attribute18 =>p_vaei_attribute18
122 ,p_vaei_attribute19 =>p_vaei_attribute19
123 ,p_vaei_attribute20 =>p_vaei_attribute20
124 ,p_vaei_information_category =>p_vaei_information_category
125 ,p_vaei_information1 =>p_vaei_information1
126 ,p_vaei_information2 =>p_vaei_information2
127 ,p_vaei_information3 =>p_vaei_information3
128 ,p_vaei_information4 =>p_vaei_information4
129 ,p_vaei_information5 =>p_vaei_information5
130 ,p_vaei_information6 =>p_vaei_information6
131 ,p_vaei_information7 =>p_vaei_information7
132 ,p_vaei_information8 =>p_vaei_information8
133 ,p_vaei_information9 =>p_vaei_information9
134 ,p_vaei_information10 =>p_vaei_information10
135 ,p_vaei_information11 =>p_vaei_information11
136 ,p_vaei_information12 =>p_vaei_information12
137 ,p_vaei_information13 =>p_vaei_information13
138 ,p_vaei_information14 =>p_vaei_information14
139 ,p_vaei_information15 =>p_vaei_information15
140 ,p_vaei_information16 =>p_vaei_information16
141 ,p_vaei_information17 =>p_vaei_information17
142 ,p_vaei_information18 =>p_vaei_information18
143 ,p_vaei_information19 =>p_vaei_information19
144 ,p_vaei_information20 =>p_vaei_information20
145 ,p_vaei_information21 =>p_vaei_information21
146 ,p_vaei_information22 =>p_vaei_information22
147 ,p_vaei_information23 =>p_vaei_information23
148 ,p_vaei_information24 =>p_vaei_information24
149 ,p_vaei_information25 =>p_vaei_information25
150 ,p_vaei_information26 =>p_vaei_information26
151 ,p_vaei_information27 =>p_vaei_information27
152 ,p_vaei_information28 =>p_vaei_information28
153 ,p_vaei_information29 =>p_vaei_information29
154 ,p_vaei_information30 =>p_vaei_information30
155 ,p_request_id =>p_request_id
156 ,p_program_application_id =>p_program_application_id
157 ,p_program_id =>p_program_id
158 ,p_program_update_date =>p_program_update_date
159 );
160 exception
161 when hr_api.cannot_find_prog_unit then
162 hr_api.cannot_find_prog_unit_error
163 (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
164 ,p_hook_type => 'BP'
165 );
166 end;
167 --
168 -- Validation in addition to Row Handlers
169 --
170
171 hr_utility.set_location('Entering row handler:'|| p_vaei_information9, 10);
172 pqp_vai_ins.ins
173 ( p_vehicle_allocation_id =>p_vehicle_allocation_id
174 ,p_information_type =>p_information_type
175 ,p_vaei_attribute_category =>p_vaei_attribute_category
176 ,p_vaei_attribute1 =>p_vaei_attribute1
177 ,p_vaei_attribute2 =>p_vaei_attribute2
178 ,p_vaei_attribute3 =>p_vaei_attribute3
179 ,p_vaei_attribute4 =>p_vaei_attribute4
180 ,p_vaei_attribute5 =>p_vaei_attribute5
181 ,p_vaei_attribute6 =>p_vaei_attribute6
182 ,p_vaei_attribute7 =>p_vaei_attribute7
183 ,p_vaei_attribute8 =>p_vaei_attribute8
184 ,p_vaei_attribute9 =>p_vaei_attribute9
185 ,p_vaei_attribute10 =>p_vaei_attribute10
186 ,p_vaei_attribute11 =>p_vaei_attribute11
187 ,p_vaei_attribute12 =>p_vaei_attribute12
188 ,p_vaei_attribute13 =>p_vaei_attribute13
189 ,p_vaei_attribute14 =>p_vaei_attribute14
190 ,p_vaei_attribute15 =>p_vaei_attribute15
191 ,p_vaei_attribute16 =>p_vaei_attribute16
192 ,p_vaei_attribute17 =>p_vaei_attribute17
193 ,p_vaei_attribute18 =>p_vaei_attribute18
194 ,p_vaei_attribute19 =>p_vaei_attribute19
195 ,p_vaei_attribute20 =>p_vaei_attribute20
196 ,p_vaei_information_category =>p_vaei_information_category
197 ,p_vaei_information1 =>p_vaei_information1
198 ,p_vaei_information2 =>p_vaei_information2
199 ,p_vaei_information3 =>p_vaei_information3
200 ,p_vaei_information4 =>p_vaei_information4
201 ,p_vaei_information5 =>p_vaei_information5
202 ,p_vaei_information6 =>p_vaei_information6
203 ,p_vaei_information7 =>p_vaei_information7
204 ,p_vaei_information8 =>p_vaei_information8
205 ,p_vaei_information9 =>p_vaei_information9
206 ,p_vaei_information10 =>p_vaei_information10
207 ,p_vaei_information11 =>p_vaei_information11
208 ,p_vaei_information12 =>p_vaei_information12
209 ,p_vaei_information13 =>p_vaei_information13
210 ,p_vaei_information14 =>p_vaei_information14
211 ,p_vaei_information15 =>p_vaei_information15
212 ,p_vaei_information16 =>p_vaei_information16
213 ,p_vaei_information17 =>p_vaei_information17
214 ,p_vaei_information18 =>p_vaei_information18
215 ,p_vaei_information19 =>p_vaei_information19
216 ,p_vaei_information20 =>p_vaei_information20
217 ,p_vaei_information21 =>p_vaei_information21
218 ,p_vaei_information22 =>p_vaei_information22
219 ,p_vaei_information23 =>p_vaei_information23
220 ,p_vaei_information24 =>p_vaei_information24
221 ,p_vaei_information25 =>p_vaei_information25
222 ,p_vaei_information26 =>p_vaei_information26
223 ,p_vaei_information27 =>p_vaei_information27
224 ,p_vaei_information28 =>p_vaei_information28
225 ,p_vaei_information29 =>p_vaei_information29
226 ,p_vaei_information30 =>p_vaei_information30
227 ,p_request_id =>p_request_id
228 ,p_program_application_id =>p_program_application_id
229 ,p_program_id =>p_program_id
230 ,p_program_update_date =>p_program_update_date
231 ,p_veh_alloc_extra_info_id =>p_veh_alloc_extra_info_id
232 ,p_object_version_number =>p_object_version_number
233 );
234 --
235 -- Process Logic
236 --
237
238
239
240 --
241 -- Call After Process User Hook
242 --
243 begin
244 pqp_veh_alloc_extra_info_bk1.create_veh_alloc_extra_info_a
245 ( p_vehicle_allocation_id =>p_vehicle_allocation_id
246 ,p_information_type =>p_information_type
247 ,p_vaei_attribute_category =>p_vaei_attribute_category
248 ,p_vaei_attribute1 =>p_vaei_attribute1
249 ,p_vaei_attribute2 =>p_vaei_attribute2
250 ,p_vaei_attribute3 =>p_vaei_attribute3
251 ,p_vaei_attribute4 =>p_vaei_attribute4
252 ,p_vaei_attribute5 =>p_vaei_attribute5
253 ,p_vaei_attribute6 =>p_vaei_attribute6
254 ,p_vaei_attribute7 =>p_vaei_attribute7
255 ,p_vaei_attribute8 =>p_vaei_attribute8
256 ,p_vaei_attribute9 =>p_vaei_attribute9
257 ,p_vaei_attribute10 =>p_vaei_attribute10
258 ,p_vaei_attribute11 =>p_vaei_attribute11
259 ,p_vaei_attribute12 =>p_vaei_attribute12
260 ,p_vaei_attribute13 =>p_vaei_attribute13
261 ,p_vaei_attribute14 =>p_vaei_attribute14
262 ,p_vaei_attribute15 =>p_vaei_attribute15
263 ,p_vaei_attribute16 =>p_vaei_attribute16
264 ,p_vaei_attribute17 =>p_vaei_attribute17
265 ,p_vaei_attribute18 =>p_vaei_attribute18
266 ,p_vaei_attribute19 =>p_vaei_attribute19
267 ,p_vaei_attribute20 =>p_vaei_attribute20
268 ,p_vaei_information_category =>p_vaei_information_category
269 ,p_vaei_information1 =>p_vaei_information1
270 ,p_vaei_information2 =>p_vaei_information2
271 ,p_vaei_information3 =>p_vaei_information3
272 ,p_vaei_information4 =>p_vaei_information4
273 ,p_vaei_information5 =>p_vaei_information5
274 ,p_vaei_information6 =>p_vaei_information6
275 ,p_vaei_information7 =>p_vaei_information7
276 ,p_vaei_information8 =>p_vaei_information8
277 ,p_vaei_information9 =>p_vaei_information9
278 ,p_vaei_information10 =>p_vaei_information10
279 ,p_vaei_information11 =>p_vaei_information11
280 ,p_vaei_information12 =>p_vaei_information12
281 ,p_vaei_information13 =>p_vaei_information13
282 ,p_vaei_information14 =>p_vaei_information14
283 ,p_vaei_information15 =>p_vaei_information15
284 ,p_vaei_information16 =>p_vaei_information16
285 ,p_vaei_information17 =>p_vaei_information17
286 ,p_vaei_information18 =>p_vaei_information18
287 ,p_vaei_information19 =>p_vaei_information19
288 ,p_vaei_information20 =>p_vaei_information20
289 ,p_vaei_information21 =>p_vaei_information21
290 ,p_vaei_information22 =>p_vaei_information22
291 ,p_vaei_information23 =>p_vaei_information23
292 ,p_vaei_information24 =>p_vaei_information24
293 ,p_vaei_information25 =>p_vaei_information25
294 ,p_vaei_information26 =>p_vaei_information26
295 ,p_vaei_information27 =>p_vaei_information27
296 ,p_vaei_information28 =>p_vaei_information28
297 ,p_vaei_information29 =>p_vaei_information29
298 ,p_vaei_information30 =>p_vaei_information30
299 ,p_request_id =>p_request_id
300 ,p_program_application_id =>p_program_application_id
301 ,p_program_id =>p_program_id
302 ,p_program_update_date =>p_program_update_date
303 ,p_veh_alloc_extra_info_id =>p_veh_alloc_extra_info_id
304 ,p_object_version_number =>p_object_version_number
305 );
306 exception
307 when hr_api.cannot_find_prog_unit then
308 hr_api.cannot_find_prog_unit_error
309 (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
310 ,p_hook_type => 'AP'
311 );
312 end;
313 --
314 -- When in validation only mode raise the Validate_Enabled exception
315 --
316 if p_validate then
317 raise hr_api.validate_enabled;
318 end if;
319 --
320 -- Set all IN OUT and OUT parameters with out values
321 --
322 p_veh_alloc_extra_info_id :=p_veh_alloc_extra_info_id;
323 p_object_version_number :=p_object_version_number;
324 --
325 hr_utility.set_location(' Leaving:'||l_proc, 70);
326 exception
327 when hr_api.validate_enabled then
328 --
329 -- As the Validate_Enabled exception has been raised
330 -- we must rollback to the savepoint
331 --
332 rollback to CREATE_VEH_ALLOC_EXTRA_INFO;
333 --
334 -- Reset IN OUT parameters and set OUT parameters
335 -- (Any key or derived arguments must be set to null
336 -- when validation only mode is being used.)
337 --
338 p_veh_alloc_extra_info_id :=null;
339 p_object_version_number :=null;
340 hr_utility.set_location(' Leaving:'||l_proc, 80);
341 when others then
342 --
343 -- A validation or unexpected error has occured
344 --
345 rollback to CREATE_VEH_ALLOC_EXTRA_INFO;
346 --
347 -- Reset IN OUT parameters and set all
348 -- OUT parameters, including warnings, to null
349 --
350 p_veh_alloc_extra_info_id :=null;
351 p_object_version_number :=null;
352 hr_utility.set_location(' Leaving:'||l_proc, 90);
353 raise;
354 end create_veh_alloc_extra_info;
355
356 -- ----------------------------------------------------------------------------
357 -- |--------------------< UPDATE_VEH_ALLOC_EXTRA_INFO >--------------------|
358 -- ----------------------------------------------------------------------------
359 --
360 --
361 procedure update_veh_alloc_extra_info
362 ( p_validate in boolean
363 ,p_veh_alloc_extra_info_id in number
364 ,p_object_version_number in out nocopy number
365 ,p_vehicle_allocation_id in number
366 ,p_information_type in varchar2
367 ,p_vaei_attribute_category in varchar2
368 ,p_vaei_attribute1 in varchar2
369 ,p_vaei_attribute2 in varchar2
370 ,p_vaei_attribute3 in varchar2
371 ,p_vaei_attribute4 in varchar2
372 ,p_vaei_attribute5 in varchar2
373 ,p_vaei_attribute6 in varchar2
374 ,p_vaei_attribute7 in varchar2
375 ,p_vaei_attribute8 in varchar2
376 ,p_vaei_attribute9 in varchar2
377 ,p_vaei_attribute10 in varchar2
378 ,p_vaei_attribute11 in varchar2
379 ,p_vaei_attribute12 in varchar2
380 ,p_vaei_attribute13 in varchar2
381 ,p_vaei_attribute14 in varchar2
382 ,p_vaei_attribute15 in varchar2
383 ,p_vaei_attribute16 in varchar2
384 ,p_vaei_attribute17 in varchar2
385 ,p_vaei_attribute18 in varchar2
386 ,p_vaei_attribute19 in varchar2
387 ,p_vaei_attribute20 in varchar2
388 ,p_vaei_information_category in varchar2
389 ,p_vaei_information1 in varchar2
390 ,p_vaei_information2 in varchar2
391 ,p_vaei_information3 in varchar2
392 ,p_vaei_information4 in varchar2
393 ,p_vaei_information5 in varchar2
394 ,p_vaei_information6 in varchar2
395 ,p_vaei_information7 in varchar2
396 ,p_vaei_information8 in varchar2
397 ,p_vaei_information9 in varchar2
398 ,p_vaei_information10 in varchar2
399 ,p_vaei_information11 in varchar2
400 ,p_vaei_information12 in varchar2
401 ,p_vaei_information13 in varchar2
402 ,p_vaei_information14 in varchar2
403 ,p_vaei_information15 in varchar2
404 ,p_vaei_information16 in varchar2
405 ,p_vaei_information17 in varchar2
406 ,p_vaei_information18 in varchar2
407 ,p_vaei_information19 in varchar2
408 ,p_vaei_information20 in varchar2
409 ,p_vaei_information21 in varchar2
410 ,p_vaei_information22 in varchar2
411 ,p_vaei_information23 in varchar2
412 ,p_vaei_information24 in varchar2
413 ,p_vaei_information25 in varchar2
414 ,p_vaei_information26 in varchar2
415 ,p_vaei_information27 in varchar2
416 ,p_vaei_information28 in varchar2
417 ,p_vaei_information29 in varchar2
418 ,p_vaei_information30 in varchar2
419 ,p_request_id in number
420 ,p_program_application_id in number
421 ,p_program_id in number
422 ,p_program_update_date in date
423 )
424 is
425 l_effective_date date;
426 l_proc varchar2(72) := g_package||'UPDATE_VEH_ALLOC_EXTRA_INFO';
427 begin
428
429 hr_utility.set_location('Entering:'|| l_proc, 10);
430 --
431 -- Issue a savepoint
432 --
433 savepoint UPDATE_VEH_ALLOC_EXTRA_INFO;
434 --
435 -- Remember IN OUT parameter IN values
436 --
437
438 --
439 -- Truncate the time portion from all IN date parameters
440 --
441
442 --
443 -- Call Before Process User Hook
444 --
445 begin
446 pqp_veh_alloc_extra_info_bk2.update_veh_alloc_extra_info_b
447 ( p_veh_alloc_extra_info_id =>p_veh_alloc_extra_info_id
448 ,p_object_version_number =>p_object_version_number
449 ,p_vehicle_allocation_id =>p_vehicle_allocation_id
450 ,p_information_type =>p_information_type
451 ,p_vaei_attribute_category =>p_vaei_attribute_category
452 ,p_vaei_attribute1 =>p_vaei_attribute1
453 ,p_vaei_attribute2 =>p_vaei_attribute2
454 ,p_vaei_attribute3 =>p_vaei_attribute3
455 ,p_vaei_attribute4 =>p_vaei_attribute4
456 ,p_vaei_attribute5 =>p_vaei_attribute5
457 ,p_vaei_attribute6 =>p_vaei_attribute6
458 ,p_vaei_attribute7 =>p_vaei_attribute7
459 ,p_vaei_attribute8 =>p_vaei_attribute8
460 ,p_vaei_attribute9 =>p_vaei_attribute9
461 ,p_vaei_attribute10 =>p_vaei_attribute10
462 ,p_vaei_attribute11 =>p_vaei_attribute11
463 ,p_vaei_attribute12 =>p_vaei_attribute12
464 ,p_vaei_attribute13 =>p_vaei_attribute13
465 ,p_vaei_attribute14 =>p_vaei_attribute14
466 ,p_vaei_attribute15 =>p_vaei_attribute15
467 ,p_vaei_attribute16 =>p_vaei_attribute16
468 ,p_vaei_attribute17 =>p_vaei_attribute17
469 ,p_vaei_attribute18 =>p_vaei_attribute18
470 ,p_vaei_attribute19 =>p_vaei_attribute19
471 ,p_vaei_attribute20 =>p_vaei_attribute20
472 ,p_vaei_information_category =>p_vaei_information_category
473 ,p_vaei_information1 =>p_vaei_information1
474 ,p_vaei_information2 =>p_vaei_information2
475 ,p_vaei_information3 =>p_vaei_information3
476 ,p_vaei_information4 =>p_vaei_information4
477 ,p_vaei_information5 =>p_vaei_information5
478 ,p_vaei_information6 =>p_vaei_information6
479 ,p_vaei_information7 =>p_vaei_information7
480 ,p_vaei_information8 =>p_vaei_information8
481 ,p_vaei_information9 =>p_vaei_information9
482 ,p_vaei_information10 =>p_vaei_information10
483 ,p_vaei_information11 =>p_vaei_information11
484 ,p_vaei_information12 =>p_vaei_information12
485 ,p_vaei_information13 =>p_vaei_information13
486 ,p_vaei_information14 =>p_vaei_information14
487 ,p_vaei_information15 =>p_vaei_information15
488 ,p_vaei_information16 =>p_vaei_information16
489 ,p_vaei_information17 =>p_vaei_information17
490 ,p_vaei_information18 =>p_vaei_information18
491 ,p_vaei_information19 =>p_vaei_information19
492 ,p_vaei_information20 =>p_vaei_information20
493 ,p_vaei_information21 =>p_vaei_information21
494 ,p_vaei_information22 =>p_vaei_information22
495 ,p_vaei_information23 =>p_vaei_information23
496 ,p_vaei_information24 =>p_vaei_information24
497 ,p_vaei_information25 =>p_vaei_information25
498 ,p_vaei_information26 =>p_vaei_information26
499 ,p_vaei_information27 =>p_vaei_information27
500 ,p_vaei_information28 =>p_vaei_information28
501 ,p_vaei_information29 =>p_vaei_information29
502 ,p_vaei_information30 =>p_vaei_information30
503 ,p_request_id =>p_request_id
504 ,p_program_application_id =>p_program_application_id
505 ,p_program_id =>p_program_id
506 ,p_program_update_date =>p_program_update_date
507 );
508 exception
509 when hr_api.cannot_find_prog_unit then
510 hr_api.cannot_find_prog_unit_error
511 (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
512 ,p_hook_type => 'BP'
513 );
514 end;
515 --
516 -- Validation in addition to Row Handlers
517 --
518
519
520 pqp_vai_upd.upd
521 ( p_veh_alloc_extra_info_id =>p_veh_alloc_extra_info_id
522 ,p_object_version_number =>p_object_version_number
523 ,p_vehicle_allocation_id =>p_vehicle_allocation_id
524 ,p_information_type =>p_information_type
525 ,p_vaei_attribute_category =>p_vaei_attribute_category
526 ,p_vaei_attribute1 =>p_vaei_attribute1
527 ,p_vaei_attribute2 =>p_vaei_attribute2
528 ,p_vaei_attribute3 =>p_vaei_attribute3
529 ,p_vaei_attribute4 =>p_vaei_attribute4
530 ,p_vaei_attribute5 =>p_vaei_attribute5
531 ,p_vaei_attribute6 =>p_vaei_attribute6
532 ,p_vaei_attribute7 =>p_vaei_attribute7
533 ,p_vaei_attribute8 =>p_vaei_attribute8
534 ,p_vaei_attribute9 =>p_vaei_attribute9
535 ,p_vaei_attribute10 =>p_vaei_attribute10
536 ,p_vaei_attribute11 =>p_vaei_attribute11
537 ,p_vaei_attribute12 =>p_vaei_attribute12
538 ,p_vaei_attribute13 =>p_vaei_attribute13
539 ,p_vaei_attribute14 =>p_vaei_attribute14
540 ,p_vaei_attribute15 =>p_vaei_attribute15
541 ,p_vaei_attribute16 =>p_vaei_attribute16
542 ,p_vaei_attribute17 =>p_vaei_attribute17
543 ,p_vaei_attribute18 =>p_vaei_attribute18
544 ,p_vaei_attribute19 =>p_vaei_attribute19
545 ,p_vaei_attribute20 =>p_vaei_attribute20
546 ,p_vaei_information_category =>p_vaei_information_category
547 ,p_vaei_information1 =>p_vaei_information1
548 ,p_vaei_information2 =>p_vaei_information2
549 ,p_vaei_information3 =>p_vaei_information3
550 ,p_vaei_information4 =>p_vaei_information4
551 ,p_vaei_information5 =>p_vaei_information5
552 ,p_vaei_information6 =>p_vaei_information6
553 ,p_vaei_information7 =>p_vaei_information7
554 ,p_vaei_information8 =>p_vaei_information8
555 ,p_vaei_information9 =>p_vaei_information9
556 ,p_vaei_information10 =>p_vaei_information10
557 ,p_vaei_information11 =>p_vaei_information11
558 ,p_vaei_information12 =>p_vaei_information12
559 ,p_vaei_information13 =>p_vaei_information13
560 ,p_vaei_information14 =>p_vaei_information14
561 ,p_vaei_information15 =>p_vaei_information15
562 ,p_vaei_information16 =>p_vaei_information16
563 ,p_vaei_information17 =>p_vaei_information17
564 ,p_vaei_information18 =>p_vaei_information18
565 ,p_vaei_information19 =>p_vaei_information19
566 ,p_vaei_information20 =>p_vaei_information20
567 ,p_vaei_information21 =>p_vaei_information21
568 ,p_vaei_information22 =>p_vaei_information22
569 ,p_vaei_information23 =>p_vaei_information23
570 ,p_vaei_information24 =>p_vaei_information24
571 ,p_vaei_information25 =>p_vaei_information25
572 ,p_vaei_information26 =>p_vaei_information26
573 ,p_vaei_information27 =>p_vaei_information27
574 ,p_vaei_information28 =>p_vaei_information28
575 ,p_vaei_information29 =>p_vaei_information29
576 ,p_vaei_information30 =>p_vaei_information30
577 ,p_request_id =>p_request_id
578 ,p_program_application_id =>p_program_application_id
579 ,p_program_id =>p_program_id
580 ,p_program_update_date =>p_program_update_date
581 );
582 --
583 -- Process Logic
584 --
585
586
587
588 --
589 -- Call After Process User Hook
590 --
591 begin
592 pqp_veh_alloc_extra_info_bk2.update_veh_alloc_extra_info_a
593 ( p_veh_alloc_extra_info_id => p_veh_alloc_extra_info_id
594 ,p_object_version_number =>p_object_version_number
595 ,p_vehicle_allocation_id =>p_vehicle_allocation_id
596 ,p_information_type =>p_information_type
597 ,p_vaei_attribute_category =>p_vaei_attribute_category
598 ,p_vaei_attribute1 =>p_vaei_attribute1
599 ,p_vaei_attribute2 =>p_vaei_attribute2
600 ,p_vaei_attribute3 =>p_vaei_attribute3
601 ,p_vaei_attribute4 =>p_vaei_attribute4
602 ,p_vaei_attribute5 =>p_vaei_attribute5
603 ,p_vaei_attribute6 =>p_vaei_attribute6
604 ,p_vaei_attribute7 =>p_vaei_attribute7
605 ,p_vaei_attribute8 =>p_vaei_attribute8
606 ,p_vaei_attribute9 =>p_vaei_attribute9
607 ,p_vaei_attribute10 =>p_vaei_attribute10
608 ,p_vaei_attribute11 =>p_vaei_attribute11
609 ,p_vaei_attribute12 =>p_vaei_attribute12
610 ,p_vaei_attribute13 =>p_vaei_attribute13
611 ,p_vaei_attribute14 =>p_vaei_attribute14
612 ,p_vaei_attribute15 =>p_vaei_attribute15
613 ,p_vaei_attribute16 =>p_vaei_attribute16
614 ,p_vaei_attribute17 =>p_vaei_attribute17
615 ,p_vaei_attribute18 =>p_vaei_attribute18
616 ,p_vaei_attribute19 =>p_vaei_attribute19
617 ,p_vaei_attribute20 =>p_vaei_attribute20
618 ,p_vaei_information_category =>p_vaei_information_category
619 ,p_vaei_information1 =>p_vaei_information1
620 ,p_vaei_information2 =>p_vaei_information2
621 ,p_vaei_information3 =>p_vaei_information3
622 ,p_vaei_information4 =>p_vaei_information4
623 ,p_vaei_information5 =>p_vaei_information5
624 ,p_vaei_information6 =>p_vaei_information6
625 ,p_vaei_information7 =>p_vaei_information7
626 ,p_vaei_information8 =>p_vaei_information8
627 ,p_vaei_information9 =>p_vaei_information9
628 ,p_vaei_information10 =>p_vaei_information10
629 ,p_vaei_information11 =>p_vaei_information11
630 ,p_vaei_information12 =>p_vaei_information12
631 ,p_vaei_information13 =>p_vaei_information13
632 ,p_vaei_information14 =>p_vaei_information14
633 ,p_vaei_information15 =>p_vaei_information15
634 ,p_vaei_information16 =>p_vaei_information16
635 ,p_vaei_information17 =>p_vaei_information17
636 ,p_vaei_information18 =>p_vaei_information18
637 ,p_vaei_information19 =>p_vaei_information19
638 ,p_vaei_information20 =>p_vaei_information20
639 ,p_vaei_information21 =>p_vaei_information21
640 ,p_vaei_information22 =>p_vaei_information22
641 ,p_vaei_information23 =>p_vaei_information23
642 ,p_vaei_information24 =>p_vaei_information24
643 ,p_vaei_information25 =>p_vaei_information25
644 ,p_vaei_information26 =>p_vaei_information26
645 ,p_vaei_information27 =>p_vaei_information27
646 ,p_vaei_information28 =>p_vaei_information28
647 ,p_vaei_information29 =>p_vaei_information29
648 ,p_vaei_information30 =>p_vaei_information30
649 ,p_request_id =>p_request_id
650 ,p_program_application_id =>p_program_application_id
651 ,p_program_id =>p_program_id
652 ,p_program_update_date =>p_program_update_date
653 );
654 exception
655 when hr_api.cannot_find_prog_unit then
656 hr_api.cannot_find_prog_unit_error
657 (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
658 ,p_hook_type => 'AP'
659 );
660 end;
661 --
662 -- When in validation only mode raise the Validate_Enabled exception
663 --
664 if p_validate then
665 raise hr_api.validate_enabled;
666 end if;
667 --
668 -- Set all IN OUT and OUT parameters with out values
669 --
670 --
671 hr_utility.set_location(' Leaving:'||l_proc, 70);
672 exception
673 when hr_api.validate_enabled then
674 --
675 -- As the Validate_Enabled exception has been raised
676 -- we must rollback to the savepoint
677 --
678 rollback to UPDATE_VEH_ALLOC_EXTRA_INFO;
679 --
680 -- Reset IN OUT parameters and set OUT parameters
681 -- (Any key or derived arguments must be set to null
682 -- when validation only mode is being used.)
683 --
684 hr_utility.set_location(' Leaving:'||l_proc, 80);
685 when others then
686 --
687 -- A validation or unexpected error has occured
688 --
689 rollback to UPDATE_VEH_ALLOC_EXTRA_INFO;
690 --
691 -- Reset IN OUT parameters and set all
692 -- OUT parameters, including warnings, to null
693 --
694 hr_utility.set_location(' Leaving:'||l_proc, 90);
695 raise;
696 end update_veh_alloc_extra_info;
697 -- ----------------------------------------------------------------------------
698 -- |--------------------< DELETE_VEH_ALLOC_EXTRA_INFO >--------------------|
699 -- ----------------------------------------------------------------------------
700 --
701 --
702 procedure delete_veh_alloc_extra_info
703 ( p_validate in boolean default false
704 ,p_veh_alloc_extra_info_id in number
705 ,p_object_version_number in number
706 )
707 is
708 cursor csr_veh_id (c_veh_alloc_extra_info_id in number) is
709 select vae.vehicle_allocation_id
710 from pqp_veh_alloc_extra_info vae
711 where vae.veh_alloc_extra_info_id = c_veh_alloc_extra_info_id;
712
713 l_vehicle_allocation_id number;
714 l_effective_date date;
715 l_proc varchar2(72) := g_package||'DELETE_VEH_ALLOC_EXTRA_INFO';
716
717 begin
718
719 hr_utility.set_location('Entering:'|| l_proc, 10);
720 --
721 -- Issue a savepoint
722 --
723 savepoint delete_veh_alloc_extra_info;
724 --
725 -- Remember IN OUT parameter IN values
726 --
727
728 --
729 -- Truncate the time portion from all IN date parameters
730 --
731 open csr_veh_id(p_veh_alloc_extra_info_id);
732 fetch csr_veh_id into l_vehicle_allocation_id;
733 close csr_veh_id;
734 --
735 -- Call Before Process User Hook
736 --
737 begin
738 pqp_veh_alloc_extra_info_bk3.delete_veh_alloc_extra_info_b
739 (p_veh_alloc_extra_info_id => p_veh_alloc_extra_info_id
740 ,p_vehicle_allocation_id => l_vehicle_allocation_id
741 ,p_object_version_number =>p_object_version_number
742 );
743 exception
744 when hr_api.cannot_find_prog_unit then
745 hr_api.cannot_find_prog_unit_error
746 (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
747 ,p_hook_type => 'BP'
748 );
749 end;
750 --
751 -- Validation in addition to Row Handlers
752 --
753 pqp_vai_del.del
754 (p_veh_alloc_extra_info_id => p_veh_alloc_extra_info_id
755 ,p_object_version_number => p_object_version_number
756 );
757 --
758 -- Process Logic
759 --
760
761 --
762 -- Call After Process User Hook
763 --
764 begin
765 pqp_veh_alloc_extra_info_bk3.delete_veh_alloc_extra_info_a
766 (p_veh_alloc_extra_info_id => p_veh_alloc_extra_info_id
767 ,p_vehicle_allocation_id => l_vehicle_allocation_id
768 ,p_object_version_number =>p_object_version_number
769 );
770 exception
771 when hr_api.cannot_find_prog_unit then
772 hr_api.cannot_find_prog_unit_error
773 (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
774 ,p_hook_type => 'AP'
775 );
776 end;
777 --
778 -- When in validation only mode raise the Validate_Enabled exception
779 --
780 if p_validate then
781 raise hr_api.validate_enabled;
782 end if;
783 --
784 -- Set all IN OUT and OUT parameters with out values
785 --
786 --
787 hr_utility.set_location(' Leaving:'||l_proc, 70);
788 exception
789 when hr_api.validate_enabled then
790 --
791 -- As the Validate_Enabled exception has been raised
792 -- we must rollback to the savepoint
793 --
794 rollback to DELETE_VEH_ALLOC_EXTRA_INFO;
795 --
796 -- Reset IN OUT parameters and set OUT parameters
797 -- (Any key or derived arguments must be set to null
798 -- when validation only mode is being used.)
799 --
800 hr_utility.set_location(' Leaving:'||l_proc, 80);
801 when others then
802 --
803 -- A validation or unexpected error has occured
804 --
805 rollback to DELETE_VEH_ALLOC_EXTRA_INFO;
806 --
807 -- Reset IN OUT parameters and set all
808 -- OUT parameters, including warnings, to null
809 --
810 hr_utility.set_location(' Leaving:'||l_proc, 90);
811 raise;
812 end delete_veh_alloc_extra_info;
813 end PQP_VEH_ALLOC_EXTRA_INFO_API;