APPS.IRC_ILP_BUS dependencies on HR_API

Line 54: hr_api.mandatory_arg_error

50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc,10);
53: --
54: hr_api.mandatory_arg_error
55: (p_api_name => l_proc
56: ,p_argument => 'business_group_id'
57: ,p_argument_value => p_business_group_id
58: );

Line 123: hr_api.mandatory_arg_error

119: --
120: Begin
121: hr_utility.set_location('Entering:'||l_proc,10);
122: --
123: hr_api.mandatory_arg_error
124: (p_api_name => l_proc
125: ,p_argument => 'country_code'
126: ,p_argument_value => p_country_code
127: );

Line 192: hr_api.mandatory_arg_error

188: --
189: Begin
190: hr_utility.set_location('Entering:'||l_proc,10);
191: --
192: hr_api.mandatory_arg_error
193: (p_api_name => l_proc
194: ,p_argument => 'location_id'
195: ,p_argument_value => p_location_id
196: );

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 337: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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) <>
341: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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 339: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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) <>
343: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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 341: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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) <>
345: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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 343: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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) <>
347: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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 345: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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) <>
349: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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 347: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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) <>
351: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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 349: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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) <>
353: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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 351: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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) <>
355: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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 353: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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) <>
357: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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 355: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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) <>
359: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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 357: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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) <>
361: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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 359: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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) <>
363: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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 361: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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) <>
365: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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 363: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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) <>
367: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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 365: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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) <>
369: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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 367: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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) <>
371: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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 369: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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) <>
373: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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 371: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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) <>
375: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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 373: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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) <>
377: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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 375: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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) <>
379: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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 377: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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) <>
381: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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 379: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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) <>
383: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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 381: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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) <>
385: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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 383: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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) <>
387: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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 385: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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) <>
389: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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 387: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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) <>
391: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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 389: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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) <>
393: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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 391: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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) <>
395: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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 393: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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) <>
397: nvl(p_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 395: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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

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 397: nvl(p_rec.attribute30, 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:
401: -- a) During update, the structure column value or any

Line 544: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

540: hr_utility.set_location('Entering:'||l_proc, 5);
541: --
542: -- Call all supporting business operations
543: --
544: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id
545: -- will only be valid when the business_group_id is not null.
546: -- As this column is defined as optional on the table then
547: -- different logic will be required to handle the null case.
548: -- If this is a start-up data entity then:

Line 560: hr_api.validate_bus_grp_id

556: -- value is set in client_info.
557: -- Remove this comment when the edit has been completed.
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: --

Line 628: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

624: hr_utility.set_location('Entering:'||l_proc, 5);
625: --
626: -- Call all supporting business operations
627: --
628: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id
629: -- will only be valid when the business_group_id is not null.
630: -- As this column is defined as optional on the table then
631: -- different logic will be required to handle the null case.
632: -- If this is a start-up data entity then:

Line 643: hr_api.validate_bus_grp_id

639: -- or c) (less likely) ensure the correct security_group_id
640: -- value is set in client_info.
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: --