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 PQP_VAI_SHD

Line 271: (p_rec in pqp_vai_shd.g_rec_type

267: -- Internal Row Handler Use Only.
268: --
269: -- ----------------------------------------------------------------------------
270: procedure chk_ddf
271: (p_rec in pqp_vai_shd.g_rec_type
272: ) is
273: --
274: l_proc varchar2(72) := g_package || 'chk_ddf';
275: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 454: (p_rec in pqp_vai_shd.g_rec_type

450: -- Internal Row Handler Use Only.
451: --
452: -- ----------------------------------------------------------------------------
453: procedure chk_df
454: (p_rec in pqp_vai_shd.g_rec_type
455: ) is
456: --
457: l_proc varchar2(72) := g_package || 'chk_df';
458: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 590: (p_rec in pqp_vai_shd.g_rec_type

586: --
587: -- {End Of Comments}
588: -- ----------------------------------------------------------------------------
589: Procedure chk_non_updateable_args
590: (p_rec in pqp_vai_shd.g_rec_type
591: ) IS
592: --
593: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
594: --

Line 600: IF NOT pqp_vai_shd.api_updating

596: --
597: -- Only proceed with the validation if a row exists for the current
598: -- record in the HR Schema.
599: --
600: IF NOT pqp_vai_shd.api_updating
601: (p_veh_alloc_extra_info_id => p_rec.veh_alloc_extra_info_id
602: ,p_object_version_number => p_rec.object_version_number
603: ) THEN
604: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 619: (p_rec in pqp_vai_shd.g_rec_type

615: -- ----------------------------------------------------------------------------
616: -- |---------------------------< insert_validate >----------------------------|
617: -- ----------------------------------------------------------------------------
618: Procedure insert_validate
619: (p_rec in pqp_vai_shd.g_rec_type
620: ) is
621: --
622: l_proc varchar2(72) := g_package||'insert_validate';
623: --

Line 651: (p_rec in pqp_vai_shd.g_rec_type

647: -- ----------------------------------------------------------------------------
648: -- |---------------------------< update_validate >----------------------------|
649: -- ----------------------------------------------------------------------------
650: Procedure update_validate
651: (p_rec in pqp_vai_shd.g_rec_type
652: ) is
653: --
654: l_proc varchar2(72) := g_package||'update_validate';
655: --

Line 687: (p_rec in pqp_vai_shd.g_rec_type

683: -- ----------------------------------------------------------------------------
684: -- |---------------------------< delete_validate >----------------------------|
685: -- ----------------------------------------------------------------------------
686: Procedure delete_validate
687: (p_rec in pqp_vai_shd.g_rec_type
688: ) is
689: --
690: l_proc varchar2(72) := g_package||'delete_validate';
691: --