[Home] [Help]
25: l_vac_rec_area_id number;
26: l_object_version_number number;
27: l_proc varchar2(72) := g_package||'create_vac_rec_area_value';
28: begin
29: hr_utility.set_location('Entering:'|| l_proc, 10);
30: --
31: -- Issue a savepoint
32: --
33: savepoint create_vac_rec_area_value;
97: --
98: p_vac_rec_area_id := l_vac_rec_area_id;
99: p_object_version_number := l_object_version_number;
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 70);
102: exception
103: when hr_api.validate_enabled then
104: --
105: -- As the Validate_Enabled exception has been raised
113: --
114: p_vac_rec_area_id := null;
115: p_object_version_number := null;
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 80);
118: when others then
119: --
120: --
121: -- A validation or unexpected error has occured
127: --
128: p_vac_rec_area_id := null;
129: p_object_version_number := null;
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 90);
132: raise;
133: end create_vac_rec_area_value;
134: --
135: -- ----------------------------------------------------------------------------
186: l_location_pref_id number;
187: l_object_version_number number;
188: l_proc varchar2(72) := g_package||'create_location_preference';
189: begin
190: hr_utility.set_location('Entering:'|| l_proc, 10);
191: --
192: -- Issue a savepoint
193: --
194: savepoint create_location_preference;
360: --
361: p_location_pref_id := l_location_pref_id;
362: p_object_version_number := l_object_version_number;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 70);
365: exception
366: when hr_api.validate_enabled then
367: --
368: -- As the Validate_Enabled exception has been raised
376: --
377: p_location_pref_id := null;
378: p_object_version_number := null;
379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 80);
381: when others then
382: --
383: --
384: -- A validation or unexpected error has occured
390: --
391: p_location_pref_id := null;
392: p_object_version_number := null;
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 90);
395: raise;
396: end create_location_preference;
397: --
398: -- ----------------------------------------------------------------------------
410: l_in_out_parameter number;
411: l_effective_date date;
412: l_proc varchar2(72) := g_package||'delete_vac_rec_area_value';
413: begin
414: hr_utility.set_location('Entering:'|| l_proc, 10);
415: --
416: -- Issue a savepoint
417: --
418: savepoint delete_vac_rec_area_value;
461: if p_validate then
462: raise hr_api.validate_enabled;
463: end if;
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 70);
466: exception
467: when hr_api.validate_enabled then
468: --
469: -- As the Validate_Enabled exception has been raised
470: -- we must rollback to the savepoint
471: --
472: rollback to delete_vac_rec_area_value;
473: --
474: hr_utility.set_location(' Leaving:'||l_proc, 80);
475: when others then
476: --
477: -- A validation or unexpected error has occured
478: --
477: -- A validation or unexpected error has occured
478: --
479: rollback to delete_vac_rec_area_value;
480: --
481: hr_utility.set_location(' Leaving:'||l_proc, 90);
482: raise;
483: end delete_vac_rec_area_value;
484: --
485: -- ----------------------------------------------------------------------------
497: l_in_out_parameter number;
498: l_effective_date date;
499: l_proc varchar2(72) := g_package||'delete_location_preference';
500: begin
501: hr_utility.set_location('Entering:'|| l_proc, 10);
502: --
503: -- Issue a savepoint
504: --
505: savepoint delete_location_preference;
548: if p_validate then
549: raise hr_api.validate_enabled;
550: end if;
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 70);
553: exception
554: when hr_api.validate_enabled then
555: --
556: -- As the Validate_Enabled exception has been raised
557: -- we must rollback to the savepoint
558: --
559: rollback to delete_location_preference;
560: --
561: hr_utility.set_location(' Leaving:'||l_proc, 80);
562: when others then
563: --
564: -- A validation or unexpected error has occured
565: --
564: -- A validation or unexpected error has occured
565: --
566: rollback to delete_location_preference;
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 90);
569: raise;
570: end delete_location_preference;
571: --
572: -- ----------------------------------------------------------------------------
589: l_object_version_number number;
590: l_proc varchar2(72) := g_package||'update_vac_rec_area_value';
591: --
592: begin
593: hr_utility.set_location('Entering:'|| l_proc, 10);
594: --
595: -- Issue a savepoint
596: --
597: savepoint update_vac_rec_area_value;
659: -- Set all IN OUT and OUT parameters with out values
660: --
661: p_object_version_number := l_object_version_number;
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 70);
664: exception
665: when hr_api.validate_enabled then
666: --
667: -- As the Validate_Enabled exception has been raised
674: -- when validation only mode is being used.)
675: --
676: p_object_version_number := l_object_version_number;
677: --
678: hr_utility.set_location(' Leaving:'||l_proc, 80);
679: when others then
680: --
681: --
682: -- A validation or unexpected error has occured
687: -- OUT parameters, including warnings, to null
688: --
689: p_object_version_number := l_object_version_number;
690: --
691: hr_utility.set_location(' Leaving:'||l_proc, 90);
692: raise;
693: end update_vac_rec_area_value;
694: --
695: end IRC_LOCATION_PREFERENCES_API;