[Home] [Help]
46: l_effective_date date;
47: l_use_count number := 0;
48: l_name ame_attributes.name%type;
49: begin
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: --
52: l_name := upper(p_name);
53: --
54: -- Issue a savepoint
151: p_atu_start_date := l_atu_start_date;
152: p_atu_end_date := l_atu_end_date;
153: end if;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 70);
156: exception
157: when hr_api.validate_enabled then
158: --
159: -- As the Validate_Enabled exception has been raised
173: p_atu_object_version_number := null;
174: p_atu_start_date := null;
175: p_atu_end_date := null;
176: end if;
177: hr_utility.set_location(' Leaving:'||l_proc, 80);
178: when others then
179: --
180: -- A validation or unexpected error has occured
181: --
192: p_atu_object_version_number:= null;
193: p_atu_start_date := null;
194: p_atu_end_date := null;
195: end if;
196: hr_utility.set_location(' Leaving:'||l_proc, 90);
197: raise;
198: end create_ame_attribute;
199: --
200: -- ----------------------------------------------------------------------------
228: l_use_count number := 0;
229: l_validation_start_date date;
230: l_validation_end_date date;
231: begin
232: hr_utility.set_location('Entering:'|| l_proc, 10);
233: --
234: -- Issue a savepoint
235: --
236: savepoint create_ame_attribute_usage;
305: p_object_version_number := l_atu_object_version_number;
306: p_start_date := l_atu_start_date;
307: p_end_date := l_atu_end_date;
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 70);
310: exception
311: when hr_api.validate_enabled then
312: --
313: -- As the Validate_Enabled exception has been raised
321: --
322: p_object_version_number := null;
323: p_start_date := null;
324: p_end_date := null;
325: hr_utility.set_location(' Leaving:'||l_proc, 80);
326: when others then
327: --
328: -- A validation or unexpected error has occured
329: --
334: --
335: p_object_version_number := null;
336: p_start_date := null;
337: p_end_date := null;
338: hr_utility.set_location(' Leaving:'||l_proc, 90);
339: raise;
340: end create_ame_attribute_usage;
341: --
342: --
361: l_atr_end_date date;
362: l_effective_date date;
363: l_proc varchar2(72) := g_package||'update_ame_attribute';
364: begin
365: hr_utility.set_location('Entering:'|| l_proc, 10);
366: --
367: -- Issue a savepoint
368: --
369: savepoint update_ame_attribute;
436: p_object_version_number := l_atr_object_version_number;
437: p_start_date := l_atr_start_date;
438: p_end_date := l_atr_end_date;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 70);
441: exception
442: when hr_api.validate_enabled then
443: --
444: -- As the Validate_Enabled exception has been raised
451: -- when validation only mode is being used.)
452: --
453: p_start_date := null;
454: p_end_date := null;
455: hr_utility.set_location(' Leaving:'||l_proc, 80);
456: when others then
457: --
458: -- A validation or unexpected error has occured
459: --
463: -- OUT parameters, including warnings, to null
464: --
465: p_start_date := null;
466: p_end_date := null;
467: hr_utility.set_location(' Leaving:'||l_proc, 90);
468: raise;
469: end update_ame_attribute;
470: --
471: --
492: l_atu_end_date date;
493: l_effective_date date;
494: l_proc varchar2(72) := g_package||'update_ame_attribute_usage';
495: begin
496: hr_utility.set_location('Entering:'|| l_proc, 10);
497: --
498: -- Issue a savepoint
499: --
500: savepoint update_ame_attribute_usage;
568: p_object_version_number := l_atu_object_version_number;
569: p_start_date := l_atu_start_date;
570: p_end_date := l_atu_end_date;
571: --
572: hr_utility.set_location(' Leaving:'||l_proc, 70);
573: exception
574: when hr_api.validate_enabled then
575: --
576: -- As the Validate_Enabled exception has been raised
583: -- when validation only mode is being used.)
584: --
585: p_start_date := null;
586: p_end_date := null;
587: hr_utility.set_location(' Leaving:'||l_proc, 80);
588: when others then
589: --
590: -- A validation or unexpected error has occured
591: --
595: -- OUT parameters, including warnings, to null
596: --
597: p_start_date := null;
598: p_end_date := null;
599: hr_utility.set_location(' Leaving:'||l_proc, 90);
600: raise;
601: end update_ame_attribute_usage;
602: --
603: -- ----------------------------------------------------------------------------
645: nvl(end_date - ame_util.oneSecond, sysdate) ;
646:
647: begin
648:
649: hr_utility.set_location('Entering:'|| l_proc, 10);
650: --
651: -- Issue a savepoint
652: --
653: savepoint delete_ame_attribute_usage;
763: p_object_version_number := l_atu_object_version_number;
764: p_start_date := l_atu_start_date;
765: p_end_date := l_atu_end_date;
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 70);
768: exception
769: when hr_api.validate_enabled then
770: --
771: -- As the Validate_Enabled exception has been raised
778: -- when validation only mode is being used.)
779: --
780: p_start_date := null;
781: p_end_date := null;
782: hr_utility.set_location(' Leaving:'||l_proc, 80);
783: when others then
784: --
785: -- A validation or unexpected error has occured
786: --
790: -- OUT parameters, including warnings, to null
791: --
792: p_start_date := null;
793: p_end_date := null;
794: hr_utility.set_location(' Leaving:'||l_proc, 90);
795: raise;
796: end delete_ame_attribute_usage;
797: --+
798: --+