APPS.PER_PJI_BUS dependencies on PER_PJI_SHD

Line 60: := per_pji_shd.api_updating(p_previous_job_extra_info_id

56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: hr_utility.set_location(l_proc, 10);
59: l_api_updating
60: := per_pji_shd.api_updating(p_previous_job_extra_info_id
61: => p_previous_job_extra_info_id
62: ,p_object_version_number
63: => p_object_version_number
64: );

Line 66: and nvl(per_pji_shd.g_old_rec.previous_job_id, hr_api.g_number)

62: ,p_object_version_number
63: => p_object_version_number
64: );
65: if ((l_api_updating
66: and nvl(per_pji_shd.g_old_rec.previous_job_id, hr_api.g_number)
67: <> nvl(p_previous_job_id,hr_api.g_number))
68: or
69: (not l_api_updating)) then
70: hr_utility.set_location(l_proc, 15);

Line 137: := per_pji_shd.api_updating(p_previous_job_extra_info_id

133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: hr_utility.set_location(l_proc, 10);
136: l_api_updating
137: := per_pji_shd.api_updating(p_previous_job_extra_info_id
138: => p_previous_job_extra_info_id
139: ,p_object_version_number
140: => p_object_version_number
141: );

Line 143: and nvl(per_pji_shd.g_old_rec.information_type, hr_api.g_varchar2)

139: ,p_object_version_number
140: => p_object_version_number
141: );
142: if ((l_api_updating
143: and nvl(per_pji_shd.g_old_rec.information_type, hr_api.g_varchar2)
144: <> nvl(p_information_type,hr_api.g_varchar2))
145: or
146: (not l_api_updating)) then
147: hr_utility.set_location(l_proc, 15);

