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 HR_API

Line 61: and nvl(p_optip_id,hr_api.g_number)

57: p_optip_id => p_optip_id,
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');

Line 178: hr_api.mandatory_arg_error

174: hr_utility.set_location('Entering:'|| l_proc, 10);
175: --
176: -- Ensure that all the mandatory parameter are not null
177: --
178: hr_api.mandatory_arg_error
179: (p_api_name => l_proc
180: ,p_argument => 'optip_id'
181: ,p_argument_value => p_optip_id
182: );

Line 201: hr_api.set_security_group_id

197: close csr_sec_grp;
198: --
199: -- Set the security_group_id in CLIENT_INFO
200: --
201: hr_api.set_security_group_id
202: (p_security_group_id => l_security_group_id
203: );
204: --
205: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 240: hr_api.mandatory_arg_error

236: hr_utility.set_location('Entering:'|| l_proc, 10);
237: --
238: -- Ensure that all the mandatory parameter are not null
239: --
240: hr_api.mandatory_arg_error
241: (p_api_name => l_proc
242: ,p_argument => 'optip_id'
243: ,p_argument_value => p_optip_id
244: );

Line 246: if ( nvl(ben_otp_bus.g_optip_id, hr_api.g_number)

242: ,p_argument => 'optip_id'
243: ,p_argument_value => p_optip_id
244: );
245: --
246: if ( nvl(ben_otp_bus.g_optip_id, hr_api.g_number)
247: = p_optip_id) then
248: --
249: -- The legislation code has already been found with a previous
250: -- call to this function. Just return the value in the global

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

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

Line 332: nvl(p_rec.legislation_subgroup, hr_api.g_varchar2) or

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

Line 333: nvl(p_rec.otp_attribute_category, hr_api.g_varchar2) or

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 532: hr_api.argument_changed_error

528: -- not been updated.
529: --
530: EXCEPTION
531: WHEN l_error THEN
532: hr_api.argument_changed_error
533: (p_api_name => l_proc
534: ,p_argument => l_argument);
535: WHEN OTHERS THEN
536: RAISE;

