eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_VAI_BUS dependencies on HR_API

Line 55: hr_api.mandatory_arg_error

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: );

Line 82: hr_api.set_security_group_id

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

Line 88: hr_api.set_legislation_context(l_legislation_code);

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: --

Line 124: hr_api.mandatory_arg_error

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: );

Line 130: if ( nvl(pqp_vai_bus.g_vehicle_allocation_id, hr_api.g_number)

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

Line 198: hr_api.mandatory_arg_error

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: );

Line 204: if ( nvl(pqp_vai_bus.g_vehicle_allocation_id, hr_api.g_number)

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

Line 280: nvl(pqp_vai_shd.g_old_rec.information_type, hr_api.g_varchar2) <>

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) <>

Line 281: nvl(p_rec.information_type, hr_api.g_varchar2) or

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

Line 282: nvl(pqp_vai_shd.g_old_rec.vaei_information_category, hr_api.g_varchar2) <>

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) <>

Line 283: nvl(p_rec.vaei_information_category, hr_api.g_varchar2) or

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

Line 284: nvl(pqp_vai_shd.g_old_rec.vaei_information1, hr_api.g_varchar2) <>

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) <>

Line 285: nvl(p_rec.vaei_information1, hr_api.g_varchar2) or

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

Line 286: nvl(pqp_vai_shd.g_old_rec.vaei_information2, hr_api.g_varchar2) <>

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) <>

Line 287: nvl(p_rec.vaei_information2, hr_api.g_varchar2) or

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

Line 288: nvl(pqp_vai_shd.g_old_rec.vaei_information3, hr_api.g_varchar2) <>

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) <>

Line 289: nvl(p_rec.vaei_information3, hr_api.g_varchar2) or

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

Line 290: nvl(pqp_vai_shd.g_old_rec.vaei_information4, hr_api.g_varchar2) <>

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) <>

Line 291: nvl(p_rec.vaei_information4, hr_api.g_varchar2) or

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

Line 292: nvl(pqp_vai_shd.g_old_rec.vaei_information5, hr_api.g_varchar2) <>

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) <>

Line 293: nvl(p_rec.vaei_information5, hr_api.g_varchar2) or

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

Line 294: nvl(pqp_vai_shd.g_old_rec.vaei_information6, hr_api.g_varchar2) <>

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) <>

Line 295: nvl(p_rec.vaei_information6, hr_api.g_varchar2) or

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

Line 296: nvl(pqp_vai_shd.g_old_rec.vaei_information7, hr_api.g_varchar2) <>

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) <>

Line 297: nvl(p_rec.vaei_information7, hr_api.g_varchar2) or

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

Line 298: nvl(pqp_vai_shd.g_old_rec.vaei_information8, hr_api.g_varchar2) <>

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) <>

Line 299: nvl(p_rec.vaei_information8, hr_api.g_varchar2) or

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

Line 300: nvl(pqp_vai_shd.g_old_rec.vaei_information9, hr_api.g_varchar2) <>

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) <>

Line 301: nvl(p_rec.vaei_information9, hr_api.g_varchar2) or

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

Line 302: nvl(pqp_vai_shd.g_old_rec.vaei_information10, hr_api.g_varchar2) <>

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) <>

Line 303: nvl(p_rec.vaei_information10, hr_api.g_varchar2) or

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

Line 304: nvl(pqp_vai_shd.g_old_rec.vaei_information11, hr_api.g_varchar2) <>

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) <>

Line 305: nvl(p_rec.vaei_information11, hr_api.g_varchar2) or

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

Line 306: nvl(pqp_vai_shd.g_old_rec.vaei_information12, hr_api.g_varchar2) <>

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) <>

Line 307: nvl(p_rec.vaei_information12, hr_api.g_varchar2) or

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

Line 308: nvl(pqp_vai_shd.g_old_rec.vaei_information13, hr_api.g_varchar2) <>

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) <>

Line 309: nvl(p_rec.vaei_information13, hr_api.g_varchar2) or

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

Line 310: nvl(pqp_vai_shd.g_old_rec.vaei_information14, hr_api.g_varchar2) <>

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) <>

Line 311: nvl(p_rec.vaei_information14, hr_api.g_varchar2) or

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

