41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
46: (p_api_name => l_proc
47: ,p_argument => 'period_of_placement_id'
48: ,p_argument_value => p_period_of_placement_id
49: );
67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc
111: ,p_argument => 'period_of_placement_id'
112: ,p_argument_value => p_period_of_placement_id
113: );
111: ,p_argument => 'period_of_placement_id'
112: ,p_argument_value => p_period_of_placement_id
113: );
114: --
115: if ( nvl(per_pdp_bus.g_period_of_placement_id, hr_api.g_number)
116: = p_period_of_placement_id) then
117: --
118: -- The legislation code has already been found with a previous
119: -- call to this function. Just return the value in the global
291: --
292: if l_api_updating
293: then
294: --
295: if nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
296: nvl(p_actual_termination_date, hr_api.g_date)
297: and p_actual_termination_date is not null
298: then
299: hr_utility.set_location(l_proc, 40);
292: if l_api_updating
293: then
294: --
295: if nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
296: nvl(p_actual_termination_date, hr_api.g_date)
297: and p_actual_termination_date is not null
298: then
299: hr_utility.set_location(l_proc, 40);
300: --
318: hr_utility.raise_error;
319: end if;
320: hr_utility.set_location(l_proc, 70);
321: --
322: if not (nvl(p_actual_termination_date, hr_api.g_eot) >=
323: p_date_start) then
324: --
325: -- CHK_ACTUAL_TERMINATION_DATE / b
326: --
444: hr_utility.set_location('Entering:'|| l_proc, 10);
445: --
446: -- CHK_DATE_START / a
447: --
448: hr_api.mandatory_arg_error
449: (p_api_name => l_proc
450: ,p_argument => 'date_start'
451: ,p_argument_value => p_date_start
452: );
515: --
516: hr_utility.set_location('Entering:'|| l_proc, 20);
517: --
518: if (l_api_updating
519: AND (nvl(per_pdp_shd.g_old_rec.projected_termination_date, hr_api.g_date) <>
520: nvl(p_projected_termination_date, hr_api.g_date)))
521: OR not l_api_updating
522: then
523: if nvl(p_projected_termination_date,hr_api.g_eot) < p_date_start
516: hr_utility.set_location('Entering:'|| l_proc, 20);
517: --
518: if (l_api_updating
519: AND (nvl(per_pdp_shd.g_old_rec.projected_termination_date, hr_api.g_date) <>
520: nvl(p_projected_termination_date, hr_api.g_date)))
521: OR not l_api_updating
522: then
523: if nvl(p_projected_termination_date,hr_api.g_eot) < p_date_start
524: then
519: AND (nvl(per_pdp_shd.g_old_rec.projected_termination_date, hr_api.g_date) <>
520: nvl(p_projected_termination_date, hr_api.g_date)))
521: OR not l_api_updating
522: then
523: if nvl(p_projected_termination_date,hr_api.g_eot) < p_date_start
524: then
525: --
526: -- CHK_PROJECTED_TERM_DATE / a
527: --
625: --
626: if l_api_updating
627: then
628: --
629: if nvl(per_pdp_shd.g_old_rec.final_process_date, hr_api.g_date) <>
630: nvl(p_final_process_date, hr_api.g_date)
631: then
632: --
633: hr_utility.set_location(l_proc, 6);
626: if l_api_updating
627: then
628: --
629: if nvl(per_pdp_shd.g_old_rec.final_process_date, hr_api.g_date) <>
630: nvl(p_final_process_date, hr_api.g_date)
631: then
632: --
633: hr_utility.set_location(l_proc, 6);
634: --
662: then
663: --
664: hr_utility.set_location(l_proc, 8);
665: --
666: if not (nvl(p_final_process_date, hr_api.g_eot) >=
667: nvl(p_actual_termination_date, hr_api.g_eot))
668: then
669: -- CHK_FINAL_PROCESS_DATE / f
670: --
663: --
664: hr_utility.set_location(l_proc, 8);
665: --
666: if not (nvl(p_final_process_date, hr_api.g_eot) >=
667: nvl(p_actual_termination_date, hr_api.g_eot))
668: then
669: -- CHK_FINAL_PROCESS_DATE / f
670: --
671: hr_utility.set_message(801,'HR_7963_PDS_INV_FP_BEFORE_ATT');
672: hr_utility.raise_error;
673: end if;
674: else
675: --
676: if not (nvl(p_final_process_date, hr_api.g_eot) >=
677: p_last_standard_process_date)
678: --
679: then
680: -- CHK_FINAL_PROCESS_DATE / c
786: --
787: if l_api_updating
788: then
789: --
790: if nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
791: nvl(p_last_standard_process_date, hr_api.g_date)
792: then
793: --
794: hr_utility.set_location(l_proc, 30);
787: if l_api_updating
788: then
789: --
790: if nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
791: nvl(p_last_standard_process_date, hr_api.g_date)
792: then
793: --
794: hr_utility.set_location(l_proc, 30);
795: --
854: end if;
855: --
856: hr_utility.set_location(l_proc, 80);
857: --
858: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=
859: nvl(p_actual_termination_date, hr_api.g_eot))
860: --
861: then
862: -- CHK_LAST_STANDARD_PROCESS_DATE / c
855: --
856: hr_utility.set_location(l_proc, 80);
857: --
858: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=
859: nvl(p_actual_termination_date, hr_api.g_eot))
860: --
861: then
862: -- CHK_LAST_STANDARD_PROCESS_DATE / c
863: --
868: hr_utility.set_location(l_proc, 90);
869: --
870: end if;
871: --
872: if (nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
873: nvl(p_actual_termination_date,hr_api.g_date) )
874: and (p_actual_termination_date is not null)
875: and l_legislation_code <> 'US'
876: then
869: --
870: end if;
871: --
872: if (nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
873: nvl(p_actual_termination_date,hr_api.g_date) )
874: and (p_actual_termination_date is not null)
875: and l_legislation_code <> 'US'
876: then
877: hr_utility.set_location(l_proc, 100);
995: -- b) The value for actual_termination_date or last_standard_process_date
996: -- has changed
997: --
998: if (l_api_updating
999: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1000: <> nvl(p_actual_termination_date, hr_api.g_date))
1001: or
1002: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1003: <> nvl(p_last_standard_process_date, hr_api.g_date))))
996: -- has changed
997: --
998: if (l_api_updating
999: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1000: <> nvl(p_actual_termination_date, hr_api.g_date))
1001: or
1002: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1003: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1004: or
998: if (l_api_updating
999: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1000: <> nvl(p_actual_termination_date, hr_api.g_date))
1001: or
1002: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1003: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1004: or
1005: NOT l_api_updating then
1006: --
999: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1000: <> nvl(p_actual_termination_date, hr_api.g_date))
1001: or
1002: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1003: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1004: or
1005: NOT l_api_updating then
1006: --
1007: hr_utility.set_location(l_proc, 30);
1108: --
1109: begin
1110: hr_utility.set_location('Entering:'|| l_proc, 1);
1111: --
1112: hr_api.mandatory_arg_error
1113: (p_api_name => l_proc
1114: ,p_argument => 'effective date'
1115: ,p_argument_value => p_effective_date
1116: );
1126: if l_api_updating
1127: and p_termination_reason is not null
1128: then
1129: --
1130: if nvl(per_pdp_shd.g_old_rec.termination_reason, hr_api.g_varchar2) <>
1131: nvl(p_termination_reason, hr_api.g_varchar2)
1132: then
1133: --
1134: -- Bug 1472162.
1127: and p_termination_reason is not null
1128: then
1129: --
1130: if nvl(per_pdp_shd.g_old_rec.termination_reason, hr_api.g_varchar2) <>
1131: nvl(p_termination_reason, hr_api.g_varchar2)
1132: then
1133: --
1134: -- Bug 1472162.
1135: --
1132: then
1133: --
1134: -- Bug 1472162.
1135: --
1136: -- if hr_api.not_exists_in_hr_lookups
1137: if hr_api.not_exists_in_leg_lookups
1138: (p_effective_date => p_effective_date
1139: ,p_lookup_type => 'HR_CWK_TERMINATION_REASONS'
1140: ,p_lookup_code => p_termination_reason
1133: --
1134: -- Bug 1472162.
1135: --
1136: -- if hr_api.not_exists_in_hr_lookups
1137: if hr_api.not_exists_in_leg_lookups
1138: (p_effective_date => p_effective_date
1139: ,p_lookup_type => 'HR_CWK_TERMINATION_REASONS'
1140: ,p_lookup_code => p_termination_reason
1141: ) then
1218: hr_utility.set_location('Entering:'|| l_proc, 10);
1219: --
1220: -- CHK_PERSON_ID / a
1221: --
1222: hr_api.mandatory_arg_error
1223: (p_api_name => l_proc
1224: ,p_argument => 'person_id'
1225: ,p_argument_value => p_person_id
1226: );
1307: hr_utility.set_location('Entering:'|| l_proc, 1);
1308: --
1309: -- Check mandatory parameters have been set
1310: --
1311: hr_api.mandatory_arg_error
1312: (p_api_name => l_proc
1313: ,p_argument => 'person_id'
1314: ,p_argument_value => p_person_id
1315: );
1314: ,p_argument_value => p_person_id
1315: );
1316: hr_utility.set_location(l_proc, 4);
1317: --
1318: hr_api.mandatory_arg_error
1319: (p_api_name => l_proc
1320: ,p_argument => 'date_start'
1321: ,p_argument_value => p_date_start
1322: );
1405: begin
1406: hr_utility.set_location('Entering:'||l_proc,10);
1407: --
1408: if ((p_rec.period_of_placement_id is not null) and (
1409: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1410: nvl(p_rec.information_category, hr_api.g_varchar2) or
1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1406: hr_utility.set_location('Entering:'||l_proc,10);
1407: --
1408: if ((p_rec.period_of_placement_id is not null) and (
1409: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1410: nvl(p_rec.information_category, hr_api.g_varchar2) or
1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1407: --
1408: if ((p_rec.period_of_placement_id is not null) and (
1409: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1410: nvl(p_rec.information_category, hr_api.g_varchar2) or
1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1408: if ((p_rec.period_of_placement_id is not null) and (
1409: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1410: nvl(p_rec.information_category, hr_api.g_varchar2) or
1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1409: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1410: nvl(p_rec.information_category, hr_api.g_varchar2) or
1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1410: nvl(p_rec.information_category, hr_api.g_varchar2) or
1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1468: nvl(p_rec.information29, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1468: nvl(p_rec.information29, hr_api.g_varchar2) or
1469: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1468: nvl(p_rec.information29, hr_api.g_varchar2) or
1469: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1470: nvl(p_rec.information30, hr_api.g_varchar2) ))
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1468: nvl(p_rec.information29, hr_api.g_varchar2) or
1469: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1470: nvl(p_rec.information30, hr_api.g_varchar2) ))
1471: or (p_rec.period_of_placement_id is null) then
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1468: nvl(p_rec.information29, hr_api.g_varchar2) or
1469: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1470: nvl(p_rec.information30, hr_api.g_varchar2) ))
1471: or (p_rec.period_of_placement_id is null) then
1472: --
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1468: nvl(p_rec.information29, hr_api.g_varchar2) or
1469: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1470: nvl(p_rec.information30, hr_api.g_varchar2) ))
1471: or (p_rec.period_of_placement_id is null) then
1472: --
1473: -- Only execute the validation if absolutely necessary:
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1468: nvl(p_rec.information29, hr_api.g_varchar2) or
1469: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1470: nvl(p_rec.information30, hr_api.g_varchar2) ))
1471: or (p_rec.period_of_placement_id is null) then
1472: --
1473: -- Only execute the validation if absolutely necessary:
1474: -- a) During update, the structure column value or any
1583: begin
1584: hr_utility.set_location('Entering:'||l_proc,10);
1585: --
1586: if ((p_rec.period_of_placement_id is not null) and (
1587: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1588: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1584: hr_utility.set_location('Entering:'||l_proc,10);
1585: --
1586: if ((p_rec.period_of_placement_id is not null) and (
1587: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1588: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1585: --
1586: if ((p_rec.period_of_placement_id is not null) and (
1587: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1588: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1586: if ((p_rec.period_of_placement_id is not null) and (
1587: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1588: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1587: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1588: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1588: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1646: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1646: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1647: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1646: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1647: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1648: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1646: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1647: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1648: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1649: or (p_rec.period_of_placement_id is null) then
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1646: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1647: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1648: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1649: or (p_rec.period_of_placement_id is null) then
1650: --
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1646: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1647: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1648: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1649: or (p_rec.period_of_placement_id is null) then
1650: --
1651: -- Only execute the validation if absolutely necessary:
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1646: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1647: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1648: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1649: or (p_rec.period_of_placement_id is null) then
1650: --
1651: -- Only execute the validation if absolutely necessary:
1652: -- a) During update, the structure column value or any
1789: hr_utility.set_location('Entering:'||l_proc, 5);
1790: --
1791: -- Call all supporting business operations
1792: --
1793: hr_api.validate_bus_grp_id
1794: (p_business_group_id => p_rec.business_group_id
1795: ,p_associated_column1 => per_pdp_shd.g_tab_nam
1796: || '.BUSINESS_GROUP_ID');
1797:
1981: hr_utility.set_location('Entering:'||l_proc, 5);
1982: --
1983: -- Call all supporting business operations
1984: --
1985: hr_api.validate_bus_grp_id
1986: (p_business_group_id => p_rec.business_group_id
1987: ,p_associated_column1 => per_pdp_shd.g_tab_nam
1988: || '.BUSINESS_GROUP_ID');
1989: