268: -- Internal Row Handler Use Only.
269: --
270: -- ----------------------------------------------------------------------------
271: procedure chk_ddf
272: (p_rec in pqp_vri_shd.g_rec_type
273: ) is
274: --
275: l_proc varchar2(72) := g_package || 'chk_ddf';
276: --
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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
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:
447: -- Internal Row Handler Use Only.
448: --
449: -- ----------------------------------------------------------------------------
450: procedure chk_df
451: (p_rec in pqp_vri_shd.g_rec_type
452: ) is
453: --
454: l_proc varchar2(72) := g_package || 'chk_df';
455: --
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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
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:
583: --
584: -- {End Of Comments}
585: -- ----------------------------------------------------------------------------
586: Procedure chk_non_updateable_args
587: (p_rec in pqp_vri_shd.g_rec_type
588: ) IS
589: --
590: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
591: --
593: --
594: -- Only proceed with the validation if a row exists for the current
595: -- record in the HR Schema.
596: --
597: IF NOT pqp_vri_shd.api_updating
598: (p_veh_repos_extra_info_id => p_rec.veh_repos_extra_info_id
599: ,p_object_version_number => p_rec.object_version_number
600: ) THEN
601: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
612: -- ----------------------------------------------------------------------------
613: -- |---------------------------< insert_validate >----------------------------|
614: -- ----------------------------------------------------------------------------
615: Procedure insert_validate
616: (p_rec in pqp_vri_shd.g_rec_type
617: ) is
618: --
619: l_proc varchar2(72) := g_package||'insert_validate';
620: --
644: -- ----------------------------------------------------------------------------
645: -- |---------------------------< update_validate >----------------------------|
646: -- ----------------------------------------------------------------------------
647: Procedure update_validate
648: (p_rec in pqp_vri_shd.g_rec_type
649: ) is
650: --
651: l_proc varchar2(72) := g_package||'update_validate';
652: --
680: -- ----------------------------------------------------------------------------
681: -- |---------------------------< delete_validate >----------------------------|
682: -- ----------------------------------------------------------------------------
683: Procedure delete_validate
684: (p_rec in pqp_vri_shd.g_rec_type
685: ) is
686: --
687: l_proc varchar2(72) := g_package||'delete_validate';
688: --