[Home] [Help]
79: l_confidential_date per_roles.confidential_date%TYPE;
80: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;
81: --
82: begin
83: hr_utility.set_location('Entering:'|| l_proc, 10);
84: --
85: -- Issue a savepoint
86: --
87: savepoint create_role;
162: --
163: -- Validation in addition to Row Handlers
164: --
165: --
166: hr_utility.set_location('before call to rh',3);
167: -- Process Logic
168: --
169: per_rol_ins.ins
170: (p_effective_date => l_effective_date
302: --
303: p_role_id := l_role_id;
304: p_object_version_number := l_object_version_number;
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 70);
307: exception
308: when hr_api.validate_enabled then
309: --
310: -- As the Validate_Enabled exception has been raised
317: -- when validation only mode is being used.)
318: --
319: p_role_id := null;
320: p_object_version_number := null;
321: hr_utility.set_location(' Leaving:'||l_proc, 80);
322: when others then
323: --
324: -- A validation or unexpected error has occured
325: --
325: --
326: p_role_id := null;
327: p_object_version_number := null;
328: rollback to create_role;
329: hr_utility.set_location(' Leaving:'||l_proc, 90);
330: raise;
331: end create_supplementary_role;
332: --
333: -- ----------------------------------------------------------------------------
403: l_old_end_date per_roles.old_end_date%TYPE; -- fix 1370960
404: l_temp_ovn number;
405: --
406: begin
407: hr_utility.set_location('Entering:'|| l_proc, 10);
408: --
409: -- Issue a savepoint
410: --
411: savepoint update_role;
621: -- Set all output arguments
622: --
623: p_object_version_number := l_object_version_number;
624: --
625: hr_utility.set_location(' Leaving:'||l_proc, 70);
626: exception
627: when hr_api.validate_enabled then
628: --
629: -- As the Validate_Enabled exception has been raised
634: -- Only set output warning arguments
635: -- (Any key or derived arguments must be set to null
636: -- when validation only mode is being used.)
637: --
638: hr_utility.set_location(' Leaving:'||l_proc, 80);
639: when others then
640: --
641: -- A validation or unexpected error has occured
642: --
641: -- A validation or unexpected error has occured
642: --
643: p_object_version_number := l_temp_ovn;
644: rollback to update_role;
645: hr_utility.set_location(' Leaving:'||l_proc, 90);
646: raise;
647: end update_supplementary_role;
648: --
649: --
671: from per_election_candidates
672: where role_id = p_role_id;
673: --
674: begin
675: hr_utility.set_location('Entering:'|| l_proc, 5);
676: --
677: -- Issue a savepoint if operating in validation only mode.
678: --
679: savepoint delete_role;
693: );
694: end;
695: --
696: --
697: hr_utility.set_location(l_proc, 7);
698: -- Changes made for bug 5475480.
699: -- First un-link the role from candidate record and then delete the person role record.
700: l_election_role_id := null;
701: --
718: (p_role_id => p_role_id
719: ,p_object_version_number => p_object_version_number
720: );
721: --
722: hr_utility.set_location(l_proc, 8);
723: --
724: --
725: -- Call After Process User Hook
726: begin
741: if p_validate then
742: raise hr_api.validate_enabled;
743: end if;
744: --
745: hr_utility.set_location(' Leaving:'||l_proc, 11);
746: exception
747: when hr_api.validate_enabled then
748: --
749: -- As the Validate_Enabled exception has been raised
750: -- we must rollback to the savepoint
751: --
752: ROLLBACK TO delete_role;
753: --
754: hr_utility.set_location(' Leaving:'||l_proc, 12);
755: --
756: when others then
757: --
758: --