[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqp_vai_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: pqp_vai_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the pqp_veh_alloc_extra_info Row
69: --
70: update pqp_veh_alloc_extra_info
130: ,program_id = p_rec.program_id
131: ,program_update_date = p_rec.program_update_date
132: where veh_alloc_extra_info_id = p_rec.veh_alloc_extra_info_id;
133: --
134: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 10);
137: --
138: Exception
137: --
138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
142: pqp_vai_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
142: pqp_vai_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
142: pqp_vai_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
147: pqp_vai_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
147: pqp_vai_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
147: pqp_vai_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
152: pqp_vai_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
152: pqp_vai_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;
151: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
152: pqp_vai_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: pqp_vai_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;
157: End update_dml;
158: --
159: -- ----------------------------------------------------------------------------
188: --
189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: Procedure pre_update
192: (p_rec in pqp_vai_shd.g_rec_type
193: ) is
194: --
195: l_proc varchar2(72) := g_package||'pre_update';
196: --
232: --
233: -- {End Of Comments}
234: -- ----------------------------------------------------------------------------
235: Procedure post_update
236: (p_rec in pqp_vai_shd.g_rec_type
237: ) is
238: --
239: l_proc varchar2(72) := g_package||'post_update';
240: --
363: => p_rec.program_id
364: ,p_program_update_date
365: => p_rec.program_update_date
366: ,p_vehicle_allocation_id_o
367: => pqp_vai_shd.g_old_rec.vehicle_allocation_id
368: ,p_information_type_o
369: => pqp_vai_shd.g_old_rec.information_type
370: ,p_vaei_attribute_category_o
371: => pqp_vai_shd.g_old_rec.vaei_attribute_category
365: => p_rec.program_update_date
366: ,p_vehicle_allocation_id_o
367: => pqp_vai_shd.g_old_rec.vehicle_allocation_id
368: ,p_information_type_o
369: => pqp_vai_shd.g_old_rec.information_type
370: ,p_vaei_attribute_category_o
371: => pqp_vai_shd.g_old_rec.vaei_attribute_category
372: ,p_vaei_attribute1_o
373: => pqp_vai_shd.g_old_rec.vaei_attribute1
367: => pqp_vai_shd.g_old_rec.vehicle_allocation_id
368: ,p_information_type_o
369: => pqp_vai_shd.g_old_rec.information_type
370: ,p_vaei_attribute_category_o
371: => pqp_vai_shd.g_old_rec.vaei_attribute_category
372: ,p_vaei_attribute1_o
373: => pqp_vai_shd.g_old_rec.vaei_attribute1
374: ,p_vaei_attribute2_o
375: => pqp_vai_shd.g_old_rec.vaei_attribute2
369: => pqp_vai_shd.g_old_rec.information_type
370: ,p_vaei_attribute_category_o
371: => pqp_vai_shd.g_old_rec.vaei_attribute_category
372: ,p_vaei_attribute1_o
373: => pqp_vai_shd.g_old_rec.vaei_attribute1
374: ,p_vaei_attribute2_o
375: => pqp_vai_shd.g_old_rec.vaei_attribute2
376: ,p_vaei_attribute3_o
377: => pqp_vai_shd.g_old_rec.vaei_attribute3
371: => pqp_vai_shd.g_old_rec.vaei_attribute_category
372: ,p_vaei_attribute1_o
373: => pqp_vai_shd.g_old_rec.vaei_attribute1
374: ,p_vaei_attribute2_o
375: => pqp_vai_shd.g_old_rec.vaei_attribute2
376: ,p_vaei_attribute3_o
377: => pqp_vai_shd.g_old_rec.vaei_attribute3
378: ,p_vaei_attribute4_o
379: => pqp_vai_shd.g_old_rec.vaei_attribute4
373: => pqp_vai_shd.g_old_rec.vaei_attribute1
374: ,p_vaei_attribute2_o
375: => pqp_vai_shd.g_old_rec.vaei_attribute2
376: ,p_vaei_attribute3_o
377: => pqp_vai_shd.g_old_rec.vaei_attribute3
378: ,p_vaei_attribute4_o
379: => pqp_vai_shd.g_old_rec.vaei_attribute4
380: ,p_vaei_attribute5_o
381: => pqp_vai_shd.g_old_rec.vaei_attribute5
375: => pqp_vai_shd.g_old_rec.vaei_attribute2
376: ,p_vaei_attribute3_o
377: => pqp_vai_shd.g_old_rec.vaei_attribute3
378: ,p_vaei_attribute4_o
379: => pqp_vai_shd.g_old_rec.vaei_attribute4
380: ,p_vaei_attribute5_o
381: => pqp_vai_shd.g_old_rec.vaei_attribute5
382: ,p_vaei_attribute6_o
383: => pqp_vai_shd.g_old_rec.vaei_attribute6
377: => pqp_vai_shd.g_old_rec.vaei_attribute3
378: ,p_vaei_attribute4_o
379: => pqp_vai_shd.g_old_rec.vaei_attribute4
380: ,p_vaei_attribute5_o
381: => pqp_vai_shd.g_old_rec.vaei_attribute5
382: ,p_vaei_attribute6_o
383: => pqp_vai_shd.g_old_rec.vaei_attribute6
384: ,p_vaei_attribute7_o
385: => pqp_vai_shd.g_old_rec.vaei_attribute7
379: => pqp_vai_shd.g_old_rec.vaei_attribute4
380: ,p_vaei_attribute5_o
381: => pqp_vai_shd.g_old_rec.vaei_attribute5
382: ,p_vaei_attribute6_o
383: => pqp_vai_shd.g_old_rec.vaei_attribute6
384: ,p_vaei_attribute7_o
385: => pqp_vai_shd.g_old_rec.vaei_attribute7
386: ,p_vaei_attribute8_o
387: => pqp_vai_shd.g_old_rec.vaei_attribute8
381: => pqp_vai_shd.g_old_rec.vaei_attribute5
382: ,p_vaei_attribute6_o
383: => pqp_vai_shd.g_old_rec.vaei_attribute6
384: ,p_vaei_attribute7_o
385: => pqp_vai_shd.g_old_rec.vaei_attribute7
386: ,p_vaei_attribute8_o
387: => pqp_vai_shd.g_old_rec.vaei_attribute8
388: ,p_vaei_attribute9_o
389: => pqp_vai_shd.g_old_rec.vaei_attribute9
383: => pqp_vai_shd.g_old_rec.vaei_attribute6
384: ,p_vaei_attribute7_o
385: => pqp_vai_shd.g_old_rec.vaei_attribute7
386: ,p_vaei_attribute8_o
387: => pqp_vai_shd.g_old_rec.vaei_attribute8
388: ,p_vaei_attribute9_o
389: => pqp_vai_shd.g_old_rec.vaei_attribute9
390: ,p_vaei_attribute10_o
391: => pqp_vai_shd.g_old_rec.vaei_attribute10
385: => pqp_vai_shd.g_old_rec.vaei_attribute7
386: ,p_vaei_attribute8_o
387: => pqp_vai_shd.g_old_rec.vaei_attribute8
388: ,p_vaei_attribute9_o
389: => pqp_vai_shd.g_old_rec.vaei_attribute9
390: ,p_vaei_attribute10_o
391: => pqp_vai_shd.g_old_rec.vaei_attribute10
392: ,p_vaei_attribute11_o
393: => pqp_vai_shd.g_old_rec.vaei_attribute11
387: => pqp_vai_shd.g_old_rec.vaei_attribute8
388: ,p_vaei_attribute9_o
389: => pqp_vai_shd.g_old_rec.vaei_attribute9
390: ,p_vaei_attribute10_o
391: => pqp_vai_shd.g_old_rec.vaei_attribute10
392: ,p_vaei_attribute11_o
393: => pqp_vai_shd.g_old_rec.vaei_attribute11
394: ,p_vaei_attribute12_o
395: => pqp_vai_shd.g_old_rec.vaei_attribute12
389: => pqp_vai_shd.g_old_rec.vaei_attribute9
390: ,p_vaei_attribute10_o
391: => pqp_vai_shd.g_old_rec.vaei_attribute10
392: ,p_vaei_attribute11_o
393: => pqp_vai_shd.g_old_rec.vaei_attribute11
394: ,p_vaei_attribute12_o
395: => pqp_vai_shd.g_old_rec.vaei_attribute12
396: ,p_vaei_attribute13_o
397: => pqp_vai_shd.g_old_rec.vaei_attribute13
391: => pqp_vai_shd.g_old_rec.vaei_attribute10
392: ,p_vaei_attribute11_o
393: => pqp_vai_shd.g_old_rec.vaei_attribute11
394: ,p_vaei_attribute12_o
395: => pqp_vai_shd.g_old_rec.vaei_attribute12
396: ,p_vaei_attribute13_o
397: => pqp_vai_shd.g_old_rec.vaei_attribute13
398: ,p_vaei_attribute14_o
399: => pqp_vai_shd.g_old_rec.vaei_attribute14
393: => pqp_vai_shd.g_old_rec.vaei_attribute11
394: ,p_vaei_attribute12_o
395: => pqp_vai_shd.g_old_rec.vaei_attribute12
396: ,p_vaei_attribute13_o
397: => pqp_vai_shd.g_old_rec.vaei_attribute13
398: ,p_vaei_attribute14_o
399: => pqp_vai_shd.g_old_rec.vaei_attribute14
400: ,p_vaei_attribute15_o
401: => pqp_vai_shd.g_old_rec.vaei_attribute15
395: => pqp_vai_shd.g_old_rec.vaei_attribute12
396: ,p_vaei_attribute13_o
397: => pqp_vai_shd.g_old_rec.vaei_attribute13
398: ,p_vaei_attribute14_o
399: => pqp_vai_shd.g_old_rec.vaei_attribute14
400: ,p_vaei_attribute15_o
401: => pqp_vai_shd.g_old_rec.vaei_attribute15
402: ,p_vaei_attribute16_o
403: => pqp_vai_shd.g_old_rec.vaei_attribute16
397: => pqp_vai_shd.g_old_rec.vaei_attribute13
398: ,p_vaei_attribute14_o
399: => pqp_vai_shd.g_old_rec.vaei_attribute14
400: ,p_vaei_attribute15_o
401: => pqp_vai_shd.g_old_rec.vaei_attribute15
402: ,p_vaei_attribute16_o
403: => pqp_vai_shd.g_old_rec.vaei_attribute16
404: ,p_vaei_attribute17_o
405: => pqp_vai_shd.g_old_rec.vaei_attribute17
399: => pqp_vai_shd.g_old_rec.vaei_attribute14
400: ,p_vaei_attribute15_o
401: => pqp_vai_shd.g_old_rec.vaei_attribute15
402: ,p_vaei_attribute16_o
403: => pqp_vai_shd.g_old_rec.vaei_attribute16
404: ,p_vaei_attribute17_o
405: => pqp_vai_shd.g_old_rec.vaei_attribute17
406: ,p_vaei_attribute18_o
407: => pqp_vai_shd.g_old_rec.vaei_attribute18
401: => pqp_vai_shd.g_old_rec.vaei_attribute15
402: ,p_vaei_attribute16_o
403: => pqp_vai_shd.g_old_rec.vaei_attribute16
404: ,p_vaei_attribute17_o
405: => pqp_vai_shd.g_old_rec.vaei_attribute17
406: ,p_vaei_attribute18_o
407: => pqp_vai_shd.g_old_rec.vaei_attribute18
408: ,p_vaei_attribute19_o
409: => pqp_vai_shd.g_old_rec.vaei_attribute19
403: => pqp_vai_shd.g_old_rec.vaei_attribute16
404: ,p_vaei_attribute17_o
405: => pqp_vai_shd.g_old_rec.vaei_attribute17
406: ,p_vaei_attribute18_o
407: => pqp_vai_shd.g_old_rec.vaei_attribute18
408: ,p_vaei_attribute19_o
409: => pqp_vai_shd.g_old_rec.vaei_attribute19
410: ,p_vaei_attribute20_o
411: => pqp_vai_shd.g_old_rec.vaei_attribute20
405: => pqp_vai_shd.g_old_rec.vaei_attribute17
406: ,p_vaei_attribute18_o
407: => pqp_vai_shd.g_old_rec.vaei_attribute18
408: ,p_vaei_attribute19_o
409: => pqp_vai_shd.g_old_rec.vaei_attribute19
410: ,p_vaei_attribute20_o
411: => pqp_vai_shd.g_old_rec.vaei_attribute20
412: ,p_vaei_information_category_o
413: => pqp_vai_shd.g_old_rec.vaei_information_category
407: => pqp_vai_shd.g_old_rec.vaei_attribute18
408: ,p_vaei_attribute19_o
409: => pqp_vai_shd.g_old_rec.vaei_attribute19
410: ,p_vaei_attribute20_o
411: => pqp_vai_shd.g_old_rec.vaei_attribute20
412: ,p_vaei_information_category_o
413: => pqp_vai_shd.g_old_rec.vaei_information_category
414: ,p_vaei_information1_o
415: => pqp_vai_shd.g_old_rec.vaei_information1
409: => pqp_vai_shd.g_old_rec.vaei_attribute19
410: ,p_vaei_attribute20_o
411: => pqp_vai_shd.g_old_rec.vaei_attribute20
412: ,p_vaei_information_category_o
413: => pqp_vai_shd.g_old_rec.vaei_information_category
414: ,p_vaei_information1_o
415: => pqp_vai_shd.g_old_rec.vaei_information1
416: ,p_vaei_information2_o
417: => pqp_vai_shd.g_old_rec.vaei_information2
411: => pqp_vai_shd.g_old_rec.vaei_attribute20
412: ,p_vaei_information_category_o
413: => pqp_vai_shd.g_old_rec.vaei_information_category
414: ,p_vaei_information1_o
415: => pqp_vai_shd.g_old_rec.vaei_information1
416: ,p_vaei_information2_o
417: => pqp_vai_shd.g_old_rec.vaei_information2
418: ,p_vaei_information3_o
419: => pqp_vai_shd.g_old_rec.vaei_information3
413: => pqp_vai_shd.g_old_rec.vaei_information_category
414: ,p_vaei_information1_o
415: => pqp_vai_shd.g_old_rec.vaei_information1
416: ,p_vaei_information2_o
417: => pqp_vai_shd.g_old_rec.vaei_information2
418: ,p_vaei_information3_o
419: => pqp_vai_shd.g_old_rec.vaei_information3
420: ,p_vaei_information4_o
421: => pqp_vai_shd.g_old_rec.vaei_information4
415: => pqp_vai_shd.g_old_rec.vaei_information1
416: ,p_vaei_information2_o
417: => pqp_vai_shd.g_old_rec.vaei_information2
418: ,p_vaei_information3_o
419: => pqp_vai_shd.g_old_rec.vaei_information3
420: ,p_vaei_information4_o
421: => pqp_vai_shd.g_old_rec.vaei_information4
422: ,p_vaei_information5_o
423: => pqp_vai_shd.g_old_rec.vaei_information5
417: => pqp_vai_shd.g_old_rec.vaei_information2
418: ,p_vaei_information3_o
419: => pqp_vai_shd.g_old_rec.vaei_information3
420: ,p_vaei_information4_o
421: => pqp_vai_shd.g_old_rec.vaei_information4
422: ,p_vaei_information5_o
423: => pqp_vai_shd.g_old_rec.vaei_information5
424: ,p_vaei_information6_o
425: => pqp_vai_shd.g_old_rec.vaei_information6
419: => pqp_vai_shd.g_old_rec.vaei_information3
420: ,p_vaei_information4_o
421: => pqp_vai_shd.g_old_rec.vaei_information4
422: ,p_vaei_information5_o
423: => pqp_vai_shd.g_old_rec.vaei_information5
424: ,p_vaei_information6_o
425: => pqp_vai_shd.g_old_rec.vaei_information6
426: ,p_vaei_information7_o
427: => pqp_vai_shd.g_old_rec.vaei_information7
421: => pqp_vai_shd.g_old_rec.vaei_information4
422: ,p_vaei_information5_o
423: => pqp_vai_shd.g_old_rec.vaei_information5
424: ,p_vaei_information6_o
425: => pqp_vai_shd.g_old_rec.vaei_information6
426: ,p_vaei_information7_o
427: => pqp_vai_shd.g_old_rec.vaei_information7
428: ,p_vaei_information8_o
429: => pqp_vai_shd.g_old_rec.vaei_information8
423: => pqp_vai_shd.g_old_rec.vaei_information5
424: ,p_vaei_information6_o
425: => pqp_vai_shd.g_old_rec.vaei_information6
426: ,p_vaei_information7_o
427: => pqp_vai_shd.g_old_rec.vaei_information7
428: ,p_vaei_information8_o
429: => pqp_vai_shd.g_old_rec.vaei_information8
430: ,p_vaei_information9_o
431: => pqp_vai_shd.g_old_rec.vaei_information9
425: => pqp_vai_shd.g_old_rec.vaei_information6
426: ,p_vaei_information7_o
427: => pqp_vai_shd.g_old_rec.vaei_information7
428: ,p_vaei_information8_o
429: => pqp_vai_shd.g_old_rec.vaei_information8
430: ,p_vaei_information9_o
431: => pqp_vai_shd.g_old_rec.vaei_information9
432: ,p_vaei_information10_o
433: => pqp_vai_shd.g_old_rec.vaei_information10
427: => pqp_vai_shd.g_old_rec.vaei_information7
428: ,p_vaei_information8_o
429: => pqp_vai_shd.g_old_rec.vaei_information8
430: ,p_vaei_information9_o
431: => pqp_vai_shd.g_old_rec.vaei_information9
432: ,p_vaei_information10_o
433: => pqp_vai_shd.g_old_rec.vaei_information10
434: ,p_vaei_information11_o
435: => pqp_vai_shd.g_old_rec.vaei_information11
429: => pqp_vai_shd.g_old_rec.vaei_information8
430: ,p_vaei_information9_o
431: => pqp_vai_shd.g_old_rec.vaei_information9
432: ,p_vaei_information10_o
433: => pqp_vai_shd.g_old_rec.vaei_information10
434: ,p_vaei_information11_o
435: => pqp_vai_shd.g_old_rec.vaei_information11
436: ,p_vaei_information12_o
437: => pqp_vai_shd.g_old_rec.vaei_information12
431: => pqp_vai_shd.g_old_rec.vaei_information9
432: ,p_vaei_information10_o
433: => pqp_vai_shd.g_old_rec.vaei_information10
434: ,p_vaei_information11_o
435: => pqp_vai_shd.g_old_rec.vaei_information11
436: ,p_vaei_information12_o
437: => pqp_vai_shd.g_old_rec.vaei_information12
438: ,p_vaei_information13_o
439: => pqp_vai_shd.g_old_rec.vaei_information13
433: => pqp_vai_shd.g_old_rec.vaei_information10
434: ,p_vaei_information11_o
435: => pqp_vai_shd.g_old_rec.vaei_information11
436: ,p_vaei_information12_o
437: => pqp_vai_shd.g_old_rec.vaei_information12
438: ,p_vaei_information13_o
439: => pqp_vai_shd.g_old_rec.vaei_information13
440: ,p_vaei_information14_o
441: => pqp_vai_shd.g_old_rec.vaei_information14
435: => pqp_vai_shd.g_old_rec.vaei_information11
436: ,p_vaei_information12_o
437: => pqp_vai_shd.g_old_rec.vaei_information12
438: ,p_vaei_information13_o
439: => pqp_vai_shd.g_old_rec.vaei_information13
440: ,p_vaei_information14_o
441: => pqp_vai_shd.g_old_rec.vaei_information14
442: ,p_vaei_information15_o
443: => pqp_vai_shd.g_old_rec.vaei_information15
437: => pqp_vai_shd.g_old_rec.vaei_information12
438: ,p_vaei_information13_o
439: => pqp_vai_shd.g_old_rec.vaei_information13
440: ,p_vaei_information14_o
441: => pqp_vai_shd.g_old_rec.vaei_information14
442: ,p_vaei_information15_o
443: => pqp_vai_shd.g_old_rec.vaei_information15
444: ,p_vaei_information16_o
445: => pqp_vai_shd.g_old_rec.vaei_information16
439: => pqp_vai_shd.g_old_rec.vaei_information13
440: ,p_vaei_information14_o
441: => pqp_vai_shd.g_old_rec.vaei_information14
442: ,p_vaei_information15_o
443: => pqp_vai_shd.g_old_rec.vaei_information15
444: ,p_vaei_information16_o
445: => pqp_vai_shd.g_old_rec.vaei_information16
446: ,p_vaei_information17_o
447: => pqp_vai_shd.g_old_rec.vaei_information17
441: => pqp_vai_shd.g_old_rec.vaei_information14
442: ,p_vaei_information15_o
443: => pqp_vai_shd.g_old_rec.vaei_information15
444: ,p_vaei_information16_o
445: => pqp_vai_shd.g_old_rec.vaei_information16
446: ,p_vaei_information17_o
447: => pqp_vai_shd.g_old_rec.vaei_information17
448: ,p_vaei_information18_o
449: => pqp_vai_shd.g_old_rec.vaei_information18
443: => pqp_vai_shd.g_old_rec.vaei_information15
444: ,p_vaei_information16_o
445: => pqp_vai_shd.g_old_rec.vaei_information16
446: ,p_vaei_information17_o
447: => pqp_vai_shd.g_old_rec.vaei_information17
448: ,p_vaei_information18_o
449: => pqp_vai_shd.g_old_rec.vaei_information18
450: ,p_vaei_information19_o
451: => pqp_vai_shd.g_old_rec.vaei_information19
445: => pqp_vai_shd.g_old_rec.vaei_information16
446: ,p_vaei_information17_o
447: => pqp_vai_shd.g_old_rec.vaei_information17
448: ,p_vaei_information18_o
449: => pqp_vai_shd.g_old_rec.vaei_information18
450: ,p_vaei_information19_o
451: => pqp_vai_shd.g_old_rec.vaei_information19
452: ,p_vaei_information20_o
453: => pqp_vai_shd.g_old_rec.vaei_information20
447: => pqp_vai_shd.g_old_rec.vaei_information17
448: ,p_vaei_information18_o
449: => pqp_vai_shd.g_old_rec.vaei_information18
450: ,p_vaei_information19_o
451: => pqp_vai_shd.g_old_rec.vaei_information19
452: ,p_vaei_information20_o
453: => pqp_vai_shd.g_old_rec.vaei_information20
454: ,p_vaei_information21_o
455: => pqp_vai_shd.g_old_rec.vaei_information21
449: => pqp_vai_shd.g_old_rec.vaei_information18
450: ,p_vaei_information19_o
451: => pqp_vai_shd.g_old_rec.vaei_information19
452: ,p_vaei_information20_o
453: => pqp_vai_shd.g_old_rec.vaei_information20
454: ,p_vaei_information21_o
455: => pqp_vai_shd.g_old_rec.vaei_information21
456: ,p_vaei_information22_o
457: => pqp_vai_shd.g_old_rec.vaei_information22
451: => pqp_vai_shd.g_old_rec.vaei_information19
452: ,p_vaei_information20_o
453: => pqp_vai_shd.g_old_rec.vaei_information20
454: ,p_vaei_information21_o
455: => pqp_vai_shd.g_old_rec.vaei_information21
456: ,p_vaei_information22_o
457: => pqp_vai_shd.g_old_rec.vaei_information22
458: ,p_vaei_information23_o
459: => pqp_vai_shd.g_old_rec.vaei_information23
453: => pqp_vai_shd.g_old_rec.vaei_information20
454: ,p_vaei_information21_o
455: => pqp_vai_shd.g_old_rec.vaei_information21
456: ,p_vaei_information22_o
457: => pqp_vai_shd.g_old_rec.vaei_information22
458: ,p_vaei_information23_o
459: => pqp_vai_shd.g_old_rec.vaei_information23
460: ,p_vaei_information24_o
461: => pqp_vai_shd.g_old_rec.vaei_information24
455: => pqp_vai_shd.g_old_rec.vaei_information21
456: ,p_vaei_information22_o
457: => pqp_vai_shd.g_old_rec.vaei_information22
458: ,p_vaei_information23_o
459: => pqp_vai_shd.g_old_rec.vaei_information23
460: ,p_vaei_information24_o
461: => pqp_vai_shd.g_old_rec.vaei_information24
462: ,p_vaei_information25_o
463: => pqp_vai_shd.g_old_rec.vaei_information25
457: => pqp_vai_shd.g_old_rec.vaei_information22
458: ,p_vaei_information23_o
459: => pqp_vai_shd.g_old_rec.vaei_information23
460: ,p_vaei_information24_o
461: => pqp_vai_shd.g_old_rec.vaei_information24
462: ,p_vaei_information25_o
463: => pqp_vai_shd.g_old_rec.vaei_information25
464: ,p_vaei_information26_o
465: => pqp_vai_shd.g_old_rec.vaei_information26
459: => pqp_vai_shd.g_old_rec.vaei_information23
460: ,p_vaei_information24_o
461: => pqp_vai_shd.g_old_rec.vaei_information24
462: ,p_vaei_information25_o
463: => pqp_vai_shd.g_old_rec.vaei_information25
464: ,p_vaei_information26_o
465: => pqp_vai_shd.g_old_rec.vaei_information26
466: ,p_vaei_information27_o
467: => pqp_vai_shd.g_old_rec.vaei_information27
461: => pqp_vai_shd.g_old_rec.vaei_information24
462: ,p_vaei_information25_o
463: => pqp_vai_shd.g_old_rec.vaei_information25
464: ,p_vaei_information26_o
465: => pqp_vai_shd.g_old_rec.vaei_information26
466: ,p_vaei_information27_o
467: => pqp_vai_shd.g_old_rec.vaei_information27
468: ,p_vaei_information28_o
469: => pqp_vai_shd.g_old_rec.vaei_information28
463: => pqp_vai_shd.g_old_rec.vaei_information25
464: ,p_vaei_information26_o
465: => pqp_vai_shd.g_old_rec.vaei_information26
466: ,p_vaei_information27_o
467: => pqp_vai_shd.g_old_rec.vaei_information27
468: ,p_vaei_information28_o
469: => pqp_vai_shd.g_old_rec.vaei_information28
470: ,p_vaei_information29_o
471: => pqp_vai_shd.g_old_rec.vaei_information29
465: => pqp_vai_shd.g_old_rec.vaei_information26
466: ,p_vaei_information27_o
467: => pqp_vai_shd.g_old_rec.vaei_information27
468: ,p_vaei_information28_o
469: => pqp_vai_shd.g_old_rec.vaei_information28
470: ,p_vaei_information29_o
471: => pqp_vai_shd.g_old_rec.vaei_information29
472: ,p_vaei_information30_o
473: => pqp_vai_shd.g_old_rec.vaei_information30
467: => pqp_vai_shd.g_old_rec.vaei_information27
468: ,p_vaei_information28_o
469: => pqp_vai_shd.g_old_rec.vaei_information28
470: ,p_vaei_information29_o
471: => pqp_vai_shd.g_old_rec.vaei_information29
472: ,p_vaei_information30_o
473: => pqp_vai_shd.g_old_rec.vaei_information30
474: ,p_object_version_number_o
475: => pqp_vai_shd.g_old_rec.object_version_number
469: => pqp_vai_shd.g_old_rec.vaei_information28
470: ,p_vaei_information29_o
471: => pqp_vai_shd.g_old_rec.vaei_information29
472: ,p_vaei_information30_o
473: => pqp_vai_shd.g_old_rec.vaei_information30
474: ,p_object_version_number_o
475: => pqp_vai_shd.g_old_rec.object_version_number
476: ,p_request_id_o
477: => pqp_vai_shd.g_old_rec.request_id
471: => pqp_vai_shd.g_old_rec.vaei_information29
472: ,p_vaei_information30_o
473: => pqp_vai_shd.g_old_rec.vaei_information30
474: ,p_object_version_number_o
475: => pqp_vai_shd.g_old_rec.object_version_number
476: ,p_request_id_o
477: => pqp_vai_shd.g_old_rec.request_id
478: ,p_program_application_id_o
479: => pqp_vai_shd.g_old_rec.program_application_id
473: => pqp_vai_shd.g_old_rec.vaei_information30
474: ,p_object_version_number_o
475: => pqp_vai_shd.g_old_rec.object_version_number
476: ,p_request_id_o
477: => pqp_vai_shd.g_old_rec.request_id
478: ,p_program_application_id_o
479: => pqp_vai_shd.g_old_rec.program_application_id
480: ,p_program_id_o
481: => pqp_vai_shd.g_old_rec.program_id
475: => pqp_vai_shd.g_old_rec.object_version_number
476: ,p_request_id_o
477: => pqp_vai_shd.g_old_rec.request_id
478: ,p_program_application_id_o
479: => pqp_vai_shd.g_old_rec.program_application_id
480: ,p_program_id_o
481: => pqp_vai_shd.g_old_rec.program_id
482: ,p_program_update_date_o
483: => pqp_vai_shd.g_old_rec.program_update_date
477: => pqp_vai_shd.g_old_rec.request_id
478: ,p_program_application_id_o
479: => pqp_vai_shd.g_old_rec.program_application_id
480: ,p_program_id_o
481: => pqp_vai_shd.g_old_rec.program_id
482: ,p_program_update_date_o
483: => pqp_vai_shd.g_old_rec.program_update_date
484: );
485: --
479: => pqp_vai_shd.g_old_rec.program_application_id
480: ,p_program_id_o
481: => pqp_vai_shd.g_old_rec.program_id
482: ,p_program_update_date_o
483: => pqp_vai_shd.g_old_rec.program_update_date
484: );
485: --
486: exception
487: --
539: --
540: -- {End Of Comments}
541: -- ----------------------------------------------------------------------------
542: Procedure convert_defs
543: (p_rec in out nocopy pqp_vai_shd.g_rec_type
544: ) is
545: --
546: Begin
547: --
551: -- is being used then we must set to the 'current' argument value.
552: --
553: If (p_rec.vehicle_allocation_id = hr_api.g_number) then
554: p_rec.vehicle_allocation_id :=
555: pqp_vai_shd.g_old_rec.vehicle_allocation_id;
556: End If;
557: If (p_rec.information_type = hr_api.g_varchar2) then
558: p_rec.information_type :=
559: pqp_vai_shd.g_old_rec.information_type;
555: pqp_vai_shd.g_old_rec.vehicle_allocation_id;
556: End If;
557: If (p_rec.information_type = hr_api.g_varchar2) then
558: p_rec.information_type :=
559: pqp_vai_shd.g_old_rec.information_type;
560: End If;
561: If (p_rec.vaei_attribute_category = hr_api.g_varchar2) then
562: p_rec.vaei_attribute_category :=
563: pqp_vai_shd.g_old_rec.vaei_attribute_category;
559: pqp_vai_shd.g_old_rec.information_type;
560: End If;
561: If (p_rec.vaei_attribute_category = hr_api.g_varchar2) then
562: p_rec.vaei_attribute_category :=
563: pqp_vai_shd.g_old_rec.vaei_attribute_category;
564: End If;
565: If (p_rec.vaei_attribute1 = hr_api.g_varchar2) then
566: p_rec.vaei_attribute1 :=
567: pqp_vai_shd.g_old_rec.vaei_attribute1;
563: pqp_vai_shd.g_old_rec.vaei_attribute_category;
564: End If;
565: If (p_rec.vaei_attribute1 = hr_api.g_varchar2) then
566: p_rec.vaei_attribute1 :=
567: pqp_vai_shd.g_old_rec.vaei_attribute1;
568: End If;
569: If (p_rec.vaei_attribute2 = hr_api.g_varchar2) then
570: p_rec.vaei_attribute2 :=
571: pqp_vai_shd.g_old_rec.vaei_attribute2;
567: pqp_vai_shd.g_old_rec.vaei_attribute1;
568: End If;
569: If (p_rec.vaei_attribute2 = hr_api.g_varchar2) then
570: p_rec.vaei_attribute2 :=
571: pqp_vai_shd.g_old_rec.vaei_attribute2;
572: End If;
573: If (p_rec.vaei_attribute3 = hr_api.g_varchar2) then
574: p_rec.vaei_attribute3 :=
575: pqp_vai_shd.g_old_rec.vaei_attribute3;
571: pqp_vai_shd.g_old_rec.vaei_attribute2;
572: End If;
573: If (p_rec.vaei_attribute3 = hr_api.g_varchar2) then
574: p_rec.vaei_attribute3 :=
575: pqp_vai_shd.g_old_rec.vaei_attribute3;
576: End If;
577: If (p_rec.vaei_attribute4 = hr_api.g_varchar2) then
578: p_rec.vaei_attribute4 :=
579: pqp_vai_shd.g_old_rec.vaei_attribute4;
575: pqp_vai_shd.g_old_rec.vaei_attribute3;
576: End If;
577: If (p_rec.vaei_attribute4 = hr_api.g_varchar2) then
578: p_rec.vaei_attribute4 :=
579: pqp_vai_shd.g_old_rec.vaei_attribute4;
580: End If;
581: If (p_rec.vaei_attribute5 = hr_api.g_varchar2) then
582: p_rec.vaei_attribute5 :=
583: pqp_vai_shd.g_old_rec.vaei_attribute5;
579: pqp_vai_shd.g_old_rec.vaei_attribute4;
580: End If;
581: If (p_rec.vaei_attribute5 = hr_api.g_varchar2) then
582: p_rec.vaei_attribute5 :=
583: pqp_vai_shd.g_old_rec.vaei_attribute5;
584: End If;
585: If (p_rec.vaei_attribute6 = hr_api.g_varchar2) then
586: p_rec.vaei_attribute6 :=
587: pqp_vai_shd.g_old_rec.vaei_attribute6;
583: pqp_vai_shd.g_old_rec.vaei_attribute5;
584: End If;
585: If (p_rec.vaei_attribute6 = hr_api.g_varchar2) then
586: p_rec.vaei_attribute6 :=
587: pqp_vai_shd.g_old_rec.vaei_attribute6;
588: End If;
589: If (p_rec.vaei_attribute7 = hr_api.g_varchar2) then
590: p_rec.vaei_attribute7 :=
591: pqp_vai_shd.g_old_rec.vaei_attribute7;
587: pqp_vai_shd.g_old_rec.vaei_attribute6;
588: End If;
589: If (p_rec.vaei_attribute7 = hr_api.g_varchar2) then
590: p_rec.vaei_attribute7 :=
591: pqp_vai_shd.g_old_rec.vaei_attribute7;
592: End If;
593: If (p_rec.vaei_attribute8 = hr_api.g_varchar2) then
594: p_rec.vaei_attribute8 :=
595: pqp_vai_shd.g_old_rec.vaei_attribute8;
591: pqp_vai_shd.g_old_rec.vaei_attribute7;
592: End If;
593: If (p_rec.vaei_attribute8 = hr_api.g_varchar2) then
594: p_rec.vaei_attribute8 :=
595: pqp_vai_shd.g_old_rec.vaei_attribute8;
596: End If;
597: If (p_rec.vaei_attribute9 = hr_api.g_varchar2) then
598: p_rec.vaei_attribute9 :=
599: pqp_vai_shd.g_old_rec.vaei_attribute9;
595: pqp_vai_shd.g_old_rec.vaei_attribute8;
596: End If;
597: If (p_rec.vaei_attribute9 = hr_api.g_varchar2) then
598: p_rec.vaei_attribute9 :=
599: pqp_vai_shd.g_old_rec.vaei_attribute9;
600: End If;
601: If (p_rec.vaei_attribute10 = hr_api.g_varchar2) then
602: p_rec.vaei_attribute10 :=
603: pqp_vai_shd.g_old_rec.vaei_attribute10;
599: pqp_vai_shd.g_old_rec.vaei_attribute9;
600: End If;
601: If (p_rec.vaei_attribute10 = hr_api.g_varchar2) then
602: p_rec.vaei_attribute10 :=
603: pqp_vai_shd.g_old_rec.vaei_attribute10;
604: End If;
605: If (p_rec.vaei_attribute11 = hr_api.g_varchar2) then
606: p_rec.vaei_attribute11 :=
607: pqp_vai_shd.g_old_rec.vaei_attribute11;
603: pqp_vai_shd.g_old_rec.vaei_attribute10;
604: End If;
605: If (p_rec.vaei_attribute11 = hr_api.g_varchar2) then
606: p_rec.vaei_attribute11 :=
607: pqp_vai_shd.g_old_rec.vaei_attribute11;
608: End If;
609: If (p_rec.vaei_attribute12 = hr_api.g_varchar2) then
610: p_rec.vaei_attribute12 :=
611: pqp_vai_shd.g_old_rec.vaei_attribute12;
607: pqp_vai_shd.g_old_rec.vaei_attribute11;
608: End If;
609: If (p_rec.vaei_attribute12 = hr_api.g_varchar2) then
610: p_rec.vaei_attribute12 :=
611: pqp_vai_shd.g_old_rec.vaei_attribute12;
612: End If;
613: If (p_rec.vaei_attribute13 = hr_api.g_varchar2) then
614: p_rec.vaei_attribute13 :=
615: pqp_vai_shd.g_old_rec.vaei_attribute13;
611: pqp_vai_shd.g_old_rec.vaei_attribute12;
612: End If;
613: If (p_rec.vaei_attribute13 = hr_api.g_varchar2) then
614: p_rec.vaei_attribute13 :=
615: pqp_vai_shd.g_old_rec.vaei_attribute13;
616: End If;
617: If (p_rec.vaei_attribute14 = hr_api.g_varchar2) then
618: p_rec.vaei_attribute14 :=
619: pqp_vai_shd.g_old_rec.vaei_attribute14;
615: pqp_vai_shd.g_old_rec.vaei_attribute13;
616: End If;
617: If (p_rec.vaei_attribute14 = hr_api.g_varchar2) then
618: p_rec.vaei_attribute14 :=
619: pqp_vai_shd.g_old_rec.vaei_attribute14;
620: End If;
621: If (p_rec.vaei_attribute15 = hr_api.g_varchar2) then
622: p_rec.vaei_attribute15 :=
623: pqp_vai_shd.g_old_rec.vaei_attribute15;
619: pqp_vai_shd.g_old_rec.vaei_attribute14;
620: End If;
621: If (p_rec.vaei_attribute15 = hr_api.g_varchar2) then
622: p_rec.vaei_attribute15 :=
623: pqp_vai_shd.g_old_rec.vaei_attribute15;
624: End If;
625: If (p_rec.vaei_attribute16 = hr_api.g_varchar2) then
626: p_rec.vaei_attribute16 :=
627: pqp_vai_shd.g_old_rec.vaei_attribute16;
623: pqp_vai_shd.g_old_rec.vaei_attribute15;
624: End If;
625: If (p_rec.vaei_attribute16 = hr_api.g_varchar2) then
626: p_rec.vaei_attribute16 :=
627: pqp_vai_shd.g_old_rec.vaei_attribute16;
628: End If;
629: If (p_rec.vaei_attribute17 = hr_api.g_varchar2) then
630: p_rec.vaei_attribute17 :=
631: pqp_vai_shd.g_old_rec.vaei_attribute17;
627: pqp_vai_shd.g_old_rec.vaei_attribute16;
628: End If;
629: If (p_rec.vaei_attribute17 = hr_api.g_varchar2) then
630: p_rec.vaei_attribute17 :=
631: pqp_vai_shd.g_old_rec.vaei_attribute17;
632: End If;
633: If (p_rec.vaei_attribute18 = hr_api.g_varchar2) then
634: p_rec.vaei_attribute18 :=
635: pqp_vai_shd.g_old_rec.vaei_attribute18;
631: pqp_vai_shd.g_old_rec.vaei_attribute17;
632: End If;
633: If (p_rec.vaei_attribute18 = hr_api.g_varchar2) then
634: p_rec.vaei_attribute18 :=
635: pqp_vai_shd.g_old_rec.vaei_attribute18;
636: End If;
637: If (p_rec.vaei_attribute19 = hr_api.g_varchar2) then
638: p_rec.vaei_attribute19 :=
639: pqp_vai_shd.g_old_rec.vaei_attribute19;
635: pqp_vai_shd.g_old_rec.vaei_attribute18;
636: End If;
637: If (p_rec.vaei_attribute19 = hr_api.g_varchar2) then
638: p_rec.vaei_attribute19 :=
639: pqp_vai_shd.g_old_rec.vaei_attribute19;
640: End If;
641: If (p_rec.vaei_attribute20 = hr_api.g_varchar2) then
642: p_rec.vaei_attribute20 :=
643: pqp_vai_shd.g_old_rec.vaei_attribute20;
639: pqp_vai_shd.g_old_rec.vaei_attribute19;
640: End If;
641: If (p_rec.vaei_attribute20 = hr_api.g_varchar2) then
642: p_rec.vaei_attribute20 :=
643: pqp_vai_shd.g_old_rec.vaei_attribute20;
644: End If;
645: If (p_rec.vaei_information_category = hr_api.g_varchar2) then
646: p_rec.vaei_information_category :=
647: pqp_vai_shd.g_old_rec.vaei_information_category;
643: pqp_vai_shd.g_old_rec.vaei_attribute20;
644: End If;
645: If (p_rec.vaei_information_category = hr_api.g_varchar2) then
646: p_rec.vaei_information_category :=
647: pqp_vai_shd.g_old_rec.vaei_information_category;
648: End If;
649: If (p_rec.vaei_information1 = hr_api.g_varchar2) then
650: p_rec.vaei_information1 :=
651: pqp_vai_shd.g_old_rec.vaei_information1;
647: pqp_vai_shd.g_old_rec.vaei_information_category;
648: End If;
649: If (p_rec.vaei_information1 = hr_api.g_varchar2) then
650: p_rec.vaei_information1 :=
651: pqp_vai_shd.g_old_rec.vaei_information1;
652: End If;
653: If (p_rec.vaei_information2 = hr_api.g_varchar2) then
654: p_rec.vaei_information2 :=
655: pqp_vai_shd.g_old_rec.vaei_information2;
651: pqp_vai_shd.g_old_rec.vaei_information1;
652: End If;
653: If (p_rec.vaei_information2 = hr_api.g_varchar2) then
654: p_rec.vaei_information2 :=
655: pqp_vai_shd.g_old_rec.vaei_information2;
656: End If;
657: If (p_rec.vaei_information3 = hr_api.g_varchar2) then
658: p_rec.vaei_information3 :=
659: pqp_vai_shd.g_old_rec.vaei_information3;
655: pqp_vai_shd.g_old_rec.vaei_information2;
656: End If;
657: If (p_rec.vaei_information3 = hr_api.g_varchar2) then
658: p_rec.vaei_information3 :=
659: pqp_vai_shd.g_old_rec.vaei_information3;
660: End If;
661: If (p_rec.vaei_information4 = hr_api.g_varchar2) then
662: p_rec.vaei_information4 :=
663: pqp_vai_shd.g_old_rec.vaei_information4;
659: pqp_vai_shd.g_old_rec.vaei_information3;
660: End If;
661: If (p_rec.vaei_information4 = hr_api.g_varchar2) then
662: p_rec.vaei_information4 :=
663: pqp_vai_shd.g_old_rec.vaei_information4;
664: End If;
665: If (p_rec.vaei_information5 = hr_api.g_varchar2) then
666: p_rec.vaei_information5 :=
667: pqp_vai_shd.g_old_rec.vaei_information5;
663: pqp_vai_shd.g_old_rec.vaei_information4;
664: End If;
665: If (p_rec.vaei_information5 = hr_api.g_varchar2) then
666: p_rec.vaei_information5 :=
667: pqp_vai_shd.g_old_rec.vaei_information5;
668: End If;
669: If (p_rec.vaei_information6 = hr_api.g_varchar2) then
670: p_rec.vaei_information6 :=
671: pqp_vai_shd.g_old_rec.vaei_information6;
667: pqp_vai_shd.g_old_rec.vaei_information5;
668: End If;
669: If (p_rec.vaei_information6 = hr_api.g_varchar2) then
670: p_rec.vaei_information6 :=
671: pqp_vai_shd.g_old_rec.vaei_information6;
672: End If;
673: If (p_rec.vaei_information7 = hr_api.g_varchar2) then
674: p_rec.vaei_information7 :=
675: pqp_vai_shd.g_old_rec.vaei_information7;
671: pqp_vai_shd.g_old_rec.vaei_information6;
672: End If;
673: If (p_rec.vaei_information7 = hr_api.g_varchar2) then
674: p_rec.vaei_information7 :=
675: pqp_vai_shd.g_old_rec.vaei_information7;
676: End If;
677: If (p_rec.vaei_information8 = hr_api.g_varchar2) then
678: p_rec.vaei_information8 :=
679: pqp_vai_shd.g_old_rec.vaei_information8;
675: pqp_vai_shd.g_old_rec.vaei_information7;
676: End If;
677: If (p_rec.vaei_information8 = hr_api.g_varchar2) then
678: p_rec.vaei_information8 :=
679: pqp_vai_shd.g_old_rec.vaei_information8;
680: End If;
681: If (p_rec.vaei_information9 = hr_api.g_varchar2) then
682: p_rec.vaei_information9 :=
683: pqp_vai_shd.g_old_rec.vaei_information9;
679: pqp_vai_shd.g_old_rec.vaei_information8;
680: End If;
681: If (p_rec.vaei_information9 = hr_api.g_varchar2) then
682: p_rec.vaei_information9 :=
683: pqp_vai_shd.g_old_rec.vaei_information9;
684: End If;
685: If (p_rec.vaei_information10 = hr_api.g_varchar2) then
686: p_rec.vaei_information10 :=
687: pqp_vai_shd.g_old_rec.vaei_information10;
683: pqp_vai_shd.g_old_rec.vaei_information9;
684: End If;
685: If (p_rec.vaei_information10 = hr_api.g_varchar2) then
686: p_rec.vaei_information10 :=
687: pqp_vai_shd.g_old_rec.vaei_information10;
688: End If;
689: If (p_rec.vaei_information11 = hr_api.g_varchar2) then
690: p_rec.vaei_information11 :=
691: pqp_vai_shd.g_old_rec.vaei_information11;
687: pqp_vai_shd.g_old_rec.vaei_information10;
688: End If;
689: If (p_rec.vaei_information11 = hr_api.g_varchar2) then
690: p_rec.vaei_information11 :=
691: pqp_vai_shd.g_old_rec.vaei_information11;
692: End If;
693: If (p_rec.vaei_information12 = hr_api.g_varchar2) then
694: p_rec.vaei_information12 :=
695: pqp_vai_shd.g_old_rec.vaei_information12;
691: pqp_vai_shd.g_old_rec.vaei_information11;
692: End If;
693: If (p_rec.vaei_information12 = hr_api.g_varchar2) then
694: p_rec.vaei_information12 :=
695: pqp_vai_shd.g_old_rec.vaei_information12;
696: End If;
697: If (p_rec.vaei_information13 = hr_api.g_varchar2) then
698: p_rec.vaei_information13 :=
699: pqp_vai_shd.g_old_rec.vaei_information13;
695: pqp_vai_shd.g_old_rec.vaei_information12;
696: End If;
697: If (p_rec.vaei_information13 = hr_api.g_varchar2) then
698: p_rec.vaei_information13 :=
699: pqp_vai_shd.g_old_rec.vaei_information13;
700: End If;
701: If (p_rec.vaei_information14 = hr_api.g_varchar2) then
702: p_rec.vaei_information14 :=
703: pqp_vai_shd.g_old_rec.vaei_information14;
699: pqp_vai_shd.g_old_rec.vaei_information13;
700: End If;
701: If (p_rec.vaei_information14 = hr_api.g_varchar2) then
702: p_rec.vaei_information14 :=
703: pqp_vai_shd.g_old_rec.vaei_information14;
704: End If;
705: If (p_rec.vaei_information15 = hr_api.g_varchar2) then
706: p_rec.vaei_information15 :=
707: pqp_vai_shd.g_old_rec.vaei_information15;
703: pqp_vai_shd.g_old_rec.vaei_information14;
704: End If;
705: If (p_rec.vaei_information15 = hr_api.g_varchar2) then
706: p_rec.vaei_information15 :=
707: pqp_vai_shd.g_old_rec.vaei_information15;
708: End If;
709: If (p_rec.vaei_information16 = hr_api.g_varchar2) then
710: p_rec.vaei_information16 :=
711: pqp_vai_shd.g_old_rec.vaei_information16;
707: pqp_vai_shd.g_old_rec.vaei_information15;
708: End If;
709: If (p_rec.vaei_information16 = hr_api.g_varchar2) then
710: p_rec.vaei_information16 :=
711: pqp_vai_shd.g_old_rec.vaei_information16;
712: End If;
713: If (p_rec.vaei_information17 = hr_api.g_varchar2) then
714: p_rec.vaei_information17 :=
715: pqp_vai_shd.g_old_rec.vaei_information17;
711: pqp_vai_shd.g_old_rec.vaei_information16;
712: End If;
713: If (p_rec.vaei_information17 = hr_api.g_varchar2) then
714: p_rec.vaei_information17 :=
715: pqp_vai_shd.g_old_rec.vaei_information17;
716: End If;
717: If (p_rec.vaei_information18 = hr_api.g_varchar2) then
718: p_rec.vaei_information18 :=
719: pqp_vai_shd.g_old_rec.vaei_information18;
715: pqp_vai_shd.g_old_rec.vaei_information17;
716: End If;
717: If (p_rec.vaei_information18 = hr_api.g_varchar2) then
718: p_rec.vaei_information18 :=
719: pqp_vai_shd.g_old_rec.vaei_information18;
720: End If;
721: If (p_rec.vaei_information19 = hr_api.g_varchar2) then
722: p_rec.vaei_information19 :=
723: pqp_vai_shd.g_old_rec.vaei_information19;
719: pqp_vai_shd.g_old_rec.vaei_information18;
720: End If;
721: If (p_rec.vaei_information19 = hr_api.g_varchar2) then
722: p_rec.vaei_information19 :=
723: pqp_vai_shd.g_old_rec.vaei_information19;
724: End If;
725: If (p_rec.vaei_information20 = hr_api.g_varchar2) then
726: p_rec.vaei_information20 :=
727: pqp_vai_shd.g_old_rec.vaei_information20;
723: pqp_vai_shd.g_old_rec.vaei_information19;
724: End If;
725: If (p_rec.vaei_information20 = hr_api.g_varchar2) then
726: p_rec.vaei_information20 :=
727: pqp_vai_shd.g_old_rec.vaei_information20;
728: End If;
729: If (p_rec.vaei_information21 = hr_api.g_varchar2) then
730: p_rec.vaei_information21 :=
731: pqp_vai_shd.g_old_rec.vaei_information21;
727: pqp_vai_shd.g_old_rec.vaei_information20;
728: End If;
729: If (p_rec.vaei_information21 = hr_api.g_varchar2) then
730: p_rec.vaei_information21 :=
731: pqp_vai_shd.g_old_rec.vaei_information21;
732: End If;
733: If (p_rec.vaei_information22 = hr_api.g_varchar2) then
734: p_rec.vaei_information22 :=
735: pqp_vai_shd.g_old_rec.vaei_information22;
731: pqp_vai_shd.g_old_rec.vaei_information21;
732: End If;
733: If (p_rec.vaei_information22 = hr_api.g_varchar2) then
734: p_rec.vaei_information22 :=
735: pqp_vai_shd.g_old_rec.vaei_information22;
736: End If;
737: If (p_rec.vaei_information23 = hr_api.g_varchar2) then
738: p_rec.vaei_information23 :=
739: pqp_vai_shd.g_old_rec.vaei_information23;
735: pqp_vai_shd.g_old_rec.vaei_information22;
736: End If;
737: If (p_rec.vaei_information23 = hr_api.g_varchar2) then
738: p_rec.vaei_information23 :=
739: pqp_vai_shd.g_old_rec.vaei_information23;
740: End If;
741: If (p_rec.vaei_information24 = hr_api.g_varchar2) then
742: p_rec.vaei_information24 :=
743: pqp_vai_shd.g_old_rec.vaei_information24;
739: pqp_vai_shd.g_old_rec.vaei_information23;
740: End If;
741: If (p_rec.vaei_information24 = hr_api.g_varchar2) then
742: p_rec.vaei_information24 :=
743: pqp_vai_shd.g_old_rec.vaei_information24;
744: End If;
745: If (p_rec.vaei_information25 = hr_api.g_varchar2) then
746: p_rec.vaei_information25 :=
747: pqp_vai_shd.g_old_rec.vaei_information25;
743: pqp_vai_shd.g_old_rec.vaei_information24;
744: End If;
745: If (p_rec.vaei_information25 = hr_api.g_varchar2) then
746: p_rec.vaei_information25 :=
747: pqp_vai_shd.g_old_rec.vaei_information25;
748: End If;
749: If (p_rec.vaei_information26 = hr_api.g_varchar2) then
750: p_rec.vaei_information26 :=
751: pqp_vai_shd.g_old_rec.vaei_information26;
747: pqp_vai_shd.g_old_rec.vaei_information25;
748: End If;
749: If (p_rec.vaei_information26 = hr_api.g_varchar2) then
750: p_rec.vaei_information26 :=
751: pqp_vai_shd.g_old_rec.vaei_information26;
752: End If;
753: If (p_rec.vaei_information27 = hr_api.g_varchar2) then
754: p_rec.vaei_information27 :=
755: pqp_vai_shd.g_old_rec.vaei_information27;
751: pqp_vai_shd.g_old_rec.vaei_information26;
752: End If;
753: If (p_rec.vaei_information27 = hr_api.g_varchar2) then
754: p_rec.vaei_information27 :=
755: pqp_vai_shd.g_old_rec.vaei_information27;
756: End If;
757: If (p_rec.vaei_information28 = hr_api.g_varchar2) then
758: p_rec.vaei_information28 :=
759: pqp_vai_shd.g_old_rec.vaei_information28;
755: pqp_vai_shd.g_old_rec.vaei_information27;
756: End If;
757: If (p_rec.vaei_information28 = hr_api.g_varchar2) then
758: p_rec.vaei_information28 :=
759: pqp_vai_shd.g_old_rec.vaei_information28;
760: End If;
761: If (p_rec.vaei_information29 = hr_api.g_varchar2) then
762: p_rec.vaei_information29 :=
763: pqp_vai_shd.g_old_rec.vaei_information29;
759: pqp_vai_shd.g_old_rec.vaei_information28;
760: End If;
761: If (p_rec.vaei_information29 = hr_api.g_varchar2) then
762: p_rec.vaei_information29 :=
763: pqp_vai_shd.g_old_rec.vaei_information29;
764: End If;
765: If (p_rec.vaei_information30 = hr_api.g_varchar2) then
766: p_rec.vaei_information30 :=
767: pqp_vai_shd.g_old_rec.vaei_information30;
763: pqp_vai_shd.g_old_rec.vaei_information29;
764: End If;
765: If (p_rec.vaei_information30 = hr_api.g_varchar2) then
766: p_rec.vaei_information30 :=
767: pqp_vai_shd.g_old_rec.vaei_information30;
768: End If;
769: If (p_rec.request_id = hr_api.g_number) then
770: p_rec.request_id :=
771: pqp_vai_shd.g_old_rec.request_id;
767: pqp_vai_shd.g_old_rec.vaei_information30;
768: End If;
769: If (p_rec.request_id = hr_api.g_number) then
770: p_rec.request_id :=
771: pqp_vai_shd.g_old_rec.request_id;
772: End If;
773: If (p_rec.program_application_id = hr_api.g_number) then
774: p_rec.program_application_id :=
775: pqp_vai_shd.g_old_rec.program_application_id;
771: pqp_vai_shd.g_old_rec.request_id;
772: End If;
773: If (p_rec.program_application_id = hr_api.g_number) then
774: p_rec.program_application_id :=
775: pqp_vai_shd.g_old_rec.program_application_id;
776: End If;
777: If (p_rec.program_id = hr_api.g_number) then
778: p_rec.program_id :=
779: pqp_vai_shd.g_old_rec.program_id;
775: pqp_vai_shd.g_old_rec.program_application_id;
776: End If;
777: If (p_rec.program_id = hr_api.g_number) then
778: p_rec.program_id :=
779: pqp_vai_shd.g_old_rec.program_id;
780: End If;
781: If (p_rec.program_update_date = hr_api.g_date) then
782: p_rec.program_update_date :=
783: pqp_vai_shd.g_old_rec.program_update_date;
779: pqp_vai_shd.g_old_rec.program_id;
780: End If;
781: If (p_rec.program_update_date = hr_api.g_date) then
782: p_rec.program_update_date :=
783: pqp_vai_shd.g_old_rec.program_update_date;
784: End If;
785: --
786: End convert_defs;
787: --
788: -- ----------------------------------------------------------------------------
789: -- |---------------------------------< upd >----------------------------------|
790: -- ----------------------------------------------------------------------------
791: Procedure upd
792: (p_rec in out nocopy pqp_vai_shd.g_rec_type
793: ) is
794: --
795: l_proc varchar2(72) := g_package||'upd';
796: --
798: hr_utility.set_location('Entering:'||l_proc, 5);
799: --
800: -- We must lock the row which we need to update.
801: --
802: pqp_vai_shd.lck
803: (p_rec.veh_alloc_extra_info_id
804: ,p_rec.object_version_number
805: );
806: --
901: ,p_program_id in number default hr_api.g_number
902: ,p_program_update_date in date default hr_api.g_date
903: ) is
904: --
905: l_rec pqp_vai_shd.g_rec_type;
906: l_proc varchar2(72) := g_package||'upd';
907: --
908: Begin
909: hr_utility.set_location('Entering:'||l_proc, 5);
911: -- Call conversion function to turn arguments into the
912: -- l_rec structure.
913: --
914: l_rec :=
915: pqp_vai_shd.convert_args
916: (p_veh_alloc_extra_info_id
917: ,p_vehicle_allocation_id
918: ,p_information_type
919: ,p_vaei_attribute_category