51: end if;
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --
55: hr_api.mandatory_arg_error(p_api_name => l_proc,
56: p_argument => 'person_id',
57: p_argument_value => p_person_id);
58: --
59: open csr_sec_grp;
70: close csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: --
82: end if;
83: if g_debug then
84: hr_utility.set_location(' Leaving:'|| l_proc, 20);
133: end if;
134: --
135: -- Check mandatory parameters have been set
136: --
137: hr_api.mandatory_arg_error
138: (p_api_name => l_proc
139: ,p_argument => 'person type id'
140: ,p_argument_value => p_person_type_id
141: );
139: ,p_argument => 'person type id'
140: ,p_argument_value => p_person_type_id
141: );
142: --
143: hr_api.mandatory_arg_error
144: (p_api_name => l_proc
145: ,p_argument => 'business group id'
146: ,p_argument_value => p_business_group_id
147: );
268: end if;
269: --
270: -- Check mandatory parameters have been set
271: --
272: hr_api.mandatory_arg_error
273: (p_api_name => l_proc
274: ,p_argument => 'business group id'
275: ,p_argument_value => p_business_group_id
276: );
274: ,p_argument => 'business group id'
275: ,p_argument_value => p_business_group_id
276: );
277: --
278: hr_api.mandatory_arg_error
279: (p_api_name => l_proc
280: ,p_argument => 'person type id'
281: ,p_argument_value => p_person_type_id
282: );
280: ,p_argument => 'person type id'
281: ,p_argument_value => p_person_type_id
282: );
283: --
284: hr_api.mandatory_arg_error
285: (p_api_name => l_proc
286: ,p_argument => 'effective date'
287: ,p_argument_value => p_effective_date
288: );
522: end if;
523: --
524: -- Check mandatory parameters have been set
525: --
526: hr_api.mandatory_arg_error
527: (p_api_name => l_proc
528: ,p_argument => 'business group id'
529: ,p_argument_value => p_business_group_id
530: );
528: ,p_argument => 'business group id'
529: ,p_argument_value => p_business_group_id
530: );
531: --
532: hr_api.mandatory_arg_error
533: (p_api_name => l_proc
534: ,p_argument => 'person type id'
535: ,p_argument_value => p_person_type_id
536: );
534: ,p_argument => 'person type id'
535: ,p_argument_value => p_person_type_id
536: );
537: --
538: hr_api.mandatory_arg_error
539: (p_api_name => l_proc
540: ,p_argument => 'effective date'
541: ,p_argument_value => p_effective_date
542: );
554: --
555: per_per_bus.chk_system_pers_type
556: (p_person_id => p_person_id
557: ,p_validation_start_date => p_validation_start_date
558: ,p_validation_end_date => hr_api.g_eot
559: ,p_datetrack_mode => p_datetrack_mode
560: ,p_effective_date => p_effective_date
561: );
562: end if;
833: if hr_multi_message.no_exclusive_error
834: (p_check_column1 => 'PER_ALL_PEOPLE_F.START_DATE'
835: )
836: then
837: hr_api.mandatory_arg_error
838: (p_api_name => l_proc
839: ,p_argument => 'person type id'
840: ,p_argument_value => p_person_type_id
841: );
839: ,p_argument => 'person type id'
840: ,p_argument_value => p_person_type_id
841: );
842: --
843: hr_api.mandatory_arg_error
844: (p_api_name => l_proc
845: ,p_argument => 'business group id'
846: ,p_argument_value => p_business_group_id
847: );
845: ,p_argument => 'business group id'
846: ,p_argument_value => p_business_group_id
847: );
848: --
849: hr_api.mandatory_arg_error
850: (p_api_name => l_proc
851: ,p_argument => 'effective date'
852: ,p_argument_value => p_effective_date
853: );
851: ,p_argument => 'effective date'
852: ,p_argument_value => p_effective_date
853: );
854: --
855: hr_api.mandatory_arg_error
856: (p_api_name => l_proc
857: ,p_argument => 'validation start date'
858: ,p_argument_value => p_validation_start_date
859: );
857: ,p_argument => 'validation start date'
858: ,p_argument_value => p_validation_start_date
859: );
860: --
861: hr_api.mandatory_arg_error
862: (p_api_name => l_proc
863: ,p_argument => 'validation end date'
864: ,p_argument_value => p_validation_end_date
865: );
876: ,p_effective_date => p_effective_date
877: ,p_object_version_number => p_object_version_number);
878: --
879: if ((l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
880: hr_api.g_date)
881: <> nvl(p_date_of_birth,hr_api.g_date)) or
882: (NOT l_api_updating)) then
883: if g_debug then
884: hr_utility.set_location(l_proc, 2);
877: ,p_object_version_number => p_object_version_number);
878: --
879: if ((l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
880: hr_api.g_date)
881: <> nvl(p_date_of_birth,hr_api.g_date)) or
882: (NOT l_api_updating)) then
883: if g_debug then
884: hr_utility.set_location(l_proc, 2);
885: end if;
1075: end if;
1076: --
1077: -- Check mandatory parameters have been set
1078: --
1079: hr_api.mandatory_arg_error
1080: (p_api_name => l_proc
1081: ,p_argument => 'effective date'
1082: ,p_argument_value => p_effective_date
1083: );
1081: ,p_argument => 'effective date'
1082: ,p_argument_value => p_effective_date
1083: );
1084: --
1085: hr_api.mandatory_arg_error
1086: (p_api_name => l_proc
1087: ,p_argument => 'validation_start_date'
1088: ,p_argument_value => p_validation_start_date
1089: );
1087: ,p_argument => 'validation_start_date'
1088: ,p_argument_value => p_validation_start_date
1089: );
1090: --
1091: hr_api.mandatory_arg_error
1092: (p_api_name => l_proc
1093: ,p_argument => 'validation_end_date'
1094: ,p_argument_value => p_validation_end_date
1095: );
1107: ,p_effective_date => p_effective_date
1108: ,p_object_version_number => p_object_version_number
1109: );
1110: if ((l_api_updating
1111: and nvl(per_per_shd.g_old_rec.marital_status, hr_api.g_varchar2)
1112: <> nvl(p_marital_status,hr_api.g_varchar2))
1113: or
1114: (NOT l_api_updating))
1115: then
1108: ,p_object_version_number => p_object_version_number
1109: );
1110: if ((l_api_updating
1111: and nvl(per_per_shd.g_old_rec.marital_status, hr_api.g_varchar2)
1112: <> nvl(p_marital_status,hr_api.g_varchar2))
1113: or
1114: (NOT l_api_updating))
1115: then
1116: if g_debug then
1125: -- lookup type 'MAR_STATUS' with an enabled flag set to 'Y' and that
1126: -- the effective start date of the person is between start date
1127: -- active and end date active in hr_lookups.
1128: --
1129: if hr_api.not_exists_in_dt_hr_lookups
1130: (p_effective_date => p_effective_date
1131: ,p_validation_start_date => p_validation_start_date
1132: ,p_validation_end_date => p_validation_end_date
1133: ,p_lookup_type => 'MAR_STATUS'
1213: end if;
1214: --
1215: -- Check mandatory parameters have been set
1216: --
1217: hr_api.mandatory_arg_error
1218: (p_api_name => l_proc
1219: ,p_argument => 'effective date'
1220: ,p_argument_value => p_effective_date
1221: );
1234: ,p_effective_date => p_effective_date
1235: ,p_object_version_number => p_object_version_number
1236: );
1237: if ((l_api_updating
1238: and nvl(per_per_shd.g_old_rec.party_id, hr_api.g_number)
1239: <> nvl(p_party_id,hr_api.g_number))
1240: or
1241: (NOT l_api_updating))
1242: then
1235: ,p_object_version_number => p_object_version_number
1236: );
1237: if ((l_api_updating
1238: and nvl(per_per_shd.g_old_rec.party_id, hr_api.g_number)
1239: <> nvl(p_party_id,hr_api.g_number))
1240: or
1241: (NOT l_api_updating))
1242: then
1243: if g_debug then
1346: end if;
1347: --
1348: -- Check mandatory parameters have been set
1349: --
1350: hr_api.mandatory_arg_error
1351: (p_api_name => l_proc
1352: ,p_argument => 'effective date'
1353: ,p_argument_value => p_effective_date
1354: );
1352: ,p_argument => 'effective date'
1353: ,p_argument_value => p_effective_date
1354: );
1355: --
1356: hr_api.mandatory_arg_error
1357: (p_api_name => l_proc
1358: ,p_argument => 'validation_start_date'
1359: ,p_argument_value => p_validation_start_date
1360: );
1358: ,p_argument => 'validation_start_date'
1359: ,p_argument_value => p_validation_start_date
1360: );
1361: --
1362: hr_api.mandatory_arg_error
1363: (p_api_name => l_proc
1364: ,p_argument => 'validation_end_date'
1365: ,p_argument_value => p_validation_end_date
1366: );
1374: ,p_effective_date => p_effective_date
1375: ,p_object_version_number => p_object_version_number
1376: );
1377: if ((l_api_updating
1378: and nvl(per_per_shd.g_old_rec.nationality, hr_api.g_varchar2)
1379: <> nvl(p_nationality,hr_api.g_varchar2))
1380: or
1381: (NOT l_api_updating))
1382: then
1375: ,p_object_version_number => p_object_version_number
1376: );
1377: if ((l_api_updating
1378: and nvl(per_per_shd.g_old_rec.nationality, hr_api.g_varchar2)
1379: <> nvl(p_nationality,hr_api.g_varchar2))
1380: or
1381: (NOT l_api_updating))
1382: then
1383: if g_debug then
1392: -- lookup type 'NATIONALITY' with an enabled flag set to 'Y' and that
1393: -- the effective start date of the person is between start date
1394: -- active and end date active in hr_lookups.
1395: --
1396: if hr_api.not_exists_in_dt_hr_lookups
1397: (p_effective_date => p_effective_date
1398: ,p_validation_start_date => p_validation_start_date
1399: ,p_validation_end_date => p_validation_end_date
1400: ,p_lookup_type => 'NATIONALITY'
1534: end if;
1535: --
1536: -- Check mandatory parameters have been set
1537: --
1538: hr_api.mandatory_arg_error
1539: (p_api_name => l_proc
1540: ,p_argument => 'business group id'
1541: ,p_argument_value => p_business_group_id
1542: );
1540: ,p_argument => 'business group id'
1541: ,p_argument_value => p_business_group_id
1542: );
1543: --
1544: hr_api.mandatory_arg_error
1545: (p_api_name => l_proc
1546: ,p_argument => 'effective date'
1547: ,p_argument_value => p_effective_date
1548: );
1557: ,p_effective_date => p_effective_date
1558: ,p_object_version_number => p_object_version_number);
1559: --
1560: if ((l_api_updating and nvl(per_per_shd.g_old_rec.national_identifier,
1561: hr_api.g_varchar2)
1562: <> nvl(p_national_identifier,hr_api.g_varchar2)) or
1563: (NOT l_api_updating)) then
1564: --
1565: if g_debug then
1558: ,p_object_version_number => p_object_version_number);
1559: --
1560: if ((l_api_updating and nvl(per_per_shd.g_old_rec.national_identifier,
1561: hr_api.g_varchar2)
1562: <> nvl(p_national_identifier,hr_api.g_varchar2)) or
1563: (NOT l_api_updating)) then
1564: --
1565: if g_debug then
1566: hr_utility.set_location(l_proc, 2);
1866: then
1867: --
1868: -- Check mandatory parameters have been set
1869: --
1870: hr_api.mandatory_arg_error
1871: (p_api_name => l_proc
1872: ,p_argument => 'business group id'
1873: ,p_argument_value => p_business_group_id
1874: );
1872: ,p_argument => 'business group id'
1873: ,p_argument_value => p_business_group_id
1874: );
1875: --
1876: hr_api.mandatory_arg_error
1877: (p_api_name => l_proc
1878: ,p_argument => 'person type id'
1879: ,p_argument_value => p_person_type_id
1880: );
1878: ,p_argument => 'person type id'
1879: ,p_argument_value => p_person_type_id
1880: );
1881: --
1882: hr_api.mandatory_arg_error
1883: (p_api_name => l_proc
1884: ,p_argument => 'effective date'
1885: ,p_argument_value => p_effective_date
1886: );
1912: -- that an employee number is now required or if the NI number has changed
1913: -- and the generation method is 'N'.
1914: --
1915: if ((l_api_updating and (nvl(per_per_shd.g_old_rec.employee_number,
1916: hr_api.g_varchar2) <>
1917: nvl(p_employee_number, hr_api.g_varchar2)
1918: or emp_sys_per_type_change
1919: (p_person_type_id
1920: ,per_per_shd.g_old_rec.person_type_id
1913: -- and the generation method is 'N'.
1914: --
1915: if ((l_api_updating and (nvl(per_per_shd.g_old_rec.employee_number,
1916: hr_api.g_varchar2) <>
1917: nvl(p_employee_number, hr_api.g_varchar2)
1918: or emp_sys_per_type_change
1919: (p_person_type_id
1920: ,per_per_shd.g_old_rec.person_type_id
1921: ,p_business_group_id)
1933: -- If we are updating and the employee number has actually changed then
1934: -- ensure the number generation method is not automatic.
1935: --
1936: if l_api_updating and
1937: nvl(per_per_shd.g_old_rec.employee_number, hr_api.g_varchar2) <>
1938: nvl(p_employee_number, hr_api.g_varchar2) and
1939: l_gen_method = 'A'
1940: and (not g_global_transfer_in_process
1941: OR
1934: -- ensure the number generation method is not automatic.
1935: --
1936: if l_api_updating and
1937: nvl(per_per_shd.g_old_rec.employee_number, hr_api.g_varchar2) <>
1938: nvl(p_employee_number, hr_api.g_varchar2) and
1939: l_gen_method = 'A'
1940: and (not g_global_transfer_in_process
1941: OR
1942: (g_global_transfer_in_process
2271: then
2272: --
2273: -- Check mandatory parameters have been set
2274: --
2275: hr_api.mandatory_arg_error
2276: (p_api_name => l_proc
2277: ,p_argument => 'business group id'
2278: ,p_argument_value => p_business_group_id
2279: );
2277: ,p_argument => 'business group id'
2278: ,p_argument_value => p_business_group_id
2279: );
2280: --
2281: hr_api.mandatory_arg_error
2282: (p_api_name => l_proc
2283: ,p_argument => 'effective date'
2284: ,p_argument_value => p_effective_date
2285: );
2312: -- that an npw number is now required or if the NI number has changed
2313: -- and the generation method is 'N'.
2314: --
2315: if ((l_api_updating and (nvl(per_per_shd.g_old_rec.npw_number,
2316: hr_api.g_varchar2) <>
2317: nvl(p_npw_number, hr_api.g_varchar2)
2318: or (p_current_npw_flag = 'Y'
2319: and per_per_shd.g_old_rec.current_npw_flag is null)
2320: or npw_ni_change
2313: -- and the generation method is 'N'.
2314: --
2315: if ((l_api_updating and (nvl(per_per_shd.g_old_rec.npw_number,
2316: hr_api.g_varchar2) <>
2317: nvl(p_npw_number, hr_api.g_varchar2)
2318: or (p_current_npw_flag = 'Y'
2319: and per_per_shd.g_old_rec.current_npw_flag is null)
2320: or npw_ni_change
2321: (p_national_identifier
2331: -- If we are updating and the npw number has actually changed then
2332: -- ensure the number generation method is not automatic.
2333: --
2334: if l_api_updating and
2335: nvl(per_per_shd.g_old_rec.npw_number, hr_api.g_varchar2) <>
2336: nvl(p_npw_number, hr_api.g_varchar2) and
2337: l_gen_method = 'A' then
2338: -- ER FPT
2339: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then
2332: -- ensure the number generation method is not automatic.
2333: --
2334: if l_api_updating and
2335: nvl(per_per_shd.g_old_rec.npw_number, hr_api.g_varchar2) <>
2336: nvl(p_npw_number, hr_api.g_varchar2) and
2337: l_gen_method = 'A' then
2338: -- ER FPT
2339: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then
2340: hr_utility.set_message(800, 'HR_289657_PER_INV_CWK_UPD');
2371: --
2372: if l_gen_method = 'A' and
2373: p_npw_number is not null and
2374:
2375: p_npw_number <> nvl(per_per_shd.g_old_rec.npw_number,hr_api.g_varchar2) then
2376: -- ER FPT
2377: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then
2378: hr_utility.set_message(800,'PER_289635_CWK_NUM_NOT_NULL');
2379: hr_utility.raise_error;
2570: end if;
2571: --
2572: -- Check mandatory parameters have been set
2573: --
2574: hr_api.mandatory_arg_error
2575: (p_api_name => l_proc
2576: ,p_argument => 'effective date'
2577: ,p_argument_value => p_effective_date
2578: );
2576: ,p_argument => 'effective date'
2577: ,p_argument_value => p_effective_date
2578: );
2579: --
2580: hr_api.mandatory_arg_error
2581: (p_api_name => l_proc
2582: ,p_argument => 'validation_start_date'
2583: ,p_argument_value => p_validation_start_date
2584: );
2582: ,p_argument => 'validation_start_date'
2583: ,p_argument_value => p_validation_start_date
2584: );
2585: --
2586: hr_api.mandatory_arg_error
2587: (p_api_name => l_proc
2588: ,p_argument => 'validation_end_date'
2589: ,p_argument_value => p_validation_end_date
2590: );
2607: end if;
2608: --
2609: if ((l_api_updating
2610: and nvl(per_per_shd.g_old_rec.expense_check_send_to_address,
2611: hr_api.g_varchar2)
2612: <> nvl(p_expense_check_send_to_addres,hr_api.g_varchar2))
2613: or
2614: (NOT l_api_updating))
2615: then
2608: --
2609: if ((l_api_updating
2610: and nvl(per_per_shd.g_old_rec.expense_check_send_to_address,
2611: hr_api.g_varchar2)
2612: <> nvl(p_expense_check_send_to_addres,hr_api.g_varchar2))
2613: or
2614: (NOT l_api_updating))
2615: then
2616: if g_debug then
2625: -- lookup type 'HOME_OFFICE' with an enabled flag set to 'Y' and that
2626: -- the effective start date of the person is between start date
2627: -- active and end date active in hr_lookups.
2628: --
2629: if hr_api.not_exists_in_dt_hr_lookups
2630: (p_effective_date => p_effective_date
2631: ,p_validation_start_date => p_validation_start_date
2632: ,p_validation_end_date => p_validation_end_date
2633: ,p_lookup_type => 'HOME_OFFICE'
2754: end if;
2755: --
2756: -- Check mandatory parameters have been set
2757: --
2758: hr_api.mandatory_arg_error
2759: (p_api_name => l_proc
2760: ,p_argument => 'effective date'
2761: ,p_argument_value => p_effective_date
2762: );
2760: ,p_argument => 'effective date'
2761: ,p_argument_value => p_effective_date
2762: );
2763: --
2764: hr_api.mandatory_arg_error
2765: (p_api_name => l_proc
2766: ,p_argument => 'validation_start_date'
2767: ,p_argument_value => p_validation_start_date
2768: );
2766: ,p_argument => 'validation_start_date'
2767: ,p_argument_value => p_validation_start_date
2768: );
2769: --
2770: hr_api.mandatory_arg_error
2771: (p_api_name => l_proc
2772: ,p_argument => 'validation_end_date'
2773: ,p_argument_value => p_validation_end_date
2774: );
2791: hr_utility.set_location(l_proc, 30);
2792: end if;
2793: --
2794: if ((l_api_updating
2795: and nvl(per_per_shd.g_old_rec.sex, hr_api.g_varchar2)
2796: <> nvl(p_sex,hr_api.g_varchar2))
2797: or
2798: (l_api_updating and nvl(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
2799: <> nvl(p_title,hr_api.g_varchar2))
2792: end if;
2793: --
2794: if ((l_api_updating
2795: and nvl(per_per_shd.g_old_rec.sex, hr_api.g_varchar2)
2796: <> nvl(p_sex,hr_api.g_varchar2))
2797: or
2798: (l_api_updating and nvl(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
2799: <> nvl(p_title,hr_api.g_varchar2))
2800: or
2794: if ((l_api_updating
2795: and nvl(per_per_shd.g_old_rec.sex, hr_api.g_varchar2)
2796: <> nvl(p_sex,hr_api.g_varchar2))
2797: or
2798: (l_api_updating and nvl(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
2799: <> nvl(p_title,hr_api.g_varchar2))
2800: or
2801: (NOT l_api_updating))
2802: then
2795: and nvl(per_per_shd.g_old_rec.sex, hr_api.g_varchar2)
2796: <> nvl(p_sex,hr_api.g_varchar2))
2797: or
2798: (l_api_updating and nvl(per_per_shd.g_old_rec.title,hr_api.g_varchar2)
2799: <> nvl(p_title,hr_api.g_varchar2))
2800: or
2801: (NOT l_api_updating))
2802: then
2803: if g_debug then
2812: -- 'TITLE' with an enabled flag set to 'Y' and that the effective
2813: -- start date of the person is between start date active and end
2814: -- date active in hr_lookups.
2815: --
2816: if hr_api.not_exists_in_dt_hr_lookups
2817: (p_effective_date => p_effective_date
2818: ,p_validation_start_date => p_validation_start_date
2819: ,p_validation_end_date => p_validation_end_date
2820: ,p_lookup_type => 'TITLE'
2842: -- 'SEX' with an enabled flag set to 'Y' and that the effective
2843: -- start date of the person is between start date active and end
2844: -- date active in hr_lookups.
2845: --
2846: if hr_api.not_exists_in_dt_hr_lookups
2847: (p_effective_date => p_effective_date
2848: ,p_validation_start_date => p_validation_start_date
2849: ,p_validation_end_date => p_validation_end_date
2850: ,p_lookup_type => 'SEX'
2982: --
2983: if ((p_person_id is null)
2984: OR
2985: ((p_person_id is not null) and
2986: nvl(p_town_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.town_of_birth,hr_api.g_varchar2))) then
2987: --
2988: if g_debug then
2989: hr_utility.set_location(l_proc, 2);
2990: end if;
2994: if csr_plfi%found then
2995: close csr_plfi;
2996: -- attempt to decode the lookup type returned from plfi record
2997: -- with the p_town_of_birth lookup_value supplied to the api.
2998: if hr_api.not_exists_in_dt_hr_lookups
2999: (p_effective_date => p_effective_date
3000: ,p_validation_start_date => p_validation_start_date
3001: ,p_validation_end_date => p_validation_end_date
3002: ,p_lookup_type => l_lookup_type
3096: --
3097: if ((p_person_id is null)
3098: OR
3099: ((p_person_id is not null) and
3100: nvl(p_region_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.region_of_birth,hr_api.g_varchar2))) then
3101: --
3102: if g_debug then
3103: hr_utility.set_location(l_proc, 2);
3104: end if;
3108: if csr_plfi%found then
3109: close csr_plfi;
3110: -- attempt to decode the lookup type returned from plfi record
3111: -- with the p_region_of_birth lookup_value supplied to the api.
3112: if hr_api.not_exists_in_dt_hr_lookups
3113: (p_effective_date => p_effective_date
3114: ,p_validation_start_date => p_validation_start_date
3115: ,p_validation_end_date => p_validation_end_date
3116: ,p_lookup_type => l_lookup_type
3198: --
3199: if ((p_person_id is null)
3200: OR
3201: ((p_person_id is not null) and
3202: nvl(p_country_of_birth,hr_api.g_varchar2) <> nvl(per_per_shd.g_old_rec.country_of_birth,hr_api.g_varchar2))) then
3203: --
3204: if g_debug then
3205: hr_utility.set_location(l_proc, 2);
3206: end if;
3294: end if;
3295: --
3296: -- Check mandatory parameters have been set
3297: --
3298: hr_api.mandatory_arg_error
3299: (p_api_name => l_proc
3300: ,p_argument => 'start date'
3301: ,p_argument_value => p_start_date
3302: );
3300: ,p_argument => 'start date'
3301: ,p_argument_value => p_start_date
3302: );
3303: --
3304: hr_api.mandatory_arg_error
3305: (p_api_name => l_proc
3306: ,p_argument => 'effective date'
3307: ,p_argument_value => p_effective_date
3308: );
3453: hr_utility.set_location('Entering:'|| l_proc,5);
3454: end if;
3455: --
3456: if p_original_date_of_hire is NOT NULL then
3457: if (nvl(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)
3458: <> nvl(p_original_date_of_hire, hr_api.g_date)) or
3459: (per_per_shd.g_old_rec.start_date <> p_start_date) then
3460: --
3461: if l_system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') then
3454: end if;
3455: --
3456: if p_original_date_of_hire is NOT NULL then
3457: if (nvl(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)
3458: <> nvl(p_original_date_of_hire, hr_api.g_date)) or
3459: (per_per_shd.g_old_rec.start_date <> p_start_date) then
3460: --
3461: if l_system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') then
3462: --
3460: --
3461: if l_system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') then
3462: --
3463: if (p_person_id is null and
3464: (nvl(p_original_date_of_hire,hr_api.g_date) > p_start_date)) then
3465: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3466: hr_multi_message.add
3467: (p_associated_column1 => 'PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE'
3468: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
3482: else
3483: close original_date_of_hire_ppf;
3484: end if;
3485: -- end of bug 5402099
3486: if (nvl(p_original_date_of_hire,hr_api.g_date) > l_earliest_date) then
3487: /* 1352469 Replaced with above IF statement
3488: if ((l_earliest_date <= p_start_date) and
3489: (nvl(p_original_date_of_hire,hr_api.g_date) > l_earliest_date))
3490: or ((l_earliest_date > p_start_date) and
3485: -- end of bug 5402099
3486: if (nvl(p_original_date_of_hire,hr_api.g_date) > l_earliest_date) then
3487: /* 1352469 Replaced with above IF statement
3488: if ((l_earliest_date <= p_start_date) and
3489: (nvl(p_original_date_of_hire,hr_api.g_date) > l_earliest_date))
3490: or ((l_earliest_date > p_start_date) and
3491: (nvl(p_original_date_of_hire,hr_api.g_date) > p_start_date)) then
3492: */
3493: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3487: /* 1352469 Replaced with above IF statement
3488: if ((l_earliest_date <= p_start_date) and
3489: (nvl(p_original_date_of_hire,hr_api.g_date) > l_earliest_date))
3490: or ((l_earliest_date > p_start_date) and
3491: (nvl(p_original_date_of_hire,hr_api.g_date) > p_start_date)) then
3492: */
3493: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3494: close csr_earliest_date;
3495: hr_multi_message.add
3652: end if;
3653: --
3654: -- Check the mandatory parameters
3655: --
3656: hr_api.mandatory_arg_error
3657: (p_api_name => l_proc
3658: ,p_argument => 'effective_date'
3659: ,p_argument_value => p_effective_date
3660: );
3658: ,p_argument => 'effective_date'
3659: ,p_argument_value => p_effective_date
3660: );
3661: --
3662: hr_api.mandatory_arg_error
3663: (p_api_name => l_proc
3664: ,p_argument => 'validation_start_date'
3665: ,p_argument_value => p_validation_start_date
3666: );
3664: ,p_argument => 'validation_start_date'
3665: ,p_argument_value => p_validation_start_date
3666: );
3667: --
3668: hr_api.mandatory_arg_error
3669: (p_api_name => l_proc
3670: ,p_argument => 'validation_end_date'
3671: ,p_argument_value => p_validation_end_date
3672: );
3686: -- lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and that
3687: -- the effective start date of the person is between start date
3688: -- active and end date active in hr_lookups.
3689: --
3690: if hr_api.not_exists_in_dt_hr_lookups
3691: (p_effective_date => p_effective_date
3692: ,p_validation_start_date => p_validation_start_date
3693: ,p_validation_end_date => p_validation_end_date
3694: ,p_lookup_type => 'ETH_TYPE'
3718: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3719: -- the effective start date of the person is between start date
3720: -- active and end date active in hr_lookups.
3721: --
3722: if hr_api.not_exists_in_dt_hr_lookups
3723: (p_effective_date => p_effective_date
3724: ,p_validation_start_date => p_validation_start_date
3725: ,p_validation_end_date => p_validation_end_date
3726: ,p_lookup_type => 'YES_NO'
3750: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3751: -- the effective start date of the person is between start date
3752: -- active and end date active in hr_lookups.
3753: --
3754: if hr_api.not_exists_in_dt_hr_lookups
3755: (p_effective_date => p_effective_date
3756: ,p_validation_start_date => p_validation_start_date
3757: ,p_validation_end_date => p_validation_end_date
3758: ,p_lookup_type => 'YES_NO'
3896: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3897: -- the effective start date of the person is between start date
3898: -- active and end date active in hr_lookups.
3899: --
3900: if hr_api.not_exists_in_dt_hr_lookups
3901: (p_effective_date => p_effective_date
3902: ,p_validation_start_date => p_validation_start_date
3903: ,p_validation_end_date => p_validation_end_date
3904: ,p_lookup_type => 'YES_NO'
3927: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
3928: -- the effective start date of the person is between start date
3929: -- active and end date active in hr_lookups.
3930: --
3931: if hr_api.not_exists_in_dt_hr_lookups
3932: (p_effective_date => p_effective_date
3933: ,p_validation_start_date => p_validation_start_date
3934: ,p_validation_end_date => p_validation_end_date
3935: ,p_lookup_type => 'YES_NO'
4274: end if;
4275: --
4276: -- Check the mandatory parameters
4277: --
4278: hr_api.mandatory_arg_error
4279: (p_api_name => l_proc
4280: ,p_argument => 'effective_date'
4281: ,p_argument_value => p_effective_date
4282: );
4280: ,p_argument => 'effective_date'
4281: ,p_argument_value => p_effective_date
4282: );
4283: --
4284: hr_api.mandatory_arg_error
4285: (p_api_name => l_proc
4286: ,p_argument => 'validation_start_date'
4287: ,p_argument_value => p_validation_start_date
4288: );
4286: ,p_argument => 'validation_start_date'
4287: ,p_argument_value => p_validation_start_date
4288: );
4289: --
4290: hr_api.mandatory_arg_error
4291: (p_api_name => l_proc
4292: ,p_argument => 'validation_end_date'
4293: ,p_argument_value => p_validation_end_date
4294: );
4301: --
4302: -- Check if the value for per information1 is set on insert or has
4303: -- changed on update.
4304: --
4305: if (((nvl(p_per_information1,hr_api.g_varchar2)
4306: <> nvl(per_per_shd.g_old_rec.per_information1,hr_api.g_varchar2)
4307: and p_api_updating)
4308: or (NOT p_api_updating))
4309: and p_per_information1 is not null)
4302: -- Check if the value for per information1 is set on insert or has
4303: -- changed on update.
4304: --
4305: if (((nvl(p_per_information1,hr_api.g_varchar2)
4306: <> nvl(per_per_shd.g_old_rec.per_information1,hr_api.g_varchar2)
4307: and p_api_updating)
4308: or (NOT p_api_updating))
4309: and p_per_information1 is not null)
4310: then
4313: -- lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
4314: -- and that the effective start date of the person is between start
4315: -- date active and end date active in hr_lookups.
4316: --
4317: if hr_api.not_exists_in_dt_hr_lookups
4318: (p_effective_date => p_effective_date
4319: ,p_validation_start_date => p_validation_start_date
4320: ,p_validation_end_date => p_validation_end_date
4321: ,p_lookup_type => 'US_ETHNIC_GROUP'
4338: --
4339: -- Check if the value for per information2 is set on insert or has
4340: -- changed on update.
4341: --
4342: if (((nvl(p_per_information2,hr_api.g_varchar2) <>
4343: nvl(per_per_shd.g_old_rec.per_information2,hr_api.g_varchar2)
4344: and p_api_updating) or
4345: (NOT p_api_updating)) and
4346: p_per_information2 is not null)
4339: -- Check if the value for per information2 is set on insert or has
4340: -- changed on update.
4341: --
4342: if (((nvl(p_per_information2,hr_api.g_varchar2) <>
4343: nvl(per_per_shd.g_old_rec.per_information2,hr_api.g_varchar2)
4344: and p_api_updating) or
4345: (NOT p_api_updating)) and
4346: p_per_information2 is not null)
4347: then
4350: -- lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y' and that
4351: -- the effective start date of the person is between start date
4352: -- active and end date active in hr_lookups.
4353: --
4354: if hr_api.not_exists_in_dt_hr_lookups
4355: (p_effective_date => p_effective_date
4356: ,p_validation_start_date => p_validation_start_date
4357: ,p_validation_end_date => p_validation_end_date
4358: ,p_lookup_type => 'PER_US_I9_STATE'
4375: --
4376: -- Check if the value for per information3 is set on insert or has
4377: -- changed on update.
4378: --
4379: if (((nvl(p_per_information3,hr_api.g_varchar2) <>
4380: nvl(per_per_shd.g_old_rec.per_information3,hr_api.g_varchar2)
4381: and p_api_updating) or
4382: (NOT p_api_updating)) and
4383: p_per_information3 is not null)
4376: -- Check if the value for per information3 is set on insert or has
4377: -- changed on update.
4378: --
4379: if (((nvl(p_per_information3,hr_api.g_varchar2) <>
4380: nvl(per_per_shd.g_old_rec.per_information3,hr_api.g_varchar2)
4381: and p_api_updating) or
4382: (NOT p_api_updating)) and
4383: p_per_information3 is not null)
4384: then
4401: --
4402: -- Check if the value for per information4 is set on insert or has
4403: -- changed on update.
4404: --
4405: if (((nvl(p_per_information4,hr_api.g_varchar2) <>
4406: nvl(per_per_shd.g_old_rec.per_information4,hr_api.g_varchar2)
4407: and p_api_updating) or
4408: (NOT p_api_updating)) and
4409: p_per_information4 is not null)
4402: -- Check if the value for per information4 is set on insert or has
4403: -- changed on update.
4404: --
4405: if (((nvl(p_per_information4,hr_api.g_varchar2) <>
4406: nvl(per_per_shd.g_old_rec.per_information4,hr_api.g_varchar2)
4407: and p_api_updating) or
4408: (NOT p_api_updating)) and
4409: p_per_information4 is not null)
4410: then
4413: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4414: -- and that the effective start date of the person is between start
4415: -- date active and end date active in hr_lookups.
4416: --
4417: if hr_api.not_exists_in_dt_hr_lookups
4418: (p_effective_date => p_effective_date
4419: ,p_validation_start_date => p_validation_start_date
4420: ,p_validation_end_date => p_validation_end_date
4421: ,p_lookup_type => 'US_VISA_TYPE'
4438: --
4439: -- Check if the value for per information5 is set on insert or has
4440: -- changed on update.
4441: --
4442: if (((nvl(p_per_information5,hr_api.g_varchar2) <>
4443: nvl(per_per_shd.g_old_rec.per_information5,hr_api.g_varchar2)
4444: and p_api_updating) or
4445: (NOT p_api_updating)) and
4446: p_per_information5 is not null)
4439: -- Check if the value for per information5 is set on insert or has
4440: -- changed on update.
4441: --
4442: if (((nvl(p_per_information5,hr_api.g_varchar2) <>
4443: nvl(per_per_shd.g_old_rec.per_information5,hr_api.g_varchar2)
4444: and p_api_updating) or
4445: (NOT p_api_updating)) and
4446: p_per_information5 is not null)
4447: then
4450: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
4451: -- and that the effective start date of the person is between start
4452: -- date active and end date active in hr_lookups.
4453: --
4454: if hr_api.not_exists_in_dt_hr_lookups
4455: (p_effective_date => p_effective_date
4456: ,p_validation_start_date => p_validation_start_date
4457: ,p_validation_end_date => p_validation_end_date
4458: ,p_lookup_type => 'US_VETERAN_STATUS'
4475: --
4476: -- Check if the value for per information6 is set on insert or has
4477: -- changed on update.
4478: --
4479: if (((nvl(p_per_information6,hr_api.g_varchar2) <>
4480: nvl(per_per_shd.g_old_rec.per_information6,hr_api.g_varchar2)
4481: and p_api_updating) or
4482: (NOT p_api_updating)) and
4483: p_per_information6 is not null)
4476: -- Check if the value for per information6 is set on insert or has
4477: -- changed on update.
4478: --
4479: if (((nvl(p_per_information6,hr_api.g_varchar2) <>
4480: nvl(per_per_shd.g_old_rec.per_information6,hr_api.g_varchar2)
4481: and p_api_updating) or
4482: (NOT p_api_updating)) and
4483: p_per_information6 is not null)
4484: then
4487: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4488: -- the effective start date of the person is between start date
4489: -- active and end date active in hr_lookups.
4490: --
4491: if hr_api.not_exists_in_dt_hr_lookups
4492: (p_effective_date => p_effective_date
4493: ,p_validation_start_date => p_validation_start_date
4494: ,p_validation_end_date => p_validation_end_date
4495: ,p_lookup_type => 'YES_NO'
4512: --
4513: -- Check if the value for per information7 is set on insert or has
4514: -- changed on update.
4515: --
4516: if (((nvl(p_per_information7,hr_api.g_varchar2) <>
4517: nvl(per_per_shd.g_old_rec.per_information7,hr_api.g_varchar2)
4518: and p_api_updating) or
4519: (NOT p_api_updating)) and
4520: p_per_information7 is not null)
4513: -- Check if the value for per information7 is set on insert or has
4514: -- changed on update.
4515: --
4516: if (((nvl(p_per_information7,hr_api.g_varchar2) <>
4517: nvl(per_per_shd.g_old_rec.per_information7,hr_api.g_varchar2)
4518: and p_api_updating) or
4519: (NOT p_api_updating)) and
4520: p_per_information7 is not null)
4521: then
4524: -- lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
4525: -- and that the effective start date of the person is between start
4526: -- date active and end date active in hr_lookups.
4527: --
4528: if hr_api.not_exists_in_dt_hr_lookups
4529: (p_effective_date => p_effective_date
4530: ,p_validation_start_date => p_validation_start_date
4531: ,p_validation_end_date => p_validation_end_date
4532: ,p_lookup_type => 'US_NEW_HIRE_STATUS'
4549: --
4550: -- Check if the value for per information8 is set on insert or has
4551: -- changed on update.
4552: --
4553: if (((nvl(p_per_information8,hr_api.g_varchar2) <>
4554: nvl(per_per_shd.g_old_rec.per_information8,hr_api.g_varchar2)
4555: and p_api_updating) or
4556: (NOT p_api_updating)) and
4557: p_per_information8 is not null)
4550: -- Check if the value for per information8 is set on insert or has
4551: -- changed on update.
4552: --
4553: if (((nvl(p_per_information8,hr_api.g_varchar2) <>
4554: nvl(per_per_shd.g_old_rec.per_information8,hr_api.g_varchar2)
4555: and p_api_updating) or
4556: (NOT p_api_updating)) and
4557: p_per_information8 is not null)
4558: then
4558: then
4559: --
4560: -- Check if per information7 is 'EXCL'
4561: --
4562: if nvl(p_per_information7,hr_api.g_varchar2) <> 'EXCL'
4563: then
4564: --
4565: -- Error: Field must be null because per_info7 is not 'EXCL'
4566: --
4572: -- lookup type 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y'
4573: -- and that the effective start date of the person is between start
4574: -- date active and end date active in hr_lookups.
4575: --
4576: if hr_api.not_exists_in_dt_hr_lookups
4577: (p_effective_date => p_effective_date
4578: ,p_validation_start_date => p_validation_start_date
4579: ,p_validation_end_date => p_validation_end_date
4580: ,p_lookup_type => 'US_NEW_HIRE_EXCEPTIONS'
4598: --
4599: -- Check if the value for per information9 is set on insert or has
4600: -- changed on update.
4601: --
4602: if (((nvl(p_per_information9,hr_api.g_varchar2) <>
4603: nvl(per_per_shd.g_old_rec.per_information9,hr_api.g_varchar2)
4604: and p_api_updating) or
4605: (NOT p_api_updating)) and
4606: p_per_information9 is not null)
4599: -- Check if the value for per information9 is set on insert or has
4600: -- changed on update.
4601: --
4602: if (((nvl(p_per_information9,hr_api.g_varchar2) <>
4603: nvl(per_per_shd.g_old_rec.per_information9,hr_api.g_varchar2)
4604: and p_api_updating) or
4605: (NOT p_api_updating)) and
4606: p_per_information9 is not null)
4607: then
4610: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4611: -- the effective start date of the person is between start date
4612: -- active and end date active in hr_lookups.
4613: --
4614: if hr_api.not_exists_in_dt_hr_lookups
4615: (p_effective_date => p_effective_date
4616: ,p_validation_start_date => p_validation_start_date
4617: ,p_validation_end_date => p_validation_end_date
4618: ,p_lookup_type => 'YES_NO'
4632: if g_debug then
4633: hr_utility.set_location( l_proc, 200);
4634: end if;
4635: --
4636: if (((nvl(p_per_information10,hr_api.g_varchar2) <>
4637: nvl(per_per_shd.g_old_rec.per_information10,hr_api.g_varchar2)
4638: and p_api_updating) or
4639: (NOT p_api_updating)) and
4640: p_per_information10 is not null)
4633: hr_utility.set_location( l_proc, 200);
4634: end if;
4635: --
4636: if (((nvl(p_per_information10,hr_api.g_varchar2) <>
4637: nvl(per_per_shd.g_old_rec.per_information10,hr_api.g_varchar2)
4638: and p_api_updating) or
4639: (NOT p_api_updating)) and
4640: p_per_information10 is not null)
4641: then
4644: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4645: -- the effective start date of the person is between start date
4646: -- active and end date active in hr_lookups.
4647: --
4648: if hr_api.not_exists_in_dt_hr_lookups
4649: (p_effective_date => p_effective_date
4650: ,p_validation_start_date => p_validation_start_date
4651: ,p_validation_end_date => p_validation_end_date
4652: ,p_lookup_type => 'YES_NO'
4808: end if;
4809: --
4810: -- Check the mandatory parameters
4811: --
4812: hr_api.mandatory_arg_error
4813: (p_api_name => l_proc
4814: ,p_argument => 'effective_date'
4815: ,p_argument_value => p_effective_date
4816: );
4814: ,p_argument => 'effective_date'
4815: ,p_argument_value => p_effective_date
4816: );
4817: --
4818: hr_api.mandatory_arg_error
4819: (p_api_name => l_proc
4820: ,p_argument => 'validation_start_date'
4821: ,p_argument_value => p_validation_start_date
4822: );
4820: ,p_argument => 'validation_start_date'
4821: ,p_argument_value => p_validation_start_date
4822: );
4823: --
4824: hr_api.mandatory_arg_error
4825: (p_api_name => l_proc
4826: ,p_argument => 'validation_end_date'
4827: ,p_argument_value => p_validation_end_date
4828: );
4842: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
4843: -- the effective start date of the person is between start date
4844: -- active and end date active in hr_lookups.
4845: --
4846: if hr_api.not_exists_in_dt_hr_lookups
4847: (p_effective_date => p_effective_date
4848: ,p_validation_start_date => p_validation_start_date
4849: ,p_validation_end_date => p_validation_end_date
4850: ,p_lookup_type => 'YES_NO'
4875: -- flag set to 'Y' and that
4876: -- the effective start date of the person is between start date
4877: -- active and end date active in hr_lookups.
4878: --
4879: if hr_api.not_exists_in_dt_hr_lookups
4880: (p_effective_date => p_effective_date
4881: ,p_validation_start_date => p_validation_start_date
4882: ,p_validation_end_date => p_validation_end_date
4883: ,p_lookup_type => 'JP_TERM_LOCAL_TAX_PAYMENT_TYPE'
4982: --
4983: if (p_rec.person_id is null)
4984: or ((p_rec.person_id is not null)
4985: and
4986: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
4987: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4988: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4983: if (p_rec.person_id is null)
4984: or ((p_rec.person_id is not null)
4985: and
4986: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
4987: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4988: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4984: or ((p_rec.person_id is not null)
4985: and
4986: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
4987: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4988: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4985: and
4986: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
4987: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4988: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4986: nvl(per_per_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
4987: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4988: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4987: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
4988: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4988: nvl(per_per_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4989: nvl(p_rec.per_information1, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4990: nvl(per_per_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4991: nvl(p_rec.per_information2, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
4992: nvl(per_per_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
4993: nvl(p_rec.per_information3, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
4994: nvl(per_per_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
4995: nvl(p_rec.per_information4, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
4996: nvl(per_per_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
4997: nvl(p_rec.per_information5, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
4998: nvl(per_per_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
4999: nvl(p_rec.per_information6, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5000: nvl(per_per_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5001: nvl(p_rec.per_information7, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5002: nvl(per_per_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5003: nvl(p_rec.per_information8, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5004: nvl(per_per_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5005: nvl(p_rec.per_information9, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5006: nvl(per_per_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5007: nvl(p_rec.per_information10, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5008: nvl(per_per_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5009: nvl(p_rec.per_information11, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5010: nvl(per_per_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5011: nvl(p_rec.per_information12, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5012: nvl(per_per_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5013: nvl(p_rec.per_information13, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5014: nvl(per_per_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5015: nvl(p_rec.per_information14, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5016: nvl(per_per_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5017: nvl(p_rec.per_information15, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5018: nvl(per_per_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5019: nvl(p_rec.per_information16, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5020: nvl(per_per_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5021: nvl(p_rec.per_information17, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5022: nvl(per_per_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5023: nvl(p_rec.per_information18, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5024: nvl(per_per_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5025: nvl(p_rec.per_information19, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5026: nvl(per_per_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5027: nvl(p_rec.per_information20, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5028: nvl(per_per_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5029: nvl(p_rec.per_information21, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5030: nvl(per_per_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5031: nvl(p_rec.per_information22, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5032: nvl(per_per_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5033: nvl(p_rec.per_information23, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5034: nvl(per_per_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5035: nvl(p_rec.per_information24, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5036: nvl(per_per_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5037: nvl(p_rec.per_information25, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5045: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5038: nvl(per_per_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5045: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5046: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
5039: nvl(p_rec.per_information26, hr_api.g_varchar2) or
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5045: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5046: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
5047: nvl(p_rec.per_information30, hr_api.g_varchar2))
5040: nvl(per_per_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5045: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5046: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
5047: nvl(p_rec.per_information30, hr_api.g_varchar2))
5048: then
5041: nvl(p_rec.per_information27, hr_api.g_varchar2) or
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5045: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5046: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
5047: nvl(p_rec.per_information30, hr_api.g_varchar2))
5048: then
5049: --
5042: nvl(per_per_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5045: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5046: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
5047: nvl(p_rec.per_information30, hr_api.g_varchar2))
5048: then
5049: --
5050: hr_dflex_utility.ins_or_upd_descflex_attribs
5043: nvl(p_rec.per_information28, hr_api.g_varchar2) or
5044: nvl(per_per_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
5045: nvl(p_rec.per_information29, hr_api.g_varchar2) or
5046: nvl(per_per_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
5047: nvl(p_rec.per_information30, hr_api.g_varchar2))
5048: then
5049: --
5050: hr_dflex_utility.ins_or_upd_descflex_attribs
5051: (p_appl_short_name => 'PER'
5200: end if;
5201: --
5202: -- Check mandatory parameters have been set
5203: --
5204: hr_api.mandatory_arg_error
5205: (p_api_name => l_proc
5206: ,p_argument => 'effective date'
5207: ,p_argument_value => p_effective_date
5208: );
5206: ,p_argument => 'effective date'
5207: ,p_argument_value => p_effective_date
5208: );
5209: --
5210: hr_api.mandatory_arg_error
5211: (p_api_name => l_proc
5212: ,p_argument => 'validation_start_date'
5213: ,p_argument_value => p_validation_start_date
5214: );
5212: ,p_argument => 'validation_start_date'
5213: ,p_argument_value => p_validation_start_date
5214: );
5215: --
5216: hr_api.mandatory_arg_error
5217: (p_api_name => l_proc
5218: ,p_argument => 'validation_end_date'
5219: ,p_argument_value => p_validation_end_date
5220: );
5237: hr_utility.set_location(l_proc, 30);
5238: end if;
5239: --
5240: if ((l_api_updating and nvl(per_per_shd.g_old_rec.per_information_category,
5241: hr_api.g_varchar2)
5242: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
5243: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5244: hr_api.g_varchar2)
5245: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5238: end if;
5239: --
5240: if ((l_api_updating and nvl(per_per_shd.g_old_rec.per_information_category,
5241: hr_api.g_varchar2)
5242: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
5243: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5244: hr_api.g_varchar2)
5245: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5246: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5240: if ((l_api_updating and nvl(per_per_shd.g_old_rec.per_information_category,
5241: hr_api.g_varchar2)
5242: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
5243: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5244: hr_api.g_varchar2)
5245: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5246: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5247: hr_api.g_varchar2)
5248: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5241: hr_api.g_varchar2)
5242: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
5243: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5244: hr_api.g_varchar2)
5245: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5246: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5247: hr_api.g_varchar2)
5248: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5249: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5243: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5244: hr_api.g_varchar2)
5245: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5246: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5247: hr_api.g_varchar2)
5248: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5249: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5250: hr_api.g_varchar2)
5251: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5244: hr_api.g_varchar2)
5245: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
5246: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5247: hr_api.g_varchar2)
5248: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5249: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5250: hr_api.g_varchar2)
5251: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5252: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5246: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5247: hr_api.g_varchar2)
5248: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5249: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5250: hr_api.g_varchar2)
5251: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5252: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5253: hr_api.g_varchar2)
5254: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5247: hr_api.g_varchar2)
5248: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
5249: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5250: hr_api.g_varchar2)
5251: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5252: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5253: hr_api.g_varchar2)
5254: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5255: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5249: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5250: hr_api.g_varchar2)
5251: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5252: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5253: hr_api.g_varchar2)
5254: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5255: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5256: hr_api.g_varchar2)
5257: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5250: hr_api.g_varchar2)
5251: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
5252: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5253: hr_api.g_varchar2)
5254: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5255: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5256: hr_api.g_varchar2)
5257: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5258: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5252: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5253: hr_api.g_varchar2)
5254: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5255: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5256: hr_api.g_varchar2)
5257: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5258: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5259: hr_api.g_varchar2)
5260: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5253: hr_api.g_varchar2)
5254: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
5255: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5256: hr_api.g_varchar2)
5257: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5258: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5259: hr_api.g_varchar2)
5260: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5261: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5255: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5256: hr_api.g_varchar2)
5257: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5258: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5259: hr_api.g_varchar2)
5260: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5261: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5262: hr_api.g_varchar2)
5263: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5256: hr_api.g_varchar2)
5257: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
5258: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5259: hr_api.g_varchar2)
5260: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5261: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5262: hr_api.g_varchar2)
5263: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5264: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5258: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5259: hr_api.g_varchar2)
5260: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5261: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5262: hr_api.g_varchar2)
5263: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5264: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5265: hr_api.g_varchar2)
5266: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5259: hr_api.g_varchar2)
5260: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
5261: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5262: hr_api.g_varchar2)
5263: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5264: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5265: hr_api.g_varchar2)
5266: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5267: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5261: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5262: hr_api.g_varchar2)
5263: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5264: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5265: hr_api.g_varchar2)
5266: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5267: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5268: hr_api.g_varchar2)
5269: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5262: hr_api.g_varchar2)
5263: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
5264: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5265: hr_api.g_varchar2)
5266: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5267: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5268: hr_api.g_varchar2)
5269: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5270: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5264: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5265: hr_api.g_varchar2)
5266: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5267: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5268: hr_api.g_varchar2)
5269: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5270: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5271: hr_api.g_varchar2)
5272: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5265: hr_api.g_varchar2)
5266: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
5267: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5268: hr_api.g_varchar2)
5269: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5270: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5271: hr_api.g_varchar2)
5272: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5273: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5267: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5268: hr_api.g_varchar2)
5269: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5270: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5271: hr_api.g_varchar2)
5272: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5273: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5274: hr_api.g_varchar2)
5275: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5268: hr_api.g_varchar2)
5269: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
5270: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5271: hr_api.g_varchar2)
5272: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5273: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5274: hr_api.g_varchar2)
5275: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5276: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5270: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5271: hr_api.g_varchar2)
5272: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5273: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5274: hr_api.g_varchar2)
5275: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5276: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5277: hr_api.g_varchar2)
5278: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5271: hr_api.g_varchar2)
5272: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
5273: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5274: hr_api.g_varchar2)
5275: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5276: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5277: hr_api.g_varchar2)
5278: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5279: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5273: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5274: hr_api.g_varchar2)
5275: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5276: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5277: hr_api.g_varchar2)
5278: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5279: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5280: hr_api.g_varchar2)
5281: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5274: hr_api.g_varchar2)
5275: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
5276: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5277: hr_api.g_varchar2)
5278: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5279: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5280: hr_api.g_varchar2)
5281: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5282: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5276: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5277: hr_api.g_varchar2)
5278: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5279: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5280: hr_api.g_varchar2)
5281: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5282: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5283: hr_api.g_varchar2)
5284: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5277: hr_api.g_varchar2)
5278: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
5279: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5280: hr_api.g_varchar2)
5281: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5282: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5283: hr_api.g_varchar2)
5284: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5285: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5279: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5280: hr_api.g_varchar2)
5281: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5282: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5283: hr_api.g_varchar2)
5284: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5285: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5286: hr_api.g_varchar2)
5287: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5280: hr_api.g_varchar2)
5281: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
5282: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5283: hr_api.g_varchar2)
5284: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5285: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5286: hr_api.g_varchar2)
5287: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5288: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5282: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5283: hr_api.g_varchar2)
5284: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5285: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5286: hr_api.g_varchar2)
5287: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5288: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5289: hr_api.g_varchar2)
5290: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5283: hr_api.g_varchar2)
5284: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
5285: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5286: hr_api.g_varchar2)
5287: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5288: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5289: hr_api.g_varchar2)
5290: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5291: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5285: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5286: hr_api.g_varchar2)
5287: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5288: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5289: hr_api.g_varchar2)
5290: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5291: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5292: hr_api.g_varchar2)
5293: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5286: hr_api.g_varchar2)
5287: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
5288: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5289: hr_api.g_varchar2)
5290: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5291: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5292: hr_api.g_varchar2)
5293: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5294: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5288: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5289: hr_api.g_varchar2)
5290: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5291: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5292: hr_api.g_varchar2)
5293: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5294: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5295: hr_api.g_varchar2)
5296: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5289: hr_api.g_varchar2)
5290: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
5291: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5292: hr_api.g_varchar2)
5293: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5294: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5295: hr_api.g_varchar2)
5296: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5297: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5291: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5292: hr_api.g_varchar2)
5293: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5294: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5295: hr_api.g_varchar2)
5296: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5297: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5298: hr_api.g_varchar2)
5299: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5292: hr_api.g_varchar2)
5293: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
5294: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5295: hr_api.g_varchar2)
5296: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5297: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5298: hr_api.g_varchar2)
5299: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5300: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5294: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5295: hr_api.g_varchar2)
5296: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5297: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5298: hr_api.g_varchar2)
5299: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5300: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5301: hr_api.g_varchar2)
5302: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5295: hr_api.g_varchar2)
5296: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
5297: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5298: hr_api.g_varchar2)
5299: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5300: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5301: hr_api.g_varchar2)
5302: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5303: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5297: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5298: hr_api.g_varchar2)
5299: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5300: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5301: hr_api.g_varchar2)
5302: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5303: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5304: hr_api.g_varchar2)
5305: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5298: hr_api.g_varchar2)
5299: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
5300: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5301: hr_api.g_varchar2)
5302: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5303: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5304: hr_api.g_varchar2)
5305: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5306: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5300: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5301: hr_api.g_varchar2)
5302: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5303: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5304: hr_api.g_varchar2)
5305: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5306: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5307: hr_api.g_varchar2)
5308: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5301: hr_api.g_varchar2)
5302: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
5303: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5304: hr_api.g_varchar2)
5305: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5306: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5307: hr_api.g_varchar2)
5308: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5309: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5303: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5304: hr_api.g_varchar2)
5305: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5306: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5307: hr_api.g_varchar2)
5308: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5309: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5310: hr_api.g_varchar2)
5311: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5304: hr_api.g_varchar2)
5305: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
5306: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5307: hr_api.g_varchar2)
5308: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5309: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5310: hr_api.g_varchar2)
5311: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5312: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5306: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5307: hr_api.g_varchar2)
5308: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5309: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5310: hr_api.g_varchar2)
5311: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5312: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5313: hr_api.g_varchar2)
5314: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5307: hr_api.g_varchar2)
5308: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
5309: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5310: hr_api.g_varchar2)
5311: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5312: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5313: hr_api.g_varchar2)
5314: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5315: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5309: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5310: hr_api.g_varchar2)
5311: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5312: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5313: hr_api.g_varchar2)
5314: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5315: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5316: hr_api.g_varchar2)
5317: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5310: hr_api.g_varchar2)
5311: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
5312: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5313: hr_api.g_varchar2)
5314: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5315: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5316: hr_api.g_varchar2)
5317: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5318: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5312: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5313: hr_api.g_varchar2)
5314: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5315: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5316: hr_api.g_varchar2)
5317: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5318: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5319: hr_api.g_varchar2)
5320: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5313: hr_api.g_varchar2)
5314: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
5315: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5316: hr_api.g_varchar2)
5317: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5318: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5319: hr_api.g_varchar2)
5320: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5321: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5315: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5316: hr_api.g_varchar2)
5317: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5318: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5319: hr_api.g_varchar2)
5320: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5321: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5322: hr_api.g_varchar2)
5323: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5316: hr_api.g_varchar2)
5317: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
5318: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5319: hr_api.g_varchar2)
5320: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5321: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5322: hr_api.g_varchar2)
5323: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5324: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5318: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5319: hr_api.g_varchar2)
5320: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5321: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5322: hr_api.g_varchar2)
5323: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5324: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5325: hr_api.g_varchar2)
5326: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5319: hr_api.g_varchar2)
5320: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
5321: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5322: hr_api.g_varchar2)
5323: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5324: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5325: hr_api.g_varchar2)
5326: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5327: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5321: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5322: hr_api.g_varchar2)
5323: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5324: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5325: hr_api.g_varchar2)
5326: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5327: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5328: hr_api.g_varchar2)
5329: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
5322: hr_api.g_varchar2)
5323: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
5324: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5325: hr_api.g_varchar2)
5326: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5327: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5328: hr_api.g_varchar2)
5329: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
5330: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5324: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5325: hr_api.g_varchar2)
5326: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5327: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5328: hr_api.g_varchar2)
5329: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
5330: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5331: hr_api.g_varchar2)
5332: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
5325: hr_api.g_varchar2)
5326: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
5327: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5328: hr_api.g_varchar2)
5329: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
5330: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5331: hr_api.g_varchar2)
5332: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
5333: (NOT l_api_updating))
5327: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5328: hr_api.g_varchar2)
5329: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
5330: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5331: hr_api.g_varchar2)
5332: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
5333: (NOT l_api_updating))
5334: then
5335: if g_debug then
5328: hr_api.g_varchar2)
5329: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
5330: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5331: hr_api.g_varchar2)
5332: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
5333: (NOT l_api_updating))
5334: then
5335: if g_debug then
5336: hr_utility.set_location(l_proc, 40);
5571: hr_utility.set_location(l_proc, 2);
5572: end if;
5573: --
5574: if ((l_api_updating
5575: and nvl(per_per_shd.g_old_rec.last_name, hr_api.g_varchar2)
5576: <> nvl(p_last_name,hr_api.g_varchar2))
5577: or
5578: (NOT l_api_updating)) then
5579: --
5572: end if;
5573: --
5574: if ((l_api_updating
5575: and nvl(per_per_shd.g_old_rec.last_name, hr_api.g_varchar2)
5576: <> nvl(p_last_name,hr_api.g_varchar2))
5577: or
5578: (NOT l_api_updating)) then
5579: --
5580: -- Perform Insert/Update checks
5594: hr_utility.set_location(l_proc, 3);
5595: end if;
5596: --
5597: if ((l_api_updating
5598: and nvl(per_per_shd.g_old_rec.first_name, hr_api.g_varchar2)
5599: <> nvl(p_first_name,hr_api.g_varchar2))
5600: or
5601: (NOT l_api_updating)) then
5602: --
5595: end if;
5596: --
5597: if ((l_api_updating
5598: and nvl(per_per_shd.g_old_rec.first_name, hr_api.g_varchar2)
5599: <> nvl(p_first_name,hr_api.g_varchar2))
5600: or
5601: (NOT l_api_updating)) then
5602: --
5603: -- Perform Insert/Update checks
5779: end if;
5780: --
5781: -- Check mandatory parameters have been set
5782: --
5783: hr_api.mandatory_arg_error
5784: (p_api_name => l_proc
5785: ,p_argument => 'business group id'
5786: ,p_argument_value => p_business_group_id
5787: );
5785: ,p_argument => 'business group id'
5786: ,p_argument_value => p_business_group_id
5787: );
5788: --
5789: hr_api.mandatory_arg_error
5790: (p_api_name => l_proc
5791: ,p_argument => 'effective date'
5792: ,p_argument_value => p_effective_date
5793: );
5823: ,p_effective_date => p_effective_date
5824: ,p_object_version_number => p_object_version_number);
5825: --
5826: if ((l_api_updating and nvl(per_per_shd.g_old_rec.last_name,
5827: hr_api.g_varchar2)
5828: <> nvl(p_last_name,hr_api.g_varchar2)) or
5829: (l_api_updating and nvl(per_per_shd.g_old_rec.title,
5830: hr_api.g_varchar2)
5831: <> nvl(p_title,hr_api.g_varchar2)) or
5824: ,p_object_version_number => p_object_version_number);
5825: --
5826: if ((l_api_updating and nvl(per_per_shd.g_old_rec.last_name,
5827: hr_api.g_varchar2)
5828: <> nvl(p_last_name,hr_api.g_varchar2)) or
5829: (l_api_updating and nvl(per_per_shd.g_old_rec.title,
5830: hr_api.g_varchar2)
5831: <> nvl(p_title,hr_api.g_varchar2)) or
5832: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5826: if ((l_api_updating and nvl(per_per_shd.g_old_rec.last_name,
5827: hr_api.g_varchar2)
5828: <> nvl(p_last_name,hr_api.g_varchar2)) or
5829: (l_api_updating and nvl(per_per_shd.g_old_rec.title,
5830: hr_api.g_varchar2)
5831: <> nvl(p_title,hr_api.g_varchar2)) or
5832: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5833: hr_api.g_varchar2)
5834: <> nvl(p_first_name,hr_api.g_varchar2)) or
5827: hr_api.g_varchar2)
5828: <> nvl(p_last_name,hr_api.g_varchar2)) or
5829: (l_api_updating and nvl(per_per_shd.g_old_rec.title,
5830: hr_api.g_varchar2)
5831: <> nvl(p_title,hr_api.g_varchar2)) or
5832: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5833: hr_api.g_varchar2)
5834: <> nvl(p_first_name,hr_api.g_varchar2)) or
5835: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5829: (l_api_updating and nvl(per_per_shd.g_old_rec.title,
5830: hr_api.g_varchar2)
5831: <> nvl(p_title,hr_api.g_varchar2)) or
5832: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5833: hr_api.g_varchar2)
5834: <> nvl(p_first_name,hr_api.g_varchar2)) or
5835: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5836: hr_api.g_varchar2)
5837: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5830: hr_api.g_varchar2)
5831: <> nvl(p_title,hr_api.g_varchar2)) or
5832: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5833: hr_api.g_varchar2)
5834: <> nvl(p_first_name,hr_api.g_varchar2)) or
5835: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5836: hr_api.g_varchar2)
5837: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5838: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5832: (l_api_updating and nvl(per_per_shd.g_old_rec.first_name,
5833: hr_api.g_varchar2)
5834: <> nvl(p_first_name,hr_api.g_varchar2)) or
5835: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5836: hr_api.g_varchar2)
5837: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5838: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5839: hr_api.g_varchar2)
5840: <> nvl(p_suffix,hr_api.g_varchar2)) or
5833: hr_api.g_varchar2)
5834: <> nvl(p_first_name,hr_api.g_varchar2)) or
5835: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5836: hr_api.g_varchar2)
5837: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5838: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5839: hr_api.g_varchar2)
5840: <> nvl(p_suffix,hr_api.g_varchar2)) or
5841: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5835: (l_api_updating and nvl(per_per_shd.g_old_rec.middle_names,
5836: hr_api.g_varchar2)
5837: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5838: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5839: hr_api.g_varchar2)
5840: <> nvl(p_suffix,hr_api.g_varchar2)) or
5841: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5842: hr_api.g_varchar2)
5843: <> nvl(p_known_as,hr_api.g_varchar2)) or
5836: hr_api.g_varchar2)
5837: <> nvl(p_middle_names,hr_api.g_varchar2)) or
5838: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5839: hr_api.g_varchar2)
5840: <> nvl(p_suffix,hr_api.g_varchar2)) or
5841: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5842: hr_api.g_varchar2)
5843: <> nvl(p_known_as,hr_api.g_varchar2)) or
5844: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5838: (l_api_updating and nvl(per_per_shd.g_old_rec.suffix,
5839: hr_api.g_varchar2)
5840: <> nvl(p_suffix,hr_api.g_varchar2)) or
5841: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5842: hr_api.g_varchar2)
5843: <> nvl(p_known_as,hr_api.g_varchar2)) or
5844: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5845: hr_api.g_date)
5846: <> nvl(p_date_of_birth,hr_api.g_date)) or
5839: hr_api.g_varchar2)
5840: <> nvl(p_suffix,hr_api.g_varchar2)) or
5841: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5842: hr_api.g_varchar2)
5843: <> nvl(p_known_as,hr_api.g_varchar2)) or
5844: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5845: hr_api.g_date)
5846: <> nvl(p_date_of_birth,hr_api.g_date)) or
5847: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5841: (l_api_updating and nvl(per_per_shd.g_old_rec.known_as,
5842: hr_api.g_varchar2)
5843: <> nvl(p_known_as,hr_api.g_varchar2)) or
5844: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5845: hr_api.g_date)
5846: <> nvl(p_date_of_birth,hr_api.g_date)) or
5847: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5848: hr_api.g_varchar2)
5849: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5842: hr_api.g_varchar2)
5843: <> nvl(p_known_as,hr_api.g_varchar2)) or
5844: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5845: hr_api.g_date)
5846: <> nvl(p_date_of_birth,hr_api.g_date)) or
5847: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5848: hr_api.g_varchar2)
5849: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5850: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5844: (l_api_updating and nvl(per_per_shd.g_old_rec.date_of_birth,
5845: hr_api.g_date)
5846: <> nvl(p_date_of_birth,hr_api.g_date)) or
5847: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5848: hr_api.g_varchar2)
5849: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5850: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5851: hr_api.g_varchar2)
5852: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5845: hr_api.g_date)
5846: <> nvl(p_date_of_birth,hr_api.g_date)) or
5847: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5848: hr_api.g_varchar2)
5849: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5850: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5851: hr_api.g_varchar2)
5852: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5853: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5847: (l_api_updating and nvl(per_per_shd.g_old_rec.pre_name_adjunct,
5848: hr_api.g_varchar2)
5849: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5850: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5851: hr_api.g_varchar2)
5852: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5853: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5854: hr_api.g_varchar2)
5855: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5848: hr_api.g_varchar2)
5849: <> nvl(p_pre_name_adjunct,hr_api.g_varchar2)) or
5850: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5851: hr_api.g_varchar2)
5852: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5853: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5854: hr_api.g_varchar2)
5855: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5856: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5850: (l_api_updating and nvl(per_per_shd.g_old_rec.employee_number,
5851: hr_api.g_varchar2)
5852: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5853: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5854: hr_api.g_varchar2)
5855: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5856: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5857: hr_api.g_varchar2)
5858: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5851: hr_api.g_varchar2)
5852: <> nvl(p_employee_number,hr_api.g_varchar2)) or
5853: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5854: hr_api.g_varchar2)
5855: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5856: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5857: hr_api.g_varchar2)
5858: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5859: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5853: (l_api_updating and nvl(per_per_shd.g_old_rec.applicant_number,
5854: hr_api.g_varchar2)
5855: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5856: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5857: hr_api.g_varchar2)
5858: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5859: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5860: hr_api.g_varchar2)
5861: <> nvl(p_email_address,hr_api.g_varchar2)) or
5854: hr_api.g_varchar2)
5855: <> nvl(p_applicant_number,hr_api.g_varchar2)) or
5856: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5857: hr_api.g_varchar2)
5858: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5859: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5860: hr_api.g_varchar2)
5861: <> nvl(p_email_address,hr_api.g_varchar2)) or
5862: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5856: (l_api_updating and nvl(per_per_shd.g_old_rec.npw_number,
5857: hr_api.g_varchar2)
5858: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5859: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5860: hr_api.g_varchar2)
5861: <> nvl(p_email_address,hr_api.g_varchar2)) or
5862: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5863: hr_api.g_varchar2)
5864: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5857: hr_api.g_varchar2)
5858: <> nvl(p_npw_number,hr_api.g_varchar2)) or
5859: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5860: hr_api.g_varchar2)
5861: <> nvl(p_email_address,hr_api.g_varchar2)) or
5862: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5863: hr_api.g_varchar2)
5864: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5865: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5859: (l_api_updating and nvl(per_per_shd.g_old_rec.email_address,
5860: hr_api.g_varchar2)
5861: <> nvl(p_email_address,hr_api.g_varchar2)) or
5862: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5863: hr_api.g_varchar2)
5864: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5865: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5866: hr_api.g_varchar2)
5867: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5860: hr_api.g_varchar2)
5861: <> nvl(p_email_address,hr_api.g_varchar2)) or
5862: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5863: hr_api.g_varchar2)
5864: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5865: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5866: hr_api.g_varchar2)
5867: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5868: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5862: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information1,
5863: hr_api.g_varchar2)
5864: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5865: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5866: hr_api.g_varchar2)
5867: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5868: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5869: hr_api.g_varchar2)
5870: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5863: hr_api.g_varchar2)
5864: <> nvl(p_per_information1,hr_api.g_varchar2)) or
5865: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5866: hr_api.g_varchar2)
5867: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5868: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5869: hr_api.g_varchar2)
5870: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5871: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5865: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information2,
5866: hr_api.g_varchar2)
5867: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5868: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5869: hr_api.g_varchar2)
5870: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5871: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5872: hr_api.g_varchar2)
5873: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5866: hr_api.g_varchar2)
5867: <> nvl(p_per_information2,hr_api.g_varchar2)) or
5868: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5869: hr_api.g_varchar2)
5870: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5871: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5872: hr_api.g_varchar2)
5873: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5874: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5868: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information3,
5869: hr_api.g_varchar2)
5870: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5871: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5872: hr_api.g_varchar2)
5873: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5874: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5875: hr_api.g_varchar2)
5876: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5869: hr_api.g_varchar2)
5870: <> nvl(p_per_information3,hr_api.g_varchar2)) or
5871: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5872: hr_api.g_varchar2)
5873: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5874: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5875: hr_api.g_varchar2)
5876: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5877: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5871: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information4,
5872: hr_api.g_varchar2)
5873: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5874: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5875: hr_api.g_varchar2)
5876: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5877: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5878: hr_api.g_varchar2)
5879: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5872: hr_api.g_varchar2)
5873: <> nvl(p_per_information4,hr_api.g_varchar2)) or
5874: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5875: hr_api.g_varchar2)
5876: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5877: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5878: hr_api.g_varchar2)
5879: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5880: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5874: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information5,
5875: hr_api.g_varchar2)
5876: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5877: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5878: hr_api.g_varchar2)
5879: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5880: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5881: hr_api.g_varchar2)
5882: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5875: hr_api.g_varchar2)
5876: <> nvl(p_per_information5,hr_api.g_varchar2)) or
5877: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5878: hr_api.g_varchar2)
5879: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5880: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5881: hr_api.g_varchar2)
5882: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5883: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5877: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information6,
5878: hr_api.g_varchar2)
5879: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5880: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5881: hr_api.g_varchar2)
5882: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5883: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5884: hr_api.g_varchar2)
5885: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5878: hr_api.g_varchar2)
5879: <> nvl(p_per_information6,hr_api.g_varchar2)) or
5880: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5881: hr_api.g_varchar2)
5882: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5883: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5884: hr_api.g_varchar2)
5885: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5886: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5880: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information7,
5881: hr_api.g_varchar2)
5882: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5883: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5884: hr_api.g_varchar2)
5885: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5886: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5887: hr_api.g_varchar2)
5888: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5881: hr_api.g_varchar2)
5882: <> nvl(p_per_information7,hr_api.g_varchar2)) or
5883: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5884: hr_api.g_varchar2)
5885: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5886: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5887: hr_api.g_varchar2)
5888: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5889: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5883: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information8,
5884: hr_api.g_varchar2)
5885: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5886: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5887: hr_api.g_varchar2)
5888: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5889: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5890: hr_api.g_varchar2)
5891: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5884: hr_api.g_varchar2)
5885: <> nvl(p_per_information8,hr_api.g_varchar2)) or
5886: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5887: hr_api.g_varchar2)
5888: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5889: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5890: hr_api.g_varchar2)
5891: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5892: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5886: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information9,
5887: hr_api.g_varchar2)
5888: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5889: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5890: hr_api.g_varchar2)
5891: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5892: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5893: hr_api.g_varchar2)
5894: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5887: hr_api.g_varchar2)
5888: <> nvl(p_per_information9,hr_api.g_varchar2)) or
5889: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5890: hr_api.g_varchar2)
5891: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5892: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5893: hr_api.g_varchar2)
5894: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5895: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5889: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information10,
5890: hr_api.g_varchar2)
5891: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5892: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5893: hr_api.g_varchar2)
5894: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5895: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5896: hr_api.g_varchar2)
5897: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5890: hr_api.g_varchar2)
5891: <> nvl(p_per_information10,hr_api.g_varchar2)) or
5892: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5893: hr_api.g_varchar2)
5894: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5895: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5896: hr_api.g_varchar2)
5897: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5898: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5892: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information11,
5893: hr_api.g_varchar2)
5894: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5895: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5896: hr_api.g_varchar2)
5897: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5898: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5899: hr_api.g_varchar2)
5900: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5893: hr_api.g_varchar2)
5894: <> nvl(p_per_information11,hr_api.g_varchar2)) or
5895: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5896: hr_api.g_varchar2)
5897: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5898: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5899: hr_api.g_varchar2)
5900: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5901: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5895: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information12,
5896: hr_api.g_varchar2)
5897: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5898: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5899: hr_api.g_varchar2)
5900: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5901: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5902: hr_api.g_varchar2)
5903: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5896: hr_api.g_varchar2)
5897: <> nvl(p_per_information12,hr_api.g_varchar2)) or
5898: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5899: hr_api.g_varchar2)
5900: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5901: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5902: hr_api.g_varchar2)
5903: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5904: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5898: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information13,
5899: hr_api.g_varchar2)
5900: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5901: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5902: hr_api.g_varchar2)
5903: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5904: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5905: hr_api.g_varchar2)
5906: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5899: hr_api.g_varchar2)
5900: <> nvl(p_per_information13,hr_api.g_varchar2)) or
5901: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5902: hr_api.g_varchar2)
5903: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5904: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5905: hr_api.g_varchar2)
5906: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5907: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5901: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information14,
5902: hr_api.g_varchar2)
5903: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5904: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5905: hr_api.g_varchar2)
5906: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5907: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5908: hr_api.g_varchar2)
5909: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5902: hr_api.g_varchar2)
5903: <> nvl(p_per_information14,hr_api.g_varchar2)) or
5904: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5905: hr_api.g_varchar2)
5906: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5907: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5908: hr_api.g_varchar2)
5909: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5910: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5904: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information15,
5905: hr_api.g_varchar2)
5906: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5907: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5908: hr_api.g_varchar2)
5909: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5910: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5911: hr_api.g_varchar2)
5912: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5905: hr_api.g_varchar2)
5906: <> nvl(p_per_information15,hr_api.g_varchar2)) or
5907: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5908: hr_api.g_varchar2)
5909: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5910: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5911: hr_api.g_varchar2)
5912: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5913: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5907: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information16,
5908: hr_api.g_varchar2)
5909: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5910: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5911: hr_api.g_varchar2)
5912: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5913: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5914: hr_api.g_varchar2)
5915: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5908: hr_api.g_varchar2)
5909: <> nvl(p_per_information16,hr_api.g_varchar2)) or
5910: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5911: hr_api.g_varchar2)
5912: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5913: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5914: hr_api.g_varchar2)
5915: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5916: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5910: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information17,
5911: hr_api.g_varchar2)
5912: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5913: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5914: hr_api.g_varchar2)
5915: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5916: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5917: hr_api.g_varchar2)
5918: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5911: hr_api.g_varchar2)
5912: <> nvl(p_per_information17,hr_api.g_varchar2)) or
5913: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5914: hr_api.g_varchar2)
5915: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5916: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5917: hr_api.g_varchar2)
5918: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5919: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5913: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information18,
5914: hr_api.g_varchar2)
5915: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5916: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5917: hr_api.g_varchar2)
5918: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5919: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5920: hr_api.g_varchar2)
5921: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5914: hr_api.g_varchar2)
5915: <> nvl(p_per_information18,hr_api.g_varchar2)) or
5916: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5917: hr_api.g_varchar2)
5918: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5919: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5920: hr_api.g_varchar2)
5921: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5922: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5916: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information19,
5917: hr_api.g_varchar2)
5918: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5919: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5920: hr_api.g_varchar2)
5921: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5922: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5923: hr_api.g_varchar2)
5924: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5917: hr_api.g_varchar2)
5918: <> nvl(p_per_information19,hr_api.g_varchar2)) or
5919: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5920: hr_api.g_varchar2)
5921: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5922: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5923: hr_api.g_varchar2)
5924: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5925: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5919: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information20,
5920: hr_api.g_varchar2)
5921: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5922: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5923: hr_api.g_varchar2)
5924: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5925: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5926: hr_api.g_varchar2)
5927: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5920: hr_api.g_varchar2)
5921: <> nvl(p_per_information20,hr_api.g_varchar2)) or
5922: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5923: hr_api.g_varchar2)
5924: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5925: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5926: hr_api.g_varchar2)
5927: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5928: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5922: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information21,
5923: hr_api.g_varchar2)
5924: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5925: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5926: hr_api.g_varchar2)
5927: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5928: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5929: hr_api.g_varchar2)
5930: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5923: hr_api.g_varchar2)
5924: <> nvl(p_per_information21,hr_api.g_varchar2)) or
5925: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5926: hr_api.g_varchar2)
5927: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5928: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5929: hr_api.g_varchar2)
5930: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5931: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5925: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information22,
5926: hr_api.g_varchar2)
5927: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5928: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5929: hr_api.g_varchar2)
5930: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5931: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5932: hr_api.g_varchar2)
5933: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5926: hr_api.g_varchar2)
5927: <> nvl(p_per_information22,hr_api.g_varchar2)) or
5928: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5929: hr_api.g_varchar2)
5930: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5931: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5932: hr_api.g_varchar2)
5933: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5934: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5928: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information23,
5929: hr_api.g_varchar2)
5930: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5931: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5932: hr_api.g_varchar2)
5933: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5934: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5935: hr_api.g_varchar2)
5936: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5929: hr_api.g_varchar2)
5930: <> nvl(p_per_information23,hr_api.g_varchar2)) or
5931: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5932: hr_api.g_varchar2)
5933: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5934: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5935: hr_api.g_varchar2)
5936: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5937: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5931: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information24,
5932: hr_api.g_varchar2)
5933: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5934: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5935: hr_api.g_varchar2)
5936: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5937: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5938: hr_api.g_varchar2)
5939: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5932: hr_api.g_varchar2)
5933: <> nvl(p_per_information24,hr_api.g_varchar2)) or
5934: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5935: hr_api.g_varchar2)
5936: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5937: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5938: hr_api.g_varchar2)
5939: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5940: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5934: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information25,
5935: hr_api.g_varchar2)
5936: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5937: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5938: hr_api.g_varchar2)
5939: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5940: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5941: hr_api.g_varchar2)
5942: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5935: hr_api.g_varchar2)
5936: <> nvl(p_per_information25,hr_api.g_varchar2)) or
5937: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5938: hr_api.g_varchar2)
5939: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5940: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5941: hr_api.g_varchar2)
5942: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5943: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5937: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information26,
5938: hr_api.g_varchar2)
5939: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5940: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5941: hr_api.g_varchar2)
5942: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5943: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5944: hr_api.g_varchar2)
5945: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5938: hr_api.g_varchar2)
5939: <> nvl(p_per_information26,hr_api.g_varchar2)) or
5940: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5941: hr_api.g_varchar2)
5942: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5943: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5944: hr_api.g_varchar2)
5945: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5946: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5940: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information27,
5941: hr_api.g_varchar2)
5942: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5943: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5944: hr_api.g_varchar2)
5945: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5946: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5947: hr_api.g_varchar2)
5948: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5941: hr_api.g_varchar2)
5942: <> nvl(p_per_information27,hr_api.g_varchar2)) or
5943: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5944: hr_api.g_varchar2)
5945: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5946: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5947: hr_api.g_varchar2)
5948: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5949: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5943: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information28,
5944: hr_api.g_varchar2)
5945: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5946: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5947: hr_api.g_varchar2)
5948: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5949: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5950: hr_api.g_varchar2)
5951: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5944: hr_api.g_varchar2)
5945: <> nvl(p_per_information28,hr_api.g_varchar2)) or
5946: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5947: hr_api.g_varchar2)
5948: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5949: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5950: hr_api.g_varchar2)
5951: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5952: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5946: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information29,
5947: hr_api.g_varchar2)
5948: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5949: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5950: hr_api.g_varchar2)
5951: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5952: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5953: hr_api.g_varchar2)
5954: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5947: hr_api.g_varchar2)
5948: <> nvl(p_per_information29,hr_api.g_varchar2)) or
5949: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5950: hr_api.g_varchar2)
5951: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5952: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5953: hr_api.g_varchar2)
5954: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5955: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5949: (l_api_updating and nvl(per_per_shd.g_old_rec.per_information30,
5950: hr_api.g_varchar2)
5951: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5952: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5953: hr_api.g_varchar2)
5954: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5955: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5956: hr_api.g_varchar2)
5957: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5950: hr_api.g_varchar2)
5951: <> nvl(p_per_information30,hr_api.g_varchar2)) or
5952: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5953: hr_api.g_varchar2)
5954: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5955: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5956: hr_api.g_varchar2)
5957: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5958: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5952: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute1,
5953: hr_api.g_varchar2)
5954: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5955: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5956: hr_api.g_varchar2)
5957: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5958: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5959: hr_api.g_varchar2)
5960: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5953: hr_api.g_varchar2)
5954: <> nvl(p_attribute1,hr_api.g_varchar2)) or
5955: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5956: hr_api.g_varchar2)
5957: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5958: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5959: hr_api.g_varchar2)
5960: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5961: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5955: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute2,
5956: hr_api.g_varchar2)
5957: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5958: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5959: hr_api.g_varchar2)
5960: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5961: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5962: hr_api.g_varchar2)
5963: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5956: hr_api.g_varchar2)
5957: <> nvl(p_attribute2,hr_api.g_varchar2)) or
5958: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5959: hr_api.g_varchar2)
5960: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5961: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5962: hr_api.g_varchar2)
5963: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5964: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5958: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute3,
5959: hr_api.g_varchar2)
5960: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5961: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5962: hr_api.g_varchar2)
5963: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5964: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5965: hr_api.g_varchar2)
5966: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5959: hr_api.g_varchar2)
5960: <> nvl(p_attribute3,hr_api.g_varchar2)) or
5961: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5962: hr_api.g_varchar2)
5963: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5964: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5965: hr_api.g_varchar2)
5966: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5967: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5961: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute4,
5962: hr_api.g_varchar2)
5963: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5964: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5965: hr_api.g_varchar2)
5966: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5967: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5968: hr_api.g_varchar2)
5969: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5962: hr_api.g_varchar2)
5963: <> nvl(p_attribute4,hr_api.g_varchar2)) or
5964: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5965: hr_api.g_varchar2)
5966: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5967: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5968: hr_api.g_varchar2)
5969: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5970: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5964: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute5,
5965: hr_api.g_varchar2)
5966: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5967: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5968: hr_api.g_varchar2)
5969: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5970: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5971: hr_api.g_varchar2)
5972: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5965: hr_api.g_varchar2)
5966: <> nvl(p_attribute5,hr_api.g_varchar2)) or
5967: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5968: hr_api.g_varchar2)
5969: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5970: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5971: hr_api.g_varchar2)
5972: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5973: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5967: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute6,
5968: hr_api.g_varchar2)
5969: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5970: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5971: hr_api.g_varchar2)
5972: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5973: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5974: hr_api.g_varchar2)
5975: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5968: hr_api.g_varchar2)
5969: <> nvl(p_attribute6,hr_api.g_varchar2)) or
5970: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5971: hr_api.g_varchar2)
5972: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5973: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5974: hr_api.g_varchar2)
5975: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5976: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5970: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute7,
5971: hr_api.g_varchar2)
5972: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5973: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5974: hr_api.g_varchar2)
5975: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5976: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5977: hr_api.g_varchar2)
5978: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5971: hr_api.g_varchar2)
5972: <> nvl(p_attribute7,hr_api.g_varchar2)) or
5973: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5974: hr_api.g_varchar2)
5975: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5976: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5977: hr_api.g_varchar2)
5978: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5979: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5973: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute8,
5974: hr_api.g_varchar2)
5975: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5976: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5977: hr_api.g_varchar2)
5978: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5979: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5980: hr_api.g_varchar2)
5981: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5974: hr_api.g_varchar2)
5975: <> nvl(p_attribute8,hr_api.g_varchar2)) or
5976: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5977: hr_api.g_varchar2)
5978: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5979: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5980: hr_api.g_varchar2)
5981: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5982: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5976: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute9,
5977: hr_api.g_varchar2)
5978: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5979: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5980: hr_api.g_varchar2)
5981: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5982: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5983: hr_api.g_varchar2)
5984: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5977: hr_api.g_varchar2)
5978: <> nvl(p_attribute9,hr_api.g_varchar2)) or
5979: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5980: hr_api.g_varchar2)
5981: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5982: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5983: hr_api.g_varchar2)
5984: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5985: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5979: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute10,
5980: hr_api.g_varchar2)
5981: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5982: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5983: hr_api.g_varchar2)
5984: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5985: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5986: hr_api.g_varchar2)
5987: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5980: hr_api.g_varchar2)
5981: <> nvl(p_attribute10,hr_api.g_varchar2)) or
5982: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5983: hr_api.g_varchar2)
5984: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5985: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5986: hr_api.g_varchar2)
5987: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5988: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5982: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute11,
5983: hr_api.g_varchar2)
5984: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5985: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5986: hr_api.g_varchar2)
5987: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5988: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5989: hr_api.g_varchar2)
5990: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5983: hr_api.g_varchar2)
5984: <> nvl(p_attribute11,hr_api.g_varchar2)) or
5985: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5986: hr_api.g_varchar2)
5987: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5988: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5989: hr_api.g_varchar2)
5990: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5991: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5985: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute12,
5986: hr_api.g_varchar2)
5987: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5988: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5989: hr_api.g_varchar2)
5990: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5991: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5992: hr_api.g_varchar2)
5993: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5986: hr_api.g_varchar2)
5987: <> nvl(p_attribute12,hr_api.g_varchar2)) or
5988: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5989: hr_api.g_varchar2)
5990: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5991: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5992: hr_api.g_varchar2)
5993: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5994: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5988: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute13,
5989: hr_api.g_varchar2)
5990: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5991: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5992: hr_api.g_varchar2)
5993: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5994: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5995: hr_api.g_varchar2)
5996: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5989: hr_api.g_varchar2)
5990: <> nvl(p_attribute13,hr_api.g_varchar2)) or
5991: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5992: hr_api.g_varchar2)
5993: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5994: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5995: hr_api.g_varchar2)
5996: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5997: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5991: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute14,
5992: hr_api.g_varchar2)
5993: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5994: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5995: hr_api.g_varchar2)
5996: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5997: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5998: hr_api.g_varchar2)
5999: <> nvl(p_attribute16,hr_api.g_varchar2)) or
5992: hr_api.g_varchar2)
5993: <> nvl(p_attribute14,hr_api.g_varchar2)) or
5994: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5995: hr_api.g_varchar2)
5996: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5997: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5998: hr_api.g_varchar2)
5999: <> nvl(p_attribute16,hr_api.g_varchar2)) or
6000: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
5994: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute15,
5995: hr_api.g_varchar2)
5996: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5997: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5998: hr_api.g_varchar2)
5999: <> nvl(p_attribute16,hr_api.g_varchar2)) or
6000: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
6001: hr_api.g_varchar2)
6002: <> nvl(p_attribute17,hr_api.g_varchar2)) or
5995: hr_api.g_varchar2)
5996: <> nvl(p_attribute15,hr_api.g_varchar2)) or
5997: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5998: hr_api.g_varchar2)
5999: <> nvl(p_attribute16,hr_api.g_varchar2)) or
6000: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
6001: hr_api.g_varchar2)
6002: <> nvl(p_attribute17,hr_api.g_varchar2)) or
6003: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
5997: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute16,
5998: hr_api.g_varchar2)
5999: <> nvl(p_attribute16,hr_api.g_varchar2)) or
6000: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
6001: hr_api.g_varchar2)
6002: <> nvl(p_attribute17,hr_api.g_varchar2)) or
6003: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
6004: hr_api.g_varchar2)
6005: <> nvl(p_attribute18,hr_api.g_varchar2)) or
5998: hr_api.g_varchar2)
5999: <> nvl(p_attribute16,hr_api.g_varchar2)) or
6000: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
6001: hr_api.g_varchar2)
6002: <> nvl(p_attribute17,hr_api.g_varchar2)) or
6003: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
6004: hr_api.g_varchar2)
6005: <> nvl(p_attribute18,hr_api.g_varchar2)) or
6006: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
6000: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute17,
6001: hr_api.g_varchar2)
6002: <> nvl(p_attribute17,hr_api.g_varchar2)) or
6003: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
6004: hr_api.g_varchar2)
6005: <> nvl(p_attribute18,hr_api.g_varchar2)) or
6006: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
6007: hr_api.g_varchar2)
6008: <> nvl(p_attribute19,hr_api.g_varchar2)) or
6001: hr_api.g_varchar2)
6002: <> nvl(p_attribute17,hr_api.g_varchar2)) or
6003: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
6004: hr_api.g_varchar2)
6005: <> nvl(p_attribute18,hr_api.g_varchar2)) or
6006: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
6007: hr_api.g_varchar2)
6008: <> nvl(p_attribute19,hr_api.g_varchar2)) or
6009: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
6003: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute18,
6004: hr_api.g_varchar2)
6005: <> nvl(p_attribute18,hr_api.g_varchar2)) or
6006: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
6007: hr_api.g_varchar2)
6008: <> nvl(p_attribute19,hr_api.g_varchar2)) or
6009: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
6010: hr_api.g_varchar2)
6011: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6004: hr_api.g_varchar2)
6005: <> nvl(p_attribute18,hr_api.g_varchar2)) or
6006: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
6007: hr_api.g_varchar2)
6008: <> nvl(p_attribute19,hr_api.g_varchar2)) or
6009: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
6010: hr_api.g_varchar2)
6011: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6012: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6006: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute19,
6007: hr_api.g_varchar2)
6008: <> nvl(p_attribute19,hr_api.g_varchar2)) or
6009: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
6010: hr_api.g_varchar2)
6011: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6012: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6013: hr_api.g_varchar2)
6014: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6007: hr_api.g_varchar2)
6008: <> nvl(p_attribute19,hr_api.g_varchar2)) or
6009: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
6010: hr_api.g_varchar2)
6011: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6012: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6013: hr_api.g_varchar2)
6014: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6015: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6009: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute20,
6010: hr_api.g_varchar2)
6011: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6012: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6013: hr_api.g_varchar2)
6014: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6015: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6016: hr_api.g_varchar2)
6017: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6010: hr_api.g_varchar2)
6011: <> nvl(p_attribute20,hr_api.g_varchar2)) or
6012: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6013: hr_api.g_varchar2)
6014: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6015: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6016: hr_api.g_varchar2)
6017: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6018: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6012: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute21,
6013: hr_api.g_varchar2)
6014: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6015: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6016: hr_api.g_varchar2)
6017: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6018: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6019: hr_api.g_varchar2)
6020: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6013: hr_api.g_varchar2)
6014: <> nvl(p_attribute21,hr_api.g_varchar2)) or
6015: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6016: hr_api.g_varchar2)
6017: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6018: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6019: hr_api.g_varchar2)
6020: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6021: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6015: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute22,
6016: hr_api.g_varchar2)
6017: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6018: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6019: hr_api.g_varchar2)
6020: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6021: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6022: hr_api.g_varchar2)
6023: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6016: hr_api.g_varchar2)
6017: <> nvl(p_attribute22,hr_api.g_varchar2)) or
6018: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6019: hr_api.g_varchar2)
6020: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6021: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6022: hr_api.g_varchar2)
6023: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6024: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6018: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute23,
6019: hr_api.g_varchar2)
6020: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6021: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6022: hr_api.g_varchar2)
6023: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6024: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6025: hr_api.g_varchar2)
6026: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6019: hr_api.g_varchar2)
6020: <> nvl(p_attribute23,hr_api.g_varchar2)) or
6021: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6022: hr_api.g_varchar2)
6023: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6024: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6025: hr_api.g_varchar2)
6026: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6027: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6021: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute24,
6022: hr_api.g_varchar2)
6023: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6024: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6025: hr_api.g_varchar2)
6026: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6027: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6028: hr_api.g_varchar2)
6029: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6022: hr_api.g_varchar2)
6023: <> nvl(p_attribute24,hr_api.g_varchar2)) or
6024: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6025: hr_api.g_varchar2)
6026: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6027: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6028: hr_api.g_varchar2)
6029: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6030: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6024: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute25,
6025: hr_api.g_varchar2)
6026: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6027: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6028: hr_api.g_varchar2)
6029: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6030: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6031: hr_api.g_varchar2)
6032: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6025: hr_api.g_varchar2)
6026: <> nvl(p_attribute25,hr_api.g_varchar2)) or
6027: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6028: hr_api.g_varchar2)
6029: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6030: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6031: hr_api.g_varchar2)
6032: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6033: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6027: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute26,
6028: hr_api.g_varchar2)
6029: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6030: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6031: hr_api.g_varchar2)
6032: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6033: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6034: hr_api.g_varchar2)
6035: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6028: hr_api.g_varchar2)
6029: <> nvl(p_attribute26,hr_api.g_varchar2)) or
6030: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6031: hr_api.g_varchar2)
6032: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6033: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6034: hr_api.g_varchar2)
6035: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6036: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6030: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute27,
6031: hr_api.g_varchar2)
6032: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6033: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6034: hr_api.g_varchar2)
6035: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6036: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6037: hr_api.g_varchar2)
6038: <> nvl(p_attribute29,hr_api.g_varchar2)) or
6031: hr_api.g_varchar2)
6032: <> nvl(p_attribute27,hr_api.g_varchar2)) or
6033: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6034: hr_api.g_varchar2)
6035: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6036: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6037: hr_api.g_varchar2)
6038: <> nvl(p_attribute29,hr_api.g_varchar2)) or
6039: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute30,
6033: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute28,
6034: hr_api.g_varchar2)
6035: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6036: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6037: hr_api.g_varchar2)
6038: <> nvl(p_attribute29,hr_api.g_varchar2)) or
6039: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute30,
6040: hr_api.g_varchar2)
6041: <> nvl(p_attribute30,hr_api.g_varchar2)) or
6034: hr_api.g_varchar2)
6035: <> nvl(p_attribute28,hr_api.g_varchar2)) or
6036: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6037: hr_api.g_varchar2)
6038: <> nvl(p_attribute29,hr_api.g_varchar2)) or
6039: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute30,
6040: hr_api.g_varchar2)
6041: <> nvl(p_attribute30,hr_api.g_varchar2)) or
6042: (NOT l_api_updating)) then
6036: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute29,
6037: hr_api.g_varchar2)
6038: <> nvl(p_attribute29,hr_api.g_varchar2)) or
6039: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute30,
6040: hr_api.g_varchar2)
6041: <> nvl(p_attribute30,hr_api.g_varchar2)) or
6042: (NOT l_api_updating)) then
6043: --
6044: if g_debug then
6037: hr_api.g_varchar2)
6038: <> nvl(p_attribute29,hr_api.g_varchar2)) or
6039: (l_api_updating and nvl(per_per_shd.g_old_rec.attribute30,
6040: hr_api.g_varchar2)
6041: <> nvl(p_attribute30,hr_api.g_varchar2)) or
6042: (NOT l_api_updating)) then
6043: --
6044: if g_debug then
6045: hr_utility.set_location(l_proc, 20);
6409: end if;
6410: --
6411: -- Check mandatory parameters have been set
6412: --
6413: hr_api.mandatory_arg_error
6414: (p_api_name => l_proc
6415: ,p_argument => 'business group id'
6416: ,p_argument_value => p_business_group_id
6417: );
6415: ,p_argument => 'business group id'
6416: ,p_argument_value => p_business_group_id
6417: );
6418: --
6419: hr_api.mandatory_arg_error
6420: (p_api_name => l_proc
6421: ,p_argument => 'effective date'
6422: ,p_argument_value => p_effective_date
6423: );
6442: -- that an applicant number is now required.
6443: --
6444: if ((l_api_updating and
6445: (nvl(per_per_shd.g_old_rec.applicant_number,
6446: hr_api.g_varchar2) <>
6447: nvl(p_applicant_number, hr_api.g_varchar2)
6448: or apl_sys_per_type_change
6449: (p_person_type_id
6450: ,per_per_shd.g_old_rec.person_type_id
6443: --
6444: if ((l_api_updating and
6445: (nvl(per_per_shd.g_old_rec.applicant_number,
6446: hr_api.g_varchar2) <>
6447: nvl(p_applicant_number, hr_api.g_varchar2)
6448: or apl_sys_per_type_change
6449: (p_person_type_id
6450: ,per_per_shd.g_old_rec.person_type_id
6451: ,p_business_group_id)))
6524: -- Check that on update with Automatic number generation
6525: -- the applicant number is not changed.
6526: --
6527: if (l_api_updating and
6528: nvl(per_per_shd.g_old_rec.applicant_number,hr_api.g_varchar2) <>
6529: nvl(p_applicant_number, hr_api.g_varchar2) and
6530: l_gen_method = 'A') then
6531: hr_utility.set_message(801, 'HR_51201_PER_INV_APL_UPD');
6532: hr_utility.raise_error;
6525: -- the applicant number is not changed.
6526: --
6527: if (l_api_updating and
6528: nvl(per_per_shd.g_old_rec.applicant_number,hr_api.g_varchar2) <>
6529: nvl(p_applicant_number, hr_api.g_varchar2) and
6530: l_gen_method = 'A') then
6531: hr_utility.set_message(801, 'HR_51201_PER_INV_APL_UPD');
6532: hr_utility.raise_error;
6533: end if;
6692: end if;
6693: --
6694: if ((l_api_updating and
6695: nvl(per_per_shd.g_old_rec.date_employee_data_verified,
6696: hr_api.g_date) <> nvl(p_date_employee_data_verified,
6697: hr_api.g_date)) or (NOT l_api_updating)) then
6698: --
6699: if g_debug then
6700: hr_utility.set_location(l_proc, 3);
6693: --
6694: if ((l_api_updating and
6695: nvl(per_per_shd.g_old_rec.date_employee_data_verified,
6696: hr_api.g_date) <> nvl(p_date_employee_data_verified,
6697: hr_api.g_date)) or (NOT l_api_updating)) then
6698: --
6699: if g_debug then
6700: hr_utility.set_location(l_proc, 3);
6701: end if;
6805: hr_utility.set_location(l_proc, 20);
6806: end if;
6807: --
6808: if ((l_api_updating and
6809: nvl(per_per_shd.g_old_rec.vendor_id, hr_api.g_number) <>
6810: nvl(p_vendor_id, hr_api.g_number)) or
6811: (NOT l_api_updating)) then
6812: --
6813: if g_debug then
6806: end if;
6807: --
6808: if ((l_api_updating and
6809: nvl(per_per_shd.g_old_rec.vendor_id, hr_api.g_number) <>
6810: nvl(p_vendor_id, hr_api.g_number)) or
6811: (NOT l_api_updating)) then
6812: --
6813: if g_debug then
6814: hr_utility.set_location(l_proc, 30);
6923: end if;
6924: --
6925: -- Check mandatory parameters have been set
6926: --
6927: hr_api.mandatory_arg_error
6928: (p_api_name => l_proc
6929: ,p_argument => 'effective date'
6930: ,p_argument_value => p_effective_date
6931: );
6948: hr_utility.set_location(l_proc, 30);
6949: end if;
6950: --
6951: if ((l_api_updating
6952: and nvl(per_per_shd.g_old_rec.suffix, hr_api.g_varchar2)
6953: <> nvl(p_suffix,hr_api.g_varchar2))
6954: or
6955: (NOT l_api_updating))
6956: then
6949: end if;
6950: --
6951: if ((l_api_updating
6952: and nvl(per_per_shd.g_old_rec.suffix, hr_api.g_varchar2)
6953: <> nvl(p_suffix,hr_api.g_varchar2))
6954: or
6955: (NOT l_api_updating))
6956: then
6957: if g_debug then
7013: hr_utility.set_location(l_proc, 30);
7014: end if;
7015: --
7016: if ((l_api_updating
7017: and nvl(per_per_shd.g_old_rec.work_telephone, hr_api.g_varchar2)
7018: <> nvl(p_work_telephone,hr_api.g_varchar2))
7019: or
7020: (NOT l_api_updating))
7021: then
7014: end if;
7015: --
7016: if ((l_api_updating
7017: and nvl(per_per_shd.g_old_rec.work_telephone, hr_api.g_varchar2)
7018: <> nvl(p_work_telephone,hr_api.g_varchar2))
7019: or
7020: (NOT l_api_updating))
7021: then
7022: --
7169: end if;
7170: --
7171: -- Check mandatory parameters have been set
7172: --
7173: hr_api.mandatory_arg_error
7174: (p_api_name => l_proc
7175: ,p_argument => 'business group id'
7176: ,p_argument_value => p_business_group_id
7177: );
7175: ,p_argument => 'business group id'
7176: ,p_argument_value => p_business_group_id
7177: );
7178: --
7179: hr_api.mandatory_arg_error
7180: (p_api_name => l_proc
7181: ,p_argument => 'person type id'
7182: ,p_argument_value => p_person_type_id
7183: );
7181: ,p_argument => 'person type id'
7182: ,p_argument_value => p_person_type_id
7183: );
7184: --
7185: hr_api.mandatory_arg_error
7186: (p_api_name => l_proc
7187: ,p_argument => 'effective date'
7188: ,p_argument_value => p_effective_date
7189: );
7187: ,p_argument => 'effective date'
7188: ,p_argument_value => p_effective_date
7189: );
7190: --
7191: hr_api.mandatory_arg_error
7192: (p_api_name => l_proc
7193: ,p_argument => 'datetrack mode'
7194: ,p_argument_value => p_datetrack_mode
7195: );
7316: if g_debug then
7317: hr_utility.set_location(l_proc, 6);
7318: end if;
7319: --
7320: if nvl(p_rec.business_group_id, hr_api.g_number) <>
7321: nvl(per_per_shd.g_old_rec.business_group_id, hr_api.g_number) then
7322: hr_api.argument_changed_error
7323: (
7324: p_api_name => l_proc
7317: hr_utility.set_location(l_proc, 6);
7318: end if;
7319: --
7320: if nvl(p_rec.business_group_id, hr_api.g_number) <>
7321: nvl(per_per_shd.g_old_rec.business_group_id, hr_api.g_number) then
7322: hr_api.argument_changed_error
7323: (
7324: p_api_name => l_proc
7325: ,p_argument => 'BUSINESS_GROUP_ID'
7318: end if;
7319: --
7320: if nvl(p_rec.business_group_id, hr_api.g_number) <>
7321: nvl(per_per_shd.g_old_rec.business_group_id, hr_api.g_number) then
7322: hr_api.argument_changed_error
7323: (
7324: p_api_name => l_proc
7325: ,p_argument => 'BUSINESS_GROUP_ID'
7326: ,p_base_table => per_per_shd.g_tab_nam
7377: end if;
7378: --
7379: -- Ensure that the p_datetrack_mode argument is not null
7380: --
7381: hr_api.mandatory_arg_error
7382: (p_api_name => l_proc,
7383: p_argument => 'datetrack_mode',
7384: p_argument_value => p_datetrack_mode);
7385: --
7389: --
7390: --
7391: -- Ensure the arguments are not null
7392: --
7393: hr_api.mandatory_arg_error
7394: (p_api_name => l_proc,
7395: p_argument => 'validation_start_date',
7396: p_argument_value => p_validation_start_date);
7397: --
7394: (p_api_name => l_proc,
7395: p_argument => 'validation_start_date',
7396: p_argument_value => p_validation_start_date);
7397: --
7398: hr_api.mandatory_arg_error
7399: (p_api_name => l_proc,
7400: p_argument => 'validation_end_date',
7401: p_argument_value => p_validation_end_date);
7402: --
7478: end if;
7479: --
7480: -- Ensure that the p_datetrack_mode argument is not null
7481: --
7482: hr_api.mandatory_arg_error
7483: (p_api_name => l_proc,
7484: p_argument => 'datetrack_mode',
7485: p_argument_value => p_datetrack_mode);
7486: --
7492: --
7493: --
7494: -- Ensure the arguments are not null
7495: --
7496: hr_api.mandatory_arg_error
7497: (p_api_name => l_proc,
7498: p_argument => 'validation_start_date',
7499: p_argument_value => p_validation_start_date);
7500: --
7497: (p_api_name => l_proc,
7498: p_argument => 'validation_start_date',
7499: p_argument_value => p_validation_start_date);
7500: --
7501: hr_api.mandatory_arg_error
7502: (p_api_name => l_proc,
7503: p_argument => 'validation_end_date',
7504: p_argument_value => p_validation_end_date);
7505: --
7502: (p_api_name => l_proc,
7503: p_argument => 'validation_end_date',
7504: p_argument_value => p_validation_end_date);
7505: --
7506: hr_api.mandatory_arg_error
7507: (p_api_name => l_proc,
7508: p_argument => 'person_id',
7509: p_argument_value => p_person_id);
7510: --
7586: hr_utility.set_location('Entering:'||l_proc, 10);
7587: end if;
7588: --
7589: if ((p_rec.person_id is not null) and (
7590: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7591: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7592: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7587: end if;
7588: --
7589: if ((p_rec.person_id is not null) and (
7590: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7591: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7592: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7588: --
7589: if ((p_rec.person_id is not null) and (
7590: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7591: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7592: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7589: if ((p_rec.person_id is not null) and (
7590: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7591: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7592: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7590: nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7591: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7592: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7591: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7592: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7592: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7593: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7594: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7595: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7596: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7597: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7598: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7599: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7600: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7601: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7602: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7603: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7604: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7605: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7606: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7607: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7608: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7609: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7610: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7611: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7612: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7613: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7614: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7615: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7616: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7617: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7618: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7619: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7620: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7621: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7622: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7623: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7624: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7625: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7626: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7627: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7628: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7629: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7630: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7631: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7632: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7633: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7634: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7635: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7636: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7637: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7638: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7639: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7640: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7641: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7649: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7642: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7649: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7650: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7643: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7649: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7650: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7651: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7644: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7649: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7650: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7651: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7652: or (p_rec.person_id is null) then
7645: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7649: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7650: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7651: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7652: or (p_rec.person_id is null) then
7653: --
7646: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7649: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7650: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7651: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7652: or (p_rec.person_id is null) then
7653: --
7654: -- Only execute the validation if absolutely necessary:
7647: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7648: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7649: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7650: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7651: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7652: or (p_rec.person_id is null) then
7653: --
7654: -- Only execute the validation if absolutely necessary:
7655: -- a) During update, the structure column value or any
7795: -- Mapping to the appropriate Business Rules in perper.bru is provided.
7796: --
7797: -- Validate Business Group Id
7798: --
7799: hr_api.validate_bus_grp_id
7800: (p_business_group_id => p_rec.business_group_id
7801: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
7802: );
7803: hr_multi_message.end_validation_set;
8493: g_previous_sys_per_type := NULL;
8494: --
8495: -- Validate Business Group Id
8496: --
8497: hr_api.validate_bus_grp_id
8498: (p_business_group_id => p_rec.business_group_id
8499: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
8500: );
8501: hr_multi_message.end_validation_set;
9231: end if;
9232: --
9233: -- Validate the specified business group
9234: --
9235: hr_api.validate_bus_grp_id
9236: (p_business_group_id => p_business_group_id
9237: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
9238: );
9239: hr_multi_message.end_validation_set;
9241: hr_utility.set_location(l_proc,20);
9242: end if;
9243: --
9244: -- If the person type hasn't been specified or is set to the system default
9245: -- hr_api.g_number, then fetch the default for
9246: -- the business group and system type.
9247: --
9248: if (p_person_type_id is null or p_person_type_id = hr_api.g_number) then
9249: if g_debug then
9244: -- If the person type hasn't been specified or is set to the system default
9245: -- hr_api.g_number, then fetch the default for
9246: -- the business group and system type.
9247: --
9248: if (p_person_type_id is null or p_person_type_id = hr_api.g_number) then
9249: if g_debug then
9250: hr_utility.set_location(l_proc,30);
9251: end if;
9252: --
9344: end if;
9345: --
9346: -- Ensure that all the mandatory parameter are not null
9347: --
9348: --hr_api.mandatory_arg_error(p_api_name => l_proc,
9349: -- p_argument => 'person_id',
9350: -- p_argument_value => p_person_id);
9351: --
9352: else
9349: -- p_argument => 'person_id',
9350: -- p_argument_value => p_person_id);
9351: --
9352: else
9353: if nvl(g_person_id, hr_api.g_number) = p_person_id then
9354: --
9355: -- The legislation code has already been found with a previous
9356: -- call to this function. Just return the value in the global
9357: -- variable.
9438: end if;
9439: --
9440: -- Check mandatory parameters have been set
9441: --
9442: hr_api.mandatory_arg_error
9443: (p_api_name => l_proc
9444: ,p_argument => 'person_id'
9445: ,p_argument_value => p_person_id
9446: );
9444: ,p_argument => 'person_id'
9445: ,p_argument_value => p_person_id
9446: );
9447: --
9448: hr_api.mandatory_arg_error
9449: (p_api_name => l_proc
9450: ,p_argument => 'validation_start_date'
9451: ,p_argument_value => p_validation_start_date
9452: );
9450: ,p_argument => 'validation_start_date'
9451: ,p_argument_value => p_validation_start_date
9452: );
9453: --
9454: hr_api.mandatory_arg_error
9455: (p_api_name => l_proc
9456: ,p_argument => 'validation_end_date'
9457: ,p_argument_value => p_validation_end_date
9458: );