51: hr_utility.set_location('Entering:'|| l_proc, 10);
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --
55: hr_api.mandatory_arg_error
56: (p_api_name => l_proc
57: ,p_argument => 'allocated_task_id'
58: ,p_argument_value => p_allocated_task_id
59: );
78: close csr_sec_grp;
79: --
80: -- Set the security_group_id in CLIENT_INFO
81: --
82: hr_api.set_security_group_id
83: (p_security_group_id => l_security_group_id
84: );
85: --
86: -- Set the sessions legislation context in HR_SESSION_DATA
84: );
85: --
86: -- Set the sessions legislation context in HR_SESSION_DATA
87: --
88: hr_api.set_legislation_context(l_legislation_code);
89: end if;
90: --
91: hr_utility.set_location(' Leaving:'|| l_proc, 20);
92: --
126: hr_utility.set_location('Entering:'|| l_proc, 10);
127: --
128: -- Ensure that all the mandatory parameter are not null
129: --
130: hr_api.mandatory_arg_error
131: (p_api_name => l_proc
132: ,p_argument => 'allocated_task_id'
133: ,p_argument_value => p_allocated_task_id
134: );
132: ,p_argument => 'allocated_task_id'
133: ,p_argument_value => p_allocated_task_id
134: );
135: --
136: if ( nvl(per_pat_bus.g_allocated_task_id, hr_api.g_number)
137: = p_allocated_task_id) then
138: --
139: -- The legislation code has already been found with a previous
140: -- call to this function. Just return the value in the global
211: ,p_object_version_number => p_object_version_number
212: );
213:
214: IF (l_api_updating
215: AND NVL(per_pat_shd.g_old_rec.task_name, hr_api.g_varchar2) = nvl(p_task_name,hr_api.g_varchar2)
216: )
217: THEN
218: RETURN;
219: END IF;
351: hr_utility.set_location('Entering:'||l_proc,10);
352: --
353: /*
354: if ((p_rec.allocated_task_id is not null) and (
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
352: --
353: /*
354: if ((p_rec.allocated_task_id is not null) and (
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
353: /*
354: if ((p_rec.allocated_task_id is not null) and (
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
354: if ((p_rec.allocated_task_id is not null) and (
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))
397: or (p_rec.allocated_task_id is null) then
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))
397: or (p_rec.allocated_task_id is null) then
398: --
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))
397: or (p_rec.allocated_task_id is null) then
398: --
399: -- Only execute the validation if absolutely necessary:
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))
397: or (p_rec.allocated_task_id is null) then
398: --
399: -- Only execute the validation if absolutely necessary:
400: -- a) During update, the structure column value or any
490: hr_utility.set_location('Entering:'||l_proc,10);
491: --
492:
493: /* if ((p_rec.allocated_task_id is not null) and (
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
491: --
492:
493: /* if ((p_rec.allocated_task_id is not null) and (
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
492:
493: /* if ((p_rec.allocated_task_id is not null) and (
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
493: /* if ((p_rec.allocated_task_id is not null) and (
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
536: or (p_rec.allocated_task_id is null) then
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
536: or (p_rec.allocated_task_id is null) then
537: --
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
536: or (p_rec.allocated_task_id is null) then
537: --
538: -- Only execute the validation if absolutely necessary:
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
536: or (p_rec.allocated_task_id is null) then
537: --
538: -- Only execute the validation if absolutely necessary:
539: -- a) During update, the structure column value or any