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 => 'outcome_id'
49: ,p_argument_value => p_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 => 'outcome_id'
117: ,p_argument_value => p_outcome_id
118: );
116: ,p_argument => 'outcome_id'
117: ,p_argument_value => p_outcome_id
118: );
119: --
120: if ( nvl(per_cpo_bus.g_outcome_id, hr_api.g_number)
121: = p_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
251: ,p_object_version_number => p_object_version_number
252: );
253: --
254: if (l_api_updating
255: and nvl(p_outcome_id,hr_api.g_number)
256: <> per_cpo_shd.g_old_rec.outcome_id) then
257: --
258: -- raise error as PK has changed
259: --
332: --
333: -- Check mandatory parameters have been set
334: --
335:
336: hr_api.mandatory_arg_error
337: (p_api_name => l_proc
338: ,p_argument => 'competence_id'
339: ,p_argument_value => p_competence_id
340: );
423: cursor csr_outcome_number is
424: select null from per_competence_outcomes
425: where competence_id = p_competence_id
426: and outcome_number = p_outcome_number
427: and (p_date_from <= nvl(date_to, hr_api.g_eot)
428: and NVL(p_date_to, hr_api.g_eot) >= date_from);
429:
430: cursor csr_upd_outcome_number is
431: select null from per_competence_outcomes
424: select null from per_competence_outcomes
425: where competence_id = p_competence_id
426: and outcome_number = p_outcome_number
427: and (p_date_from <= nvl(date_to, hr_api.g_eot)
428: and NVL(p_date_to, hr_api.g_eot) >= date_from);
429:
430: cursor csr_upd_outcome_number is
431: select null from per_competence_outcomes
432: where outcome_id <> p_outcome_id
431: select null from per_competence_outcomes
432: where outcome_id <> p_outcome_id
433: and competence_id = p_competence_id
434: and outcome_number = p_outcome_number
435: and (p_date_from <= nvl(date_to, hr_api.g_eot)
436: and NVL(p_date_to, hr_api.g_eot) >= date_from);
437:
438: --
439: -- Declare local variables
432: where outcome_id <> p_outcome_id
433: and competence_id = p_competence_id
434: and outcome_number = p_outcome_number
435: and (p_date_from <= nvl(date_to, hr_api.g_eot)
436: and NVL(p_date_to, hr_api.g_eot) >= date_from);
437:
438: --
439: -- Declare local variables
440: --
452: --
453: -- Check mandatory parameters have been set
454: --
455:
456: hr_api.mandatory_arg_error
457: (p_api_name => l_proc
458: ,p_argument => 'outcome_number'
459: ,p_argument_value => p_outcome_number
460: );
473:
474: if (l_api_updating and
475: (per_cpo_shd.g_old_rec.outcome_number <> p_outcome_number or
476: per_cpo_shd.g_old_rec.date_from <> p_date_from or
477: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
478: nvl(p_date_to,hr_api.g_eot)))
479: then
480: --
481: -- Check that outcome_number is unique
474: if (l_api_updating and
475: (per_cpo_shd.g_old_rec.outcome_number <> p_outcome_number or
476: per_cpo_shd.g_old_rec.date_from <> p_date_from or
477: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
478: nvl(p_date_to,hr_api.g_eot)))
479: then
480: --
481: -- Check that outcome_number is unique
482: --
552: cursor csr_name is
553: select null from per_competence_outcomes
554: where competence_id = p_competence_id
555: and name = p_name
556: and (p_date_from <= nvl(date_to, hr_api.g_eot)
557: and NVL(p_date_to, hr_api.g_eot) >= date_from);
558:
559: cursor csr_upd_name is
560: select null from per_competence_outcomes
553: select null from per_competence_outcomes
554: where competence_id = p_competence_id
555: and name = p_name
556: and (p_date_from <= nvl(date_to, hr_api.g_eot)
557: and NVL(p_date_to, hr_api.g_eot) >= date_from);
558:
559: cursor csr_upd_name is
560: select null from per_competence_outcomes
561: where outcome_id <> p_outcome_id
560: select null from per_competence_outcomes
561: where outcome_id <> p_outcome_id
562: and competence_id = p_competence_id
563: and name = p_name
564: and (p_date_from <= nvl(date_to, hr_api.g_eot)
565: and NVL(p_date_to, hr_api.g_eot) >= date_from);
566:
567: --
568: -- Declare local variables
561: where outcome_id <> p_outcome_id
562: and competence_id = p_competence_id
563: and name = p_name
564: and (p_date_from <= nvl(date_to, hr_api.g_eot)
565: and NVL(p_date_to, hr_api.g_eot) >= date_from);
566:
567: --
568: -- Declare local variables
569: --
576: --
577: -- Check mandatory parameters have been set
578: --
579:
580: hr_api.mandatory_arg_error
581: (p_api_name => l_proc
582: ,p_argument => 'name'
583: ,p_argument_value => p_name
584: );
597:
598: if (l_api_updating and
599: per_cpo_shd.g_old_rec.name <> p_name or
600: per_cpo_shd.g_old_rec.date_from <> p_date_from or
601: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
602: nvl(p_date_to,hr_api.g_eot))
603: then
604: --
605: -- Check that outcome_number is unique
598: if (l_api_updating and
599: per_cpo_shd.g_old_rec.name <> p_name or
600: per_cpo_shd.g_old_rec.date_from <> p_date_from or
601: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
602: nvl(p_date_to,hr_api.g_eot))
603: then
604: --
605: -- Check that outcome_number is unique
606: --
677: --
678: -- Check mandatory parameters have been set
679: --
680:
681: hr_api.mandatory_arg_error
682: (p_api_name => l_proc
683: ,p_argument => 'date_from'
684: ,p_argument_value => p_date_from
685: );
693: (p_outcome_id => p_outcome_id
694: ,p_object_version_number => p_object_version_number);
695: --
696: if (((l_api_updating and
697: (nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
698: nvl(p_date_to,hr_api.g_eot)) or
699: (per_cpo_shd.g_old_rec.date_from <> p_date_from)) or
700: (NOT l_api_updating))) then
701: --
694: ,p_object_version_number => p_object_version_number);
695: --
696: if (((l_api_updating and
697: (nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
698: nvl(p_date_to,hr_api.g_eot)) or
699: (per_cpo_shd.g_old_rec.date_from <> p_date_from)) or
700: (NOT l_api_updating))) then
701: --
702: -- Check that date_from <= date_to
702: -- Check that date_from <= date_to
703: --
704: hr_utility.set_location(l_proc, 30);
705: --
706: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
707: hr_utility.set_message(800,'HR_6758_APPL_DATE_FROM_CHK');
708: hr_utility.raise_error;
709: end if;
710: --
815: begin
816: hr_utility.set_location('Entering:'||l_proc,10);
817: --
818: if ((p_rec.outcome_id is not null) and (
819: nvl(per_cpo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
820: nvl(p_rec.information_category, hr_api.g_varchar2) or
821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
816: hr_utility.set_location('Entering:'||l_proc,10);
817: --
818: if ((p_rec.outcome_id is not null) and (
819: nvl(per_cpo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
820: nvl(p_rec.information_category, hr_api.g_varchar2) or
821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
817: --
818: if ((p_rec.outcome_id is not null) and (
819: nvl(per_cpo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
820: nvl(p_rec.information_category, hr_api.g_varchar2) or
821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
818: if ((p_rec.outcome_id is not null) and (
819: nvl(per_cpo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
820: nvl(p_rec.information_category, hr_api.g_varchar2) or
821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
819: nvl(per_cpo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
820: nvl(p_rec.information_category, hr_api.g_varchar2) or
821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
820: nvl(p_rec.information_category, hr_api.g_varchar2) or
821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_cpo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_cpo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) ))
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_cpo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) ))
859: or (p_rec.outcome_id is null) then
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_cpo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) ))
859: or (p_rec.outcome_id is null) then
860: --
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_cpo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) ))
859: or (p_rec.outcome_id is null) then
860: --
861: -- Only execute the validation if absolutely necessary:
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_cpo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) ))
859: or (p_rec.outcome_id is null) then
860: --
861: -- Only execute the validation if absolutely necessary:
862: -- a) During update, the structure column value or any
950: begin
951: hr_utility.set_location('Entering:'||l_proc,10);
952: --
953: if ((p_rec.outcome_id is not null) and (
954: nvl(per_cpo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute1, hr_api.g_varchar2) or
956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
951: hr_utility.set_location('Entering:'||l_proc,10);
952: --
953: if ((p_rec.outcome_id is not null) and (
954: nvl(per_cpo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute1, hr_api.g_varchar2) or
956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
952: --
953: if ((p_rec.outcome_id is not null) and (
954: nvl(per_cpo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute1, hr_api.g_varchar2) or
956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
953: if ((p_rec.outcome_id is not null) and (
954: nvl(per_cpo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute1, hr_api.g_varchar2) or
956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
954: nvl(per_cpo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute1, hr_api.g_varchar2) or
956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute1, hr_api.g_varchar2) or
956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute19, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute19, hr_api.g_varchar2) or
992: nvl(per_cpo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute19, hr_api.g_varchar2) or
992: nvl(per_cpo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute19, hr_api.g_varchar2) or
992: nvl(per_cpo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
994: or (p_rec.outcome_id is null) then
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute19, hr_api.g_varchar2) or
992: nvl(per_cpo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
994: or (p_rec.outcome_id is null) then
995: --
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute19, hr_api.g_varchar2) or
992: nvl(per_cpo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
994: or (p_rec.outcome_id is null) then
995: --
996: -- Only execute the validation if absolutely necessary:
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute19, hr_api.g_varchar2) or
992: nvl(per_cpo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
994: or (p_rec.outcome_id is null) then
995: --
996: -- Only execute the validation if absolutely necessary:
997: -- a) During update, the structure column value or any