53: ) is
54: --
55: -- Declare cursors and local variables
56: --
57: l_dsgntr_enrld_cvg_id ben_dsgntr_enrld_cvg_f.dsgntr_enrld_cvg_id%TYPE;
58: l_effective_start_date ben_dsgntr_enrld_cvg_f.effective_start_date%TYPE;
59: l_effective_end_date ben_dsgntr_enrld_cvg_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_DSGNTR_ENRLD_CVG';
61: l_object_version_number ben_dsgntr_enrld_cvg_f.object_version_number%TYPE;
54: --
55: -- Declare cursors and local variables
56: --
57: l_dsgntr_enrld_cvg_id ben_dsgntr_enrld_cvg_f.dsgntr_enrld_cvg_id%TYPE;
58: l_effective_start_date ben_dsgntr_enrld_cvg_f.effective_start_date%TYPE;
59: l_effective_end_date ben_dsgntr_enrld_cvg_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_DSGNTR_ENRLD_CVG';
61: l_object_version_number ben_dsgntr_enrld_cvg_f.object_version_number%TYPE;
62: --
55: -- Declare cursors and local variables
56: --
57: l_dsgntr_enrld_cvg_id ben_dsgntr_enrld_cvg_f.dsgntr_enrld_cvg_id%TYPE;
58: l_effective_start_date ben_dsgntr_enrld_cvg_f.effective_start_date%TYPE;
59: l_effective_end_date ben_dsgntr_enrld_cvg_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_DSGNTR_ENRLD_CVG';
61: l_object_version_number ben_dsgntr_enrld_cvg_f.object_version_number%TYPE;
62: --
63: begin
57: l_dsgntr_enrld_cvg_id ben_dsgntr_enrld_cvg_f.dsgntr_enrld_cvg_id%TYPE;
58: l_effective_start_date ben_dsgntr_enrld_cvg_f.effective_start_date%TYPE;
59: l_effective_end_date ben_dsgntr_enrld_cvg_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_DSGNTR_ENRLD_CVG';
61: l_object_version_number ben_dsgntr_enrld_cvg_f.object_version_number%TYPE;
62: --
63: begin
64: --
65: hr_utility.set_location('Entering:'|| l_proc, 10);
233: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
234: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
235: p_base_table_column_value => p_dpnt_cvg_eligy_prfl_id,
236: p_base_table_reference_column => 'DPNT_DSGNT_CRNTLY_ENRLD_FLAG',
237: p_reference_table => 'BEN_DSGNTR_ENRLD_CVG_F',
238: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
239: --
240:
241: -- When in validation only mode raise the Validate_Enabled exception
336: --
337: -- Declare cursors and local variables
338: --
339: l_proc varchar2(72) := g_package||'update_DSGNTR_ENRLD_CVG';
340: l_object_version_number ben_dsgntr_enrld_cvg_f.object_version_number%TYPE;
341: l_effective_start_date ben_dsgntr_enrld_cvg_f.effective_start_date%TYPE;
342: l_effective_end_date ben_dsgntr_enrld_cvg_f.effective_end_date%TYPE;
343: --
344: begin
337: -- Declare cursors and local variables
338: --
339: l_proc varchar2(72) := g_package||'update_DSGNTR_ENRLD_CVG';
340: l_object_version_number ben_dsgntr_enrld_cvg_f.object_version_number%TYPE;
341: l_effective_start_date ben_dsgntr_enrld_cvg_f.effective_start_date%TYPE;
342: l_effective_end_date ben_dsgntr_enrld_cvg_f.effective_end_date%TYPE;
343: --
344: begin
345: --
338: --
339: l_proc varchar2(72) := g_package||'update_DSGNTR_ENRLD_CVG';
340: l_object_version_number ben_dsgntr_enrld_cvg_f.object_version_number%TYPE;
341: l_effective_start_date ben_dsgntr_enrld_cvg_f.effective_start_date%TYPE;
342: l_effective_end_date ben_dsgntr_enrld_cvg_f.effective_end_date%TYPE;
343: --
344: begin
345: --
346: hr_utility.set_location('Entering:'|| l_proc, 10);
578: --
579: -- Declare cursors and local variables
580: --
581: l_proc varchar2(72) := g_package||'update_DSGNTR_ENRLD_CVG';
582: l_object_version_number ben_dsgntr_enrld_cvg_f.object_version_number%TYPE;
583: l_effective_start_date ben_dsgntr_enrld_cvg_f.effective_start_date%TYPE;
584: l_effective_end_date ben_dsgntr_enrld_cvg_f.effective_end_date%TYPE;
585: --
586: begin
579: -- Declare cursors and local variables
580: --
581: l_proc varchar2(72) := g_package||'update_DSGNTR_ENRLD_CVG';
582: l_object_version_number ben_dsgntr_enrld_cvg_f.object_version_number%TYPE;
583: l_effective_start_date ben_dsgntr_enrld_cvg_f.effective_start_date%TYPE;
584: l_effective_end_date ben_dsgntr_enrld_cvg_f.effective_end_date%TYPE;
585: --
586: begin
587: --
580: --
581: l_proc varchar2(72) := g_package||'update_DSGNTR_ENRLD_CVG';
582: l_object_version_number ben_dsgntr_enrld_cvg_f.object_version_number%TYPE;
583: l_effective_start_date ben_dsgntr_enrld_cvg_f.effective_start_date%TYPE;
584: l_effective_end_date ben_dsgntr_enrld_cvg_f.effective_end_date%TYPE;
585: --
586: begin
587: --
588: hr_utility.set_location('Entering:'|| l_proc, 10);
661: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
662: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
663: p_base_table_column_value => ben_dec_shd.g_old_rec.dpnt_cvg_eligy_prfl_id,
664: p_base_table_reference_column => 'DPNT_DSGNT_CRNTLY_ENRLD_FLAG',
665: p_reference_table => 'BEN_DSGNTR_ENRLD_CVG_F',
666: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
667: --
668: -- When in validation only mode raise the Validate_Enabled exception
669: --