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_CEO_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 => 'comp_element_outcome_id'
49: ,p_argument_value => p_comp_element_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 => 'comp_element_outcome_id'
117: ,p_argument_value => p_comp_element_outcome_id
118: );

Line 120: if ( nvl(per_ceo_bus.g_comp_element_outcome_id, hr_api.g_number)

116: ,p_argument => 'comp_element_outcome_id'
117: ,p_argument_value => p_comp_element_outcome_id
118: );
119: --
120: if ( nvl(per_ceo_bus.g_comp_element_outcome_id, hr_api.g_number)
121: = p_comp_element_outcome_id) then
122: --
123: -- The legislation code has already been found with a previous
124: -- call to this function. Just return the value in the global

Line 256: and nvl(p_comp_element_outcome_id,hr_api.g_number)

252: ,p_object_version_number => p_object_version_number
253: );
254: --
255: if (l_api_updating
256: and nvl(p_comp_element_outcome_id,hr_api.g_number)
257: <> per_ceo_shd.g_old_rec.comp_element_outcome_id) then
258: --
259: -- raise error as PK has changed
260: --

Line 337: hr_api.mandatory_arg_error

333: --
334: -- Check mandatory parameters have been set
335: --
336:
337: hr_api.mandatory_arg_error
338: (p_api_name => l_proc
339: ,p_argument => 'competence_element_id'
340: ,p_argument_value => p_competence_element_id
341: );

Line 439: hr_api.mandatory_arg_error

435: --
436: -- Check mandatory parameters have been set
437: --
438:
439: hr_api.mandatory_arg_error
440: (p_api_name => l_proc
441: ,p_argument => 'outcome_id'
442: ,p_argument_value => p_outcome_id
443: );

Line 531: and p_date_from < nvl(o.date_to,hr_api.g_eot)

527: cursor csr_uniq_comp_element_outcome is
528: select 'x' from per_comp_element_outcomes o
529: where o.competence_element_id = p_competence_element_id
530: and o.outcome_id = p_outcome_id
531: and p_date_from < nvl(o.date_to,hr_api.g_eot)
532: and nvl(p_date_to,hr_api.g_eot) > o.date_from;
533:
534: /* cursor csr_upd_uniq_comp_ele_outcome is
535: select 'x' from per_comp_element_outcomes o

Line 532: and nvl(p_date_to,hr_api.g_eot) > o.date_from;

528: select 'x' from per_comp_element_outcomes o
529: where o.competence_element_id = p_competence_element_id
530: and o.outcome_id = p_outcome_id
531: and p_date_from < nvl(o.date_to,hr_api.g_eot)
532: and nvl(p_date_to,hr_api.g_eot) > o.date_from;
533:
534: /* cursor csr_upd_uniq_comp_ele_outcome is
535: select 'x' from per_comp_element_outcomes o
536: where o.comp_element_outcome_id = p_comp_element_outcome_id

Line 539: and p_date_from < nvl(o.date_to,hr_api.g_eot)

535: select 'x' from per_comp_element_outcomes o
536: where o.comp_element_outcome_id = p_comp_element_outcome_id
537: and o.competence_element_id = p_competence_element_id
538: and o.outcome_id = p_outcome_id
539: and p_date_from < nvl(o.date_to,hr_api.g_eot)
540: and nvl(p_date_to,hr_api.g_eot) > o.date_from;*/
541:
542: l_outcome_name per_competence_outcomes.name%type;
543:

Line 540: and nvl(p_date_to,hr_api.g_eot) > o.date_from;*/

536: where o.comp_element_outcome_id = p_comp_element_outcome_id
537: and o.competence_element_id = p_competence_element_id
538: and o.outcome_id = p_outcome_id
539: and p_date_from < nvl(o.date_to,hr_api.g_eot)
540: and nvl(p_date_to,hr_api.g_eot) > o.date_from;*/
541:
542: l_outcome_name per_competence_outcomes.name%type;
543:
544: cursor csr_upd_uniq_comp_ele_outcome(p_name per_competence_outcomes.name%type)is

