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 PER_PJU_SHD

Line 63: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: hr_utility.set_location(l_proc, 10);
62: if p_previous_employer_id is not null then
63: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
64: => p_previous_job_usage_id
65: ,p_object_version_number
66: => p_object_version_number
67: );

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 142: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

138: hr_utility.set_location('Entering:'||l_proc, 5);
139: --
140: hr_utility.set_location(l_proc, 10);
141: if p_previous_job_id is not null then
142: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
143: => p_previous_job_usage_id
144: ,p_object_version_number
145: => p_object_version_number
146: );

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 219: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

215: begin
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: hr_utility.set_location(l_proc, 10);
219: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
220: => p_previous_job_usage_id
221: ,p_object_version_number
222: => p_object_version_number
223: );

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 293: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: if p_start_date is not null and p_end_date is not null then
292: hr_utility.set_location(l_proc, 10);
293: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
294: => p_previous_job_usage_id
295: ,p_object_version_number
296: => p_object_version_number
297: );

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 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 364: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

360: hr_utility.set_location('Entering:'||l_proc, 5);
361: --
362: if p_period_years is not null then
363: hr_utility.set_location(l_proc, 10);
364: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
365: => p_previous_job_usage_id
366: ,p_object_version_number
367: => p_object_version_number);
368: hr_utility.set_location(l_proc, 15);

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 432: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

428: hr_utility.set_location('Entering:'||l_proc, 5);
429: --
430: if p_period_months is not null then
431: hr_utility.set_location(l_proc, 10);
432: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
433: => p_previous_job_usage_id
434: ,p_object_version_number
435: => p_object_version_number);
436: hr_utility.set_location(l_proc, 15);

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 500: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: if p_period_days is not null then
499: hr_utility.set_location(l_proc, 10);
500: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
501: => p_previous_job_usage_id
502: ,p_object_version_number
503: => p_object_version_number);
504: hr_utility.set_location(l_proc, 15);

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 588: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

584: hr_utility.set_location('Entering:'||l_proc, 5);
585: --
586: if p_start_date is not null or p_end_date is not null then
587: hr_utility.set_location(l_proc, 10);
588: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
589: => p_previous_job_usage_id
590: ,p_object_version_number
591: => p_object_version_number
592: );

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 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 675: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

671: l_proc varchar2(72) := g_package||'chk_assignment_job';
672: l_api_updating boolean;
673: begin
674: hr_utility.set_location('Entering:'||l_proc, 5);
675: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
676: => p_previous_job_usage_id
677: ,p_object_version_number
678: => p_object_version_number
679: );

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 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 848: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id

844: l_api_updating boolean;
845: --
846: begin
847: if p_assignment_id is not null and p_previous_job_id is not null then
848: l_api_updating := per_pju_shd.api_updating(p_previous_job_usage_id
849: => p_previous_job_usage_id
850: ,p_object_version_number
851: => p_object_version_number
852: );

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 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 1043: (p_rec in per_pju_shd.g_rec_type

1039: -- Internal Row Handler Use Only.
1040: --
1041: -- ----------------------------------------------------------------------------
1042: procedure chk_ddf
1043: (p_rec in per_pju_shd.g_rec_type
1044: ) is
1045: --
1046: l_proc varchar2(72) := g_package || 'chk_ddf';
1047: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1180: (p_rec in per_pju_shd.g_rec_type

1176: -- Internal Row Handler Use Only.
1177: --
1178: -- ----------------------------------------------------------------------------
1179: procedure chk_df
1180: (p_rec in per_pju_shd.g_rec_type
1181: ) is
1182: --
1183: l_proc varchar2(72) := g_package || 'chk_df';
1184: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1316: (p_rec in per_pju_shd.g_rec_type

1312: --
1313: -- {End Of Comments}
1314: -- ----------------------------------------------------------------------------
1315: Procedure chk_non_updateable_args
1316: (p_rec in per_pju_shd.g_rec_type
1317: ) IS
1318: --
1319: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1320: l_error EXCEPTION;

Line 1328: IF NOT per_pju_shd.api_updating

1324: --
1325: -- Only proceed with the validation if a row exists for the current
1326: -- record in the HR Schema.
1327: --
1328: IF NOT per_pju_shd.api_updating
1329: (p_previous_job_usage_id => p_rec.previous_job_usage_id
1330: ,p_object_version_number => p_rec.object_version_number
1331: ) THEN
1332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1338: if per_pju_shd.g_old_rec.previous_job_usage_id <> p_rec.previous_job_usage_id

1334: fnd_message.set_token('STEP ', '5');
1335: fnd_message.raise_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'

Line 1346: if per_pju_shd.g_old_rec.previous_employer_id <> p_rec.previous_employer_id

1342: ,p_argument => 'previous_job_usage_id'
1343: );
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'

Line 1367: (p_rec in per_pju_shd.g_rec_type

1363: -- ----------------------------------------------------------------------------
1364: -- |---------------------------< insert_validate >----------------------------|
1365: -- ----------------------------------------------------------------------------
1366: Procedure insert_validate
1367: (p_rec in per_pju_shd.g_rec_type
1368: ) is
1369: --
1370: l_proc varchar2(72) := g_package||'insert_validate';
1371: --

Line 1483: (p_rec in per_pju_shd.g_rec_type

1479: -- ----------------------------------------------------------------------------
1480: -- |---------------------------< update_validate >----------------------------|
1481: -- ----------------------------------------------------------------------------
1482: Procedure update_validate
1483: (p_rec in per_pju_shd.g_rec_type
1484: ) is
1485: --
1486: l_proc varchar2(72) := g_package||'update_validate';
1487: --

Line 1592: (p_rec in per_pju_shd.g_rec_type

1588: -- ----------------------------------------------------------------------------
1589: -- |---------------------------< delete_validate >----------------------------|
1590: -- ----------------------------------------------------------------------------
1591: Procedure delete_validate
1592: (p_rec in per_pju_shd.g_rec_type
1593: ) is
1594: --
1595: l_proc varchar2(72) := g_package||'delete_validate';
1596: --