eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CTR_BUS dependencies on HR_API

Line 31: IF hr_api.not_exists_in_hrstanlookups

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

Line 95: hr_api.mandatory_arg_error

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: );

Line 178: hr_api.mandatory_arg_error

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: );

Line 260: hr_api.mandatory_arg_error

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: );

Line 286: hr_api.mandatory_arg_error

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: );

Line 292: hr_api.mandatory_arg_error

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: );

Line 303: -- if hr_api.not_exists_in_hr_lookups

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

Line 304: if hr_api.not_exists_in_leg_lookups

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

Line 679: and nvl(per_ctr_shd.g_old_rec.date_start, hr_api.g_date)

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)

Line 680: <> nvl(p_date_start, hr_api.g_date)

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))

Line 681: or nvl(per_ctr_shd.g_old_rec.date_end, hr_api.g_date)

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

Line 682: <> nvl(p_date_end, hr_api.g_date)

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: --

Line 683: or nvl(per_ctr_shd.g_old_rec.contact_type, hr_api.g_varchar2)

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;

Line 684: <> nvl(p_contact_type, hr_api.g_varchar2))

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;

Line 774: nvl(per_ctr_shd.g_old_rec.sequence_number,hr_api.g_number)

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

Line 775: <> nvl(p_sequence_number,hr_api.g_number)) 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

Line 861: hr_api.mandatory_arg_error

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: );

Line 872: hr_api.mandatory_arg_error

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: );

Line 898: ( p_date_start < nvl( l_person_date_of_birth,hr_api.g_sot ) or

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;

Line 899: p_date_start < nvl( l_contact_date_of_birth,hr_api.g_sot ) ) then

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: --

Line 938: if nvl(p_rec.business_group_id, hr_api.g_number) <>

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;

Line 944: if nvl(p_rec.person_id, hr_api.g_number) <>

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;

Line 950: if nvl(p_rec.contact_person_id, hr_api.g_number) <>

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;

Line 958: hr_api.argument_changed_error

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;

Line 1002: nvl(per_ctr_shd.g_old_rec.cont_attribute_category, hr_api.g_varchar2) <>

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) <>

Line 1003: nvl(p_rec.cont_attribute_category, hr_api.g_varchar2) or

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

Line 1004: nvl(per_ctr_shd.g_old_rec.cont_attribute1, hr_api.g_varchar2) <>

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) <>

Line 1005: nvl(p_rec.cont_attribute1, hr_api.g_varchar2) or

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

Line 1006: nvl(per_ctr_shd.g_old_rec.cont_attribute2, hr_api.g_varchar2) <>

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) <>

Line 1007: nvl(p_rec.cont_attribute2, hr_api.g_varchar2) or

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

Line 1008: nvl(per_ctr_shd.g_old_rec.cont_attribute3, hr_api.g_varchar2) <>

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) <>

Line 1009: nvl(p_rec.cont_attribute3, hr_api.g_varchar2) or

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

Line 1010: nvl(per_ctr_shd.g_old_rec.cont_attribute4, hr_api.g_varchar2) <>

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) <>

Line 1011: nvl(p_rec.cont_attribute4, hr_api.g_varchar2) or

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

Line 1012: nvl(per_ctr_shd.g_old_rec.cont_attribute5, hr_api.g_varchar2) <>

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) <>

Line 1013: nvl(p_rec.cont_attribute5, hr_api.g_varchar2) or

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

Line 1014: nvl(per_ctr_shd.g_old_rec.cont_attribute6, hr_api.g_varchar2) <>

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) <>

Line 1015: nvl(p_rec.cont_attribute6, hr_api.g_varchar2) or

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

Line 1016: nvl(per_ctr_shd.g_old_rec.cont_attribute7, hr_api.g_varchar2) <>

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) <>

Line 1017: nvl(p_rec.cont_attribute7, hr_api.g_varchar2) or

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

Line 1018: nvl(per_ctr_shd.g_old_rec.cont_attribute8, hr_api.g_varchar2) <>

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) <>

Line 1019: nvl(p_rec.cont_attribute8, hr_api.g_varchar2) or

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

Line 1020: nvl(per_ctr_shd.g_old_rec.cont_attribute9, hr_api.g_varchar2) <>

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) <>

Line 1021: nvl(p_rec.cont_attribute9, hr_api.g_varchar2) or

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

Line 1022: nvl(per_ctr_shd.g_old_rec.cont_attribute10, hr_api.g_varchar2) <>

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) <>

