75: l_object_version_number per_position_extra_info.object_version_number%type;
76: l_position_extra_info_id per_position_extra_info.position_extra_info_id%type;
77: --
78: begin
79: hr_utility.set_location('Entering:'|| l_proc, 5);
80: --
81: -- Issue a savepoint
82: --
83: savepoint create_position_extra_info;
152: --
153: -- End of Before Process User Hook call
154: --
155: --
156: hr_utility.set_location(l_proc, 7);
157: --
158: -- Process Logic
159: --
160: pe_poi_ins.ins
218: );
219: p_object_version_number := l_object_version_number;
220: p_position_extra_info_id := l_position_extra_info_id;
221: --
222: hr_utility.set_location(l_proc, 8);
223: -- Call After Process User Hook
224: --
225: begin
226: hr_position_extra_info_bk1.create_position_extra_info_a
295: if p_validate then
296: raise hr_api.validate_enabled;
297: end if;
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 11);
300: exception
301: when hr_api.validate_enabled then
302: --
303: -- As the Validate_Enabled exception has been raised
311: --
312: p_position_extra_info_id := null;
313: p_object_version_number := null;
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 12);
316: --
317: when others then
318: --
319: -- A validation or unexpected error has occurred
396: l_object_version_number per_position_extra_info.object_version_number%TYPE;
397: l_temp_ovn number := p_object_version_number;
398: --
399: begin
400: hr_utility.set_location('Entering:'|| l_proc, 5);
401: --
402: -- Issue a savepoint
403: --
404: savepoint update_position_extra_info;
472: end;
473: --
474: -- End of Before Process User Hook call
475: --
476: hr_utility.set_location(l_proc, 7);
477: --
478: -- Store the original ovn in case we rollback when p_validate is true
479: --
480: l_object_version_number := p_object_version_number;
538: ,p_object_version_number => p_object_version_number
539: ,p_validate => false
540: );
541: --
542: hr_utility.set_location(l_proc, 8);
543: --
544: -- Call After Process User Hook
545: --
546: begin
615: if p_validate then
616: raise hr_api.validate_enabled;
617: end if;
618: --
619: hr_utility.set_location(' Leaving:'||l_proc, 11);
620: exception
621: when hr_api.validate_enabled then
622: --
623: -- As the Validate_Enabled exception has been raised
630: -- when validation only mode is being used.)
631: --
632: p_object_version_number := l_object_version_number;
633: --
634: hr_utility.set_location(' Leaving:'||l_proc, 12);
635: --
636: when others then
637: --
638: -- A validation or unexpected error has occurred
661: --
662: l_proc varchar2(72) := g_package||'delete_position_extra_info';
663: --
664: begin
665: hr_utility.set_location('Entering:'|| l_proc, 5);
666: --
667: -- Issue a savepoint
668: --
669: savepoint delete_position_extra_info;
685: end;
686: --
687: -- End of Before Process User Hook call
688: --
689: hr_utility.set_location(l_proc, 7);
690: --
691: -- Process Logic - Delete Position Extra Info details
692: --
693: pe_poi_del.del
695: ,p_object_version_number => p_object_version_number
696: ,p_validate => false
697: );
698: --
699: hr_utility.set_location(l_proc, 8);
700: --
701: -- Call After Process User Hook
702: --
703: begin
719: if p_validate then
720: raise hr_api.validate_enabled;
721: end if;
722: --
723: hr_utility.set_location(' Leaving:'||l_proc, 11);
724: exception
725: when hr_api.validate_enabled then
726: --
727: -- As the Validate_Enabled exception has been raised
728: -- we must rollback to the savepoint
729: --
730: ROLLBACK TO delete_position_extra_info;
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 12);
733: --
734: when others then
735: --
736: -- A validation or unexpected error has occurred