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_ADD_BUS dependencies on HR_API

Line 79: hr_api.validate_bus_grp_id(p_business_group_id);

75: hr_utility.set_location('Entering:'||l_proc, 5);
76: if p_business_group_id is not null then
77: hr_utility.set_location(l_proc, 10);
78: --
79: hr_api.validate_bus_grp_id(p_business_group_id);
80: --
81: --
82: --If BUSINESS_GROUP_ID is specified, PERSON_ID must be specified
83: --

Line 100: and nvl(per_add_shd.g_old_rec.business_group_id,hr_api.g_number) <> hr_api.g_number

96: --
97: --UPDATE not allowed unless currently null(U)
98: --
99: if (l_api_updating
100: and nvl(per_add_shd.g_old_rec.business_group_id,hr_api.g_number) <> hr_api.g_number
101: and per_add_shd.g_old_rec.business_group_id <> p_business_group_id ) then
102: --
103: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
104: hr_utility.raise_error;

Line 173: hr_api.mandatory_arg_error

169: hr_utility.set_location('Entering:'|| l_proc, 10);
170: --
171: -- Check mandatory parameters have been set
172: --
173: hr_api.mandatory_arg_error
174: (p_api_name => l_proc
175: ,p_argument => 'person_id'
176: ,p_argument_value => p_person_id
177: );

Line 179: hr_api.mandatory_arg_error

175: ,p_argument => 'person_id'
176: ,p_argument_value => p_person_id
177: );
178: --
179: hr_api.mandatory_arg_error
180: (p_api_name => l_proc
181: ,p_argument => 'business_group_id'
182: ,p_argument_value => p_business_group_id
183: );

Line 232: and nvl(per_add_shd.g_old_rec.person_id,hr_api.g_number) <> hr_api.g_number

228: --
229: --UPDATE not allowed unless currently null(U)
230: --
231: if (l_api_updating
232: and nvl(per_add_shd.g_old_rec.person_id,hr_api.g_number) <> hr_api.g_number
233: and per_add_shd.g_old_rec.person_id <> p_person_id
234: ) then
235: --
236: hr_utility.set_message(800, 'HR_289948_INV_UPD_PERSON_ID');

Line 309: and nvl(per.effective_end_date,hr_api.g_eot);

305: from per_all_people_f per
306: where per.person_id = p_rec.person_id
307: and p_rec.date_from
308: between per.effective_start_date
309: and nvl(per.effective_end_date,hr_api.g_eot);
310: --
311: cursor csr_valid_party_id is
312: select party_id
313: from hz_parties hzp

Line 416: hr_api.mandatory_arg_error

412: hr_utility.set_location('Entering:'|| l_proc, 10);
413: --
414: -- Check mandatory parameters have been set
415: --
416: hr_api.mandatory_arg_error
417: (p_api_name => l_proc
418: ,p_argument => 'p_primary_flag'
419: ,p_argument_value => p_primary_flag
420: );

Line 500: hr_api.mandatory_arg_error

496: hr_utility.set_location('Entering:'|| l_proc, 1);
497: --
498: -- Check mandatory parameters have been set
499: --
500: hr_api.mandatory_arg_error
501: (p_api_name => l_proc
502: ,p_argument => 'date_from'
503: ,p_argument_value => p_date_from
504: );

Line 505: hr_api.mandatory_arg_error

501: (p_api_name => l_proc
502: ,p_argument => 'date_from'
503: ,p_argument_value => p_date_from
504: );
505: hr_api.mandatory_arg_error
506: (p_api_name => l_proc
507: ,p_argument => 'effective_date'
508: ,p_argument_value => p_effective_date
509: );

Line 520: nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>

516: (p_address_id => p_address_id
517: ,p_object_version_number => p_object_version_number);
518: --
519: if ((l_api_updating and
520: nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
521: nvl(p_address_type, hr_api.g_varchar2)) or
522: (NOT l_api_updating)) then
523: hr_utility.set_location(l_proc, 2);
524: --

Line 521: nvl(p_address_type, hr_api.g_varchar2)) or

517: ,p_object_version_number => p_object_version_number);
518: --
519: if ((l_api_updating and
520: nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
521: nvl(p_address_type, hr_api.g_varchar2)) or
522: (NOT l_api_updating)) then
523: hr_utility.set_location(l_proc, 2);
524: --
525: -- Checks that the value for address_type is

Line 533: -- if hr_api.not_exists_in_hr_lookups

529: if p_address_type is not null then
530: --
531: -- Bug 1472162.
532: --
533: -- if hr_api.not_exists_in_hr_lookups
534: if hr_api.not_exists_in_leg_lookups
535: (p_effective_date => p_effective_date
536: ,p_lookup_type => 'ADDRESS_TYPE'
537: ,p_lookup_code => p_address_type

Line 534: if hr_api.not_exists_in_leg_lookups

530: --
531: -- Bug 1472162.
532: --
533: -- if hr_api.not_exists_in_hr_lookups
534: if hr_api.not_exists_in_leg_lookups
535: (p_effective_date => p_effective_date
536: ,p_lookup_type => 'ADDRESS_TYPE'
537: ,p_lookup_code => p_address_type
538: ) then

Line 617: nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2) <>

613: (p_address_id => p_address_id
614: ,p_object_version_number => p_object_version_number);
615: --
616: if ((l_api_updating and
617: nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2) <>
618: nvl(p_country, hr_api.g_varchar2)) or
619: (NOT l_api_updating)) then
620: hr_utility.set_location(l_proc, 2);
621: --

Line 618: nvl(p_country, hr_api.g_varchar2)) or

614: ,p_object_version_number => p_object_version_number);
615: --
616: if ((l_api_updating and
617: nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2) <>
618: nvl(p_country, hr_api.g_varchar2)) or
619: (NOT l_api_updating)) then
620: hr_utility.set_location(l_proc, 2);
621: --
622: -- Checks that value for country is a valid

Line 700: hr_api.mandatory_arg_error

696: hr_utility.set_location('Entering:'|| l_proc, 1);
697: --
698: -- Check mandatory parameters have been set
699: --
700: hr_api.mandatory_arg_error
701: (p_api_name => l_proc
702: ,p_argument => 'date_from'
703: ,p_argument_value => p_date_from
704: );

Line 721: nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>

717: (p_address_id => p_address_id
718: ,p_object_version_number => p_object_version_number);
719: --
720: if ((l_api_updating and
721: nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
722: nvl(p_date_to, hr_api.g_eot)) or
723: (NOT l_api_updating)) then
724: --
725: hr_utility.set_location(l_proc, 2);

Line 722: nvl(p_date_to, hr_api.g_eot)) or

