[Home] [Help]
140: hr_utility.set_location('Entering:'|| l_proc, 1);
141: --
142: -- Check mandatory parameters have been set
143: --
144: hr_api.mandatory_arg_error
145: (p_api_name => l_proc
146: ,p_argument => 'date_start'
147: ,p_argument_value => p_date_start
148: );
159: --
160: if l_api_updating
161: then
162: --
163: if nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
164: nvl(p_actual_termination_date, hr_api.g_date)
165: and p_actual_termination_date is not null
166: then
167: hr_utility.set_location(l_proc, 40);
160: if l_api_updating
161: then
162: --
163: if nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
164: nvl(p_actual_termination_date, hr_api.g_date)
165: and p_actual_termination_date is not null
166: then
167: hr_utility.set_location(l_proc, 40);
168: --
186: hr_utility.raise_error;
187: end if;
188: hr_utility.set_location(l_proc, 70);
189: --
190: if not (nvl(p_actual_termination_date, hr_api.g_eot) >=
191: p_date_start) then
192: --
193: -- CHK_ACTUAL_TERMINATION_DATE / b
194: --
302: hr_utility.set_location('Entering:'|| l_proc, 1);
303: --
304: -- CHK_DATE_START / a
305: --
306: hr_api.mandatory_arg_error
307: (p_api_name => l_proc
308: ,p_argument => 'date_start'
309: ,p_argument_value => p_date_start
310: );
417: hr_utility.set_location('Entering:'|| l_proc, 1);
418: --
419: -- Check mandatory parameters have been set
420: --
421: hr_api.mandatory_arg_error
422: (p_api_name => l_proc
423: ,p_argument => 'date_start'
424: ,p_argument_value => p_date_start
425: );
436: --
437: if l_api_updating
438: then
439: --
440: if nvl(per_pds_shd.g_old_rec.final_process_date, hr_api.g_date) <>
441: nvl(p_final_process_date, hr_api.g_date)
442: then
443: --
444: hr_utility.set_location(l_proc, 6);
437: if l_api_updating
438: then
439: --
440: if nvl(per_pds_shd.g_old_rec.final_process_date, hr_api.g_date) <>
441: nvl(p_final_process_date, hr_api.g_date)
442: then
443: --
444: hr_utility.set_location(l_proc, 6);
445: --
655: then
656: --
657: hr_utility.set_location(l_proc, 8);
658: --
659: if not (nvl(p_final_process_date, hr_api.g_eot) >=
660: nvl(p_actual_termination_date, hr_api.g_eot))
661: then
662: -- CHK_FINAL_PROCESS_DATE / f
663: --
656: --
657: hr_utility.set_location(l_proc, 8);
658: --
659: if not (nvl(p_final_process_date, hr_api.g_eot) >=
660: nvl(p_actual_termination_date, hr_api.g_eot))
661: then
662: -- CHK_FINAL_PROCESS_DATE / f
663: --
664: hr_utility.set_message(801,'HR_7963_PDS_INV_FP_BEFORE_ATT');
667: else
668: --
669: -- 70.1 change a start.
670: --
671: if not (nvl(p_final_process_date, hr_api.g_eot) >=
672: p_last_standard_process_date)
673: --
674: -- 70.1 change a end.
675: --
780: hr_utility.set_location('Entering:'|| l_proc, 1);
781: --
782: -- Check mandatory parameters have been set
783: --
784: hr_api.mandatory_arg_error
785: (p_api_name => l_proc
786: ,p_argument => 'date_start'
787: ,p_argument_value => p_date_start
788: );
799: --
800: if l_api_updating
801: then
802: --
803: if nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
804: nvl(p_last_standard_process_date, hr_api.g_date)
805: then
806: --
807: hr_utility.set_location(l_proc, 30);
800: if l_api_updating
801: then
802: --
803: if nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
804: nvl(p_last_standard_process_date, hr_api.g_date)
805: then
806: --
807: hr_utility.set_location(l_proc, 30);
808: --
869: hr_utility.set_location(l_proc, 80);
870: --
871: -- 70.1 change a start.
872: --
873: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=
874: nvl(p_actual_termination_date, hr_api.g_eot))
875: --
876: -- 70.1 change a end.
877: --
870: --
871: -- 70.1 change a start.
872: --
873: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=
874: nvl(p_actual_termination_date, hr_api.g_eot))
875: --
876: -- 70.1 change a end.
877: --
878: then
887: end if;
888: --
889: -- 70.16 change h start.
890: --
891: if (nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
892: nvl(p_actual_termination_date,hr_api.g_date) )
893: and (p_actual_termination_date is not null)
894: and l_legislation_code <> 'US'
895: --
888: --
889: -- 70.16 change h start.
890: --
891: if (nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
892: nvl(p_actual_termination_date,hr_api.g_date) )
893: and (p_actual_termination_date is not null)
894: and l_legislation_code <> 'US'
895: --
896: then
1003: -- b) The value for actual_termination_date or last_standard_process_date
1004: -- has changed
1005: --
1006: if (l_api_updating
1007: and ((nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1008: <> nvl(p_actual_termination_date, hr_api.g_date))
1009: or
1010: (nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1011: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1004: -- has changed
1005: --
1006: if (l_api_updating
1007: and ((nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1008: <> nvl(p_actual_termination_date, hr_api.g_date))
1009: or
1010: (nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1011: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1012: or
1006: if (l_api_updating
1007: and ((nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1008: <> nvl(p_actual_termination_date, hr_api.g_date))
1009: or
1010: (nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1011: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1012: or
1013: NOT l_api_updating then
1014: --
1007: and ((nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1008: <> nvl(p_actual_termination_date, hr_api.g_date))
1009: or
1010: (nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1011: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1012: or
1013: NOT l_api_updating then
1014: --
1015: hr_utility.set_location(l_proc, 30);
1099: --
1100: begin
1101: hr_utility.set_location('Entering:'|| l_proc, 1);
1102: --
1103: hr_api.mandatory_arg_error
1104: (p_api_name => l_proc
1105: ,p_argument => 'effective date'
1106: ,p_argument_value => p_effective_date
1107: );
1117: if l_api_updating
1118: and p_leaving_reason is not null
1119: then
1120: --
1121: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <>
1122: nvl(p_leaving_reason, hr_api.g_varchar2)
1123: then
1124: --
1125: -- Bug 1472162.
1118: and p_leaving_reason is not null
1119: then
1120: --
1121: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <>
1122: nvl(p_leaving_reason, hr_api.g_varchar2)
1123: then
1124: --
1125: -- Bug 1472162.
1126: --
1123: then
1124: --
1125: -- Bug 1472162.
1126: --
1127: -- if hr_api.not_exists_in_hr_lookups
1128: if hr_api.not_exists_in_leg_lookups
1129: (p_effective_date => p_effective_date
1130: ,p_lookup_type => 'LEAV_REAS'
1131: ,p_lookup_code => p_leaving_reason
1124: --
1125: -- Bug 1472162.
1126: --
1127: -- if hr_api.not_exists_in_hr_lookups
1128: if hr_api.not_exists_in_leg_lookups
1129: (p_effective_date => p_effective_date
1130: ,p_lookup_type => 'LEAV_REAS'
1131: ,p_lookup_code => p_leaving_reason
1132: ) then
1203: hr_utility.set_location('Entering:'|| l_proc, 1);
1204: --
1205: -- Check mandatory parameters have been set
1206: --
1207: hr_api.mandatory_arg_error
1208: (p_api_name => l_proc
1209: ,p_argument => 'date_start'
1210: ,p_argument_value => p_date_start
1211: );
1213: hr_utility.set_location(l_proc, 2);
1214: --
1215: -- 70.1 change a start.
1216: --
1217: if not (nvl(p_notified_termination_date, hr_api.g_eot) >=
1218: nvl(p_date_start, hr_api.g_date))
1219: --
1220: -- 70.1 change a end.
1221: --
1214: --
1215: -- 70.1 change a start.
1216: --
1217: if not (nvl(p_notified_termination_date, hr_api.g_eot) >=
1218: nvl(p_date_start, hr_api.g_date))
1219: --
1220: -- 70.1 change a end.
1221: --
1222: then
1298: hr_utility.set_location('Entering:'|| l_proc, 1);
1299: --
1300: -- CHK_PERSON_ID / a
1301: --
1302: hr_api.mandatory_arg_error
1303: (p_api_name => l_proc
1304: ,p_argument => 'person_id'
1305: ,p_argument_value => p_person_id
1306: );
1306: );
1307: hr_utility.set_location(l_proc, 2);
1308: --
1309: if not (p_person_id <>
1310: nvl(p_termination_accepted_person, hr_api.g_number))
1311: then
1312: -- CHK_PERSON_ID / c
1313: --
1314: hr_utility.set_message(801,'HR_7488_PDS_INV_TAP_ID');
1378: hr_utility.set_location('Entering:'|| l_proc, 1);
1379: --
1380: -- Check mandatory parameters have been set
1381: --
1382: hr_api.mandatory_arg_error
1383: (p_api_name => l_proc
1384: ,p_argument => 'person_id'
1385: ,p_argument_value => p_person_id
1386: );
1385: ,p_argument_value => p_person_id
1386: );
1387: hr_utility.set_location(l_proc, 4);
1388: --
1389: hr_api.mandatory_arg_error
1390: (p_api_name => l_proc
1391: ,p_argument => 'date_start'
1392: ,p_argument_value => p_date_start
1393: );
1494: hr_utility.set_location('Entering:'|| l_proc, 1);
1495: --
1496: -- Check mandatory parameters have been set
1497: --
1498: hr_api.mandatory_arg_error
1499: (p_api_name => l_proc
1500: ,p_argument => 'date_start'
1501: ,p_argument_value => p_date_start
1502: );
1504: hr_utility.set_location(l_proc, 2);
1505: --
1506: -- 70.1 change a start.
1507: --
1508: if not (nvl(p_projected_termination_date, hr_api.g_eot) >=
1509: nvl(p_date_start, hr_api.g_date))
1510: --
1511: -- 70.1 change a end.
1512: --
1505: --
1506: -- 70.1 change a start.
1507: --
1508: if not (nvl(p_projected_termination_date, hr_api.g_eot) >=
1509: nvl(p_date_start, hr_api.g_date))
1510: --
1511: -- 70.1 change a end.
1512: --
1513: then
1610: hr_utility.set_location('Entering:'|| l_proc, 1);
1611: --
1612: -- Check mandatory parameters have been set
1613: --
1614: hr_api.mandatory_arg_error
1615: (p_api_name => l_proc
1616: ,p_argument => 'person_id'
1617: ,p_argument_value => p_person_id
1618: );
1628: if l_api_updating
1629: then
1630: --
1631: if (nvl(per_pds_shd.g_old_rec.termination_accepted_person_id, -- Bug # 2282955. This right hand side part of the condtion
1632: hr_api.g_number) <> -- is modified from nvl(p_termination_acceted_person,
1633: nvl(p_termination_accepted_person, nvl( -- hr_api.g_number) to nvl(p_termination_acceted_person,
1634: per_pds_shd.g_old_rec.termination_accepted_person_id,hr_api.g_number))) -- nvl(per_pds_shd.g_old_rec.termination_accepted_person_id,
1635: then -- hr_api.g_number))
1636: --
1629: then
1630: --
1631: if (nvl(per_pds_shd.g_old_rec.termination_accepted_person_id, -- Bug # 2282955. This right hand side part of the condtion
1632: hr_api.g_number) <> -- is modified from nvl(p_termination_acceted_person,
1633: nvl(p_termination_accepted_person, nvl( -- hr_api.g_number) to nvl(p_termination_acceted_person,
1634: per_pds_shd.g_old_rec.termination_accepted_person_id,hr_api.g_number))) -- nvl(per_pds_shd.g_old_rec.termination_accepted_person_id,
1635: then -- hr_api.g_number))
1636: --
1637: -- CHK_TERMINATION_ACCEPTED_PERSON_ID / b
1630: --
1631: if (nvl(per_pds_shd.g_old_rec.termination_accepted_person_id, -- Bug # 2282955. This right hand side part of the condtion
1632: hr_api.g_number) <> -- is modified from nvl(p_termination_acceted_person,
1633: nvl(p_termination_accepted_person, nvl( -- hr_api.g_number) to nvl(p_termination_acceted_person,
1634: per_pds_shd.g_old_rec.termination_accepted_person_id,hr_api.g_number))) -- nvl(per_pds_shd.g_old_rec.termination_accepted_person_id,
1635: then -- hr_api.g_number))
1636: --
1637: -- CHK_TERMINATION_ACCEPTED_PERSON_ID / b
1638: --
1631: if (nvl(per_pds_shd.g_old_rec.termination_accepted_person_id, -- Bug # 2282955. This right hand side part of the condtion
1632: hr_api.g_number) <> -- is modified from nvl(p_termination_acceted_person,
1633: nvl(p_termination_accepted_person, nvl( -- hr_api.g_number) to nvl(p_termination_acceted_person,
1634: per_pds_shd.g_old_rec.termination_accepted_person_id,hr_api.g_number))) -- nvl(per_pds_shd.g_old_rec.termination_accepted_person_id,
1635: then -- hr_api.g_number))
1636: --
1637: -- CHK_TERMINATION_ACCEPTED_PERSON_ID / b
1638: --
1639: if (nvl(p_termination_accepted_person, hr_api.g_number) =
1635: then -- hr_api.g_number))
1636: --
1637: -- CHK_TERMINATION_ACCEPTED_PERSON_ID / b
1638: --
1639: if (nvl(p_termination_accepted_person, hr_api.g_number) =
1640: per_pds_shd.g_old_rec.person_id)
1641: then
1642: hr_utility.set_message(801,'HR_7488_PDS_INV_TAP_ID');
1643: hr_utility.raise_error;
1734: end if;
1735: --
1736: hr_utility.set_location(l_proc, 6);
1737: --
1738: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1739: nvl(per_pds_shd.g_old_rec.business_group_id, hr_api.g_number)
1740: then
1741: -- CHK_BUSINESS_GROUP_ID / b
1742: --
1735: --
1736: hr_utility.set_location(l_proc, 6);
1737: --
1738: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1739: nvl(per_pds_shd.g_old_rec.business_group_id, hr_api.g_number)
1740: then
1741: -- CHK_BUSINESS_GROUP_ID / b
1742: --
1743: l_argument := 'business_group_id';
1745: end if;
1746: --
1747: hr_utility.set_location(l_proc, 7);
1748: --
1749: if nvl(p_rec.period_of_service_id, hr_api.g_number) <>
1750: nvl(per_pds_shd.g_old_rec.period_of_service_id, hr_api.g_number)
1751: then
1752: -- CHK_PERIOD_OF_SERVICE_ID / c
1753: --
1746: --
1747: hr_utility.set_location(l_proc, 7);
1748: --
1749: if nvl(p_rec.period_of_service_id, hr_api.g_number) <>
1750: nvl(per_pds_shd.g_old_rec.period_of_service_id, hr_api.g_number)
1751: then
1752: -- CHK_PERIOD_OF_SERVICE_ID / c
1753: --
1754: l_argument := 'period_of_service_id';
1756: end if;
1757: --
1758: hr_utility.set_location(l_proc, 8);
1759: --
1760: if nvl(p_rec.person_id, hr_api.g_number) <>
1761: nvl(per_pds_shd.g_old_rec.person_id, hr_api.g_number)
1762: then
1763: -- CHK_PERSON_ID / b
1764: --
1757: --
1758: hr_utility.set_location(l_proc, 8);
1759: --
1760: if nvl(p_rec.person_id, hr_api.g_number) <>
1761: nvl(per_pds_shd.g_old_rec.person_id, hr_api.g_number)
1762: then
1763: -- CHK_PERSON_ID / b
1764: --
1765: l_argument := 'person_id';
1771: exception
1772: when l_error
1773: then
1774: --
1775: hr_api.argument_changed_error
1776: (p_api_name => l_proc
1777: ,p_argument => l_argument);
1778: when others then
1779: raise;
1863: --
1864: --
1865: If ( (p_rec.period_of_service_id is not null)
1866: and
1867: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1869: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1871: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1864: --
1865: If ( (p_rec.period_of_service_id is not null)
1866: and
1867: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1869: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1871: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1865: If ( (p_rec.period_of_service_id is not null)
1866: and
1867: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1869: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1871: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1873: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1866: and
1867: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1869: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1871: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1873: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1867: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1869: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1871: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1873: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1875: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1869: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1871: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1873: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1875: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1869: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1871: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1873: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1875: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1877: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1871: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1873: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1875: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1877: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1871: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1873: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1875: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1877: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1879: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1873: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1875: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1877: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1879: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1873: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1875: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1877: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1879: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1881: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1875: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1877: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1879: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1881: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1875: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1877: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1879: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1881: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1883: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1877: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1879: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1881: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1883: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1877: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1879: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1881: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1883: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1885: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1879: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1881: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1883: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1885: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1879: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1881: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1883: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1885: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1887: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1881: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1883: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1885: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1887: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1881: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1883: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1885: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1887: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1889: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1883: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1885: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1887: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1889: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1883: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1885: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1887: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1889: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1891: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1885: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1887: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1889: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1891: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1885: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1887: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1889: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1891: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1893: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1887: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1889: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1891: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1893: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1887: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1889: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1891: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1893: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1895: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1889: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1891: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1893: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1895: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1889: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1891: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1893: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1895: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1897: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1891: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1893: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1895: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1897: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1891: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1893: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1895: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1897: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1899: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1893: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1895: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1897: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1899: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1893: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1895: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1897: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1899: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1901: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1895: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1897: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1899: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1901: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1895: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1897: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1899: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1901: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1903: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1897: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1899: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1901: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1903: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1897: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1899: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1901: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1903: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1905: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1899: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1901: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1903: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1905: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1899: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1901: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1903: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1905: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1907: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1901: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1903: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1905: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1907: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1908: nvl(p_rec.attribute20, hr_api.g_varchar2)
1901: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1903: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1905: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1907: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1908: nvl(p_rec.attribute20, hr_api.g_varchar2)
1909: )
1902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1903: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1905: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1907: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1908: nvl(p_rec.attribute20, hr_api.g_varchar2)
1909: )
1910: or
1903: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1905: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1907: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1908: nvl(p_rec.attribute20, hr_api.g_varchar2)
1909: )
1910: or
1911: (
1904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1905: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1907: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1908: nvl(p_rec.attribute20, hr_api.g_varchar2)
1909: )
1910: or
1911: (
1912: -- Added the check for date_start and adjusted_svc_date for fix
1910: or
1911: (
1912: -- Added the check for date_start and adjusted_svc_date for fix
1913: -- of #1577252
1914: ( nvl(per_pds_shd.g_old_rec.adjusted_svc_date, hr_api.g_date) =
1915: nvl(p_rec.adjusted_svc_date, hr_api.g_date) ) and
1916: ( nvl(per_pds_shd.g_old_rec.date_start, hr_api.g_date) =
1917: nvl(p_rec.date_start, hr_api.g_date) ) and
1918: (p_rec.attribute_category is null) and
1911: (
1912: -- Added the check for date_start and adjusted_svc_date for fix
1913: -- of #1577252
1914: ( nvl(per_pds_shd.g_old_rec.adjusted_svc_date, hr_api.g_date) =
1915: nvl(p_rec.adjusted_svc_date, hr_api.g_date) ) and
1916: ( nvl(per_pds_shd.g_old_rec.date_start, hr_api.g_date) =
1917: nvl(p_rec.date_start, hr_api.g_date) ) and
1918: (p_rec.attribute_category is null) and
1919: (p_rec.attribute1 is null) and
1912: -- Added the check for date_start and adjusted_svc_date for fix
1913: -- of #1577252
1914: ( nvl(per_pds_shd.g_old_rec.adjusted_svc_date, hr_api.g_date) =
1915: nvl(p_rec.adjusted_svc_date, hr_api.g_date) ) and
1916: ( nvl(per_pds_shd.g_old_rec.date_start, hr_api.g_date) =
1917: nvl(p_rec.date_start, hr_api.g_date) ) and
1918: (p_rec.attribute_category is null) and
1919: (p_rec.attribute1 is null) and
1920: (p_rec.attribute2 is null) and
1913: -- of #1577252
1914: ( nvl(per_pds_shd.g_old_rec.adjusted_svc_date, hr_api.g_date) =
1915: nvl(p_rec.adjusted_svc_date, hr_api.g_date) ) and
1916: ( nvl(per_pds_shd.g_old_rec.date_start, hr_api.g_date) =
1917: nvl(p_rec.date_start, hr_api.g_date) ) and
1918: (p_rec.attribute_category is null) and
1919: (p_rec.attribute1 is null) and
1920: (p_rec.attribute2 is null) and
1921: (p_rec.attribute3 is null) and
2043: -- value has changed
2044: --
2045: if (p_rec.period_of_service_id is null) or
2046: ((p_rec.period_of_service_id is not null) and
2047: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2048: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2049: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2050: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2051: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2044: --
2045: if (p_rec.period_of_service_id is null) or
2046: ((p_rec.period_of_service_id is not null) and
2047: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2048: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2049: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2050: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2051: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2052: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2045: if (p_rec.period_of_service_id is null) or
2046: ((p_rec.period_of_service_id is not null) and
2047: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2048: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2049: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2050: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2051: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2052: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2053: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2046: ((p_rec.period_of_service_id is not null) and
2047: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2048: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2049: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2050: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2051: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2052: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2053: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2054: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2047: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2048: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2049: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2050: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2051: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2052: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2053: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2054: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2055: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2048: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2049: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2050: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2051: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2052: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2053: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2054: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2055: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2056: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2049: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2050: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2051: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2052: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2053: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2054: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2055: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2056: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2057: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2050: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2051: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2052: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2053: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2054: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2055: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2056: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2057: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2058: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2051: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2052: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2053: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2054: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2055: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2056: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2057: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2058: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2059: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2052: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2053: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2054: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2055: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2056: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2057: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2058: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2059: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2060: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2053: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2054: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2055: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2056: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2057: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2058: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2059: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2060: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2061: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2054: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2055: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2056: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2057: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2058: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2059: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2060: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2061: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2062: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2055: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2056: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2057: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2058: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2059: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2060: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2061: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2062: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2063: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2056: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2057: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2058: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2059: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2060: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2061: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2062: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2063: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2064: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2057: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2058: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2059: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2060: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2061: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2062: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2063: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2064: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2065: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2058: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2059: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2060: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2061: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2062: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2063: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2064: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2065: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2066: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2059: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2060: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2061: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2062: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2063: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2064: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2065: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2066: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2067: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2060: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2061: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2062: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2063: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2064: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2065: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2066: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2067: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2068: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2061: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2062: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2063: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2064: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2065: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2066: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2067: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2068: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2069: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2062: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2063: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2064: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2065: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2066: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2067: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2068: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2069: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2070: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2063: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2064: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2065: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2066: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2067: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2068: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2069: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2070: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2071: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2064: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2065: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2066: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2067: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2068: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2069: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2070: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2071: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2072: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2065: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2066: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2067: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2068: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2069: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2070: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2071: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2072: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2073: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2066: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2067: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2068: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2069: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2070: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2071: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2072: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2073: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2074: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2067: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2068: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2069: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2070: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2071: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2072: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2073: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2074: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2075: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2068: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2069: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2070: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2071: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2072: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2073: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2074: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2075: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2076: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2069: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2070: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2071: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2072: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2073: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2074: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2075: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2076: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2077: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2070: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2071: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2072: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2073: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2074: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2075: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2076: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2077: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2078: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2071: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2072: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2073: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2074: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2075: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2076: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2077: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2078: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2079: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2072: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2073: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2074: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2075: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2076: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2077: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2078: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2079: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2080: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2073: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2074: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2075: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2076: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2077: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2078: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2079: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2080: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2081: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2074: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2075: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2076: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2077: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2078: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2079: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2080: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2081: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2082: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2075: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2076: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2077: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2078: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2079: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2080: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2081: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2082: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2083: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2076: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2077: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2078: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2079: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2080: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2081: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2082: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2083: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2084: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2077: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2078: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2079: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2080: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2081: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2082: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2083: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2084: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2085: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2078: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2079: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2080: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2081: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2082: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2083: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2084: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2085: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2086: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2079: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2080: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2081: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2082: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2083: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2084: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2085: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2086: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2087: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2080: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2081: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2082: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2083: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2084: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2085: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2086: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2087: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2088: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2081: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2082: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2083: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2084: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2085: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2086: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2087: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2088: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2089: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2082: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2083: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2084: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2085: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2086: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2087: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2088: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2089: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2090: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2083: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2084: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2085: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2086: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2087: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2088: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2089: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2090: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2091: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2084: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2085: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2086: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2087: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2088: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2089: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2090: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2091: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2092: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2085: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2086: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2087: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2088: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2089: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2090: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2091: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2092: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2093: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2086: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2087: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2088: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2089: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2090: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2091: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2092: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2093: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2094: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2087: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2088: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2089: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2090: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2091: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2092: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2093: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2094: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2095: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2088: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2089: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2090: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2091: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2092: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2093: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2094: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2095: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2096: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2089: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2090: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2091: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2092: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2093: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2094: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2095: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2096: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2097: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2090: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2091: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2092: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2093: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2094: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2095: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2096: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2097: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2098: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2091: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2092: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2093: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2094: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2095: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2096: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2097: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2098: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2099: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2092: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2093: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2094: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2095: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2096: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2097: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2098: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2099: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2100: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2093: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2094: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2095: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2096: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2097: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2098: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2099: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2100: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2101: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2094: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2095: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2096: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2097: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2098: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2099: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2100: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2101: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2102: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2095: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2096: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2097: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2098: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2099: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2100: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2101: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2102: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2103: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2096: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2097: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2098: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2099: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2100: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2101: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2102: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2103: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2104: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2097: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2098: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2099: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2100: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2101: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2102: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2103: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2104: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2105: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2098: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2099: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2100: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2101: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2102: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2103: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2104: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2105: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2106: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2099: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2100: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2101: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2102: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2103: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2104: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2105: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2106: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2107: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2100: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2101: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2102: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2103: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2104: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2105: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2106: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2107: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2108: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2101: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2102: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2103: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2104: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2105: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2106: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2107: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2108: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2109: --
2102: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2103: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2104: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2105: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2106: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2107: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2108: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2109: --
2110: hr_dflex_utility.ins_or_upd_descflex_attribs
2103: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2104: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2105: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2106: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2107: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2108: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2109: --
2110: hr_dflex_utility.ins_or_upd_descflex_attribs
2111: (p_appl_short_name => 'PER'
2104: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2105: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2106: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2107: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2108: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2109: --
2110: hr_dflex_utility.ins_or_upd_descflex_attribs
2111: (p_appl_short_name => 'PER'
2112: ,p_descflex_name => 'PER_PDS_DEVELOPER_DF'
2198: -- Business Rule Mapping
2199: -- =====================
2200: -- CHK_BUSINESS_GROUP_ID / a,c
2201: --
2202: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2203: --
2204: hr_utility.set_location(l_proc, 2);
2205: --
2206: --
2430: -- Business Rule Mapping
2431: -- =====================
2432: -- CHK_BUSINESS_GROUP_ID / a,c
2433: --
2434: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2435: --
2436: hr_utility.set_location(l_proc, 3);
2437: --
2438: --
2655: hr_utility.set_location('Entering:'|| l_proc, 10);
2656: --
2657: -- Ensure that all the mandatory parameter are not null
2658: --
2659: hr_api.mandatory_arg_error(p_api_name => l_proc,
2660: p_argument => 'period_of_service_id',
2661: p_argument_value => p_period_of_service_id);
2662: --
2663: if nvl(g_period_of_service_id, hr_api.g_number) = p_period_of_service_id then
2659: hr_api.mandatory_arg_error(p_api_name => l_proc,
2660: p_argument => 'period_of_service_id',
2661: p_argument_value => p_period_of_service_id);
2662: --
2663: if nvl(g_period_of_service_id, hr_api.g_number) = p_period_of_service_id then
2664: --
2665: -- The legislation code has already been found with a previous
2666: -- call to this function. Just return the value in the global
2667: -- variable.