DBA Data[Home] [Help]

APPS.IRC_ILP_BUS dependencies on IRC_ILP_SHD

Line 327: (p_rec in irc_ilp_shd.g_rec_type

323: -- Internal Row Handler Use Only.
324: --
325: -- ----------------------------------------------------------------------------
326: procedure chk_df
327: (p_rec in irc_ilp_shd.g_rec_type
328: ) is
329: --
330: l_proc varchar2(72) := g_package || 'chk_df';
331: --

Line 336: nvl(irc_ilp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

332: begin
333: hr_utility.set_location('Entering:'||l_proc,10);
334: --
335: if ((p_rec.location_pref_id is not null) and (
336: nvl(irc_ilp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
338: nvl(irc_ilp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute1, hr_api.g_varchar2) or
340: nvl(irc_ilp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 338: nvl(irc_ilp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

334: --
335: if ((p_rec.location_pref_id is not null) and (
336: nvl(irc_ilp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
338: nvl(irc_ilp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute1, hr_api.g_varchar2) or
340: nvl(irc_ilp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute2, hr_api.g_varchar2) or
342: nvl(irc_ilp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 340: nvl(irc_ilp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

336: nvl(irc_ilp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
338: nvl(irc_ilp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute1, hr_api.g_varchar2) or
340: nvl(irc_ilp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute2, hr_api.g_varchar2) or
342: nvl(irc_ilp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute3, hr_api.g_varchar2) or
344: nvl(irc_ilp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 342: nvl(irc_ilp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

338: nvl(irc_ilp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute1, hr_api.g_varchar2) or
340: nvl(irc_ilp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute2, hr_api.g_varchar2) or
342: nvl(irc_ilp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute3, hr_api.g_varchar2) or
344: nvl(irc_ilp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute4, hr_api.g_varchar2) or
346: nvl(irc_ilp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 344: nvl(irc_ilp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

340: nvl(irc_ilp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute2, hr_api.g_varchar2) or
342: nvl(irc_ilp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute3, hr_api.g_varchar2) or
344: nvl(irc_ilp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute4, hr_api.g_varchar2) or
346: nvl(irc_ilp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute5, hr_api.g_varchar2) or
348: nvl(irc_ilp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 346: nvl(irc_ilp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

342: nvl(irc_ilp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute3, hr_api.g_varchar2) or
344: nvl(irc_ilp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute4, hr_api.g_varchar2) or
346: nvl(irc_ilp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute5, hr_api.g_varchar2) or
348: nvl(irc_ilp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute6, hr_api.g_varchar2) or
350: nvl(irc_ilp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 348: nvl(irc_ilp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

344: nvl(irc_ilp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute4, hr_api.g_varchar2) or
346: nvl(irc_ilp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute5, hr_api.g_varchar2) or
348: nvl(irc_ilp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute6, hr_api.g_varchar2) or
350: nvl(irc_ilp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute7, hr_api.g_varchar2) or
352: nvl(irc_ilp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 350: nvl(irc_ilp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

346: nvl(irc_ilp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute5, hr_api.g_varchar2) or
348: nvl(irc_ilp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute6, hr_api.g_varchar2) or
350: nvl(irc_ilp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute7, hr_api.g_varchar2) or
352: nvl(irc_ilp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute8, hr_api.g_varchar2) or
354: nvl(irc_ilp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 352: nvl(irc_ilp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

348: nvl(irc_ilp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute6, hr_api.g_varchar2) or
350: nvl(irc_ilp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute7, hr_api.g_varchar2) or
352: nvl(irc_ilp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute8, hr_api.g_varchar2) or
354: nvl(irc_ilp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute9, hr_api.g_varchar2) or
356: nvl(irc_ilp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 354: nvl(irc_ilp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

350: nvl(irc_ilp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute7, hr_api.g_varchar2) or
352: nvl(irc_ilp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute8, hr_api.g_varchar2) or
354: nvl(irc_ilp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute9, hr_api.g_varchar2) or
356: nvl(irc_ilp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute10, hr_api.g_varchar2) or
358: nvl(irc_ilp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 356: nvl(irc_ilp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

352: nvl(irc_ilp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute8, hr_api.g_varchar2) or
354: nvl(irc_ilp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute9, hr_api.g_varchar2) or
356: nvl(irc_ilp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute10, hr_api.g_varchar2) or
358: nvl(irc_ilp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute11, hr_api.g_varchar2) or
360: nvl(irc_ilp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 358: nvl(irc_ilp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

354: nvl(irc_ilp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute9, hr_api.g_varchar2) or
356: nvl(irc_ilp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute10, hr_api.g_varchar2) or
358: nvl(irc_ilp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute11, hr_api.g_varchar2) or
360: nvl(irc_ilp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute12, hr_api.g_varchar2) or
362: nvl(irc_ilp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 360: nvl(irc_ilp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

356: nvl(irc_ilp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute10, hr_api.g_varchar2) or
358: nvl(irc_ilp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute11, hr_api.g_varchar2) or
360: nvl(irc_ilp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute12, hr_api.g_varchar2) or
362: nvl(irc_ilp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute13, hr_api.g_varchar2) or
364: nvl(irc_ilp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 362: nvl(irc_ilp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

358: nvl(irc_ilp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute11, hr_api.g_varchar2) or
360: nvl(irc_ilp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute12, hr_api.g_varchar2) or
362: nvl(irc_ilp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute13, hr_api.g_varchar2) or
364: nvl(irc_ilp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute14, hr_api.g_varchar2) or
366: nvl(irc_ilp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 364: nvl(irc_ilp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

360: nvl(irc_ilp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute12, hr_api.g_varchar2) or
362: nvl(irc_ilp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute13, hr_api.g_varchar2) or
364: nvl(irc_ilp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute14, hr_api.g_varchar2) or
366: nvl(irc_ilp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute15, hr_api.g_varchar2) or
368: nvl(irc_ilp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 366: nvl(irc_ilp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

362: nvl(irc_ilp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute13, hr_api.g_varchar2) or
364: nvl(irc_ilp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute14, hr_api.g_varchar2) or
366: nvl(irc_ilp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute15, hr_api.g_varchar2) or
368: nvl(irc_ilp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute16, hr_api.g_varchar2) or
370: nvl(irc_ilp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 368: nvl(irc_ilp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

364: nvl(irc_ilp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute14, hr_api.g_varchar2) or
366: nvl(irc_ilp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute15, hr_api.g_varchar2) or
368: nvl(irc_ilp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute16, hr_api.g_varchar2) or
370: nvl(irc_ilp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute17, hr_api.g_varchar2) or
372: nvl(irc_ilp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 370: nvl(irc_ilp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

366: nvl(irc_ilp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute15, hr_api.g_varchar2) or
368: nvl(irc_ilp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute16, hr_api.g_varchar2) or
370: nvl(irc_ilp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute17, hr_api.g_varchar2) or
372: nvl(irc_ilp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute18, hr_api.g_varchar2) or
374: nvl(irc_ilp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 372: nvl(irc_ilp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

368: nvl(irc_ilp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute16, hr_api.g_varchar2) or
370: nvl(irc_ilp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute17, hr_api.g_varchar2) or
372: nvl(irc_ilp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute18, hr_api.g_varchar2) or
374: nvl(irc_ilp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute19, hr_api.g_varchar2) or
376: nvl(irc_ilp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 374: nvl(irc_ilp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

370: nvl(irc_ilp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute17, hr_api.g_varchar2) or
372: nvl(irc_ilp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute18, hr_api.g_varchar2) or
374: nvl(irc_ilp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute19, hr_api.g_varchar2) or
376: nvl(irc_ilp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute20, hr_api.g_varchar2) or
378: nvl(irc_ilp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 376: nvl(irc_ilp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

372: nvl(irc_ilp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute18, hr_api.g_varchar2) or
374: nvl(irc_ilp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute19, hr_api.g_varchar2) or
376: nvl(irc_ilp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute20, hr_api.g_varchar2) or
378: nvl(irc_ilp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute21, hr_api.g_varchar2) or
380: nvl(irc_ilp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 378: nvl(irc_ilp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

374: nvl(irc_ilp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute19, hr_api.g_varchar2) or
376: nvl(irc_ilp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute20, hr_api.g_varchar2) or
378: nvl(irc_ilp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute21, hr_api.g_varchar2) or
380: nvl(irc_ilp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute22, hr_api.g_varchar2) or
382: nvl(irc_ilp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 380: nvl(irc_ilp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

376: nvl(irc_ilp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute20, hr_api.g_varchar2) or
378: nvl(irc_ilp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute21, hr_api.g_varchar2) or
380: nvl(irc_ilp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute22, hr_api.g_varchar2) or
382: nvl(irc_ilp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute23, hr_api.g_varchar2) or
384: nvl(irc_ilp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 382: nvl(irc_ilp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

378: nvl(irc_ilp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute21, hr_api.g_varchar2) or
380: nvl(irc_ilp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute22, hr_api.g_varchar2) or
382: nvl(irc_ilp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute23, hr_api.g_varchar2) or
384: nvl(irc_ilp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute24, hr_api.g_varchar2) or
386: nvl(irc_ilp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 384: nvl(irc_ilp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

380: nvl(irc_ilp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute22, hr_api.g_varchar2) or
382: nvl(irc_ilp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute23, hr_api.g_varchar2) or
384: nvl(irc_ilp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute24, hr_api.g_varchar2) or
386: nvl(irc_ilp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute25, hr_api.g_varchar2) or
388: nvl(irc_ilp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 386: nvl(irc_ilp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

382: nvl(irc_ilp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute23, hr_api.g_varchar2) or
384: nvl(irc_ilp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute24, hr_api.g_varchar2) or
386: nvl(irc_ilp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute25, hr_api.g_varchar2) or
388: nvl(irc_ilp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute26, hr_api.g_varchar2) or
390: nvl(irc_ilp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 388: nvl(irc_ilp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

384: nvl(irc_ilp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute24, hr_api.g_varchar2) or
386: nvl(irc_ilp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute25, hr_api.g_varchar2) or
388: nvl(irc_ilp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute26, hr_api.g_varchar2) or
390: nvl(irc_ilp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute27, hr_api.g_varchar2) or
392: nvl(irc_ilp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 390: nvl(irc_ilp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

386: nvl(irc_ilp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute25, hr_api.g_varchar2) or
388: nvl(irc_ilp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute26, hr_api.g_varchar2) or
390: nvl(irc_ilp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute27, hr_api.g_varchar2) or
392: nvl(irc_ilp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute28, hr_api.g_varchar2) or
394: nvl(irc_ilp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 392: nvl(irc_ilp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

388: nvl(irc_ilp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute26, hr_api.g_varchar2) or
390: nvl(irc_ilp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute27, hr_api.g_varchar2) or
392: nvl(irc_ilp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute28, hr_api.g_varchar2) or
394: nvl(irc_ilp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute29, hr_api.g_varchar2) or
396: nvl(irc_ilp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 394: nvl(irc_ilp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

390: nvl(irc_ilp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute27, hr_api.g_varchar2) or
392: nvl(irc_ilp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute28, hr_api.g_varchar2) or
394: nvl(irc_ilp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute29, hr_api.g_varchar2) or
396: nvl(irc_ilp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
398: or (p_rec.location_pref_id is null) then

Line 396: nvl(irc_ilp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

392: nvl(irc_ilp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute28, hr_api.g_varchar2) or
394: nvl(irc_ilp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute29, hr_api.g_varchar2) or
396: nvl(irc_ilp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
398: or (p_rec.location_pref_id is null) then
399: --
400: -- Only execute the validation if absolutely necessary:

Line 504: ,p_rec in irc_ilp_shd.g_rec_type

500: -- {End Of Comments}
501: -- ----------------------------------------------------------------------------
502: Procedure chk_non_updateable_args
503: (p_effective_date in date
504: ,p_rec in irc_ilp_shd.g_rec_type
505: ) IS
506: --
507: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
508: --

Line 514: IF NOT irc_ilp_shd.api_updating

510: --
511: -- Only proceed with the validation if a row exists for the current
512: -- record in the HR Schema.
513: --
514: IF NOT irc_ilp_shd.api_updating
515: (p_location_pref_id => p_rec.location_pref_id
516: ,p_object_version_number => p_rec.object_version_number
517: ) THEN
518: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 534: ,p_rec in irc_ilp_shd.g_rec_type

530: -- |---------------------------< insert_validate >----------------------------|
531: -- ----------------------------------------------------------------------------
532: Procedure insert_validate
533: (p_effective_date in date
534: ,p_rec in irc_ilp_shd.g_rec_type
535: ) is
536: --
537: l_proc varchar2(72) := g_package||'insert_validate';
538: --

Line 562: ,p_associated_column1 => irc_ilp_shd.g_tab_nam

558: -- Validate Important Attributes
559: --
560: hr_api.validate_bus_grp_id
561: (p_business_group_id => p_rec.business_group_id
562: ,p_associated_column1 => irc_ilp_shd.g_tab_nam
563: || '.BUSINESS_GROUP_ID');
564: --
565: hr_utility.set_location('Entering:'||l_proc, 10);
566: --

Line 618: ,p_rec in irc_ilp_shd.g_rec_type

614: -- |---------------------------< update_validate >----------------------------|
615: -- ----------------------------------------------------------------------------
616: Procedure update_validate
617: (p_effective_date in date
618: ,p_rec in irc_ilp_shd.g_rec_type
619: ) is
620: --
621: l_proc varchar2(72) := g_package||'update_validate';
622: --

Line 645: ,p_associated_column1 => irc_ilp_shd.g_tab_nam

641: -- Remove this comment when the edit has been completed.
642: -- Validate Important Attributes
643: hr_api.validate_bus_grp_id
644: (p_business_group_id => p_rec.business_group_id
645: ,p_associated_column1 => irc_ilp_shd.g_tab_nam
646: || '.BUSINESS_GROUP_ID');
647: --
648: -- After validating the set of important attributes,
649: -- if Multiple Message detection is enabled and at least

Line 671: (p_rec in irc_ilp_shd.g_rec_type

667: -- ----------------------------------------------------------------------------
668: -- |---------------------------< delete_validate >----------------------------|
669: -- ----------------------------------------------------------------------------
670: Procedure delete_validate
671: (p_rec in irc_ilp_shd.g_rec_type
672: ) is
673: --
674: l_proc varchar2(72) := g_package||'delete_validate';
675: --