APPS.BEN_JRT_BUS dependencies on HR_API

Line 60: and nvl(p_job_rt_id,hr_api.g_number)

56: p_job_rt_id => p_job_rt_id,
57: p_object_version_number => p_object_version_number);
58: --
59: if (l_api_updating
60: and nvl(p_job_rt_id,hr_api.g_number)
61: <> ben_jrt_shd.g_old_rec.job_rt_id) then
62: --
63: -- raise error as PK has changed
64: --

Line 140: and vrbl_rt_prfl_id <> nvl(p_job_rt_id,hr_api.g_number)

136: select null
137: from ben_job_rt_f
138: where job_id = p_job_id
139: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
140: and vrbl_rt_prfl_id <> nvl(p_job_rt_id,hr_api.g_number)
141: and business_group_id + 0 = p_business_group_id
142: and p_validation_start_date <= effective_end_date
143: and p_validation_end_date >= effective_start_date;
144: --

Line 156: and nvl(p_job_id,hr_api.g_number)

152: p_effective_date => p_effective_date,
153: p_object_version_number => p_object_version_number);
154: --
155: if (l_api_updating
156: and nvl(p_job_id,hr_api.g_number)
157: <> nvl(ben_jrt_shd.g_old_rec.job_id,hr_api.g_number)
158: or not l_api_updating) then
159: --
160: -- check if job_id value exists in per_jobs table

Line 157: <> nvl(ben_jrt_shd.g_old_rec.job_id,hr_api.g_number)

153: p_object_version_number => p_object_version_number);
154: --
155: if (l_api_updating
156: and nvl(p_job_id,hr_api.g_number)
157: <> nvl(ben_jrt_shd.g_old_rec.job_id,hr_api.g_number)
158: or not l_api_updating) then
159: --
160: -- check if job_id value exists in per_jobs table
161: --