Line 312: nvl(pqp_vai_shd.g_old_rec.vaei_information15, hr_api.g_varchar2) <>

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) <>

Line 313: nvl(p_rec.vaei_information15, hr_api.g_varchar2) or

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

Line 314: nvl(pqp_vai_shd.g_old_rec.vaei_information16, hr_api.g_varchar2) <>

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) <>

Line 315: nvl(p_rec.vaei_information16, hr_api.g_varchar2) or

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

Line 316: nvl(pqp_vai_shd.g_old_rec.vaei_information17, hr_api.g_varchar2) <>

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) <>

Line 317: nvl(p_rec.vaei_information17, hr_api.g_varchar2) or

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

Line 318: nvl(pqp_vai_shd.g_old_rec.vaei_information18, hr_api.g_varchar2) <>

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) <>

Line 319: nvl(p_rec.vaei_information18, hr_api.g_varchar2) or

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

Line 320: nvl(pqp_vai_shd.g_old_rec.vaei_information19, hr_api.g_varchar2) <>

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) <>

Line 321: nvl(p_rec.vaei_information19, hr_api.g_varchar2) or

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

Line 322: nvl(pqp_vai_shd.g_old_rec.vaei_information20, hr_api.g_varchar2) <>

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) <>

Line 323: nvl(p_rec.vaei_information20, hr_api.g_varchar2) or

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

Line 324: nvl(pqp_vai_shd.g_old_rec.vaei_information21, hr_api.g_varchar2) <>

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) <>

Line 325: nvl(p_rec.vaei_information21, hr_api.g_varchar2) or

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

Line 326: nvl(pqp_vai_shd.g_old_rec.vaei_information22, hr_api.g_varchar2) <>

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) <>

Line 327: nvl(p_rec.vaei_information22, hr_api.g_varchar2) or

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

Line 328: nvl(pqp_vai_shd.g_old_rec.vaei_information23, hr_api.g_varchar2) <>

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) <>

Line 329: nvl(p_rec.vaei_information23, hr_api.g_varchar2) or

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

Line 330: nvl(pqp_vai_shd.g_old_rec.vaei_information24, hr_api.g_varchar2) <>

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) <>

Line 331: nvl(p_rec.vaei_information24, hr_api.g_varchar2) or

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

Line 332: nvl(pqp_vai_shd.g_old_rec.vaei_information25, hr_api.g_varchar2) <>

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) <>

Line 333: nvl(p_rec.vaei_information25, hr_api.g_varchar2) or

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

Line 334: nvl(pqp_vai_shd.g_old_rec.vaei_information26, hr_api.g_varchar2) <>

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) <>

Line 335: nvl(p_rec.vaei_information26, hr_api.g_varchar2) or

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

Line 336: nvl(pqp_vai_shd.g_old_rec.vaei_information27, hr_api.g_varchar2) <>

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) <>

Line 337: nvl(p_rec.vaei_information27, hr_api.g_varchar2) or

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

Line 338: nvl(pqp_vai_shd.g_old_rec.vaei_information28, hr_api.g_varchar2) <>

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) <>

Line 339: nvl(p_rec.vaei_information28, hr_api.g_varchar2) or

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) ))

Line 340: nvl(pqp_vai_shd.g_old_rec.vaei_information29, 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

Line 341: nvl(p_rec.vaei_information29, hr_api.g_varchar2) or

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: --

Line 342: nvl(pqp_vai_shd.g_old_rec.vaei_information30, hr_api.g_varchar2) <>

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:

Line 343: nvl(p_rec.vaei_information30, 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:
347: -- a) During update, the structure column value or any

Line 463: nvl(pqp_vai_shd.g_old_rec.vaei_attribute_category, hr_api.g_varchar2) <>

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) <>

Line 464: nvl(p_rec.vaei_attribute_category, hr_api.g_varchar2) or

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

Line 465: nvl(pqp_vai_shd.g_old_rec.vaei_attribute1, hr_api.g_varchar2) <>

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) <>

Line 466: nvl(p_rec.vaei_attribute1, hr_api.g_varchar2) or

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

Line 467: nvl(pqp_vai_shd.g_old_rec.vaei_attribute2, hr_api.g_varchar2) <>

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) <>

Line 468: nvl(p_rec.vaei_attribute2, hr_api.g_varchar2) or

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

