[Home] [Help]
311: -- 2) updating and value has changed
312: --
313: if ((p_disability_id is null) or
314: ((p_disability_id is not null) and
315: (per_dis_shd.g_old_rec.incident_id <> p_incident_id))) then
316: --
317: hr_utility.set_location(l_proc, 3);
318:
319: if p_incident_id is not null then
434: -- 2) updating and value has changed
435: --
436: if ((p_disability_id is null) or
437: ((p_disability_id is not null) and
438: (per_dis_shd.g_old_rec.category <> p_category))) then
439: --
440: hr_utility.set_location(l_proc, 30);
441: --
442: if hr_api.not_exists_in_dt_leg_lookups
536: -- 2) updating and value has changed
537: --
538: if ((p_disability_id is null) or
539: ((p_disability_id is not null) and
540: (per_dis_shd.g_old_rec.status <> p_status))) then
541: --
542: hr_utility.set_location(l_proc, 30);
543: --
544: if hr_api.not_exists_in_dt_leg_lookups
685: -- 2) updating and value has changed
686: --
687: if ((p_disability_id is null) or
688: ((p_disability_id is not null) and
689: (per_dis_shd.g_old_rec.reason <> p_reason))) then
690: --
691: hr_utility.set_location(l_proc, 30);
692: --
693: if hr_api.not_exists_in_dt_leg_lookups
837: -- 2) updating and value has changed
838: --
839: if ((p_disability_id is null) or
840: ((p_disability_id is not null) and
841: (per_dis_shd.g_old_rec.organization_id <> p_organization_id))) then
842: --
843: hr_utility.set_location(l_proc, 30);
844: --
845: -- check org exists in hr_all_organization_units (fk) for the persons bg
981: -- Internal Row Handler Use Only.
982: --
983: -- ----------------------------------------------------------------------------
984: procedure chk_ddf
985: (p_rec in per_dis_shd.g_rec_type
986: ) is
987: --
988: l_proc varchar2(72) := g_package || 'chk_ddf';
989: --
990: begin
991: hr_utility.set_location('Entering:'||l_proc,10);
992: --
993: if ((p_rec.disability_id is not null) and (
994: nvl(per_dis_shd.g_old_rec.dis_information_category, hr_api.g_varchar2) <>
995: nvl(p_rec.dis_information_category, hr_api.g_varchar2) or
996: nvl(per_dis_shd.g_old_rec.dis_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.dis_information1, hr_api.g_varchar2) or
998: nvl(per_dis_shd.g_old_rec.dis_information2, hr_api.g_varchar2) <>
992: --
993: if ((p_rec.disability_id is not null) and (
994: nvl(per_dis_shd.g_old_rec.dis_information_category, hr_api.g_varchar2) <>
995: nvl(p_rec.dis_information_category, hr_api.g_varchar2) or
996: nvl(per_dis_shd.g_old_rec.dis_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.dis_information1, hr_api.g_varchar2) or
998: nvl(per_dis_shd.g_old_rec.dis_information2, hr_api.g_varchar2) <>
999: nvl(p_rec.dis_information2, hr_api.g_varchar2) or
1000: nvl(per_dis_shd.g_old_rec.dis_information3, hr_api.g_varchar2) <>
994: nvl(per_dis_shd.g_old_rec.dis_information_category, hr_api.g_varchar2) <>
995: nvl(p_rec.dis_information_category, hr_api.g_varchar2) or
996: nvl(per_dis_shd.g_old_rec.dis_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.dis_information1, hr_api.g_varchar2) or
998: nvl(per_dis_shd.g_old_rec.dis_information2, hr_api.g_varchar2) <>
999: nvl(p_rec.dis_information2, hr_api.g_varchar2) or
1000: nvl(per_dis_shd.g_old_rec.dis_information3, hr_api.g_varchar2) <>
1001: nvl(p_rec.dis_information3, hr_api.g_varchar2) or
1002: nvl(per_dis_shd.g_old_rec.dis_information4, hr_api.g_varchar2) <>
996: nvl(per_dis_shd.g_old_rec.dis_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.dis_information1, hr_api.g_varchar2) or
998: nvl(per_dis_shd.g_old_rec.dis_information2, hr_api.g_varchar2) <>
999: nvl(p_rec.dis_information2, hr_api.g_varchar2) or
1000: nvl(per_dis_shd.g_old_rec.dis_information3, hr_api.g_varchar2) <>
1001: nvl(p_rec.dis_information3, hr_api.g_varchar2) or
1002: nvl(per_dis_shd.g_old_rec.dis_information4, hr_api.g_varchar2) <>
1003: nvl(p_rec.dis_information4, hr_api.g_varchar2) or
1004: nvl(per_dis_shd.g_old_rec.dis_information5, hr_api.g_varchar2) <>
998: nvl(per_dis_shd.g_old_rec.dis_information2, hr_api.g_varchar2) <>
999: nvl(p_rec.dis_information2, hr_api.g_varchar2) or
1000: nvl(per_dis_shd.g_old_rec.dis_information3, hr_api.g_varchar2) <>
1001: nvl(p_rec.dis_information3, hr_api.g_varchar2) or
1002: nvl(per_dis_shd.g_old_rec.dis_information4, hr_api.g_varchar2) <>
1003: nvl(p_rec.dis_information4, hr_api.g_varchar2) or
1004: nvl(per_dis_shd.g_old_rec.dis_information5, hr_api.g_varchar2) <>
1005: nvl(p_rec.dis_information5, hr_api.g_varchar2) or
1006: nvl(per_dis_shd.g_old_rec.dis_information6, hr_api.g_varchar2) <>
1000: nvl(per_dis_shd.g_old_rec.dis_information3, hr_api.g_varchar2) <>
1001: nvl(p_rec.dis_information3, hr_api.g_varchar2) or
1002: nvl(per_dis_shd.g_old_rec.dis_information4, hr_api.g_varchar2) <>
1003: nvl(p_rec.dis_information4, hr_api.g_varchar2) or
1004: nvl(per_dis_shd.g_old_rec.dis_information5, hr_api.g_varchar2) <>
1005: nvl(p_rec.dis_information5, hr_api.g_varchar2) or
1006: nvl(per_dis_shd.g_old_rec.dis_information6, hr_api.g_varchar2) <>
1007: nvl(p_rec.dis_information6, hr_api.g_varchar2) or
1008: nvl(per_dis_shd.g_old_rec.dis_information7, hr_api.g_varchar2) <>
1002: nvl(per_dis_shd.g_old_rec.dis_information4, hr_api.g_varchar2) <>
1003: nvl(p_rec.dis_information4, hr_api.g_varchar2) or
1004: nvl(per_dis_shd.g_old_rec.dis_information5, hr_api.g_varchar2) <>
1005: nvl(p_rec.dis_information5, hr_api.g_varchar2) or
1006: nvl(per_dis_shd.g_old_rec.dis_information6, hr_api.g_varchar2) <>
1007: nvl(p_rec.dis_information6, hr_api.g_varchar2) or
1008: nvl(per_dis_shd.g_old_rec.dis_information7, hr_api.g_varchar2) <>
1009: nvl(p_rec.dis_information7, hr_api.g_varchar2) or
1010: nvl(per_dis_shd.g_old_rec.dis_information8, hr_api.g_varchar2) <>
1004: nvl(per_dis_shd.g_old_rec.dis_information5, hr_api.g_varchar2) <>
1005: nvl(p_rec.dis_information5, hr_api.g_varchar2) or
1006: nvl(per_dis_shd.g_old_rec.dis_information6, hr_api.g_varchar2) <>
1007: nvl(p_rec.dis_information6, hr_api.g_varchar2) or
1008: nvl(per_dis_shd.g_old_rec.dis_information7, hr_api.g_varchar2) <>
1009: nvl(p_rec.dis_information7, hr_api.g_varchar2) or
1010: nvl(per_dis_shd.g_old_rec.dis_information8, hr_api.g_varchar2) <>
1011: nvl(p_rec.dis_information8, hr_api.g_varchar2) or
1012: nvl(per_dis_shd.g_old_rec.dis_information9, hr_api.g_varchar2) <>
1006: nvl(per_dis_shd.g_old_rec.dis_information6, hr_api.g_varchar2) <>
1007: nvl(p_rec.dis_information6, hr_api.g_varchar2) or
1008: nvl(per_dis_shd.g_old_rec.dis_information7, hr_api.g_varchar2) <>
1009: nvl(p_rec.dis_information7, hr_api.g_varchar2) or
1010: nvl(per_dis_shd.g_old_rec.dis_information8, hr_api.g_varchar2) <>
1011: nvl(p_rec.dis_information8, hr_api.g_varchar2) or
1012: nvl(per_dis_shd.g_old_rec.dis_information9, hr_api.g_varchar2) <>
1013: nvl(p_rec.dis_information9, hr_api.g_varchar2) or
1014: nvl(per_dis_shd.g_old_rec.dis_information10, hr_api.g_varchar2) <>
1008: nvl(per_dis_shd.g_old_rec.dis_information7, hr_api.g_varchar2) <>
1009: nvl(p_rec.dis_information7, hr_api.g_varchar2) or
1010: nvl(per_dis_shd.g_old_rec.dis_information8, hr_api.g_varchar2) <>
1011: nvl(p_rec.dis_information8, hr_api.g_varchar2) or
1012: nvl(per_dis_shd.g_old_rec.dis_information9, hr_api.g_varchar2) <>
1013: nvl(p_rec.dis_information9, hr_api.g_varchar2) or
1014: nvl(per_dis_shd.g_old_rec.dis_information10, hr_api.g_varchar2) <>
1015: nvl(p_rec.dis_information10, hr_api.g_varchar2) or
1016: nvl(per_dis_shd.g_old_rec.dis_information11, hr_api.g_varchar2) <>
1010: nvl(per_dis_shd.g_old_rec.dis_information8, hr_api.g_varchar2) <>
1011: nvl(p_rec.dis_information8, hr_api.g_varchar2) or
1012: nvl(per_dis_shd.g_old_rec.dis_information9, hr_api.g_varchar2) <>
1013: nvl(p_rec.dis_information9, hr_api.g_varchar2) or
1014: nvl(per_dis_shd.g_old_rec.dis_information10, hr_api.g_varchar2) <>
1015: nvl(p_rec.dis_information10, hr_api.g_varchar2) or
1016: nvl(per_dis_shd.g_old_rec.dis_information11, hr_api.g_varchar2) <>
1017: nvl(p_rec.dis_information11, hr_api.g_varchar2) or
1018: nvl(per_dis_shd.g_old_rec.dis_information12, hr_api.g_varchar2) <>
1012: nvl(per_dis_shd.g_old_rec.dis_information9, hr_api.g_varchar2) <>
1013: nvl(p_rec.dis_information9, hr_api.g_varchar2) or
1014: nvl(per_dis_shd.g_old_rec.dis_information10, hr_api.g_varchar2) <>
1015: nvl(p_rec.dis_information10, hr_api.g_varchar2) or
1016: nvl(per_dis_shd.g_old_rec.dis_information11, hr_api.g_varchar2) <>
1017: nvl(p_rec.dis_information11, hr_api.g_varchar2) or
1018: nvl(per_dis_shd.g_old_rec.dis_information12, hr_api.g_varchar2) <>
1019: nvl(p_rec.dis_information12, hr_api.g_varchar2) or
1020: nvl(per_dis_shd.g_old_rec.dis_information13, hr_api.g_varchar2) <>
1014: nvl(per_dis_shd.g_old_rec.dis_information10, hr_api.g_varchar2) <>
1015: nvl(p_rec.dis_information10, hr_api.g_varchar2) or
1016: nvl(per_dis_shd.g_old_rec.dis_information11, hr_api.g_varchar2) <>
1017: nvl(p_rec.dis_information11, hr_api.g_varchar2) or
1018: nvl(per_dis_shd.g_old_rec.dis_information12, hr_api.g_varchar2) <>
1019: nvl(p_rec.dis_information12, hr_api.g_varchar2) or
1020: nvl(per_dis_shd.g_old_rec.dis_information13, hr_api.g_varchar2) <>
1021: nvl(p_rec.dis_information13, hr_api.g_varchar2) or
1022: nvl(per_dis_shd.g_old_rec.dis_information14, hr_api.g_varchar2) <>
1016: nvl(per_dis_shd.g_old_rec.dis_information11, hr_api.g_varchar2) <>
1017: nvl(p_rec.dis_information11, hr_api.g_varchar2) or
1018: nvl(per_dis_shd.g_old_rec.dis_information12, hr_api.g_varchar2) <>
1019: nvl(p_rec.dis_information12, hr_api.g_varchar2) or
1020: nvl(per_dis_shd.g_old_rec.dis_information13, hr_api.g_varchar2) <>
1021: nvl(p_rec.dis_information13, hr_api.g_varchar2) or
1022: nvl(per_dis_shd.g_old_rec.dis_information14, hr_api.g_varchar2) <>
1023: nvl(p_rec.dis_information14, hr_api.g_varchar2) or
1024: nvl(per_dis_shd.g_old_rec.dis_information15, hr_api.g_varchar2) <>
1018: nvl(per_dis_shd.g_old_rec.dis_information12, hr_api.g_varchar2) <>
1019: nvl(p_rec.dis_information12, hr_api.g_varchar2) or
1020: nvl(per_dis_shd.g_old_rec.dis_information13, hr_api.g_varchar2) <>
1021: nvl(p_rec.dis_information13, hr_api.g_varchar2) or
1022: nvl(per_dis_shd.g_old_rec.dis_information14, hr_api.g_varchar2) <>
1023: nvl(p_rec.dis_information14, hr_api.g_varchar2) or
1024: nvl(per_dis_shd.g_old_rec.dis_information15, hr_api.g_varchar2) <>
1025: nvl(p_rec.dis_information15, hr_api.g_varchar2) or
1026: nvl(per_dis_shd.g_old_rec.dis_information16, hr_api.g_varchar2) <>
1020: nvl(per_dis_shd.g_old_rec.dis_information13, hr_api.g_varchar2) <>
1021: nvl(p_rec.dis_information13, hr_api.g_varchar2) or
1022: nvl(per_dis_shd.g_old_rec.dis_information14, hr_api.g_varchar2) <>
1023: nvl(p_rec.dis_information14, hr_api.g_varchar2) or
1024: nvl(per_dis_shd.g_old_rec.dis_information15, hr_api.g_varchar2) <>
1025: nvl(p_rec.dis_information15, hr_api.g_varchar2) or
1026: nvl(per_dis_shd.g_old_rec.dis_information16, hr_api.g_varchar2) <>
1027: nvl(p_rec.dis_information16, hr_api.g_varchar2) or
1028: nvl(per_dis_shd.g_old_rec.dis_information17, hr_api.g_varchar2) <>
1022: nvl(per_dis_shd.g_old_rec.dis_information14, hr_api.g_varchar2) <>
1023: nvl(p_rec.dis_information14, hr_api.g_varchar2) or
1024: nvl(per_dis_shd.g_old_rec.dis_information15, hr_api.g_varchar2) <>
1025: nvl(p_rec.dis_information15, hr_api.g_varchar2) or
1026: nvl(per_dis_shd.g_old_rec.dis_information16, hr_api.g_varchar2) <>
1027: nvl(p_rec.dis_information16, hr_api.g_varchar2) or
1028: nvl(per_dis_shd.g_old_rec.dis_information17, hr_api.g_varchar2) <>
1029: nvl(p_rec.dis_information17, hr_api.g_varchar2) or
1030: nvl(per_dis_shd.g_old_rec.dis_information18, hr_api.g_varchar2) <>
1024: nvl(per_dis_shd.g_old_rec.dis_information15, hr_api.g_varchar2) <>
1025: nvl(p_rec.dis_information15, hr_api.g_varchar2) or
1026: nvl(per_dis_shd.g_old_rec.dis_information16, hr_api.g_varchar2) <>
1027: nvl(p_rec.dis_information16, hr_api.g_varchar2) or
1028: nvl(per_dis_shd.g_old_rec.dis_information17, hr_api.g_varchar2) <>
1029: nvl(p_rec.dis_information17, hr_api.g_varchar2) or
1030: nvl(per_dis_shd.g_old_rec.dis_information18, hr_api.g_varchar2) <>
1031: nvl(p_rec.dis_information18, hr_api.g_varchar2) or
1032: nvl(per_dis_shd.g_old_rec.dis_information19, hr_api.g_varchar2) <>
1026: nvl(per_dis_shd.g_old_rec.dis_information16, hr_api.g_varchar2) <>
1027: nvl(p_rec.dis_information16, hr_api.g_varchar2) or
1028: nvl(per_dis_shd.g_old_rec.dis_information17, hr_api.g_varchar2) <>
1029: nvl(p_rec.dis_information17, hr_api.g_varchar2) or
1030: nvl(per_dis_shd.g_old_rec.dis_information18, hr_api.g_varchar2) <>
1031: nvl(p_rec.dis_information18, hr_api.g_varchar2) or
1032: nvl(per_dis_shd.g_old_rec.dis_information19, hr_api.g_varchar2) <>
1033: nvl(p_rec.dis_information19, hr_api.g_varchar2) or
1034: nvl(per_dis_shd.g_old_rec.dis_information20, hr_api.g_varchar2) <>
1028: nvl(per_dis_shd.g_old_rec.dis_information17, hr_api.g_varchar2) <>
1029: nvl(p_rec.dis_information17, hr_api.g_varchar2) or
1030: nvl(per_dis_shd.g_old_rec.dis_information18, hr_api.g_varchar2) <>
1031: nvl(p_rec.dis_information18, hr_api.g_varchar2) or
1032: nvl(per_dis_shd.g_old_rec.dis_information19, hr_api.g_varchar2) <>
1033: nvl(p_rec.dis_information19, hr_api.g_varchar2) or
1034: nvl(per_dis_shd.g_old_rec.dis_information20, hr_api.g_varchar2) <>
1035: nvl(p_rec.dis_information20, hr_api.g_varchar2) or
1036: nvl(per_dis_shd.g_old_rec.dis_information21, hr_api.g_varchar2) <>
1030: nvl(per_dis_shd.g_old_rec.dis_information18, hr_api.g_varchar2) <>
1031: nvl(p_rec.dis_information18, hr_api.g_varchar2) or
1032: nvl(per_dis_shd.g_old_rec.dis_information19, hr_api.g_varchar2) <>
1033: nvl(p_rec.dis_information19, hr_api.g_varchar2) or
1034: nvl(per_dis_shd.g_old_rec.dis_information20, hr_api.g_varchar2) <>
1035: nvl(p_rec.dis_information20, hr_api.g_varchar2) or
1036: nvl(per_dis_shd.g_old_rec.dis_information21, hr_api.g_varchar2) <>
1037: nvl(p_rec.dis_information21, hr_api.g_varchar2) or
1038: nvl(per_dis_shd.g_old_rec.dis_information22, hr_api.g_varchar2) <>
1032: nvl(per_dis_shd.g_old_rec.dis_information19, hr_api.g_varchar2) <>
1033: nvl(p_rec.dis_information19, hr_api.g_varchar2) or
1034: nvl(per_dis_shd.g_old_rec.dis_information20, hr_api.g_varchar2) <>
1035: nvl(p_rec.dis_information20, hr_api.g_varchar2) or
1036: nvl(per_dis_shd.g_old_rec.dis_information21, hr_api.g_varchar2) <>
1037: nvl(p_rec.dis_information21, hr_api.g_varchar2) or
1038: nvl(per_dis_shd.g_old_rec.dis_information22, hr_api.g_varchar2) <>
1039: nvl(p_rec.dis_information22, hr_api.g_varchar2) or
1040: nvl(per_dis_shd.g_old_rec.dis_information23, hr_api.g_varchar2) <>
1034: nvl(per_dis_shd.g_old_rec.dis_information20, hr_api.g_varchar2) <>
1035: nvl(p_rec.dis_information20, hr_api.g_varchar2) or
1036: nvl(per_dis_shd.g_old_rec.dis_information21, hr_api.g_varchar2) <>
1037: nvl(p_rec.dis_information21, hr_api.g_varchar2) or
1038: nvl(per_dis_shd.g_old_rec.dis_information22, hr_api.g_varchar2) <>
1039: nvl(p_rec.dis_information22, hr_api.g_varchar2) or
1040: nvl(per_dis_shd.g_old_rec.dis_information23, hr_api.g_varchar2) <>
1041: nvl(p_rec.dis_information23, hr_api.g_varchar2) or
1042: nvl(per_dis_shd.g_old_rec.dis_information24, hr_api.g_varchar2) <>
1036: nvl(per_dis_shd.g_old_rec.dis_information21, hr_api.g_varchar2) <>
1037: nvl(p_rec.dis_information21, hr_api.g_varchar2) or
1038: nvl(per_dis_shd.g_old_rec.dis_information22, hr_api.g_varchar2) <>
1039: nvl(p_rec.dis_information22, hr_api.g_varchar2) or
1040: nvl(per_dis_shd.g_old_rec.dis_information23, hr_api.g_varchar2) <>
1041: nvl(p_rec.dis_information23, hr_api.g_varchar2) or
1042: nvl(per_dis_shd.g_old_rec.dis_information24, hr_api.g_varchar2) <>
1043: nvl(p_rec.dis_information24, hr_api.g_varchar2) or
1044: nvl(per_dis_shd.g_old_rec.dis_information25, hr_api.g_varchar2) <>
1038: nvl(per_dis_shd.g_old_rec.dis_information22, hr_api.g_varchar2) <>
1039: nvl(p_rec.dis_information22, hr_api.g_varchar2) or
1040: nvl(per_dis_shd.g_old_rec.dis_information23, hr_api.g_varchar2) <>
1041: nvl(p_rec.dis_information23, hr_api.g_varchar2) or
1042: nvl(per_dis_shd.g_old_rec.dis_information24, hr_api.g_varchar2) <>
1043: nvl(p_rec.dis_information24, hr_api.g_varchar2) or
1044: nvl(per_dis_shd.g_old_rec.dis_information25, hr_api.g_varchar2) <>
1045: nvl(p_rec.dis_information25, hr_api.g_varchar2) or
1046: nvl(per_dis_shd.g_old_rec.dis_information26, hr_api.g_varchar2) <>
1040: nvl(per_dis_shd.g_old_rec.dis_information23, hr_api.g_varchar2) <>
1041: nvl(p_rec.dis_information23, hr_api.g_varchar2) or
1042: nvl(per_dis_shd.g_old_rec.dis_information24, hr_api.g_varchar2) <>
1043: nvl(p_rec.dis_information24, hr_api.g_varchar2) or
1044: nvl(per_dis_shd.g_old_rec.dis_information25, hr_api.g_varchar2) <>
1045: nvl(p_rec.dis_information25, hr_api.g_varchar2) or
1046: nvl(per_dis_shd.g_old_rec.dis_information26, hr_api.g_varchar2) <>
1047: nvl(p_rec.dis_information26, hr_api.g_varchar2) or
1048: nvl(per_dis_shd.g_old_rec.dis_information27, hr_api.g_varchar2) <>
1042: nvl(per_dis_shd.g_old_rec.dis_information24, hr_api.g_varchar2) <>
1043: nvl(p_rec.dis_information24, hr_api.g_varchar2) or
1044: nvl(per_dis_shd.g_old_rec.dis_information25, hr_api.g_varchar2) <>
1045: nvl(p_rec.dis_information25, hr_api.g_varchar2) or
1046: nvl(per_dis_shd.g_old_rec.dis_information26, hr_api.g_varchar2) <>
1047: nvl(p_rec.dis_information26, hr_api.g_varchar2) or
1048: nvl(per_dis_shd.g_old_rec.dis_information27, hr_api.g_varchar2) <>
1049: nvl(p_rec.dis_information27, hr_api.g_varchar2) or
1050: nvl(per_dis_shd.g_old_rec.dis_information28, hr_api.g_varchar2) <>
1044: nvl(per_dis_shd.g_old_rec.dis_information25, hr_api.g_varchar2) <>
1045: nvl(p_rec.dis_information25, hr_api.g_varchar2) or
1046: nvl(per_dis_shd.g_old_rec.dis_information26, hr_api.g_varchar2) <>
1047: nvl(p_rec.dis_information26, hr_api.g_varchar2) or
1048: nvl(per_dis_shd.g_old_rec.dis_information27, hr_api.g_varchar2) <>
1049: nvl(p_rec.dis_information27, hr_api.g_varchar2) or
1050: nvl(per_dis_shd.g_old_rec.dis_information28, hr_api.g_varchar2) <>
1051: nvl(p_rec.dis_information28, hr_api.g_varchar2) or
1052: nvl(per_dis_shd.g_old_rec.dis_information29, hr_api.g_varchar2) <>
1046: nvl(per_dis_shd.g_old_rec.dis_information26, hr_api.g_varchar2) <>
1047: nvl(p_rec.dis_information26, hr_api.g_varchar2) or
1048: nvl(per_dis_shd.g_old_rec.dis_information27, hr_api.g_varchar2) <>
1049: nvl(p_rec.dis_information27, hr_api.g_varchar2) or
1050: nvl(per_dis_shd.g_old_rec.dis_information28, hr_api.g_varchar2) <>
1051: nvl(p_rec.dis_information28, hr_api.g_varchar2) or
1052: nvl(per_dis_shd.g_old_rec.dis_information29, hr_api.g_varchar2) <>
1053: nvl(p_rec.dis_information29, hr_api.g_varchar2) or
1054: nvl(per_dis_shd.g_old_rec.dis_information30, hr_api.g_varchar2) <>
1048: nvl(per_dis_shd.g_old_rec.dis_information27, hr_api.g_varchar2) <>
1049: nvl(p_rec.dis_information27, hr_api.g_varchar2) or
1050: nvl(per_dis_shd.g_old_rec.dis_information28, hr_api.g_varchar2) <>
1051: nvl(p_rec.dis_information28, hr_api.g_varchar2) or
1052: nvl(per_dis_shd.g_old_rec.dis_information29, hr_api.g_varchar2) <>
1053: nvl(p_rec.dis_information29, hr_api.g_varchar2) or
1054: nvl(per_dis_shd.g_old_rec.dis_information30, hr_api.g_varchar2) <>
1055: nvl(p_rec.dis_information30, hr_api.g_varchar2) ))
1056: or (p_rec.disability_id is null) then
1050: nvl(per_dis_shd.g_old_rec.dis_information28, hr_api.g_varchar2) <>
1051: nvl(p_rec.dis_information28, hr_api.g_varchar2) or
1052: nvl(per_dis_shd.g_old_rec.dis_information29, hr_api.g_varchar2) <>
1053: nvl(p_rec.dis_information29, hr_api.g_varchar2) or
1054: nvl(per_dis_shd.g_old_rec.dis_information30, hr_api.g_varchar2) <>
1055: nvl(p_rec.dis_information30, hr_api.g_varchar2) ))
1056: or (p_rec.disability_id is null) then
1057: --
1058: -- Only execute the validation if absolutely necessary:
1158: -- Internal Row Handler Use Only.
1159: --
1160: -- ----------------------------------------------------------------------------
1161: procedure chk_df
1162: (p_rec in per_dis_shd.g_rec_type
1163: ) is
1164: --
1165: l_proc varchar2(72) := g_package || 'chk_df';
1166: --
1167: begin
1168: hr_utility.set_location('Entering:'||l_proc,10);
1169: --
1170: if ((p_rec.disability_id is not null) and (
1171: nvl(per_dis_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1173: nvl(per_dis_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1175: nvl(per_dis_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1169: --
1170: if ((p_rec.disability_id is not null) and (
1171: nvl(per_dis_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1173: nvl(per_dis_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1175: nvl(per_dis_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1177: nvl(per_dis_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1171: nvl(per_dis_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1173: nvl(per_dis_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1175: nvl(per_dis_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1177: nvl(per_dis_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1179: nvl(per_dis_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1173: nvl(per_dis_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1175: nvl(per_dis_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1177: nvl(per_dis_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1179: nvl(per_dis_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1181: nvl(per_dis_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1175: nvl(per_dis_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1177: nvl(per_dis_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1179: nvl(per_dis_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1181: nvl(per_dis_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1183: nvl(per_dis_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1177: nvl(per_dis_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1179: nvl(per_dis_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1181: nvl(per_dis_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1183: nvl(per_dis_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1185: nvl(per_dis_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1179: nvl(per_dis_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1181: nvl(per_dis_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1183: nvl(per_dis_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1185: nvl(per_dis_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1187: nvl(per_dis_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1181: nvl(per_dis_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1183: nvl(per_dis_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1185: nvl(per_dis_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1187: nvl(per_dis_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1189: nvl(per_dis_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1183: nvl(per_dis_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1185: nvl(per_dis_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1187: nvl(per_dis_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1189: nvl(per_dis_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1191: nvl(per_dis_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1185: nvl(per_dis_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1187: nvl(per_dis_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1189: nvl(per_dis_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1191: nvl(per_dis_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1193: nvl(per_dis_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1187: nvl(per_dis_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1189: nvl(per_dis_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1191: nvl(per_dis_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1193: nvl(per_dis_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1195: nvl(per_dis_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1189: nvl(per_dis_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1191: nvl(per_dis_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1193: nvl(per_dis_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1195: nvl(per_dis_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1197: nvl(per_dis_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1191: nvl(per_dis_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1193: nvl(per_dis_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1195: nvl(per_dis_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1197: nvl(per_dis_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1199: nvl(per_dis_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1193: nvl(per_dis_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1195: nvl(per_dis_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1197: nvl(per_dis_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1199: nvl(per_dis_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1201: nvl(per_dis_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1195: nvl(per_dis_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1197: nvl(per_dis_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1199: nvl(per_dis_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1201: nvl(per_dis_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1203: nvl(per_dis_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1197: nvl(per_dis_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1199: nvl(per_dis_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1201: nvl(per_dis_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1203: nvl(per_dis_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1205: nvl(per_dis_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1199: nvl(per_dis_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1201: nvl(per_dis_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1203: nvl(per_dis_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1205: nvl(per_dis_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1207: nvl(per_dis_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1201: nvl(per_dis_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1203: nvl(per_dis_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1205: nvl(per_dis_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1207: nvl(per_dis_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1209: nvl(per_dis_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1203: nvl(per_dis_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1205: nvl(per_dis_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1207: nvl(per_dis_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1209: nvl(per_dis_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1211: nvl(per_dis_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1205: nvl(per_dis_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1207: nvl(per_dis_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1209: nvl(per_dis_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1211: nvl(per_dis_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1213: nvl(per_dis_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1207: nvl(per_dis_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1209: nvl(per_dis_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1211: nvl(per_dis_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1213: nvl(per_dis_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1215: nvl(per_dis_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1209: nvl(per_dis_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1211: nvl(per_dis_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1213: nvl(per_dis_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1215: nvl(per_dis_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1217: nvl(per_dis_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1211: nvl(per_dis_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1213: nvl(per_dis_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1215: nvl(per_dis_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1217: nvl(per_dis_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1219: nvl(per_dis_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1213: nvl(per_dis_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1215: nvl(per_dis_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1217: nvl(per_dis_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1219: nvl(per_dis_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1221: nvl(per_dis_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1215: nvl(per_dis_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1217: nvl(per_dis_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1219: nvl(per_dis_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1221: nvl(per_dis_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1223: nvl(per_dis_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1217: nvl(per_dis_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1219: nvl(per_dis_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1221: nvl(per_dis_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1223: nvl(per_dis_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1225: nvl(per_dis_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1219: nvl(per_dis_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1221: nvl(per_dis_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1223: nvl(per_dis_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1225: nvl(per_dis_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1227: nvl(per_dis_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1221: nvl(per_dis_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1223: nvl(per_dis_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1225: nvl(per_dis_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1227: nvl(per_dis_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1229: nvl(per_dis_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1223: nvl(per_dis_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1225: nvl(per_dis_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1227: nvl(per_dis_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1229: nvl(per_dis_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1230: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1231: nvl(per_dis_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1225: nvl(per_dis_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1227: nvl(per_dis_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1229: nvl(per_dis_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1230: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1231: nvl(per_dis_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1232: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1233: or (p_rec.disability_id is null) then
1227: nvl(per_dis_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1229: nvl(per_dis_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1230: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1231: nvl(per_dis_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1232: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1233: or (p_rec.disability_id is null) then
1234: --
1235: -- Only execute the validation if absolutely necessary:
1335: -- {End Of Comments}
1336: -- ----------------------------------------------------------------------------
1337: Procedure chk_non_updateable_args
1338: (p_effective_date in date
1339: ,p_rec in per_dis_shd.g_rec_type
1340: ) is
1341: --
1342: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1343: l_error EXCEPTION;
1347: --
1348: -- Only proceed with the validation if a row exists for the current
1349: -- record in the HR Schema.
1350: --
1351: if NOT per_dis_shd.api_updating
1352: (p_disability_id => p_rec.disability_id
1353: ,p_effective_date => p_effective_date
1354: ,p_object_version_number => p_rec.object_version_number
1355: ) THEN
1359: fnd_message.raise_error;
1360: end if;
1361: --
1362: if nvl(p_rec.person_id, hr_api.g_number) <>
1363: nvl(per_dis_shd.g_old_rec.person_id
1364: ,hr_api.g_number) then
1365: l_argument := 'person_id';
1366: raise l_error;
1367: end if;
1583: -- ----------------------------------------------------------------------------
1584: -- |---------------------------< insert_validate >----------------------------|
1585: -- ----------------------------------------------------------------------------
1586: Procedure insert_validate
1587: (p_rec in per_dis_shd.g_rec_type
1588: ,p_effective_date in date
1589: ,p_datetrack_mode in varchar2
1590: ,p_validation_start_date in date
1591: ,p_validation_end_date in date
1698: -- ----------------------------------------------------------------------------
1699: -- |---------------------------< update_validate >----------------------------|
1700: -- ----------------------------------------------------------------------------
1701: Procedure update_validate
1702: (p_rec in per_dis_shd.g_rec_type
1703: ,p_effective_date in date
1704: ,p_datetrack_mode in varchar2
1705: ,p_validation_start_date in date
1706: ,p_validation_end_date in date
1823: -- ----------------------------------------------------------------------------
1824: -- |---------------------------< delete_validate >----------------------------|
1825: -- ----------------------------------------------------------------------------
1826: Procedure delete_validate
1827: (p_rec in per_dis_shd.g_rec_type
1828: ,p_effective_date in date
1829: ,p_datetrack_mode in varchar2
1830: ,p_validation_start_date in date
1831: ,p_validation_end_date in date