27: begin
28: hr_utility.set_location('Entering:'|| l_proc, 10);
29: --
30: --
31: IF hr_api.not_exists_in_hrstanlookups
32: (p_effective_date => p_effective_date
33: ,p_lookup_type => 'YES_NO'
34: ,p_lookup_code => p_flag
35: ) THEN
91: hr_utility.set_location('Entering:'|| l_proc, 1);
92: --
93: -- Check mandatory parameters have been set
94: --
95: hr_api.mandatory_arg_error
96: (p_api_name => l_proc
97: ,p_argument => 'person_id'
98: ,p_argument_value => p_person_id
99: );
174: hr_utility.set_location('Entering:'|| l_proc, 1);
175: --
176: -- Check mandatory parameters have been set
177: --
178: hr_api.mandatory_arg_error
179: (p_api_name => l_proc
180: ,p_argument => 'contact_person_id'
181: ,p_argument_value => p_contact_person_id
182: );
256: hr_utility.set_location('Entering:'|| l_proc,1);
257: --
258: -- Check mandatory parameters have been set
259: --
260: hr_api.mandatory_arg_error
261: (p_api_name => l_proc
262: ,p_argument => 'effective date'
263: ,p_argument_value => p_effective_date
264: );
282: hr_utility.raise_error;
283: end if;
284: -- 05/28/97 Check for mandatory argument for update only
285: IF l_api_updating THEN
286: hr_api.mandatory_arg_error
287: (p_api_name => l_proc
288: ,p_argument => 'object version number'
289: ,p_argument_value => p_object_version_number
290: );
288: ,p_argument => 'object version number'
289: ,p_argument_value => p_object_version_number
290: );
291: --
292: hr_api.mandatory_arg_error
293: (p_api_name => l_proc
294: ,p_argument => 'contact relationship id'
295: ,p_argument_value => p_contact_relationship_id
296: );
299: -- 05/28/97 Change Ends
300: --
301: -- Bug 1472162.
302: --
303: -- if hr_api.not_exists_in_hr_lookups
304: if hr_api.not_exists_in_leg_lookups
305: (p_effective_date => p_effective_date
306: ,p_lookup_type => 'CONTACT'
307: ,p_lookup_code => p_contact_type
300: --
301: -- Bug 1472162.
302: --
303: -- if hr_api.not_exists_in_hr_lookups
304: if hr_api.not_exists_in_leg_lookups
305: (p_effective_date => p_effective_date
306: ,p_lookup_type => 'CONTACT'
307: ,p_lookup_code => p_contact_type
308: ) then
675: --
676: hr_utility.set_location('Entering:'|| l_proc,5);
677: --
678: if (p_contact_relationship_id is not null
679: and nvl(per_ctr_shd.g_old_rec.date_start, hr_api.g_date)
680: <> nvl(p_date_start, hr_api.g_date)
681: or nvl(per_ctr_shd.g_old_rec.date_end, hr_api.g_date)
682: <> nvl(p_date_end, hr_api.g_date)
683: or nvl(per_ctr_shd.g_old_rec.contact_type, hr_api.g_varchar2)
676: hr_utility.set_location('Entering:'|| l_proc,5);
677: --
678: if (p_contact_relationship_id is not null
679: and nvl(per_ctr_shd.g_old_rec.date_start, hr_api.g_date)
680: <> nvl(p_date_start, hr_api.g_date)
681: or nvl(per_ctr_shd.g_old_rec.date_end, hr_api.g_date)
682: <> nvl(p_date_end, hr_api.g_date)
683: or nvl(per_ctr_shd.g_old_rec.contact_type, hr_api.g_varchar2)
684: <> nvl(p_contact_type, hr_api.g_varchar2))
677: --
678: if (p_contact_relationship_id is not null
679: and nvl(per_ctr_shd.g_old_rec.date_start, hr_api.g_date)
680: <> nvl(p_date_start, hr_api.g_date)
681: or nvl(per_ctr_shd.g_old_rec.date_end, hr_api.g_date)
682: <> nvl(p_date_end, hr_api.g_date)
683: or nvl(per_ctr_shd.g_old_rec.contact_type, hr_api.g_varchar2)
684: <> nvl(p_contact_type, hr_api.g_varchar2))
685: or p_contact_relationship_id is null then
678: if (p_contact_relationship_id is not null
679: and nvl(per_ctr_shd.g_old_rec.date_start, hr_api.g_date)
680: <> nvl(p_date_start, hr_api.g_date)
681: or nvl(per_ctr_shd.g_old_rec.date_end, hr_api.g_date)
682: <> nvl(p_date_end, hr_api.g_date)
683: or nvl(per_ctr_shd.g_old_rec.contact_type, hr_api.g_varchar2)
684: <> nvl(p_contact_type, hr_api.g_varchar2))
685: or p_contact_relationship_id is null then
686: --
679: and nvl(per_ctr_shd.g_old_rec.date_start, hr_api.g_date)
680: <> nvl(p_date_start, hr_api.g_date)
681: or nvl(per_ctr_shd.g_old_rec.date_end, hr_api.g_date)
682: <> nvl(p_date_end, hr_api.g_date)
683: or nvl(per_ctr_shd.g_old_rec.contact_type, hr_api.g_varchar2)
684: <> nvl(p_contact_type, hr_api.g_varchar2))
685: or p_contact_relationship_id is null then
686: --
687: open csr_chk_time_validation;
680: <> nvl(p_date_start, hr_api.g_date)
681: or nvl(per_ctr_shd.g_old_rec.date_end, hr_api.g_date)
682: <> nvl(p_date_end, hr_api.g_date)
683: or nvl(per_ctr_shd.g_old_rec.contact_type, hr_api.g_varchar2)
684: <> nvl(p_contact_type, hr_api.g_varchar2))
685: or p_contact_relationship_id is null then
686: --
687: open csr_chk_time_validation;
688: fetch csr_chk_time_validation into l_records;
770: hr_utility.set_location(l_proc, 1);
771: --
772: if p_contact_relationship_id is null or
773: (p_contact_relationship_id is not null and
774: nvl(per_ctr_shd.g_old_rec.sequence_number,hr_api.g_number)
775: <> nvl(p_sequence_number,hr_api.g_number)) then
776: --
777: if p_sequence_number is not null and
778: p_contact_person_id is not null then
771: --
772: if p_contact_relationship_id is null or
773: (p_contact_relationship_id is not null and
774: nvl(per_ctr_shd.g_old_rec.sequence_number,hr_api.g_number)
775: <> nvl(p_sequence_number,hr_api.g_number)) then
776: --
777: if p_sequence_number is not null and
778: p_contact_person_id is not null then
779: if per_ctr_shd.g_old_rec.sequence_number is null then
857: hr_utility.set_location('Entering:'|| l_proc, 1);
858: --
859: -- Check mandatory parameters have been set
860: --
861: hr_api.mandatory_arg_error
862: (p_api_name => l_proc
863: ,p_argument => 'person_id'
864: ,p_argument_value => p_person_id
865: );
868: --
869: --
870: -- Check mandatory parameters have been set
871: --
872: hr_api.mandatory_arg_error
873: (p_api_name => l_proc
874: ,p_argument => 'contact_person_id'
875: ,p_argument_value => p_contact_person_id
876: );
894: -- condition to check whether the relationship start date
895: -- is less than person's date of birth or less than contact date of birth.
896:
897: if p_date_start is not null and
898: ( p_date_start < nvl( l_person_date_of_birth,hr_api.g_sot ) or
899: p_date_start < nvl( l_contact_date_of_birth,hr_api.g_sot ) ) then
900: hr_utility.set_message('800','PER_50386_CON_SDT_LES_EMP_BDT');
901: hr_utility.raise_error;
902: end if;
895: -- is less than person's date of birth or less than contact date of birth.
896:
897: if p_date_start is not null and
898: ( p_date_start < nvl( l_person_date_of_birth,hr_api.g_sot ) or
899: p_date_start < nvl( l_contact_date_of_birth,hr_api.g_sot ) ) then
900: hr_utility.set_message('800','PER_50386_CON_SDT_LES_EMP_BDT');
901: hr_utility.raise_error;
902: end if;
903: --
934: --
935: hr_utility.set_location(l_proc, 6);
936: --
937: --
938: if nvl(p_rec.business_group_id, hr_api.g_number) <>
939: per_ctr_shd.g_old_rec.business_group_id then
940: l_argument := 'business_group_id';
941: raise l_error;
942: end if;
940: l_argument := 'business_group_id';
941: raise l_error;
942: end if;
943: --
944: if nvl(p_rec.person_id, hr_api.g_number) <>
945: per_ctr_shd.g_old_rec.person_id then
946: l_argument := 'person_id';
947: raise l_error;
948: end if;
946: l_argument := 'person_id';
947: raise l_error;
948: end if;
949: --
950: if nvl(p_rec.contact_person_id, hr_api.g_number) <>
951: per_ctr_shd.g_old_rec.contact_person_id then
952: l_argument := 'contact_person_id';
953: raise l_error;
954: end if;
954: end if;
955: --
956: exception
957: when l_error then
958: hr_api.argument_changed_error
959: (p_api_name => l_proc
960: ,p_argument => l_argument);
961: when others then
962: raise;
998: begin
999: hr_utility.set_location('Entering:'||l_proc, 10);
1000: --
1001: if ((p_rec.contact_relationship_id is not null) and (
1002: nvl(per_ctr_shd.g_old_rec.cont_attribute_category, hr_api.g_varchar2) <>
1003: nvl(p_rec.cont_attribute_category, hr_api.g_varchar2) or
1004: nvl(per_ctr_shd.g_old_rec.cont_attribute1, hr_api.g_varchar2) <>
1005: nvl(p_rec.cont_attribute1, hr_api.g_varchar2) or
1006: nvl(per_ctr_shd.g_old_rec.cont_attribute2, hr_api.g_varchar2) <>
999: hr_utility.set_location('Entering:'||l_proc, 10);
1000: --
1001: if ((p_rec.contact_relationship_id is not null) and (
1002: nvl(per_ctr_shd.g_old_rec.cont_attribute_category, hr_api.g_varchar2) <>
1003: nvl(p_rec.cont_attribute_category, hr_api.g_varchar2) or
1004: nvl(per_ctr_shd.g_old_rec.cont_attribute1, hr_api.g_varchar2) <>
1005: nvl(p_rec.cont_attribute1, hr_api.g_varchar2) or
1006: nvl(per_ctr_shd.g_old_rec.cont_attribute2, hr_api.g_varchar2) <>
1007: nvl(p_rec.cont_attribute2, hr_api.g_varchar2) or
1000: --
1001: if ((p_rec.contact_relationship_id is not null) and (
1002: nvl(per_ctr_shd.g_old_rec.cont_attribute_category, hr_api.g_varchar2) <>
1003: nvl(p_rec.cont_attribute_category, hr_api.g_varchar2) or
1004: nvl(per_ctr_shd.g_old_rec.cont_attribute1, hr_api.g_varchar2) <>
1005: nvl(p_rec.cont_attribute1, hr_api.g_varchar2) or
1006: nvl(per_ctr_shd.g_old_rec.cont_attribute2, hr_api.g_varchar2) <>
1007: nvl(p_rec.cont_attribute2, hr_api.g_varchar2) or
1008: nvl(per_ctr_shd.g_old_rec.cont_attribute3, hr_api.g_varchar2) <>
1001: if ((p_rec.contact_relationship_id is not null) and (
1002: nvl(per_ctr_shd.g_old_rec.cont_attribute_category, hr_api.g_varchar2) <>
1003: nvl(p_rec.cont_attribute_category, hr_api.g_varchar2) or
1004: nvl(per_ctr_shd.g_old_rec.cont_attribute1, hr_api.g_varchar2) <>
1005: nvl(p_rec.cont_attribute1, hr_api.g_varchar2) or
1006: nvl(per_ctr_shd.g_old_rec.cont_attribute2, hr_api.g_varchar2) <>
1007: nvl(p_rec.cont_attribute2, hr_api.g_varchar2) or
1008: nvl(per_ctr_shd.g_old_rec.cont_attribute3, hr_api.g_varchar2) <>
1009: nvl(p_rec.cont_attribute3, hr_api.g_varchar2) or
1002: nvl(per_ctr_shd.g_old_rec.cont_attribute_category, hr_api.g_varchar2) <>
1003: nvl(p_rec.cont_attribute_category, hr_api.g_varchar2) or
1004: nvl(per_ctr_shd.g_old_rec.cont_attribute1, hr_api.g_varchar2) <>
1005: nvl(p_rec.cont_attribute1, hr_api.g_varchar2) or
1006: nvl(per_ctr_shd.g_old_rec.cont_attribute2, hr_api.g_varchar2) <>
1007: nvl(p_rec.cont_attribute2, hr_api.g_varchar2) or
1008: nvl(per_ctr_shd.g_old_rec.cont_attribute3, hr_api.g_varchar2) <>
1009: nvl(p_rec.cont_attribute3, hr_api.g_varchar2) or
1010: nvl(per_ctr_shd.g_old_rec.cont_attribute4, hr_api.g_varchar2) <>
1003: nvl(p_rec.cont_attribute_category, hr_api.g_varchar2) or
1004: nvl(per_ctr_shd.g_old_rec.cont_attribute1, hr_api.g_varchar2) <>
1005: nvl(p_rec.cont_attribute1, hr_api.g_varchar2) or
1006: nvl(per_ctr_shd.g_old_rec.cont_attribute2, hr_api.g_varchar2) <>
1007: nvl(p_rec.cont_attribute2, hr_api.g_varchar2) or
1008: nvl(per_ctr_shd.g_old_rec.cont_attribute3, hr_api.g_varchar2) <>
1009: nvl(p_rec.cont_attribute3, hr_api.g_varchar2) or
1010: nvl(per_ctr_shd.g_old_rec.cont_attribute4, hr_api.g_varchar2) <>
1011: nvl(p_rec.cont_attribute4, hr_api.g_varchar2) or
1004: nvl(per_ctr_shd.g_old_rec.cont_attribute1, hr_api.g_varchar2) <>
1005: nvl(p_rec.cont_attribute1, hr_api.g_varchar2) or
1006: nvl(per_ctr_shd.g_old_rec.cont_attribute2, hr_api.g_varchar2) <>
1007: nvl(p_rec.cont_attribute2, hr_api.g_varchar2) or
1008: nvl(per_ctr_shd.g_old_rec.cont_attribute3, hr_api.g_varchar2) <>
1009: nvl(p_rec.cont_attribute3, hr_api.g_varchar2) or
1010: nvl(per_ctr_shd.g_old_rec.cont_attribute4, hr_api.g_varchar2) <>
1011: nvl(p_rec.cont_attribute4, hr_api.g_varchar2) or
1012: nvl(per_ctr_shd.g_old_rec.cont_attribute5, hr_api.g_varchar2) <>
1005: nvl(p_rec.cont_attribute1, hr_api.g_varchar2) or
1006: nvl(per_ctr_shd.g_old_rec.cont_attribute2, hr_api.g_varchar2) <>
1007: nvl(p_rec.cont_attribute2, hr_api.g_varchar2) or
1008: nvl(per_ctr_shd.g_old_rec.cont_attribute3, hr_api.g_varchar2) <>
1009: nvl(p_rec.cont_attribute3, hr_api.g_varchar2) or
1010: nvl(per_ctr_shd.g_old_rec.cont_attribute4, hr_api.g_varchar2) <>
1011: nvl(p_rec.cont_attribute4, hr_api.g_varchar2) or
1012: nvl(per_ctr_shd.g_old_rec.cont_attribute5, hr_api.g_varchar2) <>
1013: nvl(p_rec.cont_attribute5, hr_api.g_varchar2) or
1006: nvl(per_ctr_shd.g_old_rec.cont_attribute2, hr_api.g_varchar2) <>
1007: nvl(p_rec.cont_attribute2, hr_api.g_varchar2) or
1008: nvl(per_ctr_shd.g_old_rec.cont_attribute3, hr_api.g_varchar2) <>
1009: nvl(p_rec.cont_attribute3, hr_api.g_varchar2) or
1010: nvl(per_ctr_shd.g_old_rec.cont_attribute4, hr_api.g_varchar2) <>
1011: nvl(p_rec.cont_attribute4, hr_api.g_varchar2) or
1012: nvl(per_ctr_shd.g_old_rec.cont_attribute5, hr_api.g_varchar2) <>
1013: nvl(p_rec.cont_attribute5, hr_api.g_varchar2) or
1014: nvl(per_ctr_shd.g_old_rec.cont_attribute6, hr_api.g_varchar2) <>
1007: nvl(p_rec.cont_attribute2, hr_api.g_varchar2) or
1008: nvl(per_ctr_shd.g_old_rec.cont_attribute3, hr_api.g_varchar2) <>
1009: nvl(p_rec.cont_attribute3, hr_api.g_varchar2) or
1010: nvl(per_ctr_shd.g_old_rec.cont_attribute4, hr_api.g_varchar2) <>
1011: nvl(p_rec.cont_attribute4, hr_api.g_varchar2) or
1012: nvl(per_ctr_shd.g_old_rec.cont_attribute5, hr_api.g_varchar2) <>
1013: nvl(p_rec.cont_attribute5, hr_api.g_varchar2) or
1014: nvl(per_ctr_shd.g_old_rec.cont_attribute6, hr_api.g_varchar2) <>
1015: nvl(p_rec.cont_attribute6, hr_api.g_varchar2) or
1008: nvl(per_ctr_shd.g_old_rec.cont_attribute3, hr_api.g_varchar2) <>
1009: nvl(p_rec.cont_attribute3, hr_api.g_varchar2) or
1010: nvl(per_ctr_shd.g_old_rec.cont_attribute4, hr_api.g_varchar2) <>
1011: nvl(p_rec.cont_attribute4, hr_api.g_varchar2) or
1012: nvl(per_ctr_shd.g_old_rec.cont_attribute5, hr_api.g_varchar2) <>
1013: nvl(p_rec.cont_attribute5, hr_api.g_varchar2) or
1014: nvl(per_ctr_shd.g_old_rec.cont_attribute6, hr_api.g_varchar2) <>
1015: nvl(p_rec.cont_attribute6, hr_api.g_varchar2) or
1016: nvl(per_ctr_shd.g_old_rec.cont_attribute7, hr_api.g_varchar2) <>
1009: nvl(p_rec.cont_attribute3, hr_api.g_varchar2) or
1010: nvl(per_ctr_shd.g_old_rec.cont_attribute4, hr_api.g_varchar2) <>
1011: nvl(p_rec.cont_attribute4, hr_api.g_varchar2) or
1012: nvl(per_ctr_shd.g_old_rec.cont_attribute5, hr_api.g_varchar2) <>
1013: nvl(p_rec.cont_attribute5, hr_api.g_varchar2) or
1014: nvl(per_ctr_shd.g_old_rec.cont_attribute6, hr_api.g_varchar2) <>
1015: nvl(p_rec.cont_attribute6, hr_api.g_varchar2) or
1016: nvl(per_ctr_shd.g_old_rec.cont_attribute7, hr_api.g_varchar2) <>
1017: nvl(p_rec.cont_attribute7, hr_api.g_varchar2) or
1010: nvl(per_ctr_shd.g_old_rec.cont_attribute4, hr_api.g_varchar2) <>
1011: nvl(p_rec.cont_attribute4, hr_api.g_varchar2) or
1012: nvl(per_ctr_shd.g_old_rec.cont_attribute5, hr_api.g_varchar2) <>
1013: nvl(p_rec.cont_attribute5, hr_api.g_varchar2) or
1014: nvl(per_ctr_shd.g_old_rec.cont_attribute6, hr_api.g_varchar2) <>
1015: nvl(p_rec.cont_attribute6, hr_api.g_varchar2) or
1016: nvl(per_ctr_shd.g_old_rec.cont_attribute7, hr_api.g_varchar2) <>
1017: nvl(p_rec.cont_attribute7, hr_api.g_varchar2) or
1018: nvl(per_ctr_shd.g_old_rec.cont_attribute8, hr_api.g_varchar2) <>
1011: nvl(p_rec.cont_attribute4, hr_api.g_varchar2) or
1012: nvl(per_ctr_shd.g_old_rec.cont_attribute5, hr_api.g_varchar2) <>
1013: nvl(p_rec.cont_attribute5, hr_api.g_varchar2) or
1014: nvl(per_ctr_shd.g_old_rec.cont_attribute6, hr_api.g_varchar2) <>
1015: nvl(p_rec.cont_attribute6, hr_api.g_varchar2) or
1016: nvl(per_ctr_shd.g_old_rec.cont_attribute7, hr_api.g_varchar2) <>
1017: nvl(p_rec.cont_attribute7, hr_api.g_varchar2) or
1018: nvl(per_ctr_shd.g_old_rec.cont_attribute8, hr_api.g_varchar2) <>
1019: nvl(p_rec.cont_attribute8, hr_api.g_varchar2) or
1012: nvl(per_ctr_shd.g_old_rec.cont_attribute5, hr_api.g_varchar2) <>
1013: nvl(p_rec.cont_attribute5, hr_api.g_varchar2) or
1014: nvl(per_ctr_shd.g_old_rec.cont_attribute6, hr_api.g_varchar2) <>
1015: nvl(p_rec.cont_attribute6, hr_api.g_varchar2) or
1016: nvl(per_ctr_shd.g_old_rec.cont_attribute7, hr_api.g_varchar2) <>
1017: nvl(p_rec.cont_attribute7, hr_api.g_varchar2) or
1018: nvl(per_ctr_shd.g_old_rec.cont_attribute8, hr_api.g_varchar2) <>
1019: nvl(p_rec.cont_attribute8, hr_api.g_varchar2) or
1020: nvl(per_ctr_shd.g_old_rec.cont_attribute9, hr_api.g_varchar2) <>
1013: nvl(p_rec.cont_attribute5, hr_api.g_varchar2) or
1014: nvl(per_ctr_shd.g_old_rec.cont_attribute6, hr_api.g_varchar2) <>
1015: nvl(p_rec.cont_attribute6, hr_api.g_varchar2) or
1016: nvl(per_ctr_shd.g_old_rec.cont_attribute7, hr_api.g_varchar2) <>
1017: nvl(p_rec.cont_attribute7, hr_api.g_varchar2) or
1018: nvl(per_ctr_shd.g_old_rec.cont_attribute8, hr_api.g_varchar2) <>
1019: nvl(p_rec.cont_attribute8, hr_api.g_varchar2) or
1020: nvl(per_ctr_shd.g_old_rec.cont_attribute9, hr_api.g_varchar2) <>
1021: nvl(p_rec.cont_attribute9, hr_api.g_varchar2) or
1014: nvl(per_ctr_shd.g_old_rec.cont_attribute6, hr_api.g_varchar2) <>
1015: nvl(p_rec.cont_attribute6, hr_api.g_varchar2) or
1016: nvl(per_ctr_shd.g_old_rec.cont_attribute7, hr_api.g_varchar2) <>
1017: nvl(p_rec.cont_attribute7, hr_api.g_varchar2) or
1018: nvl(per_ctr_shd.g_old_rec.cont_attribute8, hr_api.g_varchar2) <>
1019: nvl(p_rec.cont_attribute8, hr_api.g_varchar2) or
1020: nvl(per_ctr_shd.g_old_rec.cont_attribute9, hr_api.g_varchar2) <>
1021: nvl(p_rec.cont_attribute9, hr_api.g_varchar2) or
1022: nvl(per_ctr_shd.g_old_rec.cont_attribute10, hr_api.g_varchar2) <>
1015: nvl(p_rec.cont_attribute6, hr_api.g_varchar2) or
1016: nvl(per_ctr_shd.g_old_rec.cont_attribute7, hr_api.g_varchar2) <>
1017: nvl(p_rec.cont_attribute7, hr_api.g_varchar2) or
1018: nvl(per_ctr_shd.g_old_rec.cont_attribute8, hr_api.g_varchar2) <>
1019: nvl(p_rec.cont_attribute8, hr_api.g_varchar2) or
1020: nvl(per_ctr_shd.g_old_rec.cont_attribute9, hr_api.g_varchar2) <>
1021: nvl(p_rec.cont_attribute9, hr_api.g_varchar2) or
1022: nvl(per_ctr_shd.g_old_rec.cont_attribute10, hr_api.g_varchar2) <>
1023: nvl(p_rec.cont_attribute10, hr_api.g_varchar2) or
1016: nvl(per_ctr_shd.g_old_rec.cont_attribute7, hr_api.g_varchar2) <>
1017: nvl(p_rec.cont_attribute7, hr_api.g_varchar2) or
1018: nvl(per_ctr_shd.g_old_rec.cont_attribute8, hr_api.g_varchar2) <>
1019: nvl(p_rec.cont_attribute8, hr_api.g_varchar2) or
1020: nvl(per_ctr_shd.g_old_rec.cont_attribute9, hr_api.g_varchar2) <>
1021: nvl(p_rec.cont_attribute9, hr_api.g_varchar2) or
1022: nvl(per_ctr_shd.g_old_rec.cont_attribute10, hr_api.g_varchar2) <>
1023: nvl(p_rec.cont_attribute10, hr_api.g_varchar2) or
1024: nvl(per_ctr_shd.g_old_rec.cont_attribute11, hr_api.g_varchar2) <>
1017: nvl(p_rec.cont_attribute7, hr_api.g_varchar2) or
1018: nvl(per_ctr_shd.g_old_rec.cont_attribute8, hr_api.g_varchar2) <>
1019: nvl(p_rec.cont_attribute8, hr_api.g_varchar2) or
1020: nvl(per_ctr_shd.g_old_rec.cont_attribute9, hr_api.g_varchar2) <>
1021: nvl(p_rec.cont_attribute9, hr_api.g_varchar2) or
1022: nvl(per_ctr_shd.g_old_rec.cont_attribute10, hr_api.g_varchar2) <>
1023: nvl(p_rec.cont_attribute10, hr_api.g_varchar2) or
1024: nvl(per_ctr_shd.g_old_rec.cont_attribute11, hr_api.g_varchar2) <>
1025: nvl(p_rec.cont_attribute11, hr_api.g_varchar2) or
1018: nvl(per_ctr_shd.g_old_rec.cont_attribute8, hr_api.g_varchar2) <>
1019: nvl(p_rec.cont_attribute8, hr_api.g_varchar2) or
1020: nvl(per_ctr_shd.g_old_rec.cont_attribute9, hr_api.g_varchar2) <>
1021: nvl(p_rec.cont_attribute9, hr_api.g_varchar2) or
1022: nvl(per_ctr_shd.g_old_rec.cont_attribute10, hr_api.g_varchar2) <>
1023: nvl(p_rec.cont_attribute10, hr_api.g_varchar2) or
1024: nvl(per_ctr_shd.g_old_rec.cont_attribute11, hr_api.g_varchar2) <>
1025: nvl(p_rec.cont_attribute11, hr_api.g_varchar2) or
1026: nvl(per_ctr_shd.g_old_rec.cont_attribute12, hr_api.g_varchar2) <>
1019: nvl(p_rec.cont_attribute8, hr_api.g_varchar2) or
1020: nvl(per_ctr_shd.g_old_rec.cont_attribute9, hr_api.g_varchar2) <>
1021: nvl(p_rec.cont_attribute9, hr_api.g_varchar2) or
1022: nvl(per_ctr_shd.g_old_rec.cont_attribute10, hr_api.g_varchar2) <>
1023: nvl(p_rec.cont_attribute10, hr_api.g_varchar2) or
1024: nvl(per_ctr_shd.g_old_rec.cont_attribute11, hr_api.g_varchar2) <>
1025: nvl(p_rec.cont_attribute11, hr_api.g_varchar2) or
1026: nvl(per_ctr_shd.g_old_rec.cont_attribute12, hr_api.g_varchar2) <>
1027: nvl(p_rec.cont_attribute12, hr_api.g_varchar2) or
1020: nvl(per_ctr_shd.g_old_rec.cont_attribute9, hr_api.g_varchar2) <>
1021: nvl(p_rec.cont_attribute9, hr_api.g_varchar2) or
1022: nvl(per_ctr_shd.g_old_rec.cont_attribute10, hr_api.g_varchar2) <>
1023: nvl(p_rec.cont_attribute10, hr_api.g_varchar2) or
1024: nvl(per_ctr_shd.g_old_rec.cont_attribute11, hr_api.g_varchar2) <>
1025: nvl(p_rec.cont_attribute11, hr_api.g_varchar2) or
1026: nvl(per_ctr_shd.g_old_rec.cont_attribute12, hr_api.g_varchar2) <>
1027: nvl(p_rec.cont_attribute12, hr_api.g_varchar2) or
1028: nvl(per_ctr_shd.g_old_rec.cont_attribute13, hr_api.g_varchar2) <>
1021: nvl(p_rec.cont_attribute9, hr_api.g_varchar2) or
1022: nvl(per_ctr_shd.g_old_rec.cont_attribute10, hr_api.g_varchar2) <>
1023: nvl(p_rec.cont_attribute10, hr_api.g_varchar2) or
1024: nvl(per_ctr_shd.g_old_rec.cont_attribute11, hr_api.g_varchar2) <>
1025: nvl(p_rec.cont_attribute11, hr_api.g_varchar2) or
1026: nvl(per_ctr_shd.g_old_rec.cont_attribute12, hr_api.g_varchar2) <>
1027: nvl(p_rec.cont_attribute12, hr_api.g_varchar2) or
1028: nvl(per_ctr_shd.g_old_rec.cont_attribute13, hr_api.g_varchar2) <>
1029: nvl(p_rec.cont_attribute13, hr_api.g_varchar2) or
1022: nvl(per_ctr_shd.g_old_rec.cont_attribute10, hr_api.g_varchar2) <>
1023: nvl(p_rec.cont_attribute10, hr_api.g_varchar2) or
1024: nvl(per_ctr_shd.g_old_rec.cont_attribute11, hr_api.g_varchar2) <>
1025: nvl(p_rec.cont_attribute11, hr_api.g_varchar2) or
1026: nvl(per_ctr_shd.g_old_rec.cont_attribute12, hr_api.g_varchar2) <>
1027: nvl(p_rec.cont_attribute12, hr_api.g_varchar2) or
1028: nvl(per_ctr_shd.g_old_rec.cont_attribute13, hr_api.g_varchar2) <>
1029: nvl(p_rec.cont_attribute13, hr_api.g_varchar2) or
1030: nvl(per_ctr_shd.g_old_rec.cont_attribute14, hr_api.g_varchar2) <>
1023: nvl(p_rec.cont_attribute10, hr_api.g_varchar2) or
1024: nvl(per_ctr_shd.g_old_rec.cont_attribute11, hr_api.g_varchar2) <>
1025: nvl(p_rec.cont_attribute11, hr_api.g_varchar2) or
1026: nvl(per_ctr_shd.g_old_rec.cont_attribute12, hr_api.g_varchar2) <>
1027: nvl(p_rec.cont_attribute12, hr_api.g_varchar2) or
1028: nvl(per_ctr_shd.g_old_rec.cont_attribute13, hr_api.g_varchar2) <>
1029: nvl(p_rec.cont_attribute13, hr_api.g_varchar2) or
1030: nvl(per_ctr_shd.g_old_rec.cont_attribute14, hr_api.g_varchar2) <>
1031: nvl(p_rec.cont_attribute14, hr_api.g_varchar2) or
1024: nvl(per_ctr_shd.g_old_rec.cont_attribute11, hr_api.g_varchar2) <>
1025: nvl(p_rec.cont_attribute11, hr_api.g_varchar2) or
1026: nvl(per_ctr_shd.g_old_rec.cont_attribute12, hr_api.g_varchar2) <>
1027: nvl(p_rec.cont_attribute12, hr_api.g_varchar2) or
1028: nvl(per_ctr_shd.g_old_rec.cont_attribute13, hr_api.g_varchar2) <>
1029: nvl(p_rec.cont_attribute13, hr_api.g_varchar2) or
1030: nvl(per_ctr_shd.g_old_rec.cont_attribute14, hr_api.g_varchar2) <>
1031: nvl(p_rec.cont_attribute14, hr_api.g_varchar2) or
1032: nvl(per_ctr_shd.g_old_rec.cont_attribute15, hr_api.g_varchar2) <>
1025: nvl(p_rec.cont_attribute11, hr_api.g_varchar2) or
1026: nvl(per_ctr_shd.g_old_rec.cont_attribute12, hr_api.g_varchar2) <>
1027: nvl(p_rec.cont_attribute12, hr_api.g_varchar2) or
1028: nvl(per_ctr_shd.g_old_rec.cont_attribute13, hr_api.g_varchar2) <>
1029: nvl(p_rec.cont_attribute13, hr_api.g_varchar2) or
1030: nvl(per_ctr_shd.g_old_rec.cont_attribute14, hr_api.g_varchar2) <>
1031: nvl(p_rec.cont_attribute14, hr_api.g_varchar2) or
1032: nvl(per_ctr_shd.g_old_rec.cont_attribute15, hr_api.g_varchar2) <>
1033: nvl(p_rec.cont_attribute15, hr_api.g_varchar2) or
1026: nvl(per_ctr_shd.g_old_rec.cont_attribute12, hr_api.g_varchar2) <>
1027: nvl(p_rec.cont_attribute12, hr_api.g_varchar2) or
1028: nvl(per_ctr_shd.g_old_rec.cont_attribute13, hr_api.g_varchar2) <>
1029: nvl(p_rec.cont_attribute13, hr_api.g_varchar2) or
1030: nvl(per_ctr_shd.g_old_rec.cont_attribute14, hr_api.g_varchar2) <>
1031: nvl(p_rec.cont_attribute14, hr_api.g_varchar2) or
1032: nvl(per_ctr_shd.g_old_rec.cont_attribute15, hr_api.g_varchar2) <>
1033: nvl(p_rec.cont_attribute15, hr_api.g_varchar2) or
1034: nvl(per_ctr_shd.g_old_rec.cont_attribute16, hr_api.g_varchar2) <>
1027: nvl(p_rec.cont_attribute12, hr_api.g_varchar2) or
1028: nvl(per_ctr_shd.g_old_rec.cont_attribute13, hr_api.g_varchar2) <>
1029: nvl(p_rec.cont_attribute13, hr_api.g_varchar2) or
1030: nvl(per_ctr_shd.g_old_rec.cont_attribute14, hr_api.g_varchar2) <>
1031: nvl(p_rec.cont_attribute14, hr_api.g_varchar2) or
1032: nvl(per_ctr_shd.g_old_rec.cont_attribute15, hr_api.g_varchar2) <>
1033: nvl(p_rec.cont_attribute15, hr_api.g_varchar2) or
1034: nvl(per_ctr_shd.g_old_rec.cont_attribute16, hr_api.g_varchar2) <>
1035: nvl(p_rec.cont_attribute16, hr_api.g_varchar2) or
1028: nvl(per_ctr_shd.g_old_rec.cont_attribute13, hr_api.g_varchar2) <>
1029: nvl(p_rec.cont_attribute13, hr_api.g_varchar2) or
1030: nvl(per_ctr_shd.g_old_rec.cont_attribute14, hr_api.g_varchar2) <>
1031: nvl(p_rec.cont_attribute14, hr_api.g_varchar2) or
1032: nvl(per_ctr_shd.g_old_rec.cont_attribute15, hr_api.g_varchar2) <>
1033: nvl(p_rec.cont_attribute15, hr_api.g_varchar2) or
1034: nvl(per_ctr_shd.g_old_rec.cont_attribute16, hr_api.g_varchar2) <>
1035: nvl(p_rec.cont_attribute16, hr_api.g_varchar2) or
1036: nvl(per_ctr_shd.g_old_rec.cont_attribute17, hr_api.g_varchar2) <>
1029: nvl(p_rec.cont_attribute13, hr_api.g_varchar2) or
1030: nvl(per_ctr_shd.g_old_rec.cont_attribute14, hr_api.g_varchar2) <>
1031: nvl(p_rec.cont_attribute14, hr_api.g_varchar2) or
1032: nvl(per_ctr_shd.g_old_rec.cont_attribute15, hr_api.g_varchar2) <>
1033: nvl(p_rec.cont_attribute15, hr_api.g_varchar2) or
1034: nvl(per_ctr_shd.g_old_rec.cont_attribute16, hr_api.g_varchar2) <>
1035: nvl(p_rec.cont_attribute16, hr_api.g_varchar2) or
1036: nvl(per_ctr_shd.g_old_rec.cont_attribute17, hr_api.g_varchar2) <>
1037: nvl(p_rec.cont_attribute17, hr_api.g_varchar2) or
1030: nvl(per_ctr_shd.g_old_rec.cont_attribute14, hr_api.g_varchar2) <>
1031: nvl(p_rec.cont_attribute14, hr_api.g_varchar2) or
1032: nvl(per_ctr_shd.g_old_rec.cont_attribute15, hr_api.g_varchar2) <>
1033: nvl(p_rec.cont_attribute15, hr_api.g_varchar2) or
1034: nvl(per_ctr_shd.g_old_rec.cont_attribute16, hr_api.g_varchar2) <>
1035: nvl(p_rec.cont_attribute16, hr_api.g_varchar2) or
1036: nvl(per_ctr_shd.g_old_rec.cont_attribute17, hr_api.g_varchar2) <>
1037: nvl(p_rec.cont_attribute17, hr_api.g_varchar2) or
1038: nvl(per_ctr_shd.g_old_rec.cont_attribute18, hr_api.g_varchar2) <>
1031: nvl(p_rec.cont_attribute14, hr_api.g_varchar2) or
1032: nvl(per_ctr_shd.g_old_rec.cont_attribute15, hr_api.g_varchar2) <>
1033: nvl(p_rec.cont_attribute15, hr_api.g_varchar2) or
1034: nvl(per_ctr_shd.g_old_rec.cont_attribute16, hr_api.g_varchar2) <>
1035: nvl(p_rec.cont_attribute16, hr_api.g_varchar2) or
1036: nvl(per_ctr_shd.g_old_rec.cont_attribute17, hr_api.g_varchar2) <>
1037: nvl(p_rec.cont_attribute17, hr_api.g_varchar2) or
1038: nvl(per_ctr_shd.g_old_rec.cont_attribute18, hr_api.g_varchar2) <>
1039: nvl(p_rec.cont_attribute18, hr_api.g_varchar2) or
1032: nvl(per_ctr_shd.g_old_rec.cont_attribute15, hr_api.g_varchar2) <>
1033: nvl(p_rec.cont_attribute15, hr_api.g_varchar2) or
1034: nvl(per_ctr_shd.g_old_rec.cont_attribute16, hr_api.g_varchar2) <>
1035: nvl(p_rec.cont_attribute16, hr_api.g_varchar2) or
1036: nvl(per_ctr_shd.g_old_rec.cont_attribute17, hr_api.g_varchar2) <>
1037: nvl(p_rec.cont_attribute17, hr_api.g_varchar2) or
1038: nvl(per_ctr_shd.g_old_rec.cont_attribute18, hr_api.g_varchar2) <>
1039: nvl(p_rec.cont_attribute18, hr_api.g_varchar2) or
1040: nvl(per_ctr_shd.g_old_rec.cont_attribute19, hr_api.g_varchar2) <>
1033: nvl(p_rec.cont_attribute15, hr_api.g_varchar2) or
1034: nvl(per_ctr_shd.g_old_rec.cont_attribute16, hr_api.g_varchar2) <>
1035: nvl(p_rec.cont_attribute16, hr_api.g_varchar2) or
1036: nvl(per_ctr_shd.g_old_rec.cont_attribute17, hr_api.g_varchar2) <>
1037: nvl(p_rec.cont_attribute17, hr_api.g_varchar2) or
1038: nvl(per_ctr_shd.g_old_rec.cont_attribute18, hr_api.g_varchar2) <>
1039: nvl(p_rec.cont_attribute18, hr_api.g_varchar2) or
1040: nvl(per_ctr_shd.g_old_rec.cont_attribute19, hr_api.g_varchar2) <>
1041: nvl(p_rec.cont_attribute19, hr_api.g_varchar2) or
1034: nvl(per_ctr_shd.g_old_rec.cont_attribute16, hr_api.g_varchar2) <>
1035: nvl(p_rec.cont_attribute16, hr_api.g_varchar2) or
1036: nvl(per_ctr_shd.g_old_rec.cont_attribute17, hr_api.g_varchar2) <>
1037: nvl(p_rec.cont_attribute17, hr_api.g_varchar2) or
1038: nvl(per_ctr_shd.g_old_rec.cont_attribute18, hr_api.g_varchar2) <>
1039: nvl(p_rec.cont_attribute18, hr_api.g_varchar2) or
1040: nvl(per_ctr_shd.g_old_rec.cont_attribute19, hr_api.g_varchar2) <>
1041: nvl(p_rec.cont_attribute19, hr_api.g_varchar2) or
1042: nvl(per_ctr_shd.g_old_rec.cont_attribute20, hr_api.g_varchar2) <>
1035: nvl(p_rec.cont_attribute16, hr_api.g_varchar2) or
1036: nvl(per_ctr_shd.g_old_rec.cont_attribute17, hr_api.g_varchar2) <>
1037: nvl(p_rec.cont_attribute17, hr_api.g_varchar2) or
1038: nvl(per_ctr_shd.g_old_rec.cont_attribute18, hr_api.g_varchar2) <>
1039: nvl(p_rec.cont_attribute18, hr_api.g_varchar2) or
1040: nvl(per_ctr_shd.g_old_rec.cont_attribute19, hr_api.g_varchar2) <>
1041: nvl(p_rec.cont_attribute19, hr_api.g_varchar2) or
1042: nvl(per_ctr_shd.g_old_rec.cont_attribute20, hr_api.g_varchar2) <>
1043: nvl(p_rec.cont_attribute20, hr_api.g_varchar2)))
1036: nvl(per_ctr_shd.g_old_rec.cont_attribute17, hr_api.g_varchar2) <>
1037: nvl(p_rec.cont_attribute17, hr_api.g_varchar2) or
1038: nvl(per_ctr_shd.g_old_rec.cont_attribute18, hr_api.g_varchar2) <>
1039: nvl(p_rec.cont_attribute18, hr_api.g_varchar2) or
1040: nvl(per_ctr_shd.g_old_rec.cont_attribute19, hr_api.g_varchar2) <>
1041: nvl(p_rec.cont_attribute19, hr_api.g_varchar2) or
1042: nvl(per_ctr_shd.g_old_rec.cont_attribute20, hr_api.g_varchar2) <>
1043: nvl(p_rec.cont_attribute20, hr_api.g_varchar2)))
1044: or
1037: nvl(p_rec.cont_attribute17, hr_api.g_varchar2) or
1038: nvl(per_ctr_shd.g_old_rec.cont_attribute18, hr_api.g_varchar2) <>
1039: nvl(p_rec.cont_attribute18, hr_api.g_varchar2) or
1040: nvl(per_ctr_shd.g_old_rec.cont_attribute19, hr_api.g_varchar2) <>
1041: nvl(p_rec.cont_attribute19, hr_api.g_varchar2) or
1042: nvl(per_ctr_shd.g_old_rec.cont_attribute20, hr_api.g_varchar2) <>
1043: nvl(p_rec.cont_attribute20, hr_api.g_varchar2)))
1044: or
1045: (p_rec.contact_relationship_id is null) then
1038: nvl(per_ctr_shd.g_old_rec.cont_attribute18, hr_api.g_varchar2) <>
1039: nvl(p_rec.cont_attribute18, hr_api.g_varchar2) or
1040: nvl(per_ctr_shd.g_old_rec.cont_attribute19, hr_api.g_varchar2) <>
1041: nvl(p_rec.cont_attribute19, hr_api.g_varchar2) or
1042: nvl(per_ctr_shd.g_old_rec.cont_attribute20, hr_api.g_varchar2) <>
1043: nvl(p_rec.cont_attribute20, hr_api.g_varchar2)))
1044: or
1045: (p_rec.contact_relationship_id is null) then
1046: --
1039: nvl(p_rec.cont_attribute18, hr_api.g_varchar2) or
1040: nvl(per_ctr_shd.g_old_rec.cont_attribute19, hr_api.g_varchar2) <>
1041: nvl(p_rec.cont_attribute19, hr_api.g_varchar2) or
1042: nvl(per_ctr_shd.g_old_rec.cont_attribute20, hr_api.g_varchar2) <>
1043: nvl(p_rec.cont_attribute20, hr_api.g_varchar2)))
1044: or
1045: (p_rec.contact_relationship_id is null) then
1046: --
1047: -- Only execute the validation if absolutely necessary:
1134: begin
1135: hr_utility.set_location('Entering:'||l_proc, 10);
1136: --
1137: if ((p_rec.contact_relationship_id is not null) and (
1138: nvl(per_ctr_shd.g_old_rec.cont_information_category, hr_api.g_varchar2) <>
1139: nvl(p_rec.cont_information_category, hr_api.g_varchar2) or
1140: nvl(per_ctr_shd.g_old_rec.cont_information1, hr_api.g_varchar2) <>
1141: nvl(p_rec.cont_information1, hr_api.g_varchar2) or
1142: nvl(per_ctr_shd.g_old_rec.cont_information2, hr_api.g_varchar2) <>
1135: hr_utility.set_location('Entering:'||l_proc, 10);
1136: --
1137: if ((p_rec.contact_relationship_id is not null) and (
1138: nvl(per_ctr_shd.g_old_rec.cont_information_category, hr_api.g_varchar2) <>
1139: nvl(p_rec.cont_information_category, hr_api.g_varchar2) or
1140: nvl(per_ctr_shd.g_old_rec.cont_information1, hr_api.g_varchar2) <>
1141: nvl(p_rec.cont_information1, hr_api.g_varchar2) or
1142: nvl(per_ctr_shd.g_old_rec.cont_information2, hr_api.g_varchar2) <>
1143: nvl(p_rec.cont_information2, hr_api.g_varchar2) or
1136: --
1137: if ((p_rec.contact_relationship_id is not null) and (
1138: nvl(per_ctr_shd.g_old_rec.cont_information_category, hr_api.g_varchar2) <>
1139: nvl(p_rec.cont_information_category, hr_api.g_varchar2) or
1140: nvl(per_ctr_shd.g_old_rec.cont_information1, hr_api.g_varchar2) <>
1141: nvl(p_rec.cont_information1, hr_api.g_varchar2) or
1142: nvl(per_ctr_shd.g_old_rec.cont_information2, hr_api.g_varchar2) <>
1143: nvl(p_rec.cont_information2, hr_api.g_varchar2) or
1144: nvl(per_ctr_shd.g_old_rec.cont_information3, hr_api.g_varchar2) <>
1137: if ((p_rec.contact_relationship_id is not null) and (
1138: nvl(per_ctr_shd.g_old_rec.cont_information_category, hr_api.g_varchar2) <>
1139: nvl(p_rec.cont_information_category, hr_api.g_varchar2) or
1140: nvl(per_ctr_shd.g_old_rec.cont_information1, hr_api.g_varchar2) <>
1141: nvl(p_rec.cont_information1, hr_api.g_varchar2) or
1142: nvl(per_ctr_shd.g_old_rec.cont_information2, hr_api.g_varchar2) <>
1143: nvl(p_rec.cont_information2, hr_api.g_varchar2) or
1144: nvl(per_ctr_shd.g_old_rec.cont_information3, hr_api.g_varchar2) <>
1145: nvl(p_rec.cont_information3, hr_api.g_varchar2) or
1138: nvl(per_ctr_shd.g_old_rec.cont_information_category, hr_api.g_varchar2) <>
1139: nvl(p_rec.cont_information_category, hr_api.g_varchar2) or
1140: nvl(per_ctr_shd.g_old_rec.cont_information1, hr_api.g_varchar2) <>
1141: nvl(p_rec.cont_information1, hr_api.g_varchar2) or
1142: nvl(per_ctr_shd.g_old_rec.cont_information2, hr_api.g_varchar2) <>
1143: nvl(p_rec.cont_information2, hr_api.g_varchar2) or
1144: nvl(per_ctr_shd.g_old_rec.cont_information3, hr_api.g_varchar2) <>
1145: nvl(p_rec.cont_information3, hr_api.g_varchar2) or
1146: nvl(per_ctr_shd.g_old_rec.cont_information4, hr_api.g_varchar2) <>
1139: nvl(p_rec.cont_information_category, hr_api.g_varchar2) or
1140: nvl(per_ctr_shd.g_old_rec.cont_information1, hr_api.g_varchar2) <>
1141: nvl(p_rec.cont_information1, hr_api.g_varchar2) or
1142: nvl(per_ctr_shd.g_old_rec.cont_information2, hr_api.g_varchar2) <>
1143: nvl(p_rec.cont_information2, hr_api.g_varchar2) or
1144: nvl(per_ctr_shd.g_old_rec.cont_information3, hr_api.g_varchar2) <>
1145: nvl(p_rec.cont_information3, hr_api.g_varchar2) or
1146: nvl(per_ctr_shd.g_old_rec.cont_information4, hr_api.g_varchar2) <>
1147: nvl(p_rec.cont_information4, hr_api.g_varchar2) or
1140: nvl(per_ctr_shd.g_old_rec.cont_information1, hr_api.g_varchar2) <>
1141: nvl(p_rec.cont_information1, hr_api.g_varchar2) or
1142: nvl(per_ctr_shd.g_old_rec.cont_information2, hr_api.g_varchar2) <>
1143: nvl(p_rec.cont_information2, hr_api.g_varchar2) or
1144: nvl(per_ctr_shd.g_old_rec.cont_information3, hr_api.g_varchar2) <>
1145: nvl(p_rec.cont_information3, hr_api.g_varchar2) or
1146: nvl(per_ctr_shd.g_old_rec.cont_information4, hr_api.g_varchar2) <>
1147: nvl(p_rec.cont_information4, hr_api.g_varchar2) or
1148: nvl(per_ctr_shd.g_old_rec.cont_information5, hr_api.g_varchar2) <>
1141: nvl(p_rec.cont_information1, hr_api.g_varchar2) or
1142: nvl(per_ctr_shd.g_old_rec.cont_information2, hr_api.g_varchar2) <>
1143: nvl(p_rec.cont_information2, hr_api.g_varchar2) or
1144: nvl(per_ctr_shd.g_old_rec.cont_information3, hr_api.g_varchar2) <>
1145: nvl(p_rec.cont_information3, hr_api.g_varchar2) or
1146: nvl(per_ctr_shd.g_old_rec.cont_information4, hr_api.g_varchar2) <>
1147: nvl(p_rec.cont_information4, hr_api.g_varchar2) or
1148: nvl(per_ctr_shd.g_old_rec.cont_information5, hr_api.g_varchar2) <>
1149: nvl(p_rec.cont_information5, hr_api.g_varchar2) or
1142: nvl(per_ctr_shd.g_old_rec.cont_information2, hr_api.g_varchar2) <>
1143: nvl(p_rec.cont_information2, hr_api.g_varchar2) or
1144: nvl(per_ctr_shd.g_old_rec.cont_information3, hr_api.g_varchar2) <>
1145: nvl(p_rec.cont_information3, hr_api.g_varchar2) or
1146: nvl(per_ctr_shd.g_old_rec.cont_information4, hr_api.g_varchar2) <>
1147: nvl(p_rec.cont_information4, hr_api.g_varchar2) or
1148: nvl(per_ctr_shd.g_old_rec.cont_information5, hr_api.g_varchar2) <>
1149: nvl(p_rec.cont_information5, hr_api.g_varchar2) or
1150: nvl(per_ctr_shd.g_old_rec.cont_information6, hr_api.g_varchar2) <>
1143: nvl(p_rec.cont_information2, hr_api.g_varchar2) or
1144: nvl(per_ctr_shd.g_old_rec.cont_information3, hr_api.g_varchar2) <>
1145: nvl(p_rec.cont_information3, hr_api.g_varchar2) or
1146: nvl(per_ctr_shd.g_old_rec.cont_information4, hr_api.g_varchar2) <>
1147: nvl(p_rec.cont_information4, hr_api.g_varchar2) or
1148: nvl(per_ctr_shd.g_old_rec.cont_information5, hr_api.g_varchar2) <>
1149: nvl(p_rec.cont_information5, hr_api.g_varchar2) or
1150: nvl(per_ctr_shd.g_old_rec.cont_information6, hr_api.g_varchar2) <>
1151: nvl(p_rec.cont_information6, hr_api.g_varchar2) or
1144: nvl(per_ctr_shd.g_old_rec.cont_information3, hr_api.g_varchar2) <>
1145: nvl(p_rec.cont_information3, hr_api.g_varchar2) or
1146: nvl(per_ctr_shd.g_old_rec.cont_information4, hr_api.g_varchar2) <>
1147: nvl(p_rec.cont_information4, hr_api.g_varchar2) or
1148: nvl(per_ctr_shd.g_old_rec.cont_information5, hr_api.g_varchar2) <>
1149: nvl(p_rec.cont_information5, hr_api.g_varchar2) or
1150: nvl(per_ctr_shd.g_old_rec.cont_information6, hr_api.g_varchar2) <>
1151: nvl(p_rec.cont_information6, hr_api.g_varchar2) or
1152: nvl(per_ctr_shd.g_old_rec.cont_information7, hr_api.g_varchar2) <>
1145: nvl(p_rec.cont_information3, hr_api.g_varchar2) or
1146: nvl(per_ctr_shd.g_old_rec.cont_information4, hr_api.g_varchar2) <>
1147: nvl(p_rec.cont_information4, hr_api.g_varchar2) or
1148: nvl(per_ctr_shd.g_old_rec.cont_information5, hr_api.g_varchar2) <>
1149: nvl(p_rec.cont_information5, hr_api.g_varchar2) or
1150: nvl(per_ctr_shd.g_old_rec.cont_information6, hr_api.g_varchar2) <>
1151: nvl(p_rec.cont_information6, hr_api.g_varchar2) or
1152: nvl(per_ctr_shd.g_old_rec.cont_information7, hr_api.g_varchar2) <>
1153: nvl(p_rec.cont_information7, hr_api.g_varchar2) or
1146: nvl(per_ctr_shd.g_old_rec.cont_information4, hr_api.g_varchar2) <>
1147: nvl(p_rec.cont_information4, hr_api.g_varchar2) or
1148: nvl(per_ctr_shd.g_old_rec.cont_information5, hr_api.g_varchar2) <>
1149: nvl(p_rec.cont_information5, hr_api.g_varchar2) or
1150: nvl(per_ctr_shd.g_old_rec.cont_information6, hr_api.g_varchar2) <>
1151: nvl(p_rec.cont_information6, hr_api.g_varchar2) or
1152: nvl(per_ctr_shd.g_old_rec.cont_information7, hr_api.g_varchar2) <>
1153: nvl(p_rec.cont_information7, hr_api.g_varchar2) or
1154: nvl(per_ctr_shd.g_old_rec.cont_information8, hr_api.g_varchar2) <>
1147: nvl(p_rec.cont_information4, hr_api.g_varchar2) or
1148: nvl(per_ctr_shd.g_old_rec.cont_information5, hr_api.g_varchar2) <>
1149: nvl(p_rec.cont_information5, hr_api.g_varchar2) or
1150: nvl(per_ctr_shd.g_old_rec.cont_information6, hr_api.g_varchar2) <>
1151: nvl(p_rec.cont_information6, hr_api.g_varchar2) or
1152: nvl(per_ctr_shd.g_old_rec.cont_information7, hr_api.g_varchar2) <>
1153: nvl(p_rec.cont_information7, hr_api.g_varchar2) or
1154: nvl(per_ctr_shd.g_old_rec.cont_information8, hr_api.g_varchar2) <>
1155: nvl(p_rec.cont_information8, hr_api.g_varchar2) or
1148: nvl(per_ctr_shd.g_old_rec.cont_information5, hr_api.g_varchar2) <>
1149: nvl(p_rec.cont_information5, hr_api.g_varchar2) or
1150: nvl(per_ctr_shd.g_old_rec.cont_information6, hr_api.g_varchar2) <>
1151: nvl(p_rec.cont_information6, hr_api.g_varchar2) or
1152: nvl(per_ctr_shd.g_old_rec.cont_information7, hr_api.g_varchar2) <>
1153: nvl(p_rec.cont_information7, hr_api.g_varchar2) or
1154: nvl(per_ctr_shd.g_old_rec.cont_information8, hr_api.g_varchar2) <>
1155: nvl(p_rec.cont_information8, hr_api.g_varchar2) or
1156: nvl(per_ctr_shd.g_old_rec.cont_information9, hr_api.g_varchar2) <>
1149: nvl(p_rec.cont_information5, hr_api.g_varchar2) or
1150: nvl(per_ctr_shd.g_old_rec.cont_information6, hr_api.g_varchar2) <>
1151: nvl(p_rec.cont_information6, hr_api.g_varchar2) or
1152: nvl(per_ctr_shd.g_old_rec.cont_information7, hr_api.g_varchar2) <>
1153: nvl(p_rec.cont_information7, hr_api.g_varchar2) or
1154: nvl(per_ctr_shd.g_old_rec.cont_information8, hr_api.g_varchar2) <>
1155: nvl(p_rec.cont_information8, hr_api.g_varchar2) or
1156: nvl(per_ctr_shd.g_old_rec.cont_information9, hr_api.g_varchar2) <>
1157: nvl(p_rec.cont_information9, hr_api.g_varchar2) or
1150: nvl(per_ctr_shd.g_old_rec.cont_information6, hr_api.g_varchar2) <>
1151: nvl(p_rec.cont_information6, hr_api.g_varchar2) or
1152: nvl(per_ctr_shd.g_old_rec.cont_information7, hr_api.g_varchar2) <>
1153: nvl(p_rec.cont_information7, hr_api.g_varchar2) or
1154: nvl(per_ctr_shd.g_old_rec.cont_information8, hr_api.g_varchar2) <>
1155: nvl(p_rec.cont_information8, hr_api.g_varchar2) or
1156: nvl(per_ctr_shd.g_old_rec.cont_information9, hr_api.g_varchar2) <>
1157: nvl(p_rec.cont_information9, hr_api.g_varchar2) or
1158: nvl(per_ctr_shd.g_old_rec.cont_information10, hr_api.g_varchar2) <>
1151: nvl(p_rec.cont_information6, hr_api.g_varchar2) or
1152: nvl(per_ctr_shd.g_old_rec.cont_information7, hr_api.g_varchar2) <>
1153: nvl(p_rec.cont_information7, hr_api.g_varchar2) or
1154: nvl(per_ctr_shd.g_old_rec.cont_information8, hr_api.g_varchar2) <>
1155: nvl(p_rec.cont_information8, hr_api.g_varchar2) or
1156: nvl(per_ctr_shd.g_old_rec.cont_information9, hr_api.g_varchar2) <>
1157: nvl(p_rec.cont_information9, hr_api.g_varchar2) or
1158: nvl(per_ctr_shd.g_old_rec.cont_information10, hr_api.g_varchar2) <>
1159: nvl(p_rec.cont_information10, hr_api.g_varchar2) or
1152: nvl(per_ctr_shd.g_old_rec.cont_information7, hr_api.g_varchar2) <>
1153: nvl(p_rec.cont_information7, hr_api.g_varchar2) or
1154: nvl(per_ctr_shd.g_old_rec.cont_information8, hr_api.g_varchar2) <>
1155: nvl(p_rec.cont_information8, hr_api.g_varchar2) or
1156: nvl(per_ctr_shd.g_old_rec.cont_information9, hr_api.g_varchar2) <>
1157: nvl(p_rec.cont_information9, hr_api.g_varchar2) or
1158: nvl(per_ctr_shd.g_old_rec.cont_information10, hr_api.g_varchar2) <>
1159: nvl(p_rec.cont_information10, hr_api.g_varchar2) or
1160: nvl(per_ctr_shd.g_old_rec.cont_information11, hr_api.g_varchar2) <>
1153: nvl(p_rec.cont_information7, hr_api.g_varchar2) or
1154: nvl(per_ctr_shd.g_old_rec.cont_information8, hr_api.g_varchar2) <>
1155: nvl(p_rec.cont_information8, hr_api.g_varchar2) or
1156: nvl(per_ctr_shd.g_old_rec.cont_information9, hr_api.g_varchar2) <>
1157: nvl(p_rec.cont_information9, hr_api.g_varchar2) or
1158: nvl(per_ctr_shd.g_old_rec.cont_information10, hr_api.g_varchar2) <>
1159: nvl(p_rec.cont_information10, hr_api.g_varchar2) or
1160: nvl(per_ctr_shd.g_old_rec.cont_information11, hr_api.g_varchar2) <>
1161: nvl(p_rec.cont_information11, hr_api.g_varchar2) or
1154: nvl(per_ctr_shd.g_old_rec.cont_information8, hr_api.g_varchar2) <>
1155: nvl(p_rec.cont_information8, hr_api.g_varchar2) or
1156: nvl(per_ctr_shd.g_old_rec.cont_information9, hr_api.g_varchar2) <>
1157: nvl(p_rec.cont_information9, hr_api.g_varchar2) or
1158: nvl(per_ctr_shd.g_old_rec.cont_information10, hr_api.g_varchar2) <>
1159: nvl(p_rec.cont_information10, hr_api.g_varchar2) or
1160: nvl(per_ctr_shd.g_old_rec.cont_information11, hr_api.g_varchar2) <>
1161: nvl(p_rec.cont_information11, hr_api.g_varchar2) or
1162: nvl(per_ctr_shd.g_old_rec.cont_information12, hr_api.g_varchar2) <>
1155: nvl(p_rec.cont_information8, hr_api.g_varchar2) or
1156: nvl(per_ctr_shd.g_old_rec.cont_information9, hr_api.g_varchar2) <>
1157: nvl(p_rec.cont_information9, hr_api.g_varchar2) or
1158: nvl(per_ctr_shd.g_old_rec.cont_information10, hr_api.g_varchar2) <>
1159: nvl(p_rec.cont_information10, hr_api.g_varchar2) or
1160: nvl(per_ctr_shd.g_old_rec.cont_information11, hr_api.g_varchar2) <>
1161: nvl(p_rec.cont_information11, hr_api.g_varchar2) or
1162: nvl(per_ctr_shd.g_old_rec.cont_information12, hr_api.g_varchar2) <>
1163: nvl(p_rec.cont_information12, hr_api.g_varchar2) or
1156: nvl(per_ctr_shd.g_old_rec.cont_information9, hr_api.g_varchar2) <>
1157: nvl(p_rec.cont_information9, hr_api.g_varchar2) or
1158: nvl(per_ctr_shd.g_old_rec.cont_information10, hr_api.g_varchar2) <>
1159: nvl(p_rec.cont_information10, hr_api.g_varchar2) or
1160: nvl(per_ctr_shd.g_old_rec.cont_information11, hr_api.g_varchar2) <>
1161: nvl(p_rec.cont_information11, hr_api.g_varchar2) or
1162: nvl(per_ctr_shd.g_old_rec.cont_information12, hr_api.g_varchar2) <>
1163: nvl(p_rec.cont_information12, hr_api.g_varchar2) or
1164: nvl(per_ctr_shd.g_old_rec.cont_information13, hr_api.g_varchar2) <>
1157: nvl(p_rec.cont_information9, hr_api.g_varchar2) or
1158: nvl(per_ctr_shd.g_old_rec.cont_information10, hr_api.g_varchar2) <>
1159: nvl(p_rec.cont_information10, hr_api.g_varchar2) or
1160: nvl(per_ctr_shd.g_old_rec.cont_information11, hr_api.g_varchar2) <>
1161: nvl(p_rec.cont_information11, hr_api.g_varchar2) or
1162: nvl(per_ctr_shd.g_old_rec.cont_information12, hr_api.g_varchar2) <>
1163: nvl(p_rec.cont_information12, hr_api.g_varchar2) or
1164: nvl(per_ctr_shd.g_old_rec.cont_information13, hr_api.g_varchar2) <>
1165: nvl(p_rec.cont_information13, hr_api.g_varchar2) or
1158: nvl(per_ctr_shd.g_old_rec.cont_information10, hr_api.g_varchar2) <>
1159: nvl(p_rec.cont_information10, hr_api.g_varchar2) or
1160: nvl(per_ctr_shd.g_old_rec.cont_information11, hr_api.g_varchar2) <>
1161: nvl(p_rec.cont_information11, hr_api.g_varchar2) or
1162: nvl(per_ctr_shd.g_old_rec.cont_information12, hr_api.g_varchar2) <>
1163: nvl(p_rec.cont_information12, hr_api.g_varchar2) or
1164: nvl(per_ctr_shd.g_old_rec.cont_information13, hr_api.g_varchar2) <>
1165: nvl(p_rec.cont_information13, hr_api.g_varchar2) or
1166: nvl(per_ctr_shd.g_old_rec.cont_information14, hr_api.g_varchar2) <>
1159: nvl(p_rec.cont_information10, hr_api.g_varchar2) or
1160: nvl(per_ctr_shd.g_old_rec.cont_information11, hr_api.g_varchar2) <>
1161: nvl(p_rec.cont_information11, hr_api.g_varchar2) or
1162: nvl(per_ctr_shd.g_old_rec.cont_information12, hr_api.g_varchar2) <>
1163: nvl(p_rec.cont_information12, hr_api.g_varchar2) or
1164: nvl(per_ctr_shd.g_old_rec.cont_information13, hr_api.g_varchar2) <>
1165: nvl(p_rec.cont_information13, hr_api.g_varchar2) or
1166: nvl(per_ctr_shd.g_old_rec.cont_information14, hr_api.g_varchar2) <>
1167: nvl(p_rec.cont_information14, hr_api.g_varchar2) or
1160: nvl(per_ctr_shd.g_old_rec.cont_information11, hr_api.g_varchar2) <>
1161: nvl(p_rec.cont_information11, hr_api.g_varchar2) or
1162: nvl(per_ctr_shd.g_old_rec.cont_information12, hr_api.g_varchar2) <>
1163: nvl(p_rec.cont_information12, hr_api.g_varchar2) or
1164: nvl(per_ctr_shd.g_old_rec.cont_information13, hr_api.g_varchar2) <>
1165: nvl(p_rec.cont_information13, hr_api.g_varchar2) or
1166: nvl(per_ctr_shd.g_old_rec.cont_information14, hr_api.g_varchar2) <>
1167: nvl(p_rec.cont_information14, hr_api.g_varchar2) or
1168: nvl(per_ctr_shd.g_old_rec.cont_information15, hr_api.g_varchar2) <>
1161: nvl(p_rec.cont_information11, hr_api.g_varchar2) or
1162: nvl(per_ctr_shd.g_old_rec.cont_information12, hr_api.g_varchar2) <>
1163: nvl(p_rec.cont_information12, hr_api.g_varchar2) or
1164: nvl(per_ctr_shd.g_old_rec.cont_information13, hr_api.g_varchar2) <>
1165: nvl(p_rec.cont_information13, hr_api.g_varchar2) or
1166: nvl(per_ctr_shd.g_old_rec.cont_information14, hr_api.g_varchar2) <>
1167: nvl(p_rec.cont_information14, hr_api.g_varchar2) or
1168: nvl(per_ctr_shd.g_old_rec.cont_information15, hr_api.g_varchar2) <>
1169: nvl(p_rec.cont_information15, hr_api.g_varchar2) or
1162: nvl(per_ctr_shd.g_old_rec.cont_information12, hr_api.g_varchar2) <>
1163: nvl(p_rec.cont_information12, hr_api.g_varchar2) or
1164: nvl(per_ctr_shd.g_old_rec.cont_information13, hr_api.g_varchar2) <>
1165: nvl(p_rec.cont_information13, hr_api.g_varchar2) or
1166: nvl(per_ctr_shd.g_old_rec.cont_information14, hr_api.g_varchar2) <>
1167: nvl(p_rec.cont_information14, hr_api.g_varchar2) or
1168: nvl(per_ctr_shd.g_old_rec.cont_information15, hr_api.g_varchar2) <>
1169: nvl(p_rec.cont_information15, hr_api.g_varchar2) or
1170: nvl(per_ctr_shd.g_old_rec.cont_information16, hr_api.g_varchar2) <>
1163: nvl(p_rec.cont_information12, hr_api.g_varchar2) or
1164: nvl(per_ctr_shd.g_old_rec.cont_information13, hr_api.g_varchar2) <>
1165: nvl(p_rec.cont_information13, hr_api.g_varchar2) or
1166: nvl(per_ctr_shd.g_old_rec.cont_information14, hr_api.g_varchar2) <>
1167: nvl(p_rec.cont_information14, hr_api.g_varchar2) or
1168: nvl(per_ctr_shd.g_old_rec.cont_information15, hr_api.g_varchar2) <>
1169: nvl(p_rec.cont_information15, hr_api.g_varchar2) or
1170: nvl(per_ctr_shd.g_old_rec.cont_information16, hr_api.g_varchar2) <>
1171: nvl(p_rec.cont_information16, hr_api.g_varchar2) or
1164: nvl(per_ctr_shd.g_old_rec.cont_information13, hr_api.g_varchar2) <>
1165: nvl(p_rec.cont_information13, hr_api.g_varchar2) or
1166: nvl(per_ctr_shd.g_old_rec.cont_information14, hr_api.g_varchar2) <>
1167: nvl(p_rec.cont_information14, hr_api.g_varchar2) or
1168: nvl(per_ctr_shd.g_old_rec.cont_information15, hr_api.g_varchar2) <>
1169: nvl(p_rec.cont_information15, hr_api.g_varchar2) or
1170: nvl(per_ctr_shd.g_old_rec.cont_information16, hr_api.g_varchar2) <>
1171: nvl(p_rec.cont_information16, hr_api.g_varchar2) or
1172: nvl(per_ctr_shd.g_old_rec.cont_information17, hr_api.g_varchar2) <>
1165: nvl(p_rec.cont_information13, hr_api.g_varchar2) or
1166: nvl(per_ctr_shd.g_old_rec.cont_information14, hr_api.g_varchar2) <>
1167: nvl(p_rec.cont_information14, hr_api.g_varchar2) or
1168: nvl(per_ctr_shd.g_old_rec.cont_information15, hr_api.g_varchar2) <>
1169: nvl(p_rec.cont_information15, hr_api.g_varchar2) or
1170: nvl(per_ctr_shd.g_old_rec.cont_information16, hr_api.g_varchar2) <>
1171: nvl(p_rec.cont_information16, hr_api.g_varchar2) or
1172: nvl(per_ctr_shd.g_old_rec.cont_information17, hr_api.g_varchar2) <>
1173: nvl(p_rec.cont_information17, hr_api.g_varchar2) or
1166: nvl(per_ctr_shd.g_old_rec.cont_information14, hr_api.g_varchar2) <>
1167: nvl(p_rec.cont_information14, hr_api.g_varchar2) or
1168: nvl(per_ctr_shd.g_old_rec.cont_information15, hr_api.g_varchar2) <>
1169: nvl(p_rec.cont_information15, hr_api.g_varchar2) or
1170: nvl(per_ctr_shd.g_old_rec.cont_information16, hr_api.g_varchar2) <>
1171: nvl(p_rec.cont_information16, hr_api.g_varchar2) or
1172: nvl(per_ctr_shd.g_old_rec.cont_information17, hr_api.g_varchar2) <>
1173: nvl(p_rec.cont_information17, hr_api.g_varchar2) or
1174: nvl(per_ctr_shd.g_old_rec.cont_information18, hr_api.g_varchar2) <>
1167: nvl(p_rec.cont_information14, hr_api.g_varchar2) or
1168: nvl(per_ctr_shd.g_old_rec.cont_information15, hr_api.g_varchar2) <>
1169: nvl(p_rec.cont_information15, hr_api.g_varchar2) or
1170: nvl(per_ctr_shd.g_old_rec.cont_information16, hr_api.g_varchar2) <>
1171: nvl(p_rec.cont_information16, hr_api.g_varchar2) or
1172: nvl(per_ctr_shd.g_old_rec.cont_information17, hr_api.g_varchar2) <>
1173: nvl(p_rec.cont_information17, hr_api.g_varchar2) or
1174: nvl(per_ctr_shd.g_old_rec.cont_information18, hr_api.g_varchar2) <>
1175: nvl(p_rec.cont_information18, hr_api.g_varchar2) or
1168: nvl(per_ctr_shd.g_old_rec.cont_information15, hr_api.g_varchar2) <>
1169: nvl(p_rec.cont_information15, hr_api.g_varchar2) or
1170: nvl(per_ctr_shd.g_old_rec.cont_information16, hr_api.g_varchar2) <>
1171: nvl(p_rec.cont_information16, hr_api.g_varchar2) or
1172: nvl(per_ctr_shd.g_old_rec.cont_information17, hr_api.g_varchar2) <>
1173: nvl(p_rec.cont_information17, hr_api.g_varchar2) or
1174: nvl(per_ctr_shd.g_old_rec.cont_information18, hr_api.g_varchar2) <>
1175: nvl(p_rec.cont_information18, hr_api.g_varchar2) or
1176: nvl(per_ctr_shd.g_old_rec.cont_information19, hr_api.g_varchar2) <>
1169: nvl(p_rec.cont_information15, hr_api.g_varchar2) or
1170: nvl(per_ctr_shd.g_old_rec.cont_information16, hr_api.g_varchar2) <>
1171: nvl(p_rec.cont_information16, hr_api.g_varchar2) or
1172: nvl(per_ctr_shd.g_old_rec.cont_information17, hr_api.g_varchar2) <>
1173: nvl(p_rec.cont_information17, hr_api.g_varchar2) or
1174: nvl(per_ctr_shd.g_old_rec.cont_information18, hr_api.g_varchar2) <>
1175: nvl(p_rec.cont_information18, hr_api.g_varchar2) or
1176: nvl(per_ctr_shd.g_old_rec.cont_information19, hr_api.g_varchar2) <>
1177: nvl(p_rec.cont_information19, hr_api.g_varchar2) or
1170: nvl(per_ctr_shd.g_old_rec.cont_information16, hr_api.g_varchar2) <>
1171: nvl(p_rec.cont_information16, hr_api.g_varchar2) or
1172: nvl(per_ctr_shd.g_old_rec.cont_information17, hr_api.g_varchar2) <>
1173: nvl(p_rec.cont_information17, hr_api.g_varchar2) or
1174: nvl(per_ctr_shd.g_old_rec.cont_information18, hr_api.g_varchar2) <>
1175: nvl(p_rec.cont_information18, hr_api.g_varchar2) or
1176: nvl(per_ctr_shd.g_old_rec.cont_information19, hr_api.g_varchar2) <>
1177: nvl(p_rec.cont_information19, hr_api.g_varchar2) or
1178: nvl(per_ctr_shd.g_old_rec.cont_information20, hr_api.g_varchar2) <>
1171: nvl(p_rec.cont_information16, hr_api.g_varchar2) or
1172: nvl(per_ctr_shd.g_old_rec.cont_information17, hr_api.g_varchar2) <>
1173: nvl(p_rec.cont_information17, hr_api.g_varchar2) or
1174: nvl(per_ctr_shd.g_old_rec.cont_information18, hr_api.g_varchar2) <>
1175: nvl(p_rec.cont_information18, hr_api.g_varchar2) or
1176: nvl(per_ctr_shd.g_old_rec.cont_information19, hr_api.g_varchar2) <>
1177: nvl(p_rec.cont_information19, hr_api.g_varchar2) or
1178: nvl(per_ctr_shd.g_old_rec.cont_information20, hr_api.g_varchar2) <>
1179: nvl(p_rec.cont_information20, hr_api.g_varchar2)))
1172: nvl(per_ctr_shd.g_old_rec.cont_information17, hr_api.g_varchar2) <>
1173: nvl(p_rec.cont_information17, hr_api.g_varchar2) or
1174: nvl(per_ctr_shd.g_old_rec.cont_information18, hr_api.g_varchar2) <>
1175: nvl(p_rec.cont_information18, hr_api.g_varchar2) or
1176: nvl(per_ctr_shd.g_old_rec.cont_information19, hr_api.g_varchar2) <>
1177: nvl(p_rec.cont_information19, hr_api.g_varchar2) or
1178: nvl(per_ctr_shd.g_old_rec.cont_information20, hr_api.g_varchar2) <>
1179: nvl(p_rec.cont_information20, hr_api.g_varchar2)))
1180: or
1173: nvl(p_rec.cont_information17, hr_api.g_varchar2) or
1174: nvl(per_ctr_shd.g_old_rec.cont_information18, hr_api.g_varchar2) <>
1175: nvl(p_rec.cont_information18, hr_api.g_varchar2) or
1176: nvl(per_ctr_shd.g_old_rec.cont_information19, hr_api.g_varchar2) <>
1177: nvl(p_rec.cont_information19, hr_api.g_varchar2) or
1178: nvl(per_ctr_shd.g_old_rec.cont_information20, hr_api.g_varchar2) <>
1179: nvl(p_rec.cont_information20, hr_api.g_varchar2)))
1180: or
1181: (p_rec.contact_relationship_id is null) then
1174: nvl(per_ctr_shd.g_old_rec.cont_information18, hr_api.g_varchar2) <>
1175: nvl(p_rec.cont_information18, hr_api.g_varchar2) or
1176: nvl(per_ctr_shd.g_old_rec.cont_information19, hr_api.g_varchar2) <>
1177: nvl(p_rec.cont_information19, hr_api.g_varchar2) or
1178: nvl(per_ctr_shd.g_old_rec.cont_information20, hr_api.g_varchar2) <>
1179: nvl(p_rec.cont_information20, hr_api.g_varchar2)))
1180: or
1181: (p_rec.contact_relationship_id is null) then
1182: --
1175: nvl(p_rec.cont_information18, hr_api.g_varchar2) or
1176: nvl(per_ctr_shd.g_old_rec.cont_information19, hr_api.g_varchar2) <>
1177: nvl(p_rec.cont_information19, hr_api.g_varchar2) or
1178: nvl(per_ctr_shd.g_old_rec.cont_information20, hr_api.g_varchar2) <>
1179: nvl(p_rec.cont_information20, hr_api.g_varchar2)))
1180: or
1181: (p_rec.contact_relationship_id is null) then
1182: --
1183: -- Only execute the validation if absolutely necessary:
1249: -- Call all supporting business operations. Mapping to the
1250: -- appropriate Business Rules in perctr.bru is provided (where
1251: -- relevant)
1252: --
1253: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1254: --
1255: -- Bug 3114717 Start
1256: --
1257: -- Validate primary_contact_flag
1417: Begin
1418: hr_utility.set_location('Entering:'||l_proc, 5);
1419: --
1420: --
1421: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1422: --
1423: -- Check the non-updateable arguments have in fact not been modified
1424: --
1425: per_ctr_bus.check_non_updateable_args(p_rec => p_rec);
1428: -- bug fix 3982865
1429: -- Validation added to check the flag value while updating
1430: -- contact relationship.
1431:
1432: if ( p_rec.primary_contact_flag <> hr_api.g_varchar2 OR
1433: p_rec.primary_contact_flag is null ) then
1434: chk_y_or_n
1435: (p_effective_date => p_effective_date
1436: ,p_flag => p_rec.primary_contact_flag
1439: end if;
1440: --
1441: -- Validate third_party_pay_flag
1442: --
1443: if ( p_rec.third_party_pay_flag <> hr_api.g_varchar2 OR
1444: p_rec.third_party_pay_flag is null ) then
1445: chk_y_or_n
1446: (p_effective_date => p_effective_date
1447: ,p_flag => p_rec.third_party_pay_flag
1449: end if;
1450: --
1451: -- Validate rltd_per_rsds_w_dsgntr_flag
1452: --
1453: if ( p_rec.rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2 OR
1454: p_rec.rltd_per_rsds_w_dsgntr_flag is null ) then
1455: chk_y_or_n
1456: (p_effective_date => p_effective_date
1457: ,p_flag => p_rec.rltd_per_rsds_w_dsgntr_flag
1459: end if;
1460: --
1461: -- Validate personal_flag
1462: --
1463: if ( p_rec.personal_flag <> hr_api.g_varchar2 OR
1464: p_rec.personal_flag is null ) then
1465: chk_y_or_n
1466: (p_effective_date => p_effective_date
1467: ,p_flag => p_rec.personal_flag
1469: end if;
1470: --
1471: -- Validate beneficiary_flag
1472: --
1473: if ( p_rec.beneficiary_flag <> hr_api.g_varchar2 OR
1474: p_rec.beneficiary_flag is null ) then
1475: chk_y_or_n
1476: (p_effective_date => p_effective_date
1477: ,p_flag => p_rec.beneficiary_flag
1479: end if;
1480: --
1481: -- Validate dependent_flag
1482: --
1483: if ( p_rec.dependent_flag <> hr_api.g_varchar2 OR
1484: p_rec.dependent_flag is null ) then
1485: chk_y_or_n
1486: (p_effective_date => p_effective_date
1487: ,p_flag => p_rec.dependent_flag
1610: hr_utility.set_location('Entering:'|| l_proc, 10);
1611: --
1612: -- Ensure that all the mandatory parameter are not null
1613: --
1614: hr_api.mandatory_arg_error(p_api_name => l_proc,
1615: p_argument => 'contact_relationship_id',
1616: p_argument_value => p_contact_relationship_id);
1617: --
1618: if nvl(g_contact_relationship_id, hr_api.g_number) = p_contact_relationship_id then
1614: hr_api.mandatory_arg_error(p_api_name => l_proc,
1615: p_argument => 'contact_relationship_id',
1616: p_argument_value => p_contact_relationship_id);
1617: --
1618: if nvl(g_contact_relationship_id, hr_api.g_number) = p_contact_relationship_id then
1619: --
1620: -- The legislation code has already been found with a previous
1621: -- call to this function. Just return the value in the global
1622: -- variable.