598: l_proc varchar2(72) := g_package||'chk_pln_oipl_opt_mutexcl';
599: l_api_updating boolean;
600: l_dummy varchar2(1);
601: l_pl_id ben_pl_f.pl_id%TYPE;
602: l_oipl_id ben_oipl_f.oipl_id%TYPE;
603: l_opt_id ben_opt_f.opt_id%TYPE;
604:
605: --
606: cursor c1 is
817: p_argument_value => p_validation_end_date);
818: --
819: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
820: NOT (dt_api.check_min_max_dates
821: (p_base_table_name => 'ben_oipl_f',
822: p_base_key_column => 'oipl_id',
823: p_base_key_value => p_oipl_id,
824: p_from_date => p_validation_start_date,
825: p_to_date => p_validation_end_date))) Then
822: p_base_key_column => 'oipl_id',
823: p_base_key_value => p_oipl_id,
824: p_from_date => p_validation_start_date,
825: p_to_date => p_validation_end_date))) Then
826: l_table_name := 'ben_oipl_f';
827: Raise l_integrity_error;
828: End If;
829: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
830: NOT (dt_api.check_min_max_dates