Line 1023: nvl(p_rec.cont_attribute10, hr_api.g_varchar2) or

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

Line 1024: nvl(per_ctr_shd.g_old_rec.cont_attribute11, hr_api.g_varchar2) <>

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) <>

Line 1025: nvl(p_rec.cont_attribute11, hr_api.g_varchar2) or

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

Line 1026: nvl(per_ctr_shd.g_old_rec.cont_attribute12, hr_api.g_varchar2) <>

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) <>

Line 1027: nvl(p_rec.cont_attribute12, hr_api.g_varchar2) or

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

Line 1028: nvl(per_ctr_shd.g_old_rec.cont_attribute13, hr_api.g_varchar2) <>

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) <>

Line 1029: nvl(p_rec.cont_attribute13, hr_api.g_varchar2) or

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

Line 1030: nvl(per_ctr_shd.g_old_rec.cont_attribute14, hr_api.g_varchar2) <>

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) <>

Line 1031: nvl(p_rec.cont_attribute14, hr_api.g_varchar2) or

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

Line 1032: nvl(per_ctr_shd.g_old_rec.cont_attribute15, hr_api.g_varchar2) <>

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) <>

Line 1033: nvl(p_rec.cont_attribute15, hr_api.g_varchar2) or

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

Line 1034: nvl(per_ctr_shd.g_old_rec.cont_attribute16, hr_api.g_varchar2) <>

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) <>

Line 1035: nvl(p_rec.cont_attribute16, hr_api.g_varchar2) or

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

Line 1036: nvl(per_ctr_shd.g_old_rec.cont_attribute17, hr_api.g_varchar2) <>

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) <>

Line 1037: nvl(p_rec.cont_attribute17, hr_api.g_varchar2) or

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

Line 1038: nvl(per_ctr_shd.g_old_rec.cont_attribute18, hr_api.g_varchar2) <>

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) <>

Line 1039: nvl(p_rec.cont_attribute18, hr_api.g_varchar2) or

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)))

Line 1040: nvl(per_ctr_shd.g_old_rec.cont_attribute19, 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

Line 1041: nvl(p_rec.cont_attribute19, hr_api.g_varchar2) 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

Line 1042: nvl(per_ctr_shd.g_old_rec.cont_attribute20, hr_api.g_varchar2) <>

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: --

Line 1043: nvl(p_rec.cont_attribute20, 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: --
1047: -- Only execute the validation if absolutely necessary:

Line 1138: nvl(per_ctr_shd.g_old_rec.cont_information_category, hr_api.g_varchar2) <>

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) <>

Line 1139: nvl(p_rec.cont_information_category, hr_api.g_varchar2) or

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

Line 1140: nvl(per_ctr_shd.g_old_rec.cont_information1, hr_api.g_varchar2) <>

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) <>

Line 1141: nvl(p_rec.cont_information1, hr_api.g_varchar2) or

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

Line 1142: nvl(per_ctr_shd.g_old_rec.cont_information2, hr_api.g_varchar2) <>

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) <>

Line 1143: nvl(p_rec.cont_information2, hr_api.g_varchar2) or

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

Line 1144: nvl(per_ctr_shd.g_old_rec.cont_information3, hr_api.g_varchar2) <>

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) <>

Line 1145: nvl(p_rec.cont_information3, hr_api.g_varchar2) or

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

Line 1146: nvl(per_ctr_shd.g_old_rec.cont_information4, hr_api.g_varchar2) <>

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) <>

Line 1147: nvl(p_rec.cont_information4, hr_api.g_varchar2) or

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

Line 1148: nvl(per_ctr_shd.g_old_rec.cont_information5, hr_api.g_varchar2) <>

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) <>

Line 1149: nvl(p_rec.cont_information5, hr_api.g_varchar2) or

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

Line 1150: nvl(per_ctr_shd.g_old_rec.cont_information6, hr_api.g_varchar2) <>

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) <>

Line 1151: nvl(p_rec.cont_information6, hr_api.g_varchar2) or

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

Line 1152: nvl(per_ctr_shd.g_old_rec.cont_information7, hr_api.g_varchar2) <>

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) <>

Line 1153: nvl(p_rec.cont_information7, hr_api.g_varchar2) or

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

Line 1154: nvl(per_ctr_shd.g_old_rec.cont_information8, hr_api.g_varchar2) <>

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) <>

