APPS.BEN_QIG_BUS dependencies on HR_API

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

56: p_qua_in_gr_rt_id => p_qua_in_gr_rt_id,
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: --

Line 141: and qua_in_gr_rt_id <> nvl(p_qua_in_gr_rt_id,hr_api.g_number)

137: select null
138: from ben_qua_in_gr_rt_f
139: where quar_in_grade_cd = p_quar_in_grade_cd
140: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
141: and qua_in_gr_rt_id <> nvl(p_qua_in_gr_rt_id,hr_api.g_number)
142: and business_group_id + 0 = p_business_group_id
143: and p_validation_start_date <= effective_end_date
144: and p_validation_end_date >= effective_start_date;
145: --

Line 157: and nvl(p_quar_in_grade_cd,hr_api.g_varchar2)

153: p_effective_date => p_effective_date,
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

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 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 252: if hr_api.not_exists_in_hr_lookups

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

Line 299: hr_api.mandatory_arg_error

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

Line 325: hr_api.set_security_group_id

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

Line 363: hr_api.mandatory_arg_error

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

Line 369: if ( nvl(ben_qig_bus.g_qua_in_gr_rt_id, hr_api.g_number)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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) <>
506: nvl(p_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 504: nvl(p_rec.qig_attribute29, hr_api.g_varchar2) or

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

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

Line 740: (p_vrbl_rt_prfl_id in number default hr_api.g_number

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

Line 752: hr_api.mandatory_arg_error

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

Line 762: hr_api.mandatory_arg_error

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

Line 768: hr_api.mandatory_arg_error

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

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

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

Line 847: hr_api.mandatory_arg_error

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

Line 856: If (p_datetrack_mode = hr_api.g_delete or

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

Line 857: p_datetrack_mode = hr_api.g_zap) then

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

Line 862: hr_api.mandatory_arg_error

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

Line 868: hr_api.mandatory_arg_error

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

Line 874: hr_api.mandatory_arg_error

870: ,p_argument => 'validation_end_date'
871: ,p_argument_value => p_validation_end_date
872: );
873: --
874: hr_api.mandatory_arg_error
875: (p_api_name => l_proc
876: ,p_argument => 'qua_in_gr_rt_id'
877: ,p_argument_value => p_qua_in_gr_rt_id
878: );

Line 915: hr_api.validate_bus_grp_id

911: hr_utility.set_location('Entering:'||l_proc, 5);
912: --
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: --

Line 984: hr_api.validate_bus_grp_id

980: hr_utility.set_location('Entering:'||l_proc, 5);
981: --
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: