DBA Data[Home] [Help]

APPS.BEN_CWB_MATRIX_API dependencies on BEN_CWB_MATRIX

Line 1: Package Body ben_cwb_matrix_api as

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: --

Line 6: g_package varchar2(33) := ' ben_cwb_matrix_api.';

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: -- ----------------------------------------------------------------------------

Line 29: l_cwb_matrix_id ben_cwb_matrix.cwb_matrix_id%TYPE;

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

Line 30: l_object_version_number ben_cwb_matrix.object_version_number%TYPE;

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);

Line 43: ben_cwb_matrix_bk1.create_cwb_matrix_b

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

Line 82: ben_cwb_matrix_bk1.create_cwb_matrix_a

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

Line 166: l_object_version_number ben_cwb_matrix.object_version_number%TYPE;

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);

Line 185: ben_cwb_matrix_bk2.update_cwb_matrix_b

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

Line 230: ben_cwb_matrix_bk2.update_cwb_matrix_a

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

Line 304: l_object_version_number ben_cwb_matrix.object_version_number%TYPE;

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);

Line 323: ben_cwb_matrix_bk3.delete_cwb_matrix_b

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: );

Line 350: ben_cwb_matrix_bk3.delete_cwb_matrix_a

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: );

Line 427: end ben_cwb_matrix_api;

423: hr_utility.set_location(' Leaving:'||l_proc, 70);
424: --
425: end lck;
426: --
427: end ben_cwb_matrix_api;