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: --
441: hr_utility.set_location('Entering:'|| l_proc, 10);
442: --
443: -- CHK_DATE_START / a
444: --
445: hr_api.mandatory_arg_error
446: (p_api_name => l_proc
447: ,p_argument => 'date_start'
448: ,p_argument_value => p_date_start
449: );
512: --
513: hr_utility.set_location('Entering:'|| l_proc, 20);
514: --
515: if (l_api_updating
516: AND (nvl(per_pdp_shd.g_old_rec.projected_termination_date, hr_api.g_date) <>
517: nvl(p_projected_termination_date, hr_api.g_date)))
518: OR not l_api_updating
519: then
520: if nvl(p_projected_termination_date,hr_api.g_eot) < p_date_start
513: hr_utility.set_location('Entering:'|| l_proc, 20);
514: --
515: if (l_api_updating
516: AND (nvl(per_pdp_shd.g_old_rec.projected_termination_date, hr_api.g_date) <>
517: nvl(p_projected_termination_date, hr_api.g_date)))
518: OR not l_api_updating
519: then
520: if nvl(p_projected_termination_date,hr_api.g_eot) < p_date_start
521: then
516: AND (nvl(per_pdp_shd.g_old_rec.projected_termination_date, hr_api.g_date) <>
517: nvl(p_projected_termination_date, hr_api.g_date)))
518: OR not l_api_updating
519: then
520: if nvl(p_projected_termination_date,hr_api.g_eot) < p_date_start
521: then
522: --
523: -- CHK_PROJECTED_TERM_DATE / a
524: --
622: --
623: if l_api_updating
624: then
625: --
626: if nvl(per_pdp_shd.g_old_rec.final_process_date, hr_api.g_date) <>
627: nvl(p_final_process_date, hr_api.g_date)
628: then
629: --
630: hr_utility.set_location(l_proc, 6);
623: if l_api_updating
624: then
625: --
626: if nvl(per_pdp_shd.g_old_rec.final_process_date, hr_api.g_date) <>
627: nvl(p_final_process_date, hr_api.g_date)
628: then
629: --
630: hr_utility.set_location(l_proc, 6);
631: --
659: then
660: --
661: hr_utility.set_location(l_proc, 8);
662: --
663: if not (nvl(p_final_process_date, hr_api.g_eot) >=
664: nvl(p_actual_termination_date, hr_api.g_eot))
665: then
666: -- CHK_FINAL_PROCESS_DATE / f
667: --
660: --
661: hr_utility.set_location(l_proc, 8);
662: --
663: if not (nvl(p_final_process_date, hr_api.g_eot) >=
664: nvl(p_actual_termination_date, hr_api.g_eot))
665: then
666: -- CHK_FINAL_PROCESS_DATE / f
667: --
668: hr_utility.set_message(801,'HR_7963_PDS_INV_FP_BEFORE_ATT');
669: hr_utility.raise_error;
670: end if;
671: else
672: --
673: if not (nvl(p_final_process_date, hr_api.g_eot) >=
674: p_last_standard_process_date)
675: --
676: then
677: -- CHK_FINAL_PROCESS_DATE / c
783: --
784: if l_api_updating
785: then
786: --
787: if nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
788: nvl(p_last_standard_process_date, hr_api.g_date)
789: then
790: --
791: hr_utility.set_location(l_proc, 30);
784: if l_api_updating
785: then
786: --
787: if nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
788: nvl(p_last_standard_process_date, hr_api.g_date)
789: then
790: --
791: hr_utility.set_location(l_proc, 30);
792: --
851: end if;
852: --
853: hr_utility.set_location(l_proc, 80);
854: --
855: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=
856: nvl(p_actual_termination_date, hr_api.g_eot))
857: --
858: then
859: -- CHK_LAST_STANDARD_PROCESS_DATE / c
852: --
853: hr_utility.set_location(l_proc, 80);
854: --
855: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=
856: nvl(p_actual_termination_date, hr_api.g_eot))
857: --
858: then
859: -- CHK_LAST_STANDARD_PROCESS_DATE / c
860: --
865: hr_utility.set_location(l_proc, 90);
866: --
867: end if;
868: --
869: if (nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
870: nvl(p_actual_termination_date,hr_api.g_date) )
871: and (p_actual_termination_date is not null)
872: and l_legislation_code <> 'US'
873: then
866: --
867: end if;
868: --
869: if (nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
870: nvl(p_actual_termination_date,hr_api.g_date) )
871: and (p_actual_termination_date is not null)
872: and l_legislation_code <> 'US'
873: then
874: hr_utility.set_location(l_proc, 100);
992: -- b) The value for actual_termination_date or last_standard_process_date
993: -- has changed
994: --
995: if (l_api_updating
996: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)
997: <> nvl(p_actual_termination_date, hr_api.g_date))
998: or
999: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1000: <> nvl(p_last_standard_process_date, hr_api.g_date))))
993: -- has changed
994: --
995: if (l_api_updating
996: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)
997: <> nvl(p_actual_termination_date, hr_api.g_date))
998: or
999: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1000: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1001: or
995: if (l_api_updating
996: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)
997: <> nvl(p_actual_termination_date, hr_api.g_date))
998: or
999: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1000: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1001: or
1002: NOT l_api_updating then
1003: --
996: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)
997: <> nvl(p_actual_termination_date, hr_api.g_date))
998: or
999: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1000: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1001: or
1002: NOT l_api_updating then
1003: --
1004: hr_utility.set_location(l_proc, 30);
1105: --
1106: begin
1107: hr_utility.set_location('Entering:'|| l_proc, 1);
1108: --
1109: hr_api.mandatory_arg_error
1110: (p_api_name => l_proc
1111: ,p_argument => 'effective date'
1112: ,p_argument_value => p_effective_date
1113: );
1123: if l_api_updating
1124: and p_termination_reason is not null
1125: then
1126: --
1127: if nvl(per_pdp_shd.g_old_rec.termination_reason, hr_api.g_varchar2) <>
1128: nvl(p_termination_reason, hr_api.g_varchar2)
1129: then
1130: --
1131: -- Bug 1472162.
1124: and p_termination_reason is not null
1125: then
1126: --
1127: if nvl(per_pdp_shd.g_old_rec.termination_reason, hr_api.g_varchar2) <>
1128: nvl(p_termination_reason, hr_api.g_varchar2)
1129: then
1130: --
1131: -- Bug 1472162.
1132: --
1129: then
1130: --
1131: -- Bug 1472162.
1132: --
1133: -- if hr_api.not_exists_in_hr_lookups
1134: if hr_api.not_exists_in_leg_lookups
1135: (p_effective_date => p_effective_date
1136: ,p_lookup_type => 'HR_CWK_TERMINATION_REASONS'
1137: ,p_lookup_code => p_termination_reason
1130: --
1131: -- Bug 1472162.
1132: --
1133: -- if hr_api.not_exists_in_hr_lookups
1134: if hr_api.not_exists_in_leg_lookups
1135: (p_effective_date => p_effective_date
1136: ,p_lookup_type => 'HR_CWK_TERMINATION_REASONS'
1137: ,p_lookup_code => p_termination_reason
1138: ) then
1215: hr_utility.set_location('Entering:'|| l_proc, 10);
1216: --
1217: -- CHK_PERSON_ID / a
1218: --
1219: hr_api.mandatory_arg_error
1220: (p_api_name => l_proc
1221: ,p_argument => 'person_id'
1222: ,p_argument_value => p_person_id
1223: );
1304: hr_utility.set_location('Entering:'|| l_proc, 1);
1305: --
1306: -- Check mandatory parameters have been set
1307: --
1308: hr_api.mandatory_arg_error
1309: (p_api_name => l_proc
1310: ,p_argument => 'person_id'
1311: ,p_argument_value => p_person_id
1312: );
1311: ,p_argument_value => p_person_id
1312: );
1313: hr_utility.set_location(l_proc, 4);
1314: --
1315: hr_api.mandatory_arg_error
1316: (p_api_name => l_proc
1317: ,p_argument => 'date_start'
1318: ,p_argument_value => p_date_start
1319: );
1402: begin
1403: hr_utility.set_location('Entering:'||l_proc,10);
1404: --
1405: if ((p_rec.period_of_placement_id is not null) and (
1406: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1407: nvl(p_rec.information_category, hr_api.g_varchar2) or
1408: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1409: nvl(p_rec.information1, hr_api.g_varchar2) or
1410: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1403: hr_utility.set_location('Entering:'||l_proc,10);
1404: --
1405: if ((p_rec.period_of_placement_id is not null) and (
1406: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1407: nvl(p_rec.information_category, hr_api.g_varchar2) or
1408: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1409: nvl(p_rec.information1, hr_api.g_varchar2) or
1410: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1411: nvl(p_rec.information2, hr_api.g_varchar2) or
1404: --
1405: if ((p_rec.period_of_placement_id is not null) and (
1406: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1407: nvl(p_rec.information_category, hr_api.g_varchar2) or
1408: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1409: nvl(p_rec.information1, hr_api.g_varchar2) or
1410: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1411: nvl(p_rec.information2, hr_api.g_varchar2) or
1412: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1405: if ((p_rec.period_of_placement_id is not null) and (
1406: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1407: nvl(p_rec.information_category, hr_api.g_varchar2) or
1408: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1409: nvl(p_rec.information1, hr_api.g_varchar2) or
1410: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1411: nvl(p_rec.information2, hr_api.g_varchar2) or
1412: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1413: nvl(p_rec.information3, hr_api.g_varchar2) or
1406: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1407: nvl(p_rec.information_category, hr_api.g_varchar2) or
1408: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1409: nvl(p_rec.information1, hr_api.g_varchar2) or
1410: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1411: nvl(p_rec.information2, hr_api.g_varchar2) or
1412: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1413: nvl(p_rec.information3, hr_api.g_varchar2) or
1414: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1407: nvl(p_rec.information_category, hr_api.g_varchar2) or
1408: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1409: nvl(p_rec.information1, hr_api.g_varchar2) or
1410: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1411: nvl(p_rec.information2, hr_api.g_varchar2) or
1412: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1413: nvl(p_rec.information3, hr_api.g_varchar2) or
1414: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1415: nvl(p_rec.information4, hr_api.g_varchar2) or
1408: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1409: nvl(p_rec.information1, hr_api.g_varchar2) or
1410: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1411: nvl(p_rec.information2, hr_api.g_varchar2) or
1412: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1413: nvl(p_rec.information3, hr_api.g_varchar2) or
1414: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1415: nvl(p_rec.information4, hr_api.g_varchar2) or
1416: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1409: nvl(p_rec.information1, hr_api.g_varchar2) or
1410: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1411: nvl(p_rec.information2, hr_api.g_varchar2) or
1412: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1413: nvl(p_rec.information3, hr_api.g_varchar2) or
1414: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1415: nvl(p_rec.information4, hr_api.g_varchar2) or
1416: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1417: nvl(p_rec.information5, hr_api.g_varchar2) or
1410: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1411: nvl(p_rec.information2, hr_api.g_varchar2) or
1412: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1413: nvl(p_rec.information3, hr_api.g_varchar2) or
1414: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1415: nvl(p_rec.information4, hr_api.g_varchar2) or
1416: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1417: nvl(p_rec.information5, hr_api.g_varchar2) or
1418: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1411: nvl(p_rec.information2, hr_api.g_varchar2) or
1412: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1413: nvl(p_rec.information3, hr_api.g_varchar2) or
1414: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1415: nvl(p_rec.information4, hr_api.g_varchar2) or
1416: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1417: nvl(p_rec.information5, hr_api.g_varchar2) or
1418: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1419: nvl(p_rec.information6, hr_api.g_varchar2) or
1412: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1413: nvl(p_rec.information3, hr_api.g_varchar2) or
1414: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1415: nvl(p_rec.information4, hr_api.g_varchar2) or
1416: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1417: nvl(p_rec.information5, hr_api.g_varchar2) or
1418: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1419: nvl(p_rec.information6, hr_api.g_varchar2) or
1420: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1413: nvl(p_rec.information3, hr_api.g_varchar2) or
1414: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1415: nvl(p_rec.information4, hr_api.g_varchar2) or
1416: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1417: nvl(p_rec.information5, hr_api.g_varchar2) or
1418: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1419: nvl(p_rec.information6, hr_api.g_varchar2) or
1420: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1421: nvl(p_rec.information7, hr_api.g_varchar2) or
1414: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1415: nvl(p_rec.information4, hr_api.g_varchar2) or
1416: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1417: nvl(p_rec.information5, hr_api.g_varchar2) or
1418: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1419: nvl(p_rec.information6, hr_api.g_varchar2) or
1420: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1421: nvl(p_rec.information7, hr_api.g_varchar2) or
1422: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1415: nvl(p_rec.information4, hr_api.g_varchar2) or
1416: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1417: nvl(p_rec.information5, hr_api.g_varchar2) or
1418: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1419: nvl(p_rec.information6, hr_api.g_varchar2) or
1420: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1421: nvl(p_rec.information7, hr_api.g_varchar2) or
1422: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1423: nvl(p_rec.information8, hr_api.g_varchar2) or
1416: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1417: nvl(p_rec.information5, hr_api.g_varchar2) or
1418: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1419: nvl(p_rec.information6, hr_api.g_varchar2) or
1420: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1421: nvl(p_rec.information7, hr_api.g_varchar2) or
1422: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1423: nvl(p_rec.information8, hr_api.g_varchar2) or
1424: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1417: nvl(p_rec.information5, hr_api.g_varchar2) or
1418: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1419: nvl(p_rec.information6, hr_api.g_varchar2) or
1420: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1421: nvl(p_rec.information7, hr_api.g_varchar2) or
1422: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1423: nvl(p_rec.information8, hr_api.g_varchar2) or
1424: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1425: nvl(p_rec.information9, hr_api.g_varchar2) or
1418: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1419: nvl(p_rec.information6, hr_api.g_varchar2) or
1420: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1421: nvl(p_rec.information7, hr_api.g_varchar2) or
1422: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1423: nvl(p_rec.information8, hr_api.g_varchar2) or
1424: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1425: nvl(p_rec.information9, hr_api.g_varchar2) or
1426: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1419: nvl(p_rec.information6, hr_api.g_varchar2) or
1420: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1421: nvl(p_rec.information7, hr_api.g_varchar2) or
1422: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1423: nvl(p_rec.information8, hr_api.g_varchar2) or
1424: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1425: nvl(p_rec.information9, hr_api.g_varchar2) or
1426: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1427: nvl(p_rec.information10, hr_api.g_varchar2) or
1420: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1421: nvl(p_rec.information7, hr_api.g_varchar2) or
1422: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1423: nvl(p_rec.information8, hr_api.g_varchar2) or
1424: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1425: nvl(p_rec.information9, hr_api.g_varchar2) or
1426: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1427: nvl(p_rec.information10, hr_api.g_varchar2) or
1428: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1421: nvl(p_rec.information7, hr_api.g_varchar2) or
1422: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1423: nvl(p_rec.information8, hr_api.g_varchar2) or
1424: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1425: nvl(p_rec.information9, hr_api.g_varchar2) or
1426: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1427: nvl(p_rec.information10, hr_api.g_varchar2) or
1428: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1429: nvl(p_rec.information11, hr_api.g_varchar2) or
1422: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1423: nvl(p_rec.information8, hr_api.g_varchar2) or
1424: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1425: nvl(p_rec.information9, hr_api.g_varchar2) or
1426: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1427: nvl(p_rec.information10, hr_api.g_varchar2) or
1428: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1429: nvl(p_rec.information11, hr_api.g_varchar2) or
1430: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1423: nvl(p_rec.information8, hr_api.g_varchar2) or
1424: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1425: nvl(p_rec.information9, hr_api.g_varchar2) or
1426: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1427: nvl(p_rec.information10, hr_api.g_varchar2) or
1428: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1429: nvl(p_rec.information11, hr_api.g_varchar2) or
1430: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1431: nvl(p_rec.information12, hr_api.g_varchar2) or
1424: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1425: nvl(p_rec.information9, hr_api.g_varchar2) or
1426: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1427: nvl(p_rec.information10, hr_api.g_varchar2) or
1428: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1429: nvl(p_rec.information11, hr_api.g_varchar2) or
1430: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1431: nvl(p_rec.information12, hr_api.g_varchar2) or
1432: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1425: nvl(p_rec.information9, hr_api.g_varchar2) or
1426: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1427: nvl(p_rec.information10, hr_api.g_varchar2) or
1428: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1429: nvl(p_rec.information11, hr_api.g_varchar2) or
1430: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1431: nvl(p_rec.information12, hr_api.g_varchar2) or
1432: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1433: nvl(p_rec.information13, hr_api.g_varchar2) or
1426: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1427: nvl(p_rec.information10, hr_api.g_varchar2) or
1428: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1429: nvl(p_rec.information11, hr_api.g_varchar2) or
1430: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1431: nvl(p_rec.information12, hr_api.g_varchar2) or
1432: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1433: nvl(p_rec.information13, hr_api.g_varchar2) or
1434: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1427: nvl(p_rec.information10, hr_api.g_varchar2) or
1428: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1429: nvl(p_rec.information11, hr_api.g_varchar2) or
1430: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1431: nvl(p_rec.information12, hr_api.g_varchar2) or
1432: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1433: nvl(p_rec.information13, hr_api.g_varchar2) or
1434: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1435: nvl(p_rec.information14, hr_api.g_varchar2) or
1428: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1429: nvl(p_rec.information11, hr_api.g_varchar2) or
1430: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1431: nvl(p_rec.information12, hr_api.g_varchar2) or
1432: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1433: nvl(p_rec.information13, hr_api.g_varchar2) or
1434: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1435: nvl(p_rec.information14, hr_api.g_varchar2) or
1436: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1429: nvl(p_rec.information11, hr_api.g_varchar2) or
1430: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1431: nvl(p_rec.information12, hr_api.g_varchar2) or
1432: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1433: nvl(p_rec.information13, hr_api.g_varchar2) or
1434: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1435: nvl(p_rec.information14, hr_api.g_varchar2) or
1436: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1437: nvl(p_rec.information15, hr_api.g_varchar2) or
1430: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1431: nvl(p_rec.information12, hr_api.g_varchar2) or
1432: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1433: nvl(p_rec.information13, hr_api.g_varchar2) or
1434: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1435: nvl(p_rec.information14, hr_api.g_varchar2) or
1436: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1437: nvl(p_rec.information15, hr_api.g_varchar2) or
1438: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1431: nvl(p_rec.information12, hr_api.g_varchar2) or
1432: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1433: nvl(p_rec.information13, hr_api.g_varchar2) or
1434: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1435: nvl(p_rec.information14, hr_api.g_varchar2) or
1436: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1437: nvl(p_rec.information15, hr_api.g_varchar2) or
1438: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1439: nvl(p_rec.information16, hr_api.g_varchar2) or
1432: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1433: nvl(p_rec.information13, hr_api.g_varchar2) or
1434: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1435: nvl(p_rec.information14, hr_api.g_varchar2) or
1436: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1437: nvl(p_rec.information15, hr_api.g_varchar2) or
1438: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1439: nvl(p_rec.information16, hr_api.g_varchar2) or
1440: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1433: nvl(p_rec.information13, hr_api.g_varchar2) or
1434: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1435: nvl(p_rec.information14, hr_api.g_varchar2) or
1436: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1437: nvl(p_rec.information15, hr_api.g_varchar2) or
1438: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1439: nvl(p_rec.information16, hr_api.g_varchar2) or
1440: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1441: nvl(p_rec.information17, hr_api.g_varchar2) or
1434: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1435: nvl(p_rec.information14, hr_api.g_varchar2) or
1436: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1437: nvl(p_rec.information15, hr_api.g_varchar2) or
1438: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1439: nvl(p_rec.information16, hr_api.g_varchar2) or
1440: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1441: nvl(p_rec.information17, hr_api.g_varchar2) or
1442: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1435: nvl(p_rec.information14, hr_api.g_varchar2) or
1436: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1437: nvl(p_rec.information15, hr_api.g_varchar2) or
1438: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1439: nvl(p_rec.information16, hr_api.g_varchar2) or
1440: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1441: nvl(p_rec.information17, hr_api.g_varchar2) or
1442: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1443: nvl(p_rec.information18, hr_api.g_varchar2) or
1436: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1437: nvl(p_rec.information15, hr_api.g_varchar2) or
1438: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1439: nvl(p_rec.information16, hr_api.g_varchar2) or
1440: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1441: nvl(p_rec.information17, hr_api.g_varchar2) or
1442: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1443: nvl(p_rec.information18, hr_api.g_varchar2) or
1444: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1437: nvl(p_rec.information15, hr_api.g_varchar2) or
1438: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1439: nvl(p_rec.information16, hr_api.g_varchar2) or
1440: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1441: nvl(p_rec.information17, hr_api.g_varchar2) or
1442: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1443: nvl(p_rec.information18, hr_api.g_varchar2) or
1444: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1445: nvl(p_rec.information19, hr_api.g_varchar2) or
1438: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1439: nvl(p_rec.information16, hr_api.g_varchar2) or
1440: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1441: nvl(p_rec.information17, hr_api.g_varchar2) or
1442: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1443: nvl(p_rec.information18, hr_api.g_varchar2) or
1444: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1445: nvl(p_rec.information19, hr_api.g_varchar2) or
1446: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1439: nvl(p_rec.information16, hr_api.g_varchar2) or
1440: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1441: nvl(p_rec.information17, hr_api.g_varchar2) or
1442: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1443: nvl(p_rec.information18, hr_api.g_varchar2) or
1444: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1445: nvl(p_rec.information19, hr_api.g_varchar2) or
1446: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1447: nvl(p_rec.information20, hr_api.g_varchar2) or
1440: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1441: nvl(p_rec.information17, hr_api.g_varchar2) or
1442: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1443: nvl(p_rec.information18, hr_api.g_varchar2) or
1444: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1445: nvl(p_rec.information19, hr_api.g_varchar2) or
1446: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1447: nvl(p_rec.information20, hr_api.g_varchar2) or
1448: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1441: nvl(p_rec.information17, hr_api.g_varchar2) or
1442: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1443: nvl(p_rec.information18, hr_api.g_varchar2) or
1444: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1445: nvl(p_rec.information19, hr_api.g_varchar2) or
1446: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1447: nvl(p_rec.information20, hr_api.g_varchar2) or
1448: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1449: nvl(p_rec.information21, hr_api.g_varchar2) or
1442: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1443: nvl(p_rec.information18, hr_api.g_varchar2) or
1444: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1445: nvl(p_rec.information19, hr_api.g_varchar2) or
1446: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1447: nvl(p_rec.information20, hr_api.g_varchar2) or
1448: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1449: nvl(p_rec.information21, hr_api.g_varchar2) or
1450: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1443: nvl(p_rec.information18, hr_api.g_varchar2) or
1444: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1445: nvl(p_rec.information19, hr_api.g_varchar2) or
1446: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1447: nvl(p_rec.information20, hr_api.g_varchar2) or
1448: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1449: nvl(p_rec.information21, hr_api.g_varchar2) or
1450: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1451: nvl(p_rec.information22, hr_api.g_varchar2) or
1444: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1445: nvl(p_rec.information19, hr_api.g_varchar2) or
1446: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1447: nvl(p_rec.information20, hr_api.g_varchar2) or
1448: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1449: nvl(p_rec.information21, hr_api.g_varchar2) or
1450: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1451: nvl(p_rec.information22, hr_api.g_varchar2) or
1452: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1445: nvl(p_rec.information19, hr_api.g_varchar2) or
1446: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1447: nvl(p_rec.information20, hr_api.g_varchar2) or
1448: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1449: nvl(p_rec.information21, hr_api.g_varchar2) or
1450: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1451: nvl(p_rec.information22, hr_api.g_varchar2) or
1452: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1453: nvl(p_rec.information23, hr_api.g_varchar2) or
1446: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1447: nvl(p_rec.information20, hr_api.g_varchar2) or
1448: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1449: nvl(p_rec.information21, hr_api.g_varchar2) or
1450: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1451: nvl(p_rec.information22, hr_api.g_varchar2) or
1452: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1453: nvl(p_rec.information23, hr_api.g_varchar2) or
1454: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1447: nvl(p_rec.information20, hr_api.g_varchar2) or
1448: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1449: nvl(p_rec.information21, hr_api.g_varchar2) or
1450: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1451: nvl(p_rec.information22, hr_api.g_varchar2) or
1452: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1453: nvl(p_rec.information23, hr_api.g_varchar2) or
1454: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1455: nvl(p_rec.information24, hr_api.g_varchar2) or
1448: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1449: nvl(p_rec.information21, hr_api.g_varchar2) or
1450: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1451: nvl(p_rec.information22, hr_api.g_varchar2) or
1452: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1453: nvl(p_rec.information23, hr_api.g_varchar2) or
1454: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1455: nvl(p_rec.information24, hr_api.g_varchar2) or
1456: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1449: nvl(p_rec.information21, hr_api.g_varchar2) or
1450: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1451: nvl(p_rec.information22, hr_api.g_varchar2) or
1452: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1453: nvl(p_rec.information23, hr_api.g_varchar2) or
1454: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1455: nvl(p_rec.information24, hr_api.g_varchar2) or
1456: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1457: nvl(p_rec.information25, hr_api.g_varchar2) or
1450: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1451: nvl(p_rec.information22, hr_api.g_varchar2) or
1452: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1453: nvl(p_rec.information23, hr_api.g_varchar2) or
1454: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1455: nvl(p_rec.information24, hr_api.g_varchar2) or
1456: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1457: nvl(p_rec.information25, hr_api.g_varchar2) or
1458: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1451: nvl(p_rec.information22, hr_api.g_varchar2) or
1452: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1453: nvl(p_rec.information23, hr_api.g_varchar2) or
1454: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1455: nvl(p_rec.information24, hr_api.g_varchar2) or
1456: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1457: nvl(p_rec.information25, hr_api.g_varchar2) or
1458: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1459: nvl(p_rec.information26, hr_api.g_varchar2) or
1452: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1453: nvl(p_rec.information23, hr_api.g_varchar2) or
1454: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1455: nvl(p_rec.information24, hr_api.g_varchar2) or
1456: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1457: nvl(p_rec.information25, hr_api.g_varchar2) or
1458: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1459: nvl(p_rec.information26, hr_api.g_varchar2) or
1460: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1453: nvl(p_rec.information23, hr_api.g_varchar2) or
1454: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1455: nvl(p_rec.information24, hr_api.g_varchar2) or
1456: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1457: nvl(p_rec.information25, hr_api.g_varchar2) or
1458: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1459: nvl(p_rec.information26, hr_api.g_varchar2) or
1460: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1461: nvl(p_rec.information27, hr_api.g_varchar2) or
1454: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1455: nvl(p_rec.information24, hr_api.g_varchar2) or
1456: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1457: nvl(p_rec.information25, hr_api.g_varchar2) or
1458: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1459: nvl(p_rec.information26, hr_api.g_varchar2) or
1460: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1461: nvl(p_rec.information27, hr_api.g_varchar2) or
1462: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1455: nvl(p_rec.information24, hr_api.g_varchar2) or
1456: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1457: nvl(p_rec.information25, hr_api.g_varchar2) or
1458: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1459: nvl(p_rec.information26, hr_api.g_varchar2) or
1460: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1461: nvl(p_rec.information27, hr_api.g_varchar2) or
1462: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1463: nvl(p_rec.information28, hr_api.g_varchar2) or
1456: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1457: nvl(p_rec.information25, hr_api.g_varchar2) or
1458: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1459: nvl(p_rec.information26, hr_api.g_varchar2) or
1460: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1461: nvl(p_rec.information27, hr_api.g_varchar2) or
1462: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1463: nvl(p_rec.information28, hr_api.g_varchar2) or
1464: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1457: nvl(p_rec.information25, hr_api.g_varchar2) or
1458: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1459: nvl(p_rec.information26, hr_api.g_varchar2) or
1460: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1461: nvl(p_rec.information27, hr_api.g_varchar2) or
1462: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1463: nvl(p_rec.information28, hr_api.g_varchar2) or
1464: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1465: nvl(p_rec.information29, hr_api.g_varchar2) or
1458: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1459: nvl(p_rec.information26, hr_api.g_varchar2) or
1460: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1461: nvl(p_rec.information27, hr_api.g_varchar2) or
1462: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1463: nvl(p_rec.information28, hr_api.g_varchar2) or
1464: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1465: nvl(p_rec.information29, hr_api.g_varchar2) or
1466: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1459: nvl(p_rec.information26, hr_api.g_varchar2) or
1460: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1461: nvl(p_rec.information27, hr_api.g_varchar2) or
1462: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1463: nvl(p_rec.information28, hr_api.g_varchar2) or
1464: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1465: nvl(p_rec.information29, hr_api.g_varchar2) or
1466: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1467: nvl(p_rec.information30, hr_api.g_varchar2) ))
1460: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1461: nvl(p_rec.information27, hr_api.g_varchar2) or
1462: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1463: nvl(p_rec.information28, hr_api.g_varchar2) or
1464: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1465: nvl(p_rec.information29, hr_api.g_varchar2) or
1466: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1467: nvl(p_rec.information30, hr_api.g_varchar2) ))
1468: or (p_rec.period_of_placement_id is null) then
1461: nvl(p_rec.information27, hr_api.g_varchar2) or
1462: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1463: nvl(p_rec.information28, hr_api.g_varchar2) or
1464: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1465: nvl(p_rec.information29, hr_api.g_varchar2) or
1466: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1467: nvl(p_rec.information30, hr_api.g_varchar2) ))
1468: or (p_rec.period_of_placement_id is null) then
1469: --
1462: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1463: nvl(p_rec.information28, hr_api.g_varchar2) or
1464: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1465: nvl(p_rec.information29, hr_api.g_varchar2) or
1466: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1467: nvl(p_rec.information30, hr_api.g_varchar2) ))
1468: or (p_rec.period_of_placement_id is null) then
1469: --
1470: -- Only execute the validation if absolutely necessary:
1463: nvl(p_rec.information28, hr_api.g_varchar2) or
1464: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1465: nvl(p_rec.information29, hr_api.g_varchar2) or
1466: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1467: nvl(p_rec.information30, hr_api.g_varchar2) ))
1468: or (p_rec.period_of_placement_id is null) then
1469: --
1470: -- Only execute the validation if absolutely necessary:
1471: -- a) During update, the structure column value or any
1580: begin
1581: hr_utility.set_location('Entering:'||l_proc,10);
1582: --
1583: if ((p_rec.period_of_placement_id is not null) and (
1584: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1585: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1586: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1587: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1588: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1581: hr_utility.set_location('Entering:'||l_proc,10);
1582: --
1583: if ((p_rec.period_of_placement_id is not null) and (
1584: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1585: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1586: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1587: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1588: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1589: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1582: --
1583: if ((p_rec.period_of_placement_id is not null) and (
1584: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1585: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1586: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1587: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1588: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1589: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1590: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1583: if ((p_rec.period_of_placement_id is not null) and (
1584: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1585: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1586: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1587: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1588: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1589: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1590: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1591: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1584: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1585: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1586: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1587: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1588: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1589: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1590: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1591: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1592: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1585: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1586: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1587: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1588: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1589: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1590: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1591: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1592: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1593: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1586: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1587: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1588: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1589: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1590: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1591: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1592: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1593: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1594: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1587: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1588: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1589: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1590: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1591: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1592: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1593: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1594: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1595: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1588: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1589: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1590: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1591: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1592: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1593: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1594: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1595: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1596: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1589: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1590: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1591: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1592: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1593: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1594: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1595: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1596: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1597: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1590: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1591: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1592: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1593: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1594: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1595: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1596: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1597: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1598: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1591: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1592: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1593: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1594: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1595: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1596: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1597: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1598: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1599: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1592: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1593: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1594: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1595: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1596: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1597: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1598: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1599: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1600: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1593: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1594: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1595: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1596: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1597: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1598: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1599: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1600: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1601: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1594: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1595: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1596: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1597: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1598: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1599: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1600: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1601: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1602: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1595: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1596: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1597: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1598: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1599: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1600: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1601: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1602: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1603: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1596: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1597: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1598: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1599: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1600: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1601: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1602: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1603: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1604: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1597: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1598: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1599: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1600: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1601: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1602: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1603: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1604: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1605: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1598: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1599: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1600: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1601: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1602: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1603: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1604: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1605: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1606: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1599: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1600: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1601: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1602: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1603: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1604: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1605: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1606: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1607: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1600: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1601: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1602: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1603: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1604: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1605: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1606: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1607: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1608: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1601: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1602: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1603: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1604: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1605: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1606: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1607: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1608: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1609: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1602: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1603: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1604: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1605: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1606: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1607: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1608: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1609: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1610: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1603: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1604: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1605: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1606: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1607: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1608: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1609: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1610: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1611: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1604: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1605: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1606: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1607: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1608: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1609: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1610: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1611: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1612: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1605: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1606: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1607: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1608: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1609: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1610: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1611: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1612: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1613: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1606: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1607: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1608: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1609: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1610: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1611: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1612: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1613: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1614: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1607: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1608: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1609: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1610: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1611: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1612: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1613: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1614: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1615: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1608: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1609: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1610: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1611: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1612: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1613: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1614: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1615: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1616: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1609: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1610: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1611: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1612: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1613: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1614: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1615: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1616: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1617: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1610: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1611: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1612: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1613: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1614: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1615: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1616: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1617: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1618: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1611: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1612: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1613: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1614: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1615: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1616: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1617: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1618: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1619: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1612: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1613: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1614: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1615: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1616: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1617: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1618: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1619: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1620: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1613: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1614: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1615: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1616: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1617: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1618: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1619: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1620: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1621: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1614: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1615: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1616: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1617: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1618: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1619: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1620: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1621: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1622: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1615: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1616: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1617: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1618: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1619: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1620: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1621: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1622: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1623: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1616: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1617: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1618: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1619: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1620: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1621: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1622: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1623: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1624: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1617: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1618: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1619: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1620: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1621: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1622: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1623: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1624: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1625: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1618: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1619: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1620: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1621: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1622: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1623: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1624: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1625: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1626: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1619: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1620: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1621: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1622: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1623: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1624: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1625: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1626: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1627: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1620: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1621: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1622: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1623: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1624: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1625: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1626: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1627: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1628: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1621: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1622: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1623: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1624: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1625: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1626: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1627: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1628: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1629: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1622: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1623: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1624: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1625: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1626: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1627: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1628: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1629: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1630: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1623: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1624: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1625: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1626: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1627: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1628: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1629: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1630: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1624: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1625: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1626: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1627: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1628: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1629: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1630: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1632: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1625: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1626: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1627: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1628: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1629: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1630: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1632: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1626: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1627: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1628: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1629: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1630: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1632: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1634: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1627: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1628: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1629: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1630: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1632: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1634: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1628: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1629: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1630: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1632: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1634: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1636: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1629: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1630: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1632: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1634: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1636: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1630: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1632: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1634: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1636: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1638: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1632: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1634: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1636: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1638: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1632: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1634: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1636: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1638: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1640: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1634: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1636: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1638: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1640: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1634: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1636: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1638: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1640: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1642: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1636: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1638: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1640: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1642: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1636: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1638: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1640: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1642: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1644: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1638: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1640: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1642: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1644: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1638: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1640: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1642: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1644: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1646: or (p_rec.period_of_placement_id is null) then
1639: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1640: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1642: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1644: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1646: or (p_rec.period_of_placement_id is null) then
1647: --
1640: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1642: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1644: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1646: or (p_rec.period_of_placement_id is null) then
1647: --
1648: -- Only execute the validation if absolutely necessary:
1641: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1642: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1644: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1646: or (p_rec.period_of_placement_id is null) then
1647: --
1648: -- Only execute the validation if absolutely necessary:
1649: -- a) During update, the structure column value or any
1786: hr_utility.set_location('Entering:'||l_proc, 5);
1787: --
1788: -- Call all supporting business operations
1789: --
1790: hr_api.validate_bus_grp_id
1791: (p_business_group_id => p_rec.business_group_id
1792: ,p_associated_column1 => per_pdp_shd.g_tab_nam
1793: || '.BUSINESS_GROUP_ID');
1794:
1978: hr_utility.set_location('Entering:'||l_proc, 5);
1979: --
1980: -- Call all supporting business operations
1981: --
1982: hr_api.validate_bus_grp_id
1983: (p_business_group_id => p_rec.business_group_id
1984: ,p_associated_column1 => per_pdp_shd.g_tab_nam
1985: || '.BUSINESS_GROUP_ID');
1986: