APPS.BEN_QIG_BUS dependencies on BEN_QIG_SHD

Line 54: l_api_updating := ben_qig_shd.api_updating

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

Line 61: <> ben_qig_shd.g_old_rec.qua_in_gr_rt_id) then

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

Line 65: ben_qig_shd.constraint_error('BEN_QUA_IN_GR_RT_F_PK');

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

Line 75: ben_qig_shd.constraint_error('BEN_QUA_IN_GR_RT_F_PK');

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

Line 151: l_api_updating := ben_qig_shd.api_updating

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

Line 158: <> nvl(ben_qig_shd.g_old_rec.quar_in_grade_cd,hr_api.g_varchar2)

154: p_object_version_number => p_object_version_number);
155: --
156: if (l_api_updating
157: and nvl(p_quar_in_grade_cd,hr_api.g_varchar2)
158: <> nvl(ben_qig_shd.g_old_rec.quar_in_grade_cd,hr_api.g_varchar2)
159: or not l_api_updating) then
160: --
161: -- check if quar_in_grade_cd value exists in hr_lookups table
162: --

Line 173: ben_qig_shd.constraint_error('BEN_QUA_IN_GR_RT_FK2');

169: --
170: -- raise error as FK does not relate to PK
171: -- table.
172: --
173: ben_qig_shd.constraint_error('BEN_QUA_IN_GR_RT_FK2');
174: --
175: end if;
176: --
177: close c1;

Line 239: l_api_updating := ben_qig_shd.api_updating

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

