APPS.PSP_ERA_BUS dependencies on PSP_ERA_SHD

Line 207: (p_rec in psp_era_shd.g_rec_type

203: -- Internal Row Handler Use Only.
204: --
205: -- ----------------------------------------------------------------------------
206: procedure chk_ddf
207: (p_rec in psp_era_shd.g_rec_type
208: ) is
209: --
210: l_proc varchar2(72) := g_package || 'chk_ddf';
211: --

Line 216: nvl(psp_era_shd.g_old_rec.pera_information_category, hr_api.g_varchar2) <>

212: begin
213: hr_utility.set_location('Entering:'||l_proc,10);
214: --
215: if ((p_rec.effort_report_approval_id is not null) and (
216: nvl(psp_era_shd.g_old_rec.pera_information_category, hr_api.g_varchar2) <>
217: nvl(p_rec.pera_information_category, hr_api.g_varchar2) or
218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>
219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>

Line 218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>

214: --
215: if ((p_rec.effort_report_approval_id is not null) and (
216: nvl(psp_era_shd.g_old_rec.pera_information_category, hr_api.g_varchar2) <>
217: nvl(p_rec.pera_information_category, hr_api.g_varchar2) or
218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>
219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>

Line 220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>

216: nvl(psp_era_shd.g_old_rec.pera_information_category, hr_api.g_varchar2) <>
217: nvl(p_rec.pera_information_category, hr_api.g_varchar2) or
218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>
219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>

Line 222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>

218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>
219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>

Line 224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>

220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>

Line 226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>

222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>

Line 228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>

224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>

Line 230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>

226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>

Line 232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>

228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>

Line 234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>

230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>

Line 236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>

232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>

Line 238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>

234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>

Line 240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>

236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>

Line 242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>

238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>

Line 244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>

240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>

Line 246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>

242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>

Line 248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>

244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>

Line 250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>

246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>

Line 252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>

248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>
255: nvl(p_rec.pera_information19, hr_api.g_varchar2) or
256: nvl(psp_era_shd.g_old_rec.pera_information20, hr_api.g_varchar2) <>

Line 254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>

250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>
255: nvl(p_rec.pera_information19, hr_api.g_varchar2) or
256: nvl(psp_era_shd.g_old_rec.pera_information20, hr_api.g_varchar2) <>
257: nvl(p_rec.pera_information20, hr_api.g_varchar2)))
258: or (p_rec.effort_report_approval_id is null) then

Line 256: nvl(psp_era_shd.g_old_rec.pera_information20, hr_api.g_varchar2) <>

252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>
255: nvl(p_rec.pera_information19, hr_api.g_varchar2) or
256: nvl(psp_era_shd.g_old_rec.pera_information20, hr_api.g_varchar2) <>
257: nvl(p_rec.pera_information20, hr_api.g_varchar2)))
258: or (p_rec.effort_report_approval_id is null) then
259: --
260: -- Only execute the validation if absolutely necessary:

Line 313: nvl(psp_era_shd.g_old_rec.eff_information_category, hr_api.g_varchar2) <>

309: );
310: end if;
311:
312: if ((p_rec.effort_report_approval_id is not null) and (
313: nvl(psp_era_shd.g_old_rec.eff_information_category, hr_api.g_varchar2) <>
314: nvl(p_rec.eff_information_category, hr_api.g_varchar2) or
315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>
316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>

Line 315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>

311:
312: if ((p_rec.effort_report_approval_id is not null) and (
313: nvl(psp_era_shd.g_old_rec.eff_information_category, hr_api.g_varchar2) <>
314: nvl(p_rec.eff_information_category, hr_api.g_varchar2) or
315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>
316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>

Line 317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>

313: nvl(psp_era_shd.g_old_rec.eff_information_category, hr_api.g_varchar2) <>
314: nvl(p_rec.eff_information_category, hr_api.g_varchar2) or
315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>
316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>

Line 319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>

315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>
316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>

Line 321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>

317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>

Line 323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>

319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>

Line 325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>

321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>

Line 327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>

323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>

Line 329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>

325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>

Line 331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>

327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>

Line 333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>

329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>

Line 335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>

331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>

Line 337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>

333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>

Line 339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>

335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>
342: nvl(p_rec.eff_information14, hr_api.g_varchar2) or
343: nvl(psp_era_shd.g_old_rec.eff_information15, hr_api.g_varchar2) <>

Line 341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>

337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>
342: nvl(p_rec.eff_information14, hr_api.g_varchar2) or
343: nvl(psp_era_shd.g_old_rec.eff_information15, hr_api.g_varchar2) <>
344: nvl(p_rec.eff_information15, hr_api.g_varchar2 )))
345: or (p_rec.effort_report_approval_id is null) then

Line 343: nvl(psp_era_shd.g_old_rec.eff_information15, hr_api.g_varchar2) <>

339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>
342: nvl(p_rec.eff_information14, hr_api.g_varchar2) or
343: nvl(psp_era_shd.g_old_rec.eff_information15, hr_api.g_varchar2) <>
344: nvl(p_rec.eff_information15, hr_api.g_varchar2 )))
345: or (p_rec.effort_report_approval_id is null) then
346: --
347: -- Only execute the validation if absolutely necessary:

Line 421: (p_rec in psp_era_shd.g_rec_type

417: --
418: -- {End Of Comments}
419: -- ----------------------------------------------------------------------------
420: Procedure chk_non_updateable_args
421: (p_rec in psp_era_shd.g_rec_type
422: ) IS
423: --
424: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
425: --

Line 431: IF NOT psp_era_shd.api_updating

427: --
428: -- Only proceed with the validation if a row exists for the current
429: -- record in the HR Schema.
430: --
431: IF NOT psp_era_shd.api_updating
432: (p_effort_report_approval_id => p_rec.effort_report_approval_id
433: ,p_object_version_number => p_rec.object_version_number
434: ) THEN
435: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 450: (p_rec in psp_era_shd.g_rec_type

446: -- ----------------------------------------------------------------------------
447: -- |---------------------------< insert_validate >----------------------------|
448: -- ----------------------------------------------------------------------------
449: Procedure insert_validate
450: (p_rec in psp_era_shd.g_rec_type
451: ) is
452: --
453: l_proc varchar2(72) := g_package||'insert_validate';
454: --

Line 480: (p_rec in psp_era_shd.g_rec_type

476: -- ----------------------------------------------------------------------------
477: -- |---------------------------< update_validate >----------------------------|
478: -- ----------------------------------------------------------------------------
479: Procedure update_validate
480: (p_rec in psp_era_shd.g_rec_type
481: ) is
482: --
483: l_proc varchar2(72) := g_package||'update_validate';
484: --

Line 514: (p_rec in psp_era_shd.g_rec_type

510: -- ----------------------------------------------------------------------------
511: -- |---------------------------< delete_validate >----------------------------|
512: -- ----------------------------------------------------------------------------
513: Procedure delete_validate
514: (p_rec in psp_era_shd.g_rec_type
515: ) is
516: --
517: l_proc varchar2(72) := g_package||'delete_validate';
518: --