1: Package Body ben_cwb_matrix_api as
2: /* $Header: bebcmapi.pkb 115.2 2003/03/10 14:38:58 ssrayapu noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: bebcmapi.pkb 115.2 2003/03/10 14:38:58 ssrayapu noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_cwb_matrix_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_cwb_matrix >---------------------------|
10: -- ----------------------------------------------------------------------------
25: ) is
26: --
27: -- Declare cursors and local variables
28: --
29: l_cwb_matrix_id ben_cwb_matrix.cwb_matrix_id%TYPE;
30: l_object_version_number ben_cwb_matrix.object_version_number%TYPE;
31: l_proc varchar2(72) := g_package||'create_cwb_matrix';
32: --
33: begin
26: --
27: -- Declare cursors and local variables
28: --
29: l_cwb_matrix_id ben_cwb_matrix.cwb_matrix_id%TYPE;
30: l_object_version_number ben_cwb_matrix.object_version_number%TYPE;
31: l_proc varchar2(72) := g_package||'create_cwb_matrix';
32: --
33: begin
34: hr_utility.set_location('Entering:'|| l_proc, 10);
39: --
40: -- Call Before Process User Hook
41: --
42: begin
43: ben_cwb_matrix_bk1.create_cwb_matrix_b
44: (p_effective_date => p_effective_date
45: ,p_business_group_id => p_business_group_id
46: ,p_name => p_name
47: ,p_plan_id => p_plan_id
78: --
79: -- Call After Process User Hook
80: --
81: begin
82: ben_cwb_matrix_bk1.create_cwb_matrix_a
83: (p_effective_date => p_effective_date
84: ,p_business_group_id => p_business_group_id
85: ,p_name => p_name
86: ,p_plan_id => p_plan_id
162: ) is
163: --
164: -- Declare cursors and local variables
165: --
166: l_object_version_number ben_cwb_matrix.object_version_number%TYPE;
167: l_proc varchar2(72) := g_package||'update_cwb_matrix';
168: --
169: begin
170: hr_utility.set_location('Entering:'|| l_proc, 10);
181: --
182: -- Call Before Process User Hook
183: --
184: begin
185: ben_cwb_matrix_bk2.update_cwb_matrix_b
186: (p_cwb_matrix_id => p_cwb_matrix_id
187: ,p_effective_date => p_effective_date
188: ,p_business_group_id => p_business_group_id
189: ,p_name => p_name
226: begin
227: --
228: -- Start of API User Hook for the after hook of update_cwb_matrix
229: --
230: ben_cwb_matrix_bk2.update_cwb_matrix_a
231: (p_cwb_matrix_id => p_cwb_matrix_id
232: ,p_name => p_name
233: ,p_effective_date => p_effective_date
234: ,p_plan_id => p_plan_id
300: ) is
301: --
302: -- Declare cursors and local variables
303: --
304: l_object_version_number ben_cwb_matrix.object_version_number%TYPE;
305: l_proc varchar2(72) := g_package||'delete_cwb_matrix';
306: --
307: begin
308: hr_utility.set_location('Entering:'|| l_proc, 10);
319: --
320: -- Call Before Process User Hook
321: --
322: begin
323: ben_cwb_matrix_bk3.delete_cwb_matrix_b
324: (p_cwb_matrix_id => p_cwb_matrix_id
325: ,p_effective_date => p_effective_date
326: ,p_object_version_number => p_object_version_number
327: );
346: begin
347: --
348: -- Start of API User Hook for the after hook of delete_cwb_matrix
349: --
350: ben_cwb_matrix_bk3.delete_cwb_matrix_a
351: (p_cwb_matrix_id => p_cwb_matrix_id
352: ,p_effective_date => p_effective_date
353: ,p_object_version_number => l_object_version_number
354: );
423: hr_utility.set_location(' Leaving:'||l_proc, 70);
424: --
425: end lck;
426: --
427: end ben_cwb_matrix_api;