eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PEM_BUS dependencies on PER_PEM_SHD

Line 258: (p_rec in per_pem_shd.g_rec_type

254: -- Internal Row Handler Use Only.
255: --
256: -- ----------------------------------------------------------------------------
257: procedure chk_ddf
258: (p_rec in per_pem_shd.g_rec_type
259: ) is
260: --
261: l_proc varchar2(72) := g_package || 'chk_ddf';
262: --

Line 267: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>

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) <>

Line 269: nvl(per_pem_shd.g_old_rec.pem_information1, hr_api.g_varchar2) <>

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) <>

Line 271: nvl(per_pem_shd.g_old_rec.pem_information2, hr_api.g_varchar2) <>

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) <>

Line 273: nvl(per_pem_shd.g_old_rec.pem_information3, hr_api.g_varchar2) <>

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) <>

Line 275: nvl(per_pem_shd.g_old_rec.pem_information4, hr_api.g_varchar2) <>

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) <>

Line 277: nvl(per_pem_shd.g_old_rec.pem_information5, hr_api.g_varchar2) <>

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) <>

Line 279: nvl(per_pem_shd.g_old_rec.pem_information6, hr_api.g_varchar2) <>

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) <>

Line 281: nvl(per_pem_shd.g_old_rec.pem_information7, hr_api.g_varchar2) <>

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) <>

Line 283: nvl(per_pem_shd.g_old_rec.pem_information8, hr_api.g_varchar2) <>

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) <>

Line 285: nvl(per_pem_shd.g_old_rec.pem_information9, hr_api.g_varchar2) <>

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) <>

Line 287: nvl(per_pem_shd.g_old_rec.pem_information10, hr_api.g_varchar2) <>

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) <>

Line 289: nvl(per_pem_shd.g_old_rec.pem_information11, hr_api.g_varchar2) <>

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) <>

Line 291: nvl(per_pem_shd.g_old_rec.pem_information12, hr_api.g_varchar2) <>

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) <>

Line 293: nvl(per_pem_shd.g_old_rec.pem_information13, hr_api.g_varchar2) <>

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) <>

Line 295: nvl(per_pem_shd.g_old_rec.pem_information14, hr_api.g_varchar2) <>

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) <>

Line 297: nvl(per_pem_shd.g_old_rec.pem_information15, hr_api.g_varchar2) <>

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) <>

Line 299: nvl(per_pem_shd.g_old_rec.pem_information16, hr_api.g_varchar2) <>

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) <>

Line 301: nvl(per_pem_shd.g_old_rec.pem_information17, hr_api.g_varchar2) <>

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) <>

Line 303: nvl(per_pem_shd.g_old_rec.pem_information18, hr_api.g_varchar2) <>

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) <>

Line 305: nvl(per_pem_shd.g_old_rec.pem_information19, hr_api.g_varchar2) <>

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) <>

Line 307: nvl(per_pem_shd.g_old_rec.pem_information20, hr_api.g_varchar2) <>

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) <>

Line 309: nvl(per_pem_shd.g_old_rec.pem_information21, hr_api.g_varchar2) <>

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) <>

Line 311: nvl(per_pem_shd.g_old_rec.pem_information22, hr_api.g_varchar2) <>

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) <>

Line 313: nvl(per_pem_shd.g_old_rec.pem_information23, hr_api.g_varchar2) <>

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) <>

Line 315: nvl(per_pem_shd.g_old_rec.pem_information24, hr_api.g_varchar2) <>

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) <>

Line 317: nvl(per_pem_shd.g_old_rec.pem_information25, hr_api.g_varchar2) <>

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) <>

Line 319: nvl(per_pem_shd.g_old_rec.pem_information26, hr_api.g_varchar2) <>

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) <>

Line 321: nvl(per_pem_shd.g_old_rec.pem_information27, hr_api.g_varchar2) <>

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) <>

Line 323: nvl(per_pem_shd.g_old_rec.pem_information28, hr_api.g_varchar2) <>

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) <>

Line 325: nvl(per_pem_shd.g_old_rec.pem_information29, 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

Line 327: nvl(per_pem_shd.g_old_rec.pem_information30, hr_api.g_varchar2) <>

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:

Line 435: (p_rec in per_pem_shd.g_rec_type

431: -- Internal Row Handler Use Only.
432: --
433: -- ----------------------------------------------------------------------------
434: procedure chk_df
435: (p_rec in per_pem_shd.g_rec_type
436: ) is
437: --
438: l_proc varchar2(72) := g_package || 'chk_df';
439: --

Line 444: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>

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) <>

Line 446: nvl(per_pem_shd.g_old_rec.pem_attribute1, hr_api.g_varchar2) <>

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) <>

