DBA Data[Home] [Help]

APPS.BEN_ACTUAL_PREMIUM_RULE_API dependencies on BEN_ACTL_PREM_VRBL_RT_RL_F

Line 59: l_actl_prem_vrbl_rt_rl_id ben_actl_prem_vrbl_rt_rl_f.actl_prem_vrbl_rt_rl_id%TYPE;

55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_actl_prem_vrbl_rt_rl_id ben_actl_prem_vrbl_rt_rl_f.actl_prem_vrbl_rt_rl_id%TYPE;
60: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;
61: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_actual_premium_rule';
63: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;

Line 60: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;

56: --
57: -- Declare cursors and local variables
58: --
59: l_actl_prem_vrbl_rt_rl_id ben_actl_prem_vrbl_rt_rl_f.actl_prem_vrbl_rt_rl_id%TYPE;
60: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;
61: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_actual_premium_rule';
63: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;
64: --

Line 61: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;

57: -- Declare cursors and local variables
58: --
59: l_actl_prem_vrbl_rt_rl_id ben_actl_prem_vrbl_rt_rl_f.actl_prem_vrbl_rt_rl_id%TYPE;
60: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;
61: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_actual_premium_rule';
63: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;
64: --
65: begin

Line 63: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;

59: l_actl_prem_vrbl_rt_rl_id ben_actl_prem_vrbl_rt_rl_f.actl_prem_vrbl_rt_rl_id%TYPE;
60: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;
61: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_actual_premium_rule';
63: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 339: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;

335: --
336: -- Declare cursors and local variables
337: --
338: l_proc varchar2(72) := g_package||'update_actual_premium_rule';
339: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;
340: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;
341: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;
342: --
343: begin

Line 340: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;

336: -- Declare cursors and local variables
337: --
338: l_proc varchar2(72) := g_package||'update_actual_premium_rule';
339: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;
340: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;
341: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;
342: --
343: begin
344: --

Line 341: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;

337: --
338: l_proc varchar2(72) := g_package||'update_actual_premium_rule';
339: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;
340: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;
341: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;
342: --
343: begin
344: --
345: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 581: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;

577: --
578: -- Declare cursors and local variables
579: --
580: l_proc varchar2(72) := g_package||'update_actual_premium_rule';
581: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;
582: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;
583: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;
584: --
585: begin

Line 582: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;

578: -- Declare cursors and local variables
579: --
580: l_proc varchar2(72) := g_package||'update_actual_premium_rule';
581: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;
582: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;
583: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;
584: --
585: begin
586: --

Line 583: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;

579: --
580: l_proc varchar2(72) := g_package||'update_actual_premium_rule';
581: l_object_version_number ben_actl_prem_vrbl_rt_rl_f.object_version_number%TYPE;
582: l_effective_start_date ben_actl_prem_vrbl_rt_rl_f.effective_start_date%TYPE;
583: l_effective_end_date ben_actl_prem_vrbl_rt_rl_f.effective_end_date%TYPE;
584: --
585: begin
586: --
587: hr_utility.set_location('Entering:'|| l_proc, 10);