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.BEN_OTP_BUS dependencies on BEN_OTP_SHD

Line 55: l_api_updating := ben_otp_shd.api_updating

51: Begin
52: --
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: l_api_updating := ben_otp_shd.api_updating
56: (p_effective_date => p_effective_date,
57: p_optip_id => p_optip_id,
58: p_object_version_number => p_object_version_number);
59: --

Line 62: <> ben_otp_shd.g_old_rec.optip_id) then

58: p_object_version_number => p_object_version_number);
59: --
60: if (l_api_updating
61: and nvl(p_optip_id,hr_api.g_number)
62: <> ben_otp_shd.g_old_rec.optip_id) then
63: -- raise error as PK has changed
64: --
65: ben_otp_shd.constraint_error('BEN_OPTIP_F_PK');
66: --

Line 65: ben_otp_shd.constraint_error('BEN_OPTIP_F_PK');

61: and nvl(p_optip_id,hr_api.g_number)
62: <> ben_otp_shd.g_old_rec.optip_id) then
63: -- raise error as PK has changed
64: --
65: ben_otp_shd.constraint_error('BEN_OPTIP_F_PK');
66: --
67: elsif not l_api_updating then
68: --
69: -- check if PK is null

Line 75: ben_otp_shd.constraint_error('BEN_OPTIP_F_PK');

71: if p_optip_id is not null then
72: --
73: -- raise error as PK is not null
74: --
75: ben_otp_shd.constraint_error('BEN_OPTIP_F_PK');
76: --
77: end if;
78: --
79: end if;

