58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_elig_suppl_role_prte_id ben_elig_suppl_role_prte_f.elig_suppl_role_prte_id%TYPE;
63: l_effective_start_date ben_elig_suppl_role_prte_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_suppl_role_prte_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_elig_suppl_role_prte';
66: l_object_version_number ben_elig_suppl_role_prte_f.object_version_number%TYPE;
59: --
60: -- Declare cursors and local variables
61: --
62: l_elig_suppl_role_prte_id ben_elig_suppl_role_prte_f.elig_suppl_role_prte_id%TYPE;
63: l_effective_start_date ben_elig_suppl_role_prte_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_suppl_role_prte_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_elig_suppl_role_prte';
66: l_object_version_number ben_elig_suppl_role_prte_f.object_version_number%TYPE;
67: --
60: -- Declare cursors and local variables
61: --
62: l_elig_suppl_role_prte_id ben_elig_suppl_role_prte_f.elig_suppl_role_prte_id%TYPE;
63: l_effective_start_date ben_elig_suppl_role_prte_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_suppl_role_prte_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_elig_suppl_role_prte';
66: l_object_version_number ben_elig_suppl_role_prte_f.object_version_number%TYPE;
67: --
68: begin
62: l_elig_suppl_role_prte_id ben_elig_suppl_role_prte_f.elig_suppl_role_prte_id%TYPE;
63: l_effective_start_date ben_elig_suppl_role_prte_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_suppl_role_prte_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_elig_suppl_role_prte';
66: l_object_version_number ben_elig_suppl_role_prte_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);
251: p_base_table => 'BEN_ELIGY_PRFL_F',
252: p_base_table_column => 'ELIGY_PRFL_ID',
253: p_base_table_column_value => p_eligy_prfl_id,
254: p_base_table_reference_column => 'ELIG_LOA_RSN_FLAG',
255: p_reference_table => 'BEN_elig_suppl_role_prte_F',
256: p_reference_table_column => 'ELIGY_PRFL_ID');
257: --
258: hr_utility.set_location(l_proc, 60);
259: --
361: --
362: -- Declare cursors and local variables
363: --
364: l_proc varchar2(72) := g_package||'update_elig_suppl_role_prte';
365: l_object_version_number ben_elig_suppl_role_prte_f.object_version_number%TYPE;
366: l_effective_start_date ben_elig_suppl_role_prte_f.effective_start_date%TYPE;
367: l_effective_end_date ben_elig_suppl_role_prte_f.effective_end_date%TYPE;
368: --
369: begin
362: -- Declare cursors and local variables
363: --
364: l_proc varchar2(72) := g_package||'update_elig_suppl_role_prte';
365: l_object_version_number ben_elig_suppl_role_prte_f.object_version_number%TYPE;
366: l_effective_start_date ben_elig_suppl_role_prte_f.effective_start_date%TYPE;
367: l_effective_end_date ben_elig_suppl_role_prte_f.effective_end_date%TYPE;
368: --
369: begin
370: --
363: --
364: l_proc varchar2(72) := g_package||'update_elig_suppl_role_prte';
365: l_object_version_number ben_elig_suppl_role_prte_f.object_version_number%TYPE;
366: l_effective_start_date ben_elig_suppl_role_prte_f.effective_start_date%TYPE;
367: l_effective_end_date ben_elig_suppl_role_prte_f.effective_end_date%TYPE;
368: --
369: begin
370: --
371: hr_utility.set_location('Entering:'|| l_proc, 10);
614: --
615: -- Declare cursors and local variables
616: --
617: l_proc varchar2(72) := g_package||'update_elig_suppl_role_prte';
618: l_object_version_number ben_elig_suppl_role_prte_f.object_version_number%TYPE;
619: l_effective_start_date ben_elig_suppl_role_prte_f.effective_start_date%TYPE;
620: l_effective_end_date ben_elig_suppl_role_prte_f.effective_end_date%TYPE;
621: --
622: begin
615: -- Declare cursors and local variables
616: --
617: l_proc varchar2(72) := g_package||'update_elig_suppl_role_prte';
618: l_object_version_number ben_elig_suppl_role_prte_f.object_version_number%TYPE;
619: l_effective_start_date ben_elig_suppl_role_prte_f.effective_start_date%TYPE;
620: l_effective_end_date ben_elig_suppl_role_prte_f.effective_end_date%TYPE;
621: --
622: begin
623: --
616: --
617: l_proc varchar2(72) := g_package||'update_elig_suppl_role_prte';
618: l_object_version_number ben_elig_suppl_role_prte_f.object_version_number%TYPE;
619: l_effective_start_date ben_elig_suppl_role_prte_f.effective_start_date%TYPE;
620: l_effective_end_date ben_elig_suppl_role_prte_f.effective_end_date%TYPE;
621: --
622: begin
623: --
624: hr_utility.set_location('Entering:'|| l_proc, 10);
695: p_base_table => 'BEN_ELIGY_PRFL_F',
696: p_base_table_column => 'ELIGY_PRFL_ID',
697: p_base_table_column_value => ben_est_shd.g_old_rec.eligy_prfl_id,
698: p_base_table_reference_column => 'ELIG_LOA_RSN_FLAG',
699: p_reference_table => 'BEN_elig_suppl_role_prte_F',
700: p_reference_table_column => 'ELIGY_PRFL_ID');
701: --
702: hr_utility.set_location(l_proc, 60);
703: --