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 549: hr_api.mandatory_arg_error

545: hr_utility.set_location('Entering:'|| l_proc, 10);
546: --
547: -- Ensure that all the mandatory parameter are not null
548: --
549: hr_api.mandatory_arg_error
550: (p_api_name => l_proc
551: ,p_argument => 'VRBL_RT_ELIG_PRFL_ID'
552: ,p_argument_value => p_vrbl_rt_elig_prfl_id
553: );

Line 572: hr_api.set_security_group_id

568: close csr_sec_grp;
569: --
570: -- Set the security_group_id in CLIENT_INFO
571: --
572: hr_api.set_security_group_id
573: (p_security_group_id => l_security_group_id
574: );
575: --
576: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 609: hr_api.mandatory_arg_error

605: hr_utility.set_location('Entering:'|| l_proc, 10);
606: --
607: -- Ensure that all the mandatory parameter are not null
608: --
609: hr_api.mandatory_arg_error
610: (p_api_name => l_proc
611: ,p_argument => 'VRBL_RT_ELIG_PRFL_ID'
612: ,p_argument_value => p_vrbl_rt_elig_prfl_id
613: );

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

611: ,p_argument => 'VRBL_RT_ELIG_PRFL_ID'
612: ,p_argument_value => p_vrbl_rt_elig_prfl_id
613: );
614: --
615: if ( nvl(ben_vep_bus.g_vrbl_rt_elig_prfl_id, hr_api.g_number)
616: = p_vrbl_rt_elig_prfl_id) then
617: --
618: -- The legislation code has already been found with a previous
619: -- call to this function. Just return the value in the global

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

688: begin
689: hr_utility.set_location('Entering:'||l_proc,10);
690: --
691: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
692: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
694: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>

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

689: hr_utility.set_location('Entering:'||l_proc,10);
690: --
691: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
692: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
694: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or

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

690: --
691: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
692: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
694: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>

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

691: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
692: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
694: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or

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

692: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
694: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>

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

693: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
694: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or

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

694: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>

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

695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or

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

696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>

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

697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or

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

698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>

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

699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or

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

700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>

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

701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or

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

702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>

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

703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or

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

704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>

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

705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or

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

706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>

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

707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or

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

708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>

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

709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or

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

710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>

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

711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or

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

712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>

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

713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or

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

714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>

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

715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or

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

716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>

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

717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or

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

718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>

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

719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or

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

720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>

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

721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or

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

722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>

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

723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or

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

724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>

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

725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or

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

726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>

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

727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or

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

728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>

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

729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or

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

730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>

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

731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or

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

732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>

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

733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or

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

734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>

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

735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or

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

736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>

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

737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or

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

738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>

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

739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or

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

740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>

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

741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or

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

742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>

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

743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
751: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or

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

744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
751: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
752: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>

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

745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
751: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
752: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
753: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))

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

746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
751: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
752: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
753: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
754: or (p_rec.vrbl_rt_elig_prfl_idis null) then

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

747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
751: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
752: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
753: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
754: or (p_rec.vrbl_rt_elig_prfl_idis null) then
755: --

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

748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
751: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
752: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
753: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
754: or (p_rec.vrbl_rt_elig_prfl_idis null) then
755: --
756: -- Only execute the validation if absolutely necessary:

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

749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
751: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
752: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
753: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
754: or (p_rec.vrbl_rt_elig_prfl_idis null) then
755: --
756: -- Only execute the validation if absolutely necessary:
757: -- a) During update, the structure column value or any

Line 890: hr_api.argument_changed_error

886: -- not been updated.
887: --
888: EXCEPTION
889: WHEN l_error THEN
890: hr_api.argument_changed_error
891: (p_api_name => l_proc
892: ,p_argument => l_argument);
893: WHEN OTHERS THEN
894: RAISE;

Line 1088: p_vrbl_rt_prfl_id in number default hr_api.g_number

