1: Package Body ben_batch_ranges_api as
2: /* $Header: beranapi.pkb 115.4 2002/12/11 11:34:54 lakrish ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: beranapi.pkb 115.4 2002/12/11 11:34:54 lakrish ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_batch_ranges_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_batch_ranges >---------------------------|
10: -- ----------------------------------------------------------------------------
20: ,p_effective_date in date) is
21: --
22: -- Declare cursors and local variables
23: --
24: l_range_id ben_batch_ranges.range_id%TYPE;
25: l_proc varchar2(72) := g_package||'create_batch_ranges';
26: l_object_version_number ben_batch_ranges.object_version_number%TYPE;
27: --
28: begin
22: -- Declare cursors and local variables
23: --
24: l_range_id ben_batch_ranges.range_id%TYPE;
25: l_proc varchar2(72) := g_package||'create_batch_ranges';
26: l_object_version_number ben_batch_ranges.object_version_number%TYPE;
27: --
28: begin
29: --
30: hr_utility.set_location('Entering:'|| l_proc, 10);
107: --
108: -- Declare cursors and local variables
109: --
110: l_proc varchar2(72) := g_package||'update_batch_ranges';
111: l_object_version_number ben_batch_ranges.object_version_number%TYPE;
112: --
113: begin
114: --
115: hr_utility.set_location('Entering:'|| l_proc, 10);
182: --
183: -- Declare cursors and local variables
184: --
185: l_proc varchar2(72) := g_package||'update_batch_ranges';
186: l_object_version_number ben_batch_ranges.object_version_number%TYPE;
187: --
188: begin
189: --
190: hr_utility.set_location('Entering:'|| l_proc, 10);
261: hr_utility.set_location(' Leaving:'||l_proc, 70);
262: --
263: end lck;
264: --
265: end ben_batch_ranges_api;