54: ) is
55: --
56: -- Declare cursors and local variables
57: --
58: l_elig_optd_mdcr_prte_id ben_elig_optd_mdcr_prte_f.elig_optd_mdcr_prte_id%TYPE;
59: l_effective_start_date ben_elig_optd_mdcr_prte_f.effective_start_date%TYPE;
60: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_ELIG_OPTD_MDCR_PRTE';
62: l_object_version_number ben_elig_optd_mdcr_prte_f.object_version_number%TYPE;
55: --
56: -- Declare cursors and local variables
57: --
58: l_elig_optd_mdcr_prte_id ben_elig_optd_mdcr_prte_f.elig_optd_mdcr_prte_id%TYPE;
59: l_effective_start_date ben_elig_optd_mdcr_prte_f.effective_start_date%TYPE;
60: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_ELIG_OPTD_MDCR_PRTE';
62: l_object_version_number ben_elig_optd_mdcr_prte_f.object_version_number%TYPE;
63: --
56: -- Declare cursors and local variables
57: --
58: l_elig_optd_mdcr_prte_id ben_elig_optd_mdcr_prte_f.elig_optd_mdcr_prte_id%TYPE;
59: l_effective_start_date ben_elig_optd_mdcr_prte_f.effective_start_date%TYPE;
60: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_ELIG_OPTD_MDCR_PRTE';
62: l_object_version_number ben_elig_optd_mdcr_prte_f.object_version_number%TYPE;
63: --
64: begin
58: l_elig_optd_mdcr_prte_id ben_elig_optd_mdcr_prte_f.elig_optd_mdcr_prte_id%TYPE;
59: l_effective_start_date ben_elig_optd_mdcr_prte_f.effective_start_date%TYPE;
60: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_ELIG_OPTD_MDCR_PRTE';
62: l_object_version_number ben_elig_optd_mdcr_prte_f.object_version_number%TYPE;
63: --
64: begin
65: --
66: hr_utility.set_location('Entering:'|| l_proc, 10);
235: p_base_table => 'BEN_ELIGY_PRFL_F',
236: p_base_table_column => 'ELIGY_PRFL_ID',
237: p_base_table_column_value => p_eligy_prfl_id,
238: p_base_table_reference_column => 'ELIG_OPTD_MDCR_FLAG',
239: p_reference_table => 'BEN_ELIG_OPTD_MDCR_PRTE_F',
240: p_reference_table_column => 'ELIGY_PRFL_ID');
241: --
242: hr_utility.set_location(l_proc, 60);
243: --
338: --
339: -- Declare cursors and local variables
340: --
341: l_proc varchar2(72) := g_package||'update_ELIG_OPTD_MDCR_PRTE';
342: l_object_version_number ben_elig_optd_mdcr_prte_f.object_version_number%TYPE;
343: l_effective_start_date ben_elig_optd_mdcr_prte_f.effective_start_date%TYPE;
344: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
345: --
346: begin
339: -- Declare cursors and local variables
340: --
341: l_proc varchar2(72) := g_package||'update_ELIG_OPTD_MDCR_PRTE';
342: l_object_version_number ben_elig_optd_mdcr_prte_f.object_version_number%TYPE;
343: l_effective_start_date ben_elig_optd_mdcr_prte_f.effective_start_date%TYPE;
344: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
345: --
346: begin
347: --
340: --
341: l_proc varchar2(72) := g_package||'update_ELIG_OPTD_MDCR_PRTE';
342: l_object_version_number ben_elig_optd_mdcr_prte_f.object_version_number%TYPE;
343: l_effective_start_date ben_elig_optd_mdcr_prte_f.effective_start_date%TYPE;
344: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
345: --
346: begin
347: --
348: hr_utility.set_location('Entering:'|| l_proc, 10);
577: --
578: -- Declare cursors and local variables
579: --
580: l_proc varchar2(72) := g_package||'update_ELIG_OPTD_MDCR_PRTE';
581: l_object_version_number ben_elig_optd_mdcr_prte_f.object_version_number%TYPE;
582: l_effective_start_date ben_elig_optd_mdcr_prte_f.effective_start_date%TYPE;
583: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
584: --
585: begin
578: -- Declare cursors and local variables
579: --
580: l_proc varchar2(72) := g_package||'update_ELIG_OPTD_MDCR_PRTE';
581: l_object_version_number ben_elig_optd_mdcr_prte_f.object_version_number%TYPE;
582: l_effective_start_date ben_elig_optd_mdcr_prte_f.effective_start_date%TYPE;
583: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
584: --
585: begin
586: --
579: --
580: l_proc varchar2(72) := g_package||'update_ELIG_OPTD_MDCR_PRTE';
581: l_object_version_number ben_elig_optd_mdcr_prte_f.object_version_number%TYPE;
582: l_effective_start_date ben_elig_optd_mdcr_prte_f.effective_start_date%TYPE;
583: l_effective_end_date ben_elig_optd_mdcr_prte_f.effective_end_date%TYPE;
584: --
585: begin
586: --
587: hr_utility.set_location('Entering:'|| l_proc, 10);
658: p_base_table => 'BEN_ELIGY_PRFL_F',
659: p_base_table_column => 'ELIGY_PRFL_ID',
660: p_base_table_column_value => ben_eom_shd.g_old_rec.eligy_prfl_id,
661: p_base_table_reference_column => 'ELIG_OPTD_MDCR_FLAG',
662: p_reference_table => 'BEN_ELIG_OPTD_MDCR_PRTE_F',
663: p_reference_table_column => 'ELIGY_PRFL_ID');
664: --
665: hr_utility.set_location(l_proc, 60);
666: --