DBA Data[Home] [Help]

APPS.BEN_CWB_MATRIX_DTL_API dependencies on BEN_CWB_MATRIX_DTL

Line 1: Package Body ben_cwb_matrix_dtl_api as

1: Package Body ben_cwb_matrix_dtl_api as
2: /* $Header: bebcdapi.pkb 120.0 2005/05/28 00:34:22 appldev noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: bebcdapi.pkb 120.0 2005/05/28 00:34:22 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_cwb_matrix_dtl_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_cwb_matrix_dtl >------------------------|
10: -- ----------------------------------------------------------------------------

Line 27: l_cwb_matrix_dtl_id ben_cwb_matrix_dtl.cwb_matrix_dtl_id%TYPE;

23: ) is
24: --
25: -- Declare cursors and local variables
26: --
27: l_cwb_matrix_dtl_id ben_cwb_matrix_dtl.cwb_matrix_dtl_id%TYPE;
28: l_object_version_number ben_cwb_matrix_dtl.object_version_number%TYPE;
29: l_proc varchar2(72) := g_package||'create_cwb_matrix_dtl';
30: --
31: begin

Line 28: l_object_version_number ben_cwb_matrix_dtl.object_version_number%TYPE;

24: --
25: -- Declare cursors and local variables
26: --
27: l_cwb_matrix_dtl_id ben_cwb_matrix_dtl.cwb_matrix_dtl_id%TYPE;
28: l_object_version_number ben_cwb_matrix_dtl.object_version_number%TYPE;
29: l_proc varchar2(72) := g_package||'create_cwb_matrix_dtl';
30: --
31: begin
32: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 41: ben_cwb_matrix_dtl_bk1.create_cwb_matrix_dtl_b

37: --
38: -- Call Before Process User Hook
39: --
40: begin
41: ben_cwb_matrix_dtl_bk1.create_cwb_matrix_dtl_b
42: (p_cwb_matrix_id => p_cwb_matrix_id
43: ,p_business_group_id => p_business_group_id
44: ,p_row_crit_val => p_row_crit_val
45: ,p_col_crit_val => p_col_crit_val

Line 75: ben_cwb_matrix_dtl_bk1.create_cwb_matrix_dtl_a

71: --
72: -- Call After Process User Hook
73: --
74: begin
75: ben_cwb_matrix_dtl_bk1.create_cwb_matrix_dtl_a
76: (p_cwb_matrix_dtl_id => l_cwb_matrix_dtl_id
77: ,p_cwb_matrix_id => p_cwb_matrix_id
78: ,p_business_group_id => p_business_group_id
79: ,p_row_crit_val => p_row_crit_val

Line 154: l_object_version_number ben_cwb_matrix_dtl.object_version_number%TYPE;

150: ) is
151: --
152: -- Declare cursors and local variables
153: --
154: l_object_version_number ben_cwb_matrix_dtl.object_version_number%TYPE;
155: l_proc varchar2(72) := g_package||'update_cwb_matrix_dtl';
156: --
157: begin
158: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 173: ben_cwb_matrix_dtl_bk2.update_cwb_matrix_dtl_b

169: --
170: -- Call Before Process User Hook
171: --
172: begin
173: ben_cwb_matrix_dtl_bk2.update_cwb_matrix_dtl_b
174: (p_cwb_matrix_dtl_id => p_cwb_matrix_dtl_id
175: ,p_cwb_matrix_id => p_cwb_matrix_id
176: ,p_business_group_id => p_business_group_id
177: ,p_row_crit_val => p_row_crit_val

Line 213: ben_cwb_matrix_dtl_bk2.update_cwb_matrix_dtl_a

209: begin
210: --
211: -- Start of API User Hook for the after hook of update_cwb_matrix_dtl
212: --
213: ben_cwb_matrix_dtl_bk2.update_cwb_matrix_dtl_a
214: (p_cwb_matrix_dtl_id => p_cwb_matrix_dtl_id
215: ,p_cwb_matrix_id => p_cwb_matrix_id
216: ,p_business_group_id => p_business_group_id
217: ,p_row_crit_val => p_row_crit_val

Line 284: l_object_version_number ben_cwb_matrix_dtl.object_version_number%TYPE;

280: ) is
281: --
282: -- Declare cursors and local variables
283: --
284: l_object_version_number ben_cwb_matrix_dtl.object_version_number%TYPE;
285: l_proc varchar2(72) := g_package||'delete_cwb_matrix_dtl';
286: --
287: begin
288: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 303: ben_cwb_matrix_dtl_bk3.delete_cwb_matrix_dtl_b

299: --
300: -- Call Before Process User Hook
301: --
302: begin
303: ben_cwb_matrix_dtl_bk3.delete_cwb_matrix_dtl_b
304: (p_cwb_matrix_dtl_id => p_cwb_matrix_dtl_id
305: ,p_object_version_number => p_object_version_number
306: );
307:

Line 329: ben_cwb_matrix_dtl_bk3.delete_cwb_matrix_dtl_a

325: begin
326: --
327: -- Start of API User Hook for the after hook of delete_cwb_matrix_dtl
328: --
329: ben_cwb_matrix_dtl_bk3.delete_cwb_matrix_dtl_a
330: (p_cwb_matrix_dtl_id => p_cwb_matrix_dtl_id
331: ,p_object_version_number => l_object_version_number
332: );
333:

Line 406: end ben_cwb_matrix_dtl_api;

402: hr_utility.set_location(' Leaving:'||l_proc, 70);
403: --
404: end lck;
405: --
406: end ben_cwb_matrix_dtl_api;