DBA Data[Home] [Help]

APPS.BEN_BATCH_BNFT_CERT_INFO_API dependencies on BEN_BATCH_BNFT_CERT_INFO

Line 1: Package Body ben_batch_bnft_cert_info_api as

1: Package Body ben_batch_bnft_cert_info_api as
2: /* $Header: bebciapi.pkb 115.4 2002/12/16 10:30:08 rpgupta ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: bebciapi.pkb 115.4 2002/12/16 10:30:08 rpgupta ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_batch_bnft_cert_info_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_batch_bnft_cert_info >----------------------|
10: -- ----------------------------------------------------------------------------

Line 26: l_batch_benft_cert_id ben_batch_bnft_cert_info.batch_benft_cert_id%TYPE;

22: ) is
23: --
24: -- Declare cursors and local variables
25: --
26: l_batch_benft_cert_id ben_batch_bnft_cert_info.batch_benft_cert_id%TYPE;
27: l_proc varchar2(72) := g_package||'create_batch_bnft_cert_info';
28: l_object_version_number ben_batch_bnft_cert_info.object_version_number%TYPE;
29: --
30: begin

Line 28: l_object_version_number ben_batch_bnft_cert_info.object_version_number%TYPE;

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

Line 46: ben_batch_bnft_cert_info_bk1.create_batch_bnft_cert_info_b

42: begin
43: --
44: -- Start of API User Hook for the before hook of create_batch_bnft_cert_info
45: --
46: ben_batch_bnft_cert_info_bk1.create_batch_bnft_cert_info_b
47: (
48: p_benefit_action_id => p_benefit_action_id
49: ,p_person_id => p_person_id
50: ,p_actn_typ_id => p_actn_typ_id

Line 83: ben_batch_bnft_cert_info_bk1.create_batch_bnft_cert_info_a

79: begin
80: --
81: -- Start of API User Hook for the after hook of create_batch_bnft_cert_info
82: --
83: ben_batch_bnft_cert_info_bk1.create_batch_bnft_cert_info_a
84: (
85: p_batch_benft_cert_id => l_batch_benft_cert_id
86: ,p_benefit_action_id => p_benefit_action_id
87: ,p_person_id => p_person_id

Line 166: l_object_version_number ben_batch_bnft_cert_info.object_version_number%TYPE;

162: --
163: -- Declare cursors and local variables
164: --
165: l_proc varchar2(72) := g_package||'update_batch_bnft_cert_info';
166: l_object_version_number ben_batch_bnft_cert_info.object_version_number%TYPE;
167: --
168: begin
169: --
170: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 186: ben_batch_bnft_cert_info_bk2.update_batch_bnft_cert_info_b

182: begin
183: --
184: -- Start of API User Hook for the before hook of update_batch_bnft_cert_info
185: --
186: ben_batch_bnft_cert_info_bk2.update_batch_bnft_cert_info_b
187: (
188: p_batch_benft_cert_id => p_batch_benft_cert_id
189: ,p_benefit_action_id => p_benefit_action_id
190: ,p_person_id => p_person_id

Line 224: ben_batch_bnft_cert_info_bk2.update_batch_bnft_cert_info_a

220: begin
221: --
222: -- Start of API User Hook for the after hook of update_batch_bnft_cert_info
223: --
224: ben_batch_bnft_cert_info_bk2.update_batch_bnft_cert_info_a
225: (
226: p_batch_benft_cert_id => p_batch_benft_cert_id
227: ,p_benefit_action_id => p_benefit_action_id
228: ,p_person_id => p_person_id

Line 298: l_object_version_number ben_batch_bnft_cert_info.object_version_number%TYPE;

294: --
295: -- Declare cursors and local variables
296: --
297: l_proc varchar2(72) := g_package||'update_batch_bnft_cert_info';
298: l_object_version_number ben_batch_bnft_cert_info.object_version_number%TYPE;
299: --
300: begin
301: --
302: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 319: ben_batch_bnft_cert_info_bk3.delete_batch_bnft_cert_info_b

315: begin
316: --
317: -- Start of API User Hook for the before hook of delete_batch_bnft_cert_info
318: --
319: ben_batch_bnft_cert_info_bk3.delete_batch_bnft_cert_info_b
320: (
321: p_batch_benft_cert_id => p_batch_benft_cert_id
322: ,p_object_version_number => p_object_version_number
323: ,p_effective_date => trunc(p_effective_date)

Line 347: ben_batch_bnft_cert_info_bk3.delete_batch_bnft_cert_info_a

343: begin
344: --
345: -- Start of API User Hook for the after hook of delete_batch_bnft_cert_info
346: --
347: ben_batch_bnft_cert_info_bk3.delete_batch_bnft_cert_info_a
348: (
349: p_batch_benft_cert_id => p_batch_benft_cert_id
350: ,p_object_version_number => l_object_version_number
351: ,p_effective_date => trunc(p_effective_date)

Line 429: end ben_batch_bnft_cert_info_api;

425: hr_utility.set_location(' Leaving:'||l_proc, 70);
426: --
427: end lck;
428: --
429: end ben_batch_bnft_cert_info_api;