659: ben_profile_handler.event_handler
660: (p_event => 'DELETE',
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: --
726: begin
727: --
728: hr_utility.set_location('Entering:'|| l_proc, 10);
729: --
730: ben_dec_shd.lck
731: (
732: p_dsgntr_enrld_cvg_id => p_dsgntr_enrld_cvg_id
733: ,p_validation_start_date => l_validation_start_date
734: ,p_validation_end_date => l_validation_end_date