DBA Data[Home] [Help]

APPS.BEN_EXT_CRIT_VAL_API dependencies on BEN_EXT_CRIT_VAL

Line 1: Package Body ben_EXT_CRIT_VAL_api as

1: Package Body ben_EXT_CRIT_VAL_api as
2: /* $Header: bexcvapi.pkb 120.0 2005/05/28 12:27:24 appldev noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: bexcvapi.pkb 120.0 2005/05/28 12:27:24 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_EXT_CRIT_VAL_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_EXT_CRIT_VAL >----------------------|
10: -- ----------------------------------------------------------------------------

Line 27: l_ext_crit_val_id ben_ext_crit_val.ext_crit_val_id%TYPE;

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

Line 29: l_object_version_number ben_ext_crit_val.object_version_number%TYPE;

25: -- Declare cursors and local variables
26: --
27: l_ext_crit_val_id ben_ext_crit_val.ext_crit_val_id%TYPE;
28: l_proc varchar2(72) := g_package||'create_EXT_CRIT_VAL';
29: l_object_version_number ben_ext_crit_val.object_version_number%TYPE;
30: --
31: begin
32: --
33: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 47: ben_EXT_CRIT_VAL_bk1.create_EXT_CRIT_VAL_b

43: begin
44: --
45: -- Start of API User Hook for the before hook of create_EXT_CRIT_VAL
46: --
47: ben_EXT_CRIT_VAL_bk1.create_EXT_CRIT_VAL_b
48: (
49: p_val_1 => p_val_1
50: ,p_val_2 => p_val_2
51: ,p_ext_crit_typ_id => p_ext_crit_typ_id

Line 85: ben_EXT_CRIT_VAL_bk1.create_EXT_CRIT_VAL_a

81: begin
82: --
83: -- Start of API User Hook for the after hook of create_EXT_CRIT_VAL
84: --
85: ben_EXT_CRIT_VAL_bk1.create_EXT_CRIT_VAL_a
86: (
87: p_ext_crit_val_id => l_ext_crit_val_id
88: ,p_val_1 => p_val_1
89: ,p_val_2 => p_val_2

Line 174: l_object_version_number ben_ext_crit_val.object_version_number%TYPE;

170: --
171: -- Declare cursors and local variables
172: --
173: l_proc varchar2(72) := g_package||'update_EXT_CRIT_VAL';
174: l_object_version_number ben_ext_crit_val.object_version_number%TYPE;
175: --
176: begin
177: --
178: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 194: ben_EXT_CRIT_VAL_bk2.update_EXT_CRIT_VAL_b

190: begin
191: --
192: -- Start of API User Hook for the before hook of update_EXT_CRIT_VAL
193: --
194: ben_EXT_CRIT_VAL_bk2.update_EXT_CRIT_VAL_b
195: (
196: p_ext_crit_val_id => p_ext_crit_val_id
197: ,p_val_1 => p_val_1
198: ,p_val_2 => p_val_2

Line 233: ben_EXT_CRIT_VAL_bk2.update_EXT_CRIT_VAL_a

229: begin
230: --
231: -- Start of API User Hook for the after hook of update_EXT_CRIT_VAL
232: --
233: ben_EXT_CRIT_VAL_bk2.update_EXT_CRIT_VAL_a
234: (
235: p_ext_crit_val_id => p_ext_crit_val_id
236: ,p_val_1 => p_val_1
237: ,p_val_2 => p_val_2

Line 312: l_object_version_number ben_ext_crit_val.object_version_number%TYPE;

308: --
309: -- Declare cursors and local variables
310: --
311: l_proc varchar2(72) := g_package||'update_EXT_CRIT_VAL';
312: l_object_version_number ben_ext_crit_val.object_version_number%TYPE;
313: --
314: begin
315: --
316: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 333: ben_EXT_CRIT_VAL_bk3.delete_EXT_CRIT_VAL_b

329: begin
330: --
331: -- Start of API User Hook for the before hook of delete_EXT_CRIT_VAL
332: --
333: ben_EXT_CRIT_VAL_bk3.delete_EXT_CRIT_VAL_b
334: (
335: p_ext_crit_val_id => p_ext_crit_val_id
336: ,p_legislation_code => p_legislation_code
337: ,p_object_version_number => p_object_version_number

Line 361: ben_EXT_CRIT_VAL_bk3.delete_EXT_CRIT_VAL_a

357: begin
358: --
359: -- Start of API User Hook for the after hook of delete_EXT_CRIT_VAL
360: --
361: ben_EXT_CRIT_VAL_bk3.delete_EXT_CRIT_VAL_a
362: (
363: p_ext_crit_val_id => p_ext_crit_val_id
364: ,p_legislation_code => p_legislation_code
365: ,p_object_version_number => l_object_version_number

Line 446: end ben_EXT_CRIT_VAL_api;

442: hr_utility.set_location(' Leaving:'||l_proc, 70);
443: --
444: end lck;
445: --
446: end ben_EXT_CRIT_VAL_api;