APPS.PQP_VRI_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_repos_extra_info_id'
58: ,p_argument_value => p_veh_repos_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_repository_id'
127: ,p_argument_value => p_vehicle_repository_id
128: );

Line 130: IF ( nvl(pqp_vri_bus.g_vehicle_repository_id, hr_api.g_number)

126: ,p_argument => 'vehicle_repository_id'
127: ,p_argument_value => p_vehicle_repository_id
128: );
129: --
130: IF ( nvl(pqp_vri_bus.g_vehicle_repository_id, hr_api.g_number)
131: = p_vehicle_repository_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_repository_id'
201: ,p_argument_value => p_vehicle_repository_id
202: );

Line 204: if ( nvl(pqp_vri_bus.g_vehicle_repository_id, hr_api.g_number)

200: ,p_argument => 'vehicle_repository_id'
201: ,p_argument_value => p_vehicle_repository_id
202: );
203: --
204: if ( nvl(pqp_vri_bus.g_vehicle_repository_id, hr_api.g_number)
205: = p_vehicle_repository_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 281: nvl(pqp_vri_shd.g_old_rec.information_type, hr_api.g_varchar2) <>

277: begin
278: hr_utility.set_location('Entering:'||l_proc,10);
279: --
280: if ((p_rec.veh_repos_extra_info_id is not null) and (
281: nvl(pqp_vri_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
282: nvl(p_rec.information_type, hr_api.g_varchar2) or
283: nvl(pqp_vri_shd.g_old_rec.vrei_information_category, hr_api.g_varchar2) <>
284: nvl(p_rec.vrei_information_category, hr_api.g_varchar2) or
285: nvl(pqp_vri_shd.g_old_rec.vrei_information1, hr_api.g_varchar2) <>

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

278: hr_utility.set_location('Entering:'||l_proc,10);
279: --
280: if ((p_rec.veh_repos_extra_info_id is not null) and (
281: nvl(pqp_vri_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
282: nvl(p_rec.information_type, hr_api.g_varchar2) or
283: nvl(pqp_vri_shd.g_old_rec.vrei_information_category, hr_api.g_varchar2) <>
284: nvl(p_rec.vrei_information_category, hr_api.g_varchar2) or
285: nvl(pqp_vri_shd.g_old_rec.vrei_information1, hr_api.g_varchar2) <>
286: nvl(p_rec.vrei_information1, hr_api.g_varchar2) or

Line 283: nvl(pqp_vri_shd.g_old_rec.vrei_information_category, hr_api.g_varchar2) <>

279: --
280: if ((p_rec.veh_repos_extra_info_id is not null) and (
281: nvl(pqp_vri_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
282: nvl(p_rec.information_type, hr_api.g_varchar2) or
283: nvl(pqp_vri_shd.g_old_rec.vrei_information_category, hr_api.g_varchar2) <>
284: nvl(p_rec.vrei_information_category, hr_api.g_varchar2) or
285: nvl(pqp_vri_shd.g_old_rec.vrei_information1, hr_api.g_varchar2) <>
286: nvl(p_rec.vrei_information1, hr_api.g_varchar2) or
287: nvl(pqp_vri_shd.g_old_rec.vrei_information2, hr_api.g_varchar2) <>

Line 284: nvl(p_rec.vrei_information_category, hr_api.g_varchar2) or

280: if ((p_rec.veh_repos_extra_info_id is not null) and (
281: nvl(pqp_vri_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
282: nvl(p_rec.information_type, hr_api.g_varchar2) or
283: nvl(pqp_vri_shd.g_old_rec.vrei_information_category, hr_api.g_varchar2) <>
284: nvl(p_rec.vrei_information_category, hr_api.g_varchar2) or
285: nvl(pqp_vri_shd.g_old_rec.vrei_information1, hr_api.g_varchar2) <>
286: nvl(p_rec.vrei_information1, hr_api.g_varchar2) or
287: nvl(pqp_vri_shd.g_old_rec.vrei_information2, hr_api.g_varchar2) <>
288: nvl(p_rec.vrei_information2, hr_api.g_varchar2) or

Line 285: nvl(pqp_vri_shd.g_old_rec.vrei_information1, hr_api.g_varchar2) <>

281: nvl(pqp_vri_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
282: nvl(p_rec.information_type, hr_api.g_varchar2) or
283: nvl(pqp_vri_shd.g_old_rec.vrei_information_category, hr_api.g_varchar2) <>
284: nvl(p_rec.vrei_information_category, hr_api.g_varchar2) or
285: nvl(pqp_vri_shd.g_old_rec.vrei_information1, hr_api.g_varchar2) <>
286: nvl(p_rec.vrei_information1, hr_api.g_varchar2) or
287: nvl(pqp_vri_shd.g_old_rec.vrei_information2, hr_api.g_varchar2) <>
288: nvl(p_rec.vrei_information2, hr_api.g_varchar2) or
289: nvl(pqp_vri_shd.g_old_rec.vrei_information3, hr_api.g_varchar2) <>

Line 286: nvl(p_rec.vrei_information1, hr_api.g_varchar2) or

282: nvl(p_rec.information_type, hr_api.g_varchar2) or
283: nvl(pqp_vri_shd.g_old_rec.vrei_information_category, hr_api.g_varchar2) <>
284: nvl(p_rec.vrei_information_category, hr_api.g_varchar2) or
285: nvl(pqp_vri_shd.g_old_rec.vrei_information1, hr_api.g_varchar2) <>
286: nvl(p_rec.vrei_information1, hr_api.g_varchar2) or
287: nvl(pqp_vri_shd.g_old_rec.vrei_information2, hr_api.g_varchar2) <>
288: nvl(p_rec.vrei_information2, hr_api.g_varchar2) or
289: nvl(pqp_vri_shd.g_old_rec.vrei_information3, hr_api.g_varchar2) <>
290: nvl(p_rec.vrei_information3, hr_api.g_varchar2) or

Line 287: nvl(pqp_vri_shd.g_old_rec.vrei_information2, hr_api.g_varchar2) <>

283: nvl(pqp_vri_shd.g_old_rec.vrei_information_category, hr_api.g_varchar2) <>
284: nvl(p_rec.vrei_information_category, hr_api.g_varchar2) or
285: nvl(pqp_vri_shd.g_old_rec.vrei_information1, hr_api.g_varchar2) <>
286: nvl(p_rec.vrei_information1, hr_api.g_varchar2) or
287: nvl(pqp_vri_shd.g_old_rec.vrei_information2, hr_api.g_varchar2) <>
288: nvl(p_rec.vrei_information2, hr_api.g_varchar2) or
289: nvl(pqp_vri_shd.g_old_rec.vrei_information3, hr_api.g_varchar2) <>
290: nvl(p_rec.vrei_information3, hr_api.g_varchar2) or
291: nvl(pqp_vri_shd.g_old_rec.vrei_information4, hr_api.g_varchar2) <>

Line 288: nvl(p_rec.vrei_information2, hr_api.g_varchar2) or

284: nvl(p_rec.vrei_information_category, hr_api.g_varchar2) or
285: nvl(pqp_vri_shd.g_old_rec.vrei_information1, hr_api.g_varchar2) <>
286: nvl(p_rec.vrei_information1, hr_api.g_varchar2) or
287: nvl(pqp_vri_shd.g_old_rec.vrei_information2, hr_api.g_varchar2) <>
288: nvl(p_rec.vrei_information2, hr_api.g_varchar2) or
289: nvl(pqp_vri_shd.g_old_rec.vrei_information3, hr_api.g_varchar2) <>
290: nvl(p_rec.vrei_information3, hr_api.g_varchar2) or
291: nvl(pqp_vri_shd.g_old_rec.vrei_information4, hr_api.g_varchar2) <>
292: nvl(p_rec.vrei_information4, hr_api.g_varchar2) or

Line 289: nvl(pqp_vri_shd.g_old_rec.vrei_information3, hr_api.g_varchar2) <>

285: nvl(pqp_vri_shd.g_old_rec.vrei_information1, hr_api.g_varchar2) <>
286: nvl(p_rec.vrei_information1, hr_api.g_varchar2) or
287: nvl(pqp_vri_shd.g_old_rec.vrei_information2, hr_api.g_varchar2) <>
288: nvl(p_rec.vrei_information2, hr_api.g_varchar2) or
289: nvl(pqp_vri_shd.g_old_rec.vrei_information3, hr_api.g_varchar2) <>
290: nvl(p_rec.vrei_information3, hr_api.g_varchar2) or
291: nvl(pqp_vri_shd.g_old_rec.vrei_information4, hr_api.g_varchar2) <>
292: nvl(p_rec.vrei_information4, hr_api.g_varchar2) or
293: nvl(pqp_vri_shd.g_old_rec.vrei_information5, hr_api.g_varchar2) <>

Line 290: nvl(p_rec.vrei_information3, hr_api.g_varchar2) or

286: nvl(p_rec.vrei_information1, hr_api.g_varchar2) or
287: nvl(pqp_vri_shd.g_old_rec.vrei_information2, hr_api.g_varchar2) <>
288: nvl(p_rec.vrei_information2, hr_api.g_varchar2) or
289: nvl(pqp_vri_shd.g_old_rec.vrei_information3, hr_api.g_varchar2) <>
290: nvl(p_rec.vrei_information3, hr_api.g_varchar2) or
291: nvl(pqp_vri_shd.g_old_rec.vrei_information4, hr_api.g_varchar2) <>
292: nvl(p_rec.vrei_information4, hr_api.g_varchar2) or
293: nvl(pqp_vri_shd.g_old_rec.vrei_information5, hr_api.g_varchar2) <>
294: nvl(p_rec.vrei_information5, hr_api.g_varchar2) or

Line 291: nvl(pqp_vri_shd.g_old_rec.vrei_information4, hr_api.g_varchar2) <>

287: nvl(pqp_vri_shd.g_old_rec.vrei_information2, hr_api.g_varchar2) <>
288: nvl(p_rec.vrei_information2, hr_api.g_varchar2) or
289: nvl(pqp_vri_shd.g_old_rec.vrei_information3, hr_api.g_varchar2) <>
290: nvl(p_rec.vrei_information3, hr_api.g_varchar2) or
291: nvl(pqp_vri_shd.g_old_rec.vrei_information4, hr_api.g_varchar2) <>
292: nvl(p_rec.vrei_information4, hr_api.g_varchar2) or
293: nvl(pqp_vri_shd.g_old_rec.vrei_information5, hr_api.g_varchar2) <>
294: nvl(p_rec.vrei_information5, hr_api.g_varchar2) or
295: nvl(pqp_vri_shd.g_old_rec.vrei_information6, hr_api.g_varchar2) <>

Line 292: nvl(p_rec.vrei_information4, hr_api.g_varchar2) or

288: nvl(p_rec.vrei_information2, hr_api.g_varchar2) or
289: nvl(pqp_vri_shd.g_old_rec.vrei_information3, hr_api.g_varchar2) <>
290: nvl(p_rec.vrei_information3, hr_api.g_varchar2) or
291: nvl(pqp_vri_shd.g_old_rec.vrei_information4, hr_api.g_varchar2) <>
292: nvl(p_rec.vrei_information4, hr_api.g_varchar2) or
293: nvl(pqp_vri_shd.g_old_rec.vrei_information5, hr_api.g_varchar2) <>
294: nvl(p_rec.vrei_information5, hr_api.g_varchar2) or
295: nvl(pqp_vri_shd.g_old_rec.vrei_information6, hr_api.g_varchar2) <>
296: nvl(p_rec.vrei_information6, hr_api.g_varchar2) or

Line 293: nvl(pqp_vri_shd.g_old_rec.vrei_information5, hr_api.g_varchar2) <>

289: nvl(pqp_vri_shd.g_old_rec.vrei_information3, hr_api.g_varchar2) <>
290: nvl(p_rec.vrei_information3, hr_api.g_varchar2) or
291: nvl(pqp_vri_shd.g_old_rec.vrei_information4, hr_api.g_varchar2) <>
292: nvl(p_rec.vrei_information4, hr_api.g_varchar2) or
293: nvl(pqp_vri_shd.g_old_rec.vrei_information5, hr_api.g_varchar2) <>
294: nvl(p_rec.vrei_information5, hr_api.g_varchar2) or
295: nvl(pqp_vri_shd.g_old_rec.vrei_information6, hr_api.g_varchar2) <>
296: nvl(p_rec.vrei_information6, hr_api.g_varchar2) or
297: nvl(pqp_vri_shd.g_old_rec.vrei_information7, hr_api.g_varchar2) <>

Line 294: nvl(p_rec.vrei_information5, hr_api.g_varchar2) or

290: nvl(p_rec.vrei_information3, hr_api.g_varchar2) or
291: nvl(pqp_vri_shd.g_old_rec.vrei_information4, hr_api.g_varchar2) <>
292: nvl(p_rec.vrei_information4, hr_api.g_varchar2) or
293: nvl(pqp_vri_shd.g_old_rec.vrei_information5, hr_api.g_varchar2) <>
294: nvl(p_rec.vrei_information5, hr_api.g_varchar2) or
295: nvl(pqp_vri_shd.g_old_rec.vrei_information6, hr_api.g_varchar2) <>
296: nvl(p_rec.vrei_information6, hr_api.g_varchar2) or
297: nvl(pqp_vri_shd.g_old_rec.vrei_information7, hr_api.g_varchar2) <>
298: nvl(p_rec.vrei_information7, hr_api.g_varchar2) or

Line 295: nvl(pqp_vri_shd.g_old_rec.vrei_information6, hr_api.g_varchar2) <>

291: nvl(pqp_vri_shd.g_old_rec.vrei_information4, hr_api.g_varchar2) <>
292: nvl(p_rec.vrei_information4, hr_api.g_varchar2) or
293: nvl(pqp_vri_shd.g_old_rec.vrei_information5, hr_api.g_varchar2) <>
294: nvl(p_rec.vrei_information5, hr_api.g_varchar2) or
295: nvl(pqp_vri_shd.g_old_rec.vrei_information6, hr_api.g_varchar2) <>
296: nvl(p_rec.vrei_information6, hr_api.g_varchar2) or
297: nvl(pqp_vri_shd.g_old_rec.vrei_information7, hr_api.g_varchar2) <>
298: nvl(p_rec.vrei_information7, hr_api.g_varchar2) or
299: nvl(pqp_vri_shd.g_old_rec.vrei_information8, hr_api.g_varchar2) <>

Line 296: nvl(p_rec.vrei_information6, hr_api.g_varchar2) or

292: nvl(p_rec.vrei_information4, hr_api.g_varchar2) or
293: nvl(pqp_vri_shd.g_old_rec.vrei_information5, hr_api.g_varchar2) <>
294: nvl(p_rec.vrei_information5, hr_api.g_varchar2) or
295: nvl(pqp_vri_shd.g_old_rec.vrei_information6, hr_api.g_varchar2) <>
296: nvl(p_rec.vrei_information6, hr_api.g_varchar2) or
297: nvl(pqp_vri_shd.g_old_rec.vrei_information7, hr_api.g_varchar2) <>
298: nvl(p_rec.vrei_information7, hr_api.g_varchar2) or
299: nvl(pqp_vri_shd.g_old_rec.vrei_information8, hr_api.g_varchar2) <>
300: nvl(p_rec.vrei_information8, hr_api.g_varchar2) or

Line 297: nvl(pqp_vri_shd.g_old_rec.vrei_information7, hr_api.g_varchar2) <>

293: nvl(pqp_vri_shd.g_old_rec.vrei_information5, hr_api.g_varchar2) <>
294: nvl(p_rec.vrei_information5, hr_api.g_varchar2) or
295: nvl(pqp_vri_shd.g_old_rec.vrei_information6, hr_api.g_varchar2) <>
296: nvl(p_rec.vrei_information6, hr_api.g_varchar2) or
297: nvl(pqp_vri_shd.g_old_rec.vrei_information7, hr_api.g_varchar2) <>
298: nvl(p_rec.vrei_information7, hr_api.g_varchar2) or
299: nvl(pqp_vri_shd.g_old_rec.vrei_information8, hr_api.g_varchar2) <>
300: nvl(p_rec.vrei_information8, hr_api.g_varchar2) or
301: nvl(pqp_vri_shd.g_old_rec.vrei_information9, hr_api.g_varchar2) <>

Line 298: nvl(p_rec.vrei_information7, hr_api.g_varchar2) or

294: nvl(p_rec.vrei_information5, hr_api.g_varchar2) or
295: nvl(pqp_vri_shd.g_old_rec.vrei_information6, hr_api.g_varchar2) <>
296: nvl(p_rec.vrei_information6, hr_api.g_varchar2) or
297: nvl(pqp_vri_shd.g_old_rec.vrei_information7, hr_api.g_varchar2) <>
298: nvl(p_rec.vrei_information7, hr_api.g_varchar2) or
299: nvl(pqp_vri_shd.g_old_rec.vrei_information8, hr_api.g_varchar2) <>
300: nvl(p_rec.vrei_information8, hr_api.g_varchar2) or
301: nvl(pqp_vri_shd.g_old_rec.vrei_information9, hr_api.g_varchar2) <>
302: nvl(p_rec.vrei_information9, hr_api.g_varchar2) or

Line 299: nvl(pqp_vri_shd.g_old_rec.vrei_information8, hr_api.g_varchar2) <>

295: nvl(pqp_vri_shd.g_old_rec.vrei_information6, hr_api.g_varchar2) <>
296: nvl(p_rec.vrei_information6, hr_api.g_varchar2) or
297: nvl(pqp_vri_shd.g_old_rec.vrei_information7, hr_api.g_varchar2) <>
298: nvl(p_rec.vrei_information7, hr_api.g_varchar2) or
299: nvl(pqp_vri_shd.g_old_rec.vrei_information8, hr_api.g_varchar2) <>
300: nvl(p_rec.vrei_information8, hr_api.g_varchar2) or
301: nvl(pqp_vri_shd.g_old_rec.vrei_information9, hr_api.g_varchar2) <>
302: nvl(p_rec.vrei_information9, hr_api.g_varchar2) or
303: nvl(pqp_vri_shd.g_old_rec.vrei_information10, hr_api.g_varchar2) <>

Line 300: nvl(p_rec.vrei_information8, hr_api.g_varchar2) or

296: nvl(p_rec.vrei_information6, hr_api.g_varchar2) or
297: nvl(pqp_vri_shd.g_old_rec.vrei_information7, hr_api.g_varchar2) <>
298: nvl(p_rec.vrei_information7, hr_api.g_varchar2) or
299: nvl(pqp_vri_shd.g_old_rec.vrei_information8, hr_api.g_varchar2) <>
300: nvl(p_rec.vrei_information8, hr_api.g_varchar2) or
301: nvl(pqp_vri_shd.g_old_rec.vrei_information9, hr_api.g_varchar2) <>
302: nvl(p_rec.vrei_information9, hr_api.g_varchar2) or
303: nvl(pqp_vri_shd.g_old_rec.vrei_information10, hr_api.g_varchar2) <>
304: nvl(p_rec.vrei_information10, hr_api.g_varchar2) or

Line 301: nvl(pqp_vri_shd.g_old_rec.vrei_information9, hr_api.g_varchar2) <>

297: nvl(pqp_vri_shd.g_old_rec.vrei_information7, hr_api.g_varchar2) <>
298: nvl(p_rec.vrei_information7, hr_api.g_varchar2) or
299: nvl(pqp_vri_shd.g_old_rec.vrei_information8, hr_api.g_varchar2) <>
300: nvl(p_rec.vrei_information8, hr_api.g_varchar2) or
301: nvl(pqp_vri_shd.g_old_rec.vrei_information9, hr_api.g_varchar2) <>
302: nvl(p_rec.vrei_information9, hr_api.g_varchar2) or
303: nvl(pqp_vri_shd.g_old_rec.vrei_information10, hr_api.g_varchar2) <>
304: nvl(p_rec.vrei_information10, hr_api.g_varchar2) or
305: nvl(pqp_vri_shd.g_old_rec.vrei_information11, hr_api.g_varchar2) <>

Line 302: nvl(p_rec.vrei_information9, hr_api.g_varchar2) or

298: nvl(p_rec.vrei_information7, hr_api.g_varchar2) or
299: nvl(pqp_vri_shd.g_old_rec.vrei_information8, hr_api.g_varchar2) <>
300: nvl(p_rec.vrei_information8, hr_api.g_varchar2) or
301: nvl(pqp_vri_shd.g_old_rec.vrei_information9, hr_api.g_varchar2) <>
302: nvl(p_rec.vrei_information9, hr_api.g_varchar2) or
303: nvl(pqp_vri_shd.g_old_rec.vrei_information10, hr_api.g_varchar2) <>
304: nvl(p_rec.vrei_information10, hr_api.g_varchar2) or
305: nvl(pqp_vri_shd.g_old_rec.vrei_information11, hr_api.g_varchar2) <>
306: nvl(p_rec.vrei_information11, hr_api.g_varchar2) or

Line 303: nvl(pqp_vri_shd.g_old_rec.vrei_information10, hr_api.g_varchar2) <>

299: nvl(pqp_vri_shd.g_old_rec.vrei_information8, hr_api.g_varchar2) <>
300: nvl(p_rec.vrei_information8, hr_api.g_varchar2) or
301: nvl(pqp_vri_shd.g_old_rec.vrei_information9, hr_api.g_varchar2) <>
302: nvl(p_rec.vrei_information9, hr_api.g_varchar2) or
303: nvl(pqp_vri_shd.g_old_rec.vrei_information10, hr_api.g_varchar2) <>
304: nvl(p_rec.vrei_information10, hr_api.g_varchar2) or
305: nvl(pqp_vri_shd.g_old_rec.vrei_information11, hr_api.g_varchar2) <>
306: nvl(p_rec.vrei_information11, hr_api.g_varchar2) or
307: nvl(pqp_vri_shd.g_old_rec.vrei_information12, hr_api.g_varchar2) <>

Line 304: nvl(p_rec.vrei_information10, hr_api.g_varchar2) or

300: nvl(p_rec.vrei_information8, hr_api.g_varchar2) or
301: nvl(pqp_vri_shd.g_old_rec.vrei_information9, hr_api.g_varchar2) <>
302: nvl(p_rec.vrei_information9, hr_api.g_varchar2) or
303: nvl(pqp_vri_shd.g_old_rec.vrei_information10, hr_api.g_varchar2) <>
304: nvl(p_rec.vrei_information10, hr_api.g_varchar2) or
305: nvl(pqp_vri_shd.g_old_rec.vrei_information11, hr_api.g_varchar2) <>
306: nvl(p_rec.vrei_information11, hr_api.g_varchar2) or
307: nvl(pqp_vri_shd.g_old_rec.vrei_information12, hr_api.g_varchar2) <>
308: nvl(p_rec.vrei_information12, hr_api.g_varchar2) or

Line 305: nvl(pqp_vri_shd.g_old_rec.vrei_information11, hr_api.g_varchar2) <>

301: nvl(pqp_vri_shd.g_old_rec.vrei_information9, hr_api.g_varchar2) <>
302: nvl(p_rec.vrei_information9, hr_api.g_varchar2) or
303: nvl(pqp_vri_shd.g_old_rec.vrei_information10, hr_api.g_varchar2) <>
304: nvl(p_rec.vrei_information10, hr_api.g_varchar2) or
305: nvl(pqp_vri_shd.g_old_rec.vrei_information11, hr_api.g_varchar2) <>
306: nvl(p_rec.vrei_information11, hr_api.g_varchar2) or
307: nvl(pqp_vri_shd.g_old_rec.vrei_information12, hr_api.g_varchar2) <>
308: nvl(p_rec.vrei_information12, hr_api.g_varchar2) or
309: nvl(pqp_vri_shd.g_old_rec.vrei_information13, hr_api.g_varchar2) <>

Line 306: nvl(p_rec.vrei_information11, hr_api.g_varchar2) or

302: nvl(p_rec.vrei_information9, hr_api.g_varchar2) or
303: nvl(pqp_vri_shd.g_old_rec.vrei_information10, hr_api.g_varchar2) <>
304: nvl(p_rec.vrei_information10, hr_api.g_varchar2) or
305: nvl(pqp_vri_shd.g_old_rec.vrei_information11, hr_api.g_varchar2) <>
306: nvl(p_rec.vrei_information11, hr_api.g_varchar2) or
307: nvl(pqp_vri_shd.g_old_rec.vrei_information12, hr_api.g_varchar2) <>
308: nvl(p_rec.vrei_information12, hr_api.g_varchar2) or
309: nvl(pqp_vri_shd.g_old_rec.vrei_information13, hr_api.g_varchar2) <>
310: nvl(p_rec.vrei_information13, hr_api.g_varchar2) or

Line 307: nvl(pqp_vri_shd.g_old_rec.vrei_information12, hr_api.g_varchar2) <>

303: nvl(pqp_vri_shd.g_old_rec.vrei_information10, hr_api.g_varchar2) <>
304: nvl(p_rec.vrei_information10, hr_api.g_varchar2) or
305: nvl(pqp_vri_shd.g_old_rec.vrei_information11, hr_api.g_varchar2) <>
306: nvl(p_rec.vrei_information11, hr_api.g_varchar2) or
307: nvl(pqp_vri_shd.g_old_rec.vrei_information12, hr_api.g_varchar2) <>
308: nvl(p_rec.vrei_information12, hr_api.g_varchar2) or
309: nvl(pqp_vri_shd.g_old_rec.vrei_information13, hr_api.g_varchar2) <>
310: nvl(p_rec.vrei_information13, hr_api.g_varchar2) or
311: nvl(pqp_vri_shd.g_old_rec.vrei_information14, hr_api.g_varchar2) <>

Line 308: nvl(p_rec.vrei_information12, hr_api.g_varchar2) or

304: nvl(p_rec.vrei_information10, hr_api.g_varchar2) or
305: nvl(pqp_vri_shd.g_old_rec.vrei_information11, hr_api.g_varchar2) <>
306: nvl(p_rec.vrei_information11, hr_api.g_varchar2) or
307: nvl(pqp_vri_shd.g_old_rec.vrei_information12, hr_api.g_varchar2) <>
308: nvl(p_rec.vrei_information12, hr_api.g_varchar2) or
309: nvl(pqp_vri_shd.g_old_rec.vrei_information13, hr_api.g_varchar2) <>
310: nvl(p_rec.vrei_information13, hr_api.g_varchar2) or
311: nvl(pqp_vri_shd.g_old_rec.vrei_information14, hr_api.g_varchar2) <>
312: nvl(p_rec.vrei_information14, hr_api.g_varchar2) or

Line 309: nvl(pqp_vri_shd.g_old_rec.vrei_information13, hr_api.g_varchar2) <>

305: nvl(pqp_vri_shd.g_old_rec.vrei_information11, hr_api.g_varchar2) <>
306: nvl(p_rec.vrei_information11, hr_api.g_varchar2) or
307: nvl(pqp_vri_shd.g_old_rec.vrei_information12, hr_api.g_varchar2) <>
308: nvl(p_rec.vrei_information12, hr_api.g_varchar2) or
309: nvl(pqp_vri_shd.g_old_rec.vrei_information13, hr_api.g_varchar2) <>
310: nvl(p_rec.vrei_information13, hr_api.g_varchar2) or
311: nvl(pqp_vri_shd.g_old_rec.vrei_information14, hr_api.g_varchar2) <>
312: nvl(p_rec.vrei_information14, hr_api.g_varchar2) or
313: nvl(pqp_vri_shd.g_old_rec.vrei_information15, hr_api.g_varchar2) <>

Line 310: nvl(p_rec.vrei_information13, hr_api.g_varchar2) or

306: nvl(p_rec.vrei_information11, hr_api.g_varchar2) or
307: nvl(pqp_vri_shd.g_old_rec.vrei_information12, hr_api.g_varchar2) <>
308: nvl(p_rec.vrei_information12, hr_api.g_varchar2) or
309: nvl(pqp_vri_shd.g_old_rec.vrei_information13, hr_api.g_varchar2) <>
310: nvl(p_rec.vrei_information13, hr_api.g_varchar2) or
311: nvl(pqp_vri_shd.g_old_rec.vrei_information14, hr_api.g_varchar2) <>
312: nvl(p_rec.vrei_information14, hr_api.g_varchar2) or
313: nvl(pqp_vri_shd.g_old_rec.vrei_information15, hr_api.g_varchar2) <>
314: nvl(p_rec.vrei_information15, hr_api.g_varchar2) or

Line 311: nvl(pqp_vri_shd.g_old_rec.vrei_information14, hr_api.g_varchar2) <>

307: nvl(pqp_vri_shd.g_old_rec.vrei_information12, hr_api.g_varchar2) <>
308: nvl(p_rec.vrei_information12, hr_api.g_varchar2) or
309: nvl(pqp_vri_shd.g_old_rec.vrei_information13, hr_api.g_varchar2) <>
310: nvl(p_rec.vrei_information13, hr_api.g_varchar2) or
311: nvl(pqp_vri_shd.g_old_rec.vrei_information14, hr_api.g_varchar2) <>
312: nvl(p_rec.vrei_information14, hr_api.g_varchar2) or
313: nvl(pqp_vri_shd.g_old_rec.vrei_information15, hr_api.g_varchar2) <>
314: nvl(p_rec.vrei_information15, hr_api.g_varchar2) or
315: nvl(pqp_vri_shd.g_old_rec.vrei_information16, hr_api.g_varchar2) <>

Line 312: nvl(p_rec.vrei_information14, hr_api.g_varchar2) or

308: nvl(p_rec.vrei_information12, hr_api.g_varchar2) or
309: nvl(pqp_vri_shd.g_old_rec.vrei_information13, hr_api.g_varchar2) <>
310: nvl(p_rec.vrei_information13, hr_api.g_varchar2) or
311: nvl(pqp_vri_shd.g_old_rec.vrei_information14, hr_api.g_varchar2) <>
312: nvl(p_rec.vrei_information14, hr_api.g_varchar2) or
313: nvl(pqp_vri_shd.g_old_rec.vrei_information15, hr_api.g_varchar2) <>
314: nvl(p_rec.vrei_information15, hr_api.g_varchar2) or
315: nvl(pqp_vri_shd.g_old_rec.vrei_information16, hr_api.g_varchar2) <>
316: nvl(p_rec.vrei_information16, hr_api.g_varchar2) or

Line 313: nvl(pqp_vri_shd.g_old_rec.vrei_information15, hr_api.g_varchar2) <>

309: nvl(pqp_vri_shd.g_old_rec.vrei_information13, hr_api.g_varchar2) <>
310: nvl(p_rec.vrei_information13, hr_api.g_varchar2) or
311: nvl(pqp_vri_shd.g_old_rec.vrei_information14, hr_api.g_varchar2) <>
312: nvl(p_rec.vrei_information14, hr_api.g_varchar2) or
313: nvl(pqp_vri_shd.g_old_rec.vrei_information15, hr_api.g_varchar2) <>
314: nvl(p_rec.vrei_information15, hr_api.g_varchar2) or
315: nvl(pqp_vri_shd.g_old_rec.vrei_information16, hr_api.g_varchar2) <>
316: nvl(p_rec.vrei_information16, hr_api.g_varchar2) or
317: nvl(pqp_vri_shd.g_old_rec.vrei_information17, hr_api.g_varchar2) <>

Line 314: nvl(p_rec.vrei_information15, hr_api.g_varchar2) or

310: nvl(p_rec.vrei_information13, hr_api.g_varchar2) or
311: nvl(pqp_vri_shd.g_old_rec.vrei_information14, hr_api.g_varchar2) <>
312: nvl(p_rec.vrei_information14, hr_api.g_varchar2) or
313: nvl(pqp_vri_shd.g_old_rec.vrei_information15, hr_api.g_varchar2) <>
314: nvl(p_rec.vrei_information15, hr_api.g_varchar2) or
315: nvl(pqp_vri_shd.g_old_rec.vrei_information16, hr_api.g_varchar2) <>
316: nvl(p_rec.vrei_information16, hr_api.g_varchar2) or
317: nvl(pqp_vri_shd.g_old_rec.vrei_information17, hr_api.g_varchar2) <>
318: nvl(p_rec.vrei_information17, hr_api.g_varchar2) or

Line 315: nvl(pqp_vri_shd.g_old_rec.vrei_information16, hr_api.g_varchar2) <>

311: nvl(pqp_vri_shd.g_old_rec.vrei_information14, hr_api.g_varchar2) <>
312: nvl(p_rec.vrei_information14, hr_api.g_varchar2) or
313: nvl(pqp_vri_shd.g_old_rec.vrei_information15, hr_api.g_varchar2) <>
314: nvl(p_rec.vrei_information15, hr_api.g_varchar2) or
315: nvl(pqp_vri_shd.g_old_rec.vrei_information16, hr_api.g_varchar2) <>
316: nvl(p_rec.vrei_information16, hr_api.g_varchar2) or
317: nvl(pqp_vri_shd.g_old_rec.vrei_information17, hr_api.g_varchar2) <>
318: nvl(p_rec.vrei_information17, hr_api.g_varchar2) or
319: nvl(pqp_vri_shd.g_old_rec.vrei_information18, hr_api.g_varchar2) <>

Line 316: nvl(p_rec.vrei_information16, hr_api.g_varchar2) or

312: nvl(p_rec.vrei_information14, hr_api.g_varchar2) or
313: nvl(pqp_vri_shd.g_old_rec.vrei_information15, hr_api.g_varchar2) <>
314: nvl(p_rec.vrei_information15, hr_api.g_varchar2) or
315: nvl(pqp_vri_shd.g_old_rec.vrei_information16, hr_api.g_varchar2) <>
316: nvl(p_rec.vrei_information16, hr_api.g_varchar2) or
317: nvl(pqp_vri_shd.g_old_rec.vrei_information17, hr_api.g_varchar2) <>
318: nvl(p_rec.vrei_information17, hr_api.g_varchar2) or
319: nvl(pqp_vri_shd.g_old_rec.vrei_information18, hr_api.g_varchar2) <>
320: nvl(p_rec.vrei_information18, hr_api.g_varchar2) or

Line 317: nvl(pqp_vri_shd.g_old_rec.vrei_information17, hr_api.g_varchar2) <>

313: nvl(pqp_vri_shd.g_old_rec.vrei_information15, hr_api.g_varchar2) <>
314: nvl(p_rec.vrei_information15, hr_api.g_varchar2) or
315: nvl(pqp_vri_shd.g_old_rec.vrei_information16, hr_api.g_varchar2) <>
316: nvl(p_rec.vrei_information16, hr_api.g_varchar2) or
317: nvl(pqp_vri_shd.g_old_rec.vrei_information17, hr_api.g_varchar2) <>
318: nvl(p_rec.vrei_information17, hr_api.g_varchar2) or
319: nvl(pqp_vri_shd.g_old_rec.vrei_information18, hr_api.g_varchar2) <>
320: nvl(p_rec.vrei_information18, hr_api.g_varchar2) or
321: nvl(pqp_vri_shd.g_old_rec.vrei_information19, hr_api.g_varchar2) <>

Line 318: nvl(p_rec.vrei_information17, hr_api.g_varchar2) or

314: nvl(p_rec.vrei_information15, hr_api.g_varchar2) or
315: nvl(pqp_vri_shd.g_old_rec.vrei_information16, hr_api.g_varchar2) <>
316: nvl(p_rec.vrei_information16, hr_api.g_varchar2) or
317: nvl(pqp_vri_shd.g_old_rec.vrei_information17, hr_api.g_varchar2) <>
318: nvl(p_rec.vrei_information17, hr_api.g_varchar2) or
319: nvl(pqp_vri_shd.g_old_rec.vrei_information18, hr_api.g_varchar2) <>
320: nvl(p_rec.vrei_information18, hr_api.g_varchar2) or
321: nvl(pqp_vri_shd.g_old_rec.vrei_information19, hr_api.g_varchar2) <>
322: nvl(p_rec.vrei_information19, hr_api.g_varchar2) or

Line 319: nvl(pqp_vri_shd.g_old_rec.vrei_information18, hr_api.g_varchar2) <>

315: nvl(pqp_vri_shd.g_old_rec.vrei_information16, hr_api.g_varchar2) <>
316: nvl(p_rec.vrei_information16, hr_api.g_varchar2) or
317: nvl(pqp_vri_shd.g_old_rec.vrei_information17, hr_api.g_varchar2) <>
318: nvl(p_rec.vrei_information17, hr_api.g_varchar2) or
319: nvl(pqp_vri_shd.g_old_rec.vrei_information18, hr_api.g_varchar2) <>
320: nvl(p_rec.vrei_information18, hr_api.g_varchar2) or
321: nvl(pqp_vri_shd.g_old_rec.vrei_information19, hr_api.g_varchar2) <>
322: nvl(p_rec.vrei_information19, hr_api.g_varchar2) or
323: nvl(pqp_vri_shd.g_old_rec.vrei_information20, hr_api.g_varchar2) <>

Line 320: nvl(p_rec.vrei_information18, hr_api.g_varchar2) or

316: nvl(p_rec.vrei_information16, hr_api.g_varchar2) or
317: nvl(pqp_vri_shd.g_old_rec.vrei_information17, hr_api.g_varchar2) <>
318: nvl(p_rec.vrei_information17, hr_api.g_varchar2) or
319: nvl(pqp_vri_shd.g_old_rec.vrei_information18, hr_api.g_varchar2) <>
320: nvl(p_rec.vrei_information18, hr_api.g_varchar2) or
321: nvl(pqp_vri_shd.g_old_rec.vrei_information19, hr_api.g_varchar2) <>
322: nvl(p_rec.vrei_information19, hr_api.g_varchar2) or
323: nvl(pqp_vri_shd.g_old_rec.vrei_information20, hr_api.g_varchar2) <>
324: nvl(p_rec.vrei_information20, hr_api.g_varchar2) or

Line 321: nvl(pqp_vri_shd.g_old_rec.vrei_information19, hr_api.g_varchar2) <>

317: nvl(pqp_vri_shd.g_old_rec.vrei_information17, hr_api.g_varchar2) <>
318: nvl(p_rec.vrei_information17, hr_api.g_varchar2) or
319: nvl(pqp_vri_shd.g_old_rec.vrei_information18, hr_api.g_varchar2) <>
320: nvl(p_rec.vrei_information18, hr_api.g_varchar2) or
321: nvl(pqp_vri_shd.g_old_rec.vrei_information19, hr_api.g_varchar2) <>
322: nvl(p_rec.vrei_information19, hr_api.g_varchar2) or
323: nvl(pqp_vri_shd.g_old_rec.vrei_information20, hr_api.g_varchar2) <>
324: nvl(p_rec.vrei_information20, hr_api.g_varchar2) or
325: nvl(pqp_vri_shd.g_old_rec.vrei_information21, hr_api.g_varchar2) <>

Line 322: nvl(p_rec.vrei_information19, hr_api.g_varchar2) or

318: nvl(p_rec.vrei_information17, hr_api.g_varchar2) or
319: nvl(pqp_vri_shd.g_old_rec.vrei_information18, hr_api.g_varchar2) <>
320: nvl(p_rec.vrei_information18, hr_api.g_varchar2) or
321: nvl(pqp_vri_shd.g_old_rec.vrei_information19, hr_api.g_varchar2) <>
322: nvl(p_rec.vrei_information19, hr_api.g_varchar2) or
323: nvl(pqp_vri_shd.g_old_rec.vrei_information20, hr_api.g_varchar2) <>
324: nvl(p_rec.vrei_information20, hr_api.g_varchar2) or
325: nvl(pqp_vri_shd.g_old_rec.vrei_information21, hr_api.g_varchar2) <>
326: nvl(p_rec.vrei_information21, hr_api.g_varchar2) or

Line 323: nvl(pqp_vri_shd.g_old_rec.vrei_information20, hr_api.g_varchar2) <>

319: nvl(pqp_vri_shd.g_old_rec.vrei_information18, hr_api.g_varchar2) <>
320: nvl(p_rec.vrei_information18, hr_api.g_varchar2) or
321: nvl(pqp_vri_shd.g_old_rec.vrei_information19, hr_api.g_varchar2) <>
322: nvl(p_rec.vrei_information19, hr_api.g_varchar2) or
323: nvl(pqp_vri_shd.g_old_rec.vrei_information20, hr_api.g_varchar2) <>
324: nvl(p_rec.vrei_information20, hr_api.g_varchar2) or
325: nvl(pqp_vri_shd.g_old_rec.vrei_information21, hr_api.g_varchar2) <>
326: nvl(p_rec.vrei_information21, hr_api.g_varchar2) or
327: nvl(pqp_vri_shd.g_old_rec.vrei_information22, hr_api.g_varchar2) <>

Line 324: nvl(p_rec.vrei_information20, hr_api.g_varchar2) or

320: nvl(p_rec.vrei_information18, hr_api.g_varchar2) or
321: nvl(pqp_vri_shd.g_old_rec.vrei_information19, hr_api.g_varchar2) <>
322: nvl(p_rec.vrei_information19, hr_api.g_varchar2) or
323: nvl(pqp_vri_shd.g_old_rec.vrei_information20, hr_api.g_varchar2) <>
324: nvl(p_rec.vrei_information20, hr_api.g_varchar2) or
325: nvl(pqp_vri_shd.g_old_rec.vrei_information21, hr_api.g_varchar2) <>
326: nvl(p_rec.vrei_information21, hr_api.g_varchar2) or
327: nvl(pqp_vri_shd.g_old_rec.vrei_information22, hr_api.g_varchar2) <>
328: nvl(p_rec.vrei_information22, hr_api.g_varchar2) or

Line 325: nvl(pqp_vri_shd.g_old_rec.vrei_information21, hr_api.g_varchar2) <>

321: nvl(pqp_vri_shd.g_old_rec.vrei_information19, hr_api.g_varchar2) <>
322: nvl(p_rec.vrei_information19, hr_api.g_varchar2) or
323: nvl(pqp_vri_shd.g_old_rec.vrei_information20, hr_api.g_varchar2) <>
324: nvl(p_rec.vrei_information20, hr_api.g_varchar2) or
325: nvl(pqp_vri_shd.g_old_rec.vrei_information21, hr_api.g_varchar2) <>
326: nvl(p_rec.vrei_information21, hr_api.g_varchar2) or
327: nvl(pqp_vri_shd.g_old_rec.vrei_information22, hr_api.g_varchar2) <>
328: nvl(p_rec.vrei_information22, hr_api.g_varchar2) or
329: nvl(pqp_vri_shd.g_old_rec.vrei_information23, hr_api.g_varchar2) <>

Line 326: nvl(p_rec.vrei_information21, hr_api.g_varchar2) or

322: nvl(p_rec.vrei_information19, hr_api.g_varchar2) or
323: nvl(pqp_vri_shd.g_old_rec.vrei_information20, hr_api.g_varchar2) <>
324: nvl(p_rec.vrei_information20, hr_api.g_varchar2) or
325: nvl(pqp_vri_shd.g_old_rec.vrei_information21, hr_api.g_varchar2) <>
326: nvl(p_rec.vrei_information21, hr_api.g_varchar2) or
327: nvl(pqp_vri_shd.g_old_rec.vrei_information22, hr_api.g_varchar2) <>
328: nvl(p_rec.vrei_information22, hr_api.g_varchar2) or
329: nvl(pqp_vri_shd.g_old_rec.vrei_information23, hr_api.g_varchar2) <>
330: nvl(p_rec.vrei_information23, hr_api.g_varchar2) or

Line 327: nvl(pqp_vri_shd.g_old_rec.vrei_information22, hr_api.g_varchar2) <>

323: nvl(pqp_vri_shd.g_old_rec.vrei_information20, hr_api.g_varchar2) <>
324: nvl(p_rec.vrei_information20, hr_api.g_varchar2) or
325: nvl(pqp_vri_shd.g_old_rec.vrei_information21, hr_api.g_varchar2) <>
326: nvl(p_rec.vrei_information21, hr_api.g_varchar2) or
327: nvl(pqp_vri_shd.g_old_rec.vrei_information22, hr_api.g_varchar2) <>
328: nvl(p_rec.vrei_information22, hr_api.g_varchar2) or
329: nvl(pqp_vri_shd.g_old_rec.vrei_information23, hr_api.g_varchar2) <>
330: nvl(p_rec.vrei_information23, hr_api.g_varchar2) or
331: nvl(pqp_vri_shd.g_old_rec.vrei_information24, hr_api.g_varchar2) <>

Line 328: nvl(p_rec.vrei_information22, hr_api.g_varchar2) or

324: nvl(p_rec.vrei_information20, hr_api.g_varchar2) or
325: nvl(pqp_vri_shd.g_old_rec.vrei_information21, hr_api.g_varchar2) <>
326: nvl(p_rec.vrei_information21, hr_api.g_varchar2) or
327: nvl(pqp_vri_shd.g_old_rec.vrei_information22, hr_api.g_varchar2) <>
328: nvl(p_rec.vrei_information22, hr_api.g_varchar2) or
329: nvl(pqp_vri_shd.g_old_rec.vrei_information23, hr_api.g_varchar2) <>
330: nvl(p_rec.vrei_information23, hr_api.g_varchar2) or
331: nvl(pqp_vri_shd.g_old_rec.vrei_information24, hr_api.g_varchar2) <>
332: nvl(p_rec.vrei_information24, hr_api.g_varchar2) or

Line 329: nvl(pqp_vri_shd.g_old_rec.vrei_information23, hr_api.g_varchar2) <>

325: nvl(pqp_vri_shd.g_old_rec.vrei_information21, hr_api.g_varchar2) <>
326: nvl(p_rec.vrei_information21, hr_api.g_varchar2) or
327: nvl(pqp_vri_shd.g_old_rec.vrei_information22, hr_api.g_varchar2) <>
328: nvl(p_rec.vrei_information22, hr_api.g_varchar2) or
329: nvl(pqp_vri_shd.g_old_rec.vrei_information23, hr_api.g_varchar2) <>
330: nvl(p_rec.vrei_information23, hr_api.g_varchar2) or
331: nvl(pqp_vri_shd.g_old_rec.vrei_information24, hr_api.g_varchar2) <>
332: nvl(p_rec.vrei_information24, hr_api.g_varchar2) or
333: nvl(pqp_vri_shd.g_old_rec.vrei_information25, hr_api.g_varchar2) <>

Line 330: nvl(p_rec.vrei_information23, hr_api.g_varchar2) or

326: nvl(p_rec.vrei_information21, hr_api.g_varchar2) or
327: nvl(pqp_vri_shd.g_old_rec.vrei_information22, hr_api.g_varchar2) <>
328: nvl(p_rec.vrei_information22, hr_api.g_varchar2) or
329: nvl(pqp_vri_shd.g_old_rec.vrei_information23, hr_api.g_varchar2) <>
330: nvl(p_rec.vrei_information23, hr_api.g_varchar2) or
331: nvl(pqp_vri_shd.g_old_rec.vrei_information24, hr_api.g_varchar2) <>
332: nvl(p_rec.vrei_information24, hr_api.g_varchar2) or
333: nvl(pqp_vri_shd.g_old_rec.vrei_information25, hr_api.g_varchar2) <>
334: nvl(p_rec.vrei_information25, hr_api.g_varchar2) or

Line 331: nvl(pqp_vri_shd.g_old_rec.vrei_information24, hr_api.g_varchar2) <>

327: nvl(pqp_vri_shd.g_old_rec.vrei_information22, hr_api.g_varchar2) <>
328: nvl(p_rec.vrei_information22, hr_api.g_varchar2) or
329: nvl(pqp_vri_shd.g_old_rec.vrei_information23, hr_api.g_varchar2) <>
330: nvl(p_rec.vrei_information23, hr_api.g_varchar2) or
331: nvl(pqp_vri_shd.g_old_rec.vrei_information24, hr_api.g_varchar2) <>
332: nvl(p_rec.vrei_information24, hr_api.g_varchar2) or
333: nvl(pqp_vri_shd.g_old_rec.vrei_information25, hr_api.g_varchar2) <>
334: nvl(p_rec.vrei_information25, hr_api.g_varchar2) or
335: nvl(pqp_vri_shd.g_old_rec.vrei_information26, hr_api.g_varchar2) <>

Line 332: nvl(p_rec.vrei_information24, hr_api.g_varchar2) or

328: nvl(p_rec.vrei_information22, hr_api.g_varchar2) or
329: nvl(pqp_vri_shd.g_old_rec.vrei_information23, hr_api.g_varchar2) <>
330: nvl(p_rec.vrei_information23, hr_api.g_varchar2) or
331: nvl(pqp_vri_shd.g_old_rec.vrei_information24, hr_api.g_varchar2) <>
332: nvl(p_rec.vrei_information24, hr_api.g_varchar2) or
333: nvl(pqp_vri_shd.g_old_rec.vrei_information25, hr_api.g_varchar2) <>
334: nvl(p_rec.vrei_information25, hr_api.g_varchar2) or
335: nvl(pqp_vri_shd.g_old_rec.vrei_information26, hr_api.g_varchar2) <>
336: nvl(p_rec.vrei_information26, hr_api.g_varchar2) or

Line 333: nvl(pqp_vri_shd.g_old_rec.vrei_information25, hr_api.g_varchar2) <>

329: nvl(pqp_vri_shd.g_old_rec.vrei_information23, hr_api.g_varchar2) <>
330: nvl(p_rec.vrei_information23, hr_api.g_varchar2) or
331: nvl(pqp_vri_shd.g_old_rec.vrei_information24, hr_api.g_varchar2) <>
332: nvl(p_rec.vrei_information24, hr_api.g_varchar2) or
333: nvl(pqp_vri_shd.g_old_rec.vrei_information25, hr_api.g_varchar2) <>
334: nvl(p_rec.vrei_information25, hr_api.g_varchar2) or
335: nvl(pqp_vri_shd.g_old_rec.vrei_information26, hr_api.g_varchar2) <>
336: nvl(p_rec.vrei_information26, hr_api.g_varchar2) or
337: nvl(pqp_vri_shd.g_old_rec.vrei_information27, hr_api.g_varchar2) <>

Line 334: nvl(p_rec.vrei_information25, hr_api.g_varchar2) or

330: nvl(p_rec.vrei_information23, hr_api.g_varchar2) or
331: nvl(pqp_vri_shd.g_old_rec.vrei_information24, hr_api.g_varchar2) <>
332: nvl(p_rec.vrei_information24, hr_api.g_varchar2) or
333: nvl(pqp_vri_shd.g_old_rec.vrei_information25, hr_api.g_varchar2) <>
334: nvl(p_rec.vrei_information25, hr_api.g_varchar2) or
335: nvl(pqp_vri_shd.g_old_rec.vrei_information26, hr_api.g_varchar2) <>
336: nvl(p_rec.vrei_information26, hr_api.g_varchar2) or
337: nvl(pqp_vri_shd.g_old_rec.vrei_information27, hr_api.g_varchar2) <>
338: nvl(p_rec.vrei_information27, hr_api.g_varchar2) or

Line 335: nvl(pqp_vri_shd.g_old_rec.vrei_information26, hr_api.g_varchar2) <>

331: nvl(pqp_vri_shd.g_old_rec.vrei_information24, hr_api.g_varchar2) <>
332: nvl(p_rec.vrei_information24, hr_api.g_varchar2) or
333: nvl(pqp_vri_shd.g_old_rec.vrei_information25, hr_api.g_varchar2) <>
334: nvl(p_rec.vrei_information25, hr_api.g_varchar2) or
335: nvl(pqp_vri_shd.g_old_rec.vrei_information26, hr_api.g_varchar2) <>
336: nvl(p_rec.vrei_information26, hr_api.g_varchar2) or
337: nvl(pqp_vri_shd.g_old_rec.vrei_information27, hr_api.g_varchar2) <>
338: nvl(p_rec.vrei_information27, hr_api.g_varchar2) or
339: nvl(pqp_vri_shd.g_old_rec.vrei_information28, hr_api.g_varchar2) <>

Line 336: nvl(p_rec.vrei_information26, hr_api.g_varchar2) or

332: nvl(p_rec.vrei_information24, hr_api.g_varchar2) or
333: nvl(pqp_vri_shd.g_old_rec.vrei_information25, hr_api.g_varchar2) <>
334: nvl(p_rec.vrei_information25, hr_api.g_varchar2) or
335: nvl(pqp_vri_shd.g_old_rec.vrei_information26, hr_api.g_varchar2) <>
336: nvl(p_rec.vrei_information26, hr_api.g_varchar2) or
337: nvl(pqp_vri_shd.g_old_rec.vrei_information27, hr_api.g_varchar2) <>
338: nvl(p_rec.vrei_information27, hr_api.g_varchar2) or
339: nvl(pqp_vri_shd.g_old_rec.vrei_information28, hr_api.g_varchar2) <>
340: nvl(p_rec.vrei_information28, hr_api.g_varchar2) or

Line 337: nvl(pqp_vri_shd.g_old_rec.vrei_information27, hr_api.g_varchar2) <>

333: nvl(pqp_vri_shd.g_old_rec.vrei_information25, hr_api.g_varchar2) <>
334: nvl(p_rec.vrei_information25, hr_api.g_varchar2) or
335: nvl(pqp_vri_shd.g_old_rec.vrei_information26, hr_api.g_varchar2) <>
336: nvl(p_rec.vrei_information26, hr_api.g_varchar2) or
337: nvl(pqp_vri_shd.g_old_rec.vrei_information27, hr_api.g_varchar2) <>
338: nvl(p_rec.vrei_information27, hr_api.g_varchar2) or
339: nvl(pqp_vri_shd.g_old_rec.vrei_information28, hr_api.g_varchar2) <>
340: nvl(p_rec.vrei_information28, hr_api.g_varchar2) or
341: nvl(pqp_vri_shd.g_old_rec.vrei_information29, hr_api.g_varchar2) <>

Line 338: nvl(p_rec.vrei_information27, hr_api.g_varchar2) or

334: nvl(p_rec.vrei_information25, hr_api.g_varchar2) or
335: nvl(pqp_vri_shd.g_old_rec.vrei_information26, hr_api.g_varchar2) <>
336: nvl(p_rec.vrei_information26, hr_api.g_varchar2) or
337: nvl(pqp_vri_shd.g_old_rec.vrei_information27, hr_api.g_varchar2) <>
338: nvl(p_rec.vrei_information27, hr_api.g_varchar2) or
339: nvl(pqp_vri_shd.g_old_rec.vrei_information28, hr_api.g_varchar2) <>
340: nvl(p_rec.vrei_information28, hr_api.g_varchar2) or
341: nvl(pqp_vri_shd.g_old_rec.vrei_information29, hr_api.g_varchar2) <>
342: nvl(p_rec.vrei_information29, hr_api.g_varchar2) or

Line 339: nvl(pqp_vri_shd.g_old_rec.vrei_information28, hr_api.g_varchar2) <>

335: nvl(pqp_vri_shd.g_old_rec.vrei_information26, hr_api.g_varchar2) <>
336: nvl(p_rec.vrei_information26, hr_api.g_varchar2) or
337: nvl(pqp_vri_shd.g_old_rec.vrei_information27, hr_api.g_varchar2) <>
338: nvl(p_rec.vrei_information27, hr_api.g_varchar2) or
339: nvl(pqp_vri_shd.g_old_rec.vrei_information28, hr_api.g_varchar2) <>
340: nvl(p_rec.vrei_information28, hr_api.g_varchar2) or
341: nvl(pqp_vri_shd.g_old_rec.vrei_information29, hr_api.g_varchar2) <>
342: nvl(p_rec.vrei_information29, hr_api.g_varchar2) or
343: nvl(pqp_vri_shd.g_old_rec.vrei_information30, hr_api.g_varchar2) <>

Line 340: nvl(p_rec.vrei_information28, hr_api.g_varchar2) or

336: nvl(p_rec.vrei_information26, hr_api.g_varchar2) or
337: nvl(pqp_vri_shd.g_old_rec.vrei_information27, hr_api.g_varchar2) <>
338: nvl(p_rec.vrei_information27, hr_api.g_varchar2) or
339: nvl(pqp_vri_shd.g_old_rec.vrei_information28, hr_api.g_varchar2) <>
340: nvl(p_rec.vrei_information28, hr_api.g_varchar2) or
341: nvl(pqp_vri_shd.g_old_rec.vrei_information29, hr_api.g_varchar2) <>
342: nvl(p_rec.vrei_information29, hr_api.g_varchar2) or
343: nvl(pqp_vri_shd.g_old_rec.vrei_information30, hr_api.g_varchar2) <>
344: nvl(p_rec.vrei_information30, hr_api.g_varchar2) ))

Line 341: nvl(pqp_vri_shd.g_old_rec.vrei_information29, hr_api.g_varchar2) <>

337: nvl(pqp_vri_shd.g_old_rec.vrei_information27, hr_api.g_varchar2) <>
338: nvl(p_rec.vrei_information27, hr_api.g_varchar2) or
339: nvl(pqp_vri_shd.g_old_rec.vrei_information28, hr_api.g_varchar2) <>
340: nvl(p_rec.vrei_information28, hr_api.g_varchar2) or
341: nvl(pqp_vri_shd.g_old_rec.vrei_information29, hr_api.g_varchar2) <>
342: nvl(p_rec.vrei_information29, hr_api.g_varchar2) or
343: nvl(pqp_vri_shd.g_old_rec.vrei_information30, hr_api.g_varchar2) <>
344: nvl(p_rec.vrei_information30, hr_api.g_varchar2) ))
345: or (p_rec.veh_repos_extra_info_id is null) then

Line 342: nvl(p_rec.vrei_information29, hr_api.g_varchar2) or

338: nvl(p_rec.vrei_information27, hr_api.g_varchar2) or
339: nvl(pqp_vri_shd.g_old_rec.vrei_information28, hr_api.g_varchar2) <>
340: nvl(p_rec.vrei_information28, hr_api.g_varchar2) or
341: nvl(pqp_vri_shd.g_old_rec.vrei_information29, hr_api.g_varchar2) <>
342: nvl(p_rec.vrei_information29, hr_api.g_varchar2) or
343: nvl(pqp_vri_shd.g_old_rec.vrei_information30, hr_api.g_varchar2) <>
344: nvl(p_rec.vrei_information30, hr_api.g_varchar2) ))
345: or (p_rec.veh_repos_extra_info_id is null) then
346: --

Line 343: nvl(pqp_vri_shd.g_old_rec.vrei_information30, hr_api.g_varchar2) <>

339: nvl(pqp_vri_shd.g_old_rec.vrei_information28, hr_api.g_varchar2) <>
340: nvl(p_rec.vrei_information28, hr_api.g_varchar2) or
341: nvl(pqp_vri_shd.g_old_rec.vrei_information29, hr_api.g_varchar2) <>
342: nvl(p_rec.vrei_information29, hr_api.g_varchar2) or
343: nvl(pqp_vri_shd.g_old_rec.vrei_information30, hr_api.g_varchar2) <>
344: nvl(p_rec.vrei_information30, hr_api.g_varchar2) ))
345: or (p_rec.veh_repos_extra_info_id is null) then
346: --
347: -- Only execute the validation if absolutely necessary:

Line 344: nvl(p_rec.vrei_information30, hr_api.g_varchar2) ))

340: nvl(p_rec.vrei_information28, hr_api.g_varchar2) or
341: nvl(pqp_vri_shd.g_old_rec.vrei_information29, hr_api.g_varchar2) <>
342: nvl(p_rec.vrei_information29, hr_api.g_varchar2) or
343: nvl(pqp_vri_shd.g_old_rec.vrei_information30, hr_api.g_varchar2) <>
344: nvl(p_rec.vrei_information30, hr_api.g_varchar2) ))
345: or (p_rec.veh_repos_extra_info_id is null) then
346: --
347: -- Only execute the validation if absolutely necessary:
348: -- a) During update, the structure column value or any

Line 460: nvl(pqp_vri_shd.g_old_rec.vrei_attribute_category, hr_api.g_varchar2) <>

456: begin
457: hr_utility.set_location('Entering:'||l_proc,10);
458: --
459: if ((p_rec.veh_repos_extra_info_id is not null) and (
460: nvl(pqp_vri_shd.g_old_rec.vrei_attribute_category, hr_api.g_varchar2) <>
461: nvl(p_rec.vrei_attribute_category, hr_api.g_varchar2) or
462: nvl(pqp_vri_shd.g_old_rec.vrei_attribute1, hr_api.g_varchar2) <>
463: nvl(p_rec.vrei_attribute1, hr_api.g_varchar2) or
464: nvl(pqp_vri_shd.g_old_rec.vrei_attribute2, hr_api.g_varchar2) <>

Line 461: nvl(p_rec.vrei_attribute_category, hr_api.g_varchar2) or

457: hr_utility.set_location('Entering:'||l_proc,10);
458: --
459: if ((p_rec.veh_repos_extra_info_id is not null) and (
460: nvl(pqp_vri_shd.g_old_rec.vrei_attribute_category, hr_api.g_varchar2) <>
461: nvl(p_rec.vrei_attribute_category, hr_api.g_varchar2) or
462: nvl(pqp_vri_shd.g_old_rec.vrei_attribute1, hr_api.g_varchar2) <>
463: nvl(p_rec.vrei_attribute1, hr_api.g_varchar2) or
464: nvl(pqp_vri_shd.g_old_rec.vrei_attribute2, hr_api.g_varchar2) <>
465: nvl(p_rec.vrei_attribute2, hr_api.g_varchar2) or

Line 462: nvl(pqp_vri_shd.g_old_rec.vrei_attribute1, hr_api.g_varchar2) <>

458: --
459: if ((p_rec.veh_repos_extra_info_id is not null) and (
460: nvl(pqp_vri_shd.g_old_rec.vrei_attribute_category, hr_api.g_varchar2) <>
461: nvl(p_rec.vrei_attribute_category, hr_api.g_varchar2) or
462: nvl(pqp_vri_shd.g_old_rec.vrei_attribute1, hr_api.g_varchar2) <>
463: nvl(p_rec.vrei_attribute1, hr_api.g_varchar2) or
464: nvl(pqp_vri_shd.g_old_rec.vrei_attribute2, hr_api.g_varchar2) <>
465: nvl(p_rec.vrei_attribute2, hr_api.g_varchar2) or
466: nvl(pqp_vri_shd.g_old_rec.vrei_attribute3, hr_api.g_varchar2) <>

Line 463: nvl(p_rec.vrei_attribute1, hr_api.g_varchar2) or

459: if ((p_rec.veh_repos_extra_info_id is not null) and (
460: nvl(pqp_vri_shd.g_old_rec.vrei_attribute_category, hr_api.g_varchar2) <>
461: nvl(p_rec.vrei_attribute_category, hr_api.g_varchar2) or
462: nvl(pqp_vri_shd.g_old_rec.vrei_attribute1, hr_api.g_varchar2) <>
463: nvl(p_rec.vrei_attribute1, hr_api.g_varchar2) or
464: nvl(pqp_vri_shd.g_old_rec.vrei_attribute2, hr_api.g_varchar2) <>
465: nvl(p_rec.vrei_attribute2, hr_api.g_varchar2) or
466: nvl(pqp_vri_shd.g_old_rec.vrei_attribute3, hr_api.g_varchar2) <>
467: nvl(p_rec.vrei_attribute3, hr_api.g_varchar2) or

Line 464: nvl(pqp_vri_shd.g_old_rec.vrei_attribute2, hr_api.g_varchar2) <>

460: nvl(pqp_vri_shd.g_old_rec.vrei_attribute_category, hr_api.g_varchar2) <>
461: nvl(p_rec.vrei_attribute_category, hr_api.g_varchar2) or
462: nvl(pqp_vri_shd.g_old_rec.vrei_attribute1, hr_api.g_varchar2) <>
463: nvl(p_rec.vrei_attribute1, hr_api.g_varchar2) or
464: nvl(pqp_vri_shd.g_old_rec.vrei_attribute2, hr_api.g_varchar2) <>
465: nvl(p_rec.vrei_attribute2, hr_api.g_varchar2) or
466: nvl(pqp_vri_shd.g_old_rec.vrei_attribute3, hr_api.g_varchar2) <>
467: nvl(p_rec.vrei_attribute3, hr_api.g_varchar2) or
468: nvl(pqp_vri_shd.g_old_rec.vrei_attribute4, hr_api.g_varchar2) <>

Line 465: nvl(p_rec.vrei_attribute2, hr_api.g_varchar2) or

461: nvl(p_rec.vrei_attribute_category, hr_api.g_varchar2) or
462: nvl(pqp_vri_shd.g_old_rec.vrei_attribute1, hr_api.g_varchar2) <>
463: nvl(p_rec.vrei_attribute1, hr_api.g_varchar2) or
464: nvl(pqp_vri_shd.g_old_rec.vrei_attribute2, hr_api.g_varchar2) <>
465: nvl(p_rec.vrei_attribute2, hr_api.g_varchar2) or
466: nvl(pqp_vri_shd.g_old_rec.vrei_attribute3, hr_api.g_varchar2) <>
467: nvl(p_rec.vrei_attribute3, hr_api.g_varchar2) or
468: nvl(pqp_vri_shd.g_old_rec.vrei_attribute4, hr_api.g_varchar2) <>
469: nvl(p_rec.vrei_attribute4, hr_api.g_varchar2) or

Line 466: nvl(pqp_vri_shd.g_old_rec.vrei_attribute3, hr_api.g_varchar2) <>

462: nvl(pqp_vri_shd.g_old_rec.vrei_attribute1, hr_api.g_varchar2) <>
463: nvl(p_rec.vrei_attribute1, hr_api.g_varchar2) or
464: nvl(pqp_vri_shd.g_old_rec.vrei_attribute2, hr_api.g_varchar2) <>
465: nvl(p_rec.vrei_attribute2, hr_api.g_varchar2) or
466: nvl(pqp_vri_shd.g_old_rec.vrei_attribute3, hr_api.g_varchar2) <>
467: nvl(p_rec.vrei_attribute3, hr_api.g_varchar2) or
468: nvl(pqp_vri_shd.g_old_rec.vrei_attribute4, hr_api.g_varchar2) <>
469: nvl(p_rec.vrei_attribute4, hr_api.g_varchar2) or
470: nvl(pqp_vri_shd.g_old_rec.vrei_attribute5, hr_api.g_varchar2) <>

Line 467: nvl(p_rec.vrei_attribute3, hr_api.g_varchar2) or

463: nvl(p_rec.vrei_attribute1, hr_api.g_varchar2) or
464: nvl(pqp_vri_shd.g_old_rec.vrei_attribute2, hr_api.g_varchar2) <>
465: nvl(p_rec.vrei_attribute2, hr_api.g_varchar2) or
466: nvl(pqp_vri_shd.g_old_rec.vrei_attribute3, hr_api.g_varchar2) <>
467: nvl(p_rec.vrei_attribute3, hr_api.g_varchar2) or
468: nvl(pqp_vri_shd.g_old_rec.vrei_attribute4, hr_api.g_varchar2) <>
469: nvl(p_rec.vrei_attribute4, hr_api.g_varchar2) or
470: nvl(pqp_vri_shd.g_old_rec.vrei_attribute5, hr_api.g_varchar2) <>
471: nvl(p_rec.vrei_attribute5, hr_api.g_varchar2) or

Line 468: nvl(pqp_vri_shd.g_old_rec.vrei_attribute4, hr_api.g_varchar2) <>

464: nvl(pqp_vri_shd.g_old_rec.vrei_attribute2, hr_api.g_varchar2) <>
465: nvl(p_rec.vrei_attribute2, hr_api.g_varchar2) or
466: nvl(pqp_vri_shd.g_old_rec.vrei_attribute3, hr_api.g_varchar2) <>
467: nvl(p_rec.vrei_attribute3, hr_api.g_varchar2) or
468: nvl(pqp_vri_shd.g_old_rec.vrei_attribute4, hr_api.g_varchar2) <>
469: nvl(p_rec.vrei_attribute4, hr_api.g_varchar2) or
470: nvl(pqp_vri_shd.g_old_rec.vrei_attribute5, hr_api.g_varchar2) <>
471: nvl(p_rec.vrei_attribute5, hr_api.g_varchar2) or
472: nvl(pqp_vri_shd.g_old_rec.vrei_attribute6, hr_api.g_varchar2) <>

Line 469: nvl(p_rec.vrei_attribute4, hr_api.g_varchar2) or

465: nvl(p_rec.vrei_attribute2, hr_api.g_varchar2) or
466: nvl(pqp_vri_shd.g_old_rec.vrei_attribute3, hr_api.g_varchar2) <>
467: nvl(p_rec.vrei_attribute3, hr_api.g_varchar2) or
468: nvl(pqp_vri_shd.g_old_rec.vrei_attribute4, hr_api.g_varchar2) <>
469: nvl(p_rec.vrei_attribute4, hr_api.g_varchar2) or
470: nvl(pqp_vri_shd.g_old_rec.vrei_attribute5, hr_api.g_varchar2) <>
471: nvl(p_rec.vrei_attribute5, hr_api.g_varchar2) or
472: nvl(pqp_vri_shd.g_old_rec.vrei_attribute6, hr_api.g_varchar2) <>
473: nvl(p_rec.vrei_attribute6, hr_api.g_varchar2) or

Line 470: nvl(pqp_vri_shd.g_old_rec.vrei_attribute5, hr_api.g_varchar2) <>

466: nvl(pqp_vri_shd.g_old_rec.vrei_attribute3, hr_api.g_varchar2) <>
467: nvl(p_rec.vrei_attribute3, hr_api.g_varchar2) or
468: nvl(pqp_vri_shd.g_old_rec.vrei_attribute4, hr_api.g_varchar2) <>
469: nvl(p_rec.vrei_attribute4, hr_api.g_varchar2) or
470: nvl(pqp_vri_shd.g_old_rec.vrei_attribute5, hr_api.g_varchar2) <>
471: nvl(p_rec.vrei_attribute5, hr_api.g_varchar2) or
472: nvl(pqp_vri_shd.g_old_rec.vrei_attribute6, hr_api.g_varchar2) <>
473: nvl(p_rec.vrei_attribute6, hr_api.g_varchar2) or
474: nvl(pqp_vri_shd.g_old_rec.vrei_attribute7, hr_api.g_varchar2) <>

Line 471: nvl(p_rec.vrei_attribute5, hr_api.g_varchar2) or

467: nvl(p_rec.vrei_attribute3, hr_api.g_varchar2) or
468: nvl(pqp_vri_shd.g_old_rec.vrei_attribute4, hr_api.g_varchar2) <>
469: nvl(p_rec.vrei_attribute4, hr_api.g_varchar2) or
470: nvl(pqp_vri_shd.g_old_rec.vrei_attribute5, hr_api.g_varchar2) <>
471: nvl(p_rec.vrei_attribute5, hr_api.g_varchar2) or
472: nvl(pqp_vri_shd.g_old_rec.vrei_attribute6, hr_api.g_varchar2) <>
473: nvl(p_rec.vrei_attribute6, hr_api.g_varchar2) or
474: nvl(pqp_vri_shd.g_old_rec.vrei_attribute7, hr_api.g_varchar2) <>
475: nvl(p_rec.vrei_attribute7, hr_api.g_varchar2) or

Line 472: nvl(pqp_vri_shd.g_old_rec.vrei_attribute6, hr_api.g_varchar2) <>

468: nvl(pqp_vri_shd.g_old_rec.vrei_attribute4, hr_api.g_varchar2) <>
469: nvl(p_rec.vrei_attribute4, hr_api.g_varchar2) or
470: nvl(pqp_vri_shd.g_old_rec.vrei_attribute5, hr_api.g_varchar2) <>
471: nvl(p_rec.vrei_attribute5, hr_api.g_varchar2) or
472: nvl(pqp_vri_shd.g_old_rec.vrei_attribute6, hr_api.g_varchar2) <>
473: nvl(p_rec.vrei_attribute6, hr_api.g_varchar2) or
474: nvl(pqp_vri_shd.g_old_rec.vrei_attribute7, hr_api.g_varchar2) <>
475: nvl(p_rec.vrei_attribute7, hr_api.g_varchar2) or
476: nvl(pqp_vri_shd.g_old_rec.vrei_attribute8, hr_api.g_varchar2) <>

Line 473: nvl(p_rec.vrei_attribute6, hr_api.g_varchar2) or

469: nvl(p_rec.vrei_attribute4, hr_api.g_varchar2) or
470: nvl(pqp_vri_shd.g_old_rec.vrei_attribute5, hr_api.g_varchar2) <>
471: nvl(p_rec.vrei_attribute5, hr_api.g_varchar2) or
472: nvl(pqp_vri_shd.g_old_rec.vrei_attribute6, hr_api.g_varchar2) <>
473: nvl(p_rec.vrei_attribute6, hr_api.g_varchar2) or
474: nvl(pqp_vri_shd.g_old_rec.vrei_attribute7, hr_api.g_varchar2) <>
475: nvl(p_rec.vrei_attribute7, hr_api.g_varchar2) or
476: nvl(pqp_vri_shd.g_old_rec.vrei_attribute8, hr_api.g_varchar2) <>
477: nvl(p_rec.vrei_attribute8, hr_api.g_varchar2) or

Line 474: nvl(pqp_vri_shd.g_old_rec.vrei_attribute7, hr_api.g_varchar2) <>

470: nvl(pqp_vri_shd.g_old_rec.vrei_attribute5, hr_api.g_varchar2) <>
471: nvl(p_rec.vrei_attribute5, hr_api.g_varchar2) or
472: nvl(pqp_vri_shd.g_old_rec.vrei_attribute6, hr_api.g_varchar2) <>
473: nvl(p_rec.vrei_attribute6, hr_api.g_varchar2) or
474: nvl(pqp_vri_shd.g_old_rec.vrei_attribute7, hr_api.g_varchar2) <>
475: nvl(p_rec.vrei_attribute7, hr_api.g_varchar2) or
476: nvl(pqp_vri_shd.g_old_rec.vrei_attribute8, hr_api.g_varchar2) <>
477: nvl(p_rec.vrei_attribute8, hr_api.g_varchar2) or
478: nvl(pqp_vri_shd.g_old_rec.vrei_attribute9, hr_api.g_varchar2) <>

Line 475: nvl(p_rec.vrei_attribute7, hr_api.g_varchar2) or

471: nvl(p_rec.vrei_attribute5, hr_api.g_varchar2) or
472: nvl(pqp_vri_shd.g_old_rec.vrei_attribute6, hr_api.g_varchar2) <>
473: nvl(p_rec.vrei_attribute6, hr_api.g_varchar2) or
474: nvl(pqp_vri_shd.g_old_rec.vrei_attribute7, hr_api.g_varchar2) <>
475: nvl(p_rec.vrei_attribute7, hr_api.g_varchar2) or
476: nvl(pqp_vri_shd.g_old_rec.vrei_attribute8, hr_api.g_varchar2) <>
477: nvl(p_rec.vrei_attribute8, hr_api.g_varchar2) or
478: nvl(pqp_vri_shd.g_old_rec.vrei_attribute9, hr_api.g_varchar2) <>
479: nvl(p_rec.vrei_attribute9, hr_api.g_varchar2) or

Line 476: nvl(pqp_vri_shd.g_old_rec.vrei_attribute8, hr_api.g_varchar2) <>

472: nvl(pqp_vri_shd.g_old_rec.vrei_attribute6, hr_api.g_varchar2) <>
473: nvl(p_rec.vrei_attribute6, hr_api.g_varchar2) or
474: nvl(pqp_vri_shd.g_old_rec.vrei_attribute7, hr_api.g_varchar2) <>
475: nvl(p_rec.vrei_attribute7, hr_api.g_varchar2) or
476: nvl(pqp_vri_shd.g_old_rec.vrei_attribute8, hr_api.g_varchar2) <>
477: nvl(p_rec.vrei_attribute8, hr_api.g_varchar2) or
478: nvl(pqp_vri_shd.g_old_rec.vrei_attribute9, hr_api.g_varchar2) <>
479: nvl(p_rec.vrei_attribute9, hr_api.g_varchar2) or
480: nvl(pqp_vri_shd.g_old_rec.vrei_attribute10, hr_api.g_varchar2) <>

Line 477: nvl(p_rec.vrei_attribute8, hr_api.g_varchar2) or

473: nvl(p_rec.vrei_attribute6, hr_api.g_varchar2) or
474: nvl(pqp_vri_shd.g_old_rec.vrei_attribute7, hr_api.g_varchar2) <>
475: nvl(p_rec.vrei_attribute7, hr_api.g_varchar2) or
476: nvl(pqp_vri_shd.g_old_rec.vrei_attribute8, hr_api.g_varchar2) <>
477: nvl(p_rec.vrei_attribute8, hr_api.g_varchar2) or
478: nvl(pqp_vri_shd.g_old_rec.vrei_attribute9, hr_api.g_varchar2) <>
479: nvl(p_rec.vrei_attribute9, hr_api.g_varchar2) or
480: nvl(pqp_vri_shd.g_old_rec.vrei_attribute10, hr_api.g_varchar2) <>
481: nvl(p_rec.vrei_attribute10, hr_api.g_varchar2) or

Line 478: nvl(pqp_vri_shd.g_old_rec.vrei_attribute9, hr_api.g_varchar2) <>

474: nvl(pqp_vri_shd.g_old_rec.vrei_attribute7, hr_api.g_varchar2) <>
475: nvl(p_rec.vrei_attribute7, hr_api.g_varchar2) or
476: nvl(pqp_vri_shd.g_old_rec.vrei_attribute8, hr_api.g_varchar2) <>
477: nvl(p_rec.vrei_attribute8, hr_api.g_varchar2) or
478: nvl(pqp_vri_shd.g_old_rec.vrei_attribute9, hr_api.g_varchar2) <>
479: nvl(p_rec.vrei_attribute9, hr_api.g_varchar2) or
480: nvl(pqp_vri_shd.g_old_rec.vrei_attribute10, hr_api.g_varchar2) <>
481: nvl(p_rec.vrei_attribute10, hr_api.g_varchar2) or
482: nvl(pqp_vri_shd.g_old_rec.vrei_attribute11, hr_api.g_varchar2) <>

Line 479: nvl(p_rec.vrei_attribute9, hr_api.g_varchar2) or

475: nvl(p_rec.vrei_attribute7, hr_api.g_varchar2) or
476: nvl(pqp_vri_shd.g_old_rec.vrei_attribute8, hr_api.g_varchar2) <>
477: nvl(p_rec.vrei_attribute8, hr_api.g_varchar2) or
478: nvl(pqp_vri_shd.g_old_rec.vrei_attribute9, hr_api.g_varchar2) <>
479: nvl(p_rec.vrei_attribute9, hr_api.g_varchar2) or
480: nvl(pqp_vri_shd.g_old_rec.vrei_attribute10, hr_api.g_varchar2) <>
481: nvl(p_rec.vrei_attribute10, hr_api.g_varchar2) or
482: nvl(pqp_vri_shd.g_old_rec.vrei_attribute11, hr_api.g_varchar2) <>
483: nvl(p_rec.vrei_attribute11, hr_api.g_varchar2) or

Line 480: nvl(pqp_vri_shd.g_old_rec.vrei_attribute10, hr_api.g_varchar2) <>

476: nvl(pqp_vri_shd.g_old_rec.vrei_attribute8, hr_api.g_varchar2) <>
477: nvl(p_rec.vrei_attribute8, hr_api.g_varchar2) or
478: nvl(pqp_vri_shd.g_old_rec.vrei_attribute9, hr_api.g_varchar2) <>
479: nvl(p_rec.vrei_attribute9, hr_api.g_varchar2) or
480: nvl(pqp_vri_shd.g_old_rec.vrei_attribute10, hr_api.g_varchar2) <>
481: nvl(p_rec.vrei_attribute10, hr_api.g_varchar2) or
482: nvl(pqp_vri_shd.g_old_rec.vrei_attribute11, hr_api.g_varchar2) <>
483: nvl(p_rec.vrei_attribute11, hr_api.g_varchar2) or
484: nvl(pqp_vri_shd.g_old_rec.vrei_attribute12, hr_api.g_varchar2) <>

Line 481: nvl(p_rec.vrei_attribute10, hr_api.g_varchar2) or

477: nvl(p_rec.vrei_attribute8, hr_api.g_varchar2) or
478: nvl(pqp_vri_shd.g_old_rec.vrei_attribute9, hr_api.g_varchar2) <>
479: nvl(p_rec.vrei_attribute9, hr_api.g_varchar2) or
480: nvl(pqp_vri_shd.g_old_rec.vrei_attribute10, hr_api.g_varchar2) <>
481: nvl(p_rec.vrei_attribute10, hr_api.g_varchar2) or
482: nvl(pqp_vri_shd.g_old_rec.vrei_attribute11, hr_api.g_varchar2) <>
483: nvl(p_rec.vrei_attribute11, hr_api.g_varchar2) or
484: nvl(pqp_vri_shd.g_old_rec.vrei_attribute12, hr_api.g_varchar2) <>
485: nvl(p_rec.vrei_attribute12, hr_api.g_varchar2) or

Line 482: nvl(pqp_vri_shd.g_old_rec.vrei_attribute11, hr_api.g_varchar2) <>

478: nvl(pqp_vri_shd.g_old_rec.vrei_attribute9, hr_api.g_varchar2) <>
479: nvl(p_rec.vrei_attribute9, hr_api.g_varchar2) or
480: nvl(pqp_vri_shd.g_old_rec.vrei_attribute10, hr_api.g_varchar2) <>
481: nvl(p_rec.vrei_attribute10, hr_api.g_varchar2) or
482: nvl(pqp_vri_shd.g_old_rec.vrei_attribute11, hr_api.g_varchar2) <>
483: nvl(p_rec.vrei_attribute11, hr_api.g_varchar2) or
484: nvl(pqp_vri_shd.g_old_rec.vrei_attribute12, hr_api.g_varchar2) <>
485: nvl(p_rec.vrei_attribute12, hr_api.g_varchar2) or
486: nvl(pqp_vri_shd.g_old_rec.vrei_attribute13, hr_api.g_varchar2) <>

Line 483: nvl(p_rec.vrei_attribute11, hr_api.g_varchar2) or

479: nvl(p_rec.vrei_attribute9, hr_api.g_varchar2) or
480: nvl(pqp_vri_shd.g_old_rec.vrei_attribute10, hr_api.g_varchar2) <>
481: nvl(p_rec.vrei_attribute10, hr_api.g_varchar2) or
482: nvl(pqp_vri_shd.g_old_rec.vrei_attribute11, hr_api.g_varchar2) <>
483: nvl(p_rec.vrei_attribute11, hr_api.g_varchar2) or
484: nvl(pqp_vri_shd.g_old_rec.vrei_attribute12, hr_api.g_varchar2) <>
485: nvl(p_rec.vrei_attribute12, hr_api.g_varchar2) or
486: nvl(pqp_vri_shd.g_old_rec.vrei_attribute13, hr_api.g_varchar2) <>
487: nvl(p_rec.vrei_attribute13, hr_api.g_varchar2) or

Line 484: nvl(pqp_vri_shd.g_old_rec.vrei_attribute12, hr_api.g_varchar2) <>

480: nvl(pqp_vri_shd.g_old_rec.vrei_attribute10, hr_api.g_varchar2) <>
481: nvl(p_rec.vrei_attribute10, hr_api.g_varchar2) or
482: nvl(pqp_vri_shd.g_old_rec.vrei_attribute11, hr_api.g_varchar2) <>
483: nvl(p_rec.vrei_attribute11, hr_api.g_varchar2) or
484: nvl(pqp_vri_shd.g_old_rec.vrei_attribute12, hr_api.g_varchar2) <>
485: nvl(p_rec.vrei_attribute12, hr_api.g_varchar2) or
486: nvl(pqp_vri_shd.g_old_rec.vrei_attribute13, hr_api.g_varchar2) <>
487: nvl(p_rec.vrei_attribute13, hr_api.g_varchar2) or
488: nvl(pqp_vri_shd.g_old_rec.vrei_attribute14, hr_api.g_varchar2) <>

Line 485: nvl(p_rec.vrei_attribute12, hr_api.g_varchar2) or

481: nvl(p_rec.vrei_attribute10, hr_api.g_varchar2) or
482: nvl(pqp_vri_shd.g_old_rec.vrei_attribute11, hr_api.g_varchar2) <>
483: nvl(p_rec.vrei_attribute11, hr_api.g_varchar2) or
484: nvl(pqp_vri_shd.g_old_rec.vrei_attribute12, hr_api.g_varchar2) <>
485: nvl(p_rec.vrei_attribute12, hr_api.g_varchar2) or
486: nvl(pqp_vri_shd.g_old_rec.vrei_attribute13, hr_api.g_varchar2) <>
487: nvl(p_rec.vrei_attribute13, hr_api.g_varchar2) or
488: nvl(pqp_vri_shd.g_old_rec.vrei_attribute14, hr_api.g_varchar2) <>
489: nvl(p_rec.vrei_attribute14, hr_api.g_varchar2) or

Line 486: nvl(pqp_vri_shd.g_old_rec.vrei_attribute13, hr_api.g_varchar2) <>

482: nvl(pqp_vri_shd.g_old_rec.vrei_attribute11, hr_api.g_varchar2) <>
483: nvl(p_rec.vrei_attribute11, hr_api.g_varchar2) or
484: nvl(pqp_vri_shd.g_old_rec.vrei_attribute12, hr_api.g_varchar2) <>
485: nvl(p_rec.vrei_attribute12, hr_api.g_varchar2) or
486: nvl(pqp_vri_shd.g_old_rec.vrei_attribute13, hr_api.g_varchar2) <>
487: nvl(p_rec.vrei_attribute13, hr_api.g_varchar2) or
488: nvl(pqp_vri_shd.g_old_rec.vrei_attribute14, hr_api.g_varchar2) <>
489: nvl(p_rec.vrei_attribute14, hr_api.g_varchar2) or
490: nvl(pqp_vri_shd.g_old_rec.vrei_attribute15, hr_api.g_varchar2) <>

Line 487: nvl(p_rec.vrei_attribute13, hr_api.g_varchar2) or

483: nvl(p_rec.vrei_attribute11, hr_api.g_varchar2) or
484: nvl(pqp_vri_shd.g_old_rec.vrei_attribute12, hr_api.g_varchar2) <>
485: nvl(p_rec.vrei_attribute12, hr_api.g_varchar2) or
486: nvl(pqp_vri_shd.g_old_rec.vrei_attribute13, hr_api.g_varchar2) <>
487: nvl(p_rec.vrei_attribute13, hr_api.g_varchar2) or
488: nvl(pqp_vri_shd.g_old_rec.vrei_attribute14, hr_api.g_varchar2) <>
489: nvl(p_rec.vrei_attribute14, hr_api.g_varchar2) or
490: nvl(pqp_vri_shd.g_old_rec.vrei_attribute15, hr_api.g_varchar2) <>
491: nvl(p_rec.vrei_attribute15, hr_api.g_varchar2) or

Line 488: nvl(pqp_vri_shd.g_old_rec.vrei_attribute14, hr_api.g_varchar2) <>

484: nvl(pqp_vri_shd.g_old_rec.vrei_attribute12, hr_api.g_varchar2) <>
485: nvl(p_rec.vrei_attribute12, hr_api.g_varchar2) or
486: nvl(pqp_vri_shd.g_old_rec.vrei_attribute13, hr_api.g_varchar2) <>
487: nvl(p_rec.vrei_attribute13, hr_api.g_varchar2) or
488: nvl(pqp_vri_shd.g_old_rec.vrei_attribute14, hr_api.g_varchar2) <>
489: nvl(p_rec.vrei_attribute14, hr_api.g_varchar2) or
490: nvl(pqp_vri_shd.g_old_rec.vrei_attribute15, hr_api.g_varchar2) <>
491: nvl(p_rec.vrei_attribute15, hr_api.g_varchar2) or
492: nvl(pqp_vri_shd.g_old_rec.vrei_attribute16, hr_api.g_varchar2) <>

Line 489: nvl(p_rec.vrei_attribute14, hr_api.g_varchar2) or

485: nvl(p_rec.vrei_attribute12, hr_api.g_varchar2) or
486: nvl(pqp_vri_shd.g_old_rec.vrei_attribute13, hr_api.g_varchar2) <>
487: nvl(p_rec.vrei_attribute13, hr_api.g_varchar2) or
488: nvl(pqp_vri_shd.g_old_rec.vrei_attribute14, hr_api.g_varchar2) <>
489: nvl(p_rec.vrei_attribute14, hr_api.g_varchar2) or
490: nvl(pqp_vri_shd.g_old_rec.vrei_attribute15, hr_api.g_varchar2) <>
491: nvl(p_rec.vrei_attribute15, hr_api.g_varchar2) or
492: nvl(pqp_vri_shd.g_old_rec.vrei_attribute16, hr_api.g_varchar2) <>
493: nvl(p_rec.vrei_attribute16, hr_api.g_varchar2) or

Line 490: nvl(pqp_vri_shd.g_old_rec.vrei_attribute15, hr_api.g_varchar2) <>

486: nvl(pqp_vri_shd.g_old_rec.vrei_attribute13, hr_api.g_varchar2) <>
487: nvl(p_rec.vrei_attribute13, hr_api.g_varchar2) or
488: nvl(pqp_vri_shd.g_old_rec.vrei_attribute14, hr_api.g_varchar2) <>
489: nvl(p_rec.vrei_attribute14, hr_api.g_varchar2) or
490: nvl(pqp_vri_shd.g_old_rec.vrei_attribute15, hr_api.g_varchar2) <>
491: nvl(p_rec.vrei_attribute15, hr_api.g_varchar2) or
492: nvl(pqp_vri_shd.g_old_rec.vrei_attribute16, hr_api.g_varchar2) <>
493: nvl(p_rec.vrei_attribute16, hr_api.g_varchar2) or
494: nvl(pqp_vri_shd.g_old_rec.vrei_attribute17, hr_api.g_varchar2) <>

Line 491: nvl(p_rec.vrei_attribute15, hr_api.g_varchar2) or

487: nvl(p_rec.vrei_attribute13, hr_api.g_varchar2) or
488: nvl(pqp_vri_shd.g_old_rec.vrei_attribute14, hr_api.g_varchar2) <>
489: nvl(p_rec.vrei_attribute14, hr_api.g_varchar2) or
490: nvl(pqp_vri_shd.g_old_rec.vrei_attribute15, hr_api.g_varchar2) <>
491: nvl(p_rec.vrei_attribute15, hr_api.g_varchar2) or
492: nvl(pqp_vri_shd.g_old_rec.vrei_attribute16, hr_api.g_varchar2) <>
493: nvl(p_rec.vrei_attribute16, hr_api.g_varchar2) or
494: nvl(pqp_vri_shd.g_old_rec.vrei_attribute17, hr_api.g_varchar2) <>
495: nvl(p_rec.vrei_attribute17, hr_api.g_varchar2) or

Line 492: nvl(pqp_vri_shd.g_old_rec.vrei_attribute16, hr_api.g_varchar2) <>

488: nvl(pqp_vri_shd.g_old_rec.vrei_attribute14, hr_api.g_varchar2) <>
489: nvl(p_rec.vrei_attribute14, hr_api.g_varchar2) or
490: nvl(pqp_vri_shd.g_old_rec.vrei_attribute15, hr_api.g_varchar2) <>
491: nvl(p_rec.vrei_attribute15, hr_api.g_varchar2) or
492: nvl(pqp_vri_shd.g_old_rec.vrei_attribute16, hr_api.g_varchar2) <>
493: nvl(p_rec.vrei_attribute16, hr_api.g_varchar2) or
494: nvl(pqp_vri_shd.g_old_rec.vrei_attribute17, hr_api.g_varchar2) <>
495: nvl(p_rec.vrei_attribute17, hr_api.g_varchar2) or
496: nvl(pqp_vri_shd.g_old_rec.vrei_attribute18, hr_api.g_varchar2) <>

Line 493: nvl(p_rec.vrei_attribute16, hr_api.g_varchar2) or

489: nvl(p_rec.vrei_attribute14, hr_api.g_varchar2) or
490: nvl(pqp_vri_shd.g_old_rec.vrei_attribute15, hr_api.g_varchar2) <>
491: nvl(p_rec.vrei_attribute15, hr_api.g_varchar2) or
492: nvl(pqp_vri_shd.g_old_rec.vrei_attribute16, hr_api.g_varchar2) <>
493: nvl(p_rec.vrei_attribute16, hr_api.g_varchar2) or
494: nvl(pqp_vri_shd.g_old_rec.vrei_attribute17, hr_api.g_varchar2) <>
495: nvl(p_rec.vrei_attribute17, hr_api.g_varchar2) or
496: nvl(pqp_vri_shd.g_old_rec.vrei_attribute18, hr_api.g_varchar2) <>
497: nvl(p_rec.vrei_attribute18, hr_api.g_varchar2) or

Line 494: nvl(pqp_vri_shd.g_old_rec.vrei_attribute17, hr_api.g_varchar2) <>

490: nvl(pqp_vri_shd.g_old_rec.vrei_attribute15, hr_api.g_varchar2) <>
491: nvl(p_rec.vrei_attribute15, hr_api.g_varchar2) or
492: nvl(pqp_vri_shd.g_old_rec.vrei_attribute16, hr_api.g_varchar2) <>
493: nvl(p_rec.vrei_attribute16, hr_api.g_varchar2) or
494: nvl(pqp_vri_shd.g_old_rec.vrei_attribute17, hr_api.g_varchar2) <>
495: nvl(p_rec.vrei_attribute17, hr_api.g_varchar2) or
496: nvl(pqp_vri_shd.g_old_rec.vrei_attribute18, hr_api.g_varchar2) <>
497: nvl(p_rec.vrei_attribute18, hr_api.g_varchar2) or
498: nvl(pqp_vri_shd.g_old_rec.vrei_attribute19, hr_api.g_varchar2) <>

Line 495: nvl(p_rec.vrei_attribute17, hr_api.g_varchar2) or

491: nvl(p_rec.vrei_attribute15, hr_api.g_varchar2) or
492: nvl(pqp_vri_shd.g_old_rec.vrei_attribute16, hr_api.g_varchar2) <>
493: nvl(p_rec.vrei_attribute16, hr_api.g_varchar2) or
494: nvl(pqp_vri_shd.g_old_rec.vrei_attribute17, hr_api.g_varchar2) <>
495: nvl(p_rec.vrei_attribute17, hr_api.g_varchar2) or
496: nvl(pqp_vri_shd.g_old_rec.vrei_attribute18, hr_api.g_varchar2) <>
497: nvl(p_rec.vrei_attribute18, hr_api.g_varchar2) or
498: nvl(pqp_vri_shd.g_old_rec.vrei_attribute19, hr_api.g_varchar2) <>
499: nvl(p_rec.vrei_attribute19, hr_api.g_varchar2) or

Line 496: nvl(pqp_vri_shd.g_old_rec.vrei_attribute18, hr_api.g_varchar2) <>

492: nvl(pqp_vri_shd.g_old_rec.vrei_attribute16, hr_api.g_varchar2) <>
493: nvl(p_rec.vrei_attribute16, hr_api.g_varchar2) or
494: nvl(pqp_vri_shd.g_old_rec.vrei_attribute17, hr_api.g_varchar2) <>
495: nvl(p_rec.vrei_attribute17, hr_api.g_varchar2) or
496: nvl(pqp_vri_shd.g_old_rec.vrei_attribute18, hr_api.g_varchar2) <>
497: nvl(p_rec.vrei_attribute18, hr_api.g_varchar2) or
498: nvl(pqp_vri_shd.g_old_rec.vrei_attribute19, hr_api.g_varchar2) <>
499: nvl(p_rec.vrei_attribute19, hr_api.g_varchar2) or
500: nvl(pqp_vri_shd.g_old_rec.vrei_attribute20, hr_api.g_varchar2) <>

Line 497: nvl(p_rec.vrei_attribute18, hr_api.g_varchar2) or

493: nvl(p_rec.vrei_attribute16, hr_api.g_varchar2) or
494: nvl(pqp_vri_shd.g_old_rec.vrei_attribute17, hr_api.g_varchar2) <>
495: nvl(p_rec.vrei_attribute17, hr_api.g_varchar2) or
496: nvl(pqp_vri_shd.g_old_rec.vrei_attribute18, hr_api.g_varchar2) <>
497: nvl(p_rec.vrei_attribute18, hr_api.g_varchar2) or
498: nvl(pqp_vri_shd.g_old_rec.vrei_attribute19, hr_api.g_varchar2) <>
499: nvl(p_rec.vrei_attribute19, hr_api.g_varchar2) or
500: nvl(pqp_vri_shd.g_old_rec.vrei_attribute20, hr_api.g_varchar2) <>
501: nvl(p_rec.vrei_attribute20, hr_api.g_varchar2) ))

Line 498: nvl(pqp_vri_shd.g_old_rec.vrei_attribute19, hr_api.g_varchar2) <>

494: nvl(pqp_vri_shd.g_old_rec.vrei_attribute17, hr_api.g_varchar2) <>
495: nvl(p_rec.vrei_attribute17, hr_api.g_varchar2) or
496: nvl(pqp_vri_shd.g_old_rec.vrei_attribute18, hr_api.g_varchar2) <>
497: nvl(p_rec.vrei_attribute18, hr_api.g_varchar2) or
498: nvl(pqp_vri_shd.g_old_rec.vrei_attribute19, hr_api.g_varchar2) <>
499: nvl(p_rec.vrei_attribute19, hr_api.g_varchar2) or
500: nvl(pqp_vri_shd.g_old_rec.vrei_attribute20, hr_api.g_varchar2) <>
501: nvl(p_rec.vrei_attribute20, hr_api.g_varchar2) ))
502: or (p_rec.veh_repos_extra_info_id is null) then

Line 499: nvl(p_rec.vrei_attribute19, hr_api.g_varchar2) or

495: nvl(p_rec.vrei_attribute17, hr_api.g_varchar2) or
496: nvl(pqp_vri_shd.g_old_rec.vrei_attribute18, hr_api.g_varchar2) <>
497: nvl(p_rec.vrei_attribute18, hr_api.g_varchar2) or
498: nvl(pqp_vri_shd.g_old_rec.vrei_attribute19, hr_api.g_varchar2) <>
499: nvl(p_rec.vrei_attribute19, hr_api.g_varchar2) or
500: nvl(pqp_vri_shd.g_old_rec.vrei_attribute20, hr_api.g_varchar2) <>
501: nvl(p_rec.vrei_attribute20, hr_api.g_varchar2) ))
502: or (p_rec.veh_repos_extra_info_id is null) then
503: --

Line 500: nvl(pqp_vri_shd.g_old_rec.vrei_attribute20, hr_api.g_varchar2) <>

496: nvl(pqp_vri_shd.g_old_rec.vrei_attribute18, hr_api.g_varchar2) <>
497: nvl(p_rec.vrei_attribute18, hr_api.g_varchar2) or
498: nvl(pqp_vri_shd.g_old_rec.vrei_attribute19, hr_api.g_varchar2) <>
499: nvl(p_rec.vrei_attribute19, hr_api.g_varchar2) or
500: nvl(pqp_vri_shd.g_old_rec.vrei_attribute20, hr_api.g_varchar2) <>
501: nvl(p_rec.vrei_attribute20, hr_api.g_varchar2) ))
502: or (p_rec.veh_repos_extra_info_id is null) then
503: --
504: -- Only execute the validation if absolutely necessary:

Line 501: nvl(p_rec.vrei_attribute20, hr_api.g_varchar2) ))

497: nvl(p_rec.vrei_attribute18, hr_api.g_varchar2) or
498: nvl(pqp_vri_shd.g_old_rec.vrei_attribute19, hr_api.g_varchar2) <>
499: nvl(p_rec.vrei_attribute19, hr_api.g_varchar2) or
500: nvl(pqp_vri_shd.g_old_rec.vrei_attribute20, hr_api.g_varchar2) <>
501: nvl(p_rec.vrei_attribute20, hr_api.g_varchar2) ))
502: or (p_rec.veh_repos_extra_info_id is null) then
503: --
504: -- Only execute the validation if absolutely necessary:
505: -- a) During update, the structure column value or any