APPS.PQP_PVD_BUS dependencies on PQP_PVD_SHD

Line 177: (p_rec in pqp_pvd_shd.g_rec_type

173: -- Internal Row Handler Use Only.
174: --
175: -- ----------------------------------------------------------------------------
176: procedure chk_ddf
177: (p_rec in pqp_pvd_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72) := g_package || 'chk_ddf';
181: --

Line 186: nvl(pqp_pvd_shd.g_old_rec.vhd_information_category, hr_api.g_varchar2) <>

182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.vehicle_details_id is not null) and (
186: nvl(pqp_pvd_shd.g_old_rec.vhd_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.vhd_information_category, hr_api.g_varchar2) or
188: nvl(pqp_pvd_shd.g_old_rec.vhd_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.vhd_information1, hr_api.g_varchar2) or
190: nvl(pqp_pvd_shd.g_old_rec.vhd_information2, hr_api.g_varchar2) <>

Line 188: nvl(pqp_pvd_shd.g_old_rec.vhd_information1, hr_api.g_varchar2) <>

184: --
185: if ((p_rec.vehicle_details_id is not null) and (
186: nvl(pqp_pvd_shd.g_old_rec.vhd_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.vhd_information_category, hr_api.g_varchar2) or
188: nvl(pqp_pvd_shd.g_old_rec.vhd_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.vhd_information1, hr_api.g_varchar2) or
190: nvl(pqp_pvd_shd.g_old_rec.vhd_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.vhd_information2, hr_api.g_varchar2) or
192: nvl(pqp_pvd_shd.g_old_rec.vhd_information3, hr_api.g_varchar2) <>

Line 190: nvl(pqp_pvd_shd.g_old_rec.vhd_information2, hr_api.g_varchar2) <>

186: nvl(pqp_pvd_shd.g_old_rec.vhd_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.vhd_information_category, hr_api.g_varchar2) or
188: nvl(pqp_pvd_shd.g_old_rec.vhd_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.vhd_information1, hr_api.g_varchar2) or
190: nvl(pqp_pvd_shd.g_old_rec.vhd_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.vhd_information2, hr_api.g_varchar2) or
192: nvl(pqp_pvd_shd.g_old_rec.vhd_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.vhd_information3, hr_api.g_varchar2) or
194: nvl(pqp_pvd_shd.g_old_rec.vhd_information4, hr_api.g_varchar2) <>

Line 192: nvl(pqp_pvd_shd.g_old_rec.vhd_information3, hr_api.g_varchar2) <>

188: nvl(pqp_pvd_shd.g_old_rec.vhd_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.vhd_information1, hr_api.g_varchar2) or
190: nvl(pqp_pvd_shd.g_old_rec.vhd_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.vhd_information2, hr_api.g_varchar2) or
192: nvl(pqp_pvd_shd.g_old_rec.vhd_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.vhd_information3, hr_api.g_varchar2) or
194: nvl(pqp_pvd_shd.g_old_rec.vhd_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.vhd_information4, hr_api.g_varchar2) or
196: nvl(pqp_pvd_shd.g_old_rec.vhd_information5, hr_api.g_varchar2) <>

Line 194: nvl(pqp_pvd_shd.g_old_rec.vhd_information4, hr_api.g_varchar2) <>

190: nvl(pqp_pvd_shd.g_old_rec.vhd_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.vhd_information2, hr_api.g_varchar2) or
192: nvl(pqp_pvd_shd.g_old_rec.vhd_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.vhd_information3, hr_api.g_varchar2) or
194: nvl(pqp_pvd_shd.g_old_rec.vhd_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.vhd_information4, hr_api.g_varchar2) or
196: nvl(pqp_pvd_shd.g_old_rec.vhd_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.vhd_information5, hr_api.g_varchar2) or
198: nvl(pqp_pvd_shd.g_old_rec.vhd_information6, hr_api.g_varchar2) <>

Line 196: nvl(pqp_pvd_shd.g_old_rec.vhd_information5, hr_api.g_varchar2) <>

192: nvl(pqp_pvd_shd.g_old_rec.vhd_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.vhd_information3, hr_api.g_varchar2) or
194: nvl(pqp_pvd_shd.g_old_rec.vhd_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.vhd_information4, hr_api.g_varchar2) or
196: nvl(pqp_pvd_shd.g_old_rec.vhd_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.vhd_information5, hr_api.g_varchar2) or
198: nvl(pqp_pvd_shd.g_old_rec.vhd_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.vhd_information6, hr_api.g_varchar2) or
200: nvl(pqp_pvd_shd.g_old_rec.vhd_information7, hr_api.g_varchar2) <>

Line 198: nvl(pqp_pvd_shd.g_old_rec.vhd_information6, hr_api.g_varchar2) <>

194: nvl(pqp_pvd_shd.g_old_rec.vhd_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.vhd_information4, hr_api.g_varchar2) or
196: nvl(pqp_pvd_shd.g_old_rec.vhd_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.vhd_information5, hr_api.g_varchar2) or
198: nvl(pqp_pvd_shd.g_old_rec.vhd_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.vhd_information6, hr_api.g_varchar2) or
200: nvl(pqp_pvd_shd.g_old_rec.vhd_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.vhd_information7, hr_api.g_varchar2) or
202: nvl(pqp_pvd_shd.g_old_rec.vhd_information8, hr_api.g_varchar2) <>

Line 200: nvl(pqp_pvd_shd.g_old_rec.vhd_information7, hr_api.g_varchar2) <>

196: nvl(pqp_pvd_shd.g_old_rec.vhd_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.vhd_information5, hr_api.g_varchar2) or
198: nvl(pqp_pvd_shd.g_old_rec.vhd_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.vhd_information6, hr_api.g_varchar2) or
200: nvl(pqp_pvd_shd.g_old_rec.vhd_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.vhd_information7, hr_api.g_varchar2) or
202: nvl(pqp_pvd_shd.g_old_rec.vhd_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.vhd_information8, hr_api.g_varchar2) or
204: nvl(pqp_pvd_shd.g_old_rec.vhd_information9, hr_api.g_varchar2) <>

Line 202: nvl(pqp_pvd_shd.g_old_rec.vhd_information8, hr_api.g_varchar2) <>

198: nvl(pqp_pvd_shd.g_old_rec.vhd_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.vhd_information6, hr_api.g_varchar2) or
200: nvl(pqp_pvd_shd.g_old_rec.vhd_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.vhd_information7, hr_api.g_varchar2) or
202: nvl(pqp_pvd_shd.g_old_rec.vhd_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.vhd_information8, hr_api.g_varchar2) or
204: nvl(pqp_pvd_shd.g_old_rec.vhd_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.vhd_information9, hr_api.g_varchar2) or
206: nvl(pqp_pvd_shd.g_old_rec.vhd_information10, hr_api.g_varchar2) <>

Line 204: nvl(pqp_pvd_shd.g_old_rec.vhd_information9, hr_api.g_varchar2) <>

200: nvl(pqp_pvd_shd.g_old_rec.vhd_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.vhd_information7, hr_api.g_varchar2) or
202: nvl(pqp_pvd_shd.g_old_rec.vhd_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.vhd_information8, hr_api.g_varchar2) or
204: nvl(pqp_pvd_shd.g_old_rec.vhd_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.vhd_information9, hr_api.g_varchar2) or
206: nvl(pqp_pvd_shd.g_old_rec.vhd_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.vhd_information10, hr_api.g_varchar2) or
208: nvl(pqp_pvd_shd.g_old_rec.vhd_information11, hr_api.g_varchar2) <>

Line 206: nvl(pqp_pvd_shd.g_old_rec.vhd_information10, hr_api.g_varchar2) <>

202: nvl(pqp_pvd_shd.g_old_rec.vhd_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.vhd_information8, hr_api.g_varchar2) or
204: nvl(pqp_pvd_shd.g_old_rec.vhd_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.vhd_information9, hr_api.g_varchar2) or
206: nvl(pqp_pvd_shd.g_old_rec.vhd_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.vhd_information10, hr_api.g_varchar2) or
208: nvl(pqp_pvd_shd.g_old_rec.vhd_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.vhd_information11, hr_api.g_varchar2) or
210: nvl(pqp_pvd_shd.g_old_rec.vhd_information12, hr_api.g_varchar2) <>

Line 208: nvl(pqp_pvd_shd.g_old_rec.vhd_information11, hr_api.g_varchar2) <>

204: nvl(pqp_pvd_shd.g_old_rec.vhd_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.vhd_information9, hr_api.g_varchar2) or
206: nvl(pqp_pvd_shd.g_old_rec.vhd_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.vhd_information10, hr_api.g_varchar2) or
208: nvl(pqp_pvd_shd.g_old_rec.vhd_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.vhd_information11, hr_api.g_varchar2) or
210: nvl(pqp_pvd_shd.g_old_rec.vhd_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.vhd_information12, hr_api.g_varchar2) or
212: nvl(pqp_pvd_shd.g_old_rec.vhd_information13, hr_api.g_varchar2) <>

Line 210: nvl(pqp_pvd_shd.g_old_rec.vhd_information12, hr_api.g_varchar2) <>

206: nvl(pqp_pvd_shd.g_old_rec.vhd_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.vhd_information10, hr_api.g_varchar2) or
208: nvl(pqp_pvd_shd.g_old_rec.vhd_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.vhd_information11, hr_api.g_varchar2) or
210: nvl(pqp_pvd_shd.g_old_rec.vhd_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.vhd_information12, hr_api.g_varchar2) or
212: nvl(pqp_pvd_shd.g_old_rec.vhd_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.vhd_information13, hr_api.g_varchar2) or
214: nvl(pqp_pvd_shd.g_old_rec.vhd_information14, hr_api.g_varchar2) <>

Line 212: nvl(pqp_pvd_shd.g_old_rec.vhd_information13, hr_api.g_varchar2) <>

208: nvl(pqp_pvd_shd.g_old_rec.vhd_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.vhd_information11, hr_api.g_varchar2) or
210: nvl(pqp_pvd_shd.g_old_rec.vhd_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.vhd_information12, hr_api.g_varchar2) or
212: nvl(pqp_pvd_shd.g_old_rec.vhd_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.vhd_information13, hr_api.g_varchar2) or
214: nvl(pqp_pvd_shd.g_old_rec.vhd_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.vhd_information14, hr_api.g_varchar2) or
216: nvl(pqp_pvd_shd.g_old_rec.vhd_information15, hr_api.g_varchar2) <>

Line 214: nvl(pqp_pvd_shd.g_old_rec.vhd_information14, hr_api.g_varchar2) <>

210: nvl(pqp_pvd_shd.g_old_rec.vhd_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.vhd_information12, hr_api.g_varchar2) or
212: nvl(pqp_pvd_shd.g_old_rec.vhd_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.vhd_information13, hr_api.g_varchar2) or
214: nvl(pqp_pvd_shd.g_old_rec.vhd_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.vhd_information14, hr_api.g_varchar2) or
216: nvl(pqp_pvd_shd.g_old_rec.vhd_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.vhd_information15, hr_api.g_varchar2) or
218: nvl(pqp_pvd_shd.g_old_rec.vhd_information16, hr_api.g_varchar2) <>

Line 216: nvl(pqp_pvd_shd.g_old_rec.vhd_information15, hr_api.g_varchar2) <>

212: nvl(pqp_pvd_shd.g_old_rec.vhd_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.vhd_information13, hr_api.g_varchar2) or
214: nvl(pqp_pvd_shd.g_old_rec.vhd_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.vhd_information14, hr_api.g_varchar2) or
216: nvl(pqp_pvd_shd.g_old_rec.vhd_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.vhd_information15, hr_api.g_varchar2) or
218: nvl(pqp_pvd_shd.g_old_rec.vhd_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.vhd_information16, hr_api.g_varchar2) or
220: nvl(pqp_pvd_shd.g_old_rec.vhd_information17, hr_api.g_varchar2) <>

Line 218: nvl(pqp_pvd_shd.g_old_rec.vhd_information16, hr_api.g_varchar2) <>

214: nvl(pqp_pvd_shd.g_old_rec.vhd_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.vhd_information14, hr_api.g_varchar2) or
216: nvl(pqp_pvd_shd.g_old_rec.vhd_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.vhd_information15, hr_api.g_varchar2) or
218: nvl(pqp_pvd_shd.g_old_rec.vhd_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.vhd_information16, hr_api.g_varchar2) or
220: nvl(pqp_pvd_shd.g_old_rec.vhd_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.vhd_information17, hr_api.g_varchar2) or
222: nvl(pqp_pvd_shd.g_old_rec.vhd_information18, hr_api.g_varchar2) <>

Line 220: nvl(pqp_pvd_shd.g_old_rec.vhd_information17, hr_api.g_varchar2) <>

216: nvl(pqp_pvd_shd.g_old_rec.vhd_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.vhd_information15, hr_api.g_varchar2) or
218: nvl(pqp_pvd_shd.g_old_rec.vhd_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.vhd_information16, hr_api.g_varchar2) or
220: nvl(pqp_pvd_shd.g_old_rec.vhd_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.vhd_information17, hr_api.g_varchar2) or
222: nvl(pqp_pvd_shd.g_old_rec.vhd_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.vhd_information18, hr_api.g_varchar2) or
224: nvl(pqp_pvd_shd.g_old_rec.vhd_information19, hr_api.g_varchar2) <>

Line 222: nvl(pqp_pvd_shd.g_old_rec.vhd_information18, hr_api.g_varchar2) <>

218: nvl(pqp_pvd_shd.g_old_rec.vhd_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.vhd_information16, hr_api.g_varchar2) or
220: nvl(pqp_pvd_shd.g_old_rec.vhd_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.vhd_information17, hr_api.g_varchar2) or
222: nvl(pqp_pvd_shd.g_old_rec.vhd_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.vhd_information18, hr_api.g_varchar2) or
224: nvl(pqp_pvd_shd.g_old_rec.vhd_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.vhd_information19, hr_api.g_varchar2) or
226: nvl(pqp_pvd_shd.g_old_rec.vhd_information20, hr_api.g_varchar2) <>

Line 224: nvl(pqp_pvd_shd.g_old_rec.vhd_information19, hr_api.g_varchar2) <>

220: nvl(pqp_pvd_shd.g_old_rec.vhd_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.vhd_information17, hr_api.g_varchar2) or
222: nvl(pqp_pvd_shd.g_old_rec.vhd_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.vhd_information18, hr_api.g_varchar2) or
224: nvl(pqp_pvd_shd.g_old_rec.vhd_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.vhd_information19, hr_api.g_varchar2) or
226: nvl(pqp_pvd_shd.g_old_rec.vhd_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.vhd_information20, hr_api.g_varchar2) ))
228: or (p_rec.vehicle_details_id is null) then

Line 226: nvl(pqp_pvd_shd.g_old_rec.vhd_information20, hr_api.g_varchar2) <>

222: nvl(pqp_pvd_shd.g_old_rec.vhd_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.vhd_information18, hr_api.g_varchar2) or
224: nvl(pqp_pvd_shd.g_old_rec.vhd_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.vhd_information19, hr_api.g_varchar2) or
226: nvl(pqp_pvd_shd.g_old_rec.vhd_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.vhd_information20, hr_api.g_varchar2) ))
228: or (p_rec.vehicle_details_id is null) then
229: --
230: -- Only execute the validation if absolutely necessary:

Line 314: (p_rec in pqp_pvd_shd.g_rec_type

310: -- Internal Row Handler Use Only.
311: --
312: -- ----------------------------------------------------------------------------
313: procedure chk_df
314: (p_rec in pqp_pvd_shd.g_rec_type
315: ) is
316: --
317: l_proc varchar2(72) := g_package || 'chk_df';
318: --

Line 323: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute_category, hr_api.g_varchar2) <>

319: begin
320: hr_utility.set_location('Entering:'||l_proc,10);
321: --
322: if ((p_rec.vehicle_details_id is not null) and (
323: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.vhd_attribute_category, hr_api.g_varchar2) or
325: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.vhd_attribute1, hr_api.g_varchar2) or
327: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute2, hr_api.g_varchar2) <>

Line 325: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute1, hr_api.g_varchar2) <>

321: --
322: if ((p_rec.vehicle_details_id is not null) and (
323: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.vhd_attribute_category, hr_api.g_varchar2) or
325: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.vhd_attribute1, hr_api.g_varchar2) or
327: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.vhd_attribute2, hr_api.g_varchar2) or
329: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute3, hr_api.g_varchar2) <>

Line 327: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute2, hr_api.g_varchar2) <>

323: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.vhd_attribute_category, hr_api.g_varchar2) or
325: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.vhd_attribute1, hr_api.g_varchar2) or
327: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.vhd_attribute2, hr_api.g_varchar2) or
329: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.vhd_attribute3, hr_api.g_varchar2) or
331: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute4, hr_api.g_varchar2) <>

