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.PAY_PAY_BUS dependencies on PAY_PAY_SHD

Line 196: (p_rec in pay_pay_shd.g_rec_type

192: --
193: -- ----------------------------------------------------------------------------
194: --
195: procedure chk_ddf
196: (p_rec in pay_pay_shd.g_rec_type
197: ) is
198: --
199: l_proc varchar2(72) := g_package || 'chk_ddf';
200: --

Line 205: nvl(pay_pay_shd.g_old_rec.prl_information_category, hr_api.g_varchar2) <>

201: begin
202: hr_utility.set_location('Entering:'||l_proc,10);
203: --
204: if ((p_rec.payroll_id is not null) and (
205: nvl(pay_pay_shd.g_old_rec.prl_information_category, hr_api.g_varchar2) <>
206: nvl(p_rec.prl_information_category, hr_api.g_varchar2) or
207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>

Line 207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>

203: --
204: if ((p_rec.payroll_id is not null) and (
205: nvl(pay_pay_shd.g_old_rec.prl_information_category, hr_api.g_varchar2) <>
206: nvl(p_rec.prl_information_category, hr_api.g_varchar2) or
207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>

Line 209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>

205: nvl(pay_pay_shd.g_old_rec.prl_information_category, hr_api.g_varchar2) <>
206: nvl(p_rec.prl_information_category, hr_api.g_varchar2) or
207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>

Line 211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>

207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>

Line 213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>

209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>

Line 215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>

211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>

Line 217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>

213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>

Line 219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>

215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>

Line 221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>

217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>

Line 223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>

219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>

Line 225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>

221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>

Line 227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>

223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>

Line 229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>

225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>

Line 231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>

227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>

Line 233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>

229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>

Line 235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>

231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>

Line 237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>

233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>

Line 239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>

235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>

Line 241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>

237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>

Line 243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>

239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>

Line 245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>

241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>

Line 247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>

243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>

Line 249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>

245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>

Line 251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>

247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>

Line 253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>

249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>

Line 255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>

251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>

Line 257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>

253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>

Line 259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>

255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>

Line 261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>

257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>
264: nvl(p_rec.prl_information29, hr_api.g_varchar2) or
265: nvl(pay_pay_shd.g_old_rec.prl_information30, hr_api.g_varchar2) <>

Line 263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>

259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>
264: nvl(p_rec.prl_information29, hr_api.g_varchar2) or
265: nvl(pay_pay_shd.g_old_rec.prl_information30, hr_api.g_varchar2) <>
266: nvl(p_rec.prl_information30, hr_api.g_varchar2) ))
267: or (p_rec.payroll_id is null) then

Line 265: nvl(pay_pay_shd.g_old_rec.prl_information30, hr_api.g_varchar2) <>

261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>
264: nvl(p_rec.prl_information29, hr_api.g_varchar2) or
265: nvl(pay_pay_shd.g_old_rec.prl_information30, hr_api.g_varchar2) <>
266: nvl(p_rec.prl_information30, hr_api.g_varchar2) ))
267: or (p_rec.payroll_id is null) then
268: --
269: -- Only execute the validation if absolutely necessary:

Line 374: (p_rec in pay_pay_shd.g_rec_type

370: -- Internal Row Handler Use Only.
371: --
372: -- ----------------------------------------------------------------------------
373: procedure chk_df
374: (p_rec in pay_pay_shd.g_rec_type
375: ) is
376: --
377: l_proc varchar2(72) := g_package || 'chk_df';
378: --

Line 383: nvl(pay_pay_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

379: begin
380: hr_utility.set_location('Entering:'||l_proc,10);
381: --
382: if ((p_rec.payroll_id is not null) and (
383: nvl(pay_pay_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

381: --
382: if ((p_rec.payroll_id is not null) and (
383: nvl(pay_pay_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

383: nvl(pay_pay_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
423: nvl(pay_pay_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
423: nvl(pay_pay_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
424: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
425: or (p_rec.payroll_id is null) then

Line 423: nvl(pay_pay_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
423: nvl(pay_pay_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
424: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
425: or (p_rec.payroll_id is null) then
426: --
427: -- Only execute the validation if absolutely necessary:

Line 513: ,p_rec in out nocopy pay_pay_shd.g_rec_type

509: -- {End Of Comments}
510: -- ----------------------------------------------------------------------------
511: Procedure chk_non_updateable_args
512: (p_effective_date in date
513: ,p_rec in out nocopy pay_pay_shd.g_rec_type
514: ) IS
515: --
516: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
517: --

Line 523: IF NOT pay_pay_shd.api_updating

519: --
520: -- Only proceed with the validation if a row exists for the current
521: -- record in the HR Schema.
522: --
523: IF NOT pay_pay_shd.api_updating
524: (p_payroll_id => p_rec.payroll_id
525: ,p_effective_date => p_effective_date
526: ,p_object_version_number => p_rec.object_version_number
527: ) THEN

Line 535: nvl(pay_pay_shd.g_old_rec.gl_set_of_books_id, hr_api.g_number) then

531: fnd_message.raise_error;
532: END IF;
533:
534: if nvl(p_rec.gl_set_of_books_id, hr_api.g_number) <>
535: nvl(pay_pay_shd.g_old_rec.gl_set_of_books_id, hr_api.g_number) then
536: --
537: hr_api.argument_changed_error
538: (p_api_name => l_proc
539: ,p_argument => 'GL_SET_OF_BOOKS_ID'

Line 540: ,p_base_table => pay_pay_shd.g_tab_nam

536: --
537: hr_api.argument_changed_error
538: (p_api_name => l_proc
539: ,p_argument => 'GL_SET_OF_BOOKS_ID'
540: ,p_base_table => pay_pay_shd.g_tab_nam
541: );
542: --
543: end if;
544:

Line 546: nvl(pay_pay_shd.g_old_rec.period_type, hr_api.g_varchar2) then

542: --
543: end if;
544:
545: if nvl(p_rec.period_type, hr_api.g_varchar2) <>
546: nvl(pay_pay_shd.g_old_rec.period_type, hr_api.g_varchar2) then
547: --
548: hr_api.argument_changed_error
549: (p_api_name => l_proc
550: ,p_argument => 'PERIOD_TYPE'

Line 551: ,p_base_table => pay_pay_shd.g_tab_nam

547: --
548: hr_api.argument_changed_error
549: (p_api_name => l_proc
550: ,p_argument => 'PERIOD_TYPE'
551: ,p_base_table => pay_pay_shd.g_tab_nam
552: );
553: --
554: end if;
555:

Line 557: nvl(pay_pay_shd.g_old_rec.organization_id, hr_api.g_number) then

553: --
554: end if;
555:
556: if nvl(p_rec.organization_id, hr_api.g_number) <>
557: nvl(pay_pay_shd.g_old_rec.organization_id, hr_api.g_number) then
558: --
559: hr_api.argument_changed_error
560: (p_api_name => l_proc
561: ,p_argument => 'ORGANIZATION_ID'

Line 562: ,p_base_table => pay_pay_shd.g_tab_nam

558: --
559: hr_api.argument_changed_error
560: (p_api_name => l_proc
561: ,p_argument => 'ORGANIZATION_ID'
562: ,p_base_table => pay_pay_shd.g_tab_nam
563: );
564: --
565: end if;
566:

Line 568: nvl(pay_pay_shd.g_old_rec.cut_off_date_offset, hr_api.g_number) then

564: --
565: end if;
566:
567: if nvl(p_rec.cut_off_date_offset , hr_api.g_number) <>
568: nvl(pay_pay_shd.g_old_rec.cut_off_date_offset, hr_api.g_number) then
569: --
570: hr_api.argument_changed_error
571: (p_api_name => l_proc
572: ,p_argument => 'CUT_OFF_DATE_OFFSET'

Line 573: ,p_base_table => pay_pay_shd.g_tab_nam

569: --
570: hr_api.argument_changed_error
571: (p_api_name => l_proc
572: ,p_argument => 'CUT_OFF_DATE_OFFSET'
573: ,p_base_table => pay_pay_shd.g_tab_nam
574: );
575: --
576: end if;
577:

Line 579: nvl(pay_pay_shd.g_old_rec.direct_deposit_date_offset, hr_api.g_number) then

575: --
576: end if;
577:
578: if nvl(p_rec.direct_deposit_date_offset , hr_api.g_number) <>
579: nvl(pay_pay_shd.g_old_rec.direct_deposit_date_offset, hr_api.g_number) then
580: --
581: hr_api.argument_changed_error
582: (p_api_name => l_proc
583: ,p_argument => 'DIRECT_DEPOSIT_DATE_OFFSET'

Line 584: ,p_base_table => pay_pay_shd.g_tab_nam

580: --
581: hr_api.argument_changed_error
582: (p_api_name => l_proc
583: ,p_argument => 'DIRECT_DEPOSIT_DATE_OFFSET'
584: ,p_base_table => pay_pay_shd.g_tab_nam
585: );
586: --
587: end if;
588:

Line 590: nvl(pay_pay_shd.g_old_rec.first_period_end_date, hr_api.g_date) then

586: --
587: end if;
588:
589: if nvl(p_rec.first_period_end_date , hr_api.g_date) <>
590: nvl(pay_pay_shd.g_old_rec.first_period_end_date, hr_api.g_date) then
591: --
592: hr_api.argument_changed_error
593: (p_api_name => l_proc
594: ,p_argument => 'FIRST_PERIOD_END_DATE'

Line 595: ,p_base_table => pay_pay_shd.g_tab_nam

591: --
592: hr_api.argument_changed_error
593: (p_api_name => l_proc
594: ,p_argument => 'FIRST_PERIOD_END_DATE'
595: ,p_base_table => pay_pay_shd.g_tab_nam
596: );
597: --
598: end if;
599:

Line 601: nvl(pay_pay_shd.g_old_rec.pay_advice_date_offset, hr_api.g_number) then

597: --
598: end if;
599:
600: if nvl(p_rec.pay_advice_date_offset , hr_api.g_number) <>
601: nvl(pay_pay_shd.g_old_rec.pay_advice_date_offset, hr_api.g_number) then
602: --
603: hr_api.argument_changed_error
604: (p_api_name => l_proc
605: ,p_argument => 'PAY_ADVICE_DATE_OFFSET'

Line 606: ,p_base_table => pay_pay_shd.g_tab_nam

602: --
603: hr_api.argument_changed_error
604: (p_api_name => l_proc
605: ,p_argument => 'PAY_ADVICE_DATE_OFFSET'
606: ,p_base_table => pay_pay_shd.g_tab_nam
607: );
608: --
609: end if;
610:

Line 612: nvl(pay_pay_shd.g_old_rec.pay_date_offset, hr_api.g_number) then

608: --
609: end if;
610:
611: if nvl(p_rec.pay_date_offset , hr_api.g_number) <>
612: nvl(pay_pay_shd.g_old_rec.pay_date_offset, hr_api.g_number) then
613: --
614: hr_api.argument_changed_error
615: (p_api_name => l_proc
616: ,p_argument => 'PAY_DATE_OFFSET'

Line 617: ,p_base_table => pay_pay_shd.g_tab_nam

613: --
614: hr_api.argument_changed_error
615: (p_api_name => l_proc
616: ,p_argument => 'PAY_DATE_OFFSET'
617: ,p_base_table => pay_pay_shd.g_tab_nam
618: );
619: --
620: end if;
621:

Line 623: nvl(pay_pay_shd.g_old_rec.midpoint_offset, hr_api.g_number) then

619: --
620: end if;
621:
622: if nvl(p_rec.midpoint_offset , hr_api.g_number) <>
623: nvl(pay_pay_shd.g_old_rec.midpoint_offset, hr_api.g_number) then
624: --
625: hr_api.argument_changed_error
626: (p_api_name => l_proc
627: ,p_argument => 'MIDPOINT_OFFSET'

Line 628: ,p_base_table => pay_pay_shd.g_tab_nam

624: --
625: hr_api.argument_changed_error
626: (p_api_name => l_proc
627: ,p_argument => 'MIDPOINT_OFFSET'
628: ,p_base_table => pay_pay_shd.g_tab_nam
629: );
630: --
631: end if;
632:

Line 634: nvl(pay_pay_shd.g_old_rec.payroll_type, hr_api.g_varchar2) then

630: --
631: end if;
632:
633: if nvl(p_rec.payroll_type , hr_api.g_varchar2) <>
634: nvl(pay_pay_shd.g_old_rec.payroll_type, hr_api.g_varchar2) then
635: --
636: hr_api.argument_changed_error
637: (p_api_name => l_proc
638: ,p_argument => 'PAYROLL_TYPE'

Line 639: ,p_base_table => pay_pay_shd.g_tab_nam

635: --
636: hr_api.argument_changed_error
637: (p_api_name => l_proc
638: ,p_argument => 'PAYROLL_TYPE'
639: ,p_base_table => pay_pay_shd.g_tab_nam
640: );
641: --
642: end if;
643:

Line 645: nvl(pay_pay_shd.g_old_rec.period_reset_years, hr_api.g_varchar2) then

641: --
642: end if;
643:
644: if nvl(p_rec.period_reset_years, hr_api.g_varchar2) <>
645: nvl(pay_pay_shd.g_old_rec.period_reset_years, hr_api.g_varchar2) then
646: --
647: hr_api.argument_changed_error
648: (p_api_name => l_proc
649: ,p_argument => 'PERIOD_RESET_YEARS'

Line 650: ,p_base_table => pay_pay_shd.g_tab_nam

646: --
647: hr_api.argument_changed_error
648: (p_api_name => l_proc
649: ,p_argument => 'PERIOD_RESET_YEARS'
650: ,p_base_table => pay_pay_shd.g_tab_nam
651: );
652: --
653: end if;
654: --

Line 731: (p_associated_column1 => pay_pay_shd.g_tab_nam || '.ORG_PAYMENT_METHOD_ID');

727: ,p_to_date => p_validation_end_date))) Then
728: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
729: fnd_message.set_token('TABLE_NAME','org payment methods');
730: hr_multi_message.add
731: (p_associated_column1 => pay_pay_shd.g_tab_nam || '.ORG_PAYMENT_METHOD_ID');
732: --
733: End If;
734: --
735:

Line 1597: nvl(pay_pay_shd.g_old_rec.COST_ALLOCATION_KEYFLEX_ID, hr_api.g_number)))

1593: if (p_datetrack_mode = hr_api.g_insert and
1594: p_cost_allocation_keyflex_id is not null)
1595: or ((p_datetrack_mode <> hr_api.g_insert) and
1596: (p_cost_allocation_keyflex_id <>
1597: nvl(pay_pay_shd.g_old_rec.COST_ALLOCATION_KEYFLEX_ID, hr_api.g_number)))
1598: then
1599: --
1600: open csr_chk_keyflexs (p_cost_allocation_keyflex_id);
1601: fetch csr_chk_keyflexs into g_exists;

Line 1619: nvl(pay_pay_shd.g_old_rec.suspense_account_keyflex_id, hr_api.g_number)))

1615: if (p_datetrack_mode = hr_api.g_insert and
1616: p_suspense_account_keyflex_id is not null)
1617: or ((p_datetrack_mode <> hr_api.g_insert) and
1618: (p_suspense_account_keyflex_id <>
1619: nvl(pay_pay_shd.g_old_rec.suspense_account_keyflex_id, hr_api.g_number)))
1620: then
1621: --
1622: open csr_chk_keyflexs (p_suspense_account_keyflex_id);
1623: fetch csr_chk_keyflexs into g_exists;

Line 1641: nvl(pay_pay_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number)))

1637: if (p_datetrack_mode = hr_api.g_insert and
1638: p_soft_coding_keyflex_id is not null)
1639: or ((p_datetrack_mode <> hr_api.g_insert) and
1640: (p_soft_coding_keyflex_id <>
1641: nvl(pay_pay_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number)))
1642: then
1643: --
1644: open csr_chk_soft_coding_kff;
1645: fetch csr_chk_soft_coding_kff into g_exists;

Line 1704: (p_rec in out nocopy pay_pay_shd.g_rec_type

1700: -- ----------------------------------------------------------------------------
1701: -- |---------------------------< insert_validate >----------------------------|
1702: -- ----------------------------------------------------------------------------
1703: Procedure insert_validate
1704: (p_rec in out nocopy pay_pay_shd.g_rec_type
1705: ,p_effective_date in date
1706: ,p_datetrack_mode in varchar2
1707: ,p_validation_start_date in date
1708: ,p_validation_end_date in date

Line 1731: ,p_associated_column1 => pay_pay_shd.g_tab_nam

1727: p_rec.business_group_id := l_business_group_id;
1728:
1729: hr_api.validate_bus_grp_id
1730: (p_business_group_id => p_rec.business_group_id
1731: ,p_associated_column1 => pay_pay_shd.g_tab_nam
1732: || '.BUSINESS_GROUP_ID');
1733: --
1734: -- After validating the set of important attributes,
1735: -- if Multiple Message detection is enabled and at least

Line 1854: (p_rec in out nocopy pay_pay_shd.g_rec_type

1850: -- ----------------------------------------------------------------------------
1851: -- |---------------------------< update_validate >----------------------------|
1852: -- ----------------------------------------------------------------------------
1853: Procedure update_validate
1854: (p_rec in out nocopy pay_pay_shd.g_rec_type
1855: ,p_effective_date in date
1856: ,p_datetrack_mode in varchar2
1857: ,p_validation_start_date in date
1858: ,p_validation_end_date in date

Line 1874: ,p_associated_column1 => pay_pay_shd.g_tab_nam

1870: -- Call all supporting business operations
1871: --
1872: hr_api.validate_bus_grp_id
1873: (p_business_group_id => p_rec.business_group_id
1874: ,p_associated_column1 => pay_pay_shd.g_tab_nam
1875: || '.BUSINESS_GROUP_ID');
1876:
1877: hr_multi_message.end_validation_set;
1878: --

Line 1880: nvl(pay_pay_shd.g_old_rec.default_payment_method_id, hr_api.g_number) then

1876:
1877: hr_multi_message.end_validation_set;
1878: --
1879: if p_rec.default_payment_method_id <>
1880: nvl(pay_pay_shd.g_old_rec.default_payment_method_id, hr_api.g_number) then
1881: pay_pay_bus.chk_default_payment_method_id
1882: (p_effective_date => p_effective_date
1883: ,p_business_group_id => p_rec.business_group_id
1884: ,p_default_payment_method_id => p_rec.default_payment_method_id

Line 1889: nvl(pay_pay_shd.g_old_rec.consolidation_set_id, hr_api.g_number) then

1885: );
1886: end if;
1887: --
1888: if p_rec.consolidation_set_id <>
1889: nvl(pay_pay_shd.g_old_rec.consolidation_set_id, hr_api.g_number) then
1890: --
1891: pay_pay_bus.chk_consolidation_set_id( p_rec.consolidation_set_id,
1892: l_business_group_id );
1893: if (l_business_group_id <> p_rec.business_group_id) then

Line 1904: nvl(pay_pay_shd.g_old_rec.negative_pay_allowed_flag, hr_api.g_varchar2) then

1900: End if;
1901: --
1902: --
1903: if p_rec.negative_pay_allowed_flag <>
1904: nvl(pay_pay_shd.g_old_rec.negative_pay_allowed_flag, hr_api.g_varchar2) then
1905: --
1906: pay_pay_bus.chk_negative_pay_allowed_flag
1907: (p_effective_date => p_effective_date
1908: ,p_negative_pay_allowed_flag => p_rec.negative_pay_allowed_flag

Line 1913: if p_rec.number_of_years <> pay_pay_shd.g_old_rec.number_of_years then

1909: );
1910: --
1911: end if;
1912: --
1913: if p_rec.number_of_years <> pay_pay_shd.g_old_rec.number_of_years then
1914: --
1915: pay_pay_bus.chk_number_of_years
1916: (p_effective_date => p_effective_date
1917: ,p_number_of_years => p_rec.number_of_years

Line 1923: if p_rec.payroll_name <> pay_pay_shd.g_old_rec.payroll_name then

1919: );
1920: --
1921: end if;
1922: --
1923: if p_rec.payroll_name <> pay_pay_shd.g_old_rec.payroll_name then
1924: --
1925: pay_pay_bus.chk_payroll_name
1926: (p_payroll_name => p_rec.payroll_name
1927: ,p_business_group_id => p_rec.business_group_id

Line 1943: if p_rec.arrears_flag <> nvl(pay_pay_shd.g_old_rec.arrears_flag, hr_api.g_varchar2) then

1939: ,p_pay_date_rule => l_dummy
1940: ,p_arrears_flag_rule => l_arrears_flag_rule
1941: );
1942: --
1943: if p_rec.arrears_flag <> nvl(pay_pay_shd.g_old_rec.arrears_flag, hr_api.g_varchar2) then
1944: --
1945: pay_pay_bus.chk_arrears_flag
1946: (p_effective_date => p_effective_date
1947: ,p_arrears_flag => p_rec.arrears_flag

Line 1954: nvl(pay_pay_shd.g_old_rec.multi_assignments_flag, hr_api.g_varchar2) then

1950: --
1951: end if;
1952: --
1953: if p_rec.multi_assignments_flag <>
1954: nvl(pay_pay_shd.g_old_rec.multi_assignments_flag, hr_api.g_varchar2) then
1955: --
1956: pay_pay_bus.chk_multi_assignments_flag
1957: (p_effective_date => p_effective_date
1958: ,p_multi_assignments_flag => p_rec.multi_assignments_flag

Line 2011: (p_rec in pay_pay_shd.g_rec_type

2007: -- ----------------------------------------------------------------------------
2008: -- |---------------------------< delete_validate >----------------------------|
2009: -- ----------------------------------------------------------------------------
2010: Procedure delete_validate
2011: (p_rec in pay_pay_shd.g_rec_type
2012: ,p_effective_date in date
2013: ,p_datetrack_mode in varchar2
2014: ,p_validation_start_date in date
2015: ,p_validation_end_date in date

Line 2036: ,p_default_payment_method_id => pay_pay_shd.g_old_rec.default_payment_method_id

2032: --Added to check for the other validations.
2033: --
2034: pay_payrolls_f_pkg.validate_delete_payroll
2035: ( p_payroll_id => p_rec.payroll_id
2036: ,p_default_payment_method_id => pay_pay_shd.g_old_rec.default_payment_method_id
2037: ,p_dt_delete_mode => p_datetrack_mode
2038: ,p_validation_start_date => p_validation_start_date
2039: ,p_validation_end_date => p_validation_end_date
2040: );