Line 448: nvl(per_pem_shd.g_old_rec.pem_attribute2, hr_api.g_varchar2) <>

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) <>

Line 450: nvl(per_pem_shd.g_old_rec.pem_attribute3, hr_api.g_varchar2) <>

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) <>

Line 452: nvl(per_pem_shd.g_old_rec.pem_attribute4, hr_api.g_varchar2) <>

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) <>

Line 454: nvl(per_pem_shd.g_old_rec.pem_attribute5, hr_api.g_varchar2) <>

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) <>

Line 456: nvl(per_pem_shd.g_old_rec.pem_attribute6, hr_api.g_varchar2) <>

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) <>

Line 458: nvl(per_pem_shd.g_old_rec.pem_attribute7, hr_api.g_varchar2) <>

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) <>

Line 460: nvl(per_pem_shd.g_old_rec.pem_attribute8, hr_api.g_varchar2) <>

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) <>

Line 462: nvl(per_pem_shd.g_old_rec.pem_attribute9, hr_api.g_varchar2) <>

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) <>

Line 464: nvl(per_pem_shd.g_old_rec.pem_attribute10, hr_api.g_varchar2) <>

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) <>

Line 466: nvl(per_pem_shd.g_old_rec.pem_attribute11, hr_api.g_varchar2) <>

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) <>

Line 468: nvl(per_pem_shd.g_old_rec.pem_attribute12, hr_api.g_varchar2) <>

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) <>

Line 470: nvl(per_pem_shd.g_old_rec.pem_attribute13, hr_api.g_varchar2) <>

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) <>

Line 472: nvl(per_pem_shd.g_old_rec.pem_attribute14, hr_api.g_varchar2) <>

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) <>

Line 474: nvl(per_pem_shd.g_old_rec.pem_attribute15, hr_api.g_varchar2) <>

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) <>

Line 476: nvl(per_pem_shd.g_old_rec.pem_attribute16, hr_api.g_varchar2) <>

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) <>

Line 478: nvl(per_pem_shd.g_old_rec.pem_attribute17, hr_api.g_varchar2) <>

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) <>

Line 480: nvl(per_pem_shd.g_old_rec.pem_attribute18, hr_api.g_varchar2) <>

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) <>

Line 482: nvl(per_pem_shd.g_old_rec.pem_attribute19, hr_api.g_varchar2) <>

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) <>

Line 484: nvl(per_pem_shd.g_old_rec.pem_attribute20, hr_api.g_varchar2) <>

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) <>

Line 486: nvl(per_pem_shd.g_old_rec.pem_attribute21, hr_api.g_varchar2) <>

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) <>

Line 488: nvl(per_pem_shd.g_old_rec.pem_attribute22, hr_api.g_varchar2) <>

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) <>

Line 490: nvl(per_pem_shd.g_old_rec.pem_attribute23, hr_api.g_varchar2) <>

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) <>

Line 492: nvl(per_pem_shd.g_old_rec.pem_attribute24, hr_api.g_varchar2) <>

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) <>

Line 494: nvl(per_pem_shd.g_old_rec.pem_attribute25, hr_api.g_varchar2) <>

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) <>

Line 496: nvl(per_pem_shd.g_old_rec.pem_attribute26, hr_api.g_varchar2) <>

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) <>

Line 498: nvl(per_pem_shd.g_old_rec.pem_attribute27, hr_api.g_varchar2) <>

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) <>

Line 500: nvl(per_pem_shd.g_old_rec.pem_attribute28, hr_api.g_varchar2) <>

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) <>