718: ,p_object_version_number => p_object_version_number);
719: --
720: if ((l_api_updating and
721: nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
722: nvl(p_date_to, hr_api.g_eot)) or
723: (NOT l_api_updating)) then
724: --
725: hr_utility.set_location(l_proc, 2);
726: --

Line 731: if nvl(p_date_to, hr_api.g_eot) < p_date_from then

727: -- Checks that the value for date_to is greater than or
728: -- equal to the corresponding value for date_from for the
729: -- same record
730: --
731: if nvl(p_date_to, hr_api.g_eot) < p_date_from then
732: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');
733: hr_utility.raise_error;
734: end if;
735: --

Line 797: hr_api.mandatory_arg_error

793: hr_utility.set_location('Entering:'|| l_proc, 1);
794: --
795: -- Check mandatory parameters have been set
796: --
797: hr_api.mandatory_arg_error
798: (p_api_name => l_proc
799: ,p_argument => 'date_from'
800: ,p_argument_value => p_date_from
801: );

Line 819: if p_date_from > nvl(p_date_to, hr_api.g_eot) then

815: -- Check that the date_from values is less than
816: -- or equal to the date_to value for the current
817: -- record
818: --
819: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
820: hr_utility.set_message(801, 'HR_7303_ADD_DATE_FROM_EARLIER');
821: hr_utility.raise_error;
822: end if;
823: --

Line 947: where p_date_from <= nvl(pa.date_to, hr_api.g_eot)

943: --
944: cursor csr_dup_add_type_exists is
945: select null
946: from per_addresses pa
947: where p_date_from <= nvl(pa.date_to, hr_api.g_eot)
948: and l_date_to >= pa.date_from
949: and pa.address_type = p_address_type
950: and (pa.person_id = p_person_id OR -- HR/TCA merge
951: (pa.party_id = p_party_id and p_person_id is null)) -- #3406505

Line 959: where p_date_from <= nvl(pa.date_to, hr_api.g_eot)

955: --
956: cursor csr_dup_prim_flag is
957: select null
958: from per_addresses pa
959: where p_date_from <= nvl(pa.date_to, hr_api.g_eot)
960: and l_date_to >= pa.date_from
961: and pa.primary_flag = 'Y'
962: and (pa.person_id = p_person_id OR --
963: (pa.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge -- #3406505

Line 974: where nvl(pa2.date_to, hr_api.g_eot) >= l_date_to

970: from per_addresses pa
971: where p_date_from >= pa.date_from
972: and exists (select null
973: from per_addresses pa2
974: where nvl(pa2.date_to, hr_api.g_eot) >= l_date_to
975: and (pa2.person_id = p_person_id OR --
976: (pa2.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge -- #3406505
977: and pa2.primary_flag = 'Y')
978: and pa.primary_flag = 'Y'

Line 990: and nvl(pa.date_to, hr_api.g_eot) >=

986: from sys.dual
987: where exists(select null
988: from per_addresses pa
989: where ((pa.date_from < p_date_from
990: and nvl(pa.date_to, hr_api.g_eot) >=
991: (select date_from
992: from per_addresses
993: where address_id = p_address_id)
994: and p_date_from <> (select date_from

Line 997: or (nvl(pa.date_to, hr_api.g_eot) >

993: where address_id = p_address_id)
994: and p_date_from <> (select date_from
995: from per_addresses
996: where address_id = p_address_id) )
997: or (nvl(pa.date_to, hr_api.g_eot) >
998: nvl(p_date_to, hr_api.g_eot)
999: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)
1000: from per_addresses
1001: where address_id = p_address_id)

Line 998: nvl(p_date_to, hr_api.g_eot)

994: and p_date_from <> (select date_from
995: from per_addresses
996: where address_id = p_address_id) )
997: or (nvl(pa.date_to, hr_api.g_eot) >
998: nvl(p_date_to, hr_api.g_eot)
999: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)
1000: from per_addresses
1001: where address_id = p_address_id)
1002: and nvl(p_date_to, hr_api.g_eot) <>

Line 999: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)

995: from per_addresses
996: where address_id = p_address_id) )
997: or (nvl(pa.date_to, hr_api.g_eot) >
998: nvl(p_date_to, hr_api.g_eot)
999: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)
1000: from per_addresses
1001: where address_id = p_address_id)
1002: and nvl(p_date_to, hr_api.g_eot) <>
1003: (select nvl(date_to, hr_api.g_eot)

Line 1002: and nvl(p_date_to, hr_api.g_eot) <>

998: nvl(p_date_to, hr_api.g_eot)
999: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)
1000: from per_addresses
1001: where address_id = p_address_id)
1002: and nvl(p_date_to, hr_api.g_eot) <>
1003: (select nvl(date_to, hr_api.g_eot)
1004: from per_addresses
1005: where address_id = p_address_id) ))
1006: and pa.primary_flag = 'N'

Line 1003: (select nvl(date_to, hr_api.g_eot)

999: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)
1000: from per_addresses
1001: where address_id = p_address_id)
1002: and nvl(p_date_to, hr_api.g_eot) <>
1003: (select nvl(date_to, hr_api.g_eot)
1004: from per_addresses
1005: where address_id = p_address_id) ))
1006: and pa.primary_flag = 'N'
1007: and (pa.person_id = p_person_id OR

Line 1051: hr_api.mandatory_arg_error

1047: hr_utility.set_location('Entering:'|| l_proc, 10);
1048: --
1049: -- Check mandatory parameters have been set
1050: --
1051: hr_api.mandatory_arg_error
1052: (p_api_name => l_proc
1053: ,p_argument => 'date_from'
1054: ,p_argument_value => p_date_from
1055: );

Line 1058: hr_api.mandatory_arg_error

1054: ,p_argument_value => p_date_from
1055: );
1056: --
1057: if p_party_id is null then -- HR/TCA merge
1058: hr_api.mandatory_arg_error
1059: (p_api_name => l_proc
1060: ,p_argument => 'person_id'
1061: ,p_argument_value => p_person_id
1062: );

Line 1065: hr_api.mandatory_arg_error

1061: ,p_argument_value => p_person_id
1062: );
1063: end if;
1064: --
1065: hr_api.mandatory_arg_error
1066: (p_api_name => l_proc
1067: ,p_argument => 'primary_flag'
1068: ,p_argument_value => p_primary_flag
1069: );

Line 1080: l_date_to := nvl(p_date_to, hr_api.g_eot);

1076: ) then
1077: --
1078: -- Set the DATE_TO to entered value or the end of time
1079: --
1080: l_date_to := nvl(p_date_to, hr_api.g_eot);
1081: --
1082: -- Only proceed with validation if :
1083: -- a) The current g_old_rec is current and
1084: -- b) The value for date_to/date_from has changed

