eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CPO_BUS dependencies on HR_API

Line 46: hr_api.mandatory_arg_error

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: );

Line 73: hr_api.set_security_group_id

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

Line 79: hr_api.set_legislation_context(l_legislation_code);

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: --

Line 114: hr_api.mandatory_arg_error

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: );

Line 120: if ( nvl(per_cpo_bus.g_outcome_id, hr_api.g_number)

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

Line 255: and nvl(p_outcome_id,hr_api.g_number)

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: --

Line 336: hr_api.mandatory_arg_error

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: );

Line 427: and (p_date_from <= nvl(date_to, hr_api.g_eot)

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

Line 428: and NVL(p_date_to, hr_api.g_eot) >= date_from);

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

Line 435: and (p_date_from <= nvl(date_to, hr_api.g_eot)

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

Line 436: and NVL(p_date_to, hr_api.g_eot) >= date_from);

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: --

Line 456: hr_api.mandatory_arg_error

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: );

Line 477: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>

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

Line 478: nvl(p_date_to,hr_api.g_eot)))

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: --

Line 556: and (p_date_from <= nvl(date_to, hr_api.g_eot)

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

Line 557: and NVL(p_date_to, hr_api.g_eot) >= date_from);

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

Line 564: and (p_date_from <= nvl(date_to, hr_api.g_eot)

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

Line 565: and NVL(p_date_to, hr_api.g_eot) >= date_from);

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: --

Line 580: hr_api.mandatory_arg_error

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: );

Line 601: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>

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

Line 602: nvl(p_date_to,hr_api.g_eot))

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: --

Line 681: hr_api.mandatory_arg_error

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: );

Line 697: (nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>

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: --

Line 698: nvl(p_date_to,hr_api.g_eot)) or

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

Line 706: if p_date_from > nvl(p_date_to,hr_api.g_eot) then

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: --

Line 819: nvl(per_cpo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

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) <>

Line 820: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

Line 821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>

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) <>

Line 822: nvl(p_rec.information1, hr_api.g_varchar2) or

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

Line 823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>

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) <>

Line 824: nvl(p_rec.information2, hr_api.g_varchar2) or

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

Line 825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>

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) <>

Line 826: nvl(p_rec.information3, hr_api.g_varchar2) or

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

Line 827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>

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) <>

Line 828: nvl(p_rec.information4, hr_api.g_varchar2) or

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

Line 829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>

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) <>

Line 830: nvl(p_rec.information5, hr_api.g_varchar2) or

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

Line 831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>

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) <>

Line 832: nvl(p_rec.information6, hr_api.g_varchar2) or

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

Line 833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>

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) <>

Line 834: nvl(p_rec.information7, hr_api.g_varchar2) or

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

Line 835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>

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) <>

Line 836: nvl(p_rec.information8, hr_api.g_varchar2) or

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

Line 837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>

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) <>

Line 838: nvl(p_rec.information9, hr_api.g_varchar2) or

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

Line 839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>

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) <>

Line 840: nvl(p_rec.information10, hr_api.g_varchar2) or

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

Line 841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>

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) <>

Line 842: nvl(p_rec.information11, hr_api.g_varchar2) or

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

Line 843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>

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) <>

Line 844: nvl(p_rec.information13, hr_api.g_varchar2) or

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

Line 845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>

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) <>

Line 846: nvl(p_rec.information14, hr_api.g_varchar2) or

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

Line 847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>

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) <>

Line 848: nvl(p_rec.information15, hr_api.g_varchar2) or

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

Line 849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>

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) <>

Line 850: nvl(p_rec.information16, hr_api.g_varchar2) or

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

Line 851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>

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) <>

Line 852: nvl(p_rec.information17, hr_api.g_varchar2) or

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

Line 853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>

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) <>

Line 854: nvl(p_rec.information18, hr_api.g_varchar2) or

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) ))

Line 855: nvl(per_cpo_shd.g_old_rec.information19, 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

Line 856: nvl(p_rec.information19, hr_api.g_varchar2) or

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: --

Line 857: nvl(per_cpo_shd.g_old_rec.information20, hr_api.g_varchar2) <>

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:

Line 858: nvl(p_rec.information20, 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:
862: -- a) During update, the structure column value or any

Line 954: nvl(per_cpo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

Line 955: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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

Line 956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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) <>

Line 957: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

Line 958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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) <>

Line 959: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

Line 960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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) <>

Line 961: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

Line 962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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) <>

Line 963: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

Line 964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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) <>

Line 965: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

Line 966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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) <>

Line 967: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

Line 968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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) <>

Line 969: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

Line 970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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) <>

Line 971: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

Line 972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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) <>

Line 973: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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

Line 974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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) <>

Line 975: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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

Line 976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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) <>

Line 977: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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

Line 978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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) <>

Line 979: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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

Line 980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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) <>

Line 981: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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

Line 982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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) <>

Line 983: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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

Line 984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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) <>

Line 985: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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

Line 986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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) <>

Line 987: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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

Line 988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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) <>

Line 989: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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) ))

Line 990: nvl(per_cpo_shd.g_old_rec.attribute19, 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

Line 991: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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: --

Line 992: nvl(per_cpo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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:

Line 993: nvl(p_rec.attribute20, 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:
997: -- a) During update, the structure column value or any