Line 329: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute3, hr_api.g_varchar2) <>

325: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.vhd_attribute1, hr_api.g_varchar2) or
327: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.vhd_attribute2, hr_api.g_varchar2) or
329: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.vhd_attribute3, hr_api.g_varchar2) or
331: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.vhd_attribute4, hr_api.g_varchar2) or
333: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute5, hr_api.g_varchar2) <>

Line 331: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute4, hr_api.g_varchar2) <>

327: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.vhd_attribute2, hr_api.g_varchar2) or
329: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.vhd_attribute3, hr_api.g_varchar2) or
331: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.vhd_attribute4, hr_api.g_varchar2) or
333: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.vhd_attribute5, hr_api.g_varchar2) or
335: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute6, hr_api.g_varchar2) <>

Line 333: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute5, hr_api.g_varchar2) <>

329: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.vhd_attribute3, hr_api.g_varchar2) or
331: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.vhd_attribute4, hr_api.g_varchar2) or
333: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.vhd_attribute5, hr_api.g_varchar2) or
335: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.vhd_attribute6, hr_api.g_varchar2) or
337: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute7, hr_api.g_varchar2) <>

Line 335: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute6, hr_api.g_varchar2) <>

331: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.vhd_attribute4, hr_api.g_varchar2) or
333: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.vhd_attribute5, hr_api.g_varchar2) or
335: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.vhd_attribute6, hr_api.g_varchar2) or
337: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.vhd_attribute7, hr_api.g_varchar2) or
339: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute8, hr_api.g_varchar2) <>