Line 1093: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>

1089: );
1090: --
1091: if ((l_api_updating and
1092: per_add_shd.g_old_rec.date_from <> p_date_from) or
1093: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1094: nvl(p_date_to, hr_api.g_eot)) or
1095: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1096: nvl(p_address_type, hr_api.g_varchar2))
1097: or

Line 1094: nvl(p_date_to, hr_api.g_eot)) or

1090: --
1091: if ((l_api_updating and
1092: per_add_shd.g_old_rec.date_from <> p_date_from) or
1093: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1094: nvl(p_date_to, hr_api.g_eot)) or
1095: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1096: nvl(p_address_type, hr_api.g_varchar2))
1097: or
1098: (NOT l_api_updating))

Line 1095: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>

1091: if ((l_api_updating and
1092: per_add_shd.g_old_rec.date_from <> p_date_from) or
1093: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1094: nvl(p_date_to, hr_api.g_eot)) or
1095: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1096: nvl(p_address_type, hr_api.g_varchar2))
1097: or
1098: (NOT l_api_updating))
1099: then

Line 1096: nvl(p_address_type, hr_api.g_varchar2))

1092: per_add_shd.g_old_rec.date_from <> p_date_from) or
1093: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1094: nvl(p_date_to, hr_api.g_eot)) or
1095: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1096: nvl(p_address_type, hr_api.g_varchar2))
1097: or
1098: (NOT l_api_updating))
1099: then
1100: hr_utility.set_location(l_proc, 30);

Line 1108: if (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>

1104: -- Checks that the date_from, date_to values for a given address
1105: -- do not cause an overlap of address_type value between two
1106: -- addresses for the same person within a given date range.
1107: --
1108: if (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1109: nvl(p_address_type, hr_api.g_varchar2)) or
1110: (NOT l_api_updating) then
1111: --
1112: if p_address_type is not null then

Line 1109: nvl(p_address_type, hr_api.g_varchar2)) or

1105: -- do not cause an overlap of address_type value between two
1106: -- addresses for the same person within a given date range.
1107: --
1108: if (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1109: nvl(p_address_type, hr_api.g_varchar2)) or
1110: (NOT l_api_updating) then
1111: --
1112: if p_address_type is not null then
1113: open csr_dup_add_type_exists;

Line 1239: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>

1235: -- address is left without a corresponding
1236: -- primary
1237: --
1238: if ((per_add_shd.g_old_rec.date_from <> p_date_from) or
1239: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1240: (nvl(p_date_to, hr_api.g_eot)))) and
1241: p_address_id is not null then
1242: open csr_invalid_non_prim;
1243: fetch csr_invalid_non_prim into l_exists;

Line 1240: (nvl(p_date_to, hr_api.g_eot)))) and

1236: -- primary
1237: --
1238: if ((per_add_shd.g_old_rec.date_from <> p_date_from) or
1239: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1240: (nvl(p_date_to, hr_api.g_eot)))) and
1241: p_address_id is not null then
1242: open csr_invalid_non_prim;
1243: fetch csr_invalid_non_prim into l_exists;
1244: if csr_invalid_non_prim%found then

Line 1391: hr_api.mandatory_arg_error

1387: hr_utility.set_location('Entering:'|| l_proc, 1);
1388: --
1389: -- Check mandatory parameters have been set
1390: --
1391: hr_api.mandatory_arg_error
1392: (p_api_name => l_proc
1393: ,p_argument => 'style'
1394: ,p_argument_value => p_style
1395: );

Line 1510: and nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)

1506: ,p_object_version_number => p_object_version_number
1507: );
1508: --
1509: if p_region_3 is not null
1510: and nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
1511: = nvl(p_region_3, hr_api.g_varchar2)
1512: then
1513: --
1514: null;

Line 1511: = nvl(p_region_3, hr_api.g_varchar2)

1507: );
1508: --
1509: if p_region_3 is not null
1510: and nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
1511: = nvl(p_region_3, hr_api.g_varchar2)
1512: then
1513: --
1514: null;
1515: --

Line 1526: and nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)

1522: --
1523: -- Check if telephone number 3 is set but is unchanged on update
1524: --
1525: if p_telephone_number_3 is not null
1526: and nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
1527: = nvl(p_telephone_number_3, hr_api.g_varchar2)
1528: then
1529: --
1530: null;

Line 1527: = nvl(p_telephone_number_3, hr_api.g_varchar2)

1523: -- Check if telephone number 3 is set but is unchanged on update
1524: --
1525: if p_telephone_number_3 is not null
1526: and nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
1527: = nvl(p_telephone_number_3, hr_api.g_varchar2)
1528: then
1529: --
1530: null;
1531: --

Line 1609: hr_api.mandatory_arg_error

1605: hr_utility.set_location('Entering:'|| l_proc, 1);
1606: --
1607: -- Check mandatory parameters have been set
1608: --
1609: hr_api.mandatory_arg_error
1610: (p_api_name => l_proc
1611: ,p_argument => 'style'
1612: ,p_argument_value => p_style
1613: );

Line 1624: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2) <>

1620: (p_address_id => p_address_id
1621: ,p_object_version_number => p_object_version_number);
1622: --
1623: if ((l_api_updating and
1624: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2) <>
1625: nvl(p_address_line1, hr_api.g_varchar2)) or
1626: (NOT l_api_updating)) then
1627: hr_utility.set_location(l_proc, 2);
1628: --

Line 1625: nvl(p_address_line1, hr_api.g_varchar2)) or

1621: ,p_object_version_number => p_object_version_number);
1622: --
1623: if ((l_api_updating and
1624: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2) <>
1625: nvl(p_address_line1, hr_api.g_varchar2)) or
1626: (NOT l_api_updating)) then
1627: hr_utility.set_location(l_proc, 2);
1628: --
1629: -- Check that value for address_line1 is not null for 'US' and 'GB'

Line 1711: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>