Line 502: nvl(per_pem_shd.g_old_rec.pem_attribute29, 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

Line 504: nvl(per_pem_shd.g_old_rec.pem_attribute30, hr_api.g_varchar2) <>

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:

Line 612: ,p_rec in per_pem_shd.g_rec_type

608: -- {End Of Comments}
609: -- ----------------------------------------------------------------------------
610: Procedure chk_non_updateable_args
611: (p_effective_date in date
612: ,p_rec in per_pem_shd.g_rec_type
613: ) IS
614: --
615: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
616: --

Line 623: IF NOT per_pem_shd.api_updating

619: --
620: -- Only proceed with the validation if a row exists for the current
621: -- record in the HR Schema.
622: --
623: IF NOT per_pem_shd.api_updating
624: (p_previous_employer_id => p_rec.previous_employer_id
625: ,p_object_version_number => p_rec.object_version_number
626: ) THEN
627: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 636: if per_pem_shd.g_old_rec.previous_employer_id <> p_rec.previous_employer_id

632: --
633: -- Add checks to ensure non-updateable args have
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'

Line 641: ,p_base_table => per_pem_shd.g_tab_nam

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: );
643: end if;
644: --
645: hr_utility.set_location(l_proc,15);

Line 646: if per_pem_shd.g_old_rec.person_id <> p_rec.person_id

642: );
643: end if;
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'

Line 651: ,p_base_table => per_pem_shd.g_tab_nam

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: );
653: end if;
654: --
655: hr_utility.set_location(l_proc,20);

Line 656: if nvl(per_pem_shd.g_old_rec.party_id,p_rec.party_id) <>

652: );
653: end if;
654: --
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

Line 657: nvl(p_rec.party_id,per_pem_shd.g_old_rec.party_id)

653: end if;
654: --
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'

Line 662: ,p_base_table => per_pem_shd.g_tab_nam

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: );
664: end if;
665: hr_utility.set_location(l_proc,25);
666: --

Line 671: if per_pem_shd.g_old_rec.business_group_id <> p_rec.business_group_id

667: -- start commented code for business_group_id is
668: -- updateable if previously null.
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'

Line 676: ,p_base_table => per_pem_shd.g_tab_nam

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: );
678: end if;
679: --
680: */

Line 747: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

743: begin
744: hr_utility.set_location('Entering:'||l_proc, 5);
745: if p_person_id is not null then
746: hr_utility.set_location(l_proc, 10);
747: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
748: => p_previous_employer_id
749: ,p_object_version_number
750: => p_object_version_number
751: );

Line 753: and nvl(per_pem_shd.g_old_rec.person_id, hr_api.g_number)

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

Line 844: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

840: hr_utility.set_location('Entering:'||l_proc, 5);
841: --
842: if p_party_id is not null then
843: hr_utility.set_location(l_proc, 10);
844: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
845: => p_previous_employer_id
846: ,p_object_version_number
847: => p_object_version_number
848: );

Line 850: and nvl(per_pem_shd.g_old_rec.party_id, hr_api.g_number)

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

Line 928: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: if p_employer_country is not null then
927: hr_utility.set_location(l_proc, 10);
928: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
929: => p_previous_employer_id
930: ,p_object_version_number
931: => p_object_version_number
932: );

Line 934: and nvl(per_pem_shd.g_old_rec.employer_country, hr_api.g_varchar2)

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

Line 1012: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1008: hr_utility.set_location('Entering:'||l_proc, 5);
1009: --
1010: if p_employer_type is not null then
1011: hr_utility.set_location(l_proc, 10);
1012: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1013: => p_previous_employer_id
1014: ,p_object_version_number
1015: => p_object_version_number
1016: );

Line 1019: <> nvl(per_pem_shd.g_old_rec.employer_type, hr_api.g_varchar2))

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

Line 1112: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1108: (p_check_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'
1109: ) then
1110: if p_employer_subtype is not null then
1111: hr_utility.set_location(l_proc, 10);
1112: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1113: => p_previous_employer_id
1114: ,p_object_version_number
1115: => p_object_version_number
1116: );

Line 1119: <> nvl(per_pem_shd.g_old_rec.employer_subtype

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
1123: hr_utility.set_location(l_proc, 15);

Line 1237: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1233: hr_utility.set_location('Entering:'||l_proc, 6);
1234:
1235: if p_start_date is not null and p_end_date is not null then
1236: hr_utility.set_location(l_proc, 10);
1237: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1238: => p_previous_employer_id
1239: ,p_object_version_number
1240: => p_object_version_number
1241: );

Line 1244: <> nvl(per_pem_shd.g_old_rec.start_date, hr_api.g_sot)

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: ))

Line 1247: <> nvl(per_pem_shd.g_old_rec.end_date, hr_api.g_eot)

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);

Line 1314: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1310: begin
1311: hr_utility.set_location('Entering:'||l_proc, 5);
1312: --
1313: if p_period_years is not null then
1314: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1315: => p_previous_employer_id
1316: ,p_object_version_number
1317: => p_object_version_number);
1318: hr_utility.set_location(l_proc, 10);

