APPS.PAY_AIF_BUS dependencies on PAY_AIF_SHD

Line 335: (p_rec in pay_aif_shd.g_rec_type

331: -- Internal Row Handler Use Only.
332: --
333: -- ----------------------------------------------------------------------------
334: procedure chk_ddf
335: (p_rec in pay_aif_shd.g_rec_type
336: ) is
337: --
338: l_proc varchar2(72) := g_package || 'chk_ddf';
339: --

Line 344: nvl(pay_aif_shd.g_old_rec.action_information_id, hr_api.g_number) <>

340: begin
341: hr_utility.set_location('Entering:'||l_proc,10);
342: --
343: if ((p_rec.action_information_id is not null) and (
344: nvl(pay_aif_shd.g_old_rec.action_information_id, hr_api.g_number) <>
345: nvl(p_rec.action_information_id, hr_api.g_number) or
346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>

Line 346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>

342: --
343: if ((p_rec.action_information_id is not null) and (
344: nvl(pay_aif_shd.g_old_rec.action_information_id, hr_api.g_number) <>
345: nvl(p_rec.action_information_id, hr_api.g_number) or
346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>

Line 348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>

344: nvl(pay_aif_shd.g_old_rec.action_information_id, hr_api.g_number) <>
345: nvl(p_rec.action_information_id, hr_api.g_number) or
346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>

Line 350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>

346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>

Line 352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>

348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>

Line 354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>

350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>

Line 356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>

352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>

Line 358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>

354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>

Line 360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>

356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>

Line 362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>

358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>

Line 364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>

360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>

Line 366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>

362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>

Line 368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>

364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>

Line 370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>

366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>

Line 372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>

368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>

Line 374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>

370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>

Line 376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>

372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>

Line 378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>

374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>

Line 380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>

376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>

Line 382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>

378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>

Line 384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>

380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>

Line 386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>

382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>

Line 388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>

384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>

Line 390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>

386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>

Line 392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>

388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>

Line 394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>

390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>

Line 396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>

392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>

Line 398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>

394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>

Line 400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>

396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>

Line 402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>

398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>

Line 404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>

400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>

Line 406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>

402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>
409: nvl(p_rec.action_information29, hr_api.g_varchar2) or
410: nvl(pay_aif_shd.g_old_rec.action_information30, hr_api.g_varchar2) <>

Line 408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>

404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>
409: nvl(p_rec.action_information29, hr_api.g_varchar2) or
410: nvl(pay_aif_shd.g_old_rec.action_information30, hr_api.g_varchar2) <>
411: nvl(p_rec.action_information30, hr_api.g_varchar2) ))
412: or (p_rec.action_information_id is null) then

Line 410: nvl(pay_aif_shd.g_old_rec.action_information30, hr_api.g_varchar2) <>

406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>
409: nvl(p_rec.action_information29, hr_api.g_varchar2) or
410: nvl(pay_aif_shd.g_old_rec.action_information30, hr_api.g_varchar2) <>
411: nvl(p_rec.action_information30, hr_api.g_varchar2) ))
412: or (p_rec.action_information_id is null) then
413: --
414: -- Only execute the validation if absolutely necessary:

Line 706: (p_rec in pay_aif_shd.g_rec_type

702: --
703: -- {End Of Comments}
704: -- ----------------------------------------------------------------------------
705: Procedure chk_non_updateable_args
706: (p_rec in pay_aif_shd.g_rec_type
707: ) IS
708: --
709: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
710: l_error EXCEPTION;

Line 718: IF NOT pay_aif_shd.api_updating

714: --
715: -- Only proceed with the validation if a row exists for the current
716: -- record in the HR Schema.
717: --
718: IF NOT pay_aif_shd.api_updating
719: (p_action_information_id => p_rec.action_information_id
720: ,p_object_version_number => p_rec.object_version_number
721: ) THEN
722: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 731: nvl(pay_aif_shd.g_old_rec.action_context_id,hr_api.g_number) then

727: --
728: -- action_context_id
729: --
730: if nvl(p_rec.action_context_id,hr_api.g_number) <>
731: nvl(pay_aif_shd.g_old_rec.action_context_id,hr_api.g_number) then
732: --
733: l_argument := 'p_rec.action_context_id';
734: raise l_error;
735: --

Line 741: nvl(pay_aif_shd.g_old_rec.action_context_type,hr_api.g_varchar2) then

737: --
738: -- action_context_type
739: --
740: if nvl(p_rec.action_context_type,hr_api.g_varchar2) <>
741: nvl(pay_aif_shd.g_old_rec.action_context_type,hr_api.g_varchar2) then
742: --
743: l_argument := 'p_rec.action_context_type';
744: raise l_error;
745: --

Line 751: nvl(pay_aif_shd.g_old_rec.effective_date,hr_api.g_date) then

747: --
748: -- effective_date
749: --
750: if nvl(p_rec.effective_date,hr_api.g_date) <>
751: nvl(pay_aif_shd.g_old_rec.effective_date,hr_api.g_date) then
752: --
753: l_argument := 'p_rec.effective_date';
754: raise l_error;
755: --

Line 761: nvl(pay_aif_shd.g_old_rec.assignment_id,hr_api.g_number) then

757: --
758: -- assignment_id
759: --
760: if nvl(p_rec.assignment_id,hr_api.g_number) <>
761: nvl(pay_aif_shd.g_old_rec.assignment_id,hr_api.g_number) then
762: --
763: l_argument := 'p_rec.assignment_id';
764: raise l_error;
765: --

Line 771: nvl(pay_aif_shd.g_old_rec.action_information_category,hr_api.g_varchar2) then

767: --
768: -- action_information_category
769: --
770: if nvl(p_rec.action_information_category,hr_api.g_varchar2) <>
771: nvl(pay_aif_shd.g_old_rec.action_information_category,hr_api.g_varchar2) then
772: --
773: l_argument := 'p_rec.action_information_category';
774: raise l_error;
775: --

Line 781: nvl(pay_aif_shd.g_old_rec.tax_unit_id,hr_api.g_number) then

777: --
778: -- tax_unit_id
779: --
780: if nvl(p_rec.tax_unit_id,hr_api.g_number) <>
781: nvl(pay_aif_shd.g_old_rec.tax_unit_id,hr_api.g_number) then
782: --
783: l_argument := 'p_rec.tax_unit_id';
784: raise l_error;
785: --

Line 791: nvl(pay_aif_shd.g_old_rec.jurisdiction_code,hr_api.g_varchar2) then

787: --
788: -- jurisdiction_code
789: --
790: if nvl(p_rec.jurisdiction_code,hr_api.g_varchar2) <>
791: nvl(pay_aif_shd.g_old_rec.jurisdiction_code,hr_api.g_varchar2) then
792: --
793: l_argument := 'p_rec.jurisdiction_code';
794: raise l_error;
795: --

Line 801: nvl(pay_aif_shd.g_old_rec.source_id,hr_api.g_number) then

797: --
798: -- source_id
799: --
800: if nvl(p_rec.source_id,hr_api.g_number) <>
801: nvl(pay_aif_shd.g_old_rec.source_id,hr_api.g_number) then
802: --
803: l_argument := 'p_rec.source_id';
804: raise l_error;
805: --

Line 811: nvl(pay_aif_shd.g_old_rec.source_text,hr_api.g_varchar2) then

807: --
808: -- source_text
809: --
810: if nvl(p_rec.source_text,hr_api.g_varchar2) <>
811: nvl(pay_aif_shd.g_old_rec.source_text,hr_api.g_varchar2) then
812: --
813: l_argument := 'p_rec.source_text';
814: raise l_error;
815: --

Line 821: nvl(pay_aif_shd.g_old_rec.tax_group,hr_api.g_varchar2) then

817: --
818: -- tax_group
819: --
820: if nvl(p_rec.tax_group,hr_api.g_varchar2) <>
821: nvl(pay_aif_shd.g_old_rec.tax_group,hr_api.g_varchar2) then
822: --
823: l_argument := 'p_rec.tax_group';
824: raise l_error;
825: --

Line 841: (p_rec in pay_aif_shd.g_rec_type

837: -- ----------------------------------------------------------------------------
838: -- |---------------------------< insert_validate >----------------------------|
839: -- ----------------------------------------------------------------------------
840: Procedure insert_validate
841: (p_rec in pay_aif_shd.g_rec_type
842: ) is
843: --
844: l_proc varchar2(72) := g_package||'insert_validate';
845: --

Line 870: (p_rec in pay_aif_shd.g_rec_type

866: -- ----------------------------------------------------------------------------
867: -- |---------------------------< update_validate >----------------------------|
868: -- ----------------------------------------------------------------------------
869: Procedure update_validate
870: (p_rec in pay_aif_shd.g_rec_type
871: ) is
872: --
873: l_proc varchar2(72) := g_package||'update_validate';
874: --

Line 893: (p_rec in pay_aif_shd.g_rec_type

889: -- ----------------------------------------------------------------------------
890: -- |---------------------------< delete_validate >----------------------------|
891: -- ----------------------------------------------------------------------------
892: Procedure delete_validate
893: (p_rec in pay_aif_shd.g_rec_type
894: ) is
895: --
896: l_proc varchar2(72) := g_package||'delete_validate';
897: --