48: hr_utility.set_location('Entering:'|| l_proc, 10);
49: --
50: -- Ensure that all the mandatory parameter are not null
51: --
52: hr_api.mandatory_arg_error
53: (p_api_name => l_proc
54: ,p_argument => 'allocated_checklist_id'
55: ,p_argument_value => p_allocated_checklist_id
56: );
75: close csr_sec_grp;
76: --
77: -- Set the security_group_id in CLIENT_INFO
78: --
79: hr_api.set_security_group_id
80: (p_security_group_id => l_security_group_id
81: );
82: --
83: -- Set the sessions legislation context in HR_SESSION_DATA
81: );
82: --
83: -- Set the sessions legislation context in HR_SESSION_DATA
84: --
85: hr_api.set_legislation_context(l_legislation_code);
86: end if;
87: --
88: hr_utility.set_location(' Leaving:'|| l_proc, 20);
89: --
123: hr_utility.set_location('Entering:'|| l_proc, 10);
124: --
125: -- Ensure that all the mandatory parameter are not null
126: --
127: hr_api.mandatory_arg_error
128: (p_api_name => l_proc
129: ,p_argument => 'allocated_checklist_id'
130: ,p_argument_value => p_allocated_checklist_id
131: );
129: ,p_argument => 'allocated_checklist_id'
130: ,p_argument_value => p_allocated_checklist_id
131: );
132: --
133: if ( nvl(per_pac_bus.g_allocated_checklist_id, hr_api.g_number)
134: = p_allocated_checklist_id) then
135: --
136: -- The legislation code has already been found with a previous
137: -- call to this function. Just return the value in the global
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;
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) <>
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) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
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) <>
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) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
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) <>
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) <>
305: nvl(p_rec.information4, 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) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, 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) <>
307: nvl(p_rec.information5, 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) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, 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) <>
309: nvl(p_rec.information6, 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) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, 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) <>
311: nvl(p_rec.information7, 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) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, 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) <>
313: nvl(p_rec.information8, 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) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, 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) <>
315: nvl(p_rec.information9, 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) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, 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) <>
317: nvl(p_rec.information10, 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) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, 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) <>
319: nvl(p_rec.information11, 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) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, 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) <>
321: nvl(p_rec.information12, 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) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, 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) <>
323: nvl(p_rec.information13, 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) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, 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) <>
325: nvl(p_rec.information14, 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) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, 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) <>
327: nvl(p_rec.information15, 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) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, 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) <>
329: nvl(p_rec.information16, 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) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, 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) <>
331: nvl(p_rec.information17, 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) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, 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) <>
333: nvl(p_rec.information18, 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) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, 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) <>
335: nvl(p_rec.information19, 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) <>
335: nvl(p_rec.information19, hr_api.g_varchar2) or
336: nvl(per_pac_shd.g_old_rec.information20, 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) <>
337: nvl(p_rec.information20, 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
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
339: --
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:
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:
341: -- a) During update, the structure column value or any
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) <>
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) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
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) <>
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) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
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) <>
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) <>
444: nvl(p_rec.attribute4, 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) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, 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) <>
446: nvl(p_rec.attribute5, 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) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, 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) <>
448: nvl(p_rec.attribute6, 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) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, 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) <>
450: nvl(p_rec.attribute7, 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) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, 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) <>
452: nvl(p_rec.attribute8, 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) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, 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) <>
454: nvl(p_rec.attribute9, 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) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, 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) <>
456: nvl(p_rec.attribute10, 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) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, 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) <>
458: nvl(p_rec.attribute11, 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) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, 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) <>
460: nvl(p_rec.attribute12, 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) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, 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) <>
462: nvl(p_rec.attribute13, 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) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, 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) <>
464: nvl(p_rec.attribute14, 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) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, 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) <>
466: nvl(p_rec.attribute15, 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) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, 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) <>
468: nvl(p_rec.attribute16, 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) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, 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) <>
470: nvl(p_rec.attribute17, 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) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, 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) <>
472: nvl(p_rec.attribute18, 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) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, 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) <>
474: nvl(p_rec.attribute19, 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) <>
474: nvl(p_rec.attribute19, hr_api.g_varchar2) or
475: nvl(per_pac_shd.g_old_rec.attribute20, 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) <>
476: nvl(p_rec.attribute20, 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
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
478: --
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:
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:
480: -- a) During update, the structure column value or any