Line 319: (p_rec in ben_otp_shd.g_rec_type

315: -- Internal Row Handler Use Only.
316: --
317: -- ----------------------------------------------------------------------------
318: procedure chk_df
319: (p_rec in ben_otp_shd.g_rec_type
320: ) is
321: --
322: l_proc varchar2(72) := g_package || 'chk_df';
323: --

Line 328: nvl(ben_otp_shd.g_old_rec.legislation_code, hr_api.g_varchar2) <>

324: begin
325: hr_utility.set_location('Entering:'||l_proc,10);
326: --
327: if ((p_rec.optip_id is not null) and (
328: nvl(ben_otp_shd.g_old_rec.legislation_code, hr_api.g_varchar2) <>
329: nvl(ben_otp_shd.g_old_rec.legislation_subgroup, hr_api.g_varchar2) <>
330: nvl(ben_otp_shd.g_old_rec.otp_attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.legislation_code, hr_api.g_varchar2) or
332: nvl(p_rec.legislation_subgroup, hr_api.g_varchar2) or

Line 329: nvl(ben_otp_shd.g_old_rec.legislation_subgroup, hr_api.g_varchar2) <>

325: hr_utility.set_location('Entering:'||l_proc,10);
326: --
327: if ((p_rec.optip_id is not null) and (
328: nvl(ben_otp_shd.g_old_rec.legislation_code, hr_api.g_varchar2) <>
329: nvl(ben_otp_shd.g_old_rec.legislation_subgroup, hr_api.g_varchar2) <>
330: nvl(ben_otp_shd.g_old_rec.otp_attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.legislation_code, hr_api.g_varchar2) or
332: nvl(p_rec.legislation_subgroup, hr_api.g_varchar2) or
333: nvl(p_rec.otp_attribute_category, hr_api.g_varchar2) or

Line 330: nvl(ben_otp_shd.g_old_rec.otp_attribute_category, hr_api.g_varchar2) <>

326: --
327: if ((p_rec.optip_id is not null) and (
328: nvl(ben_otp_shd.g_old_rec.legislation_code, hr_api.g_varchar2) <>
329: nvl(ben_otp_shd.g_old_rec.legislation_subgroup, hr_api.g_varchar2) <>
330: nvl(ben_otp_shd.g_old_rec.otp_attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.legislation_code, hr_api.g_varchar2) or
332: nvl(p_rec.legislation_subgroup, hr_api.g_varchar2) or
333: nvl(p_rec.otp_attribute_category, hr_api.g_varchar2) or
334: nvl(ben_otp_shd.g_old_rec.otp_attribute1, hr_api.g_varchar2) <>

Line 334: nvl(ben_otp_shd.g_old_rec.otp_attribute1, hr_api.g_varchar2) <>

330: nvl(ben_otp_shd.g_old_rec.otp_attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.legislation_code, hr_api.g_varchar2) or
332: nvl(p_rec.legislation_subgroup, hr_api.g_varchar2) or
333: nvl(p_rec.otp_attribute_category, hr_api.g_varchar2) or
334: nvl(ben_otp_shd.g_old_rec.otp_attribute1, hr_api.g_varchar2) <>
335: nvl(p_rec.otp_attribute1, hr_api.g_varchar2) or
336: nvl(ben_otp_shd.g_old_rec.otp_attribute2, hr_api.g_varchar2) <>
337: nvl(p_rec.otp_attribute2, hr_api.g_varchar2) or
338: nvl(ben_otp_shd.g_old_rec.otp_attribute3, hr_api.g_varchar2) <>

Line 336: nvl(ben_otp_shd.g_old_rec.otp_attribute2, hr_api.g_varchar2) <>

332: nvl(p_rec.legislation_subgroup, hr_api.g_varchar2) or
333: nvl(p_rec.otp_attribute_category, hr_api.g_varchar2) or
334: nvl(ben_otp_shd.g_old_rec.otp_attribute1, hr_api.g_varchar2) <>
335: nvl(p_rec.otp_attribute1, hr_api.g_varchar2) or
336: nvl(ben_otp_shd.g_old_rec.otp_attribute2, hr_api.g_varchar2) <>
337: nvl(p_rec.otp_attribute2, hr_api.g_varchar2) or
338: nvl(ben_otp_shd.g_old_rec.otp_attribute3, hr_api.g_varchar2) <>
339: nvl(p_rec.otp_attribute3, hr_api.g_varchar2) or
340: nvl(ben_otp_shd.g_old_rec.otp_attribute4, hr_api.g_varchar2) <>

Line 338: nvl(ben_otp_shd.g_old_rec.otp_attribute3, hr_api.g_varchar2) <>

334: nvl(ben_otp_shd.g_old_rec.otp_attribute1, hr_api.g_varchar2) <>
335: nvl(p_rec.otp_attribute1, hr_api.g_varchar2) or
336: nvl(ben_otp_shd.g_old_rec.otp_attribute2, hr_api.g_varchar2) <>
337: nvl(p_rec.otp_attribute2, hr_api.g_varchar2) or
338: nvl(ben_otp_shd.g_old_rec.otp_attribute3, hr_api.g_varchar2) <>
339: nvl(p_rec.otp_attribute3, hr_api.g_varchar2) or
340: nvl(ben_otp_shd.g_old_rec.otp_attribute4, hr_api.g_varchar2) <>
341: nvl(p_rec.otp_attribute4, hr_api.g_varchar2) or
342: nvl(ben_otp_shd.g_old_rec.otp_attribute5, hr_api.g_varchar2) <>

Line 340: nvl(ben_otp_shd.g_old_rec.otp_attribute4, hr_api.g_varchar2) <>

336: nvl(ben_otp_shd.g_old_rec.otp_attribute2, hr_api.g_varchar2) <>
337: nvl(p_rec.otp_attribute2, hr_api.g_varchar2) or
338: nvl(ben_otp_shd.g_old_rec.otp_attribute3, hr_api.g_varchar2) <>
339: nvl(p_rec.otp_attribute3, hr_api.g_varchar2) or
340: nvl(ben_otp_shd.g_old_rec.otp_attribute4, hr_api.g_varchar2) <>
341: nvl(p_rec.otp_attribute4, hr_api.g_varchar2) or
342: nvl(ben_otp_shd.g_old_rec.otp_attribute5, hr_api.g_varchar2) <>
343: nvl(p_rec.otp_attribute5, hr_api.g_varchar2) or
344: nvl(ben_otp_shd.g_old_rec.otp_attribute6, hr_api.g_varchar2) <>

Line 342: nvl(ben_otp_shd.g_old_rec.otp_attribute5, hr_api.g_varchar2) <>

338: nvl(ben_otp_shd.g_old_rec.otp_attribute3, hr_api.g_varchar2) <>
339: nvl(p_rec.otp_attribute3, hr_api.g_varchar2) or
340: nvl(ben_otp_shd.g_old_rec.otp_attribute4, hr_api.g_varchar2) <>
341: nvl(p_rec.otp_attribute4, hr_api.g_varchar2) or
342: nvl(ben_otp_shd.g_old_rec.otp_attribute5, hr_api.g_varchar2) <>
343: nvl(p_rec.otp_attribute5, hr_api.g_varchar2) or
344: nvl(ben_otp_shd.g_old_rec.otp_attribute6, hr_api.g_varchar2) <>
345: nvl(p_rec.otp_attribute6, hr_api.g_varchar2) or
346: nvl(ben_otp_shd.g_old_rec.otp_attribute7, hr_api.g_varchar2) <>

Line 344: nvl(ben_otp_shd.g_old_rec.otp_attribute6, hr_api.g_varchar2) <>

340: nvl(ben_otp_shd.g_old_rec.otp_attribute4, hr_api.g_varchar2) <>
341: nvl(p_rec.otp_attribute4, hr_api.g_varchar2) or
342: nvl(ben_otp_shd.g_old_rec.otp_attribute5, hr_api.g_varchar2) <>
343: nvl(p_rec.otp_attribute5, hr_api.g_varchar2) or
344: nvl(ben_otp_shd.g_old_rec.otp_attribute6, hr_api.g_varchar2) <>
345: nvl(p_rec.otp_attribute6, hr_api.g_varchar2) or
346: nvl(ben_otp_shd.g_old_rec.otp_attribute7, hr_api.g_varchar2) <>
347: nvl(p_rec.otp_attribute7, hr_api.g_varchar2) or
348: nvl(ben_otp_shd.g_old_rec.otp_attribute8, hr_api.g_varchar2) <>

Line 346: nvl(ben_otp_shd.g_old_rec.otp_attribute7, hr_api.g_varchar2) <>

342: nvl(ben_otp_shd.g_old_rec.otp_attribute5, hr_api.g_varchar2) <>
343: nvl(p_rec.otp_attribute5, hr_api.g_varchar2) or
344: nvl(ben_otp_shd.g_old_rec.otp_attribute6, hr_api.g_varchar2) <>
345: nvl(p_rec.otp_attribute6, hr_api.g_varchar2) or
346: nvl(ben_otp_shd.g_old_rec.otp_attribute7, hr_api.g_varchar2) <>
347: nvl(p_rec.otp_attribute7, hr_api.g_varchar2) or
348: nvl(ben_otp_shd.g_old_rec.otp_attribute8, hr_api.g_varchar2) <>
349: nvl(p_rec.otp_attribute8, hr_api.g_varchar2) or
350: nvl(ben_otp_shd.g_old_rec.otp_attribute9, hr_api.g_varchar2) <>

Line 348: nvl(ben_otp_shd.g_old_rec.otp_attribute8, hr_api.g_varchar2) <>

344: nvl(ben_otp_shd.g_old_rec.otp_attribute6, hr_api.g_varchar2) <>
345: nvl(p_rec.otp_attribute6, hr_api.g_varchar2) or
346: nvl(ben_otp_shd.g_old_rec.otp_attribute7, hr_api.g_varchar2) <>
347: nvl(p_rec.otp_attribute7, hr_api.g_varchar2) or
348: nvl(ben_otp_shd.g_old_rec.otp_attribute8, hr_api.g_varchar2) <>
349: nvl(p_rec.otp_attribute8, hr_api.g_varchar2) or
350: nvl(ben_otp_shd.g_old_rec.otp_attribute9, hr_api.g_varchar2) <>
351: nvl(p_rec.otp_attribute9, hr_api.g_varchar2) or
352: nvl(ben_otp_shd.g_old_rec.otp_attribute10, hr_api.g_varchar2) <>

Line 350: nvl(ben_otp_shd.g_old_rec.otp_attribute9, hr_api.g_varchar2) <>

346: nvl(ben_otp_shd.g_old_rec.otp_attribute7, hr_api.g_varchar2) <>
347: nvl(p_rec.otp_attribute7, hr_api.g_varchar2) or
348: nvl(ben_otp_shd.g_old_rec.otp_attribute8, hr_api.g_varchar2) <>
349: nvl(p_rec.otp_attribute8, hr_api.g_varchar2) or
350: nvl(ben_otp_shd.g_old_rec.otp_attribute9, hr_api.g_varchar2) <>
351: nvl(p_rec.otp_attribute9, hr_api.g_varchar2) or
352: nvl(ben_otp_shd.g_old_rec.otp_attribute10, hr_api.g_varchar2) <>
353: nvl(p_rec.otp_attribute10, hr_api.g_varchar2) or
354: nvl(ben_otp_shd.g_old_rec.otp_attribute11, hr_api.g_varchar2) <>

Line 352: nvl(ben_otp_shd.g_old_rec.otp_attribute10, hr_api.g_varchar2) <>

348: nvl(ben_otp_shd.g_old_rec.otp_attribute8, hr_api.g_varchar2) <>
349: nvl(p_rec.otp_attribute8, hr_api.g_varchar2) or
350: nvl(ben_otp_shd.g_old_rec.otp_attribute9, hr_api.g_varchar2) <>
351: nvl(p_rec.otp_attribute9, hr_api.g_varchar2) or
352: nvl(ben_otp_shd.g_old_rec.otp_attribute10, hr_api.g_varchar2) <>
353: nvl(p_rec.otp_attribute10, hr_api.g_varchar2) or
354: nvl(ben_otp_shd.g_old_rec.otp_attribute11, hr_api.g_varchar2) <>
355: nvl(p_rec.otp_attribute11, hr_api.g_varchar2) or
356: nvl(ben_otp_shd.g_old_rec.otp_attribute12, hr_api.g_varchar2) <>

Line 354: nvl(ben_otp_shd.g_old_rec.otp_attribute11, hr_api.g_varchar2) <>

350: nvl(ben_otp_shd.g_old_rec.otp_attribute9, hr_api.g_varchar2) <>
351: nvl(p_rec.otp_attribute9, hr_api.g_varchar2) or
352: nvl(ben_otp_shd.g_old_rec.otp_attribute10, hr_api.g_varchar2) <>
353: nvl(p_rec.otp_attribute10, hr_api.g_varchar2) or
354: nvl(ben_otp_shd.g_old_rec.otp_attribute11, hr_api.g_varchar2) <>
355: nvl(p_rec.otp_attribute11, hr_api.g_varchar2) or
356: nvl(ben_otp_shd.g_old_rec.otp_attribute12, hr_api.g_varchar2) <>
357: nvl(p_rec.otp_attribute12, hr_api.g_varchar2) or
358: nvl(ben_otp_shd.g_old_rec.otp_attribute13, hr_api.g_varchar2) <>

Line 356: nvl(ben_otp_shd.g_old_rec.otp_attribute12, hr_api.g_varchar2) <>

352: nvl(ben_otp_shd.g_old_rec.otp_attribute10, hr_api.g_varchar2) <>
353: nvl(p_rec.otp_attribute10, hr_api.g_varchar2) or
354: nvl(ben_otp_shd.g_old_rec.otp_attribute11, hr_api.g_varchar2) <>
355: nvl(p_rec.otp_attribute11, hr_api.g_varchar2) or
356: nvl(ben_otp_shd.g_old_rec.otp_attribute12, hr_api.g_varchar2) <>
357: nvl(p_rec.otp_attribute12, hr_api.g_varchar2) or
358: nvl(ben_otp_shd.g_old_rec.otp_attribute13, hr_api.g_varchar2) <>
359: nvl(p_rec.otp_attribute13, hr_api.g_varchar2) or
360: nvl(ben_otp_shd.g_old_rec.otp_attribute14, hr_api.g_varchar2) <>

Line 358: nvl(ben_otp_shd.g_old_rec.otp_attribute13, hr_api.g_varchar2) <>

354: nvl(ben_otp_shd.g_old_rec.otp_attribute11, hr_api.g_varchar2) <>
355: nvl(p_rec.otp_attribute11, hr_api.g_varchar2) or
356: nvl(ben_otp_shd.g_old_rec.otp_attribute12, hr_api.g_varchar2) <>
357: nvl(p_rec.otp_attribute12, hr_api.g_varchar2) or
358: nvl(ben_otp_shd.g_old_rec.otp_attribute13, hr_api.g_varchar2) <>
359: nvl(p_rec.otp_attribute13, hr_api.g_varchar2) or
360: nvl(ben_otp_shd.g_old_rec.otp_attribute14, hr_api.g_varchar2) <>
361: nvl(p_rec.otp_attribute14, hr_api.g_varchar2) or
362: nvl(ben_otp_shd.g_old_rec.otp_attribute15, hr_api.g_varchar2) <>

Line 360: nvl(ben_otp_shd.g_old_rec.otp_attribute14, hr_api.g_varchar2) <>

356: nvl(ben_otp_shd.g_old_rec.otp_attribute12, hr_api.g_varchar2) <>
357: nvl(p_rec.otp_attribute12, hr_api.g_varchar2) or
358: nvl(ben_otp_shd.g_old_rec.otp_attribute13, hr_api.g_varchar2) <>
359: nvl(p_rec.otp_attribute13, hr_api.g_varchar2) or
360: nvl(ben_otp_shd.g_old_rec.otp_attribute14, hr_api.g_varchar2) <>
361: nvl(p_rec.otp_attribute14, hr_api.g_varchar2) or
362: nvl(ben_otp_shd.g_old_rec.otp_attribute15, hr_api.g_varchar2) <>
363: nvl(p_rec.otp_attribute15, hr_api.g_varchar2) or
364: nvl(ben_otp_shd.g_old_rec.otp_attribute16, hr_api.g_varchar2) <>

Line 362: nvl(ben_otp_shd.g_old_rec.otp_attribute15, hr_api.g_varchar2) <>

358: nvl(ben_otp_shd.g_old_rec.otp_attribute13, hr_api.g_varchar2) <>
359: nvl(p_rec.otp_attribute13, hr_api.g_varchar2) or
360: nvl(ben_otp_shd.g_old_rec.otp_attribute14, hr_api.g_varchar2) <>
361: nvl(p_rec.otp_attribute14, hr_api.g_varchar2) or
362: nvl(ben_otp_shd.g_old_rec.otp_attribute15, hr_api.g_varchar2) <>
363: nvl(p_rec.otp_attribute15, hr_api.g_varchar2) or
364: nvl(ben_otp_shd.g_old_rec.otp_attribute16, hr_api.g_varchar2) <>
365: nvl(p_rec.otp_attribute16, hr_api.g_varchar2) or
366: nvl(ben_otp_shd.g_old_rec.otp_attribute17, hr_api.g_varchar2) <>

Line 364: nvl(ben_otp_shd.g_old_rec.otp_attribute16, hr_api.g_varchar2) <>

360: nvl(ben_otp_shd.g_old_rec.otp_attribute14, hr_api.g_varchar2) <>
361: nvl(p_rec.otp_attribute14, hr_api.g_varchar2) or
362: nvl(ben_otp_shd.g_old_rec.otp_attribute15, hr_api.g_varchar2) <>
363: nvl(p_rec.otp_attribute15, hr_api.g_varchar2) or
364: nvl(ben_otp_shd.g_old_rec.otp_attribute16, hr_api.g_varchar2) <>
365: nvl(p_rec.otp_attribute16, hr_api.g_varchar2) or
366: nvl(ben_otp_shd.g_old_rec.otp_attribute17, hr_api.g_varchar2) <>
367: nvl(p_rec.otp_attribute17, hr_api.g_varchar2) or
368: nvl(ben_otp_shd.g_old_rec.otp_attribute18, hr_api.g_varchar2) <>

Line 366: nvl(ben_otp_shd.g_old_rec.otp_attribute17, hr_api.g_varchar2) <>

362: nvl(ben_otp_shd.g_old_rec.otp_attribute15, hr_api.g_varchar2) <>
363: nvl(p_rec.otp_attribute15, hr_api.g_varchar2) or
364: nvl(ben_otp_shd.g_old_rec.otp_attribute16, hr_api.g_varchar2) <>
365: nvl(p_rec.otp_attribute16, hr_api.g_varchar2) or
366: nvl(ben_otp_shd.g_old_rec.otp_attribute17, hr_api.g_varchar2) <>
367: nvl(p_rec.otp_attribute17, hr_api.g_varchar2) or
368: nvl(ben_otp_shd.g_old_rec.otp_attribute18, hr_api.g_varchar2) <>
369: nvl(p_rec.otp_attribute18, hr_api.g_varchar2) or
370: nvl(ben_otp_shd.g_old_rec.otp_attribute19, hr_api.g_varchar2) <>

Line 368: nvl(ben_otp_shd.g_old_rec.otp_attribute18, hr_api.g_varchar2) <>

364: nvl(ben_otp_shd.g_old_rec.otp_attribute16, hr_api.g_varchar2) <>
365: nvl(p_rec.otp_attribute16, hr_api.g_varchar2) or
366: nvl(ben_otp_shd.g_old_rec.otp_attribute17, hr_api.g_varchar2) <>
367: nvl(p_rec.otp_attribute17, hr_api.g_varchar2) or
368: nvl(ben_otp_shd.g_old_rec.otp_attribute18, hr_api.g_varchar2) <>
369: nvl(p_rec.otp_attribute18, hr_api.g_varchar2) or
370: nvl(ben_otp_shd.g_old_rec.otp_attribute19, hr_api.g_varchar2) <>
371: nvl(p_rec.otp_attribute19, hr_api.g_varchar2) or
372: nvl(ben_otp_shd.g_old_rec.otp_attribute20, hr_api.g_varchar2) <>

Line 370: nvl(ben_otp_shd.g_old_rec.otp_attribute19, hr_api.g_varchar2) <>

366: nvl(ben_otp_shd.g_old_rec.otp_attribute17, hr_api.g_varchar2) <>
367: nvl(p_rec.otp_attribute17, hr_api.g_varchar2) or
368: nvl(ben_otp_shd.g_old_rec.otp_attribute18, hr_api.g_varchar2) <>
369: nvl(p_rec.otp_attribute18, hr_api.g_varchar2) or
370: nvl(ben_otp_shd.g_old_rec.otp_attribute19, hr_api.g_varchar2) <>
371: nvl(p_rec.otp_attribute19, hr_api.g_varchar2) or
372: nvl(ben_otp_shd.g_old_rec.otp_attribute20, hr_api.g_varchar2) <>
373: nvl(p_rec.otp_attribute20, hr_api.g_varchar2) or
374: nvl(ben_otp_shd.g_old_rec.otp_attribute21, hr_api.g_varchar2) <>

Line 372: nvl(ben_otp_shd.g_old_rec.otp_attribute20, hr_api.g_varchar2) <>

368: nvl(ben_otp_shd.g_old_rec.otp_attribute18, hr_api.g_varchar2) <>
369: nvl(p_rec.otp_attribute18, hr_api.g_varchar2) or
370: nvl(ben_otp_shd.g_old_rec.otp_attribute19, hr_api.g_varchar2) <>
371: nvl(p_rec.otp_attribute19, hr_api.g_varchar2) or
372: nvl(ben_otp_shd.g_old_rec.otp_attribute20, hr_api.g_varchar2) <>
373: nvl(p_rec.otp_attribute20, hr_api.g_varchar2) or
374: nvl(ben_otp_shd.g_old_rec.otp_attribute21, hr_api.g_varchar2) <>
375: nvl(p_rec.otp_attribute21, hr_api.g_varchar2) or
376: nvl(ben_otp_shd.g_old_rec.otp_attribute22, hr_api.g_varchar2) <>

Line 374: nvl(ben_otp_shd.g_old_rec.otp_attribute21, hr_api.g_varchar2) <>

370: nvl(ben_otp_shd.g_old_rec.otp_attribute19, hr_api.g_varchar2) <>
371: nvl(p_rec.otp_attribute19, hr_api.g_varchar2) or
372: nvl(ben_otp_shd.g_old_rec.otp_attribute20, hr_api.g_varchar2) <>
373: nvl(p_rec.otp_attribute20, hr_api.g_varchar2) or
374: nvl(ben_otp_shd.g_old_rec.otp_attribute21, hr_api.g_varchar2) <>
375: nvl(p_rec.otp_attribute21, hr_api.g_varchar2) or
376: nvl(ben_otp_shd.g_old_rec.otp_attribute22, hr_api.g_varchar2) <>
377: nvl(p_rec.otp_attribute22, hr_api.g_varchar2) or
378: nvl(ben_otp_shd.g_old_rec.otp_attribute23, hr_api.g_varchar2) <>

Line 376: nvl(ben_otp_shd.g_old_rec.otp_attribute22, hr_api.g_varchar2) <>

372: nvl(ben_otp_shd.g_old_rec.otp_attribute20, hr_api.g_varchar2) <>
373: nvl(p_rec.otp_attribute20, hr_api.g_varchar2) or
374: nvl(ben_otp_shd.g_old_rec.otp_attribute21, hr_api.g_varchar2) <>
375: nvl(p_rec.otp_attribute21, hr_api.g_varchar2) or
376: nvl(ben_otp_shd.g_old_rec.otp_attribute22, hr_api.g_varchar2) <>
377: nvl(p_rec.otp_attribute22, hr_api.g_varchar2) or
378: nvl(ben_otp_shd.g_old_rec.otp_attribute23, hr_api.g_varchar2) <>
379: nvl(p_rec.otp_attribute23, hr_api.g_varchar2) or
380: nvl(ben_otp_shd.g_old_rec.otp_attribute24, hr_api.g_varchar2) <>

Line 378: nvl(ben_otp_shd.g_old_rec.otp_attribute23, hr_api.g_varchar2) <>

374: nvl(ben_otp_shd.g_old_rec.otp_attribute21, hr_api.g_varchar2) <>
375: nvl(p_rec.otp_attribute21, hr_api.g_varchar2) or
376: nvl(ben_otp_shd.g_old_rec.otp_attribute22, hr_api.g_varchar2) <>
377: nvl(p_rec.otp_attribute22, hr_api.g_varchar2) or
378: nvl(ben_otp_shd.g_old_rec.otp_attribute23, hr_api.g_varchar2) <>
379: nvl(p_rec.otp_attribute23, hr_api.g_varchar2) or
380: nvl(ben_otp_shd.g_old_rec.otp_attribute24, hr_api.g_varchar2) <>
381: nvl(p_rec.otp_attribute24, hr_api.g_varchar2) or
382: nvl(ben_otp_shd.g_old_rec.otp_attribute25, hr_api.g_varchar2) <>

Line 380: nvl(ben_otp_shd.g_old_rec.otp_attribute24, hr_api.g_varchar2) <>

376: nvl(ben_otp_shd.g_old_rec.otp_attribute22, hr_api.g_varchar2) <>
377: nvl(p_rec.otp_attribute22, hr_api.g_varchar2) or
378: nvl(ben_otp_shd.g_old_rec.otp_attribute23, hr_api.g_varchar2) <>
379: nvl(p_rec.otp_attribute23, hr_api.g_varchar2) or
380: nvl(ben_otp_shd.g_old_rec.otp_attribute24, hr_api.g_varchar2) <>
381: nvl(p_rec.otp_attribute24, hr_api.g_varchar2) or
382: nvl(ben_otp_shd.g_old_rec.otp_attribute25, hr_api.g_varchar2) <>
383: nvl(p_rec.otp_attribute25, hr_api.g_varchar2) or
384: nvl(ben_otp_shd.g_old_rec.otp_attribute26, hr_api.g_varchar2) <>

Line 382: nvl(ben_otp_shd.g_old_rec.otp_attribute25, hr_api.g_varchar2) <>

378: nvl(ben_otp_shd.g_old_rec.otp_attribute23, hr_api.g_varchar2) <>
379: nvl(p_rec.otp_attribute23, hr_api.g_varchar2) or
380: nvl(ben_otp_shd.g_old_rec.otp_attribute24, hr_api.g_varchar2) <>
381: nvl(p_rec.otp_attribute24, hr_api.g_varchar2) or
382: nvl(ben_otp_shd.g_old_rec.otp_attribute25, hr_api.g_varchar2) <>
383: nvl(p_rec.otp_attribute25, hr_api.g_varchar2) or
384: nvl(ben_otp_shd.g_old_rec.otp_attribute26, hr_api.g_varchar2) <>
385: nvl(p_rec.otp_attribute26, hr_api.g_varchar2) or
386: nvl(ben_otp_shd.g_old_rec.otp_attribute27, hr_api.g_varchar2) <>

Line 384: nvl(ben_otp_shd.g_old_rec.otp_attribute26, hr_api.g_varchar2) <>

380: nvl(ben_otp_shd.g_old_rec.otp_attribute24, hr_api.g_varchar2) <>
381: nvl(p_rec.otp_attribute24, hr_api.g_varchar2) or
382: nvl(ben_otp_shd.g_old_rec.otp_attribute25, hr_api.g_varchar2) <>
383: nvl(p_rec.otp_attribute25, hr_api.g_varchar2) or
384: nvl(ben_otp_shd.g_old_rec.otp_attribute26, hr_api.g_varchar2) <>
385: nvl(p_rec.otp_attribute26, hr_api.g_varchar2) or
386: nvl(ben_otp_shd.g_old_rec.otp_attribute27, hr_api.g_varchar2) <>
387: nvl(p_rec.otp_attribute27, hr_api.g_varchar2) or
388: nvl(ben_otp_shd.g_old_rec.otp_attribute28, hr_api.g_varchar2) <>

Line 386: nvl(ben_otp_shd.g_old_rec.otp_attribute27, hr_api.g_varchar2) <>

382: nvl(ben_otp_shd.g_old_rec.otp_attribute25, hr_api.g_varchar2) <>
383: nvl(p_rec.otp_attribute25, hr_api.g_varchar2) or
384: nvl(ben_otp_shd.g_old_rec.otp_attribute26, hr_api.g_varchar2) <>
385: nvl(p_rec.otp_attribute26, hr_api.g_varchar2) or
386: nvl(ben_otp_shd.g_old_rec.otp_attribute27, hr_api.g_varchar2) <>
387: nvl(p_rec.otp_attribute27, hr_api.g_varchar2) or
388: nvl(ben_otp_shd.g_old_rec.otp_attribute28, hr_api.g_varchar2) <>
389: nvl(p_rec.otp_attribute28, hr_api.g_varchar2) or
390: nvl(ben_otp_shd.g_old_rec.otp_attribute29, hr_api.g_varchar2) <>

Line 388: nvl(ben_otp_shd.g_old_rec.otp_attribute28, hr_api.g_varchar2) <>

384: nvl(ben_otp_shd.g_old_rec.otp_attribute26, hr_api.g_varchar2) <>
385: nvl(p_rec.otp_attribute26, hr_api.g_varchar2) or
386: nvl(ben_otp_shd.g_old_rec.otp_attribute27, hr_api.g_varchar2) <>
387: nvl(p_rec.otp_attribute27, hr_api.g_varchar2) or
388: nvl(ben_otp_shd.g_old_rec.otp_attribute28, hr_api.g_varchar2) <>
389: nvl(p_rec.otp_attribute28, hr_api.g_varchar2) or
390: nvl(ben_otp_shd.g_old_rec.otp_attribute29, hr_api.g_varchar2) <>
391: nvl(p_rec.otp_attribute29, hr_api.g_varchar2) or
392: nvl(ben_otp_shd.g_old_rec.otp_attribute30, hr_api.g_varchar2) <>

Line 390: nvl(ben_otp_shd.g_old_rec.otp_attribute29, hr_api.g_varchar2) <>

386: nvl(ben_otp_shd.g_old_rec.otp_attribute27, hr_api.g_varchar2) <>
387: nvl(p_rec.otp_attribute27, hr_api.g_varchar2) or
388: nvl(ben_otp_shd.g_old_rec.otp_attribute28, hr_api.g_varchar2) <>
389: nvl(p_rec.otp_attribute28, hr_api.g_varchar2) or
390: nvl(ben_otp_shd.g_old_rec.otp_attribute29, hr_api.g_varchar2) <>
391: nvl(p_rec.otp_attribute29, hr_api.g_varchar2) or
392: nvl(ben_otp_shd.g_old_rec.otp_attribute30, hr_api.g_varchar2) <>
393: nvl(p_rec.otp_attribute30, hr_api.g_varchar2) ))
394: or (p_rec.optip_idis null) then

Line 392: nvl(ben_otp_shd.g_old_rec.otp_attribute30, hr_api.g_varchar2) <>

388: nvl(ben_otp_shd.g_old_rec.otp_attribute28, hr_api.g_varchar2) <>
389: nvl(p_rec.otp_attribute28, hr_api.g_varchar2) or
390: nvl(ben_otp_shd.g_old_rec.otp_attribute29, hr_api.g_varchar2) <>
391: nvl(p_rec.otp_attribute29, hr_api.g_varchar2) or
392: nvl(ben_otp_shd.g_old_rec.otp_attribute30, hr_api.g_varchar2) <>
393: nvl(p_rec.otp_attribute30, hr_api.g_varchar2) ))
394: or (p_rec.optip_idis null) then
395: --
396: -- Only execute the validation if absolutely necessary:

Line 504: ,p_rec in ben_otp_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 ben_otp_shd.g_rec_type
505: ) IS
506: --
507: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
508: l_error EXCEPTION;

Line 516: IF NOT ben_otp_shd.api_updating

512: --
513: -- Only proceed with the validation if a row exists for the current
514: -- record in the HR Schema.
515: --
516: IF NOT ben_otp_shd.api_updating
517: (p_optip_id => p_rec.optip_id
518: ,p_effective_date => p_effective_date
519: ,p_object_version_number => p_rec.object_version_number
520: ) THEN

Line 771: (p_rec in ben_otp_shd.g_rec_type

767: -- ----------------------------------------------------------------------------
768: -- |---------------------------< insert_validate >----------------------------|
769: -- ----------------------------------------------------------------------------
770: Procedure insert_validate
771: (p_rec in ben_otp_shd.g_rec_type
772: ,p_effective_date in date
773: ,p_datetrack_mode in varchar2
774: ,p_validation_start_date in date
775: ,p_validation_end_date in date

Line 810: (p_rec in ben_otp_shd.g_rec_type

806: -- ----------------------------------------------------------------------------
807: -- |---------------------------< update_validate >----------------------------|
808: -- ----------------------------------------------------------------------------
809: Procedure update_validate
810: (p_rec in ben_otp_shd.g_rec_type
811: ,p_effective_date in date
812: ,p_datetrack_mode in varchar2
813: ,p_validation_start_date in date
814: ,p_validation_end_date in date

Line 861: (p_rec in ben_otp_shd.g_rec_type

857: -- ----------------------------------------------------------------------------
858: -- |---------------------------< delete_validate >----------------------------|
859: -- ----------------------------------------------------------------------------
860: Procedure delete_validate
861: (p_rec in ben_otp_shd.g_rec_type
862: ,p_effective_date in date
863: ,p_datetrack_mode in varchar2
864: ,p_validation_start_date in date
865: ,p_validation_end_date in date