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.PQP_VRE_BUS dependencies on HR_API

Line 48: hr_api.mandatory_arg_error

44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error
49: (p_api_name => l_proc
50: ,p_argument =>'vehicle_repository_id'
51: ,p_argument_value => p_vehicle_repository_id
52: );

Line 74: hr_api.set_security_group_id

70: CLOSE csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA

Line 80: hr_api.set_legislation_context(l_legislation_code);

76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: END IF;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --

Line 117: hr_api.mandatory_arg_error

113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error
118: (p_api_name => l_proc
119: ,p_argument => 'vehicle_repository_id'
120: ,p_argument_value => p_vehicle_repository_id
121: );

Line 123: IF ( nvl(pqp_vre_bus.g_vehicle_repository_id, hr_api.g_number)

119: ,p_argument => 'vehicle_repository_id'
120: ,p_argument_value => p_vehicle_repository_id
121: );
122: --
123: IF ( nvl(pqp_vre_bus.g_vehicle_repository_id, hr_api.g_number)
124: = p_vehicle_repository_id) THEN
125: --
126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global

Line 199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>

195: BEGIN
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: IF ((p_rec.vehicle_repository_id is not null) and (
199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>

Line 200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or

196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: IF ((p_rec.vehicle_repository_id is not null) and (
199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or

Line 201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>

197: --
198: IF ((p_rec.vehicle_repository_id is not null) and (
199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>

Line 202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or

198: IF ((p_rec.vehicle_repository_id is not null) and (
199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or

Line 203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>

199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>

Line 204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or

200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or

Line 205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>

201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>

Line 206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or

202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or

Line 207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>

203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>

Line 208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or

204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or

Line 209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>

205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>

Line 210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or

206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or

Line 211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>

207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>

Line 212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or

208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or

Line 213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>

209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>

Line 214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or

210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or

Line 215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>

211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>

Line 216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or

212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or

Line 217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>

213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>

Line 218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or

214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or

Line 219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>

215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>

Line 220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or

216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or

Line 221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>

217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>

Line 222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or

218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or

Line 223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>

219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>

Line 224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or

220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or

Line 225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>

221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>

Line 226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or

222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or

Line 227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>

223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>

Line 228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or

224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or

Line 229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>

225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>

Line 230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or

226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or

Line 231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>

227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>

Line 232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or

228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or

Line 233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>

229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>

Line 234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or

230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or

Line 235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>

231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>

Line 236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or

232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>
240: nvl(p_rec.vre_information20, hr_api.g_varchar2) ))

Line 237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>

233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>
240: nvl(p_rec.vre_information20, hr_api.g_varchar2) ))
241: or (p_rec.vehicle_repository_id is null) THEN

Line 238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or

234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>
240: nvl(p_rec.vre_information20, hr_api.g_varchar2) ))
241: or (p_rec.vehicle_repository_id is null) THEN
242: --

Line 239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>

235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>
240: nvl(p_rec.vre_information20, hr_api.g_varchar2) ))
241: or (p_rec.vehicle_repository_id is null) THEN
242: --
243: -- Only execute the validation if absolutely necessary:

Line 240: nvl(p_rec.vre_information20, hr_api.g_varchar2) ))

236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>
240: nvl(p_rec.vre_information20, hr_api.g_varchar2) ))
241: or (p_rec.vehicle_repository_id is null) THEN
242: --
243: -- Only execute the validation if absolutely necessary:
244: -- a) During update, the structure column value or any

Line 336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>

332: BEGIN
333: hr_utility.set_location('Entering:'||l_proc,10);
334: --
335: IF ((p_rec.vehicle_repository_id is not null) and (
336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>

Line 337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or

333: hr_utility.set_location('Entering:'||l_proc,10);
334: --
335: IF ((p_rec.vehicle_repository_id is not null) and (
336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or

Line 338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>

334: --
335: IF ((p_rec.vehicle_repository_id is not null) and (
336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>

Line 339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or

335: IF ((p_rec.vehicle_repository_id is not null) and (
336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or

Line 340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>

336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>

Line 341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or

337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or

Line 342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>

338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>

Line 343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or

339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or

Line 344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>

340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>

Line 345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or

341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or

Line 346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>

342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>

Line 347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or

343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or

Line 348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>

344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>

Line 349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or

345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or

Line 350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>

346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>

Line 351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or

347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or

Line 352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>

348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>

Line 353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or

349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or

Line 354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>

350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>

Line 355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or

351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or

Line 356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>

352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>

Line 357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or

353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or

Line 358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>

354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>

Line 359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or

355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or

Line 360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>

356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>

Line 361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or

357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or

Line 362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>

358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>

Line 363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or

359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or

Line 364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>

360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>

Line 365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or

361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or

Line 366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>

362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>

Line 367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or

363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or

Line 368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>

364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>

Line 369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or

365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or

Line 370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>

366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>

Line 371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or

367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or

Line 372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>

368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>

Line 373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or

369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.vre_attribute20, hr_api.g_varchar2) ))

Line 374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>

370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.vre_attribute20, hr_api.g_varchar2) ))
378: or (p_rec.vehicle_repository_id is null) then

Line 375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or

371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.vre_attribute20, hr_api.g_varchar2) ))
378: or (p_rec.vehicle_repository_id is null) then
379: --

Line 376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>

372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.vre_attribute20, hr_api.g_varchar2) ))
378: or (p_rec.vehicle_repository_id is null) then
379: --
380: -- Only execute the validation if absolutely necessary:

Line 377: nvl(p_rec.vre_attribute20, hr_api.g_varchar2) ))

373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.vre_attribute20, hr_api.g_varchar2) ))
378: or (p_rec.vehicle_repository_id is null) then
379: --
380: -- Only execute the validation if absolutely necessary:
381: -- a) During update, the structure column value or any

Line 531: hr_api.mandatory_arg_error

527: BEGIN
528: --
529: -- Ensure that the p_datetrack_mode argument is not null
530: --
531: hr_api.mandatory_arg_error
532: (p_api_name => l_proc
533: ,p_argument => 'datetrack_mode'
534: ,p_argument_value => p_datetrack_mode
535: );

Line 541: hr_api.mandatory_arg_error

537: -- Mode will be valid, as this is checked at the start of the upd.
538: --
539: -- Ensure the arguments are not null
540: --
541: hr_api.mandatory_arg_error
542: (p_api_name => l_proc
543: ,p_argument => 'validation_start_date'
544: ,p_argument_value => p_validation_start_date
545: );

Line 547: hr_api.mandatory_arg_error

543: ,p_argument => 'validation_start_date'
544: ,p_argument_value => p_validation_start_date
545: );
546: --
547: hr_api.mandatory_arg_error
548: (p_api_name => l_proc
549: ,p_argument => 'validation_end_date'
550: ,p_argument_value => p_validation_end_date
551: );

Line 615: hr_api.mandatory_arg_error

611: BEGIN
612: --
613: -- Ensure that the p_datetrack_mode argument is not null
614: --
615: hr_api.mandatory_arg_error
616: (p_api_name => l_proc
617: ,p_argument => 'datetrack_mode'
618: ,p_argument_value => p_datetrack_mode
619: );

Line 624: IF (p_datetrack_mode = hr_api.g_delete or

620: --
621: -- Only perform the validation if the datetrack mode is either
622: -- DELETE or ZAP
623: --
624: IF (p_datetrack_mode = hr_api.g_delete or
625: p_datetrack_mode = hr_api.g_zap) THEN
626: --
627: --
628: -- Ensure the arguments are not null

Line 625: p_datetrack_mode = hr_api.g_zap) THEN

621: -- Only perform the validation if the datetrack mode is either
622: -- DELETE or ZAP
623: --
624: IF (p_datetrack_mode = hr_api.g_delete or
625: p_datetrack_mode = hr_api.g_zap) THEN
626: --
627: --
628: -- Ensure the arguments are not null
629: --

Line 630: hr_api.mandatory_arg_error

626: --
627: --
628: -- Ensure the arguments are not null
629: --
630: hr_api.mandatory_arg_error
631: (p_api_name => l_proc
632: ,p_argument => 'validation_start_date'
633: ,p_argument_value => p_validation_start_date
634: );

Line 636: hr_api.mandatory_arg_error

632: ,p_argument => 'validation_start_date'
633: ,p_argument_value => p_validation_start_date
634: );
635: --
636: hr_api.mandatory_arg_error
637: (p_api_name => l_proc
638: ,p_argument => 'validation_end_date'
639: ,p_argument_value => p_validation_end_date
640: );

Line 642: hr_api.mandatory_arg_error

638: ,p_argument => 'validation_end_date'
639: ,p_argument_value => p_validation_end_date
640: );
641: --
642: hr_api.mandatory_arg_error
643: (p_api_name => l_proc
644: ,p_argument => 'vehicle_repository_id'
645: ,p_argument_value => p_vehicle_repository_id
646: );

Line 913: hr_api.set_legislation_context(l_legislation_code);

909: --Getting the legislationId for business groupId
910: l_legislation_code :=
911: pqp_vre_bus.get_legislation_code(p_business_group_id);
912: --setting the lg context
913: hr_api.set_legislation_context(l_legislation_code);
914: OPEN fiscal_cursor;
915: FETCH fiscal_cursor INTO l_meaning;
916: CLOSE fiscal_cursor;
917: p_meaning := NVL(l_meaning,'NONE');

Line 943: IF hr_api.not_exists_in_dt_hrstanlookups

939: -- Check if the argument value exists in hr_lookups
940: -- where the lookup_type is passed lookuptype
941: --
942: IF p_lookup_code IS NOT NULL then
943: IF hr_api.not_exists_in_dt_hrstanlookups
944: (p_effective_date => p_effective_date
945: ,p_validation_start_date => p_validation_start_date
946: ,p_validation_end_date => p_validation_end_date
947: ,p_lookup_type => p_lookup_type

Line 1487: hr_api.validate_bus_grp_id

1483:
1484: --
1485: -- Call all supporting business operations
1486: --
1487: hr_api.validate_bus_grp_id
1488: (p_business_group_id => p_rec.business_group_id
1489: ,p_associated_column1 => pqp_vre_shd.g_tab_nam
1490: || '.BUSINESS_GROUP_ID');
1491:

Line 1858: hr_api.validate_bus_grp_id

1854: -- Call all supporting business operations
1855: --
1856:
1857:
1858: hr_api.validate_bus_grp_id
1859: (p_business_group_id => p_rec.business_group_id
1860: ,p_associated_column1 => pqp_vre_shd.g_tab_nam
1861: || '.BUSINESS_GROUP_ID');
1862:

Line 2086: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_status,hr_api.g_varchar2)

2082: END IF;
2083:
2084:
2085: --Checking for value change
2086: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_status,hr_api.g_varchar2)
2087: <> nvl(p_rec.vehicle_status,hr_api.g_varchar2) ) THEN
2088:
2089: --Checking If Vehicle Status is Inactive then inactive reason is mandatory
2090: --and should check with lookup

Line 2087: <> nvl(p_rec.vehicle_status,hr_api.g_varchar2) ) THEN

2083:
2084:
2085: --Checking for value change
2086: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_status,hr_api.g_varchar2)
2087: <> nvl(p_rec.vehicle_status,hr_api.g_varchar2) ) THEN
2088:
2089: --Checking If Vehicle Status is Inactive then inactive reason is mandatory
2090: --and should check with lookup
2091: IF p_rec.vehicle_status = 'I' THEN

Line 2115: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_ownership,hr_api.g_varchar2)

2111: END IF;
2112: END IF;
2113:
2114: --Checking for value change
2115: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_ownership,hr_api.g_varchar2)
2116: <> nvl(p_rec.vehicle_ownership,hr_api.g_varchar2) ) THEN
2117: --If not equal then Checking Ownership lookup validation
2118: l_return_status := chk_lookup(
2119: p_vehicle_repository_id => p_rec.vehicle_repository_id

Line 2116: <> nvl(p_rec.vehicle_ownership,hr_api.g_varchar2) ) THEN

2112: END IF;
2113:
2114: --Checking for value change
2115: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_ownership,hr_api.g_varchar2)
2116: <> nvl(p_rec.vehicle_ownership,hr_api.g_varchar2) ) THEN
2117: --If not equal then Checking Ownership lookup validation
2118: l_return_status := chk_lookup(
2119: p_vehicle_repository_id => p_rec.vehicle_repository_id
2120: ,p_lookup_type =>'PQP_VEHICLE_OWNERSHIP_TYPE'

Line 2133: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_status,hr_api.g_varchar2)

2129: END IF;
2130: END IF;
2131:
2132: --Checking for value change
2133: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_status,hr_api.g_varchar2)
2134: <> nvl(p_rec.vehicle_status,hr_api.g_varchar2) ) THEN
2135: --If not equal then Checking vehicle_status lookup validation
2136: l_return_status := chk_lookup(
2137: p_vehicle_repository_id => p_rec.vehicle_repository_id

Line 2134: <> nvl(p_rec.vehicle_status,hr_api.g_varchar2) ) THEN

2130: END IF;
2131:
2132: --Checking for value change
2133: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_status,hr_api.g_varchar2)
2134: <> nvl(p_rec.vehicle_status,hr_api.g_varchar2) ) THEN
2135: --If not equal then Checking vehicle_status lookup validation
2136: l_return_status := chk_lookup(
2137: p_vehicle_repository_id => p_rec.vehicle_repository_id
2138: ,p_lookup_type =>'PQP_VEHICLE_STATUS'

Line 2151: IF ( nvl(pqp_vre_shd.g_old_rec.fuel_type,hr_api.g_varchar2)

2147: END IF;
2148: END IF;
2149:
2150: --Checking for value change
2151: IF ( nvl(pqp_vre_shd.g_old_rec.fuel_type,hr_api.g_varchar2)
2152: <> nvl(p_rec.fuel_type,hr_api.g_varchar2) ) THEN
2153: --Checking Fuel Type lookup validation
2154: l_return_status := chk_lookup(
2155: p_vehicle_repository_id => p_rec.vehicle_repository_id

Line 2152: <> nvl(p_rec.fuel_type,hr_api.g_varchar2) ) THEN

2148: END IF;
2149:
2150: --Checking for value change
2151: IF ( nvl(pqp_vre_shd.g_old_rec.fuel_type,hr_api.g_varchar2)
2152: <> nvl(p_rec.fuel_type,hr_api.g_varchar2) ) THEN
2153: --Checking Fuel Type lookup validation
2154: l_return_status := chk_lookup(
2155: p_vehicle_repository_id => p_rec.vehicle_repository_id
2156: ,p_lookup_type =>'PQP_FUEL_TYPE'

Line 2168: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_type,hr_api.g_varchar2)

2164: END IF;
2165: END IF;
2166:
2167: --Checking for value change
2168: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_type,hr_api.g_varchar2)
2169: <> nvl(p_rec.vehicle_type,hr_api.g_varchar2) ) THEN
2170: --Checking Vehicle Type lookup validation
2171: l_return_status := chk_lookup(
2172: p_vehicle_repository_id => p_rec.vehicle_repository_id

Line 2169: <> nvl(p_rec.vehicle_type,hr_api.g_varchar2) ) THEN

2165: END IF;
2166:
2167: --Checking for value change
2168: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_type,hr_api.g_varchar2)
2169: <> nvl(p_rec.vehicle_type,hr_api.g_varchar2) ) THEN
2170: --Checking Vehicle Type lookup validation
2171: l_return_status := chk_lookup(
2172: p_vehicle_repository_id => p_rec.vehicle_repository_id
2173: ,p_lookup_type =>'PQP_VEHICLE_TYPE'