APPS.PER_CTK_BUS dependencies on HR_API

Line 50: hr_api.mandatory_arg_error

46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error
51: (p_api_name => l_proc
52: ,p_argument => 'task_in_checklist_id'
53: ,p_argument_value => p_task_in_checklist_id
54: );

Line 77: hr_api.set_security_group_id

73: close csr_sec_grp;
74: --
75: -- Set the security_group_id in CLIENT_INFO
76: --
77: hr_api.set_security_group_id
78: (p_security_group_id => l_security_group_id
79: );
80: --
81: -- Set the sessions legislation context in HR_SESSION_DATA

Line 83: hr_api.set_legislation_context(l_legislation_code);

79: );
80: --
81: -- Set the sessions legislation context in HR_SESSION_DATA
82: --
83: hr_api.set_legislation_context(l_legislation_code);
84: end if;
85: --
86: hr_utility.set_location(' Leaving:'|| l_proc, 20);
87: --

Line 122: hr_api.mandatory_arg_error

118: hr_utility.set_location('Entering:'|| l_proc, 10);
119: --
120: -- Ensure that all the mandatory parameter are not null
121: --
122: hr_api.mandatory_arg_error
123: (p_api_name => l_proc
124: ,p_argument => 'task_in_checklist_id'
125: ,p_argument_value => p_task_in_checklist_id
126: );

Line 128: if ( nvl(per_ctk_bus.g_task_in_checklist_id, hr_api.g_number)

124: ,p_argument => 'task_in_checklist_id'
125: ,p_argument_value => p_task_in_checklist_id
126: );
127: --
128: if ( nvl(per_ctk_bus.g_task_in_checklist_id, hr_api.g_number)
129: = p_task_in_checklist_id) then
130: --
131: -- The legislation code has already been found with a previous
132: -- call to this function. Just return the value in the global

Line 190: hr_api.mandatory_arg_error

186: begin
187: IF g_debug THEN hr_utility.set_location('Entering:'||l_proc, 10); END IF;
188:
189: --
190: hr_api.mandatory_arg_error
191: (p_api_name => l_proc
192: ,p_argument => 'p_checklist_id'
193: ,p_argument_value => p_checklist_id
194: );

Line 263: and nvl(per_ctk_shd.g_old_rec.checklist_task_name, hr_api.g_varchar2)

259: (p_task_in_checklist_id => p_task_in_checklist_id
260: ,p_object_version_number => p_object_version_number
261: );
262: IF (l_api_updating
263: and nvl(per_ctk_shd.g_old_rec.checklist_task_name, hr_api.g_varchar2)
264: = nvl(p_checklist_task_name,hr_api.g_varchar2))
265: THEN
266: RETURN;
267: END IF;

Line 264: = nvl(p_checklist_task_name,hr_api.g_varchar2))

260: ,p_object_version_number => p_object_version_number
261: );
262: IF (l_api_updating
263: and nvl(per_ctk_shd.g_old_rec.checklist_task_name, hr_api.g_varchar2)
264: = nvl(p_checklist_task_name,hr_api.g_varchar2))
265: THEN
266: RETURN;
267: END IF;
268: --

Line 337: and ( (nvl(per_ctk_shd.g_old_rec.target_duration, hr_api.g_number) = nvl(p_target_duration,hr_api.g_number))

333: ,p_object_version_number => p_object_version_number
334: );
335: --
336: IF (l_api_updating
337: and ( (nvl(per_ctk_shd.g_old_rec.target_duration, hr_api.g_number) = nvl(p_target_duration,hr_api.g_number))
338: AND
339: (nvl(per_ctk_shd.g_old_rec.target_duration_UOM, hr_api.g_varchar2) = nvl(p_target_duration_uom,hr_api.g_varchar2))
340: )
341: )

Line 339: (nvl(per_ctk_shd.g_old_rec.target_duration_UOM, hr_api.g_varchar2) = nvl(p_target_duration_uom,hr_api.g_varchar2))

335: --
336: IF (l_api_updating
337: and ( (nvl(per_ctk_shd.g_old_rec.target_duration, hr_api.g_number) = nvl(p_target_duration,hr_api.g_number))
338: AND
339: (nvl(per_ctk_shd.g_old_rec.target_duration_UOM, hr_api.g_varchar2) = nvl(p_target_duration_uom,hr_api.g_varchar2))
340: )
341: )
342: THEN
343: RETURN;