Line 1155: nvl(p_rec.cont_information8, hr_api.g_varchar2) or

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

Line 1156: nvl(per_ctr_shd.g_old_rec.cont_information9, hr_api.g_varchar2) <>

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) <>

Line 1157: nvl(p_rec.cont_information9, hr_api.g_varchar2) or

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

Line 1158: nvl(per_ctr_shd.g_old_rec.cont_information10, hr_api.g_varchar2) <>

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) <>

Line 1159: nvl(p_rec.cont_information10, hr_api.g_varchar2) or

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

Line 1160: nvl(per_ctr_shd.g_old_rec.cont_information11, hr_api.g_varchar2) <>

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) <>

Line 1161: nvl(p_rec.cont_information11, hr_api.g_varchar2) or

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

Line 1162: nvl(per_ctr_shd.g_old_rec.cont_information12, hr_api.g_varchar2) <>

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) <>

Line 1163: nvl(p_rec.cont_information12, hr_api.g_varchar2) or

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

Line 1164: nvl(per_ctr_shd.g_old_rec.cont_information13, hr_api.g_varchar2) <>

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) <>

Line 1165: nvl(p_rec.cont_information13, hr_api.g_varchar2) or

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

Line 1166: nvl(per_ctr_shd.g_old_rec.cont_information14, hr_api.g_varchar2) <>

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) <>

Line 1167: nvl(p_rec.cont_information14, hr_api.g_varchar2) or

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

Line 1168: nvl(per_ctr_shd.g_old_rec.cont_information15, hr_api.g_varchar2) <>

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) <>

Line 1169: nvl(p_rec.cont_information15, hr_api.g_varchar2) or

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

Line 1170: nvl(per_ctr_shd.g_old_rec.cont_information16, hr_api.g_varchar2) <>

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) <>

Line 1171: nvl(p_rec.cont_information16, hr_api.g_varchar2) or

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

Line 1172: nvl(per_ctr_shd.g_old_rec.cont_information17, hr_api.g_varchar2) <>

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) <>

Line 1173: nvl(p_rec.cont_information17, hr_api.g_varchar2) or

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

Line 1174: nvl(per_ctr_shd.g_old_rec.cont_information18, hr_api.g_varchar2) <>

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) <>

Line 1175: nvl(p_rec.cont_information18, hr_api.g_varchar2) or

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)))

Line 1176: nvl(per_ctr_shd.g_old_rec.cont_information19, 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

Line 1177: nvl(p_rec.cont_information19, hr_api.g_varchar2) 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

Line 1178: nvl(per_ctr_shd.g_old_rec.cont_information20, hr_api.g_varchar2) <>

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: --

Line 1179: nvl(p_rec.cont_information20, 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: --
1183: -- Only execute the validation if absolutely necessary:

Line 1253: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

Line 1421: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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);

Line 1432: if ( p_rec.primary_contact_flag <> hr_api.g_varchar2 OR

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

Line 1443: if ( p_rec.third_party_pay_flag <> hr_api.g_varchar2 OR

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

Line 1453: if ( p_rec.rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2 OR

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

Line 1463: if ( p_rec.personal_flag <> hr_api.g_varchar2 OR

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

Line 1473: if ( p_rec.beneficiary_flag <> hr_api.g_varchar2 OR

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

Line 1483: if ( p_rec.dependent_flag <> hr_api.g_varchar2 OR

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

Line 1623: hr_api.mandatory_arg_error(p_api_name => l_proc,

1619: hr_utility.set_location('Entering:'|| l_proc, 10);
1620: --
1621: -- Ensure that all the mandatory parameter are not null
1622: --
1623: hr_api.mandatory_arg_error(p_api_name => l_proc,
1624: p_argument => 'contact_relationship_id',
1625: p_argument_value => p_contact_relationship_id);
1626: --
1627: if nvl(g_contact_relationship_id, hr_api.g_number) = p_contact_relationship_id then

Line 1627: if nvl(g_contact_relationship_id, hr_api.g_number) = p_contact_relationship_id then

1623: hr_api.mandatory_arg_error(p_api_name => l_proc,
1624: p_argument => 'contact_relationship_id',
1625: p_argument_value => p_contact_relationship_id);
1626: --
1627: if nvl(g_contact_relationship_id, hr_api.g_number) = p_contact_relationship_id then
1628: --
1629: -- The legislation code has already been found with a previous
1630: -- call to this function. Just return the value in the global
1631: -- variable.