APPS.BEN_DCE_BUS dependencies on DT_API

Line 552: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then

548: p_argument_value => p_datetrack_mode);
549: --
550: -- Only perform the validation if the datetrack update mode is valid
551: --
552: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
553: --
554: --
555: -- Ensure the arguments are not null
556: --

Line 568: NOT (dt_api.check_min_max_dates

564: p_argument => 'validation_end_date',
565: p_argument_value => p_validation_end_date);
566: --
567: If ((nvl(p_regn_id, hr_api.g_number) <> hr_api.g_number) and
568: NOT (dt_api.check_min_max_dates
569: (p_base_table_name => 'ben_regn_f',
570: p_base_key_column => 'regn_id',
571: p_base_key_value => p_regn_id,
572: p_from_date => p_validation_start_date,

Line 623: -- generic dt_api.rows_exist function then we must supply an error via

619: -- Processing continues.
620: --
621: -- Post Failure:
622: -- If a row exists by determining the returning Boolean value from the
623: -- generic dt_api.rows_exist function then we must supply an error via
624: -- the use of the local exception handler l_rows_exist.
625: --
626: -- Developer Implementation Notes:
627: -- This procedure should not need maintenance unless the HR Schema model

Line 679: If (dt_api.rows_exist

675: (p_api_name => l_proc,
676: p_argument => 'dpnt_cvg_eligy_prfl_id',
677: p_argument_value => p_dpnt_cvg_eligy_prfl_id);
678: --
679: If (dt_api.rows_exist
680: (p_base_table_name => 'ben_dpnt_cvg_rqd_rlshp_f',
681: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
682: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,
683: p_from_date => p_validation_start_date,

Line 688: If (dt_api.rows_exist

684: p_to_date => p_validation_end_date)) Then
685: l_table_name := 'ben_dpnt_cvg_rqd_rlshp_f';
686: Raise l_rows_exist;
687: End If;
688: If (dt_api.rows_exist
689: (p_base_table_name => 'ben_elig_age_cvg_f',
690: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
691: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,
692: p_from_date => p_validation_start_date,

Line 697: If (dt_api.rows_exist

693: p_to_date => p_validation_end_date)) Then
694: l_table_name := 'ben_elig_age_cvg_f';
695: Raise l_rows_exist;
696: End If;
697: If (dt_api.rows_exist
698: (p_base_table_name => 'ben_elig_mrtl_stat_cvg_f',
699: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
700: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,
701: p_from_date => p_validation_start_date,

Line 706: If (dt_api.rows_exist

702: p_to_date => p_validation_end_date)) Then
703: l_table_name := 'ben_elig_mrtl_stat_cvg_f';
704: Raise l_rows_exist;
705: End If;
706: If (dt_api.rows_exist
707: (p_base_table_name => 'ben_elig_mltry_stat_cvg_f',
708: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
709: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,
710: p_from_date => p_validation_start_date,

Line 715: If (dt_api.rows_exist

711: p_to_date => p_validation_end_date)) Then
712: l_table_name := 'ben_elig_mltry_stat_cvg_f';
713: Raise l_rows_exist;
714: End If;
715: If (dt_api.rows_exist
716: (p_base_table_name => 'ben_elig_dsbld_stat_cvg_f',
717: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
718: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,
719: p_from_date => p_validation_start_date,

Line 724: If (dt_api.rows_exist

720: p_to_date => p_validation_end_date)) Then
721: l_table_name := 'ben_elig_dsbld_stat_cvg_f';
722: Raise l_rows_exist;
723: End If;
724: If (dt_api.rows_exist
725: (p_base_table_name => 'ben_elig_stdnt_stat_cvg_f',
726: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
727: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,
728: p_from_date => p_validation_start_date,

Line 734: If (dt_api.rows_exist

730: l_table_name := 'ben_elig_stdnt_stat_cvg_f';
731: Raise l_rows_exist;
732: End If;
733: --
734: If (dt_api.rows_exist
735: (p_base_table_name => 'ben_dpnt_cvrd_anthr_pl_cvg_f',
736: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
737: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,
738: p_from_date => p_validation_start_date,

Line 744: If (dt_api.rows_exist

740: l_table_name := 'ben_dpnt_cvrd_anthr_pl_cvg_f';
741: Raise l_rows_exist;
742: End If;
743: --
744: If (dt_api.rows_exist
745: (p_base_table_name => 'ben_dsgntr_enrld_cvg_f',
746: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
747: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,
748: p_from_date => p_validation_start_date,

Line 755: If (dt_api.rows_exist

751: Raise l_rows_exist;
752: End If;
753: --
754: /*
755: If (dt_api.rows_exist
756: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',
757: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
758: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,
759: p_from_date => p_validation_start_date,