1707:
1708: if ( (l_legislation_code = 'JP')
1709: and
1710: ( (l_api_updating and
1711: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1712: nvl(p_town_or_city, hr_api.g_varchar2) or
1713: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1714: nvl(p_address_line1, hr_api.g_varchar2) or
1715: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>

Line 1712: nvl(p_town_or_city, hr_api.g_varchar2) or

1708: if ( (l_legislation_code = 'JP')
1709: and
1710: ( (l_api_updating and
1711: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1712: nvl(p_town_or_city, hr_api.g_varchar2) or
1713: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1714: nvl(p_address_line1, hr_api.g_varchar2) or
1715: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1716: nvl(p_region_1, hr_api.g_varchar2)))

Line 1713: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>

1709: and
1710: ( (l_api_updating and
1711: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1712: nvl(p_town_or_city, hr_api.g_varchar2) or
1713: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1714: nvl(p_address_line1, hr_api.g_varchar2) or
1715: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1716: nvl(p_region_1, hr_api.g_varchar2)))
1717: or

Line 1714: nvl(p_address_line1, hr_api.g_varchar2) or

1710: ( (l_api_updating and
1711: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1712: nvl(p_town_or_city, hr_api.g_varchar2) or
1713: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1714: nvl(p_address_line1, hr_api.g_varchar2) or
1715: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1716: nvl(p_region_1, hr_api.g_varchar2)))
1717: or
1718: (NOT l_api_updating))

Line 1715: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>

1711: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1712: nvl(p_town_or_city, hr_api.g_varchar2) or
1713: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1714: nvl(p_address_line1, hr_api.g_varchar2) or
1715: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1716: nvl(p_region_1, hr_api.g_varchar2)))
1717: or
1718: (NOT l_api_updating))
1719: ) then

Line 1716: nvl(p_region_1, hr_api.g_varchar2)))

1712: nvl(p_town_or_city, hr_api.g_varchar2) or
1713: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1714: nvl(p_address_line1, hr_api.g_varchar2) or
1715: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1716: nvl(p_region_1, hr_api.g_varchar2)))
1717: or
1718: (NOT l_api_updating))
1719: ) then
1720:

Line 1894: (nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2) <>

1890: (p_address_id => p_address_id
1891: ,p_object_version_number => p_object_version_number);
1892:
1893: if ((l_api_updating and
1894: (nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2) <>
1895: nvl(p_address_line2, hr_api.g_varchar2) or
1896: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1897: nvl(p_region_2, hr_api.g_varchar2)
1898: )) or (NOT l_api_updating)) then

Line 1895: nvl(p_address_line2, hr_api.g_varchar2) or

1891: ,p_object_version_number => p_object_version_number);
1892:
1893: if ((l_api_updating and
1894: (nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2) <>
1895: nvl(p_address_line2, hr_api.g_varchar2) or
1896: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1897: nvl(p_region_2, hr_api.g_varchar2)
1898: )) or (NOT l_api_updating)) then
1899:

Line 1896: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>

1892:
1893: if ((l_api_updating and
1894: (nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2) <>
1895: nvl(p_address_line2, hr_api.g_varchar2) or
1896: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1897: nvl(p_region_2, hr_api.g_varchar2)
1898: )) or (NOT l_api_updating)) then
1899:
1900: hr_utility.set_location(l_proc, 2);

Line 1897: nvl(p_region_2, hr_api.g_varchar2)

1893: if ((l_api_updating and
1894: (nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2) <>
1895: nvl(p_address_line2, hr_api.g_varchar2) or
1896: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1897: nvl(p_region_2, hr_api.g_varchar2)
1898: )) or (NOT l_api_updating)) then
1899:
1900: hr_utility.set_location(l_proc, 2);
1901:

Line 1955: (nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2) <>

1951: (p_address_id => p_address_id
1952: ,p_object_version_number => p_object_version_number);
1953:
1954: if ((l_api_updating and
1955: (nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2) <>
1956: nvl(p_address_line3, hr_api.g_varchar2) or
1957: nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1958: nvl(p_region_3, hr_api.g_varchar2)
1959: )) or (NOT l_api_updating)) then

Line 1956: nvl(p_address_line3, hr_api.g_varchar2) or

1952: ,p_object_version_number => p_object_version_number);
1953:
1954: if ((l_api_updating and
1955: (nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2) <>
1956: nvl(p_address_line3, hr_api.g_varchar2) or
1957: nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1958: nvl(p_region_3, hr_api.g_varchar2)
1959: )) or (NOT l_api_updating)) then
1960:

Line 1957: nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2) <>

1953:
1954: if ((l_api_updating and
1955: (nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2) <>
1956: nvl(p_address_line3, hr_api.g_varchar2) or
1957: nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1958: nvl(p_region_3, hr_api.g_varchar2)
1959: )) or (NOT l_api_updating)) then
1960:
1961: hr_utility.set_location(l_proc, 2);

Line 1958: nvl(p_region_3, hr_api.g_varchar2)

1954: if ((l_api_updating and
1955: (nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2) <>
1956: nvl(p_address_line3, hr_api.g_varchar2) or
1957: nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1958: nvl(p_region_3, hr_api.g_varchar2)
1959: )) or (NOT l_api_updating)) then
1960:
1961: hr_utility.set_location(l_proc, 2);
1962:

Line 2126: hr_api.mandatory_arg_error

2122: hr_utility.set_location('Entering:'|| l_proc, 1);
2123: --
2124: -- Check mandatory parameters have been set
2125: --
2126: hr_api.mandatory_arg_error
2127: (p_api_name => l_proc
2128: ,p_argument => 'style'
2129: ,p_argument_value => p_style
2130: );

Line 2141: and nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>

2137: (p_address_id => p_address_id
2138: ,p_object_version_number => p_object_version_number);
2139: --
2140: if ((l_api_updating
2141: and nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
2142: nvl(p_postal_code, hr_api.g_varchar2)) or
2143: (NOT l_api_updating))
2144: then
2145: hr_utility.set_location(l_proc, 2);

Line 2142: nvl(p_postal_code, hr_api.g_varchar2)) or

2138: ,p_object_version_number => p_object_version_number);
2139: --
2140: if ((l_api_updating
2141: and nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
2142: nvl(p_postal_code, hr_api.g_varchar2)) or
2143: (NOT l_api_updating))
2144: then
2145: hr_utility.set_location(l_proc, 2);
2146: --

Line 2431: hr_api.mandatory_arg_error

2427: hr_utility.set_location('Entering:'|| l_proc, 1);
2428: --
2429: -- Check mandatory parameters have been set
2430: --
2431: hr_api.mandatory_arg_error
2432: (p_api_name => l_proc
2433: ,p_argument => 'style'
2434: ,p_argument_value => p_style
2435: );

Line 2446: and nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>

2442: (p_address_id => p_address_id
2443: ,p_object_version_number => p_object_version_number);
2444: --
2445: if ((l_api_updating
2446: and nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
2447: nvl(p_tax_address_zip, hr_api.g_varchar2)) or
2448: (NOT l_api_updating))
2449: then
2450: hr_utility.set_location(l_proc, 2);

Line 2447: nvl(p_tax_address_zip, hr_api.g_varchar2)) or

