65: ,p_object_version_number
66: => p_object_version_number
67: );
68: if ((l_api_updating
69: and nvl(per_pju_shd.g_old_rec.previous_employer_id, hr_api.g_number)
70: <> nvl(p_previous_employer_id,hr_api.g_number))
71: or
72: (not l_api_updating)) then
73: hr_utility.set_location(l_proc, 15);
66: => p_object_version_number
67: );
68: if ((l_api_updating
69: and nvl(per_pju_shd.g_old_rec.previous_employer_id, hr_api.g_number)
70: <> nvl(p_previous_employer_id,hr_api.g_number))
71: or
72: (not l_api_updating)) then
73: hr_utility.set_location(l_proc, 15);
74: open csr_previous_employer_id;
144: ,p_object_version_number
145: => p_object_version_number
146: );
147: if ((l_api_updating
148: and nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)
149: <> nvl(p_previous_job_id,hr_api.g_number))
150: or
151: (not l_api_updating)) then
152: hr_utility.set_location(l_proc, 15);
145: => p_object_version_number
146: );
147: if ((l_api_updating
148: and nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)
149: <> nvl(p_previous_job_id,hr_api.g_number))
150: or
151: (not l_api_updating)) then
152: hr_utility.set_location(l_proc, 15);
153: open csr_previous_job_id;
221: ,p_object_version_number
222: => p_object_version_number
223: );
224: if ((l_api_updating
225: and nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)
226: <> nvl(p_assignment_id,hr_api.g_number))
227: or
228: (not l_api_updating)) then
229: hr_utility.set_location(l_proc, 15);
222: => p_object_version_number
223: );
224: if ((l_api_updating
225: and nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)
226: <> nvl(p_assignment_id,hr_api.g_number))
227: or
228: (not l_api_updating)) then
229: hr_utility.set_location(l_proc, 15);
230: -- Check for valid Assignment ID.
295: ,p_object_version_number
296: => p_object_version_number
297: );
298: if ((l_api_updating
299: and (nvl(per_pju_shd.g_old_rec.start_date, hr_api.g_sot)
300: <> nvl(p_start_date,hr_api.g_sot)
301: or
302: nvl(per_pju_shd.g_old_rec.end_date, hr_api.g_eot)
303: <> nvl(p_end_date,hr_api.g_eot))
296: => p_object_version_number
297: );
298: if ((l_api_updating
299: and (nvl(per_pju_shd.g_old_rec.start_date, hr_api.g_sot)
300: <> nvl(p_start_date,hr_api.g_sot)
301: or
302: nvl(per_pju_shd.g_old_rec.end_date, hr_api.g_eot)
303: <> nvl(p_end_date,hr_api.g_eot))
304: )
298: if ((l_api_updating
299: and (nvl(per_pju_shd.g_old_rec.start_date, hr_api.g_sot)
300: <> nvl(p_start_date,hr_api.g_sot)
301: or
302: nvl(per_pju_shd.g_old_rec.end_date, hr_api.g_eot)
303: <> nvl(p_end_date,hr_api.g_eot))
304: )
305: or
306: (not l_api_updating)) then
299: and (nvl(per_pju_shd.g_old_rec.start_date, hr_api.g_sot)
300: <> nvl(p_start_date,hr_api.g_sot)
301: or
302: nvl(per_pju_shd.g_old_rec.end_date, hr_api.g_eot)
303: <> nvl(p_end_date,hr_api.g_eot))
304: )
305: or
306: (not l_api_updating)) then
307: hr_utility.set_location(l_proc, 15);
304: )
305: or
306: (not l_api_updating)) then
307: hr_utility.set_location(l_proc, 15);
308: if nvl(p_start_date,hr_api.g_sot) > nvl(p_end_date,hr_api.g_eot) then
309: hr_utility.set_location(l_proc, 20);
310: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
311: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
312: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
366: ,p_object_version_number
367: => p_object_version_number);
368: hr_utility.set_location(l_proc, 15);
369: if ((l_api_updating and
370: ( nvl(p_period_years,hr_api.g_number)
371: <> nvl(per_pju_shd.g_old_rec.period_years,hr_api.g_number)
372: )
373: ) or
374: (not l_api_updating)) then
367: => p_object_version_number);
368: hr_utility.set_location(l_proc, 15);
369: if ((l_api_updating and
370: ( nvl(p_period_years,hr_api.g_number)
371: <> nvl(per_pju_shd.g_old_rec.period_years,hr_api.g_number)
372: )
373: ) or
374: (not l_api_updating)) then
375: hr_utility.set_location(l_proc, 20);
434: ,p_object_version_number
435: => p_object_version_number);
436: hr_utility.set_location(l_proc, 15);
437: if ((l_api_updating and
438: ( nvl(p_period_months ,hr_api.g_number)
439: <> nvl(per_pju_shd.g_old_rec.period_months ,hr_api.g_number)
440: )
441: ) or
442: (not l_api_updating)) then
435: => p_object_version_number);
436: hr_utility.set_location(l_proc, 15);
437: if ((l_api_updating and
438: ( nvl(p_period_months ,hr_api.g_number)
439: <> nvl(per_pju_shd.g_old_rec.period_months ,hr_api.g_number)
440: )
441: ) or
442: (not l_api_updating)) then
443: hr_utility.set_location(l_proc, 20);
502: ,p_object_version_number
503: => p_object_version_number);
504: hr_utility.set_location(l_proc, 15);
505: if ((l_api_updating and
506: ( nvl(p_period_days ,hr_api.g_number)
507: <> nvl(per_pju_shd.g_old_rec.period_days ,hr_api.g_number)
508: )
509: ) or
510: (not l_api_updating)) then
503: => p_object_version_number);
504: hr_utility.set_location(l_proc, 15);
505: if ((l_api_updating and
506: ( nvl(p_period_days ,hr_api.g_number)
507: <> nvl(per_pju_shd.g_old_rec.period_days ,hr_api.g_number)
508: )
509: ) or
510: (not l_api_updating)) then
511: hr_utility.set_location(l_proc, 20);
571: cursor csr_pem_start_end_dates is
572: select previous_employer_id
573: from per_previous_employers
574: where previous_employer_id = p_previous_employer_id
575: and ( p_start_date not between nvl(start_date,hr_api.g_sot)
576: and nvl(end_date,hr_api.g_eot)
577: or p_end_date not between nvl(start_date,hr_api.g_sot)
578: and nvl(end_date,hr_api.g_eot));
579: l_previous_employer_id per_previous_employers.previous_employer_id%type;
572: select previous_employer_id
573: from per_previous_employers
574: where previous_employer_id = p_previous_employer_id
575: and ( p_start_date not between nvl(start_date,hr_api.g_sot)
576: and nvl(end_date,hr_api.g_eot)
577: or p_end_date not between nvl(start_date,hr_api.g_sot)
578: and nvl(end_date,hr_api.g_eot));
579: l_previous_employer_id per_previous_employers.previous_employer_id%type;
580: --
573: from per_previous_employers
574: where previous_employer_id = p_previous_employer_id
575: and ( p_start_date not between nvl(start_date,hr_api.g_sot)
576: and nvl(end_date,hr_api.g_eot)
577: or p_end_date not between nvl(start_date,hr_api.g_sot)
578: and nvl(end_date,hr_api.g_eot));
579: l_previous_employer_id per_previous_employers.previous_employer_id%type;
580: --
581: l_api_updating boolean;
574: where previous_employer_id = p_previous_employer_id
575: and ( p_start_date not between nvl(start_date,hr_api.g_sot)
576: and nvl(end_date,hr_api.g_eot)
577: or p_end_date not between nvl(start_date,hr_api.g_sot)
578: and nvl(end_date,hr_api.g_eot));
579: l_previous_employer_id per_previous_employers.previous_employer_id%type;
580: --
581: l_api_updating boolean;
582: l_proc varchar2(72) := g_package||'chk_pju_start_end_dates';
590: ,p_object_version_number
591: => p_object_version_number
592: );
593: if ((l_api_updating
594: and (nvl(per_pju_shd.g_old_rec.start_date, hr_api.g_sot)
595: <> nvl(p_start_date,hr_api.g_sot)
596: or
597: nvl(per_pju_shd.g_old_rec.end_date, hr_api.g_eot)
598: <> nvl(p_end_date,hr_api.g_eot))
591: => p_object_version_number
592: );
593: if ((l_api_updating
594: and (nvl(per_pju_shd.g_old_rec.start_date, hr_api.g_sot)
595: <> nvl(p_start_date,hr_api.g_sot)
596: or
597: nvl(per_pju_shd.g_old_rec.end_date, hr_api.g_eot)
598: <> nvl(p_end_date,hr_api.g_eot))
599: )
593: if ((l_api_updating
594: and (nvl(per_pju_shd.g_old_rec.start_date, hr_api.g_sot)
595: <> nvl(p_start_date,hr_api.g_sot)
596: or
597: nvl(per_pju_shd.g_old_rec.end_date, hr_api.g_eot)
598: <> nvl(p_end_date,hr_api.g_eot))
599: )
600: or
601: (not l_api_updating)) then
594: and (nvl(per_pju_shd.g_old_rec.start_date, hr_api.g_sot)
595: <> nvl(p_start_date,hr_api.g_sot)
596: or
597: nvl(per_pju_shd.g_old_rec.end_date, hr_api.g_eot)
598: <> nvl(p_end_date,hr_api.g_eot))
599: )
600: or
601: (not l_api_updating)) then
602: hr_utility.set_location(l_proc, 15);
677: ,p_object_version_number
678: => p_object_version_number
679: );
680: if ((l_api_updating
681: and (nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)
682: <> nvl(p_assignment_id,hr_api.g_number)
683: or nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)
684: <> nvl(p_previous_job_id, hr_api.g_number)
685: )
678: => p_object_version_number
679: );
680: if ((l_api_updating
681: and (nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)
682: <> nvl(p_assignment_id,hr_api.g_number)
683: or nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)
684: <> nvl(p_previous_job_id, hr_api.g_number)
685: )
686: )
679: );
680: if ((l_api_updating
681: and (nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)
682: <> nvl(p_assignment_id,hr_api.g_number)
683: or nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)
684: <> nvl(p_previous_job_id, hr_api.g_number)
685: )
686: )
687: or
680: if ((l_api_updating
681: and (nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)
682: <> nvl(p_assignment_id,hr_api.g_number)
683: or nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)
684: <> nvl(p_previous_job_id, hr_api.g_number)
685: )
686: )
687: or
688: (not l_api_updating)) then
850: ,p_object_version_number
851: => p_object_version_number
852: );
853: if ((l_api_updating
854: and (nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)
855: <> nvl(p_assignment_id,hr_api.g_number)
856: or nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)
857: <> nvl(p_previous_job_id, hr_api.g_number)
858: )
851: => p_object_version_number
852: );
853: if ((l_api_updating
854: and (nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)
855: <> nvl(p_assignment_id,hr_api.g_number)
856: or nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)
857: <> nvl(p_previous_job_id, hr_api.g_number)
858: )
859: )
852: );
853: if ((l_api_updating
854: and (nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)
855: <> nvl(p_assignment_id,hr_api.g_number)
856: or nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)
857: <> nvl(p_previous_job_id, hr_api.g_number)
858: )
859: )
860: or
853: if ((l_api_updating
854: and (nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)
855: <> nvl(p_assignment_id,hr_api.g_number)
856: or nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)
857: <> nvl(p_previous_job_id, hr_api.g_number)
858: )
859: )
860: or
861: (not l_api_updating)) then
905: hr_utility.set_location('Entering:'|| l_proc, 10);
906: --
907: -- Ensure that all the mandatory parameter are not null
908: --
909: hr_api.mandatory_arg_error
910: (p_api_name => l_proc
911: ,p_argument => 'previous_job_usage_id'
912: ,p_argument_value => p_previous_job_usage_id
913: );
928: close csr_sec_grp;
929: --
930: -- Set the security_group_id in CLIENT_INFO
931: --
932: hr_api.set_security_group_id
933: (p_security_group_id => l_security_group_id
934: );
935: --
936: hr_utility.set_location(' Leaving:'|| l_proc, 20);
966: hr_utility.set_location('Entering:'|| l_proc, 10);
967: --
968: -- Ensure that all the mandatory parameter are not null
969: --
970: hr_api.mandatory_arg_error
971: (p_api_name => l_proc
972: ,p_argument => 'previous_job_usage_id'
973: ,p_argument_value => p_previous_job_usage_id
974: );
972: ,p_argument => 'previous_job_usage_id'
973: ,p_argument_value => p_previous_job_usage_id
974: );
975: --
976: if ( nvl(per_pju_bus.g_previous_job_usage_id, hr_api.g_number)
977: = p_previous_job_usage_id) then
978: --
979: -- The legislation code has already been found with a previous
980: -- call to this function. Just return the value in the global
1048: begin
1049: hr_utility.set_location('Entering:'||l_proc,10);
1050: --
1051: if ((p_rec.previous_job_usage_id is not null) and (
1052: nvl(per_pju_shd.g_old_rec.pju_information_category, hr_api.g_varchar2) <>
1053: nvl(p_rec.pju_information_category, hr_api.g_varchar2) or
1054: nvl(per_pju_shd.g_old_rec.pju_information1, hr_api.g_varchar2) <>
1055: nvl(p_rec.pju_information1, hr_api.g_varchar2) or
1056: nvl(per_pju_shd.g_old_rec.pju_information2, hr_api.g_varchar2) <>
1049: hr_utility.set_location('Entering:'||l_proc,10);
1050: --
1051: if ((p_rec.previous_job_usage_id is not null) and (
1052: nvl(per_pju_shd.g_old_rec.pju_information_category, hr_api.g_varchar2) <>
1053: nvl(p_rec.pju_information_category, hr_api.g_varchar2) or
1054: nvl(per_pju_shd.g_old_rec.pju_information1, hr_api.g_varchar2) <>
1055: nvl(p_rec.pju_information1, hr_api.g_varchar2) or
1056: nvl(per_pju_shd.g_old_rec.pju_information2, hr_api.g_varchar2) <>
1057: nvl(p_rec.pju_information2, hr_api.g_varchar2) or
1050: --
1051: if ((p_rec.previous_job_usage_id is not null) and (
1052: nvl(per_pju_shd.g_old_rec.pju_information_category, hr_api.g_varchar2) <>
1053: nvl(p_rec.pju_information_category, hr_api.g_varchar2) or
1054: nvl(per_pju_shd.g_old_rec.pju_information1, hr_api.g_varchar2) <>
1055: nvl(p_rec.pju_information1, hr_api.g_varchar2) or
1056: nvl(per_pju_shd.g_old_rec.pju_information2, hr_api.g_varchar2) <>
1057: nvl(p_rec.pju_information2, hr_api.g_varchar2) or
1058: nvl(per_pju_shd.g_old_rec.pju_information3, hr_api.g_varchar2) <>
1051: if ((p_rec.previous_job_usage_id is not null) and (
1052: nvl(per_pju_shd.g_old_rec.pju_information_category, hr_api.g_varchar2) <>
1053: nvl(p_rec.pju_information_category, hr_api.g_varchar2) or
1054: nvl(per_pju_shd.g_old_rec.pju_information1, hr_api.g_varchar2) <>
1055: nvl(p_rec.pju_information1, hr_api.g_varchar2) or
1056: nvl(per_pju_shd.g_old_rec.pju_information2, hr_api.g_varchar2) <>
1057: nvl(p_rec.pju_information2, hr_api.g_varchar2) or
1058: nvl(per_pju_shd.g_old_rec.pju_information3, hr_api.g_varchar2) <>
1059: nvl(p_rec.pju_information3, hr_api.g_varchar2) or
1052: nvl(per_pju_shd.g_old_rec.pju_information_category, hr_api.g_varchar2) <>
1053: nvl(p_rec.pju_information_category, hr_api.g_varchar2) or
1054: nvl(per_pju_shd.g_old_rec.pju_information1, hr_api.g_varchar2) <>
1055: nvl(p_rec.pju_information1, hr_api.g_varchar2) or
1056: nvl(per_pju_shd.g_old_rec.pju_information2, hr_api.g_varchar2) <>
1057: nvl(p_rec.pju_information2, hr_api.g_varchar2) or
1058: nvl(per_pju_shd.g_old_rec.pju_information3, hr_api.g_varchar2) <>
1059: nvl(p_rec.pju_information3, hr_api.g_varchar2) or
1060: nvl(per_pju_shd.g_old_rec.pju_information4, hr_api.g_varchar2) <>
1053: nvl(p_rec.pju_information_category, hr_api.g_varchar2) or
1054: nvl(per_pju_shd.g_old_rec.pju_information1, hr_api.g_varchar2) <>
1055: nvl(p_rec.pju_information1, hr_api.g_varchar2) or
1056: nvl(per_pju_shd.g_old_rec.pju_information2, hr_api.g_varchar2) <>
1057: nvl(p_rec.pju_information2, hr_api.g_varchar2) or
1058: nvl(per_pju_shd.g_old_rec.pju_information3, hr_api.g_varchar2) <>
1059: nvl(p_rec.pju_information3, hr_api.g_varchar2) or
1060: nvl(per_pju_shd.g_old_rec.pju_information4, hr_api.g_varchar2) <>
1061: nvl(p_rec.pju_information4, hr_api.g_varchar2) or
1054: nvl(per_pju_shd.g_old_rec.pju_information1, hr_api.g_varchar2) <>
1055: nvl(p_rec.pju_information1, hr_api.g_varchar2) or
1056: nvl(per_pju_shd.g_old_rec.pju_information2, hr_api.g_varchar2) <>
1057: nvl(p_rec.pju_information2, hr_api.g_varchar2) or
1058: nvl(per_pju_shd.g_old_rec.pju_information3, hr_api.g_varchar2) <>
1059: nvl(p_rec.pju_information3, hr_api.g_varchar2) or
1060: nvl(per_pju_shd.g_old_rec.pju_information4, hr_api.g_varchar2) <>
1061: nvl(p_rec.pju_information4, hr_api.g_varchar2) or
1062: nvl(per_pju_shd.g_old_rec.pju_information5, hr_api.g_varchar2) <>
1055: nvl(p_rec.pju_information1, hr_api.g_varchar2) or
1056: nvl(per_pju_shd.g_old_rec.pju_information2, hr_api.g_varchar2) <>
1057: nvl(p_rec.pju_information2, hr_api.g_varchar2) or
1058: nvl(per_pju_shd.g_old_rec.pju_information3, hr_api.g_varchar2) <>
1059: nvl(p_rec.pju_information3, hr_api.g_varchar2) or
1060: nvl(per_pju_shd.g_old_rec.pju_information4, hr_api.g_varchar2) <>
1061: nvl(p_rec.pju_information4, hr_api.g_varchar2) or
1062: nvl(per_pju_shd.g_old_rec.pju_information5, hr_api.g_varchar2) <>
1063: nvl(p_rec.pju_information5, hr_api.g_varchar2) or
1056: nvl(per_pju_shd.g_old_rec.pju_information2, hr_api.g_varchar2) <>
1057: nvl(p_rec.pju_information2, hr_api.g_varchar2) or
1058: nvl(per_pju_shd.g_old_rec.pju_information3, hr_api.g_varchar2) <>
1059: nvl(p_rec.pju_information3, hr_api.g_varchar2) or
1060: nvl(per_pju_shd.g_old_rec.pju_information4, hr_api.g_varchar2) <>
1061: nvl(p_rec.pju_information4, hr_api.g_varchar2) or
1062: nvl(per_pju_shd.g_old_rec.pju_information5, hr_api.g_varchar2) <>
1063: nvl(p_rec.pju_information5, hr_api.g_varchar2) or
1064: nvl(per_pju_shd.g_old_rec.pju_information6, hr_api.g_varchar2) <>
1057: nvl(p_rec.pju_information2, hr_api.g_varchar2) or
1058: nvl(per_pju_shd.g_old_rec.pju_information3, hr_api.g_varchar2) <>
1059: nvl(p_rec.pju_information3, hr_api.g_varchar2) or
1060: nvl(per_pju_shd.g_old_rec.pju_information4, hr_api.g_varchar2) <>
1061: nvl(p_rec.pju_information4, hr_api.g_varchar2) or
1062: nvl(per_pju_shd.g_old_rec.pju_information5, hr_api.g_varchar2) <>
1063: nvl(p_rec.pju_information5, hr_api.g_varchar2) or
1064: nvl(per_pju_shd.g_old_rec.pju_information6, hr_api.g_varchar2) <>
1065: nvl(p_rec.pju_information6, hr_api.g_varchar2) or
1058: nvl(per_pju_shd.g_old_rec.pju_information3, hr_api.g_varchar2) <>
1059: nvl(p_rec.pju_information3, hr_api.g_varchar2) or
1060: nvl(per_pju_shd.g_old_rec.pju_information4, hr_api.g_varchar2) <>
1061: nvl(p_rec.pju_information4, hr_api.g_varchar2) or
1062: nvl(per_pju_shd.g_old_rec.pju_information5, hr_api.g_varchar2) <>
1063: nvl(p_rec.pju_information5, hr_api.g_varchar2) or
1064: nvl(per_pju_shd.g_old_rec.pju_information6, hr_api.g_varchar2) <>
1065: nvl(p_rec.pju_information6, hr_api.g_varchar2) or
1066: nvl(per_pju_shd.g_old_rec.pju_information7, hr_api.g_varchar2) <>
1059: nvl(p_rec.pju_information3, hr_api.g_varchar2) or
1060: nvl(per_pju_shd.g_old_rec.pju_information4, hr_api.g_varchar2) <>
1061: nvl(p_rec.pju_information4, hr_api.g_varchar2) or
1062: nvl(per_pju_shd.g_old_rec.pju_information5, hr_api.g_varchar2) <>
1063: nvl(p_rec.pju_information5, hr_api.g_varchar2) or
1064: nvl(per_pju_shd.g_old_rec.pju_information6, hr_api.g_varchar2) <>
1065: nvl(p_rec.pju_information6, hr_api.g_varchar2) or
1066: nvl(per_pju_shd.g_old_rec.pju_information7, hr_api.g_varchar2) <>
1067: nvl(p_rec.pju_information7, hr_api.g_varchar2) or
1060: nvl(per_pju_shd.g_old_rec.pju_information4, hr_api.g_varchar2) <>
1061: nvl(p_rec.pju_information4, hr_api.g_varchar2) or
1062: nvl(per_pju_shd.g_old_rec.pju_information5, hr_api.g_varchar2) <>
1063: nvl(p_rec.pju_information5, hr_api.g_varchar2) or
1064: nvl(per_pju_shd.g_old_rec.pju_information6, hr_api.g_varchar2) <>
1065: nvl(p_rec.pju_information6, hr_api.g_varchar2) or
1066: nvl(per_pju_shd.g_old_rec.pju_information7, hr_api.g_varchar2) <>
1067: nvl(p_rec.pju_information7, hr_api.g_varchar2) or
1068: nvl(per_pju_shd.g_old_rec.pju_information8, hr_api.g_varchar2) <>
1061: nvl(p_rec.pju_information4, hr_api.g_varchar2) or
1062: nvl(per_pju_shd.g_old_rec.pju_information5, hr_api.g_varchar2) <>
1063: nvl(p_rec.pju_information5, hr_api.g_varchar2) or
1064: nvl(per_pju_shd.g_old_rec.pju_information6, hr_api.g_varchar2) <>
1065: nvl(p_rec.pju_information6, hr_api.g_varchar2) or
1066: nvl(per_pju_shd.g_old_rec.pju_information7, hr_api.g_varchar2) <>
1067: nvl(p_rec.pju_information7, hr_api.g_varchar2) or
1068: nvl(per_pju_shd.g_old_rec.pju_information8, hr_api.g_varchar2) <>
1069: nvl(p_rec.pju_information8, hr_api.g_varchar2) or
1062: nvl(per_pju_shd.g_old_rec.pju_information5, hr_api.g_varchar2) <>
1063: nvl(p_rec.pju_information5, hr_api.g_varchar2) or
1064: nvl(per_pju_shd.g_old_rec.pju_information6, hr_api.g_varchar2) <>
1065: nvl(p_rec.pju_information6, hr_api.g_varchar2) or
1066: nvl(per_pju_shd.g_old_rec.pju_information7, hr_api.g_varchar2) <>
1067: nvl(p_rec.pju_information7, hr_api.g_varchar2) or
1068: nvl(per_pju_shd.g_old_rec.pju_information8, hr_api.g_varchar2) <>
1069: nvl(p_rec.pju_information8, hr_api.g_varchar2) or
1070: nvl(per_pju_shd.g_old_rec.pju_information9, hr_api.g_varchar2) <>
1063: nvl(p_rec.pju_information5, hr_api.g_varchar2) or
1064: nvl(per_pju_shd.g_old_rec.pju_information6, hr_api.g_varchar2) <>
1065: nvl(p_rec.pju_information6, hr_api.g_varchar2) or
1066: nvl(per_pju_shd.g_old_rec.pju_information7, hr_api.g_varchar2) <>
1067: nvl(p_rec.pju_information7, hr_api.g_varchar2) or
1068: nvl(per_pju_shd.g_old_rec.pju_information8, hr_api.g_varchar2) <>
1069: nvl(p_rec.pju_information8, hr_api.g_varchar2) or
1070: nvl(per_pju_shd.g_old_rec.pju_information9, hr_api.g_varchar2) <>
1071: nvl(p_rec.pju_information9, hr_api.g_varchar2) or
1064: nvl(per_pju_shd.g_old_rec.pju_information6, hr_api.g_varchar2) <>
1065: nvl(p_rec.pju_information6, hr_api.g_varchar2) or
1066: nvl(per_pju_shd.g_old_rec.pju_information7, hr_api.g_varchar2) <>
1067: nvl(p_rec.pju_information7, hr_api.g_varchar2) or
1068: nvl(per_pju_shd.g_old_rec.pju_information8, hr_api.g_varchar2) <>
1069: nvl(p_rec.pju_information8, hr_api.g_varchar2) or
1070: nvl(per_pju_shd.g_old_rec.pju_information9, hr_api.g_varchar2) <>
1071: nvl(p_rec.pju_information9, hr_api.g_varchar2) or
1072: nvl(per_pju_shd.g_old_rec.pju_information10, hr_api.g_varchar2) <>
1065: nvl(p_rec.pju_information6, hr_api.g_varchar2) or
1066: nvl(per_pju_shd.g_old_rec.pju_information7, hr_api.g_varchar2) <>
1067: nvl(p_rec.pju_information7, hr_api.g_varchar2) or
1068: nvl(per_pju_shd.g_old_rec.pju_information8, hr_api.g_varchar2) <>
1069: nvl(p_rec.pju_information8, hr_api.g_varchar2) or
1070: nvl(per_pju_shd.g_old_rec.pju_information9, hr_api.g_varchar2) <>
1071: nvl(p_rec.pju_information9, hr_api.g_varchar2) or
1072: nvl(per_pju_shd.g_old_rec.pju_information10, hr_api.g_varchar2) <>
1073: nvl(p_rec.pju_information10, hr_api.g_varchar2) or
1066: nvl(per_pju_shd.g_old_rec.pju_information7, hr_api.g_varchar2) <>
1067: nvl(p_rec.pju_information7, hr_api.g_varchar2) or
1068: nvl(per_pju_shd.g_old_rec.pju_information8, hr_api.g_varchar2) <>
1069: nvl(p_rec.pju_information8, hr_api.g_varchar2) or
1070: nvl(per_pju_shd.g_old_rec.pju_information9, hr_api.g_varchar2) <>
1071: nvl(p_rec.pju_information9, hr_api.g_varchar2) or
1072: nvl(per_pju_shd.g_old_rec.pju_information10, hr_api.g_varchar2) <>
1073: nvl(p_rec.pju_information10, hr_api.g_varchar2) or
1074: nvl(per_pju_shd.g_old_rec.pju_information11, hr_api.g_varchar2) <>
1067: nvl(p_rec.pju_information7, hr_api.g_varchar2) or
1068: nvl(per_pju_shd.g_old_rec.pju_information8, hr_api.g_varchar2) <>
1069: nvl(p_rec.pju_information8, hr_api.g_varchar2) or
1070: nvl(per_pju_shd.g_old_rec.pju_information9, hr_api.g_varchar2) <>
1071: nvl(p_rec.pju_information9, hr_api.g_varchar2) or
1072: nvl(per_pju_shd.g_old_rec.pju_information10, hr_api.g_varchar2) <>
1073: nvl(p_rec.pju_information10, hr_api.g_varchar2) or
1074: nvl(per_pju_shd.g_old_rec.pju_information11, hr_api.g_varchar2) <>
1075: nvl(p_rec.pju_information11, hr_api.g_varchar2) or
1068: nvl(per_pju_shd.g_old_rec.pju_information8, hr_api.g_varchar2) <>
1069: nvl(p_rec.pju_information8, hr_api.g_varchar2) or
1070: nvl(per_pju_shd.g_old_rec.pju_information9, hr_api.g_varchar2) <>
1071: nvl(p_rec.pju_information9, hr_api.g_varchar2) or
1072: nvl(per_pju_shd.g_old_rec.pju_information10, hr_api.g_varchar2) <>
1073: nvl(p_rec.pju_information10, hr_api.g_varchar2) or
1074: nvl(per_pju_shd.g_old_rec.pju_information11, hr_api.g_varchar2) <>
1075: nvl(p_rec.pju_information11, hr_api.g_varchar2) or
1076: nvl(per_pju_shd.g_old_rec.pju_information12, hr_api.g_varchar2) <>
1069: nvl(p_rec.pju_information8, hr_api.g_varchar2) or
1070: nvl(per_pju_shd.g_old_rec.pju_information9, hr_api.g_varchar2) <>
1071: nvl(p_rec.pju_information9, hr_api.g_varchar2) or
1072: nvl(per_pju_shd.g_old_rec.pju_information10, hr_api.g_varchar2) <>
1073: nvl(p_rec.pju_information10, hr_api.g_varchar2) or
1074: nvl(per_pju_shd.g_old_rec.pju_information11, hr_api.g_varchar2) <>
1075: nvl(p_rec.pju_information11, hr_api.g_varchar2) or
1076: nvl(per_pju_shd.g_old_rec.pju_information12, hr_api.g_varchar2) <>
1077: nvl(p_rec.pju_information12, hr_api.g_varchar2) or
1070: nvl(per_pju_shd.g_old_rec.pju_information9, hr_api.g_varchar2) <>
1071: nvl(p_rec.pju_information9, hr_api.g_varchar2) or
1072: nvl(per_pju_shd.g_old_rec.pju_information10, hr_api.g_varchar2) <>
1073: nvl(p_rec.pju_information10, hr_api.g_varchar2) or
1074: nvl(per_pju_shd.g_old_rec.pju_information11, hr_api.g_varchar2) <>
1075: nvl(p_rec.pju_information11, hr_api.g_varchar2) or
1076: nvl(per_pju_shd.g_old_rec.pju_information12, hr_api.g_varchar2) <>
1077: nvl(p_rec.pju_information12, hr_api.g_varchar2) or
1078: nvl(per_pju_shd.g_old_rec.pju_information13, hr_api.g_varchar2) <>
1071: nvl(p_rec.pju_information9, hr_api.g_varchar2) or
1072: nvl(per_pju_shd.g_old_rec.pju_information10, hr_api.g_varchar2) <>
1073: nvl(p_rec.pju_information10, hr_api.g_varchar2) or
1074: nvl(per_pju_shd.g_old_rec.pju_information11, hr_api.g_varchar2) <>
1075: nvl(p_rec.pju_information11, hr_api.g_varchar2) or
1076: nvl(per_pju_shd.g_old_rec.pju_information12, hr_api.g_varchar2) <>
1077: nvl(p_rec.pju_information12, hr_api.g_varchar2) or
1078: nvl(per_pju_shd.g_old_rec.pju_information13, hr_api.g_varchar2) <>
1079: nvl(p_rec.pju_information13, hr_api.g_varchar2) or
1072: nvl(per_pju_shd.g_old_rec.pju_information10, hr_api.g_varchar2) <>
1073: nvl(p_rec.pju_information10, hr_api.g_varchar2) or
1074: nvl(per_pju_shd.g_old_rec.pju_information11, hr_api.g_varchar2) <>
1075: nvl(p_rec.pju_information11, hr_api.g_varchar2) or
1076: nvl(per_pju_shd.g_old_rec.pju_information12, hr_api.g_varchar2) <>
1077: nvl(p_rec.pju_information12, hr_api.g_varchar2) or
1078: nvl(per_pju_shd.g_old_rec.pju_information13, hr_api.g_varchar2) <>
1079: nvl(p_rec.pju_information13, hr_api.g_varchar2) or
1080: nvl(per_pju_shd.g_old_rec.pju_information14, hr_api.g_varchar2) <>
1073: nvl(p_rec.pju_information10, hr_api.g_varchar2) or
1074: nvl(per_pju_shd.g_old_rec.pju_information11, hr_api.g_varchar2) <>
1075: nvl(p_rec.pju_information11, hr_api.g_varchar2) or
1076: nvl(per_pju_shd.g_old_rec.pju_information12, hr_api.g_varchar2) <>
1077: nvl(p_rec.pju_information12, hr_api.g_varchar2) or
1078: nvl(per_pju_shd.g_old_rec.pju_information13, hr_api.g_varchar2) <>
1079: nvl(p_rec.pju_information13, hr_api.g_varchar2) or
1080: nvl(per_pju_shd.g_old_rec.pju_information14, hr_api.g_varchar2) <>
1081: nvl(p_rec.pju_information14, hr_api.g_varchar2) or
1074: nvl(per_pju_shd.g_old_rec.pju_information11, hr_api.g_varchar2) <>
1075: nvl(p_rec.pju_information11, hr_api.g_varchar2) or
1076: nvl(per_pju_shd.g_old_rec.pju_information12, hr_api.g_varchar2) <>
1077: nvl(p_rec.pju_information12, hr_api.g_varchar2) or
1078: nvl(per_pju_shd.g_old_rec.pju_information13, hr_api.g_varchar2) <>
1079: nvl(p_rec.pju_information13, hr_api.g_varchar2) or
1080: nvl(per_pju_shd.g_old_rec.pju_information14, hr_api.g_varchar2) <>
1081: nvl(p_rec.pju_information14, hr_api.g_varchar2) or
1082: nvl(per_pju_shd.g_old_rec.pju_information15, hr_api.g_varchar2) <>
1075: nvl(p_rec.pju_information11, hr_api.g_varchar2) or
1076: nvl(per_pju_shd.g_old_rec.pju_information12, hr_api.g_varchar2) <>
1077: nvl(p_rec.pju_information12, hr_api.g_varchar2) or
1078: nvl(per_pju_shd.g_old_rec.pju_information13, hr_api.g_varchar2) <>
1079: nvl(p_rec.pju_information13, hr_api.g_varchar2) or
1080: nvl(per_pju_shd.g_old_rec.pju_information14, hr_api.g_varchar2) <>
1081: nvl(p_rec.pju_information14, hr_api.g_varchar2) or
1082: nvl(per_pju_shd.g_old_rec.pju_information15, hr_api.g_varchar2) <>
1083: nvl(p_rec.pju_information15, hr_api.g_varchar2) or
1076: nvl(per_pju_shd.g_old_rec.pju_information12, hr_api.g_varchar2) <>
1077: nvl(p_rec.pju_information12, hr_api.g_varchar2) or
1078: nvl(per_pju_shd.g_old_rec.pju_information13, hr_api.g_varchar2) <>
1079: nvl(p_rec.pju_information13, hr_api.g_varchar2) or
1080: nvl(per_pju_shd.g_old_rec.pju_information14, hr_api.g_varchar2) <>
1081: nvl(p_rec.pju_information14, hr_api.g_varchar2) or
1082: nvl(per_pju_shd.g_old_rec.pju_information15, hr_api.g_varchar2) <>
1083: nvl(p_rec.pju_information15, hr_api.g_varchar2) or
1084: nvl(per_pju_shd.g_old_rec.pju_information16, hr_api.g_varchar2) <>
1077: nvl(p_rec.pju_information12, hr_api.g_varchar2) or
1078: nvl(per_pju_shd.g_old_rec.pju_information13, hr_api.g_varchar2) <>
1079: nvl(p_rec.pju_information13, hr_api.g_varchar2) or
1080: nvl(per_pju_shd.g_old_rec.pju_information14, hr_api.g_varchar2) <>
1081: nvl(p_rec.pju_information14, hr_api.g_varchar2) or
1082: nvl(per_pju_shd.g_old_rec.pju_information15, hr_api.g_varchar2) <>
1083: nvl(p_rec.pju_information15, hr_api.g_varchar2) or
1084: nvl(per_pju_shd.g_old_rec.pju_information16, hr_api.g_varchar2) <>
1085: nvl(p_rec.pju_information16, hr_api.g_varchar2) or
1078: nvl(per_pju_shd.g_old_rec.pju_information13, hr_api.g_varchar2) <>
1079: nvl(p_rec.pju_information13, hr_api.g_varchar2) or
1080: nvl(per_pju_shd.g_old_rec.pju_information14, hr_api.g_varchar2) <>
1081: nvl(p_rec.pju_information14, hr_api.g_varchar2) or
1082: nvl(per_pju_shd.g_old_rec.pju_information15, hr_api.g_varchar2) <>
1083: nvl(p_rec.pju_information15, hr_api.g_varchar2) or
1084: nvl(per_pju_shd.g_old_rec.pju_information16, hr_api.g_varchar2) <>
1085: nvl(p_rec.pju_information16, hr_api.g_varchar2) or
1086: nvl(per_pju_shd.g_old_rec.pju_information17, hr_api.g_varchar2) <>
1079: nvl(p_rec.pju_information13, hr_api.g_varchar2) or
1080: nvl(per_pju_shd.g_old_rec.pju_information14, hr_api.g_varchar2) <>
1081: nvl(p_rec.pju_information14, hr_api.g_varchar2) or
1082: nvl(per_pju_shd.g_old_rec.pju_information15, hr_api.g_varchar2) <>
1083: nvl(p_rec.pju_information15, hr_api.g_varchar2) or
1084: nvl(per_pju_shd.g_old_rec.pju_information16, hr_api.g_varchar2) <>
1085: nvl(p_rec.pju_information16, hr_api.g_varchar2) or
1086: nvl(per_pju_shd.g_old_rec.pju_information17, hr_api.g_varchar2) <>
1087: nvl(p_rec.pju_information17, hr_api.g_varchar2) or
1080: nvl(per_pju_shd.g_old_rec.pju_information14, hr_api.g_varchar2) <>
1081: nvl(p_rec.pju_information14, hr_api.g_varchar2) or
1082: nvl(per_pju_shd.g_old_rec.pju_information15, hr_api.g_varchar2) <>
1083: nvl(p_rec.pju_information15, hr_api.g_varchar2) or
1084: nvl(per_pju_shd.g_old_rec.pju_information16, hr_api.g_varchar2) <>
1085: nvl(p_rec.pju_information16, hr_api.g_varchar2) or
1086: nvl(per_pju_shd.g_old_rec.pju_information17, hr_api.g_varchar2) <>
1087: nvl(p_rec.pju_information17, hr_api.g_varchar2) or
1088: nvl(per_pju_shd.g_old_rec.pju_information18, hr_api.g_varchar2) <>
1081: nvl(p_rec.pju_information14, hr_api.g_varchar2) or
1082: nvl(per_pju_shd.g_old_rec.pju_information15, hr_api.g_varchar2) <>
1083: nvl(p_rec.pju_information15, hr_api.g_varchar2) or
1084: nvl(per_pju_shd.g_old_rec.pju_information16, hr_api.g_varchar2) <>
1085: nvl(p_rec.pju_information16, hr_api.g_varchar2) or
1086: nvl(per_pju_shd.g_old_rec.pju_information17, hr_api.g_varchar2) <>
1087: nvl(p_rec.pju_information17, hr_api.g_varchar2) or
1088: nvl(per_pju_shd.g_old_rec.pju_information18, hr_api.g_varchar2) <>
1089: nvl(p_rec.pju_information18, hr_api.g_varchar2) or
1082: nvl(per_pju_shd.g_old_rec.pju_information15, hr_api.g_varchar2) <>
1083: nvl(p_rec.pju_information15, hr_api.g_varchar2) or
1084: nvl(per_pju_shd.g_old_rec.pju_information16, hr_api.g_varchar2) <>
1085: nvl(p_rec.pju_information16, hr_api.g_varchar2) or
1086: nvl(per_pju_shd.g_old_rec.pju_information17, hr_api.g_varchar2) <>
1087: nvl(p_rec.pju_information17, hr_api.g_varchar2) or
1088: nvl(per_pju_shd.g_old_rec.pju_information18, hr_api.g_varchar2) <>
1089: nvl(p_rec.pju_information18, hr_api.g_varchar2) or
1090: nvl(per_pju_shd.g_old_rec.pju_information19, hr_api.g_varchar2) <>
1083: nvl(p_rec.pju_information15, hr_api.g_varchar2) or
1084: nvl(per_pju_shd.g_old_rec.pju_information16, hr_api.g_varchar2) <>
1085: nvl(p_rec.pju_information16, hr_api.g_varchar2) or
1086: nvl(per_pju_shd.g_old_rec.pju_information17, hr_api.g_varchar2) <>
1087: nvl(p_rec.pju_information17, hr_api.g_varchar2) or
1088: nvl(per_pju_shd.g_old_rec.pju_information18, hr_api.g_varchar2) <>
1089: nvl(p_rec.pju_information18, hr_api.g_varchar2) or
1090: nvl(per_pju_shd.g_old_rec.pju_information19, hr_api.g_varchar2) <>
1091: nvl(p_rec.pju_information19, hr_api.g_varchar2) or
1084: nvl(per_pju_shd.g_old_rec.pju_information16, hr_api.g_varchar2) <>
1085: nvl(p_rec.pju_information16, hr_api.g_varchar2) or
1086: nvl(per_pju_shd.g_old_rec.pju_information17, hr_api.g_varchar2) <>
1087: nvl(p_rec.pju_information17, hr_api.g_varchar2) or
1088: nvl(per_pju_shd.g_old_rec.pju_information18, hr_api.g_varchar2) <>
1089: nvl(p_rec.pju_information18, hr_api.g_varchar2) or
1090: nvl(per_pju_shd.g_old_rec.pju_information19, hr_api.g_varchar2) <>
1091: nvl(p_rec.pju_information19, hr_api.g_varchar2) or
1092: nvl(per_pju_shd.g_old_rec.pju_information20, hr_api.g_varchar2) <>
1085: nvl(p_rec.pju_information16, hr_api.g_varchar2) or
1086: nvl(per_pju_shd.g_old_rec.pju_information17, hr_api.g_varchar2) <>
1087: nvl(p_rec.pju_information17, hr_api.g_varchar2) or
1088: nvl(per_pju_shd.g_old_rec.pju_information18, hr_api.g_varchar2) <>
1089: nvl(p_rec.pju_information18, hr_api.g_varchar2) or
1090: nvl(per_pju_shd.g_old_rec.pju_information19, hr_api.g_varchar2) <>
1091: nvl(p_rec.pju_information19, hr_api.g_varchar2) or
1092: nvl(per_pju_shd.g_old_rec.pju_information20, hr_api.g_varchar2) <>
1093: nvl(p_rec.pju_information20, hr_api.g_varchar2) ))
1086: nvl(per_pju_shd.g_old_rec.pju_information17, hr_api.g_varchar2) <>
1087: nvl(p_rec.pju_information17, hr_api.g_varchar2) or
1088: nvl(per_pju_shd.g_old_rec.pju_information18, hr_api.g_varchar2) <>
1089: nvl(p_rec.pju_information18, hr_api.g_varchar2) or
1090: nvl(per_pju_shd.g_old_rec.pju_information19, hr_api.g_varchar2) <>
1091: nvl(p_rec.pju_information19, hr_api.g_varchar2) or
1092: nvl(per_pju_shd.g_old_rec.pju_information20, hr_api.g_varchar2) <>
1093: nvl(p_rec.pju_information20, hr_api.g_varchar2) ))
1094: or (p_rec.previous_job_usage_id is null) then
1087: nvl(p_rec.pju_information17, hr_api.g_varchar2) or
1088: nvl(per_pju_shd.g_old_rec.pju_information18, hr_api.g_varchar2) <>
1089: nvl(p_rec.pju_information18, hr_api.g_varchar2) or
1090: nvl(per_pju_shd.g_old_rec.pju_information19, hr_api.g_varchar2) <>
1091: nvl(p_rec.pju_information19, hr_api.g_varchar2) or
1092: nvl(per_pju_shd.g_old_rec.pju_information20, hr_api.g_varchar2) <>
1093: nvl(p_rec.pju_information20, hr_api.g_varchar2) ))
1094: or (p_rec.previous_job_usage_id is null) then
1095: --
1088: nvl(per_pju_shd.g_old_rec.pju_information18, hr_api.g_varchar2) <>
1089: nvl(p_rec.pju_information18, hr_api.g_varchar2) or
1090: nvl(per_pju_shd.g_old_rec.pju_information19, hr_api.g_varchar2) <>
1091: nvl(p_rec.pju_information19, hr_api.g_varchar2) or
1092: nvl(per_pju_shd.g_old_rec.pju_information20, hr_api.g_varchar2) <>
1093: nvl(p_rec.pju_information20, hr_api.g_varchar2) ))
1094: or (p_rec.previous_job_usage_id is null) then
1095: --
1096: -- Only execute the validation if absolutely necessary:
1089: nvl(p_rec.pju_information18, hr_api.g_varchar2) or
1090: nvl(per_pju_shd.g_old_rec.pju_information19, hr_api.g_varchar2) <>
1091: nvl(p_rec.pju_information19, hr_api.g_varchar2) or
1092: nvl(per_pju_shd.g_old_rec.pju_information20, hr_api.g_varchar2) <>
1093: nvl(p_rec.pju_information20, hr_api.g_varchar2) ))
1094: or (p_rec.previous_job_usage_id is null) then
1095: --
1096: -- Only execute the validation if absolutely necessary:
1097: -- a) During update, the structure column value or any
1185: begin
1186: hr_utility.set_location('Entering:'||l_proc,10);
1187: --
1188: if ((p_rec.previous_job_usage_id is not null) and (
1189: nvl(per_pju_shd.g_old_rec.pju_attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.pju_attribute_category, hr_api.g_varchar2) or
1191: nvl(per_pju_shd.g_old_rec.pju_attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.pju_attribute1, hr_api.g_varchar2) or
1193: nvl(per_pju_shd.g_old_rec.pju_attribute2, hr_api.g_varchar2) <>
1186: hr_utility.set_location('Entering:'||l_proc,10);
1187: --
1188: if ((p_rec.previous_job_usage_id is not null) and (
1189: nvl(per_pju_shd.g_old_rec.pju_attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.pju_attribute_category, hr_api.g_varchar2) or
1191: nvl(per_pju_shd.g_old_rec.pju_attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.pju_attribute1, hr_api.g_varchar2) or
1193: nvl(per_pju_shd.g_old_rec.pju_attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.pju_attribute2, hr_api.g_varchar2) or
1187: --
1188: if ((p_rec.previous_job_usage_id is not null) and (
1189: nvl(per_pju_shd.g_old_rec.pju_attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.pju_attribute_category, hr_api.g_varchar2) or
1191: nvl(per_pju_shd.g_old_rec.pju_attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.pju_attribute1, hr_api.g_varchar2) or
1193: nvl(per_pju_shd.g_old_rec.pju_attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.pju_attribute2, hr_api.g_varchar2) or
1195: nvl(per_pju_shd.g_old_rec.pju_attribute3, hr_api.g_varchar2) <>
1188: if ((p_rec.previous_job_usage_id is not null) and (
1189: nvl(per_pju_shd.g_old_rec.pju_attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.pju_attribute_category, hr_api.g_varchar2) or
1191: nvl(per_pju_shd.g_old_rec.pju_attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.pju_attribute1, hr_api.g_varchar2) or
1193: nvl(per_pju_shd.g_old_rec.pju_attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.pju_attribute2, hr_api.g_varchar2) or
1195: nvl(per_pju_shd.g_old_rec.pju_attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.pju_attribute3, hr_api.g_varchar2) or
1189: nvl(per_pju_shd.g_old_rec.pju_attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.pju_attribute_category, hr_api.g_varchar2) or
1191: nvl(per_pju_shd.g_old_rec.pju_attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.pju_attribute1, hr_api.g_varchar2) or
1193: nvl(per_pju_shd.g_old_rec.pju_attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.pju_attribute2, hr_api.g_varchar2) or
1195: nvl(per_pju_shd.g_old_rec.pju_attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.pju_attribute3, hr_api.g_varchar2) or
1197: nvl(per_pju_shd.g_old_rec.pju_attribute4, hr_api.g_varchar2) <>
1190: nvl(p_rec.pju_attribute_category, hr_api.g_varchar2) or
1191: nvl(per_pju_shd.g_old_rec.pju_attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.pju_attribute1, hr_api.g_varchar2) or
1193: nvl(per_pju_shd.g_old_rec.pju_attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.pju_attribute2, hr_api.g_varchar2) or
1195: nvl(per_pju_shd.g_old_rec.pju_attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.pju_attribute3, hr_api.g_varchar2) or
1197: nvl(per_pju_shd.g_old_rec.pju_attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.pju_attribute4, hr_api.g_varchar2) or
1191: nvl(per_pju_shd.g_old_rec.pju_attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.pju_attribute1, hr_api.g_varchar2) or
1193: nvl(per_pju_shd.g_old_rec.pju_attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.pju_attribute2, hr_api.g_varchar2) or
1195: nvl(per_pju_shd.g_old_rec.pju_attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.pju_attribute3, hr_api.g_varchar2) or
1197: nvl(per_pju_shd.g_old_rec.pju_attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.pju_attribute4, hr_api.g_varchar2) or
1199: nvl(per_pju_shd.g_old_rec.pju_attribute5, hr_api.g_varchar2) <>
1192: nvl(p_rec.pju_attribute1, hr_api.g_varchar2) or
1193: nvl(per_pju_shd.g_old_rec.pju_attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.pju_attribute2, hr_api.g_varchar2) or
1195: nvl(per_pju_shd.g_old_rec.pju_attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.pju_attribute3, hr_api.g_varchar2) or
1197: nvl(per_pju_shd.g_old_rec.pju_attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.pju_attribute4, hr_api.g_varchar2) or
1199: nvl(per_pju_shd.g_old_rec.pju_attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.pju_attribute5, hr_api.g_varchar2) or
1193: nvl(per_pju_shd.g_old_rec.pju_attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.pju_attribute2, hr_api.g_varchar2) or
1195: nvl(per_pju_shd.g_old_rec.pju_attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.pju_attribute3, hr_api.g_varchar2) or
1197: nvl(per_pju_shd.g_old_rec.pju_attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.pju_attribute4, hr_api.g_varchar2) or
1199: nvl(per_pju_shd.g_old_rec.pju_attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.pju_attribute5, hr_api.g_varchar2) or
1201: nvl(per_pju_shd.g_old_rec.pju_attribute6, hr_api.g_varchar2) <>
1194: nvl(p_rec.pju_attribute2, hr_api.g_varchar2) or
1195: nvl(per_pju_shd.g_old_rec.pju_attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.pju_attribute3, hr_api.g_varchar2) or
1197: nvl(per_pju_shd.g_old_rec.pju_attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.pju_attribute4, hr_api.g_varchar2) or
1199: nvl(per_pju_shd.g_old_rec.pju_attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.pju_attribute5, hr_api.g_varchar2) or
1201: nvl(per_pju_shd.g_old_rec.pju_attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.pju_attribute6, hr_api.g_varchar2) or
1195: nvl(per_pju_shd.g_old_rec.pju_attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.pju_attribute3, hr_api.g_varchar2) or
1197: nvl(per_pju_shd.g_old_rec.pju_attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.pju_attribute4, hr_api.g_varchar2) or
1199: nvl(per_pju_shd.g_old_rec.pju_attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.pju_attribute5, hr_api.g_varchar2) or
1201: nvl(per_pju_shd.g_old_rec.pju_attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.pju_attribute6, hr_api.g_varchar2) or
1203: nvl(per_pju_shd.g_old_rec.pju_attribute7, hr_api.g_varchar2) <>
1196: nvl(p_rec.pju_attribute3, hr_api.g_varchar2) or
1197: nvl(per_pju_shd.g_old_rec.pju_attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.pju_attribute4, hr_api.g_varchar2) or
1199: nvl(per_pju_shd.g_old_rec.pju_attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.pju_attribute5, hr_api.g_varchar2) or
1201: nvl(per_pju_shd.g_old_rec.pju_attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.pju_attribute6, hr_api.g_varchar2) or
1203: nvl(per_pju_shd.g_old_rec.pju_attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.pju_attribute7, hr_api.g_varchar2) or
1197: nvl(per_pju_shd.g_old_rec.pju_attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.pju_attribute4, hr_api.g_varchar2) or
1199: nvl(per_pju_shd.g_old_rec.pju_attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.pju_attribute5, hr_api.g_varchar2) or
1201: nvl(per_pju_shd.g_old_rec.pju_attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.pju_attribute6, hr_api.g_varchar2) or
1203: nvl(per_pju_shd.g_old_rec.pju_attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.pju_attribute7, hr_api.g_varchar2) or
1205: nvl(per_pju_shd.g_old_rec.pju_attribute8, hr_api.g_varchar2) <>
1198: nvl(p_rec.pju_attribute4, hr_api.g_varchar2) or
1199: nvl(per_pju_shd.g_old_rec.pju_attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.pju_attribute5, hr_api.g_varchar2) or
1201: nvl(per_pju_shd.g_old_rec.pju_attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.pju_attribute6, hr_api.g_varchar2) or
1203: nvl(per_pju_shd.g_old_rec.pju_attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.pju_attribute7, hr_api.g_varchar2) or
1205: nvl(per_pju_shd.g_old_rec.pju_attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.pju_attribute8, hr_api.g_varchar2) or
1199: nvl(per_pju_shd.g_old_rec.pju_attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.pju_attribute5, hr_api.g_varchar2) or
1201: nvl(per_pju_shd.g_old_rec.pju_attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.pju_attribute6, hr_api.g_varchar2) or
1203: nvl(per_pju_shd.g_old_rec.pju_attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.pju_attribute7, hr_api.g_varchar2) or
1205: nvl(per_pju_shd.g_old_rec.pju_attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.pju_attribute8, hr_api.g_varchar2) or
1207: nvl(per_pju_shd.g_old_rec.pju_attribute9, hr_api.g_varchar2) <>
1200: nvl(p_rec.pju_attribute5, hr_api.g_varchar2) or
1201: nvl(per_pju_shd.g_old_rec.pju_attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.pju_attribute6, hr_api.g_varchar2) or
1203: nvl(per_pju_shd.g_old_rec.pju_attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.pju_attribute7, hr_api.g_varchar2) or
1205: nvl(per_pju_shd.g_old_rec.pju_attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.pju_attribute8, hr_api.g_varchar2) or
1207: nvl(per_pju_shd.g_old_rec.pju_attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.pju_attribute9, hr_api.g_varchar2) or
1201: nvl(per_pju_shd.g_old_rec.pju_attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.pju_attribute6, hr_api.g_varchar2) or
1203: nvl(per_pju_shd.g_old_rec.pju_attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.pju_attribute7, hr_api.g_varchar2) or
1205: nvl(per_pju_shd.g_old_rec.pju_attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.pju_attribute8, hr_api.g_varchar2) or
1207: nvl(per_pju_shd.g_old_rec.pju_attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.pju_attribute9, hr_api.g_varchar2) or
1209: nvl(per_pju_shd.g_old_rec.pju_attribute10, hr_api.g_varchar2) <>
1202: nvl(p_rec.pju_attribute6, hr_api.g_varchar2) or
1203: nvl(per_pju_shd.g_old_rec.pju_attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.pju_attribute7, hr_api.g_varchar2) or
1205: nvl(per_pju_shd.g_old_rec.pju_attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.pju_attribute8, hr_api.g_varchar2) or
1207: nvl(per_pju_shd.g_old_rec.pju_attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.pju_attribute9, hr_api.g_varchar2) or
1209: nvl(per_pju_shd.g_old_rec.pju_attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.pju_attribute10, hr_api.g_varchar2) or
1203: nvl(per_pju_shd.g_old_rec.pju_attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.pju_attribute7, hr_api.g_varchar2) or
1205: nvl(per_pju_shd.g_old_rec.pju_attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.pju_attribute8, hr_api.g_varchar2) or
1207: nvl(per_pju_shd.g_old_rec.pju_attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.pju_attribute9, hr_api.g_varchar2) or
1209: nvl(per_pju_shd.g_old_rec.pju_attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.pju_attribute10, hr_api.g_varchar2) or
1211: nvl(per_pju_shd.g_old_rec.pju_attribute11, hr_api.g_varchar2) <>
1204: nvl(p_rec.pju_attribute7, hr_api.g_varchar2) or
1205: nvl(per_pju_shd.g_old_rec.pju_attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.pju_attribute8, hr_api.g_varchar2) or
1207: nvl(per_pju_shd.g_old_rec.pju_attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.pju_attribute9, hr_api.g_varchar2) or
1209: nvl(per_pju_shd.g_old_rec.pju_attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.pju_attribute10, hr_api.g_varchar2) or
1211: nvl(per_pju_shd.g_old_rec.pju_attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.pju_attribute11, hr_api.g_varchar2) or
1205: nvl(per_pju_shd.g_old_rec.pju_attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.pju_attribute8, hr_api.g_varchar2) or
1207: nvl(per_pju_shd.g_old_rec.pju_attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.pju_attribute9, hr_api.g_varchar2) or
1209: nvl(per_pju_shd.g_old_rec.pju_attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.pju_attribute10, hr_api.g_varchar2) or
1211: nvl(per_pju_shd.g_old_rec.pju_attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.pju_attribute11, hr_api.g_varchar2) or
1213: nvl(per_pju_shd.g_old_rec.pju_attribute12, hr_api.g_varchar2) <>
1206: nvl(p_rec.pju_attribute8, hr_api.g_varchar2) or
1207: nvl(per_pju_shd.g_old_rec.pju_attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.pju_attribute9, hr_api.g_varchar2) or
1209: nvl(per_pju_shd.g_old_rec.pju_attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.pju_attribute10, hr_api.g_varchar2) or
1211: nvl(per_pju_shd.g_old_rec.pju_attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.pju_attribute11, hr_api.g_varchar2) or
1213: nvl(per_pju_shd.g_old_rec.pju_attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.pju_attribute12, hr_api.g_varchar2) or
1207: nvl(per_pju_shd.g_old_rec.pju_attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.pju_attribute9, hr_api.g_varchar2) or
1209: nvl(per_pju_shd.g_old_rec.pju_attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.pju_attribute10, hr_api.g_varchar2) or
1211: nvl(per_pju_shd.g_old_rec.pju_attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.pju_attribute11, hr_api.g_varchar2) or
1213: nvl(per_pju_shd.g_old_rec.pju_attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.pju_attribute12, hr_api.g_varchar2) or
1215: nvl(per_pju_shd.g_old_rec.pju_attribute13, hr_api.g_varchar2) <>
1208: nvl(p_rec.pju_attribute9, hr_api.g_varchar2) or
1209: nvl(per_pju_shd.g_old_rec.pju_attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.pju_attribute10, hr_api.g_varchar2) or
1211: nvl(per_pju_shd.g_old_rec.pju_attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.pju_attribute11, hr_api.g_varchar2) or
1213: nvl(per_pju_shd.g_old_rec.pju_attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.pju_attribute12, hr_api.g_varchar2) or
1215: nvl(per_pju_shd.g_old_rec.pju_attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.pju_attribute13, hr_api.g_varchar2) or
1209: nvl(per_pju_shd.g_old_rec.pju_attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.pju_attribute10, hr_api.g_varchar2) or
1211: nvl(per_pju_shd.g_old_rec.pju_attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.pju_attribute11, hr_api.g_varchar2) or
1213: nvl(per_pju_shd.g_old_rec.pju_attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.pju_attribute12, hr_api.g_varchar2) or
1215: nvl(per_pju_shd.g_old_rec.pju_attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.pju_attribute13, hr_api.g_varchar2) or
1217: nvl(per_pju_shd.g_old_rec.pju_attribute14, hr_api.g_varchar2) <>
1210: nvl(p_rec.pju_attribute10, hr_api.g_varchar2) or
1211: nvl(per_pju_shd.g_old_rec.pju_attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.pju_attribute11, hr_api.g_varchar2) or
1213: nvl(per_pju_shd.g_old_rec.pju_attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.pju_attribute12, hr_api.g_varchar2) or
1215: nvl(per_pju_shd.g_old_rec.pju_attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.pju_attribute13, hr_api.g_varchar2) or
1217: nvl(per_pju_shd.g_old_rec.pju_attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.pju_attribute14, hr_api.g_varchar2) or
1211: nvl(per_pju_shd.g_old_rec.pju_attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.pju_attribute11, hr_api.g_varchar2) or
1213: nvl(per_pju_shd.g_old_rec.pju_attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.pju_attribute12, hr_api.g_varchar2) or
1215: nvl(per_pju_shd.g_old_rec.pju_attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.pju_attribute13, hr_api.g_varchar2) or
1217: nvl(per_pju_shd.g_old_rec.pju_attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.pju_attribute14, hr_api.g_varchar2) or
1219: nvl(per_pju_shd.g_old_rec.pju_attribute15, hr_api.g_varchar2) <>
1212: nvl(p_rec.pju_attribute11, hr_api.g_varchar2) or
1213: nvl(per_pju_shd.g_old_rec.pju_attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.pju_attribute12, hr_api.g_varchar2) or
1215: nvl(per_pju_shd.g_old_rec.pju_attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.pju_attribute13, hr_api.g_varchar2) or
1217: nvl(per_pju_shd.g_old_rec.pju_attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.pju_attribute14, hr_api.g_varchar2) or
1219: nvl(per_pju_shd.g_old_rec.pju_attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.pju_attribute15, hr_api.g_varchar2) or
1213: nvl(per_pju_shd.g_old_rec.pju_attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.pju_attribute12, hr_api.g_varchar2) or
1215: nvl(per_pju_shd.g_old_rec.pju_attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.pju_attribute13, hr_api.g_varchar2) or
1217: nvl(per_pju_shd.g_old_rec.pju_attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.pju_attribute14, hr_api.g_varchar2) or
1219: nvl(per_pju_shd.g_old_rec.pju_attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.pju_attribute15, hr_api.g_varchar2) or
1221: nvl(per_pju_shd.g_old_rec.pju_attribute16, hr_api.g_varchar2) <>
1214: nvl(p_rec.pju_attribute12, hr_api.g_varchar2) or
1215: nvl(per_pju_shd.g_old_rec.pju_attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.pju_attribute13, hr_api.g_varchar2) or
1217: nvl(per_pju_shd.g_old_rec.pju_attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.pju_attribute14, hr_api.g_varchar2) or
1219: nvl(per_pju_shd.g_old_rec.pju_attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.pju_attribute15, hr_api.g_varchar2) or
1221: nvl(per_pju_shd.g_old_rec.pju_attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.pju_attribute16, hr_api.g_varchar2) or
1215: nvl(per_pju_shd.g_old_rec.pju_attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.pju_attribute13, hr_api.g_varchar2) or
1217: nvl(per_pju_shd.g_old_rec.pju_attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.pju_attribute14, hr_api.g_varchar2) or
1219: nvl(per_pju_shd.g_old_rec.pju_attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.pju_attribute15, hr_api.g_varchar2) or
1221: nvl(per_pju_shd.g_old_rec.pju_attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.pju_attribute16, hr_api.g_varchar2) or
1223: nvl(per_pju_shd.g_old_rec.pju_attribute17, hr_api.g_varchar2) <>
1216: nvl(p_rec.pju_attribute13, hr_api.g_varchar2) or
1217: nvl(per_pju_shd.g_old_rec.pju_attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.pju_attribute14, hr_api.g_varchar2) or
1219: nvl(per_pju_shd.g_old_rec.pju_attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.pju_attribute15, hr_api.g_varchar2) or
1221: nvl(per_pju_shd.g_old_rec.pju_attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.pju_attribute16, hr_api.g_varchar2) or
1223: nvl(per_pju_shd.g_old_rec.pju_attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.pju_attribute17, hr_api.g_varchar2) or
1217: nvl(per_pju_shd.g_old_rec.pju_attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.pju_attribute14, hr_api.g_varchar2) or
1219: nvl(per_pju_shd.g_old_rec.pju_attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.pju_attribute15, hr_api.g_varchar2) or
1221: nvl(per_pju_shd.g_old_rec.pju_attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.pju_attribute16, hr_api.g_varchar2) or
1223: nvl(per_pju_shd.g_old_rec.pju_attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.pju_attribute17, hr_api.g_varchar2) or
1225: nvl(per_pju_shd.g_old_rec.pju_attribute18, hr_api.g_varchar2) <>
1218: nvl(p_rec.pju_attribute14, hr_api.g_varchar2) or
1219: nvl(per_pju_shd.g_old_rec.pju_attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.pju_attribute15, hr_api.g_varchar2) or
1221: nvl(per_pju_shd.g_old_rec.pju_attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.pju_attribute16, hr_api.g_varchar2) or
1223: nvl(per_pju_shd.g_old_rec.pju_attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.pju_attribute17, hr_api.g_varchar2) or
1225: nvl(per_pju_shd.g_old_rec.pju_attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.pju_attribute18, hr_api.g_varchar2) or
1219: nvl(per_pju_shd.g_old_rec.pju_attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.pju_attribute15, hr_api.g_varchar2) or
1221: nvl(per_pju_shd.g_old_rec.pju_attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.pju_attribute16, hr_api.g_varchar2) or
1223: nvl(per_pju_shd.g_old_rec.pju_attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.pju_attribute17, hr_api.g_varchar2) or
1225: nvl(per_pju_shd.g_old_rec.pju_attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.pju_attribute18, hr_api.g_varchar2) or
1227: nvl(per_pju_shd.g_old_rec.pju_attribute19, hr_api.g_varchar2) <>
1220: nvl(p_rec.pju_attribute15, hr_api.g_varchar2) or
1221: nvl(per_pju_shd.g_old_rec.pju_attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.pju_attribute16, hr_api.g_varchar2) or
1223: nvl(per_pju_shd.g_old_rec.pju_attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.pju_attribute17, hr_api.g_varchar2) or
1225: nvl(per_pju_shd.g_old_rec.pju_attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.pju_attribute18, hr_api.g_varchar2) or
1227: nvl(per_pju_shd.g_old_rec.pju_attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.pju_attribute19, hr_api.g_varchar2) or
1221: nvl(per_pju_shd.g_old_rec.pju_attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.pju_attribute16, hr_api.g_varchar2) or
1223: nvl(per_pju_shd.g_old_rec.pju_attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.pju_attribute17, hr_api.g_varchar2) or
1225: nvl(per_pju_shd.g_old_rec.pju_attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.pju_attribute18, hr_api.g_varchar2) or
1227: nvl(per_pju_shd.g_old_rec.pju_attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.pju_attribute19, hr_api.g_varchar2) or
1229: nvl(per_pju_shd.g_old_rec.pju_attribute20, hr_api.g_varchar2) <>
1222: nvl(p_rec.pju_attribute16, hr_api.g_varchar2) or
1223: nvl(per_pju_shd.g_old_rec.pju_attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.pju_attribute17, hr_api.g_varchar2) or
1225: nvl(per_pju_shd.g_old_rec.pju_attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.pju_attribute18, hr_api.g_varchar2) or
1227: nvl(per_pju_shd.g_old_rec.pju_attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.pju_attribute19, hr_api.g_varchar2) or
1229: nvl(per_pju_shd.g_old_rec.pju_attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.pju_attribute20, hr_api.g_varchar2) ))
1223: nvl(per_pju_shd.g_old_rec.pju_attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.pju_attribute17, hr_api.g_varchar2) or
1225: nvl(per_pju_shd.g_old_rec.pju_attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.pju_attribute18, hr_api.g_varchar2) or
1227: nvl(per_pju_shd.g_old_rec.pju_attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.pju_attribute19, hr_api.g_varchar2) or
1229: nvl(per_pju_shd.g_old_rec.pju_attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.pju_attribute20, hr_api.g_varchar2) ))
1231: or (p_rec.previous_job_usage_id is null) then
1224: nvl(p_rec.pju_attribute17, hr_api.g_varchar2) or
1225: nvl(per_pju_shd.g_old_rec.pju_attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.pju_attribute18, hr_api.g_varchar2) or
1227: nvl(per_pju_shd.g_old_rec.pju_attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.pju_attribute19, hr_api.g_varchar2) or
1229: nvl(per_pju_shd.g_old_rec.pju_attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.pju_attribute20, hr_api.g_varchar2) ))
1231: or (p_rec.previous_job_usage_id is null) then
1232: --
1225: nvl(per_pju_shd.g_old_rec.pju_attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.pju_attribute18, hr_api.g_varchar2) or
1227: nvl(per_pju_shd.g_old_rec.pju_attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.pju_attribute19, hr_api.g_varchar2) or
1229: nvl(per_pju_shd.g_old_rec.pju_attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.pju_attribute20, hr_api.g_varchar2) ))
1231: or (p_rec.previous_job_usage_id is null) then
1232: --
1233: -- Only execute the validation if absolutely necessary:
1226: nvl(p_rec.pju_attribute18, hr_api.g_varchar2) or
1227: nvl(per_pju_shd.g_old_rec.pju_attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.pju_attribute19, hr_api.g_varchar2) or
1229: nvl(per_pju_shd.g_old_rec.pju_attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.pju_attribute20, hr_api.g_varchar2) ))
1231: or (p_rec.previous_job_usage_id is null) then
1232: --
1233: -- Only execute the validation if absolutely necessary:
1234: -- a) During update, the structure column value or any
1336: END IF;
1337: -- Check for non updateable args
1338: if per_pju_shd.g_old_rec.previous_job_usage_id <> p_rec.previous_job_usage_id
1339: then
1340: hr_api.argument_changed_error
1341: (p_api_name => l_proc
1342: ,p_argument => 'previous_job_usage_id'
1343: );
1344: end if;
1344: end if;
1345: --
1346: if per_pju_shd.g_old_rec.previous_employer_id <> p_rec.previous_employer_id
1347: then
1348: hr_api.argument_changed_error
1349: (p_api_name => l_proc
1350: ,p_argument => 'previous_employer_id'
1351: );
1352: end if;
1352: end if;
1353: --
1354: EXCEPTION
1355: WHEN l_error THEN
1356: hr_api.argument_changed_error
1357: (p_api_name => l_proc
1358: ,p_argument => l_argument);
1359: WHEN OTHERS THEN
1360: RAISE;
1488: Begin
1489: hr_utility.set_location('Entering:'||l_proc, 5);
1490: --
1491: -- Call all supporting business operations
1492: hr_api.mandatory_arg_error
1493: (p_api_name => l_proc
1494: ,p_argument => 'assignment_id'
1495: ,p_argument_value => p_rec.assignment_id
1496: );