115: hr_utility.set_location('Entering:'|| l_proc, 10);
116: --
117: -- Ensure that all the mandatory parameter are not null
118: --
119: hr_api.mandatory_arg_error
120: (p_api_name => l_proc
121: ,p_argument => 'previous_employer_id'
122: ,p_argument_value => p_previous_employer_id
123: );
139: close csr_sec_grp;
140: --
141: -- Set the security_group_id in CLIENT_INFO
142: --
143: hr_api.set_security_group_id
144: (p_security_group_id => l_security_group_id
145: );
146: end if;
147: --
177: hr_utility.set_location('Entering:'|| l_proc, 10);
178: --
179: -- Ensure that all the mandatory parameter are not null
180: --
181: hr_api.mandatory_arg_error
182: (p_api_name => l_proc
183: ,p_argument => 'previous_employer_id'
184: ,p_argument_value => p_previous_employer_id
185: );
183: ,p_argument => 'previous_employer_id'
184: ,p_argument_value => p_previous_employer_id
185: );
186: --
187: if ( nvl(per_pem_bus.g_previous_employer_id, hr_api.g_number)
188: = p_previous_employer_id) then
189: --
190: -- The legislation code has already been found with a previous
191: -- call to this function. Just return the value in the global
259: begin
260: hr_utility.set_location('Entering:'||l_proc,10);
261: --
262: if ((p_rec.previous_employer_id is not null) and (
263: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>
264: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
265: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
266: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
267: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
260: hr_utility.set_location('Entering:'||l_proc,10);
261: --
262: if ((p_rec.previous_employer_id is not null) and (
263: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>
264: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
265: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
266: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
267: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
261: --
262: if ((p_rec.previous_employer_id is not null) and (
263: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>
264: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
265: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
266: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
267: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
262: if ((p_rec.previous_employer_id is not null) and (
263: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>
264: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
265: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
266: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
267: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
263: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>
264: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
265: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
266: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
267: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
264: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or
265: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
266: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
267: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
265: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>
266: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
267: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
266: nvl(p_rec.pem_information1, hr_api.g_varchar2) or
267: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
267: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
268: nvl(p_rec.pem_information2, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
269: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
270: nvl(p_rec.pem_information3, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
271: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
272: nvl(p_rec.pem_information4, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
273: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
274: nvl(p_rec.pem_information5, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
275: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
276: nvl(p_rec.pem_information6, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
277: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
278: nvl(p_rec.pem_information7, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
279: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
280: nvl(p_rec.pem_information8, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
281: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
282: nvl(p_rec.pem_information9, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
283: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
284: nvl(p_rec.pem_information10, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
285: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
286: nvl(p_rec.pem_information11, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
287: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
288: nvl(p_rec.pem_information12, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
289: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
290: nvl(p_rec.pem_information13, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
291: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
292: nvl(p_rec.pem_information14, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
293: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
294: nvl(p_rec.pem_information15, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
295: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
296: nvl(p_rec.pem_information16, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
297: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
298: nvl(p_rec.pem_information17, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
299: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
300: nvl(p_rec.pem_information18, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
301: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
302: nvl(p_rec.pem_information19, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
303: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
304: nvl(p_rec.pem_information20, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
305: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
306: nvl(p_rec.pem_information21, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
307: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
308: nvl(p_rec.pem_information22, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
309: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
310: nvl(p_rec.pem_information23, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
311: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
312: nvl(p_rec.pem_information24, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
313: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
314: nvl(p_rec.pem_information25, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
315: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
316: nvl(p_rec.pem_information26, hr_api.g_varchar2) or
317: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information30, hr_api.g_varchar2) ))
317: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>
318: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information30, hr_api.g_varchar2) ))
325: or (p_rec.previous_employer_id is null) then
318: nvl(p_rec.pem_information27, hr_api.g_varchar2) or
319: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information30, hr_api.g_varchar2) ))
325: or (p_rec.previous_employer_id is null) then
326: --
319: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>
320: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information30, hr_api.g_varchar2) ))
325: or (p_rec.previous_employer_id is null) then
326: --
327: -- Only execute the validation if absolutely necessary:
320: nvl(p_rec.pem_information28, hr_api.g_varchar2) or
321: nvl(per_pem_shd.g_old_rec.pem_information29, hr_api.g_varchar2) <>
322: nvl(p_rec.pem_information29, hr_api.g_varchar2) or
323: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>
324: nvl(p_rec.pem_information30, hr_api.g_varchar2) ))
325: or (p_rec.previous_employer_id is null) then
326: --
327: -- Only execute the validation if absolutely necessary:
328: -- a) During update, the structure column value or any
436: begin
437: hr_utility.set_location('Entering:'||l_proc,10);
438: --
439: if ((p_rec.previous_employer_id is not null) and (
440: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>
441: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
442: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
443: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
444: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
437: hr_utility.set_location('Entering:'||l_proc,10);
438: --
439: if ((p_rec.previous_employer_id is not null) and (
440: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>
441: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
442: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
443: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
444: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
438: --
439: if ((p_rec.previous_employer_id is not null) and (
440: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>
441: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
442: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
443: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
444: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
439: if ((p_rec.previous_employer_id is not null) and (
440: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>
441: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
442: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
443: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
444: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
440: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>
441: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
442: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
443: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
444: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
441: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or
442: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
443: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
444: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
442: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>
443: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
444: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
443: nvl(p_rec.pem_attribute1, hr_api.g_varchar2) or
444: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
444: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
445: nvl(p_rec.pem_attribute2, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
446: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
447: nvl(p_rec.pem_attribute3, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
448: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
449: nvl(p_rec.pem_attribute4, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
450: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
451: nvl(p_rec.pem_attribute5, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
452: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
453: nvl(p_rec.pem_attribute6, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
454: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
455: nvl(p_rec.pem_attribute7, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
456: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
457: nvl(p_rec.pem_attribute8, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
458: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
459: nvl(p_rec.pem_attribute9, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
460: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
461: nvl(p_rec.pem_attribute10, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
462: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
463: nvl(p_rec.pem_attribute11, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
464: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
465: nvl(p_rec.pem_attribute12, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
466: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
467: nvl(p_rec.pem_attribute13, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
468: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
469: nvl(p_rec.pem_attribute14, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
470: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
471: nvl(p_rec.pem_attribute15, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
472: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
473: nvl(p_rec.pem_attribute16, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
474: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
475: nvl(p_rec.pem_attribute17, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
476: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
477: nvl(p_rec.pem_attribute18, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
478: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
479: nvl(p_rec.pem_attribute19, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
480: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
481: nvl(p_rec.pem_attribute20, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
482: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
483: nvl(p_rec.pem_attribute21, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
484: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
485: nvl(p_rec.pem_attribute22, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
486: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
487: nvl(p_rec.pem_attribute23, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
488: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
489: nvl(p_rec.pem_attribute24, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
490: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
491: nvl(p_rec.pem_attribute25, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
492: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
493: nvl(p_rec.pem_attribute26, hr_api.g_varchar2) or
494: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute30, hr_api.g_varchar2) ))
494: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>
495: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute30, hr_api.g_varchar2) ))
502: or (p_rec.previous_employer_id is null) then
495: nvl(p_rec.pem_attribute27, hr_api.g_varchar2) or
496: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute30, hr_api.g_varchar2) ))
502: or (p_rec.previous_employer_id is null) then
503: --
496: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>
497: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute30, hr_api.g_varchar2) ))
502: or (p_rec.previous_employer_id is null) then
503: --
504: -- Only execute the validation if absolutely necessary:
497: nvl(p_rec.pem_attribute28, hr_api.g_varchar2) or
498: nvl(per_pem_shd.g_old_rec.pem_attribute29, hr_api.g_varchar2) <>
499: nvl(p_rec.pem_attribute29, hr_api.g_varchar2) or
500: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>
501: nvl(p_rec.pem_attribute30, hr_api.g_varchar2) ))
502: or (p_rec.previous_employer_id is null) then
503: --
504: -- Only execute the validation if absolutely necessary:
505: -- a) During update, the structure column value or any
630: -- not been updated.
631: hr_utility.set_location(l_proc,10);
632: if per_pem_shd.g_old_rec.previous_employer_id <> p_rec.previous_employer_id
633: then
634: hr_api.argument_changed_error
635: (p_api_name => l_proc
636: ,p_argument => 'previous_employer_id'
637: ,p_base_table => per_pem_shd.g_tab_nam
638: );
640: --
641: hr_utility.set_location(l_proc,15);
642: if per_pem_shd.g_old_rec.person_id <> p_rec.person_id
643: then
644: hr_api.argument_changed_error
645: (p_api_name => l_proc
646: ,p_argument => 'person_id'
647: ,p_base_table => per_pem_shd.g_tab_nam
648: );
651: hr_utility.set_location(l_proc,20);
652: if nvl(per_pem_shd.g_old_rec.party_id,p_rec.party_id) <>
653: nvl(p_rec.party_id,per_pem_shd.g_old_rec.party_id)
654: then
655: hr_api.argument_changed_error
656: (p_api_name => l_proc
657: ,p_argument => 'party_id'
658: ,p_base_table => per_pem_shd.g_tab_nam
659: );
665: --
666: /*
667: if per_pem_shd.g_old_rec.business_group_id <> p_rec.business_group_id
668: then
669: hr_api.argument_changed_error
670: (p_api_name => l_proc
671: ,p_argument => 'business_group_id'
672: ,p_base_table => per_pem_shd.g_tab_nam
673: );
745: ,p_object_version_number
746: => p_object_version_number
747: );
748: if ((l_api_updating
749: and nvl(per_pem_shd.g_old_rec.person_id, hr_api.g_number)
750: <> nvl(p_person_id,hr_api.g_number))
751: or
752: (not l_api_updating))
753: then
746: => p_object_version_number
747: );
748: if ((l_api_updating
749: and nvl(per_pem_shd.g_old_rec.person_id, hr_api.g_number)
750: <> nvl(p_person_id,hr_api.g_number))
751: or
752: (not l_api_updating))
753: then
754: -- Check for invalid person_id
842: ,p_object_version_number
843: => p_object_version_number
844: );
845: if ((l_api_updating
846: and nvl(per_pem_shd.g_old_rec.party_id, hr_api.g_number)
847: <> nvl(p_party_id,hr_api.g_number))
848: or
849: (not l_api_updating))
850: then
843: => p_object_version_number
844: );
845: if ((l_api_updating
846: and nvl(per_pem_shd.g_old_rec.party_id, hr_api.g_number)
847: <> nvl(p_party_id,hr_api.g_number))
848: or
849: (not l_api_updating))
850: then
851: hr_utility.set_location(l_proc, 15);
926: ,p_object_version_number
927: => p_object_version_number
928: );
929: if ((l_api_updating
930: and nvl(per_pem_shd.g_old_rec.employer_country, hr_api.g_varchar2)
931: <> nvl(p_employer_country,hr_api.g_varchar2))
932: or
933: (not l_api_updating))
934: then
927: => p_object_version_number
928: );
929: if ((l_api_updating
930: and nvl(per_pem_shd.g_old_rec.employer_country, hr_api.g_varchar2)
931: <> nvl(p_employer_country,hr_api.g_varchar2))
932: or
933: (not l_api_updating))
934: then
935: hr_utility.set_location(l_proc, 15);
1010: ,p_object_version_number
1011: => p_object_version_number
1012: );
1013: if ((l_api_updating and
1014: nvl(p_employer_type,hr_api.g_varchar2)
1015: <> nvl(per_pem_shd.g_old_rec.employer_type, hr_api.g_varchar2))
1016: or
1017: (not l_api_updating)) then
1018: hr_utility.set_location(l_proc, 15);
1011: => p_object_version_number
1012: );
1013: if ((l_api_updating and
1014: nvl(p_employer_type,hr_api.g_varchar2)
1015: <> nvl(per_pem_shd.g_old_rec.employer_type, hr_api.g_varchar2))
1016: or
1017: (not l_api_updating)) then
1018: hr_utility.set_location(l_proc, 15);
1019: l_no_lookup := hr_api.not_exists_in_leg_lookups
1015: <> nvl(per_pem_shd.g_old_rec.employer_type, hr_api.g_varchar2))
1016: or
1017: (not l_api_updating)) then
1018: hr_utility.set_location(l_proc, 15);
1019: l_no_lookup := hr_api.not_exists_in_leg_lookups
1020: (p_effective_date => l_effective_date
1021: ,p_lookup_type => l_lookup_type
1022: ,p_lookup_code => l_lookup_code
1023: );
1110: ,p_object_version_number
1111: => p_object_version_number
1112: );
1113: if ((l_api_updating and
1114: nvl(p_employer_subtype,hr_api.g_varchar2)
1115: <> nvl(per_pem_shd.g_old_rec.employer_subtype
1116: , hr_api.g_varchar2))
1117: or
1118: (not l_api_updating)) then
1112: );
1113: if ((l_api_updating and
1114: nvl(p_employer_subtype,hr_api.g_varchar2)
1115: <> nvl(per_pem_shd.g_old_rec.employer_subtype
1116: , hr_api.g_varchar2))
1117: or
1118: (not l_api_updating)) then
1119: hr_utility.set_location(l_proc, 15);
1120: -- Check for standard lookup
1117: or
1118: (not l_api_updating)) then
1119: hr_utility.set_location(l_proc, 15);
1120: -- Check for standard lookup
1121: l_no_lookup := hr_api.not_exists_in_leg_lookups
1122: (p_effective_date => l_effective_date
1123: ,p_lookup_type => l_lookup_type
1124: ,p_lookup_code => l_lookup_code
1125: );
1215: ,p_object_version_number
1216: => p_object_version_number
1217: );
1218: if ((l_api_updating and
1219: ( nvl(p_start_date,hr_api.g_sot)
1220: <> nvl(per_pem_shd.g_old_rec.start_date, hr_api.g_sot)
1221: or
1222: nvl(p_end_date,hr_api.g_eot)
1223: <> nvl(per_pem_shd.g_old_rec.end_date, hr_api.g_eot)
1216: => p_object_version_number
1217: );
1218: if ((l_api_updating and
1219: ( nvl(p_start_date,hr_api.g_sot)
1220: <> nvl(per_pem_shd.g_old_rec.start_date, hr_api.g_sot)
1221: or
1222: nvl(p_end_date,hr_api.g_eot)
1223: <> nvl(per_pem_shd.g_old_rec.end_date, hr_api.g_eot)
1224: ))
1218: if ((l_api_updating and
1219: ( nvl(p_start_date,hr_api.g_sot)
1220: <> nvl(per_pem_shd.g_old_rec.start_date, hr_api.g_sot)
1221: or
1222: nvl(p_end_date,hr_api.g_eot)
1223: <> nvl(per_pem_shd.g_old_rec.end_date, hr_api.g_eot)
1224: ))
1225: or
1226: (not l_api_updating)) then
1219: ( nvl(p_start_date,hr_api.g_sot)
1220: <> nvl(per_pem_shd.g_old_rec.start_date, hr_api.g_sot)
1221: or
1222: nvl(p_end_date,hr_api.g_eot)
1223: <> nvl(per_pem_shd.g_old_rec.end_date, hr_api.g_eot)
1224: ))
1225: or
1226: (not l_api_updating)) then
1227: hr_utility.set_location(l_proc, 15);
1292: ,p_object_version_number
1293: => p_object_version_number);
1294: hr_utility.set_location(l_proc, 10);
1295: if ((l_api_updating and
1296: ( nvl(p_period_years,hr_api.g_number)
1297: <> nvl(per_pem_shd.g_old_rec.period_years, hr_api.g_number)
1298: )
1299: ) or
1300: (not l_api_updating)) then
1293: => p_object_version_number);
1294: hr_utility.set_location(l_proc, 10);
1295: if ((l_api_updating and
1296: ( nvl(p_period_years,hr_api.g_number)
1297: <> nvl(per_pem_shd.g_old_rec.period_years, hr_api.g_number)
1298: )
1299: ) or
1300: (not l_api_updating)) then
1301: hr_utility.set_location(l_proc, 15);
1365: ,p_object_version_number
1366: => p_object_version_number);
1367: hr_utility.set_location(l_proc, 10);
1368: if ((l_api_updating and
1369: ( nvl(p_period_months,hr_api.g_number)
1370: <> nvl(per_pem_shd.g_old_rec.period_months,hr_api.g_number)
1371: )
1372: ) or
1373: (not l_api_updating)) then
1366: => p_object_version_number);
1367: hr_utility.set_location(l_proc, 10);
1368: if ((l_api_updating and
1369: ( nvl(p_period_months,hr_api.g_number)
1370: <> nvl(per_pem_shd.g_old_rec.period_months,hr_api.g_number)
1371: )
1372: ) or
1373: (not l_api_updating)) then
1374: hr_utility.set_location(l_proc, 15);
1438: ,p_object_version_number
1439: => p_object_version_number);
1440: hr_utility.set_location(l_proc, 10);
1441: if ((l_api_updating and
1442: ( nvl(p_period_days,hr_api.g_number)
1443: <> nvl(per_pem_shd.g_old_rec.period_days,hr_api.g_number)
1444: )
1445: ) or
1446: (not l_api_updating)) then
1439: => p_object_version_number);
1440: hr_utility.set_location(l_proc, 10);
1441: if ((l_api_updating and
1442: ( nvl(p_period_days,hr_api.g_number)
1443: <> nvl(per_pem_shd.g_old_rec.period_days,hr_api.g_number)
1444: )
1445: ) or
1446: (not l_api_updating)) then
1447: hr_utility.set_location(l_proc, 15);
1523: => p_object_version_number
1524: );
1525:
1526: if ((l_api_updating and
1527: nvl(p_all_assignments,hr_api.g_varchar2)
1528: <> nvl(per_pem_shd.g_old_rec.all_assignments, hr_api.g_varchar2))
1529: or
1530: (not l_api_updating)) then
1531: hr_utility.set_location(l_proc, 15);
1524: );
1525:
1526: if ((l_api_updating and
1527: nvl(p_all_assignments,hr_api.g_varchar2)
1528: <> nvl(per_pem_shd.g_old_rec.all_assignments, hr_api.g_varchar2))
1529: or
1530: (not l_api_updating)) then
1531: hr_utility.set_location(l_proc, 15);
1532: if p_all_assignments = 'Y' or p_all_assignments = 'N' then
1607: hr_utility.set_location(l_proc, 10);
1608: --
1609: --validate business_group_id
1610: --
1611: hr_api.validate_bus_grp_id(p_business_group_id);
1612: --
1613: end if;
1614: --
1615: --
1654: --
1655: --Validate Important Attributes
1656: --
1657: hr_utility.set_location(l_proc, 10);
1658: hr_api.mandatory_arg_error
1659: (p_api_name => l_proc
1660: ,p_argument => 'EFFECTIVE_DATE'
1661: ,p_argument_value => p_effective_date
1662: );
1663: -- Call all supporting business operations
1664: hr_utility.set_location(l_proc, 15);
1665: --
1666: if p_rec.party_id is null and p_rec.business_group_id is not null then
1667: hr_api.validate_bus_grp_id
1668: (p_business_group_id => p_rec.business_group_id
1669: ,p_associated_column1 =>per_pem_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
1670: ); -- Validate Bus Grp
1671: end if;
1772: --
1773: -- Call all supporting business operations
1774: --
1775: hr_utility.set_location(l_proc, 10);
1776: hr_api.mandatory_arg_error
1777: (p_api_name => l_proc
1778: ,p_argument => 'EFFECTIVE_DATE'
1779: ,p_argument_value => p_effective_date
1780: );
1785: );
1786: --
1787: hr_utility.set_location(l_proc, 15);
1788: if p_rec.party_id is null and p_rec.business_group_id is not null then
1789: hr_api.validate_bus_grp_id
1790: (p_business_group_id => p_rec.business_group_id
1791: ,p_associated_column1 =>per_pem_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
1792: ); -- Validate Bus Grp
1793: end if;