60: ) is
61: --
62: -- Declare cursors and local variables
63: --
64: l_ttl_prtt_rt_id ben_ttl_prtt_rt_f.ttl_prtt_rt_id%TYPE;
65: l_effective_start_date ben_ttl_prtt_rt_f.effective_start_date%TYPE;
66: l_effective_end_date ben_ttl_prtt_rt_f.effective_end_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_ttl_prtt_rt';
68: l_object_version_number ben_ttl_prtt_rt_f.object_version_number%TYPE;
61: --
62: -- Declare cursors and local variables
63: --
64: l_ttl_prtt_rt_id ben_ttl_prtt_rt_f.ttl_prtt_rt_id%TYPE;
65: l_effective_start_date ben_ttl_prtt_rt_f.effective_start_date%TYPE;
66: l_effective_end_date ben_ttl_prtt_rt_f.effective_end_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_ttl_prtt_rt';
68: l_object_version_number ben_ttl_prtt_rt_f.object_version_number%TYPE;
69: --
62: -- Declare cursors and local variables
63: --
64: l_ttl_prtt_rt_id ben_ttl_prtt_rt_f.ttl_prtt_rt_id%TYPE;
65: l_effective_start_date ben_ttl_prtt_rt_f.effective_start_date%TYPE;
66: l_effective_end_date ben_ttl_prtt_rt_f.effective_end_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_ttl_prtt_rt';
68: l_object_version_number ben_ttl_prtt_rt_f.object_version_number%TYPE;
69: --
70: begin
64: l_ttl_prtt_rt_id ben_ttl_prtt_rt_f.ttl_prtt_rt_id%TYPE;
65: l_effective_start_date ben_ttl_prtt_rt_f.effective_start_date%TYPE;
66: l_effective_end_date ben_ttl_prtt_rt_f.effective_end_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_ttl_prtt_rt';
68: l_object_version_number ben_ttl_prtt_rt_f.object_version_number%TYPE;
69: --
70: begin
71: --
72: hr_utility.set_location('Entering:'|| l_proc, 10);
259: p_base_table => 'BEN_VRBL_RT_PRFL_F',
260: p_base_table_column => 'VRBL_RT_PRFL_ID',
261: p_base_table_column_value => p_vrbl_rt_prfl_id,
262: p_base_table_reference_column => 'RT_TTL_PRTT_FLAG',
263: p_reference_table => 'BEN_TTL_PRTT_RT_F',
264: p_reference_table_column => 'VRBL_RT_PRFL_ID');
265: --
266: hr_utility.set_location(l_proc, 60);
267: --
370: --
371: -- Declare cursors and local variables
372: --
373: l_proc varchar2(72) := g_package||'update_ttl_prtt_rt';
374: l_object_version_number ben_ttl_prtt_rt_f.object_version_number%TYPE;
375: l_effective_start_date ben_ttl_prtt_rt_f.effective_start_date%TYPE;
376: l_effective_end_date ben_ttl_prtt_rt_f.effective_end_date%TYPE;
377: --
378: begin
371: -- Declare cursors and local variables
372: --
373: l_proc varchar2(72) := g_package||'update_ttl_prtt_rt';
374: l_object_version_number ben_ttl_prtt_rt_f.object_version_number%TYPE;
375: l_effective_start_date ben_ttl_prtt_rt_f.effective_start_date%TYPE;
376: l_effective_end_date ben_ttl_prtt_rt_f.effective_end_date%TYPE;
377: --
378: begin
379: --
372: --
373: l_proc varchar2(72) := g_package||'update_ttl_prtt_rt';
374: l_object_version_number ben_ttl_prtt_rt_f.object_version_number%TYPE;
375: l_effective_start_date ben_ttl_prtt_rt_f.effective_start_date%TYPE;
376: l_effective_end_date ben_ttl_prtt_rt_f.effective_end_date%TYPE;
377: --
378: begin
379: --
380: hr_utility.set_location('Entering:'|| l_proc, 10);
628: --
629: -- Declare cursors and local variables
630: --
631: l_proc varchar2(72) := g_package||'update_ttl_prtt_rt';
632: l_object_version_number ben_ttl_prtt_rt_f.object_version_number%TYPE;
633: l_effective_start_date ben_ttl_prtt_rt_f.effective_start_date%TYPE;
634: l_effective_end_date ben_ttl_prtt_rt_f.effective_end_date%TYPE;
635: --
636: begin
629: -- Declare cursors and local variables
630: --
631: l_proc varchar2(72) := g_package||'update_ttl_prtt_rt';
632: l_object_version_number ben_ttl_prtt_rt_f.object_version_number%TYPE;
633: l_effective_start_date ben_ttl_prtt_rt_f.effective_start_date%TYPE;
634: l_effective_end_date ben_ttl_prtt_rt_f.effective_end_date%TYPE;
635: --
636: begin
637: --
630: --
631: l_proc varchar2(72) := g_package||'update_ttl_prtt_rt';
632: l_object_version_number ben_ttl_prtt_rt_f.object_version_number%TYPE;
633: l_effective_start_date ben_ttl_prtt_rt_f.effective_start_date%TYPE;
634: l_effective_end_date ben_ttl_prtt_rt_f.effective_end_date%TYPE;
635: --
636: begin
637: --
638: hr_utility.set_location('Entering:'|| l_proc, 10);
709: p_base_table => 'BEN_VRBL_RT_PRFL_F',
710: p_base_table_column => 'VRBL_RT_PRFL_ID',
711: p_base_table_column_value => ben_ttp_shd.g_old_rec.vrbl_rt_prfl_id,
712: p_base_table_reference_column => 'RT_TTL_PRTT_FLAG',
713: p_reference_table => 'BEN_TTL_PRTT_RT_F',
714: p_reference_table_column => 'VRBL_RT_PRFL_ID');
715: --
716: hr_utility.set_location(l_proc, 60);
717: --