[Home] [Help]
148: hr_utility.set_location('Entering:'|| l_proc, 1);
149: --
150: -- Check mandatory parameters have been set
151: --
152: hr_api.mandatory_arg_error
153: (p_api_name => l_proc
154: ,p_argument => 'date_start'
155: ,p_argument_value => p_date_start
156: );
167: --
168: if l_api_updating
169: then
170: --
171: if nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
172: nvl(p_actual_termination_date, hr_api.g_date)
173: and p_actual_termination_date is not null
174: then
175: hr_utility.set_location(l_proc, 40);
168: if l_api_updating
169: then
170: --
171: if nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
172: nvl(p_actual_termination_date, hr_api.g_date)
173: and p_actual_termination_date is not null
174: then
175: hr_utility.set_location(l_proc, 40);
176: --
194: hr_utility.raise_error;
195: end if;
196: hr_utility.set_location(l_proc, 70);
197: --
198: if not (nvl(p_actual_termination_date, hr_api.g_eot) >=
199: p_date_start) then
200: --
201: -- CHK_ACTUAL_TERMINATION_DATE / b
202: --
321: hr_utility.set_location('Entering:'|| l_proc, 1);
322: --
323: -- CHK_DATE_START / a
324: --
325: hr_api.mandatory_arg_error
326: (p_api_name => l_proc
327: ,p_argument => 'date_start'
328: ,p_argument_value => p_date_start
329: );
436: hr_utility.set_location('Entering:'|| l_proc, 1);
437: --
438: -- Check mandatory parameters have been set
439: --
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc
442: ,p_argument => 'date_start'
443: ,p_argument_value => p_date_start
444: );
455: --
456: if l_api_updating
457: then
458: --
459: if nvl(per_pds_shd.g_old_rec.final_process_date, hr_api.g_date) <>
460: nvl(p_final_process_date, hr_api.g_date)
461: then
462: --
463: hr_utility.set_location(l_proc, 6);
456: if l_api_updating
457: then
458: --
459: if nvl(per_pds_shd.g_old_rec.final_process_date, hr_api.g_date) <>
460: nvl(p_final_process_date, hr_api.g_date)
461: then
462: --
463: hr_utility.set_location(l_proc, 6);
464: --
676: then
677: --
678: hr_utility.set_location(l_proc, 8);
679: --
680: if not (nvl(p_final_process_date, hr_api.g_eot) >=
681: nvl(p_actual_termination_date, hr_api.g_eot))
682: then
683: -- CHK_FINAL_PROCESS_DATE / f
684: --
677: --
678: hr_utility.set_location(l_proc, 8);
679: --
680: if not (nvl(p_final_process_date, hr_api.g_eot) >=
681: nvl(p_actual_termination_date, hr_api.g_eot))
682: then
683: -- CHK_FINAL_PROCESS_DATE / f
684: --
685: hr_utility.set_message(801,'HR_7963_PDS_INV_FP_BEFORE_ATT');
688: else
689: --
690: -- 70.1 change a start.
691: --
692: if not (nvl(p_final_process_date, hr_api.g_eot) >=
693: p_last_standard_process_date)
694: --
695: -- 70.1 change a end.
696: --
801: hr_utility.set_location('Entering:'|| l_proc, 1);
802: --
803: -- Check mandatory parameters have been set
804: --
805: hr_api.mandatory_arg_error
806: (p_api_name => l_proc
807: ,p_argument => 'date_start'
808: ,p_argument_value => p_date_start
809: );
820: --
821: if l_api_updating
822: then
823: --
824: if nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
825: nvl(p_last_standard_process_date, hr_api.g_date)
826: then
827: --
828: hr_utility.set_location(l_proc, 30);
821: if l_api_updating
822: then
823: --
824: if nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
825: nvl(p_last_standard_process_date, hr_api.g_date)
826: then
827: --
828: hr_utility.set_location(l_proc, 30);
829: --
890: hr_utility.set_location(l_proc, 80);
891: --
892: -- 70.1 change a start.
893: --
894: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=
895: nvl(p_actual_termination_date, hr_api.g_eot))
896: --
897: -- 70.1 change a end.
898: --
891: --
892: -- 70.1 change a start.
893: --
894: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=
895: nvl(p_actual_termination_date, hr_api.g_eot))
896: --
897: -- 70.1 change a end.
898: --
899: then
908: end if;
909: --
910: -- 70.16 change h start.
911: --
912: if (nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
913: nvl(p_actual_termination_date,hr_api.g_date) )
914: and (p_actual_termination_date is not null)
915: and l_legislation_code <> 'US'
916: --
909: --
910: -- 70.16 change h start.
911: --
912: if (nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
913: nvl(p_actual_termination_date,hr_api.g_date) )
914: and (p_actual_termination_date is not null)
915: and l_legislation_code <> 'US'
916: --
917: then
1024: -- b) The value for actual_termination_date or last_standard_process_date
1025: -- has changed
1026: --
1027: if (l_api_updating
1028: and ((nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1029: <> nvl(p_actual_termination_date, hr_api.g_date))
1030: or
1031: (nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1032: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1025: -- has changed
1026: --
1027: if (l_api_updating
1028: and ((nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1029: <> nvl(p_actual_termination_date, hr_api.g_date))
1030: or
1031: (nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1032: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1033: or
1027: if (l_api_updating
1028: and ((nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1029: <> nvl(p_actual_termination_date, hr_api.g_date))
1030: or
1031: (nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1032: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1033: or
1034: NOT l_api_updating then
1035: --
1028: and ((nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1029: <> nvl(p_actual_termination_date, hr_api.g_date))
1030: or
1031: (nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1032: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1033: or
1034: NOT l_api_updating then
1035: --
1036: hr_utility.set_location(l_proc, 30);
1120: --
1121: begin
1122: hr_utility.set_location('Entering:'|| l_proc, 1);
1123: --
1124: hr_api.mandatory_arg_error
1125: (p_api_name => l_proc
1126: ,p_argument => 'effective date'
1127: ,p_argument_value => p_effective_date
1128: );
1138: if l_api_updating
1139: and p_leaving_reason is not null
1140: then
1141: --
1142: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <>
1143: nvl(p_leaving_reason, hr_api.g_varchar2)
1144: then
1145: --
1146: -- Bug 1472162.
1139: and p_leaving_reason is not null
1140: then
1141: --
1142: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <>
1143: nvl(p_leaving_reason, hr_api.g_varchar2)
1144: then
1145: --
1146: -- Bug 1472162.
1147: --
1144: then
1145: --
1146: -- Bug 1472162.
1147: --
1148: -- if hr_api.not_exists_in_hr_lookups
1149: if hr_api.not_exists_in_leg_lookups
1150: (p_effective_date => p_effective_date
1151: ,p_lookup_type => 'LEAV_REAS'
1152: ,p_lookup_code => p_leaving_reason
1145: --
1146: -- Bug 1472162.
1147: --
1148: -- if hr_api.not_exists_in_hr_lookups
1149: if hr_api.not_exists_in_leg_lookups
1150: (p_effective_date => p_effective_date
1151: ,p_lookup_type => 'LEAV_REAS'
1152: ,p_lookup_code => p_leaving_reason
1153: ) then
1224: hr_utility.set_location('Entering:'|| l_proc, 1);
1225: --
1226: -- Check mandatory parameters have been set
1227: --
1228: hr_api.mandatory_arg_error
1229: (p_api_name => l_proc
1230: ,p_argument => 'date_start'
1231: ,p_argument_value => p_date_start
1232: );
1234: hr_utility.set_location(l_proc, 2);
1235: --
1236: -- 70.1 change a start.
1237: --
1238: if not (nvl(p_notified_termination_date, hr_api.g_eot) >=
1239: nvl(p_date_start, hr_api.g_date))
1240: --
1241: -- 70.1 change a end.
1242: --
1235: --
1236: -- 70.1 change a start.
1237: --
1238: if not (nvl(p_notified_termination_date, hr_api.g_eot) >=
1239: nvl(p_date_start, hr_api.g_date))
1240: --
1241: -- 70.1 change a end.
1242: --
1243: then
1319: hr_utility.set_location('Entering:'|| l_proc, 1);
1320: --
1321: -- CHK_PERSON_ID / a
1322: --
1323: hr_api.mandatory_arg_error
1324: (p_api_name => l_proc
1325: ,p_argument => 'person_id'
1326: ,p_argument_value => p_person_id
1327: );
1327: );
1328: hr_utility.set_location(l_proc, 2);
1329: --
1330: if not (p_person_id <>
1331: nvl(p_termination_accepted_person, hr_api.g_number))
1332: then
1333: -- CHK_PERSON_ID / c
1334: --
1335: hr_utility.set_message(801,'HR_7488_PDS_INV_TAP_ID');
1399: hr_utility.set_location('Entering:'|| l_proc, 1);
1400: --
1401: -- Check mandatory parameters have been set
1402: --
1403: hr_api.mandatory_arg_error
1404: (p_api_name => l_proc
1405: ,p_argument => 'person_id'
1406: ,p_argument_value => p_person_id
1407: );
1406: ,p_argument_value => p_person_id
1407: );
1408: hr_utility.set_location(l_proc, 4);
1409: --
1410: hr_api.mandatory_arg_error
1411: (p_api_name => l_proc
1412: ,p_argument => 'date_start'
1413: ,p_argument_value => p_date_start
1414: );
1515: hr_utility.set_location('Entering:'|| l_proc, 1);
1516: --
1517: -- Check mandatory parameters have been set
1518: --
1519: hr_api.mandatory_arg_error
1520: (p_api_name => l_proc
1521: ,p_argument => 'date_start'
1522: ,p_argument_value => p_date_start
1523: );
1525: hr_utility.set_location(l_proc, 2);
1526: --
1527: -- 70.1 change a start.
1528: --
1529: if not (nvl(p_projected_termination_date, hr_api.g_eot) >=
1530: nvl(p_date_start, hr_api.g_date))
1531: --
1532: -- 70.1 change a end.
1533: --
1526: --
1527: -- 70.1 change a start.
1528: --
1529: if not (nvl(p_projected_termination_date, hr_api.g_eot) >=
1530: nvl(p_date_start, hr_api.g_date))
1531: --
1532: -- 70.1 change a end.
1533: --
1534: then
1631: hr_utility.set_location('Entering:'|| l_proc, 1);
1632: --
1633: -- Check mandatory parameters have been set
1634: --
1635: hr_api.mandatory_arg_error
1636: (p_api_name => l_proc
1637: ,p_argument => 'person_id'
1638: ,p_argument_value => p_person_id
1639: );
1649: if l_api_updating
1650: then
1651: --
1652: if (nvl(per_pds_shd.g_old_rec.termination_accepted_person_id, -- Bug # 2282955. This right hand side part of the condtion
1653: hr_api.g_number) <> -- is modified from nvl(p_termination_acceted_person,
1654: nvl(p_termination_accepted_person, nvl( -- hr_api.g_number) to nvl(p_termination_acceted_person,
1655: 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,
1656: then -- hr_api.g_number))
1657: --
1650: then
1651: --
1652: if (nvl(per_pds_shd.g_old_rec.termination_accepted_person_id, -- Bug # 2282955. This right hand side part of the condtion
1653: hr_api.g_number) <> -- is modified from nvl(p_termination_acceted_person,
1654: nvl(p_termination_accepted_person, nvl( -- hr_api.g_number) to nvl(p_termination_acceted_person,
1655: 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,
1656: then -- hr_api.g_number))
1657: --
1658: -- CHK_TERMINATION_ACCEPTED_PERSON_ID / b
1651: --
1652: if (nvl(per_pds_shd.g_old_rec.termination_accepted_person_id, -- Bug # 2282955. This right hand side part of the condtion
1653: hr_api.g_number) <> -- is modified from nvl(p_termination_acceted_person,
1654: nvl(p_termination_accepted_person, nvl( -- hr_api.g_number) to nvl(p_termination_acceted_person,
1655: 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,
1656: then -- hr_api.g_number))
1657: --
1658: -- CHK_TERMINATION_ACCEPTED_PERSON_ID / b
1659: --
1652: if (nvl(per_pds_shd.g_old_rec.termination_accepted_person_id, -- Bug # 2282955. This right hand side part of the condtion
1653: hr_api.g_number) <> -- is modified from nvl(p_termination_acceted_person,
1654: nvl(p_termination_accepted_person, nvl( -- hr_api.g_number) to nvl(p_termination_acceted_person,
1655: 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,
1656: then -- hr_api.g_number))
1657: --
1658: -- CHK_TERMINATION_ACCEPTED_PERSON_ID / b
1659: --
1660: if (nvl(p_termination_accepted_person, hr_api.g_number) =
1656: then -- hr_api.g_number))
1657: --
1658: -- CHK_TERMINATION_ACCEPTED_PERSON_ID / b
1659: --
1660: if (nvl(p_termination_accepted_person, hr_api.g_number) =
1661: per_pds_shd.g_old_rec.person_id)
1662: then
1663: hr_utility.set_message(801,'HR_7488_PDS_INV_TAP_ID');
1664: hr_utility.raise_error;
1755: end if;
1756: --
1757: hr_utility.set_location(l_proc, 6);
1758: --
1759: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1760: nvl(per_pds_shd.g_old_rec.business_group_id, hr_api.g_number)
1761: then
1762: -- CHK_BUSINESS_GROUP_ID / b
1763: --
1756: --
1757: hr_utility.set_location(l_proc, 6);
1758: --
1759: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1760: nvl(per_pds_shd.g_old_rec.business_group_id, hr_api.g_number)
1761: then
1762: -- CHK_BUSINESS_GROUP_ID / b
1763: --
1764: l_argument := 'business_group_id';
1766: end if;
1767: --
1768: hr_utility.set_location(l_proc, 7);
1769: --
1770: if nvl(p_rec.period_of_service_id, hr_api.g_number) <>
1771: nvl(per_pds_shd.g_old_rec.period_of_service_id, hr_api.g_number)
1772: then
1773: -- CHK_PERIOD_OF_SERVICE_ID / c
1774: --
1767: --
1768: hr_utility.set_location(l_proc, 7);
1769: --
1770: if nvl(p_rec.period_of_service_id, hr_api.g_number) <>
1771: nvl(per_pds_shd.g_old_rec.period_of_service_id, hr_api.g_number)
1772: then
1773: -- CHK_PERIOD_OF_SERVICE_ID / c
1774: --
1775: l_argument := 'period_of_service_id';
1777: end if;
1778: --
1779: hr_utility.set_location(l_proc, 8);
1780: --
1781: if nvl(p_rec.person_id, hr_api.g_number) <>
1782: nvl(per_pds_shd.g_old_rec.person_id, hr_api.g_number)
1783: then
1784: -- CHK_PERSON_ID / b
1785: --
1778: --
1779: hr_utility.set_location(l_proc, 8);
1780: --
1781: if nvl(p_rec.person_id, hr_api.g_number) <>
1782: nvl(per_pds_shd.g_old_rec.person_id, hr_api.g_number)
1783: then
1784: -- CHK_PERSON_ID / b
1785: --
1786: l_argument := 'person_id';
1792: exception
1793: when l_error
1794: then
1795: --
1796: hr_api.argument_changed_error
1797: (p_api_name => l_proc
1798: ,p_argument => l_argument);
1799: when others then
1800: raise;
1884: --
1885: --
1886: If ( (p_rec.period_of_service_id is not null)
1887: and
1888: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1885: --
1886: If ( (p_rec.period_of_service_id is not null)
1887: and
1888: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1886: If ( (p_rec.period_of_service_id is not null)
1887: and
1888: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1887: and
1888: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1888: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1927: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1927: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1928: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1927: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1928: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1929: nvl(p_rec.attribute20, hr_api.g_varchar2)
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1927: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1928: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1929: nvl(p_rec.attribute20, hr_api.g_varchar2)
1930: )
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1927: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1928: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1929: nvl(p_rec.attribute20, hr_api.g_varchar2)
1930: )
1931: or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1927: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1928: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1929: nvl(p_rec.attribute20, hr_api.g_varchar2)
1930: )
1931: or
1932: (
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1927: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1928: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1929: nvl(p_rec.attribute20, hr_api.g_varchar2)
1930: )
1931: or
1932: (
1933: -- Added the check for date_start and adjusted_svc_date for fix
1931: or
1932: (
1933: -- Added the check for date_start and adjusted_svc_date for fix
1934: -- of #1577252
1935: ( nvl(per_pds_shd.g_old_rec.adjusted_svc_date, hr_api.g_date) =
1936: nvl(p_rec.adjusted_svc_date, hr_api.g_date) ) and
1937: ( nvl(per_pds_shd.g_old_rec.date_start, hr_api.g_date) =
1938: nvl(p_rec.date_start, hr_api.g_date) ) and
1939: (p_rec.attribute_category is null) and
1932: (
1933: -- Added the check for date_start and adjusted_svc_date for fix
1934: -- of #1577252
1935: ( nvl(per_pds_shd.g_old_rec.adjusted_svc_date, hr_api.g_date) =
1936: nvl(p_rec.adjusted_svc_date, hr_api.g_date) ) and
1937: ( nvl(per_pds_shd.g_old_rec.date_start, hr_api.g_date) =
1938: nvl(p_rec.date_start, hr_api.g_date) ) and
1939: (p_rec.attribute_category is null) and
1940: (p_rec.attribute1 is null) and
1933: -- Added the check for date_start and adjusted_svc_date for fix
1934: -- of #1577252
1935: ( nvl(per_pds_shd.g_old_rec.adjusted_svc_date, hr_api.g_date) =
1936: nvl(p_rec.adjusted_svc_date, hr_api.g_date) ) and
1937: ( nvl(per_pds_shd.g_old_rec.date_start, hr_api.g_date) =
1938: nvl(p_rec.date_start, hr_api.g_date) ) and
1939: (p_rec.attribute_category is null) and
1940: (p_rec.attribute1 is null) and
1941: (p_rec.attribute2 is null) and
1934: -- of #1577252
1935: ( nvl(per_pds_shd.g_old_rec.adjusted_svc_date, hr_api.g_date) =
1936: nvl(p_rec.adjusted_svc_date, hr_api.g_date) ) and
1937: ( nvl(per_pds_shd.g_old_rec.date_start, hr_api.g_date) =
1938: nvl(p_rec.date_start, hr_api.g_date) ) and
1939: (p_rec.attribute_category is null) and
1940: (p_rec.attribute1 is null) and
1941: (p_rec.attribute2 is null) and
1942: (p_rec.attribute3 is null) and
2064: -- value has changed
2065: --
2066: if (p_rec.period_of_service_id is null) or
2067: ((p_rec.period_of_service_id is not null) and
2068: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2069: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2065: --
2066: if (p_rec.period_of_service_id is null) or
2067: ((p_rec.period_of_service_id is not null) and
2068: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2069: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2066: if (p_rec.period_of_service_id is null) or
2067: ((p_rec.period_of_service_id is not null) and
2068: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2069: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2067: ((p_rec.period_of_service_id is not null) and
2068: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2069: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2068: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2069: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2069: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2127: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2127: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2128: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2127: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2128: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2129: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2127: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2128: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2129: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2130: --
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2127: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2128: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2129: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2130: --
2131: hr_dflex_utility.ins_or_upd_descflex_attribs
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2127: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2128: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2129: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2130: --
2131: hr_dflex_utility.ins_or_upd_descflex_attribs
2132: (p_appl_short_name => 'PER'
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2127: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2128: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2129: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2130: --
2131: hr_dflex_utility.ins_or_upd_descflex_attribs
2132: (p_appl_short_name => 'PER'
2133: ,p_descflex_name => 'PER_PDS_DEVELOPER_DF'
2219: -- Business Rule Mapping
2220: -- =====================
2221: -- CHK_BUSINESS_GROUP_ID / a,c
2222: --
2223: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2224: --
2225: hr_utility.set_location(l_proc, 2);
2226: --
2227: --
2451: -- Business Rule Mapping
2452: -- =====================
2453: -- CHK_BUSINESS_GROUP_ID / a,c
2454: --
2455: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2456: --
2457: hr_utility.set_location(l_proc, 3);
2458: --
2459: --
2676: hr_utility.set_location('Entering:'|| l_proc, 10);
2677: --
2678: -- Ensure that all the mandatory parameter are not null
2679: --
2680: hr_api.mandatory_arg_error(p_api_name => l_proc,
2681: p_argument => 'period_of_service_id',
2682: p_argument_value => p_period_of_service_id);
2683: --
2684: if nvl(g_period_of_service_id, hr_api.g_number) = p_period_of_service_id then
2680: hr_api.mandatory_arg_error(p_api_name => l_proc,
2681: p_argument => 'period_of_service_id',
2682: p_argument_value => p_period_of_service_id);
2683: --
2684: if nvl(g_period_of_service_id, hr_api.g_number) = p_period_of_service_id then
2685: --
2686: -- The legislation code has already been found with a previous
2687: -- call to this function. Just return the value in the global
2688: -- variable.