eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CTY_BUS dependencies on HR_API

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

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

Line 141: -- and vrbl_rt_prfl_id <> nvl(p_comptncy_rt_id,hr_api.g_number)

137: from ben_comptncy_rt_f
138: where competence_id = p_competence_id
139: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
140: -- changed for Bug 5078478 .. change the commented query to the new one
141: -- and vrbl_rt_prfl_id <> nvl(p_comptncy_rt_id,hr_api.g_number)
142: and comptncy_rt_id <> nvl(p_comptncy_rt_id,hr_api.g_number)
143: -- changed end for Bug 5078478
144: and business_group_id + 0 = p_business_group_id
145: and p_validation_start_date <= effective_end_date

Line 142: and comptncy_rt_id <> nvl(p_comptncy_rt_id,hr_api.g_number)

138: where competence_id = p_competence_id
139: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
140: -- changed for Bug 5078478 .. change the commented query to the new one
141: -- and vrbl_rt_prfl_id <> nvl(p_comptncy_rt_id,hr_api.g_number)
142: and comptncy_rt_id <> nvl(p_comptncy_rt_id,hr_api.g_number)
143: -- changed end for Bug 5078478
144: and business_group_id + 0 = p_business_group_id
145: and p_validation_start_date <= effective_end_date
146: and p_validation_end_date >= effective_start_date;

Line 159: and nvl(p_competence_id,hr_api.g_number)

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

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 267: -- and vrbl_rt_prfl_id <> nvl(p_comptncy_rt_id,hr_api.g_number)

263: where competence_id = p_competence_id
264: and rating_level_id = p_rating_level_id
265: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
266: -- changed for Bug 5078478 .. change the commented query to the new one
267: -- and vrbl_rt_prfl_id <> nvl(p_comptncy_rt_id,hr_api.g_number)
268: and comptncy_rt_id <> nvl(p_comptncy_rt_id,hr_api.g_number)
269: -- -- changed end for Bug 5078478
270: and business_group_id + 0 = p_business_group_id
271: and p_validation_start_date <= effective_end_date

Line 268: and comptncy_rt_id <> nvl(p_comptncy_rt_id,hr_api.g_number)

264: and rating_level_id = p_rating_level_id
265: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
266: -- changed for Bug 5078478 .. change the commented query to the new one
267: -- and vrbl_rt_prfl_id <> nvl(p_comptncy_rt_id,hr_api.g_number)
268: and comptncy_rt_id <> nvl(p_comptncy_rt_id,hr_api.g_number)
269: -- -- changed end for Bug 5078478
270: and business_group_id + 0 = p_business_group_id
271: and p_validation_start_date <= effective_end_date
272: and p_validation_end_date >= effective_start_date;

Line 285: and nvl(p_competence_id,hr_api.g_number)

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

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

378: --
379: -- check if value of lookup falls within lookup type.
380: --
381: --
382: if hr_api.not_exists_in_hr_lookups
383: (p_lookup_type => 'YES_NO',
384: p_lookup_code => p_excld_flag,
385: p_effective_date => p_effective_date) then
386: --

Line 497: hr_api.mandatory_arg_error

493: hr_utility.set_location('Entering:'|| l_proc, 10);
494: --
495: -- Ensure that all the mandatory parameter are not null
496: --
497: hr_api.mandatory_arg_error
498: (p_api_name => l_proc
499: ,p_argument => 'comptncy_rt_id'
500: ,p_argument_value => p_comptncy_rt_id
501: );

Line 523: hr_api.set_security_group_id

519: close csr_sec_grp;
520: --
521: -- Set the security_group_id in CLIENT_INFO
522: --
523: hr_api.set_security_group_id
524: (p_security_group_id => l_security_group_id
525: );
526: end if;
527: --

Line 561: hr_api.mandatory_arg_error

557: hr_utility.set_location('Entering:'|| l_proc, 10);
558: --
559: -- Ensure that all the mandatory parameter are not null
560: --
561: hr_api.mandatory_arg_error
562: (p_api_name => l_proc
563: ,p_argument => 'comptncy_rt_id'
564: ,p_argument_value => p_comptncy_rt_id
565: );

