44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error
49: (p_api_name => l_proc
50: ,p_argument => 'checklist_id'
51: ,p_argument_value => p_checklist_id
52: );
71: close csr_sec_grp;
72: --
73: -- Set the security_group_id in CLIENT_INFO
74: --
75: hr_api.set_security_group_id
76: (p_security_group_id => l_security_group_id
77: );
78: --
79: -- Set the sessions legislation context in HR_SESSION_DATA
77: );
78: --
79: -- Set the sessions legislation context in HR_SESSION_DATA
80: --
81: hr_api.set_legislation_context(l_legislation_code);
82: end if;
83: --
84: hr_utility.set_location(' Leaving:'|| l_proc, 20);
85: --
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error
118: (p_api_name => l_proc
119: ,p_argument => 'checklist_id'
120: ,p_argument_value => p_checklist_id
121: );
119: ,p_argument => 'checklist_id'
120: ,p_argument_value => p_checklist_id
121: );
122: --
123: if ( nvl(per_ckl_bus.g_checklist_id, hr_api.g_number)
124: = p_checklist_id) then
125: --
126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global
199: ,p_object_version_number => p_object_version_number
200: );
201:
202: IF (l_api_updating
203: and nvl(per_ckl_shd.g_old_rec.name, hr_api.g_varchar2) = nvl(p_name,hr_api.g_varchar2)
204: )
205: THEN
206: RETURN;
207: END IF;
344: hr_utility.set_location('Entering:'|| l_proc, 1);
345: --
346: -- Check mandatory parameters have been set
347: --
348: hr_api.mandatory_arg_error
349: (p_api_name => l_proc
350: ,p_argument => 'effective_date'
351: ,p_argument_value => p_effective_date
352: );
360: -- b) The value for category has changed
361: --
362: if ((p_checklist_id is null) or
363: ((p_checklist_id is not null) and
364: (nvl(per_ckl_shd.g_old_rec.checklist_category,hr_api.g_varchar2) <> nvl(p_ckl_category,hr_api.g_varchar2)))) then
365: --
366: if hr_api.not_exists_in_leg_lookups
367: (p_effective_date => p_effective_date
368: ,p_lookup_type => 'CHECKLIST_CATEGORY'
362: if ((p_checklist_id is null) or
363: ((p_checklist_id is not null) and
364: (nvl(per_ckl_shd.g_old_rec.checklist_category,hr_api.g_varchar2) <> nvl(p_ckl_category,hr_api.g_varchar2)))) then
365: --
366: if hr_api.not_exists_in_leg_lookups
367: (p_effective_date => p_effective_date
368: ,p_lookup_type => 'CHECKLIST_CATEGORY'
369: ,p_lookup_code => p_ckl_category
370: )
427: begin
428: hr_utility.set_location('Entering:'||l_proc,10);
429: --
430: if ((p_rec.checklist_id is not null) and (
431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
428: hr_utility.set_location('Entering:'||l_proc,10);
429: --
430: if ((p_rec.checklist_id is not null) and (
431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
429: --
430: if ((p_rec.checklist_id is not null) and (
431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
430: if ((p_rec.checklist_id is not null) and (
431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))
473: or (p_rec.checklist_id is null) then
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))
473: or (p_rec.checklist_id is null) then
474: --
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))
473: or (p_rec.checklist_id is null) then
474: --
475: -- Only execute the validation if absolutely necessary:
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))
473: or (p_rec.checklist_id is null) then
474: --
475: -- Only execute the validation if absolutely necessary:
476: -- a) During update, the structure column value or any
564: begin
565: hr_utility.set_location('Entering:'||l_proc,10);
566: --
567: if ((p_rec.checklist_id is not null) and (
568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
565: hr_utility.set_location('Entering:'||l_proc,10);
566: --
567: if ((p_rec.checklist_id is not null) and (
568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
566: --
567: if ((p_rec.checklist_id is not null) and (
568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
567: if ((p_rec.checklist_id is not null) and (
568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
610: or (p_rec.checklist_id is null) then
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
610: or (p_rec.checklist_id is null) then
611: --
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
610: or (p_rec.checklist_id is null) then
611: --
612: -- Only execute the validation if absolutely necessary:
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
610: or (p_rec.checklist_id is null) then
611: --
612: -- Only execute the validation if absolutely necessary:
613: -- a) During update, the structure column value or any
732: hr_utility.set_location('Entering:'||l_proc, 5);
733: --
734: -- Call all supporting business operations
735: --
736: hr_api.validate_bus_grp_id
737: (p_business_group_id => p_rec.business_group_id
738: ,p_associated_column1 => per_ckl_shd.g_tab_nam
739: || '.BUSINESS_GROUP_ID');
740: --
788: hr_utility.set_location('Entering:'||l_proc, 5);
789: --
790: -- Call all supporting business operations
791: --
792: hr_api.validate_bus_grp_id
793: (p_business_group_id => p_rec.business_group_id
794: ,p_associated_column1 => per_ckl_shd.g_tab_nam
795: || '.BUSINESS_GROUP_ID');
796: --