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 939: where p_date_from <= nvl(pa.date_to, hr_api.g_eot)

935: --
936: cursor csr_dup_add_type_exists is
937: select null
938: from per_addresses pa
939: where p_date_from <= nvl(pa.date_to, hr_api.g_eot)
940: and l_date_to >= pa.date_from
941: and pa.address_type = p_address_type
942: and (pa.person_id = p_person_id OR -- HR/TCA merge
943: (pa.party_id = p_party_id and p_person_id is null)) -- #3406505

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

947: --
948: cursor csr_dup_prim_flag is
949: select null
950: from per_addresses pa
951: where p_date_from <= nvl(pa.date_to, hr_api.g_eot)
952: and l_date_to >= pa.date_from
953: and pa.primary_flag = 'Y'
954: and (pa.person_id = p_person_id OR --
955: (pa.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge -- #3406505

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

962: from per_addresses pa
963: where p_date_from >= pa.date_from
964: and exists (select null
965: from per_addresses pa2
966: where nvl(pa2.date_to, hr_api.g_eot) >= l_date_to
967: and (pa2.person_id = p_person_id OR --
968: (pa2.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge -- #3406505
969: and pa2.primary_flag = 'Y')
970: and pa.primary_flag = 'Y'

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

978: from sys.dual
979: where exists(select null
980: from per_addresses pa
981: where ((pa.date_from < p_date_from
982: and nvl(pa.date_to, hr_api.g_eot) >=
983: (select date_from
984: from per_addresses
985: where address_id = p_address_id)
986: and p_date_from <> (select date_from

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

985: where address_id = p_address_id)
986: and p_date_from <> (select date_from
987: from per_addresses
988: where address_id = p_address_id) )
989: or (nvl(pa.date_to, hr_api.g_eot) >
990: nvl(p_date_to, hr_api.g_eot)
991: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)
992: from per_addresses
993: where address_id = p_address_id)

Line 990: nvl(p_date_to, hr_api.g_eot)

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

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

987: from per_addresses
988: where address_id = p_address_id) )
989: or (nvl(pa.date_to, hr_api.g_eot) >
990: nvl(p_date_to, hr_api.g_eot)
991: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)
992: from per_addresses
993: where address_id = p_address_id)
994: and nvl(p_date_to, hr_api.g_eot) <>
995: (select nvl(date_to, hr_api.g_eot)

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

990: nvl(p_date_to, hr_api.g_eot)
991: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)
992: from per_addresses
993: where address_id = p_address_id)
994: and nvl(p_date_to, hr_api.g_eot) <>
995: (select nvl(date_to, hr_api.g_eot)
996: from per_addresses
997: where address_id = p_address_id) ))
998: and pa.primary_flag = 'N'

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

991: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)
992: from per_addresses
993: where address_id = p_address_id)
994: and nvl(p_date_to, hr_api.g_eot) <>
995: (select nvl(date_to, hr_api.g_eot)
996: from per_addresses
997: where address_id = p_address_id) ))
998: and pa.primary_flag = 'N'
999: and (pa.person_id = p_person_id OR

Line 1043: hr_api.mandatory_arg_error

1039: hr_utility.set_location('Entering:'|| l_proc, 10);
1040: --
1041: -- Check mandatory parameters have been set
1042: --
1043: hr_api.mandatory_arg_error
1044: (p_api_name => l_proc
1045: ,p_argument => 'date_from'
1046: ,p_argument_value => p_date_from
1047: );

Line 1050: hr_api.mandatory_arg_error

1046: ,p_argument_value => p_date_from
1047: );
1048: --
1049: if p_party_id is null then -- HR/TCA merge
1050: hr_api.mandatory_arg_error
1051: (p_api_name => l_proc
1052: ,p_argument => 'person_id'
1053: ,p_argument_value => p_person_id
1054: );

Line 1057: hr_api.mandatory_arg_error

1053: ,p_argument_value => p_person_id
1054: );
1055: end if;
1056: --
1057: hr_api.mandatory_arg_error
1058: (p_api_name => l_proc
1059: ,p_argument => 'primary_flag'
1060: ,p_argument_value => p_primary_flag
1061: );

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

1068: ) then
1069: --
1070: -- Set the DATE_TO to entered value or the end of time
1071: --
1072: l_date_to := nvl(p_date_to, hr_api.g_eot);
1073: --
1074: -- Only proceed with validation if :
1075: -- a) The current g_old_rec is current and
1076: -- b) The value for date_to/date_from has changed

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

1081: );
1082: --
1083: if ((l_api_updating and
1084: per_add_shd.g_old_rec.date_from <> p_date_from) or
1085: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1086: nvl(p_date_to, hr_api.g_eot)) or
1087: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1088: nvl(p_address_type, hr_api.g_varchar2))
1089: or

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

1082: --
1083: if ((l_api_updating and
1084: per_add_shd.g_old_rec.date_from <> p_date_from) or
1085: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1086: nvl(p_date_to, hr_api.g_eot)) or
1087: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1088: nvl(p_address_type, hr_api.g_varchar2))
1089: or
1090: (NOT l_api_updating))

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

1083: if ((l_api_updating and
1084: per_add_shd.g_old_rec.date_from <> p_date_from) or
1085: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1086: nvl(p_date_to, hr_api.g_eot)) or
1087: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1088: nvl(p_address_type, hr_api.g_varchar2))
1089: or
1090: (NOT l_api_updating))
1091: then

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

1084: per_add_shd.g_old_rec.date_from <> p_date_from) or
1085: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1086: nvl(p_date_to, hr_api.g_eot)) or
1087: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1088: nvl(p_address_type, hr_api.g_varchar2))
1089: or
1090: (NOT l_api_updating))
1091: then
1092: hr_utility.set_location(l_proc, 30);

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

1096: -- Checks that the date_from, date_to values for a given address
1097: -- do not cause an overlap of address_type value between two
1098: -- addresses for the same person within a given date range.
1099: --
1100: if (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1101: nvl(p_address_type, hr_api.g_varchar2)) or
1102: (NOT l_api_updating) then
1103: --
1104: if p_address_type is not null then

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

1097: -- do not cause an overlap of address_type value between two
1098: -- addresses for the same person within a given date range.
1099: --
1100: if (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1101: nvl(p_address_type, hr_api.g_varchar2)) or
1102: (NOT l_api_updating) then
1103: --
1104: if p_address_type is not null then
1105: open csr_dup_add_type_exists;

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

