APPS.BEN_VEP_BUS dependencies on HR_API

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

56: p_vrbl_rt_elig_prfl_id => p_vrbl_rt_elig_prfl_id,
57: p_object_version_number => p_object_version_number);
58: --
59: if (l_api_updating
60: and nvl(p_vrbl_rt_elig_prfl_id,hr_api.g_number)
61: <> ben_vep_shd.g_old_rec.vrbl_rt_elig_prfl_id) then
62: -- raise error as PK has changed
63: --
64: ben_vep_shd.constraint_error('BEN_VRBL_RT_ELIG_PRFL_F_PK');

Line 132: <> nvl(ben_vep_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)

128: p_object_version_number => p_object_version_number);
129: --
130: if (l_api_updating
131: and p_mndtry_flag
132: <> nvl(ben_vep_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)
133: or not l_api_updating)
134: and p_mndtry_flag is not null then
135: --
136: -- check if value of lookup falls within lookup type.

Line 138: if hr_api.not_exists_in_hr_lookups

134: and p_mndtry_flag is not null then
135: --
136: -- check if value of lookup falls within lookup type.
137: --
138: if hr_api.not_exists_in_hr_lookups
139: (p_lookup_type => 'YES_NO',
140: p_lookup_code => p_mndtry_flag,
141: p_effective_date => p_effective_date) then
142: --

Line 435: hr_api.mandatory_arg_error

431: hr_utility.set_location('Entering:'|| l_proc, 10);
432: --
433: -- Ensure that all the mandatory parameter are not null
434: --
435: hr_api.mandatory_arg_error
436: (p_api_name => l_proc
437: ,p_argument => 'VRBL_RT_ELIG_PRFL_ID'
438: ,p_argument_value => p_vrbl_rt_elig_prfl_id
439: );

Line 458: hr_api.set_security_group_id

454: close csr_sec_grp;
455: --
456: -- Set the security_group_id in CLIENT_INFO
457: --
458: hr_api.set_security_group_id
459: (p_security_group_id => l_security_group_id
460: );
461: --
462: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 495: hr_api.mandatory_arg_error

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

Line 501: if ( nvl(ben_vep_bus.g_vrbl_rt_elig_prfl_id, hr_api.g_number)

497: ,p_argument => 'VRBL_RT_ELIG_PRFL_ID'
498: ,p_argument_value => p_vrbl_rt_elig_prfl_id
499: );
500: --
501: if ( nvl(ben_vep_bus.g_vrbl_rt_elig_prfl_id, hr_api.g_number)
502: = p_vrbl_rt_elig_prfl_id) then
503: --
504: -- The legislation code has already been found with a previous
505: -- call to this function. Just return the value in the global

Line 578: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>

574: begin
575: hr_utility.set_location('Entering:'||l_proc,10);
576: --
577: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
578: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
579: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>

Line 579: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or

575: hr_utility.set_location('Entering:'||l_proc,10);
576: --
577: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
578: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
579: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or

Line 580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>

576: --
577: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
578: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
579: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>

Line 581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or

577: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
578: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
579: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or

Line 582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>

578: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
579: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>

Line 583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or

579: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or

Line 584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>

580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>

Line 585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or

581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or

Line 586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>

582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>

Line 587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or

583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or

Line 588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>

584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>

Line 589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or

585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or

Line 590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>

586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>

Line 591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or

587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or

Line 592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>

588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>

Line 593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or

589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or

Line 594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>

590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>

Line 595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or

591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or

Line 596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>

592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>

Line 597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or

593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or

Line 598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>

594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>

Line 599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or

595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or

Line 600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>

596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>

Line 601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or

597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or

Line 602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>

598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>

Line 603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or

599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or

Line 604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>

600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>

Line 605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or

601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or

Line 606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>

602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>

Line 607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or

603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or

Line 608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>

604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>

Line 609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or

605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or

Line 610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>

606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>

Line 611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or

607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or

Line 612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>

608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>

Line 613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or

609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or

Line 614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>

610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>

Line 615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or

611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or

Line 616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>

612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>

Line 617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or

613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or

Line 618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>

614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>

Line 619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or

615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or

Line 620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>

616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>

Line 621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or

617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or

Line 622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>

618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>

Line 623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or

619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or

Line 624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>

620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>

Line 625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or

621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or

Line 626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>

622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>

Line 627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or

623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or

Line 628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>

624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>

Line 629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or

625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or

Line 630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>

626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>

Line 631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or

627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or

Line 632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>

628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>

Line 633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or

629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
637: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or

Line 634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>

630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
637: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
638: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>

Line 635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or

631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
637: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
638: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
639: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))

Line 636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>

632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
637: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
638: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
639: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
640: or (p_rec.vrbl_rt_elig_prfl_idis null) then

Line 637: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or

633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
637: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
638: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
639: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
640: or (p_rec.vrbl_rt_elig_prfl_idis null) then
641: --

Line 638: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>

634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
637: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
638: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
639: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
640: or (p_rec.vrbl_rt_elig_prfl_idis null) then
641: --
642: -- Only execute the validation if absolutely necessary:

Line 639: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))

635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
637: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
638: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
639: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
640: or (p_rec.vrbl_rt_elig_prfl_idis null) then
641: --
642: -- Only execute the validation if absolutely necessary:
643: -- a) During update, the structure column value or any