Line 1321: <> nvl(per_pem_shd.g_old_rec.period_years, hr_api.g_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
1325: hr_utility.set_location(l_proc, 15);

Line 1387: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1383: begin
1384: hr_utility.set_location('Entering:'||l_proc, 5);
1385: --
1386: if p_period_months is not null then
1387: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1388: => p_previous_employer_id
1389: ,p_object_version_number
1390: => p_object_version_number);
1391: hr_utility.set_location(l_proc, 10);

Line 1394: <> nvl(per_pem_shd.g_old_rec.period_months,hr_api.g_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
1398: hr_utility.set_location(l_proc, 15);

Line 1460: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1456: begin
1457: hr_utility.set_location('Entering:'||l_proc, 5);
1458: --
1459: if p_period_days is not null then
1460: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1461: => p_previous_employer_id
1462: ,p_object_version_number
1463: => p_object_version_number);
1464: hr_utility.set_location(l_proc, 10);

Line 1467: <> nvl(per_pem_shd.g_old_rec.period_days,hr_api.g_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
1471: hr_utility.set_location(l_proc, 15);

Line 1544: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1540: hr_utility.set_location('Entering:'||l_proc, 5);
1541: --
1542: if p_all_assignments is not null then
1543: hr_utility.set_location(l_proc, 10);
1544: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1545: => p_previous_employer_id
1546: ,p_object_version_number
1547: => p_object_version_number
1548: );

Line 1552: <> nvl(per_pem_shd.g_old_rec.all_assignments, hr_api.g_varchar2))

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

Line 1642: l_api_updating := per_pem_shd.api_updating

1638: --
1639: --
1640: --update only if null
1641: --
1642: l_api_updating := per_pem_shd.api_updating
1643: (p_previous_employer_id => p_previous_employer_id
1644: ,p_object_version_number => p_object_version_number );
1645: if (l_api_updating
1646: and per_pem_shd.g_old_rec.business_group_id is not null

Line 1646: and per_pem_shd.g_old_rec.business_group_id is not null

1642: l_api_updating := per_pem_shd.api_updating
1643: (p_previous_employer_id => p_previous_employer_id
1644: ,p_object_version_number => p_object_version_number );
1645: if (l_api_updating
1646: and per_pem_shd.g_old_rec.business_group_id is not null
1647: and per_pem_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1648: --
1649: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1650: hr_utility.raise_error;

Line 1647: and per_pem_shd.g_old_rec.business_group_id <> p_business_group_id ) then

1643: (p_previous_employer_id => p_previous_employer_id
1644: ,p_object_version_number => p_object_version_number );
1645: if (l_api_updating
1646: and per_pem_shd.g_old_rec.business_group_id is not null
1647: and per_pem_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1648: --
1649: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1650: hr_utility.raise_error;
1651: --

Line 1671: ,p_rec in per_pem_shd.g_rec_type

1667: -- |---------------------------< insert_validate >----------------------------|
1668: -- ----------------------------------------------------------------------------
1669: Procedure insert_validate
1670: (p_effective_date in date
1671: ,p_rec in per_pem_shd.g_rec_type
1672: ) is
1673: --
1674: l_proc varchar2(72) := g_package||'insert_validate';
1675: --

Line 1693: ,p_associated_column1 =>per_pem_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

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;
1696: --After validating the set of important attributes,
1697: --if multiple message detection is enabled and atleast

Line 1791: ,p_rec in per_pem_shd.g_rec_type

1787: -- |---------------------------< update_validate >----------------------------|
1788: -- ----------------------------------------------------------------------------
1789: Procedure update_validate
1790: (p_effective_date in date
1791: ,p_rec in per_pem_shd.g_rec_type
1792: ) is
1793: --
1794: l_proc varchar2(72) := g_package||'update_validate';
1795: --

Line 1817: ,p_associated_column1 =>per_pem_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

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;
1820: --
1821: --After validating the set of important attributes,

Line 1904: (p_rec in per_pem_shd.g_rec_type

1900: -- ----------------------------------------------------------------------------
1901: -- |---------------------------< delete_validate >----------------------------|
1902: -- ----------------------------------------------------------------------------
1903: Procedure delete_validate
1904: (p_rec in per_pem_shd.g_rec_type
1905: ) is
1906: --
1907: l_proc varchar2(72) := g_package||'delete_validate';
1908: --