Line 245: <> nvl(ben_jrt_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

241: p_object_version_number => p_object_version_number);
242: --
243: if (l_api_updating
244: and p_excld_flag
245: <> nvl(ben_jrt_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
246: or not l_api_updating) then
247: --
248: -- check if value of lookup falls within lookup type.
249: --

Line 251: if hr_api.not_exists_in_hr_lookups

247: --
248: -- check if value of lookup falls within lookup type.
249: --
250: --
251: if hr_api.not_exists_in_hr_lookups
252: (p_lookup_type => 'YES_NO',
253: p_lookup_code => p_excld_flag,
254: p_effective_date => p_effective_date) then
255: --

Line 298: hr_api.mandatory_arg_error

294: hr_utility.set_location('Entering:'|| l_proc, 10);
295: --
296: -- Ensure that all the mandatory parameter are not null
297: --
298: hr_api.mandatory_arg_error
299: (p_api_name => l_proc
300: ,p_argument => 'job_rt_id'
301: ,p_argument_value => p_job_rt_id
302: );

Line 324: hr_api.set_security_group_id

320: close csr_sec_grp;
321: --
322: -- Set the security_group_id in CLIENT_INFO
323: --
324: hr_api.set_security_group_id
325: (p_security_group_id => l_security_group_id
326: );
327: end if;
328: --

Line 362: hr_api.mandatory_arg_error

358: hr_utility.set_location('Entering:'|| l_proc, 10);
359: --
360: -- Ensure that all the mandatory parameter are not null
361: --
362: hr_api.mandatory_arg_error
363: (p_api_name => l_proc
364: ,p_argument => 'job_rt_id'
365: ,p_argument_value => p_job_rt_id
366: );

Line 368: if ( nvl(ben_jrt_bus.g_job_rt_id, hr_api.g_number)

364: ,p_argument => 'job_rt_id'
365: ,p_argument_value => p_job_rt_id
366: );
367: --
368: if ( nvl(ben_jrt_bus.g_job_rt_id, hr_api.g_number)
369: = p_job_rt_id) then
370: --
371: -- The legislation code has already been found with a previous
372: -- call to this function. Just return the value in the global

Line 444: nvl(ben_jrt_shd.g_old_rec.jrt_attribute_category, hr_api.g_varchar2) <>

440: begin
441: hr_utility.set_location('Entering:'||l_proc,10);
442: --
443: if ((p_rec.job_rt_id is not null) and (
444: nvl(ben_jrt_shd.g_old_rec.jrt_attribute_category, hr_api.g_varchar2) <>
445: nvl(p_rec.jrt_attribute_category, hr_api.g_varchar2) or
446: nvl(ben_jrt_shd.g_old_rec.jrt_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.jrt_attribute1, hr_api.g_varchar2) or
448: nvl(ben_jrt_shd.g_old_rec.jrt_attribute2, hr_api.g_varchar2) <>

Line 445: nvl(p_rec.jrt_attribute_category, hr_api.g_varchar2) or

441: hr_utility.set_location('Entering:'||l_proc,10);
442: --
443: if ((p_rec.job_rt_id is not null) and (
444: nvl(ben_jrt_shd.g_old_rec.jrt_attribute_category, hr_api.g_varchar2) <>
445: nvl(p_rec.jrt_attribute_category, hr_api.g_varchar2) or
446: nvl(ben_jrt_shd.g_old_rec.jrt_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.jrt_attribute1, hr_api.g_varchar2) or
448: nvl(ben_jrt_shd.g_old_rec.jrt_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.jrt_attribute2, hr_api.g_varchar2) or

Line 446: nvl(ben_jrt_shd.g_old_rec.jrt_attribute1, hr_api.g_varchar2) <>

442: --
443: if ((p_rec.job_rt_id is not null) and (
444: nvl(ben_jrt_shd.g_old_rec.jrt_attribute_category, hr_api.g_varchar2) <>
445: nvl(p_rec.jrt_attribute_category, hr_api.g_varchar2) or
446: nvl(ben_jrt_shd.g_old_rec.jrt_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.jrt_attribute1, hr_api.g_varchar2) or
448: nvl(ben_jrt_shd.g_old_rec.jrt_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.jrt_attribute2, hr_api.g_varchar2) or
450: nvl(ben_jrt_shd.g_old_rec.jrt_attribute3, hr_api.g_varchar2) <>

Line 447: nvl(p_rec.jrt_attribute1, hr_api.g_varchar2) or

443: if ((p_rec.job_rt_id is not null) and (
444: nvl(ben_jrt_shd.g_old_rec.jrt_attribute_category, hr_api.g_varchar2) <>
445: nvl(p_rec.jrt_attribute_category, hr_api.g_varchar2) or
446: nvl(ben_jrt_shd.g_old_rec.jrt_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.jrt_attribute1, hr_api.g_varchar2) or
448: nvl(ben_jrt_shd.g_old_rec.jrt_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.jrt_attribute2, hr_api.g_varchar2) or
450: nvl(ben_jrt_shd.g_old_rec.jrt_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.jrt_attribute3, hr_api.g_varchar2) or

Line 448: nvl(ben_jrt_shd.g_old_rec.jrt_attribute2, hr_api.g_varchar2) <>

444: nvl(ben_jrt_shd.g_old_rec.jrt_attribute_category, hr_api.g_varchar2) <>
445: nvl(p_rec.jrt_attribute_category, hr_api.g_varchar2) or
446: nvl(ben_jrt_shd.g_old_rec.jrt_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.jrt_attribute1, hr_api.g_varchar2) or
448: nvl(ben_jrt_shd.g_old_rec.jrt_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.jrt_attribute2, hr_api.g_varchar2) or
450: nvl(ben_jrt_shd.g_old_rec.jrt_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.jrt_attribute3, hr_api.g_varchar2) or
452: nvl(ben_jrt_shd.g_old_rec.jrt_attribute4, hr_api.g_varchar2) <>

Line 449: nvl(p_rec.jrt_attribute2, hr_api.g_varchar2) or

445: nvl(p_rec.jrt_attribute_category, hr_api.g_varchar2) or
446: nvl(ben_jrt_shd.g_old_rec.jrt_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.jrt_attribute1, hr_api.g_varchar2) or
448: nvl(ben_jrt_shd.g_old_rec.jrt_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.jrt_attribute2, hr_api.g_varchar2) or
450: nvl(ben_jrt_shd.g_old_rec.jrt_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.jrt_attribute3, hr_api.g_varchar2) or
452: nvl(ben_jrt_shd.g_old_rec.jrt_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.jrt_attribute4, hr_api.g_varchar2) or

Line 450: nvl(ben_jrt_shd.g_old_rec.jrt_attribute3, hr_api.g_varchar2) <>

446: nvl(ben_jrt_shd.g_old_rec.jrt_attribute1, hr_api.g_varchar2) <>
447: nvl(p_rec.jrt_attribute1, hr_api.g_varchar2) or
448: nvl(ben_jrt_shd.g_old_rec.jrt_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.jrt_attribute2, hr_api.g_varchar2) or
450: nvl(ben_jrt_shd.g_old_rec.jrt_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.jrt_attribute3, hr_api.g_varchar2) or
452: nvl(ben_jrt_shd.g_old_rec.jrt_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.jrt_attribute4, hr_api.g_varchar2) or
454: nvl(ben_jrt_shd.g_old_rec.jrt_attribute5, hr_api.g_varchar2) <>

Line 451: nvl(p_rec.jrt_attribute3, hr_api.g_varchar2) or

447: nvl(p_rec.jrt_attribute1, hr_api.g_varchar2) or
448: nvl(ben_jrt_shd.g_old_rec.jrt_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.jrt_attribute2, hr_api.g_varchar2) or
450: nvl(ben_jrt_shd.g_old_rec.jrt_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.jrt_attribute3, hr_api.g_varchar2) or
452: nvl(ben_jrt_shd.g_old_rec.jrt_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.jrt_attribute4, hr_api.g_varchar2) or
454: nvl(ben_jrt_shd.g_old_rec.jrt_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.jrt_attribute5, hr_api.g_varchar2) or

Line 452: nvl(ben_jrt_shd.g_old_rec.jrt_attribute4, hr_api.g_varchar2) <>

448: nvl(ben_jrt_shd.g_old_rec.jrt_attribute2, hr_api.g_varchar2) <>
449: nvl(p_rec.jrt_attribute2, hr_api.g_varchar2) or
450: nvl(ben_jrt_shd.g_old_rec.jrt_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.jrt_attribute3, hr_api.g_varchar2) or
452: nvl(ben_jrt_shd.g_old_rec.jrt_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.jrt_attribute4, hr_api.g_varchar2) or
454: nvl(ben_jrt_shd.g_old_rec.jrt_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.jrt_attribute5, hr_api.g_varchar2) or
456: nvl(ben_jrt_shd.g_old_rec.jrt_attribute6, hr_api.g_varchar2) <>

Line 453: nvl(p_rec.jrt_attribute4, hr_api.g_varchar2) or

449: nvl(p_rec.jrt_attribute2, hr_api.g_varchar2) or
450: nvl(ben_jrt_shd.g_old_rec.jrt_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.jrt_attribute3, hr_api.g_varchar2) or
452: nvl(ben_jrt_shd.g_old_rec.jrt_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.jrt_attribute4, hr_api.g_varchar2) or
454: nvl(ben_jrt_shd.g_old_rec.jrt_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.jrt_attribute5, hr_api.g_varchar2) or
456: nvl(ben_jrt_shd.g_old_rec.jrt_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.jrt_attribute6, hr_api.g_varchar2) or

Line 454: nvl(ben_jrt_shd.g_old_rec.jrt_attribute5, hr_api.g_varchar2) <>

450: nvl(ben_jrt_shd.g_old_rec.jrt_attribute3, hr_api.g_varchar2) <>
451: nvl(p_rec.jrt_attribute3, hr_api.g_varchar2) or
452: nvl(ben_jrt_shd.g_old_rec.jrt_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.jrt_attribute4, hr_api.g_varchar2) or
454: nvl(ben_jrt_shd.g_old_rec.jrt_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.jrt_attribute5, hr_api.g_varchar2) or
456: nvl(ben_jrt_shd.g_old_rec.jrt_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.jrt_attribute6, hr_api.g_varchar2) or
458: nvl(ben_jrt_shd.g_old_rec.jrt_attribute7, hr_api.g_varchar2) <>

Line 455: nvl(p_rec.jrt_attribute5, hr_api.g_varchar2) or

451: nvl(p_rec.jrt_attribute3, hr_api.g_varchar2) or
452: nvl(ben_jrt_shd.g_old_rec.jrt_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.jrt_attribute4, hr_api.g_varchar2) or
454: nvl(ben_jrt_shd.g_old_rec.jrt_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.jrt_attribute5, hr_api.g_varchar2) or
456: nvl(ben_jrt_shd.g_old_rec.jrt_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.jrt_attribute6, hr_api.g_varchar2) or
458: nvl(ben_jrt_shd.g_old_rec.jrt_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.jrt_attribute7, hr_api.g_varchar2) or

Line 456: nvl(ben_jrt_shd.g_old_rec.jrt_attribute6, hr_api.g_varchar2) <>

452: nvl(ben_jrt_shd.g_old_rec.jrt_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.jrt_attribute4, hr_api.g_varchar2) or
454: nvl(ben_jrt_shd.g_old_rec.jrt_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.jrt_attribute5, hr_api.g_varchar2) or
456: nvl(ben_jrt_shd.g_old_rec.jrt_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.jrt_attribute6, hr_api.g_varchar2) or
458: nvl(ben_jrt_shd.g_old_rec.jrt_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.jrt_attribute7, hr_api.g_varchar2) or
460: nvl(ben_jrt_shd.g_old_rec.jrt_attribute8, hr_api.g_varchar2) <>

Line 457: nvl(p_rec.jrt_attribute6, hr_api.g_varchar2) or

453: nvl(p_rec.jrt_attribute4, hr_api.g_varchar2) or
454: nvl(ben_jrt_shd.g_old_rec.jrt_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.jrt_attribute5, hr_api.g_varchar2) or
456: nvl(ben_jrt_shd.g_old_rec.jrt_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.jrt_attribute6, hr_api.g_varchar2) or
458: nvl(ben_jrt_shd.g_old_rec.jrt_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.jrt_attribute7, hr_api.g_varchar2) or
460: nvl(ben_jrt_shd.g_old_rec.jrt_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.jrt_attribute8, hr_api.g_varchar2) or

Line 458: nvl(ben_jrt_shd.g_old_rec.jrt_attribute7, hr_api.g_varchar2) <>

454: nvl(ben_jrt_shd.g_old_rec.jrt_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.jrt_attribute5, hr_api.g_varchar2) or
456: nvl(ben_jrt_shd.g_old_rec.jrt_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.jrt_attribute6, hr_api.g_varchar2) or
458: nvl(ben_jrt_shd.g_old_rec.jrt_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.jrt_attribute7, hr_api.g_varchar2) or
460: nvl(ben_jrt_shd.g_old_rec.jrt_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.jrt_attribute8, hr_api.g_varchar2) or
462: nvl(ben_jrt_shd.g_old_rec.jrt_attribute9, hr_api.g_varchar2) <>

Line 459: nvl(p_rec.jrt_attribute7, hr_api.g_varchar2) or

455: nvl(p_rec.jrt_attribute5, hr_api.g_varchar2) or
456: nvl(ben_jrt_shd.g_old_rec.jrt_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.jrt_attribute6, hr_api.g_varchar2) or
458: nvl(ben_jrt_shd.g_old_rec.jrt_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.jrt_attribute7, hr_api.g_varchar2) or
460: nvl(ben_jrt_shd.g_old_rec.jrt_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.jrt_attribute8, hr_api.g_varchar2) or
462: nvl(ben_jrt_shd.g_old_rec.jrt_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.jrt_attribute9, hr_api.g_varchar2) or

Line 460: nvl(ben_jrt_shd.g_old_rec.jrt_attribute8, hr_api.g_varchar2) <>

456: nvl(ben_jrt_shd.g_old_rec.jrt_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.jrt_attribute6, hr_api.g_varchar2) or
458: nvl(ben_jrt_shd.g_old_rec.jrt_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.jrt_attribute7, hr_api.g_varchar2) or
460: nvl(ben_jrt_shd.g_old_rec.jrt_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.jrt_attribute8, hr_api.g_varchar2) or
462: nvl(ben_jrt_shd.g_old_rec.jrt_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.jrt_attribute9, hr_api.g_varchar2) or
464: nvl(ben_jrt_shd.g_old_rec.jrt_attribute10, hr_api.g_varchar2) <>

Line 461: nvl(p_rec.jrt_attribute8, hr_api.g_varchar2) or

457: nvl(p_rec.jrt_attribute6, hr_api.g_varchar2) or
458: nvl(ben_jrt_shd.g_old_rec.jrt_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.jrt_attribute7, hr_api.g_varchar2) or
460: nvl(ben_jrt_shd.g_old_rec.jrt_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.jrt_attribute8, hr_api.g_varchar2) or
462: nvl(ben_jrt_shd.g_old_rec.jrt_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.jrt_attribute9, hr_api.g_varchar2) or
464: nvl(ben_jrt_shd.g_old_rec.jrt_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.jrt_attribute10, hr_api.g_varchar2) or

Line 462: nvl(ben_jrt_shd.g_old_rec.jrt_attribute9, hr_api.g_varchar2) <>

458: nvl(ben_jrt_shd.g_old_rec.jrt_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.jrt_attribute7, hr_api.g_varchar2) or
460: nvl(ben_jrt_shd.g_old_rec.jrt_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.jrt_attribute8, hr_api.g_varchar2) or
462: nvl(ben_jrt_shd.g_old_rec.jrt_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.jrt_attribute9, hr_api.g_varchar2) or
464: nvl(ben_jrt_shd.g_old_rec.jrt_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.jrt_attribute10, hr_api.g_varchar2) or
466: nvl(ben_jrt_shd.g_old_rec.jrt_attribute11, hr_api.g_varchar2) <>

Line 463: nvl(p_rec.jrt_attribute9, hr_api.g_varchar2) or

459: nvl(p_rec.jrt_attribute7, hr_api.g_varchar2) or
460: nvl(ben_jrt_shd.g_old_rec.jrt_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.jrt_attribute8, hr_api.g_varchar2) or
462: nvl(ben_jrt_shd.g_old_rec.jrt_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.jrt_attribute9, hr_api.g_varchar2) or
464: nvl(ben_jrt_shd.g_old_rec.jrt_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.jrt_attribute10, hr_api.g_varchar2) or
466: nvl(ben_jrt_shd.g_old_rec.jrt_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.jrt_attribute11, hr_api.g_varchar2) or

Line 464: nvl(ben_jrt_shd.g_old_rec.jrt_attribute10, hr_api.g_varchar2) <>

460: nvl(ben_jrt_shd.g_old_rec.jrt_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.jrt_attribute8, hr_api.g_varchar2) or
462: nvl(ben_jrt_shd.g_old_rec.jrt_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.jrt_attribute9, hr_api.g_varchar2) or
464: nvl(ben_jrt_shd.g_old_rec.jrt_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.jrt_attribute10, hr_api.g_varchar2) or
466: nvl(ben_jrt_shd.g_old_rec.jrt_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.jrt_attribute11, hr_api.g_varchar2) or
468: nvl(ben_jrt_shd.g_old_rec.jrt_attribute12, hr_api.g_varchar2) <>

Line 465: nvl(p_rec.jrt_attribute10, hr_api.g_varchar2) or

461: nvl(p_rec.jrt_attribute8, hr_api.g_varchar2) or
462: nvl(ben_jrt_shd.g_old_rec.jrt_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.jrt_attribute9, hr_api.g_varchar2) or
464: nvl(ben_jrt_shd.g_old_rec.jrt_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.jrt_attribute10, hr_api.g_varchar2) or
466: nvl(ben_jrt_shd.g_old_rec.jrt_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.jrt_attribute11, hr_api.g_varchar2) or
468: nvl(ben_jrt_shd.g_old_rec.jrt_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.jrt_attribute12, hr_api.g_varchar2) or

Line 466: nvl(ben_jrt_shd.g_old_rec.jrt_attribute11, hr_api.g_varchar2) <>

462: nvl(ben_jrt_shd.g_old_rec.jrt_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.jrt_attribute9, hr_api.g_varchar2) or
464: nvl(ben_jrt_shd.g_old_rec.jrt_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.jrt_attribute10, hr_api.g_varchar2) or
466: nvl(ben_jrt_shd.g_old_rec.jrt_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.jrt_attribute11, hr_api.g_varchar2) or
468: nvl(ben_jrt_shd.g_old_rec.jrt_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.jrt_attribute12, hr_api.g_varchar2) or
470: nvl(ben_jrt_shd.g_old_rec.jrt_attribute13, hr_api.g_varchar2) <>

Line 467: nvl(p_rec.jrt_attribute11, hr_api.g_varchar2) or

463: nvl(p_rec.jrt_attribute9, hr_api.g_varchar2) or
464: nvl(ben_jrt_shd.g_old_rec.jrt_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.jrt_attribute10, hr_api.g_varchar2) or
466: nvl(ben_jrt_shd.g_old_rec.jrt_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.jrt_attribute11, hr_api.g_varchar2) or
468: nvl(ben_jrt_shd.g_old_rec.jrt_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.jrt_attribute12, hr_api.g_varchar2) or
470: nvl(ben_jrt_shd.g_old_rec.jrt_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.jrt_attribute13, hr_api.g_varchar2) or

Line 468: nvl(ben_jrt_shd.g_old_rec.jrt_attribute12, hr_api.g_varchar2) <>

464: nvl(ben_jrt_shd.g_old_rec.jrt_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.jrt_attribute10, hr_api.g_varchar2) or
466: nvl(ben_jrt_shd.g_old_rec.jrt_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.jrt_attribute11, hr_api.g_varchar2) or
468: nvl(ben_jrt_shd.g_old_rec.jrt_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.jrt_attribute12, hr_api.g_varchar2) or
470: nvl(ben_jrt_shd.g_old_rec.jrt_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.jrt_attribute13, hr_api.g_varchar2) or
472: nvl(ben_jrt_shd.g_old_rec.jrt_attribute14, hr_api.g_varchar2) <>

Line 469: nvl(p_rec.jrt_attribute12, hr_api.g_varchar2) or

465: nvl(p_rec.jrt_attribute10, hr_api.g_varchar2) or
466: nvl(ben_jrt_shd.g_old_rec.jrt_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.jrt_attribute11, hr_api.g_varchar2) or
468: nvl(ben_jrt_shd.g_old_rec.jrt_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.jrt_attribute12, hr_api.g_varchar2) or
470: nvl(ben_jrt_shd.g_old_rec.jrt_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.jrt_attribute13, hr_api.g_varchar2) or
472: nvl(ben_jrt_shd.g_old_rec.jrt_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.jrt_attribute14, hr_api.g_varchar2) or

Line 470: nvl(ben_jrt_shd.g_old_rec.jrt_attribute13, hr_api.g_varchar2) <>

466: nvl(ben_jrt_shd.g_old_rec.jrt_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.jrt_attribute11, hr_api.g_varchar2) or
468: nvl(ben_jrt_shd.g_old_rec.jrt_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.jrt_attribute12, hr_api.g_varchar2) or
470: nvl(ben_jrt_shd.g_old_rec.jrt_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.jrt_attribute13, hr_api.g_varchar2) or
472: nvl(ben_jrt_shd.g_old_rec.jrt_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.jrt_attribute14, hr_api.g_varchar2) or
474: nvl(ben_jrt_shd.g_old_rec.jrt_attribute15, hr_api.g_varchar2) <>

Line 471: nvl(p_rec.jrt_attribute13, hr_api.g_varchar2) or

467: nvl(p_rec.jrt_attribute11, hr_api.g_varchar2) or
468: nvl(ben_jrt_shd.g_old_rec.jrt_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.jrt_attribute12, hr_api.g_varchar2) or
470: nvl(ben_jrt_shd.g_old_rec.jrt_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.jrt_attribute13, hr_api.g_varchar2) or
472: nvl(ben_jrt_shd.g_old_rec.jrt_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.jrt_attribute14, hr_api.g_varchar2) or
474: nvl(ben_jrt_shd.g_old_rec.jrt_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.jrt_attribute15, hr_api.g_varchar2) or

Line 472: nvl(ben_jrt_shd.g_old_rec.jrt_attribute14, hr_api.g_varchar2) <>

468: nvl(ben_jrt_shd.g_old_rec.jrt_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.jrt_attribute12, hr_api.g_varchar2) or
470: nvl(ben_jrt_shd.g_old_rec.jrt_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.jrt_attribute13, hr_api.g_varchar2) or
472: nvl(ben_jrt_shd.g_old_rec.jrt_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.jrt_attribute14, hr_api.g_varchar2) or
474: nvl(ben_jrt_shd.g_old_rec.jrt_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.jrt_attribute15, hr_api.g_varchar2) or
476: nvl(ben_jrt_shd.g_old_rec.jrt_attribute16, hr_api.g_varchar2) <>

Line 473: nvl(p_rec.jrt_attribute14, hr_api.g_varchar2) or

469: nvl(p_rec.jrt_attribute12, hr_api.g_varchar2) or
470: nvl(ben_jrt_shd.g_old_rec.jrt_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.jrt_attribute13, hr_api.g_varchar2) or
472: nvl(ben_jrt_shd.g_old_rec.jrt_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.jrt_attribute14, hr_api.g_varchar2) or
474: nvl(ben_jrt_shd.g_old_rec.jrt_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.jrt_attribute15, hr_api.g_varchar2) or
476: nvl(ben_jrt_shd.g_old_rec.jrt_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.jrt_attribute16, hr_api.g_varchar2) or

Line 474: nvl(ben_jrt_shd.g_old_rec.jrt_attribute15, hr_api.g_varchar2) <>

470: nvl(ben_jrt_shd.g_old_rec.jrt_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.jrt_attribute13, hr_api.g_varchar2) or
472: nvl(ben_jrt_shd.g_old_rec.jrt_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.jrt_attribute14, hr_api.g_varchar2) or
474: nvl(ben_jrt_shd.g_old_rec.jrt_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.jrt_attribute15, hr_api.g_varchar2) or
476: nvl(ben_jrt_shd.g_old_rec.jrt_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.jrt_attribute16, hr_api.g_varchar2) or
478: nvl(ben_jrt_shd.g_old_rec.jrt_attribute17, hr_api.g_varchar2) <>

Line 475: nvl(p_rec.jrt_attribute15, hr_api.g_varchar2) or

471: nvl(p_rec.jrt_attribute13, hr_api.g_varchar2) or
472: nvl(ben_jrt_shd.g_old_rec.jrt_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.jrt_attribute14, hr_api.g_varchar2) or
474: nvl(ben_jrt_shd.g_old_rec.jrt_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.jrt_attribute15, hr_api.g_varchar2) or
476: nvl(ben_jrt_shd.g_old_rec.jrt_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.jrt_attribute16, hr_api.g_varchar2) or
478: nvl(ben_jrt_shd.g_old_rec.jrt_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.jrt_attribute17, hr_api.g_varchar2) or

Line 476: nvl(ben_jrt_shd.g_old_rec.jrt_attribute16, hr_api.g_varchar2) <>

472: nvl(ben_jrt_shd.g_old_rec.jrt_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.jrt_attribute14, hr_api.g_varchar2) or
474: nvl(ben_jrt_shd.g_old_rec.jrt_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.jrt_attribute15, hr_api.g_varchar2) or
476: nvl(ben_jrt_shd.g_old_rec.jrt_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.jrt_attribute16, hr_api.g_varchar2) or
478: nvl(ben_jrt_shd.g_old_rec.jrt_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.jrt_attribute17, hr_api.g_varchar2) or
480: nvl(ben_jrt_shd.g_old_rec.jrt_attribute18, hr_api.g_varchar2) <>

Line 477: nvl(p_rec.jrt_attribute16, hr_api.g_varchar2) or

473: nvl(p_rec.jrt_attribute14, hr_api.g_varchar2) or
474: nvl(ben_jrt_shd.g_old_rec.jrt_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.jrt_attribute15, hr_api.g_varchar2) or
476: nvl(ben_jrt_shd.g_old_rec.jrt_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.jrt_attribute16, hr_api.g_varchar2) or
478: nvl(ben_jrt_shd.g_old_rec.jrt_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.jrt_attribute17, hr_api.g_varchar2) or
480: nvl(ben_jrt_shd.g_old_rec.jrt_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.jrt_attribute18, hr_api.g_varchar2) or

Line 478: nvl(ben_jrt_shd.g_old_rec.jrt_attribute17, hr_api.g_varchar2) <>

474: nvl(ben_jrt_shd.g_old_rec.jrt_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.jrt_attribute15, hr_api.g_varchar2) or
476: nvl(ben_jrt_shd.g_old_rec.jrt_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.jrt_attribute16, hr_api.g_varchar2) or
478: nvl(ben_jrt_shd.g_old_rec.jrt_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.jrt_attribute17, hr_api.g_varchar2) or
480: nvl(ben_jrt_shd.g_old_rec.jrt_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.jrt_attribute18, hr_api.g_varchar2) or
482: nvl(ben_jrt_shd.g_old_rec.jrt_attribute19, hr_api.g_varchar2) <>

Line 479: nvl(p_rec.jrt_attribute17, hr_api.g_varchar2) or

475: nvl(p_rec.jrt_attribute15, hr_api.g_varchar2) or
476: nvl(ben_jrt_shd.g_old_rec.jrt_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.jrt_attribute16, hr_api.g_varchar2) or
478: nvl(ben_jrt_shd.g_old_rec.jrt_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.jrt_attribute17, hr_api.g_varchar2) or
480: nvl(ben_jrt_shd.g_old_rec.jrt_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.jrt_attribute18, hr_api.g_varchar2) or
482: nvl(ben_jrt_shd.g_old_rec.jrt_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.jrt_attribute19, hr_api.g_varchar2) or

Line 480: nvl(ben_jrt_shd.g_old_rec.jrt_attribute18, hr_api.g_varchar2) <>

476: nvl(ben_jrt_shd.g_old_rec.jrt_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.jrt_attribute16, hr_api.g_varchar2) or
478: nvl(ben_jrt_shd.g_old_rec.jrt_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.jrt_attribute17, hr_api.g_varchar2) or
480: nvl(ben_jrt_shd.g_old_rec.jrt_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.jrt_attribute18, hr_api.g_varchar2) or
482: nvl(ben_jrt_shd.g_old_rec.jrt_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.jrt_attribute19, hr_api.g_varchar2) or
484: nvl(ben_jrt_shd.g_old_rec.jrt_attribute20, hr_api.g_varchar2) <>

Line 481: nvl(p_rec.jrt_attribute18, hr_api.g_varchar2) or

477: nvl(p_rec.jrt_attribute16, hr_api.g_varchar2) or
478: nvl(ben_jrt_shd.g_old_rec.jrt_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.jrt_attribute17, hr_api.g_varchar2) or
480: nvl(ben_jrt_shd.g_old_rec.jrt_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.jrt_attribute18, hr_api.g_varchar2) or
482: nvl(ben_jrt_shd.g_old_rec.jrt_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.jrt_attribute19, hr_api.g_varchar2) or
484: nvl(ben_jrt_shd.g_old_rec.jrt_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.jrt_attribute20, hr_api.g_varchar2) or

Line 482: nvl(ben_jrt_shd.g_old_rec.jrt_attribute19, hr_api.g_varchar2) <>

478: nvl(ben_jrt_shd.g_old_rec.jrt_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.jrt_attribute17, hr_api.g_varchar2) or
480: nvl(ben_jrt_shd.g_old_rec.jrt_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.jrt_attribute18, hr_api.g_varchar2) or
482: nvl(ben_jrt_shd.g_old_rec.jrt_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.jrt_attribute19, hr_api.g_varchar2) or
484: nvl(ben_jrt_shd.g_old_rec.jrt_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.jrt_attribute20, hr_api.g_varchar2) or
486: nvl(ben_jrt_shd.g_old_rec.jrt_attribute21, hr_api.g_varchar2) <>

Line 483: nvl(p_rec.jrt_attribute19, hr_api.g_varchar2) or

479: nvl(p_rec.jrt_attribute17, hr_api.g_varchar2) or
480: nvl(ben_jrt_shd.g_old_rec.jrt_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.jrt_attribute18, hr_api.g_varchar2) or
482: nvl(ben_jrt_shd.g_old_rec.jrt_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.jrt_attribute19, hr_api.g_varchar2) or
484: nvl(ben_jrt_shd.g_old_rec.jrt_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.jrt_attribute20, hr_api.g_varchar2) or
486: nvl(ben_jrt_shd.g_old_rec.jrt_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.jrt_attribute21, hr_api.g_varchar2) or

Line 484: nvl(ben_jrt_shd.g_old_rec.jrt_attribute20, hr_api.g_varchar2) <>

480: nvl(ben_jrt_shd.g_old_rec.jrt_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.jrt_attribute18, hr_api.g_varchar2) or
482: nvl(ben_jrt_shd.g_old_rec.jrt_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.jrt_attribute19, hr_api.g_varchar2) or
484: nvl(ben_jrt_shd.g_old_rec.jrt_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.jrt_attribute20, hr_api.g_varchar2) or
486: nvl(ben_jrt_shd.g_old_rec.jrt_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.jrt_attribute21, hr_api.g_varchar2) or
488: nvl(ben_jrt_shd.g_old_rec.jrt_attribute22, hr_api.g_varchar2) <>

Line 485: nvl(p_rec.jrt_attribute20, hr_api.g_varchar2) or

481: nvl(p_rec.jrt_attribute18, hr_api.g_varchar2) or
482: nvl(ben_jrt_shd.g_old_rec.jrt_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.jrt_attribute19, hr_api.g_varchar2) or
484: nvl(ben_jrt_shd.g_old_rec.jrt_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.jrt_attribute20, hr_api.g_varchar2) or
486: nvl(ben_jrt_shd.g_old_rec.jrt_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.jrt_attribute21, hr_api.g_varchar2) or
488: nvl(ben_jrt_shd.g_old_rec.jrt_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.jrt_attribute22, hr_api.g_varchar2) or

Line 486: nvl(ben_jrt_shd.g_old_rec.jrt_attribute21, hr_api.g_varchar2) <>

482: nvl(ben_jrt_shd.g_old_rec.jrt_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.jrt_attribute19, hr_api.g_varchar2) or
484: nvl(ben_jrt_shd.g_old_rec.jrt_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.jrt_attribute20, hr_api.g_varchar2) or
486: nvl(ben_jrt_shd.g_old_rec.jrt_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.jrt_attribute21, hr_api.g_varchar2) or
488: nvl(ben_jrt_shd.g_old_rec.jrt_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.jrt_attribute22, hr_api.g_varchar2) or
490: nvl(ben_jrt_shd.g_old_rec.jrt_attribute23, hr_api.g_varchar2) <>

Line 487: nvl(p_rec.jrt_attribute21, hr_api.g_varchar2) or

483: nvl(p_rec.jrt_attribute19, hr_api.g_varchar2) or
484: nvl(ben_jrt_shd.g_old_rec.jrt_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.jrt_attribute20, hr_api.g_varchar2) or
486: nvl(ben_jrt_shd.g_old_rec.jrt_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.jrt_attribute21, hr_api.g_varchar2) or
488: nvl(ben_jrt_shd.g_old_rec.jrt_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.jrt_attribute22, hr_api.g_varchar2) or
490: nvl(ben_jrt_shd.g_old_rec.jrt_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.jrt_attribute23, hr_api.g_varchar2) or

Line 488: nvl(ben_jrt_shd.g_old_rec.jrt_attribute22, hr_api.g_varchar2) <>

484: nvl(ben_jrt_shd.g_old_rec.jrt_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.jrt_attribute20, hr_api.g_varchar2) or
486: nvl(ben_jrt_shd.g_old_rec.jrt_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.jrt_attribute21, hr_api.g_varchar2) or
488: nvl(ben_jrt_shd.g_old_rec.jrt_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.jrt_attribute22, hr_api.g_varchar2) or
490: nvl(ben_jrt_shd.g_old_rec.jrt_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.jrt_attribute23, hr_api.g_varchar2) or
492: nvl(ben_jrt_shd.g_old_rec.jrt_attribute24, hr_api.g_varchar2) <>

Line 489: nvl(p_rec.jrt_attribute22, hr_api.g_varchar2) or

485: nvl(p_rec.jrt_attribute20, hr_api.g_varchar2) or
486: nvl(ben_jrt_shd.g_old_rec.jrt_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.jrt_attribute21, hr_api.g_varchar2) or
488: nvl(ben_jrt_shd.g_old_rec.jrt_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.jrt_attribute22, hr_api.g_varchar2) or
490: nvl(ben_jrt_shd.g_old_rec.jrt_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.jrt_attribute23, hr_api.g_varchar2) or
492: nvl(ben_jrt_shd.g_old_rec.jrt_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.jrt_attribute24, hr_api.g_varchar2) or

Line 490: nvl(ben_jrt_shd.g_old_rec.jrt_attribute23, hr_api.g_varchar2) <>

486: nvl(ben_jrt_shd.g_old_rec.jrt_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.jrt_attribute21, hr_api.g_varchar2) or
488: nvl(ben_jrt_shd.g_old_rec.jrt_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.jrt_attribute22, hr_api.g_varchar2) or
490: nvl(ben_jrt_shd.g_old_rec.jrt_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.jrt_attribute23, hr_api.g_varchar2) or
492: nvl(ben_jrt_shd.g_old_rec.jrt_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.jrt_attribute24, hr_api.g_varchar2) or
494: nvl(ben_jrt_shd.g_old_rec.jrt_attribute25, hr_api.g_varchar2) <>

Line 491: nvl(p_rec.jrt_attribute23, hr_api.g_varchar2) or

487: nvl(p_rec.jrt_attribute21, hr_api.g_varchar2) or
488: nvl(ben_jrt_shd.g_old_rec.jrt_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.jrt_attribute22, hr_api.g_varchar2) or
490: nvl(ben_jrt_shd.g_old_rec.jrt_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.jrt_attribute23, hr_api.g_varchar2) or
492: nvl(ben_jrt_shd.g_old_rec.jrt_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.jrt_attribute24, hr_api.g_varchar2) or
494: nvl(ben_jrt_shd.g_old_rec.jrt_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.jrt_attribute25, hr_api.g_varchar2) or

Line 492: nvl(ben_jrt_shd.g_old_rec.jrt_attribute24, hr_api.g_varchar2) <>

488: nvl(ben_jrt_shd.g_old_rec.jrt_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.jrt_attribute22, hr_api.g_varchar2) or
490: nvl(ben_jrt_shd.g_old_rec.jrt_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.jrt_attribute23, hr_api.g_varchar2) or
492: nvl(ben_jrt_shd.g_old_rec.jrt_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.jrt_attribute24, hr_api.g_varchar2) or
494: nvl(ben_jrt_shd.g_old_rec.jrt_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.jrt_attribute25, hr_api.g_varchar2) or
496: nvl(ben_jrt_shd.g_old_rec.jrt_attribute26, hr_api.g_varchar2) <>

Line 493: nvl(p_rec.jrt_attribute24, hr_api.g_varchar2) or

489: nvl(p_rec.jrt_attribute22, hr_api.g_varchar2) or
490: nvl(ben_jrt_shd.g_old_rec.jrt_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.jrt_attribute23, hr_api.g_varchar2) or
492: nvl(ben_jrt_shd.g_old_rec.jrt_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.jrt_attribute24, hr_api.g_varchar2) or
494: nvl(ben_jrt_shd.g_old_rec.jrt_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.jrt_attribute25, hr_api.g_varchar2) or
496: nvl(ben_jrt_shd.g_old_rec.jrt_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.jrt_attribute26, hr_api.g_varchar2) or

Line 494: nvl(ben_jrt_shd.g_old_rec.jrt_attribute25, hr_api.g_varchar2) <>

490: nvl(ben_jrt_shd.g_old_rec.jrt_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.jrt_attribute23, hr_api.g_varchar2) or
492: nvl(ben_jrt_shd.g_old_rec.jrt_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.jrt_attribute24, hr_api.g_varchar2) or
494: nvl(ben_jrt_shd.g_old_rec.jrt_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.jrt_attribute25, hr_api.g_varchar2) or
496: nvl(ben_jrt_shd.g_old_rec.jrt_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.jrt_attribute26, hr_api.g_varchar2) or
498: nvl(ben_jrt_shd.g_old_rec.jrt_attribute27, hr_api.g_varchar2) <>

Line 495: nvl(p_rec.jrt_attribute25, hr_api.g_varchar2) or

491: nvl(p_rec.jrt_attribute23, hr_api.g_varchar2) or
492: nvl(ben_jrt_shd.g_old_rec.jrt_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.jrt_attribute24, hr_api.g_varchar2) or
494: nvl(ben_jrt_shd.g_old_rec.jrt_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.jrt_attribute25, hr_api.g_varchar2) or
496: nvl(ben_jrt_shd.g_old_rec.jrt_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.jrt_attribute26, hr_api.g_varchar2) or
498: nvl(ben_jrt_shd.g_old_rec.jrt_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.jrt_attribute27, hr_api.g_varchar2) or

Line 496: nvl(ben_jrt_shd.g_old_rec.jrt_attribute26, hr_api.g_varchar2) <>

492: nvl(ben_jrt_shd.g_old_rec.jrt_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.jrt_attribute24, hr_api.g_varchar2) or
494: nvl(ben_jrt_shd.g_old_rec.jrt_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.jrt_attribute25, hr_api.g_varchar2) or
496: nvl(ben_jrt_shd.g_old_rec.jrt_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.jrt_attribute26, hr_api.g_varchar2) or
498: nvl(ben_jrt_shd.g_old_rec.jrt_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.jrt_attribute27, hr_api.g_varchar2) or
500: nvl(ben_jrt_shd.g_old_rec.jrt_attribute28, hr_api.g_varchar2) <>

Line 497: nvl(p_rec.jrt_attribute26, hr_api.g_varchar2) or

493: nvl(p_rec.jrt_attribute24, hr_api.g_varchar2) or
494: nvl(ben_jrt_shd.g_old_rec.jrt_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.jrt_attribute25, hr_api.g_varchar2) or
496: nvl(ben_jrt_shd.g_old_rec.jrt_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.jrt_attribute26, hr_api.g_varchar2) or
498: nvl(ben_jrt_shd.g_old_rec.jrt_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.jrt_attribute27, hr_api.g_varchar2) or
500: nvl(ben_jrt_shd.g_old_rec.jrt_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.jrt_attribute28, hr_api.g_varchar2) or

Line 498: nvl(ben_jrt_shd.g_old_rec.jrt_attribute27, hr_api.g_varchar2) <>

494: nvl(ben_jrt_shd.g_old_rec.jrt_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.jrt_attribute25, hr_api.g_varchar2) or
496: nvl(ben_jrt_shd.g_old_rec.jrt_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.jrt_attribute26, hr_api.g_varchar2) or
498: nvl(ben_jrt_shd.g_old_rec.jrt_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.jrt_attribute27, hr_api.g_varchar2) or
500: nvl(ben_jrt_shd.g_old_rec.jrt_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.jrt_attribute28, hr_api.g_varchar2) or
502: nvl(ben_jrt_shd.g_old_rec.jrt_attribute29, hr_api.g_varchar2) <>

Line 499: nvl(p_rec.jrt_attribute27, hr_api.g_varchar2) or

495: nvl(p_rec.jrt_attribute25, hr_api.g_varchar2) or
496: nvl(ben_jrt_shd.g_old_rec.jrt_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.jrt_attribute26, hr_api.g_varchar2) or
498: nvl(ben_jrt_shd.g_old_rec.jrt_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.jrt_attribute27, hr_api.g_varchar2) or
500: nvl(ben_jrt_shd.g_old_rec.jrt_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.jrt_attribute28, hr_api.g_varchar2) or
502: nvl(ben_jrt_shd.g_old_rec.jrt_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.jrt_attribute29, hr_api.g_varchar2) or

Line 500: nvl(ben_jrt_shd.g_old_rec.jrt_attribute28, hr_api.g_varchar2) <>

496: nvl(ben_jrt_shd.g_old_rec.jrt_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.jrt_attribute26, hr_api.g_varchar2) or
498: nvl(ben_jrt_shd.g_old_rec.jrt_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.jrt_attribute27, hr_api.g_varchar2) or
500: nvl(ben_jrt_shd.g_old_rec.jrt_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.jrt_attribute28, hr_api.g_varchar2) or
502: nvl(ben_jrt_shd.g_old_rec.jrt_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.jrt_attribute29, hr_api.g_varchar2) or
504: nvl(ben_jrt_shd.g_old_rec.jrt_attribute30, hr_api.g_varchar2) <>

Line 501: nvl(p_rec.jrt_attribute28, hr_api.g_varchar2) or

497: nvl(p_rec.jrt_attribute26, hr_api.g_varchar2) or
498: nvl(ben_jrt_shd.g_old_rec.jrt_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.jrt_attribute27, hr_api.g_varchar2) or
500: nvl(ben_jrt_shd.g_old_rec.jrt_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.jrt_attribute28, hr_api.g_varchar2) or
502: nvl(ben_jrt_shd.g_old_rec.jrt_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.jrt_attribute29, hr_api.g_varchar2) or
504: nvl(ben_jrt_shd.g_old_rec.jrt_attribute30, hr_api.g_varchar2) <>
505: nvl(p_rec.jrt_attribute30, hr_api.g_varchar2) ))

Line 502: nvl(ben_jrt_shd.g_old_rec.jrt_attribute29, hr_api.g_varchar2) <>

498: nvl(ben_jrt_shd.g_old_rec.jrt_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.jrt_attribute27, hr_api.g_varchar2) or
500: nvl(ben_jrt_shd.g_old_rec.jrt_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.jrt_attribute28, hr_api.g_varchar2) or
502: nvl(ben_jrt_shd.g_old_rec.jrt_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.jrt_attribute29, hr_api.g_varchar2) or
504: nvl(ben_jrt_shd.g_old_rec.jrt_attribute30, hr_api.g_varchar2) <>
505: nvl(p_rec.jrt_attribute30, hr_api.g_varchar2) ))
506: or (p_rec.job_rt_id is null) then

Line 503: nvl(p_rec.jrt_attribute29, hr_api.g_varchar2) or

499: nvl(p_rec.jrt_attribute27, hr_api.g_varchar2) or
500: nvl(ben_jrt_shd.g_old_rec.jrt_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.jrt_attribute28, hr_api.g_varchar2) or
502: nvl(ben_jrt_shd.g_old_rec.jrt_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.jrt_attribute29, hr_api.g_varchar2) or
504: nvl(ben_jrt_shd.g_old_rec.jrt_attribute30, hr_api.g_varchar2) <>
505: nvl(p_rec.jrt_attribute30, hr_api.g_varchar2) ))
506: or (p_rec.job_rt_id is null) then
507: --

Line 504: nvl(ben_jrt_shd.g_old_rec.jrt_attribute30, hr_api.g_varchar2) <>

500: nvl(ben_jrt_shd.g_old_rec.jrt_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.jrt_attribute28, hr_api.g_varchar2) or
502: nvl(ben_jrt_shd.g_old_rec.jrt_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.jrt_attribute29, hr_api.g_varchar2) or
504: nvl(ben_jrt_shd.g_old_rec.jrt_attribute30, hr_api.g_varchar2) <>
505: nvl(p_rec.jrt_attribute30, hr_api.g_varchar2) ))
506: or (p_rec.job_rt_id is null) then
507: --
508: -- Only execute the validation if absolutely necessary:

Line 505: nvl(p_rec.jrt_attribute30, hr_api.g_varchar2) ))

501: nvl(p_rec.jrt_attribute28, hr_api.g_varchar2) or
502: nvl(ben_jrt_shd.g_old_rec.jrt_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.jrt_attribute29, hr_api.g_varchar2) or
504: nvl(ben_jrt_shd.g_old_rec.jrt_attribute30, hr_api.g_varchar2) <>
505: nvl(p_rec.jrt_attribute30, hr_api.g_varchar2) ))
506: or (p_rec.job_rt_id is null) then
507: --
508: -- Only execute the validation if absolutely necessary:
509: -- a) During update, the structure column value or any

Line 737: (p_vrbl_rt_prfl_id in number default hr_api.g_number

733: --
734: -- {End Of Comments}
735: -- ----------------------------------------------------------------------------
736: Procedure dt_update_validate
737: (p_vrbl_rt_prfl_id in number default hr_api.g_number
738: ,p_datetrack_mode in varchar2
739: ,p_validation_start_date in date
740: ,p_validation_end_date in date
741: ) Is

Line 749: hr_api.mandatory_arg_error

745: Begin
746: --
747: -- Ensure that the p_datetrack_mode argument is not null
748: --
749: hr_api.mandatory_arg_error
750: (p_api_name => l_proc
751: ,p_argument => 'datetrack_mode'
752: ,p_argument_value => p_datetrack_mode
753: );

Line 759: hr_api.mandatory_arg_error

755: -- Mode will be valid, as this is checked at the start of the upd.
756: --
757: -- Ensure the arguments are not null
758: --
759: hr_api.mandatory_arg_error
760: (p_api_name => l_proc
761: ,p_argument => 'validation_start_date'
762: ,p_argument_value => p_validation_start_date
763: );

Line 765: hr_api.mandatory_arg_error

761: ,p_argument => 'validation_start_date'
762: ,p_argument_value => p_validation_start_date
763: );
764: --
765: hr_api.mandatory_arg_error
766: (p_api_name => l_proc
767: ,p_argument => 'validation_end_date'
768: ,p_argument_value => p_validation_end_date
769: );

