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.HR_DEI_BUS dependencies on HR_DEI_SHD

Line 265: (p_rec in hr_dei_shd.g_rec_type

261: -- Internal Row Handler Use Only.
262: --
263: -- ----------------------------------------------------------------------------
264: procedure chk_ddf
265: (p_rec in hr_dei_shd.g_rec_type
266: ) is
267: --
268: l_proc varchar2(72) := g_package || 'chk_ddf';
269: --

Line 274: nvl(hr_dei_shd.g_old_rec.dei_information_category, hr_api.g_varchar2) <>

270: begin
271: hr_utility.set_location('Entering:'||l_proc,10);
272: --
273: if ((p_rec.document_extra_info_id is not null) and (
274: nvl(hr_dei_shd.g_old_rec.dei_information_category, hr_api.g_varchar2) <>
275: nvl(p_rec.dei_information_category, hr_api.g_varchar2) or
276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>

Line 276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>

272: --
273: if ((p_rec.document_extra_info_id is not null) and (
274: nvl(hr_dei_shd.g_old_rec.dei_information_category, hr_api.g_varchar2) <>
275: nvl(p_rec.dei_information_category, hr_api.g_varchar2) or
276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>

Line 278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>

274: nvl(hr_dei_shd.g_old_rec.dei_information_category, hr_api.g_varchar2) <>
275: nvl(p_rec.dei_information_category, hr_api.g_varchar2) or
276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>

Line 280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>

276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>

Line 282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>

278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>

Line 284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>

280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>

Line 286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>

282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>

Line 288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>

284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>

Line 290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>

286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>

Line 292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>

288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>

Line 294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>

290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>

Line 296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>

292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>

Line 298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>

294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>

Line 300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>

296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>

Line 302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>

298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>

Line 304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>

300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>

Line 306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>

302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>

Line 308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>

304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>

Line 310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>

306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>

Line 312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>

308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>

Line 314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>

310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>

Line 316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>

312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>

Line 318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>

314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>

Line 320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>

316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>

Line 322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>

318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>

Line 324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>

320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>

Line 326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>

322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>

Line 328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>

324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>

Line 330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>

326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>
333: nvl(p_rec.dei_information29, hr_api.g_varchar2) or
334: nvl(hr_dei_shd.g_old_rec.dei_information30, hr_api.g_varchar2) <>

Line 332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>

328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>
333: nvl(p_rec.dei_information29, hr_api.g_varchar2) or
334: nvl(hr_dei_shd.g_old_rec.dei_information30, hr_api.g_varchar2) <>
335: nvl(p_rec.dei_information30, hr_api.g_varchar2) ))
336: or (p_rec.document_extra_info_id is null) then

Line 334: nvl(hr_dei_shd.g_old_rec.dei_information30, hr_api.g_varchar2) <>

330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>
333: nvl(p_rec.dei_information29, hr_api.g_varchar2) or
334: nvl(hr_dei_shd.g_old_rec.dei_information30, hr_api.g_varchar2) <>
335: nvl(p_rec.dei_information30, hr_api.g_varchar2) ))
336: or (p_rec.document_extra_info_id is null) then
337: --
338: -- Only execute the validation if absolutely necessary:

Line 443: (p_rec in hr_dei_shd.g_rec_type

439: -- Internal Row Handler Use Only.
440: --
441: -- ----------------------------------------------------------------------------
442: procedure chk_df
443: (p_rec in hr_dei_shd.g_rec_type
444: ) is
445: --
446: l_proc varchar2(72) := g_package || 'chk_df';
447: --

Line 452: nvl(hr_dei_shd.g_old_rec.dei_attribute_category, hr_api.g_varchar2) <>

448: begin
449: hr_utility.set_location('Entering:'||l_proc,10);
450: --
451: if ((p_rec.document_extra_info_id is not null) and (
452: nvl(hr_dei_shd.g_old_rec.dei_attribute_category, hr_api.g_varchar2) <>
453: nvl(p_rec.dei_attribute_category, hr_api.g_varchar2) or
454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>

Line 454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>

450: --
451: if ((p_rec.document_extra_info_id is not null) and (
452: nvl(hr_dei_shd.g_old_rec.dei_attribute_category, hr_api.g_varchar2) <>
453: nvl(p_rec.dei_attribute_category, hr_api.g_varchar2) or
454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>

Line 456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>

452: nvl(hr_dei_shd.g_old_rec.dei_attribute_category, hr_api.g_varchar2) <>
453: nvl(p_rec.dei_attribute_category, hr_api.g_varchar2) or
454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>

Line 458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>

454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>

Line 460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>

456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>

Line 462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>

458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>

Line 464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>

460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>

Line 466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>

462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>

Line 468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>

464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>

Line 470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>

466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>

Line 472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>

468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>

Line 474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>

470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>

Line 476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>

472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>

Line 478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>

474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>

Line 480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>

476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>

Line 482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>

478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>

Line 484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>

480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>

Line 486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>

482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>

Line 488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>

484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>

Line 490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>

486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>

Line 492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>

488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>

Line 494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>

490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>

Line 496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>

492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>

Line 498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>

494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>

Line 500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>

496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>

Line 502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>

498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>

Line 504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>

500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>

Line 506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>

502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>

Line 508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>

504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>
511: nvl(p_rec.dei_attribute29, hr_api.g_varchar2) or
512: nvl(hr_dei_shd.g_old_rec.dei_attribute30, hr_api.g_varchar2) <>

Line 510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>

506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>
511: nvl(p_rec.dei_attribute29, hr_api.g_varchar2) or
512: nvl(hr_dei_shd.g_old_rec.dei_attribute30, hr_api.g_varchar2) <>
513: nvl(p_rec.dei_attribute30, hr_api.g_varchar2) ))
514: or (p_rec.document_extra_info_id is null) then

Line 512: nvl(hr_dei_shd.g_old_rec.dei_attribute30, hr_api.g_varchar2) <>

508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>
511: nvl(p_rec.dei_attribute29, hr_api.g_varchar2) or
512: nvl(hr_dei_shd.g_old_rec.dei_attribute30, hr_api.g_varchar2) <>
513: nvl(p_rec.dei_attribute30, hr_api.g_varchar2) ))
514: or (p_rec.document_extra_info_id is null) then
515: --
516: -- Only execute the validation if absolutely necessary:

Line 619: (p_rec in hr_dei_shd.g_rec_type

615: --
616: -- {End Of Comments}
617: -- ----------------------------------------------------------------------------
618: Procedure chk_non_updateable_args
619: (p_rec in hr_dei_shd.g_rec_type
620: ) IS
621: --
622: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
623: --

Line 629: IF NOT hr_dei_shd.api_updating

625: --
626: -- Only proceed with the validation if a row exists for the current
627: -- record in the HR Schema.
628: --
629: IF NOT hr_dei_shd.api_updating
630: (p_document_extra_info_id => p_rec.document_extra_info_id
631: ,p_object_version_number => p_rec.object_version_number
632: ) THEN
633: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 644: hr_dei_shd.g_old_rec.person_id then

640: --Check for Non- updation of person_id
641: --
642: --
643: if nvl(p_rec.person_id, hr_api.g_number) <>
644: hr_dei_shd.g_old_rec.person_id then
645:
646: hr_api.argument_changed_error
647: (p_api_name => l_proc
648: ,p_argument => 'PERSON_ID'

Line 649: ,p_base_table => hr_dei_shd.g_tab_nam

645:
646: hr_api.argument_changed_error
647: (p_api_name => l_proc
648: ,p_argument => 'PERSON_ID'
649: ,p_base_table => hr_dei_shd.g_tab_nam
650: );
651:
652: end if;
653:

Line 658: hr_dei_shd.g_old_rec.document_type_id then

654: --Check for Non- updation of DOCUMENT_TYPE_ID
655: --
656: --
657: if nvl(p_rec.document_type_id, hr_api.g_number) <>
658: hr_dei_shd.g_old_rec.document_type_id then
659:
660: hr_api.argument_changed_error
661: (p_api_name => l_proc
662: ,p_argument => 'DOCUMENT_TYPE_ID'

Line 663: ,p_base_table => hr_dei_shd.g_tab_nam

659:
660: hr_api.argument_changed_error
661: (p_api_name => l_proc
662: ,p_argument => 'DOCUMENT_TYPE_ID'
663: ,p_base_table => hr_dei_shd.g_tab_nam
664: );
665:
666: end if;
667: --

Line 673: hr_dei_shd.g_old_rec.document_extra_info_id then

669: --
670: --
671: hr_utility.set_location(l_proc, 8);
672: if nvl(p_rec.document_extra_info_id, hr_api.g_number) <>
673: hr_dei_shd.g_old_rec.document_extra_info_id then
674: hr_api.argument_changed_error
675: (p_api_name => l_proc
676: ,p_argument => 'DOCUMENT_EXTRA_INFO_ID'
677: ,p_base_table => hr_dei_shd.g_tab_nam

Line 677: ,p_base_table => hr_dei_shd.g_tab_nam

673: hr_dei_shd.g_old_rec.document_extra_info_id then
674: hr_api.argument_changed_error
675: (p_api_name => l_proc
676: ,p_argument => 'DOCUMENT_EXTRA_INFO_ID'
677: ,p_base_table => hr_dei_shd.g_tab_nam
678: );
679: end if;
680: --
681: End chk_non_updateable_args;

Line 1037: (p_rec in hr_dei_shd.g_rec_type

1033: -- ----------------------------------------------------------------------------
1034: -- |---------------------------< insert_validate >----------------------------|
1035: -- ----------------------------------------------------------------------------
1036: Procedure insert_validate
1037: (p_rec in hr_dei_shd.g_rec_type
1038: ) is
1039: --
1040: l_proc varchar2(72) := g_package||'insert_validate';
1041: --

Line 1095: (p_rec in hr_dei_shd.g_rec_type

1091: -- ----------------------------------------------------------------------------
1092: -- |---------------------------< update_validate >----------------------------|
1093: -- ----------------------------------------------------------------------------
1094: Procedure update_validate
1095: (p_rec in hr_dei_shd.g_rec_type
1096: ) is
1097: --
1098: l_proc varchar2(72) := g_package||'update_validate';
1099: --

Line 1144: (p_rec in hr_dei_shd.g_rec_type

1140: -- ----------------------------------------------------------------------------
1141: -- |---------------------------< delete_validate >----------------------------|
1142: -- ----------------------------------------------------------------------------
1143: Procedure delete_validate
1144: (p_rec in hr_dei_shd.g_rec_type
1145: ) is
1146: --
1147: l_proc varchar2(72) := g_package||'delete_validate';
1148: --