42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Ensure that all the mandatory parameter are not null
45: --
46: hr_api.mandatory_arg_error
47: (p_api_name => l_proc
48: ,p_argument => 'comp_element_outcome_id'
49: ,p_argument_value => p_comp_element_outcome_id
50: );
69: close csr_sec_grp;
70: --
71: -- Set the security_group_id in CLIENT_INFO
72: --
73: hr_api.set_security_group_id
74: (p_security_group_id => l_security_group_id
75: );
76: --
77: -- Set the sessions legislation context in HR_SESSION_DATA
75: );
76: --
77: -- Set the sessions legislation context in HR_SESSION_DATA
78: --
79: hr_api.set_legislation_context(l_legislation_code);
80: end if;
81: --
82: hr_utility.set_location(' Leaving:'|| l_proc, 20);
83: --
110: hr_utility.set_location('Entering:'|| l_proc, 10);
111: --
112: -- Ensure that all the mandatory parameter are not null
113: --
114: hr_api.mandatory_arg_error
115: (p_api_name => l_proc
116: ,p_argument => 'comp_element_outcome_id'
117: ,p_argument_value => p_comp_element_outcome_id
118: );
116: ,p_argument => 'comp_element_outcome_id'
117: ,p_argument_value => p_comp_element_outcome_id
118: );
119: --
120: if ( nvl(per_ceo_bus.g_comp_element_outcome_id, hr_api.g_number)
121: = p_comp_element_outcome_id) then
122: --
123: -- The legislation code has already been found with a previous
124: -- call to this function. Just return the value in the global
252: ,p_object_version_number => p_object_version_number
253: );
254: --
255: if (l_api_updating
256: and nvl(p_comp_element_outcome_id,hr_api.g_number)
257: <> per_ceo_shd.g_old_rec.comp_element_outcome_id) then
258: --
259: -- raise error as PK has changed
260: --
333: --
334: -- Check mandatory parameters have been set
335: --
336:
337: hr_api.mandatory_arg_error
338: (p_api_name => l_proc
339: ,p_argument => 'competence_element_id'
340: ,p_argument_value => p_competence_element_id
341: );
435: --
436: -- Check mandatory parameters have been set
437: --
438:
439: hr_api.mandatory_arg_error
440: (p_api_name => l_proc
441: ,p_argument => 'outcome_id'
442: ,p_argument_value => p_outcome_id
443: );
527: cursor csr_uniq_comp_element_outcome is
528: select 'x' from per_comp_element_outcomes o
529: where o.competence_element_id = p_competence_element_id
530: and o.outcome_id = p_outcome_id
531: and p_date_from < nvl(o.date_to,hr_api.g_eot)
532: and nvl(p_date_to,hr_api.g_eot) > o.date_from;
533:
534: /* cursor csr_upd_uniq_comp_ele_outcome is
535: select 'x' from per_comp_element_outcomes o
528: select 'x' from per_comp_element_outcomes o
529: where o.competence_element_id = p_competence_element_id
530: and o.outcome_id = p_outcome_id
531: and p_date_from < nvl(o.date_to,hr_api.g_eot)
532: and nvl(p_date_to,hr_api.g_eot) > o.date_from;
533:
534: /* cursor csr_upd_uniq_comp_ele_outcome is
535: select 'x' from per_comp_element_outcomes o
536: where o.comp_element_outcome_id = p_comp_element_outcome_id
535: select 'x' from per_comp_element_outcomes o
536: where o.comp_element_outcome_id = p_comp_element_outcome_id
537: and o.competence_element_id = p_competence_element_id
538: and o.outcome_id = p_outcome_id
539: and p_date_from < nvl(o.date_to,hr_api.g_eot)
540: and nvl(p_date_to,hr_api.g_eot) > o.date_from;*/
541:
542: l_outcome_name per_competence_outcomes.name%type;
543:
536: where o.comp_element_outcome_id = p_comp_element_outcome_id
537: and o.competence_element_id = p_competence_element_id
538: and o.outcome_id = p_outcome_id
539: and p_date_from < nvl(o.date_to,hr_api.g_eot)
540: and nvl(p_date_to,hr_api.g_eot) > o.date_from;*/
541:
542: l_outcome_name per_competence_outcomes.name%type;
543:
544: cursor csr_upd_uniq_comp_ele_outcome(p_name per_competence_outcomes.name%type)is
546: where o.comp_element_outcome_id <> p_comp_element_outcome_id
547: and o.competence_element_id = p_competence_element_id
548: and co.outcome_id = o.outcome_id
549: and co.name = p_name
550: and(p_date_from between o.date_from and nvl(o.date_to,hr_api.g_eot)
551: or p_date_to between o.date_from and nvl(o.date_to,hr_api.g_eot)
552: or o.date_from between p_date_from and p_date_to );
553:
554:
547: and o.competence_element_id = p_competence_element_id
548: and co.outcome_id = o.outcome_id
549: and co.name = p_name
550: and(p_date_from between o.date_from and nvl(o.date_to,hr_api.g_eot)
551: or p_date_to between o.date_from and nvl(o.date_to,hr_api.g_eot)
552: or o.date_from between p_date_from and p_date_to );
553:
554:
555: --
576: (per_ceo_shd.g_old_rec.competence_element_id <>
577: p_competence_element_id or
578: per_ceo_shd.g_old_rec.outcome_id <> p_outcome_id or
579: per_ceo_shd.g_old_rec.date_from <> p_date_from or
580: nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
581: nvl(p_date_to,hr_api.g_eot))) then
582: --
583: -- Check that a combination is unique
584: --
577: p_competence_element_id or
578: per_ceo_shd.g_old_rec.outcome_id <> p_outcome_id or
579: per_ceo_shd.g_old_rec.date_from <> p_date_from or
580: nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
581: nvl(p_date_to,hr_api.g_eot))) then
582: --
583: -- Check that a combination is unique
584: --
585:
679: --
680: -- Check mandatory parameters have been set
681: --
682:
683: hr_api.mandatory_arg_error
684: (p_api_name => l_proc
685: ,p_argument => 'date_from'
686: ,p_argument_value => p_date_from
687: );
695: (p_comp_element_outcome_id => p_comp_element_outcome_id
696: ,p_object_version_number => p_object_version_number);
697: --
698: if (((l_api_updating and
699: (nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
700: nvl(p_date_to,hr_api.g_eot)) or
701: (per_ceo_shd.g_old_rec.date_from <> p_date_from)) or
702: (NOT l_api_updating))) then
703: --
696: ,p_object_version_number => p_object_version_number);
697: --
698: if (((l_api_updating and
699: (nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
700: nvl(p_date_to,hr_api.g_eot)) or
701: (per_ceo_shd.g_old_rec.date_from <> p_date_from)) or
702: (NOT l_api_updating))) then
703: --
704: -- Check that date_from <= date_to
704: -- Check that date_from <= date_to
705: --
706: hr_utility.set_location(l_proc, 30);
707: --
708: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
709: hr_utility.set_message(800,'HR_6758_APPL_DATE_FROM_CHK');
710: hr_multi_message.add
711: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
712: hr_utility.raise_error;
720: open csr_get_outcome_active_date ;
721: fetch csr_get_outcome_active_date into l_outcome_active_date;
722: close csr_get_outcome_active_date;
723:
724: if p_date_from < nvl( l_outcome_active_date,hr_api.g_eot) then
725: hr_utility.set_message(800,'HR_34724_COMP_OUTCME_DATE_INVL');
726: hr_multi_message.add
727: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
728: hr_utility.raise_error;
771: begin
772: hr_utility.set_location('Entering:'||l_proc,10);
773: --
774: if ((p_rec.comp_element_outcome_id is not null) and (
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
772: hr_utility.set_location('Entering:'||l_proc,10);
773: --
774: if ((p_rec.comp_element_outcome_id is not null) and (
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
773: --
774: if ((p_rec.comp_element_outcome_id is not null) and (
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
774: if ((p_rec.comp_element_outcome_id is not null) and (
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))
815: or (p_rec.comp_element_outcome_id is null) then
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))
815: or (p_rec.comp_element_outcome_id is null) then
816: --
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))
815: or (p_rec.comp_element_outcome_id is null) then
816: --
817: -- Only execute the validation if absolutely necessary:
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))
815: or (p_rec.comp_element_outcome_id is null) then
816: --
817: -- Only execute the validation if absolutely necessary:
818: -- a) During update, the structure column value or any
906: begin
907: hr_utility.set_location('Entering:'||l_proc,10);
908: --
909: if ((p_rec.comp_element_outcome_id is not null) and (
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
907: hr_utility.set_location('Entering:'||l_proc,10);
908: --
909: if ((p_rec.comp_element_outcome_id is not null) and (
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
908: --
909: if ((p_rec.comp_element_outcome_id is not null) and (
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
909: if ((p_rec.comp_element_outcome_id is not null) and (
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
950: or (p_rec.comp_element_outcome_id is null) then
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
950: or (p_rec.comp_element_outcome_id is null) then
951: --
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
950: or (p_rec.comp_element_outcome_id is null) then
951: --
952: -- Only execute the validation if absolutely necessary:
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
950: or (p_rec.comp_element_outcome_id is null) then
951: --
952: -- Only execute the validation if absolutely necessary:
953: -- a) During update, the structure column value or any
1205: cursor csr_get_outcome_number is
1206: select count(cpo.outcome_id) from per_competence_outcomes cpo
1207: where cpo.competence_id = p_competence_id
1208: and p_effective_date between date_from
1209: and nvl(date_to,hr_api.g_eot);
1210:
1211: cursor csr_get_achieved_number is
1212: select count(ceo.comp_element_outcome_id)
1213: ,max(ceo.date_from)
1213: ,max(ceo.date_from)
1214: from per_comp_element_outcomes ceo
1215: where ceo.competence_element_id = p_competence_element_id
1216: -- and p_effective_date between ceo.date_from
1217: -- and nvl(date_to,hr_api.g_eot)
1218: and ceo.outcome_id in (
1219: select cpo2.outcome_id from per_competence_outcomes cpo2
1220: where cpo2.competence_id = p_competence_id
1221: and p_effective_date between cpo2.date_from
1218: and ceo.outcome_id in (
1219: select cpo2.outcome_id from per_competence_outcomes cpo2
1220: where cpo2.competence_id = p_competence_id
1221: and p_effective_date between cpo2.date_from
1222: and nvl(cpo2.date_to,hr_api.g_eot));
1223:
1224: --
1225: --
1226: l_proc varchar2(72) := g_package||'check_outcome_achieved';