APPS.BEN_CTY_BUS dependencies on BEN_CTY_SHD

Line 54: l_api_updating := ben_cty_shd.api_updating

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

Line 61: <> ben_cty_shd.g_old_rec.comptncy_rt_id) then

57: p_object_version_number => p_object_version_number);
58: --
59: if (l_api_updating
60: and nvl(p_comptncy_rt_id,hr_api.g_number)
61: <> ben_cty_shd.g_old_rec.comptncy_rt_id) then
62: --
63: -- raise error as PK has changed
64: --
65: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_F_PK');

Line 65: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_F_PK');

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

Line 75: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_F_PK');

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

Line 153: l_api_updating := ben_cty_shd.api_updating

149: Begin
150: --
151: hr_utility.set_location('Entering:'||l_proc,5);
152: --
153: l_api_updating := ben_cty_shd.api_updating
154: (p_comptncy_rt_id => p_comptncy_rt_id,
155: p_effective_date => p_effective_date,
156: p_object_version_number => p_object_version_number);
157: --

Line 160: <> nvl(ben_cty_shd.g_old_rec.competence_id,hr_api.g_number)

156: p_object_version_number => p_object_version_number);
157: --
158: if (l_api_updating
159: and nvl(p_competence_id,hr_api.g_number)
160: <> nvl(ben_cty_shd.g_old_rec.competence_id,hr_api.g_number)
161: or not l_api_updating) then
162: --
163: -- check if competence_id value exists in per_competences table
164: --

Line 175: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_FK2');

171: --
172: -- raise error as FK does not relate to PK in per_jobs
173: -- table.
174: --
175: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_FK2');
176: --
177: end if;
178: --
179: close c1;

Line 279: l_api_updating := ben_cty_shd.api_updating

275: Begin
276: --
277: hr_utility.set_location('Entering:'||l_proc,5);
278: --
279: l_api_updating := ben_cty_shd.api_updating
280: (p_comptncy_rt_id => p_comptncy_rt_id,
281: p_effective_date => p_effective_date,
282: p_object_version_number => p_object_version_number);
283: --

Line 286: <> nvl(ben_cty_shd.g_old_rec.rating_level_id,hr_api.g_number)

282: p_object_version_number => p_object_version_number);
283: --
284: if (l_api_updating
285: and nvl(p_competence_id,hr_api.g_number)
286: <> nvl(ben_cty_shd.g_old_rec.rating_level_id,hr_api.g_number)
287: or not l_api_updating) then
288: --
289: -- check if rating_level_id value exists in per_rating_levels table
290: --

Line 301: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_FK2');

297: --
298: -- raise error as FK does not relate to PK in per_jobs
299: -- table.
300: --
301: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_FK2');
302: --
303: end if;
304: --
305: close c1;

Line 369: l_api_updating := ben_cty_shd.api_updating

365: Begin
366: --
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: l_api_updating := ben_cty_shd.api_updating
370: (p_comptncy_rt_id => p_comptncy_rt_id,
371: p_effective_date => p_effective_date,
372: p_object_version_number => p_object_version_number);
373: --

Line 376: <> nvl(ben_cty_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

372: p_object_version_number => p_object_version_number);
373: --
374: if (l_api_updating
375: and p_excld_flag
376: <> nvl(ben_cty_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
377: or not l_api_updating) then
378: --
379: -- check if value of lookup falls within lookup type.
380: --

Line 634: (p_rec in ben_cty_shd.g_rec_type

630: -- Internal Row Handler Use Only.
631: --
632: -- ----------------------------------------------------------------------------
633: procedure chk_df
634: (p_rec in ben_cty_shd.g_rec_type
635: ) is
636: --
637: l_proc varchar2(72) := g_package || 'chk_df';
638: --

Line 643: nvl(ben_cty_shd.g_old_rec.cty_attribute_category, hr_api.g_varchar2) <>

639: begin
640: hr_utility.set_location('Entering:'||l_proc,10);
641: --
642: if ((p_rec.comptncy_rt_id is not null) and (
643: nvl(ben_cty_shd.g_old_rec.cty_attribute_category, hr_api.g_varchar2) <>
644: nvl(p_rec.cty_attribute_category, hr_api.g_varchar2) or
645: nvl(ben_cty_shd.g_old_rec.cty_attribute1, hr_api.g_varchar2) <>
646: nvl(p_rec.cty_attribute1, hr_api.g_varchar2) or
647: nvl(ben_cty_shd.g_old_rec.cty_attribute2, hr_api.g_varchar2) <>

Line 645: nvl(ben_cty_shd.g_old_rec.cty_attribute1, hr_api.g_varchar2) <>

641: --
642: if ((p_rec.comptncy_rt_id is not null) and (
643: nvl(ben_cty_shd.g_old_rec.cty_attribute_category, hr_api.g_varchar2) <>
644: nvl(p_rec.cty_attribute_category, hr_api.g_varchar2) or
645: nvl(ben_cty_shd.g_old_rec.cty_attribute1, hr_api.g_varchar2) <>
646: nvl(p_rec.cty_attribute1, hr_api.g_varchar2) or
647: nvl(ben_cty_shd.g_old_rec.cty_attribute2, hr_api.g_varchar2) <>
648: nvl(p_rec.cty_attribute2, hr_api.g_varchar2) or
649: nvl(ben_cty_shd.g_old_rec.cty_attribute3, hr_api.g_varchar2) <>

Line 647: nvl(ben_cty_shd.g_old_rec.cty_attribute2, hr_api.g_varchar2) <>

643: nvl(ben_cty_shd.g_old_rec.cty_attribute_category, hr_api.g_varchar2) <>
644: nvl(p_rec.cty_attribute_category, hr_api.g_varchar2) or
645: nvl(ben_cty_shd.g_old_rec.cty_attribute1, hr_api.g_varchar2) <>
646: nvl(p_rec.cty_attribute1, hr_api.g_varchar2) or
647: nvl(ben_cty_shd.g_old_rec.cty_attribute2, hr_api.g_varchar2) <>
648: nvl(p_rec.cty_attribute2, hr_api.g_varchar2) or
649: nvl(ben_cty_shd.g_old_rec.cty_attribute3, hr_api.g_varchar2) <>
650: nvl(p_rec.cty_attribute3, hr_api.g_varchar2) or
651: nvl(ben_cty_shd.g_old_rec.cty_attribute4, hr_api.g_varchar2) <>

Line 649: nvl(ben_cty_shd.g_old_rec.cty_attribute3, hr_api.g_varchar2) <>

645: nvl(ben_cty_shd.g_old_rec.cty_attribute1, hr_api.g_varchar2) <>
646: nvl(p_rec.cty_attribute1, hr_api.g_varchar2) or
647: nvl(ben_cty_shd.g_old_rec.cty_attribute2, hr_api.g_varchar2) <>
648: nvl(p_rec.cty_attribute2, hr_api.g_varchar2) or
649: nvl(ben_cty_shd.g_old_rec.cty_attribute3, hr_api.g_varchar2) <>
650: nvl(p_rec.cty_attribute3, hr_api.g_varchar2) or
651: nvl(ben_cty_shd.g_old_rec.cty_attribute4, hr_api.g_varchar2) <>
652: nvl(p_rec.cty_attribute4, hr_api.g_varchar2) or
653: nvl(ben_cty_shd.g_old_rec.cty_attribute5, hr_api.g_varchar2) <>

Line 651: nvl(ben_cty_shd.g_old_rec.cty_attribute4, hr_api.g_varchar2) <>

647: nvl(ben_cty_shd.g_old_rec.cty_attribute2, hr_api.g_varchar2) <>
648: nvl(p_rec.cty_attribute2, hr_api.g_varchar2) or
649: nvl(ben_cty_shd.g_old_rec.cty_attribute3, hr_api.g_varchar2) <>
650: nvl(p_rec.cty_attribute3, hr_api.g_varchar2) or
651: nvl(ben_cty_shd.g_old_rec.cty_attribute4, hr_api.g_varchar2) <>
652: nvl(p_rec.cty_attribute4, hr_api.g_varchar2) or
653: nvl(ben_cty_shd.g_old_rec.cty_attribute5, hr_api.g_varchar2) <>
654: nvl(p_rec.cty_attribute5, hr_api.g_varchar2) or
655: nvl(ben_cty_shd.g_old_rec.cty_attribute6, hr_api.g_varchar2) <>

Line 653: nvl(ben_cty_shd.g_old_rec.cty_attribute5, hr_api.g_varchar2) <>

649: nvl(ben_cty_shd.g_old_rec.cty_attribute3, hr_api.g_varchar2) <>
650: nvl(p_rec.cty_attribute3, hr_api.g_varchar2) or
651: nvl(ben_cty_shd.g_old_rec.cty_attribute4, hr_api.g_varchar2) <>
652: nvl(p_rec.cty_attribute4, hr_api.g_varchar2) or
653: nvl(ben_cty_shd.g_old_rec.cty_attribute5, hr_api.g_varchar2) <>
654: nvl(p_rec.cty_attribute5, hr_api.g_varchar2) or
655: nvl(ben_cty_shd.g_old_rec.cty_attribute6, hr_api.g_varchar2) <>
656: nvl(p_rec.cty_attribute6, hr_api.g_varchar2) or
657: nvl(ben_cty_shd.g_old_rec.cty_attribute7, hr_api.g_varchar2) <>

Line 655: nvl(ben_cty_shd.g_old_rec.cty_attribute6, hr_api.g_varchar2) <>

651: nvl(ben_cty_shd.g_old_rec.cty_attribute4, hr_api.g_varchar2) <>
652: nvl(p_rec.cty_attribute4, hr_api.g_varchar2) or
653: nvl(ben_cty_shd.g_old_rec.cty_attribute5, hr_api.g_varchar2) <>
654: nvl(p_rec.cty_attribute5, hr_api.g_varchar2) or
655: nvl(ben_cty_shd.g_old_rec.cty_attribute6, hr_api.g_varchar2) <>
656: nvl(p_rec.cty_attribute6, hr_api.g_varchar2) or
657: nvl(ben_cty_shd.g_old_rec.cty_attribute7, hr_api.g_varchar2) <>
658: nvl(p_rec.cty_attribute7, hr_api.g_varchar2) or
659: nvl(ben_cty_shd.g_old_rec.cty_attribute8, hr_api.g_varchar2) <>

Line 657: nvl(ben_cty_shd.g_old_rec.cty_attribute7, hr_api.g_varchar2) <>

653: nvl(ben_cty_shd.g_old_rec.cty_attribute5, hr_api.g_varchar2) <>
654: nvl(p_rec.cty_attribute5, hr_api.g_varchar2) or
655: nvl(ben_cty_shd.g_old_rec.cty_attribute6, hr_api.g_varchar2) <>
656: nvl(p_rec.cty_attribute6, hr_api.g_varchar2) or
657: nvl(ben_cty_shd.g_old_rec.cty_attribute7, hr_api.g_varchar2) <>
658: nvl(p_rec.cty_attribute7, hr_api.g_varchar2) or
659: nvl(ben_cty_shd.g_old_rec.cty_attribute8, hr_api.g_varchar2) <>
660: nvl(p_rec.cty_attribute8, hr_api.g_varchar2) or
661: nvl(ben_cty_shd.g_old_rec.cty_attribute9, hr_api.g_varchar2) <>

Line 659: nvl(ben_cty_shd.g_old_rec.cty_attribute8, hr_api.g_varchar2) <>

655: nvl(ben_cty_shd.g_old_rec.cty_attribute6, hr_api.g_varchar2) <>
656: nvl(p_rec.cty_attribute6, hr_api.g_varchar2) or
657: nvl(ben_cty_shd.g_old_rec.cty_attribute7, hr_api.g_varchar2) <>
658: nvl(p_rec.cty_attribute7, hr_api.g_varchar2) or
659: nvl(ben_cty_shd.g_old_rec.cty_attribute8, hr_api.g_varchar2) <>
660: nvl(p_rec.cty_attribute8, hr_api.g_varchar2) or
661: nvl(ben_cty_shd.g_old_rec.cty_attribute9, hr_api.g_varchar2) <>
662: nvl(p_rec.cty_attribute9, hr_api.g_varchar2) or
663: nvl(ben_cty_shd.g_old_rec.cty_attribute10, hr_api.g_varchar2) <>

Line 661: nvl(ben_cty_shd.g_old_rec.cty_attribute9, hr_api.g_varchar2) <>

657: nvl(ben_cty_shd.g_old_rec.cty_attribute7, hr_api.g_varchar2) <>
658: nvl(p_rec.cty_attribute7, hr_api.g_varchar2) or
659: nvl(ben_cty_shd.g_old_rec.cty_attribute8, hr_api.g_varchar2) <>
660: nvl(p_rec.cty_attribute8, hr_api.g_varchar2) or
661: nvl(ben_cty_shd.g_old_rec.cty_attribute9, hr_api.g_varchar2) <>
662: nvl(p_rec.cty_attribute9, hr_api.g_varchar2) or
663: nvl(ben_cty_shd.g_old_rec.cty_attribute10, hr_api.g_varchar2) <>
664: nvl(p_rec.cty_attribute10, hr_api.g_varchar2) or
665: nvl(ben_cty_shd.g_old_rec.cty_attribute11, hr_api.g_varchar2) <>

Line 663: nvl(ben_cty_shd.g_old_rec.cty_attribute10, hr_api.g_varchar2) <>

659: nvl(ben_cty_shd.g_old_rec.cty_attribute8, hr_api.g_varchar2) <>
660: nvl(p_rec.cty_attribute8, hr_api.g_varchar2) or
661: nvl(ben_cty_shd.g_old_rec.cty_attribute9, hr_api.g_varchar2) <>
662: nvl(p_rec.cty_attribute9, hr_api.g_varchar2) or
663: nvl(ben_cty_shd.g_old_rec.cty_attribute10, hr_api.g_varchar2) <>
664: nvl(p_rec.cty_attribute10, hr_api.g_varchar2) or
665: nvl(ben_cty_shd.g_old_rec.cty_attribute11, hr_api.g_varchar2) <>
666: nvl(p_rec.cty_attribute11, hr_api.g_varchar2) or
667: nvl(ben_cty_shd.g_old_rec.cty_attribute12, hr_api.g_varchar2) <>

Line 665: nvl(ben_cty_shd.g_old_rec.cty_attribute11, hr_api.g_varchar2) <>

661: nvl(ben_cty_shd.g_old_rec.cty_attribute9, hr_api.g_varchar2) <>
662: nvl(p_rec.cty_attribute9, hr_api.g_varchar2) or
663: nvl(ben_cty_shd.g_old_rec.cty_attribute10, hr_api.g_varchar2) <>
664: nvl(p_rec.cty_attribute10, hr_api.g_varchar2) or
665: nvl(ben_cty_shd.g_old_rec.cty_attribute11, hr_api.g_varchar2) <>
666: nvl(p_rec.cty_attribute11, hr_api.g_varchar2) or
667: nvl(ben_cty_shd.g_old_rec.cty_attribute12, hr_api.g_varchar2) <>
668: nvl(p_rec.cty_attribute12, hr_api.g_varchar2) or
669: nvl(ben_cty_shd.g_old_rec.cty_attribute13, hr_api.g_varchar2) <>

Line 667: nvl(ben_cty_shd.g_old_rec.cty_attribute12, hr_api.g_varchar2) <>

663: nvl(ben_cty_shd.g_old_rec.cty_attribute10, hr_api.g_varchar2) <>
664: nvl(p_rec.cty_attribute10, hr_api.g_varchar2) or
665: nvl(ben_cty_shd.g_old_rec.cty_attribute11, hr_api.g_varchar2) <>
666: nvl(p_rec.cty_attribute11, hr_api.g_varchar2) or
667: nvl(ben_cty_shd.g_old_rec.cty_attribute12, hr_api.g_varchar2) <>
668: nvl(p_rec.cty_attribute12, hr_api.g_varchar2) or
669: nvl(ben_cty_shd.g_old_rec.cty_attribute13, hr_api.g_varchar2) <>
670: nvl(p_rec.cty_attribute13, hr_api.g_varchar2) or
671: nvl(ben_cty_shd.g_old_rec.cty_attribute14, hr_api.g_varchar2) <>

Line 669: nvl(ben_cty_shd.g_old_rec.cty_attribute13, hr_api.g_varchar2) <>

665: nvl(ben_cty_shd.g_old_rec.cty_attribute11, hr_api.g_varchar2) <>
666: nvl(p_rec.cty_attribute11, hr_api.g_varchar2) or
667: nvl(ben_cty_shd.g_old_rec.cty_attribute12, hr_api.g_varchar2) <>
668: nvl(p_rec.cty_attribute12, hr_api.g_varchar2) or
669: nvl(ben_cty_shd.g_old_rec.cty_attribute13, hr_api.g_varchar2) <>
670: nvl(p_rec.cty_attribute13, hr_api.g_varchar2) or
671: nvl(ben_cty_shd.g_old_rec.cty_attribute14, hr_api.g_varchar2) <>
672: nvl(p_rec.cty_attribute14, hr_api.g_varchar2) or
673: nvl(ben_cty_shd.g_old_rec.cty_attribute15, hr_api.g_varchar2) <>

Line 671: nvl(ben_cty_shd.g_old_rec.cty_attribute14, hr_api.g_varchar2) <>

667: nvl(ben_cty_shd.g_old_rec.cty_attribute12, hr_api.g_varchar2) <>
668: nvl(p_rec.cty_attribute12, hr_api.g_varchar2) or
669: nvl(ben_cty_shd.g_old_rec.cty_attribute13, hr_api.g_varchar2) <>
670: nvl(p_rec.cty_attribute13, hr_api.g_varchar2) or
671: nvl(ben_cty_shd.g_old_rec.cty_attribute14, hr_api.g_varchar2) <>
672: nvl(p_rec.cty_attribute14, hr_api.g_varchar2) or
673: nvl(ben_cty_shd.g_old_rec.cty_attribute15, hr_api.g_varchar2) <>
674: nvl(p_rec.cty_attribute15, hr_api.g_varchar2) or
675: nvl(ben_cty_shd.g_old_rec.cty_attribute16, hr_api.g_varchar2) <>

Line 673: nvl(ben_cty_shd.g_old_rec.cty_attribute15, hr_api.g_varchar2) <>

669: nvl(ben_cty_shd.g_old_rec.cty_attribute13, hr_api.g_varchar2) <>
670: nvl(p_rec.cty_attribute13, hr_api.g_varchar2) or
671: nvl(ben_cty_shd.g_old_rec.cty_attribute14, hr_api.g_varchar2) <>
672: nvl(p_rec.cty_attribute14, hr_api.g_varchar2) or
673: nvl(ben_cty_shd.g_old_rec.cty_attribute15, hr_api.g_varchar2) <>
674: nvl(p_rec.cty_attribute15, hr_api.g_varchar2) or
675: nvl(ben_cty_shd.g_old_rec.cty_attribute16, hr_api.g_varchar2) <>
676: nvl(p_rec.cty_attribute16, hr_api.g_varchar2) or
677: nvl(ben_cty_shd.g_old_rec.cty_attribute17, hr_api.g_varchar2) <>

Line 675: nvl(ben_cty_shd.g_old_rec.cty_attribute16, hr_api.g_varchar2) <>

671: nvl(ben_cty_shd.g_old_rec.cty_attribute14, hr_api.g_varchar2) <>
672: nvl(p_rec.cty_attribute14, hr_api.g_varchar2) or
673: nvl(ben_cty_shd.g_old_rec.cty_attribute15, hr_api.g_varchar2) <>
674: nvl(p_rec.cty_attribute15, hr_api.g_varchar2) or
675: nvl(ben_cty_shd.g_old_rec.cty_attribute16, hr_api.g_varchar2) <>
676: nvl(p_rec.cty_attribute16, hr_api.g_varchar2) or
677: nvl(ben_cty_shd.g_old_rec.cty_attribute17, hr_api.g_varchar2) <>
678: nvl(p_rec.cty_attribute17, hr_api.g_varchar2) or
679: nvl(ben_cty_shd.g_old_rec.cty_attribute18, hr_api.g_varchar2) <>

Line 677: nvl(ben_cty_shd.g_old_rec.cty_attribute17, hr_api.g_varchar2) <>

673: nvl(ben_cty_shd.g_old_rec.cty_attribute15, hr_api.g_varchar2) <>
674: nvl(p_rec.cty_attribute15, hr_api.g_varchar2) or
675: nvl(ben_cty_shd.g_old_rec.cty_attribute16, hr_api.g_varchar2) <>
676: nvl(p_rec.cty_attribute16, hr_api.g_varchar2) or
677: nvl(ben_cty_shd.g_old_rec.cty_attribute17, hr_api.g_varchar2) <>
678: nvl(p_rec.cty_attribute17, hr_api.g_varchar2) or
679: nvl(ben_cty_shd.g_old_rec.cty_attribute18, hr_api.g_varchar2) <>
680: nvl(p_rec.cty_attribute18, hr_api.g_varchar2) or
681: nvl(ben_cty_shd.g_old_rec.cty_attribute19, hr_api.g_varchar2) <>

Line 679: nvl(ben_cty_shd.g_old_rec.cty_attribute18, hr_api.g_varchar2) <>

675: nvl(ben_cty_shd.g_old_rec.cty_attribute16, hr_api.g_varchar2) <>
676: nvl(p_rec.cty_attribute16, hr_api.g_varchar2) or
677: nvl(ben_cty_shd.g_old_rec.cty_attribute17, hr_api.g_varchar2) <>
678: nvl(p_rec.cty_attribute17, hr_api.g_varchar2) or
679: nvl(ben_cty_shd.g_old_rec.cty_attribute18, hr_api.g_varchar2) <>
680: nvl(p_rec.cty_attribute18, hr_api.g_varchar2) or
681: nvl(ben_cty_shd.g_old_rec.cty_attribute19, hr_api.g_varchar2) <>
682: nvl(p_rec.cty_attribute19, hr_api.g_varchar2) or
683: nvl(ben_cty_shd.g_old_rec.cty_attribute20, hr_api.g_varchar2) <>

Line 681: nvl(ben_cty_shd.g_old_rec.cty_attribute19, hr_api.g_varchar2) <>

677: nvl(ben_cty_shd.g_old_rec.cty_attribute17, hr_api.g_varchar2) <>
678: nvl(p_rec.cty_attribute17, hr_api.g_varchar2) or
679: nvl(ben_cty_shd.g_old_rec.cty_attribute18, hr_api.g_varchar2) <>
680: nvl(p_rec.cty_attribute18, hr_api.g_varchar2) or
681: nvl(ben_cty_shd.g_old_rec.cty_attribute19, hr_api.g_varchar2) <>
682: nvl(p_rec.cty_attribute19, hr_api.g_varchar2) or
683: nvl(ben_cty_shd.g_old_rec.cty_attribute20, hr_api.g_varchar2) <>
684: nvl(p_rec.cty_attribute20, hr_api.g_varchar2) or
685: nvl(ben_cty_shd.g_old_rec.cty_attribute21, hr_api.g_varchar2) <>

Line 683: nvl(ben_cty_shd.g_old_rec.cty_attribute20, hr_api.g_varchar2) <>

679: nvl(ben_cty_shd.g_old_rec.cty_attribute18, hr_api.g_varchar2) <>
680: nvl(p_rec.cty_attribute18, hr_api.g_varchar2) or
681: nvl(ben_cty_shd.g_old_rec.cty_attribute19, hr_api.g_varchar2) <>
682: nvl(p_rec.cty_attribute19, hr_api.g_varchar2) or
683: nvl(ben_cty_shd.g_old_rec.cty_attribute20, hr_api.g_varchar2) <>
684: nvl(p_rec.cty_attribute20, hr_api.g_varchar2) or
685: nvl(ben_cty_shd.g_old_rec.cty_attribute21, hr_api.g_varchar2) <>
686: nvl(p_rec.cty_attribute21, hr_api.g_varchar2) or
687: nvl(ben_cty_shd.g_old_rec.cty_attribute22, hr_api.g_varchar2) <>

Line 685: nvl(ben_cty_shd.g_old_rec.cty_attribute21, hr_api.g_varchar2) <>

681: nvl(ben_cty_shd.g_old_rec.cty_attribute19, hr_api.g_varchar2) <>
682: nvl(p_rec.cty_attribute19, hr_api.g_varchar2) or
683: nvl(ben_cty_shd.g_old_rec.cty_attribute20, hr_api.g_varchar2) <>
684: nvl(p_rec.cty_attribute20, hr_api.g_varchar2) or
685: nvl(ben_cty_shd.g_old_rec.cty_attribute21, hr_api.g_varchar2) <>
686: nvl(p_rec.cty_attribute21, hr_api.g_varchar2) or
687: nvl(ben_cty_shd.g_old_rec.cty_attribute22, hr_api.g_varchar2) <>
688: nvl(p_rec.cty_attribute22, hr_api.g_varchar2) or
689: nvl(ben_cty_shd.g_old_rec.cty_attribute23, hr_api.g_varchar2) <>

Line 687: nvl(ben_cty_shd.g_old_rec.cty_attribute22, hr_api.g_varchar2) <>

683: nvl(ben_cty_shd.g_old_rec.cty_attribute20, hr_api.g_varchar2) <>
684: nvl(p_rec.cty_attribute20, hr_api.g_varchar2) or
685: nvl(ben_cty_shd.g_old_rec.cty_attribute21, hr_api.g_varchar2) <>
686: nvl(p_rec.cty_attribute21, hr_api.g_varchar2) or
687: nvl(ben_cty_shd.g_old_rec.cty_attribute22, hr_api.g_varchar2) <>
688: nvl(p_rec.cty_attribute22, hr_api.g_varchar2) or
689: nvl(ben_cty_shd.g_old_rec.cty_attribute23, hr_api.g_varchar2) <>
690: nvl(p_rec.cty_attribute23, hr_api.g_varchar2) or
691: nvl(ben_cty_shd.g_old_rec.cty_attribute24, hr_api.g_varchar2) <>

Line 689: nvl(ben_cty_shd.g_old_rec.cty_attribute23, hr_api.g_varchar2) <>

685: nvl(ben_cty_shd.g_old_rec.cty_attribute21, hr_api.g_varchar2) <>
686: nvl(p_rec.cty_attribute21, hr_api.g_varchar2) or
687: nvl(ben_cty_shd.g_old_rec.cty_attribute22, hr_api.g_varchar2) <>
688: nvl(p_rec.cty_attribute22, hr_api.g_varchar2) or
689: nvl(ben_cty_shd.g_old_rec.cty_attribute23, hr_api.g_varchar2) <>
690: nvl(p_rec.cty_attribute23, hr_api.g_varchar2) or
691: nvl(ben_cty_shd.g_old_rec.cty_attribute24, hr_api.g_varchar2) <>
692: nvl(p_rec.cty_attribute24, hr_api.g_varchar2) or
693: nvl(ben_cty_shd.g_old_rec.cty_attribute25, hr_api.g_varchar2) <>

Line 691: nvl(ben_cty_shd.g_old_rec.cty_attribute24, hr_api.g_varchar2) <>

687: nvl(ben_cty_shd.g_old_rec.cty_attribute22, hr_api.g_varchar2) <>
688: nvl(p_rec.cty_attribute22, hr_api.g_varchar2) or
689: nvl(ben_cty_shd.g_old_rec.cty_attribute23, hr_api.g_varchar2) <>
690: nvl(p_rec.cty_attribute23, hr_api.g_varchar2) or
691: nvl(ben_cty_shd.g_old_rec.cty_attribute24, hr_api.g_varchar2) <>
692: nvl(p_rec.cty_attribute24, hr_api.g_varchar2) or
693: nvl(ben_cty_shd.g_old_rec.cty_attribute25, hr_api.g_varchar2) <>
694: nvl(p_rec.cty_attribute25, hr_api.g_varchar2) or
695: nvl(ben_cty_shd.g_old_rec.cty_attribute26, hr_api.g_varchar2) <>

Line 693: nvl(ben_cty_shd.g_old_rec.cty_attribute25, hr_api.g_varchar2) <>

689: nvl(ben_cty_shd.g_old_rec.cty_attribute23, hr_api.g_varchar2) <>
690: nvl(p_rec.cty_attribute23, hr_api.g_varchar2) or
691: nvl(ben_cty_shd.g_old_rec.cty_attribute24, hr_api.g_varchar2) <>
692: nvl(p_rec.cty_attribute24, hr_api.g_varchar2) or
693: nvl(ben_cty_shd.g_old_rec.cty_attribute25, hr_api.g_varchar2) <>
694: nvl(p_rec.cty_attribute25, hr_api.g_varchar2) or
695: nvl(ben_cty_shd.g_old_rec.cty_attribute26, hr_api.g_varchar2) <>
696: nvl(p_rec.cty_attribute26, hr_api.g_varchar2) or
697: nvl(ben_cty_shd.g_old_rec.cty_attribute27, hr_api.g_varchar2) <>

Line 695: nvl(ben_cty_shd.g_old_rec.cty_attribute26, hr_api.g_varchar2) <>

691: nvl(ben_cty_shd.g_old_rec.cty_attribute24, hr_api.g_varchar2) <>
692: nvl(p_rec.cty_attribute24, hr_api.g_varchar2) or
693: nvl(ben_cty_shd.g_old_rec.cty_attribute25, hr_api.g_varchar2) <>
694: nvl(p_rec.cty_attribute25, hr_api.g_varchar2) or
695: nvl(ben_cty_shd.g_old_rec.cty_attribute26, hr_api.g_varchar2) <>
696: nvl(p_rec.cty_attribute26, hr_api.g_varchar2) or
697: nvl(ben_cty_shd.g_old_rec.cty_attribute27, hr_api.g_varchar2) <>
698: nvl(p_rec.cty_attribute27, hr_api.g_varchar2) or
699: nvl(ben_cty_shd.g_old_rec.cty_attribute28, hr_api.g_varchar2) <>

Line 697: nvl(ben_cty_shd.g_old_rec.cty_attribute27, hr_api.g_varchar2) <>

693: nvl(ben_cty_shd.g_old_rec.cty_attribute25, hr_api.g_varchar2) <>
694: nvl(p_rec.cty_attribute25, hr_api.g_varchar2) or
695: nvl(ben_cty_shd.g_old_rec.cty_attribute26, hr_api.g_varchar2) <>
696: nvl(p_rec.cty_attribute26, hr_api.g_varchar2) or
697: nvl(ben_cty_shd.g_old_rec.cty_attribute27, hr_api.g_varchar2) <>
698: nvl(p_rec.cty_attribute27, hr_api.g_varchar2) or
699: nvl(ben_cty_shd.g_old_rec.cty_attribute28, hr_api.g_varchar2) <>
700: nvl(p_rec.cty_attribute28, hr_api.g_varchar2) or
701: nvl(ben_cty_shd.g_old_rec.cty_attribute29, hr_api.g_varchar2) <>

Line 699: nvl(ben_cty_shd.g_old_rec.cty_attribute28, hr_api.g_varchar2) <>

695: nvl(ben_cty_shd.g_old_rec.cty_attribute26, hr_api.g_varchar2) <>
696: nvl(p_rec.cty_attribute26, hr_api.g_varchar2) or
697: nvl(ben_cty_shd.g_old_rec.cty_attribute27, hr_api.g_varchar2) <>
698: nvl(p_rec.cty_attribute27, hr_api.g_varchar2) or
699: nvl(ben_cty_shd.g_old_rec.cty_attribute28, hr_api.g_varchar2) <>
700: nvl(p_rec.cty_attribute28, hr_api.g_varchar2) or
701: nvl(ben_cty_shd.g_old_rec.cty_attribute29, hr_api.g_varchar2) <>
702: nvl(p_rec.cty_attribute29, hr_api.g_varchar2) or
703: nvl(ben_cty_shd.g_old_rec.cty_attribute30, hr_api.g_varchar2) <>

Line 701: nvl(ben_cty_shd.g_old_rec.cty_attribute29, hr_api.g_varchar2) <>

697: nvl(ben_cty_shd.g_old_rec.cty_attribute27, hr_api.g_varchar2) <>
698: nvl(p_rec.cty_attribute27, hr_api.g_varchar2) or
699: nvl(ben_cty_shd.g_old_rec.cty_attribute28, hr_api.g_varchar2) <>
700: nvl(p_rec.cty_attribute28, hr_api.g_varchar2) or
701: nvl(ben_cty_shd.g_old_rec.cty_attribute29, hr_api.g_varchar2) <>
702: nvl(p_rec.cty_attribute29, hr_api.g_varchar2) or
703: nvl(ben_cty_shd.g_old_rec.cty_attribute30, hr_api.g_varchar2) <>
704: nvl(p_rec.cty_attribute30, hr_api.g_varchar2) ))
705: or (p_rec.comptncy_rt_id is null) then

Line 703: nvl(ben_cty_shd.g_old_rec.cty_attribute30, hr_api.g_varchar2) <>

699: nvl(ben_cty_shd.g_old_rec.cty_attribute28, hr_api.g_varchar2) <>
700: nvl(p_rec.cty_attribute28, hr_api.g_varchar2) or
701: nvl(ben_cty_shd.g_old_rec.cty_attribute29, hr_api.g_varchar2) <>
702: nvl(p_rec.cty_attribute29, hr_api.g_varchar2) or
703: nvl(ben_cty_shd.g_old_rec.cty_attribute30, hr_api.g_varchar2) <>
704: nvl(p_rec.cty_attribute30, hr_api.g_varchar2) ))
705: or (p_rec.comptncy_rt_id is null) then
706: --
707: -- Only execute the validation if absolutely necessary:

Line 811: ,p_rec in ben_cty_shd.g_rec_type

807: -- {End Of Comments}
808: -- ----------------------------------------------------------------------------
809: Procedure chk_non_updateable_args
810: (p_effective_date in date
811: ,p_rec in ben_cty_shd.g_rec_type
812: ) IS
813: --
814: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
815: --

Line 821: IF NOT ben_cty_shd.api_updating

817: --
818: -- Only proceed with the validation if a row exists for the current
819: -- record in the HR Schema.
820: --
821: IF NOT ben_cty_shd.api_updating
822: (p_comptncy_rt_id => p_rec.comptncy_rt_id
823: ,p_effective_date => p_effective_date
824: ,p_object_version_number => p_rec.object_version_number
825: ) THEN

Line 911: (p_associated_column1 => ben_cty_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');

907: ,p_to_date => p_validation_end_date))) Then
908: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
909: fnd_message.set_token('TABLE_NAME','vrbl rt prfl');
910: hr_multi_message.add
911: (p_associated_column1 => ben_cty_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');
912: End If;
913: --
914: Exception
915: When Others Then

Line 1028: (p_rec in ben_cty_shd.g_rec_type

1024: -- ----------------------------------------------------------------------------
1025: -- |---------------------------< insert_validate >----------------------------|
1026: -- ----------------------------------------------------------------------------
1027: Procedure insert_validate
1028: (p_rec in ben_cty_shd.g_rec_type
1029: ,p_effective_date in date
1030: ,p_datetrack_mode in varchar2
1031: ,p_validation_start_date in date
1032: ,p_validation_end_date in date

Line 1044: ,p_associated_column1 => ben_cty_shd.g_tab_nam

1040: -- Call all supporting business operations
1041: --
1042: hr_api.validate_bus_grp_id
1043: (p_business_group_id => p_rec.business_group_id
1044: ,p_associated_column1 => ben_cty_shd.g_tab_nam
1045: || '.BUSINESS_GROUP_ID');
1046: --
1047:
1048: chk_comptncy_rt_id

Line 1108: (p_rec in ben_cty_shd.g_rec_type

1104: -- ----------------------------------------------------------------------------
1105: -- |---------------------------< update_validate >----------------------------|
1106: -- ----------------------------------------------------------------------------
1107: Procedure update_validate
1108: (p_rec in ben_cty_shd.g_rec_type
1109: ,p_effective_date in date
1110: ,p_datetrack_mode in varchar2
1111: ,p_validation_start_date in date
1112: ,p_validation_end_date in date

Line 1124: ,p_associated_column1 => ben_cty_shd.g_tab_nam

1120: -- Call all supporting business operations
1121: --
1122: hr_api.validate_bus_grp_id
1123: (p_business_group_id => p_rec.business_group_id
1124: ,p_associated_column1 => ben_cty_shd.g_tab_nam
1125: || '.BUSINESS_GROUP_ID');
1126:
1127: chk_comptncy_rt_id
1128: (p_comptncy_rt_id => p_rec.comptncy_rt_id,

Line 1200: (p_rec in ben_cty_shd.g_rec_type

1196: -- ----------------------------------------------------------------------------
1197: -- |---------------------------< delete_validate >----------------------------|
1198: -- ----------------------------------------------------------------------------
1199: Procedure delete_validate
1200: (p_rec in ben_cty_shd.g_rec_type
1201: ,p_effective_date in date
1202: ,p_datetrack_mode in varchar2
1203: ,p_validation_start_date in date
1204: ,p_validation_end_date in date