97: l_absence_case_id number;
98: l_object_version_number number;
99: --
100: begin
101: hr_utility.set_location('Entering:'|| l_proc, 10);
102: --
103: -- Create a savepoint.
104: --
105: savepoint create_person_absence_case;
188: ,p_hook_type => 'BP'
189: );
190: end;
191:
192: hr_utility.set_location(l_proc, 30);
193: --
194: -- Insert Person Absence Case
195: per_abc_ins.ins
196: (p_name => p_name
360: --
361: p_absence_case_id := l_absence_case_id;
362: p_object_version_number := l_object_version_number;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 70);
365:
366: exception
367: when hr_api.validate_enabled then
368: --
376: -- when validation only mode is being used.)
377: --
378: p_absence_case_id := null;
379: p_object_version_number := null;
380: hr_utility.set_location(l_proc, 80);
381: when others then
382: --
383: -- A validation or unexpected error has occured
384: --
385: p_absence_case_id := null;
386: p_object_version_number := null;
387:
388: rollback to create_person_absence_case;
389: hr_utility.set_location(' Leaving:'||l_proc, 90);
390: raise;
391: end create_person_absence_case;
392: --
393: -- ----------------------------------------------------------------------------
477: --
478:
479: begin
480:
481: hr_utility.set_location('Entering:'|| l_proc, 10);
482: --
483: lv_object_version_number := p_object_version_number ;
484: -- Issue a savepoint
485: --
571: );
572: end;
573:
574: --
575: hr_utility.set_location(l_proc, 30);
576: --
577: l_object_version_number := p_object_version_number;
578: --
579: -- Update Person Absence
742: if p_validate then
743: raise hr_api.validate_enabled;
744: end if;
745: --
746: hr_utility.set_location(' Leaving:'||l_proc, 90);
747: exception
748: when hr_api.validate_enabled then
749: --
750: -- As the Validate_Enabled exception has been raised
756: -- (Any key or derived arguments must be set to null
757: -- when validation only mode is being used.)
758: --
759: p_object_version_number := null;
760: hr_utility.set_location(' Leaving:'||l_proc, 100);
761: when others then
762: --
763: -- A validation or unexpected error has occured
764: --
764: --
765: p_object_version_number := lv_object_version_number ;
766:
767: rollback to update_person_absence_case;
768: hr_utility.set_location(' Leaving:'||l_proc, 110);
769: raise;
770: end update_person_absence_case;
771: --
772: -- ----------------------------------------------------------------------------
782: l_proc varchar2(72) := g_package||'delete_person_absence_case';
783: l_exists number;
784:
785: begin
786: hr_utility.set_location('Entering:'|| l_proc, 10);
787: --
788: -- Issue a savepoint
789: --
790: savepoint delete_person_absence_case;
816:
817: --
818: -- Update Person Absence Attendances to remove link to Case record.
819: --
820: hr_utility.set_location(l_proc, 48);
821:
822: update per_absence_attendances
823: set absence_case_id = null
824: where absence_case_id =p_absence_case_id;
822: update per_absence_attendances
823: set absence_case_id = null
824: where absence_case_id =p_absence_case_id;
825:
826: hr_utility.set_location(l_proc, 50);
827:
828: --
829: -- Call After Process User Hook
830: --
848: raise hr_api.validate_enabled;
849: end if;
850:
851: --
852: hr_utility.set_location(' Leaving:'||l_proc, 70);
853: exception
854: when hr_api.validate_enabled then
855: --
856: -- As the Validate_Enabled exception has been raised
861: -- Only set output warning arguments
862: -- (Any key or derived arguments must be set to null
863: -- when validation only mode is being used.)
864: --
865: hr_utility.set_location(' Leaving:'||l_proc, 80);
866: when others then
867: --
868: -- A validation or unexpected error has occured
869: --
867: --
868: -- A validation or unexpected error has occured
869: --
870: rollback to delete_person_absence_case;
871: hr_utility.set_location(' Leaving:'||l_proc, 90);
872: raise;
873: --
874: end delete_person_absence_case;
875: