1: Package Body ben_batch_bnft_cert_info_api as
2: /* $Header: bebciapi.pkb 115.4 2002/12/16 10:30:08 rpgupta ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: bebciapi.pkb 115.4 2002/12/16 10:30:08 rpgupta ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_batch_bnft_cert_info_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_batch_bnft_cert_info >----------------------|
10: -- ----------------------------------------------------------------------------
22: ) is
23: --
24: -- Declare cursors and local variables
25: --
26: l_batch_benft_cert_id ben_batch_bnft_cert_info.batch_benft_cert_id%TYPE;
27: l_proc varchar2(72) := g_package||'create_batch_bnft_cert_info';
28: l_object_version_number ben_batch_bnft_cert_info.object_version_number%TYPE;
29: --
30: begin
24: -- Declare cursors and local variables
25: --
26: l_batch_benft_cert_id ben_batch_bnft_cert_info.batch_benft_cert_id%TYPE;
27: l_proc varchar2(72) := g_package||'create_batch_bnft_cert_info';
28: l_object_version_number ben_batch_bnft_cert_info.object_version_number%TYPE;
29: --
30: begin
31: --
32: hr_utility.set_location('Entering:'|| l_proc, 10);
42: begin
43: --
44: -- Start of API User Hook for the before hook of create_batch_bnft_cert_info
45: --
46: ben_batch_bnft_cert_info_bk1.create_batch_bnft_cert_info_b
47: (
48: p_benefit_action_id => p_benefit_action_id
49: ,p_person_id => p_person_id
50: ,p_actn_typ_id => p_actn_typ_id
79: begin
80: --
81: -- Start of API User Hook for the after hook of create_batch_bnft_cert_info
82: --
83: ben_batch_bnft_cert_info_bk1.create_batch_bnft_cert_info_a
84: (
85: p_batch_benft_cert_id => l_batch_benft_cert_id
86: ,p_benefit_action_id => p_benefit_action_id
87: ,p_person_id => p_person_id
162: --
163: -- Declare cursors and local variables
164: --
165: l_proc varchar2(72) := g_package||'update_batch_bnft_cert_info';
166: l_object_version_number ben_batch_bnft_cert_info.object_version_number%TYPE;
167: --
168: begin
169: --
170: hr_utility.set_location('Entering:'|| l_proc, 10);
182: begin
183: --
184: -- Start of API User Hook for the before hook of update_batch_bnft_cert_info
185: --
186: ben_batch_bnft_cert_info_bk2.update_batch_bnft_cert_info_b
187: (
188: p_batch_benft_cert_id => p_batch_benft_cert_id
189: ,p_benefit_action_id => p_benefit_action_id
190: ,p_person_id => p_person_id
220: begin
221: --
222: -- Start of API User Hook for the after hook of update_batch_bnft_cert_info
223: --
224: ben_batch_bnft_cert_info_bk2.update_batch_bnft_cert_info_a
225: (
226: p_batch_benft_cert_id => p_batch_benft_cert_id
227: ,p_benefit_action_id => p_benefit_action_id
228: ,p_person_id => p_person_id
294: --
295: -- Declare cursors and local variables
296: --
297: l_proc varchar2(72) := g_package||'update_batch_bnft_cert_info';
298: l_object_version_number ben_batch_bnft_cert_info.object_version_number%TYPE;
299: --
300: begin
301: --
302: hr_utility.set_location('Entering:'|| l_proc, 10);
315: begin
316: --
317: -- Start of API User Hook for the before hook of delete_batch_bnft_cert_info
318: --
319: ben_batch_bnft_cert_info_bk3.delete_batch_bnft_cert_info_b
320: (
321: p_batch_benft_cert_id => p_batch_benft_cert_id
322: ,p_object_version_number => p_object_version_number
323: ,p_effective_date => trunc(p_effective_date)
343: begin
344: --
345: -- Start of API User Hook for the after hook of delete_batch_bnft_cert_info
346: --
347: ben_batch_bnft_cert_info_bk3.delete_batch_bnft_cert_info_a
348: (
349: p_batch_benft_cert_id => p_batch_benft_cert_id
350: ,p_object_version_number => l_object_version_number
351: ,p_effective_date => trunc(p_effective_date)
425: hr_utility.set_location(' Leaving:'||l_proc, 70);
426: --
427: end lck;
428: --
429: end ben_batch_bnft_cert_info_api;