[Home] [Help]
181: l_event_id number;
182: l_object_version_number number;
183: l_effective_date date;
184: begin
185: hr_utility.set_location('Entering:'|| l_proc, 10);
186: --
187: -- Issue a savepoint
188: --
189: savepoint CREATE_CLASS;
463: --
464: p_event_id := l_event_id;
465: p_object_version_number := l_object_version_number;
466: --
467: hr_utility.set_location(' Leaving:'||l_proc, 70);
468: exception
469: when hr_api.validate_enabled then
470: --
471: -- As the Validate_Enabled exception has been raised
478: -- when validation only mode is being used.)
479: --
480: p_event_id := null;
481: p_object_version_number := null;
482: hr_utility.set_location(' Leaving:'||l_proc, 80);
483: when others then
484: --
485: -- A validation or unexpected error has occured
486: --
486: --
487: rollback to CREATE_CLASS;
488: p_event_id := null;
489: p_object_version_number := null;
490: hr_utility.set_location(' Leaving:'||l_proc, 90);
491: raise;
492: end create_class;
493: -- ----------------------------------------------------------------------------
494: -- |-------------------------< UPDATE_CLASS >---------------------------------|
576: l_effective_date date;
577: l_object_version_number number := p_object_version_number;
578: l_timezonechanged BOOLEAN := false;
579: begin
580: hr_utility.set_location('Entering:'|| l_proc, 10);
581: --
582: -- Issue a savepoint
583: --
584: savepoint UPDATE_CLASS;
861: end if;
862: --
863: -- Set all output arguments
864: --
865: hr_utility.set_location(' Leaving:'||l_proc, 70);
866: exception
867: when hr_api.validate_enabled then
868: --
869: -- As the Validate_Enabled exception has been raised
875: -- (Any key or derived arguments must be set to null
876: -- when validation only mode is being used.)
877: --
878: p_object_version_number := null;
879: hr_utility.set_location(' Leaving:'||l_proc, 80);
880: when others then
881: --
882: -- A validation or unexpected error has occured
883: --
882: -- A validation or unexpected error has occured
883: --
884: rollback to UPDATE_CLASS;
885: p_object_version_number := l_object_version_number;
886: hr_utility.set_location(' Leaving:'||l_proc, 90);
887: raise;
888: end update_class;
889: --
890: -- ----------------------------------------------------------------------------
903: l_object_version_id number;
904: --
905: --
906: begin
907: hr_utility.set_location('Entering:'|| l_proc, 10);
908: --
909: -- Issue a savepoint
910: --
911: savepoint DELETE_CLASS;
971: --
972: -- Set all output arguments
973: --
974: --
975: hr_utility.set_location(' Leaving:'||l_proc, 170);
976: exception
977: when hr_api.validate_enabled then
978: --
979: -- As the Validate_Enabled exception has been raised
984: -- Only set output warning arguments
985: -- (Any key or derived arguments must be set to null
986: -- when validation only mode is being used.)
987: --
988: hr_utility.set_location(' Leaving:'||l_proc, 180);
989: when others then
990: --
991: -- A validation or unexpected error has occured
992: --
990: --
991: -- A validation or unexpected error has occured
992: --
993: rollback to DELETE_CLASS;
994: hr_utility.set_location(' Leaving:'||l_proc, 190);
995: raise;
996: end delete_class;
997: --
998: -- ----------------------------------------------------------------------------
1013: and object_type = 'A';
1014:
1015: l_proc varchar2(72) := g_package ||'add_evaluation';
1016: Begin
1017: hr_utility.set_location(' Entering:' || l_proc,10);
1018: open c_dflt_eval;
1019: fetch c_dflt_eval into l_eval_id, l_mand_flag;
1020: close c_dflt_eval;
1021: if l_eval_id is not null then
1029: p_event_id,
1030: 'E',
1031: 1);
1032: end if;
1033: hr_utility.set_location(' Exiting:' || l_proc,15);
1034: end add_evaluation;
1035:
1036: end OTA_EVENT_API;