APPS.BEN_JRT_BUS dependencies on BEN_JRT_SHD

Line 54: l_api_updating := ben_jrt_shd.api_updating

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

Line 61: <> ben_jrt_shd.g_old_rec.job_rt_id) then

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: --
65: ben_jrt_shd.constraint_error('BEN_JOB_RT_F_PK');

Line 65: ben_jrt_shd.constraint_error('BEN_JOB_RT_F_PK');

61: <> ben_jrt_shd.g_old_rec.job_rt_id) then
62: --
63: -- raise error as PK has changed
64: --
65: ben_jrt_shd.constraint_error('BEN_JOB_RT_F_PK');
66: --
67: elsif not l_api_updating then
68: --
69: -- check if PK is null

Line 75: ben_jrt_shd.constraint_error('BEN_JOB_RT_F_PK');

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

Line 150: l_api_updating := ben_jrt_shd.api_updating

146: Begin
147: --
148: hr_utility.set_location('Entering:'||l_proc,5);
149: --
150: l_api_updating := ben_jrt_shd.api_updating
151: (p_job_rt_id => p_job_rt_id,
152: p_effective_date => p_effective_date,
153: p_object_version_number => p_object_version_number);
154: --

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 172: ben_jrt_shd.constraint_error('BEN_JOB_RT_FK2');

168: --
169: -- raise error as FK does not relate to PK in per_jobs
170: -- table.
171: --
172: ben_jrt_shd.constraint_error('BEN_JOB_RT_FK2');
173: --
174: end if;
175: --
176: close c1;

Line 238: l_api_updating := ben_jrt_shd.api_updating

234: Begin
235: --
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: l_api_updating := ben_jrt_shd.api_updating
239: (p_job_rt_id => p_job_rt_id,
240: p_effective_date => p_effective_date,
241: p_object_version_number => p_object_version_number);
242: --

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 435: (p_rec in ben_jrt_shd.g_rec_type

431: -- Internal Row Handler Use Only.
432: --
433: -- ----------------------------------------------------------------------------
434: procedure chk_df
435: (p_rec in ben_jrt_shd.g_rec_type
436: ) is
437: --
438: l_proc varchar2(72) := g_package || 'chk_df';
439: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 612: ,p_rec in ben_jrt_shd.g_rec_type

608: -- {End Of Comments}
609: -- ----------------------------------------------------------------------------
610: Procedure chk_non_updateable_args
611: (p_effective_date in date
612: ,p_rec in ben_jrt_shd.g_rec_type
613: ) IS
614: --
615: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
616: --

Line 622: IF NOT ben_jrt_shd.api_updating

618: --
619: -- Only proceed with the validation if a row exists for the current
620: -- record in the HR Schema.
621: --
622: IF NOT ben_jrt_shd.api_updating
623: (p_job_rt_id => p_rec.job_rt_id
624: ,p_effective_date => p_effective_date
625: ,p_object_version_number => p_rec.object_version_number
626: ) THEN

Line 781: (p_associated_column1 => ben_jrt_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');

777: ,p_to_date => p_validation_end_date))) Then
778: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
779: fnd_message.set_token('TABLE_NAME','vrbl rt prfl');
780: hr_multi_message.add
781: (p_associated_column1 => ben_jrt_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');
782: End If;
783: --
784: Exception
785: When Others Then

Line 898: (p_rec in ben_jrt_shd.g_rec_type

894: -- ----------------------------------------------------------------------------
895: -- |---------------------------< insert_validate >----------------------------|
896: -- ----------------------------------------------------------------------------
897: Procedure insert_validate
898: (p_rec in ben_jrt_shd.g_rec_type
899: ,p_effective_date in date
900: ,p_datetrack_mode in varchar2
901: ,p_validation_start_date in date
902: ,p_validation_end_date in date

Line 914: ,p_associated_column1 => ben_jrt_shd.g_tab_nam

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: --
917:
918: chk_job_rt_id

Line 966: (p_rec in ben_jrt_shd.g_rec_type

962: -- ----------------------------------------------------------------------------
963: -- |---------------------------< update_validate >----------------------------|
964: -- ----------------------------------------------------------------------------
965: Procedure update_validate
966: (p_rec in ben_jrt_shd.g_rec_type
967: ,p_effective_date in date
968: ,p_datetrack_mode in varchar2
969: ,p_validation_start_date in date
970: ,p_validation_end_date in date

Line 982: ,p_associated_column1 => ben_jrt_shd.g_tab_nam

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:
985: chk_job_rt_id
986: (p_job_rt_id => p_rec.job_rt_id,

Line 1048: (p_rec in ben_jrt_shd.g_rec_type

1044: -- ----------------------------------------------------------------------------
1045: -- |---------------------------< delete_validate >----------------------------|
1046: -- ----------------------------------------------------------------------------
1047: Procedure delete_validate
1048: (p_rec in ben_jrt_shd.g_rec_type
1049: ,p_effective_date in date
1050: ,p_datetrack_mode in varchar2
1051: ,p_validation_start_date in date
1052: ,p_validation_end_date in date