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);
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);
71: open csr_previous_job_id;
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);
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);
148: open csr_information_type;
195: hr_utility.set_location('Entering:'|| l_proc, 10);
196: --
197: -- Ensure that all the mandatory parameter are not null
198: --
199: hr_api.mandatory_arg_error
200: (p_api_name => l_proc
201: ,p_argument => 'previous_job_extra_info_id'
202: ,p_argument_value => p_previous_job_extra_info_id
203: );
218: close csr_sec_grp;
219: --
220: -- Set the security_group_id in CLIENT_INFO
221: --
222: hr_api.set_security_group_id
223: (p_security_group_id => l_security_group_id
224: );
225: --
226: hr_utility.set_location(' Leaving:'|| l_proc, 20);
258: hr_utility.set_location('Entering:'|| l_proc, 10);
259: --
260: -- Ensure that all the mandatory parameter are not null
261: --
262: hr_api.mandatory_arg_error
263: (p_api_name => l_proc
264: ,p_argument => 'previous_job_extra_info_id'
265: ,p_argument_value => p_previous_job_extra_info_id
266: );
264: ,p_argument => 'previous_job_extra_info_id'
265: ,p_argument_value => p_previous_job_extra_info_id
266: );
267: --
268: if ( nvl(per_pji_bus.g_previous_job_extra_info_id, hr_api.g_number)
269: = p_previous_job_extra_info_id) then
270: --
271: -- The legislation code has already been found with a previous
272: -- call to this function. Just return the value in the global
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) <>
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) <>
349: nvl(p_rec.pji_information1, hr_api.g_varchar2) or
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) <>
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) <>
351: nvl(p_rec.pji_information2, hr_api.g_varchar2) or
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) <>
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) <>
353: nvl(p_rec.pji_information3, 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) <>
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) <>
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) <>
355: nvl(p_rec.pji_information4, 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) <>
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) <>
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) <>
357: nvl(p_rec.pji_information5, 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) <>
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) <>
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) <>
359: nvl(p_rec.pji_information6, 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) <>
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) <>
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) <>
361: nvl(p_rec.pji_information7, 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) <>
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) <>
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) <>
363: nvl(p_rec.pji_information8, 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) <>
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) <>
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) <>
365: nvl(p_rec.pji_information9, 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) <>
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) <>
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) <>
367: nvl(p_rec.pji_information10, 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) <>
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) <>
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) <>
369: nvl(p_rec.pji_information11, 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) <>
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) <>
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) <>
371: nvl(p_rec.pji_information12, 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) <>
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) <>
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) <>
373: nvl(p_rec.pji_information13, 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) <>
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) <>
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) <>
375: nvl(p_rec.pji_information14, 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) <>
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) <>
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) <>
377: nvl(p_rec.pji_information15, 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) <>
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) <>
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) <>
379: nvl(p_rec.pji_information16, 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) <>
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) <>
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) <>
381: nvl(p_rec.pji_information17, 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) <>
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) <>
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) <>
383: nvl(p_rec.pji_information18, 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) <>
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) <>
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) <>
385: nvl(p_rec.pji_information19, 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) <>
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) <>
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) <>
387: nvl(p_rec.pji_information20, 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) <>
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) <>
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) <>
389: nvl(p_rec.pji_information21, 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) <>
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) <>
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) <>
391: nvl(p_rec.pji_information22, 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) <>
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) <>
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) <>
393: nvl(p_rec.pji_information23, 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) <>
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) <>
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) <>
395: nvl(p_rec.pji_information24, 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) <>
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) <>
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) <>
397: nvl(p_rec.pji_information25, 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) <>
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) <>
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) <>
399: nvl(p_rec.pji_information26, 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) <>
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) <>
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) <>
401: nvl(p_rec.pji_information27, 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) <>
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) <>
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) <>
403: nvl(p_rec.pji_information28, 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) <>
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) <>
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) <>
405: nvl(p_rec.pji_information29, 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) <>
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) <>
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) <>
407: nvl(p_rec.pji_information30, 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
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
409: --
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:
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:
411: -- a) During update, the structure column value or any
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) <>
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) <>
528: nvl(p_rec.pji_attribute2, hr_api.g_varchar2) or
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) <>
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) <>
530: nvl(p_rec.pji_attribute3, hr_api.g_varchar2) or
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) <>
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) <>
532: nvl(p_rec.pji_attribute4, 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) <>
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) <>
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) <>
534: nvl(p_rec.pji_attribute5, 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) <>
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) <>
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) <>
536: nvl(p_rec.pji_attribute6, 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) <>
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) <>
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) <>
538: nvl(p_rec.pji_attribute7, 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) <>
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) <>
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) <>
540: nvl(p_rec.pji_attribute8, 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) <>
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) <>
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) <>
542: nvl(p_rec.pji_attribute9, 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) <>
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) <>
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) <>
544: nvl(p_rec.pji_attribute10, 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) <>
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) <>
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) <>
546: nvl(p_rec.pji_attribute11, 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) <>
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) <>
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) <>
548: nvl(p_rec.pji_attribute12, 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) <>
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) <>
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) <>
550: nvl(p_rec.pji_attribute13, 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) <>
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) <>
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) <>
552: nvl(p_rec.pji_attribute14, 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) <>
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) <>
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) <>
554: nvl(p_rec.pji_attribute15, 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) <>
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) <>
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) <>
556: nvl(p_rec.pji_attribute16, 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) <>
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) <>
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) <>
558: nvl(p_rec.pji_attribute17, 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) <>
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) <>
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) <>
560: nvl(p_rec.pji_attribute18, 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) <>
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) <>
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) <>
562: nvl(p_rec.pji_attribute19, 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) <>
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) <>
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) <>
564: nvl(p_rec.pji_attribute20, 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) <>
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) <>
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) <>
566: nvl(p_rec.pji_attribute21, 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) <>
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) <>
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) <>
568: nvl(p_rec.pji_attribute22, 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) <>
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) <>
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) <>
570: nvl(p_rec.pji_attribute23, 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) <>
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) <>
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) <>
572: nvl(p_rec.pji_attribute24, 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) <>
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) <>
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) <>
574: nvl(p_rec.pji_attribute25, 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) <>
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) <>
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) <>
576: nvl(p_rec.pji_attribute26, 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) <>
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) <>
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) <>
578: nvl(p_rec.pji_attribute27, 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) <>
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) <>
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) <>
580: nvl(p_rec.pji_attribute28, 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) <>
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) <>
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) <>
582: nvl(p_rec.pji_attribute29, 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) <>
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) <>
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) <>
584: nvl(p_rec.pji_attribute30, 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
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
586: --
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:
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:
588: -- a) During update, the structure column value or any
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
717: ,p_argument => 'previous_job_extra_info_id'
718: );
719: end if;
719: end if;
720: --
721: EXCEPTION
722: WHEN l_error THEN
723: hr_api.argument_changed_error
724: (p_api_name => l_proc
725: ,p_argument => l_argument);
726: WHEN OTHERS THEN
727: RAISE;
737: Begin
738: hr_utility.set_location('Entering:'||l_proc, 5);
739: --
740: -- Check whether the Previous Job Id is Valid
741: hr_api.mandatory_arg_error
742: (p_api_name => l_proc
743: ,p_argument => 'previous_job_id'
744: ,p_argument_value => p_rec.previous_job_id
745: );
743: ,p_argument => 'previous_job_id'
744: ,p_argument_value => p_rec.previous_job_id
745: );
746: --
747: hr_api.mandatory_arg_error
748: (p_api_name => l_proc
749: ,p_argument => 'information_type'
750: ,p_argument_value => p_rec.information_type
751: );
788: hr_utility.set_location('Entering:'||l_proc, 5);
789: --
790: -- Call all supporting business operations
791: --
792: hr_api.mandatory_arg_error
793: (p_api_name => l_proc
794: ,p_argument => 'previous_job_id'
795: ,p_argument_value => p_rec.previous_job_id
796: );
794: ,p_argument => 'previous_job_id'
795: ,p_argument_value => p_rec.previous_job_id
796: );
797: --
798: hr_api.mandatory_arg_error
799: (p_api_name => l_proc
800: ,p_argument => 'information_type'
801: ,p_argument_value => p_rec.information_type
802: );