[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
1082: -- Only proceed with validation if :
1083: -- a) The current g_old_rec is current and
1084: -- b) The value for date_to/date_from has changed
1085: --
1086: l_api_updating := per_add_shd.api_updating
1087: (p_address_id => p_address_id
1088: ,p_object_version_number => p_object_version_number
1089: );
1090: --
1088: ,p_object_version_number => p_object_version_number
1089: );
1090: --
1091: if ((l_api_updating and
1092: per_add_shd.g_old_rec.date_from <> p_date_from) or
1093: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1094: nvl(p_date_to, hr_api.g_eot)) or
1095: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1096: nvl(p_address_type, hr_api.g_varchar2))
1089: );
1090: --
1091: if ((l_api_updating and
1092: per_add_shd.g_old_rec.date_from <> p_date_from) or
1093: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1094: nvl(p_date_to, hr_api.g_eot)) or
1095: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1096: nvl(p_address_type, hr_api.g_varchar2))
1097: or
1091: if ((l_api_updating and
1092: per_add_shd.g_old_rec.date_from <> p_date_from) or
1093: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1094: nvl(p_date_to, hr_api.g_eot)) or
1095: (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1096: nvl(p_address_type, hr_api.g_varchar2))
1097: or
1098: (NOT l_api_updating))
1099: then
1104: -- Checks that the date_from, date_to values for a given address
1105: -- do not cause an overlap of address_type value between two
1106: -- addresses for the same person within a given date range.
1107: --
1108: if (nvl(per_add_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
1109: nvl(p_address_type, hr_api.g_varchar2)) or
1110: (NOT l_api_updating) then
1111: --
1112: if p_address_type is not null then
1234: -- for a Primary address that no Non-primary
1235: -- address is left without a corresponding
1236: -- primary
1237: --
1238: if ((per_add_shd.g_old_rec.date_from <> p_date_from) or
1239: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1240: (nvl(p_date_to, hr_api.g_eot)))) and
1241: p_address_id is not null then
1242: open csr_invalid_non_prim;
1235: -- address is left without a corresponding
1236: -- primary
1237: --
1238: if ((per_add_shd.g_old_rec.date_from <> p_date_from) or
1239: (nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot) <>
1240: (nvl(p_date_to, hr_api.g_eot)))) and
1241: p_address_id is not null then
1242: open csr_invalid_non_prim;
1243: fetch csr_invalid_non_prim into l_exists;
1500: elsif p_style = 'US' then
1501: --
1502: -- Check if region 3 is set but is unchanged on update
1503: --
1504: l_api_updating := per_add_shd.api_updating
1505: (p_address_id => p_address_id
1506: ,p_object_version_number => p_object_version_number
1507: );
1508: --
1506: ,p_object_version_number => p_object_version_number
1507: );
1508: --
1509: if p_region_3 is not null
1510: and nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
1511: = nvl(p_region_3, hr_api.g_varchar2)
1512: then
1513: --
1514: null;
1522: --
1523: -- Check if telephone number 3 is set but is unchanged on update
1524: --
1525: if p_telephone_number_3 is not null
1526: and nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
1527: = nvl(p_telephone_number_3, hr_api.g_varchar2)
1528: then
1529: --
1530: null;
1552: hr_utility.set_message(801, 'HR_7324_ADD_ADD_ATTRIBUTE_NULL');
1553: hr_utility.set_message_token('ARGUMENT', l_token);
1554: hr_multi_message.add(
1555: p_associated_column1 =>
1556: (per_add_shd.g_tab_nam || '.' || upper(l_token))
1557: );
1558: when others then
1559: raise;
1560: --
1615: -- Only proceed with validation if :
1616: -- a) The current g_old_rec is current and
1617: -- b) The value for address_line1 has changed
1618: --
1619: l_api_updating := per_add_shd.api_updating
1620: (p_address_id => p_address_id
1621: ,p_object_version_number => p_object_version_number);
1622: --
1623: if ((l_api_updating and
1620: (p_address_id => p_address_id
1621: ,p_object_version_number => p_object_version_number);
1622: --
1623: if ((l_api_updating and
1624: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2) <>
1625: nvl(p_address_line1, hr_api.g_varchar2)) or
1626: (NOT l_api_updating)) then
1627: hr_utility.set_location(l_proc, 2);
1628: --
1700: -- Only proceed with validation if :
1701: -- a) The current g_old_rec is current and
1702: -- b) The value for town_or_city, address_line1, or region_1 have changed
1703: --
1704: l_api_updating := per_add_shd.api_updating
1705: (p_address_id => p_address_id
1706: ,p_object_version_number => p_object_version_number);
1707:
1708: if ( (l_legislation_code = 'JP')
1707:
1708: if ( (l_legislation_code = 'JP')
1709: and
1710: ( (l_api_updating and
1711: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1712: nvl(p_town_or_city, hr_api.g_varchar2) or
1713: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1714: nvl(p_address_line1, hr_api.g_varchar2) or
1715: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1709: and
1710: ( (l_api_updating and
1711: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1712: nvl(p_town_or_city, hr_api.g_varchar2) or
1713: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1714: nvl(p_address_line1, hr_api.g_varchar2) or
1715: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1716: nvl(p_region_1, hr_api.g_varchar2)))
1717: or
1711: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1712: nvl(p_town_or_city, hr_api.g_varchar2) or
1713: nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)<>
1714: nvl(p_address_line1, hr_api.g_varchar2) or
1715: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1716: nvl(p_region_1, hr_api.g_varchar2)))
1717: or
1718: (NOT l_api_updating))
1719: ) then
1885: -- Only proceed with validation if :
1886: -- a) The current g_old_rec is current and
1887: -- b) The value for address_line2, or region_2 have changed
1888: --
1889: l_api_updating := per_add_shd.api_updating
1890: (p_address_id => p_address_id
1891: ,p_object_version_number => p_object_version_number);
1892:
1893: if ((l_api_updating and
1890: (p_address_id => p_address_id
1891: ,p_object_version_number => p_object_version_number);
1892:
1893: if ((l_api_updating and
1894: (nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2) <>
1895: nvl(p_address_line2, hr_api.g_varchar2) or
1896: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1897: nvl(p_region_2, hr_api.g_varchar2)
1898: )) or (NOT l_api_updating)) then
1892:
1893: if ((l_api_updating and
1894: (nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2) <>
1895: nvl(p_address_line2, hr_api.g_varchar2) or
1896: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1897: nvl(p_region_2, hr_api.g_varchar2)
1898: )) or (NOT l_api_updating)) then
1899:
1900: hr_utility.set_location(l_proc, 2);
1946: -- Only proceed with validation if :
1947: -- a) The current g_old_rec is current and
1948: -- b) The value for address_line3, or region_3 have changed
1949: --
1950: l_api_updating := per_add_shd.api_updating
1951: (p_address_id => p_address_id
1952: ,p_object_version_number => p_object_version_number);
1953:
1954: if ((l_api_updating and
1951: (p_address_id => p_address_id
1952: ,p_object_version_number => p_object_version_number);
1953:
1954: if ((l_api_updating and
1955: (nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2) <>
1956: nvl(p_address_line3, hr_api.g_varchar2) or
1957: nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1958: nvl(p_region_3, hr_api.g_varchar2)
1959: )) or (NOT l_api_updating)) then
1953:
1954: if ((l_api_updating and
1955: (nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2) <>
1956: nvl(p_address_line3, hr_api.g_varchar2) or
1957: nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1958: nvl(p_region_3, hr_api.g_varchar2)
1959: )) or (NOT l_api_updating)) then
1960:
1961: hr_utility.set_location(l_proc, 2);
2132: -- Only proceed with validation if :
2133: -- a) The current g_old_rec is current and
2134: -- b) The value for postal code has changed
2135: --
2136: l_api_updating := per_add_shd.api_updating
2137: (p_address_id => p_address_id
2138: ,p_object_version_number => p_object_version_number);
2139: --
2140: if ((l_api_updating
2137: (p_address_id => p_address_id
2138: ,p_object_version_number => p_object_version_number);
2139: --
2140: if ((l_api_updating
2141: and nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
2142: nvl(p_postal_code, hr_api.g_varchar2)) or
2143: (NOT l_api_updating))
2144: then
2145: hr_utility.set_location(l_proc, 2);
2437: -- Only proceed with validation if :
2438: -- a) The current g_old_rec is current and
2439: -- b) The value for add_information20 has changed
2440: --
2441: l_api_updating := per_add_shd.api_updating
2442: (p_address_id => p_address_id
2443: ,p_object_version_number => p_object_version_number);
2444: --
2445: if ((l_api_updating
2442: (p_address_id => p_address_id
2443: ,p_object_version_number => p_object_version_number);
2444: --
2445: if ((l_api_updating
2446: and nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
2447: nvl(p_tax_address_zip, hr_api.g_varchar2)) or
2448: (NOT l_api_updating))
2449: then
2450: hr_utility.set_location(l_proc, 2);
2621: -- Only proceed with validation if :
2622: -- a) The current g_old_rec is current and
2623: -- b) The value for region_1 has changed
2624: --
2625: l_api_updating := per_add_shd.api_updating
2626: (p_address_id => p_address_id
2627: ,p_object_version_number => p_object_version_number);
2628: --
2629: if ((l_api_updating and
2626: (p_address_id => p_address_id
2627: ,p_object_version_number => p_object_version_number);
2628: --
2629: if ((l_api_updating and
2630: nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
2631: nvl(p_region_1, hr_api.g_varchar2)) or
2632: (NOT l_api_updating))
2633: then
2634: hr_utility.set_location(l_proc, 2);
2775: -- Only proceed with validation if :
2776: -- a) The current g_old_rec is current and
2777: -- b) The value for tax_county has changed
2778: --
2779: l_api_updating := per_add_shd.api_updating
2780: (p_address_id => p_address_id
2781: ,p_object_version_number => p_object_version_number);
2782: --
2783: if ((l_api_updating and
2780: (p_address_id => p_address_id
2781: ,p_object_version_number => p_object_version_number);
2782: --
2783: if ((l_api_updating and
2784: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
2785: nvl(p_tax_county, hr_api.g_varchar2)) or
2786: (NOT l_api_updating))
2787: then
2788: hr_utility.set_location(l_proc, 2);
2900: -- Only proceed with validation if :
2901: -- a) The current g_old_rec is current and
2902: -- b) The value for region_2 has changed
2903: --
2904: l_api_updating := per_add_shd.api_updating
2905: (p_address_id => p_address_id
2906: ,p_object_version_number => p_object_version_number
2907: );
2908: --
2906: ,p_object_version_number => p_object_version_number
2907: );
2908: --
2909: if ((l_api_updating and
2910: nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
2911: nvl(p_region_2, hr_api.g_varchar2)) or
2912: (NOT l_api_updating))
2913: then
2914: hr_utility.set_location(l_proc, 2);
3062: -- Only proceed with validation if :
3063: -- a) The current g_old_rec is current and
3064: -- b) The value for tax_state (add_information17) has changed
3065: --
3066: l_api_updating := per_add_shd.api_updating
3067: (p_address_id => p_address_id
3068: ,p_object_version_number => p_object_version_number
3069: );
3070: --
3068: ,p_object_version_number => p_object_version_number
3069: );
3070: --
3071: if ((l_api_updating and
3072: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3073: nvl(p_tax_state, hr_api.g_varchar2)) or
3074: (NOT l_api_updating))
3075: then
3076: hr_utility.set_location(l_proc, 2);
3191: -- Only proceed with validation if :
3192: -- a) The current g_old_rec is current and
3193: -- b) The value for town_or_city has changed
3194: --
3195: l_api_updating := per_add_shd.api_updating
3196: (p_address_id => p_address_id
3197: ,p_object_version_number => p_object_version_number);
3198: --
3199: if ((l_api_updating and
3196: (p_address_id => p_address_id
3197: ,p_object_version_number => p_object_version_number);
3198: --
3199: if ((l_api_updating and
3200: nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3201: nvl(p_town_or_city, hr_api.g_varchar2)) or
3202: (NOT l_api_updating))
3203: then
3204: hr_utility.set_location(l_proc, 2);
3308: -- Only proceed with validation if :
3309: -- a) The current g_old_rec is current and
3310: -- b) The value for tax_city has changed
3311: --
3312: l_api_updating := per_add_shd.api_updating
3313: (p_address_id => p_address_id
3314: ,p_object_version_number => p_object_version_number);
3315: --
3316: if ((l_api_updating and
3313: (p_address_id => p_address_id
3314: ,p_object_version_number => p_object_version_number);
3315: --
3316: if ((l_api_updating and
3317: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3318: nvl(p_tax_city, hr_api.g_varchar2)) or
3319: (NOT l_api_updating))
3320: then
3321: hr_utility.set_location(l_proc, 2);
3467: -- a) US address style and payroll is installed under US legislation and
3468: -- b) The current g_old_rec is current and
3469: -- c) The value for postal_code/region_2/town_or_city has changed.
3470: --
3471: l_api_updating := per_add_shd.api_updating
3472: (p_address_id => p_address_id
3473: ,p_object_version_number => p_object_version_number);
3474: --
3475: if ((l_api_updating and
3472: (p_address_id => p_address_id
3473: ,p_object_version_number => p_object_version_number);
3474: --
3475: if ((l_api_updating and
3476: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3477: nvl(p_region_2, hr_api.g_varchar2)) or
3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3474: --
3475: if ((l_api_updating and
3476: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3477: nvl(p_region_2, hr_api.g_varchar2)) or
3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3481: nvl(p_postal_code, hr_api.g_varchar2)) or
3482: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3476: (nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
3477: nvl(p_region_2, hr_api.g_varchar2)) or
3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3481: nvl(p_postal_code, hr_api.g_varchar2)) or
3482: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3483: nvl(p_town_or_city, hr_api.g_varchar2))) or
3484: (NOT l_api_updating)) then
3478: (nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
3479: nvl(p_region_1, hr_api.g_varchar2)) or
3480: (nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
3481: nvl(p_postal_code, hr_api.g_varchar2)) or
3482: (nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
3483: nvl(p_town_or_city, hr_api.g_varchar2))) or
3484: (NOT l_api_updating)) then
3485: --
3486: hr_utility.set_location(l_proc, 20);
3773: -- b) The current g_old_rec is current and
3774: -- c) The value for tax_zip (add_information20)/tax_state(add_information17)
3775: -- /tax_city(add_information18) has changed.
3776: --
3777: l_api_updating := per_add_shd.api_updating
3778: (p_address_id => p_address_id
3779: ,p_object_version_number => p_object_version_number);
3780: --
3781: if ((l_api_updating and
3778: (p_address_id => p_address_id
3779: ,p_object_version_number => p_object_version_number);
3780: --
3781: if ((l_api_updating and
3782: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3783: nvl(p_tax_city, hr_api.g_varchar2)) or
3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3780: --
3781: if ((l_api_updating and
3782: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3783: nvl(p_tax_city, hr_api.g_varchar2)) or
3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3787: nvl(p_tax_zip, hr_api.g_varchar2)) or
3788: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3782: (nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
3783: nvl(p_tax_city, hr_api.g_varchar2)) or
3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3787: nvl(p_tax_zip, hr_api.g_varchar2)) or
3788: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3789: nvl(p_tax_city, hr_api.g_varchar2))) or
3790: (NOT l_api_updating)) then
3784: (nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
3785: nvl(p_tax_county, hr_api.g_varchar2)) or
3786: (nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
3787: nvl(p_tax_zip, hr_api.g_varchar2)) or
3788: (nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
3789: nvl(p_tax_city, hr_api.g_varchar2))) or
3790: (NOT l_api_updating)) then
3791: --
3792: hr_utility.set_location(l_proc, 20);
4005: --
4006: cursor csr_del_address is
4007: select null
4008: from per_addresses pa
4009: where pa.date_from between per_add_shd.g_old_rec.date_from
4010: and l_date
4011: and pa.person_id = per_add_shd.g_old_rec.person_id
4012: and pa.primary_flag = 'N';
4013: --
4007: select null
4008: from per_addresses pa
4009: where pa.date_from between per_add_shd.g_old_rec.date_from
4010: and l_date
4011: and pa.person_id = per_add_shd.g_old_rec.person_id
4012: and pa.primary_flag = 'N';
4013: --
4014: cursor csr_no_del_contig_add is
4015: select null
4016: from sys.dual
4017: where exists(select null
4018: from per_addresses pa2
4019: where pa2.date_from > l_date
4020: and pa2.person_id = per_add_shd.g_old_rec.person_id
4021: and pa2.primary_flag = 'Y');
4022: --
4023: begin
4024: l_date := nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot);
4020: and pa2.person_id = per_add_shd.g_old_rec.person_id
4021: and pa2.primary_flag = 'Y');
4022: --
4023: begin
4024: l_date := nvl(per_add_shd.g_old_rec.date_to, hr_api.g_eot);
4025: hr_utility.set_location('Entering:'|| l_proc, 1);
4026: --
4027: -- For primary addresses only
4028: -- ==========================
4026: --
4027: -- For primary addresses only
4028: -- ==========================
4029: --
4030: if per_add_shd.g_old_rec.primary_flag = 'Y' then
4031: --
4032: -- Check that no non primary addresses
4033: -- exist within the date range of the
4034: -- currently selected primary address.
4089: -- (business_group_id, person_id, address_id, primary_flag or style)
4090: -- have been altered.
4091: --
4092: -- {End Of Comments}
4093: Procedure check_non_updateable_args(p_rec in per_add_shd.g_rec_type) is
4094: --
4095: l_proc varchar2(72) := g_package||'check_non_updateable_args';
4096: --
4097: Begin
4099: --
4100: -- Only proceed with validation if a row exists for
4101: -- the current record in the HR Schema
4102: --
4103: if not per_add_shd.api_updating
4104: (p_address_id => p_rec.address_id,
4105: p_object_version_number => p_rec.object_version_number) then
4106: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
4107: hr_utility.set_message_token('PROCEDURE', l_proc);
4113: -- start of commenting the code for business_group_id and person_id
4114: -- are updateable if currently null
4115: /*
4116: if nvl(p_rec.business_group_id, hr_api.g_number) <>
4117: per_add_shd.g_old_rec.business_group_id then
4118: hr_api.argument_changed_error
4119: (p_api_name => l_proc
4120: ,p_argument => 'BUSINESS_GROUP_ID'
4121: ,p_base_table => per_add_shd.g_tab_nam
4117: per_add_shd.g_old_rec.business_group_id then
4118: hr_api.argument_changed_error
4119: (p_api_name => l_proc
4120: ,p_argument => 'BUSINESS_GROUP_ID'
4121: ,p_base_table => per_add_shd.g_tab_nam
4122: );
4123: end if;
4124: hr_utility.set_location(l_proc, 7);
4125: --
4123: end if;
4124: hr_utility.set_location(l_proc, 7);
4125: --
4126: if nvl(p_rec.person_id, hr_api.g_number) <>
4127: per_add_shd.g_old_rec.person_id then
4128: hr_api.argument_changed_error
4129: (p_api_name => l_proc
4130: ,p_argument => 'PERSON_ID'
4131: ,p_base_table => per_add_shd.g_tab_nam
4127: per_add_shd.g_old_rec.person_id then
4128: hr_api.argument_changed_error
4129: (p_api_name => l_proc
4130: ,p_argument => 'PERSON_ID'
4131: ,p_base_table => per_add_shd.g_tab_nam
4132: );
4133: end if;
4134: */
4135: -- end of commenting code
4137: hr_utility.set_location(l_proc, 8);
4138: --
4139: if not g_called_from_form then
4140: if nvl(p_rec.primary_flag, hr_api.g_varchar2) <>
4141: per_add_shd.g_old_rec.primary_flag then
4142: hr_api.argument_changed_error
4143: (p_api_name => l_proc
4144: ,p_argument => 'PRIMARY_FLAG'
4145: ,p_base_table => per_add_shd.g_tab_nam
4141: per_add_shd.g_old_rec.primary_flag then
4142: hr_api.argument_changed_error
4143: (p_api_name => l_proc
4144: ,p_argument => 'PRIMARY_FLAG'
4145: ,p_base_table => per_add_shd.g_tab_nam
4146: );
4147: end if;
4148: end if;
4149: hr_utility.set_location(l_proc, 11);
4155: -- |--------------------------------< chk_df >---------------------------------|
4156: -- -----------------------------------------------------------------------------
4157: --
4158: procedure chk_df
4159: (p_rec in per_add_shd.g_rec_type) is
4160: --
4161: l_proc varchar2(72) := g_package||'chk_df';
4162: --
4163: Begin
4167: -- value has changed
4168: --
4169: if (p_rec.address_id is null)
4170: or ((p_rec.address_id is not null)
4171: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4172: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4169: if (p_rec.address_id is null)
4170: or ((p_rec.address_id is not null)
4171: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4172: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4171: and (nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2)
4172: <> nvl(p_rec.addr_attribute_category, hr_api.g_varchar2)
4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4173: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4174: <> nvl(p_rec.ADDR_ATTRIBUTE1, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4175: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4176: <> nvl(p_rec.ADDR_ATTRIBUTE2, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4177: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4178: <> nvl(p_rec.ADDR_ATTRIBUTE3, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4179: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4180: <> nvl(p_rec.ADDR_ATTRIBUTE4, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4181: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4182: <> nvl(p_rec.ADDR_ATTRIBUTE5, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4183: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4184: <> nvl(p_rec.ADDR_ATTRIBUTE6, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4185: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4186: <> nvl(p_rec.ADDR_ATTRIBUTE7, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4187: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4188: <> nvl(p_rec.ADDR_ATTRIBUTE8, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4189: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4190: <> nvl(p_rec.ADDR_ATTRIBUTE9, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4191: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4192: <> nvl(p_rec.ADDR_ATTRIBUTE10, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4193: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4194: <> nvl(p_rec.ADDR_ATTRIBUTE11, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4195: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4196: <> nvl(p_rec.ADDR_ATTRIBUTE12, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4197: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4198: <> nvl(p_rec.ADDR_ATTRIBUTE13, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4199: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4200: <> nvl(p_rec.ADDR_ATTRIBUTE14, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4201: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4202: <> nvl(p_rec.ADDR_ATTRIBUTE15, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4203: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4204: <> nvl(p_rec.ADDR_ATTRIBUTE16, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4210: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4211: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4205: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4206: <> nvl(p_rec.ADDR_ATTRIBUTE17, hr_api.g_varchar2)
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4210: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4211: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4212: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4213: )
4207: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4208: <> nvl(p_rec.ADDR_ATTRIBUTE18, hr_api.g_varchar2)
4209: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4210: <> nvl(p_rec.ADDR_ATTRIBUTE19, hr_api.g_varchar2)
4211: or nvl(per_add_shd.g_old_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4212: <> nvl(p_rec.ADDR_ATTRIBUTE20, hr_api.g_varchar2)
4213: )
4214: )
4215: then
4269: -- |-------------------------------< chk_ddf >---------------------------------|
4270: -- -----------------------------------------------------------------------------
4271: --
4272: procedure chk_ddf
4273: (p_rec in per_add_shd.g_rec_type) is
4274: --
4275: l_proc varchar2(72) := g_package||'chk_ddf';
4276: l_error exception;
4277: --
4282: -- value has changed
4283: --
4284: if (p_rec.address_id is null)
4285: or ((p_rec.address_id is not null)
4286: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4287: <> nvl(p_rec.style, hr_api.g_varchar2)
4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4284: if (p_rec.address_id is null)
4285: or ((p_rec.address_id is not null)
4286: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4287: <> nvl(p_rec.style, hr_api.g_varchar2)
4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4286: and (nvl(per_add_shd.g_old_rec.style, hr_api.g_varchar2)
4287: <> nvl(p_rec.style, hr_api.g_varchar2)
4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4288: or nvl(per_add_shd.g_old_rec.address_line1, hr_api.g_varchar2)
4289: <> nvl(p_rec.address_line1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4290: or nvl(per_add_shd.g_old_rec.address_line2, hr_api.g_varchar2)
4291: <> nvl(p_rec.address_line2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4292: or nvl(per_add_shd.g_old_rec.address_line3, hr_api.g_varchar2)
4293: <> nvl(p_rec.address_line3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4294: or nvl(per_add_shd.g_old_rec.town_or_city, hr_api.g_varchar2)
4295: <> nvl(p_rec.town_or_city, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4296: or nvl(per_add_shd.g_old_rec.region_1, hr_api.g_varchar2)
4297: <> nvl(p_rec.region_1, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4298: or nvl(per_add_shd.g_old_rec.region_2, hr_api.g_varchar2)
4299: <> nvl(p_rec.region_2, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4300: or nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
4301: <> nvl(p_rec.region_3, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4302: or nvl(per_add_shd.g_old_rec.postal_code, hr_api.g_varchar2)
4303: <> nvl(p_rec.postal_code, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4304: or nvl(per_add_shd.g_old_rec.country, hr_api.g_varchar2)
4305: <> nvl(p_rec.country, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4306: or nvl(per_add_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2)
4307: <> nvl(p_rec.telephone_number_1, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4308: or nvl(per_add_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2)
4309: <> nvl(p_rec.telephone_number_2, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4310: or nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
4311: <> nvl(p_rec.telephone_number_3, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4312: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4313: <> nvl(p_rec.add_information13, hr_api.g_varchar2)
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4314: or nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2)
4315: <> nvl(p_rec.add_information14, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4316: or nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2)
4317: <> nvl(p_rec.add_information15, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4318: or nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2)
4319: <> nvl(p_rec.add_information16, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4325: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4326: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4320: or nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) --Start of new code for Bug #2164019
4321: <> nvl(p_rec.add_information17, hr_api.g_varchar2)
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4325: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4326: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4327: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019
4328: )
4322: or nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2)
4323: <> nvl(p_rec.add_information18, hr_api.g_varchar2)
4324: or nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2)
4325: <> nvl(p_rec.add_information19, hr_api.g_varchar2)
4326: or nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2)
4327: <> nvl(p_rec.add_information20, hr_api.g_varchar2) --End of new code for Bug #2164019
4328: )
4329: )
4330: then
4409: -- Access Status:
4410: -- Internal Table Handler Use Only.
4411: -- ---------------------------------------------------------------------------
4412: procedure df_update_validate
4413: (p_rec in per_add_shd.g_rec_type) is
4414: --
4415: l_proc varchar2(72) := g_package||'df_update_validate';
4416: --
4417: begin
4416: --
4417: begin
4418: hr_utility.set_location('Entering:'||l_proc, 10);
4419: --
4420: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4421: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4418: hr_utility.set_location('Entering:'||l_proc, 10);
4419: --
4420: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4421: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4420: if nvl(per_add_shd.g_old_rec.addr_attribute_category, hr_api.g_varchar2) <>
4421: nvl(p_rec.addr_attribute_category, hr_api.g_varchar2) or
4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4422: nvl(per_add_shd.g_old_rec.addr_attribute1, hr_api.g_varchar2) <>
4423: nvl(p_rec.addr_attribute1, hr_api.g_varchar2) or
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4424: nvl(per_add_shd.g_old_rec.addr_attribute2, hr_api.g_varchar2) <>
4425: nvl(p_rec.addr_attribute2, hr_api.g_varchar2) or
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4426: nvl(per_add_shd.g_old_rec.addr_attribute3, hr_api.g_varchar2) <>
4427: nvl(p_rec.addr_attribute3, hr_api.g_varchar2) or
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4428: nvl(per_add_shd.g_old_rec.addr_attribute4, hr_api.g_varchar2) <>
4429: nvl(p_rec.addr_attribute4, hr_api.g_varchar2) or
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4430: nvl(per_add_shd.g_old_rec.addr_attribute5, hr_api.g_varchar2) <>
4431: nvl(p_rec.addr_attribute5, hr_api.g_varchar2) or
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4432: nvl(per_add_shd.g_old_rec.addr_attribute6, hr_api.g_varchar2) <>
4433: nvl(p_rec.addr_attribute6, hr_api.g_varchar2) or
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4434: nvl(per_add_shd.g_old_rec.addr_attribute7, hr_api.g_varchar2) <>
4435: nvl(p_rec.addr_attribute7, hr_api.g_varchar2) or
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4436: nvl(per_add_shd.g_old_rec.addr_attribute8, hr_api.g_varchar2) <>
4437: nvl(p_rec.addr_attribute8, hr_api.g_varchar2) or
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4438: nvl(per_add_shd.g_old_rec.addr_attribute9, hr_api.g_varchar2) <>
4439: nvl(p_rec.addr_attribute9, hr_api.g_varchar2) or
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4440: nvl(per_add_shd.g_old_rec.addr_attribute10, hr_api.g_varchar2) <>
4441: nvl(p_rec.addr_attribute10, hr_api.g_varchar2) or
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4442: nvl(per_add_shd.g_old_rec.addr_attribute11, hr_api.g_varchar2) <>
4443: nvl(p_rec.addr_attribute11, hr_api.g_varchar2) or
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4444: nvl(per_add_shd.g_old_rec.addr_attribute12, hr_api.g_varchar2) <>
4445: nvl(p_rec.addr_attribute12, hr_api.g_varchar2) or
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4446: nvl(per_add_shd.g_old_rec.addr_attribute13, hr_api.g_varchar2) <>
4447: nvl(p_rec.addr_attribute13, hr_api.g_varchar2) or
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4448: nvl(per_add_shd.g_old_rec.addr_attribute14, hr_api.g_varchar2) <>
4449: nvl(p_rec.addr_attribute14, hr_api.g_varchar2) or
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4450: nvl(per_add_shd.g_old_rec.addr_attribute15, hr_api.g_varchar2) <>
4451: nvl(p_rec.addr_attribute15, hr_api.g_varchar2) or
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4452: nvl(per_add_shd.g_old_rec.addr_attribute16, hr_api.g_varchar2) <>
4453: nvl(p_rec.addr_attribute16, hr_api.g_varchar2) or
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4454: nvl(per_add_shd.g_old_rec.addr_attribute17, hr_api.g_varchar2) <>
4455: nvl(p_rec.addr_attribute17, hr_api.g_varchar2) or
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4456: nvl(per_add_shd.g_old_rec.addr_attribute18, hr_api.g_varchar2) <>
4457: nvl(p_rec.addr_attribute18, hr_api.g_varchar2) or
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4458: nvl(per_add_shd.g_old_rec.addr_attribute19, hr_api.g_varchar2) <>
4459: nvl(p_rec.addr_attribute19, hr_api.g_varchar2) or
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4460: nvl(per_add_shd.g_old_rec.addr_attribute20, hr_api.g_varchar2) <>
4461: nvl(p_rec.addr_attribute20, hr_api.g_varchar2) or
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4462: nvl(per_add_shd.g_old_rec.add_information13, hr_api.g_varchar2) <>
4463: nvl(p_rec.add_information13, hr_api.g_varchar2) or
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4464: nvl(per_add_shd.g_old_rec.add_information14, hr_api.g_varchar2) <>
4465: nvl(p_rec.add_information14, hr_api.g_varchar2) or
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4466: nvl(per_add_shd.g_old_rec.add_information15, hr_api.g_varchar2) <>
4467: nvl(p_rec.add_information15, hr_api.g_varchar2) or
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4468: nvl(per_add_shd.g_old_rec.add_information16, hr_api.g_varchar2) <>
4469: nvl(p_rec.add_information16, hr_api.g_varchar2) or
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4470: nvl(per_add_shd.g_old_rec.add_information17, hr_api.g_varchar2) <>
4471: nvl(p_rec.add_information17, hr_api.g_varchar2) or
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4477: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4478: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4472: nvl(per_add_shd.g_old_rec.add_information18, hr_api.g_varchar2) <>
4473: nvl(p_rec.add_information18, hr_api.g_varchar2) or
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4477: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4478: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4479: nvl(p_rec.party_id, hr_api.g_number)
4480: then
4474: nvl(per_add_shd.g_old_rec.add_information19, hr_api.g_varchar2) <>
4475: nvl(p_rec.add_information19, hr_api.g_varchar2) or
4476: nvl(per_add_shd.g_old_rec.add_information20, hr_api.g_varchar2) <>
4477: nvl(p_rec.add_information20, hr_api.g_varchar2) or
4478: nvl(per_add_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
4479: nvl(p_rec.party_id, hr_api.g_number)
4480: then
4481: -- either the attribute_category or attribute1..30 have changed
4482: -- so we must call the flex stub
4489: -- ----------------------------------------------------------------------------
4490: -- |---------------------------< insert_validate >----------------------------|
4491: -- ----------------------------------------------------------------------------
4492: Procedure insert_validate
4493: (p_rec in out nocopy per_add_shd.g_rec_type
4494: ,p_effective_date in date
4495: ,p_validate_county in boolean default true
4496: ) is
4497: --
4517: -- Validate business group id
4518: --
4519: hr_api.validate_bus_grp_id(
4520: p_business_group_id => p_rec.business_group_id
4521: ,p_associated_column1 => per_add_shd.g_tab_nam ||
4522: '.BUSINESS_GROUP_ID'
4523: );
4524: hr_utility.set_location(l_proc, 20);
4525: --
4867: -- ----------------------------------------------------------------------------
4868: -- |---------------------------< update_validate >----------------------------|
4869: -- ----------------------------------------------------------------------------
4870: Procedure update_validate
4871: (p_rec in out nocopy per_add_shd.g_rec_type
4872: ,p_effective_date in date
4873: ,p_prflagval_override in boolean default false
4874: ,p_validate_county in boolean default true
4875: ) is
4902: -- Validate business group id
4903: --
4904: hr_api.validate_bus_grp_id(
4905: p_business_group_id => p_rec.business_group_id
4906: ,p_associated_column1 => per_add_shd.g_tab_nam ||
4907: '.BUSINESS_GROUP_ID'
4908: );
4909: hr_utility.set_location(l_proc, 20);
4910: --
5241: --
5242: -- ----------------------------------------------------------------------------
5243: -- |---------------------------< delete_validate >----------------------------|
5244: -- ----------------------------------------------------------------------------
5245: Procedure delete_validate(p_rec in out nocopy per_add_shd.g_rec_type) is
5246: --
5247: l_proc varchar2(72) := g_package||'delete_validate';
5248: --
5249: Begin