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_GRD_BUS dependencies on PER_GRD_SHD

Line 445: l_api_updating := per_grd_shd.api_updating

441: Begin
442: --
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: l_api_updating := per_grd_shd.api_updating
446: (p_grade_id => p_grade_id,
447: p_object_version_number => p_object_version_number
448: );
449: --

Line 452: <> per_grd_shd.g_old_rec.grade_id) then

448: );
449: --
450: if (l_api_updating
451: and nvl(p_grade_id,hr_api.g_number)
452: <> per_grd_shd.g_old_rec.grade_id) then
453: --
454: -- raise error as PK has changed
455: --
456: per_grd_shd.constraint_error('PER_GRADES_PK');

Line 456: per_grd_shd.constraint_error('PER_GRADES_PK');

452: <> per_grd_shd.g_old_rec.grade_id) then
453: --
454: -- raise error as PK has changed
455: --
456: per_grd_shd.constraint_error('PER_GRADES_PK');
457: --
458: elsif not l_api_updating then
459: --
460: -- check if PK is null

Line 466: per_grd_shd.constraint_error('PER_GRADES_PK');

462: if p_grade_id is not null then
463: --
464: -- raise error as PK is not null
465: --
466: per_grd_shd.constraint_error('PER_GRADES_PK');
467: --
468: end if;
469: --
470: end if;

Line 542: l_api_updating := per_grd_shd.api_updating

538: --
539: -- If Grade Ladder implementation exists and short_name
540: -- isn't specified, a warning message should appear.
541: --
542: l_api_updating := per_grd_shd.api_updating
543: (p_grade_id => p_grade_id,
544: p_object_version_number => p_object_version_number
545: );
546: --

Line 550: ((p_short_name is not null and per_grd_shd.g_old_rec.short_name is null)

546: --
547: hr_utility.set_location(l_proc, 20);
548: --
549: if (l_api_updating and
550: ((p_short_name is not null and per_grd_shd.g_old_rec.short_name is null)
551: or (per_grd_shd.g_old_rec.short_name <> p_short_name))) then
552:
553: hr_utility.set_location(l_proc, 30);
554: --

Line 551: or (per_grd_shd.g_old_rec.short_name <> p_short_name))) then

547: hr_utility.set_location(l_proc, 20);
548: --
549: if (l_api_updating and
550: ((p_short_name is not null and per_grd_shd.g_old_rec.short_name is null)
551: or (per_grd_shd.g_old_rec.short_name <> p_short_name))) then
552:
553: hr_utility.set_location(l_proc, 30);
554: --
555: open csr_update_short_name;

Line 651: l_api_updating := per_grd_shd.api_updating

647: );
648: --
649: hr_utility.set_location(l_proc, 2);
650: --
651: l_api_updating := per_grd_shd.api_updating
652: (p_grade_id => p_grade_id
653: ,p_object_version_number => p_object_version_number);
654: --
655: hr_utility.set_location(l_proc, 3);