Line 567: if ( nvl(ben_cty_bus.g_comptncy_rt_id, hr_api.g_number)

563: ,p_argument => 'comptncy_rt_id'
564: ,p_argument_value => p_comptncy_rt_id
565: );
566: --
567: if ( nvl(ben_cty_bus.g_comptncy_rt_id, hr_api.g_number)
568: = p_comptncy_rt_id) then
569: --
570: -- The legislation code has already been found with a previous
571: -- call to this function. Just return the value in the global

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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) <>
704: nvl(p_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 702: nvl(p_rec.cty_attribute29, hr_api.g_varchar2) or

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

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

Line 867: (p_vrbl_rt_prfl_id in number default hr_api.g_number

863: --
864: -- {End Of Comments}
865: -- ----------------------------------------------------------------------------
866: Procedure dt_update_validate
867: (p_vrbl_rt_prfl_id in number default hr_api.g_number
868: ,p_datetrack_mode in varchar2
869: ,p_validation_start_date in date
870: ,p_validation_end_date in date
871: ) Is

Line 879: hr_api.mandatory_arg_error

875: Begin
876: --
877: -- Ensure that the p_datetrack_mode argument is not null
878: --
879: hr_api.mandatory_arg_error
880: (p_api_name => l_proc
881: ,p_argument => 'datetrack_mode'
882: ,p_argument_value => p_datetrack_mode
883: );

Line 889: hr_api.mandatory_arg_error

885: -- Mode will be valid, as this is checked at the start of the upd.
886: --
887: -- Ensure the arguments are not null
888: --
889: hr_api.mandatory_arg_error
890: (p_api_name => l_proc
891: ,p_argument => 'validation_start_date'
892: ,p_argument_value => p_validation_start_date
893: );

Line 895: hr_api.mandatory_arg_error

891: ,p_argument => 'validation_start_date'
892: ,p_argument_value => p_validation_start_date
893: );
894: --
895: hr_api.mandatory_arg_error
896: (p_api_name => l_proc
897: ,p_argument => 'validation_end_date'
898: ,p_argument_value => p_validation_end_date
899: );

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

897: ,p_argument => 'validation_end_date'
898: ,p_argument_value => p_validation_end_date
899: );
900: --
901: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
902: NOT (dt_api.check_min_max_dates
903: (p_base_table_name => 'ben_vrbl_rt_prfl_f'
904: ,p_base_key_column => 'VRBL_RT_PRFL_ID'
905: ,p_base_key_value => p_vrbl_rt_prfl_id

Line 974: hr_api.mandatory_arg_error

970: Begin
971: --
972: -- Ensure that the p_datetrack_mode argument is not null
973: --
974: hr_api.mandatory_arg_error
975: (p_api_name => l_proc
976: ,p_argument => 'datetrack_mode'
977: ,p_argument_value => p_datetrack_mode
978: );

Line 983: If (p_datetrack_mode = hr_api.g_delete or

979: --
980: -- Only perform the validation if the datetrack mode is either
981: -- DELETE or ZAP
982: --
983: If (p_datetrack_mode = hr_api.g_delete or
984: p_datetrack_mode = hr_api.g_zap) then
985: --
986: --
987: -- Ensure the arguments are not null

Line 984: p_datetrack_mode = hr_api.g_zap) then

980: -- Only perform the validation if the datetrack mode is either
981: -- DELETE or ZAP
982: --
983: If (p_datetrack_mode = hr_api.g_delete or
984: p_datetrack_mode = hr_api.g_zap) then
985: --
986: --
987: -- Ensure the arguments are not null
988: --

Line 989: hr_api.mandatory_arg_error

985: --
986: --
987: -- Ensure the arguments are not null
988: --
989: hr_api.mandatory_arg_error
990: (p_api_name => l_proc
991: ,p_argument => 'validation_start_date'
992: ,p_argument_value => p_validation_start_date
993: );

Line 995: hr_api.mandatory_arg_error

991: ,p_argument => 'validation_start_date'
992: ,p_argument_value => p_validation_start_date
993: );
994: --
995: hr_api.mandatory_arg_error
996: (p_api_name => l_proc
997: ,p_argument => 'validation_end_date'
998: ,p_argument_value => p_validation_end_date
999: );

Line 1001: hr_api.mandatory_arg_error

997: ,p_argument => 'validation_end_date'
998: ,p_argument_value => p_validation_end_date
999: );
1000: --
1001: hr_api.mandatory_arg_error
1002: (p_api_name => l_proc
1003: ,p_argument => 'comptncy_rt_id'
1004: ,p_argument_value => p_comptncy_rt_id
1005: );

Line 1042: hr_api.validate_bus_grp_id

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

Line 1122: hr_api.validate_bus_grp_id

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