2443: ,p_object_version_number => p_object_version_number);
2444: --
2445: if ((l_api_updating
2446: and nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
2447: nvl(p_tax_address_zip, hr_api.g_varchar2)) or
2448: (NOT l_api_updating))
2449: then
2450: hr_utility.set_location(l_proc, 2);
2451: --

Line 2609: hr_api.mandatory_arg_error

2605: hr_utility.set_location('Entering:'|| l_proc, 1);
2606: --
2607: -- Check mandatory parameters have been set
2608: --
2609: hr_api.mandatory_arg_error
2610: (p_api_name => l_proc
2611: ,p_argument => 'style'
2612: ,p_argument_value => p_style
2613: );

Line 2615: hr_api.mandatory_arg_error

2611: ,p_argument => 'style'
2612: ,p_argument_value => p_style
2613: );
2614: --
2615: hr_api.mandatory_arg_error
2616: (p_api_name => l_proc
2617: ,p_argument => 'effective_date'
2618: ,p_argument_value => p_effective_date
2619: );

Line 2630: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>

2626: (p_address_id => p_address_id
2627: ,p_object_version_number => p_object_version_number);
2628: --
2629: if ((l_api_updating and
2630: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
2631: nvl(p_region_1, hr_api.g_varchar2)) or
2632: (NOT l_api_updating))
2633: then
2634: hr_utility.set_location(l_proc, 2);

Line 2631: nvl(p_region_1, hr_api.g_varchar2)) or

2627: ,p_object_version_number => p_object_version_number);
2628: --
2629: if ((l_api_updating and
2630: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
2631: nvl(p_region_1, hr_api.g_varchar2)) or
2632: (NOT l_api_updating))
2633: then
2634: hr_utility.set_location(l_proc, 2);
2635: --

Line 2672: if hr_api.not_exists_in_hr_lookups

2668: --
2669: if p_style = 'GB' then
2670: hr_utility.set_location(l_proc, 4);
2671: --
2672: if hr_api.not_exists_in_hr_lookups
2673: (p_effective_date => p_effective_date
2674: ,p_lookup_type => 'GB_COUNTY'
2675: ,p_lookup_code => p_region_1
2676: ) then

Line 2763: hr_api.mandatory_arg_error

2759: -- Check mandatory parameters have been set
2760: --
2761: if p_tax_county is not null
2762: then
2763: hr_api.mandatory_arg_error
2764: (p_api_name => l_proc
2765: ,p_argument => 'style'
2766: ,p_argument_value => p_style
2767: );

Line 2769: hr_api.mandatory_arg_error

2765: ,p_argument => 'style'
2766: ,p_argument_value => p_style
2767: );
2768: --
2769: hr_api.mandatory_arg_error
2770: (p_api_name => l_proc
2771: ,p_argument => 'effective_date'
2772: ,p_argument_value => p_effective_date
2773: );

Line 2784: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>

2780: (p_address_id => p_address_id
2781: ,p_object_version_number => p_object_version_number);
2782: --
2783: if ((l_api_updating and
2784: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
2785: nvl(p_tax_county, hr_api.g_varchar2)) or
2786: (NOT l_api_updating))
2787: then
2788: hr_utility.set_location(l_proc, 2);

Line 2785: nvl(p_tax_county, hr_api.g_varchar2)) or

2781: ,p_object_version_number => p_object_version_number);
2782: --
2783: if ((l_api_updating and
2784: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
2785: nvl(p_tax_county, hr_api.g_varchar2)) or
2786: (NOT l_api_updating))
2787: then
2788: hr_utility.set_location(l_proc, 2);
2789: --

Line 2888: hr_api.mandatory_arg_error

2884: hr_utility.set_location('Entering:'|| l_proc, 1);
2885: --
2886: -- Check mandatory parameters have been set.
2887: --
2888: hr_api.mandatory_arg_error
2889: (p_api_name => l_proc
2890: ,p_argument => 'style'
2891: ,p_argument_value => p_style
2892: );

Line 2894: hr_api.mandatory_arg_error

2890: ,p_argument => 'style'
2891: ,p_argument_value => p_style
2892: );
2893: --
2894: hr_api.mandatory_arg_error
2895: (p_api_name => l_proc
2896: ,p_argument => 'effective_date'
2897: ,p_argument_value => p_effective_date
2898: );

Line 2910: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>

2906: ,p_object_version_number => p_object_version_number
2907: );
2908: --
2909: if ((l_api_updating and
2910: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
2911: nvl(p_region_2, hr_api.g_varchar2)) or
2912: (NOT l_api_updating))
2913: then
2914: hr_utility.set_location(l_proc, 2);

Line 2911: nvl(p_region_2, hr_api.g_varchar2)) or

2907: );
2908: --
2909: if ((l_api_updating and
2910: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
2911: nvl(p_region_2, hr_api.g_varchar2)) or
2912: (NOT l_api_updating))
2913: then
2914: hr_utility.set_location(l_proc, 2);
2915: --

Line 2951: if hr_api.not_exists_in_hr_lookups

2947: if p_style = 'US'
2948: then
2949: hr_utility.set_location(l_proc, 4);
2950: --
2951: if hr_api.not_exists_in_hr_lookups
2952: (p_effective_date => p_effective_date
2953: ,p_lookup_type => 'US_STATE'
2954: ,p_lookup_code => p_region_2
2955: )

Line 3050: hr_api.mandatory_arg_error

3046: hr_utility.set_location('Entering:'|| l_proc, 1);
3047: --
3048: -- Check mandatory parameters have been set.
3049: --
3050: hr_api.mandatory_arg_error
3051: (p_api_name => l_proc
3052: ,p_argument => 'style'
3053: ,p_argument_value => p_style
3054: );

Line 3056: hr_api.mandatory_arg_error

3052: ,p_argument => 'style'
3053: ,p_argument_value => p_style
3054: );
3055: --
3056: hr_api.mandatory_arg_error
3057: (p_api_name => l_proc
3058: ,p_argument => 'effective_date'
3059: ,p_argument_value => p_effective_date
3060: );

Line 3072: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>

3068: ,p_object_version_number => p_object_version_number
3069: );
3070: --
3071: if ((l_api_updating and
3072: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3073: nvl(p_tax_state, hr_api.g_varchar2)) or
3074: (NOT l_api_updating))
3075: then
3076: hr_utility.set_location(l_proc, 2);

Line 3073: nvl(p_tax_state, hr_api.g_varchar2)) or

3069: );
3070: --
3071: if ((l_api_updating and
3072: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3073: nvl(p_tax_state, hr_api.g_varchar2)) or
3074: (NOT l_api_updating))
3075: then
3076: hr_utility.set_location(l_proc, 2);
3077: --

