eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PJU_BUS dependencies on HR_API

Line 69: and nvl(per_pju_shd.g_old_rec.previous_employer_id, hr_api.g_number)

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);

Line 70: <> nvl(p_previous_employer_id,hr_api.g_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);
74: open csr_previous_employer_id;

Line 148: and nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_number)

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);

Line 149: <> nvl(p_previous_job_id,hr_api.g_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);
153: open csr_previous_job_id;

Line 225: and nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)

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);

Line 226: <> nvl(p_assignment_id,hr_api.g_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);
230: -- Check for valid Assignment ID.

Line 299: and (nvl(per_pju_shd.g_old_rec.start_date, hr_api.g_sot)

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))

Line 300: <> nvl(p_start_date,hr_api.g_sot)

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: )

Line 302: nvl(per_pju_shd.g_old_rec.end_date, hr_api.g_eot)

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

Line 303: <> nvl(p_end_date,hr_api.g_eot))

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);

Line 308: if nvl(p_start_date,hr_api.g_sot) > nvl(p_end_date,hr_api.g_eot) then

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);

Line 370: ( nvl(p_period_years,hr_api.g_number)

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

Line 371: <> nvl(per_pju_shd.g_old_rec.period_years,hr_api.g_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
375: hr_utility.set_location(l_proc, 20);

Line 438: ( nvl(p_period_months ,hr_api.g_number)

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

Line 439: <> nvl(per_pju_shd.g_old_rec.period_months ,hr_api.g_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
443: hr_utility.set_location(l_proc, 20);

Line 506: ( nvl(p_period_days ,hr_api.g_number)

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

Line 507: <> nvl(per_pju_shd.g_old_rec.period_days ,hr_api.g_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
511: hr_utility.set_location(l_proc, 20);

Line 575: and ( p_start_date not between nvl(start_date,hr_api.g_sot)

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;

Line 576: and nvl(end_date,hr_api.g_eot)

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: --

Line 577: or p_end_date not between nvl(start_date,hr_api.g_sot)

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;

Line 578: and nvl(end_date,hr_api.g_eot));

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';

Line 594: and (nvl(per_pju_shd.g_old_rec.start_date, hr_api.g_sot)

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))

Line 595: <> nvl(p_start_date,hr_api.g_sot)

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: )

Line 597: nvl(per_pju_shd.g_old_rec.end_date, hr_api.g_eot)

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

Line 598: <> nvl(p_end_date,hr_api.g_eot))

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);

Line 681: and (nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)

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: )

Line 682: <> nvl(p_assignment_id,hr_api.g_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: )
686: )

Line 683: or nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_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: )
687: or

Line 684: <> nvl(p_previous_job_id, hr_api.g_number)

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

Line 854: and (nvl(per_pju_shd.g_old_rec.assignment_id, hr_api.g_number)

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: )

Line 855: <> nvl(p_assignment_id,hr_api.g_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: )
859: )

Line 856: or nvl(per_pju_shd.g_old_rec.previous_job_id, hr_api.g_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: )
860: or

Line 857: <> nvl(p_previous_job_id, hr_api.g_number)

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

Line 909: hr_api.mandatory_arg_error

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: );

Line 932: hr_api.set_security_group_id

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);

Line 970: hr_api.mandatory_arg_error

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: );

Line 976: if ( nvl(per_pju_bus.g_previous_job_usage_id, hr_api.g_number)

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

Line 1052: nvl(per_pju_shd.g_old_rec.pju_information_category, hr_api.g_varchar2) <>

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) <>

Line 1053: nvl(p_rec.pju_information_category, hr_api.g_varchar2) or

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

Line 1054: nvl(per_pju_shd.g_old_rec.pju_information1, hr_api.g_varchar2) <>

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) <>

Line 1055: nvl(p_rec.pju_information1, hr_api.g_varchar2) or

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

Line 1056: nvl(per_pju_shd.g_old_rec.pju_information2, hr_api.g_varchar2) <>

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) <>

Line 1057: nvl(p_rec.pju_information2, hr_api.g_varchar2) or

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

Line 1058: nvl(per_pju_shd.g_old_rec.pju_information3, hr_api.g_varchar2) <>

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) <>

Line 1059: nvl(p_rec.pju_information3, hr_api.g_varchar2) or

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

Line 1060: nvl(per_pju_shd.g_old_rec.pju_information4, hr_api.g_varchar2) <>

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) <>