Line 469: nvl(pqp_vai_shd.g_old_rec.vaei_attribute3, hr_api.g_varchar2) <>

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) <>

Line 470: nvl(p_rec.vaei_attribute3, hr_api.g_varchar2) or

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

Line 471: nvl(pqp_vai_shd.g_old_rec.vaei_attribute4, hr_api.g_varchar2) <>

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) <>

Line 472: nvl(p_rec.vaei_attribute4, hr_api.g_varchar2) or

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

Line 473: nvl(pqp_vai_shd.g_old_rec.vaei_attribute5, hr_api.g_varchar2) <>

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) <>

Line 474: nvl(p_rec.vaei_attribute5, hr_api.g_varchar2) or

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

Line 475: nvl(pqp_vai_shd.g_old_rec.vaei_attribute6, hr_api.g_varchar2) <>

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) <>

Line 476: nvl(p_rec.vaei_attribute6, hr_api.g_varchar2) or

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

Line 477: nvl(pqp_vai_shd.g_old_rec.vaei_attribute7, hr_api.g_varchar2) <>

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) <>

Line 478: nvl(p_rec.vaei_attribute7, hr_api.g_varchar2) or

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

Line 479: nvl(pqp_vai_shd.g_old_rec.vaei_attribute8, hr_api.g_varchar2) <>

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) <>

Line 480: nvl(p_rec.vaei_attribute8, hr_api.g_varchar2) or

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

Line 481: nvl(pqp_vai_shd.g_old_rec.vaei_attribute9, hr_api.g_varchar2) <>

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) <>

Line 482: nvl(p_rec.vaei_attribute9, hr_api.g_varchar2) or

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

Line 483: nvl(pqp_vai_shd.g_old_rec.vaei_attribute10, hr_api.g_varchar2) <>

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) <>

Line 484: nvl(p_rec.vaei_attribute10, hr_api.g_varchar2) or

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

Line 485: nvl(pqp_vai_shd.g_old_rec.vaei_attribute11, hr_api.g_varchar2) <>

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) <>

Line 486: nvl(p_rec.vaei_attribute11, hr_api.g_varchar2) or

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

Line 487: nvl(pqp_vai_shd.g_old_rec.vaei_attribute12, hr_api.g_varchar2) <>

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) <>

Line 488: nvl(p_rec.vaei_attribute12, hr_api.g_varchar2) or

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

Line 489: nvl(pqp_vai_shd.g_old_rec.vaei_attribute13, hr_api.g_varchar2) <>

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) <>

Line 490: nvl(p_rec.vaei_attribute13, hr_api.g_varchar2) or

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

Line 491: nvl(pqp_vai_shd.g_old_rec.vaei_attribute14, hr_api.g_varchar2) <>

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) <>

Line 492: nvl(p_rec.vaei_attribute14, hr_api.g_varchar2) or

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

Line 493: nvl(pqp_vai_shd.g_old_rec.vaei_attribute15, hr_api.g_varchar2) <>

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) <>

Line 494: nvl(p_rec.vaei_attribute15, hr_api.g_varchar2) or

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

Line 495: nvl(pqp_vai_shd.g_old_rec.vaei_attribute16, hr_api.g_varchar2) <>

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) <>

Line 496: nvl(p_rec.vaei_attribute16, hr_api.g_varchar2) or

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

Line 497: nvl(pqp_vai_shd.g_old_rec.vaei_attribute17, hr_api.g_varchar2) <>

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) <>

Line 498: nvl(p_rec.vaei_attribute17, hr_api.g_varchar2) or

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

Line 499: nvl(pqp_vai_shd.g_old_rec.vaei_attribute18, hr_api.g_varchar2) <>

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) <>

Line 500: nvl(p_rec.vaei_attribute18, hr_api.g_varchar2) or

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) ))

Line 501: nvl(pqp_vai_shd.g_old_rec.vaei_attribute19, 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

Line 502: nvl(p_rec.vaei_attribute19, hr_api.g_varchar2) or

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: --

Line 503: nvl(pqp_vai_shd.g_old_rec.vaei_attribute20, hr_api.g_varchar2) <>

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:

Line 504: nvl(p_rec.vaei_attribute20, 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:
508: -- a) During update, the structure column value or any