[Home] [Help]
89: end if;
90: --
91: end if;
92: --
93: l_api_updating := per_add_shd.api_updating
94: (p_address_id => p_address_id
95: ,p_object_version_number => p_object_version_number );
96: --
97: --UPDATE not allowed unless currently null(U)
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;
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;
105: --
184: hr_utility.set_location(l_proc, 20);
185: --
186: -- Check if inserting or updating with modified values
187: --
188: l_api_updating := per_add_shd.api_updating
189: (p_address_id => p_address_id
190: ,p_object_version_number => p_object_version_number
191: );
192: --
189: (p_address_id => p_address_id
190: ,p_object_version_number => p_object_version_number
191: );
192: --
193: if ((l_api_updating and per_add_shd.g_old_rec.person_id <> p_person_id)
194: or
195: (NOT l_api_updating))
196: then
197: hr_utility.set_location(l_proc, 30);
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');
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');
237: hr_utility.raise_error;
285: --
286: -- {End Of Comments}
287: -- ----------------------------------------------------------------------------
288: procedure chk_party_id
289: (p_rec in out nocopy per_add_shd.g_rec_type
290: )
291: is
292: --
293: l_proc varchar2(72) := g_package||'chk_party_id';
421: hr_utility.set_location(l_proc, 20);
422: --
423: -- Check if inserting or updating with modified values
424: --
425: l_api_updating := per_add_shd.api_updating
426: (p_address_id => p_address_id
427: ,p_object_version_number => p_object_version_number
428: );
429: --
426: (p_address_id => p_address_id
427: ,p_object_version_number => p_object_version_number
428: );
429: --
430: if ((l_api_updating and per_add_shd.g_old_rec.primary_flag <> p_primary_flag)
431: or
432: (NOT l_api_updating))
433: then
434: hr_utility.set_location(l_proc, 30);
436: -- Check that the value is 'Y' or 'N'
437: --
438: if p_primary_flag not in('Y','N') then
439: --
440: per_add_shd.constraint_error
441: (p_constraint_name => 'PER_ADDR_PRIMARY_FLAG_CHK'
442: );
443: --
444: end if;
511: -- Only proceed with validation if :
512: -- a) The current g_old_rec is current and
513: -- b) The value for address type has changed
514: --
515: l_api_updating := per_add_shd.api_updating
516: (p_address_id => p_address_id
517: ,p_object_version_number => p_object_version_number);
518: --
519: if ((l_api_updating and
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: --
608: -- Only proceed with validation if :
609: -- a) The current g_old_rec is current and
610: -- b) The value for country has changed
611: --
612: l_api_updating := per_add_shd.api_updating
613: (p_address_id => p_address_id
614: ,p_object_version_number => p_object_version_number);
615: --
616: if ((l_api_updating and
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: --
712: -- Only proceed with validation if :
713: -- a) The current g_old_rec is current and
714: -- b) The value for date to has changed
715: --
716: l_api_updating := per_add_shd.api_updating
717: (p_address_id => p_address_id
718: ,p_object_version_number => p_object_version_number);
719: --
720: if ((l_api_updating and
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);
803: -- Only proceed with validation if :
804: -- a) The current g_old_rec is current and
805: -- b) The date_from value has changed
806: --
807: l_api_updating := per_add_shd.api_updating
808: (p_address_id => p_address_id
809: ,p_object_version_number => p_object_version_number);
810: --
811: if ((l_api_updating and per_add_shd.g_old_rec.date_from <> p_date_from) or
807: l_api_updating := per_add_shd.api_updating
808: (p_address_id => p_address_id
809: ,p_object_version_number => p_object_version_number);
810: --
811: if ((l_api_updating and per_add_shd.g_old_rec.date_from <> p_date_from) or
812: (NOT l_api_updating)) then
813: hr_utility.set_location(l_proc, 2);
814: --
815: -- Check that the date_from values is less than
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
1077: --
1078: l_api_updating := per_add_shd.api_updating
1079: (p_address_id => p_address_id
1080: ,p_object_version_number => p_object_version_number
1081: );
1082: --
1080: ,p_object_version_number => p_object_version_number
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))
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
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
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
1226: -- for a Primary address that no Non-primary
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;
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;
1480: elsif p_style = 'US' then
1481: --
1482: -- Check if region 3 is set but is unchanged on update
1483: --
1484: l_api_updating := per_add_shd.api_updating
1485: (p_address_id => p_address_id
1486: ,p_object_version_number => p_object_version_number
1487: );
1488: --
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;
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;
1532: hr_utility.set_message(801, 'HR_7324_ADD_ADD_ATTRIBUTE_NULL');
1533: hr_utility.set_message_token('ARGUMENT', l_token);
1534: hr_multi_message.add(
1535: p_associated_column1 =>
1536: (per_add_shd.g_tab_nam || '.' || upper(l_token))
1537: );
1538: when others then
1539: raise;
1540: --
1595: -- Only proceed with validation if :
1596: -- a) The current g_old_rec is current and
1597: -- b) The value for address_line1 has changed
1598: --
1599: l_api_updating := per_add_shd.api_updating
1600: (p_address_id => p_address_id
1601: ,p_object_version_number => p_object_version_number);
1602: --
1603: if ((l_api_updating and
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: --
1680: -- Only proceed with validation if :
1681: -- a) The current g_old_rec is current and
1682: -- b) The value for town_or_city, address_line1, or region_1 have changed
1683: --
1684: l_api_updating := per_add_shd.api_updating
1685: (p_address_id => p_address_id
1686: ,p_object_version_number => p_object_version_number);
1687:
1688: if ( (l_legislation_code = 'JP')
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) <>
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
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
1865: -- Only proceed with validation if :
1866: -- a) The current g_old_rec is current and
1867: -- b) The value for address_line2, or region_2 have changed
1868: --
1869: l_api_updating := per_add_shd.api_updating
1870: (p_address_id => p_address_id
1871: ,p_object_version_number => p_object_version_number);
1872:
1873: if ((l_api_updating and
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
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);
1926: -- Only proceed with validation if :
1927: -- a) The current g_old_rec is current and
1928: -- b) The value for address_line3, or region_3 have changed
1929: --
1930: l_api_updating := per_add_shd.api_updating
1931: (p_address_id => p_address_id
1932: ,p_object_version_number => p_object_version_number);
1933:
1934: if ((l_api_updating and
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
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);
2113: -- Only proceed with validation if :
2114: -- a) The current g_old_rec is current and
2115: -- b) The value for postal code has changed
2116: --
2117: l_api_updating := per_add_shd.api_updating
2118: (p_address_id => p_address_id
2119: ,p_object_version_number => p_object_version_number);
2120: --
2121: if ((l_api_updating
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);
2418: -- Only proceed with validation if :
2419: -- a) The current g_old_rec is current and
2420: -- b) The value for add_information20 has changed
2421: --
2422: l_api_updating := per_add_shd.api_updating
2423: (p_address_id => p_address_id
2424: ,p_object_version_number => p_object_version_number);
2425: --
2426: if ((l_api_updating
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);
2602: -- Only proceed with validation if :
2603: -- a) The current g_old_rec is current and
2604: -- b) The value for region_1 has changed
2605: --
2606: l_api_updating := per_add_shd.api_updating
2607: (p_address_id => p_address_id
2608: ,p_object_version_number => p_object_version_number);
2609: --
2610: if ((l_api_updating and
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);
2756: -- Only proceed with validation if :
2757: -- a) The current g_old_rec is current and
2758: -- b) The value for tax_county has changed
2759: --
2760: l_api_updating := per_add_shd.api_updating
2761: (p_address_id => p_address_id
2762: ,p_object_version_number => p_object_version_number);
2763: --
2764: if ((l_api_updating and
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);
2881: -- Only proceed with validation if :
2882: -- a) The current g_old_rec is current and
2883: -- b) The value for region_2 has changed
2884: --
2885: l_api_updating := per_add_shd.api_updating
2886: (p_address_id => p_address_id
2887: ,p_object_version_number => p_object_version_number
2888: );
2889: --
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);
3043: -- Only proceed with validation if :
3044: -- a) The current g_old_rec is current and
3045: -- b) The value for tax_state (add_information17) has changed
3046: --
3047: l_api_updating := per_add_shd.api_updating
3048: (p_address_id => p_address_id
3049: ,p_object_version_number => p_object_version_number
3050: );
3051: --
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);
3172: -- Only proceed with validation if :
3173: -- a) The current g_old_rec is current and
3174: -- b) The value for town_or_city has changed
3175: --
3176: l_api_updating := per_add_shd.api_updating
3177: (p_address_id => p_address_id
3178: ,p_object_version_number => p_object_version_number);
3179: --
3180: if ((l_api_updating and
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);
3289: -- Only proceed with validation if :
3290: -- a) The current g_old_rec is current and
3291: -- b) The value for tax_city has changed
3292: --
3293: l_api_updating := per_add_shd.api_updating
3294: (p_address_id => p_address_id
3295: ,p_object_version_number => p_object_version_number);
3296: --
3297: if ((l_api_updating and
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);
3448: -- a) US address style and payroll is installed under US legislation and
3449: -- b) The current g_old_rec is current and
3450: -- c) The value for postal_code/region_2/town_or_city has changed.
3451: --
3452: l_api_updating := per_add_shd.api_updating
3453: (p_address_id => p_address_id
3454: ,p_object_version_number => p_object_version_number);
3455: --
3456: if ((l_api_updating and
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) <>
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) <>
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
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);
3754: -- b) The current g_old_rec is current and
3755: -- c) The value for tax_zip (add_information20)/tax_state(add_information17)
3756: -- /tax_city(add_information18) has changed.
3757: --
3758: l_api_updating := per_add_shd.api_updating
3759: (p_address_id => p_address_id
3760: ,p_object_version_number => p_object_version_number);
3761: --
3762: if ((l_api_updating and
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) <>
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) <>
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
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);
3986: --
3987: cursor csr_del_address is
3988: select null
3989: from per_addresses pa
3990: where pa.date_from between per_add_shd.g_old_rec.date_from
3991: and l_date
3992: and pa.person_id = per_add_shd.g_old_rec.person_id
3993: and pa.primary_flag = 'N';
3994: --
3988: select null
3989: from per_addresses pa
3990: where pa.date_from between per_add_shd.g_old_rec.date_from
3991: and l_date
3992: and pa.person_id = per_add_shd.g_old_rec.person_id
3993: and pa.primary_flag = 'N';
3994: --
3995: cursor csr_no_del_contig_add is
3996: select null
3997: from sys.dual
3998: where exists(select null
3999: from per_addresses pa2
4000: where pa2.date_from > l_date
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);
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: -- ==========================
4007: --
4008: -- For primary addresses only
4009: -- ==========================
4010: --
4011: if per_add_shd.g_old_rec.primary_flag = 'Y' then
4012: --
4013: -- Check that no non primary addresses
4014: -- exist within the date range of the
4015: -- currently selected primary address.
4070: -- (business_group_id, person_id, address_id, primary_flag or style)
4071: -- have been altered.
4072: --
4073: -- {End Of Comments}
4074: Procedure check_non_updateable_args(p_rec in per_add_shd.g_rec_type) is
4075: --
4076: l_proc varchar2(72) := g_package||'check_non_updateable_args';
4077: --
4078: Begin
4080: --
4081: -- Only proceed with validation if a row exists for
4082: -- the current record in the HR Schema
4083: --
4084: if not per_add_shd.api_updating
4085: (p_address_id => p_rec.address_id,
4086: p_object_version_number => p_rec.object_version_number) then
4087: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
4088: hr_utility.set_message_token('PROCEDURE', l_proc);
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'
4102: ,p_base_table => per_add_shd.g_tab_nam
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: );
4104: end if;
4105: hr_utility.set_location(l_proc, 7);
4106: --
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'
4112: ,p_base_table => per_add_shd.g_tab_nam
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: );
4114: end if;
4115: */
4116: -- end of commenting code
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'
4126: ,p_base_table => per_add_shd.g_tab_nam
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: );
4128: end if;
4129: end if;
4130: hr_utility.set_location(l_proc, 11);
4136: -- |--------------------------------< chk_df >---------------------------------|
4137: -- -----------------------------------------------------------------------------
4138: --
4139: procedure chk_df
4140: (p_rec in per_add_shd.g_rec_type) is
4141: --
4142: l_proc varchar2(72) := g_package||'chk_df';
4143: --
4144: Begin
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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: )
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
4250: -- |-------------------------------< chk_ddf >---------------------------------|
4251: -- -----------------------------------------------------------------------------
4252: --
4253: procedure chk_ddf
4254: (p_rec in per_add_shd.g_rec_type) is
4255: --
4256: l_proc varchar2(72) := g_package||'chk_ddf';
4257: l_error exception;
4258: --
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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
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)
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)
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)
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: )
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
4390: -- Access Status:
4391: -- Internal Table Handler Use Only.
4392: -- ---------------------------------------------------------------------------
4393: procedure df_update_validate
4394: (p_rec in per_add_shd.g_rec_type) is
4395: --
4396: l_proc varchar2(72) := g_package||'df_update_validate';
4397: --
4398: begin
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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
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
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
4470: -- ----------------------------------------------------------------------------
4471: -- |---------------------------< insert_validate >----------------------------|
4472: -- ----------------------------------------------------------------------------
4473: Procedure insert_validate
4474: (p_rec in out nocopy per_add_shd.g_rec_type
4475: ,p_effective_date in date
4476: ,p_validate_county in boolean default true
4477: ) is
4478: --
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: );
4505: hr_utility.set_location(l_proc, 20);
4506: --
4848: -- ----------------------------------------------------------------------------
4849: -- |---------------------------< update_validate >----------------------------|
4850: -- ----------------------------------------------------------------------------
4851: Procedure update_validate
4852: (p_rec in out nocopy per_add_shd.g_rec_type
4853: ,p_effective_date in date
4854: ,p_prflagval_override in boolean default false
4855: ,p_validate_county in boolean default true
4856: ) is
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: );
4890: hr_utility.set_location(l_proc, 20);
4891: --
5222: --
5223: -- ----------------------------------------------------------------------------
5224: -- |---------------------------< delete_validate >----------------------------|
5225: -- ----------------------------------------------------------------------------
5226: Procedure delete_validate(p_rec in out nocopy per_add_shd.g_rec_type) is
5227: --
5228: l_proc varchar2(72) := g_package||'delete_validate';
5229: --
5230: Begin