Line 1061: nvl(p_rec.pju_information4, hr_api.g_varchar2) or

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

Line 1062: nvl(per_pju_shd.g_old_rec.pju_information5, hr_api.g_varchar2) <>

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) <>

Line 1063: nvl(p_rec.pju_information5, hr_api.g_varchar2) or

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

Line 1064: nvl(per_pju_shd.g_old_rec.pju_information6, hr_api.g_varchar2) <>

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) <>

Line 1065: nvl(p_rec.pju_information6, hr_api.g_varchar2) or

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

Line 1066: nvl(per_pju_shd.g_old_rec.pju_information7, hr_api.g_varchar2) <>

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) <>

Line 1067: nvl(p_rec.pju_information7, hr_api.g_varchar2) or

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

Line 1068: nvl(per_pju_shd.g_old_rec.pju_information8, hr_api.g_varchar2) <>

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) <>

Line 1069: nvl(p_rec.pju_information8, hr_api.g_varchar2) or

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

Line 1070: nvl(per_pju_shd.g_old_rec.pju_information9, hr_api.g_varchar2) <>

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) <>

Line 1071: nvl(p_rec.pju_information9, hr_api.g_varchar2) or

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

Line 1072: nvl(per_pju_shd.g_old_rec.pju_information10, hr_api.g_varchar2) <>

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) <>

Line 1073: nvl(p_rec.pju_information10, hr_api.g_varchar2) or

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

Line 1074: nvl(per_pju_shd.g_old_rec.pju_information11, hr_api.g_varchar2) <>

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) <>

Line 1075: nvl(p_rec.pju_information11, hr_api.g_varchar2) or

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

Line 1076: nvl(per_pju_shd.g_old_rec.pju_information12, hr_api.g_varchar2) <>

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) <>

Line 1077: nvl(p_rec.pju_information12, hr_api.g_varchar2) or

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

Line 1078: nvl(per_pju_shd.g_old_rec.pju_information13, hr_api.g_varchar2) <>

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) <>

Line 1079: nvl(p_rec.pju_information13, hr_api.g_varchar2) or

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

Line 1080: nvl(per_pju_shd.g_old_rec.pju_information14, hr_api.g_varchar2) <>

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) <>

Line 1081: nvl(p_rec.pju_information14, hr_api.g_varchar2) or

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

Line 1082: nvl(per_pju_shd.g_old_rec.pju_information15, hr_api.g_varchar2) <>

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) <>

Line 1083: nvl(p_rec.pju_information15, hr_api.g_varchar2) or

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

Line 1084: nvl(per_pju_shd.g_old_rec.pju_information16, hr_api.g_varchar2) <>

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) <>

Line 1085: nvl(p_rec.pju_information16, hr_api.g_varchar2) or

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

Line 1086: nvl(per_pju_shd.g_old_rec.pju_information17, hr_api.g_varchar2) <>

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) <>

Line 1087: nvl(p_rec.pju_information17, hr_api.g_varchar2) or

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

Line 1088: nvl(per_pju_shd.g_old_rec.pju_information18, hr_api.g_varchar2) <>

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) <>

Line 1089: nvl(p_rec.pju_information18, hr_api.g_varchar2) or

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) ))

Line 1090: nvl(per_pju_shd.g_old_rec.pju_information19, 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

Line 1091: nvl(p_rec.pju_information19, hr_api.g_varchar2) or

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: --

Line 1092: nvl(per_pju_shd.g_old_rec.pju_information20, hr_api.g_varchar2) <>

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:

Line 1093: nvl(p_rec.pju_information20, 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:
1097: -- a) During update, the structure column value or any

Line 1189: nvl(per_pju_shd.g_old_rec.pju_attribute_category, hr_api.g_varchar2) <>

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) <>

Line 1190: nvl(p_rec.pju_attribute_category, hr_api.g_varchar2) or

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

Line 1191: nvl(per_pju_shd.g_old_rec.pju_attribute1, hr_api.g_varchar2) <>

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) <>

Line 1192: nvl(p_rec.pju_attribute1, hr_api.g_varchar2) or

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

Line 1193: nvl(per_pju_shd.g_old_rec.pju_attribute2, hr_api.g_varchar2) <>

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) <>

Line 1194: nvl(p_rec.pju_attribute2, hr_api.g_varchar2) or

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

Line 1195: nvl(per_pju_shd.g_old_rec.pju_attribute3, hr_api.g_varchar2) <>

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) <>

Line 1196: nvl(p_rec.pju_attribute3, hr_api.g_varchar2) or

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

Line 1197: nvl(per_pju_shd.g_old_rec.pju_attribute4, hr_api.g_varchar2) <>

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) <>

Line 1198: nvl(p_rec.pju_attribute4, hr_api.g_varchar2) or

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

Line 1199: nvl(per_pju_shd.g_old_rec.pju_attribute5, hr_api.g_varchar2) <>

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) <>

Line 1200: nvl(p_rec.pju_attribute5, hr_api.g_varchar2) or

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

Line 1201: nvl(per_pju_shd.g_old_rec.pju_attribute6, hr_api.g_varchar2) <>

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) <>

Line 1202: nvl(p_rec.pju_attribute6, hr_api.g_varchar2) or

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

Line 1203: nvl(per_pju_shd.g_old_rec.pju_attribute7, hr_api.g_varchar2) <>

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) <>

Line 1204: nvl(p_rec.pju_attribute7, hr_api.g_varchar2) or

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

Line 1205: nvl(per_pju_shd.g_old_rec.pju_attribute8, hr_api.g_varchar2) <>

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) <>

Line 1206: nvl(p_rec.pju_attribute8, hr_api.g_varchar2) or

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

Line 1207: nvl(per_pju_shd.g_old_rec.pju_attribute9, hr_api.g_varchar2) <>

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) <>

Line 1208: nvl(p_rec.pju_attribute9, hr_api.g_varchar2) or

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

Line 1209: nvl(per_pju_shd.g_old_rec.pju_attribute10, hr_api.g_varchar2) <>

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) <>

Line 1210: nvl(p_rec.pju_attribute10, hr_api.g_varchar2) or

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

Line 1211: nvl(per_pju_shd.g_old_rec.pju_attribute11, hr_api.g_varchar2) <>

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) <>

Line 1212: nvl(p_rec.pju_attribute11, hr_api.g_varchar2) or

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

Line 1213: nvl(per_pju_shd.g_old_rec.pju_attribute12, hr_api.g_varchar2) <>

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) <>

Line 1214: nvl(p_rec.pju_attribute12, hr_api.g_varchar2) or

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

Line 1215: nvl(per_pju_shd.g_old_rec.pju_attribute13, hr_api.g_varchar2) <>

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) <>

Line 1216: nvl(p_rec.pju_attribute13, hr_api.g_varchar2) or

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

Line 1217: nvl(per_pju_shd.g_old_rec.pju_attribute14, hr_api.g_varchar2) <>

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) <>

Line 1218: nvl(p_rec.pju_attribute14, hr_api.g_varchar2) or

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

Line 1219: nvl(per_pju_shd.g_old_rec.pju_attribute15, hr_api.g_varchar2) <>

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) <>

Line 1220: nvl(p_rec.pju_attribute15, hr_api.g_varchar2) or

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

Line 1221: nvl(per_pju_shd.g_old_rec.pju_attribute16, hr_api.g_varchar2) <>

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) <>

Line 1222: nvl(p_rec.pju_attribute16, hr_api.g_varchar2) or

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

Line 1223: nvl(per_pju_shd.g_old_rec.pju_attribute17, hr_api.g_varchar2) <>

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) <>

Line 1224: nvl(p_rec.pju_attribute17, hr_api.g_varchar2) or

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

Line 1225: nvl(per_pju_shd.g_old_rec.pju_attribute18, hr_api.g_varchar2) <>

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) <>

Line 1226: nvl(p_rec.pju_attribute18, hr_api.g_varchar2) or

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) ))

Line 1227: nvl(per_pju_shd.g_old_rec.pju_attribute19, 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

Line 1228: nvl(p_rec.pju_attribute19, hr_api.g_varchar2) or

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: --

Line 1229: nvl(per_pju_shd.g_old_rec.pju_attribute20, hr_api.g_varchar2) <>

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:

Line 1230: nvl(p_rec.pju_attribute20, 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:
1234: -- a) During update, the structure column value or any

Line 1340: hr_api.argument_changed_error

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;

Line 1348: hr_api.argument_changed_error

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;

Line 1356: hr_api.argument_changed_error

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;

Line 1492: hr_api.mandatory_arg_error

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: );