55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_py_bss_rt_id ben_py_bss_rt_f.py_bss_rt_id%TYPE;
60: l_effective_start_date ben_py_bss_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_py_bss_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PAY_BASIS_RATE';
63: l_object_version_number ben_py_bss_rt_f.object_version_number%TYPE;
56: --
57: -- Declare cursors and local variables
58: --
59: l_py_bss_rt_id ben_py_bss_rt_f.py_bss_rt_id%TYPE;
60: l_effective_start_date ben_py_bss_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_py_bss_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PAY_BASIS_RATE';
63: l_object_version_number ben_py_bss_rt_f.object_version_number%TYPE;
64: --
57: -- Declare cursors and local variables
58: --
59: l_py_bss_rt_id ben_py_bss_rt_f.py_bss_rt_id%TYPE;
60: l_effective_start_date ben_py_bss_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_py_bss_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PAY_BASIS_RATE';
63: l_object_version_number ben_py_bss_rt_f.object_version_number%TYPE;
64: --
65: begin
59: l_py_bss_rt_id ben_py_bss_rt_f.py_bss_rt_id%TYPE;
60: l_effective_start_date ben_py_bss_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_py_bss_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PAY_BASIS_RATE';
63: l_object_version_number ben_py_bss_rt_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);
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_PY_BSS_FLAG',
243: p_reference_table => 'BEN_PY_BSS_RT_F',
244: p_reference_table_column => 'VRBL_RT_PRFL_ID');
245: --
246: hr_utility.set_location(l_proc, 60);
247: --
343: --
344: -- Declare cursors and local variables
345: --
346: l_proc varchar2(72) := g_package||'update_PAY_BASIS_RATE';
347: l_object_version_number ben_py_bss_rt_f.object_version_number%TYPE;
348: l_effective_start_date ben_py_bss_rt_f.effective_start_date%TYPE;
349: l_effective_end_date ben_py_bss_rt_f.effective_end_date%TYPE;
350: --
351: begin
344: -- Declare cursors and local variables
345: --
346: l_proc varchar2(72) := g_package||'update_PAY_BASIS_RATE';
347: l_object_version_number ben_py_bss_rt_f.object_version_number%TYPE;
348: l_effective_start_date ben_py_bss_rt_f.effective_start_date%TYPE;
349: l_effective_end_date ben_py_bss_rt_f.effective_end_date%TYPE;
350: --
351: begin
352: --
345: --
346: l_proc varchar2(72) := g_package||'update_PAY_BASIS_RATE';
347: l_object_version_number ben_py_bss_rt_f.object_version_number%TYPE;
348: l_effective_start_date ben_py_bss_rt_f.effective_start_date%TYPE;
349: l_effective_end_date ben_py_bss_rt_f.effective_end_date%TYPE;
350: --
351: begin
352: --
353: hr_utility.set_location('Entering:'|| l_proc, 10);
585: --
586: -- Declare cursors and local variables
587: --
588: l_proc varchar2(72) := g_package||'update_PAY_BASIS_RATE';
589: l_object_version_number ben_py_bss_rt_f.object_version_number%TYPE;
590: l_effective_start_date ben_py_bss_rt_f.effective_start_date%TYPE;
591: l_effective_end_date ben_py_bss_rt_f.effective_end_date%TYPE;
592: --
593: begin
586: -- Declare cursors and local variables
587: --
588: l_proc varchar2(72) := g_package||'update_PAY_BASIS_RATE';
589: l_object_version_number ben_py_bss_rt_f.object_version_number%TYPE;
590: l_effective_start_date ben_py_bss_rt_f.effective_start_date%TYPE;
591: l_effective_end_date ben_py_bss_rt_f.effective_end_date%TYPE;
592: --
593: begin
594: --
587: --
588: l_proc varchar2(72) := g_package||'update_PAY_BASIS_RATE';
589: l_object_version_number ben_py_bss_rt_f.object_version_number%TYPE;
590: l_effective_start_date ben_py_bss_rt_f.effective_start_date%TYPE;
591: l_effective_end_date ben_py_bss_rt_f.effective_end_date%TYPE;
592: --
593: begin
594: --
595: hr_utility.set_location('Entering:'|| l_proc, 10);
666: p_base_table => 'BEN_VRBL_RT_PRFL_F',
667: p_base_table_column => 'VRBL_RT_PRFL_ID',
668: p_base_table_column_value => ben_pbr_shd.g_old_rec.vrbl_rt_prfl_id,
669: p_base_table_reference_column => 'RT_PY_BSS_FLAG',
670: p_reference_table => 'BEN_PY_BSS_RT_F',
671: p_reference_table_column => 'VRBL_RT_PRFL_ID');
672: --
673: hr_utility.set_location(l_proc, 60);
674: --