[Home] [Help]
67: l_object_version_number number;
68: l_effective_date date;
69: l_proc varchar2(72) := g_package||'create_configuration_value';
70: begin
71: hr_utility.set_location('Entering:'|| l_proc, 10);
72: --
73: -- Issue a savepoint
74: --
75: savepoint create_configuration_value;
278: --
279: p_configuration_value_id := l_configuration_value_id;
280: p_object_version_number := l_object_version_number;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 70);
283: exception
284: when hr_api.validate_enabled then
285: --
286: -- As the Validate_Enabled exception has been raised
293: -- when validation only mode is being used.)
294: --
295: p_configuration_value_id := null;
296: p_object_version_number := null;
297: hr_utility.set_location(' Leaving:'||l_proc, 80);
298: when others then
299: --
300: -- A validation or unexpected error has occured
301: --
305: -- OUT parameters, including warnings, to null
306: --
307: p_configuration_value_id := null;
308: p_object_version_number := null;
309: hr_utility.set_location(' Leaving:'||l_proc, 90);
310: raise;
311: end create_configuration_value;
312: --
313: --
372: l_object_version_number number;
373: l_effective_date date;
374: l_proc varchar2(72) := g_package||'update_configuration_value';
375: begin
376: hr_utility.set_location('Entering:'|| l_proc, 10);
377: --
378: -- Issue a savepoint
379: --
380: savepoint update_configuration_value;
582: -- Set all IN OUT and OUT parameters with out values
583: --
584: p_object_version_number := l_object_version_number;
585: --
586: hr_utility.set_location(' Leaving:'||l_proc, 70);
587: exception
588: when hr_api.validate_enabled then
589: --
590: -- As the Validate_Enabled exception has been raised
596: -- (Any key or derived arguments must be set to null
597: -- when validation only mode is being used.)
598: --
599: p_object_version_number := null;
600: hr_utility.set_location(' Leaving:'||l_proc, 80);
601: when others then
602: --
603: -- A validation or unexpected error has occured
604: --
607: -- Reset IN OUT parameters and set all
608: -- OUT parameters, including warnings, to null
609: --
610: p_object_version_number := null;
611: hr_utility.set_location(' Leaving:'||l_proc, 90);
612: raise;
613: end update_configuration_value;
614: --
615: --
628: --
629: l_object_version_number number;
630: l_proc varchar2(72) := g_package||'delete_configuration_value';
631: begin
632: hr_utility.set_location('Entering:'|| l_proc, 10);
633: --
634: -- Issue a savepoint
635: --
636: savepoint delete_configuration_value;
693: -- Set all IN OUT and OUT parameters with out values
694: --
695: -- p_object_version_number := l_object_version_number;
696: --
697: hr_utility.set_location(' Leaving:'||l_proc, 70);
698: exception
699: when hr_api.validate_enabled then
700: --
701: -- As the Validate_Enabled exception has been raised
707: -- (Any key or derived arguments must be set to null
708: -- when validation only mode is being used.)
709: --
710: -- p_object_version_number := null;
711: hr_utility.set_location(' Leaving:'||l_proc, 80);
712: when others then
713: --
714: -- A validation or unexpected error has occured
715: --
718: -- Reset IN OUT parameters and set all
719: -- OUT parameters, including warnings, to null
720: --
721: -- p_object_version_number := null;
722: hr_utility.set_location(' Leaving:'||l_proc, 90);
723: raise;
724: end delete_configuration_value;
725: --
726: end pqp_pcv_api;