1: Package Body ben_batch_elig_info_api as
2: /* $Header: bebeiapi.pkb 115.3 2002/12/23 12:33:01 nhunur ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: bebeiapi.pkb 115.3 2002/12/23 12:33:01 nhunur ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_batch_elig_info_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_batch_elig_info >------------------------|
10: -- ----------------------------------------------------------------------------
24: ,p_effective_date in date) is
25: --
26: -- Declare cursors and local variables
27: --
28: l_batch_elig_id ben_batch_elig_info.batch_elig_id%TYPE;
29: l_proc varchar2(72) := g_package||'create_batch_elig_info';
30: l_object_version_number ben_batch_elig_info.object_version_number%TYPE;
31: --
32: begin
26: -- Declare cursors and local variables
27: --
28: l_batch_elig_id ben_batch_elig_info.batch_elig_id%TYPE;
29: l_proc varchar2(72) := g_package||'create_batch_elig_info';
30: l_object_version_number ben_batch_elig_info.object_version_number%TYPE;
31: --
32: begin
33: --
34: hr_utility.set_location('Entering:'|| l_proc, 10);
44: begin
45: --
46: -- Start of API User Hook for the before hook of create_batch_elig_info
47: --
48: ben_batch_elig_info_bk1.create_batch_elig_info_b
49: (p_benefit_action_id => p_benefit_action_id
50: ,p_person_id => p_person_id
51: ,p_pgm_id => p_pgm_id
52: ,p_pl_id => p_pl_id
84: begin
85: --
86: -- Start of API User Hook for the after hook of create_batch_elig_info
87: --
88: ben_batch_elig_info_bk1.create_batch_elig_info_a
89: (p_batch_elig_id => l_batch_elig_id
90: ,p_benefit_action_id => p_benefit_action_id
91: ,p_person_id => p_person_id
92: ,p_pgm_id => p_pgm_id
173: --
174: -- Declare cursors and local variables
175: --
176: l_proc varchar2(72) := g_package||'update_batch_elig_info';
177: l_object_version_number ben_batch_elig_info.object_version_number%TYPE;
178: --
179: begin
180: --
181: hr_utility.set_location('Entering:'|| l_proc, 10);
193: begin
194: --
195: -- Start of API User Hook for the before hook of update_batch_elig_info
196: --
197: ben_batch_elig_info_bk2.update_batch_elig_info_b
198: (p_batch_elig_id => p_batch_elig_id
199: ,p_benefit_action_id => p_benefit_action_id
200: ,p_person_id => p_person_id
201: ,p_pgm_id => p_pgm_id
234: begin
235: --
236: -- Start of API User Hook for the after hook of update_batch_elig_info
237: --
238: ben_batch_elig_info_bk2.update_batch_elig_info_a
239: (p_batch_elig_id => p_batch_elig_id
240: ,p_benefit_action_id => p_benefit_action_id
241: ,p_person_id => p_person_id
242: ,p_pgm_id => p_pgm_id
310: --
311: -- Declare cursors and local variables
312: --
313: l_proc varchar2(72) := g_package||'update_batch_elig_info';
314: l_object_version_number ben_batch_elig_info.object_version_number%TYPE;
315: --
316: begin
317: --
318: hr_utility.set_location('Entering:'|| l_proc, 10);
331: begin
332: --
333: -- Start of API User Hook for the before hook of delete_batch_elig_info
334: --
335: ben_batch_elig_info_bk3.delete_batch_elig_info_b
336: (p_batch_elig_id => p_batch_elig_id
337: ,p_object_version_number => p_object_version_number
338: ,p_effective_date => trunc(p_effective_date));
339: --
357: begin
358: --
359: -- Start of API User Hook for the after hook of delete_batch_elig_info
360: --
361: ben_batch_elig_info_bk3.delete_batch_elig_info_a
362: (p_batch_elig_id => p_batch_elig_id
363: ,p_object_version_number => l_object_version_number
364: ,p_effective_date => trunc(p_effective_date));
365: --
434: hr_utility.set_location(' Leaving:'||l_proc, 70);
435: --
436: end lck;
437: --
438: end ben_batch_elig_info_api;