1227: -- address is left without a corresponding
1228: -- primary
1229: --
1230: if ((per_add_shd.g_old_rec.date_from <> p_date_from) or
1231: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1232: (nvl(p_date_to, hr_api.g_eot)))) and
1233: p_address_id is not null then
1234: open csr_invalid_non_prim;
1235: fetch csr_invalid_non_prim into l_exists;

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

1228: -- primary
1229: --
1230: if ((per_add_shd.g_old_rec.date_from <> p_date_from) or
1231: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1232: (nvl(p_date_to, hr_api.g_eot)))) and
1233: p_address_id is not null then
1234: open csr_invalid_non_prim;
1235: fetch csr_invalid_non_prim into l_exists;
1236: if csr_invalid_non_prim%found then

Line 1371: hr_api.mandatory_arg_error

1367: hr_utility.set_location('Entering:'|| l_proc, 1);
1368: --
1369: -- Check mandatory parameters have been set
1370: --
1371: hr_api.mandatory_arg_error
1372: (p_api_name => l_proc
1373: ,p_argument => 'style'
1374: ,p_argument_value => p_style
1375: );

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

1486: ,p_object_version_number => p_object_version_number
1487: );
1488: --
1489: if p_region_3 is not null
1490: and nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
1491: = nvl(p_region_3, hr_api.g_varchar2)
1492: then
1493: --
1494: null;

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

1487: );
1488: --
1489: if p_region_3 is not null
1490: and nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
1491: = nvl(p_region_3, hr_api.g_varchar2)
1492: then
1493: --
1494: null;
1495: --

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

1502: --
1503: -- Check if telephone number 3 is set but is unchanged on update
1504: --
1505: if p_telephone_number_3 is not null
1506: and nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
1507: = nvl(p_telephone_number_3, hr_api.g_varchar2)
1508: then
1509: --
1510: null;

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

1503: -- Check if telephone number 3 is set but is unchanged on update
1504: --
1505: if p_telephone_number_3 is not null
1506: and nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
1507: = nvl(p_telephone_number_3, hr_api.g_varchar2)
1508: then
1509: --
1510: null;
1511: --

Line 1589: hr_api.mandatory_arg_error

1585: hr_utility.set_location('Entering:'|| l_proc, 1);
1586: --
1587: -- Check mandatory parameters have been set
1588: --
1589: hr_api.mandatory_arg_error
1590: (p_api_name => l_proc
1591: ,p_argument => 'style'
1592: ,p_argument_value => p_style
1593: );

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

1600: (p_address_id => p_address_id
1601: ,p_object_version_number => p_object_version_number);
1602: --
1603: if ((l_api_updating and
1604: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2) <>
1605: nvl(p_address_line1, hr_api.g_varchar2)) or
1606: (NOT l_api_updating)) then
1607: hr_utility.set_location(l_proc, 2);
1608: --

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

1601: ,p_object_version_number => p_object_version_number);
1602: --
1603: if ((l_api_updating and
1604: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2) <>
1605: nvl(p_address_line1, hr_api.g_varchar2)) or
1606: (NOT l_api_updating)) then
1607: hr_utility.set_location(l_proc, 2);
1608: --
1609: -- Check that value for address_line1 is not null for 'US' and 'GB'

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

1687:
1688: if ( (l_legislation_code = 'JP')
1689: and
1690: ( (l_api_updating and
1691: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1692: nvl(p_town_or_city, hr_api.g_varchar2) or
1693: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1694: nvl(p_address_line1, hr_api.g_varchar2) or
1695: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>

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

1688: if ( (l_legislation_code = 'JP')
1689: and
1690: ( (l_api_updating and
1691: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1692: nvl(p_town_or_city, hr_api.g_varchar2) or
1693: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1694: nvl(p_address_line1, hr_api.g_varchar2) or
1695: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1696: nvl(p_region_1, hr_api.g_varchar2)))

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

1689: and
1690: ( (l_api_updating and
1691: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1692: nvl(p_town_or_city, hr_api.g_varchar2) or
1693: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1694: nvl(p_address_line1, hr_api.g_varchar2) or
1695: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1696: nvl(p_region_1, hr_api.g_varchar2)))
1697: or

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

1690: ( (l_api_updating and
1691: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1692: nvl(p_town_or_city, hr_api.g_varchar2) or
1693: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1694: nvl(p_address_line1, hr_api.g_varchar2) or
1695: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1696: nvl(p_region_1, hr_api.g_varchar2)))
1697: or
1698: (NOT l_api_updating))

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

1691: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1692: nvl(p_town_or_city, hr_api.g_varchar2) or
1693: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1694: nvl(p_address_line1, hr_api.g_varchar2) or
1695: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1696: nvl(p_region_1, hr_api.g_varchar2)))
1697: or
1698: (NOT l_api_updating))
1699: ) then

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

1692: nvl(p_town_or_city, hr_api.g_varchar2) or
1693: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1694: nvl(p_address_line1, hr_api.g_varchar2) or
1695: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1696: nvl(p_region_1, hr_api.g_varchar2)))
1697: or
1698: (NOT l_api_updating))
1699: ) then
1700:

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

1870: (p_address_id => p_address_id
1871: ,p_object_version_number => p_object_version_number);
1872:
1873: if ((l_api_updating and
1874: (nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2) <>
1875: nvl(p_address_line2, hr_api.g_varchar2) or
1876: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1877: nvl(p_region_2, hr_api.g_varchar2)
1878: )) or (NOT l_api_updating)) then

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

1871: ,p_object_version_number => p_object_version_number);
1872:
1873: if ((l_api_updating and
1874: (nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2) <>
1875: nvl(p_address_line2, hr_api.g_varchar2) or
1876: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1877: nvl(p_region_2, hr_api.g_varchar2)
1878: )) or (NOT l_api_updating)) then
1879:

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

1872:
1873: if ((l_api_updating and
1874: (nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2) <>
1875: nvl(p_address_line2, hr_api.g_varchar2) or
1876: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1877: nvl(p_region_2, hr_api.g_varchar2)
1878: )) or (NOT l_api_updating)) then
1879:
1880: hr_utility.set_location(l_proc, 2);

Line 1877: nvl(p_region_2, hr_api.g_varchar2)

1873: if ((l_api_updating and
1874: (nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2) <>
1875: nvl(p_address_line2, hr_api.g_varchar2) or
1876: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1877: nvl(p_region_2, hr_api.g_varchar2)
1878: )) or (NOT l_api_updating)) then
1879:
1880: hr_utility.set_location(l_proc, 2);
1881:

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

1931: (p_address_id => p_address_id
1932: ,p_object_version_number => p_object_version_number);
1933:
1934: if ((l_api_updating and
1935: (nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2) <>
1936: nvl(p_address_line3, hr_api.g_varchar2) or
1937: nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1938: nvl(p_region_3, hr_api.g_varchar2)
1939: )) or (NOT l_api_updating)) then

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