Line 337: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute7, hr_api.g_varchar2) <>

333: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.vhd_attribute5, hr_api.g_varchar2) or
335: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.vhd_attribute6, hr_api.g_varchar2) or
337: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.vhd_attribute7, hr_api.g_varchar2) or
339: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.vhd_attribute8, hr_api.g_varchar2) or
341: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute9, hr_api.g_varchar2) <>

Line 339: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute8, hr_api.g_varchar2) <>

335: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.vhd_attribute6, hr_api.g_varchar2) or
337: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.vhd_attribute7, hr_api.g_varchar2) or
339: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.vhd_attribute8, hr_api.g_varchar2) or
341: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.vhd_attribute9, hr_api.g_varchar2) or
343: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute10, hr_api.g_varchar2) <>

Line 341: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute9, hr_api.g_varchar2) <>

337: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.vhd_attribute7, hr_api.g_varchar2) or
339: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.vhd_attribute8, hr_api.g_varchar2) or
341: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.vhd_attribute9, hr_api.g_varchar2) or
343: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.vhd_attribute10, hr_api.g_varchar2) or
345: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute11, hr_api.g_varchar2) <>

Line 343: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute10, hr_api.g_varchar2) <>

339: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.vhd_attribute8, hr_api.g_varchar2) or
341: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.vhd_attribute9, hr_api.g_varchar2) or
343: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.vhd_attribute10, hr_api.g_varchar2) or
345: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.vhd_attribute11, hr_api.g_varchar2) or
347: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute12, hr_api.g_varchar2) <>

