[Home] [Help]
75: l_object_version_number per_assignment_extra_info.object_version_number%type;
76: l_assignment_extra_info_id per_assignment_extra_info.assignment_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_assignment_extra_info;
149: p_hook_type => 'BP'
150: );
151: end;
152: --
153: hr_utility.set_location(l_proc, 7);
154: --
155: -- Process Logic
156: --
157: pe_aei_ins.ins
215: );
216: p_object_version_number := l_object_version_number;
217: p_assignment_extra_info_id := l_assignment_extra_info_id;
218: --
219: hr_utility.set_location(l_proc, 8);
220: --
221: --
222: -- Call After Process User Hook
223: --
294: if p_validate then
295: raise hr_api.validate_enabled;
296: end if;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 11);
299: exception
300: when hr_api.validate_enabled then
301: --
302: -- As the Validate_Enabled exception has been raised
310: --
311: p_assignment_extra_info_id := null;
312: p_object_version_number := null;
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 12);
315: --
316: when others then
317: --
318: -- A validation or unexpected error has occurred
396: --
397: lv_object_version_number 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_assignment_extra_info;
470: p_hook_type => 'BP'
471: );
472: end;
473: --
474: hr_utility.set_location(l_proc, 7);
475: --
476: -- Store the original ovn in case we rollback when p_validate is true
477: --
478: l_object_version_number := p_object_version_number;
536: ,p_object_version_number => p_object_version_number
537: ,p_validate => false
538: );
539: --
540: hr_utility.set_location(l_proc, 8);
541: --
542: --
543: -- Call After Process User Hook
544: --
613: if p_validate then
614: raise hr_api.validate_enabled;
615: end if;
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 11);
618: exception
619: when hr_api.validate_enabled then
620: --
621: -- As the Validate_Enabled exception has been raised
628: -- when validation only mode is being used.)
629: --
630: p_object_version_number := l_object_version_number;
631: --
632: hr_utility.set_location(' Leaving:'||l_proc, 12);
633: --
634: when others then
635: --
636: -- A validation or unexpected error has occurred
660: --
661: l_proc varchar2(72) := g_package||'delete_assignment_extra_info';
662: --
663: begin
664: hr_utility.set_location('Entering:'|| l_proc, 5);
665: --
666: -- Issue a savepoint
667: --
668: savepoint delete_assignment_extra_info;
682: p_hook_type => 'BP'
683: );
684: end;
685: --
686: hr_utility.set_location(l_proc, 7);
687: --
688: -- Process Logic - Delete assignment Extra Info details
689: --
690: pe_aei_del.del
692: ,p_object_version_number => p_object_version_number
693: ,p_validate => false
694: );
695: --
696: hr_utility.set_location(l_proc, 8);
697: --
698: -- Call After Process User Hook
699: --
700: begin
716: if p_validate then
717: raise hr_api.validate_enabled;
718: end if;
719: --
720: hr_utility.set_location(' Leaving:'||l_proc, 11);
721: exception
722: when hr_api.validate_enabled then
723: --
724: -- As the Validate_Enabled exception has been raised
725: -- we must rollback to the savepoint
726: --
727: ROLLBACK TO delete_assignment_extra_info;
728: --
729: hr_utility.set_location(' Leaving:'||l_proc, 12);
730: --
731: when others then
732: --
733: -- A validation or unexpected error has occurred