DBA Data[Home] [Help]

APPS.BEN_BNFT_VRBL_RT_RL_API dependencies on BEN_BNFT_VRBL_RT_RL_F

Line 58: l_bnft_vrbl_rt_rl_id ben_bnft_vrbl_rt_rl_f.bnft_vrbl_rt_rl_id%TYPE;

54: ) is
55: --
56: -- Declare cursors and local variables
57: --
58: l_bnft_vrbl_rt_rl_id ben_bnft_vrbl_rt_rl_f.bnft_vrbl_rt_rl_id%TYPE;
59: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_bnft_vrbl_rt_rl';
62: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;

Line 59: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;

55: --
56: -- Declare cursors and local variables
57: --
58: l_bnft_vrbl_rt_rl_id ben_bnft_vrbl_rt_rl_f.bnft_vrbl_rt_rl_id%TYPE;
59: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_bnft_vrbl_rt_rl';
62: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;
63: --

Line 60: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;

56: -- Declare cursors and local variables
57: --
58: l_bnft_vrbl_rt_rl_id ben_bnft_vrbl_rt_rl_f.bnft_vrbl_rt_rl_id%TYPE;
59: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_bnft_vrbl_rt_rl';
62: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;
63: --
64: begin

Line 62: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;

58: l_bnft_vrbl_rt_rl_id ben_bnft_vrbl_rt_rl_f.bnft_vrbl_rt_rl_id%TYPE;
59: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_bnft_vrbl_rt_rl';
62: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;
63: --
64: begin
65: --
66: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 335: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;

331: --
332: -- Declare cursors and local variables
333: --
334: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt_rl';
335: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;
336: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;
337: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;
338: --
339: begin

Line 336: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;

332: -- Declare cursors and local variables
333: --
334: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt_rl';
335: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;
336: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;
337: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;
338: --
339: begin
340: --

Line 337: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;

333: --
334: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt_rl';
335: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;
336: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;
337: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;
338: --
339: begin
340: --
341: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 575: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;

571: --
572: -- Declare cursors and local variables
573: --
574: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt_rl';
575: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;
576: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;
577: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;
578: --
579: begin

Line 576: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;

572: -- Declare cursors and local variables
573: --
574: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt_rl';
575: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;
576: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;
577: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;
578: --
579: begin
580: --

Line 577: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;

573: --
574: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt_rl';
575: l_object_version_number ben_bnft_vrbl_rt_rl_f.object_version_number%TYPE;
576: l_effective_start_date ben_bnft_vrbl_rt_rl_f.effective_start_date%TYPE;
577: l_effective_end_date ben_bnft_vrbl_rt_rl_f.effective_end_date%TYPE;
578: --
579: begin
580: --
581: hr_utility.set_location('Entering:'|| l_proc, 10);