Line 658: (per_grd_shd.g_old_rec.grade_definition_id <>

654: --
655: hr_utility.set_location(l_proc, 3);
656: --
657: if ((l_api_updating and
658: (per_grd_shd.g_old_rec.grade_definition_id <>
659: p_grade_definition_id)) or (NOT l_api_updating)) then
660: --
661: hr_utility.set_location(l_proc, 4);
662: --

Line 667: per_grd_shd.constraint_error(p_constraint_name => 'PER_GRADES_FK2');

663: open csr_grade_def;
664: fetch csr_grade_def into l_exists;
665: if csr_grade_def%notfound then
666: close csr_grade_def;
667: per_grd_shd.constraint_error(p_constraint_name => 'PER_GRADES_FK2');
668: end if;
669: close csr_grade_def;
670: --
671: hr_utility.set_location(l_proc, 5);

Line 747: l_api_updating := per_grd_shd.api_updating

743: -- Only proceed with validation if :
744: -- a) The current g_old_rec is current and
745: -- b) The date_end value has changed
746: --
747: l_api_updating := per_grd_shd.api_updating
748: (p_grade_id => p_grade_id
749: ,p_object_version_number => p_object_version_number);
750: --
751: if (((l_api_updating and

Line 752: (nvl(per_grd_shd.g_old_rec.date_to,hr_api.g_eot) <>

748: (p_grade_id => p_grade_id
749: ,p_object_version_number => p_object_version_number);
750: --
751: if (((l_api_updating and
752: (nvl(per_grd_shd.g_old_rec.date_to,hr_api.g_eot) <>
753: nvl(p_date_to,hr_api.g_eot)) or
754: (per_grd_shd.g_old_rec.date_from <> p_date_from)) or
755: (NOT l_api_updating))) then
756: --

Line 754: (per_grd_shd.g_old_rec.date_from <> p_date_from)) or

750: --
751: if (((l_api_updating and
752: (nvl(per_grd_shd.g_old_rec.date_to,hr_api.g_eot) <>
753: nvl(p_date_to,hr_api.g_eot)) or
754: (per_grd_shd.g_old_rec.date_from <> p_date_from)) or
755: (NOT l_api_updating))) then
756: --
757: -- Check that date_from <= date_to
758: --

Line 878: (p_rec in per_grd_shd.g_rec_type

874: -- Internal Row Handler Use Only.
875: --
876: -- ----------------------------------------------------------------------------
877: procedure chk_ddf
878: (p_rec in per_grd_shd.g_rec_type
879: ) is
880: --
881: l_proc varchar2(72) := g_package || 'chk_ddf';
882: --

Line 887: nvl(per_grd_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

883: begin
884: hr_utility.set_location('Entering:'||l_proc,10);
885: --
886: if ((p_rec.grade_id is not null) and (
887: nvl(per_grd_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
888: nvl(p_rec.information_category, hr_api.g_varchar2) or
889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>
890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>

885: --
886: if ((p_rec.grade_id is not null) and (
887: nvl(per_grd_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
888: nvl(p_rec.information_category, hr_api.g_varchar2) or
889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>
890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>

887: nvl(per_grd_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
888: nvl(p_rec.information_category, hr_api.g_varchar2) or
889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>
890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>

889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>
890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>

891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>

893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>

895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>

897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>

899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>

901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>

903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>

905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>

907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>

909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>

911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>

913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>

915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>

917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>

919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>
926: nvl(p_rec.information19, hr_api.g_varchar2) or
927: nvl(per_grd_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>

921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>
926: nvl(p_rec.information19, hr_api.g_varchar2) or
927: nvl(per_grd_shd.g_old_rec.information20, hr_api.g_varchar2) <>
928: nvl(p_rec.information20, hr_api.g_varchar2) ))
929: or (p_rec.grade_id is null) then

Line 927: nvl(per_grd_shd.g_old_rec.information20, hr_api.g_varchar2) <>

923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>
926: nvl(p_rec.information19, hr_api.g_varchar2) or
927: nvl(per_grd_shd.g_old_rec.information20, hr_api.g_varchar2) <>
928: nvl(p_rec.information20, hr_api.g_varchar2) ))
929: or (p_rec.grade_id is null) then
930: --
931: -- Only execute the validation if absolutely necessary:

Line 1015: (p_rec in per_grd_shd.g_rec_type

1011: -- Internal Row Handler Use Only.
1012: --
1013: -- ----------------------------------------------------------------------------
1014: procedure chk_df
1015: (p_rec in per_grd_shd.g_rec_type
1016: ) is
1017: --
1018: l_proc varchar2(72) := g_package || 'chk_df';
1019: --

Line 1024: nvl(per_grd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1020: begin
1021: hr_utility.set_location('Entering:'||l_proc,10);
1022: --
1023: if ((p_rec.grade_id is not null) and (
1024: nvl(per_grd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1025: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1022: --
1023: if ((p_rec.grade_id is not null) and (
1024: nvl(per_grd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1025: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1024: nvl(per_grd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1025: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1063: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1064: nvl(per_grd_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1063: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1064: nvl(per_grd_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1065: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1066: or (p_rec.grade_id is null) then

Line 1064: nvl(per_grd_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1063: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1064: nvl(per_grd_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1065: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1066: or (p_rec.grade_id is null) then
1067: --
1068: -- Only execute the validation if absolutely necessary:

Line 1152: ,p_rec in per_grd_shd.g_rec_type

1148: -- {End Of Comments}
1149: -- ----------------------------------------------------------------------------
1150: Procedure chk_non_updateable_args
1151: (p_effective_date in date
1152: ,p_rec in per_grd_shd.g_rec_type
1153: ) IS
1154: --
1155: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1156: --

Line 1162: IF NOT per_grd_shd.api_updating

1158: --
1159: -- Only proceed with the validation if a row exists for the current
1160: -- record in the HR Schema.
1161: --
1162: IF NOT per_grd_shd.api_updating
1163: (p_grade_id => p_rec.grade_id
1164: ,p_object_version_number => p_rec.object_version_number
1165: ) THEN
1166: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1182: ,p_rec in per_grd_shd.g_rec_type

1178: -- |---------------------------< insert_validate >----------------------------|
1179: -- ----------------------------------------------------------------------------
1180: Procedure insert_validate
1181: (p_effective_date in date
1182: ,p_rec in per_grd_shd.g_rec_type
1183: ) is
1184: --
1185: l_proc varchar2(72) := g_package||'insert_validate';
1186: --

Line 1194: ,p_associated_column1 => per_grd_shd.g_tab_nam

1190: -- Call all supporting business operations
1191: --
1192: hr_api.validate_bus_grp_id
1193: (p_business_group_id => p_rec.business_group_id
1194: ,p_associated_column1 => per_grd_shd.g_tab_nam
1195: || '.BUSINESS_GROUP_ID');
1196: --
1197: chk_grade_id
1198: (p_grade_id => p_rec.grade_id

Line 1261: ,p_rec in per_grd_shd.g_rec_type

1257: -- |---------------------------< update_validate >----------------------------|
1258: -- ----------------------------------------------------------------------------
1259: Procedure update_validate
1260: (p_effective_date in date
1261: ,p_rec in per_grd_shd.g_rec_type
1262: ) is
1263: --
1264: l_proc varchar2(72) := g_package||'update_validate';
1265: --

Line 1273: -- ,p_associated_column1 => per_grd_shd.g_tab_nam

1269: -- Call all supporting business operations
1270: --
1271: -- hr_api.validate_bus_grp_id
1272: -- (p_business_group_id => p_rec.business_group_id
1273: -- ,p_associated_column1 => per_grd_shd.g_tab_nam
1274: -- || '.BUSINESS_GROUP_ID');
1275: --
1276: chk_grade_id
1277: (p_grade_id => p_rec.grade_id

Line 1352: (p_rec in per_grd_shd.g_rec_type

1348: -- ----------------------------------------------------------------------------
1349: -- |---------------------------< delete_validate >----------------------------|
1350: -- ----------------------------------------------------------------------------
1351: Procedure delete_validate
1352: (p_rec in per_grd_shd.g_rec_type
1353: ) is
1354: --
1355: l_proc varchar2(72) := g_package||'delete_validate';
1356: --