Line 353: IF hr_api.not_exists_in_hrstanlookups

349: -- Checks that the target_duration_uom is valid
350: --
351: IF (nvl(p_target_duration_uom,'ZZ') <> 'ZZ') THEN
352: --
353: IF hr_api.not_exists_in_hrstanlookups
354: (p_effective_date => p_effective_date
355: ,p_lookup_type => 'QUALIFYING_UNITS'
356: ,p_lookup_code => p_target_duration_uom
357: ) then

Line 571: nvl(per_ctk_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

567: begin
568: hr_utility.set_location('Entering:'||l_proc,10);
569: --
570: if ((p_rec.task_in_checklist_id is not null) and (
571: nvl(per_ctk_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
572: nvl(p_rec.information_category, hr_api.g_varchar2) or
573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>
574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 572: nvl(p_rec.information_category, hr_api.g_varchar2) or

568: hr_utility.set_location('Entering:'||l_proc,10);
569: --
570: if ((p_rec.task_in_checklist_id is not null) and (
571: nvl(per_ctk_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
572: nvl(p_rec.information_category, hr_api.g_varchar2) or
573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>
574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>

569: --
570: if ((p_rec.task_in_checklist_id is not null) and (
571: nvl(per_ctk_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
572: nvl(p_rec.information_category, hr_api.g_varchar2) or
573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>
574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 574: nvl(p_rec.information1, hr_api.g_varchar2) or

570: if ((p_rec.task_in_checklist_id is not null) and (
571: nvl(per_ctk_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
572: nvl(p_rec.information_category, hr_api.g_varchar2) or
573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>
574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>

571: nvl(per_ctk_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
572: nvl(p_rec.information_category, hr_api.g_varchar2) or
573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>
574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 576: nvl(p_rec.information2, hr_api.g_varchar2) or

572: nvl(p_rec.information_category, hr_api.g_varchar2) or
573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>
574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>

573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>
574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 578: nvl(p_rec.information3, hr_api.g_varchar2) or

574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>

575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 580: nvl(p_rec.information4, hr_api.g_varchar2) or

576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>

577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 582: nvl(p_rec.information5, hr_api.g_varchar2) or

578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>

579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 584: nvl(p_rec.information6, hr_api.g_varchar2) or

580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>

581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 586: nvl(p_rec.information7, hr_api.g_varchar2) or

582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>

583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 588: nvl(p_rec.information8, hr_api.g_varchar2) or

584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>

585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 590: nvl(p_rec.information9, hr_api.g_varchar2) or

586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>

587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 592: nvl(p_rec.information10, hr_api.g_varchar2) or

588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>

589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 594: nvl(p_rec.information11, hr_api.g_varchar2) or

590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>

591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 596: nvl(p_rec.information12, hr_api.g_varchar2) or

592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>

593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 598: nvl(p_rec.information13, hr_api.g_varchar2) or

594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>

595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 600: nvl(p_rec.information14, hr_api.g_varchar2) or

596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>

597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 602: nvl(p_rec.information15, hr_api.g_varchar2) or

598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>

599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 604: nvl(p_rec.information16, hr_api.g_varchar2) or

600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>

601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 606: nvl(p_rec.information17, hr_api.g_varchar2) or

602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>
610: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>

603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>
610: nvl(p_rec.information19, hr_api.g_varchar2) or
611: nvl(per_ctk_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 608: nvl(p_rec.information18, hr_api.g_varchar2) or

604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>
610: nvl(p_rec.information19, hr_api.g_varchar2) or
611: nvl(per_ctk_shd.g_old_rec.information20, hr_api.g_varchar2) <>
612: nvl(p_rec.information20, hr_api.g_varchar2) ))

Line 609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>

605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>
610: nvl(p_rec.information19, hr_api.g_varchar2) or
611: nvl(per_ctk_shd.g_old_rec.information20, hr_api.g_varchar2) <>
612: nvl(p_rec.information20, hr_api.g_varchar2) ))
613: or (p_rec.task_in_checklist_id is null) then

Line 610: nvl(p_rec.information19, hr_api.g_varchar2) or

606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>
610: nvl(p_rec.information19, hr_api.g_varchar2) or
611: nvl(per_ctk_shd.g_old_rec.information20, hr_api.g_varchar2) <>
612: nvl(p_rec.information20, hr_api.g_varchar2) ))
613: or (p_rec.task_in_checklist_id is null) then
614: --

Line 611: nvl(per_ctk_shd.g_old_rec.information20, hr_api.g_varchar2) <>

607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>
610: nvl(p_rec.information19, hr_api.g_varchar2) or
611: nvl(per_ctk_shd.g_old_rec.information20, hr_api.g_varchar2) <>
612: nvl(p_rec.information20, hr_api.g_varchar2) ))
613: or (p_rec.task_in_checklist_id is null) then
614: --
615: -- Only execute the validation if absolutely necessary:

Line 612: nvl(p_rec.information20, hr_api.g_varchar2) ))

608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>
610: nvl(p_rec.information19, hr_api.g_varchar2) or
611: nvl(per_ctk_shd.g_old_rec.information20, hr_api.g_varchar2) <>
612: nvl(p_rec.information20, hr_api.g_varchar2) ))
613: or (p_rec.task_in_checklist_id is null) then
614: --
615: -- Only execute the validation if absolutely necessary:
616: -- a) During update, the structure column value or any

Line 708: nvl(per_ctk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

704: begin
705: hr_utility.set_location('Entering:'||l_proc,10);
706: --
707: if ((p_rec.task_in_checklist_id is not null) and (
708: nvl(per_ctk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 709: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

705: hr_utility.set_location('Entering:'||l_proc,10);
706: --
707: if ((p_rec.task_in_checklist_id is not null) and (
708: nvl(per_ctk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

706: --
707: if ((p_rec.task_in_checklist_id is not null) and (
708: nvl(per_ctk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 711: nvl(p_rec.attribute1, hr_api.g_varchar2) or

707: if ((p_rec.task_in_checklist_id is not null) and (
708: nvl(per_ctk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

708: nvl(per_ctk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 713: nvl(p_rec.attribute2, hr_api.g_varchar2) or

709: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 715: nvl(p_rec.attribute3, hr_api.g_varchar2) or

711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 717: nvl(p_rec.attribute4, hr_api.g_varchar2) or

713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 719: nvl(p_rec.attribute5, hr_api.g_varchar2) or

715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 721: nvl(p_rec.attribute6, hr_api.g_varchar2) or

717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 723: nvl(p_rec.attribute7, hr_api.g_varchar2) or

719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 725: nvl(p_rec.attribute8, hr_api.g_varchar2) or

721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 727: nvl(p_rec.attribute9, hr_api.g_varchar2) or

723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 729: nvl(p_rec.attribute10, hr_api.g_varchar2) or

725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 731: nvl(p_rec.attribute11, hr_api.g_varchar2) or

727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 733: nvl(p_rec.attribute12, hr_api.g_varchar2) or

729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 735: nvl(p_rec.attribute13, hr_api.g_varchar2) or

731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 737: nvl(p_rec.attribute14, hr_api.g_varchar2) or

733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 739: nvl(p_rec.attribute15, hr_api.g_varchar2) or

735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 741: nvl(p_rec.attribute16, hr_api.g_varchar2) or

737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 743: nvl(p_rec.attribute17, hr_api.g_varchar2) or

739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute19, hr_api.g_varchar2) or
748: nvl(per_ctk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 745: nvl(p_rec.attribute18, hr_api.g_varchar2) or

741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute19, hr_api.g_varchar2) or
748: nvl(per_ctk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute19, hr_api.g_varchar2) or
748: nvl(per_ctk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
750: or (p_rec.task_in_checklist_id is null) then

Line 747: nvl(p_rec.attribute19, hr_api.g_varchar2) or

743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute19, hr_api.g_varchar2) or
748: nvl(per_ctk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
750: or (p_rec.task_in_checklist_id is null) then
751: --

Line 748: nvl(per_ctk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute19, hr_api.g_varchar2) or
748: nvl(per_ctk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
750: or (p_rec.task_in_checklist_id is null) then
751: --
752: -- Only execute the validation if absolutely necessary:

Line 749: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute19, hr_api.g_varchar2) or
748: nvl(per_ctk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
750: or (p_rec.task_in_checklist_id is null) then
751: --
752: -- Only execute the validation if absolutely necessary:
753: -- a) During update, the structure column value or any