Line 3098: if hr_api.not_exists_in_hr_lookups

3094: -- Check that value for tax_state is valid.
3095: --
3096: hr_utility.set_location(l_proc, 4);
3097: --
3098: if hr_api.not_exists_in_hr_lookups
3099: (p_effective_date => p_effective_date
3100: ,p_lookup_type => 'US_STATE'
3101: ,p_lookup_code => p_tax_state
3102: )

Line 3185: hr_api.mandatory_arg_error

3181: hr_utility.set_location('Entering:'|| l_proc, 1);
3182: --
3183: -- Check mandatory parameters have been set
3184: --
3185: hr_api.mandatory_arg_error
3186: (p_api_name => l_proc
3187: ,p_argument => 'style'
3188: ,p_argument_value => p_style
3189: );

Line 3200: nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>

3196: (p_address_id => p_address_id
3197: ,p_object_version_number => p_object_version_number);
3198: --
3199: if ((l_api_updating and
3200: nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3201: nvl(p_town_or_city, hr_api.g_varchar2)) or
3202: (NOT l_api_updating))
3203: then
3204: hr_utility.set_location(l_proc, 2);

Line 3201: nvl(p_town_or_city, hr_api.g_varchar2)) or

3197: ,p_object_version_number => p_object_version_number);
3198: --
3199: if ((l_api_updating and
3200: nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3201: nvl(p_town_or_city, hr_api.g_varchar2)) or
3202: (NOT l_api_updating))
3203: then
3204: hr_utility.set_location(l_proc, 2);
3205: --

Line 3302: hr_api.mandatory_arg_error

3298: hr_utility.set_location('Entering:'|| l_proc, 1);
3299: --
3300: -- Check mandatory parameters have been set
3301: --
3302: hr_api.mandatory_arg_error
3303: (p_api_name => l_proc
3304: ,p_argument => 'style'
3305: ,p_argument_value => p_style
3306: );

Line 3317: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>

3313: (p_address_id => p_address_id
3314: ,p_object_version_number => p_object_version_number);
3315: --
3316: if ((l_api_updating and
3317: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3318: nvl(p_tax_city, hr_api.g_varchar2)) or
3319: (NOT l_api_updating))
3320: then
3321: hr_utility.set_location(l_proc, 2);

Line 3318: nvl(p_tax_city, hr_api.g_varchar2)) or

3314: ,p_object_version_number => p_object_version_number);
3315: --
3316: if ((l_api_updating and
3317: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3318: nvl(p_tax_city, hr_api.g_varchar2)) or
3319: (NOT l_api_updating))
3320: then
3321: hr_utility.set_location(l_proc, 2);
3322: --

Line 3476: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>

3472: (p_address_id => p_address_id
3473: ,p_object_version_number => p_object_version_number);
3474: --
3475: if ((l_api_updating and
3476: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3477: nvl(p_region_2, hr_api.g_varchar2)) or
3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>

Line 3477: nvl(p_region_2, hr_api.g_varchar2)) or

3473: ,p_object_version_number => p_object_version_number);
3474: --
3475: if ((l_api_updating and
3476: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3477: nvl(p_region_2, hr_api.g_varchar2)) or
3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3481: nvl(p_postal_code, hr_api.g_varchar2)) or

Line 3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>

3474: --
3475: if ((l_api_updating and
3476: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3477: nvl(p_region_2, hr_api.g_varchar2)) or
3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3481: nvl(p_postal_code, hr_api.g_varchar2)) or
3482: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>

Line 3479: nvl(p_region_1, hr_api.g_varchar2)) or

3475: if ((l_api_updating and
3476: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3477: nvl(p_region_2, hr_api.g_varchar2)) or
3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3481: nvl(p_postal_code, hr_api.g_varchar2)) or
3482: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3483: nvl(p_town_or_city, hr_api.g_varchar2))) or

Line 3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>

3476: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3477: nvl(p_region_2, hr_api.g_varchar2)) or
3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3481: nvl(p_postal_code, hr_api.g_varchar2)) or
3482: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3483: nvl(p_town_or_city, hr_api.g_varchar2))) or
3484: (NOT l_api_updating)) then

Line 3481: nvl(p_postal_code, hr_api.g_varchar2)) or

3477: nvl(p_region_2, hr_api.g_varchar2)) or
3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3481: nvl(p_postal_code, hr_api.g_varchar2)) or
3482: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3483: nvl(p_town_or_city, hr_api.g_varchar2))) or
3484: (NOT l_api_updating)) then
3485: --

Line 3482: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>

3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3481: nvl(p_postal_code, hr_api.g_varchar2)) or
3482: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3483: nvl(p_town_or_city, hr_api.g_varchar2))) or
3484: (NOT l_api_updating)) then
3485: --
3486: hr_utility.set_location(l_proc, 20);

Line 3483: nvl(p_town_or_city, hr_api.g_varchar2))) or

3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3481: nvl(p_postal_code, hr_api.g_varchar2)) or
3482: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3483: nvl(p_town_or_city, hr_api.g_varchar2))) or
3484: (NOT l_api_updating)) then
3485: --
3486: hr_utility.set_location(l_proc, 20);
3487: --

Line 3782: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>

3778: (p_address_id => p_address_id
3779: ,p_object_version_number => p_object_version_number);
3780: --
3781: if ((l_api_updating and
3782: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3783: nvl(p_tax_city, hr_api.g_varchar2)) or
3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>

Line 3783: nvl(p_tax_city, hr_api.g_varchar2)) or

3779: ,p_object_version_number => p_object_version_number);
3780: --
3781: if ((l_api_updating and
3782: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3783: nvl(p_tax_city, hr_api.g_varchar2)) or
3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3787: nvl(p_tax_zip, hr_api.g_varchar2)) or

Line 3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>

3780: --
3781: if ((l_api_updating and
3782: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3783: nvl(p_tax_city, hr_api.g_varchar2)) or
3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3787: nvl(p_tax_zip, hr_api.g_varchar2)) or
3788: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>

Line 3785: nvl(p_tax_county, hr_api.g_varchar2)) or

3781: if ((l_api_updating and
3782: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3783: nvl(p_tax_city, hr_api.g_varchar2)) or
3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3787: nvl(p_tax_zip, hr_api.g_varchar2)) or
3788: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3789: nvl(p_tax_city, hr_api.g_varchar2))) or

Line 3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>

3782: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3783: nvl(p_tax_city, hr_api.g_varchar2)) or
3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3787: nvl(p_tax_zip, hr_api.g_varchar2)) or
3788: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3789: nvl(p_tax_city, hr_api.g_varchar2))) or
3790: (NOT l_api_updating)) then