Line 345: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute11, hr_api.g_varchar2) <>

341: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.vhd_attribute9, hr_api.g_varchar2) or
343: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.vhd_attribute10, hr_api.g_varchar2) or
345: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.vhd_attribute11, hr_api.g_varchar2) or
347: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.vhd_attribute12, hr_api.g_varchar2) or
349: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute13, hr_api.g_varchar2) <>

Line 347: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute12, hr_api.g_varchar2) <>

343: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.vhd_attribute10, hr_api.g_varchar2) or
345: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.vhd_attribute11, hr_api.g_varchar2) or
347: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.vhd_attribute12, hr_api.g_varchar2) or
349: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.vhd_attribute13, hr_api.g_varchar2) or
351: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute14, hr_api.g_varchar2) <>

Line 349: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute13, hr_api.g_varchar2) <>

345: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.vhd_attribute11, hr_api.g_varchar2) or
347: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.vhd_attribute12, hr_api.g_varchar2) or
349: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.vhd_attribute13, hr_api.g_varchar2) or
351: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.vhd_attribute14, hr_api.g_varchar2) or
353: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute15, hr_api.g_varchar2) <>

Line 351: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute14, hr_api.g_varchar2) <>

347: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.vhd_attribute12, hr_api.g_varchar2) or
349: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.vhd_attribute13, hr_api.g_varchar2) or
351: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.vhd_attribute14, hr_api.g_varchar2) or
353: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.vhd_attribute15, hr_api.g_varchar2) or
355: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute16, hr_api.g_varchar2) <>

Line 353: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute15, hr_api.g_varchar2) <>