1932: ,p_object_version_number => p_object_version_number);
1933:
1934: if ((l_api_updating and
1935: (nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2) <>
1936: nvl(p_address_line3, hr_api.g_varchar2) or
1937: nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1938: nvl(p_region_3, hr_api.g_varchar2)
1939: )) or (NOT l_api_updating)) then
1940:

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

1933:
1934: if ((l_api_updating and
1935: (nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2) <>
1936: nvl(p_address_line3, hr_api.g_varchar2) or
1937: nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1938: nvl(p_region_3, hr_api.g_varchar2)
1939: )) or (NOT l_api_updating)) then
1940:
1941: hr_utility.set_location(l_proc, 2);

Line 1938: nvl(p_region_3, hr_api.g_varchar2)

1934: if ((l_api_updating and
1935: (nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2) <>
1936: nvl(p_address_line3, hr_api.g_varchar2) or
1937: nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1938: nvl(p_region_3, hr_api.g_varchar2)
1939: )) or (NOT l_api_updating)) then
1940:
1941: hr_utility.set_location(l_proc, 2);
1942:

Line 2107: hr_api.mandatory_arg_error

2103: hr_utility.set_location('Entering:'|| l_proc, 1);
2104: --
2105: -- Check mandatory parameters have been set
2106: --
2107: hr_api.mandatory_arg_error
2108: (p_api_name => l_proc
2109: ,p_argument => 'style'
2110: ,p_argument_value => p_style
2111: );

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

2118: (p_address_id => p_address_id
2119: ,p_object_version_number => p_object_version_number);
2120: --
2121: if ((l_api_updating
2122: and nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
2123: nvl(p_postal_code, hr_api.g_varchar2)) or
2124: (NOT l_api_updating))
2125: then
2126: hr_utility.set_location(l_proc, 2);

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

2119: ,p_object_version_number => p_object_version_number);
2120: --
2121: if ((l_api_updating
2122: and nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
2123: nvl(p_postal_code, hr_api.g_varchar2)) or
2124: (NOT l_api_updating))
2125: then
2126: hr_utility.set_location(l_proc, 2);
2127: --

Line 2412: hr_api.mandatory_arg_error

2408: hr_utility.set_location('Entering:'|| l_proc, 1);
2409: --
2410: -- Check mandatory parameters have been set
2411: --
2412: hr_api.mandatory_arg_error
2413: (p_api_name => l_proc
2414: ,p_argument => 'style'
2415: ,p_argument_value => p_style
2416: );

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

2423: (p_address_id => p_address_id
2424: ,p_object_version_number => p_object_version_number);
2425: --
2426: if ((l_api_updating
2427: and nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
2428: nvl(p_tax_address_zip, hr_api.g_varchar2)) or
2429: (NOT l_api_updating))
2430: then
2431: hr_utility.set_location(l_proc, 2);

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

2424: ,p_object_version_number => p_object_version_number);
2425: --
2426: if ((l_api_updating
2427: and nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
2428: nvl(p_tax_address_zip, hr_api.g_varchar2)) or
2429: (NOT l_api_updating))
2430: then
2431: hr_utility.set_location(l_proc, 2);
2432: --

Line 2590: hr_api.mandatory_arg_error

2586: hr_utility.set_location('Entering:'|| l_proc, 1);
2587: --
2588: -- Check mandatory parameters have been set
2589: --
2590: hr_api.mandatory_arg_error
2591: (p_api_name => l_proc
2592: ,p_argument => 'style'
2593: ,p_argument_value => p_style
2594: );

Line 2596: hr_api.mandatory_arg_error

2592: ,p_argument => 'style'
2593: ,p_argument_value => p_style
2594: );
2595: --
2596: hr_api.mandatory_arg_error
2597: (p_api_name => l_proc
2598: ,p_argument => 'effective_date'
2599: ,p_argument_value => p_effective_date
2600: );

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

2607: (p_address_id => p_address_id
2608: ,p_object_version_number => p_object_version_number);
2609: --
2610: if ((l_api_updating and
2611: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
2612: nvl(p_region_1, hr_api.g_varchar2)) or
2613: (NOT l_api_updating))
2614: then
2615: hr_utility.set_location(l_proc, 2);

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

2608: ,p_object_version_number => p_object_version_number);
2609: --
2610: if ((l_api_updating and
2611: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
2612: nvl(p_region_1, hr_api.g_varchar2)) or
2613: (NOT l_api_updating))
2614: then
2615: hr_utility.set_location(l_proc, 2);
2616: --

Line 2653: if hr_api.not_exists_in_hr_lookups

2649: --
2650: if p_style = 'GB' then
2651: hr_utility.set_location(l_proc, 4);
2652: --
2653: if hr_api.not_exists_in_hr_lookups
2654: (p_effective_date => p_effective_date
2655: ,p_lookup_type => 'GB_COUNTY'
2656: ,p_lookup_code => p_region_1
2657: ) then

Line 2744: hr_api.mandatory_arg_error

2740: -- Check mandatory parameters have been set
2741: --
2742: if p_tax_county is not null
2743: then
2744: hr_api.mandatory_arg_error
2745: (p_api_name => l_proc
2746: ,p_argument => 'style'
2747: ,p_argument_value => p_style
2748: );

Line 2750: hr_api.mandatory_arg_error

2746: ,p_argument => 'style'
2747: ,p_argument_value => p_style
2748: );
2749: --
2750: hr_api.mandatory_arg_error
2751: (p_api_name => l_proc
2752: ,p_argument => 'effective_date'
2753: ,p_argument_value => p_effective_date
2754: );

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

2761: (p_address_id => p_address_id
2762: ,p_object_version_number => p_object_version_number);
2763: --
2764: if ((l_api_updating and
2765: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
2766: nvl(p_tax_county, hr_api.g_varchar2)) or
2767: (NOT l_api_updating))
2768: then
2769: hr_utility.set_location(l_proc, 2);

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

2762: ,p_object_version_number => p_object_version_number);
2763: --
2764: if ((l_api_updating and
2765: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
2766: nvl(p_tax_county, hr_api.g_varchar2)) or
2767: (NOT l_api_updating))
2768: then
2769: hr_utility.set_location(l_proc, 2);
2770: --

Line 2869: hr_api.mandatory_arg_error

2865: hr_utility.set_location('Entering:'|| l_proc, 1);
2866: --
2867: -- Check mandatory parameters have been set.
2868: --
2869: hr_api.mandatory_arg_error
2870: (p_api_name => l_proc
2871: ,p_argument => 'style'
2872: ,p_argument_value => p_style
2873: );

