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 702: (p_rec in pay_aif_shd.g_rec_type

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

Line 714: IF NOT pay_aif_shd.api_updating

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

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

723: --
724: -- action_context_id
725: --
726: if nvl(p_rec.action_context_id,hr_api.g_number) <>
727: nvl(pay_aif_shd.g_old_rec.action_context_id,hr_api.g_number) then
728: --
729: l_argument := 'p_rec.action_context_id';
730: raise l_error;
731: --

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

733: --
734: -- action_context_type
735: --
736: if nvl(p_rec.action_context_type,hr_api.g_varchar2) <>
737: nvl(pay_aif_shd.g_old_rec.action_context_type,hr_api.g_varchar2) then
738: --
739: l_argument := 'p_rec.action_context_type';
740: raise l_error;
741: --

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

743: --
744: -- effective_date
745: --
746: if nvl(p_rec.effective_date,hr_api.g_date) <>
747: nvl(pay_aif_shd.g_old_rec.effective_date,hr_api.g_date) then
748: --
749: l_argument := 'p_rec.effective_date';
750: raise l_error;
751: --

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

753: --
754: -- assignment_id
755: --
756: if nvl(p_rec.assignment_id,hr_api.g_number) <>
757: nvl(pay_aif_shd.g_old_rec.assignment_id,hr_api.g_number) then
758: --
759: l_argument := 'p_rec.assignment_id';
760: raise l_error;
761: --

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

763: --
764: -- action_information_category
765: --
766: if nvl(p_rec.action_information_category,hr_api.g_varchar2) <>
767: nvl(pay_aif_shd.g_old_rec.action_information_category,hr_api.g_varchar2) then
768: --
769: l_argument := 'p_rec.action_information_category';
770: raise l_error;
771: --

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

773: --
774: -- tax_unit_id
775: --
776: if nvl(p_rec.tax_unit_id,hr_api.g_number) <>
777: nvl(pay_aif_shd.g_old_rec.tax_unit_id,hr_api.g_number) then
778: --
779: l_argument := 'p_rec.tax_unit_id';
780: raise l_error;
781: --

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

783: --
784: -- jurisdiction_code
785: --
786: if nvl(p_rec.jurisdiction_code,hr_api.g_varchar2) <>
787: nvl(pay_aif_shd.g_old_rec.jurisdiction_code,hr_api.g_varchar2) then
788: --
789: l_argument := 'p_rec.jurisdiction_code';
790: raise l_error;
791: --

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

793: --
794: -- source_id
795: --
796: if nvl(p_rec.source_id,hr_api.g_number) <>
797: nvl(pay_aif_shd.g_old_rec.source_id,hr_api.g_number) then
798: --
799: l_argument := 'p_rec.source_id';
800: raise l_error;
801: --

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

803: --
804: -- source_text
805: --
806: if nvl(p_rec.source_text,hr_api.g_varchar2) <>
807: nvl(pay_aif_shd.g_old_rec.source_text,hr_api.g_varchar2) then
808: --
809: l_argument := 'p_rec.source_text';
810: raise l_error;
811: --

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

813: --
814: -- tax_group
815: --
816: if nvl(p_rec.tax_group,hr_api.g_varchar2) <>
817: nvl(pay_aif_shd.g_old_rec.tax_group,hr_api.g_varchar2) then
818: --
819: l_argument := 'p_rec.tax_group';
820: raise l_error;
821: --

Line 837: (p_rec in pay_aif_shd.g_rec_type

833: -- ----------------------------------------------------------------------------
834: -- |---------------------------< insert_validate >----------------------------|
835: -- ----------------------------------------------------------------------------
836: Procedure insert_validate
837: (p_rec in pay_aif_shd.g_rec_type
838: ) is
839: --
840: l_proc varchar2(72) := g_package||'insert_validate';
841: --

Line 866: (p_rec in pay_aif_shd.g_rec_type

862: -- ----------------------------------------------------------------------------
863: -- |---------------------------< update_validate >----------------------------|
864: -- ----------------------------------------------------------------------------
865: Procedure update_validate
866: (p_rec in pay_aif_shd.g_rec_type
867: ) is
868: --
869: l_proc varchar2(72) := g_package||'update_validate';
870: --

Line 889: (p_rec in pay_aif_shd.g_rec_type

885: -- ----------------------------------------------------------------------------
886: -- |---------------------------< delete_validate >----------------------------|
887: -- ----------------------------------------------------------------------------
888: Procedure delete_validate
889: (p_rec in pay_aif_shd.g_rec_type
890: ) is
891: --
892: l_proc varchar2(72) := g_package||'delete_validate';
893: --