Line 246: <> nvl(ben_qig_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 436: (p_rec in ben_qig_shd.g_rec_type

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

Line 445: nvl(ben_qig_shd.g_old_rec.qig_attribute_category, hr_api.g_varchar2) <>

441: begin
442: hr_utility.set_location('Entering:'||l_proc,10);
443: --
444: if ((p_rec.qua_in_gr_rt_id is not null) and (
445: nvl(ben_qig_shd.g_old_rec.qig_attribute_category, hr_api.g_varchar2) <>
446: nvl(p_rec.qig_attribute_category, hr_api.g_varchar2) or
447: nvl(ben_qig_shd.g_old_rec.qig_attribute1, hr_api.g_varchar2) <>
448: nvl(p_rec.qig_attribute1, hr_api.g_varchar2) or
449: nvl(ben_qig_shd.g_old_rec.qig_attribute2, hr_api.g_varchar2) <>

Line 447: nvl(ben_qig_shd.g_old_rec.qig_attribute1, hr_api.g_varchar2) <>

443: --
444: if ((p_rec.qua_in_gr_rt_id is not null) and (
445: nvl(ben_qig_shd.g_old_rec.qig_attribute_category, hr_api.g_varchar2) <>
446: nvl(p_rec.qig_attribute_category, hr_api.g_varchar2) or
447: nvl(ben_qig_shd.g_old_rec.qig_attribute1, hr_api.g_varchar2) <>
448: nvl(p_rec.qig_attribute1, hr_api.g_varchar2) or
449: nvl(ben_qig_shd.g_old_rec.qig_attribute2, hr_api.g_varchar2) <>
450: nvl(p_rec.qig_attribute2, hr_api.g_varchar2) or
451: nvl(ben_qig_shd.g_old_rec.qig_attribute3, hr_api.g_varchar2) <>

Line 449: nvl(ben_qig_shd.g_old_rec.qig_attribute2, hr_api.g_varchar2) <>

445: nvl(ben_qig_shd.g_old_rec.qig_attribute_category, hr_api.g_varchar2) <>
446: nvl(p_rec.qig_attribute_category, hr_api.g_varchar2) or
447: nvl(ben_qig_shd.g_old_rec.qig_attribute1, hr_api.g_varchar2) <>
448: nvl(p_rec.qig_attribute1, hr_api.g_varchar2) or
449: nvl(ben_qig_shd.g_old_rec.qig_attribute2, hr_api.g_varchar2) <>
450: nvl(p_rec.qig_attribute2, hr_api.g_varchar2) or
451: nvl(ben_qig_shd.g_old_rec.qig_attribute3, hr_api.g_varchar2) <>
452: nvl(p_rec.qig_attribute3, hr_api.g_varchar2) or
453: nvl(ben_qig_shd.g_old_rec.qig_attribute4, hr_api.g_varchar2) <>

Line 451: nvl(ben_qig_shd.g_old_rec.qig_attribute3, hr_api.g_varchar2) <>

447: nvl(ben_qig_shd.g_old_rec.qig_attribute1, hr_api.g_varchar2) <>
448: nvl(p_rec.qig_attribute1, hr_api.g_varchar2) or
449: nvl(ben_qig_shd.g_old_rec.qig_attribute2, hr_api.g_varchar2) <>
450: nvl(p_rec.qig_attribute2, hr_api.g_varchar2) or
451: nvl(ben_qig_shd.g_old_rec.qig_attribute3, hr_api.g_varchar2) <>
452: nvl(p_rec.qig_attribute3, hr_api.g_varchar2) or
453: nvl(ben_qig_shd.g_old_rec.qig_attribute4, hr_api.g_varchar2) <>
454: nvl(p_rec.qig_attribute4, hr_api.g_varchar2) or
455: nvl(ben_qig_shd.g_old_rec.qig_attribute5, hr_api.g_varchar2) <>

Line 453: nvl(ben_qig_shd.g_old_rec.qig_attribute4, hr_api.g_varchar2) <>

449: nvl(ben_qig_shd.g_old_rec.qig_attribute2, hr_api.g_varchar2) <>
450: nvl(p_rec.qig_attribute2, hr_api.g_varchar2) or
451: nvl(ben_qig_shd.g_old_rec.qig_attribute3, hr_api.g_varchar2) <>
452: nvl(p_rec.qig_attribute3, hr_api.g_varchar2) or
453: nvl(ben_qig_shd.g_old_rec.qig_attribute4, hr_api.g_varchar2) <>
454: nvl(p_rec.qig_attribute4, hr_api.g_varchar2) or
455: nvl(ben_qig_shd.g_old_rec.qig_attribute5, hr_api.g_varchar2) <>
456: nvl(p_rec.qig_attribute5, hr_api.g_varchar2) or
457: nvl(ben_qig_shd.g_old_rec.qig_attribute6, hr_api.g_varchar2) <>

Line 455: nvl(ben_qig_shd.g_old_rec.qig_attribute5, hr_api.g_varchar2) <>

451: nvl(ben_qig_shd.g_old_rec.qig_attribute3, hr_api.g_varchar2) <>
452: nvl(p_rec.qig_attribute3, hr_api.g_varchar2) or
453: nvl(ben_qig_shd.g_old_rec.qig_attribute4, hr_api.g_varchar2) <>
454: nvl(p_rec.qig_attribute4, hr_api.g_varchar2) or
455: nvl(ben_qig_shd.g_old_rec.qig_attribute5, hr_api.g_varchar2) <>
456: nvl(p_rec.qig_attribute5, hr_api.g_varchar2) or
457: nvl(ben_qig_shd.g_old_rec.qig_attribute6, hr_api.g_varchar2) <>
458: nvl(p_rec.qig_attribute6, hr_api.g_varchar2) or
459: nvl(ben_qig_shd.g_old_rec.qig_attribute7, hr_api.g_varchar2) <>

Line 457: nvl(ben_qig_shd.g_old_rec.qig_attribute6, hr_api.g_varchar2) <>

453: nvl(ben_qig_shd.g_old_rec.qig_attribute4, hr_api.g_varchar2) <>
454: nvl(p_rec.qig_attribute4, hr_api.g_varchar2) or
455: nvl(ben_qig_shd.g_old_rec.qig_attribute5, hr_api.g_varchar2) <>
456: nvl(p_rec.qig_attribute5, hr_api.g_varchar2) or
457: nvl(ben_qig_shd.g_old_rec.qig_attribute6, hr_api.g_varchar2) <>
458: nvl(p_rec.qig_attribute6, hr_api.g_varchar2) or
459: nvl(ben_qig_shd.g_old_rec.qig_attribute7, hr_api.g_varchar2) <>
460: nvl(p_rec.qig_attribute7, hr_api.g_varchar2) or
461: nvl(ben_qig_shd.g_old_rec.qig_attribute8, hr_api.g_varchar2) <>

Line 459: nvl(ben_qig_shd.g_old_rec.qig_attribute7, hr_api.g_varchar2) <>

455: nvl(ben_qig_shd.g_old_rec.qig_attribute5, hr_api.g_varchar2) <>
456: nvl(p_rec.qig_attribute5, hr_api.g_varchar2) or
457: nvl(ben_qig_shd.g_old_rec.qig_attribute6, hr_api.g_varchar2) <>
458: nvl(p_rec.qig_attribute6, hr_api.g_varchar2) or
459: nvl(ben_qig_shd.g_old_rec.qig_attribute7, hr_api.g_varchar2) <>
460: nvl(p_rec.qig_attribute7, hr_api.g_varchar2) or
461: nvl(ben_qig_shd.g_old_rec.qig_attribute8, hr_api.g_varchar2) <>
462: nvl(p_rec.qig_attribute8, hr_api.g_varchar2) or
463: nvl(ben_qig_shd.g_old_rec.qig_attribute9, hr_api.g_varchar2) <>

Line 461: nvl(ben_qig_shd.g_old_rec.qig_attribute8, hr_api.g_varchar2) <>

457: nvl(ben_qig_shd.g_old_rec.qig_attribute6, hr_api.g_varchar2) <>
458: nvl(p_rec.qig_attribute6, hr_api.g_varchar2) or
459: nvl(ben_qig_shd.g_old_rec.qig_attribute7, hr_api.g_varchar2) <>
460: nvl(p_rec.qig_attribute7, hr_api.g_varchar2) or
461: nvl(ben_qig_shd.g_old_rec.qig_attribute8, hr_api.g_varchar2) <>
462: nvl(p_rec.qig_attribute8, hr_api.g_varchar2) or
463: nvl(ben_qig_shd.g_old_rec.qig_attribute9, hr_api.g_varchar2) <>
464: nvl(p_rec.qig_attribute9, hr_api.g_varchar2) or
465: nvl(ben_qig_shd.g_old_rec.qig_attribute10, hr_api.g_varchar2) <>

Line 463: nvl(ben_qig_shd.g_old_rec.qig_attribute9, hr_api.g_varchar2) <>

459: nvl(ben_qig_shd.g_old_rec.qig_attribute7, hr_api.g_varchar2) <>
460: nvl(p_rec.qig_attribute7, hr_api.g_varchar2) or
461: nvl(ben_qig_shd.g_old_rec.qig_attribute8, hr_api.g_varchar2) <>
462: nvl(p_rec.qig_attribute8, hr_api.g_varchar2) or
463: nvl(ben_qig_shd.g_old_rec.qig_attribute9, hr_api.g_varchar2) <>
464: nvl(p_rec.qig_attribute9, hr_api.g_varchar2) or
465: nvl(ben_qig_shd.g_old_rec.qig_attribute10, hr_api.g_varchar2) <>
466: nvl(p_rec.qig_attribute10, hr_api.g_varchar2) or
467: nvl(ben_qig_shd.g_old_rec.qig_attribute11, hr_api.g_varchar2) <>

Line 465: nvl(ben_qig_shd.g_old_rec.qig_attribute10, hr_api.g_varchar2) <>

461: nvl(ben_qig_shd.g_old_rec.qig_attribute8, hr_api.g_varchar2) <>
462: nvl(p_rec.qig_attribute8, hr_api.g_varchar2) or
463: nvl(ben_qig_shd.g_old_rec.qig_attribute9, hr_api.g_varchar2) <>
464: nvl(p_rec.qig_attribute9, hr_api.g_varchar2) or
465: nvl(ben_qig_shd.g_old_rec.qig_attribute10, hr_api.g_varchar2) <>
466: nvl(p_rec.qig_attribute10, hr_api.g_varchar2) or
467: nvl(ben_qig_shd.g_old_rec.qig_attribute11, hr_api.g_varchar2) <>
468: nvl(p_rec.qig_attribute11, hr_api.g_varchar2) or
469: nvl(ben_qig_shd.g_old_rec.qig_attribute12, hr_api.g_varchar2) <>

Line 467: nvl(ben_qig_shd.g_old_rec.qig_attribute11, hr_api.g_varchar2) <>

463: nvl(ben_qig_shd.g_old_rec.qig_attribute9, hr_api.g_varchar2) <>
464: nvl(p_rec.qig_attribute9, hr_api.g_varchar2) or
465: nvl(ben_qig_shd.g_old_rec.qig_attribute10, hr_api.g_varchar2) <>
466: nvl(p_rec.qig_attribute10, hr_api.g_varchar2) or
467: nvl(ben_qig_shd.g_old_rec.qig_attribute11, hr_api.g_varchar2) <>
468: nvl(p_rec.qig_attribute11, hr_api.g_varchar2) or
469: nvl(ben_qig_shd.g_old_rec.qig_attribute12, hr_api.g_varchar2) <>
470: nvl(p_rec.qig_attribute12, hr_api.g_varchar2) or
471: nvl(ben_qig_shd.g_old_rec.qig_attribute13, hr_api.g_varchar2) <>

Line 469: nvl(ben_qig_shd.g_old_rec.qig_attribute12, hr_api.g_varchar2) <>

465: nvl(ben_qig_shd.g_old_rec.qig_attribute10, hr_api.g_varchar2) <>
466: nvl(p_rec.qig_attribute10, hr_api.g_varchar2) or
467: nvl(ben_qig_shd.g_old_rec.qig_attribute11, hr_api.g_varchar2) <>
468: nvl(p_rec.qig_attribute11, hr_api.g_varchar2) or
469: nvl(ben_qig_shd.g_old_rec.qig_attribute12, hr_api.g_varchar2) <>
470: nvl(p_rec.qig_attribute12, hr_api.g_varchar2) or
471: nvl(ben_qig_shd.g_old_rec.qig_attribute13, hr_api.g_varchar2) <>
472: nvl(p_rec.qig_attribute13, hr_api.g_varchar2) or
473: nvl(ben_qig_shd.g_old_rec.qig_attribute14, hr_api.g_varchar2) <>

Line 471: nvl(ben_qig_shd.g_old_rec.qig_attribute13, hr_api.g_varchar2) <>

467: nvl(ben_qig_shd.g_old_rec.qig_attribute11, hr_api.g_varchar2) <>
468: nvl(p_rec.qig_attribute11, hr_api.g_varchar2) or
469: nvl(ben_qig_shd.g_old_rec.qig_attribute12, hr_api.g_varchar2) <>
470: nvl(p_rec.qig_attribute12, hr_api.g_varchar2) or
471: nvl(ben_qig_shd.g_old_rec.qig_attribute13, hr_api.g_varchar2) <>
472: nvl(p_rec.qig_attribute13, hr_api.g_varchar2) or
473: nvl(ben_qig_shd.g_old_rec.qig_attribute14, hr_api.g_varchar2) <>
474: nvl(p_rec.qig_attribute14, hr_api.g_varchar2) or
475: nvl(ben_qig_shd.g_old_rec.qig_attribute15, hr_api.g_varchar2) <>

Line 473: nvl(ben_qig_shd.g_old_rec.qig_attribute14, hr_api.g_varchar2) <>

469: nvl(ben_qig_shd.g_old_rec.qig_attribute12, hr_api.g_varchar2) <>
470: nvl(p_rec.qig_attribute12, hr_api.g_varchar2) or
471: nvl(ben_qig_shd.g_old_rec.qig_attribute13, hr_api.g_varchar2) <>
472: nvl(p_rec.qig_attribute13, hr_api.g_varchar2) or
473: nvl(ben_qig_shd.g_old_rec.qig_attribute14, hr_api.g_varchar2) <>
474: nvl(p_rec.qig_attribute14, hr_api.g_varchar2) or
475: nvl(ben_qig_shd.g_old_rec.qig_attribute15, hr_api.g_varchar2) <>
476: nvl(p_rec.qig_attribute15, hr_api.g_varchar2) or
477: nvl(ben_qig_shd.g_old_rec.qig_attribute16, hr_api.g_varchar2) <>

Line 475: nvl(ben_qig_shd.g_old_rec.qig_attribute15, hr_api.g_varchar2) <>

471: nvl(ben_qig_shd.g_old_rec.qig_attribute13, hr_api.g_varchar2) <>
472: nvl(p_rec.qig_attribute13, hr_api.g_varchar2) or
473: nvl(ben_qig_shd.g_old_rec.qig_attribute14, hr_api.g_varchar2) <>
474: nvl(p_rec.qig_attribute14, hr_api.g_varchar2) or
475: nvl(ben_qig_shd.g_old_rec.qig_attribute15, hr_api.g_varchar2) <>
476: nvl(p_rec.qig_attribute15, hr_api.g_varchar2) or
477: nvl(ben_qig_shd.g_old_rec.qig_attribute16, hr_api.g_varchar2) <>
478: nvl(p_rec.qig_attribute16, hr_api.g_varchar2) or
479: nvl(ben_qig_shd.g_old_rec.qig_attribute17, hr_api.g_varchar2) <>

Line 477: nvl(ben_qig_shd.g_old_rec.qig_attribute16, hr_api.g_varchar2) <>

473: nvl(ben_qig_shd.g_old_rec.qig_attribute14, hr_api.g_varchar2) <>
474: nvl(p_rec.qig_attribute14, hr_api.g_varchar2) or
475: nvl(ben_qig_shd.g_old_rec.qig_attribute15, hr_api.g_varchar2) <>
476: nvl(p_rec.qig_attribute15, hr_api.g_varchar2) or
477: nvl(ben_qig_shd.g_old_rec.qig_attribute16, hr_api.g_varchar2) <>
478: nvl(p_rec.qig_attribute16, hr_api.g_varchar2) or
479: nvl(ben_qig_shd.g_old_rec.qig_attribute17, hr_api.g_varchar2) <>
480: nvl(p_rec.qig_attribute17, hr_api.g_varchar2) or
481: nvl(ben_qig_shd.g_old_rec.qig_attribute18, hr_api.g_varchar2) <>

Line 479: nvl(ben_qig_shd.g_old_rec.qig_attribute17, hr_api.g_varchar2) <>

475: nvl(ben_qig_shd.g_old_rec.qig_attribute15, hr_api.g_varchar2) <>
476: nvl(p_rec.qig_attribute15, hr_api.g_varchar2) or
477: nvl(ben_qig_shd.g_old_rec.qig_attribute16, hr_api.g_varchar2) <>
478: nvl(p_rec.qig_attribute16, hr_api.g_varchar2) or
479: nvl(ben_qig_shd.g_old_rec.qig_attribute17, hr_api.g_varchar2) <>
480: nvl(p_rec.qig_attribute17, hr_api.g_varchar2) or
481: nvl(ben_qig_shd.g_old_rec.qig_attribute18, hr_api.g_varchar2) <>
482: nvl(p_rec.qig_attribute18, hr_api.g_varchar2) or
483: nvl(ben_qig_shd.g_old_rec.qig_attribute19, hr_api.g_varchar2) <>

Line 481: nvl(ben_qig_shd.g_old_rec.qig_attribute18, hr_api.g_varchar2) <>

477: nvl(ben_qig_shd.g_old_rec.qig_attribute16, hr_api.g_varchar2) <>
478: nvl(p_rec.qig_attribute16, hr_api.g_varchar2) or
479: nvl(ben_qig_shd.g_old_rec.qig_attribute17, hr_api.g_varchar2) <>
480: nvl(p_rec.qig_attribute17, hr_api.g_varchar2) or
481: nvl(ben_qig_shd.g_old_rec.qig_attribute18, hr_api.g_varchar2) <>
482: nvl(p_rec.qig_attribute18, hr_api.g_varchar2) or
483: nvl(ben_qig_shd.g_old_rec.qig_attribute19, hr_api.g_varchar2) <>
484: nvl(p_rec.qig_attribute19, hr_api.g_varchar2) or
485: nvl(ben_qig_shd.g_old_rec.qig_attribute20, hr_api.g_varchar2) <>

Line 483: nvl(ben_qig_shd.g_old_rec.qig_attribute19, hr_api.g_varchar2) <>

479: nvl(ben_qig_shd.g_old_rec.qig_attribute17, hr_api.g_varchar2) <>
480: nvl(p_rec.qig_attribute17, hr_api.g_varchar2) or
481: nvl(ben_qig_shd.g_old_rec.qig_attribute18, hr_api.g_varchar2) <>
482: nvl(p_rec.qig_attribute18, hr_api.g_varchar2) or
483: nvl(ben_qig_shd.g_old_rec.qig_attribute19, hr_api.g_varchar2) <>
484: nvl(p_rec.qig_attribute19, hr_api.g_varchar2) or
485: nvl(ben_qig_shd.g_old_rec.qig_attribute20, hr_api.g_varchar2) <>
486: nvl(p_rec.qig_attribute20, hr_api.g_varchar2) or
487: nvl(ben_qig_shd.g_old_rec.qig_attribute21, hr_api.g_varchar2) <>

Line 485: nvl(ben_qig_shd.g_old_rec.qig_attribute20, hr_api.g_varchar2) <>

481: nvl(ben_qig_shd.g_old_rec.qig_attribute18, hr_api.g_varchar2) <>
482: nvl(p_rec.qig_attribute18, hr_api.g_varchar2) or
483: nvl(ben_qig_shd.g_old_rec.qig_attribute19, hr_api.g_varchar2) <>
484: nvl(p_rec.qig_attribute19, hr_api.g_varchar2) or
485: nvl(ben_qig_shd.g_old_rec.qig_attribute20, hr_api.g_varchar2) <>
486: nvl(p_rec.qig_attribute20, hr_api.g_varchar2) or
487: nvl(ben_qig_shd.g_old_rec.qig_attribute21, hr_api.g_varchar2) <>
488: nvl(p_rec.qig_attribute21, hr_api.g_varchar2) or
489: nvl(ben_qig_shd.g_old_rec.qig_attribute22, hr_api.g_varchar2) <>

Line 487: nvl(ben_qig_shd.g_old_rec.qig_attribute21, hr_api.g_varchar2) <>

483: nvl(ben_qig_shd.g_old_rec.qig_attribute19, hr_api.g_varchar2) <>
484: nvl(p_rec.qig_attribute19, hr_api.g_varchar2) or
485: nvl(ben_qig_shd.g_old_rec.qig_attribute20, hr_api.g_varchar2) <>
486: nvl(p_rec.qig_attribute20, hr_api.g_varchar2) or
487: nvl(ben_qig_shd.g_old_rec.qig_attribute21, hr_api.g_varchar2) <>
488: nvl(p_rec.qig_attribute21, hr_api.g_varchar2) or
489: nvl(ben_qig_shd.g_old_rec.qig_attribute22, hr_api.g_varchar2) <>
490: nvl(p_rec.qig_attribute22, hr_api.g_varchar2) or
491: nvl(ben_qig_shd.g_old_rec.qig_attribute23, hr_api.g_varchar2) <>

Line 489: nvl(ben_qig_shd.g_old_rec.qig_attribute22, hr_api.g_varchar2) <>

485: nvl(ben_qig_shd.g_old_rec.qig_attribute20, hr_api.g_varchar2) <>
486: nvl(p_rec.qig_attribute20, hr_api.g_varchar2) or
487: nvl(ben_qig_shd.g_old_rec.qig_attribute21, hr_api.g_varchar2) <>
488: nvl(p_rec.qig_attribute21, hr_api.g_varchar2) or
489: nvl(ben_qig_shd.g_old_rec.qig_attribute22, hr_api.g_varchar2) <>
490: nvl(p_rec.qig_attribute22, hr_api.g_varchar2) or
491: nvl(ben_qig_shd.g_old_rec.qig_attribute23, hr_api.g_varchar2) <>
492: nvl(p_rec.qig_attribute23, hr_api.g_varchar2) or
493: nvl(ben_qig_shd.g_old_rec.qig_attribute24, hr_api.g_varchar2) <>

Line 491: nvl(ben_qig_shd.g_old_rec.qig_attribute23, hr_api.g_varchar2) <>

487: nvl(ben_qig_shd.g_old_rec.qig_attribute21, hr_api.g_varchar2) <>
488: nvl(p_rec.qig_attribute21, hr_api.g_varchar2) or
489: nvl(ben_qig_shd.g_old_rec.qig_attribute22, hr_api.g_varchar2) <>
490: nvl(p_rec.qig_attribute22, hr_api.g_varchar2) or
491: nvl(ben_qig_shd.g_old_rec.qig_attribute23, hr_api.g_varchar2) <>
492: nvl(p_rec.qig_attribute23, hr_api.g_varchar2) or
493: nvl(ben_qig_shd.g_old_rec.qig_attribute24, hr_api.g_varchar2) <>
494: nvl(p_rec.qig_attribute24, hr_api.g_varchar2) or
495: nvl(ben_qig_shd.g_old_rec.qig_attribute25, hr_api.g_varchar2) <>

Line 493: nvl(ben_qig_shd.g_old_rec.qig_attribute24, hr_api.g_varchar2) <>

489: nvl(ben_qig_shd.g_old_rec.qig_attribute22, hr_api.g_varchar2) <>
490: nvl(p_rec.qig_attribute22, hr_api.g_varchar2) or
491: nvl(ben_qig_shd.g_old_rec.qig_attribute23, hr_api.g_varchar2) <>
492: nvl(p_rec.qig_attribute23, hr_api.g_varchar2) or
493: nvl(ben_qig_shd.g_old_rec.qig_attribute24, hr_api.g_varchar2) <>
494: nvl(p_rec.qig_attribute24, hr_api.g_varchar2) or
495: nvl(ben_qig_shd.g_old_rec.qig_attribute25, hr_api.g_varchar2) <>
496: nvl(p_rec.qig_attribute25, hr_api.g_varchar2) or
497: nvl(ben_qig_shd.g_old_rec.qig_attribute26, hr_api.g_varchar2) <>

Line 495: nvl(ben_qig_shd.g_old_rec.qig_attribute25, hr_api.g_varchar2) <>

491: nvl(ben_qig_shd.g_old_rec.qig_attribute23, hr_api.g_varchar2) <>
492: nvl(p_rec.qig_attribute23, hr_api.g_varchar2) or
493: nvl(ben_qig_shd.g_old_rec.qig_attribute24, hr_api.g_varchar2) <>
494: nvl(p_rec.qig_attribute24, hr_api.g_varchar2) or
495: nvl(ben_qig_shd.g_old_rec.qig_attribute25, hr_api.g_varchar2) <>
496: nvl(p_rec.qig_attribute25, hr_api.g_varchar2) or
497: nvl(ben_qig_shd.g_old_rec.qig_attribute26, hr_api.g_varchar2) <>
498: nvl(p_rec.qig_attribute26, hr_api.g_varchar2) or
499: nvl(ben_qig_shd.g_old_rec.qig_attribute27, hr_api.g_varchar2) <>

Line 497: nvl(ben_qig_shd.g_old_rec.qig_attribute26, hr_api.g_varchar2) <>

493: nvl(ben_qig_shd.g_old_rec.qig_attribute24, hr_api.g_varchar2) <>
494: nvl(p_rec.qig_attribute24, hr_api.g_varchar2) or
495: nvl(ben_qig_shd.g_old_rec.qig_attribute25, hr_api.g_varchar2) <>
496: nvl(p_rec.qig_attribute25, hr_api.g_varchar2) or
497: nvl(ben_qig_shd.g_old_rec.qig_attribute26, hr_api.g_varchar2) <>
498: nvl(p_rec.qig_attribute26, hr_api.g_varchar2) or
499: nvl(ben_qig_shd.g_old_rec.qig_attribute27, hr_api.g_varchar2) <>
500: nvl(p_rec.qig_attribute27, hr_api.g_varchar2) or
501: nvl(ben_qig_shd.g_old_rec.qig_attribute28, hr_api.g_varchar2) <>

Line 499: nvl(ben_qig_shd.g_old_rec.qig_attribute27, hr_api.g_varchar2) <>

495: nvl(ben_qig_shd.g_old_rec.qig_attribute25, hr_api.g_varchar2) <>
496: nvl(p_rec.qig_attribute25, hr_api.g_varchar2) or
497: nvl(ben_qig_shd.g_old_rec.qig_attribute26, hr_api.g_varchar2) <>
498: nvl(p_rec.qig_attribute26, hr_api.g_varchar2) or
499: nvl(ben_qig_shd.g_old_rec.qig_attribute27, hr_api.g_varchar2) <>
500: nvl(p_rec.qig_attribute27, hr_api.g_varchar2) or
501: nvl(ben_qig_shd.g_old_rec.qig_attribute28, hr_api.g_varchar2) <>
502: nvl(p_rec.qig_attribute28, hr_api.g_varchar2) or
503: nvl(ben_qig_shd.g_old_rec.qig_attribute29, hr_api.g_varchar2) <>

Line 501: nvl(ben_qig_shd.g_old_rec.qig_attribute28, hr_api.g_varchar2) <>

497: nvl(ben_qig_shd.g_old_rec.qig_attribute26, hr_api.g_varchar2) <>
498: nvl(p_rec.qig_attribute26, hr_api.g_varchar2) or
499: nvl(ben_qig_shd.g_old_rec.qig_attribute27, hr_api.g_varchar2) <>
500: nvl(p_rec.qig_attribute27, hr_api.g_varchar2) or
501: nvl(ben_qig_shd.g_old_rec.qig_attribute28, hr_api.g_varchar2) <>
502: nvl(p_rec.qig_attribute28, hr_api.g_varchar2) or
503: nvl(ben_qig_shd.g_old_rec.qig_attribute29, hr_api.g_varchar2) <>
504: nvl(p_rec.qig_attribute29, hr_api.g_varchar2) or
505: nvl(ben_qig_shd.g_old_rec.qig_attribute30, hr_api.g_varchar2) <>

Line 503: nvl(ben_qig_shd.g_old_rec.qig_attribute29, hr_api.g_varchar2) <>

499: nvl(ben_qig_shd.g_old_rec.qig_attribute27, hr_api.g_varchar2) <>
500: nvl(p_rec.qig_attribute27, hr_api.g_varchar2) or
501: nvl(ben_qig_shd.g_old_rec.qig_attribute28, hr_api.g_varchar2) <>
502: nvl(p_rec.qig_attribute28, hr_api.g_varchar2) or
503: nvl(ben_qig_shd.g_old_rec.qig_attribute29, hr_api.g_varchar2) <>
504: nvl(p_rec.qig_attribute29, hr_api.g_varchar2) or
505: nvl(ben_qig_shd.g_old_rec.qig_attribute30, hr_api.g_varchar2) <>
506: nvl(p_rec.qig_attribute30, hr_api.g_varchar2) ))
507: or (p_rec.qua_in_gr_rt_id is null) then

Line 505: nvl(ben_qig_shd.g_old_rec.qig_attribute30, hr_api.g_varchar2) <>

501: nvl(ben_qig_shd.g_old_rec.qig_attribute28, hr_api.g_varchar2) <>
502: nvl(p_rec.qig_attribute28, hr_api.g_varchar2) or
503: nvl(ben_qig_shd.g_old_rec.qig_attribute29, hr_api.g_varchar2) <>
504: nvl(p_rec.qig_attribute29, hr_api.g_varchar2) or
505: nvl(ben_qig_shd.g_old_rec.qig_attribute30, hr_api.g_varchar2) <>
506: nvl(p_rec.qig_attribute30, hr_api.g_varchar2) ))
507: or (p_rec.qua_in_gr_rt_id is null) then
508: --
509: -- Only execute the validation if absolutely necessary:

Line 613: ,p_rec in ben_qig_shd.g_rec_type

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

Line 623: IF NOT ben_qig_shd.api_updating

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

Line 784: (p_associated_column1 => ben_qig_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');

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

Line 901: (p_rec in ben_qig_shd.g_rec_type

897: -- ----------------------------------------------------------------------------
898: -- |---------------------------< insert_validate >----------------------------|
899: -- ----------------------------------------------------------------------------
900: Procedure insert_validate
901: (p_rec in ben_qig_shd.g_rec_type
902: ,p_effective_date in date
903: ,p_datetrack_mode in varchar2
904: ,p_validation_start_date in date
905: ,p_validation_end_date in date

Line 917: ,p_associated_column1 => ben_qig_shd.g_tab_nam

913: -- Call all supporting business operations
914: --
915: hr_api.validate_bus_grp_id
916: (p_business_group_id => p_rec.business_group_id
917: ,p_associated_column1 => ben_qig_shd.g_tab_nam
918: || '.BUSINESS_GROUP_ID');
919: --
920:
921: chk_qua_in_gr_rt_id

Line 970: (p_rec in ben_qig_shd.g_rec_type

966: -- ----------------------------------------------------------------------------
967: -- |---------------------------< update_validate >----------------------------|
968: -- ----------------------------------------------------------------------------
969: Procedure update_validate
970: (p_rec in ben_qig_shd.g_rec_type
971: ,p_effective_date in date
972: ,p_datetrack_mode in varchar2
973: ,p_validation_start_date in date
974: ,p_validation_end_date in date

Line 986: ,p_associated_column1 => ben_qig_shd.g_tab_nam

982: -- Call all supporting business operations
983: --
984: hr_api.validate_bus_grp_id
985: (p_business_group_id => p_rec.business_group_id
986: ,p_associated_column1 => ben_qig_shd.g_tab_nam
987: || '.BUSINESS_GROUP_ID');
988:
989: chk_qua_in_gr_rt_id
990: (p_qua_in_gr_rt_id => p_rec.qua_in_gr_rt_id,

Line 1052: (p_rec in ben_qig_shd.g_rec_type

1048: -- ----------------------------------------------------------------------------
1049: -- |---------------------------< delete_validate >----------------------------|
1050: -- ----------------------------------------------------------------------------
1051: Procedure delete_validate
1052: (p_rec in ben_qig_shd.g_rec_type
1053: ,p_effective_date in date
1054: ,p_datetrack_mode in varchar2
1055: ,p_validation_start_date in date
1056: ,p_validation_end_date in date