APPS.PER_PAC_BUS dependencies on PER_PAC_SHD

Line 207: l_api_updating := per_pac_shd.api_updating

203: -- a) The current g_old_rec is current and
204: -- b) The checklist name value has changed
205: -- c) a record is being inserted
206: --
207: l_api_updating := per_pac_shd.api_updating
208: (p_allocated_checklist_id => p_allocated_checklist_id
209: ,p_object_version_number => p_object_version_number
210: );
211:

Line 213: AND NVL(per_pac_shd.g_old_rec.checklist_name, hr_api.g_varchar2) = nvl(p_checklist_name,hr_api.g_varchar2)

209: ,p_object_version_number => p_object_version_number
210: );
211:
212: IF (l_api_updating
213: AND NVL(per_pac_shd.g_old_rec.checklist_name, hr_api.g_varchar2) = nvl(p_checklist_name,hr_api.g_varchar2)
214: )
215: THEN
216: RETURN;
217: END IF;

Line 286: (p_rec in per_pac_shd.g_rec_type

282: -- Internal Row Handler Use Only.
283: --
284: -- ----------------------------------------------------------------------------
285: procedure chk_ddf
286: (p_rec in per_pac_shd.g_rec_type
287: ) is
288: --
289: l_proc varchar2(72) := g_package || 'chk_ddf';
290: --

Line 296: nvl(per_pac_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

292: hr_utility.set_location('Entering:'||l_proc,10);
293: --
294: /*
295: if ((p_rec.allocated_checklist_id is not null) and (
296: nvl(per_pac_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
297: nvl(p_rec.information_category, hr_api.g_varchar2) or
298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>
299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>

294: /*
295: if ((p_rec.allocated_checklist_id is not null) and (
296: nvl(per_pac_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
297: nvl(p_rec.information_category, hr_api.g_varchar2) or
298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>
299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>

296: nvl(per_pac_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
297: nvl(p_rec.information_category, hr_api.g_varchar2) or
298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>
299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>

298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>
299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>

300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>

302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>

304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>

306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>

308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>

310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>

312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>

314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>

316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>

318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>

320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>

322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>

324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>

326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>

328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>
335: nvl(p_rec.information19, hr_api.g_varchar2) or
336: nvl(per_pac_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>

330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>
335: nvl(p_rec.information19, hr_api.g_varchar2) or
336: nvl(per_pac_shd.g_old_rec.information20, hr_api.g_varchar2) <>
337: nvl(p_rec.information20, hr_api.g_varchar2) ))
338: or (p_rec.allocated_checklist_id is null) then

Line 336: nvl(per_pac_shd.g_old_rec.information20, hr_api.g_varchar2) <>

332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>
335: nvl(p_rec.information19, hr_api.g_varchar2) or
336: nvl(per_pac_shd.g_old_rec.information20, hr_api.g_varchar2) <>
337: nvl(p_rec.information20, hr_api.g_varchar2) ))
338: or (p_rec.allocated_checklist_id is null) then
339: --
340: -- Only execute the validation if absolutely necessary:

Line 425: (p_rec in per_pac_shd.g_rec_type

421: -- Internal Row Handler Use Only.
422: --
423: -- ----------------------------------------------------------------------------
424: procedure chk_df
425: (p_rec in per_pac_shd.g_rec_type
426: ) is
427: --
428: l_proc varchar2(72) := g_package || 'chk_df';
429: --

Line 435: nvl(per_pac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

431: hr_utility.set_location('Entering:'||l_proc,10);
432: --
433: /*
434: if ((p_rec.allocated_checklist_id is not null) and (
435: nvl(per_pac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

433: /*
434: if ((p_rec.allocated_checklist_id is not null) and (
435: nvl(per_pac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

435: nvl(per_pac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute19, hr_api.g_varchar2) or
475: nvl(per_pac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute19, hr_api.g_varchar2) or
475: nvl(per_pac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
477: or (p_rec.allocated_checklist_id is null) then

Line 475: nvl(per_pac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute19, hr_api.g_varchar2) or
475: nvl(per_pac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
477: or (p_rec.allocated_checklist_id is null) then
478: --
479: -- Only execute the validation if absolutely necessary:

Line 564: ,p_rec in per_pac_shd.g_rec_type

560: -- {End Of Comments}
561: -- ----------------------------------------------------------------------------
562: Procedure chk_non_updateable_args
563: (p_effective_date in date
564: ,p_rec in per_pac_shd.g_rec_type
565: ) IS
566: --
567: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
568: --

Line 574: IF NOT per_pac_shd.api_updating

570: --
571: -- Only proceed with the validation if a row exists for the current
572: -- record in the HR Schema.
573: --
574: IF NOT per_pac_shd.api_updating
575: (p_allocated_checklist_id => p_rec.allocated_checklist_id
576: ,p_object_version_number => p_rec.object_version_number
577: ) THEN
578: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 595: ,p_rec in per_pac_shd.g_rec_type

591: -- |---------------------------< insert_validate >----------------------------|
592: -- ----------------------------------------------------------------------------
593: Procedure insert_validate
594: (p_effective_date in date
595: ,p_rec in per_pac_shd.g_rec_type
596: ) is
597: --
598: l_proc varchar2(72) := g_package||'insert_validate';
599: --

Line 627: ,p_rec in per_pac_shd.g_rec_type

623: -- |---------------------------< update_validate >----------------------------|
624: -- ----------------------------------------------------------------------------
625: Procedure update_validate
626: (p_effective_date in date
627: ,p_rec in per_pac_shd.g_rec_type
628: ) is
629: --
630: l_proc varchar2(72) := g_package||'update_validate';
631: --

Line 664: (p_rec in per_pac_shd.g_rec_type

660: -- ----------------------------------------------------------------------------
661: -- |---------------------------< delete_validate >----------------------------|
662: -- ----------------------------------------------------------------------------
663: Procedure delete_validate
664: (p_rec in per_pac_shd.g_rec_type
665: ) is
666: --
667: l_proc varchar2(72) := g_package||'delete_validate';
668: --