Line 570: (p_pgm_id in number default hr_api.g_number

566: --
567: -- {End Of Comments}
568: -- ----------------------------------------------------------------------------
569: Procedure dt_update_validate
570: (p_pgm_id in number default hr_api.g_number
571: ,p_ptip_id in number default hr_api.g_number
572: ,p_opt_id in number default hr_api.g_number
573: ,p_datetrack_mode in varchar2
574: ,p_validation_start_date in date

Line 571: ,p_ptip_id in number default hr_api.g_number

567: -- {End Of Comments}
568: -- ----------------------------------------------------------------------------
569: Procedure dt_update_validate
570: (p_pgm_id in number default hr_api.g_number
571: ,p_ptip_id in number default hr_api.g_number
572: ,p_opt_id in number default hr_api.g_number
573: ,p_datetrack_mode in varchar2
574: ,p_validation_start_date in date
575: ,p_validation_end_date in date

Line 572: ,p_opt_id in number default hr_api.g_number

568: -- ----------------------------------------------------------------------------
569: Procedure dt_update_validate
570: (p_pgm_id in number default hr_api.g_number
571: ,p_ptip_id in number default hr_api.g_number
572: ,p_opt_id in number default hr_api.g_number
573: ,p_datetrack_mode in varchar2
574: ,p_validation_start_date in date
575: ,p_validation_end_date in date
576: ) Is

Line 586: hr_api.mandatory_arg_error

582: Begin
583: --
584: -- Ensure that the p_datetrack_mode argument is not null
585: --
586: hr_api.mandatory_arg_error
587: (p_api_name => l_proc
588: ,p_argument => 'datetrack_mode'
589: ,p_argument_value => p_datetrack_mode
590: );

Line 596: hr_api.mandatory_arg_error

592: -- Mode will be valid, as this is checked at the start of the upd.
593: --
594: -- Ensure the arguments are not null
595: --
596: hr_api.mandatory_arg_error
597: (p_api_name => l_proc
598: ,p_argument => 'validation_start_date'
599: ,p_argument_value => p_validation_start_date
600: );

Line 602: hr_api.mandatory_arg_error

598: ,p_argument => 'validation_start_date'
599: ,p_argument_value => p_validation_start_date
600: );
601: --
602: hr_api.mandatory_arg_error
603: (p_api_name => l_proc
604: ,p_argument => 'validation_end_date'
605: ,p_argument_value => p_validation_end_date
606: );

Line 608: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

604: ,p_argument => 'validation_end_date'
605: ,p_argument_value => p_validation_end_date
606: );
607: --
608: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
609: NOT (dt_api.check_min_max_dates
610: (p_base_table_name => 'ben_pgm_f'
611: ,p_base_key_column => 'PGM_ID'
612: ,p_base_key_value => p_pgm_id

Line 618: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

614: ,p_to_date => p_validation_end_date))) Then
615: l_table_name := 'pgm';
616: raise l_integrity_error;
617: End If;
618: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
619: NOT (dt_api.check_min_max_dates
620: (p_base_table_name => 'ben_ptip_f'
621: ,p_base_key_column => 'PTIP_ID'
622: ,p_base_key_value => p_ptip_id

Line 628: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and

624: ,p_to_date => p_validation_end_date))) Then
625: l_table_name := 'ptip';
626: raise l_integrity_error;
627: End If;
628: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
629: NOT (dt_api.check_min_max_dates
630: (p_base_table_name => 'ben_opt_f'
631: ,p_base_key_column => 'OPT_ID'
632: ,p_base_key_value => p_opt_id

Line 709: hr_api.mandatory_arg_error

705: Begin
706: --
707: -- Ensure that the p_datetrack_mode argument is not null
708: --
709: hr_api.mandatory_arg_error
710: (p_api_name => l_proc
711: ,p_argument => 'datetrack_mode'
712: ,p_argument_value => p_datetrack_mode
713: );

Line 718: If (p_datetrack_mode = hr_api.g_delete or

714: --
715: -- Only perform the validation if the datetrack mode is either
716: -- DELETE or ZAP
717: --
718: If (p_datetrack_mode = hr_api.g_delete or
719: p_datetrack_mode = hr_api.g_zap) then
720: --
721: --
722: -- Ensure the arguments are not null

Line 719: p_datetrack_mode = hr_api.g_zap) then

715: -- Only perform the validation if the datetrack mode is either
716: -- DELETE or ZAP
717: --
718: If (p_datetrack_mode = hr_api.g_delete or
719: p_datetrack_mode = hr_api.g_zap) then
720: --
721: --
722: -- Ensure the arguments are not null
723: --

Line 724: hr_api.mandatory_arg_error

720: --
721: --
722: -- Ensure the arguments are not null
723: --
724: hr_api.mandatory_arg_error
725: (p_api_name => l_proc
726: ,p_argument => 'validation_start_date'
727: ,p_argument_value => p_validation_start_date
728: );

Line 730: hr_api.mandatory_arg_error

726: ,p_argument => 'validation_start_date'
727: ,p_argument_value => p_validation_start_date
728: );
729: --
730: hr_api.mandatory_arg_error
731: (p_api_name => l_proc
732: ,p_argument => 'validation_end_date'
733: ,p_argument_value => p_validation_end_date
734: );

Line 736: hr_api.mandatory_arg_error

732: ,p_argument => 'validation_end_date'
733: ,p_argument_value => p_validation_end_date
734: );
735: --
736: hr_api.mandatory_arg_error
737: (p_api_name => l_proc
738: ,p_argument => 'optip_id'
739: ,p_argument_value => p_optip_id
740: );

Line 786: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

782: --
783: -- Call all supporting business operations
784: --
785: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
786: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
787: end if;
788: --
789: --
790: --ben_otp_bus.chk_df(p_rec);

Line 825: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

821: --
822: -- Call all supporting business operations
823: --
824: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
825: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
826: end if;
827: --
828: chk_optip_id
829: (p_optip_id => p_rec.optip_id,