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 254: (p_rec in per_pem_shd.g_rec_type

250: -- Internal Row Handler Use Only.
251: --
252: -- ----------------------------------------------------------------------------
253: procedure chk_ddf
254: (p_rec in per_pem_shd.g_rec_type
255: ) is
256: --
257: l_proc varchar2(72) := g_package || 'chk_ddf';
258: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:

Line 431: (p_rec in per_pem_shd.g_rec_type

427: -- Internal Row Handler Use Only.
428: --
429: -- ----------------------------------------------------------------------------
430: procedure chk_df
431: (p_rec in per_pem_shd.g_rec_type
432: ) is
433: --
434: l_proc varchar2(72) := g_package || 'chk_df';
435: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:

Line 608: ,p_rec in per_pem_shd.g_rec_type

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

Line 619: IF NOT per_pem_shd.api_updating

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

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

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

Line 637: ,p_base_table => per_pem_shd.g_tab_nam

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: );
639: end if;
640: --
641: hr_utility.set_location(l_proc,15);

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

638: );
639: end if;
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'

Line 647: ,p_base_table => per_pem_shd.g_tab_nam

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: );
649: end if;
650: --
651: hr_utility.set_location(l_proc,20);

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

648: );
649: end if;
650: --
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

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

649: end if;
650: --
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'

Line 658: ,p_base_table => per_pem_shd.g_tab_nam

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: );
660: end if;
661: hr_utility.set_location(l_proc,25);
662: --

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

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

Line 672: ,p_base_table => per_pem_shd.g_tab_nam

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: );
674: end if;
675: --
676: */

Line 743: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

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

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

Line 840: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

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

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

Line 924: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

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

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

Line 1008: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

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

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

Line 1108: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

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

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

Line 1213: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1209: hr_utility.set_location('Entering:'||l_proc, 6);
1210:
1211: if p_start_date is not null and p_end_date is not null then
1212: hr_utility.set_location(l_proc, 10);
1213: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1214: => p_previous_employer_id
1215: ,p_object_version_number
1216: => p_object_version_number
1217: );

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

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

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

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

Line 1290: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1286: begin
1287: hr_utility.set_location('Entering:'||l_proc, 5);
1288: --
1289: if p_period_years is not null then
1290: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1291: => p_previous_employer_id
1292: ,p_object_version_number
1293: => p_object_version_number);
1294: hr_utility.set_location(l_proc, 10);

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

Line 1363: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1359: begin
1360: hr_utility.set_location('Entering:'||l_proc, 5);
1361: --
1362: if p_period_months is not null then
1363: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1364: => p_previous_employer_id
1365: ,p_object_version_number
1366: => p_object_version_number);
1367: hr_utility.set_location(l_proc, 10);

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

Line 1436: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1432: begin
1433: hr_utility.set_location('Entering:'||l_proc, 5);
1434: --
1435: if p_period_days is not null then
1436: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1437: => p_previous_employer_id
1438: ,p_object_version_number
1439: => p_object_version_number);
1440: hr_utility.set_location(l_proc, 10);

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

Line 1520: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

1516: hr_utility.set_location('Entering:'||l_proc, 5);
1517: --
1518: if p_all_assignments is not null then
1519: hr_utility.set_location(l_proc, 10);
1520: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1521: => p_previous_employer_id
1522: ,p_object_version_number
1523: => p_object_version_number
1524: );

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

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

Line 1618: l_api_updating := per_pem_shd.api_updating

1614: --
1615: --
1616: --update only if null
1617: --
1618: l_api_updating := per_pem_shd.api_updating
1619: (p_previous_employer_id => p_previous_employer_id
1620: ,p_object_version_number => p_object_version_number );
1621: if (l_api_updating
1622: and per_pem_shd.g_old_rec.business_group_id is not null

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

1618: l_api_updating := per_pem_shd.api_updating
1619: (p_previous_employer_id => p_previous_employer_id
1620: ,p_object_version_number => p_object_version_number );
1621: if (l_api_updating
1622: and per_pem_shd.g_old_rec.business_group_id is not null
1623: and per_pem_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1624: --
1625: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1626: hr_utility.raise_error;

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

1619: (p_previous_employer_id => p_previous_employer_id
1620: ,p_object_version_number => p_object_version_number );
1621: if (l_api_updating
1622: and per_pem_shd.g_old_rec.business_group_id is not null
1623: and per_pem_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1624: --
1625: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1626: hr_utility.raise_error;
1627: --

Line 1647: ,p_rec in per_pem_shd.g_rec_type

1643: -- |---------------------------< insert_validate >----------------------------|
1644: -- ----------------------------------------------------------------------------
1645: Procedure insert_validate
1646: (p_effective_date in date
1647: ,p_rec in per_pem_shd.g_rec_type
1648: ) is
1649: --
1650: l_proc varchar2(72) := g_package||'insert_validate';
1651: --

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

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

Line 1765: ,p_rec in per_pem_shd.g_rec_type

1761: -- |---------------------------< update_validate >----------------------------|
1762: -- ----------------------------------------------------------------------------
1763: Procedure update_validate
1764: (p_effective_date in date
1765: ,p_rec in per_pem_shd.g_rec_type
1766: ) is
1767: --
1768: l_proc varchar2(72) := g_package||'update_validate';
1769: --

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

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

Line 1876: (p_rec in per_pem_shd.g_rec_type

1872: -- ----------------------------------------------------------------------------
1873: -- |---------------------------< delete_validate >----------------------------|
1874: -- ----------------------------------------------------------------------------
1875: Procedure delete_validate
1876: (p_rec in per_pem_shd.g_rec_type
1877: ) is
1878: --
1879: l_proc varchar2(72) := g_package||'delete_validate';
1880: --