Line 771: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

767: ,p_argument => 'validation_end_date'
768: ,p_argument_value => p_validation_end_date
769: );
770: --
771: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
772: NOT (dt_api.check_min_max_dates
773: (p_base_table_name => 'ben_vrbl_rt_prfl_f'
774: ,p_base_key_column => 'VRBL_RT_PRFL_ID'
775: ,p_base_key_value => p_vrbl_rt_prfl_id

Line 844: hr_api.mandatory_arg_error

840: Begin
841: --
842: -- Ensure that the p_datetrack_mode argument is not null
843: --
844: hr_api.mandatory_arg_error
845: (p_api_name => l_proc
846: ,p_argument => 'datetrack_mode'
847: ,p_argument_value => p_datetrack_mode
848: );

Line 853: If (p_datetrack_mode = hr_api.g_delete or

849: --
850: -- Only perform the validation if the datetrack mode is either
851: -- DELETE or ZAP
852: --
853: If (p_datetrack_mode = hr_api.g_delete or
854: p_datetrack_mode = hr_api.g_zap) then
855: --
856: --
857: -- Ensure the arguments are not null

Line 854: p_datetrack_mode = hr_api.g_zap) then

850: -- Only perform the validation if the datetrack mode is either
851: -- DELETE or ZAP
852: --
853: If (p_datetrack_mode = hr_api.g_delete or
854: p_datetrack_mode = hr_api.g_zap) then
855: --
856: --
857: -- Ensure the arguments are not null
858: --

Line 859: hr_api.mandatory_arg_error

855: --
856: --
857: -- Ensure the arguments are not null
858: --
859: hr_api.mandatory_arg_error
860: (p_api_name => l_proc
861: ,p_argument => 'validation_start_date'
862: ,p_argument_value => p_validation_start_date
863: );

Line 865: hr_api.mandatory_arg_error

861: ,p_argument => 'validation_start_date'
862: ,p_argument_value => p_validation_start_date
863: );
864: --
865: hr_api.mandatory_arg_error
866: (p_api_name => l_proc
867: ,p_argument => 'validation_end_date'
868: ,p_argument_value => p_validation_end_date
869: );

Line 871: hr_api.mandatory_arg_error

867: ,p_argument => 'validation_end_date'
868: ,p_argument_value => p_validation_end_date
869: );
870: --
871: hr_api.mandatory_arg_error
872: (p_api_name => l_proc
873: ,p_argument => 'job_rt_id'
874: ,p_argument_value => p_job_rt_id
875: );

Line 912: hr_api.validate_bus_grp_id

908: hr_utility.set_location('Entering:'||l_proc, 5);
909: --
910: -- Call all supporting business operations
911: --
912: hr_api.validate_bus_grp_id
913: (p_business_group_id => p_rec.business_group_id
914: ,p_associated_column1 => ben_jrt_shd.g_tab_nam
915: || '.BUSINESS_GROUP_ID');
916: --

Line 980: hr_api.validate_bus_grp_id

976: hr_utility.set_location('Entering:'||l_proc, 5);
977: --
978: -- Call all supporting business operations
979: --
980: hr_api.validate_bus_grp_id
981: (p_business_group_id => p_rec.business_group_id
982: ,p_associated_column1 => ben_jrt_shd.g_tab_nam
983: || '.BUSINESS_GROUP_ID');
984: