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 PQP_VRE_SHD

Line 190: (p_rec in pqp_vre_shd.g_rec_type

186: -- Internal Row Handler Use Only.
187: --
188: -- ----------------------------------------------------------------------------
189: PROCEDURE chk_ddf
190: (p_rec in pqp_vre_shd.g_rec_type
191: ) IS
192: --
193: l_proc varchar2(72) := g_package || 'chk_ddf';
194: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 327: (p_rec in pqp_vre_shd.g_rec_type

323: -- Internal Row Handler Use Only.
324: --
325: -- ----------------------------------------------------------------------------
326: PROCEDURE chk_df
327: (p_rec in pqp_vre_shd.g_rec_type
328: ) IS
329: --
330: l_proc varchar2(72) := g_package || 'chk_df';
331: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 464: ,p_rec IN pqp_vre_shd.g_rec_type

460: -- {End Of Comments}
461: -- ----------------------------------------------------------------------------
462: PROCEDURE chk_non_updateable_args
463: (p_effective_date IN DATE
464: ,p_rec IN pqp_vre_shd.g_rec_type
465: ) IS
466: --
467: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
468: --

Line 474: IF NOT pqp_vre_shd.api_updating

470: --
471: -- Only proceed with the validation if a row exists for the current
472: -- record in the HR Schema.
473: --
474: IF NOT pqp_vre_shd.api_updating
475: (p_vehicle_repository_id => p_rec.vehicle_repository_id
476: ,p_effective_date => p_effective_date
477: ,p_object_version_number => p_rec.object_version_number
478: ) THEN

Line 671: (p_rec IN pqp_vre_shd.g_rec_type

667: -- ----------------------------------------------------------------------------
668: --Checking the Vehicle Identification existence ,if same id exist
669: --then user cannot enter same Identification number once again.
670: PROCEDURE chk_unique_idennum
671: (p_rec IN pqp_vre_shd.g_rec_type
672: ,p_effective_date IN DATE
673: ,p_datetrack_mode IN VARCHAR2
674: ,p_validation_start_date IN DATE
675: ,p_validation_end_date IN DATE

Line 738: (p_rec IN pqp_vre_shd.g_rec_type

734: -- ----------------------------------------------------------------------------
735: --Checking th RegNumber existence ,if same registration number exist
736: --then user cannot enter same registration number once again.
737: PROCEDURE chk_unique_regnum
738: (p_rec IN pqp_vre_shd.g_rec_type
739: ,p_effective_date IN DATE
740: ,p_datetrack_mode IN VARCHAR2
741: ,p_validation_start_date IN DATE
742: ,p_validation_end_date IN DATE

Line 984: (p_rec IN pqp_vre_shd.g_rec_type

980: /*
981: This is used for checking all lookup types at once ,but now we removed this
982: because individual calls to
983: FUNCTION check_lookup
984: (p_rec IN pqp_vre_shd.g_rec_type
985: ,p_message OUT NOCOPY VARCHAR2
986: ) RETURN NUMBER IS
987:
988: CURSOR csr_lookup(cp_argument_value VARCHAR2,cp_lookup_type VARCHAR2) IS

Line 1057: (p_rec in pqp_vre_shd.g_rec_type

1053: ----------------------------------------------------------------------------
1054: --Used to check is there any ragistraion number change at update time.
1055: --If there is any change in reg number then throw error
1056: PROCEDURE validate_regnum
1057: (p_rec in pqp_vre_shd.g_rec_type
1058: ,p_effective_date in date
1059: ,p_datetrack_mode in varchar2
1060: ,p_validation_start_date in date
1061: ,p_validation_end_date in date

Line 1064: IF p_rec.registration_number<> pqp_vre_shd.g_old_rec.registration_number THEN

1060: ,p_validation_start_date in date
1061: ,p_validation_end_date in date
1062: ) IS
1063: BEGIN
1064: IF p_rec.registration_number<> pqp_vre_shd.g_old_rec.registration_number THEN
1065: fnd_message.set_name('PQP', 'PQP_230727_REGNUM_UPD_RSTRICT');
1066: fnd_message.raise_error;
1067: END IF;
1068: END;

Line 1078: (p_rec IN pqp_vre_shd.g_rec_type

1074: --is given to the user if the vehicle is assigned to employee to
1075: --indicate the change has to be done in the assignment on the usage type.
1076:
1077: FUNCTION pqp_check_ownership_change
1078: (p_rec IN pqp_vre_shd.g_rec_type
1079: ,p_effective_date IN DATE
1080: ,p_message OUT NOCOPY VARCHAR2
1081: ) RETURN NUMBER IS
1082:

Line 1102: IF pqp_vre_shd.g_old_rec.vehicle_ownership

1098: CLOSE c_alloc_count_cursor;
1099:
1100: IF l_rowcount > 0 THEN
1101:
1102: IF pqp_vre_shd.g_old_rec.vehicle_ownership
1103: <> p_rec.vehicle_ownership THEN
1104: p_message :='There is allocation for this vehicle, '||
1105: ' Please change the allocation usage type';
1106: RETURN -1;

Line 1179: (p_rec IN pqp_vre_shd.g_rec_type,

1175: --user indicating the car has been shared and need to go and
1176: --unallocated the car for employees and make this change.
1177:
1178: FUNCTION pqp_check_shared_veh
1179: (p_rec IN pqp_vre_shd.g_rec_type,
1180: p_effective_date IN DATE ,
1181: p_message OUT NOCOPY VARCHAR2
1182: ) RETURN NUMBER IS
1183:

Line 1213: IF pqp_vre_shd.g_old_rec.shared_vehicle = 'Y' THEN

1209: --If ShareVehicle is 'N' then check the value of original
1210: --shared vehicle value
1211: IF p_rec.shared_vehicle = 'N' THEN
1212:
1213: IF pqp_vre_shd.g_old_rec.shared_vehicle = 'Y' THEN
1214:
1215: --Check value existence in allcations table
1216: OPEN c_alloc_count_cursor;
1217: LOOP

Line 1268: ( p_rec IN pqp_vre_shd.g_rec_type

1264: /*
1265: This is used checking all mandatory values at once
1266: removed this functin and made individual calls
1267: FUNCTION chk_mandatory
1268: ( p_rec IN pqp_vre_shd.g_rec_type
1269: ,p_message OUT NOCOPY VARCHAR2
1270: ) RETURN NUMBER IS
1271: BEGIN
1272: IF p_rec.vehicle_ownership IS NULL THEN

Line 1306: (p_rec IN pqp_vre_shd.g_rec_type,

1302: --Purge means the data is completely zapped from the database
1303: --but again the error message is given if the vehicle has been assigned to
1304: --an employee
1305: FUNCTION pqp_purge_delete_veh
1306: (p_rec IN pqp_vre_shd.g_rec_type,
1307: p_effective_date IN DATE ,
1308: p_message OUT NOCOPY VARCHAR2
1309: ) RETURN VARCHAR2 IS
1310: --Getting the allocation count for past ,future and current date tracks

Line 1383: (p_rec IN pqp_vre_shd.g_rec_type,

1379: --message will be given if the user is still using the vehicle.
1380: --The user must end date all the allocations and then end date repository data.
1381: --
1382: FUNCTION pqp_enddate_delete_veh
1383: (p_rec IN pqp_vre_shd.g_rec_type,
1384: p_effective_date IN DATE ,
1385: p_message OUT NOCOPY VARCHAR2
1386: ) RETURN VARCHAR2 IS
1387:

Line 1465: (p_rec IN pqp_vre_shd.g_rec_type

1461: -- ----------------------------------------------------------------------------
1462: -- |---------------------------< insert_validate >----------------------------|
1463: -- ----------------------------------------------------------------------------
1464: PROCEDURE insert_validate
1465: (p_rec IN pqp_vre_shd.g_rec_type
1466: ,p_effective_date IN DATE
1467: ,p_datetrack_mode IN VARCHAR2
1468: ,p_validation_start_date IN DATE
1469: ,p_validation_end_date IN DATE

Line 1489: ,p_associated_column1 => pqp_vre_shd.g_tab_nam

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:
1492: --Checking the unique regNumber
1493: chk_unique_regnum

Line 1836: (p_rec in pqp_vre_shd.g_rec_type

1832: -- ----------------------------------------------------------------------------
1833: -- |---------------------------< update_validate >----------------------------|
1834: -- ----------------------------------------------------------------------------
1835: PROCEDURE update_validate
1836: (p_rec in pqp_vre_shd.g_rec_type
1837: ,p_effective_date in date
1838: ,p_datetrack_mode in varchar2
1839: ,p_validation_start_date in date
1840: ,p_validation_end_date in date

Line 1860: ,p_associated_column1 => pqp_vre_shd.g_tab_nam

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:
1863:
1864: dt_update_validate

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 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 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 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 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 2254: (p_rec IN pqp_vre_shd.g_rec_type

2250: -- ----------------------------------------------------------------------------
2251: -- |---------------------------< delete_validate >----------------------------|
2252: -- ----------------------------------------------------------------------------
2253: PROCEDURE delete_validate
2254: (p_rec IN pqp_vre_shd.g_rec_type
2255: ,p_effective_date IN DATE
2256: ,p_datetrack_mode IN VARCHAR2
2257: ,p_validation_start_date IN DATE
2258: ,p_validation_end_date IN DATE