Line 550: and(p_date_from between o.date_from and nvl(o.date_to,hr_api.g_eot)

546: where o.comp_element_outcome_id <> p_comp_element_outcome_id
547: and o.competence_element_id = p_competence_element_id
548: and co.outcome_id = o.outcome_id
549: and co.name = p_name
550: and(p_date_from between o.date_from and nvl(o.date_to,hr_api.g_eot)
551: or p_date_to between o.date_from and nvl(o.date_to,hr_api.g_eot)
552: or o.date_from between p_date_from and p_date_to );
553:
554:

Line 551: or p_date_to between o.date_from and nvl(o.date_to,hr_api.g_eot)

547: and o.competence_element_id = p_competence_element_id
548: and co.outcome_id = o.outcome_id
549: and co.name = p_name
550: and(p_date_from between o.date_from and nvl(o.date_to,hr_api.g_eot)
551: or p_date_to between o.date_from and nvl(o.date_to,hr_api.g_eot)
552: or o.date_from between p_date_from and p_date_to );
553:
554:
555: --

Line 580: nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>

576: (per_ceo_shd.g_old_rec.competence_element_id <>
577: p_competence_element_id or
578: per_ceo_shd.g_old_rec.outcome_id <> p_outcome_id or
579: per_ceo_shd.g_old_rec.date_from <> p_date_from or
580: nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
581: nvl(p_date_to,hr_api.g_eot))) then
582: --
583: -- Check that a combination is unique
584: --

Line 581: nvl(p_date_to,hr_api.g_eot))) then

577: p_competence_element_id or
578: per_ceo_shd.g_old_rec.outcome_id <> p_outcome_id or
579: per_ceo_shd.g_old_rec.date_from <> p_date_from or
580: nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
581: nvl(p_date_to,hr_api.g_eot))) then
582: --
583: -- Check that a combination is unique
584: --
585:

Line 683: hr_api.mandatory_arg_error

679: --
680: -- Check mandatory parameters have been set
681: --
682:
683: hr_api.mandatory_arg_error
684: (p_api_name => l_proc
685: ,p_argument => 'date_from'
686: ,p_argument_value => p_date_from
687: );

Line 699: (nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>

695: (p_comp_element_outcome_id => p_comp_element_outcome_id
696: ,p_object_version_number => p_object_version_number);
697: --
698: if (((l_api_updating and
699: (nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
700: nvl(p_date_to,hr_api.g_eot)) or
701: (per_ceo_shd.g_old_rec.date_from <> p_date_from)) or
702: (NOT l_api_updating))) then
703: --

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

696: ,p_object_version_number => p_object_version_number);
697: --
698: if (((l_api_updating and
699: (nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
700: nvl(p_date_to,hr_api.g_eot)) or
701: (per_ceo_shd.g_old_rec.date_from <> p_date_from)) or
702: (NOT l_api_updating))) then
703: --
704: -- Check that date_from <= date_to

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

704: -- Check that date_from <= date_to
705: --
706: hr_utility.set_location(l_proc, 30);
707: --
708: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
709: hr_utility.set_message(800,'HR_6758_APPL_DATE_FROM_CHK');
710: hr_multi_message.add
711: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
712: hr_utility.raise_error;

Line 724: if p_date_from < nvl( l_outcome_active_date,hr_api.g_eot) then

720: open csr_get_outcome_active_date ;
721: fetch csr_get_outcome_active_date into l_outcome_active_date;
722: close csr_get_outcome_active_date;
723:
724: if p_date_from < nvl( l_outcome_active_date,hr_api.g_eot) then
725: hr_utility.set_message(800,'HR_34724_COMP_OUTCME_DATE_INVL');
726: hr_multi_message.add
727: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
728: hr_utility.raise_error;

Line 775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

