57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_pyrl_prte_id ben_elig_pyrl_prte_f.elig_pyrl_prte_id%TYPE;
62: l_effective_start_date ben_elig_pyrl_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pyrl_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PYRL_PRTE';
65: l_object_version_number ben_elig_pyrl_prte_f.object_version_number%TYPE;
58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_pyrl_prte_id ben_elig_pyrl_prte_f.elig_pyrl_prte_id%TYPE;
62: l_effective_start_date ben_elig_pyrl_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pyrl_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PYRL_PRTE';
65: l_object_version_number ben_elig_pyrl_prte_f.object_version_number%TYPE;
66: --
59: -- Declare cursors and local variables
60: --
61: l_elig_pyrl_prte_id ben_elig_pyrl_prte_f.elig_pyrl_prte_id%TYPE;
62: l_effective_start_date ben_elig_pyrl_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pyrl_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PYRL_PRTE';
65: l_object_version_number ben_elig_pyrl_prte_f.object_version_number%TYPE;
66: --
67: begin
61: l_elig_pyrl_prte_id ben_elig_pyrl_prte_f.elig_pyrl_prte_id%TYPE;
62: l_effective_start_date ben_elig_pyrl_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pyrl_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PYRL_PRTE';
65: l_object_version_number ben_elig_pyrl_prte_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);
247: p_base_table => 'BEN_ELIGY_PRFL_F',
248: p_base_table_column => 'ELIGY_PRFL_ID',
249: p_base_table_column_value => p_eligy_prfl_id,
250: p_base_table_reference_column => 'ELIG_PYRL_FLAG',
251: p_reference_table => 'BEN_ELIG_PYRL_PRTE_F',
252: p_reference_table_column => 'ELIGY_PRFL_ID');
253: --
254: hr_utility.set_location(l_proc, 60);
255: --
356: --
357: -- Declare cursors and local variables
358: --
359: l_proc varchar2(72) := g_package||'update_ELIG_PYRL_PRTE';
360: l_object_version_number ben_elig_pyrl_prte_f.object_version_number%TYPE;
361: l_effective_start_date ben_elig_pyrl_prte_f.effective_start_date%TYPE;
362: l_effective_end_date ben_elig_pyrl_prte_f.effective_end_date%TYPE;
363: --
364: begin
357: -- Declare cursors and local variables
358: --
359: l_proc varchar2(72) := g_package||'update_ELIG_PYRL_PRTE';
360: l_object_version_number ben_elig_pyrl_prte_f.object_version_number%TYPE;
361: l_effective_start_date ben_elig_pyrl_prte_f.effective_start_date%TYPE;
362: l_effective_end_date ben_elig_pyrl_prte_f.effective_end_date%TYPE;
363: --
364: begin
365: --
358: --
359: l_proc varchar2(72) := g_package||'update_ELIG_PYRL_PRTE';
360: l_object_version_number ben_elig_pyrl_prte_f.object_version_number%TYPE;
361: l_effective_start_date ben_elig_pyrl_prte_f.effective_start_date%TYPE;
362: l_effective_end_date ben_elig_pyrl_prte_f.effective_end_date%TYPE;
363: --
364: begin
365: --
366: hr_utility.set_location('Entering:'|| l_proc, 10);
608: --
609: -- Declare cursors and local variables
610: --
611: l_proc varchar2(72) := g_package||'update_ELIG_PYRL_PRTE';
612: l_object_version_number ben_elig_pyrl_prte_f.object_version_number%TYPE;
613: l_effective_start_date ben_elig_pyrl_prte_f.effective_start_date%TYPE;
614: l_effective_end_date ben_elig_pyrl_prte_f.effective_end_date%TYPE;
615: --
616: begin
609: -- Declare cursors and local variables
610: --
611: l_proc varchar2(72) := g_package||'update_ELIG_PYRL_PRTE';
612: l_object_version_number ben_elig_pyrl_prte_f.object_version_number%TYPE;
613: l_effective_start_date ben_elig_pyrl_prte_f.effective_start_date%TYPE;
614: l_effective_end_date ben_elig_pyrl_prte_f.effective_end_date%TYPE;
615: --
616: begin
617: --
610: --
611: l_proc varchar2(72) := g_package||'update_ELIG_PYRL_PRTE';
612: l_object_version_number ben_elig_pyrl_prte_f.object_version_number%TYPE;
613: l_effective_start_date ben_elig_pyrl_prte_f.effective_start_date%TYPE;
614: l_effective_end_date ben_elig_pyrl_prte_f.effective_end_date%TYPE;
615: --
616: begin
617: --
618: hr_utility.set_location('Entering:'|| l_proc, 10);
689: p_base_table => 'BEN_ELIGY_PRFL_F',
690: p_base_table_column => 'ELIGY_PRFL_ID',
691: p_base_table_column_value => ben_epy_shd.g_old_rec.eligy_prfl_id,
692: p_base_table_reference_column => 'ELIG_PYRL_FLAG',
693: p_reference_table => 'BEN_ELIG_PYRL_PRTE_F',
694: p_reference_table_column => 'ELIGY_PRFL_ID');
695: --
696: hr_utility.set_location(l_proc, 60);
697: --