Line 776: hr_api.argument_changed_error

772: -- not been updated.
773: --
774: EXCEPTION
775: WHEN l_error THEN
776: hr_api.argument_changed_error
777: (p_api_name => l_proc
778: ,p_argument => l_argument);
779: WHEN OTHERS THEN
780: RAISE;

Line 974: p_vrbl_rt_prfl_id in number default hr_api.g_number

970: -- {End Of Comments}
971: -- ----------------------------------------------------------------------------
972: Procedure dt_update_validate
973: (
974: p_vrbl_rt_prfl_id in number default hr_api.g_number
975: ,p_eligy_prfl_id in number default hr_api.g_number
976: ,p_datetrack_mode in varchar2
977: ,p_validation_start_date in date
978: ,p_validation_end_date in date

Line 975: ,p_eligy_prfl_id in number default hr_api.g_number

971: -- ----------------------------------------------------------------------------
972: Procedure dt_update_validate
973: (
974: p_vrbl_rt_prfl_id in number default hr_api.g_number
975: ,p_eligy_prfl_id in number default hr_api.g_number
976: ,p_datetrack_mode in varchar2
977: ,p_validation_start_date in date
978: ,p_validation_end_date in date
979: ) Is

Line 989: hr_api.mandatory_arg_error

985: Begin
986: --
987: -- Ensure that the p_datetrack_mode argument is not null
988: --
989: hr_api.mandatory_arg_error
990: (p_api_name => l_proc
991: ,p_argument => 'datetrack_mode'
992: ,p_argument_value => p_datetrack_mode
993: );

Line 999: hr_api.mandatory_arg_error

995: -- Mode will be valid, as this is checked at the start of the upd.
996: --
997: -- Ensure the arguments are not null
998: --
999: hr_api.mandatory_arg_error
1000: (p_api_name => l_proc
1001: ,p_argument => 'validation_start_date'
1002: ,p_argument_value => p_validation_start_date
1003: );

Line 1005: hr_api.mandatory_arg_error

1001: ,p_argument => 'validation_start_date'
1002: ,p_argument_value => p_validation_start_date
1003: );
1004: --
1005: hr_api.mandatory_arg_error
1006: (p_api_name => l_proc
1007: ,p_argument => 'validation_end_date'
1008: ,p_argument_value => p_validation_end_date
1009: );

Line 1073: hr_api.mandatory_arg_error

1069: Begin
1070: --
1071: -- Ensure that the p_datetrack_mode argument is not null
1072: --
1073: hr_api.mandatory_arg_error
1074: (p_api_name => l_proc
1075: ,p_argument => 'datetrack_mode'
1076: ,p_argument_value => p_datetrack_mode
1077: );

Line 1082: If (p_datetrack_mode = hr_api.g_delete or

1078: --
1079: -- Only perform the validation if the datetrack mode is either
1080: -- DELETE or ZAP
1081: --
1082: If (p_datetrack_mode = hr_api.g_delete or
1083: p_datetrack_mode = hr_api.g_zap) then
1084: --
1085: --
1086: -- Ensure the arguments are not null

Line 1083: p_datetrack_mode = hr_api.g_zap) then

1079: -- Only perform the validation if the datetrack mode is either
1080: -- DELETE or ZAP
1081: --
1082: If (p_datetrack_mode = hr_api.g_delete or
1083: p_datetrack_mode = hr_api.g_zap) then
1084: --
1085: --
1086: -- Ensure the arguments are not null
1087: --

Line 1088: hr_api.mandatory_arg_error

1084: --
1085: --
1086: -- Ensure the arguments are not null
1087: --
1088: hr_api.mandatory_arg_error
1089: (p_api_name => l_proc
1090: ,p_argument => 'validation_start_date'
1091: ,p_argument_value => p_validation_start_date
1092: );

Line 1094: hr_api.mandatory_arg_error

1090: ,p_argument => 'validation_start_date'
1091: ,p_argument_value => p_validation_start_date
1092: );
1093: --
1094: hr_api.mandatory_arg_error
1095: (p_api_name => l_proc
1096: ,p_argument => 'validation_end_date'
1097: ,p_argument_value => p_validation_end_date
1098: );

Line 1100: hr_api.mandatory_arg_error

1096: ,p_argument => 'validation_end_date'
1097: ,p_argument_value => p_validation_end_date
1098: );
1099: --
1100: hr_api.mandatory_arg_error
1101: (p_api_name => l_proc
1102: ,p_argument => 'VRBL_RT_ELIG_PRFL_ID'
1103: ,p_argument_value => p_vrbl_rt_elig_prfl_id
1104: );

Line 1149: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1145: hr_utility.set_location('Entering:'||l_proc, 5);
1146: --
1147: -- Call all supporting business operations
1148: --
1149: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1150: --
1151: --
1152: --ben_vep_bus.chk_df(p_rec);
1153:

Line 1218: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1214: hr_utility.set_location('Entering:'||l_proc, 5);
1215: --
1216: -- Call all supporting business operations
1217: --
1218: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1219: --
1220: chk_vrbl_rt_elig_prfl_id
1221: (p_vrbl_rt_elig_prfl_id => p_rec.vrbl_rt_elig_prfl_id,
1222: p_effective_date => p_effective_date,