1: Package Body ben_EXT_INCL_DATA_ELMT_api as
2: /* $Header: bexidapi.pkb 115.4 2002/12/16 07:24:26 rpgupta ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: bexidapi.pkb 115.4 2002/12/16 07:24:26 rpgupta ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_EXT_INCL_DATA_ELMT_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_EXT_INCL_DATA_ELMT >----------------------|
10: -- ----------------------------------------------------------------------------
21: ) is
22: --
23: -- Declare cursors and local variables
24: --
25: l_ext_incl_data_elmt_id ben_ext_incl_data_elmt.ext_incl_data_elmt_id%TYPE;
26: l_proc varchar2(72) := g_package||'create_EXT_INCL_DATA_ELMT';
27: l_object_version_number ben_ext_incl_data_elmt.object_version_number%TYPE;
28: --
29: begin
23: -- Declare cursors and local variables
24: --
25: l_ext_incl_data_elmt_id ben_ext_incl_data_elmt.ext_incl_data_elmt_id%TYPE;
26: l_proc varchar2(72) := g_package||'create_EXT_INCL_DATA_ELMT';
27: l_object_version_number ben_ext_incl_data_elmt.object_version_number%TYPE;
28: --
29: begin
30: --
31: hr_utility.set_location('Entering:'|| l_proc, 10);
41: begin
42: --
43: -- Start of API User Hook for the before hook of create_EXT_INCL_DATA_ELMT
44: --
45: ben_EXT_INCL_DATA_ELMT_bk1.create_EXT_INCL_DATA_ELMT_b
46: (
47: p_ext_rcd_in_file_id => p_ext_rcd_in_file_id
48: ,p_ext_data_elmt_id => p_ext_data_elmt_id
49: ,p_business_group_id => p_business_group_id
76: begin
77: --
78: -- Start of API User Hook for the after hook of create_EXT_INCL_DATA_ELMT
79: --
80: ben_EXT_INCL_DATA_ELMT_bk1.create_EXT_INCL_DATA_ELMT_a
81: (
82: p_ext_incl_data_elmt_id => l_ext_incl_data_elmt_id
83: ,p_ext_rcd_in_file_id => p_ext_rcd_in_file_id
84: ,p_ext_data_elmt_id => p_ext_data_elmt_id
157: --
158: -- Declare cursors and local variables
159: --
160: l_proc varchar2(72) := g_package||'update_EXT_INCL_DATA_ELMT';
161: l_object_version_number ben_ext_incl_data_elmt.object_version_number%TYPE;
162: --
163: begin
164: --
165: hr_utility.set_location('Entering:'|| l_proc, 10);
177: begin
178: --
179: -- Start of API User Hook for the before hook of update_EXT_INCL_DATA_ELMT
180: --
181: ben_EXT_INCL_DATA_ELMT_bk2.update_EXT_INCL_DATA_ELMT_b
182: (
183: p_ext_incl_data_elmt_id => p_ext_incl_data_elmt_id
184: ,p_ext_rcd_in_file_id => p_ext_rcd_in_file_id
185: ,p_ext_data_elmt_id => p_ext_data_elmt_id
213: begin
214: --
215: -- Start of API User Hook for the after hook of update_EXT_INCL_DATA_ELMT
216: --
217: ben_EXT_INCL_DATA_ELMT_bk2.update_EXT_INCL_DATA_ELMT_a
218: (
219: p_ext_incl_data_elmt_id => p_ext_incl_data_elmt_id
220: ,p_ext_rcd_in_file_id => p_ext_rcd_in_file_id
221: ,p_ext_data_elmt_id => p_ext_data_elmt_id
285: --
286: -- Declare cursors and local variables
287: --
288: l_proc varchar2(72) := g_package||'update_EXT_INCL_DATA_ELMT';
289: l_object_version_number ben_ext_incl_data_elmt.object_version_number%TYPE;
290: --
291: begin
292: --
293: hr_utility.set_location('Entering:'|| l_proc, 10);
306: begin
307: --
308: -- Start of API User Hook for the before hook of delete_EXT_INCL_DATA_ELMT
309: --
310: ben_EXT_INCL_DATA_ELMT_bk3.delete_EXT_INCL_DATA_ELMT_b
311: (
312: p_ext_incl_data_elmt_id => p_ext_incl_data_elmt_id
313: ,p_legislation_code => p_legislation_code
314: ,p_object_version_number => p_object_version_number
334: begin
335: --
336: -- Start of API User Hook for the after hook of delete_EXT_INCL_DATA_ELMT
337: --
338: ben_EXT_INCL_DATA_ELMT_bk3.delete_EXT_INCL_DATA_ELMT_a
339: (
340: p_ext_incl_data_elmt_id => p_ext_incl_data_elmt_id
341: ,p_legislation_code => p_legislation_code
342: ,p_object_version_number => l_object_version_number
413: hr_utility.set_location(' Leaving:'||l_proc, 70);
414: --
415: end lck;
416: --
417: end ben_EXT_INCL_DATA_ELMT_api;