1084: -- {End Of Comments}
1085: -- ----------------------------------------------------------------------------
1086: Procedure dt_update_validate
1087: (
1088: p_vrbl_rt_prfl_id in number default hr_api.g_number
1089: ,p_eligy_prfl_id in number default hr_api.g_number
1090: ,p_datetrack_mode in varchar2
1091: ,p_validation_start_date in date
1092: ,p_validation_end_date in date

Line 1089: ,p_eligy_prfl_id in number default hr_api.g_number

1085: -- ----------------------------------------------------------------------------
1086: Procedure dt_update_validate
1087: (
1088: p_vrbl_rt_prfl_id in number default hr_api.g_number
1089: ,p_eligy_prfl_id in number default hr_api.g_number
1090: ,p_datetrack_mode in varchar2
1091: ,p_validation_start_date in date
1092: ,p_validation_end_date in date
1093: ) Is

Line 1103: hr_api.mandatory_arg_error

1099: Begin
1100: --
1101: -- Ensure that the p_datetrack_mode argument is not null
1102: --
1103: hr_api.mandatory_arg_error
1104: (p_api_name => l_proc
1105: ,p_argument => 'datetrack_mode'
1106: ,p_argument_value => p_datetrack_mode
1107: );

Line 1113: hr_api.mandatory_arg_error

1109: -- Mode will be valid, as this is checked at the start of the upd.
1110: --
1111: -- Ensure the arguments are not null
1112: --
1113: hr_api.mandatory_arg_error
1114: (p_api_name => l_proc
1115: ,p_argument => 'validation_start_date'
1116: ,p_argument_value => p_validation_start_date
1117: );

Line 1119: hr_api.mandatory_arg_error

1115: ,p_argument => 'validation_start_date'
1116: ,p_argument_value => p_validation_start_date
1117: );
1118: --
1119: hr_api.mandatory_arg_error
1120: (p_api_name => l_proc
1121: ,p_argument => 'validation_end_date'
1122: ,p_argument_value => p_validation_end_date
1123: );

Line 1187: hr_api.mandatory_arg_error

1183: Begin
1184: --
1185: -- Ensure that the p_datetrack_mode argument is not null
1186: --
1187: hr_api.mandatory_arg_error
1188: (p_api_name => l_proc
1189: ,p_argument => 'datetrack_mode'
1190: ,p_argument_value => p_datetrack_mode
1191: );

Line 1196: If (p_datetrack_mode = hr_api.g_delete or

1192: --
1193: -- Only perform the validation if the datetrack mode is either
1194: -- DELETE or ZAP
1195: --
1196: If (p_datetrack_mode = hr_api.g_delete or
1197: p_datetrack_mode = hr_api.g_zap) then
1198: --
1199: --
1200: -- Ensure the arguments are not null

Line 1197: p_datetrack_mode = hr_api.g_zap) then

1193: -- Only perform the validation if the datetrack mode is either
1194: -- DELETE or ZAP
1195: --
1196: If (p_datetrack_mode = hr_api.g_delete or
1197: p_datetrack_mode = hr_api.g_zap) then
1198: --
1199: --
1200: -- Ensure the arguments are not null
1201: --

Line 1202: hr_api.mandatory_arg_error

1198: --
1199: --
1200: -- Ensure the arguments are not null
1201: --
1202: hr_api.mandatory_arg_error
1203: (p_api_name => l_proc
1204: ,p_argument => 'validation_start_date'
1205: ,p_argument_value => p_validation_start_date
1206: );

Line 1208: hr_api.mandatory_arg_error

1204: ,p_argument => 'validation_start_date'
1205: ,p_argument_value => p_validation_start_date
1206: );
1207: --
1208: hr_api.mandatory_arg_error
1209: (p_api_name => l_proc
1210: ,p_argument => 'validation_end_date'
1211: ,p_argument_value => p_validation_end_date
1212: );

Line 1214: hr_api.mandatory_arg_error

1210: ,p_argument => 'validation_end_date'
1211: ,p_argument_value => p_validation_end_date
1212: );
1213: --
1214: hr_api.mandatory_arg_error
1215: (p_api_name => l_proc
1216: ,p_argument => 'VRBL_RT_ELIG_PRFL_ID'
1217: ,p_argument_value => p_vrbl_rt_elig_prfl_id
1218: );

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

1259: hr_utility.set_location('Entering:'||l_proc, 5);
1260: --
1261: -- Call all supporting business operations
1262: --
1263: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1264: --
1265: --
1266: --ben_vep_bus.chk_df(p_rec);
1267:

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

1328: hr_utility.set_location('Entering:'||l_proc, 5);
1329: --
1330: -- Call all supporting business operations
1331: --
1332: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1333: --
1334: chk_vrbl_rt_elig_prfl_id
1335: (p_vrbl_rt_elig_prfl_id => p_rec.vrbl_rt_elig_prfl_id,
1336: p_effective_date => p_effective_date,