Line 335: (p_rec in per_pji_shd.g_rec_type

331: -- Internal Row Handler Use Only.
332: --
333: -- ----------------------------------------------------------------------------
334: procedure chk_ddf
335: (p_rec in per_pji_shd.g_rec_type
336: ) is
337: --
338: l_proc varchar2(72) := g_package || 'chk_ddf';
339: --

Line 344: nvl(per_pji_shd.g_old_rec.information_type, hr_api.g_varchar2) <>

340: begin
341: hr_utility.set_location('Entering:'||l_proc,10);
342: --
343: if ((p_rec.previous_job_extra_info_id is not null) and (
344: nvl(per_pji_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
345: nvl(p_rec.information_type, hr_api.g_varchar2) or
346: nvl(per_pji_shd.g_old_rec.pji_information_category, hr_api.g_varchar2) <>
347: nvl(p_rec.pji_information_category, hr_api.g_varchar2) or
348: nvl(per_pji_shd.g_old_rec.pji_information1, hr_api.g_varchar2) <>

Line 346: nvl(per_pji_shd.g_old_rec.pji_information_category, hr_api.g_varchar2) <>

342: --
343: if ((p_rec.previous_job_extra_info_id is not null) and (
344: nvl(per_pji_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
345: nvl(p_rec.information_type, hr_api.g_varchar2) or
346: nvl(per_pji_shd.g_old_rec.pji_information_category, hr_api.g_varchar2) <>
347: nvl(p_rec.pji_information_category, hr_api.g_varchar2) or
348: nvl(per_pji_shd.g_old_rec.pji_information1, hr_api.g_varchar2) <>
349: nvl(p_rec.pji_information1, hr_api.g_varchar2) or
350: nvl(per_pji_shd.g_old_rec.pji_information2, hr_api.g_varchar2) <>

Line 348: nvl(per_pji_shd.g_old_rec.pji_information1, hr_api.g_varchar2) <>

344: nvl(per_pji_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
345: nvl(p_rec.information_type, hr_api.g_varchar2) or
346: nvl(per_pji_shd.g_old_rec.pji_information_category, hr_api.g_varchar2) <>
347: nvl(p_rec.pji_information_category, hr_api.g_varchar2) or
348: nvl(per_pji_shd.g_old_rec.pji_information1, hr_api.g_varchar2) <>
349: nvl(p_rec.pji_information1, hr_api.g_varchar2) or
350: nvl(per_pji_shd.g_old_rec.pji_information2, hr_api.g_varchar2) <>
351: nvl(p_rec.pji_information2, hr_api.g_varchar2) or
352: nvl(per_pji_shd.g_old_rec.pji_information3, hr_api.g_varchar2) <>

Line 350: nvl(per_pji_shd.g_old_rec.pji_information2, hr_api.g_varchar2) <>

346: nvl(per_pji_shd.g_old_rec.pji_information_category, hr_api.g_varchar2) <>
347: nvl(p_rec.pji_information_category, hr_api.g_varchar2) or
348: nvl(per_pji_shd.g_old_rec.pji_information1, hr_api.g_varchar2) <>
349: nvl(p_rec.pji_information1, hr_api.g_varchar2) or
350: nvl(per_pji_shd.g_old_rec.pji_information2, hr_api.g_varchar2) <>
351: nvl(p_rec.pji_information2, hr_api.g_varchar2) or
352: nvl(per_pji_shd.g_old_rec.pji_information3, hr_api.g_varchar2) <>
353: nvl(p_rec.pji_information3, hr_api.g_varchar2) or
354: nvl(per_pji_shd.g_old_rec.pji_information4, hr_api.g_varchar2) <>

Line 352: nvl(per_pji_shd.g_old_rec.pji_information3, hr_api.g_varchar2) <>

348: nvl(per_pji_shd.g_old_rec.pji_information1, hr_api.g_varchar2) <>
349: nvl(p_rec.pji_information1, hr_api.g_varchar2) or
350: nvl(per_pji_shd.g_old_rec.pji_information2, hr_api.g_varchar2) <>
351: nvl(p_rec.pji_information2, hr_api.g_varchar2) or
352: nvl(per_pji_shd.g_old_rec.pji_information3, hr_api.g_varchar2) <>
353: nvl(p_rec.pji_information3, hr_api.g_varchar2) or
354: nvl(per_pji_shd.g_old_rec.pji_information4, hr_api.g_varchar2) <>
355: nvl(p_rec.pji_information4, hr_api.g_varchar2) or
356: nvl(per_pji_shd.g_old_rec.pji_information5, hr_api.g_varchar2) <>

Line 354: nvl(per_pji_shd.g_old_rec.pji_information4, hr_api.g_varchar2) <>

350: nvl(per_pji_shd.g_old_rec.pji_information2, hr_api.g_varchar2) <>
351: nvl(p_rec.pji_information2, hr_api.g_varchar2) or
352: nvl(per_pji_shd.g_old_rec.pji_information3, hr_api.g_varchar2) <>
353: nvl(p_rec.pji_information3, hr_api.g_varchar2) or
354: nvl(per_pji_shd.g_old_rec.pji_information4, hr_api.g_varchar2) <>
355: nvl(p_rec.pji_information4, hr_api.g_varchar2) or
356: nvl(per_pji_shd.g_old_rec.pji_information5, hr_api.g_varchar2) <>
357: nvl(p_rec.pji_information5, hr_api.g_varchar2) or
358: nvl(per_pji_shd.g_old_rec.pji_information6, hr_api.g_varchar2) <>

Line 356: nvl(per_pji_shd.g_old_rec.pji_information5, hr_api.g_varchar2) <>

352: nvl(per_pji_shd.g_old_rec.pji_information3, hr_api.g_varchar2) <>
353: nvl(p_rec.pji_information3, hr_api.g_varchar2) or
354: nvl(per_pji_shd.g_old_rec.pji_information4, hr_api.g_varchar2) <>
355: nvl(p_rec.pji_information4, hr_api.g_varchar2) or
356: nvl(per_pji_shd.g_old_rec.pji_information5, hr_api.g_varchar2) <>
357: nvl(p_rec.pji_information5, hr_api.g_varchar2) or
358: nvl(per_pji_shd.g_old_rec.pji_information6, hr_api.g_varchar2) <>
359: nvl(p_rec.pji_information6, hr_api.g_varchar2) or
360: nvl(per_pji_shd.g_old_rec.pji_information7, hr_api.g_varchar2) <>

Line 358: nvl(per_pji_shd.g_old_rec.pji_information6, hr_api.g_varchar2) <>

354: nvl(per_pji_shd.g_old_rec.pji_information4, hr_api.g_varchar2) <>
355: nvl(p_rec.pji_information4, hr_api.g_varchar2) or
356: nvl(per_pji_shd.g_old_rec.pji_information5, hr_api.g_varchar2) <>
357: nvl(p_rec.pji_information5, hr_api.g_varchar2) or
358: nvl(per_pji_shd.g_old_rec.pji_information6, hr_api.g_varchar2) <>
359: nvl(p_rec.pji_information6, hr_api.g_varchar2) or
360: nvl(per_pji_shd.g_old_rec.pji_information7, hr_api.g_varchar2) <>
361: nvl(p_rec.pji_information7, hr_api.g_varchar2) or
362: nvl(per_pji_shd.g_old_rec.pji_information8, hr_api.g_varchar2) <>

Line 360: nvl(per_pji_shd.g_old_rec.pji_information7, hr_api.g_varchar2) <>

356: nvl(per_pji_shd.g_old_rec.pji_information5, hr_api.g_varchar2) <>
357: nvl(p_rec.pji_information5, hr_api.g_varchar2) or
358: nvl(per_pji_shd.g_old_rec.pji_information6, hr_api.g_varchar2) <>
359: nvl(p_rec.pji_information6, hr_api.g_varchar2) or
360: nvl(per_pji_shd.g_old_rec.pji_information7, hr_api.g_varchar2) <>
361: nvl(p_rec.pji_information7, hr_api.g_varchar2) or
362: nvl(per_pji_shd.g_old_rec.pji_information8, hr_api.g_varchar2) <>
363: nvl(p_rec.pji_information8, hr_api.g_varchar2) or
364: nvl(per_pji_shd.g_old_rec.pji_information9, hr_api.g_varchar2) <>

Line 362: nvl(per_pji_shd.g_old_rec.pji_information8, hr_api.g_varchar2) <>

358: nvl(per_pji_shd.g_old_rec.pji_information6, hr_api.g_varchar2) <>
359: nvl(p_rec.pji_information6, hr_api.g_varchar2) or
360: nvl(per_pji_shd.g_old_rec.pji_information7, hr_api.g_varchar2) <>
361: nvl(p_rec.pji_information7, hr_api.g_varchar2) or
362: nvl(per_pji_shd.g_old_rec.pji_information8, hr_api.g_varchar2) <>
363: nvl(p_rec.pji_information8, hr_api.g_varchar2) or
364: nvl(per_pji_shd.g_old_rec.pji_information9, hr_api.g_varchar2) <>
365: nvl(p_rec.pji_information9, hr_api.g_varchar2) or
366: nvl(per_pji_shd.g_old_rec.pji_information10, hr_api.g_varchar2) <>

Line 364: nvl(per_pji_shd.g_old_rec.pji_information9, hr_api.g_varchar2) <>

360: nvl(per_pji_shd.g_old_rec.pji_information7, hr_api.g_varchar2) <>
361: nvl(p_rec.pji_information7, hr_api.g_varchar2) or
362: nvl(per_pji_shd.g_old_rec.pji_information8, hr_api.g_varchar2) <>
363: nvl(p_rec.pji_information8, hr_api.g_varchar2) or
364: nvl(per_pji_shd.g_old_rec.pji_information9, hr_api.g_varchar2) <>
365: nvl(p_rec.pji_information9, hr_api.g_varchar2) or
366: nvl(per_pji_shd.g_old_rec.pji_information10, hr_api.g_varchar2) <>
367: nvl(p_rec.pji_information10, hr_api.g_varchar2) or
368: nvl(per_pji_shd.g_old_rec.pji_information11, hr_api.g_varchar2) <>

Line 366: nvl(per_pji_shd.g_old_rec.pji_information10, hr_api.g_varchar2) <>

362: nvl(per_pji_shd.g_old_rec.pji_information8, hr_api.g_varchar2) <>
363: nvl(p_rec.pji_information8, hr_api.g_varchar2) or
364: nvl(per_pji_shd.g_old_rec.pji_information9, hr_api.g_varchar2) <>
365: nvl(p_rec.pji_information9, hr_api.g_varchar2) or
366: nvl(per_pji_shd.g_old_rec.pji_information10, hr_api.g_varchar2) <>
367: nvl(p_rec.pji_information10, hr_api.g_varchar2) or
368: nvl(per_pji_shd.g_old_rec.pji_information11, hr_api.g_varchar2) <>
369: nvl(p_rec.pji_information11, hr_api.g_varchar2) or
370: nvl(per_pji_shd.g_old_rec.pji_information12, hr_api.g_varchar2) <>

Line 368: nvl(per_pji_shd.g_old_rec.pji_information11, hr_api.g_varchar2) <>

364: nvl(per_pji_shd.g_old_rec.pji_information9, hr_api.g_varchar2) <>
365: nvl(p_rec.pji_information9, hr_api.g_varchar2) or
366: nvl(per_pji_shd.g_old_rec.pji_information10, hr_api.g_varchar2) <>
367: nvl(p_rec.pji_information10, hr_api.g_varchar2) or
368: nvl(per_pji_shd.g_old_rec.pji_information11, hr_api.g_varchar2) <>
369: nvl(p_rec.pji_information11, hr_api.g_varchar2) or
370: nvl(per_pji_shd.g_old_rec.pji_information12, hr_api.g_varchar2) <>
371: nvl(p_rec.pji_information12, hr_api.g_varchar2) or
372: nvl(per_pji_shd.g_old_rec.pji_information13, hr_api.g_varchar2) <>

Line 370: nvl(per_pji_shd.g_old_rec.pji_information12, hr_api.g_varchar2) <>

366: nvl(per_pji_shd.g_old_rec.pji_information10, hr_api.g_varchar2) <>
367: nvl(p_rec.pji_information10, hr_api.g_varchar2) or
368: nvl(per_pji_shd.g_old_rec.pji_information11, hr_api.g_varchar2) <>
369: nvl(p_rec.pji_information11, hr_api.g_varchar2) or
370: nvl(per_pji_shd.g_old_rec.pji_information12, hr_api.g_varchar2) <>
371: nvl(p_rec.pji_information12, hr_api.g_varchar2) or
372: nvl(per_pji_shd.g_old_rec.pji_information13, hr_api.g_varchar2) <>
373: nvl(p_rec.pji_information13, hr_api.g_varchar2) or
374: nvl(per_pji_shd.g_old_rec.pji_information14, hr_api.g_varchar2) <>

Line 372: nvl(per_pji_shd.g_old_rec.pji_information13, hr_api.g_varchar2) <>

368: nvl(per_pji_shd.g_old_rec.pji_information11, hr_api.g_varchar2) <>
369: nvl(p_rec.pji_information11, hr_api.g_varchar2) or
370: nvl(per_pji_shd.g_old_rec.pji_information12, hr_api.g_varchar2) <>
371: nvl(p_rec.pji_information12, hr_api.g_varchar2) or
372: nvl(per_pji_shd.g_old_rec.pji_information13, hr_api.g_varchar2) <>
373: nvl(p_rec.pji_information13, hr_api.g_varchar2) or
374: nvl(per_pji_shd.g_old_rec.pji_information14, hr_api.g_varchar2) <>
375: nvl(p_rec.pji_information14, hr_api.g_varchar2) or
376: nvl(per_pji_shd.g_old_rec.pji_information15, hr_api.g_varchar2) <>

Line 374: nvl(per_pji_shd.g_old_rec.pji_information14, hr_api.g_varchar2) <>

370: nvl(per_pji_shd.g_old_rec.pji_information12, hr_api.g_varchar2) <>
371: nvl(p_rec.pji_information12, hr_api.g_varchar2) or
372: nvl(per_pji_shd.g_old_rec.pji_information13, hr_api.g_varchar2) <>
373: nvl(p_rec.pji_information13, hr_api.g_varchar2) or
374: nvl(per_pji_shd.g_old_rec.pji_information14, hr_api.g_varchar2) <>
375: nvl(p_rec.pji_information14, hr_api.g_varchar2) or
376: nvl(per_pji_shd.g_old_rec.pji_information15, hr_api.g_varchar2) <>
377: nvl(p_rec.pji_information15, hr_api.g_varchar2) or
378: nvl(per_pji_shd.g_old_rec.pji_information16, hr_api.g_varchar2) <>

Line 376: nvl(per_pji_shd.g_old_rec.pji_information15, hr_api.g_varchar2) <>

372: nvl(per_pji_shd.g_old_rec.pji_information13, hr_api.g_varchar2) <>
373: nvl(p_rec.pji_information13, hr_api.g_varchar2) or
374: nvl(per_pji_shd.g_old_rec.pji_information14, hr_api.g_varchar2) <>
375: nvl(p_rec.pji_information14, hr_api.g_varchar2) or
376: nvl(per_pji_shd.g_old_rec.pji_information15, hr_api.g_varchar2) <>
377: nvl(p_rec.pji_information15, hr_api.g_varchar2) or
378: nvl(per_pji_shd.g_old_rec.pji_information16, hr_api.g_varchar2) <>
379: nvl(p_rec.pji_information16, hr_api.g_varchar2) or
380: nvl(per_pji_shd.g_old_rec.pji_information17, hr_api.g_varchar2) <>

Line 378: nvl(per_pji_shd.g_old_rec.pji_information16, hr_api.g_varchar2) <>

374: nvl(per_pji_shd.g_old_rec.pji_information14, hr_api.g_varchar2) <>
375: nvl(p_rec.pji_information14, hr_api.g_varchar2) or
376: nvl(per_pji_shd.g_old_rec.pji_information15, hr_api.g_varchar2) <>
377: nvl(p_rec.pji_information15, hr_api.g_varchar2) or
378: nvl(per_pji_shd.g_old_rec.pji_information16, hr_api.g_varchar2) <>
379: nvl(p_rec.pji_information16, hr_api.g_varchar2) or
380: nvl(per_pji_shd.g_old_rec.pji_information17, hr_api.g_varchar2) <>
381: nvl(p_rec.pji_information17, hr_api.g_varchar2) or
382: nvl(per_pji_shd.g_old_rec.pji_information18, hr_api.g_varchar2) <>

Line 380: nvl(per_pji_shd.g_old_rec.pji_information17, hr_api.g_varchar2) <>

376: nvl(per_pji_shd.g_old_rec.pji_information15, hr_api.g_varchar2) <>
377: nvl(p_rec.pji_information15, hr_api.g_varchar2) or
378: nvl(per_pji_shd.g_old_rec.pji_information16, hr_api.g_varchar2) <>
379: nvl(p_rec.pji_information16, hr_api.g_varchar2) or
380: nvl(per_pji_shd.g_old_rec.pji_information17, hr_api.g_varchar2) <>
381: nvl(p_rec.pji_information17, hr_api.g_varchar2) or
382: nvl(per_pji_shd.g_old_rec.pji_information18, hr_api.g_varchar2) <>
383: nvl(p_rec.pji_information18, hr_api.g_varchar2) or
384: nvl(per_pji_shd.g_old_rec.pji_information19, hr_api.g_varchar2) <>

Line 382: nvl(per_pji_shd.g_old_rec.pji_information18, hr_api.g_varchar2) <>

378: nvl(per_pji_shd.g_old_rec.pji_information16, hr_api.g_varchar2) <>
379: nvl(p_rec.pji_information16, hr_api.g_varchar2) or
380: nvl(per_pji_shd.g_old_rec.pji_information17, hr_api.g_varchar2) <>
381: nvl(p_rec.pji_information17, hr_api.g_varchar2) or
382: nvl(per_pji_shd.g_old_rec.pji_information18, hr_api.g_varchar2) <>
383: nvl(p_rec.pji_information18, hr_api.g_varchar2) or
384: nvl(per_pji_shd.g_old_rec.pji_information19, hr_api.g_varchar2) <>
385: nvl(p_rec.pji_information19, hr_api.g_varchar2) or
386: nvl(per_pji_shd.g_old_rec.pji_information20, hr_api.g_varchar2) <>

Line 384: nvl(per_pji_shd.g_old_rec.pji_information19, hr_api.g_varchar2) <>

380: nvl(per_pji_shd.g_old_rec.pji_information17, hr_api.g_varchar2) <>
381: nvl(p_rec.pji_information17, hr_api.g_varchar2) or
382: nvl(per_pji_shd.g_old_rec.pji_information18, hr_api.g_varchar2) <>
383: nvl(p_rec.pji_information18, hr_api.g_varchar2) or
384: nvl(per_pji_shd.g_old_rec.pji_information19, hr_api.g_varchar2) <>
385: nvl(p_rec.pji_information19, hr_api.g_varchar2) or
386: nvl(per_pji_shd.g_old_rec.pji_information20, hr_api.g_varchar2) <>
387: nvl(p_rec.pji_information20, hr_api.g_varchar2) or
388: nvl(per_pji_shd.g_old_rec.pji_information21, hr_api.g_varchar2) <>

Line 386: nvl(per_pji_shd.g_old_rec.pji_information20, hr_api.g_varchar2) <>

382: nvl(per_pji_shd.g_old_rec.pji_information18, hr_api.g_varchar2) <>
383: nvl(p_rec.pji_information18, hr_api.g_varchar2) or
384: nvl(per_pji_shd.g_old_rec.pji_information19, hr_api.g_varchar2) <>
385: nvl(p_rec.pji_information19, hr_api.g_varchar2) or
386: nvl(per_pji_shd.g_old_rec.pji_information20, hr_api.g_varchar2) <>
387: nvl(p_rec.pji_information20, hr_api.g_varchar2) or
388: nvl(per_pji_shd.g_old_rec.pji_information21, hr_api.g_varchar2) <>
389: nvl(p_rec.pji_information21, hr_api.g_varchar2) or
390: nvl(per_pji_shd.g_old_rec.pji_information22, hr_api.g_varchar2) <>

Line 388: nvl(per_pji_shd.g_old_rec.pji_information21, hr_api.g_varchar2) <>

384: nvl(per_pji_shd.g_old_rec.pji_information19, hr_api.g_varchar2) <>
385: nvl(p_rec.pji_information19, hr_api.g_varchar2) or
386: nvl(per_pji_shd.g_old_rec.pji_information20, hr_api.g_varchar2) <>
387: nvl(p_rec.pji_information20, hr_api.g_varchar2) or
388: nvl(per_pji_shd.g_old_rec.pji_information21, hr_api.g_varchar2) <>
389: nvl(p_rec.pji_information21, hr_api.g_varchar2) or
390: nvl(per_pji_shd.g_old_rec.pji_information22, hr_api.g_varchar2) <>
391: nvl(p_rec.pji_information22, hr_api.g_varchar2) or
392: nvl(per_pji_shd.g_old_rec.pji_information23, hr_api.g_varchar2) <>

Line 390: nvl(per_pji_shd.g_old_rec.pji_information22, hr_api.g_varchar2) <>

386: nvl(per_pji_shd.g_old_rec.pji_information20, hr_api.g_varchar2) <>
387: nvl(p_rec.pji_information20, hr_api.g_varchar2) or
388: nvl(per_pji_shd.g_old_rec.pji_information21, hr_api.g_varchar2) <>
389: nvl(p_rec.pji_information21, hr_api.g_varchar2) or
390: nvl(per_pji_shd.g_old_rec.pji_information22, hr_api.g_varchar2) <>
391: nvl(p_rec.pji_information22, hr_api.g_varchar2) or
392: nvl(per_pji_shd.g_old_rec.pji_information23, hr_api.g_varchar2) <>
393: nvl(p_rec.pji_information23, hr_api.g_varchar2) or
394: nvl(per_pji_shd.g_old_rec.pji_information24, hr_api.g_varchar2) <>

Line 392: nvl(per_pji_shd.g_old_rec.pji_information23, hr_api.g_varchar2) <>

388: nvl(per_pji_shd.g_old_rec.pji_information21, hr_api.g_varchar2) <>
389: nvl(p_rec.pji_information21, hr_api.g_varchar2) or
390: nvl(per_pji_shd.g_old_rec.pji_information22, hr_api.g_varchar2) <>
391: nvl(p_rec.pji_information22, hr_api.g_varchar2) or
392: nvl(per_pji_shd.g_old_rec.pji_information23, hr_api.g_varchar2) <>
393: nvl(p_rec.pji_information23, hr_api.g_varchar2) or
394: nvl(per_pji_shd.g_old_rec.pji_information24, hr_api.g_varchar2) <>
395: nvl(p_rec.pji_information24, hr_api.g_varchar2) or
396: nvl(per_pji_shd.g_old_rec.pji_information25, hr_api.g_varchar2) <>

Line 394: nvl(per_pji_shd.g_old_rec.pji_information24, hr_api.g_varchar2) <>

390: nvl(per_pji_shd.g_old_rec.pji_information22, hr_api.g_varchar2) <>
391: nvl(p_rec.pji_information22, hr_api.g_varchar2) or
392: nvl(per_pji_shd.g_old_rec.pji_information23, hr_api.g_varchar2) <>
393: nvl(p_rec.pji_information23, hr_api.g_varchar2) or
394: nvl(per_pji_shd.g_old_rec.pji_information24, hr_api.g_varchar2) <>
395: nvl(p_rec.pji_information24, hr_api.g_varchar2) or
396: nvl(per_pji_shd.g_old_rec.pji_information25, hr_api.g_varchar2) <>
397: nvl(p_rec.pji_information25, hr_api.g_varchar2) or
398: nvl(per_pji_shd.g_old_rec.pji_information26, hr_api.g_varchar2) <>

Line 396: nvl(per_pji_shd.g_old_rec.pji_information25, hr_api.g_varchar2) <>

392: nvl(per_pji_shd.g_old_rec.pji_information23, hr_api.g_varchar2) <>
393: nvl(p_rec.pji_information23, hr_api.g_varchar2) or
394: nvl(per_pji_shd.g_old_rec.pji_information24, hr_api.g_varchar2) <>
395: nvl(p_rec.pji_information24, hr_api.g_varchar2) or
396: nvl(per_pji_shd.g_old_rec.pji_information25, hr_api.g_varchar2) <>
397: nvl(p_rec.pji_information25, hr_api.g_varchar2) or
398: nvl(per_pji_shd.g_old_rec.pji_information26, hr_api.g_varchar2) <>
399: nvl(p_rec.pji_information26, hr_api.g_varchar2) or
400: nvl(per_pji_shd.g_old_rec.pji_information27, hr_api.g_varchar2) <>

Line 398: nvl(per_pji_shd.g_old_rec.pji_information26, hr_api.g_varchar2) <>

394: nvl(per_pji_shd.g_old_rec.pji_information24, hr_api.g_varchar2) <>
395: nvl(p_rec.pji_information24, hr_api.g_varchar2) or
396: nvl(per_pji_shd.g_old_rec.pji_information25, hr_api.g_varchar2) <>
397: nvl(p_rec.pji_information25, hr_api.g_varchar2) or
398: nvl(per_pji_shd.g_old_rec.pji_information26, hr_api.g_varchar2) <>
399: nvl(p_rec.pji_information26, hr_api.g_varchar2) or
400: nvl(per_pji_shd.g_old_rec.pji_information27, hr_api.g_varchar2) <>
401: nvl(p_rec.pji_information27, hr_api.g_varchar2) or
402: nvl(per_pji_shd.g_old_rec.pji_information28, hr_api.g_varchar2) <>

Line 400: nvl(per_pji_shd.g_old_rec.pji_information27, hr_api.g_varchar2) <>

396: nvl(per_pji_shd.g_old_rec.pji_information25, hr_api.g_varchar2) <>
397: nvl(p_rec.pji_information25, hr_api.g_varchar2) or
398: nvl(per_pji_shd.g_old_rec.pji_information26, hr_api.g_varchar2) <>
399: nvl(p_rec.pji_information26, hr_api.g_varchar2) or
400: nvl(per_pji_shd.g_old_rec.pji_information27, hr_api.g_varchar2) <>
401: nvl(p_rec.pji_information27, hr_api.g_varchar2) or
402: nvl(per_pji_shd.g_old_rec.pji_information28, hr_api.g_varchar2) <>
403: nvl(p_rec.pji_information28, hr_api.g_varchar2) or
404: nvl(per_pji_shd.g_old_rec.pji_information29, hr_api.g_varchar2) <>

Line 402: nvl(per_pji_shd.g_old_rec.pji_information28, hr_api.g_varchar2) <>

398: nvl(per_pji_shd.g_old_rec.pji_information26, hr_api.g_varchar2) <>
399: nvl(p_rec.pji_information26, hr_api.g_varchar2) or
400: nvl(per_pji_shd.g_old_rec.pji_information27, hr_api.g_varchar2) <>
401: nvl(p_rec.pji_information27, hr_api.g_varchar2) or
402: nvl(per_pji_shd.g_old_rec.pji_information28, hr_api.g_varchar2) <>
403: nvl(p_rec.pji_information28, hr_api.g_varchar2) or
404: nvl(per_pji_shd.g_old_rec.pji_information29, hr_api.g_varchar2) <>
405: nvl(p_rec.pji_information29, hr_api.g_varchar2) or
406: nvl(per_pji_shd.g_old_rec.pji_information30, hr_api.g_varchar2) <>

Line 404: nvl(per_pji_shd.g_old_rec.pji_information29, hr_api.g_varchar2) <>

400: nvl(per_pji_shd.g_old_rec.pji_information27, hr_api.g_varchar2) <>
401: nvl(p_rec.pji_information27, hr_api.g_varchar2) or
402: nvl(per_pji_shd.g_old_rec.pji_information28, hr_api.g_varchar2) <>
403: nvl(p_rec.pji_information28, hr_api.g_varchar2) or
404: nvl(per_pji_shd.g_old_rec.pji_information29, hr_api.g_varchar2) <>
405: nvl(p_rec.pji_information29, hr_api.g_varchar2) or
406: nvl(per_pji_shd.g_old_rec.pji_information30, hr_api.g_varchar2) <>
407: nvl(p_rec.pji_information30, hr_api.g_varchar2) ))
408: or (p_rec.previous_job_extra_info_id is null) then

Line 406: nvl(per_pji_shd.g_old_rec.pji_information30, hr_api.g_varchar2) <>

402: nvl(per_pji_shd.g_old_rec.pji_information28, hr_api.g_varchar2) <>
403: nvl(p_rec.pji_information28, hr_api.g_varchar2) or
404: nvl(per_pji_shd.g_old_rec.pji_information29, hr_api.g_varchar2) <>
405: nvl(p_rec.pji_information29, hr_api.g_varchar2) or
406: nvl(per_pji_shd.g_old_rec.pji_information30, hr_api.g_varchar2) <>
407: nvl(p_rec.pji_information30, hr_api.g_varchar2) ))
408: or (p_rec.previous_job_extra_info_id is null) then
409: --
410: -- Only execute the validation if absolutely necessary:

Line 514: (p_rec in per_pji_shd.g_rec_type

510: -- Internal Row Handler Use Only.
511: --
512: -- ----------------------------------------------------------------------------
513: procedure chk_df
514: (p_rec in per_pji_shd.g_rec_type
515: ) is
516: --
517: l_proc varchar2(72) := g_package || 'chk_df';
518: --

Line 523: nvl(per_pji_shd.g_old_rec.pji_attribute_category, hr_api.g_varchar2) <>

519: begin
520: hr_utility.set_location('Entering:'||l_proc,10);
521: --
522: if ((p_rec.previous_job_extra_info_id is not null) and (
523: nvl(per_pji_shd.g_old_rec.pji_attribute_category, hr_api.g_varchar2) <>
524: nvl(p_rec.pji_attribute_category, hr_api.g_varchar2) or
525: nvl(per_pji_shd.g_old_rec.pji_attribute1, hr_api.g_varchar2) <>
526: nvl(p_rec.pji_attribute1, hr_api.g_varchar2) or
527: nvl(per_pji_shd.g_old_rec.pji_attribute2, hr_api.g_varchar2) <>

Line 525: nvl(per_pji_shd.g_old_rec.pji_attribute1, hr_api.g_varchar2) <>

521: --
522: if ((p_rec.previous_job_extra_info_id is not null) and (
523: nvl(per_pji_shd.g_old_rec.pji_attribute_category, hr_api.g_varchar2) <>
524: nvl(p_rec.pji_attribute_category, hr_api.g_varchar2) or
525: nvl(per_pji_shd.g_old_rec.pji_attribute1, hr_api.g_varchar2) <>
526: nvl(p_rec.pji_attribute1, hr_api.g_varchar2) or
527: nvl(per_pji_shd.g_old_rec.pji_attribute2, hr_api.g_varchar2) <>
528: nvl(p_rec.pji_attribute2, hr_api.g_varchar2) or
529: nvl(per_pji_shd.g_old_rec.pji_attribute3, hr_api.g_varchar2) <>

Line 527: nvl(per_pji_shd.g_old_rec.pji_attribute2, hr_api.g_varchar2) <>

523: nvl(per_pji_shd.g_old_rec.pji_attribute_category, hr_api.g_varchar2) <>
524: nvl(p_rec.pji_attribute_category, hr_api.g_varchar2) or
525: nvl(per_pji_shd.g_old_rec.pji_attribute1, hr_api.g_varchar2) <>
526: nvl(p_rec.pji_attribute1, hr_api.g_varchar2) or
527: nvl(per_pji_shd.g_old_rec.pji_attribute2, hr_api.g_varchar2) <>
528: nvl(p_rec.pji_attribute2, hr_api.g_varchar2) or
529: nvl(per_pji_shd.g_old_rec.pji_attribute3, hr_api.g_varchar2) <>
530: nvl(p_rec.pji_attribute3, hr_api.g_varchar2) or
531: nvl(per_pji_shd.g_old_rec.pji_attribute4, hr_api.g_varchar2) <>

Line 529: nvl(per_pji_shd.g_old_rec.pji_attribute3, hr_api.g_varchar2) <>

525: nvl(per_pji_shd.g_old_rec.pji_attribute1, hr_api.g_varchar2) <>
526: nvl(p_rec.pji_attribute1, hr_api.g_varchar2) or
527: nvl(per_pji_shd.g_old_rec.pji_attribute2, hr_api.g_varchar2) <>
528: nvl(p_rec.pji_attribute2, hr_api.g_varchar2) or
529: nvl(per_pji_shd.g_old_rec.pji_attribute3, hr_api.g_varchar2) <>
530: nvl(p_rec.pji_attribute3, hr_api.g_varchar2) or
531: nvl(per_pji_shd.g_old_rec.pji_attribute4, hr_api.g_varchar2) <>
532: nvl(p_rec.pji_attribute4, hr_api.g_varchar2) or
533: nvl(per_pji_shd.g_old_rec.pji_attribute5, hr_api.g_varchar2) <>

Line 531: nvl(per_pji_shd.g_old_rec.pji_attribute4, hr_api.g_varchar2) <>

527: nvl(per_pji_shd.g_old_rec.pji_attribute2, hr_api.g_varchar2) <>
528: nvl(p_rec.pji_attribute2, hr_api.g_varchar2) or
529: nvl(per_pji_shd.g_old_rec.pji_attribute3, hr_api.g_varchar2) <>
530: nvl(p_rec.pji_attribute3, hr_api.g_varchar2) or
531: nvl(per_pji_shd.g_old_rec.pji_attribute4, hr_api.g_varchar2) <>
532: nvl(p_rec.pji_attribute4, hr_api.g_varchar2) or
533: nvl(per_pji_shd.g_old_rec.pji_attribute5, hr_api.g_varchar2) <>
534: nvl(p_rec.pji_attribute5, hr_api.g_varchar2) or
535: nvl(per_pji_shd.g_old_rec.pji_attribute6, hr_api.g_varchar2) <>

Line 533: nvl(per_pji_shd.g_old_rec.pji_attribute5, hr_api.g_varchar2) <>

529: nvl(per_pji_shd.g_old_rec.pji_attribute3, hr_api.g_varchar2) <>
530: nvl(p_rec.pji_attribute3, hr_api.g_varchar2) or
531: nvl(per_pji_shd.g_old_rec.pji_attribute4, hr_api.g_varchar2) <>
532: nvl(p_rec.pji_attribute4, hr_api.g_varchar2) or
533: nvl(per_pji_shd.g_old_rec.pji_attribute5, hr_api.g_varchar2) <>
534: nvl(p_rec.pji_attribute5, hr_api.g_varchar2) or
535: nvl(per_pji_shd.g_old_rec.pji_attribute6, hr_api.g_varchar2) <>
536: nvl(p_rec.pji_attribute6, hr_api.g_varchar2) or
537: nvl(per_pji_shd.g_old_rec.pji_attribute7, hr_api.g_varchar2) <>

Line 535: nvl(per_pji_shd.g_old_rec.pji_attribute6, hr_api.g_varchar2) <>

531: nvl(per_pji_shd.g_old_rec.pji_attribute4, hr_api.g_varchar2) <>
532: nvl(p_rec.pji_attribute4, hr_api.g_varchar2) or
533: nvl(per_pji_shd.g_old_rec.pji_attribute5, hr_api.g_varchar2) <>
534: nvl(p_rec.pji_attribute5, hr_api.g_varchar2) or
535: nvl(per_pji_shd.g_old_rec.pji_attribute6, hr_api.g_varchar2) <>
536: nvl(p_rec.pji_attribute6, hr_api.g_varchar2) or
537: nvl(per_pji_shd.g_old_rec.pji_attribute7, hr_api.g_varchar2) <>
538: nvl(p_rec.pji_attribute7, hr_api.g_varchar2) or
539: nvl(per_pji_shd.g_old_rec.pji_attribute8, hr_api.g_varchar2) <>

Line 537: nvl(per_pji_shd.g_old_rec.pji_attribute7, hr_api.g_varchar2) <>

533: nvl(per_pji_shd.g_old_rec.pji_attribute5, hr_api.g_varchar2) <>
534: nvl(p_rec.pji_attribute5, hr_api.g_varchar2) or
535: nvl(per_pji_shd.g_old_rec.pji_attribute6, hr_api.g_varchar2) <>
536: nvl(p_rec.pji_attribute6, hr_api.g_varchar2) or
537: nvl(per_pji_shd.g_old_rec.pji_attribute7, hr_api.g_varchar2) <>
538: nvl(p_rec.pji_attribute7, hr_api.g_varchar2) or
539: nvl(per_pji_shd.g_old_rec.pji_attribute8, hr_api.g_varchar2) <>
540: nvl(p_rec.pji_attribute8, hr_api.g_varchar2) or
541: nvl(per_pji_shd.g_old_rec.pji_attribute9, hr_api.g_varchar2) <>

Line 539: nvl(per_pji_shd.g_old_rec.pji_attribute8, hr_api.g_varchar2) <>

535: nvl(per_pji_shd.g_old_rec.pji_attribute6, hr_api.g_varchar2) <>
536: nvl(p_rec.pji_attribute6, hr_api.g_varchar2) or
537: nvl(per_pji_shd.g_old_rec.pji_attribute7, hr_api.g_varchar2) <>
538: nvl(p_rec.pji_attribute7, hr_api.g_varchar2) or
539: nvl(per_pji_shd.g_old_rec.pji_attribute8, hr_api.g_varchar2) <>
540: nvl(p_rec.pji_attribute8, hr_api.g_varchar2) or
541: nvl(per_pji_shd.g_old_rec.pji_attribute9, hr_api.g_varchar2) <>
542: nvl(p_rec.pji_attribute9, hr_api.g_varchar2) or
543: nvl(per_pji_shd.g_old_rec.pji_attribute10, hr_api.g_varchar2) <>

Line 541: nvl(per_pji_shd.g_old_rec.pji_attribute9, hr_api.g_varchar2) <>

537: nvl(per_pji_shd.g_old_rec.pji_attribute7, hr_api.g_varchar2) <>
538: nvl(p_rec.pji_attribute7, hr_api.g_varchar2) or
539: nvl(per_pji_shd.g_old_rec.pji_attribute8, hr_api.g_varchar2) <>
540: nvl(p_rec.pji_attribute8, hr_api.g_varchar2) or
541: nvl(per_pji_shd.g_old_rec.pji_attribute9, hr_api.g_varchar2) <>
542: nvl(p_rec.pji_attribute9, hr_api.g_varchar2) or
543: nvl(per_pji_shd.g_old_rec.pji_attribute10, hr_api.g_varchar2) <>
544: nvl(p_rec.pji_attribute10, hr_api.g_varchar2) or
545: nvl(per_pji_shd.g_old_rec.pji_attribute11, hr_api.g_varchar2) <>

Line 543: nvl(per_pji_shd.g_old_rec.pji_attribute10, hr_api.g_varchar2) <>

539: nvl(per_pji_shd.g_old_rec.pji_attribute8, hr_api.g_varchar2) <>
540: nvl(p_rec.pji_attribute8, hr_api.g_varchar2) or
541: nvl(per_pji_shd.g_old_rec.pji_attribute9, hr_api.g_varchar2) <>
542: nvl(p_rec.pji_attribute9, hr_api.g_varchar2) or
543: nvl(per_pji_shd.g_old_rec.pji_attribute10, hr_api.g_varchar2) <>
544: nvl(p_rec.pji_attribute10, hr_api.g_varchar2) or
545: nvl(per_pji_shd.g_old_rec.pji_attribute11, hr_api.g_varchar2) <>
546: nvl(p_rec.pji_attribute11, hr_api.g_varchar2) or
547: nvl(per_pji_shd.g_old_rec.pji_attribute12, hr_api.g_varchar2) <>

Line 545: nvl(per_pji_shd.g_old_rec.pji_attribute11, hr_api.g_varchar2) <>

541: nvl(per_pji_shd.g_old_rec.pji_attribute9, hr_api.g_varchar2) <>
542: nvl(p_rec.pji_attribute9, hr_api.g_varchar2) or
543: nvl(per_pji_shd.g_old_rec.pji_attribute10, hr_api.g_varchar2) <>
544: nvl(p_rec.pji_attribute10, hr_api.g_varchar2) or
545: nvl(per_pji_shd.g_old_rec.pji_attribute11, hr_api.g_varchar2) <>
546: nvl(p_rec.pji_attribute11, hr_api.g_varchar2) or
547: nvl(per_pji_shd.g_old_rec.pji_attribute12, hr_api.g_varchar2) <>
548: nvl(p_rec.pji_attribute12, hr_api.g_varchar2) or
549: nvl(per_pji_shd.g_old_rec.pji_attribute13, hr_api.g_varchar2) <>

Line 547: nvl(per_pji_shd.g_old_rec.pji_attribute12, hr_api.g_varchar2) <>

543: nvl(per_pji_shd.g_old_rec.pji_attribute10, hr_api.g_varchar2) <>
544: nvl(p_rec.pji_attribute10, hr_api.g_varchar2) or
545: nvl(per_pji_shd.g_old_rec.pji_attribute11, hr_api.g_varchar2) <>
546: nvl(p_rec.pji_attribute11, hr_api.g_varchar2) or
547: nvl(per_pji_shd.g_old_rec.pji_attribute12, hr_api.g_varchar2) <>
548: nvl(p_rec.pji_attribute12, hr_api.g_varchar2) or
549: nvl(per_pji_shd.g_old_rec.pji_attribute13, hr_api.g_varchar2) <>
550: nvl(p_rec.pji_attribute13, hr_api.g_varchar2) or
551: nvl(per_pji_shd.g_old_rec.pji_attribute14, hr_api.g_varchar2) <>

Line 549: nvl(per_pji_shd.g_old_rec.pji_attribute13, hr_api.g_varchar2) <>

545: nvl(per_pji_shd.g_old_rec.pji_attribute11, hr_api.g_varchar2) <>
546: nvl(p_rec.pji_attribute11, hr_api.g_varchar2) or
547: nvl(per_pji_shd.g_old_rec.pji_attribute12, hr_api.g_varchar2) <>
548: nvl(p_rec.pji_attribute12, hr_api.g_varchar2) or
549: nvl(per_pji_shd.g_old_rec.pji_attribute13, hr_api.g_varchar2) <>
550: nvl(p_rec.pji_attribute13, hr_api.g_varchar2) or
551: nvl(per_pji_shd.g_old_rec.pji_attribute14, hr_api.g_varchar2) <>
552: nvl(p_rec.pji_attribute14, hr_api.g_varchar2) or
553: nvl(per_pji_shd.g_old_rec.pji_attribute15, hr_api.g_varchar2) <>

Line 551: nvl(per_pji_shd.g_old_rec.pji_attribute14, hr_api.g_varchar2) <>

547: nvl(per_pji_shd.g_old_rec.pji_attribute12, hr_api.g_varchar2) <>
548: nvl(p_rec.pji_attribute12, hr_api.g_varchar2) or
549: nvl(per_pji_shd.g_old_rec.pji_attribute13, hr_api.g_varchar2) <>
550: nvl(p_rec.pji_attribute13, hr_api.g_varchar2) or
551: nvl(per_pji_shd.g_old_rec.pji_attribute14, hr_api.g_varchar2) <>
552: nvl(p_rec.pji_attribute14, hr_api.g_varchar2) or
553: nvl(per_pji_shd.g_old_rec.pji_attribute15, hr_api.g_varchar2) <>
554: nvl(p_rec.pji_attribute15, hr_api.g_varchar2) or
555: nvl(per_pji_shd.g_old_rec.pji_attribute16, hr_api.g_varchar2) <>

Line 553: nvl(per_pji_shd.g_old_rec.pji_attribute15, hr_api.g_varchar2) <>

549: nvl(per_pji_shd.g_old_rec.pji_attribute13, hr_api.g_varchar2) <>
550: nvl(p_rec.pji_attribute13, hr_api.g_varchar2) or
551: nvl(per_pji_shd.g_old_rec.pji_attribute14, hr_api.g_varchar2) <>
552: nvl(p_rec.pji_attribute14, hr_api.g_varchar2) or
553: nvl(per_pji_shd.g_old_rec.pji_attribute15, hr_api.g_varchar2) <>
554: nvl(p_rec.pji_attribute15, hr_api.g_varchar2) or
555: nvl(per_pji_shd.g_old_rec.pji_attribute16, hr_api.g_varchar2) <>
556: nvl(p_rec.pji_attribute16, hr_api.g_varchar2) or
557: nvl(per_pji_shd.g_old_rec.pji_attribute17, hr_api.g_varchar2) <>

Line 555: nvl(per_pji_shd.g_old_rec.pji_attribute16, hr_api.g_varchar2) <>

551: nvl(per_pji_shd.g_old_rec.pji_attribute14, hr_api.g_varchar2) <>
552: nvl(p_rec.pji_attribute14, hr_api.g_varchar2) or
553: nvl(per_pji_shd.g_old_rec.pji_attribute15, hr_api.g_varchar2) <>
554: nvl(p_rec.pji_attribute15, hr_api.g_varchar2) or
555: nvl(per_pji_shd.g_old_rec.pji_attribute16, hr_api.g_varchar2) <>
556: nvl(p_rec.pji_attribute16, hr_api.g_varchar2) or
557: nvl(per_pji_shd.g_old_rec.pji_attribute17, hr_api.g_varchar2) <>
558: nvl(p_rec.pji_attribute17, hr_api.g_varchar2) or
559: nvl(per_pji_shd.g_old_rec.pji_attribute18, hr_api.g_varchar2) <>

Line 557: nvl(per_pji_shd.g_old_rec.pji_attribute17, hr_api.g_varchar2) <>

553: nvl(per_pji_shd.g_old_rec.pji_attribute15, hr_api.g_varchar2) <>
554: nvl(p_rec.pji_attribute15, hr_api.g_varchar2) or
555: nvl(per_pji_shd.g_old_rec.pji_attribute16, hr_api.g_varchar2) <>
556: nvl(p_rec.pji_attribute16, hr_api.g_varchar2) or
557: nvl(per_pji_shd.g_old_rec.pji_attribute17, hr_api.g_varchar2) <>
558: nvl(p_rec.pji_attribute17, hr_api.g_varchar2) or
559: nvl(per_pji_shd.g_old_rec.pji_attribute18, hr_api.g_varchar2) <>
560: nvl(p_rec.pji_attribute18, hr_api.g_varchar2) or
561: nvl(per_pji_shd.g_old_rec.pji_attribute19, hr_api.g_varchar2) <>

Line 559: nvl(per_pji_shd.g_old_rec.pji_attribute18, hr_api.g_varchar2) <>

555: nvl(per_pji_shd.g_old_rec.pji_attribute16, hr_api.g_varchar2) <>
556: nvl(p_rec.pji_attribute16, hr_api.g_varchar2) or
557: nvl(per_pji_shd.g_old_rec.pji_attribute17, hr_api.g_varchar2) <>
558: nvl(p_rec.pji_attribute17, hr_api.g_varchar2) or
559: nvl(per_pji_shd.g_old_rec.pji_attribute18, hr_api.g_varchar2) <>
560: nvl(p_rec.pji_attribute18, hr_api.g_varchar2) or
561: nvl(per_pji_shd.g_old_rec.pji_attribute19, hr_api.g_varchar2) <>
562: nvl(p_rec.pji_attribute19, hr_api.g_varchar2) or
563: nvl(per_pji_shd.g_old_rec.pji_attribute20, hr_api.g_varchar2) <>

Line 561: nvl(per_pji_shd.g_old_rec.pji_attribute19, hr_api.g_varchar2) <>

557: nvl(per_pji_shd.g_old_rec.pji_attribute17, hr_api.g_varchar2) <>
558: nvl(p_rec.pji_attribute17, hr_api.g_varchar2) or
559: nvl(per_pji_shd.g_old_rec.pji_attribute18, hr_api.g_varchar2) <>
560: nvl(p_rec.pji_attribute18, hr_api.g_varchar2) or
561: nvl(per_pji_shd.g_old_rec.pji_attribute19, hr_api.g_varchar2) <>
562: nvl(p_rec.pji_attribute19, hr_api.g_varchar2) or
563: nvl(per_pji_shd.g_old_rec.pji_attribute20, hr_api.g_varchar2) <>
564: nvl(p_rec.pji_attribute20, hr_api.g_varchar2) or
565: nvl(per_pji_shd.g_old_rec.pji_attribute21, hr_api.g_varchar2) <>

Line 563: nvl(per_pji_shd.g_old_rec.pji_attribute20, hr_api.g_varchar2) <>

559: nvl(per_pji_shd.g_old_rec.pji_attribute18, hr_api.g_varchar2) <>
560: nvl(p_rec.pji_attribute18, hr_api.g_varchar2) or
561: nvl(per_pji_shd.g_old_rec.pji_attribute19, hr_api.g_varchar2) <>
562: nvl(p_rec.pji_attribute19, hr_api.g_varchar2) or
563: nvl(per_pji_shd.g_old_rec.pji_attribute20, hr_api.g_varchar2) <>
564: nvl(p_rec.pji_attribute20, hr_api.g_varchar2) or
565: nvl(per_pji_shd.g_old_rec.pji_attribute21, hr_api.g_varchar2) <>
566: nvl(p_rec.pji_attribute21, hr_api.g_varchar2) or
567: nvl(per_pji_shd.g_old_rec.pji_attribute22, hr_api.g_varchar2) <>

Line 565: nvl(per_pji_shd.g_old_rec.pji_attribute21, hr_api.g_varchar2) <>

561: nvl(per_pji_shd.g_old_rec.pji_attribute19, hr_api.g_varchar2) <>
562: nvl(p_rec.pji_attribute19, hr_api.g_varchar2) or
563: nvl(per_pji_shd.g_old_rec.pji_attribute20, hr_api.g_varchar2) <>
564: nvl(p_rec.pji_attribute20, hr_api.g_varchar2) or
565: nvl(per_pji_shd.g_old_rec.pji_attribute21, hr_api.g_varchar2) <>
566: nvl(p_rec.pji_attribute21, hr_api.g_varchar2) or
567: nvl(per_pji_shd.g_old_rec.pji_attribute22, hr_api.g_varchar2) <>
568: nvl(p_rec.pji_attribute22, hr_api.g_varchar2) or
569: nvl(per_pji_shd.g_old_rec.pji_attribute23, hr_api.g_varchar2) <>

Line 567: nvl(per_pji_shd.g_old_rec.pji_attribute22, hr_api.g_varchar2) <>

563: nvl(per_pji_shd.g_old_rec.pji_attribute20, hr_api.g_varchar2) <>
564: nvl(p_rec.pji_attribute20, hr_api.g_varchar2) or
565: nvl(per_pji_shd.g_old_rec.pji_attribute21, hr_api.g_varchar2) <>
566: nvl(p_rec.pji_attribute21, hr_api.g_varchar2) or
567: nvl(per_pji_shd.g_old_rec.pji_attribute22, hr_api.g_varchar2) <>
568: nvl(p_rec.pji_attribute22, hr_api.g_varchar2) or
569: nvl(per_pji_shd.g_old_rec.pji_attribute23, hr_api.g_varchar2) <>
570: nvl(p_rec.pji_attribute23, hr_api.g_varchar2) or
571: nvl(per_pji_shd.g_old_rec.pji_attribute24, hr_api.g_varchar2) <>

Line 569: nvl(per_pji_shd.g_old_rec.pji_attribute23, hr_api.g_varchar2) <>

565: nvl(per_pji_shd.g_old_rec.pji_attribute21, hr_api.g_varchar2) <>
566: nvl(p_rec.pji_attribute21, hr_api.g_varchar2) or
567: nvl(per_pji_shd.g_old_rec.pji_attribute22, hr_api.g_varchar2) <>
568: nvl(p_rec.pji_attribute22, hr_api.g_varchar2) or
569: nvl(per_pji_shd.g_old_rec.pji_attribute23, hr_api.g_varchar2) <>
570: nvl(p_rec.pji_attribute23, hr_api.g_varchar2) or
571: nvl(per_pji_shd.g_old_rec.pji_attribute24, hr_api.g_varchar2) <>
572: nvl(p_rec.pji_attribute24, hr_api.g_varchar2) or
573: nvl(per_pji_shd.g_old_rec.pji_attribute25, hr_api.g_varchar2) <>

Line 571: nvl(per_pji_shd.g_old_rec.pji_attribute24, hr_api.g_varchar2) <>

567: nvl(per_pji_shd.g_old_rec.pji_attribute22, hr_api.g_varchar2) <>
568: nvl(p_rec.pji_attribute22, hr_api.g_varchar2) or
569: nvl(per_pji_shd.g_old_rec.pji_attribute23, hr_api.g_varchar2) <>
570: nvl(p_rec.pji_attribute23, hr_api.g_varchar2) or
571: nvl(per_pji_shd.g_old_rec.pji_attribute24, hr_api.g_varchar2) <>
572: nvl(p_rec.pji_attribute24, hr_api.g_varchar2) or
573: nvl(per_pji_shd.g_old_rec.pji_attribute25, hr_api.g_varchar2) <>
574: nvl(p_rec.pji_attribute25, hr_api.g_varchar2) or
575: nvl(per_pji_shd.g_old_rec.pji_attribute26, hr_api.g_varchar2) <>

Line 573: nvl(per_pji_shd.g_old_rec.pji_attribute25, hr_api.g_varchar2) <>

569: nvl(per_pji_shd.g_old_rec.pji_attribute23, hr_api.g_varchar2) <>
570: nvl(p_rec.pji_attribute23, hr_api.g_varchar2) or
571: nvl(per_pji_shd.g_old_rec.pji_attribute24, hr_api.g_varchar2) <>
572: nvl(p_rec.pji_attribute24, hr_api.g_varchar2) or
573: nvl(per_pji_shd.g_old_rec.pji_attribute25, hr_api.g_varchar2) <>
574: nvl(p_rec.pji_attribute25, hr_api.g_varchar2) or
575: nvl(per_pji_shd.g_old_rec.pji_attribute26, hr_api.g_varchar2) <>
576: nvl(p_rec.pji_attribute26, hr_api.g_varchar2) or
577: nvl(per_pji_shd.g_old_rec.pji_attribute27, hr_api.g_varchar2) <>

Line 575: nvl(per_pji_shd.g_old_rec.pji_attribute26, hr_api.g_varchar2) <>

571: nvl(per_pji_shd.g_old_rec.pji_attribute24, hr_api.g_varchar2) <>
572: nvl(p_rec.pji_attribute24, hr_api.g_varchar2) or
573: nvl(per_pji_shd.g_old_rec.pji_attribute25, hr_api.g_varchar2) <>
574: nvl(p_rec.pji_attribute25, hr_api.g_varchar2) or
575: nvl(per_pji_shd.g_old_rec.pji_attribute26, hr_api.g_varchar2) <>
576: nvl(p_rec.pji_attribute26, hr_api.g_varchar2) or
577: nvl(per_pji_shd.g_old_rec.pji_attribute27, hr_api.g_varchar2) <>
578: nvl(p_rec.pji_attribute27, hr_api.g_varchar2) or
579: nvl(per_pji_shd.g_old_rec.pji_attribute28, hr_api.g_varchar2) <>

Line 577: nvl(per_pji_shd.g_old_rec.pji_attribute27, hr_api.g_varchar2) <>

573: nvl(per_pji_shd.g_old_rec.pji_attribute25, hr_api.g_varchar2) <>
574: nvl(p_rec.pji_attribute25, hr_api.g_varchar2) or
575: nvl(per_pji_shd.g_old_rec.pji_attribute26, hr_api.g_varchar2) <>
576: nvl(p_rec.pji_attribute26, hr_api.g_varchar2) or
577: nvl(per_pji_shd.g_old_rec.pji_attribute27, hr_api.g_varchar2) <>
578: nvl(p_rec.pji_attribute27, hr_api.g_varchar2) or
579: nvl(per_pji_shd.g_old_rec.pji_attribute28, hr_api.g_varchar2) <>
580: nvl(p_rec.pji_attribute28, hr_api.g_varchar2) or
581: nvl(per_pji_shd.g_old_rec.pji_attribute29, hr_api.g_varchar2) <>

Line 579: nvl(per_pji_shd.g_old_rec.pji_attribute28, hr_api.g_varchar2) <>

575: nvl(per_pji_shd.g_old_rec.pji_attribute26, hr_api.g_varchar2) <>
576: nvl(p_rec.pji_attribute26, hr_api.g_varchar2) or
577: nvl(per_pji_shd.g_old_rec.pji_attribute27, hr_api.g_varchar2) <>
578: nvl(p_rec.pji_attribute27, hr_api.g_varchar2) or
579: nvl(per_pji_shd.g_old_rec.pji_attribute28, hr_api.g_varchar2) <>
580: nvl(p_rec.pji_attribute28, hr_api.g_varchar2) or
581: nvl(per_pji_shd.g_old_rec.pji_attribute29, hr_api.g_varchar2) <>
582: nvl(p_rec.pji_attribute29, hr_api.g_varchar2) or
583: nvl(per_pji_shd.g_old_rec.pji_attribute30, hr_api.g_varchar2) <>

Line 581: nvl(per_pji_shd.g_old_rec.pji_attribute29, hr_api.g_varchar2) <>

577: nvl(per_pji_shd.g_old_rec.pji_attribute27, hr_api.g_varchar2) <>
578: nvl(p_rec.pji_attribute27, hr_api.g_varchar2) or
579: nvl(per_pji_shd.g_old_rec.pji_attribute28, hr_api.g_varchar2) <>
580: nvl(p_rec.pji_attribute28, hr_api.g_varchar2) or
581: nvl(per_pji_shd.g_old_rec.pji_attribute29, hr_api.g_varchar2) <>
582: nvl(p_rec.pji_attribute29, hr_api.g_varchar2) or
583: nvl(per_pji_shd.g_old_rec.pji_attribute30, hr_api.g_varchar2) <>
584: nvl(p_rec.pji_attribute30, hr_api.g_varchar2) ))
585: or (p_rec.previous_job_extra_info_id is null) then

Line 583: nvl(per_pji_shd.g_old_rec.pji_attribute30, hr_api.g_varchar2) <>

579: nvl(per_pji_shd.g_old_rec.pji_attribute28, hr_api.g_varchar2) <>
580: nvl(p_rec.pji_attribute28, hr_api.g_varchar2) or
581: nvl(per_pji_shd.g_old_rec.pji_attribute29, hr_api.g_varchar2) <>
582: nvl(p_rec.pji_attribute29, hr_api.g_varchar2) or
583: nvl(per_pji_shd.g_old_rec.pji_attribute30, hr_api.g_varchar2) <>
584: nvl(p_rec.pji_attribute30, hr_api.g_varchar2) ))
585: or (p_rec.previous_job_extra_info_id is null) then
586: --
587: -- Only execute the validation if absolutely necessary:

Line 690: (p_rec in per_pji_shd.g_rec_type

686: --
687: -- {End Of Comments}
688: -- ----------------------------------------------------------------------------
689: Procedure chk_non_updateable_args
690: (p_rec in per_pji_shd.g_rec_type
691: ) IS
692: --
693: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
694: l_error EXCEPTION;

Line 702: IF NOT per_pji_shd.api_updating

698: --
699: -- Only proceed with the validation if a row exists for the current
700: -- record in the HR Schema.
701: --
702: IF NOT per_pji_shd.api_updating
703: (p_previous_job_extra_info_id => p_rec.previous_job_extra_info_id
704: ,p_object_version_number => p_rec.object_version_number
705: ) THEN
706: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 712: if per_pji_shd.g_old_rec.previous_job_extra_info_id

708: fnd_message.set_token('STEP ', '5');
709: fnd_message.raise_error;
710: END IF;
711: -- Check for non updateable args
712: if per_pji_shd.g_old_rec.previous_job_extra_info_id
713: <> p_rec.previous_job_extra_info_id
714: then
715: hr_api.argument_changed_error
716: (p_api_name => l_proc

Line 734: (p_rec in per_pji_shd.g_rec_type) is

730: -- ----------------------------------------------------------------------------
731: -- |---------------------------< insert_validate >----------------------------|
732: -- ----------------------------------------------------------------------------
733: Procedure insert_validate
734: (p_rec in per_pji_shd.g_rec_type) is
735: l_proc varchar2(72) := g_package||'insert_validate';
736: --
737: Begin
738: hr_utility.set_location('Entering:'||l_proc, 5);

Line 782: (p_rec in per_pji_shd.g_rec_type

778: -- ----------------------------------------------------------------------------
779: -- |---------------------------< update_validate >----------------------------|
780: -- ----------------------------------------------------------------------------
781: Procedure update_validate
782: (p_rec in per_pji_shd.g_rec_type
783: ) is
784: --
785: l_proc varchar2(72) := g_package||'update_validate';
786: --

Line 828: (p_rec in per_pji_shd.g_rec_type

824: -- ----------------------------------------------------------------------------
825: -- |---------------------------< delete_validate >----------------------------|
826: -- ----------------------------------------------------------------------------
827: Procedure delete_validate
828: (p_rec in per_pji_shd.g_rec_type
829: ) is
830: --
831: l_proc varchar2(72) := g_package||'delete_validate';
832: --