APPS.PER_ELC_BUS dependencies on PER_ELC_SHD

Line 87: l_api_updating := per_elc_shd.api_updating

83: hr_utility.set_location(l_proc, 20);
84: --
85: -- Check if inserting or updating with modified values
86: --
87: l_api_updating := per_elc_shd.api_updating
88: (p_election_id => p_election_id
89: ,p_object_version_number => p_object_version_number
90: );
91: --

Line 93: if ((l_api_updating and per_elc_shd.g_old_rec.rep_body_id <> p_rep_body_id)

89: ,p_object_version_number => p_object_version_number
90: );
91: --
92: --
93: if ((l_api_updating and per_elc_shd.g_old_rec.rep_body_id <> p_rep_body_id)
94: or
95: (NOT l_api_updating))
96: then
97: hr_utility.set_location(l_proc, 30);

Line 167: l_api_updating := per_elc_shd.api_updating

163: hr_utility.set_location(l_proc, 20);
164: --
165: -- Check if inserting or updating with modified values
166: --
167: l_api_updating := per_elc_shd.api_updating
168: (p_election_id => p_election_id
169: ,p_object_version_number => p_object_version_number
170: );
171: --

Line 173: -- if ((l_api_updating and per_elc_shd.g_old_rec.election_id <> p_election_id)

169: ,p_object_version_number => p_object_version_number
170: );
171: --
172: --
173: -- if ((l_api_updating and per_elc_shd.g_old_rec.election_id <> p_election_id)
174: -- or
175: -- (NOT l_api_updating))
176: -- then
177: hr_utility.set_location(l_proc, 30);

Line 267: l_api_updating := per_elc_shd.api_updating

263: hr_utility.set_location(l_proc, 20);
264: --
265: -- Check if inserting or updating with modified values
266: --
267: l_api_updating := per_elc_shd.api_updating
268: (p_election_id => p_election_id
269: ,p_object_version_number => p_object_version_number
270: );
271: --

