73:
74: --
75: begin
76: --
77: hr_utility.set_location('Entering:'|| l_proc, 10);
78:
79: l_step_id := p_step_id;
80:
81: --
82: -- Issue a savepoint
83: --
84: savepoint create_grade_step;
85:
86: hr_utility.set_location(l_proc, 20);
87:
88: --
89: -- Truncate the time portion from all IN date parameters
90: --
146: -- End of before hook process (create_grade_step)
147: --
148: end;
149:
150: hr_utility.set_location(l_proc, 30);
151: --
152: -- Process Logic
153: --
154:
202: ,p_effective_start_date => l_effective_start_date
203: ,p_effective_end_date => l_effective_end_date
204: );
205:
206: hr_utility.set_location(l_proc, 40);
207:
208: --
209: --
210: -- Call After Process hook for create_grade_step
274: then
275: raise hr_api.validate_enabled;
276: end if;
277: --
278: hr_utility.set_location(l_proc, 50);
279: --
280: -- Set OUT parameters
281: --
282: p_step_id := l_step_id;
283: p_object_version_number := l_object_version_number;
284: p_effective_start_date := l_effective_start_date;
285: p_effective_end_date := l_effective_end_date;
286: --
287: hr_utility.set_location(' Leaving:' ||l_proc, 60);
288: --
289: exception
290: --
291: when hr_api.validate_enabled then
304: p_object_version_number := null;
305: p_effective_start_date := null;
306: p_effective_end_date := null;
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 70);
309: --
310: when others then
311: --
312: -- A validation or unexpected error has occurred
312: -- A validation or unexpected error has occurred
313: --
314: ROLLBACK TO create_grade_step;
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 80);
317: --
318: p_step_id := null;
319: p_object_version_number := null;
320: p_effective_start_date := null;
393:
394: --
395: begin
396: --
397: hr_utility.set_location('Entering:'|| l_proc, 10);
398: --
399: lv_object_version_number := p_object_version_number;
400:
401: --
402: -- Issue a savepoint
403: --
404: savepoint update_grade_step;
405:
406: hr_utility.set_location(l_proc, 20);
407:
408: --
409: -- Truncate the time portion from all IN date parameters
410: --
474: -- End of before hook process (update_grade_step)
475: --
476: end;
477:
478: hr_utility.set_location(l_proc, 30);
479: --
480: -- Process Logic
481: --
482:
538: -- Assign the out parameters.
539: --
540: p_object_version_number := l_object_version_number;
541:
542: hr_utility.set_location(l_proc, 40);
543:
544: --
545: --
546: -- Call After Process hook for update_grade_step
611: then
612: raise hr_api.validate_enabled;
613: end if;
614: --
615: hr_utility.set_location(l_proc, 50);
616: --
617: -- Set OUT parameters
618: --
619: p_object_version_number := l_object_version_number;
619: p_object_version_number := l_object_version_number;
620: p_effective_start_date := l_effective_start_date;
621: p_effective_end_date := l_effective_end_date;
622: --
623: hr_utility.set_location(' Leaving:' ||l_proc, 60);
624: --
625: exception
626: --
627: when hr_api.validate_enabled then
637: -- when validation only mode is being used.)
638: --
639: p_object_version_number := p_object_version_number;
640: --
641: hr_utility.set_location(' Leaving:'||l_proc, 70);
642: --
643: when others then
644: --
645: -- A validation or unexpected error has occurred
649: p_object_version_number := lv_object_version_number;
650: p_effective_start_date := null;
651: p_effective_end_date := null;
652: --
653: hr_utility.set_location(' Leaving:'||l_proc, 80);
654: --
655: raise;
656: --
657: end update_grade_step;
675:
676: l_proc varchar2(72) := g_package||'delete_grade_step';
677:
678: begin
679: hr_utility.set_location('Entering:'|| l_proc, 10);
680:
681: delete_grade_step
682: (p_validate => p_validate
683: ,p_effective_date => p_effective_date
687: ,p_effective_start_date => p_effective_start_date
688: ,p_effective_end_date => p_effective_end_date
689: ,p_called_from_del_grd_scale => FALSE
690: );
691: hr_utility.set_location('Leaving:'|| l_proc, 10);
692:
693: end;
694: --
695: --
723: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;
724: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;
725: --
726: begin
727: hr_utility.set_location('Entering:'|| l_proc, 10);
728:
729: l_effective_date := trunc(p_effective_date);
730: lv_object_version_number := p_object_version_number;
731:
753: ,p_hook_type => 'BP'
754: );
755: end;
756:
757: hr_utility.set_location(l_proc, 20);
758:
759: --
760: -- Process Logic
761: --
769: ,p_effective_end_date => l_effective_end_date
770: ,p_called_from_del_grd_scale => p_called_from_del_grd_scale -- BUG 4096238
771: );
772:
773: hr_utility.set_location(l_proc, 30);
774:
775: --
776: -- Call After Process User Hook
777: --
791: ,p_hook_type => 'AP'
792: );
793: end;
794:
795: hr_utility.set_location(l_proc, 40);
796:
797: p_object_version_number := l_object_version_number;
798: --
799: -- When in validation only mode raise the Validate_Enabled exception
806: -- Set all output arguments (returned by some dt modes only)
807: --
808: p_object_version_number := l_object_version_number;
809:
810: hr_utility.set_location(' Leaving:'||l_proc, 100);
811: exception
812: when hr_api.validate_enabled then
813: hr_utility.set_location(' Leaving...:'||l_proc, 50);
814: --
809:
810: hr_utility.set_location(' Leaving:'||l_proc, 100);
811: exception
812: when hr_api.validate_enabled then
813: hr_utility.set_location(' Leaving...:'||l_proc, 50);
814: --
815: -- As the Validate_Enabled exception has been raised
816: -- we must rollback to the savepoint
817: --
825: p_effective_end_date := null;
826: p_object_version_number := null;
827: --
828: when others then
829: hr_utility.set_location(' Leaving...:'||l_proc, 60);
830: --
831: -- A validation or unexpected error has occured
832: --
833: rollback to delete_grade_step;