119: hr_utility.set_location('Entering:'|| l_proc, 10);
120: --
121: -- Ensure that all the mandatory parameter are not null
122: --
123: hr_api.mandatory_arg_error
124: (p_api_name => l_proc
125: ,p_argument => 'previous_employer_id'
126: ,p_argument_value => p_previous_employer_id
127: );
143: close csr_sec_grp;
144: --
145: -- Set the security_group_id in CLIENT_INFO
146: --
147: hr_api.set_security_group_id
148: (p_security_group_id => l_security_group_id
149: );
150: end if;
151: --
181: hr_utility.set_location('Entering:'|| l_proc, 10);
182: --
183: -- Ensure that all the mandatory parameter are not null
184: --
185: hr_api.mandatory_arg_error
186: (p_api_name => l_proc
187: ,p_argument => 'previous_employer_id'
188: ,p_argument_value => p_previous_employer_id
189: );
187: ,p_argument => 'previous_employer_id'
188: ,p_argument_value => p_previous_employer_id
189: );
190: --
191: if ( nvl(per_pem_bus.g_previous_employer_id, hr_api.g_number)
192: = p_previous_employer_id) then
193: --
194: -- The legislation code has already been found with a previous
195: -- call to this function. Just return the value in the global
263: begin
264: hr_utility.set_location('Entering:'||l_proc,10);
265: --
266: if ((p_rec.previous_employer_id is not null) and (
267: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
264: hr_utility.set_location('Entering:'||l_proc,10);
265: --
266: if ((p_rec.previous_employer_id is not null) and (
267: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
265: --
266: if ((p_rec.previous_employer_id is not null) and (
267: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
266: if ((p_rec.previous_employer_id is not null) and (
267: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
267: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
325: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
325: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
326: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
325: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
326: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
327: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
325: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
326: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
327: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
328: nvl(p_rec.pem_information30, hr_api.g_varchar2) ))
321: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
325: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
326: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
327: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
328: nvl(p_rec.pem_information30, hr_api.g_varchar2) ))
329: or (p_rec.previous_employer_id is null) then
322: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
325: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
326: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
327: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
328: nvl(p_rec.pem_information30, hr_api.g_varchar2) ))
329: or (p_rec.previous_employer_id is null) then
330: --
323: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
325: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
326: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
327: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
328: nvl(p_rec.pem_information30, hr_api.g_varchar2) ))
329: or (p_rec.previous_employer_id is null) then
330: --
331: -- Only execute the validation if absolutely necessary:
324: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
325: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
326: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
327: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
328: nvl(p_rec.pem_information30, hr_api.g_varchar2) ))
329: or (p_rec.previous_employer_id is null) then
330: --
331: -- Only execute the validation if absolutely necessary:
332: -- a) During update, the structure column value or any
440: begin
441: hr_utility.set_location('Entering:'||l_proc,10);
442: --
443: if ((p_rec.previous_employer_id is not null) and (
444: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
441: hr_utility.set_location('Entering:'||l_proc,10);
442: --
443: if ((p_rec.previous_employer_id is not null) and (
444: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
442: --
443: if ((p_rec.previous_employer_id is not null) and (
444: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
443: if ((p_rec.previous_employer_id is not null) and (
444: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
444: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
502: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
502: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
502: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
504: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
502: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
504: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
505: nvl(p_rec.pem_attribute30, hr_api.g_varchar2) ))
498: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
502: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
504: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
505: nvl(p_rec.pem_attribute30, hr_api.g_varchar2) ))
506: or (p_rec.previous_employer_id is null) then
499: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
502: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
504: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
505: nvl(p_rec.pem_attribute30, hr_api.g_varchar2) ))
506: or (p_rec.previous_employer_id is null) then
507: --
500: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
502: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
504: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
505: nvl(p_rec.pem_attribute30, hr_api.g_varchar2) ))
506: or (p_rec.previous_employer_id is null) then
507: --
508: -- Only execute the validation if absolutely necessary:
501: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
502: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
504: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
505: nvl(p_rec.pem_attribute30, hr_api.g_varchar2) ))
506: or (p_rec.previous_employer_id is null) then
507: --
508: -- Only execute the validation if absolutely necessary:
509: -- a) During update, the structure column value or any
634: -- not been updated.
635: hr_utility.set_location(l_proc,10);
636: if per_pem_shd.g_old_rec.previous_employer_id <> p_rec.previous_employer_id
637: then
638: hr_api.argument_changed_error
639: (p_api_name => l_proc
640: ,p_argument => 'previous_employer_id'
641: ,p_base_table => per_pem_shd.g_tab_nam
642: );
644: --
645: hr_utility.set_location(l_proc,15);
646: if per_pem_shd.g_old_rec.person_id <> p_rec.person_id
647: then
648: hr_api.argument_changed_error
649: (p_api_name => l_proc
650: ,p_argument => 'person_id'
651: ,p_base_table => per_pem_shd.g_tab_nam
652: );
655: hr_utility.set_location(l_proc,20);
656: if nvl(per_pem_shd.g_old_rec.party_id,p_rec.party_id) <>
657: nvl(p_rec.party_id,per_pem_shd.g_old_rec.party_id)
658: then
659: hr_api.argument_changed_error
660: (p_api_name => l_proc
661: ,p_argument => 'party_id'
662: ,p_base_table => per_pem_shd.g_tab_nam
663: );
669: --
670: /*
671: if per_pem_shd.g_old_rec.business_group_id <> p_rec.business_group_id
672: then
673: hr_api.argument_changed_error
674: (p_api_name => l_proc
675: ,p_argument => 'business_group_id'
676: ,p_base_table => per_pem_shd.g_tab_nam
677: );
749: ,p_object_version_number
750: => p_object_version_number
751: );
752: if ((l_api_updating
753: and nvl(per_pem_shd.g_old_rec.person_id, hr_api.g_number)
754: <> nvl(p_person_id,hr_api.g_number))
755: or
756: (not l_api_updating))
757: then
750: => p_object_version_number
751: );
752: if ((l_api_updating
753: and nvl(per_pem_shd.g_old_rec.person_id, hr_api.g_number)
754: <> nvl(p_person_id,hr_api.g_number))
755: or
756: (not l_api_updating))
757: then
758: -- Check for invalid person_id
846: ,p_object_version_number
847: => p_object_version_number
848: );
849: if ((l_api_updating
850: and nvl(per_pem_shd.g_old_rec.party_id, hr_api.g_number)
851: <> nvl(p_party_id,hr_api.g_number))
852: or
853: (not l_api_updating))
854: then
847: => p_object_version_number
848: );
849: if ((l_api_updating
850: and nvl(per_pem_shd.g_old_rec.party_id, hr_api.g_number)
851: <> nvl(p_party_id,hr_api.g_number))
852: or
853: (not l_api_updating))
854: then
855: hr_utility.set_location(l_proc, 15);
930: ,p_object_version_number
931: => p_object_version_number
932: );
933: if ((l_api_updating
934: and nvl(per_pem_shd.g_old_rec.employer_country, hr_api.g_varchar2)
935: <> nvl(p_employer_country,hr_api.g_varchar2))
936: or
937: (not l_api_updating))
938: then
931: => p_object_version_number
932: );
933: if ((l_api_updating
934: and nvl(per_pem_shd.g_old_rec.employer_country, hr_api.g_varchar2)
935: <> nvl(p_employer_country,hr_api.g_varchar2))
936: or
937: (not l_api_updating))
938: then
939: hr_utility.set_location(l_proc, 15);
1014: ,p_object_version_number
1015: => p_object_version_number
1016: );
1017: if ((l_api_updating and
1018: nvl(p_employer_type,hr_api.g_varchar2)
1019: <> nvl(per_pem_shd.g_old_rec.employer_type, hr_api.g_varchar2))
1020: or
1021: (not l_api_updating)) then
1022: hr_utility.set_location(l_proc, 15);
1015: => p_object_version_number
1016: );
1017: if ((l_api_updating and
1018: nvl(p_employer_type,hr_api.g_varchar2)
1019: <> nvl(per_pem_shd.g_old_rec.employer_type, hr_api.g_varchar2))
1020: or
1021: (not l_api_updating)) then
1022: hr_utility.set_location(l_proc, 15);
1023: l_no_lookup := hr_api.not_exists_in_leg_lookups
1019: <> nvl(per_pem_shd.g_old_rec.employer_type, hr_api.g_varchar2))
1020: or
1021: (not l_api_updating)) then
1022: hr_utility.set_location(l_proc, 15);
1023: l_no_lookup := hr_api.not_exists_in_leg_lookups
1024: (p_effective_date => l_effective_date
1025: ,p_lookup_type => l_lookup_type
1026: ,p_lookup_code => l_lookup_code
1027: );
1114: ,p_object_version_number
1115: => p_object_version_number
1116: );
1117: if ((l_api_updating and
1118: nvl(p_employer_subtype,hr_api.g_varchar2)
1119: <> nvl(per_pem_shd.g_old_rec.employer_subtype
1120: , hr_api.g_varchar2))
1121: or
1122: (not l_api_updating)) then
1116: );
1117: if ((l_api_updating and
1118: nvl(p_employer_subtype,hr_api.g_varchar2)
1119: <> nvl(per_pem_shd.g_old_rec.employer_subtype
1120: , hr_api.g_varchar2))
1121: or
1122: (not l_api_updating)) then
1123: hr_utility.set_location(l_proc, 15);
1124: -- Check for standard lookup
1121: or
1122: (not l_api_updating)) then
1123: hr_utility.set_location(l_proc, 15);
1124: -- Check for standard lookup
1125: l_no_lookup := hr_api.not_exists_in_leg_lookups
1126: (p_effective_date => l_effective_date
1127: ,p_lookup_type => l_lookup_type
1128: ,p_lookup_code => l_lookup_code
1129: );
1239: ,p_object_version_number
1240: => p_object_version_number
1241: );
1242: if ((l_api_updating and
1243: ( nvl(p_start_date,hr_api.g_sot)
1244: <> nvl(per_pem_shd.g_old_rec.start_date, hr_api.g_sot)
1245: or
1246: nvl(p_end_date,hr_api.g_eot)
1247: <> nvl(per_pem_shd.g_old_rec.end_date, hr_api.g_eot)
1240: => p_object_version_number
1241: );
1242: if ((l_api_updating and
1243: ( nvl(p_start_date,hr_api.g_sot)
1244: <> nvl(per_pem_shd.g_old_rec.start_date, hr_api.g_sot)
1245: or
1246: nvl(p_end_date,hr_api.g_eot)
1247: <> nvl(per_pem_shd.g_old_rec.end_date, hr_api.g_eot)
1248: ))
1242: if ((l_api_updating and
1243: ( nvl(p_start_date,hr_api.g_sot)
1244: <> nvl(per_pem_shd.g_old_rec.start_date, hr_api.g_sot)
1245: or
1246: nvl(p_end_date,hr_api.g_eot)
1247: <> nvl(per_pem_shd.g_old_rec.end_date, hr_api.g_eot)
1248: ))
1249: or
1250: (not l_api_updating)) then
1243: ( nvl(p_start_date,hr_api.g_sot)
1244: <> nvl(per_pem_shd.g_old_rec.start_date, hr_api.g_sot)
1245: or
1246: nvl(p_end_date,hr_api.g_eot)
1247: <> nvl(per_pem_shd.g_old_rec.end_date, hr_api.g_eot)
1248: ))
1249: or
1250: (not l_api_updating)) then
1251: hr_utility.set_location(l_proc, 15);
1316: ,p_object_version_number
1317: => p_object_version_number);
1318: hr_utility.set_location(l_proc, 10);
1319: if ((l_api_updating and
1320: ( nvl(p_period_years,hr_api.g_number)
1321: <> nvl(per_pem_shd.g_old_rec.period_years, hr_api.g_number)
1322: )
1323: ) or
1324: (not l_api_updating)) then
1317: => p_object_version_number);
1318: hr_utility.set_location(l_proc, 10);
1319: if ((l_api_updating and
1320: ( nvl(p_period_years,hr_api.g_number)
1321: <> nvl(per_pem_shd.g_old_rec.period_years, hr_api.g_number)
1322: )
1323: ) or
1324: (not l_api_updating)) then
1325: hr_utility.set_location(l_proc, 15);
1389: ,p_object_version_number
1390: => p_object_version_number);
1391: hr_utility.set_location(l_proc, 10);
1392: if ((l_api_updating and
1393: ( nvl(p_period_months,hr_api.g_number)
1394: <> nvl(per_pem_shd.g_old_rec.period_months,hr_api.g_number)
1395: )
1396: ) or
1397: (not l_api_updating)) then
1390: => p_object_version_number);
1391: hr_utility.set_location(l_proc, 10);
1392: if ((l_api_updating and
1393: ( nvl(p_period_months,hr_api.g_number)
1394: <> nvl(per_pem_shd.g_old_rec.period_months,hr_api.g_number)
1395: )
1396: ) or
1397: (not l_api_updating)) then
1398: hr_utility.set_location(l_proc, 15);
1462: ,p_object_version_number
1463: => p_object_version_number);
1464: hr_utility.set_location(l_proc, 10);
1465: if ((l_api_updating and
1466: ( nvl(p_period_days,hr_api.g_number)
1467: <> nvl(per_pem_shd.g_old_rec.period_days,hr_api.g_number)
1468: )
1469: ) or
1470: (not l_api_updating)) then
1463: => p_object_version_number);
1464: hr_utility.set_location(l_proc, 10);
1465: if ((l_api_updating and
1466: ( nvl(p_period_days,hr_api.g_number)
1467: <> nvl(per_pem_shd.g_old_rec.period_days,hr_api.g_number)
1468: )
1469: ) or
1470: (not l_api_updating)) then
1471: hr_utility.set_location(l_proc, 15);
1547: => p_object_version_number
1548: );
1549:
1550: if ((l_api_updating and
1551: nvl(p_all_assignments,hr_api.g_varchar2)
1552: <> nvl(per_pem_shd.g_old_rec.all_assignments, hr_api.g_varchar2))
1553: or
1554: (not l_api_updating)) then
1555: hr_utility.set_location(l_proc, 15);
1548: );
1549:
1550: if ((l_api_updating and
1551: nvl(p_all_assignments,hr_api.g_varchar2)
1552: <> nvl(per_pem_shd.g_old_rec.all_assignments, hr_api.g_varchar2))
1553: or
1554: (not l_api_updating)) then
1555: hr_utility.set_location(l_proc, 15);
1556: if p_all_assignments = 'Y' or p_all_assignments = 'N' then
1631: hr_utility.set_location(l_proc, 10);
1632: --
1633: --validate business_group_id
1634: --
1635: hr_api.validate_bus_grp_id(p_business_group_id);
1636: --
1637: end if;
1638: --
1639: --
1678: --
1679: --Validate Important Attributes
1680: --
1681: hr_utility.set_location(l_proc, 10);
1682: hr_api.mandatory_arg_error
1683: (p_api_name => l_proc
1684: ,p_argument => 'EFFECTIVE_DATE'
1685: ,p_argument_value => p_effective_date
1686: );
1687: -- Call all supporting business operations
1688: hr_utility.set_location(l_proc, 15);
1689: --
1690: if p_rec.party_id is null and p_rec.business_group_id is not null then
1691: hr_api.validate_bus_grp_id
1692: (p_business_group_id => p_rec.business_group_id
1693: ,p_associated_column1 =>per_pem_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
1694: ); -- Validate Bus Grp
1695: end if;
1798: --
1799: -- Call all supporting business operations
1800: --
1801: hr_utility.set_location(l_proc, 10);
1802: hr_api.mandatory_arg_error
1803: (p_api_name => l_proc
1804: ,p_argument => 'EFFECTIVE_DATE'
1805: ,p_argument_value => p_effective_date
1806: );
1811: );
1812: --
1813: hr_utility.set_location(l_proc, 15);
1814: if p_rec.party_id is null and p_rec.business_group_id is not null then
1815: hr_api.validate_bus_grp_id
1816: (p_business_group_id => p_rec.business_group_id
1817: ,p_associated_column1 =>per_pem_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
1818: ); -- Validate Bus Grp
1819: end if;