73: hr_utility.set_location('Entering:'|| l_proc, 12);
74: --
75: -- Check mandatory parameters have been set
76: --
77: hr_api.mandatory_arg_error
78: (p_api_name => l_proc
79: ,p_argument => 'rep_body_id'
80: ,p_argument_value => p_rep_body_id
81: );
252: hr_utility.set_location('Entering:'|| l_proc, 10);
253: --
254: -- Check mandatory parameters have been set
255: --
256: hr_api.mandatory_arg_error
257: (p_api_name => l_proc
258: ,p_argument => 'election_date'
259: ,p_argument_value => p_election_date
260: );
278: -- Check that the date_from values is less than
279: -- or equal to the date_to value for the current
280: -- record
281: --
282: if p_election_date > nvl(p_result_publish_date, hr_api.g_eot) then
283: fnd_message.set_name('PER', 'PER_289098_ELC_DATE_ERROR');
284: hr_utility.raise_error;
285: end if;
286: --
317: hr_utility.set_location('Entering:'|| l_proc, 10);
318: --
319: -- Ensure that all the mandatory parameter are not null
320: --
321: hr_api.mandatory_arg_error
322: (p_api_name => l_proc
323: ,p_argument => 'election_id'
324: ,p_argument_value => p_election_id
325: );
340: close csr_sec_grp;
341: --
342: -- Set the security_group_id in CLIENT_INFO
343: --
344: hr_api.set_security_group_id
345: (p_security_group_id => l_security_group_id
346: );
347: --
348: hr_utility.set_location(' Leaving:'|| l_proc, 20);
377: hr_utility.set_location('Entering:'|| l_proc, 10);
378: --
379: -- Ensure that all the mandatory parameter are not null
380: --
381: hr_api.mandatory_arg_error
382: (p_api_name => l_proc
383: ,p_argument => 'election_id'
384: ,p_argument_value => p_election_id
385: );
383: ,p_argument => 'election_id'
384: ,p_argument_value => p_election_id
385: );
386: --
387: if ( nvl(per_elc_bus.g_election_id, hr_api.g_number)
388: = p_election_id) then
389: --
390: -- The legislation code has already been found with a previous
391: -- call to this function. Just return the value in the global
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) <>
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) <>
468: nvl(p_rec.election_information2, hr_api.g_varchar2) or
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) <>
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) <>
470: nvl(p_rec.election_information3, hr_api.g_varchar2) or
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) <>
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) <>
472: nvl(p_rec.election_information4, 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) <>
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) <>
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) <>
474: nvl(p_rec.election_information5, 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) <>
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) <>
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) <>
476: nvl(p_rec.election_information6, 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) <>
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) <>
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) <>
478: nvl(p_rec.election_information7, 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) <>
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) <>
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) <>
480: nvl(p_rec.election_information8, 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) <>
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) <>
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) <>
482: nvl(p_rec.election_information9, 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) <>
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) <>
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) <>
484: nvl(p_rec.election_information10, 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) <>
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) <>
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) <>
486: nvl(p_rec.election_information11, 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) <>
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) <>
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) <>
488: nvl(p_rec.election_information12, 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) <>
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) <>
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) <>
490: nvl(p_rec.election_information13, 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) <>
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) <>
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) <>
492: nvl(p_rec.election_information14, 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) <>
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) <>
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) <>
494: nvl(p_rec.election_information15, 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) <>
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) <>
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) <>
496: nvl(p_rec.election_information16, 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) <>
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) <>
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) <>
498: nvl(p_rec.election_information17, 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) <>
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) <>
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) <>
500: nvl(p_rec.election_information18, 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) <>
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) <>
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) <>
502: nvl(p_rec.election_information19, 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) <>
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) <>
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) <>
504: nvl(p_rec.election_information20, 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) <>
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) <>
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) <>
506: nvl(p_rec.election_information21, 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) <>
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) <>
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) <>
508: nvl(p_rec.election_information22, 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) <>
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) <>
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) <>
510: nvl(p_rec.election_information23, 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) <>
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) <>
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) <>
512: nvl(p_rec.election_information24, 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) <>
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) <>
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) <>
514: nvl(p_rec.election_information25, 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) <>
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) <>
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) <>
516: nvl(p_rec.election_information26, 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) <>
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) <>
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) <>
518: nvl(p_rec.election_information27, 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) <>
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) <>
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) <>
520: nvl(p_rec.election_information28, 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) <>
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) <>
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) <>
522: nvl(p_rec.election_information29, 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) <>
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) <>
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) <>
524: nvl(p_rec.election_information30, 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
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
526: --
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:
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:
528: -- a) During update, the structure column value or any
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) <>
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) <>
645: nvl(p_rec.attribute2, hr_api.g_varchar2) or
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) <>
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) <>
647: nvl(p_rec.attribute3, hr_api.g_varchar2) or
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) <>
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) <>
649: nvl(p_rec.attribute4, 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) <>
649: nvl(p_rec.attribute4, hr_api.g_varchar2) or
650: nvl(per_elc_shd.g_old_rec.attribute5, 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) <>
651: nvl(p_rec.attribute5, 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) <>
651: nvl(p_rec.attribute5, hr_api.g_varchar2) or
652: nvl(per_elc_shd.g_old_rec.attribute6, 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) <>
653: nvl(p_rec.attribute6, 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) <>
653: nvl(p_rec.attribute6, hr_api.g_varchar2) or
654: nvl(per_elc_shd.g_old_rec.attribute7, 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) <>
655: nvl(p_rec.attribute7, 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) <>
655: nvl(p_rec.attribute7, hr_api.g_varchar2) or
656: nvl(per_elc_shd.g_old_rec.attribute8, 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) <>
657: nvl(p_rec.attribute8, 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) <>
657: nvl(p_rec.attribute8, hr_api.g_varchar2) or
658: nvl(per_elc_shd.g_old_rec.attribute9, 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) <>
659: nvl(p_rec.attribute9, 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) <>
659: nvl(p_rec.attribute9, hr_api.g_varchar2) or
660: nvl(per_elc_shd.g_old_rec.attribute10, 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) <>
661: nvl(p_rec.attribute10, 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) <>
661: nvl(p_rec.attribute10, hr_api.g_varchar2) or
662: nvl(per_elc_shd.g_old_rec.attribute11, 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) <>
663: nvl(p_rec.attribute11, 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) <>
663: nvl(p_rec.attribute11, hr_api.g_varchar2) or
664: nvl(per_elc_shd.g_old_rec.attribute12, 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) <>
665: nvl(p_rec.attribute12, 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) <>
665: nvl(p_rec.attribute12, hr_api.g_varchar2) or
666: nvl(per_elc_shd.g_old_rec.attribute13, 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) <>
667: nvl(p_rec.attribute13, 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) <>
667: nvl(p_rec.attribute13, hr_api.g_varchar2) or
668: nvl(per_elc_shd.g_old_rec.attribute14, 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) <>
669: nvl(p_rec.attribute14, 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) <>
669: nvl(p_rec.attribute14, hr_api.g_varchar2) or
670: nvl(per_elc_shd.g_old_rec.attribute15, 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) <>
671: nvl(p_rec.attribute15, 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) <>
671: nvl(p_rec.attribute15, hr_api.g_varchar2) or
672: nvl(per_elc_shd.g_old_rec.attribute16, 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) <>
673: nvl(p_rec.attribute16, 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) <>
673: nvl(p_rec.attribute16, hr_api.g_varchar2) or
674: nvl(per_elc_shd.g_old_rec.attribute17, 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) <>
675: nvl(p_rec.attribute17, 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) <>
675: nvl(p_rec.attribute17, hr_api.g_varchar2) or
676: nvl(per_elc_shd.g_old_rec.attribute18, 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) <>
677: nvl(p_rec.attribute18, 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) <>
677: nvl(p_rec.attribute18, hr_api.g_varchar2) or
678: nvl(per_elc_shd.g_old_rec.attribute19, 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) <>
679: nvl(p_rec.attribute19, 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) <>
679: nvl(p_rec.attribute19, hr_api.g_varchar2) or
680: nvl(per_elc_shd.g_old_rec.attribute20, 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) <>
681: nvl(p_rec.attribute20, 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) <>
681: nvl(p_rec.attribute20, hr_api.g_varchar2) or
682: nvl(per_elc_shd.g_old_rec.attribute21, 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) <>
683: nvl(p_rec.attribute21, 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) <>
683: nvl(p_rec.attribute21, hr_api.g_varchar2) or
684: nvl(per_elc_shd.g_old_rec.attribute22, 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) <>
685: nvl(p_rec.attribute22, 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) <>
685: nvl(p_rec.attribute22, hr_api.g_varchar2) or
686: nvl(per_elc_shd.g_old_rec.attribute23, 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) <>
687: nvl(p_rec.attribute23, 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) <>
687: nvl(p_rec.attribute23, hr_api.g_varchar2) or
688: nvl(per_elc_shd.g_old_rec.attribute24, 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) <>
689: nvl(p_rec.attribute24, 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) <>
689: nvl(p_rec.attribute24, hr_api.g_varchar2) or
690: nvl(per_elc_shd.g_old_rec.attribute25, 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) <>
691: nvl(p_rec.attribute25, 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) <>
691: nvl(p_rec.attribute25, hr_api.g_varchar2) or
692: nvl(per_elc_shd.g_old_rec.attribute26, 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) <>
693: nvl(p_rec.attribute26, 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) <>
693: nvl(p_rec.attribute26, hr_api.g_varchar2) or
694: nvl(per_elc_shd.g_old_rec.attribute27, 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) <>
695: nvl(p_rec.attribute27, 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) <>
695: nvl(p_rec.attribute27, hr_api.g_varchar2) or
696: nvl(per_elc_shd.g_old_rec.attribute28, 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) <>
697: nvl(p_rec.attribute28, 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) <>
697: nvl(p_rec.attribute28, hr_api.g_varchar2) or
698: nvl(per_elc_shd.g_old_rec.attribute29, 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) <>
699: nvl(p_rec.attribute29, 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) <>
699: nvl(p_rec.attribute29, hr_api.g_varchar2) or
700: nvl(per_elc_shd.g_old_rec.attribute30, 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) <>
701: nvl(p_rec.attribute30, 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
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
703: --
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:
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:
705: -- a) During update, the structure column value or any
831: -- not been updated.
832: --
833: EXCEPTION
834: WHEN l_error THEN
835: hr_api.argument_changed_error
836: (p_api_name => l_proc
837: ,p_argument => l_argument);
838: WHEN OTHERS THEN
839: RAISE;
853: hr_utility.set_location('Entering:'||l_proc, 5);
854: --
855: -- Call all supporting business operations
856: --
857: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
858: --
859: --
860: hr_utility.set_location('Entering: chk_rep_body_id', 10);
861:
895: hr_utility.set_location('Entering:'||l_proc, 5);
896: --
897: -- Call all supporting business operations
898: --
899: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
900: --
901: chk_non_updateable_args
902: (p_effective_date => p_effective_date
903: ,p_rec => p_rec