Line 3787: nvl(p_tax_zip, hr_api.g_varchar2)) or

3783: nvl(p_tax_city, hr_api.g_varchar2)) or
3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3787: nvl(p_tax_zip, hr_api.g_varchar2)) or
3788: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3789: nvl(p_tax_city, hr_api.g_varchar2))) or
3790: (NOT l_api_updating)) then
3791: --

Line 3788: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>

3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3787: nvl(p_tax_zip, hr_api.g_varchar2)) or
3788: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3789: nvl(p_tax_city, hr_api.g_varchar2))) or
3790: (NOT l_api_updating)) then
3791: --
3792: hr_utility.set_location(l_proc, 20);

Line 3789: nvl(p_tax_city, hr_api.g_varchar2))) or

3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3787: nvl(p_tax_zip, hr_api.g_varchar2)) or
3788: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3789: nvl(p_tax_city, hr_api.g_varchar2))) or
3790: (NOT l_api_updating)) then
3791: --
3792: hr_utility.set_location(l_proc, 20);
3793: --

Line 4024: l_date := nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot);

4020: and pa2.person_id = per_add_shd.g_old_rec.person_id
4021: and pa2.primary_flag = 'Y');
4022: --
4023: begin
4024: l_date := nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot);
4025: hr_utility.set_location('Entering:'|| l_proc, 1);
4026: --
4027: -- For primary addresses only
4028: -- ==========================

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

