51: hr_utility.set_location('Entering:'|| l_proc, 10);
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --
55: hr_api.mandatory_arg_error
56: (p_api_name => l_proc
57: ,p_argument => 'veh_alloc_extra_info_id'
58: ,p_argument_value => p_veh_alloc_extra_info_id
59: );
78: close csr_sec_grp;
79: --
80: -- Set the security_group_id in CLIENT_INFO
81: --
82: hr_api.set_security_group_id
83: (p_security_group_id => l_security_group_id
84: );
85: --
86: -- Set the sessions legislation context in HR_SESSION_DATA
84: );
85: --
86: -- Set the sessions legislation context in HR_SESSION_DATA
87: --
88: hr_api.set_legislation_context(l_legislation_code);
89: end if;
90: --
91: hr_utility.set_location(' Leaving:'|| l_proc, 20);
92: --
120: hr_utility.set_location('Entering:'|| l_proc, 10);
121: --
122: -- Ensure that all the mandatory parameter are not null
123: --
124: hr_api.mandatory_arg_error
125: (p_api_name => l_proc
126: ,p_argument => 'vehicle_allocation_id'
127: ,p_argument_value => p_vehicle_allocation_id
128: );
126: ,p_argument => 'vehicle_allocation_id'
127: ,p_argument_value => p_vehicle_allocation_id
128: );
129: --
130: if ( nvl(pqp_vai_bus.g_vehicle_allocation_id, hr_api.g_number)
131: = p_vehicle_allocation_id) then
132: --
133: -- The legislation code has already been found with a previous
134: -- call to this function. Just return the value in the global
194: hr_utility.set_location('Entering:'|| l_proc, 10);
195: --
196: -- Ensure that all the mandatory parameter are not null
197: --
198: hr_api.mandatory_arg_error
199: (p_api_name => l_proc
200: ,p_argument => 'vehicle_allocation_id'
201: ,p_argument_value => p_vehicle_allocation_id
202: );
200: ,p_argument => 'vehicle_allocation_id'
201: ,p_argument_value => p_vehicle_allocation_id
202: );
203: --
204: if ( nvl(pqp_vai_bus.g_vehicle_allocation_id, hr_api.g_number)
205: = p_vehicle_allocation_id) then
206: --
207: -- The legislation code has already been found with a previous
208: -- call to this function. Just return the value in the global
276: begin
277: hr_utility.set_location('Entering:'||l_proc,10);
278: --
279: if ((p_rec.veh_alloc_extra_info_id is not null) and (
280: nvl(pqp_vai_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
281: nvl(p_rec.information_type, hr_api.g_varchar2) or
282: nvl(pqp_vai_shd.g_old_rec.vaei_information_category, hr_api.g_varchar2) <>
283: nvl(p_rec.vaei_information_category, hr_api.g_varchar2) or
284: nvl(pqp_vai_shd.g_old_rec.vaei_information1, hr_api.g_varchar2) <>
277: hr_utility.set_location('Entering:'||l_proc,10);
278: --
279: if ((p_rec.veh_alloc_extra_info_id is not null) and (
280: nvl(pqp_vai_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
281: nvl(p_rec.information_type, hr_api.g_varchar2) or
282: nvl(pqp_vai_shd.g_old_rec.vaei_information_category, hr_api.g_varchar2) <>
283: nvl(p_rec.vaei_information_category, hr_api.g_varchar2) or
284: nvl(pqp_vai_shd.g_old_rec.vaei_information1, hr_api.g_varchar2) <>
285: nvl(p_rec.vaei_information1, hr_api.g_varchar2) or
278: --
279: if ((p_rec.veh_alloc_extra_info_id is not null) and (
280: nvl(pqp_vai_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
281: nvl(p_rec.information_type, hr_api.g_varchar2) or
282: nvl(pqp_vai_shd.g_old_rec.vaei_information_category, hr_api.g_varchar2) <>
283: nvl(p_rec.vaei_information_category, hr_api.g_varchar2) or
284: nvl(pqp_vai_shd.g_old_rec.vaei_information1, hr_api.g_varchar2) <>
285: nvl(p_rec.vaei_information1, hr_api.g_varchar2) or
286: nvl(pqp_vai_shd.g_old_rec.vaei_information2, hr_api.g_varchar2) <>
279: if ((p_rec.veh_alloc_extra_info_id is not null) and (
280: nvl(pqp_vai_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
281: nvl(p_rec.information_type, hr_api.g_varchar2) or
282: nvl(pqp_vai_shd.g_old_rec.vaei_information_category, hr_api.g_varchar2) <>
283: nvl(p_rec.vaei_information_category, hr_api.g_varchar2) or
284: nvl(pqp_vai_shd.g_old_rec.vaei_information1, hr_api.g_varchar2) <>
285: nvl(p_rec.vaei_information1, hr_api.g_varchar2) or
286: nvl(pqp_vai_shd.g_old_rec.vaei_information2, hr_api.g_varchar2) <>
287: nvl(p_rec.vaei_information2, hr_api.g_varchar2) or
280: nvl(pqp_vai_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
281: nvl(p_rec.information_type, hr_api.g_varchar2) or
282: nvl(pqp_vai_shd.g_old_rec.vaei_information_category, hr_api.g_varchar2) <>
283: nvl(p_rec.vaei_information_category, hr_api.g_varchar2) or
284: nvl(pqp_vai_shd.g_old_rec.vaei_information1, hr_api.g_varchar2) <>
285: nvl(p_rec.vaei_information1, hr_api.g_varchar2) or
286: nvl(pqp_vai_shd.g_old_rec.vaei_information2, hr_api.g_varchar2) <>
287: nvl(p_rec.vaei_information2, hr_api.g_varchar2) or
288: nvl(pqp_vai_shd.g_old_rec.vaei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.information_type, hr_api.g_varchar2) or
282: nvl(pqp_vai_shd.g_old_rec.vaei_information_category, hr_api.g_varchar2) <>
283: nvl(p_rec.vaei_information_category, hr_api.g_varchar2) or
284: nvl(pqp_vai_shd.g_old_rec.vaei_information1, hr_api.g_varchar2) <>
285: nvl(p_rec.vaei_information1, hr_api.g_varchar2) or
286: nvl(pqp_vai_shd.g_old_rec.vaei_information2, hr_api.g_varchar2) <>
287: nvl(p_rec.vaei_information2, hr_api.g_varchar2) or
288: nvl(pqp_vai_shd.g_old_rec.vaei_information3, hr_api.g_varchar2) <>
289: nvl(p_rec.vaei_information3, hr_api.g_varchar2) or
282: nvl(pqp_vai_shd.g_old_rec.vaei_information_category, hr_api.g_varchar2) <>
283: nvl(p_rec.vaei_information_category, hr_api.g_varchar2) or
284: nvl(pqp_vai_shd.g_old_rec.vaei_information1, hr_api.g_varchar2) <>
285: nvl(p_rec.vaei_information1, hr_api.g_varchar2) or
286: nvl(pqp_vai_shd.g_old_rec.vaei_information2, hr_api.g_varchar2) <>
287: nvl(p_rec.vaei_information2, hr_api.g_varchar2) or
288: nvl(pqp_vai_shd.g_old_rec.vaei_information3, hr_api.g_varchar2) <>
289: nvl(p_rec.vaei_information3, hr_api.g_varchar2) or
290: nvl(pqp_vai_shd.g_old_rec.vaei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.vaei_information_category, hr_api.g_varchar2) or
284: nvl(pqp_vai_shd.g_old_rec.vaei_information1, hr_api.g_varchar2) <>
285: nvl(p_rec.vaei_information1, hr_api.g_varchar2) or
286: nvl(pqp_vai_shd.g_old_rec.vaei_information2, hr_api.g_varchar2) <>
287: nvl(p_rec.vaei_information2, hr_api.g_varchar2) or
288: nvl(pqp_vai_shd.g_old_rec.vaei_information3, hr_api.g_varchar2) <>
289: nvl(p_rec.vaei_information3, hr_api.g_varchar2) or
290: nvl(pqp_vai_shd.g_old_rec.vaei_information4, hr_api.g_varchar2) <>
291: nvl(p_rec.vaei_information4, hr_api.g_varchar2) or
284: nvl(pqp_vai_shd.g_old_rec.vaei_information1, hr_api.g_varchar2) <>
285: nvl(p_rec.vaei_information1, hr_api.g_varchar2) or
286: nvl(pqp_vai_shd.g_old_rec.vaei_information2, hr_api.g_varchar2) <>
287: nvl(p_rec.vaei_information2, hr_api.g_varchar2) or
288: nvl(pqp_vai_shd.g_old_rec.vaei_information3, hr_api.g_varchar2) <>
289: nvl(p_rec.vaei_information3, hr_api.g_varchar2) or
290: nvl(pqp_vai_shd.g_old_rec.vaei_information4, hr_api.g_varchar2) <>
291: nvl(p_rec.vaei_information4, hr_api.g_varchar2) or
292: nvl(pqp_vai_shd.g_old_rec.vaei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.vaei_information1, hr_api.g_varchar2) or
286: nvl(pqp_vai_shd.g_old_rec.vaei_information2, hr_api.g_varchar2) <>
287: nvl(p_rec.vaei_information2, hr_api.g_varchar2) or
288: nvl(pqp_vai_shd.g_old_rec.vaei_information3, hr_api.g_varchar2) <>
289: nvl(p_rec.vaei_information3, hr_api.g_varchar2) or
290: nvl(pqp_vai_shd.g_old_rec.vaei_information4, hr_api.g_varchar2) <>
291: nvl(p_rec.vaei_information4, hr_api.g_varchar2) or
292: nvl(pqp_vai_shd.g_old_rec.vaei_information5, hr_api.g_varchar2) <>
293: nvl(p_rec.vaei_information5, hr_api.g_varchar2) or
286: nvl(pqp_vai_shd.g_old_rec.vaei_information2, hr_api.g_varchar2) <>
287: nvl(p_rec.vaei_information2, hr_api.g_varchar2) or
288: nvl(pqp_vai_shd.g_old_rec.vaei_information3, hr_api.g_varchar2) <>
289: nvl(p_rec.vaei_information3, hr_api.g_varchar2) or
290: nvl(pqp_vai_shd.g_old_rec.vaei_information4, hr_api.g_varchar2) <>
291: nvl(p_rec.vaei_information4, hr_api.g_varchar2) or
292: nvl(pqp_vai_shd.g_old_rec.vaei_information5, hr_api.g_varchar2) <>
293: nvl(p_rec.vaei_information5, hr_api.g_varchar2) or
294: nvl(pqp_vai_shd.g_old_rec.vaei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.vaei_information2, hr_api.g_varchar2) or
288: nvl(pqp_vai_shd.g_old_rec.vaei_information3, hr_api.g_varchar2) <>
289: nvl(p_rec.vaei_information3, hr_api.g_varchar2) or
290: nvl(pqp_vai_shd.g_old_rec.vaei_information4, hr_api.g_varchar2) <>
291: nvl(p_rec.vaei_information4, hr_api.g_varchar2) or
292: nvl(pqp_vai_shd.g_old_rec.vaei_information5, hr_api.g_varchar2) <>
293: nvl(p_rec.vaei_information5, hr_api.g_varchar2) or
294: nvl(pqp_vai_shd.g_old_rec.vaei_information6, hr_api.g_varchar2) <>
295: nvl(p_rec.vaei_information6, hr_api.g_varchar2) or
288: nvl(pqp_vai_shd.g_old_rec.vaei_information3, hr_api.g_varchar2) <>
289: nvl(p_rec.vaei_information3, hr_api.g_varchar2) or
290: nvl(pqp_vai_shd.g_old_rec.vaei_information4, hr_api.g_varchar2) <>
291: nvl(p_rec.vaei_information4, hr_api.g_varchar2) or
292: nvl(pqp_vai_shd.g_old_rec.vaei_information5, hr_api.g_varchar2) <>
293: nvl(p_rec.vaei_information5, hr_api.g_varchar2) or
294: nvl(pqp_vai_shd.g_old_rec.vaei_information6, hr_api.g_varchar2) <>
295: nvl(p_rec.vaei_information6, hr_api.g_varchar2) or
296: nvl(pqp_vai_shd.g_old_rec.vaei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.vaei_information3, hr_api.g_varchar2) or
290: nvl(pqp_vai_shd.g_old_rec.vaei_information4, hr_api.g_varchar2) <>
291: nvl(p_rec.vaei_information4, hr_api.g_varchar2) or
292: nvl(pqp_vai_shd.g_old_rec.vaei_information5, hr_api.g_varchar2) <>
293: nvl(p_rec.vaei_information5, hr_api.g_varchar2) or
294: nvl(pqp_vai_shd.g_old_rec.vaei_information6, hr_api.g_varchar2) <>
295: nvl(p_rec.vaei_information6, hr_api.g_varchar2) or
296: nvl(pqp_vai_shd.g_old_rec.vaei_information7, hr_api.g_varchar2) <>
297: nvl(p_rec.vaei_information7, hr_api.g_varchar2) or
290: nvl(pqp_vai_shd.g_old_rec.vaei_information4, hr_api.g_varchar2) <>
291: nvl(p_rec.vaei_information4, hr_api.g_varchar2) or
292: nvl(pqp_vai_shd.g_old_rec.vaei_information5, hr_api.g_varchar2) <>
293: nvl(p_rec.vaei_information5, hr_api.g_varchar2) or
294: nvl(pqp_vai_shd.g_old_rec.vaei_information6, hr_api.g_varchar2) <>
295: nvl(p_rec.vaei_information6, hr_api.g_varchar2) or
296: nvl(pqp_vai_shd.g_old_rec.vaei_information7, hr_api.g_varchar2) <>
297: nvl(p_rec.vaei_information7, hr_api.g_varchar2) or
298: nvl(pqp_vai_shd.g_old_rec.vaei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.vaei_information4, hr_api.g_varchar2) or
292: nvl(pqp_vai_shd.g_old_rec.vaei_information5, hr_api.g_varchar2) <>
293: nvl(p_rec.vaei_information5, hr_api.g_varchar2) or
294: nvl(pqp_vai_shd.g_old_rec.vaei_information6, hr_api.g_varchar2) <>
295: nvl(p_rec.vaei_information6, hr_api.g_varchar2) or
296: nvl(pqp_vai_shd.g_old_rec.vaei_information7, hr_api.g_varchar2) <>
297: nvl(p_rec.vaei_information7, hr_api.g_varchar2) or
298: nvl(pqp_vai_shd.g_old_rec.vaei_information8, hr_api.g_varchar2) <>
299: nvl(p_rec.vaei_information8, hr_api.g_varchar2) or
292: nvl(pqp_vai_shd.g_old_rec.vaei_information5, hr_api.g_varchar2) <>
293: nvl(p_rec.vaei_information5, hr_api.g_varchar2) or
294: nvl(pqp_vai_shd.g_old_rec.vaei_information6, hr_api.g_varchar2) <>
295: nvl(p_rec.vaei_information6, hr_api.g_varchar2) or
296: nvl(pqp_vai_shd.g_old_rec.vaei_information7, hr_api.g_varchar2) <>
297: nvl(p_rec.vaei_information7, hr_api.g_varchar2) or
298: nvl(pqp_vai_shd.g_old_rec.vaei_information8, hr_api.g_varchar2) <>
299: nvl(p_rec.vaei_information8, hr_api.g_varchar2) or
300: nvl(pqp_vai_shd.g_old_rec.vaei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.vaei_information5, hr_api.g_varchar2) or
294: nvl(pqp_vai_shd.g_old_rec.vaei_information6, hr_api.g_varchar2) <>
295: nvl(p_rec.vaei_information6, hr_api.g_varchar2) or
296: nvl(pqp_vai_shd.g_old_rec.vaei_information7, hr_api.g_varchar2) <>
297: nvl(p_rec.vaei_information7, hr_api.g_varchar2) or
298: nvl(pqp_vai_shd.g_old_rec.vaei_information8, hr_api.g_varchar2) <>
299: nvl(p_rec.vaei_information8, hr_api.g_varchar2) or
300: nvl(pqp_vai_shd.g_old_rec.vaei_information9, hr_api.g_varchar2) <>
301: nvl(p_rec.vaei_information9, hr_api.g_varchar2) or
294: nvl(pqp_vai_shd.g_old_rec.vaei_information6, hr_api.g_varchar2) <>
295: nvl(p_rec.vaei_information6, hr_api.g_varchar2) or
296: nvl(pqp_vai_shd.g_old_rec.vaei_information7, hr_api.g_varchar2) <>
297: nvl(p_rec.vaei_information7, hr_api.g_varchar2) or
298: nvl(pqp_vai_shd.g_old_rec.vaei_information8, hr_api.g_varchar2) <>
299: nvl(p_rec.vaei_information8, hr_api.g_varchar2) or
300: nvl(pqp_vai_shd.g_old_rec.vaei_information9, hr_api.g_varchar2) <>
301: nvl(p_rec.vaei_information9, hr_api.g_varchar2) or
302: nvl(pqp_vai_shd.g_old_rec.vaei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.vaei_information6, hr_api.g_varchar2) or
296: nvl(pqp_vai_shd.g_old_rec.vaei_information7, hr_api.g_varchar2) <>
297: nvl(p_rec.vaei_information7, hr_api.g_varchar2) or
298: nvl(pqp_vai_shd.g_old_rec.vaei_information8, hr_api.g_varchar2) <>
299: nvl(p_rec.vaei_information8, hr_api.g_varchar2) or
300: nvl(pqp_vai_shd.g_old_rec.vaei_information9, hr_api.g_varchar2) <>
301: nvl(p_rec.vaei_information9, hr_api.g_varchar2) or
302: nvl(pqp_vai_shd.g_old_rec.vaei_information10, hr_api.g_varchar2) <>
303: nvl(p_rec.vaei_information10, hr_api.g_varchar2) or
296: nvl(pqp_vai_shd.g_old_rec.vaei_information7, hr_api.g_varchar2) <>
297: nvl(p_rec.vaei_information7, hr_api.g_varchar2) or
298: nvl(pqp_vai_shd.g_old_rec.vaei_information8, hr_api.g_varchar2) <>
299: nvl(p_rec.vaei_information8, hr_api.g_varchar2) or
300: nvl(pqp_vai_shd.g_old_rec.vaei_information9, hr_api.g_varchar2) <>
301: nvl(p_rec.vaei_information9, hr_api.g_varchar2) or
302: nvl(pqp_vai_shd.g_old_rec.vaei_information10, hr_api.g_varchar2) <>
303: nvl(p_rec.vaei_information10, hr_api.g_varchar2) or
304: nvl(pqp_vai_shd.g_old_rec.vaei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.vaei_information7, hr_api.g_varchar2) or
298: nvl(pqp_vai_shd.g_old_rec.vaei_information8, hr_api.g_varchar2) <>
299: nvl(p_rec.vaei_information8, hr_api.g_varchar2) or
300: nvl(pqp_vai_shd.g_old_rec.vaei_information9, hr_api.g_varchar2) <>
301: nvl(p_rec.vaei_information9, hr_api.g_varchar2) or
302: nvl(pqp_vai_shd.g_old_rec.vaei_information10, hr_api.g_varchar2) <>
303: nvl(p_rec.vaei_information10, hr_api.g_varchar2) or
304: nvl(pqp_vai_shd.g_old_rec.vaei_information11, hr_api.g_varchar2) <>
305: nvl(p_rec.vaei_information11, hr_api.g_varchar2) or
298: nvl(pqp_vai_shd.g_old_rec.vaei_information8, hr_api.g_varchar2) <>
299: nvl(p_rec.vaei_information8, hr_api.g_varchar2) or
300: nvl(pqp_vai_shd.g_old_rec.vaei_information9, hr_api.g_varchar2) <>
301: nvl(p_rec.vaei_information9, hr_api.g_varchar2) or
302: nvl(pqp_vai_shd.g_old_rec.vaei_information10, hr_api.g_varchar2) <>
303: nvl(p_rec.vaei_information10, hr_api.g_varchar2) or
304: nvl(pqp_vai_shd.g_old_rec.vaei_information11, hr_api.g_varchar2) <>
305: nvl(p_rec.vaei_information11, hr_api.g_varchar2) or
306: nvl(pqp_vai_shd.g_old_rec.vaei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.vaei_information8, hr_api.g_varchar2) or
300: nvl(pqp_vai_shd.g_old_rec.vaei_information9, hr_api.g_varchar2) <>
301: nvl(p_rec.vaei_information9, hr_api.g_varchar2) or
302: nvl(pqp_vai_shd.g_old_rec.vaei_information10, hr_api.g_varchar2) <>
303: nvl(p_rec.vaei_information10, hr_api.g_varchar2) or
304: nvl(pqp_vai_shd.g_old_rec.vaei_information11, hr_api.g_varchar2) <>
305: nvl(p_rec.vaei_information11, hr_api.g_varchar2) or
306: nvl(pqp_vai_shd.g_old_rec.vaei_information12, hr_api.g_varchar2) <>
307: nvl(p_rec.vaei_information12, hr_api.g_varchar2) or
300: nvl(pqp_vai_shd.g_old_rec.vaei_information9, hr_api.g_varchar2) <>
301: nvl(p_rec.vaei_information9, hr_api.g_varchar2) or
302: nvl(pqp_vai_shd.g_old_rec.vaei_information10, hr_api.g_varchar2) <>
303: nvl(p_rec.vaei_information10, hr_api.g_varchar2) or
304: nvl(pqp_vai_shd.g_old_rec.vaei_information11, hr_api.g_varchar2) <>
305: nvl(p_rec.vaei_information11, hr_api.g_varchar2) or
306: nvl(pqp_vai_shd.g_old_rec.vaei_information12, hr_api.g_varchar2) <>
307: nvl(p_rec.vaei_information12, hr_api.g_varchar2) or
308: nvl(pqp_vai_shd.g_old_rec.vaei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.vaei_information9, hr_api.g_varchar2) or
302: nvl(pqp_vai_shd.g_old_rec.vaei_information10, hr_api.g_varchar2) <>
303: nvl(p_rec.vaei_information10, hr_api.g_varchar2) or
304: nvl(pqp_vai_shd.g_old_rec.vaei_information11, hr_api.g_varchar2) <>
305: nvl(p_rec.vaei_information11, hr_api.g_varchar2) or
306: nvl(pqp_vai_shd.g_old_rec.vaei_information12, hr_api.g_varchar2) <>
307: nvl(p_rec.vaei_information12, hr_api.g_varchar2) or
308: nvl(pqp_vai_shd.g_old_rec.vaei_information13, hr_api.g_varchar2) <>
309: nvl(p_rec.vaei_information13, hr_api.g_varchar2) or
302: nvl(pqp_vai_shd.g_old_rec.vaei_information10, hr_api.g_varchar2) <>
303: nvl(p_rec.vaei_information10, hr_api.g_varchar2) or
304: nvl(pqp_vai_shd.g_old_rec.vaei_information11, hr_api.g_varchar2) <>
305: nvl(p_rec.vaei_information11, hr_api.g_varchar2) or
306: nvl(pqp_vai_shd.g_old_rec.vaei_information12, hr_api.g_varchar2) <>
307: nvl(p_rec.vaei_information12, hr_api.g_varchar2) or
308: nvl(pqp_vai_shd.g_old_rec.vaei_information13, hr_api.g_varchar2) <>
309: nvl(p_rec.vaei_information13, hr_api.g_varchar2) or
310: nvl(pqp_vai_shd.g_old_rec.vaei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.vaei_information10, hr_api.g_varchar2) or
304: nvl(pqp_vai_shd.g_old_rec.vaei_information11, hr_api.g_varchar2) <>
305: nvl(p_rec.vaei_information11, hr_api.g_varchar2) or
306: nvl(pqp_vai_shd.g_old_rec.vaei_information12, hr_api.g_varchar2) <>
307: nvl(p_rec.vaei_information12, hr_api.g_varchar2) or
308: nvl(pqp_vai_shd.g_old_rec.vaei_information13, hr_api.g_varchar2) <>
309: nvl(p_rec.vaei_information13, hr_api.g_varchar2) or
310: nvl(pqp_vai_shd.g_old_rec.vaei_information14, hr_api.g_varchar2) <>
311: nvl(p_rec.vaei_information14, hr_api.g_varchar2) or
304: nvl(pqp_vai_shd.g_old_rec.vaei_information11, hr_api.g_varchar2) <>
305: nvl(p_rec.vaei_information11, hr_api.g_varchar2) or
306: nvl(pqp_vai_shd.g_old_rec.vaei_information12, hr_api.g_varchar2) <>
307: nvl(p_rec.vaei_information12, hr_api.g_varchar2) or
308: nvl(pqp_vai_shd.g_old_rec.vaei_information13, hr_api.g_varchar2) <>
309: nvl(p_rec.vaei_information13, hr_api.g_varchar2) or
310: nvl(pqp_vai_shd.g_old_rec.vaei_information14, hr_api.g_varchar2) <>
311: nvl(p_rec.vaei_information14, hr_api.g_varchar2) or
312: nvl(pqp_vai_shd.g_old_rec.vaei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.vaei_information11, hr_api.g_varchar2) or
306: nvl(pqp_vai_shd.g_old_rec.vaei_information12, hr_api.g_varchar2) <>
307: nvl(p_rec.vaei_information12, hr_api.g_varchar2) or
308: nvl(pqp_vai_shd.g_old_rec.vaei_information13, hr_api.g_varchar2) <>
309: nvl(p_rec.vaei_information13, hr_api.g_varchar2) or
310: nvl(pqp_vai_shd.g_old_rec.vaei_information14, hr_api.g_varchar2) <>
311: nvl(p_rec.vaei_information14, hr_api.g_varchar2) or
312: nvl(pqp_vai_shd.g_old_rec.vaei_information15, hr_api.g_varchar2) <>
313: nvl(p_rec.vaei_information15, hr_api.g_varchar2) or
306: nvl(pqp_vai_shd.g_old_rec.vaei_information12, hr_api.g_varchar2) <>
307: nvl(p_rec.vaei_information12, hr_api.g_varchar2) or
308: nvl(pqp_vai_shd.g_old_rec.vaei_information13, hr_api.g_varchar2) <>
309: nvl(p_rec.vaei_information13, hr_api.g_varchar2) or
310: nvl(pqp_vai_shd.g_old_rec.vaei_information14, hr_api.g_varchar2) <>
311: nvl(p_rec.vaei_information14, hr_api.g_varchar2) or
312: nvl(pqp_vai_shd.g_old_rec.vaei_information15, hr_api.g_varchar2) <>
313: nvl(p_rec.vaei_information15, hr_api.g_varchar2) or
314: nvl(pqp_vai_shd.g_old_rec.vaei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.vaei_information12, hr_api.g_varchar2) or
308: nvl(pqp_vai_shd.g_old_rec.vaei_information13, hr_api.g_varchar2) <>
309: nvl(p_rec.vaei_information13, hr_api.g_varchar2) or
310: nvl(pqp_vai_shd.g_old_rec.vaei_information14, hr_api.g_varchar2) <>
311: nvl(p_rec.vaei_information14, hr_api.g_varchar2) or
312: nvl(pqp_vai_shd.g_old_rec.vaei_information15, hr_api.g_varchar2) <>
313: nvl(p_rec.vaei_information15, hr_api.g_varchar2) or
314: nvl(pqp_vai_shd.g_old_rec.vaei_information16, hr_api.g_varchar2) <>
315: nvl(p_rec.vaei_information16, hr_api.g_varchar2) or
308: nvl(pqp_vai_shd.g_old_rec.vaei_information13, hr_api.g_varchar2) <>
309: nvl(p_rec.vaei_information13, hr_api.g_varchar2) or
310: nvl(pqp_vai_shd.g_old_rec.vaei_information14, hr_api.g_varchar2) <>
311: nvl(p_rec.vaei_information14, hr_api.g_varchar2) or
312: nvl(pqp_vai_shd.g_old_rec.vaei_information15, hr_api.g_varchar2) <>
313: nvl(p_rec.vaei_information15, hr_api.g_varchar2) or
314: nvl(pqp_vai_shd.g_old_rec.vaei_information16, hr_api.g_varchar2) <>
315: nvl(p_rec.vaei_information16, hr_api.g_varchar2) or
316: nvl(pqp_vai_shd.g_old_rec.vaei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.vaei_information13, hr_api.g_varchar2) or
310: nvl(pqp_vai_shd.g_old_rec.vaei_information14, hr_api.g_varchar2) <>
311: nvl(p_rec.vaei_information14, hr_api.g_varchar2) or
312: nvl(pqp_vai_shd.g_old_rec.vaei_information15, hr_api.g_varchar2) <>
313: nvl(p_rec.vaei_information15, hr_api.g_varchar2) or
314: nvl(pqp_vai_shd.g_old_rec.vaei_information16, hr_api.g_varchar2) <>
315: nvl(p_rec.vaei_information16, hr_api.g_varchar2) or
316: nvl(pqp_vai_shd.g_old_rec.vaei_information17, hr_api.g_varchar2) <>
317: nvl(p_rec.vaei_information17, hr_api.g_varchar2) or
310: nvl(pqp_vai_shd.g_old_rec.vaei_information14, hr_api.g_varchar2) <>
311: nvl(p_rec.vaei_information14, hr_api.g_varchar2) or
312: nvl(pqp_vai_shd.g_old_rec.vaei_information15, hr_api.g_varchar2) <>
313: nvl(p_rec.vaei_information15, hr_api.g_varchar2) or
314: nvl(pqp_vai_shd.g_old_rec.vaei_information16, hr_api.g_varchar2) <>
315: nvl(p_rec.vaei_information16, hr_api.g_varchar2) or
316: nvl(pqp_vai_shd.g_old_rec.vaei_information17, hr_api.g_varchar2) <>
317: nvl(p_rec.vaei_information17, hr_api.g_varchar2) or
318: nvl(pqp_vai_shd.g_old_rec.vaei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.vaei_information14, hr_api.g_varchar2) or
312: nvl(pqp_vai_shd.g_old_rec.vaei_information15, hr_api.g_varchar2) <>
313: nvl(p_rec.vaei_information15, hr_api.g_varchar2) or
314: nvl(pqp_vai_shd.g_old_rec.vaei_information16, hr_api.g_varchar2) <>
315: nvl(p_rec.vaei_information16, hr_api.g_varchar2) or
316: nvl(pqp_vai_shd.g_old_rec.vaei_information17, hr_api.g_varchar2) <>
317: nvl(p_rec.vaei_information17, hr_api.g_varchar2) or
318: nvl(pqp_vai_shd.g_old_rec.vaei_information18, hr_api.g_varchar2) <>
319: nvl(p_rec.vaei_information18, hr_api.g_varchar2) or
312: nvl(pqp_vai_shd.g_old_rec.vaei_information15, hr_api.g_varchar2) <>
313: nvl(p_rec.vaei_information15, hr_api.g_varchar2) or
314: nvl(pqp_vai_shd.g_old_rec.vaei_information16, hr_api.g_varchar2) <>
315: nvl(p_rec.vaei_information16, hr_api.g_varchar2) or
316: nvl(pqp_vai_shd.g_old_rec.vaei_information17, hr_api.g_varchar2) <>
317: nvl(p_rec.vaei_information17, hr_api.g_varchar2) or
318: nvl(pqp_vai_shd.g_old_rec.vaei_information18, hr_api.g_varchar2) <>
319: nvl(p_rec.vaei_information18, hr_api.g_varchar2) or
320: nvl(pqp_vai_shd.g_old_rec.vaei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.vaei_information15, hr_api.g_varchar2) or
314: nvl(pqp_vai_shd.g_old_rec.vaei_information16, hr_api.g_varchar2) <>
315: nvl(p_rec.vaei_information16, hr_api.g_varchar2) or
316: nvl(pqp_vai_shd.g_old_rec.vaei_information17, hr_api.g_varchar2) <>
317: nvl(p_rec.vaei_information17, hr_api.g_varchar2) or
318: nvl(pqp_vai_shd.g_old_rec.vaei_information18, hr_api.g_varchar2) <>
319: nvl(p_rec.vaei_information18, hr_api.g_varchar2) or
320: nvl(pqp_vai_shd.g_old_rec.vaei_information19, hr_api.g_varchar2) <>
321: nvl(p_rec.vaei_information19, hr_api.g_varchar2) or
314: nvl(pqp_vai_shd.g_old_rec.vaei_information16, hr_api.g_varchar2) <>
315: nvl(p_rec.vaei_information16, hr_api.g_varchar2) or
316: nvl(pqp_vai_shd.g_old_rec.vaei_information17, hr_api.g_varchar2) <>
317: nvl(p_rec.vaei_information17, hr_api.g_varchar2) or
318: nvl(pqp_vai_shd.g_old_rec.vaei_information18, hr_api.g_varchar2) <>
319: nvl(p_rec.vaei_information18, hr_api.g_varchar2) or
320: nvl(pqp_vai_shd.g_old_rec.vaei_information19, hr_api.g_varchar2) <>
321: nvl(p_rec.vaei_information19, hr_api.g_varchar2) or
322: nvl(pqp_vai_shd.g_old_rec.vaei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.vaei_information16, hr_api.g_varchar2) or
316: nvl(pqp_vai_shd.g_old_rec.vaei_information17, hr_api.g_varchar2) <>
317: nvl(p_rec.vaei_information17, hr_api.g_varchar2) or
318: nvl(pqp_vai_shd.g_old_rec.vaei_information18, hr_api.g_varchar2) <>
319: nvl(p_rec.vaei_information18, hr_api.g_varchar2) or
320: nvl(pqp_vai_shd.g_old_rec.vaei_information19, hr_api.g_varchar2) <>
321: nvl(p_rec.vaei_information19, hr_api.g_varchar2) or
322: nvl(pqp_vai_shd.g_old_rec.vaei_information20, hr_api.g_varchar2) <>
323: nvl(p_rec.vaei_information20, hr_api.g_varchar2) or
316: nvl(pqp_vai_shd.g_old_rec.vaei_information17, hr_api.g_varchar2) <>
317: nvl(p_rec.vaei_information17, hr_api.g_varchar2) or
318: nvl(pqp_vai_shd.g_old_rec.vaei_information18, hr_api.g_varchar2) <>
319: nvl(p_rec.vaei_information18, hr_api.g_varchar2) or
320: nvl(pqp_vai_shd.g_old_rec.vaei_information19, hr_api.g_varchar2) <>
321: nvl(p_rec.vaei_information19, hr_api.g_varchar2) or
322: nvl(pqp_vai_shd.g_old_rec.vaei_information20, hr_api.g_varchar2) <>
323: nvl(p_rec.vaei_information20, hr_api.g_varchar2) or
324: nvl(pqp_vai_shd.g_old_rec.vaei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.vaei_information17, hr_api.g_varchar2) or
318: nvl(pqp_vai_shd.g_old_rec.vaei_information18, hr_api.g_varchar2) <>
319: nvl(p_rec.vaei_information18, hr_api.g_varchar2) or
320: nvl(pqp_vai_shd.g_old_rec.vaei_information19, hr_api.g_varchar2) <>
321: nvl(p_rec.vaei_information19, hr_api.g_varchar2) or
322: nvl(pqp_vai_shd.g_old_rec.vaei_information20, hr_api.g_varchar2) <>
323: nvl(p_rec.vaei_information20, hr_api.g_varchar2) or
324: nvl(pqp_vai_shd.g_old_rec.vaei_information21, hr_api.g_varchar2) <>
325: nvl(p_rec.vaei_information21, hr_api.g_varchar2) or
318: nvl(pqp_vai_shd.g_old_rec.vaei_information18, hr_api.g_varchar2) <>
319: nvl(p_rec.vaei_information18, hr_api.g_varchar2) or
320: nvl(pqp_vai_shd.g_old_rec.vaei_information19, hr_api.g_varchar2) <>
321: nvl(p_rec.vaei_information19, hr_api.g_varchar2) or
322: nvl(pqp_vai_shd.g_old_rec.vaei_information20, hr_api.g_varchar2) <>
323: nvl(p_rec.vaei_information20, hr_api.g_varchar2) or
324: nvl(pqp_vai_shd.g_old_rec.vaei_information21, hr_api.g_varchar2) <>
325: nvl(p_rec.vaei_information21, hr_api.g_varchar2) or
326: nvl(pqp_vai_shd.g_old_rec.vaei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.vaei_information18, hr_api.g_varchar2) or
320: nvl(pqp_vai_shd.g_old_rec.vaei_information19, hr_api.g_varchar2) <>
321: nvl(p_rec.vaei_information19, hr_api.g_varchar2) or
322: nvl(pqp_vai_shd.g_old_rec.vaei_information20, hr_api.g_varchar2) <>
323: nvl(p_rec.vaei_information20, hr_api.g_varchar2) or
324: nvl(pqp_vai_shd.g_old_rec.vaei_information21, hr_api.g_varchar2) <>
325: nvl(p_rec.vaei_information21, hr_api.g_varchar2) or
326: nvl(pqp_vai_shd.g_old_rec.vaei_information22, hr_api.g_varchar2) <>
327: nvl(p_rec.vaei_information22, hr_api.g_varchar2) or
320: nvl(pqp_vai_shd.g_old_rec.vaei_information19, hr_api.g_varchar2) <>
321: nvl(p_rec.vaei_information19, hr_api.g_varchar2) or
322: nvl(pqp_vai_shd.g_old_rec.vaei_information20, hr_api.g_varchar2) <>
323: nvl(p_rec.vaei_information20, hr_api.g_varchar2) or
324: nvl(pqp_vai_shd.g_old_rec.vaei_information21, hr_api.g_varchar2) <>
325: nvl(p_rec.vaei_information21, hr_api.g_varchar2) or
326: nvl(pqp_vai_shd.g_old_rec.vaei_information22, hr_api.g_varchar2) <>
327: nvl(p_rec.vaei_information22, hr_api.g_varchar2) or
328: nvl(pqp_vai_shd.g_old_rec.vaei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.vaei_information19, hr_api.g_varchar2) or
322: nvl(pqp_vai_shd.g_old_rec.vaei_information20, hr_api.g_varchar2) <>
323: nvl(p_rec.vaei_information20, hr_api.g_varchar2) or
324: nvl(pqp_vai_shd.g_old_rec.vaei_information21, hr_api.g_varchar2) <>
325: nvl(p_rec.vaei_information21, hr_api.g_varchar2) or
326: nvl(pqp_vai_shd.g_old_rec.vaei_information22, hr_api.g_varchar2) <>
327: nvl(p_rec.vaei_information22, hr_api.g_varchar2) or
328: nvl(pqp_vai_shd.g_old_rec.vaei_information23, hr_api.g_varchar2) <>
329: nvl(p_rec.vaei_information23, hr_api.g_varchar2) or
322: nvl(pqp_vai_shd.g_old_rec.vaei_information20, hr_api.g_varchar2) <>
323: nvl(p_rec.vaei_information20, hr_api.g_varchar2) or
324: nvl(pqp_vai_shd.g_old_rec.vaei_information21, hr_api.g_varchar2) <>
325: nvl(p_rec.vaei_information21, hr_api.g_varchar2) or
326: nvl(pqp_vai_shd.g_old_rec.vaei_information22, hr_api.g_varchar2) <>
327: nvl(p_rec.vaei_information22, hr_api.g_varchar2) or
328: nvl(pqp_vai_shd.g_old_rec.vaei_information23, hr_api.g_varchar2) <>
329: nvl(p_rec.vaei_information23, hr_api.g_varchar2) or
330: nvl(pqp_vai_shd.g_old_rec.vaei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.vaei_information20, hr_api.g_varchar2) or
324: nvl(pqp_vai_shd.g_old_rec.vaei_information21, hr_api.g_varchar2) <>
325: nvl(p_rec.vaei_information21, hr_api.g_varchar2) or
326: nvl(pqp_vai_shd.g_old_rec.vaei_information22, hr_api.g_varchar2) <>
327: nvl(p_rec.vaei_information22, hr_api.g_varchar2) or
328: nvl(pqp_vai_shd.g_old_rec.vaei_information23, hr_api.g_varchar2) <>
329: nvl(p_rec.vaei_information23, hr_api.g_varchar2) or
330: nvl(pqp_vai_shd.g_old_rec.vaei_information24, hr_api.g_varchar2) <>
331: nvl(p_rec.vaei_information24, hr_api.g_varchar2) or
324: nvl(pqp_vai_shd.g_old_rec.vaei_information21, hr_api.g_varchar2) <>
325: nvl(p_rec.vaei_information21, hr_api.g_varchar2) or
326: nvl(pqp_vai_shd.g_old_rec.vaei_information22, hr_api.g_varchar2) <>
327: nvl(p_rec.vaei_information22, hr_api.g_varchar2) or
328: nvl(pqp_vai_shd.g_old_rec.vaei_information23, hr_api.g_varchar2) <>
329: nvl(p_rec.vaei_information23, hr_api.g_varchar2) or
330: nvl(pqp_vai_shd.g_old_rec.vaei_information24, hr_api.g_varchar2) <>
331: nvl(p_rec.vaei_information24, hr_api.g_varchar2) or
332: nvl(pqp_vai_shd.g_old_rec.vaei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.vaei_information21, hr_api.g_varchar2) or
326: nvl(pqp_vai_shd.g_old_rec.vaei_information22, hr_api.g_varchar2) <>
327: nvl(p_rec.vaei_information22, hr_api.g_varchar2) or
328: nvl(pqp_vai_shd.g_old_rec.vaei_information23, hr_api.g_varchar2) <>
329: nvl(p_rec.vaei_information23, hr_api.g_varchar2) or
330: nvl(pqp_vai_shd.g_old_rec.vaei_information24, hr_api.g_varchar2) <>
331: nvl(p_rec.vaei_information24, hr_api.g_varchar2) or
332: nvl(pqp_vai_shd.g_old_rec.vaei_information25, hr_api.g_varchar2) <>
333: nvl(p_rec.vaei_information25, hr_api.g_varchar2) or
326: nvl(pqp_vai_shd.g_old_rec.vaei_information22, hr_api.g_varchar2) <>
327: nvl(p_rec.vaei_information22, hr_api.g_varchar2) or
328: nvl(pqp_vai_shd.g_old_rec.vaei_information23, hr_api.g_varchar2) <>
329: nvl(p_rec.vaei_information23, hr_api.g_varchar2) or
330: nvl(pqp_vai_shd.g_old_rec.vaei_information24, hr_api.g_varchar2) <>
331: nvl(p_rec.vaei_information24, hr_api.g_varchar2) or
332: nvl(pqp_vai_shd.g_old_rec.vaei_information25, hr_api.g_varchar2) <>
333: nvl(p_rec.vaei_information25, hr_api.g_varchar2) or
334: nvl(pqp_vai_shd.g_old_rec.vaei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.vaei_information22, hr_api.g_varchar2) or
328: nvl(pqp_vai_shd.g_old_rec.vaei_information23, hr_api.g_varchar2) <>
329: nvl(p_rec.vaei_information23, hr_api.g_varchar2) or
330: nvl(pqp_vai_shd.g_old_rec.vaei_information24, hr_api.g_varchar2) <>
331: nvl(p_rec.vaei_information24, hr_api.g_varchar2) or
332: nvl(pqp_vai_shd.g_old_rec.vaei_information25, hr_api.g_varchar2) <>
333: nvl(p_rec.vaei_information25, hr_api.g_varchar2) or
334: nvl(pqp_vai_shd.g_old_rec.vaei_information26, hr_api.g_varchar2) <>
335: nvl(p_rec.vaei_information26, hr_api.g_varchar2) or
328: nvl(pqp_vai_shd.g_old_rec.vaei_information23, hr_api.g_varchar2) <>
329: nvl(p_rec.vaei_information23, hr_api.g_varchar2) or
330: nvl(pqp_vai_shd.g_old_rec.vaei_information24, hr_api.g_varchar2) <>
331: nvl(p_rec.vaei_information24, hr_api.g_varchar2) or
332: nvl(pqp_vai_shd.g_old_rec.vaei_information25, hr_api.g_varchar2) <>
333: nvl(p_rec.vaei_information25, hr_api.g_varchar2) or
334: nvl(pqp_vai_shd.g_old_rec.vaei_information26, hr_api.g_varchar2) <>
335: nvl(p_rec.vaei_information26, hr_api.g_varchar2) or
336: nvl(pqp_vai_shd.g_old_rec.vaei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.vaei_information23, hr_api.g_varchar2) or
330: nvl(pqp_vai_shd.g_old_rec.vaei_information24, hr_api.g_varchar2) <>
331: nvl(p_rec.vaei_information24, hr_api.g_varchar2) or
332: nvl(pqp_vai_shd.g_old_rec.vaei_information25, hr_api.g_varchar2) <>
333: nvl(p_rec.vaei_information25, hr_api.g_varchar2) or
334: nvl(pqp_vai_shd.g_old_rec.vaei_information26, hr_api.g_varchar2) <>
335: nvl(p_rec.vaei_information26, hr_api.g_varchar2) or
336: nvl(pqp_vai_shd.g_old_rec.vaei_information27, hr_api.g_varchar2) <>
337: nvl(p_rec.vaei_information27, hr_api.g_varchar2) or
330: nvl(pqp_vai_shd.g_old_rec.vaei_information24, hr_api.g_varchar2) <>
331: nvl(p_rec.vaei_information24, hr_api.g_varchar2) or
332: nvl(pqp_vai_shd.g_old_rec.vaei_information25, hr_api.g_varchar2) <>
333: nvl(p_rec.vaei_information25, hr_api.g_varchar2) or
334: nvl(pqp_vai_shd.g_old_rec.vaei_information26, hr_api.g_varchar2) <>
335: nvl(p_rec.vaei_information26, hr_api.g_varchar2) or
336: nvl(pqp_vai_shd.g_old_rec.vaei_information27, hr_api.g_varchar2) <>
337: nvl(p_rec.vaei_information27, hr_api.g_varchar2) or
338: nvl(pqp_vai_shd.g_old_rec.vaei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.vaei_information24, hr_api.g_varchar2) or
332: nvl(pqp_vai_shd.g_old_rec.vaei_information25, hr_api.g_varchar2) <>
333: nvl(p_rec.vaei_information25, hr_api.g_varchar2) or
334: nvl(pqp_vai_shd.g_old_rec.vaei_information26, hr_api.g_varchar2) <>
335: nvl(p_rec.vaei_information26, hr_api.g_varchar2) or
336: nvl(pqp_vai_shd.g_old_rec.vaei_information27, hr_api.g_varchar2) <>
337: nvl(p_rec.vaei_information27, hr_api.g_varchar2) or
338: nvl(pqp_vai_shd.g_old_rec.vaei_information28, hr_api.g_varchar2) <>
339: nvl(p_rec.vaei_information28, hr_api.g_varchar2) or
332: nvl(pqp_vai_shd.g_old_rec.vaei_information25, hr_api.g_varchar2) <>
333: nvl(p_rec.vaei_information25, hr_api.g_varchar2) or
334: nvl(pqp_vai_shd.g_old_rec.vaei_information26, hr_api.g_varchar2) <>
335: nvl(p_rec.vaei_information26, hr_api.g_varchar2) or
336: nvl(pqp_vai_shd.g_old_rec.vaei_information27, hr_api.g_varchar2) <>
337: nvl(p_rec.vaei_information27, hr_api.g_varchar2) or
338: nvl(pqp_vai_shd.g_old_rec.vaei_information28, hr_api.g_varchar2) <>
339: nvl(p_rec.vaei_information28, hr_api.g_varchar2) or
340: nvl(pqp_vai_shd.g_old_rec.vaei_information29, hr_api.g_varchar2) <>
333: nvl(p_rec.vaei_information25, hr_api.g_varchar2) or
334: nvl(pqp_vai_shd.g_old_rec.vaei_information26, hr_api.g_varchar2) <>
335: nvl(p_rec.vaei_information26, hr_api.g_varchar2) or
336: nvl(pqp_vai_shd.g_old_rec.vaei_information27, hr_api.g_varchar2) <>
337: nvl(p_rec.vaei_information27, hr_api.g_varchar2) or
338: nvl(pqp_vai_shd.g_old_rec.vaei_information28, hr_api.g_varchar2) <>
339: nvl(p_rec.vaei_information28, hr_api.g_varchar2) or
340: nvl(pqp_vai_shd.g_old_rec.vaei_information29, hr_api.g_varchar2) <>
341: nvl(p_rec.vaei_information29, hr_api.g_varchar2) or
334: nvl(pqp_vai_shd.g_old_rec.vaei_information26, hr_api.g_varchar2) <>
335: nvl(p_rec.vaei_information26, hr_api.g_varchar2) or
336: nvl(pqp_vai_shd.g_old_rec.vaei_information27, hr_api.g_varchar2) <>
337: nvl(p_rec.vaei_information27, hr_api.g_varchar2) or
338: nvl(pqp_vai_shd.g_old_rec.vaei_information28, hr_api.g_varchar2) <>
339: nvl(p_rec.vaei_information28, hr_api.g_varchar2) or
340: nvl(pqp_vai_shd.g_old_rec.vaei_information29, hr_api.g_varchar2) <>
341: nvl(p_rec.vaei_information29, hr_api.g_varchar2) or
342: nvl(pqp_vai_shd.g_old_rec.vaei_information30, hr_api.g_varchar2) <>
335: nvl(p_rec.vaei_information26, hr_api.g_varchar2) or
336: nvl(pqp_vai_shd.g_old_rec.vaei_information27, hr_api.g_varchar2) <>
337: nvl(p_rec.vaei_information27, hr_api.g_varchar2) or
338: nvl(pqp_vai_shd.g_old_rec.vaei_information28, hr_api.g_varchar2) <>
339: nvl(p_rec.vaei_information28, hr_api.g_varchar2) or
340: nvl(pqp_vai_shd.g_old_rec.vaei_information29, hr_api.g_varchar2) <>
341: nvl(p_rec.vaei_information29, hr_api.g_varchar2) or
342: nvl(pqp_vai_shd.g_old_rec.vaei_information30, hr_api.g_varchar2) <>
343: nvl(p_rec.vaei_information30, hr_api.g_varchar2) ))
336: nvl(pqp_vai_shd.g_old_rec.vaei_information27, hr_api.g_varchar2) <>
337: nvl(p_rec.vaei_information27, hr_api.g_varchar2) or
338: nvl(pqp_vai_shd.g_old_rec.vaei_information28, hr_api.g_varchar2) <>
339: nvl(p_rec.vaei_information28, hr_api.g_varchar2) or
340: nvl(pqp_vai_shd.g_old_rec.vaei_information29, hr_api.g_varchar2) <>
341: nvl(p_rec.vaei_information29, hr_api.g_varchar2) or
342: nvl(pqp_vai_shd.g_old_rec.vaei_information30, hr_api.g_varchar2) <>
343: nvl(p_rec.vaei_information30, hr_api.g_varchar2) ))
344: or (p_rec.veh_alloc_extra_info_id is null) then
337: nvl(p_rec.vaei_information27, hr_api.g_varchar2) or
338: nvl(pqp_vai_shd.g_old_rec.vaei_information28, hr_api.g_varchar2) <>
339: nvl(p_rec.vaei_information28, hr_api.g_varchar2) or
340: nvl(pqp_vai_shd.g_old_rec.vaei_information29, hr_api.g_varchar2) <>
341: nvl(p_rec.vaei_information29, hr_api.g_varchar2) or
342: nvl(pqp_vai_shd.g_old_rec.vaei_information30, hr_api.g_varchar2) <>
343: nvl(p_rec.vaei_information30, hr_api.g_varchar2) ))
344: or (p_rec.veh_alloc_extra_info_id is null) then
345: --
338: nvl(pqp_vai_shd.g_old_rec.vaei_information28, hr_api.g_varchar2) <>
339: nvl(p_rec.vaei_information28, hr_api.g_varchar2) or
340: nvl(pqp_vai_shd.g_old_rec.vaei_information29, hr_api.g_varchar2) <>
341: nvl(p_rec.vaei_information29, hr_api.g_varchar2) or
342: nvl(pqp_vai_shd.g_old_rec.vaei_information30, hr_api.g_varchar2) <>
343: nvl(p_rec.vaei_information30, hr_api.g_varchar2) ))
344: or (p_rec.veh_alloc_extra_info_id is null) then
345: --
346: -- Only execute the validation if absolutely necessary:
339: nvl(p_rec.vaei_information28, hr_api.g_varchar2) or
340: nvl(pqp_vai_shd.g_old_rec.vaei_information29, hr_api.g_varchar2) <>
341: nvl(p_rec.vaei_information29, hr_api.g_varchar2) or
342: nvl(pqp_vai_shd.g_old_rec.vaei_information30, hr_api.g_varchar2) <>
343: nvl(p_rec.vaei_information30, hr_api.g_varchar2) ))
344: or (p_rec.veh_alloc_extra_info_id is null) then
345: --
346: -- Only execute the validation if absolutely necessary:
347: -- a) During update, the structure column value or any
459: begin
460: hr_utility.set_location('Entering:'||l_proc,10);
461: --
462: if ((p_rec.veh_alloc_extra_info_id is not null) and (
463: nvl(pqp_vai_shd.g_old_rec.vaei_attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.vaei_attribute_category, hr_api.g_varchar2) or
465: nvl(pqp_vai_shd.g_old_rec.vaei_attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.vaei_attribute1, hr_api.g_varchar2) or
467: nvl(pqp_vai_shd.g_old_rec.vaei_attribute2, hr_api.g_varchar2) <>
460: hr_utility.set_location('Entering:'||l_proc,10);
461: --
462: if ((p_rec.veh_alloc_extra_info_id is not null) and (
463: nvl(pqp_vai_shd.g_old_rec.vaei_attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.vaei_attribute_category, hr_api.g_varchar2) or
465: nvl(pqp_vai_shd.g_old_rec.vaei_attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.vaei_attribute1, hr_api.g_varchar2) or
467: nvl(pqp_vai_shd.g_old_rec.vaei_attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.vaei_attribute2, hr_api.g_varchar2) or
461: --
462: if ((p_rec.veh_alloc_extra_info_id is not null) and (
463: nvl(pqp_vai_shd.g_old_rec.vaei_attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.vaei_attribute_category, hr_api.g_varchar2) or
465: nvl(pqp_vai_shd.g_old_rec.vaei_attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.vaei_attribute1, hr_api.g_varchar2) or
467: nvl(pqp_vai_shd.g_old_rec.vaei_attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.vaei_attribute2, hr_api.g_varchar2) or
469: nvl(pqp_vai_shd.g_old_rec.vaei_attribute3, hr_api.g_varchar2) <>
462: if ((p_rec.veh_alloc_extra_info_id is not null) and (
463: nvl(pqp_vai_shd.g_old_rec.vaei_attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.vaei_attribute_category, hr_api.g_varchar2) or
465: nvl(pqp_vai_shd.g_old_rec.vaei_attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.vaei_attribute1, hr_api.g_varchar2) or
467: nvl(pqp_vai_shd.g_old_rec.vaei_attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.vaei_attribute2, hr_api.g_varchar2) or
469: nvl(pqp_vai_shd.g_old_rec.vaei_attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.vaei_attribute3, hr_api.g_varchar2) or
463: nvl(pqp_vai_shd.g_old_rec.vaei_attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.vaei_attribute_category, hr_api.g_varchar2) or
465: nvl(pqp_vai_shd.g_old_rec.vaei_attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.vaei_attribute1, hr_api.g_varchar2) or
467: nvl(pqp_vai_shd.g_old_rec.vaei_attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.vaei_attribute2, hr_api.g_varchar2) or
469: nvl(pqp_vai_shd.g_old_rec.vaei_attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.vaei_attribute3, hr_api.g_varchar2) or
471: nvl(pqp_vai_shd.g_old_rec.vaei_attribute4, hr_api.g_varchar2) <>
464: nvl(p_rec.vaei_attribute_category, hr_api.g_varchar2) or
465: nvl(pqp_vai_shd.g_old_rec.vaei_attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.vaei_attribute1, hr_api.g_varchar2) or
467: nvl(pqp_vai_shd.g_old_rec.vaei_attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.vaei_attribute2, hr_api.g_varchar2) or
469: nvl(pqp_vai_shd.g_old_rec.vaei_attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.vaei_attribute3, hr_api.g_varchar2) or
471: nvl(pqp_vai_shd.g_old_rec.vaei_attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.vaei_attribute4, hr_api.g_varchar2) or
465: nvl(pqp_vai_shd.g_old_rec.vaei_attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.vaei_attribute1, hr_api.g_varchar2) or
467: nvl(pqp_vai_shd.g_old_rec.vaei_attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.vaei_attribute2, hr_api.g_varchar2) or
469: nvl(pqp_vai_shd.g_old_rec.vaei_attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.vaei_attribute3, hr_api.g_varchar2) or
471: nvl(pqp_vai_shd.g_old_rec.vaei_attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.vaei_attribute4, hr_api.g_varchar2) or
473: nvl(pqp_vai_shd.g_old_rec.vaei_attribute5, hr_api.g_varchar2) <>
466: nvl(p_rec.vaei_attribute1, hr_api.g_varchar2) or
467: nvl(pqp_vai_shd.g_old_rec.vaei_attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.vaei_attribute2, hr_api.g_varchar2) or
469: nvl(pqp_vai_shd.g_old_rec.vaei_attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.vaei_attribute3, hr_api.g_varchar2) or
471: nvl(pqp_vai_shd.g_old_rec.vaei_attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.vaei_attribute4, hr_api.g_varchar2) or
473: nvl(pqp_vai_shd.g_old_rec.vaei_attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.vaei_attribute5, hr_api.g_varchar2) or
467: nvl(pqp_vai_shd.g_old_rec.vaei_attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.vaei_attribute2, hr_api.g_varchar2) or
469: nvl(pqp_vai_shd.g_old_rec.vaei_attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.vaei_attribute3, hr_api.g_varchar2) or
471: nvl(pqp_vai_shd.g_old_rec.vaei_attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.vaei_attribute4, hr_api.g_varchar2) or
473: nvl(pqp_vai_shd.g_old_rec.vaei_attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.vaei_attribute5, hr_api.g_varchar2) or
475: nvl(pqp_vai_shd.g_old_rec.vaei_attribute6, hr_api.g_varchar2) <>
468: nvl(p_rec.vaei_attribute2, hr_api.g_varchar2) or
469: nvl(pqp_vai_shd.g_old_rec.vaei_attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.vaei_attribute3, hr_api.g_varchar2) or
471: nvl(pqp_vai_shd.g_old_rec.vaei_attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.vaei_attribute4, hr_api.g_varchar2) or
473: nvl(pqp_vai_shd.g_old_rec.vaei_attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.vaei_attribute5, hr_api.g_varchar2) or
475: nvl(pqp_vai_shd.g_old_rec.vaei_attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.vaei_attribute6, hr_api.g_varchar2) or
469: nvl(pqp_vai_shd.g_old_rec.vaei_attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.vaei_attribute3, hr_api.g_varchar2) or
471: nvl(pqp_vai_shd.g_old_rec.vaei_attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.vaei_attribute4, hr_api.g_varchar2) or
473: nvl(pqp_vai_shd.g_old_rec.vaei_attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.vaei_attribute5, hr_api.g_varchar2) or
475: nvl(pqp_vai_shd.g_old_rec.vaei_attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.vaei_attribute6, hr_api.g_varchar2) or
477: nvl(pqp_vai_shd.g_old_rec.vaei_attribute7, hr_api.g_varchar2) <>
470: nvl(p_rec.vaei_attribute3, hr_api.g_varchar2) or
471: nvl(pqp_vai_shd.g_old_rec.vaei_attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.vaei_attribute4, hr_api.g_varchar2) or
473: nvl(pqp_vai_shd.g_old_rec.vaei_attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.vaei_attribute5, hr_api.g_varchar2) or
475: nvl(pqp_vai_shd.g_old_rec.vaei_attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.vaei_attribute6, hr_api.g_varchar2) or
477: nvl(pqp_vai_shd.g_old_rec.vaei_attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.vaei_attribute7, hr_api.g_varchar2) or
471: nvl(pqp_vai_shd.g_old_rec.vaei_attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.vaei_attribute4, hr_api.g_varchar2) or
473: nvl(pqp_vai_shd.g_old_rec.vaei_attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.vaei_attribute5, hr_api.g_varchar2) or
475: nvl(pqp_vai_shd.g_old_rec.vaei_attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.vaei_attribute6, hr_api.g_varchar2) or
477: nvl(pqp_vai_shd.g_old_rec.vaei_attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.vaei_attribute7, hr_api.g_varchar2) or
479: nvl(pqp_vai_shd.g_old_rec.vaei_attribute8, hr_api.g_varchar2) <>
472: nvl(p_rec.vaei_attribute4, hr_api.g_varchar2) or
473: nvl(pqp_vai_shd.g_old_rec.vaei_attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.vaei_attribute5, hr_api.g_varchar2) or
475: nvl(pqp_vai_shd.g_old_rec.vaei_attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.vaei_attribute6, hr_api.g_varchar2) or
477: nvl(pqp_vai_shd.g_old_rec.vaei_attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.vaei_attribute7, hr_api.g_varchar2) or
479: nvl(pqp_vai_shd.g_old_rec.vaei_attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.vaei_attribute8, hr_api.g_varchar2) or
473: nvl(pqp_vai_shd.g_old_rec.vaei_attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.vaei_attribute5, hr_api.g_varchar2) or
475: nvl(pqp_vai_shd.g_old_rec.vaei_attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.vaei_attribute6, hr_api.g_varchar2) or
477: nvl(pqp_vai_shd.g_old_rec.vaei_attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.vaei_attribute7, hr_api.g_varchar2) or
479: nvl(pqp_vai_shd.g_old_rec.vaei_attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.vaei_attribute8, hr_api.g_varchar2) or
481: nvl(pqp_vai_shd.g_old_rec.vaei_attribute9, hr_api.g_varchar2) <>
474: nvl(p_rec.vaei_attribute5, hr_api.g_varchar2) or
475: nvl(pqp_vai_shd.g_old_rec.vaei_attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.vaei_attribute6, hr_api.g_varchar2) or
477: nvl(pqp_vai_shd.g_old_rec.vaei_attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.vaei_attribute7, hr_api.g_varchar2) or
479: nvl(pqp_vai_shd.g_old_rec.vaei_attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.vaei_attribute8, hr_api.g_varchar2) or
481: nvl(pqp_vai_shd.g_old_rec.vaei_attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.vaei_attribute9, hr_api.g_varchar2) or
475: nvl(pqp_vai_shd.g_old_rec.vaei_attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.vaei_attribute6, hr_api.g_varchar2) or
477: nvl(pqp_vai_shd.g_old_rec.vaei_attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.vaei_attribute7, hr_api.g_varchar2) or
479: nvl(pqp_vai_shd.g_old_rec.vaei_attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.vaei_attribute8, hr_api.g_varchar2) or
481: nvl(pqp_vai_shd.g_old_rec.vaei_attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.vaei_attribute9, hr_api.g_varchar2) or
483: nvl(pqp_vai_shd.g_old_rec.vaei_attribute10, hr_api.g_varchar2) <>
476: nvl(p_rec.vaei_attribute6, hr_api.g_varchar2) or
477: nvl(pqp_vai_shd.g_old_rec.vaei_attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.vaei_attribute7, hr_api.g_varchar2) or
479: nvl(pqp_vai_shd.g_old_rec.vaei_attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.vaei_attribute8, hr_api.g_varchar2) or
481: nvl(pqp_vai_shd.g_old_rec.vaei_attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.vaei_attribute9, hr_api.g_varchar2) or
483: nvl(pqp_vai_shd.g_old_rec.vaei_attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.vaei_attribute10, hr_api.g_varchar2) or
477: nvl(pqp_vai_shd.g_old_rec.vaei_attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.vaei_attribute7, hr_api.g_varchar2) or
479: nvl(pqp_vai_shd.g_old_rec.vaei_attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.vaei_attribute8, hr_api.g_varchar2) or
481: nvl(pqp_vai_shd.g_old_rec.vaei_attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.vaei_attribute9, hr_api.g_varchar2) or
483: nvl(pqp_vai_shd.g_old_rec.vaei_attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.vaei_attribute10, hr_api.g_varchar2) or
485: nvl(pqp_vai_shd.g_old_rec.vaei_attribute11, hr_api.g_varchar2) <>
478: nvl(p_rec.vaei_attribute7, hr_api.g_varchar2) or
479: nvl(pqp_vai_shd.g_old_rec.vaei_attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.vaei_attribute8, hr_api.g_varchar2) or
481: nvl(pqp_vai_shd.g_old_rec.vaei_attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.vaei_attribute9, hr_api.g_varchar2) or
483: nvl(pqp_vai_shd.g_old_rec.vaei_attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.vaei_attribute10, hr_api.g_varchar2) or
485: nvl(pqp_vai_shd.g_old_rec.vaei_attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.vaei_attribute11, hr_api.g_varchar2) or
479: nvl(pqp_vai_shd.g_old_rec.vaei_attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.vaei_attribute8, hr_api.g_varchar2) or
481: nvl(pqp_vai_shd.g_old_rec.vaei_attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.vaei_attribute9, hr_api.g_varchar2) or
483: nvl(pqp_vai_shd.g_old_rec.vaei_attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.vaei_attribute10, hr_api.g_varchar2) or
485: nvl(pqp_vai_shd.g_old_rec.vaei_attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.vaei_attribute11, hr_api.g_varchar2) or
487: nvl(pqp_vai_shd.g_old_rec.vaei_attribute12, hr_api.g_varchar2) <>
480: nvl(p_rec.vaei_attribute8, hr_api.g_varchar2) or
481: nvl(pqp_vai_shd.g_old_rec.vaei_attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.vaei_attribute9, hr_api.g_varchar2) or
483: nvl(pqp_vai_shd.g_old_rec.vaei_attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.vaei_attribute10, hr_api.g_varchar2) or
485: nvl(pqp_vai_shd.g_old_rec.vaei_attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.vaei_attribute11, hr_api.g_varchar2) or
487: nvl(pqp_vai_shd.g_old_rec.vaei_attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.vaei_attribute12, hr_api.g_varchar2) or
481: nvl(pqp_vai_shd.g_old_rec.vaei_attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.vaei_attribute9, hr_api.g_varchar2) or
483: nvl(pqp_vai_shd.g_old_rec.vaei_attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.vaei_attribute10, hr_api.g_varchar2) or
485: nvl(pqp_vai_shd.g_old_rec.vaei_attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.vaei_attribute11, hr_api.g_varchar2) or
487: nvl(pqp_vai_shd.g_old_rec.vaei_attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.vaei_attribute12, hr_api.g_varchar2) or
489: nvl(pqp_vai_shd.g_old_rec.vaei_attribute13, hr_api.g_varchar2) <>
482: nvl(p_rec.vaei_attribute9, hr_api.g_varchar2) or
483: nvl(pqp_vai_shd.g_old_rec.vaei_attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.vaei_attribute10, hr_api.g_varchar2) or
485: nvl(pqp_vai_shd.g_old_rec.vaei_attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.vaei_attribute11, hr_api.g_varchar2) or
487: nvl(pqp_vai_shd.g_old_rec.vaei_attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.vaei_attribute12, hr_api.g_varchar2) or
489: nvl(pqp_vai_shd.g_old_rec.vaei_attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.vaei_attribute13, hr_api.g_varchar2) or
483: nvl(pqp_vai_shd.g_old_rec.vaei_attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.vaei_attribute10, hr_api.g_varchar2) or
485: nvl(pqp_vai_shd.g_old_rec.vaei_attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.vaei_attribute11, hr_api.g_varchar2) or
487: nvl(pqp_vai_shd.g_old_rec.vaei_attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.vaei_attribute12, hr_api.g_varchar2) or
489: nvl(pqp_vai_shd.g_old_rec.vaei_attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.vaei_attribute13, hr_api.g_varchar2) or
491: nvl(pqp_vai_shd.g_old_rec.vaei_attribute14, hr_api.g_varchar2) <>
484: nvl(p_rec.vaei_attribute10, hr_api.g_varchar2) or
485: nvl(pqp_vai_shd.g_old_rec.vaei_attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.vaei_attribute11, hr_api.g_varchar2) or
487: nvl(pqp_vai_shd.g_old_rec.vaei_attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.vaei_attribute12, hr_api.g_varchar2) or
489: nvl(pqp_vai_shd.g_old_rec.vaei_attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.vaei_attribute13, hr_api.g_varchar2) or
491: nvl(pqp_vai_shd.g_old_rec.vaei_attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.vaei_attribute14, hr_api.g_varchar2) or
485: nvl(pqp_vai_shd.g_old_rec.vaei_attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.vaei_attribute11, hr_api.g_varchar2) or
487: nvl(pqp_vai_shd.g_old_rec.vaei_attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.vaei_attribute12, hr_api.g_varchar2) or
489: nvl(pqp_vai_shd.g_old_rec.vaei_attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.vaei_attribute13, hr_api.g_varchar2) or
491: nvl(pqp_vai_shd.g_old_rec.vaei_attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.vaei_attribute14, hr_api.g_varchar2) or
493: nvl(pqp_vai_shd.g_old_rec.vaei_attribute15, hr_api.g_varchar2) <>
486: nvl(p_rec.vaei_attribute11, hr_api.g_varchar2) or
487: nvl(pqp_vai_shd.g_old_rec.vaei_attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.vaei_attribute12, hr_api.g_varchar2) or
489: nvl(pqp_vai_shd.g_old_rec.vaei_attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.vaei_attribute13, hr_api.g_varchar2) or
491: nvl(pqp_vai_shd.g_old_rec.vaei_attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.vaei_attribute14, hr_api.g_varchar2) or
493: nvl(pqp_vai_shd.g_old_rec.vaei_attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.vaei_attribute15, hr_api.g_varchar2) or
487: nvl(pqp_vai_shd.g_old_rec.vaei_attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.vaei_attribute12, hr_api.g_varchar2) or
489: nvl(pqp_vai_shd.g_old_rec.vaei_attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.vaei_attribute13, hr_api.g_varchar2) or
491: nvl(pqp_vai_shd.g_old_rec.vaei_attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.vaei_attribute14, hr_api.g_varchar2) or
493: nvl(pqp_vai_shd.g_old_rec.vaei_attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.vaei_attribute15, hr_api.g_varchar2) or
495: nvl(pqp_vai_shd.g_old_rec.vaei_attribute16, hr_api.g_varchar2) <>
488: nvl(p_rec.vaei_attribute12, hr_api.g_varchar2) or
489: nvl(pqp_vai_shd.g_old_rec.vaei_attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.vaei_attribute13, hr_api.g_varchar2) or
491: nvl(pqp_vai_shd.g_old_rec.vaei_attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.vaei_attribute14, hr_api.g_varchar2) or
493: nvl(pqp_vai_shd.g_old_rec.vaei_attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.vaei_attribute15, hr_api.g_varchar2) or
495: nvl(pqp_vai_shd.g_old_rec.vaei_attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.vaei_attribute16, hr_api.g_varchar2) or
489: nvl(pqp_vai_shd.g_old_rec.vaei_attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.vaei_attribute13, hr_api.g_varchar2) or
491: nvl(pqp_vai_shd.g_old_rec.vaei_attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.vaei_attribute14, hr_api.g_varchar2) or
493: nvl(pqp_vai_shd.g_old_rec.vaei_attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.vaei_attribute15, hr_api.g_varchar2) or
495: nvl(pqp_vai_shd.g_old_rec.vaei_attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.vaei_attribute16, hr_api.g_varchar2) or
497: nvl(pqp_vai_shd.g_old_rec.vaei_attribute17, hr_api.g_varchar2) <>
490: nvl(p_rec.vaei_attribute13, hr_api.g_varchar2) or
491: nvl(pqp_vai_shd.g_old_rec.vaei_attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.vaei_attribute14, hr_api.g_varchar2) or
493: nvl(pqp_vai_shd.g_old_rec.vaei_attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.vaei_attribute15, hr_api.g_varchar2) or
495: nvl(pqp_vai_shd.g_old_rec.vaei_attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.vaei_attribute16, hr_api.g_varchar2) or
497: nvl(pqp_vai_shd.g_old_rec.vaei_attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.vaei_attribute17, hr_api.g_varchar2) or
491: nvl(pqp_vai_shd.g_old_rec.vaei_attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.vaei_attribute14, hr_api.g_varchar2) or
493: nvl(pqp_vai_shd.g_old_rec.vaei_attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.vaei_attribute15, hr_api.g_varchar2) or
495: nvl(pqp_vai_shd.g_old_rec.vaei_attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.vaei_attribute16, hr_api.g_varchar2) or
497: nvl(pqp_vai_shd.g_old_rec.vaei_attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.vaei_attribute17, hr_api.g_varchar2) or
499: nvl(pqp_vai_shd.g_old_rec.vaei_attribute18, hr_api.g_varchar2) <>
492: nvl(p_rec.vaei_attribute14, hr_api.g_varchar2) or
493: nvl(pqp_vai_shd.g_old_rec.vaei_attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.vaei_attribute15, hr_api.g_varchar2) or
495: nvl(pqp_vai_shd.g_old_rec.vaei_attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.vaei_attribute16, hr_api.g_varchar2) or
497: nvl(pqp_vai_shd.g_old_rec.vaei_attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.vaei_attribute17, hr_api.g_varchar2) or
499: nvl(pqp_vai_shd.g_old_rec.vaei_attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.vaei_attribute18, hr_api.g_varchar2) or
493: nvl(pqp_vai_shd.g_old_rec.vaei_attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.vaei_attribute15, hr_api.g_varchar2) or
495: nvl(pqp_vai_shd.g_old_rec.vaei_attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.vaei_attribute16, hr_api.g_varchar2) or
497: nvl(pqp_vai_shd.g_old_rec.vaei_attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.vaei_attribute17, hr_api.g_varchar2) or
499: nvl(pqp_vai_shd.g_old_rec.vaei_attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.vaei_attribute18, hr_api.g_varchar2) or
501: nvl(pqp_vai_shd.g_old_rec.vaei_attribute19, hr_api.g_varchar2) <>
494: nvl(p_rec.vaei_attribute15, hr_api.g_varchar2) or
495: nvl(pqp_vai_shd.g_old_rec.vaei_attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.vaei_attribute16, hr_api.g_varchar2) or
497: nvl(pqp_vai_shd.g_old_rec.vaei_attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.vaei_attribute17, hr_api.g_varchar2) or
499: nvl(pqp_vai_shd.g_old_rec.vaei_attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.vaei_attribute18, hr_api.g_varchar2) or
501: nvl(pqp_vai_shd.g_old_rec.vaei_attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.vaei_attribute19, hr_api.g_varchar2) or
495: nvl(pqp_vai_shd.g_old_rec.vaei_attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.vaei_attribute16, hr_api.g_varchar2) or
497: nvl(pqp_vai_shd.g_old_rec.vaei_attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.vaei_attribute17, hr_api.g_varchar2) or
499: nvl(pqp_vai_shd.g_old_rec.vaei_attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.vaei_attribute18, hr_api.g_varchar2) or
501: nvl(pqp_vai_shd.g_old_rec.vaei_attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.vaei_attribute19, hr_api.g_varchar2) or
503: nvl(pqp_vai_shd.g_old_rec.vaei_attribute20, hr_api.g_varchar2) <>
496: nvl(p_rec.vaei_attribute16, hr_api.g_varchar2) or
497: nvl(pqp_vai_shd.g_old_rec.vaei_attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.vaei_attribute17, hr_api.g_varchar2) or
499: nvl(pqp_vai_shd.g_old_rec.vaei_attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.vaei_attribute18, hr_api.g_varchar2) or
501: nvl(pqp_vai_shd.g_old_rec.vaei_attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.vaei_attribute19, hr_api.g_varchar2) or
503: nvl(pqp_vai_shd.g_old_rec.vaei_attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.vaei_attribute20, hr_api.g_varchar2) ))
497: nvl(pqp_vai_shd.g_old_rec.vaei_attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.vaei_attribute17, hr_api.g_varchar2) or
499: nvl(pqp_vai_shd.g_old_rec.vaei_attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.vaei_attribute18, hr_api.g_varchar2) or
501: nvl(pqp_vai_shd.g_old_rec.vaei_attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.vaei_attribute19, hr_api.g_varchar2) or
503: nvl(pqp_vai_shd.g_old_rec.vaei_attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.vaei_attribute20, hr_api.g_varchar2) ))
505: or (p_rec.veh_alloc_extra_info_id is null) then
498: nvl(p_rec.vaei_attribute17, hr_api.g_varchar2) or
499: nvl(pqp_vai_shd.g_old_rec.vaei_attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.vaei_attribute18, hr_api.g_varchar2) or
501: nvl(pqp_vai_shd.g_old_rec.vaei_attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.vaei_attribute19, hr_api.g_varchar2) or
503: nvl(pqp_vai_shd.g_old_rec.vaei_attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.vaei_attribute20, hr_api.g_varchar2) ))
505: or (p_rec.veh_alloc_extra_info_id is null) then
506: --
499: nvl(pqp_vai_shd.g_old_rec.vaei_attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.vaei_attribute18, hr_api.g_varchar2) or
501: nvl(pqp_vai_shd.g_old_rec.vaei_attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.vaei_attribute19, hr_api.g_varchar2) or
503: nvl(pqp_vai_shd.g_old_rec.vaei_attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.vaei_attribute20, hr_api.g_varchar2) ))
505: or (p_rec.veh_alloc_extra_info_id is null) then
506: --
507: -- Only execute the validation if absolutely necessary:
500: nvl(p_rec.vaei_attribute18, hr_api.g_varchar2) or
501: nvl(pqp_vai_shd.g_old_rec.vaei_attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.vaei_attribute19, hr_api.g_varchar2) or
503: nvl(pqp_vai_shd.g_old_rec.vaei_attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.vaei_attribute20, hr_api.g_varchar2) ))
505: or (p_rec.veh_alloc_extra_info_id is null) then
506: --
507: -- Only execute the validation if absolutely necessary:
508: -- a) During update, the structure column value or any