[Home] [Help]
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 => 'disability_id'
49: ,p_argument_value => p_disability_id
50: );
65: close csr_sec_grp;
66: --
67: -- Set the security_group_id in CLIENT_INFO
68: --
69: hr_api.set_security_group_id
70: (p_security_group_id => l_security_group_id
71: );
72: --
73: hr_utility.set_location(' Leaving:'|| l_proc, 20);
104: hr_utility.set_location('Entering:'|| l_proc, 10);
105: --
106: -- Ensure that all the mandatory parameter are not null
107: --
108: hr_api.mandatory_arg_error
109: (p_api_name => l_proc
110: ,p_argument => 'disability_id'
111: ,p_argument_value => p_disability_id
112: );
110: ,p_argument => 'disability_id'
111: ,p_argument_value => p_disability_id
112: );
113: --
114: if ( nvl(per_dis_bus.g_disability_id, hr_api.g_number)
115: = p_disability_id) then
116: --
117: -- The legislation code has already been found with a previous
118: -- call to this function. Just return the value in the global
200: hr_utility.set_location('Entering:'|| l_proc, 1);
201: --
202: -- Check mandatory parameter is set
203: --
204: hr_api.mandatory_arg_error
205: (p_api_name => l_proc
206: ,p_argument => 'effective_date'
207: ,p_argument_value => p_effective_date
208: );
293: hr_utility.set_location('Entering:'|| l_proc, 1);
294: --
295: -- Check mandatory parameter is set
296: --
297: hr_api.mandatory_arg_error
298: (p_api_name => l_proc
299: ,p_argument => 'effective_date'
300: ,p_argument_value => p_effective_date
301: );
299: ,p_argument => 'effective_date'
300: ,p_argument_value => p_effective_date
301: );
302: --
303: hr_api.mandatory_arg_error
304: (p_api_name => l_proc
305: ,p_argument => 'person_id'
306: ,p_argument_value => p_person_id
307: );
403: hr_utility.set_location('Entering:'|| l_proc, 10);
404: --
405: -- Check mandatory arguments
406: --
407: hr_api.mandatory_arg_error
408: (p_api_name => l_proc
409: ,p_argument => 'effective_date'
410: ,p_argument_value => p_effective_date
411: );
409: ,p_argument => 'effective_date'
410: ,p_argument_value => p_effective_date
411: );
412: --
413: hr_api.mandatory_arg_error
414: (p_api_name => l_proc
415: ,p_argument => 'validation_start_date'
416: ,p_argument_value => p_validation_start_date
417: );
415: ,p_argument => 'validation_start_date'
416: ,p_argument_value => p_validation_start_date
417: );
418: --
419: hr_api.mandatory_arg_error
420: (p_api_name => l_proc
421: ,p_argument => 'validation_end_date'
422: ,p_argument_value => p_validation_end_date
423: );
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
443: (p_effective_date => p_effective_date
444: ,p_validation_start_date => p_validation_start_date
445: ,p_validation_end_date => p_validation_end_date
446: ,p_lookup_type => 'DISABILITY_CATEGORY'
505: hr_utility.set_location('Entering:'|| l_proc, 10);
506: --
507: -- Check mandatory parameters have been set
508: --
509: hr_api.mandatory_arg_error
510: (p_api_name => l_proc
511: ,p_argument => 'effective_date'
512: ,p_argument_value => p_effective_date
513: );
511: ,p_argument => 'effective_date'
512: ,p_argument_value => p_effective_date
513: );
514: --
515: hr_api.mandatory_arg_error
516: (p_api_name => l_proc
517: ,p_argument => 'validation_start_date'
518: ,p_argument_value => p_validation_start_date
519: );
517: ,p_argument => 'validation_start_date'
518: ,p_argument_value => p_validation_start_date
519: );
520: --
521: hr_api.mandatory_arg_error
522: (p_api_name => l_proc
523: ,p_argument => 'validation_end_date'
524: ,p_argument_value => p_validation_end_date
525: );
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
545: (p_effective_date => p_effective_date
546: ,p_validation_start_date => p_validation_start_date
547: ,p_validation_end_date => p_validation_end_date
548: ,p_lookup_type => 'DISABILITY_STATUS'
657: hr_utility.set_location('Entering:'|| l_proc, 10);
658: --
659: -- Check mandatory arguments
660: --
661: hr_api.mandatory_arg_error
662: (p_api_name => l_proc
663: ,p_argument => 'effective_date'
664: ,p_argument_value => p_effective_date
665: );
663: ,p_argument => 'effective_date'
664: ,p_argument_value => p_effective_date
665: );
666: --
667: hr_api.mandatory_arg_error
668: (p_api_name => l_proc
669: ,p_argument => 'validation_start_date'
670: ,p_argument_value => p_validation_start_date
671: );
669: ,p_argument => 'validation_start_date'
670: ,p_argument_value => p_validation_start_date
671: );
672: --
673: hr_api.mandatory_arg_error
674: (p_api_name => l_proc
675: ,p_argument => 'validation_end_date'
676: ,p_argument_value => p_validation_end_date
677: );
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
694: (p_effective_date => p_effective_date
695: ,p_validation_start_date => p_validation_start_date
696: ,p_validation_end_date => p_validation_end_date
697: ,p_lookup_type => 'DISABILITY_REASON'
797: cursor csr_org is
798: select business_group_id
799: from hr_all_organization_units hou
800: where hou.organization_id = p_organization_id
801: and p_validation_start_date between hou.date_from and nvl(hou.date_to, hr_api.g_eot)
802: and hou.internal_external_flag = 'EXT';
803: --
804: cursor csr_org_inf is
805: select null
817: hr_utility.set_location('Entering:'|| l_proc, 10);
818: --
819: -- Check mandatory parameters have been set
820: --
821: hr_api.mandatory_arg_error
822: (p_api_name => l_proc
823: ,p_argument => 'business_group_id'
824: ,p_argument_value => p_business_group_id);
825: --
822: (p_api_name => l_proc
823: ,p_argument => 'business_group_id'
824: ,p_argument_value => p_business_group_id);
825: --
826: hr_api.mandatory_arg_error
827: (p_api_name => l_proc
828: ,p_argument => 'validation_start_date'
829: ,p_argument_value => p_validation_start_date);
830: --
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) <>
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) <>
999: nvl(p_rec.dis_information2, hr_api.g_varchar2) or
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) <>
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) <>
1001: nvl(p_rec.dis_information3, hr_api.g_varchar2) or
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) <>
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) <>
1003: nvl(p_rec.dis_information4, 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) <>
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) <>
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) <>
1005: nvl(p_rec.dis_information5, 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) <>
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) <>
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) <>
1007: nvl(p_rec.dis_information6, 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) <>
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) <>
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) <>
1009: nvl(p_rec.dis_information7, 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) <>
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) <>
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) <>
1011: nvl(p_rec.dis_information8, 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) <>
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) <>
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) <>
1013: nvl(p_rec.dis_information9, 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) <>
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) <>
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) <>
1015: nvl(p_rec.dis_information10, 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) <>
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) <>
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) <>
1017: nvl(p_rec.dis_information11, 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) <>
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) <>
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) <>
1019: nvl(p_rec.dis_information12, 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) <>
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) <>
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) <>
1021: nvl(p_rec.dis_information13, 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) <>
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) <>
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) <>
1023: nvl(p_rec.dis_information14, 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) <>
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) <>
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) <>
1025: nvl(p_rec.dis_information15, 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) <>
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) <>
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) <>
1027: nvl(p_rec.dis_information16, 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) <>
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) <>
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) <>
1029: nvl(p_rec.dis_information17, 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) <>
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) <>
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) <>
1031: nvl(p_rec.dis_information18, 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) <>
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) <>
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) <>
1033: nvl(p_rec.dis_information19, 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) <>
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) <>
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) <>
1035: nvl(p_rec.dis_information20, 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) <>
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) <>
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) <>
1037: nvl(p_rec.dis_information21, 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) <>
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) <>
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) <>
1039: nvl(p_rec.dis_information22, 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) <>
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) <>
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) <>
1041: nvl(p_rec.dis_information23, 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) <>
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) <>
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) <>
1043: nvl(p_rec.dis_information24, 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) <>
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) <>
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) <>
1045: nvl(p_rec.dis_information25, 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) <>
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) <>
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) <>
1047: nvl(p_rec.dis_information26, 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) <>
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) <>
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) <>
1049: nvl(p_rec.dis_information27, 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) <>
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) <>
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) <>
1051: nvl(p_rec.dis_information28, 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) <>
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) <>
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) <>
1053: nvl(p_rec.dis_information29, 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) <>
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) <>
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) <>
1055: nvl(p_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
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
1057: --
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:
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:
1059: -- a) During update, the structure column value or any
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) <>
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) <>
1176: nvl(p_rec.attribute2, hr_api.g_varchar2) or
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) <>
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) <>
1178: nvl(p_rec.attribute3, hr_api.g_varchar2) or
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) <>
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) <>
1180: nvl(p_rec.attribute4, 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) <>
1180: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1181: nvl(per_dis_shd.g_old_rec.attribute5, 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) <>
1182: nvl(p_rec.attribute5, 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) <>
1182: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1183: nvl(per_dis_shd.g_old_rec.attribute6, 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) <>
1184: nvl(p_rec.attribute6, 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) <>
1184: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1185: nvl(per_dis_shd.g_old_rec.attribute7, 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) <>
1186: nvl(p_rec.attribute7, 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) <>
1186: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1187: nvl(per_dis_shd.g_old_rec.attribute8, 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) <>
1188: nvl(p_rec.attribute8, 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) <>
1188: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1189: nvl(per_dis_shd.g_old_rec.attribute9, 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) <>
1190: nvl(p_rec.attribute9, 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) <>
1190: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1191: nvl(per_dis_shd.g_old_rec.attribute10, 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) <>
1192: nvl(p_rec.attribute10, 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) <>
1192: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1193: nvl(per_dis_shd.g_old_rec.attribute11, 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) <>
1194: nvl(p_rec.attribute11, 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) <>
1194: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1195: nvl(per_dis_shd.g_old_rec.attribute12, 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) <>
1196: nvl(p_rec.attribute12, 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) <>
1196: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1197: nvl(per_dis_shd.g_old_rec.attribute13, 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) <>
1198: nvl(p_rec.attribute13, 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) <>
1198: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1199: nvl(per_dis_shd.g_old_rec.attribute14, 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) <>
1200: nvl(p_rec.attribute14, 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) <>
1200: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1201: nvl(per_dis_shd.g_old_rec.attribute15, 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) <>
1202: nvl(p_rec.attribute15, 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) <>
1202: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1203: nvl(per_dis_shd.g_old_rec.attribute16, 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) <>
1204: nvl(p_rec.attribute16, 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) <>
1204: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1205: nvl(per_dis_shd.g_old_rec.attribute17, 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) <>
1206: nvl(p_rec.attribute17, 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) <>
1206: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1207: nvl(per_dis_shd.g_old_rec.attribute18, 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) <>
1208: nvl(p_rec.attribute18, 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) <>
1208: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1209: nvl(per_dis_shd.g_old_rec.attribute19, 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) <>
1210: nvl(p_rec.attribute19, 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) <>
1210: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1211: nvl(per_dis_shd.g_old_rec.attribute20, 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) <>
1212: nvl(p_rec.attribute20, 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) <>
1212: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1213: nvl(per_dis_shd.g_old_rec.attribute21, 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) <>
1214: nvl(p_rec.attribute21, 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) <>
1214: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1215: nvl(per_dis_shd.g_old_rec.attribute22, 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) <>
1216: nvl(p_rec.attribute22, 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) <>
1216: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1217: nvl(per_dis_shd.g_old_rec.attribute23, 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) <>
1218: nvl(p_rec.attribute23, 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) <>
1218: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1219: nvl(per_dis_shd.g_old_rec.attribute24, 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) <>
1220: nvl(p_rec.attribute24, 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) <>
1220: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1221: nvl(per_dis_shd.g_old_rec.attribute25, 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) <>
1222: nvl(p_rec.attribute25, 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) <>
1222: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1223: nvl(per_dis_shd.g_old_rec.attribute26, 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) <>
1224: nvl(p_rec.attribute26, 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) <>
1224: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1225: nvl(per_dis_shd.g_old_rec.attribute27, 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) <>
1226: nvl(p_rec.attribute27, 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) <>
1226: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1227: nvl(per_dis_shd.g_old_rec.attribute28, 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) <>
1228: nvl(p_rec.attribute28, 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) <>
1228: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1229: nvl(per_dis_shd.g_old_rec.attribute29, 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) <>
1230: nvl(p_rec.attribute29, 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) <>
1230: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1231: nvl(per_dis_shd.g_old_rec.attribute30, 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) <>
1232: nvl(p_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
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
1234: --
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:
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:
1236: -- a) During update, the structure column value or any
1358: fnd_message.set_token('STEP ', '5');
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;
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;
1368: --
1367: end if;
1368: --
1369: EXCEPTION
1370: WHEN l_error THEN
1371: hr_api.argument_changed_error
1372: (p_api_name => l_proc
1373: ,p_argument => l_argument);
1374: WHEN OTHERS THEN
1375: RAISE;
1404: --
1405: -- {End Of Comments}
1406: -- ----------------------------------------------------------------------------
1407: Procedure dt_update_validate
1408: (p_person_id in number default hr_api.g_number
1409: ,p_datetrack_mode in varchar2
1410: ,p_validation_start_date in date
1411: ,p_validation_end_date in date
1412: ) Is
1418: Begin
1419: --
1420: -- Ensure that the p_datetrack_mode argument is not null
1421: --
1422: hr_api.mandatory_arg_error
1423: (p_api_name => l_proc
1424: ,p_argument => 'datetrack_mode'
1425: ,p_argument_value => p_datetrack_mode
1426: );
1428: -- Mode will be valid, as this is checked at the start of the upd.
1429: --
1430: -- Ensure the arguments are not null
1431: --
1432: hr_api.mandatory_arg_error
1433: (p_api_name => l_proc
1434: ,p_argument => 'validation_start_date'
1435: ,p_argument_value => p_validation_start_date
1436: );
1434: ,p_argument => 'validation_start_date'
1435: ,p_argument_value => p_validation_start_date
1436: );
1437: --
1438: hr_api.mandatory_arg_error
1439: (p_api_name => l_proc
1440: ,p_argument => 'validation_end_date'
1441: ,p_argument_value => p_validation_end_date
1442: );
1440: ,p_argument => 'validation_end_date'
1441: ,p_argument_value => p_validation_end_date
1442: );
1443: --
1444: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
1445: NOT (dt_api.check_min_max_dates
1446: (p_base_table_name => 'per_all_people_f'
1447: ,p_base_key_column => 'PERSON_ID'
1448: ,p_base_key_value => p_person_id
1521: Begin
1522: --
1523: -- Ensure that the p_datetrack_mode argument is not null
1524: --
1525: hr_api.mandatory_arg_error
1526: (p_api_name => l_proc
1527: ,p_argument => 'datetrack_mode'
1528: ,p_argument_value => p_datetrack_mode
1529: );
1530: --
1531: -- Only perform the validation if the datetrack mode is either
1532: -- DELETE or ZAP
1533: --
1534: If (p_datetrack_mode = hr_api.g_delete or
1535: p_datetrack_mode = hr_api.g_zap) then
1536: --
1537: --
1538: -- Ensure the arguments are not null
1531: -- Only perform the validation if the datetrack mode is either
1532: -- DELETE or ZAP
1533: --
1534: If (p_datetrack_mode = hr_api.g_delete or
1535: p_datetrack_mode = hr_api.g_zap) then
1536: --
1537: --
1538: -- Ensure the arguments are not null
1539: --
1536: --
1537: --
1538: -- Ensure the arguments are not null
1539: --
1540: hr_api.mandatory_arg_error
1541: (p_api_name => l_proc
1542: ,p_argument => 'validation_start_date'
1543: ,p_argument_value => p_validation_start_date
1544: );
1542: ,p_argument => 'validation_start_date'
1543: ,p_argument_value => p_validation_start_date
1544: );
1545: --
1546: hr_api.mandatory_arg_error
1547: (p_api_name => l_proc
1548: ,p_argument => 'validation_end_date'
1549: ,p_argument_value => p_validation_end_date
1550: );
1548: ,p_argument => 'validation_end_date'
1549: ,p_argument_value => p_validation_end_date
1550: );
1551: --
1552: hr_api.mandatory_arg_error
1553: (p_api_name => l_proc
1554: ,p_argument => 'disability_id'
1555: ,p_argument_value => p_disability_id
1556: );