Line 2875: hr_api.mandatory_arg_error

2871: ,p_argument => 'style'
2872: ,p_argument_value => p_style
2873: );
2874: --
2875: hr_api.mandatory_arg_error
2876: (p_api_name => l_proc
2877: ,p_argument => 'effective_date'
2878: ,p_argument_value => p_effective_date
2879: );

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

2887: ,p_object_version_number => p_object_version_number
2888: );
2889: --
2890: if ((l_api_updating and
2891: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
2892: nvl(p_region_2, hr_api.g_varchar2)) or
2893: (NOT l_api_updating))
2894: then
2895: hr_utility.set_location(l_proc, 2);

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

2888: );
2889: --
2890: if ((l_api_updating and
2891: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
2892: nvl(p_region_2, hr_api.g_varchar2)) or
2893: (NOT l_api_updating))
2894: then
2895: hr_utility.set_location(l_proc, 2);
2896: --

Line 2932: if hr_api.not_exists_in_hr_lookups

2928: if p_style = 'US'
2929: then
2930: hr_utility.set_location(l_proc, 4);
2931: --
2932: if hr_api.not_exists_in_hr_lookups
2933: (p_effective_date => p_effective_date
2934: ,p_lookup_type => 'US_STATE'
2935: ,p_lookup_code => p_region_2
2936: )

Line 3031: hr_api.mandatory_arg_error

3027: hr_utility.set_location('Entering:'|| l_proc, 1);
3028: --
3029: -- Check mandatory parameters have been set.
3030: --
3031: hr_api.mandatory_arg_error
3032: (p_api_name => l_proc
3033: ,p_argument => 'style'
3034: ,p_argument_value => p_style
3035: );

Line 3037: hr_api.mandatory_arg_error

3033: ,p_argument => 'style'
3034: ,p_argument_value => p_style
3035: );
3036: --
3037: hr_api.mandatory_arg_error
3038: (p_api_name => l_proc
3039: ,p_argument => 'effective_date'
3040: ,p_argument_value => p_effective_date
3041: );

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

3049: ,p_object_version_number => p_object_version_number
3050: );
3051: --
3052: if ((l_api_updating and
3053: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3054: nvl(p_tax_state, hr_api.g_varchar2)) or
3055: (NOT l_api_updating))
3056: then
3057: hr_utility.set_location(l_proc, 2);

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

3050: );
3051: --
3052: if ((l_api_updating and
3053: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3054: nvl(p_tax_state, hr_api.g_varchar2)) or
3055: (NOT l_api_updating))
3056: then
3057: hr_utility.set_location(l_proc, 2);
3058: --

Line 3079: if hr_api.not_exists_in_hr_lookups

3075: -- Check that value for tax_state is valid.
3076: --
3077: hr_utility.set_location(l_proc, 4);
3078: --
3079: if hr_api.not_exists_in_hr_lookups
3080: (p_effective_date => p_effective_date
3081: ,p_lookup_type => 'US_STATE'
3082: ,p_lookup_code => p_tax_state
3083: )

Line 3166: hr_api.mandatory_arg_error

3162: hr_utility.set_location('Entering:'|| l_proc, 1);
3163: --
3164: -- Check mandatory parameters have been set
3165: --
3166: hr_api.mandatory_arg_error
3167: (p_api_name => l_proc
3168: ,p_argument => 'style'
3169: ,p_argument_value => p_style
3170: );

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

3177: (p_address_id => p_address_id
3178: ,p_object_version_number => p_object_version_number);
3179: --
3180: if ((l_api_updating and
3181: nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3182: nvl(p_town_or_city, hr_api.g_varchar2)) or
3183: (NOT l_api_updating))
3184: then
3185: hr_utility.set_location(l_proc, 2);

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

3178: ,p_object_version_number => p_object_version_number);
3179: --
3180: if ((l_api_updating and
3181: nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3182: nvl(p_town_or_city, hr_api.g_varchar2)) or
3183: (NOT l_api_updating))
3184: then
3185: hr_utility.set_location(l_proc, 2);
3186: --

Line 3283: hr_api.mandatory_arg_error

3279: hr_utility.set_location('Entering:'|| l_proc, 1);
3280: --
3281: -- Check mandatory parameters have been set
3282: --
3283: hr_api.mandatory_arg_error
3284: (p_api_name => l_proc
3285: ,p_argument => 'style'
3286: ,p_argument_value => p_style
3287: );

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

3294: (p_address_id => p_address_id
3295: ,p_object_version_number => p_object_version_number);
3296: --
3297: if ((l_api_updating and
3298: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3299: nvl(p_tax_city, hr_api.g_varchar2)) or
3300: (NOT l_api_updating))
3301: then
3302: hr_utility.set_location(l_proc, 2);

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

3295: ,p_object_version_number => p_object_version_number);
3296: --
3297: if ((l_api_updating and
3298: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3299: nvl(p_tax_city, hr_api.g_varchar2)) or
3300: (NOT l_api_updating))
3301: then
3302: hr_utility.set_location(l_proc, 2);
3303: --

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

3453: (p_address_id => p_address_id
3454: ,p_object_version_number => p_object_version_number);
3455: --
3456: if ((l_api_updating and
3457: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3458: nvl(p_region_2, hr_api.g_varchar2)) or
3459: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3460: nvl(p_region_1, hr_api.g_varchar2)) or
3461: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>

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

3454: ,p_object_version_number => p_object_version_number);
3455: --
3456: if ((l_api_updating and
3457: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3458: nvl(p_region_2, hr_api.g_varchar2)) or
3459: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3460: nvl(p_region_1, hr_api.g_varchar2)) or
3461: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3462: nvl(p_postal_code, hr_api.g_varchar2)) or

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

3455: --
3456: if ((l_api_updating and
3457: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3458: nvl(p_region_2, hr_api.g_varchar2)) or
3459: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3460: nvl(p_region_1, hr_api.g_varchar2)) or
3461: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3462: nvl(p_postal_code, hr_api.g_varchar2)) or
3463: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>

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

3456: if ((l_api_updating and
3457: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3458: nvl(p_region_2, hr_api.g_varchar2)) or
3459: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3460: nvl(p_region_1, hr_api.g_varchar2)) or
3461: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3462: nvl(p_postal_code, hr_api.g_varchar2)) or
3463: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3464: nvl(p_town_or_city, hr_api.g_varchar2))) or

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

3457: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3458: nvl(p_region_2, hr_api.g_varchar2)) or
3459: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3460: nvl(p_region_1, hr_api.g_varchar2)) or
3461: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3462: nvl(p_postal_code, hr_api.g_varchar2)) or
3463: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3464: nvl(p_town_or_city, hr_api.g_varchar2))) or
3465: (NOT l_api_updating)) then

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

3458: nvl(p_region_2, hr_api.g_varchar2)) or
3459: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3460: nvl(p_region_1, hr_api.g_varchar2)) or
3461: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3462: nvl(p_postal_code, hr_api.g_varchar2)) or
3463: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3464: nvl(p_town_or_city, hr_api.g_varchar2))) or
3465: (NOT l_api_updating)) then
3466: --

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

3459: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3460: nvl(p_region_1, hr_api.g_varchar2)) or
3461: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3462: nvl(p_postal_code, hr_api.g_varchar2)) or
3463: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3464: nvl(p_town_or_city, hr_api.g_varchar2))) or
3465: (NOT l_api_updating)) then
3466: --
3467: hr_utility.set_location(l_proc, 20);

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

3460: nvl(p_region_1, hr_api.g_varchar2)) or
3461: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3462: nvl(p_postal_code, hr_api.g_varchar2)) or
3463: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3464: nvl(p_town_or_city, hr_api.g_varchar2))) or
3465: (NOT l_api_updating)) then
3466: --
3467: hr_utility.set_location(l_proc, 20);
3468: --

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

3759: (p_address_id => p_address_id
3760: ,p_object_version_number => p_object_version_number);
3761: --
3762: if ((l_api_updating and
3763: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3764: nvl(p_tax_city, hr_api.g_varchar2)) or
3765: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3766: nvl(p_tax_county, hr_api.g_varchar2)) or
3767: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>

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

3760: ,p_object_version_number => p_object_version_number);
3761: --
3762: if ((l_api_updating and
3763: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3764: nvl(p_tax_city, hr_api.g_varchar2)) or
3765: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3766: nvl(p_tax_county, hr_api.g_varchar2)) or
3767: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3768: nvl(p_tax_zip, hr_api.g_varchar2)) or

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

3761: --
3762: if ((l_api_updating and
3763: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3764: nvl(p_tax_city, hr_api.g_varchar2)) or
3765: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3766: nvl(p_tax_county, hr_api.g_varchar2)) or
3767: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3768: nvl(p_tax_zip, hr_api.g_varchar2)) or
3769: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>

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

3762: if ((l_api_updating and
3763: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3764: nvl(p_tax_city, hr_api.g_varchar2)) or
3765: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3766: nvl(p_tax_county, hr_api.g_varchar2)) or
3767: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3768: nvl(p_tax_zip, hr_api.g_varchar2)) or
3769: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3770: nvl(p_tax_city, hr_api.g_varchar2))) or

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

3763: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3764: nvl(p_tax_city, hr_api.g_varchar2)) or
3765: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3766: nvl(p_tax_county, hr_api.g_varchar2)) or
3767: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3768: nvl(p_tax_zip, hr_api.g_varchar2)) or
3769: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3770: nvl(p_tax_city, hr_api.g_varchar2))) or
3771: (NOT l_api_updating)) then

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

3764: nvl(p_tax_city, hr_api.g_varchar2)) or
3765: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3766: nvl(p_tax_county, hr_api.g_varchar2)) or
3767: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3768: nvl(p_tax_zip, hr_api.g_varchar2)) or
3769: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3770: nvl(p_tax_city, hr_api.g_varchar2))) or
3771: (NOT l_api_updating)) then
3772: --

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

3765: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3766: nvl(p_tax_county, hr_api.g_varchar2)) or
3767: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3768: nvl(p_tax_zip, hr_api.g_varchar2)) or
3769: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3770: nvl(p_tax_city, hr_api.g_varchar2))) or
3771: (NOT l_api_updating)) then
3772: --
3773: hr_utility.set_location(l_proc, 20);

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

3766: nvl(p_tax_county, hr_api.g_varchar2)) or
3767: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3768: nvl(p_tax_zip, hr_api.g_varchar2)) or
3769: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3770: nvl(p_tax_city, hr_api.g_varchar2))) or
3771: (NOT l_api_updating)) then
3772: --
3773: hr_utility.set_location(l_proc, 20);
3774: --

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

4001: and pa2.person_id = per_add_shd.g_old_rec.person_id
4002: and pa2.primary_flag = 'Y');
4003: --
4004: begin
4005: l_date := nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot);
4006: hr_utility.set_location('Entering:'|| l_proc, 1);
4007: --
4008: -- For primary addresses only
4009: -- ==========================

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

4093: --
4094: -- start of commenting the code for business_group_id and person_id
4095: -- are updateable if currently null
4096: /*
4097: if nvl(p_rec.business_group_id, hr_api.g_number) <>
4098: per_add_shd.g_old_rec.business_group_id then
4099: hr_api.argument_changed_error
4100: (p_api_name => l_proc
4101: ,p_argument => 'BUSINESS_GROUP_ID'

Line 4099: hr_api.argument_changed_error

4095: -- are updateable if currently null
4096: /*
4097: if nvl(p_rec.business_group_id, hr_api.g_number) <>
4098: per_add_shd.g_old_rec.business_group_id then
4099: hr_api.argument_changed_error
4100: (p_api_name => l_proc
4101: ,p_argument => 'BUSINESS_GROUP_ID'
4102: ,p_base_table => per_add_shd.g_tab_nam
4103: );

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

4103: );
4104: end if;
4105: hr_utility.set_location(l_proc, 7);
4106: --
4107: if nvl(p_rec.person_id, hr_api.g_number) <>
4108: per_add_shd.g_old_rec.person_id then
4109: hr_api.argument_changed_error
4110: (p_api_name => l_proc
4111: ,p_argument => 'PERSON_ID'

Line 4109: hr_api.argument_changed_error

4105: hr_utility.set_location(l_proc, 7);
4106: --
4107: if nvl(p_rec.person_id, hr_api.g_number) <>
4108: per_add_shd.g_old_rec.person_id then
4109: hr_api.argument_changed_error
4110: (p_api_name => l_proc
4111: ,p_argument => 'PERSON_ID'
4112: ,p_base_table => per_add_shd.g_tab_nam
4113: );

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

4117: --
4118: hr_utility.set_location(l_proc, 8);
4119: --
4120: if not g_called_from_form then
4121: if nvl(p_rec.primary_flag, hr_api.g_varchar2) <>
4122: per_add_shd.g_old_rec.primary_flag then
4123: hr_api.argument_changed_error
4124: (p_api_name => l_proc
4125: ,p_argument => 'PRIMARY_FLAG'

Line 4123: hr_api.argument_changed_error

4119: --
4120: if not g_called_from_form then
4121: if nvl(p_rec.primary_flag, hr_api.g_varchar2) <>
4122: per_add_shd.g_old_rec.primary_flag then
4123: hr_api.argument_changed_error
4124: (p_api_name => l_proc
4125: ,p_argument => 'PRIMARY_FLAG'
4126: ,p_base_table => per_add_shd.g_tab_nam
4127: );

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

4148: -- value has changed
4149: --
4150: if (p_rec.address_id is null)
4151: or ((p_rec.address_id is not null)
4152: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4153: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4154: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4155: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4156: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)

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

4149: --
4150: if (p_rec.address_id is null)
4151: or ((p_rec.address_id is not null)
4152: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4153: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4154: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4155: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4156: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4157: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)

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

4150: if (p_rec.address_id is null)
4151: or ((p_rec.address_id is not null)
4152: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4153: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4154: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4155: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4156: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4157: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4158: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)

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

4151: or ((p_rec.address_id is not null)
4152: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4153: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4154: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4155: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4156: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4157: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4158: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4159: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)

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

4152: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4153: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4154: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4155: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4156: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4157: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4158: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4159: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4160: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)

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

4153: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4154: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4155: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4156: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4157: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4158: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4159: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4160: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4161: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)

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

4154: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4155: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4156: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4157: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4158: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4159: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4160: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4161: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4162: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)

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

4155: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4156: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4157: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4158: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4159: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4160: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4161: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4162: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4163: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)

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

4156: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4157: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4158: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4159: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4160: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4161: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4162: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4163: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4164: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)

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

4157: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4158: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4159: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4160: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4161: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4162: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4163: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4164: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4165: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)

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

4158: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4159: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4160: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4161: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4162: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4163: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4164: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4165: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4166: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)

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

4159: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4160: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4161: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4162: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4163: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4164: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4165: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4166: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4167: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)

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

4160: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4161: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4162: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4163: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4164: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4165: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4166: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4167: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4168: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)

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

4161: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4162: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4163: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4164: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4165: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4166: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4167: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4168: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4169: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)

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

4162: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4163: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4164: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4165: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4166: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4167: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4168: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4169: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4170: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)

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

4163: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4164: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4165: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4166: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4167: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4168: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4169: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4170: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4171: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)

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

4164: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4165: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4166: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4167: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4168: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4169: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4170: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4171: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4172: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)

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

4165: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4166: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4167: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4168: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4169: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4170: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4171: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4172: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4173: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)

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

4166: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4167: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4168: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4169: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4170: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4171: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4172: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4173: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4174: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)

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

4167: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4168: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4169: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4170: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4171: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4172: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4173: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4174: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4175: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)

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

4168: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4169: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4170: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4171: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4172: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4173: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4174: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4175: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4176: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)

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

4169: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4170: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4171: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4172: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4173: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4174: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4175: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4176: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4177: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)

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

4170: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4171: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4172: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4173: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4174: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4175: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4176: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4177: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4178: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)

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

4171: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4172: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4173: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4174: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4175: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4176: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4177: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4178: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4179: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)

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

4172: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4173: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4174: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4175: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4176: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4177: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4178: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4179: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4180: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)

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

4173: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4174: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4175: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4176: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4177: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4178: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4179: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4180: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4181: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)

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

4174: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4175: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4176: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4177: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4178: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4179: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4180: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4181: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4182: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)

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

4175: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4176: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4177: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4178: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4179: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4180: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4181: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4182: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4183: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)

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

4176: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4177: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4178: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4179: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4180: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4181: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4182: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4183: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4184: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)

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

4177: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4178: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4179: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4180: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4181: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4182: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4183: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4184: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4185: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)

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

4178: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4179: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4180: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4181: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4182: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4183: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4184: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4185: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4186: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)

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

4179: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4180: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4181: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4182: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4183: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4184: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4185: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4186: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4187: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)

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

4180: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4181: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4182: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4183: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4184: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4185: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4186: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4187: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4188: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)

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

4181: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4182: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4183: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4184: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4185: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4186: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4187: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4188: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4189: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)

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

4182: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4183: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4184: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4185: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4186: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4187: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4188: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4189: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4190: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)

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

4183: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4184: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4185: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4186: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4187: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4188: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4189: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4190: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4191: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)

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

4184: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4185: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4186: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4187: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4188: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4189: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4190: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4191: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4192: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)

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

4185: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4186: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4187: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4188: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4189: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4190: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4191: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4192: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4193: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)

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

4186: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4187: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4188: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4189: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4190: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4191: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4192: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4193: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4194: )

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

4187: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4188: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4189: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4190: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4191: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4192: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4193: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4194: )
4195: )

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

4188: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4189: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4190: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4191: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4192: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4193: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4194: )
4195: )
4196: then

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

4189: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4190: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4191: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4192: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4193: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4194: )
4195: )
4196: then
4197: --

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

4263: -- value has changed
4264: --
4265: if (p_rec.address_id is null)
4266: or ((p_rec.address_id is not null)
4267: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4268: <> nvl(p_rec.style, hr_api.g_varchar2)
4269: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4270: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4271: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)

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

4264: --
4265: if (p_rec.address_id is null)
4266: or ((p_rec.address_id is not null)
4267: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4268: <> nvl(p_rec.style, hr_api.g_varchar2)
4269: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4270: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4271: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4272: <> nvl(p_rec.address_line2, hr_api.g_varchar2)

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

4265: if (p_rec.address_id is null)
4266: or ((p_rec.address_id is not null)
4267: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4268: <> nvl(p_rec.style, hr_api.g_varchar2)
4269: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4270: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4271: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4272: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4273: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)

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

4266: or ((p_rec.address_id is not null)
4267: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4268: <> nvl(p_rec.style, hr_api.g_varchar2)
4269: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4270: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4271: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4272: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4273: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4274: <> nvl(p_rec.address_line3, hr_api.g_varchar2)

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

4267: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4268: <> nvl(p_rec.style, hr_api.g_varchar2)
4269: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4270: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4271: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4272: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4273: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4274: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4275: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)

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

4268: <> nvl(p_rec.style, hr_api.g_varchar2)
4269: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4270: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4271: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4272: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4273: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4274: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4275: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4276: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)

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

4269: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4270: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4271: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4272: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4273: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4274: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4275: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4276: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4277: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)

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

4270: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4271: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4272: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4273: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4274: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4275: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4276: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4277: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4278: <> nvl(p_rec.region_1, hr_api.g_varchar2)

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

4271: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4272: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4273: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4274: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4275: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4276: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4277: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4278: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4279: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)

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

4272: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4273: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4274: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4275: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4276: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4277: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4278: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4279: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4280: <> nvl(p_rec.region_2, hr_api.g_varchar2)

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

4273: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4274: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4275: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4276: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4277: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4278: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4279: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4280: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4281: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)

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

4274: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4275: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4276: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4277: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4278: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4279: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4280: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4281: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4282: <> nvl(p_rec.region_3, hr_api.g_varchar2)

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

4275: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4276: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4277: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4278: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4279: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4280: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4281: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4282: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4283: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)

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

4276: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4277: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4278: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4279: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4280: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4281: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4282: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4283: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4284: <> nvl(p_rec.postal_code, hr_api.g_varchar2)

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

4277: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4278: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4279: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4280: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4281: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4282: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4283: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4284: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4285: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)

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

4278: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4279: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4280: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4281: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4282: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4283: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4284: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4285: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4286: <> nvl(p_rec.country, hr_api.g_varchar2)

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

4279: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4280: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4281: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4282: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4283: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4284: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4285: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4286: <> nvl(p_rec.country, hr_api.g_varchar2)
4287: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)

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

4280: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4281: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4282: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4283: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4284: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4285: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4286: <> nvl(p_rec.country, hr_api.g_varchar2)
4287: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4288: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)

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

4281: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4282: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4283: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4284: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4285: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4286: <> nvl(p_rec.country, hr_api.g_varchar2)
4287: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4288: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4289: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)

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

4282: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4283: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4284: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4285: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4286: <> nvl(p_rec.country, hr_api.g_varchar2)
4287: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4288: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4289: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4290: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)

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

4283: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4284: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4285: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4286: <> nvl(p_rec.country, hr_api.g_varchar2)
4287: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4288: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4289: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4290: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4291: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)

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

4284: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4285: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4286: <> nvl(p_rec.country, hr_api.g_varchar2)
4287: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4288: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4289: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4290: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4291: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4292: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)

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

4285: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4286: <> nvl(p_rec.country, hr_api.g_varchar2)
4287: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4288: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4289: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4290: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4291: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4292: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4293: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)

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

4286: <> nvl(p_rec.country, hr_api.g_varchar2)
4287: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4288: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4289: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4290: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4291: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4292: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4293: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4294: <> nvl(p_rec.add_information13, hr_api.g_varchar2)

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

4287: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4288: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4289: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4290: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4291: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4292: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4293: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4294: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4295: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)

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

4288: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4289: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4290: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4291: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4292: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4293: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4294: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4295: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4296: <> nvl(p_rec.add_information14, hr_api.g_varchar2)

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

4289: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4290: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4291: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4292: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4293: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4294: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4295: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4296: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4297: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)

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

4290: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4291: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4292: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4293: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4294: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4295: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4296: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4297: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4298: <> nvl(p_rec.add_information15, hr_api.g_varchar2)

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

4291: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4292: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4293: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4294: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4295: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4296: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4297: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4298: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4299: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)

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

4292: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4293: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4294: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4295: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4296: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4297: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4298: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4299: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4300: <> nvl(p_rec.add_information16, hr_api.g_varchar2)

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

4293: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4294: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4295: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4296: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4297: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4298: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4299: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4300: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4301: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019

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

4294: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4295: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4296: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4297: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4298: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4299: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4300: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4301: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4302: <> nvl(p_rec.add_information17, hr_api.g_varchar2)

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

4295: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4296: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4297: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4298: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4299: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4300: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4301: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4302: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4303: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)

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

4296: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4297: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4298: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4299: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4300: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4301: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4302: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4303: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4304: <> nvl(p_rec.add_information18, hr_api.g_varchar2)

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

4297: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4298: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4299: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4300: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4301: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4302: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4303: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4304: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4305: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)

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

4298: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4299: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4300: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4301: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4302: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4303: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4304: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4305: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4306: <> nvl(p_rec.add_information19, hr_api.g_varchar2)

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

4299: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4300: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4301: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4302: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4303: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4304: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4305: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4306: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4307: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)

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

4300: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4301: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4302: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4303: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4304: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4305: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4306: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4307: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4308: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019

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

4301: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4302: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4303: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4304: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4305: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4306: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4307: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4308: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019
4309: )

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

4302: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4303: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4304: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4305: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4306: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4307: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4308: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019
4309: )
4310: )

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

4303: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4304: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4305: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4306: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4307: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4308: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019
4309: )
4310: )
4311: then

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

4304: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4305: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4306: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4307: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4308: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019
4309: )
4310: )
4311: then
4312: --

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

4397: --
4398: begin
4399: hr_utility.set_location('Entering:'||l_proc, 10);
4400: --
4401: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4402: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4403: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4404: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4405: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>

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

4398: begin
4399: hr_utility.set_location('Entering:'||l_proc, 10);
4400: --
4401: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4402: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4403: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4404: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4405: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4406: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or

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

4399: hr_utility.set_location('Entering:'||l_proc, 10);
4400: --
4401: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4402: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4403: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4404: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4405: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4406: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4407: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>

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

4400: --
4401: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4402: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4403: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4404: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4405: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4406: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4407: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4408: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or

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

4401: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4402: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4403: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4404: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4405: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4406: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4407: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4408: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4409: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>

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

4402: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4403: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4404: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4405: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4406: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4407: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4408: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4409: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4410: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or

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

4403: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4404: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4405: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4406: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4407: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4408: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4409: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4410: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4411: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>

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

4404: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4405: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4406: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4407: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4408: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4409: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4410: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4411: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4412: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or

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

4405: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4406: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4407: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4408: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4409: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4410: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4411: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4412: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4413: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>

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

4406: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4407: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4408: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4409: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4410: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4411: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4412: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4413: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4414: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or

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

4407: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4408: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4409: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4410: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4411: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4412: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4413: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4414: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4415: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>

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

4408: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4409: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4410: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4411: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4412: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4413: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4414: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4415: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4416: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or

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

4409: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4410: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4411: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4412: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4413: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4414: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4415: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4416: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4417: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>

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

4410: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4411: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4412: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4413: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4414: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4415: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4416: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4417: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4418: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or

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

4411: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4412: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4413: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4414: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4415: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4416: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4417: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4418: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4419: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>

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

4412: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4413: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4414: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4415: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4416: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4417: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4418: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4419: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4420: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or

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

4413: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4414: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4415: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4416: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4417: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4418: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4419: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4420: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4421: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>

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

4414: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4415: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4416: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4417: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4418: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4419: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4420: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4421: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4422: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or

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

4415: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4416: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4417: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4418: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4419: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4420: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4421: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4422: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4423: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>

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

4416: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4417: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4418: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4419: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4420: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4421: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4422: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4423: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4424: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or

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

4417: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4418: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4419: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4420: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4421: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4422: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4423: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4424: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4425: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>

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

4418: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4419: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4420: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4421: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4422: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4423: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4424: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4425: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4426: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or

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

4419: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4420: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4421: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4422: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4423: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4424: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4425: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4426: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4427: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>

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

4420: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4421: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4422: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4423: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4424: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4425: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4426: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4427: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4428: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or

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

4421: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4422: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4423: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4424: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4425: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4426: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4427: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4428: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4429: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>

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

4422: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4423: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4424: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4425: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4426: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4427: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4428: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4429: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4430: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or

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

4423: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4424: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4425: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4426: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4427: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4428: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4429: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4430: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4431: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>

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

4424: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4425: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4426: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4427: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4428: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4429: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4430: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4431: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4432: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or

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

4425: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4426: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4427: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4428: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4429: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4430: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4431: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4432: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4433: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>

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

4426: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4427: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4428: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4429: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4430: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4431: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4432: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4433: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4434: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or

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

4427: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4428: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4429: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4430: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4431: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4432: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4433: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4434: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4435: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>

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

4428: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4429: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4430: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4431: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4432: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4433: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4434: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4435: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4436: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or

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

4429: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4430: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4431: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4432: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4433: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4434: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4435: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4436: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4437: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>

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

4430: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4431: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4432: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4433: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4434: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4435: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4436: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4437: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4438: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or

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

4431: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4432: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4433: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4434: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4435: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4436: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4437: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4438: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4439: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>

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

4432: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4433: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4434: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4435: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4436: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4437: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4438: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4439: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4440: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or

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

4433: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4434: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4435: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4436: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4437: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4438: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4439: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4440: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4441: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>

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

4434: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4435: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4436: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4437: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4438: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4439: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4440: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4441: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4442: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or

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

4435: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4436: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4437: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4438: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4439: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4440: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4441: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4442: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4443: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>

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

4436: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4437: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4438: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4439: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4440: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4441: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4442: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4443: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4444: nvl(p_rec.add_information13, hr_api.g_varchar2) or

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

4437: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4438: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4439: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4440: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4441: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4442: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4443: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4444: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4445: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>

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

4438: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4439: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4440: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4441: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4442: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4443: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4444: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4445: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4446: nvl(p_rec.add_information14, hr_api.g_varchar2) or

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

4439: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4440: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4441: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4442: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4443: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4444: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4445: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4446: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4447: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>

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

4440: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4441: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4442: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4443: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4444: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4445: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4446: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4447: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4448: nvl(p_rec.add_information15, hr_api.g_varchar2) or

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

4441: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4442: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4443: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4444: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4445: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4446: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4447: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4448: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4449: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>

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

4442: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4443: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4444: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4445: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4446: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4447: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4448: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4449: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4450: nvl(p_rec.add_information16, hr_api.g_varchar2) or

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

4443: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4444: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4445: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4446: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4447: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4448: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4449: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4450: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4451: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>

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

4444: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4445: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4446: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4447: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4448: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4449: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4450: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4451: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4452: nvl(p_rec.add_information17, hr_api.g_varchar2) or

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

4445: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4446: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4447: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4448: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4449: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4450: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4451: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4452: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4453: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>

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

4446: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4447: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4448: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4449: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4450: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4451: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4452: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4453: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4454: nvl(p_rec.add_information18, hr_api.g_varchar2) or

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

4447: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4448: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4449: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4450: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4451: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4452: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4453: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4454: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4455: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>

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

4448: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4449: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4450: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4451: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4452: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4453: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4454: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4455: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4456: nvl(p_rec.add_information19, hr_api.g_varchar2) or

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

4449: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4450: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4451: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4452: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4453: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4454: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4455: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4456: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4457: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>

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

4450: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4451: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4452: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4453: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4454: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4455: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4456: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4457: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4458: nvl(p_rec.add_information20, hr_api.g_varchar2) or

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

4451: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4452: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4453: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4454: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4455: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4456: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4457: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4458: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4459: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge

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

4452: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4453: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4454: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4455: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4456: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4457: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4458: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4459: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4460: nvl(p_rec.party_id, hr_api.g_number)

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

4453: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4454: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4455: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4456: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4457: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4458: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4459: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4460: nvl(p_rec.party_id, hr_api.g_number)
4461: then

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

4454: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4455: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4456: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4457: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4458: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4459: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4460: nvl(p_rec.party_id, hr_api.g_number)
4461: then
4462: -- either the attribute_category or attribute1..30 have changed

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

4455: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4456: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4457: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4458: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4459: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4460: nvl(p_rec.party_id, hr_api.g_number)
4461: then
4462: -- either the attribute_category or attribute1..30 have changed
4463: -- so we must call the flex stub

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

4456: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4457: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4458: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4459: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4460: nvl(p_rec.party_id, hr_api.g_number)
4461: then
4462: -- either the attribute_category or attribute1..30 have changed
4463: -- so we must call the flex stub
4464: per_add_flex.df(p_rec => p_rec);

Line 4500: hr_api.validate_bus_grp_id(

4496: if p_rec.person_id is not null then
4497: --
4498: -- Validate business group id
4499: --
4500: hr_api.validate_bus_grp_id(
4501: p_business_group_id => p_rec.business_group_id
4502: ,p_associated_column1 => per_add_shd.g_tab_nam ||
4503: '.BUSINESS_GROUP_ID'
4504: );

Line 4885: hr_api.validate_bus_grp_id(

4881: if p_rec.person_id is not null then
4882: --
4883: -- Validate business group id
4884: --
4885: hr_api.validate_bus_grp_id(
4886: p_business_group_id => p_rec.business_group_id
4887: ,p_associated_column1 => per_add_shd.g_tab_nam ||
4888: '.BUSINESS_GROUP_ID'
4889: );

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

5268: hr_utility.set_location('Entering:'|| l_proc, 10);
5269: --
5270: -- Ensure that all the mandatory parameter are not null
5271: --
5272: hr_api.mandatory_arg_error(p_api_name => l_proc,
5273: p_argument => 'address_id',
5274: p_argument_value => p_address_id);
5275: --
5276: if nvl(g_address_id, hr_api.g_number) = p_address_id then

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

5272: hr_api.mandatory_arg_error(p_api_name => l_proc,
5273: p_argument => 'address_id',
5274: p_argument_value => p_address_id);
5275: --
5276: if nvl(g_address_id, hr_api.g_number) = p_address_id then
5277: --
5278: -- The legislation has already been found with a previous
5279: -- call to this function. Just return the value in the global
5280: -- variable.