349: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.vhd_attribute13, hr_api.g_varchar2) or
351: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.vhd_attribute14, hr_api.g_varchar2) or
353: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.vhd_attribute15, hr_api.g_varchar2) or
355: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.vhd_attribute16, hr_api.g_varchar2) or
357: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute17, hr_api.g_varchar2) <>

Line 355: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute16, hr_api.g_varchar2) <>

351: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.vhd_attribute14, hr_api.g_varchar2) or
353: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.vhd_attribute15, hr_api.g_varchar2) or
355: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.vhd_attribute16, hr_api.g_varchar2) or
357: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.vhd_attribute17, hr_api.g_varchar2) or
359: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute18, hr_api.g_varchar2) <>

Line 357: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute17, hr_api.g_varchar2) <>

353: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.vhd_attribute15, hr_api.g_varchar2) or
355: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.vhd_attribute16, hr_api.g_varchar2) or
357: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.vhd_attribute17, hr_api.g_varchar2) or
359: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.vhd_attribute18, hr_api.g_varchar2) or
361: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute19, hr_api.g_varchar2) <>

Line 359: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute18, hr_api.g_varchar2) <>

355: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.vhd_attribute16, hr_api.g_varchar2) or
357: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.vhd_attribute17, hr_api.g_varchar2) or
359: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.vhd_attribute18, hr_api.g_varchar2) or
361: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.vhd_attribute19, hr_api.g_varchar2) or
363: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute20, hr_api.g_varchar2) <>

Line 361: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute19, hr_api.g_varchar2) <>

357: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.vhd_attribute17, hr_api.g_varchar2) or
359: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.vhd_attribute18, hr_api.g_varchar2) or
361: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.vhd_attribute19, hr_api.g_varchar2) or
363: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute20, hr_api.g_varchar2) <>
364: nvl(p_rec.vhd_attribute20, hr_api.g_varchar2) ))
365: or (p_rec.vehicle_details_id is null) then

Line 363: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute20, hr_api.g_varchar2) <>

359: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.vhd_attribute18, hr_api.g_varchar2) or
361: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.vhd_attribute19, hr_api.g_varchar2) or
363: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute20, hr_api.g_varchar2) <>
364: nvl(p_rec.vhd_attribute20, hr_api.g_varchar2) ))
365: or (p_rec.vehicle_details_id is null) then
366: --
367: -- Only execute the validation if absolutely necessary:

Line 451: ,p_rec in pqp_pvd_shd.g_rec_type

447: -- {End Of Comments}
448: -- ----------------------------------------------------------------------------
449: Procedure chk_non_updateable_args
450: (p_effective_date in date
451: ,p_rec in pqp_pvd_shd.g_rec_type
452: ) IS
453: --
454: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
455: l_error EXCEPTION;

Line 463: IF NOT pqp_pvd_shd.api_updating

459: --
460: -- Only proceed with the validation if a row exists for the current
461: -- record in the HR Schema.
462: --
463: IF NOT pqp_pvd_shd.api_updating
464: (p_vehicle_details_id => p_rec.vehicle_details_id
465: ,p_object_version_number => p_rec.object_version_number
466: ) THEN
467: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 650: ,p_rec in pqp_pvd_shd.g_rec_type

646: -- |---------------------------< insert_validate >----------------------------|
647: -- ----------------------------------------------------------------------------
648: Procedure insert_validate
649: (p_effective_date in date
650: ,p_rec in pqp_pvd_shd.g_rec_type
651: ) is
652: --
653: l_proc varchar2(72) := g_package||'insert_validate';
654: --

Line 713: ,p_rec in pqp_pvd_shd.g_rec_type

709: -- |---------------------------< update_validate >----------------------------|
710: -- ----------------------------------------------------------------------------
711: Procedure update_validate
712: (p_effective_date in date
713: ,p_rec in pqp_pvd_shd.g_rec_type
714: ) is
715: --
716: l_proc varchar2(72) := g_package||'update_validate';
717: --

Line 780: (p_rec in pqp_pvd_shd.g_rec_type

776: -- ----------------------------------------------------------------------------
777: -- |---------------------------< delete_validate >----------------------------|
778: -- ----------------------------------------------------------------------------
779: Procedure delete_validate
780: (p_rec in pqp_pvd_shd.g_rec_type
781: ) is
782: --
783: l_proc varchar2(72) := g_package||'delete_validate';
784: --