DBA Data[Home] [Help]

APPS.BEN_CMBN_AGE_LOS_RT_API dependencies on BEN_CMBN_AGE_LOS_RT_F

Line 59: l_cmbn_age_los_rt_id ben_cmbn_age_los_rt_f.cmbn_age_los_rt_id%TYPE;

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

Line 60: l_effective_start_date ben_cmbn_age_los_rt_f.effective_start_date%TYPE;

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

Line 61: l_effective_end_date ben_cmbn_age_los_rt_f.effective_end_date%TYPE;

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

Line 63: l_object_version_number ben_cmbn_age_los_rt_f.object_version_number%TYPE;

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

Line 243: p_reference_table => 'BEN_CMBN_AGE_LOS_RT_F',

239: p_base_table => 'BEN_VRBL_RT_PRFL_F',
240: p_base_table_column => 'VRBL_RT_PRFL_ID',
241: p_base_table_column_value => p_vrbl_rt_prfl_id,
242: p_base_table_reference_column => 'RT_CMBN_AGE_LOS_FLAG',
243: p_reference_table => 'BEN_CMBN_AGE_LOS_RT_F',
244: p_reference_table_column => 'VRBL_RT_PRFL_ID');
245: --
246: ben_derivable_rate.derivable_rate_handler
247: (p_event =>'CREATE',

Line 348: l_object_version_number ben_cmbn_age_los_rt_f.object_version_number%TYPE;

344: --
345: -- Declare cursors and local variables
346: --
347: l_proc varchar2(72) := g_package||'update_CMBN_AGE_LOS_RT';
348: l_object_version_number ben_cmbn_age_los_rt_f.object_version_number%TYPE;
349: l_effective_start_date ben_cmbn_age_los_rt_f.effective_start_date%TYPE;
350: l_effective_end_date ben_cmbn_age_los_rt_f.effective_end_date%TYPE;
351: --
352: begin

Line 349: l_effective_start_date ben_cmbn_age_los_rt_f.effective_start_date%TYPE;

345: -- Declare cursors and local variables
346: --
347: l_proc varchar2(72) := g_package||'update_CMBN_AGE_LOS_RT';
348: l_object_version_number ben_cmbn_age_los_rt_f.object_version_number%TYPE;
349: l_effective_start_date ben_cmbn_age_los_rt_f.effective_start_date%TYPE;
350: l_effective_end_date ben_cmbn_age_los_rt_f.effective_end_date%TYPE;
351: --
352: begin
353: --

Line 350: l_effective_end_date ben_cmbn_age_los_rt_f.effective_end_date%TYPE;

346: --
347: l_proc varchar2(72) := g_package||'update_CMBN_AGE_LOS_RT';
348: l_object_version_number ben_cmbn_age_los_rt_f.object_version_number%TYPE;
349: l_effective_start_date ben_cmbn_age_los_rt_f.effective_start_date%TYPE;
350: l_effective_end_date ben_cmbn_age_los_rt_f.effective_end_date%TYPE;
351: --
352: begin
353: --
354: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 590: l_object_version_number ben_cmbn_age_los_rt_f.object_version_number%TYPE;

586: --
587: -- Declare cursors and local variables
588: --
589: l_proc varchar2(72) := g_package||'update_CMBN_AGE_LOS_RT';
590: l_object_version_number ben_cmbn_age_los_rt_f.object_version_number%TYPE;
591: l_effective_start_date ben_cmbn_age_los_rt_f.effective_start_date%TYPE;
592: l_effective_end_date ben_cmbn_age_los_rt_f.effective_end_date%TYPE;
593: --
594: begin

Line 591: l_effective_start_date ben_cmbn_age_los_rt_f.effective_start_date%TYPE;

587: -- Declare cursors and local variables
588: --
589: l_proc varchar2(72) := g_package||'update_CMBN_AGE_LOS_RT';
590: l_object_version_number ben_cmbn_age_los_rt_f.object_version_number%TYPE;
591: l_effective_start_date ben_cmbn_age_los_rt_f.effective_start_date%TYPE;
592: l_effective_end_date ben_cmbn_age_los_rt_f.effective_end_date%TYPE;
593: --
594: begin
595: --

Line 592: l_effective_end_date ben_cmbn_age_los_rt_f.effective_end_date%TYPE;

588: --
589: l_proc varchar2(72) := g_package||'update_CMBN_AGE_LOS_RT';
590: l_object_version_number ben_cmbn_age_los_rt_f.object_version_number%TYPE;
591: l_effective_start_date ben_cmbn_age_los_rt_f.effective_start_date%TYPE;
592: l_effective_end_date ben_cmbn_age_los_rt_f.effective_end_date%TYPE;
593: --
594: begin
595: --
596: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 671: p_reference_table => 'BEN_CMBN_AGE_LOS_RT_F',

667: p_base_table => 'BEN_VRBL_RT_PRFL_F',
668: p_base_table_column => 'VRBL_RT_PRFL_ID',
669: p_base_table_column_value => ben_cmr_shd.g_old_rec.vrbl_rt_prfl_id,
670: p_base_table_reference_column => 'RT_CMBN_AGE_LOS_FLAG',
671: p_reference_table => 'BEN_CMBN_AGE_LOS_RT_F',
672: p_reference_table_column => 'VRBL_RT_PRFL_ID');
673: --
674: ben_derivable_rate.derivable_rate_handler
675: (p_event =>'DELETE',