4112: --
4113: -- start of commenting the code for business_group_id and person_id
4114: -- are updateable if currently null
4115: /*
4116: if nvl(p_rec.business_group_id, hr_api.g_number) <>
4117: per_add_shd.g_old_rec.business_group_id then
4118: hr_api.argument_changed_error
4119: (p_api_name => l_proc
4120: ,p_argument => 'BUSINESS_GROUP_ID'

Line 4118: hr_api.argument_changed_error

4114: -- are updateable if currently null
4115: /*
4116: if nvl(p_rec.business_group_id, hr_api.g_number) <>
4117: per_add_shd.g_old_rec.business_group_id then
4118: hr_api.argument_changed_error
4119: (p_api_name => l_proc
4120: ,p_argument => 'BUSINESS_GROUP_ID'
4121: ,p_base_table => per_add_shd.g_tab_nam
4122: );

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

4122: );
4123: end if;
4124: hr_utility.set_location(l_proc, 7);
4125: --
4126: if nvl(p_rec.person_id, hr_api.g_number) <>
4127: per_add_shd.g_old_rec.person_id then
4128: hr_api.argument_changed_error
4129: (p_api_name => l_proc
4130: ,p_argument => 'PERSON_ID'

Line 4128: hr_api.argument_changed_error

4124: hr_utility.set_location(l_proc, 7);
4125: --
4126: if nvl(p_rec.person_id, hr_api.g_number) <>
4127: per_add_shd.g_old_rec.person_id then
4128: hr_api.argument_changed_error
4129: (p_api_name => l_proc
4130: ,p_argument => 'PERSON_ID'
4131: ,p_base_table => per_add_shd.g_tab_nam
4132: );

Line 4140: if nvl(p_rec.primary_flag, hr_api.g_varchar2) <>

4136: --
4137: hr_utility.set_location(l_proc, 8);
4138: --
4139: if not g_called_from_form then
4140: if nvl(p_rec.primary_flag, hr_api.g_varchar2) <>
4141: per_add_shd.g_old_rec.primary_flag then
4142: hr_api.argument_changed_error
4143: (p_api_name => l_proc
4144: ,p_argument => 'PRIMARY_FLAG'

Line 4142: hr_api.argument_changed_error

4138: --
4139: if not g_called_from_form then
4140: if nvl(p_rec.primary_flag, hr_api.g_varchar2) <>
4141: per_add_shd.g_old_rec.primary_flag then
4142: hr_api.argument_changed_error
4143: (p_api_name => l_proc
4144: ,p_argument => 'PRIMARY_FLAG'
4145: ,p_base_table => per_add_shd.g_tab_nam
4146: );

Line 4171: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)

4167: -- value has changed
4168: --
4169: if (p_rec.address_id is null)
4170: or ((p_rec.address_id is not null)
4171: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4172: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)

Line 4172: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)

4168: --
4169: if (p_rec.address_id is null)
4170: or ((p_rec.address_id is not null)
4171: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4172: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)

Line 4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)

4169: if (p_rec.address_id is null)
4170: or ((p_rec.address_id is not null)
4171: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4172: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)

Line 4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)

4170: or ((p_rec.address_id is not null)
4171: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4172: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)

Line 4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)

4171: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4172: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)

Line 4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)

4172: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)

Line 4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)

4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)

Line 4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)

4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)

Line 4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)

4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)

Line 4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)

4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)

Line 4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)

4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)

Line 4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)

4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)

Line 4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)

4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)

Line 4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)

4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)

Line 4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)

4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)

Line 4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)

4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)

Line 4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)

4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)

Line 4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)

4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)

Line 4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)

4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)

Line 4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)

4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)

Line 4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)

4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)

Line 4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)

4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)

Line 4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)

4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)

Line 4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)

4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)

Line 4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)

4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)

Line 4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)

4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)

Line 4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)

4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)

Line 4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)

4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)

Line 4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)

4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)

Line 4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)

4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)

Line 4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)

4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)

Line 4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)

4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)

Line 4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)

4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)

Line 4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)

4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)

Line 4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)

4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)

Line 4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)

4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4210: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)

Line 4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)

4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4210: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4211: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)

Line 4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)

4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4210: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4211: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4212: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)

Line 4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)

4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4210: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4211: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4212: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4213: )

Line 4210: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)

4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4210: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4211: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4212: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4213: )
4214: )

Line 4211: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)

4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4210: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4211: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4212: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4213: )
4214: )
4215: then

Line 4212: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)

4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4210: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4211: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4212: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4213: )
4214: )
4215: then
4216: --

Line 4286: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)

4282: -- value has changed
4283: --
4284: if (p_rec.address_id is null)
4285: or ((p_rec.address_id is not null)
4286: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4287: <> nvl(p_rec.style, hr_api.g_varchar2)
4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)

Line 4287: <> nvl(p_rec.style, hr_api.g_varchar2)

4283: --
4284: if (p_rec.address_id is null)
4285: or ((p_rec.address_id is not null)
4286: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4287: <> nvl(p_rec.style, hr_api.g_varchar2)
4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)

Line 4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)

4284: if (p_rec.address_id is null)
4285: or ((p_rec.address_id is not null)
4286: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4287: <> nvl(p_rec.style, hr_api.g_varchar2)
4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)

Line 4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)

4285: or ((p_rec.address_id is not null)
4286: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4287: <> nvl(p_rec.style, hr_api.g_varchar2)
4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)

Line 4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)

4286: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4287: <> nvl(p_rec.style, hr_api.g_varchar2)
4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)

Line 4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)

4287: <> nvl(p_rec.style, hr_api.g_varchar2)
4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)

Line 4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)

4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)

Line 4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)

4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)

Line 4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)

4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)

Line 4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)

4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)

Line 4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)

4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)

Line 4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)

4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)

Line 4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)

4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)

Line 4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)

4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)

Line 4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)

4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)

Line 4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)

4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)

Line 4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)

4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)

Line 4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)

4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)

Line 4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)

4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)

Line 4305: <> nvl(p_rec.country, hr_api.g_varchar2)

4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)

Line 4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)

4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)

Line 4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)

4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)

Line 4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)

4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)

Line 4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)

4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)

Line 4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)

4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)

Line 4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)

4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)

Line 4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)

4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)

Line 4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)

4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)

Line 4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)

4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)

Line 4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)

4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)

Line 4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)

4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019

Line 4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)

4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)

Line 4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)

4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)

Line 4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)

4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)

Line 4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019

4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)

Line 4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)

4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4325: <> nvl(p_rec.add_information19, hr_api.g_varchar2)

Line 4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)

4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4325: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4326: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)

Line 4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)

4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4325: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4326: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4327: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019

Line 4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)

4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4325: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4326: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4327: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019
4328: )

Line 4325: <> nvl(p_rec.add_information19, hr_api.g_varchar2)

4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4325: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4326: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4327: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019
4328: )
4329: )

Line 4326: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)

4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4325: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4326: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4327: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019
4328: )
4329: )
4330: then

Line 4327: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019

4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4325: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4326: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4327: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019
4328: )
4329: )
4330: then
4331: --

Line 4420: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>

4416: --
4417: begin
4418: hr_utility.set_location('Entering:'||l_proc, 10);
4419: --
4420: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4421: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>

Line 4421: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or

4417: begin
4418: hr_utility.set_location('Entering:'||l_proc, 10);
4419: --
4420: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4421: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or

Line 4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>

4418: hr_utility.set_location('Entering:'||l_proc, 10);
4419: --
4420: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4421: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>

Line 4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or

4419: --
4420: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4421: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or

Line 4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>

4420: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4421: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>

Line 4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or

4421: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or

Line 4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>

4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>

Line 4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or

4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or

Line 4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>

4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>

Line 4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or

4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or

Line 4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>

4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>

Line 4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or

4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or

Line 4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>

4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>

Line 4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or

4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or

Line 4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>

4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>

Line 4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or

4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or

Line 4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>

4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>

Line 4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or

4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or

Line 4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>

4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>

Line 4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or

4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or

Line 4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>

4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>

Line 4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or

4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or

Line 4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>

4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>

Line 4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or

4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or

Line 4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>

4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>

Line 4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or

4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or

Line 4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>

4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>

Line 4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or

4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or

Line 4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>

4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>

Line 4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or

4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or

Line 4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>

4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>

Line 4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or

4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or

Line 4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>

4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>

Line 4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or

4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or

Line 4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>

4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>

Line 4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or

4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or

Line 4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>

4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>

Line 4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or

4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or

Line 4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>

4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>

Line 4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or

4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or

Line 4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>

4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>

Line 4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or

4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or

Line 4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>

4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>

Line 4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or

4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or

Line 4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>

4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>

Line 4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or

4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or

Line 4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>

4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>

Line 4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or

4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or

Line 4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>

4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>

Line 4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or

4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or

Line 4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>

4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>

Line 4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or

4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or

Line 4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>

4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>

Line 4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or

4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4477: nvl(p_rec.add_information20, hr_api.g_varchar2) or

Line 4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>

4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4477: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4478: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge

Line 4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or

4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4477: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4478: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4479: nvl(p_rec.party_id, hr_api.g_number)

Line 4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>

4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4477: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4478: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4479: nvl(p_rec.party_id, hr_api.g_number)
4480: then

Line 4477: nvl(p_rec.add_information20, hr_api.g_varchar2) or

4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4477: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4478: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4479: nvl(p_rec.party_id, hr_api.g_number)
4480: then
4481: -- either the attribute_category or attribute1..30 have changed

Line 4478: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge

4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4477: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4478: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4479: nvl(p_rec.party_id, hr_api.g_number)
4480: then
4481: -- either the attribute_category or attribute1..30 have changed
4482: -- so we must call the flex stub

Line 4479: nvl(p_rec.party_id, hr_api.g_number)

4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4477: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4478: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4479: nvl(p_rec.party_id, hr_api.g_number)
4480: then
4481: -- either the attribute_category or attribute1..30 have changed
4482: -- so we must call the flex stub
4483: per_add_flex.df(p_rec => p_rec);

Line 4519: hr_api.validate_bus_grp_id(

4515: if p_rec.person_id is not null then
4516: --
4517: -- Validate business group id
4518: --
4519: hr_api.validate_bus_grp_id(
4520: p_business_group_id => p_rec.business_group_id
4521: ,p_associated_column1 => per_add_shd.g_tab_nam ||
4522: '.BUSINESS_GROUP_ID'
4523: );

Line 4904: hr_api.validate_bus_grp_id(

4900: if p_rec.person_id is not null then
4901: --
4902: -- Validate business group id
4903: --
4904: hr_api.validate_bus_grp_id(
4905: p_business_group_id => p_rec.business_group_id
4906: ,p_associated_column1 => per_add_shd.g_tab_nam ||
4907: '.BUSINESS_GROUP_ID'
4908: );

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

5287: hr_utility.set_location('Entering:'|| l_proc, 10);
5288: --
5289: -- Ensure that all the mandatory parameter are not null
5290: --
5291: hr_api.mandatory_arg_error(p_api_name => l_proc,
5292: p_argument => 'address_id',
5293: p_argument_value => p_address_id);
5294: --
5295: if nvl(g_address_id, hr_api.g_number) = p_address_id then

Line 5295: if nvl(g_address_id, hr_api.g_number) = p_address_id then

5291: hr_api.mandatory_arg_error(p_api_name => l_proc,
5292: p_argument => 'address_id',
5293: p_argument_value => p_address_id);
5294: --
5295: if nvl(g_address_id, hr_api.g_number) = p_address_id then
5296: --
5297: -- The legislation has already been found with a previous
5298: -- call to this function. Just return the value in the global
5299: -- variable.