DBA Data[Home] [Help]

APPS.BEN_APLCN_TO_BENEFIT_POOL_API dependencies on BEN_APLCN_TO_BNFT_POOL_F

Line 57: l_aplcn_to_bnft_pool_id ben_aplcn_to_bnft_pool_f.aplcn_to_bnft_pool_id%TYPE;

53: ) is
54: --
55: -- Declare cursors and local variables
56: --
57: l_aplcn_to_bnft_pool_id ben_aplcn_to_bnft_pool_f.aplcn_to_bnft_pool_id%TYPE;
58: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;
59: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_Aplcn_To_Benefit_Pool';
61: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;

Line 58: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;

54: --
55: -- Declare cursors and local variables
56: --
57: l_aplcn_to_bnft_pool_id ben_aplcn_to_bnft_pool_f.aplcn_to_bnft_pool_id%TYPE;
58: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;
59: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_Aplcn_To_Benefit_Pool';
61: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;
62: --

Line 59: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;

55: -- Declare cursors and local variables
56: --
57: l_aplcn_to_bnft_pool_id ben_aplcn_to_bnft_pool_f.aplcn_to_bnft_pool_id%TYPE;
58: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;
59: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_Aplcn_To_Benefit_Pool';
61: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;
62: --
63: begin

Line 61: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;

57: l_aplcn_to_bnft_pool_id ben_aplcn_to_bnft_pool_f.aplcn_to_bnft_pool_id%TYPE;
58: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;
59: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_Aplcn_To_Benefit_Pool';
61: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;
62: --
63: begin
64: --
65: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 324: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;

320: --
321: -- Declare cursors and local variables
322: --
323: l_proc varchar2(72) := g_package||'update_Aplcn_To_Benefit_Pool';
324: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;
325: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;
326: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;
327: --
328: begin

Line 325: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;

321: -- Declare cursors and local variables
322: --
323: l_proc varchar2(72) := g_package||'update_Aplcn_To_Benefit_Pool';
324: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;
325: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;
326: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;
327: --
328: begin
329: --

Line 326: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;

322: --
323: l_proc varchar2(72) := g_package||'update_Aplcn_To_Benefit_Pool';
324: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;
325: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;
326: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;
327: --
328: begin
329: --
330: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 556: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;

552: --
553: -- Declare cursors and local variables
554: --
555: l_proc varchar2(72) := g_package||'update_Aplcn_To_Benefit_Pool';
556: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;
557: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;
558: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;
559: --
560: begin

Line 557: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;

553: -- Declare cursors and local variables
554: --
555: l_proc varchar2(72) := g_package||'update_Aplcn_To_Benefit_Pool';
556: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;
557: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;
558: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;
559: --
560: begin
561: --

Line 558: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;

554: --
555: l_proc varchar2(72) := g_package||'update_Aplcn_To_Benefit_Pool';
556: l_object_version_number ben_aplcn_to_bnft_pool_f.object_version_number%TYPE;
557: l_effective_start_date ben_aplcn_to_bnft_pool_f.effective_start_date%TYPE;
558: l_effective_end_date ben_aplcn_to_bnft_pool_f.effective_end_date%TYPE;
559: --
560: begin
561: --
562: hr_utility.set_location('Entering:'|| l_proc, 10);