[Home] [Help]
91: hr_utility.set_location(l_proc, 20);
92: --
93: -- Check if inserting or updating with modified values
94: --
95: l_api_updating := per_spp_shd.api_updating
96: (p_placement_id => p_placement_id
97: ,p_effective_date => p_effective_date -- Bug 2488727
98: ,p_object_version_number => p_object_version_number
99: );
97: ,p_effective_date => p_effective_date -- Bug 2488727
98: ,p_object_version_number => p_object_version_number
99: );
100: --
101: if ((l_api_updating and per_spp_shd.g_old_rec.assignment_id <> p_assignment_id)
102: or
103: (NOT l_api_updating))
104: then
105: hr_utility.set_location(l_proc, 30);
427: hr_utility.set_location(l_proc, 20);
428: --
429: -- Check if inserting or updating with modified values
430: --
431: l_api_updating := per_spp_shd.api_updating
432: (p_placement_id => p_placement_id
433: ,p_effective_date => p_effective_date
434: ,p_object_version_number => p_object_version_number
435: );
515: -- will equal new value and l_api_updating will be true.
516: --
517: -- Check if inserting or updating with modified values
518: --
519: l_api_updating := per_spp_shd.api_updating
520: (p_placement_id => p_placement_id
521: ,p_effective_date => l_effective_date not used
522: ,p_object_version_number => p_object_version_number
523: );
521: ,p_effective_date => l_effective_date not used
522: ,p_object_version_number => p_object_version_number
523: );
524: --
525: if ((l_api_updating and per_spp_shd.g_old_rec.auto_increment_flag <> p_auto_increment_flag)
526: or
527: (NOT l_api_updating))
528: then
529: */
595: --
596: -- {End Of Comments}
597: -- ----------------------------------------------------------------------------
598: procedure chk_reason_only_update
599: (p_rec in per_spp_shd.g_rec_type
600: ,p_datetrack_mode in out nocopy varchar2
601: ,p_effective_date in date
602: ,p_validation_start_date in out nocopy date
603: ,p_validation_end_date in out nocopy date
612: l_step_id per_spinal_point_placements_f.step_id%TYPE;
613: l_auto_inc_flag per_spinal_point_placements_f.auto_increment_flag%TYPE;
614: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
615: l_reason per_spinal_point_placements_f.reason%TYPE;
616: l_old_rec per_spp_shd.g_rec_type;
617: --
618:
619: cursor csr_reason_1 is
620: select placement_id,
796: hr_utility.set_location(l_proc, 20);
797: --
798: -- Check if inserting or updating with modified values
799: --
800: l_api_updating := per_spp_shd.api_updating
801: (p_placement_id => p_placement_id
802: ,p_effective_date => l_effective_date
803: ,p_object_version_number => p_object_version_number
804: );
804: );
805: --
806: hr_utility.set_location(l_proc, 25);
807: --
808: if ((l_api_updating and (per_spp_shd.g_old_rec.parent_spine_id <> p_parent_spine_id)
809: or (per_spp_shd.g_old_rec.step_id <> p_step_id))
810: or
811: (NOT l_api_updating))
812: then
805: --
806: hr_utility.set_location(l_proc, 25);
807: --
808: if ((l_api_updating and (per_spp_shd.g_old_rec.parent_spine_id <> p_parent_spine_id)
809: or (per_spp_shd.g_old_rec.step_id <> p_step_id))
810: or
811: (NOT l_api_updating))
812: then
813: hr_utility.set_location(l_proc, 30);
1162: -- {End Of Comments}
1163: -- ----------------------------------------------------------------------------
1164: Procedure chk_non_updateable_args
1165: (p_effective_date in date
1166: ,p_rec in per_spp_shd.g_rec_type
1167: ) IS
1168: --
1169: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1170: l_error EXCEPTION;
1175: -- Only proceed with the validation if a row exists for the current
1176: -- record in the HR Schema.
1177: --
1178: hr_utility.set_location(' Entering:'||l_proc,10);
1179: IF NOT per_spp_shd.api_updating
1180: (p_placement_id => p_rec.placement_id
1181: ,p_effective_date => p_effective_date
1182: ,p_object_version_number => p_rec.object_version_number
1183: ) THEN
1426: -- ----------------------------------------------------------------------------
1427: -- |---------------------------< insert_validate >----------------------------|
1428: -- ----------------------------------------------------------------------------
1429: Procedure insert_validate
1430: (p_rec in per_spp_shd.g_rec_type
1431: ,p_effective_date in date
1432: ,p_datetrack_mode in varchar2
1433: ,p_validation_start_date in date
1434: ,p_validation_end_date in date
1499: -- ----------------------------------------------------------------------------
1500: -- |---------------------------< update_validate >----------------------------|
1501: -- ----------------------------------------------------------------------------
1502: Procedure update_validate
1503: (p_rec in out nocopy per_spp_shd.g_rec_type
1504: ,p_effective_date in date
1505: ,p_datetrack_mode in out nocopy varchar2
1506: ,p_validation_start_date in out nocopy date
1507: ,p_validation_end_date in out nocopy date
1650: -- ----------------------------------------------------------------------------
1651: -- |---------------------------< delete_validate >----------------------------|
1652: -- ----------------------------------------------------------------------------
1653: Procedure delete_validate
1654: (p_rec in per_spp_shd.g_rec_type
1655: ,p_effective_date in date
1656: ,p_datetrack_mode in varchar2
1657: ,p_validation_start_date in date
1658: ,p_validation_end_date in date