771: begin
772: hr_utility.set_location('Entering:'||l_proc,10);
773: --
774: if ((p_rec.comp_element_outcome_id is not null) and (
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>

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

772: hr_utility.set_location('Entering:'||l_proc,10);
773: --
774: if ((p_rec.comp_element_outcome_id is not null) and (
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>

773: --
774: if ((p_rec.comp_element_outcome_id is not null) and (
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>

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

774: if ((p_rec.comp_element_outcome_id is not null) and (
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>

775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>

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

776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>

777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>

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

778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>

779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>

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

780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>

781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>

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

782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>

783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>

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

784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>

785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>

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

786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>

787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>

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

788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>

789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>

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

790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>

791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>

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

792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>

793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>

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

794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>

795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>

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

796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>

797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>

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

798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>

799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>

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

800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>

801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>

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

802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>

803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>

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

804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>

805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>

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

806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))

Line 811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>

807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))
815: or (p_rec.comp_element_outcome_id is null) then

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

808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))
815: or (p_rec.comp_element_outcome_id is null) then
816: --

Line 813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>

809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))
815: or (p_rec.comp_element_outcome_id is null) then
816: --
817: -- Only execute the validation if absolutely necessary:

Line 814: nvl(p_rec.information20, hr_api.g_varchar2) ))

810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))
815: or (p_rec.comp_element_outcome_id is null) then
816: --
817: -- Only execute the validation if absolutely necessary:
818: -- a) During update, the structure column value or any

Line 910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

906: begin
907: hr_utility.set_location('Entering:'||l_proc,10);
908: --
909: if ((p_rec.comp_element_outcome_id is not null) and (
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

907: hr_utility.set_location('Entering:'||l_proc,10);
908: --
909: if ((p_rec.comp_element_outcome_id is not null) and (
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

908: --
909: if ((p_rec.comp_element_outcome_id is not null) and (
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

909: if ((p_rec.comp_element_outcome_id is not null) and (
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
950: or (p_rec.comp_element_outcome_id is null) then

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

943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
950: or (p_rec.comp_element_outcome_id is null) then
951: --

Line 948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
950: or (p_rec.comp_element_outcome_id is null) then
951: --
952: -- Only execute the validation if absolutely necessary:

Line 949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
950: or (p_rec.comp_element_outcome_id is null) then
951: --
952: -- Only execute the validation if absolutely necessary:
953: -- a) During update, the structure column value or any

Line 1209: and nvl(date_to,hr_api.g_eot);

1205: cursor csr_get_outcome_number is
1206: select count(cpo.outcome_id) from per_competence_outcomes cpo
1207: where cpo.competence_id = p_competence_id
1208: and p_effective_date between date_from
1209: and nvl(date_to,hr_api.g_eot);
1210:
1211: cursor csr_get_achieved_number is
1212: select count(ceo.comp_element_outcome_id)
1213: ,max(ceo.date_from)

Line 1217: -- and nvl(date_to,hr_api.g_eot)

1213: ,max(ceo.date_from)
1214: from per_comp_element_outcomes ceo
1215: where ceo.competence_element_id = p_competence_element_id
1216: -- and p_effective_date between ceo.date_from
1217: -- and nvl(date_to,hr_api.g_eot)
1218: and ceo.outcome_id in (
1219: select cpo2.outcome_id from per_competence_outcomes cpo2
1220: where cpo2.competence_id = p_competence_id
1221: and p_effective_date between cpo2.date_from

Line 1222: and nvl(cpo2.date_to,hr_api.g_eot));

1218: and ceo.outcome_id in (
1219: select cpo2.outcome_id from per_competence_outcomes cpo2
1220: where cpo2.competence_id = p_competence_id
1221: and p_effective_date between cpo2.date_from
1222: and nvl(cpo2.date_to,hr_api.g_eot));
1223:
1224: --
1225: --
1226: l_proc varchar2(72) := g_package||'check_outcome_achieved';