Line 272: if ((l_api_updating and per_elc_shd.g_old_rec.election_date <> p_election_date)

268: (p_election_id => p_election_id
269: ,p_object_version_number => p_object_version_number
270: );
271: --
272: if ((l_api_updating and per_elc_shd.g_old_rec.election_date <> p_election_date)
273: or
274: (NOT l_api_updating))
275: then
276: hr_utility.set_location(l_proc, 30);

Line 454: (p_rec in per_elc_shd.g_rec_type

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

Line 463: nvl(per_elc_shd.g_old_rec.election_info_category, hr_api.g_varchar2) <>

459: begin
460: hr_utility.set_location('Entering:'||l_proc,10);
461: --
462: if ((p_rec.election_id is not null) and (
463: nvl(per_elc_shd.g_old_rec.election_info_category, hr_api.g_varchar2) <>
464: nvl(p_rec.election_info_category, hr_api.g_varchar2) or
465: nvl(per_elc_shd.g_old_rec.election_information1, hr_api.g_varchar2) <>
466: nvl(p_rec.election_information1, hr_api.g_varchar2) or
467: nvl(per_elc_shd.g_old_rec.election_information2, hr_api.g_varchar2) <>

Line 465: nvl(per_elc_shd.g_old_rec.election_information1, hr_api.g_varchar2) <>

461: --
462: if ((p_rec.election_id is not null) and (
463: nvl(per_elc_shd.g_old_rec.election_info_category, hr_api.g_varchar2) <>
464: nvl(p_rec.election_info_category, hr_api.g_varchar2) or
465: nvl(per_elc_shd.g_old_rec.election_information1, hr_api.g_varchar2) <>
466: nvl(p_rec.election_information1, hr_api.g_varchar2) or
467: nvl(per_elc_shd.g_old_rec.election_information2, hr_api.g_varchar2) <>
468: nvl(p_rec.election_information2, hr_api.g_varchar2) or
469: nvl(per_elc_shd.g_old_rec.election_information3, hr_api.g_varchar2) <>

Line 467: nvl(per_elc_shd.g_old_rec.election_information2, hr_api.g_varchar2) <>

463: nvl(per_elc_shd.g_old_rec.election_info_category, hr_api.g_varchar2) <>
464: nvl(p_rec.election_info_category, hr_api.g_varchar2) or
465: nvl(per_elc_shd.g_old_rec.election_information1, hr_api.g_varchar2) <>
466: nvl(p_rec.election_information1, hr_api.g_varchar2) or
467: nvl(per_elc_shd.g_old_rec.election_information2, hr_api.g_varchar2) <>
468: nvl(p_rec.election_information2, hr_api.g_varchar2) or
469: nvl(per_elc_shd.g_old_rec.election_information3, hr_api.g_varchar2) <>
470: nvl(p_rec.election_information3, hr_api.g_varchar2) or
471: nvl(per_elc_shd.g_old_rec.election_information4, hr_api.g_varchar2) <>

Line 469: nvl(per_elc_shd.g_old_rec.election_information3, hr_api.g_varchar2) <>

465: nvl(per_elc_shd.g_old_rec.election_information1, hr_api.g_varchar2) <>
466: nvl(p_rec.election_information1, hr_api.g_varchar2) or
467: nvl(per_elc_shd.g_old_rec.election_information2, hr_api.g_varchar2) <>
468: nvl(p_rec.election_information2, hr_api.g_varchar2) or
469: nvl(per_elc_shd.g_old_rec.election_information3, hr_api.g_varchar2) <>
470: nvl(p_rec.election_information3, hr_api.g_varchar2) or
471: nvl(per_elc_shd.g_old_rec.election_information4, hr_api.g_varchar2) <>
472: nvl(p_rec.election_information4, hr_api.g_varchar2) or
473: nvl(per_elc_shd.g_old_rec.election_information5, hr_api.g_varchar2) <>

Line 471: nvl(per_elc_shd.g_old_rec.election_information4, hr_api.g_varchar2) <>

467: nvl(per_elc_shd.g_old_rec.election_information2, hr_api.g_varchar2) <>
468: nvl(p_rec.election_information2, hr_api.g_varchar2) or
469: nvl(per_elc_shd.g_old_rec.election_information3, hr_api.g_varchar2) <>
470: nvl(p_rec.election_information3, hr_api.g_varchar2) or
471: nvl(per_elc_shd.g_old_rec.election_information4, hr_api.g_varchar2) <>
472: nvl(p_rec.election_information4, hr_api.g_varchar2) or
473: nvl(per_elc_shd.g_old_rec.election_information5, hr_api.g_varchar2) <>
474: nvl(p_rec.election_information5, hr_api.g_varchar2) or
475: nvl(per_elc_shd.g_old_rec.election_information6, hr_api.g_varchar2) <>

Line 473: nvl(per_elc_shd.g_old_rec.election_information5, hr_api.g_varchar2) <>

469: nvl(per_elc_shd.g_old_rec.election_information3, hr_api.g_varchar2) <>
470: nvl(p_rec.election_information3, hr_api.g_varchar2) or
471: nvl(per_elc_shd.g_old_rec.election_information4, hr_api.g_varchar2) <>
472: nvl(p_rec.election_information4, hr_api.g_varchar2) or
473: nvl(per_elc_shd.g_old_rec.election_information5, hr_api.g_varchar2) <>
474: nvl(p_rec.election_information5, hr_api.g_varchar2) or
475: nvl(per_elc_shd.g_old_rec.election_information6, hr_api.g_varchar2) <>
476: nvl(p_rec.election_information6, hr_api.g_varchar2) or
477: nvl(per_elc_shd.g_old_rec.election_information7, hr_api.g_varchar2) <>

Line 475: nvl(per_elc_shd.g_old_rec.election_information6, hr_api.g_varchar2) <>

471: nvl(per_elc_shd.g_old_rec.election_information4, hr_api.g_varchar2) <>
472: nvl(p_rec.election_information4, hr_api.g_varchar2) or
473: nvl(per_elc_shd.g_old_rec.election_information5, hr_api.g_varchar2) <>
474: nvl(p_rec.election_information5, hr_api.g_varchar2) or
475: nvl(per_elc_shd.g_old_rec.election_information6, hr_api.g_varchar2) <>
476: nvl(p_rec.election_information6, hr_api.g_varchar2) or
477: nvl(per_elc_shd.g_old_rec.election_information7, hr_api.g_varchar2) <>
478: nvl(p_rec.election_information7, hr_api.g_varchar2) or
479: nvl(per_elc_shd.g_old_rec.election_information8, hr_api.g_varchar2) <>

Line 477: nvl(per_elc_shd.g_old_rec.election_information7, hr_api.g_varchar2) <>

473: nvl(per_elc_shd.g_old_rec.election_information5, hr_api.g_varchar2) <>
474: nvl(p_rec.election_information5, hr_api.g_varchar2) or
475: nvl(per_elc_shd.g_old_rec.election_information6, hr_api.g_varchar2) <>
476: nvl(p_rec.election_information6, hr_api.g_varchar2) or
477: nvl(per_elc_shd.g_old_rec.election_information7, hr_api.g_varchar2) <>
478: nvl(p_rec.election_information7, hr_api.g_varchar2) or
479: nvl(per_elc_shd.g_old_rec.election_information8, hr_api.g_varchar2) <>
480: nvl(p_rec.election_information8, hr_api.g_varchar2) or
481: nvl(per_elc_shd.g_old_rec.election_information9, hr_api.g_varchar2) <>

Line 479: nvl(per_elc_shd.g_old_rec.election_information8, hr_api.g_varchar2) <>

475: nvl(per_elc_shd.g_old_rec.election_information6, hr_api.g_varchar2) <>
476: nvl(p_rec.election_information6, hr_api.g_varchar2) or
477: nvl(per_elc_shd.g_old_rec.election_information7, hr_api.g_varchar2) <>
478: nvl(p_rec.election_information7, hr_api.g_varchar2) or
479: nvl(per_elc_shd.g_old_rec.election_information8, hr_api.g_varchar2) <>
480: nvl(p_rec.election_information8, hr_api.g_varchar2) or
481: nvl(per_elc_shd.g_old_rec.election_information9, hr_api.g_varchar2) <>
482: nvl(p_rec.election_information9, hr_api.g_varchar2) or
483: nvl(per_elc_shd.g_old_rec.election_information10, hr_api.g_varchar2) <>

Line 481: nvl(per_elc_shd.g_old_rec.election_information9, hr_api.g_varchar2) <>

477: nvl(per_elc_shd.g_old_rec.election_information7, hr_api.g_varchar2) <>
478: nvl(p_rec.election_information7, hr_api.g_varchar2) or
479: nvl(per_elc_shd.g_old_rec.election_information8, hr_api.g_varchar2) <>
480: nvl(p_rec.election_information8, hr_api.g_varchar2) or
481: nvl(per_elc_shd.g_old_rec.election_information9, hr_api.g_varchar2) <>
482: nvl(p_rec.election_information9, hr_api.g_varchar2) or
483: nvl(per_elc_shd.g_old_rec.election_information10, hr_api.g_varchar2) <>
484: nvl(p_rec.election_information10, hr_api.g_varchar2) or
485: nvl(per_elc_shd.g_old_rec.election_information11, hr_api.g_varchar2) <>

Line 483: nvl(per_elc_shd.g_old_rec.election_information10, hr_api.g_varchar2) <>

479: nvl(per_elc_shd.g_old_rec.election_information8, hr_api.g_varchar2) <>
480: nvl(p_rec.election_information8, hr_api.g_varchar2) or
481: nvl(per_elc_shd.g_old_rec.election_information9, hr_api.g_varchar2) <>
482: nvl(p_rec.election_information9, hr_api.g_varchar2) or
483: nvl(per_elc_shd.g_old_rec.election_information10, hr_api.g_varchar2) <>
484: nvl(p_rec.election_information10, hr_api.g_varchar2) or
485: nvl(per_elc_shd.g_old_rec.election_information11, hr_api.g_varchar2) <>
486: nvl(p_rec.election_information11, hr_api.g_varchar2) or
487: nvl(per_elc_shd.g_old_rec.election_information12, hr_api.g_varchar2) <>

Line 485: nvl(per_elc_shd.g_old_rec.election_information11, hr_api.g_varchar2) <>

481: nvl(per_elc_shd.g_old_rec.election_information9, hr_api.g_varchar2) <>
482: nvl(p_rec.election_information9, hr_api.g_varchar2) or
483: nvl(per_elc_shd.g_old_rec.election_information10, hr_api.g_varchar2) <>
484: nvl(p_rec.election_information10, hr_api.g_varchar2) or
485: nvl(per_elc_shd.g_old_rec.election_information11, hr_api.g_varchar2) <>
486: nvl(p_rec.election_information11, hr_api.g_varchar2) or
487: nvl(per_elc_shd.g_old_rec.election_information12, hr_api.g_varchar2) <>
488: nvl(p_rec.election_information12, hr_api.g_varchar2) or
489: nvl(per_elc_shd.g_old_rec.election_information13, hr_api.g_varchar2) <>

Line 487: nvl(per_elc_shd.g_old_rec.election_information12, hr_api.g_varchar2) <>

483: nvl(per_elc_shd.g_old_rec.election_information10, hr_api.g_varchar2) <>
484: nvl(p_rec.election_information10, hr_api.g_varchar2) or
485: nvl(per_elc_shd.g_old_rec.election_information11, hr_api.g_varchar2) <>
486: nvl(p_rec.election_information11, hr_api.g_varchar2) or
487: nvl(per_elc_shd.g_old_rec.election_information12, hr_api.g_varchar2) <>
488: nvl(p_rec.election_information12, hr_api.g_varchar2) or
489: nvl(per_elc_shd.g_old_rec.election_information13, hr_api.g_varchar2) <>
490: nvl(p_rec.election_information13, hr_api.g_varchar2) or
491: nvl(per_elc_shd.g_old_rec.election_information14, hr_api.g_varchar2) <>

Line 489: nvl(per_elc_shd.g_old_rec.election_information13, hr_api.g_varchar2) <>

485: nvl(per_elc_shd.g_old_rec.election_information11, hr_api.g_varchar2) <>
486: nvl(p_rec.election_information11, hr_api.g_varchar2) or
487: nvl(per_elc_shd.g_old_rec.election_information12, hr_api.g_varchar2) <>
488: nvl(p_rec.election_information12, hr_api.g_varchar2) or
489: nvl(per_elc_shd.g_old_rec.election_information13, hr_api.g_varchar2) <>
490: nvl(p_rec.election_information13, hr_api.g_varchar2) or
491: nvl(per_elc_shd.g_old_rec.election_information14, hr_api.g_varchar2) <>
492: nvl(p_rec.election_information14, hr_api.g_varchar2) or
493: nvl(per_elc_shd.g_old_rec.election_information15, hr_api.g_varchar2) <>

Line 491: nvl(per_elc_shd.g_old_rec.election_information14, hr_api.g_varchar2) <>

487: nvl(per_elc_shd.g_old_rec.election_information12, hr_api.g_varchar2) <>
488: nvl(p_rec.election_information12, hr_api.g_varchar2) or
489: nvl(per_elc_shd.g_old_rec.election_information13, hr_api.g_varchar2) <>
490: nvl(p_rec.election_information13, hr_api.g_varchar2) or
491: nvl(per_elc_shd.g_old_rec.election_information14, hr_api.g_varchar2) <>
492: nvl(p_rec.election_information14, hr_api.g_varchar2) or
493: nvl(per_elc_shd.g_old_rec.election_information15, hr_api.g_varchar2) <>
494: nvl(p_rec.election_information15, hr_api.g_varchar2) or
495: nvl(per_elc_shd.g_old_rec.election_information16, hr_api.g_varchar2) <>

Line 493: nvl(per_elc_shd.g_old_rec.election_information15, hr_api.g_varchar2) <>

489: nvl(per_elc_shd.g_old_rec.election_information13, hr_api.g_varchar2) <>
490: nvl(p_rec.election_information13, hr_api.g_varchar2) or
491: nvl(per_elc_shd.g_old_rec.election_information14, hr_api.g_varchar2) <>
492: nvl(p_rec.election_information14, hr_api.g_varchar2) or
493: nvl(per_elc_shd.g_old_rec.election_information15, hr_api.g_varchar2) <>
494: nvl(p_rec.election_information15, hr_api.g_varchar2) or
495: nvl(per_elc_shd.g_old_rec.election_information16, hr_api.g_varchar2) <>
496: nvl(p_rec.election_information16, hr_api.g_varchar2) or
497: nvl(per_elc_shd.g_old_rec.election_information17, hr_api.g_varchar2) <>

Line 495: nvl(per_elc_shd.g_old_rec.election_information16, hr_api.g_varchar2) <>

491: nvl(per_elc_shd.g_old_rec.election_information14, hr_api.g_varchar2) <>
492: nvl(p_rec.election_information14, hr_api.g_varchar2) or
493: nvl(per_elc_shd.g_old_rec.election_information15, hr_api.g_varchar2) <>
494: nvl(p_rec.election_information15, hr_api.g_varchar2) or
495: nvl(per_elc_shd.g_old_rec.election_information16, hr_api.g_varchar2) <>
496: nvl(p_rec.election_information16, hr_api.g_varchar2) or
497: nvl(per_elc_shd.g_old_rec.election_information17, hr_api.g_varchar2) <>
498: nvl(p_rec.election_information17, hr_api.g_varchar2) or
499: nvl(per_elc_shd.g_old_rec.election_information18, hr_api.g_varchar2) <>

Line 497: nvl(per_elc_shd.g_old_rec.election_information17, hr_api.g_varchar2) <>

493: nvl(per_elc_shd.g_old_rec.election_information15, hr_api.g_varchar2) <>
494: nvl(p_rec.election_information15, hr_api.g_varchar2) or
495: nvl(per_elc_shd.g_old_rec.election_information16, hr_api.g_varchar2) <>
496: nvl(p_rec.election_information16, hr_api.g_varchar2) or
497: nvl(per_elc_shd.g_old_rec.election_information17, hr_api.g_varchar2) <>
498: nvl(p_rec.election_information17, hr_api.g_varchar2) or
499: nvl(per_elc_shd.g_old_rec.election_information18, hr_api.g_varchar2) <>
500: nvl(p_rec.election_information18, hr_api.g_varchar2) or
501: nvl(per_elc_shd.g_old_rec.election_information19, hr_api.g_varchar2) <>

Line 499: nvl(per_elc_shd.g_old_rec.election_information18, hr_api.g_varchar2) <>

495: nvl(per_elc_shd.g_old_rec.election_information16, hr_api.g_varchar2) <>
496: nvl(p_rec.election_information16, hr_api.g_varchar2) or
497: nvl(per_elc_shd.g_old_rec.election_information17, hr_api.g_varchar2) <>
498: nvl(p_rec.election_information17, hr_api.g_varchar2) or
499: nvl(per_elc_shd.g_old_rec.election_information18, hr_api.g_varchar2) <>
500: nvl(p_rec.election_information18, hr_api.g_varchar2) or
501: nvl(per_elc_shd.g_old_rec.election_information19, hr_api.g_varchar2) <>
502: nvl(p_rec.election_information19, hr_api.g_varchar2) or
503: nvl(per_elc_shd.g_old_rec.election_information20, hr_api.g_varchar2) <>

Line 501: nvl(per_elc_shd.g_old_rec.election_information19, hr_api.g_varchar2) <>

497: nvl(per_elc_shd.g_old_rec.election_information17, hr_api.g_varchar2) <>
498: nvl(p_rec.election_information17, hr_api.g_varchar2) or
499: nvl(per_elc_shd.g_old_rec.election_information18, hr_api.g_varchar2) <>
500: nvl(p_rec.election_information18, hr_api.g_varchar2) or
501: nvl(per_elc_shd.g_old_rec.election_information19, hr_api.g_varchar2) <>
502: nvl(p_rec.election_information19, hr_api.g_varchar2) or
503: nvl(per_elc_shd.g_old_rec.election_information20, hr_api.g_varchar2) <>
504: nvl(p_rec.election_information20, hr_api.g_varchar2) or
505: nvl(per_elc_shd.g_old_rec.election_information21, hr_api.g_varchar2) <>

Line 503: nvl(per_elc_shd.g_old_rec.election_information20, hr_api.g_varchar2) <>

499: nvl(per_elc_shd.g_old_rec.election_information18, hr_api.g_varchar2) <>
500: nvl(p_rec.election_information18, hr_api.g_varchar2) or
501: nvl(per_elc_shd.g_old_rec.election_information19, hr_api.g_varchar2) <>
502: nvl(p_rec.election_information19, hr_api.g_varchar2) or
503: nvl(per_elc_shd.g_old_rec.election_information20, hr_api.g_varchar2) <>
504: nvl(p_rec.election_information20, hr_api.g_varchar2) or
505: nvl(per_elc_shd.g_old_rec.election_information21, hr_api.g_varchar2) <>
506: nvl(p_rec.election_information21, hr_api.g_varchar2) or
507: nvl(per_elc_shd.g_old_rec.election_information22, hr_api.g_varchar2) <>

Line 505: nvl(per_elc_shd.g_old_rec.election_information21, hr_api.g_varchar2) <>

501: nvl(per_elc_shd.g_old_rec.election_information19, hr_api.g_varchar2) <>
502: nvl(p_rec.election_information19, hr_api.g_varchar2) or
503: nvl(per_elc_shd.g_old_rec.election_information20, hr_api.g_varchar2) <>
504: nvl(p_rec.election_information20, hr_api.g_varchar2) or
505: nvl(per_elc_shd.g_old_rec.election_information21, hr_api.g_varchar2) <>
506: nvl(p_rec.election_information21, hr_api.g_varchar2) or
507: nvl(per_elc_shd.g_old_rec.election_information22, hr_api.g_varchar2) <>
508: nvl(p_rec.election_information22, hr_api.g_varchar2) or
509: nvl(per_elc_shd.g_old_rec.election_information23, hr_api.g_varchar2) <>

Line 507: nvl(per_elc_shd.g_old_rec.election_information22, hr_api.g_varchar2) <>

503: nvl(per_elc_shd.g_old_rec.election_information20, hr_api.g_varchar2) <>
504: nvl(p_rec.election_information20, hr_api.g_varchar2) or
505: nvl(per_elc_shd.g_old_rec.election_information21, hr_api.g_varchar2) <>
506: nvl(p_rec.election_information21, hr_api.g_varchar2) or
507: nvl(per_elc_shd.g_old_rec.election_information22, hr_api.g_varchar2) <>
508: nvl(p_rec.election_information22, hr_api.g_varchar2) or
509: nvl(per_elc_shd.g_old_rec.election_information23, hr_api.g_varchar2) <>
510: nvl(p_rec.election_information23, hr_api.g_varchar2) or
511: nvl(per_elc_shd.g_old_rec.election_information24, hr_api.g_varchar2) <>

Line 509: nvl(per_elc_shd.g_old_rec.election_information23, hr_api.g_varchar2) <>

505: nvl(per_elc_shd.g_old_rec.election_information21, hr_api.g_varchar2) <>
506: nvl(p_rec.election_information21, hr_api.g_varchar2) or
507: nvl(per_elc_shd.g_old_rec.election_information22, hr_api.g_varchar2) <>
508: nvl(p_rec.election_information22, hr_api.g_varchar2) or
509: nvl(per_elc_shd.g_old_rec.election_information23, hr_api.g_varchar2) <>
510: nvl(p_rec.election_information23, hr_api.g_varchar2) or
511: nvl(per_elc_shd.g_old_rec.election_information24, hr_api.g_varchar2) <>
512: nvl(p_rec.election_information24, hr_api.g_varchar2) or
513: nvl(per_elc_shd.g_old_rec.election_information25, hr_api.g_varchar2) <>

Line 511: nvl(per_elc_shd.g_old_rec.election_information24, hr_api.g_varchar2) <>

507: nvl(per_elc_shd.g_old_rec.election_information22, hr_api.g_varchar2) <>
508: nvl(p_rec.election_information22, hr_api.g_varchar2) or
509: nvl(per_elc_shd.g_old_rec.election_information23, hr_api.g_varchar2) <>
510: nvl(p_rec.election_information23, hr_api.g_varchar2) or
511: nvl(per_elc_shd.g_old_rec.election_information24, hr_api.g_varchar2) <>
512: nvl(p_rec.election_information24, hr_api.g_varchar2) or
513: nvl(per_elc_shd.g_old_rec.election_information25, hr_api.g_varchar2) <>
514: nvl(p_rec.election_information25, hr_api.g_varchar2) or
515: nvl(per_elc_shd.g_old_rec.election_information26, hr_api.g_varchar2) <>

Line 513: nvl(per_elc_shd.g_old_rec.election_information25, hr_api.g_varchar2) <>

509: nvl(per_elc_shd.g_old_rec.election_information23, hr_api.g_varchar2) <>
510: nvl(p_rec.election_information23, hr_api.g_varchar2) or
511: nvl(per_elc_shd.g_old_rec.election_information24, hr_api.g_varchar2) <>
512: nvl(p_rec.election_information24, hr_api.g_varchar2) or
513: nvl(per_elc_shd.g_old_rec.election_information25, hr_api.g_varchar2) <>
514: nvl(p_rec.election_information25, hr_api.g_varchar2) or
515: nvl(per_elc_shd.g_old_rec.election_information26, hr_api.g_varchar2) <>
516: nvl(p_rec.election_information26, hr_api.g_varchar2) or
517: nvl(per_elc_shd.g_old_rec.election_information27, hr_api.g_varchar2) <>

Line 515: nvl(per_elc_shd.g_old_rec.election_information26, hr_api.g_varchar2) <>

511: nvl(per_elc_shd.g_old_rec.election_information24, hr_api.g_varchar2) <>
512: nvl(p_rec.election_information24, hr_api.g_varchar2) or
513: nvl(per_elc_shd.g_old_rec.election_information25, hr_api.g_varchar2) <>
514: nvl(p_rec.election_information25, hr_api.g_varchar2) or
515: nvl(per_elc_shd.g_old_rec.election_information26, hr_api.g_varchar2) <>
516: nvl(p_rec.election_information26, hr_api.g_varchar2) or
517: nvl(per_elc_shd.g_old_rec.election_information27, hr_api.g_varchar2) <>
518: nvl(p_rec.election_information27, hr_api.g_varchar2) or
519: nvl(per_elc_shd.g_old_rec.election_information28, hr_api.g_varchar2) <>

Line 517: nvl(per_elc_shd.g_old_rec.election_information27, hr_api.g_varchar2) <>

513: nvl(per_elc_shd.g_old_rec.election_information25, hr_api.g_varchar2) <>
514: nvl(p_rec.election_information25, hr_api.g_varchar2) or
515: nvl(per_elc_shd.g_old_rec.election_information26, hr_api.g_varchar2) <>
516: nvl(p_rec.election_information26, hr_api.g_varchar2) or
517: nvl(per_elc_shd.g_old_rec.election_information27, hr_api.g_varchar2) <>
518: nvl(p_rec.election_information27, hr_api.g_varchar2) or
519: nvl(per_elc_shd.g_old_rec.election_information28, hr_api.g_varchar2) <>
520: nvl(p_rec.election_information28, hr_api.g_varchar2) or
521: nvl(per_elc_shd.g_old_rec.election_information29, hr_api.g_varchar2) <>

Line 519: nvl(per_elc_shd.g_old_rec.election_information28, hr_api.g_varchar2) <>

515: nvl(per_elc_shd.g_old_rec.election_information26, hr_api.g_varchar2) <>
516: nvl(p_rec.election_information26, hr_api.g_varchar2) or
517: nvl(per_elc_shd.g_old_rec.election_information27, hr_api.g_varchar2) <>
518: nvl(p_rec.election_information27, hr_api.g_varchar2) or
519: nvl(per_elc_shd.g_old_rec.election_information28, hr_api.g_varchar2) <>
520: nvl(p_rec.election_information28, hr_api.g_varchar2) or
521: nvl(per_elc_shd.g_old_rec.election_information29, hr_api.g_varchar2) <>
522: nvl(p_rec.election_information29, hr_api.g_varchar2) or
523: nvl(per_elc_shd.g_old_rec.election_information30, hr_api.g_varchar2) <>

Line 521: nvl(per_elc_shd.g_old_rec.election_information29, hr_api.g_varchar2) <>

517: nvl(per_elc_shd.g_old_rec.election_information27, hr_api.g_varchar2) <>
518: nvl(p_rec.election_information27, hr_api.g_varchar2) or
519: nvl(per_elc_shd.g_old_rec.election_information28, hr_api.g_varchar2) <>
520: nvl(p_rec.election_information28, hr_api.g_varchar2) or
521: nvl(per_elc_shd.g_old_rec.election_information29, hr_api.g_varchar2) <>
522: nvl(p_rec.election_information29, hr_api.g_varchar2) or
523: nvl(per_elc_shd.g_old_rec.election_information30, hr_api.g_varchar2) <>
524: nvl(p_rec.election_information30, hr_api.g_varchar2) ))
525: or (p_rec.election_id is null) then

Line 523: nvl(per_elc_shd.g_old_rec.election_information30, hr_api.g_varchar2) <>

519: nvl(per_elc_shd.g_old_rec.election_information28, hr_api.g_varchar2) <>
520: nvl(p_rec.election_information28, hr_api.g_varchar2) or
521: nvl(per_elc_shd.g_old_rec.election_information29, hr_api.g_varchar2) <>
522: nvl(p_rec.election_information29, hr_api.g_varchar2) or
523: nvl(per_elc_shd.g_old_rec.election_information30, hr_api.g_varchar2) <>
524: nvl(p_rec.election_information30, hr_api.g_varchar2) ))
525: or (p_rec.election_id is null) then
526: --
527: -- Only execute the validation if absolutely necessary:

Line 631: (p_rec in per_elc_shd.g_rec_type

627: -- Internal Row Handler Use Only.
628: --
629: -- ----------------------------------------------------------------------------
630: procedure chk_df
631: (p_rec in per_elc_shd.g_rec_type
632: ) is
633: --
634: l_proc varchar2(72) := g_package || 'chk_df';
635: --

Line 640: nvl(per_elc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

636: begin
637: hr_utility.set_location('Entering:'||l_proc,10);
638: --
639: if ((p_rec.election_id is not null) and (
640: nvl(per_elc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
641: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
642: nvl(per_elc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
643: nvl(p_rec.attribute1, hr_api.g_varchar2) or
644: nvl(per_elc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 642: nvl(per_elc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

638: --
639: if ((p_rec.election_id is not null) and (
640: nvl(per_elc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
641: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
642: nvl(per_elc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
643: nvl(p_rec.attribute1, hr_api.g_varchar2) or
644: nvl(per_elc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
645: nvl(p_rec.attribute2, hr_api.g_varchar2) or
646: nvl(per_elc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 644: nvl(per_elc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

640: nvl(per_elc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
641: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
642: nvl(per_elc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
643: nvl(p_rec.attribute1, hr_api.g_varchar2) or
644: nvl(per_elc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
645: nvl(p_rec.attribute2, hr_api.g_varchar2) or
646: nvl(per_elc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
647: nvl(p_rec.attribute3, hr_api.g_varchar2) or
648: nvl(per_elc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 646: nvl(per_elc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

642: nvl(per_elc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
643: nvl(p_rec.attribute1, hr_api.g_varchar2) or
644: nvl(per_elc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
645: nvl(p_rec.attribute2, hr_api.g_varchar2) or
646: nvl(per_elc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
647: nvl(p_rec.attribute3, hr_api.g_varchar2) or
648: nvl(per_elc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
649: nvl(p_rec.attribute4, hr_api.g_varchar2) or
650: nvl(per_elc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 648: nvl(per_elc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

644: nvl(per_elc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
645: nvl(p_rec.attribute2, hr_api.g_varchar2) or
646: nvl(per_elc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
647: nvl(p_rec.attribute3, hr_api.g_varchar2) or
648: nvl(per_elc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
649: nvl(p_rec.attribute4, hr_api.g_varchar2) or
650: nvl(per_elc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
651: nvl(p_rec.attribute5, hr_api.g_varchar2) or
652: nvl(per_elc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 650: nvl(per_elc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

646: nvl(per_elc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
647: nvl(p_rec.attribute3, hr_api.g_varchar2) or
648: nvl(per_elc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
649: nvl(p_rec.attribute4, hr_api.g_varchar2) or
650: nvl(per_elc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
651: nvl(p_rec.attribute5, hr_api.g_varchar2) or
652: nvl(per_elc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
653: nvl(p_rec.attribute6, hr_api.g_varchar2) or
654: nvl(per_elc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 652: nvl(per_elc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

648: nvl(per_elc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
649: nvl(p_rec.attribute4, hr_api.g_varchar2) or
650: nvl(per_elc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
651: nvl(p_rec.attribute5, hr_api.g_varchar2) or
652: nvl(per_elc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
653: nvl(p_rec.attribute6, hr_api.g_varchar2) or
654: nvl(per_elc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
655: nvl(p_rec.attribute7, hr_api.g_varchar2) or
656: nvl(per_elc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 654: nvl(per_elc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

650: nvl(per_elc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
651: nvl(p_rec.attribute5, hr_api.g_varchar2) or
652: nvl(per_elc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
653: nvl(p_rec.attribute6, hr_api.g_varchar2) or
654: nvl(per_elc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
655: nvl(p_rec.attribute7, hr_api.g_varchar2) or
656: nvl(per_elc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
657: nvl(p_rec.attribute8, hr_api.g_varchar2) or
658: nvl(per_elc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 656: nvl(per_elc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

652: nvl(per_elc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
653: nvl(p_rec.attribute6, hr_api.g_varchar2) or
654: nvl(per_elc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
655: nvl(p_rec.attribute7, hr_api.g_varchar2) or
656: nvl(per_elc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
657: nvl(p_rec.attribute8, hr_api.g_varchar2) or
658: nvl(per_elc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
659: nvl(p_rec.attribute9, hr_api.g_varchar2) or
660: nvl(per_elc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 658: nvl(per_elc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

654: nvl(per_elc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
655: nvl(p_rec.attribute7, hr_api.g_varchar2) or
656: nvl(per_elc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
657: nvl(p_rec.attribute8, hr_api.g_varchar2) or
658: nvl(per_elc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
659: nvl(p_rec.attribute9, hr_api.g_varchar2) or
660: nvl(per_elc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
661: nvl(p_rec.attribute10, hr_api.g_varchar2) or
662: nvl(per_elc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 660: nvl(per_elc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

656: nvl(per_elc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
657: nvl(p_rec.attribute8, hr_api.g_varchar2) or
658: nvl(per_elc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
659: nvl(p_rec.attribute9, hr_api.g_varchar2) or
660: nvl(per_elc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
661: nvl(p_rec.attribute10, hr_api.g_varchar2) or
662: nvl(per_elc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
663: nvl(p_rec.attribute11, hr_api.g_varchar2) or
664: nvl(per_elc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 662: nvl(per_elc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

658: nvl(per_elc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
659: nvl(p_rec.attribute9, hr_api.g_varchar2) or
660: nvl(per_elc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
661: nvl(p_rec.attribute10, hr_api.g_varchar2) or
662: nvl(per_elc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
663: nvl(p_rec.attribute11, hr_api.g_varchar2) or
664: nvl(per_elc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
665: nvl(p_rec.attribute12, hr_api.g_varchar2) or
666: nvl(per_elc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 664: nvl(per_elc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

660: nvl(per_elc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
661: nvl(p_rec.attribute10, hr_api.g_varchar2) or
662: nvl(per_elc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
663: nvl(p_rec.attribute11, hr_api.g_varchar2) or
664: nvl(per_elc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
665: nvl(p_rec.attribute12, hr_api.g_varchar2) or
666: nvl(per_elc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
667: nvl(p_rec.attribute13, hr_api.g_varchar2) or
668: nvl(per_elc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 666: nvl(per_elc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

662: nvl(per_elc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
663: nvl(p_rec.attribute11, hr_api.g_varchar2) or
664: nvl(per_elc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
665: nvl(p_rec.attribute12, hr_api.g_varchar2) or
666: nvl(per_elc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
667: nvl(p_rec.attribute13, hr_api.g_varchar2) or
668: nvl(per_elc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
669: nvl(p_rec.attribute14, hr_api.g_varchar2) or
670: nvl(per_elc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 668: nvl(per_elc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

664: nvl(per_elc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
665: nvl(p_rec.attribute12, hr_api.g_varchar2) or
666: nvl(per_elc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
667: nvl(p_rec.attribute13, hr_api.g_varchar2) or
668: nvl(per_elc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
669: nvl(p_rec.attribute14, hr_api.g_varchar2) or
670: nvl(per_elc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
671: nvl(p_rec.attribute15, hr_api.g_varchar2) or
672: nvl(per_elc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 670: nvl(per_elc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

666: nvl(per_elc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
667: nvl(p_rec.attribute13, hr_api.g_varchar2) or
668: nvl(per_elc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
669: nvl(p_rec.attribute14, hr_api.g_varchar2) or
670: nvl(per_elc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
671: nvl(p_rec.attribute15, hr_api.g_varchar2) or
672: nvl(per_elc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
673: nvl(p_rec.attribute16, hr_api.g_varchar2) or
674: nvl(per_elc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 672: nvl(per_elc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

668: nvl(per_elc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
669: nvl(p_rec.attribute14, hr_api.g_varchar2) or
670: nvl(per_elc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
671: nvl(p_rec.attribute15, hr_api.g_varchar2) or
672: nvl(per_elc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
673: nvl(p_rec.attribute16, hr_api.g_varchar2) or
674: nvl(per_elc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
675: nvl(p_rec.attribute17, hr_api.g_varchar2) or
676: nvl(per_elc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 674: nvl(per_elc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

670: nvl(per_elc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
671: nvl(p_rec.attribute15, hr_api.g_varchar2) or
672: nvl(per_elc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
673: nvl(p_rec.attribute16, hr_api.g_varchar2) or
674: nvl(per_elc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
675: nvl(p_rec.attribute17, hr_api.g_varchar2) or
676: nvl(per_elc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
677: nvl(p_rec.attribute18, hr_api.g_varchar2) or
678: nvl(per_elc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 676: nvl(per_elc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

672: nvl(per_elc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
673: nvl(p_rec.attribute16, hr_api.g_varchar2) or
674: nvl(per_elc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
675: nvl(p_rec.attribute17, hr_api.g_varchar2) or
676: nvl(per_elc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
677: nvl(p_rec.attribute18, hr_api.g_varchar2) or
678: nvl(per_elc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
679: nvl(p_rec.attribute19, hr_api.g_varchar2) or
680: nvl(per_elc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 678: nvl(per_elc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

674: nvl(per_elc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
675: nvl(p_rec.attribute17, hr_api.g_varchar2) or
676: nvl(per_elc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
677: nvl(p_rec.attribute18, hr_api.g_varchar2) or
678: nvl(per_elc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
679: nvl(p_rec.attribute19, hr_api.g_varchar2) or
680: nvl(per_elc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
681: nvl(p_rec.attribute20, hr_api.g_varchar2) or
682: nvl(per_elc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 680: nvl(per_elc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

676: nvl(per_elc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
677: nvl(p_rec.attribute18, hr_api.g_varchar2) or
678: nvl(per_elc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
679: nvl(p_rec.attribute19, hr_api.g_varchar2) or
680: nvl(per_elc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
681: nvl(p_rec.attribute20, hr_api.g_varchar2) or
682: nvl(per_elc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
683: nvl(p_rec.attribute21, hr_api.g_varchar2) or
684: nvl(per_elc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 682: nvl(per_elc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

678: nvl(per_elc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
679: nvl(p_rec.attribute19, hr_api.g_varchar2) or
680: nvl(per_elc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
681: nvl(p_rec.attribute20, hr_api.g_varchar2) or
682: nvl(per_elc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
683: nvl(p_rec.attribute21, hr_api.g_varchar2) or
684: nvl(per_elc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
685: nvl(p_rec.attribute22, hr_api.g_varchar2) or
686: nvl(per_elc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 684: nvl(per_elc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

680: nvl(per_elc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
681: nvl(p_rec.attribute20, hr_api.g_varchar2) or
682: nvl(per_elc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
683: nvl(p_rec.attribute21, hr_api.g_varchar2) or
684: nvl(per_elc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
685: nvl(p_rec.attribute22, hr_api.g_varchar2) or
686: nvl(per_elc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
687: nvl(p_rec.attribute23, hr_api.g_varchar2) or
688: nvl(per_elc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 686: nvl(per_elc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

682: nvl(per_elc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
683: nvl(p_rec.attribute21, hr_api.g_varchar2) or
684: nvl(per_elc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
685: nvl(p_rec.attribute22, hr_api.g_varchar2) or
686: nvl(per_elc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
687: nvl(p_rec.attribute23, hr_api.g_varchar2) or
688: nvl(per_elc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
689: nvl(p_rec.attribute24, hr_api.g_varchar2) or
690: nvl(per_elc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 688: nvl(per_elc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

684: nvl(per_elc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
685: nvl(p_rec.attribute22, hr_api.g_varchar2) or
686: nvl(per_elc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
687: nvl(p_rec.attribute23, hr_api.g_varchar2) or
688: nvl(per_elc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
689: nvl(p_rec.attribute24, hr_api.g_varchar2) or
690: nvl(per_elc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
691: nvl(p_rec.attribute25, hr_api.g_varchar2) or
692: nvl(per_elc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 690: nvl(per_elc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

686: nvl(per_elc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
687: nvl(p_rec.attribute23, hr_api.g_varchar2) or
688: nvl(per_elc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
689: nvl(p_rec.attribute24, hr_api.g_varchar2) or
690: nvl(per_elc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
691: nvl(p_rec.attribute25, hr_api.g_varchar2) or
692: nvl(per_elc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute26, hr_api.g_varchar2) or
694: nvl(per_elc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 692: nvl(per_elc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

688: nvl(per_elc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
689: nvl(p_rec.attribute24, hr_api.g_varchar2) or
690: nvl(per_elc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
691: nvl(p_rec.attribute25, hr_api.g_varchar2) or
692: nvl(per_elc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute26, hr_api.g_varchar2) or
694: nvl(per_elc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute27, hr_api.g_varchar2) or
696: nvl(per_elc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 694: nvl(per_elc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

690: nvl(per_elc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
691: nvl(p_rec.attribute25, hr_api.g_varchar2) or
692: nvl(per_elc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute26, hr_api.g_varchar2) or
694: nvl(per_elc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute27, hr_api.g_varchar2) or
696: nvl(per_elc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute28, hr_api.g_varchar2) or
698: nvl(per_elc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 696: nvl(per_elc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

692: nvl(per_elc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute26, hr_api.g_varchar2) or
694: nvl(per_elc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute27, hr_api.g_varchar2) or
696: nvl(per_elc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute28, hr_api.g_varchar2) or
698: nvl(per_elc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute29, hr_api.g_varchar2) or
700: nvl(per_elc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 698: nvl(per_elc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

694: nvl(per_elc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute27, hr_api.g_varchar2) or
696: nvl(per_elc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute28, hr_api.g_varchar2) or
698: nvl(per_elc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute29, hr_api.g_varchar2) or
700: nvl(per_elc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
702: or (p_rec.election_id is null) then

Line 700: nvl(per_elc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

696: nvl(per_elc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute28, hr_api.g_varchar2) or
698: nvl(per_elc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute29, hr_api.g_varchar2) or
700: nvl(per_elc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
702: or (p_rec.election_id is null) then
703: --
704: -- Only execute the validation if absolutely necessary:

Line 808: ,p_rec in per_elc_shd.g_rec_type

804: -- {End Of Comments}
805: -- ----------------------------------------------------------------------------
806: Procedure chk_non_updateable_args
807: (p_effective_date in date
808: ,p_rec in per_elc_shd.g_rec_type
809: ) IS
810: --
811: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
812: l_error EXCEPTION;

Line 820: IF NOT per_elc_shd.api_updating

816: --
817: -- Only proceed with the validation if a row exists for the current
818: -- record in the HR Schema.
819: --
820: IF NOT per_elc_shd.api_updating
821: (p_election_id => p_rec.election_id
822: ,p_object_version_number => p_rec.object_version_number
823: ) THEN
824: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 847: ,p_rec in per_elc_shd.g_rec_type

843: -- |---------------------------< insert_validate >----------------------------|
844: -- ----------------------------------------------------------------------------
845: Procedure insert_validate
846: (p_effective_date in date
847: ,p_rec in per_elc_shd.g_rec_type
848: ) is
849: --
850: l_proc varchar2(72) := g_package||'insert_validate';
851: --

Line 889: ,p_rec in per_elc_shd.g_rec_type

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

Line 935: (p_rec in per_elc_shd.g_rec_type

931: -- ----------------------------------------------------------------------------
932: -- |---------------------------< delete_validate >----------------------------|
933: -- ----------------------------------------------------------------------------
934: Procedure delete_validate
935: (p_rec in per_elc_shd.g_rec_type
936: ) is
937: --
938: l_proc varchar2(72) := g_package||'delete_validate';
939: --