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_VAL_BUS dependencies on PQP_VAL_SHD

Line 189: (p_rec in pqp_val_shd.g_rec_type

185: -- Internal Row Handler Use Only.
186: --
187: -- ----------------------------------------------------------------------------
188: procedure chk_ddf
189: (p_rec in pqp_val_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package || 'chk_ddf';
193: --

Line 198: nvl(pqp_val_shd.g_old_rec.val_information_category, hr_api.g_varchar2) <>

194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.vehicle_allocation_id is not null) and (
198: nvl(pqp_val_shd.g_old_rec.val_information_category, hr_api.g_varchar2) <>
199: nvl(p_rec.val_information_category, hr_api.g_varchar2) or
200: nvl(pqp_val_shd.g_old_rec.val_information1, hr_api.g_varchar2) <>
201: nvl(p_rec.val_information1, hr_api.g_varchar2) or
202: nvl(pqp_val_shd.g_old_rec.val_information2, hr_api.g_varchar2) <>

Line 200: nvl(pqp_val_shd.g_old_rec.val_information1, hr_api.g_varchar2) <>

196: --
197: if ((p_rec.vehicle_allocation_id is not null) and (
198: nvl(pqp_val_shd.g_old_rec.val_information_category, hr_api.g_varchar2) <>
199: nvl(p_rec.val_information_category, hr_api.g_varchar2) or
200: nvl(pqp_val_shd.g_old_rec.val_information1, hr_api.g_varchar2) <>
201: nvl(p_rec.val_information1, hr_api.g_varchar2) or
202: nvl(pqp_val_shd.g_old_rec.val_information2, hr_api.g_varchar2) <>
203: nvl(p_rec.val_information2, hr_api.g_varchar2) or
204: nvl(pqp_val_shd.g_old_rec.val_information3, hr_api.g_varchar2) <>

Line 202: nvl(pqp_val_shd.g_old_rec.val_information2, hr_api.g_varchar2) <>

198: nvl(pqp_val_shd.g_old_rec.val_information_category, hr_api.g_varchar2) <>
199: nvl(p_rec.val_information_category, hr_api.g_varchar2) or
200: nvl(pqp_val_shd.g_old_rec.val_information1, hr_api.g_varchar2) <>
201: nvl(p_rec.val_information1, hr_api.g_varchar2) or
202: nvl(pqp_val_shd.g_old_rec.val_information2, hr_api.g_varchar2) <>
203: nvl(p_rec.val_information2, hr_api.g_varchar2) or
204: nvl(pqp_val_shd.g_old_rec.val_information3, hr_api.g_varchar2) <>
205: nvl(p_rec.val_information3, hr_api.g_varchar2) or
206: nvl(pqp_val_shd.g_old_rec.val_information4, hr_api.g_varchar2) <>

Line 204: nvl(pqp_val_shd.g_old_rec.val_information3, hr_api.g_varchar2) <>

200: nvl(pqp_val_shd.g_old_rec.val_information1, hr_api.g_varchar2) <>
201: nvl(p_rec.val_information1, hr_api.g_varchar2) or
202: nvl(pqp_val_shd.g_old_rec.val_information2, hr_api.g_varchar2) <>
203: nvl(p_rec.val_information2, hr_api.g_varchar2) or
204: nvl(pqp_val_shd.g_old_rec.val_information3, hr_api.g_varchar2) <>
205: nvl(p_rec.val_information3, hr_api.g_varchar2) or
206: nvl(pqp_val_shd.g_old_rec.val_information4, hr_api.g_varchar2) <>
207: nvl(p_rec.val_information4, hr_api.g_varchar2) or
208: nvl(pqp_val_shd.g_old_rec.val_information5, hr_api.g_varchar2) <>

Line 206: nvl(pqp_val_shd.g_old_rec.val_information4, hr_api.g_varchar2) <>

202: nvl(pqp_val_shd.g_old_rec.val_information2, hr_api.g_varchar2) <>
203: nvl(p_rec.val_information2, hr_api.g_varchar2) or
204: nvl(pqp_val_shd.g_old_rec.val_information3, hr_api.g_varchar2) <>
205: nvl(p_rec.val_information3, hr_api.g_varchar2) or
206: nvl(pqp_val_shd.g_old_rec.val_information4, hr_api.g_varchar2) <>
207: nvl(p_rec.val_information4, hr_api.g_varchar2) or
208: nvl(pqp_val_shd.g_old_rec.val_information5, hr_api.g_varchar2) <>
209: nvl(p_rec.val_information5, hr_api.g_varchar2) or
210: nvl(pqp_val_shd.g_old_rec.val_information6, hr_api.g_varchar2) <>

Line 208: nvl(pqp_val_shd.g_old_rec.val_information5, hr_api.g_varchar2) <>

204: nvl(pqp_val_shd.g_old_rec.val_information3, hr_api.g_varchar2) <>
205: nvl(p_rec.val_information3, hr_api.g_varchar2) or
206: nvl(pqp_val_shd.g_old_rec.val_information4, hr_api.g_varchar2) <>
207: nvl(p_rec.val_information4, hr_api.g_varchar2) or
208: nvl(pqp_val_shd.g_old_rec.val_information5, hr_api.g_varchar2) <>
209: nvl(p_rec.val_information5, hr_api.g_varchar2) or
210: nvl(pqp_val_shd.g_old_rec.val_information6, hr_api.g_varchar2) <>
211: nvl(p_rec.val_information6, hr_api.g_varchar2) or
212: nvl(pqp_val_shd.g_old_rec.val_information7, hr_api.g_varchar2) <>

Line 210: nvl(pqp_val_shd.g_old_rec.val_information6, hr_api.g_varchar2) <>

206: nvl(pqp_val_shd.g_old_rec.val_information4, hr_api.g_varchar2) <>
207: nvl(p_rec.val_information4, hr_api.g_varchar2) or
208: nvl(pqp_val_shd.g_old_rec.val_information5, hr_api.g_varchar2) <>
209: nvl(p_rec.val_information5, hr_api.g_varchar2) or
210: nvl(pqp_val_shd.g_old_rec.val_information6, hr_api.g_varchar2) <>
211: nvl(p_rec.val_information6, hr_api.g_varchar2) or
212: nvl(pqp_val_shd.g_old_rec.val_information7, hr_api.g_varchar2) <>
213: nvl(p_rec.val_information7, hr_api.g_varchar2) or
214: nvl(pqp_val_shd.g_old_rec.val_information8, hr_api.g_varchar2) <>

Line 212: nvl(pqp_val_shd.g_old_rec.val_information7, hr_api.g_varchar2) <>

208: nvl(pqp_val_shd.g_old_rec.val_information5, hr_api.g_varchar2) <>
209: nvl(p_rec.val_information5, hr_api.g_varchar2) or
210: nvl(pqp_val_shd.g_old_rec.val_information6, hr_api.g_varchar2) <>
211: nvl(p_rec.val_information6, hr_api.g_varchar2) or
212: nvl(pqp_val_shd.g_old_rec.val_information7, hr_api.g_varchar2) <>
213: nvl(p_rec.val_information7, hr_api.g_varchar2) or
214: nvl(pqp_val_shd.g_old_rec.val_information8, hr_api.g_varchar2) <>
215: nvl(p_rec.val_information8, hr_api.g_varchar2) or
216: nvl(pqp_val_shd.g_old_rec.val_information9, hr_api.g_varchar2) <>

Line 214: nvl(pqp_val_shd.g_old_rec.val_information8, hr_api.g_varchar2) <>

210: nvl(pqp_val_shd.g_old_rec.val_information6, hr_api.g_varchar2) <>
211: nvl(p_rec.val_information6, hr_api.g_varchar2) or
212: nvl(pqp_val_shd.g_old_rec.val_information7, hr_api.g_varchar2) <>
213: nvl(p_rec.val_information7, hr_api.g_varchar2) or
214: nvl(pqp_val_shd.g_old_rec.val_information8, hr_api.g_varchar2) <>
215: nvl(p_rec.val_information8, hr_api.g_varchar2) or
216: nvl(pqp_val_shd.g_old_rec.val_information9, hr_api.g_varchar2) <>
217: nvl(p_rec.val_information9, hr_api.g_varchar2) or
218: nvl(pqp_val_shd.g_old_rec.val_information10, hr_api.g_varchar2) <>

Line 216: nvl(pqp_val_shd.g_old_rec.val_information9, hr_api.g_varchar2) <>

212: nvl(pqp_val_shd.g_old_rec.val_information7, hr_api.g_varchar2) <>
213: nvl(p_rec.val_information7, hr_api.g_varchar2) or
214: nvl(pqp_val_shd.g_old_rec.val_information8, hr_api.g_varchar2) <>
215: nvl(p_rec.val_information8, hr_api.g_varchar2) or
216: nvl(pqp_val_shd.g_old_rec.val_information9, hr_api.g_varchar2) <>
217: nvl(p_rec.val_information9, hr_api.g_varchar2) or
218: nvl(pqp_val_shd.g_old_rec.val_information10, hr_api.g_varchar2) <>
219: nvl(p_rec.val_information10, hr_api.g_varchar2) or
220: nvl(pqp_val_shd.g_old_rec.val_information11, hr_api.g_varchar2) <>

Line 218: nvl(pqp_val_shd.g_old_rec.val_information10, hr_api.g_varchar2) <>

214: nvl(pqp_val_shd.g_old_rec.val_information8, hr_api.g_varchar2) <>
215: nvl(p_rec.val_information8, hr_api.g_varchar2) or
216: nvl(pqp_val_shd.g_old_rec.val_information9, hr_api.g_varchar2) <>
217: nvl(p_rec.val_information9, hr_api.g_varchar2) or
218: nvl(pqp_val_shd.g_old_rec.val_information10, hr_api.g_varchar2) <>
219: nvl(p_rec.val_information10, hr_api.g_varchar2) or
220: nvl(pqp_val_shd.g_old_rec.val_information11, hr_api.g_varchar2) <>
221: nvl(p_rec.val_information11, hr_api.g_varchar2) or
222: nvl(pqp_val_shd.g_old_rec.val_information12, hr_api.g_varchar2) <>

Line 220: nvl(pqp_val_shd.g_old_rec.val_information11, hr_api.g_varchar2) <>

216: nvl(pqp_val_shd.g_old_rec.val_information9, hr_api.g_varchar2) <>
217: nvl(p_rec.val_information9, hr_api.g_varchar2) or
218: nvl(pqp_val_shd.g_old_rec.val_information10, hr_api.g_varchar2) <>
219: nvl(p_rec.val_information10, hr_api.g_varchar2) or
220: nvl(pqp_val_shd.g_old_rec.val_information11, hr_api.g_varchar2) <>
221: nvl(p_rec.val_information11, hr_api.g_varchar2) or
222: nvl(pqp_val_shd.g_old_rec.val_information12, hr_api.g_varchar2) <>
223: nvl(p_rec.val_information12, hr_api.g_varchar2) or
224: nvl(pqp_val_shd.g_old_rec.val_information13, hr_api.g_varchar2) <>

Line 222: nvl(pqp_val_shd.g_old_rec.val_information12, hr_api.g_varchar2) <>

218: nvl(pqp_val_shd.g_old_rec.val_information10, hr_api.g_varchar2) <>
219: nvl(p_rec.val_information10, hr_api.g_varchar2) or
220: nvl(pqp_val_shd.g_old_rec.val_information11, hr_api.g_varchar2) <>
221: nvl(p_rec.val_information11, hr_api.g_varchar2) or
222: nvl(pqp_val_shd.g_old_rec.val_information12, hr_api.g_varchar2) <>
223: nvl(p_rec.val_information12, hr_api.g_varchar2) or
224: nvl(pqp_val_shd.g_old_rec.val_information13, hr_api.g_varchar2) <>
225: nvl(p_rec.val_information13, hr_api.g_varchar2) or
226: nvl(pqp_val_shd.g_old_rec.val_information14, hr_api.g_varchar2) <>

Line 224: nvl(pqp_val_shd.g_old_rec.val_information13, hr_api.g_varchar2) <>

220: nvl(pqp_val_shd.g_old_rec.val_information11, hr_api.g_varchar2) <>
221: nvl(p_rec.val_information11, hr_api.g_varchar2) or
222: nvl(pqp_val_shd.g_old_rec.val_information12, hr_api.g_varchar2) <>
223: nvl(p_rec.val_information12, hr_api.g_varchar2) or
224: nvl(pqp_val_shd.g_old_rec.val_information13, hr_api.g_varchar2) <>
225: nvl(p_rec.val_information13, hr_api.g_varchar2) or
226: nvl(pqp_val_shd.g_old_rec.val_information14, hr_api.g_varchar2) <>
227: nvl(p_rec.val_information14, hr_api.g_varchar2) or
228: nvl(pqp_val_shd.g_old_rec.val_information15, hr_api.g_varchar2) <>

Line 226: nvl(pqp_val_shd.g_old_rec.val_information14, hr_api.g_varchar2) <>

222: nvl(pqp_val_shd.g_old_rec.val_information12, hr_api.g_varchar2) <>
223: nvl(p_rec.val_information12, hr_api.g_varchar2) or
224: nvl(pqp_val_shd.g_old_rec.val_information13, hr_api.g_varchar2) <>
225: nvl(p_rec.val_information13, hr_api.g_varchar2) or
226: nvl(pqp_val_shd.g_old_rec.val_information14, hr_api.g_varchar2) <>
227: nvl(p_rec.val_information14, hr_api.g_varchar2) or
228: nvl(pqp_val_shd.g_old_rec.val_information15, hr_api.g_varchar2) <>
229: nvl(p_rec.val_information15, hr_api.g_varchar2) or
230: nvl(pqp_val_shd.g_old_rec.val_information16, hr_api.g_varchar2) <>

Line 228: nvl(pqp_val_shd.g_old_rec.val_information15, hr_api.g_varchar2) <>

224: nvl(pqp_val_shd.g_old_rec.val_information13, hr_api.g_varchar2) <>
225: nvl(p_rec.val_information13, hr_api.g_varchar2) or
226: nvl(pqp_val_shd.g_old_rec.val_information14, hr_api.g_varchar2) <>
227: nvl(p_rec.val_information14, hr_api.g_varchar2) or
228: nvl(pqp_val_shd.g_old_rec.val_information15, hr_api.g_varchar2) <>
229: nvl(p_rec.val_information15, hr_api.g_varchar2) or
230: nvl(pqp_val_shd.g_old_rec.val_information16, hr_api.g_varchar2) <>
231: nvl(p_rec.val_information16, hr_api.g_varchar2) or
232: nvl(pqp_val_shd.g_old_rec.val_information17, hr_api.g_varchar2) <>

Line 230: nvl(pqp_val_shd.g_old_rec.val_information16, hr_api.g_varchar2) <>

226: nvl(pqp_val_shd.g_old_rec.val_information14, hr_api.g_varchar2) <>
227: nvl(p_rec.val_information14, hr_api.g_varchar2) or
228: nvl(pqp_val_shd.g_old_rec.val_information15, hr_api.g_varchar2) <>
229: nvl(p_rec.val_information15, hr_api.g_varchar2) or
230: nvl(pqp_val_shd.g_old_rec.val_information16, hr_api.g_varchar2) <>
231: nvl(p_rec.val_information16, hr_api.g_varchar2) or
232: nvl(pqp_val_shd.g_old_rec.val_information17, hr_api.g_varchar2) <>
233: nvl(p_rec.val_information17, hr_api.g_varchar2) or
234: nvl(pqp_val_shd.g_old_rec.val_information18, hr_api.g_varchar2) <>

Line 232: nvl(pqp_val_shd.g_old_rec.val_information17, hr_api.g_varchar2) <>

228: nvl(pqp_val_shd.g_old_rec.val_information15, hr_api.g_varchar2) <>
229: nvl(p_rec.val_information15, hr_api.g_varchar2) or
230: nvl(pqp_val_shd.g_old_rec.val_information16, hr_api.g_varchar2) <>
231: nvl(p_rec.val_information16, hr_api.g_varchar2) or
232: nvl(pqp_val_shd.g_old_rec.val_information17, hr_api.g_varchar2) <>
233: nvl(p_rec.val_information17, hr_api.g_varchar2) or
234: nvl(pqp_val_shd.g_old_rec.val_information18, hr_api.g_varchar2) <>
235: nvl(p_rec.val_information18, hr_api.g_varchar2) or
236: nvl(pqp_val_shd.g_old_rec.val_information19, hr_api.g_varchar2) <>

Line 234: nvl(pqp_val_shd.g_old_rec.val_information18, hr_api.g_varchar2) <>

230: nvl(pqp_val_shd.g_old_rec.val_information16, hr_api.g_varchar2) <>
231: nvl(p_rec.val_information16, hr_api.g_varchar2) or
232: nvl(pqp_val_shd.g_old_rec.val_information17, hr_api.g_varchar2) <>
233: nvl(p_rec.val_information17, hr_api.g_varchar2) or
234: nvl(pqp_val_shd.g_old_rec.val_information18, hr_api.g_varchar2) <>
235: nvl(p_rec.val_information18, hr_api.g_varchar2) or
236: nvl(pqp_val_shd.g_old_rec.val_information19, hr_api.g_varchar2) <>
237: nvl(p_rec.val_information19, hr_api.g_varchar2) or
238: nvl(pqp_val_shd.g_old_rec.val_information20, hr_api.g_varchar2) <>

Line 236: nvl(pqp_val_shd.g_old_rec.val_information19, hr_api.g_varchar2) <>

232: nvl(pqp_val_shd.g_old_rec.val_information17, hr_api.g_varchar2) <>
233: nvl(p_rec.val_information17, hr_api.g_varchar2) or
234: nvl(pqp_val_shd.g_old_rec.val_information18, hr_api.g_varchar2) <>
235: nvl(p_rec.val_information18, hr_api.g_varchar2) or
236: nvl(pqp_val_shd.g_old_rec.val_information19, hr_api.g_varchar2) <>
237: nvl(p_rec.val_information19, hr_api.g_varchar2) or
238: nvl(pqp_val_shd.g_old_rec.val_information20, hr_api.g_varchar2) <>
239: nvl(p_rec.val_information20, hr_api.g_varchar2) ))
240: or (p_rec.vehicle_allocation_id is null) then

Line 238: nvl(pqp_val_shd.g_old_rec.val_information20, hr_api.g_varchar2) <>

234: nvl(pqp_val_shd.g_old_rec.val_information18, hr_api.g_varchar2) <>
235: nvl(p_rec.val_information18, hr_api.g_varchar2) or
236: nvl(pqp_val_shd.g_old_rec.val_information19, hr_api.g_varchar2) <>
237: nvl(p_rec.val_information19, hr_api.g_varchar2) or
238: nvl(pqp_val_shd.g_old_rec.val_information20, hr_api.g_varchar2) <>
239: nvl(p_rec.val_information20, hr_api.g_varchar2) ))
240: or (p_rec.vehicle_allocation_id is null) then
241: --
242: -- Only execute the validation if absolutely necessary:

Line 326: (p_rec in pqp_val_shd.g_rec_type

322: -- Internal Row Handler Use Only.
323: --
324: -- ----------------------------------------------------------------------------
325: procedure chk_df
326: (p_rec in pqp_val_shd.g_rec_type
327: ) is
328: --
329: l_proc varchar2(72) := g_package || 'chk_df';
330: --

Line 335: nvl(pqp_val_shd.g_old_rec.val_attribute_category, hr_api.g_varchar2) <>

331: begin
332: hr_utility.set_location('Entering:'||l_proc,10);
333: --
334: if ((p_rec.vehicle_allocation_id is not null) and (
335: nvl(pqp_val_shd.g_old_rec.val_attribute_category, hr_api.g_varchar2) <>
336: nvl(p_rec.val_attribute_category, hr_api.g_varchar2) or
337: nvl(pqp_val_shd.g_old_rec.val_attribute1, hr_api.g_varchar2) <>
338: nvl(p_rec.val_attribute1, hr_api.g_varchar2) or
339: nvl(pqp_val_shd.g_old_rec.val_attribute2, hr_api.g_varchar2) <>

Line 337: nvl(pqp_val_shd.g_old_rec.val_attribute1, hr_api.g_varchar2) <>

333: --
334: if ((p_rec.vehicle_allocation_id is not null) and (
335: nvl(pqp_val_shd.g_old_rec.val_attribute_category, hr_api.g_varchar2) <>
336: nvl(p_rec.val_attribute_category, hr_api.g_varchar2) or
337: nvl(pqp_val_shd.g_old_rec.val_attribute1, hr_api.g_varchar2) <>
338: nvl(p_rec.val_attribute1, hr_api.g_varchar2) or
339: nvl(pqp_val_shd.g_old_rec.val_attribute2, hr_api.g_varchar2) <>
340: nvl(p_rec.val_attribute2, hr_api.g_varchar2) or
341: nvl(pqp_val_shd.g_old_rec.val_attribute3, hr_api.g_varchar2) <>

Line 339: nvl(pqp_val_shd.g_old_rec.val_attribute2, hr_api.g_varchar2) <>

335: nvl(pqp_val_shd.g_old_rec.val_attribute_category, hr_api.g_varchar2) <>
336: nvl(p_rec.val_attribute_category, hr_api.g_varchar2) or
337: nvl(pqp_val_shd.g_old_rec.val_attribute1, hr_api.g_varchar2) <>
338: nvl(p_rec.val_attribute1, hr_api.g_varchar2) or
339: nvl(pqp_val_shd.g_old_rec.val_attribute2, hr_api.g_varchar2) <>
340: nvl(p_rec.val_attribute2, hr_api.g_varchar2) or
341: nvl(pqp_val_shd.g_old_rec.val_attribute3, hr_api.g_varchar2) <>
342: nvl(p_rec.val_attribute3, hr_api.g_varchar2) or
343: nvl(pqp_val_shd.g_old_rec.val_attribute4, hr_api.g_varchar2) <>

Line 341: nvl(pqp_val_shd.g_old_rec.val_attribute3, hr_api.g_varchar2) <>

337: nvl(pqp_val_shd.g_old_rec.val_attribute1, hr_api.g_varchar2) <>
338: nvl(p_rec.val_attribute1, hr_api.g_varchar2) or
339: nvl(pqp_val_shd.g_old_rec.val_attribute2, hr_api.g_varchar2) <>
340: nvl(p_rec.val_attribute2, hr_api.g_varchar2) or
341: nvl(pqp_val_shd.g_old_rec.val_attribute3, hr_api.g_varchar2) <>
342: nvl(p_rec.val_attribute3, hr_api.g_varchar2) or
343: nvl(pqp_val_shd.g_old_rec.val_attribute4, hr_api.g_varchar2) <>
344: nvl(p_rec.val_attribute4, hr_api.g_varchar2) or
345: nvl(pqp_val_shd.g_old_rec.val_attribute5, hr_api.g_varchar2) <>

Line 343: nvl(pqp_val_shd.g_old_rec.val_attribute4, hr_api.g_varchar2) <>

339: nvl(pqp_val_shd.g_old_rec.val_attribute2, hr_api.g_varchar2) <>
340: nvl(p_rec.val_attribute2, hr_api.g_varchar2) or
341: nvl(pqp_val_shd.g_old_rec.val_attribute3, hr_api.g_varchar2) <>
342: nvl(p_rec.val_attribute3, hr_api.g_varchar2) or
343: nvl(pqp_val_shd.g_old_rec.val_attribute4, hr_api.g_varchar2) <>
344: nvl(p_rec.val_attribute4, hr_api.g_varchar2) or
345: nvl(pqp_val_shd.g_old_rec.val_attribute5, hr_api.g_varchar2) <>
346: nvl(p_rec.val_attribute5, hr_api.g_varchar2) or
347: nvl(pqp_val_shd.g_old_rec.val_attribute6, hr_api.g_varchar2) <>

Line 345: nvl(pqp_val_shd.g_old_rec.val_attribute5, hr_api.g_varchar2) <>

341: nvl(pqp_val_shd.g_old_rec.val_attribute3, hr_api.g_varchar2) <>
342: nvl(p_rec.val_attribute3, hr_api.g_varchar2) or
343: nvl(pqp_val_shd.g_old_rec.val_attribute4, hr_api.g_varchar2) <>
344: nvl(p_rec.val_attribute4, hr_api.g_varchar2) or
345: nvl(pqp_val_shd.g_old_rec.val_attribute5, hr_api.g_varchar2) <>
346: nvl(p_rec.val_attribute5, hr_api.g_varchar2) or
347: nvl(pqp_val_shd.g_old_rec.val_attribute6, hr_api.g_varchar2) <>
348: nvl(p_rec.val_attribute6, hr_api.g_varchar2) or
349: nvl(pqp_val_shd.g_old_rec.val_attribute7, hr_api.g_varchar2) <>

Line 347: nvl(pqp_val_shd.g_old_rec.val_attribute6, hr_api.g_varchar2) <>

343: nvl(pqp_val_shd.g_old_rec.val_attribute4, hr_api.g_varchar2) <>
344: nvl(p_rec.val_attribute4, hr_api.g_varchar2) or
345: nvl(pqp_val_shd.g_old_rec.val_attribute5, hr_api.g_varchar2) <>
346: nvl(p_rec.val_attribute5, hr_api.g_varchar2) or
347: nvl(pqp_val_shd.g_old_rec.val_attribute6, hr_api.g_varchar2) <>
348: nvl(p_rec.val_attribute6, hr_api.g_varchar2) or
349: nvl(pqp_val_shd.g_old_rec.val_attribute7, hr_api.g_varchar2) <>
350: nvl(p_rec.val_attribute7, hr_api.g_varchar2) or
351: nvl(pqp_val_shd.g_old_rec.val_attribute8, hr_api.g_varchar2) <>

Line 349: nvl(pqp_val_shd.g_old_rec.val_attribute7, hr_api.g_varchar2) <>

345: nvl(pqp_val_shd.g_old_rec.val_attribute5, hr_api.g_varchar2) <>
346: nvl(p_rec.val_attribute5, hr_api.g_varchar2) or
347: nvl(pqp_val_shd.g_old_rec.val_attribute6, hr_api.g_varchar2) <>
348: nvl(p_rec.val_attribute6, hr_api.g_varchar2) or
349: nvl(pqp_val_shd.g_old_rec.val_attribute7, hr_api.g_varchar2) <>
350: nvl(p_rec.val_attribute7, hr_api.g_varchar2) or
351: nvl(pqp_val_shd.g_old_rec.val_attribute8, hr_api.g_varchar2) <>
352: nvl(p_rec.val_attribute8, hr_api.g_varchar2) or
353: nvl(pqp_val_shd.g_old_rec.val_attribute9, hr_api.g_varchar2) <>

Line 351: nvl(pqp_val_shd.g_old_rec.val_attribute8, hr_api.g_varchar2) <>

347: nvl(pqp_val_shd.g_old_rec.val_attribute6, hr_api.g_varchar2) <>
348: nvl(p_rec.val_attribute6, hr_api.g_varchar2) or
349: nvl(pqp_val_shd.g_old_rec.val_attribute7, hr_api.g_varchar2) <>
350: nvl(p_rec.val_attribute7, hr_api.g_varchar2) or
351: nvl(pqp_val_shd.g_old_rec.val_attribute8, hr_api.g_varchar2) <>
352: nvl(p_rec.val_attribute8, hr_api.g_varchar2) or
353: nvl(pqp_val_shd.g_old_rec.val_attribute9, hr_api.g_varchar2) <>
354: nvl(p_rec.val_attribute9, hr_api.g_varchar2) or
355: nvl(pqp_val_shd.g_old_rec.val_attribute10, hr_api.g_varchar2) <>

Line 353: nvl(pqp_val_shd.g_old_rec.val_attribute9, hr_api.g_varchar2) <>

349: nvl(pqp_val_shd.g_old_rec.val_attribute7, hr_api.g_varchar2) <>
350: nvl(p_rec.val_attribute7, hr_api.g_varchar2) or
351: nvl(pqp_val_shd.g_old_rec.val_attribute8, hr_api.g_varchar2) <>
352: nvl(p_rec.val_attribute8, hr_api.g_varchar2) or
353: nvl(pqp_val_shd.g_old_rec.val_attribute9, hr_api.g_varchar2) <>
354: nvl(p_rec.val_attribute9, hr_api.g_varchar2) or
355: nvl(pqp_val_shd.g_old_rec.val_attribute10, hr_api.g_varchar2) <>
356: nvl(p_rec.val_attribute10, hr_api.g_varchar2) or
357: nvl(pqp_val_shd.g_old_rec.val_attribute11, hr_api.g_varchar2) <>

Line 355: nvl(pqp_val_shd.g_old_rec.val_attribute10, hr_api.g_varchar2) <>

351: nvl(pqp_val_shd.g_old_rec.val_attribute8, hr_api.g_varchar2) <>
352: nvl(p_rec.val_attribute8, hr_api.g_varchar2) or
353: nvl(pqp_val_shd.g_old_rec.val_attribute9, hr_api.g_varchar2) <>
354: nvl(p_rec.val_attribute9, hr_api.g_varchar2) or
355: nvl(pqp_val_shd.g_old_rec.val_attribute10, hr_api.g_varchar2) <>
356: nvl(p_rec.val_attribute10, hr_api.g_varchar2) or
357: nvl(pqp_val_shd.g_old_rec.val_attribute11, hr_api.g_varchar2) <>
358: nvl(p_rec.val_attribute11, hr_api.g_varchar2) or
359: nvl(pqp_val_shd.g_old_rec.val_attribute12, hr_api.g_varchar2) <>

Line 357: nvl(pqp_val_shd.g_old_rec.val_attribute11, hr_api.g_varchar2) <>

353: nvl(pqp_val_shd.g_old_rec.val_attribute9, hr_api.g_varchar2) <>
354: nvl(p_rec.val_attribute9, hr_api.g_varchar2) or
355: nvl(pqp_val_shd.g_old_rec.val_attribute10, hr_api.g_varchar2) <>
356: nvl(p_rec.val_attribute10, hr_api.g_varchar2) or
357: nvl(pqp_val_shd.g_old_rec.val_attribute11, hr_api.g_varchar2) <>
358: nvl(p_rec.val_attribute11, hr_api.g_varchar2) or
359: nvl(pqp_val_shd.g_old_rec.val_attribute12, hr_api.g_varchar2) <>
360: nvl(p_rec.val_attribute12, hr_api.g_varchar2) or
361: nvl(pqp_val_shd.g_old_rec.val_attribute13, hr_api.g_varchar2) <>

Line 359: nvl(pqp_val_shd.g_old_rec.val_attribute12, hr_api.g_varchar2) <>

355: nvl(pqp_val_shd.g_old_rec.val_attribute10, hr_api.g_varchar2) <>
356: nvl(p_rec.val_attribute10, hr_api.g_varchar2) or
357: nvl(pqp_val_shd.g_old_rec.val_attribute11, hr_api.g_varchar2) <>
358: nvl(p_rec.val_attribute11, hr_api.g_varchar2) or
359: nvl(pqp_val_shd.g_old_rec.val_attribute12, hr_api.g_varchar2) <>
360: nvl(p_rec.val_attribute12, hr_api.g_varchar2) or
361: nvl(pqp_val_shd.g_old_rec.val_attribute13, hr_api.g_varchar2) <>
362: nvl(p_rec.val_attribute13, hr_api.g_varchar2) or
363: nvl(pqp_val_shd.g_old_rec.val_attribute14, hr_api.g_varchar2) <>

Line 361: nvl(pqp_val_shd.g_old_rec.val_attribute13, hr_api.g_varchar2) <>

357: nvl(pqp_val_shd.g_old_rec.val_attribute11, hr_api.g_varchar2) <>
358: nvl(p_rec.val_attribute11, hr_api.g_varchar2) or
359: nvl(pqp_val_shd.g_old_rec.val_attribute12, hr_api.g_varchar2) <>
360: nvl(p_rec.val_attribute12, hr_api.g_varchar2) or
361: nvl(pqp_val_shd.g_old_rec.val_attribute13, hr_api.g_varchar2) <>
362: nvl(p_rec.val_attribute13, hr_api.g_varchar2) or
363: nvl(pqp_val_shd.g_old_rec.val_attribute14, hr_api.g_varchar2) <>
364: nvl(p_rec.val_attribute14, hr_api.g_varchar2) or
365: nvl(pqp_val_shd.g_old_rec.val_attribute15, hr_api.g_varchar2) <>

Line 363: nvl(pqp_val_shd.g_old_rec.val_attribute14, hr_api.g_varchar2) <>

359: nvl(pqp_val_shd.g_old_rec.val_attribute12, hr_api.g_varchar2) <>
360: nvl(p_rec.val_attribute12, hr_api.g_varchar2) or
361: nvl(pqp_val_shd.g_old_rec.val_attribute13, hr_api.g_varchar2) <>
362: nvl(p_rec.val_attribute13, hr_api.g_varchar2) or
363: nvl(pqp_val_shd.g_old_rec.val_attribute14, hr_api.g_varchar2) <>
364: nvl(p_rec.val_attribute14, hr_api.g_varchar2) or
365: nvl(pqp_val_shd.g_old_rec.val_attribute15, hr_api.g_varchar2) <>
366: nvl(p_rec.val_attribute15, hr_api.g_varchar2) or
367: nvl(pqp_val_shd.g_old_rec.val_attribute16, hr_api.g_varchar2) <>

Line 365: nvl(pqp_val_shd.g_old_rec.val_attribute15, hr_api.g_varchar2) <>

361: nvl(pqp_val_shd.g_old_rec.val_attribute13, hr_api.g_varchar2) <>
362: nvl(p_rec.val_attribute13, hr_api.g_varchar2) or
363: nvl(pqp_val_shd.g_old_rec.val_attribute14, hr_api.g_varchar2) <>
364: nvl(p_rec.val_attribute14, hr_api.g_varchar2) or
365: nvl(pqp_val_shd.g_old_rec.val_attribute15, hr_api.g_varchar2) <>
366: nvl(p_rec.val_attribute15, hr_api.g_varchar2) or
367: nvl(pqp_val_shd.g_old_rec.val_attribute16, hr_api.g_varchar2) <>
368: nvl(p_rec.val_attribute16, hr_api.g_varchar2) or
369: nvl(pqp_val_shd.g_old_rec.val_attribute17, hr_api.g_varchar2) <>

Line 367: nvl(pqp_val_shd.g_old_rec.val_attribute16, hr_api.g_varchar2) <>

363: nvl(pqp_val_shd.g_old_rec.val_attribute14, hr_api.g_varchar2) <>
364: nvl(p_rec.val_attribute14, hr_api.g_varchar2) or
365: nvl(pqp_val_shd.g_old_rec.val_attribute15, hr_api.g_varchar2) <>
366: nvl(p_rec.val_attribute15, hr_api.g_varchar2) or
367: nvl(pqp_val_shd.g_old_rec.val_attribute16, hr_api.g_varchar2) <>
368: nvl(p_rec.val_attribute16, hr_api.g_varchar2) or
369: nvl(pqp_val_shd.g_old_rec.val_attribute17, hr_api.g_varchar2) <>
370: nvl(p_rec.val_attribute17, hr_api.g_varchar2) or
371: nvl(pqp_val_shd.g_old_rec.val_attribute18, hr_api.g_varchar2) <>

Line 369: nvl(pqp_val_shd.g_old_rec.val_attribute17, hr_api.g_varchar2) <>

365: nvl(pqp_val_shd.g_old_rec.val_attribute15, hr_api.g_varchar2) <>
366: nvl(p_rec.val_attribute15, hr_api.g_varchar2) or
367: nvl(pqp_val_shd.g_old_rec.val_attribute16, hr_api.g_varchar2) <>
368: nvl(p_rec.val_attribute16, hr_api.g_varchar2) or
369: nvl(pqp_val_shd.g_old_rec.val_attribute17, hr_api.g_varchar2) <>
370: nvl(p_rec.val_attribute17, hr_api.g_varchar2) or
371: nvl(pqp_val_shd.g_old_rec.val_attribute18, hr_api.g_varchar2) <>
372: nvl(p_rec.val_attribute18, hr_api.g_varchar2) or
373: nvl(pqp_val_shd.g_old_rec.val_attribute19, hr_api.g_varchar2) <>

Line 371: nvl(pqp_val_shd.g_old_rec.val_attribute18, hr_api.g_varchar2) <>

367: nvl(pqp_val_shd.g_old_rec.val_attribute16, hr_api.g_varchar2) <>
368: nvl(p_rec.val_attribute16, hr_api.g_varchar2) or
369: nvl(pqp_val_shd.g_old_rec.val_attribute17, hr_api.g_varchar2) <>
370: nvl(p_rec.val_attribute17, hr_api.g_varchar2) or
371: nvl(pqp_val_shd.g_old_rec.val_attribute18, hr_api.g_varchar2) <>
372: nvl(p_rec.val_attribute18, hr_api.g_varchar2) or
373: nvl(pqp_val_shd.g_old_rec.val_attribute19, hr_api.g_varchar2) <>
374: nvl(p_rec.val_attribute19, hr_api.g_varchar2) or
375: nvl(pqp_val_shd.g_old_rec.val_attribute20, hr_api.g_varchar2) <>

Line 373: nvl(pqp_val_shd.g_old_rec.val_attribute19, hr_api.g_varchar2) <>

369: nvl(pqp_val_shd.g_old_rec.val_attribute17, hr_api.g_varchar2) <>
370: nvl(p_rec.val_attribute17, hr_api.g_varchar2) or
371: nvl(pqp_val_shd.g_old_rec.val_attribute18, hr_api.g_varchar2) <>
372: nvl(p_rec.val_attribute18, hr_api.g_varchar2) or
373: nvl(pqp_val_shd.g_old_rec.val_attribute19, hr_api.g_varchar2) <>
374: nvl(p_rec.val_attribute19, hr_api.g_varchar2) or
375: nvl(pqp_val_shd.g_old_rec.val_attribute20, hr_api.g_varchar2) <>
376: nvl(p_rec.val_attribute20, hr_api.g_varchar2) ))
377: or (p_rec.vehicle_allocation_id is null) then

Line 375: nvl(pqp_val_shd.g_old_rec.val_attribute20, hr_api.g_varchar2) <>

371: nvl(pqp_val_shd.g_old_rec.val_attribute18, hr_api.g_varchar2) <>
372: nvl(p_rec.val_attribute18, hr_api.g_varchar2) or
373: nvl(pqp_val_shd.g_old_rec.val_attribute19, hr_api.g_varchar2) <>
374: nvl(p_rec.val_attribute19, hr_api.g_varchar2) or
375: nvl(pqp_val_shd.g_old_rec.val_attribute20, hr_api.g_varchar2) <>
376: nvl(p_rec.val_attribute20, hr_api.g_varchar2) ))
377: or (p_rec.vehicle_allocation_id is null) then
378: --
379: -- Only execute the validation if absolutely necessary:

Line 463: ,p_rec in pqp_val_shd.g_rec_type

459: -- {End Of Comments}
460: -- ----------------------------------------------------------------------------
461: Procedure chk_non_updateable_args
462: (p_effective_date in date
463: ,p_rec in pqp_val_shd.g_rec_type
464: ) IS
465: --
466: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
467: --

Line 473: IF NOT pqp_val_shd.api_updating

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

Line 678: (p_rec IN pqp_val_shd.g_rec_type,

674: --Fuel Benefit:Check box available for only company vehicles and
675: --need to be validated in API.
676:
677: FUNCTION pqp_check_cmyveh_fuel_card
678: (p_rec IN pqp_val_shd.g_rec_type,
679: p_vehicle_ownership IN VARCHAR2,
680: p_effective_date IN DATE ,
681: p_message OUT NOCOPY VARCHAR2
682: ) RETURN VARCHAR2 IS

Line 716: ( p_rec IN pqp_val_shd.g_rec_type

712: --If the number is reached then a new vehicle can be associated only after
713: --one of the existing allocated vehicles is removed.
714: --The default value is null (no limit).
715: FUNCTION pqp_get_max_allowed_veh
716: ( p_rec IN pqp_val_shd.g_rec_type
717: ,p_vehicle_ownership IN VARCHAR2
718: ,p_effective_date IN DATE
719: ) RETURN NUMBER IS
720:

Line 810: ( p_rec IN pqp_val_shd.g_rec_type

806: --and also the vehicle must be checked if the vehicle can be shared or status
807: -- is inactive.
808: --
809: FUNCTION pqp_veh_eligibility_check
810: ( p_rec IN pqp_val_shd.g_rec_type
811: ,p_effective_date IN DATE
812: ,p_message OUT NOCOPY VARCHAR2
813: )RETURN NUMBER IS
814: --get the values for vehicleStatus and SharedVehicle

Line 839: p_rec in pqp_val_shd.g_rec_type

835: ------------------------------------------------------------------------------
836: -----------------------------------------------
837: -----------------------------------------------------------------------------
838: Procedure chk_vehicle_exst (
839: p_rec in pqp_val_shd.g_rec_type
840: ,p_effective_date in date
841: ,p_datetrack_mode in varchar2
842: ,p_validation_start_date in date
843: ,p_validation_end_date in date

Line 869: ( p_rec in pqp_val_shd.g_rec_type

865: ------------------------------------------------------------------------------
866: -----------------------------------------------
867: -----------------------------------------------------------------------------
868: Procedure chk_asg_exst
869: ( p_rec in pqp_val_shd.g_rec_type
870: ,p_effective_date in date
871: ,p_datetrack_mode in varchar2
872: ,p_validation_start_date in date
873: ,p_validation_end_date in date

Line 902: ( p_rec IN pqp_val_shd.g_rec_type

898: --Secondary:Any additional vehicle is recorded as a secondary vehicle.
899: --Multiple secondary cars can be allocated based on business rules.
900: --
901: FUNCTION pqp_check_veh_alloc_process
902: ( p_rec IN pqp_val_shd.g_rec_type
903: ,p_vehicle_ownership IN VARCHAR2
904: ,p_effective_date IN DATE
905: ,p_message OUT NOCOPY VARCHAR2
906: ) RETURN NUMBER IS

Line 958: (p_rec IN pqp_val_shd.g_rec_type

954: --
955: --There are any claims that spans across any date cannot be purged.
956: --
957: FUNCTION pqp_purge_veh_alloc
958: (p_rec IN pqp_val_shd.g_rec_type
959: ,p_effective_date IN DATE
960: ,p_message OUT NOCOPY VARCHAR2
961: ) RETURN NUMBER IS
962:

Line 1036: (p_rec IN pqp_val_shd.g_rec_type,

1032: --Default value will be 'No'.
1033:
1034:
1035: FUNCTION pqp_config_shared_veh
1036: (p_rec IN pqp_val_shd.g_rec_type,
1037: p_vehicle_ownership IN VARCHAR2 ,
1038: p_shared_vehicle IN VARCHAR2,
1039: p_effective_date IN DATE,
1040: p_legislation_code IN VARCHAR2,

Line 1116: (p_rec IN pqp_val_shd.g_rec_type

1112: --------------------------------------------------------------------------
1113: ------------------Check reg exist for alloc------------------------------
1114: -------------------------------------------------------------------------
1115: FUNCTION chk_reg_exist_for_alloc
1116: (p_rec IN pqp_val_shd.g_rec_type
1117: ,p_effective_date IN DATE
1118: ,p_message out NOCOPY VARCHAR2
1119: ) RETURN NUMBER IS
1120:

Line 1153: (p_rec IN pqp_val_shd.g_rec_type

1149: --
1150: --There are no pending claims that spans across this date
1151: --
1152: FUNCTION pqp_enddate_veh_alloc
1153: (p_rec IN pqp_val_shd.g_rec_type
1154: ,p_effective_date IN DATE
1155: ,p_message OUT NOCOPY VARCHAR2
1156: ) RETURN NUMBER IS
1157: --Get the claim count for future and current date tracks

Line 1219: ( p_rec IN pqp_val_shd.g_rec_type

1215: --Default Vehicle:Checking only one default private vehicle is allocated at
1216: --any point of time to that assignment
1217: --
1218: FUNCTION chk_defult_private_veh
1219: ( p_rec IN pqp_val_shd.g_rec_type
1220: ,p_vehicle_ownership IN VARCHAR2
1221: ,p_effective_date IN DATE
1222: ,p_message OUT NOCOPY VARCHAR2
1223: ) RETURN NUMBER IS

Line 1371: (p_rec in pqp_val_shd.g_rec_type

1367: -- ----------------------------------------------------------------------------
1368: -- |---------------------------< insert_validate >----------------------------|
1369: -- ----------------------------------------------------------------------------
1370: Procedure insert_validate
1371: (p_rec in pqp_val_shd.g_rec_type
1372: ,p_effective_date in date
1373: ,p_datetrack_mode in varchar2
1374: ,p_validation_start_date in date
1375: ,p_validation_end_date in date

Line 1415: ,p_associated_column1 => pqp_val_shd.g_tab_nam

1411: -- Call all supporting business operations
1412: --
1413: hr_api.validate_bus_grp_id
1414: (p_business_group_id => p_rec.business_group_id
1415: ,p_associated_column1 => pqp_val_shd.g_tab_nam
1416: || '.BUSINESS_GROUP_ID');
1417:
1418: --Used to get the ownership for repId at once
1419: OPEN c_veh_det_cursor;

Line 1702: (p_rec in pqp_val_shd.g_rec_type

1698: -- ----------------------------------------------------------------------------
1699: -- |---------------------------< update_validate >----------------------------|
1700: -- ----------------------------------------------------------------------------
1701: Procedure update_validate
1702: (p_rec in pqp_val_shd.g_rec_type
1703: ,p_effective_date in date
1704: ,p_datetrack_mode in varchar2
1705: ,p_validation_start_date in date
1706: ,p_validation_end_date in date

Line 1743: ,p_associated_column1 => pqp_val_shd.g_tab_nam

1739: -- Call all supporting business operations
1740: --
1741: hr_api.validate_bus_grp_id
1742: (p_business_group_id => p_rec.business_group_id
1743: ,p_associated_column1 => pqp_val_shd.g_tab_nam
1744: || '.BUSINESS_GROUP_ID');
1745: --
1746: -- After validating the set of important attributes,
1747: -- if Multiple Message detection is enabled and at least

Line 1788: IF pqp_val_shd.g_old_rec.vehicle_repository_id <>

1784: l_initial_registration,l_registration_number;
1785: CLOSE c_veh_det_cursor;
1786:
1787: --Used to get the ownership for repId at once
1788: IF pqp_val_shd.g_old_rec.vehicle_repository_id <>
1789: p_rec.vehicle_repository_id THEN
1790:
1791: IF l_vehicle_status = 'I' THEN
1792: l_message := 'Vehicle status is Inactive,so vehicle cannot update';

Line 1810: IF ( nvl(pqp_val_shd.g_old_rec.usage_type,hr_api.g_varchar2)

1806: END IF;
1807: END IF;
1808:
1809: --Checking for value change
1810: IF ( nvl(pqp_val_shd.g_old_rec.usage_type,hr_api.g_varchar2)
1811: <> nvl(p_rec.usage_type,hr_api.g_varchar2) ) THEN
1812:
1813: --Checking usage Type lookup validation
1814: --Usage type lookup type will vary based on ownership

Line 1846: IF ( nvl(pqp_val_shd.g_old_rec.calculation_method,hr_api.g_varchar2)

1842: END IF;
1843: END IF;
1844:
1845: --Checking for value change
1846: IF ( nvl(pqp_val_shd.g_old_rec.calculation_method,hr_api.g_varchar2)
1847: <> nvl(p_rec.calculation_method,hr_api.g_varchar2) ) THEN
1848: --Checking calculation method lookup validation
1849: l_return_status := chk_lookup(
1850: p_vehicle_allocation_id => p_rec.vehicle_allocation_id

Line 1865: IF pqp_val_shd.g_old_rec.usage_type <> p_rec.usage_type THEN

1861: END IF;
1862:
1863:
1864: --checking only if there is change in UsageType for update
1865: IF pqp_val_shd.g_old_rec.usage_type <> p_rec.usage_type THEN
1866:
1867: --If usage type is 'PRIMARY' then check is there any
1868: --Private vehicles for this assignment
1869: IF p_rec.usage_type = 'P' THEN

Line 1888: IF pqp_val_shd.g_old_rec.default_vehicle = 'N' THEN

1884:
1885:
1886:
1887:
1888: IF pqp_val_shd.g_old_rec.default_vehicle = 'N' THEN
1889:
1890: IF p_rec.default_vehicle = 'Y' THEN
1891:
1892: --Checking default private Vehicle already exist or not

Line 1930: (p_rec in pqp_val_shd.g_rec_type

1926: -- ----------------------------------------------------------------------------
1927: -- |---------------------------< delete_validate >----------------------------|
1928: -- ----------------------------------------------------------------------------
1929: Procedure delete_validate
1930: (p_rec in pqp_val_shd.g_rec_type
1931: ,p_effective_date in date
1932: ,p_datetrack_mode in varchar2
1933: ,p_validation_start_date in date
1934: ,p_validation_end_date in date